The Importance Of Excel In The Workplace

Excel is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.

Outside the workplace, Excel is in broad use for everyday problem solving.

Let’s say you have a home office. You can use Excel to calculate sales tax on a purchase, calculate the cost of a trip by car, create a temperature converter, calculate the price of pizza per square inch and do analysis of inputted data. You can track your debt, income and assets, determine your debt to income ratio, calculate your net worth, and use this information to prepare for the process of applying for a mortgage on a new house. The personal uses for Excel are almost as endless as the business uses for this software – and an Excel tutorial delves into the practical uses of the program for personal and business use.

The use of spreadsheets on computers is not new. Spreadsheets, in electronic form, have been in existence since before the introduction of the personal computer. Forerunners to Excel and Lotus 1-2-3 were packages such as VisiCalc, developed and modeled on the accountant’s financial ledger. Since 1987, spreadsheet programs have been impacting the business world. Along the way, computerized spreadsheets have become a pervasive and increasingly effective tool for comparative data analysis throughout the world.

Today, end users employ Excel to create and modify spreadsheets as well as to author web pages with links and complex formatting specifications. They create macros and scripts. While some of these programs are small, one-shot calculations, many are much more critical and affect significant financial decisions and business transactions.

Widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others, Microsoft Excel has become a staple of end users and business professionals.

The beauty of Excel is that it can be used as a receiver of workplace or business data, or as a calculator, a decision support tool, a data converter or even a display spreadsheet for information interpretation. Excel can create a chart or graph, operate in conjunction with Mail Merge functions, import data from the Internet, create a concept map and sequentially rank information by importance.

Excel offers new data analysis and visualization tools that assist in analyzing information, spotting trends and accessing information more easily than in the past. Using conditional formatting with rich data display schemes, you can evaluate and illustrate important trends and highlight exceptions with colored gradients, data bars and icons.

Indeed, Excel can be customized to perform such a wide variety of functions that many businesses can’t operate without it. Excel training has become mandatory in many workplaces; in fact, computer software training is a must for any workplace trying to keep up with the times.

Let’s say you’re an employer with 97 workers, 17 of whom called in sick today, and you want to know the percentage represented by absentees. Excel can do that. You can learn Excel and use it to determine the ratio of male to female employees, the percentage of minorities on the payroll, and the ranking of each worker by compensation package amount, including the percentages of that package according to pay and benefits. You can use Excel to keep track of production by department, information that may assist you in future development plans. You can create additional spreadsheets to track data on vendors and customers while maintaining an ongoing inventory of product stock.

Let’s say you want to know your business production versus cost. You don’t have to be a math wiz – you just have to learn Excel. Excel allows you to input all of the data, analyze it, sort it according to your customized format, and display the results with color, shading, backgrounds, icons and other gimmicks that offer time-saving assistance in later locating precisely the information desired. If this spreadsheet is for presentation purposes, Excel helps you put it together in such a visually appealing way that the data may seem to pop and sparkle.

The single most important thing an employer may do is learn Excel – it is one of the most essential tools of the workplace.

Excel and Microsoft are trademarks of Microsoft Corporation, registered in the U.S. and other countries. Lotus is a registered trademark of International Business Machines Corporation in the U.S. and/or other countries.

Posted in general | Comments Off on The Importance Of Excel In The Workplace

Why Architectural Drafting Is Common in Architectural Design

For architectural design projects, while there is the emphasis on using 3D models and architectural BIM modeling, the time-tested practice of using architectural drafting and 2D technical drawings is still commonplace in the AEC industry. Architectural drafting has evolved from the drawing board to computer-aided design and drafting (CAD) software programs. Drafting practices help to provide architectural construction drawings that include the technical details of architectural, structural and electrical elements required for the construction of a building. To understand the stage at which architectural drafting takes place, the workflow of a building design lifecycle must be considered.

The basic workflow of an architectural design project starts with the architect creating a conceptual plan which is usually modelled into architectural 3D models and rendered as photorealistic images for marketing and presentation to clients and customers.

Once the conceptual design is approved by the client, the design is then progressed into more detail and shared with other parties such as structural and MEP engineers. The way in which the design is progressed for the ‘design development’ phase by an architect lends itself to two options, either to develop a 3D model with more detail and then create subsequent sheets and details using a 3D tool such as Revit or AutoCAD, or as is still commonplace, to develop the concept design in 2D using more traditional methods. From the conceptual plans provided by architects and engineers, a drafter can convert these designs using CAD software programs to create technical drawings.

Architectural drafting is the process of creating technical drawings which include the floor plan, sections, elevations, detailed drawings and other documents in a construction drawing set (CD Set), which are typically required for the construction of a building.

The difference between Architectural Drafting and Modelling

Architectural drafting refers to creating 2D technical drawings and architectural construction drawings which are mainly used by contractors and consultants on site. Architectural 3D modelling refers to creating 3D models and renders of photorealistic images which are mainly used to present the architectural design for marketing purposes and then progressed from there to create the 2D technical drawings, in effect feeling like an extra stage (the 3D modelling element). The main software used for drafting, to create 2D technical drawings is AutoCAD while modellers use Revit and ArchiCAD to create 3D models and rendered images. Architectural draftsmen need to have basic 2D and 3D software knowledge such as AutoCAD and knowledge of technical codes and drafting guidelines specified by organisations such as American National Standards Institute (ANSI), American Society of Mechanical Engineers (ASME), American Design Drafting Association (ADDA), Public Works Government Services Canada (PWGSC), National Institute of Building Sciences (NIBS), BSI British Standards Institute and Standards Australia Code AS1100. Architectural modellers need to have a deeper understanding of architectural, building and construction concepts and experience with 3D software programs such as Revit and ArchiCAD.

Why Architectural Drafting is still Common in Architectural Design Practices

Architectural 3D models are preferred by architects and designers because they provide a 3D perspective of the conceptual plan of the building; it makes management of project data easier and allows for design changes on the go. However, construction companies that require technical specifications of the architectural project prefer 2D technical drawings and architectural construction drawings because they provide accurate details required for construction, most of the resources involved in construction understand 2D drawings, there are no issues with compatibility of software as compared to when using 3D models and it is a suitable solution to meet the budgetary requirements of a construction project. Some of the reasons why architectural drafting is preferable by several construction companies include:

• Suitable as per construction requirements – In some building projects, 2D technical drawings or architectural CAD drawings are sufficient to complete construction, where additional information that 3D models provide is not required. A construction drawing set (CD set) includes all the floor plans, elevations, sections and detailed drawings required for construction. Technical codes, symbols and other additional information such as the type of material are provided in technical drawings. Therefore, construction companies find 2D technical drawings sufficient to successfully complete construction.

• Availability of technical resources – Not all companies have technical resources to deliver 3D models. While drafting teams are qualified to work on AutoCAD to deliver 2D technical drawings, they may not be qualified to work on Revit to deliver 3D models. In the construction industry, the availability of drafting teams who can provide 2D technical drawings is ample compared to companies that provide 3D modelling services.

• Availability of software – The adoption of new software and practices is gradual and slow in the construction industry. The software used in building projects varies from country to country. Some countries use ArchiCAD and AutoCAD Architecture instead of Revit, therefore leading to the incompatibility of project data. 2D technical drawings in AutoCAD are widely used and compatible making it a preferred option to Revit 3D models.

• Suitable as per cost and budgetary requirements – In most cases, construction companies do not find the need to invest more in 3D models, when drafting solutions provide detailed technical drawings which are sufficient and relevant enough for construction. There is also the added investment in resources that are competent enough to understand and implement architectural 3d models on-site.

While architectural 3D modelling and BIM modelling provide design-related information typically required for architects and designers in the design stage of the building project lifecycle, architectural drafting provides technical drawings that are not just about aesthetics but about high-performance detailing of construction elements. Architectural CAD drawings specifically communicate the design intent and help in the construction of buildings which companies find relevantly sufficient over 3D models. Even as construction companies will need to eventually evolve to combining the use of 2D technical drawings and architectural 3D models until then, the time-tested practice of using architectural drafting and drawing solutions in construction is here to stay.

Posted in general | Comments Off on Why Architectural Drafting Is Common in Architectural Design

Clinic Management Software: Benefits of Clinic Software

Clinic management software is a web-based program which helps clinic owners manage their operations. It is already widely used in clinics in many regions of the world especially in the American continents, Europe, and Australia.

Here is a list of the many benefits of clinic management software.

1. It helps clinic owners simplify their business and helps them manage one clinic or a huge group of clinics.

2. It keeps and updates patients’ demographics like residence, gender, age, ethnicity, and diagnosis of patients.

3. It keeps and updates patients’ records like lungs chart, heart chart, kidney chart, weight and height charts, nutritional date, respiratory system chart and others.

4. It can print out prescriptions, patient records, billings, certificates, and others. It can also give information about patients’ prescription, medicine available, and the formulation of the medicine.

5. It completes receptions in an automated and systematized way.

6. It manages accounting needs and maintains the inventory.

7. It completes billing transactions.

8. It checks account balances.

5. It schedules multiple appointments.

6. It can send out multiple email reminders.

7. It allows patients to confirm appointment in real time with the use of a mobile phone or a computer.

8. It allows practitioners an easy and quick access to their schedule and patients’ record anytime.

9. It includes reporting tools which could quickly present, print out, or send out reports like patient visits, patients referred to other doctors, patients referred by other doctors, list of fee collection, and daily profit report.

10. It can multitask and designed for quick and easy usage which consequently lessens the stress of clinic owners and clinic employees.

11. It saves business owners a significant sum of money since clinic management software does not require expensive servers or IT support group.

12. It allows clinic owners maximize billable time and spend more time in taking care of their patients since almost all administrative procedures are supported by the software including the daily backing up of everyday reports.

13. It also allows clinic owners to spend more time in making their business grow.

14. Clinic management software general has security features like password facility to validate users, entry validation, data secrecy feature, and data access that is user defined.

Business establishments like clinics need to cope up with the fast advancement in technology nowadays. Otherwise, they will be left behind since most business enterprises are already using such software.

Posted in general | Comments Off on Clinic Management Software: Benefits of Clinic Software

Introduction to Silk Test Architecture

Normal use of an application consists of a person manipulating a keyboard and mouse to initiate application operations. The person is said to be interacting with the GUI (Graphical User Interface). During Silk Test testing, Silk Test interacts with the GUI to submit operations to the application automatically.

Thus Silk Test can simulate the actions of a person who is exercising all the capabilities of an application and verifying the results of each operation. The simulated user (Silk test) is said to be driving the application. The application under test reacts to the simulated user exactly as it would react to a human rest. Silk Test consists of two distinct software components that execute in separate processes:

The Silk Test host software

The 4Test Agent software

Silk Test host software

The Silk Test host software is the program you use to develop, edit, compile, run and debug your 4Test scripts and test plans. This manual refers to the system that runs this program as the host machine or the Silk Test machine.

The Agent

The 4Test Agent is the software process that translates the commands in your 4Test scripts into GUI-specific commands. In order words, it is the Agent that actually drives and monitors the application you are testing. One Agent can run locally on the host machine. In a networked environment, any number of Agents can run on remote machines. This manual refers to the systems that run remote Agents as target machines. This manual refers to the systems that run remote Agents as target machines. In a client/server environment, Silk Test drives the client application by means of an Agent process running on each application’s machine. The application then drives the server just as it always does. Silk Test is also capable of driving the GUI belonging to a server or of directly driving a server database by running scripts that submit SQL statements to the database. These methods o directly manipulating the server application are intended to support testing in which the client application drives the server.

Posted in general | Comments Off on Introduction to Silk Test Architecture

Medical Coding History – From Paper to Medial Coding Software

If we define medical coding as the assignment of alphanumerical characters to diagnoses, diseases, and treatments, then medical coding has been traced back to the 1600s in England with the London Bills of Mortality. A more standardized system of coding was developed for classifying death at the tail end of the 19th century. In 1893, Jacque Bertillon, a statistician, created the Bertillon Classification of Causes of Death, a system which was eventually adopted by 26 countries at the beginning of the 20th century. Shortly after the Bertillon Classification system was implemented, people began discussing the possibility of expanding the system beyond mortality as a way of tracking diseases.

By the middle of the 20th century, the World Health Organization (WHO) adopted a goal of a single global classification system for disease and mortality, entitled the International Classification of Diseases, Injuries, and Causes of Death (ICD). This classification system is updated every 10 years. The latest revision, ICD-10, is scheduled for adoption in the United States in 2013.

What started out as a small set of medical codes has evolved into a complex system that was initially standardized by the American Medical Association back in 1966 with current procedure codes (CPT) codes that are updated annually.

In the late 1970s, the Healthcare Common Procedure Coding System (HCPCS) was developed based on CPT. HCPCS has three levels of codes: Level One is the original CPT system. Level Two codes are alphanumeric and include non-physician services such as ambulances and other transportation as well as patient devices such as prosthetic devices. Level Three codes were developed as local codes, and were discontinued in 2003 in order to keep all codes relevant worldwide.

Recently, medical coding systems have been expanded to include other medical specialties. For example, there are coding systems related to disabilities, the dental field, prescription drugs, and mental health.

As the coding systems have become more complex and diverse, the need for training of medical coders has grown exponentially. Private training schools and public colleges throughout the country have developed certification programs. In order to be awarded a certificate, students must obtain a two-year degree from an accredited medical coding school and pass an exam given by the AHIMA.

Over the past 20 years, many coding processes have shifted from a paper-based system to a computer-based system using medical coding software and medical billing software. Many companies sell complete medical software-based coding solutions and myriad of products for specific medical disciplines, such as products that are specifically tailored to skilled nursing facilities, physicians, hospitals, surgery, cardiology, and more.

As medical facilities and professionals begin preparing for the conversion to ICD-10 in 2013, the need for more sophisticated medical coding software solutions and qualified medical coders will continue to grow.

CPT is a registered trademark of the American Medical Association.

Posted in general | Comments Off on Medical Coding History – From Paper to Medial Coding Software

The Advantages and Disadvantages to Bug Tracking Software

Bug tracking has been around as early as the 1940’s, just not in a software form. In these early days, simply using a pen and a paper created tracking systems. It evolved from then to using spreadsheets. Now there is bug tracking software like the defect tracking tool and even more specific programs like Mantis and Bugzilla, just to name a couple. As with anything that evolves however, there will always be those that are 100% for the programs and those that are against it. This article will cover all claims – both positive and negative – of bug tracking software like the defect tracking tool.

The Positive Claims

It certainly depends on the type of bug tracking software that is used, but it seems as if there are many more advantages to these tools than disadvantages. The most obvious advantage is that these types of tools allow companies to keep a record of the issues that are recorded, who fixed them, and even how long it took to fix the issue for some types of programs. Customers are encouraged to be as detailed as they can be when requesting that an issue be fixed so that companies can complete their requests as quickly as possible. The fact that the issues are recorded and saved is a huge benefit for the companies because sending the recorded bug list with the purchased software is a common practice. This is a benefit to customers because if it is a common error, they can simply look up this issue in the previously recorded bug list. However, if the list is incredibly long (a common disadvantage) it can become more of a hassle.

The Negative Claims

As with anything that has a list of positive aspects there is also a list of negative aspects, though there are few. One of the biggest complaints is not so much from the bug tracking software or defect tracking tool itself but more from the process of submitting issue requests. Customers need to be extremely detailed with their issue requests if they want a detailed response. Miscommunication isn’t a fault of the product, the customer, or the company – it’s simply something that happens. Customers and companies alike both need to remember to be patient with each other and to treat each other with a mutual respect. A second complaint that was previously mentioned is the length of issues in some of these software programs.

Some customers don’t have the patience to look through a long list of software issues that have been previously recorded and this causes frustration among the companies that took the time to purchase software that saves them. The length of issues that are submitted can also become a problem because if there are too many issues submitted and not enough engineers to address them, some can get overlooked. Nobody likes to be forgotten, but usually these types of bug tracking software include detailed instructions and are easy to use.

Usually when a company purchases a bug tracking software or defect tracking tool it already has an experienced IT department in place. Whatever the software is that is being used with these programs should have some sort of backup for when the work is completed so it does not get lost if the issues that occur are deadly.

Posted in general | Comments Off on The Advantages and Disadvantages to Bug Tracking Software

Advantages and Disadvantages of Biometric Time and Attendance Software

First of all let me ask you what you understand by time and attendance software? Have you ever been asked to log in as soon as you enter office and the main gate of the office has a Biometric machine that takes in your finger prints and allows you to enter the office premise? Yes, these are the time and attendance software being installed in a company.

Biometrics consists of methods for uniquely identifying a person (human being) by his/her physical or behavioral traits. There are many biometric software available in market for such purpose and their use is widely known. One such use is Biometric time and attendance management software.

Those days are gone when we had to punch in cards or sign into a register to tell the other person that we are present. Just as paper checking has been changed from manual to computerized, identifying a person and letting him in your office has been changed from manual to biometrics.

There are many benefits of having such methodology in your office. Such as:

• Accurate timing: When a person looks at his watch and enters the time there is a slight chance that he may see the wrong timing and write. Whereas with biometric time and attendance software there is no possibility of such mistake. The user does not need to see or check the time, it automatically gets logged in.

• Less error: There is no scope of human error here.

• Profit to company: If it’s accurate and correct the company will definitely gain from it.

As everything has a good and bad side this too has its disadvantages, such as:

• Extra cost to company: Biometric software and machine cost a lot more, so installing such software need a good investment money wise.

• Extra management: Remember when every employee is logging his own timing when he comes or leaves; there is no extra management here. But, if you are putting a machine there has to be taken some care of it.

Biometrics time and management software is really helpful when creating payrolls for employees. Once a definite timing has been registered you don’t need to think twice before creating the employees pay.

Many homes are also using such kind of software to have a safe and secure home. Biometric software is really helpful when you need security in your home as well as in office. There are many companies all over the world providing such biometric time and attendance software. You just need to keep an eye on the technologies and websites that are providing you these.

Posted in general | Comments Off on Advantages and Disadvantages of Biometric Time and Attendance Software

Strengths and Weaknesses of Waterfall Approach for Software Development

One of the most famous and widely used approaches for software development is the waterfall model. Waterfall approach is an old technique that has been in use for quite some time, but in modern times agile approach is gaining prominence.

Waterfall approach, as is evident from the name, refers to a systematic approach where one step comes after the other. It cannot go the other way round. The process works like the waterfall effect that flows in one direction, which is from up to down.

In this process the life cycle of the development process is predetermined. All the steps are defined before the start of the project. The approach is predictive, where the team is well aware of the order of each step and therefore works accordingly. It starts from the requirement analysis, the design phase and then proceeds on to the implementation, testing and the maintenance phases.

The waterfall approach can be quite beneficial for those who are quite clear on their requirements. A planned approach works for them because they want fixed processes and budget. Where fixed processes are beneficial, at the same time they can be inconvenient at times. In cases where the client is not clear on the requirements and finds in the middle of the project that he/she wants to change course, this approach can prove to be quite problematic.

Another point of the waterfall approach is that the requirement analysis and design of architectural structure can consume a lot of time. Extensive research is done initially as the next phases depend completely on the planning strategy. However, the good thing is that everything is thoroughly worked out and each aspect is studied beforehand. The developers in such cases know what is expected of them.

A waterfall approach works in a systematic order, with one step following the other and the testing phase comes in the end. If there are any big problems encountered in the testing phase, it means a long process to make the amends. The process can consume extra time and money.

We cannot conclude that one approach is better than the other, as every method would have its own strengths and weaknesses. The determination of success for each method depends on how it is being used and whether the approach suits the scope of work being undertaken. While one approach may be suitable for a particular project, it might become totally useless under different circumstances. For example, some believe that agile methods are not well suited for offshore development, as they require a closer contact and communication that is not possible in an offshore project.

Posted in general | Comments Off on Strengths and Weaknesses of Waterfall Approach for Software Development

The Importance Of Excel In The Workplace

Excel is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.

Outside the workplace, Excel is in broad use for everyday problem solving.

Let’s say you have a home office. You can use Excel to calculate sales tax on a purchase, calculate the cost of a trip by car, create a temperature converter, calculate the price of pizza per square inch and do analysis of inputted data. You can track your debt, income and assets, determine your debt to income ratio, calculate your net worth, and use this information to prepare for the process of applying for a mortgage on a new house. The personal uses for Excel are almost as endless as the business uses for this software – and an Excel tutorial delves into the practical uses of the program for personal and business use.

The use of spreadsheets on computers is not new. Spreadsheets, in electronic form, have been in existence since before the introduction of the personal computer. Forerunners to Excel and Lotus 1-2-3 were packages such as VisiCalc, developed and modeled on the accountant’s financial ledger. Since 1987, spreadsheet programs have been impacting the business world. Along the way, computerized spreadsheets have become a pervasive and increasingly effective tool for comparative data analysis throughout the world.

Today, end users employ Excel to create and modify spreadsheets as well as to author web pages with links and complex formatting specifications. They create macros and scripts. While some of these programs are small, one-shot calculations, many are much more critical and affect significant financial decisions and business transactions.

Widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others, Microsoft Excel has become a staple of end users and business professionals.

The beauty of Excel is that it can be used as a receiver of workplace or business data, or as a calculator, a decision support tool, a data converter or even a display spreadsheet for information interpretation. Excel can create a chart or graph, operate in conjunction with Mail Merge functions, import data from the Internet, create a concept map and sequentially rank information by importance.

Excel offers new data analysis and visualization tools that assist in analyzing information, spotting trends and accessing information more easily than in the past. Using conditional formatting with rich data display schemes, you can evaluate and illustrate important trends and highlight exceptions with colored gradients, data bars and icons.

Indeed, Excel can be customized to perform such a wide variety of functions that many businesses can’t operate without it. Excel training has become mandatory in many workplaces; in fact, computer software training is a must for any workplace trying to keep up with the times.

Let’s say you’re an employer with 97 workers, 17 of whom called in sick today, and you want to know the percentage represented by absentees. Excel can do that. You can learn Excel and use it to determine the ratio of male to female employees, the percentage of minorities on the payroll, and the ranking of each worker by compensation package amount, including the percentages of that package according to pay and benefits. You can use Excel to keep track of production by department, information that may assist you in future development plans. You can create additional spreadsheets to track data on vendors and customers while maintaining an ongoing inventory of product stock.

Let’s say you want to know your business production versus cost. You don’t have to be a math wiz – you just have to learn Excel. Excel allows you to input all of the data, analyze it, sort it according to your customized format, and display the results with color, shading, backgrounds, icons and other gimmicks that offer time-saving assistance in later locating precisely the information desired. If this spreadsheet is for presentation purposes, Excel helps you put it together in such a visually appealing way that the data may seem to pop and sparkle.

The single most important thing an employer may do is learn Excel – it is one of the most essential tools of the workplace.

Excel and Microsoft are trademarks of Microsoft Corporation, registered in the U.S. and other countries. Lotus is a registered trademark of International Business Machines Corporation in the U.S. and/or other countries.

Posted in general | Comments Off on The Importance Of Excel In The Workplace

Examples Of Spyware And What They Are

Spyware is a general term used to describe software that performs certain behaviors such as advertising, collecting personal information, or changing the configuration of your computer, generally without appropriately obtaining your consent first.

Spyware is often associated with software that displays advertisements (called adware) or software that tracks personal or sensitive information.

That does not mean all software that provides ads or tracks your online activities is bad. For example, you might sign up for a free music service, but you “pay” for the service by agreeing to receive targeted ads. If you understand the terms and agree to them, you may have decided that it is a fair tradeoff. You might also agree to let the company track your online activities to determine which ads to show you.

Other kinds of Spyware make changes to your computer that can be annoying and can cause your computer slow down or crash.

These programs can change your Web browsers home page or search page, or add additional components to your browser you don’t need or want. These programs also make it very difficult for you to change your settings back to the way you originally had them.

The key in all cases is whether or not you (or someone who uses your computer) understand what the software will do and have agreed to install the software on your computer.

There are a number of ways Spyware or other unwanted software can get on your computer. A common trick is to covertly install the software during the installation of other software you want such as a music or video file sharing program.

Any software that covertly gathers user information through the user’s Internet connection without his or her knowledge, usually for advertising purposes. Spyware applications are typically bundled as a hidden component of freeware or shareware programs that can be downloaded from the Internet; however, it should be noted that the majority of shareware and freeware applications do not come with SpyWare. Once installed, the Spyware monitors user activity on the Internet and transmits that information in the background to someone else. Spyware can also gather information about e-mail addresses and even passwords and credit card numbers

Aside from the questions of ethics and privacy, SpyWare steals from the user by using the computer’s memory resources and also by eating bandwidth as it sends information back to the spy ware’s home base via the user’s Internet connection. Because SpyWare is using memory and system resources, the applications running in the background can lead to system crashes or general system instability.

Because SpyWare exists as independent executable programs, they have the ability to monitor keystrokes, scan files on the hard drive, snoop other applications, such as chat programs or word processors, install other SpyWare programs, read cookies, change the default home page on the Web browser, consistently relaying this information back to the SpyWare author who will either use it for advertising/marketing purposes or sell the information to another party.

Licensing agreements that accompany software downloads sometimes warn the user that a SpyWare program will be installed along with the requested software, but the licensing agreements may not always be read completely because the notice of a SpyWare installation is often couched in obtuse, hard-to-read legal disclaimers.

Examples of SpyWare

These common SpyWare programs illustrate the diversity of behaviors found in these attacks. Note that as with computer viruses, researchers give names to SpyWare programs which may not be used by their creators. Programs may be grouped into “families” based not on shared program code, but on common behaviors, or by “following the money” of apparent financial or business connections. For instance, a number of the SpyWare programs distributed by Claria are collectively known as “Gator”. Likewise, programs which are frequently installed together may be described as parts of the same SpyWare package, even if they function separately.

o CoolWebSearch, a group of programs, takes advantage of Internet Explorer vulnerabilities. The package directs traffic to advertisements on Web sites including coolwebsearch.com. It displays pop-up ads, rewrites search engine results, and alters the infected computer’s hosts file to direct DNS lookups to these sites.

o Internet Optimizer, also known as DyFuCa, redirects Internet Explorer error pages to advertising. When users follow a broken link or enter an erroneous URL, they see a page of advertisements. However, because password-protected Web sites (HTTP Basic authentication) use the same mechanism as HTTP errors, Internet Optimizer makes it impossible for the user to access password-protected sites.

o Zango (formerly 180 Solutions) transmits detailed information to advertisers about the Web sites which users visit. It also alters HTTP requests for affiliate advertisements linked from a Web site, so that the advertisements make unearned profit for the 180 Solutions Company. It opens pop-up ads that cover over the Web sites of competing companies.

o HuntBar, aka WinTools or Adware,WebSearch was installed by an ActiveX drive-by download at affiliate Web sites, or by advertisements displayed by other SpyWare programs-an example of how SpyWare can install more SpyWare. These programs add toolbars to IE, track aggregate browsing behavior, redirect affiliate references, and display advertisements.

oZlob Trojan or just Zlob, Downloads itself to your computer via ActiveX codec and reports information back to Control Server. Some information can be as your search history, the Websites you visited, and even Key Strokes.

Posted in general | Comments Off on Examples Of Spyware And What They Are