Icon IRA WILSKER PAGE Icon

PLEASE USE MY NEW EMAIL: iwilsker@sbcglobal.net
LISTEN to my "My Computer Show" on NEWS TALK AM560 KLVI
NOW STREAMING ON THE NET, MONDAYS, 6-7pm Central Time, KLVI.COM
READ my weekly computer and technology column in the EXAMINER
http://www.theexaminer.com  Click on the "Front Page" image and scroll to my column 

www.theexaminer.com  click on Page Guide, then click Personal Technology


March 13, 2010

 

OpenOffice 3.2 – Free Competitor to Microsoft Office

by Ira Wilsker

WEBSITES:

         http://www.openoffice.org

         http://extensions.services.openoffice.org/en

         http://templates.services.openoffice.org

 

For only the third time in the ten years that I have been writing this column, I am not using Microsoft Word as my word processor to write this column. For one column about three years ago, I used the then new Google Docs to compose my column, and saved the output in the Word format requested by the Examiner. About two years prior to that, I used the then new OpenOffice as my word processor for a column about OpenOffice. Now that a new release of OpenOffice, version 3.2, is available which includes full file compatibility with Microsoft Office 2007, I concluded that it was worthy of another look. My first impression of this new version is very positive, as it has much the same look and feel of the Microsoft products that I have been using almost exclusively for the past many years. I had no learning curve with OpenOffice, and proceeded to use it immediately. While this new version can read and write files in the latest Microsoft formats, and is so feature rich that it would be a worthy competitor to Microsoft Office, it does have one overwhelming advantage over Microsoft Office; that is that it is totally free to download and use by anyone. Unlike some other free software that is only free for personal use, but mandates a fee for corporate or academic use, OpenOffice is absolutely free for all users.

     I have been considering writing an updated review of OpenOffice for quite a while, as it has been garnering a lot of positive reviews in the media, but two recent events provided me with the impetus to write this review today. First is that a new version of OpenOffice was recently released (version 3.2), which included several enhancements and compatibility improvements with the latest Microsoft Office file formats. The other reason was an email I received today asking for help, we have an 80 year old man, recently lost his wife... his computer went out, so we went and got one from <local computer store>. Question, is there a program like Microsoft word that we can download free for him. He has to write letters and makes signs for his lodge. i have done searches but am afraid to download something that may not work. thank you in advance!! <sic>. I replied back with the link to OpenOffice, which will do what this gentleman wants, and much more.

     OpenOffice is a large download (149 megs) and is available from OpenOffice.org. OpenOffice is also one of the most widely downloaded suites on the internet, with over 100 million copies of version 3 downloaded within the past year, with millions more of the earlier versions being downloaded. With numbers like these, OpenOffice has earned a large and loyal following. OpenOffice is not just for English speaking Windows users, as it is available in 80 of the world's languages, and for almost all popular operating systems including GNU/Linux, Sun Solaris, and Apple Mac. It is simple enough for a novice user to master, and comprehensive enough for an experienced office suite user. According to the OpenOffice web page, OpenOffice.org 3 is easy to learn, and if you're already using another office software package, you'll take to OpenOffice.org 3 straight away. Our world-wide native-language community means that OpenOffice.org 3 is probably available and supported in your own language. And if you already have files from another office package - OpenOffice.org 3 will probably read them with no difficulty. To test this, I opened a variety of word processor, spreadsheet, and presentation files created in Microsoft Office, and all opened successfully. I then created some similar files with OpenOffice, saved them in the appropriate Microsoft format, and my copy of Microsoft Office opened them without a hiccup. I also tried opening some old WordPerfect (word processor) and Quattro (spreadsheet) files with OpenOffice, and they also opened and displayed flawlessly. The listing of file formats available for import or export with OpenOffice is nothing less than spectacular, with every format I could think of listed, as well as many I am not familiar with. If an unusual document format is encountered, OpenOffice can likely open it.

     I am currently typing this using the OpenOffice Writer, which is the word processor included in the suite. When I first opened it, it looked almost identical to my Microsoft Word, and all of the keyboard shortcuts that I used regularly in Word, worked flawlessly in Writer. Writer can read and write many more file formats than Word, and has an integral PDF creator to make PDF files out of any documents that can be opened or created with OpenOffice. Writer is feature rich including auto correct, auto complete, auto format, styles and formatting, text frames and linking, automated table of contents, indexing, bibliography, references, illustrations, tables, and other features found on its expensive commercial competitors. I searched and tried, but I could not find any feature missing on Writer that is available on the commercial products.

     I have been using Microsoft's Excel spreadsheet utility for several years for a variety of financial and data tasks. Excel has a near monopoly in industry as the spreadsheet of choice, replacing the classical Lotus and Quattro, both of which I used extensively in the past. I opened several of my Excel spreadsheets in OpenOffice's Calc, and they opened without any problems. Calc looks just like Excel, and has a similar menu and command set, which meant that there was nothing new for me to learn in order to master Calc. I tried creating color graphs and charts in Calc, and the same skills set I have for Excel worked fine on Calc. I have used a lot of the integral calculation functions in Excel, and they were all available in Calc. A Function Wizard in Calc makes the implementation and inclusion of mathematical and statistical functions very easy. Calc has proven itself to be a very worthy competitor to Excel at a price that can not be beat (free!).

     Microsoft's PowerPoint is the defacto standard for presentation software, and I have used it frequently for the many presentations that I have done. OpenOffice has a very capable competitor with its Impress, which can read and write PowerPoint files as well as most other presentation formats. Impress looks very similar to PowerPoint, and like the other components in OpenOffice, employs a similar menu structure and keyboard shortcut set. Special effects, transitions, sounds, video, and other features are integral with Impress, allowing the user to do anything that he can do in PowerPoint. Impress files can be printed as PDF files by simply clicking on File – Export as PDF, or exported into dozens of other file formats, including most graphical formats, and the web page HTML format, by clicking on File – Export. This same process can be used to create a video in Macromedia Flash SWF format, where the Impress presentation can be viewed as a video, with a mouse click advancing to the next slide. Impress is a powerful presentation utility, and is very capable of being used to create very professional appearing presentations that can be played on almost any computer. Impress can also be freely used to show PowerPoint presentations even if the user does not have PowerPoint.

     Many of us use a lot of images and graphics for a variety of purposes, and these images often need to be edited, cropped, have captions or labels inserted, merged, or otherwise manipulated. While there are many commercial and freeware utilities that can perform these tasks, OpenOffice has a utility aptly named Draw that can be used as a free standing but comprehensive imaging editor, which is also integrated into the other OpenOffice functions. Draw can import, export, and edit almost all graphic formats, including JPG, GIF, BMP, WMF, PNG, TIFF, Kodak Photo CD PCD, and many other graphic formats. In addition to manipulating graphics, Draw also has smart connectors that can be used to quickly create flowcharts, organization charts, network diagrams, and other forms of diagrams and charts. When used with the Writer word processor, Draw is capable of being used to create posters, brochures, pamphlets, and other items for display or distribution.

     Another common utility incorporated in most office suites is some form of database utility, and OpenOffice is no different by including a comprehensive database utility with the simple name Base. Base can be used to create or modify tables, forms, queries, and reports. With its own HQSL database engine, Base can be used to manage information and data, or the user can use a variety of wizards, design views, or SQL views. I am personally not a database wizard, but I was able to quickly create a simple data base using Base, and mine it for information and reports.

     The entire OpenOffice suite has over 500 free extensions available which can be used to enhance the capabilities of OpenOffice. These extensions add dictionaries in many languages, forms, templates, clip art galleries, and many other features. One that I especially like is Sun PDF Import Extension, which allows the user to import and modify PDF documents. Another extension that I will be trying is the Presenter Console which gives the presenter more control over his presentation by showing the upcoming slide, slide notes, and a presentation timer. What is unusual is that only the presenter sees this console, while the audience only sees the current slide. The hundreds of other extensions available provide a wealth of additional capabilities to OpenOffice.

     For those who would sometimes prefer to use pre-made templates to accomplish a variety of tasks, OpenOffice has hundreds of free templates available at templates.services.openoffice.org. Templates come in three primary categories, Business, Education, and Private, with over 600 available templates. Some of the most popular templates include several resume formats, calendars, business cards, business letters, brochures and pamphlets, newsletters, meal planners, automated invoices, greeting cards, APA-style templates that would be suitable for college or university students, fax cover sheets, weekly planners, recipe cards, and hundreds of others. By using a template, complex tasks may be as easy as filling in the blanks, and producing professional appearing output.

     OpenOffice has been adopted as a standard office suite by hundreds of colleges and universities, government agencies at all levels, businesses of all sizes, and millions of individuals. Some countries have also adopted OpenOffice as a national standard office suite, as well as many cities. At least one US state has adopted OpenOffice as its standardized office suite, much to the consternation of Microsoft and its supporters. I have been recommending OpenOffice to my students as a free alternative to Microsoft Office. In these tight fiscal times, switching to a free open source office suite that can read and write almost all of the existing Office formats might make a lot of sense. The State of Texas, for example, has set Microsoft Word as the defacto standard for state documents; with massive budget cuts being implemented statewide (including at my college), imagine how much money could be saved by phasing in the free OpenOffice as a replacement for the very costly Microsoft Office. Anyone who currently uses Microsoft Office can instantly use OpenOffice, and with its outstanding file compatibility, almost nothing would be lost from any existing Office documents.

     Sorry Microsoft, but the free OpenOffice may possibly displace you as the predominant office suite. Free is a very hard price to beat.















 

February 27, 2010

Personal Finance Websites Help You Spend, Save, and Invest

By Ira Wilsker

 

WEBSITES:

         http://www.dealnews.com

         http://shortcuts.com

         http://www.cellfire.com

         http://www.smartsource.com

         http://www.coupons.com

         http://finance.yahoo.com

         http://finance.yahoo.com/personal-finance

         http://finance.yahoo.com/how-to-guide/index

         http://finance.yahoo.com/calculator/index

         http://www.google.com/finance

         http://moneycentral.msn.com

         http://moneycentral.msn.com/personal-finance

 

There are three basic uses of money; you can spend it, save it, and invest it.  Any economics student can tell you that money is one of the scarce commodities, and the household never seems to have enough of it.  There are thousands of websites that can help you spend, save, and invest wisely, such that the little money that we do have can go farther.

There are many websites that can help us spend our money more wisely by finding bargains, or by using coupons.  One place that I check for bargains several times a day that includes both local brick-and-mortar stores as well as online sites is Dealnews, at dealnews.com.  This website tracks bargains and posts them continuously updated throughout the day, and includes items from several categories (electronics, clothing, groceries, music, and many more).  Items that may be listed at any given time may include coupons for local restaurants, unadvertised specials for local home improvement centers, deeply discounted merchandise from both local retailers and online stores, and often some free items (commonly music, free samples, and computer software).  Dealnews also has an extensive and searchable library of coupons that can be used locally or online.

Many of us have found that the use of coupons can dramatically save us money at the supermarket, restaurant, auto service company, and other local stores.  There is no reason to be ashamed to use a coupon, as the manufacturer or retailer would not publish them if he did not want us to use them.  One of my favorite grocery coupon websites is AOL’s Shortcuts.com.  Shortcuts has dozens of manufacturers coupons available at any time, but rather than require the user to clip them from the newspaper, or print them, Shortcuts automatically loads them on to the supermarkets shoppers card.  Nationally, there are many supermarket chains that participate, but locally Kroger is the only participant.  Registration is required, but free to use the service.  Every week, a listing of dozens of new coupons is released which the user can select from by simply clicking on the displayed item.  Within minutes, the coupons are electronically loaded onto the shoppers card account, and are automatically deducted at checkout when the product is scanned at the register, all without paper coupons.  The Shortcuts website tracks and displays the coupons used, available coupons, and the expired coupons.  Shopping lists can be printed that display the available coupons

Another competing website that works much the same way as Shortcuts is CellFire, at Cellfire.com.  While CellFire will load grocery coupons on the shoppers card, it also offers digital coupons for non-grocery items and services that can be displayed on most modern cell phones.  These coupons that can be displayed on the cell phone are intended to be shown to the clerk at the counter to get the discount or promotion, and include discounts for local photo studios, florists, auto services, and other discounts.  The CellFire service is free, but requires that the user register a cell phone number which will only be used to display the requested coupons.

Other useful coupon websites that offer printable coupons, mostly for grocery items, are SmartSource at www.smartsource.com, and Coupons.com (www.coupons.com ).  Both Coupons.com and SmartSource also have printable coupons for local restaurants, florists, auto services, photo studios, office supplies, and other businesses.  Both of these sites require the installation of a proprietary coupon printing utility in order to securely print the coupons and verify their authenticity to the retailer.

In terms of the saving and investing, there are many legitimate websites that offer a wealth of information on banking and investing.  My personal favorite is Yahoo! personal finance site at finance.yahoo.com.  While the main page is heavy on investing information, including continuously updated stock quotes and business news, there are also tabs for a wide assortment of other personal finance information at finance.yahoo.com/personal-finance.  Categories of personal finance information presented include banking, college & education, family & home, insurance, loans, real estate, retirement, and taxes.  A selection of detailed How-To Guides (finance.yahoo.com/how-to-guide/index) show how to accomplish a wide assortment of financial tasks, including mortgage basics, how to buy a car, how to get out of debt, deciding on traditional IRA or Roth accounts, retirement planning, and many others.  An assortment of financial calculators are available at finance.yahoo.com/calculator/index, and include calculators to figure mortgages and monthly payments, cash flow, a CD analyzer, how long will it take to pay off my credit cards, the value of a college education, and a Coverdell Education Savings Account calculator.  I personally used the Coverdell ESA calculator to help plan a college savings and investment plan for my new granddaughter.  One other interesting feature on Yahoo! Personal Finance is the Rates table that shows the current national average interest rates for home mortgages, home equity loans, savings accounts, auto loans, and credit cards; this chart is updated on a daily basis.

Not to be outdone by Yahoo!, Google also offers a finance website at www.google.com/finance. This Google site has excellent and comprehensive finance information including stock quotes, business news, and portfolio tracking, but lacks the comprehensive personal finance information that is offered on Yahoo!’s finance page.

Microsoft offers its Money Central at moneycentral.msn.com, which is a typical page primarily devoted to investment information, and also offers a personal finance page at moneycentral.msn.com/personal-finance.  While not as feature rich as Yahoo! Personal Finance, it does contain comprehensive information on banking, family and college, insurance, retirement, savings and debt, and taxes.  Looking at the MSN Retirement and Wills Center (articles.moneycentral.msn.com/RetirementandWills), are a selection of retirement articles, as well as calculators fro retirement planning.  The other sections in MSN Personal Finance also contain a variety of relevant articles and calculators.

There is a lot of information available online to help the reader spend, save, and invest wisely.  Check them out so you too can improve your financial standing.






















 

February 20, 2010

 

Edit Your Videos for Free By Ira Wilsker

 

WEBSITES:

http://download.live.com/moviemaker

http://www.techsupportalert.com/best-free-video-editor.htm

http://www.avidemux.org

http://fixounet.free.fr/avidemux/

http://www.videospin.com

 

            Since the advent of digital film, it seems that almost all of us now have a digital movie camera of some sort.  My two year old cell phone, which is not a technical marvel when compared to what is available today, has a simple video camera.  Every section of every class that I am teaching this semester is video recorded, allowing my students to review precisely what we covered in class.  There are now decent digital video cameras that are not much larger than a deck of cards, and are often advertised for less than $100.  It seems that almost nothing happens now that someone is not video recording.  Once recorded, we often have hours of digital video that are in sore need of editing in order to make the video more appealing to viewers.  Our videos may be used for strictly private home use or show up on YouTube where there may be countless viewers.  The big box stores have several, often expensive, utilities that can be used for video editing, but as is common in the software industry, there are also some very functional free video editors available.

            One of the most widely used free video editors is Microsoft's Movie Maker, a part of the Windows Live service, available for download from download.live.com/moviemaker.  Movie Maker will run on Vista or Windows 7.  While most Windows Live utilities will run on XP, Microsoft says, Windows Live Movie Maker is not available for Windows XP or earlier versions of Windows.  Movie Maker incorporates a tool-box of intuitive and easy to use tools that can edit video, incorporate music, add titles, and incorporate special effects.  Using the integral AutoMovie feature, the software will invoke a wizard to add a title, display credits, and add transitions and special effects, resulting in a file that is ready to show or upload to services such as YouTube.  Movie Maker can also utilize still images to create animated slide shows complete with music, transitions, and effects, with the output looking much like a video.  The output of Movie Maker can be saved to the hard drive or other digital media, or burned to a CD or DVD disc.  Since it is free and widely used, Microsoft's Movie Maker may be a worthwhile video editing utility to try first.

            Recently, I wrote about one of my favorite websites, Gizmo's Freeware Reviews (www.techsupportalert.com), which reviews and rates free software.  On its recently updated ratings of the best free video editing software (www.techsupportalert.com/best-free-video-editor.htm), Gizmo gave his highest rating to the French freeware video editor Avidemux, version 2.5.2, available for direct download from fixounet.free.fr/avidemux.  Gizmo summarized Avidemux with the statement that it is, Powerful, Easy to use (and has) Well documented tutorials.  As with any other video editing program, it can be confusing.  While originally written for Linux based computers, Avidemux has been rewritten to also run on BSD, Mac OS X and Microsoft Windows under the GNU GPL license.  The Windows version will run on both 32 and 64 bit versions of Windows.  According to its home page at fixounet.free.fr/avidemux, Avidemux is a free video editor designed for simple cutting, filtering and encoding tasks. It supports many file types, including AVI, DVD compatible MPEG files, MP4 and ASF, using a variety of codecs. Tasks can be automated using projects, job queue and powerful scripting capabilities.  I downloaded Avidemux (Windows version, 12.5 mb), and it installed smoothly and quickly.  I tried some of the simple editing tasks in its Video Filter Manager, and they appeared to work smoothly.  While I am no expert at video editing, I was able to perform the listed tasks including cropping and color corrections, and Avidemux worked very well.  For someone with some sense of graphics and artistic talent, Avidemux would be an excellent choice.

            Since I lack a lot of artistic skills, I like simplicity when it comes to graphics software, and that is why I have been a long time user of the free VideoSpin video editor published by Pinnacle Software.  Available from www.videospin.com, the software is a large 162mb download.  VideoSpin is one of the simplest video editors to use, based on my own experiences.  While lacking some of the more advanced features of more sophisticated (and expensive) video editing software, VideoSpin is reasonably feature rich with a very simple front end interface that makes video editing a simple process.  For those who try this free version of VideoSpin and like it, but want additional features, there is a commercial version available.  The newly released version 2.01, in addition to the traditional video formats, now also supports QuickTime and 3GP video formats.  One interesting feature of the new version of VideoSpin is the ability to save videos in a higher quality and widescreen format, compatible with YouTube's newest standards.  Users can also directly upload their output directly to YouTube.  VideoSpin has an enormous and loyal following that have created countless videos for a multitude of purposes.  One reason for its wide use and popularity are the tutorial videos, some made by users, that clearly demonstrates how to create, edit, and distribute videos using VideoSpin.  These tutorials can be viewed by clicking on the How To link on the menu bar at the top of the VideoSpin webpage.  For those who need additional help, VideoSpin has a very active Community which includes a number of forums where users can post questions or request help, with a response likely in a short period of time.  VideoSpin will run on almost any contemporary PC with a Pentium or AMD processor with a speed of at least 1.4 GHz, but faster chips are recommended.  XP users should have at least 512 mb of RAM, and Vista users need at least 1 gb in order for VideoSpin to run.  Since editing video files is graphically intensive, a video card that is DirectX 9 (or higher) compatible, and has at least 64 mb of video RAM is required; almost all video cards manufactured in the past several years would meet that standard.  Being a large program, 150 mb of available hard drive space is required to install the software, and much more space may be necessary to store video files.  VideoSpin was the very first video editing software I ever used, and still use it.  For the user who wants an easy to use free video editor, VideoSpin would be an excellent choice.

            Any of the above free video editors will serve the typical home user well, and each would be worthwhile to download and try.  With any of these three free utilities, there is no reason not to have well edited and interesting videos.

EXAMINER 021910 - Edit Your Videos for Free.doc EXAMINER 021910 - Edit Your Videos for Free.doc









February 13, 2010

The Best Free Software According to Gizmo By Ira Wilsker
 
WEBSITES:
 
http://www.techsupportalert.com
http://www.techsupportalert.com/secwiz
http://www.techsupportalert.com/pc/security-tools.html
http://www.techsupportalert.com/content/easily-find-powerpoint-slides-and-presentations-using-site.htm
http://www.slidefinder.net
http://www.techsupportalert.com/view/hot
http://www.techsupportalert.com/tutorials 

 
            In these tough economic times, many of us are finding it difficult to afford new software for our computers.  Locally and on line we can shop and sometimes find some deals on software, but if money is especially tight, some of us would choose to do without.  Alternatively, there has always been a huge assortment of free software or "freeware" available that can adequately accomplish almost all computing tasks.  While there are some mega-sites such as download.com and tucows.com that each carry thousands of software titles, many of which are freeware, there are also some lesser known websites that provide comprehensive information and reviews about freeware.  One recent find that has now become one of my favorites is Gizmo's Freeware Reviews, at techsupportalert.com.

 
            Upon accessing the Gizmo website, the user is greeted with a graphical menu containing 20 categories of software, including cleanup, educational, games, Linux, security, programming, security, system tools, and a dozen others.  In addition to free software, Gizmo offers additional categories of information in its navigation window on the left side of the main page.  These additional categories include the Best Tech Websites, How-to Guides and Tutorials, Freeware Updates, Security Advice Wizard, and Video Tutorials, as well as some housekeeping functions.

 
            Since I am very concerned about cyber security, I chose to open the Security link from the front page graphical menu, one of the 20 possible selections.  I was greeted with a listing of about two dozen Gizmo articles on security software and related topics.  Ranked in order of number of hits, and indication of the popularity of each topic, the first security article is "Best Free Antivirus Software", which has had nearly 1.4 million hits.  Opening the antivirus article, the user is greeted with a non-technical explanation of antivirus software, followed by a discussion of what Gizmo has determined as the best of the many free antivirus utilities.  Gizmo awarded Avira AntiVir Personal Edition its top pick, narrowly beating out Microsoft Security Essentials, which is actually Gizmo's personal choice.  Each review is hyperlinked to a section farther down on the webpage, called the "Quick Selection Guide" which summarizes the pros and cons of each recommended product, download links, file size, latest version, 32 and 64 bit compatibility, installation tips, a discussion forum, and online help.  The other recommended antivirus products are Avast!, and a-squared Free. 

 
For those who might need help in deciding which security products would be most appropriate for their personal circumstances, Gizmo offers a "Security Advice Wizard" at techsupportalert.com/secwiz where the user selects his operating system, and answers some simple questions about internet habits and personal computer skills.  Upon completing the wizard, Gizmo makes a recommendation of an antivirus product and a firewall.  I tried the wizard using a variety of operating systems and levels of experience, and the wizard arrived at reasonable recommendations for each.  The user who follows the wizard's recommendations will likely be well served by its picks.

 
In addition to having information and reviews on software products, Gizmo also offers a wide selection of other helpful services and information.  One that I found exceptionally useful and interesting was a listing of PowerPoint slides and presentations, under the heading "Easily Find PowerPoint Slides and Presentations Using This Site" at www.techsupportalert.com/content/easily-find-powerpoint-slides-and-presentations-using-site.htm.  I do a lot of PowerPoint presentations in a variety of settings and to different audiences, and often have some difficulties coming up with material.  Gizmo may be of great help locating material, and one such resource linked on Gizmo is Slidefinder, at www.slidefinder.net. Available in 23 languages, Slidefinder has proven to be an outstanding resource, capable of locating individual slides and complete presentations on thousands of topics.  One of the most frequent PowerPoint presentations that I do is on identity theft; entering the term "identity theft" in the search box displayed Slidefinder's limit of 1000 items.  Scrolling over the displayed slides (20 per page), opens a larger image of the selected slide and also displays any notes integrated with the slide.  A link to the full PowerPoint file is also displayed, and a simple right-click on the file name and selecting "Save Link As" will download the complete file.  The primary source of the PowerPoint slides and files are hundreds of universities from all over the globe, as well as government agencies, organizations, trade associations, and other sources.

 
Another very beneficial section of the Gizmo website is the "Hot Finds" at www.techsupportalert.com/view/hot
This selection displays software deals, mostly free, offered by the commercial software publishers for a limited time.  As I type this, some of the commercial software being offered for free includes PC performance enhancing utilities, anti-malware utilities, backup utilities, graphics editors, and many others.  Frequently checking this list may provide the user with an occasional gem of commercial software either for free, or at a ridiculous low price, such as a recent offer (now expired) for a top rated $30 anti-malware product available for the paltry sum of 99 cents (I purchased 6 copies).

 
Many users sometimes need some help with accomplishing some computer tasks, or may even find some tasks that may need to be performed that they may have been unaware of.  Gizmo has a "How-to Guides and Tutorials" section at www.techsupportalert.com/tutorials, with over 50 topics listed.  The most widely used tutorial "How to Make Vista Run Faster" has been viewed over 300 thousand times.  Other tutorials cover different browsers, backing up critical files, improving performance, creating a bootable rescue CD, how to reduce spam, and many other helpful and useful subjects.  The Gizmo tutorials are presented in a readable non-technical fashion that is easy to follow and implement,

 
Gizmo has a wealth of information available, including free software that has been reviewed and evaluated, as well as tutorials and other valuable information.  I subscribed to both the RSS feed and email alerts so I can always be promptly informed of any new articles and software added to Gizmo.  Stop by www.techsupportalert.com and see what treasures that you might find.


 


 


 


 


 


 


 







February 06, 2010

Scumware and Scareware Warning and Removal By Ira Wilsker 

 

WEBSITES:

http://www.fbi.gov/pressrel/pressrel09/popup121109.htm

http://www.usatoday.com/tech/news/2009-06-09-cybergangs-scareware-hackers_N.htm

http://www.networkworld.com/news/2009/101909-scareware.html

http://blogs.zdnet.com/security/?p=4297

http://online.wsj.com/article/SB123976230407519659.html

http://www.malwarebytes.org/mbam-download.php

http://www.malwarebytes.org/mbam/database/mbam-rules.exe

http://www.emsisoft.com/en/software/free/

http://download1.emsisoft.com/a2usb.zip

http://www.threatfire.com

http://www.microsoft.com/security/malwareremove/default.aspx  

 

            Many of you have had the experience of having a popup or window open on your computer that tells you that your computer is infected with a substantial quantity of viruses, worms, Trojans, and other forms of spyware.  Typically, these warning messages, which may appear to be authentic Windows warnings, instruct the user to “click here” to remove the malware.  Upon clicking, another window opens which solicits a fee, typically $29.95 to $49.95 (or more) to purchase software to remove the infection.  The software being offered has an attractive and professional looking interface, and often carries a name that is intended to inspire confidence, sometimes even being similar to reputable product names that we have heard of before.  Trying to close the window often results in the popup reappearing again, almost instantly.  If we choose to ignore the warning or close it, it may continue to reappear whenever we click on a webpage, open our own already installed programs or security software, or randomly.  These warnings may scare us, or become so intrusive that many of us will pay to purchase the recommended software to clean our computers of malware and restore the usability of our machines.  By doing so, at a minimum, we just became the victim of a scam that according to the FBI has duped Americans out of an estimated $150 million. 

If it was only money that was lost, the damage would be bad enough, but the infection and hijacking that produced the popups and warnings in the first place may have also destroyed our existing antivirus software, deactivated our firewall, transmitted our vulnerabilities to unknown miscreants, and made our computers vulnerable to continued attacks.  Purchasing, downloading, and installing this rogue software may possibly also open us up to even worse attacks such as turning our computers into spam sending zombies that can generate massive income for the zombie master.  Other identified hazards of this software may include the installation of keylogging software to steal our usernames, passwords, and credit card information to be sold on illicit websites for criminal purposes including credit card fraud and identity theft.  Simply put, your computer may physically be in your home, but for all practical purposes it belongs to some crook somewhere who in reality has control over it for nefarious and pecuniary reasons.

            This may sound like science fiction or the theme of an action movie, but the scenario is a sad reality that has been repeated on millions of personal computers.  The victims of this scam may have visited websites, often legitimate websites, that have been victimized themselves by hackers who installed the dangerous code that can infect a computer by simply opening a webpage, causing the malware to be loaded onto the victim computer.  In some other cases the infection can occur by clicking on an apparently authentic looking online advertisement, opening an email attachment, or simply doing other online activities.  A lot of the victims clicked on links posted on Twitter, YouTube comments, instant messages, links illicitly planted in search engine results, and ads posted on legitimate websites. Many of these “drive-by” infections are explicitly designed to evade antivirus and anti-spyware software, and once on the computer, may destroy the ability of the antivirus and anti-spyware to provide any future protection.  The authors of this malware are smart, and if the legitimate security software is indeed neutralized, it will still appear to load and even update, as well as display the program icon in the tray by the clock, giving the user a false sense of security that his computer is still protected.  Not just is the computer no longer protected, but some of the malware sends out invitations to other cyber crooks to visit the buffet of purloined computers and help themselves to the bounty of goodies that may be available, as well as allow them to install additional spyware and malware on the victimized computer. 

Some of this illicit activity is done in a multi-level marketing or pyramid model where cyber criminals can pay the master crook for access, and then resell this access to others, who can then sell to others, each paying a fee or commission that is passed up the line to the master crook.  This is not some obscure threat or risk that we face, but a very common occurrence.  According to the security company F-Secure’s senior researcher Mikko Hypponen, one of these master criminals recently ran a contest offering a $36,000 Lexus sedan to the top-selling affiliate.  According to a report in USA Today, in 2008,  SecureWorks researcher Stewart infiltrated a Russian group known as the Baka Software gang. He accessed documentation showing one affiliate earned $146,525 in 10 days by spreading promotions for a worthless program, called Antivirus XP 2008, to more than 154,000 people, and closing sales to 2,772 of them. Another record showed five top Baka Software affiliates earning weekly commissions averaging $107,604.  In another example of the degree of infection, Microsoft reported that its Malicious Software Removal Tool found one specific fake security program on 4.4 million computers!  There are hundreds or thousands of these rogue programs currently infesting countless millions of computers.  This begs an answer to a rhetorical question; would you really want to give your credit card number and security code to a crook that is probably in Russia?  If you fell for this scam, contact your credit card company immediately and tell them what happened; also ask them to chargeback the charges made on your card by the crooks.

            If you feel that you have been victimized there are some free utilities that can likely detect and kill the malware.  Since much of this malware will not be initially detected by the protective software on our computers, and may in fact neutralize the protection that we do have, simply performing a scan with the security software we already have may provide little or no benefit.  It should also be noted that if the user cannot access the websites of the legitimate utilities that can detect and kill the malware, that is a sure symptom that the victim computer is under the control of the cyber crook.

            I am now receiving daily emails and phone calls from people describing a similar problem, complete with the typical symptoms of a scumware or scareware infection.  I have had very good results with a few free utilities that will likely detect and kill the malware, and remove it from our machines.  While there can be no guarantees that they will continue to work well, they do have a proven track record, and so far, have fared well in this cat and mouse game where the cyber crooks keep developing something new, and the security companies have to come up with a way to detect and kill the infection.

            My first choice is Malwarebytes Anti-Malware, available for download from www.malwarebytes.ORG.  I emphasized the .ORG because there have been knock-off websites with other upper-level domains designed to explicitly scam people looking for the authentic product.  Malwarebytes has both a free version and a commercial version.  As is customary, the paid commercial version has more features and capabilities, but the free version is fine for detecting and removing most malware.  Download it (probably from a link redirecting the user to CNet’s Download.com), install it, update it, and perform a scan.  A quick scan will detect malware in the most common locations in just a few minutes, but a full scan will be much more thorough, and may take an hour or two to run.  If the user cannot directly access the malwarebytes.org website, but is redirected somewhere else or totally blocked, then that is a sure sign that the computer has been hijacked.  If this happens, download Malwarebytes to another computer, and copy it to a flash drive or CD, and install it from that media.  It may also be a good idea to manually download the latest updated signature files (called rules), from www.malwarebytes.org/mbam/database/mbam-rules.exe, as access to the update server may also be blocked on the infected computer.  Install the Malwarebytes on the infected computer, and then run the file mbam-rules.exe to update the software.  If there is memory resident malware detected, Malwarebytes may direct the user to reboot the computer, and Malwarebytes will then automatically rerun at boot, killing the malware before it can load.  Update it and rerun it frequently to help keep your computer clean of malware.

            The other utility that I use along with Malwarebytes to detect and kill malware is A-Squared Free, available for download from www.emsisoft.com/en/software/free/.  A-Squared Free has a commercial sister product, A-squared Anti-Malware (www.emsisoft.com/en/) with more features and a memory resident component that provides real time protection in addition to the security software already on the computer.  Both versions also integrate a full featured virus scanner to detect more than most other scanners.  Download one of the versions of A-Squared (the free version is adequate if the user only wants to detect and remove malware and viruses), install it, and update it.  Do a quick scan for a quick clean, and a deep scan to detect more potential threats.  A-Squared also detects fragments, or pieces of code that may be a threat.  Since a detector as sensitive as A-Squared may occasionally detect a file and label it as a threat, but it is really a false-positive, I choose to initially quarantine anything that is found, rather than delete it.  That way, I can recover any files that may have been misdiagnosed.  A-Squared is another product whose website is commonly blocked by malware, in order for the malware to protect itself from removal.  If that happens, the A-Squared software can be downloaded to another computer, and copied to a flash drive or CD, and installed from that.  An alternative designed explicitly for just such an occurrence is A-Squared Emergency USB Stick Files (download1.emsisoft.com/a2usb.zip).  This version, which is kept up to date continuously on the Emsisoft website, is a 67mb download which contains all of the necessary files, is intended to be copied to a flash drive, and installed on the infected computer from that media.

            After the computer is cleaned of malware, the user will often notice a marked increase in performance.  Do not be complacent, because you may still be victimized even though your computer is likely clean.  Since your logons, user names, and passwords may have been compromised, it would be a good idea to change them, and repeat the scanning process on a frequent and regular basis.  It may also be necessary to reinstall your security software, as it may have been destroyed by the malware.  Consider installing another layer of security that works in addition to your security software, and enhances your protection, making a re-infestation less likely.  The paid commercial versions of Malwarebytes or A-Squared Anti-Malware would be good choices, or a freeware product such as Threatfire (www.threatfire.com) would provide enhanced protection in addition to the traditional security software.









  • January 30, 2010

    Downloading and Converting YouTube Videos By Ira Wilsker
     
    WEBSITES:
    http://www.forinside.com – Online download and conversion
    http://www.downloadhelper.net – FireFox Add-on and converter
    http://www.orbitdownloader.com – Automated downloader
    http://www.download-youtube.com -- Online download
    http://www.videolan.org – Free universal video player
    http://www.any-video-converter.com/products/for_video_free/
    http://www.dvdvideosoft.com/free-dvd-video-software.htm
     
                I frequently get emails from readers of this column and listeners of my radio show regarding problems they are having.  While I cannot guarantee an effective answer, I can at least try to help them out, or tell them where they can find a solution.  Some of the more interesting, or more common questions I will occasionally post here under the premise that if a few of you are having a similar problem, then many others are having a similar problem.
     
                Last Friday I was forwarded an email that had been bouncing around one of the departments at Lamar University about how to download YouTube videos and convert them to a format that can be used in PowerPoint.  Some of the faculty have rightly found that there is some useful content on YouTube that is applicable to academic lectures, and they would like to use this information in class.  Fortunately, there are several good solutions.
     
                My personal first choice in downloading YouTube videos and converting them into a format that can play in PowerPoint, or on most video players, is a free add-on for the FireFox browser called DownloadHelper ( www.downloadhelper.net).  DownloadHelper is extremely popular with FireFox users, having been downloaded and installed about 54 million times!  DownloadHelper places a small icon on the bottom edge of the browser window consisting of three colored balls; when the balls become animated, the DownloadHelper menu becomes available by clicking on the icon.  Left clicking on the icon shows the title of the video, and clicking the title downloads the video in YouTube's native FLV format to your computer.  Right clicking on the icon opens the menu which allows the user to convert the video into any of many popular formats.  Alternatively, clicking on the three-ball icon that appears to the left of the video title at the top of the screen opens a one-click menu that offers all of the options.  The one that I use most often is the "Download and Convert" which can download and convert the video in a single action.  For compatibility purposes, especially when embedding the video in PowerPoint, I mostly select the WMV (Windows media format), but sometimes choose the QuickTime MOV, or AVI formats.  For those who do not have FireFox installed, it is available free at getfirefox.com, and does not interfere with any other browser on the computer.
     
                For those using any browser, there are several free online services that will download YouTube (and other) videos to your computer, and some will also convert them to popular formats for you.  Even though its server is frequently busy and located in Brazil, I like Forinside, at www.forinside.com. Forinside is extremely easy to use; all the user needs to do is copy the URL (web address) of the video and paste it into the textbox, and use the pull down menu to select a format.  Clicking the download button will start the process.  Forinside can convert online videos into any of the 10 most widely used formats, and can download videos and audio from YouTube, MySpace, Google Video, and Mp3Tube.  For those who already have videos on their computers that they would like to convert into other formats, Forinside offers that service for free.  Simply click on the orange "File" tab, then "Browse" your hard drive for the file you want converted.  Use the pull down menu to select any of the 10 formats available, click on "Convert" and Forinside will upload the original video to its server, convert it to the chosen format, and then download it to your computer in the new format.  Your original video remains intact on your computer.  As stated above, the Forinside server is often very busy.

                Another service that can download YouTube videos directly to your computer is Download-YouTube.com.  This site is very easy to use from any browser.  Simply open the desired YouTube page, and in the address bar of your browser insert  the phrase "download-" (download hyphen) before the word "YouTube " in the URL, and the user will be directed to the Download-YouTube web page.  On the Download-YouTube page either click on the "Click here to download" link, or right click and "Save Link As" or "Save target as" and the file will be downloaded in the native YouTube FLV format.

                One of the easiest free YouTube downloaders is Orbit Downloader, available at www.orbitdownloader.com. This download tool has some of the highest editor and user ratings on the popular download sites, and can accelerate downloading of not just YouTube videos, but most general downloads as well.  Orbit Downloader integrates seamlessly into Internet Explorer, FireFox, and Opera, and includes a "Get It" button that appears when connecting to YouTube that offers a single click download.  YouTube videos will be downloaded in their native FLV format.
     
                There is a free bundle of video software that can download YouTube and other media, convert them to most formats, and even edit video and audio files.  The software bundle aptly named "Free Studio" contains 23 video and audio utilities, and is a 30 Meg download available for free download from www.dvdvideosoft.com/free-dvd-video-software.htm. According to the publisher of Free Studio, "With this free software you can convert video and audio files between different formats and to iPod, PSP, iPhone, BlackBerry and other portable devices; burn and rip DVDs and audio CDs; upload and download videos and music to your computer, iPod, PSP, iPhone and BlackBerry; perform basic editing of audio and video files."  This bundle, reviewed and top rated by several of the major download sites, may be a worthwhile bundle to download and install.
     
                If there is a need to convert the YouTube FLV videos, or any other video formats, into a more useful format, such as WMV or MOV, a utility called "Any Video Converter Freeware" may be useful, as it supports dozens of video and audio formats, and can easily convert files between these formats.  This software is available for download from
     
    www.any-video-converter.com/products/for_video_free, and according to its publisher, has been downloaded over 25 million times.  The online service CNet gave Any Video Converter Freeware its highest 5-star editors' rating.
     
    If your only need is to play downloaded YouTube videos, there is an easy and free solution that does not require any conversion utilities.  YouTube's FLV format can be played on the universal video player (free) VideoLAN - VLC Media Player (www.videolan.org ).  The VLC media player is one of the most widely used video players in the world, with over 110 million downloads, and has earned a very loyal following.  VLC media Player can play almost every available video and audio format without the need for any plug-ins or add-ons, and is available for free, and will run on almost every operating system.
     
    With these utilities and services, downloading YouTube and other videos and converting them into another useful format is simple.  I routinely use such downloads in class both as individual videos, and as videos embedded in PowerPoint.  There is much that can be done with online videos, and these utilities and services are worthy of a try.

    January 23, 2010

    More Helpful Tools from Google By Ira Wilsker
     
    WEBSITES:
    http://www.google.com/goog411/
    http://www.youtube.com/watch?v=cN0q8SvlQAk
    http://maps.google.com/help/maps/streetview/
    http://en.wikipedia.org/wiki/Google_Street_View
    http://code.google.com/apis/maps
     
    It is no secret that Google is one of the most sophisticated, progressive, and successful technology companies.  What started as a search engine has become much more, as more technology is incorporated on the web.  Google has been very successful by implementing more useful tools and utilities, providing more value to its users.  Some of Google's more interesting features which I have been recently utilizing are its "411" information service, and Google Maps "Street View".
     
         Many of our local phone companies and wireless carriers charge a fee for using the once free 411 directory assistance service to find phone numbers.  In recent years some 411 information competitors have come on the scene offering a variety of directory assistance services either for a fee, or after listening to a mandatory commercial advertisement.  Google has entered the fray with its new, free, GOOG-411 service.  According to Google's 411 website (google.com/goog411), "Google's new 411 service is free, fast and easy to use. Give it a try now and see how simple it is to find and connect with local businesses for free.  Your telephone company may apply usual charges for making a phone call or receiving an SMS. You will not be charged any additional 411 fee."¯  The process of getting directory assistance from Google is very simple three step process: first, dial 1-800-GOOG-411 from any phone; then state the location and business type. Google will then connect you to the business for free.  That is all there is.  I just tried it by calling the 800 number, giving my city and the name of my favorite restaurant, and Google connected me directly to the restaurant!  It was that fast and easy, and it was free.  This 411 service could be very useful not just locally, but while traveling, or looking for a distant phone number.  A non-local phone number connected in this manner is connected without incurring a long distance charge when 1-800-GOOG-411 is dialed from a home phone.
     
    Google Maps has been a mainstay and leader in the online mapping business.  In an earlier column I expounded on how useful Google Maps (maps.google.com) is for generating local and long distance driving directions.  Recently, Google Maps released the latest iteration of its "Street View"¯ feature which shows integrated street level photos of almost every street in the United States, as well as most major cities in Europe, Australia and eastern Asia, and is currently generating street level photos in several countries in South America.  As an experiment, I entered the street address of The Examiner into Google Maps, and was presented with the traditional street map by default.  The street map had buttons on the top to display the same area as a high resolution satellite image, a hybrid with streets overlaid on the satellite image, or as a topographic map.  On the top left corner of the image was what Google calls its "Pegman"¯ icon, a small orange image of a man that some users say looks more like a wooden clothes pin.  By dragging the Pegman (click on the Pegman icon holding down the left mouse button and moving the cursor) over the chosen location opened a new window on the top half of the image.  This top window was an interactive street level image which could be zoomed in or out, rotated in any direction, and dragged up and down the street.  The location determined for The Examiner by Google Maps based on the street address was off by about one-half block.  Dragging the image a few inches, the Examiner building, parking lot, and cars came into view.  An additional photo of the park across the street from the Examiner was also available, as displayed on the map.
     
    For a second experiment I entered my street address, selected the hybrid satellite view, and dragged Pegman over the image of my house.  When the top street level image opened, I saw that it was actually one house north of my house.  I dragged the image slightly south, and there was a clear image of my house, complete with my white van parked in the driveway.
     
    Google says on its website that these Street View images have a lot of functionality including personal use, business use, and educational use.  With Street View the user can easily explore the world visualizing the selected locations.  Since these images have been taken by GPS and laser range finding equipped Google vehicles driving up and down the streets, a lot more than just buildings have been captured.  Google and several independent websites have posted hundreds of unexpected and interesting Street View images captured by Google including fires, auto wrecks, romantic encounters, crimes, street entertainment, and countless other events captured by Google as they occurred.  For those concerned with privacy issues, Google says, "We then apply cutting-edge face blurring technology, which helps make sure that passers-by in the photographs can't be identified. We will also blur legible license plates."¯
     
    Users who have smart phones or other mobile internet devices can use Street View to view images of specific destinations, landmarks on street routes, parking lots, and other helpful scenes and integrate these with driving or walking directions.  According to Google, these are some of the actual uses that people have posted, including looking for public transit, at a nearby beach, and other points of interest.  Many times the Street View can give better and more useful information that just a traditional street map.  Businesses can use the service to promote their businesses by showing their building facade, nearby buildings and features, and other attractions.  Real estate agents have been using the service to show neighborhoods around their listings, and conduct virtual neighborhood tours.  Some teachers have used Street View to conduct virtual field trips, as well as integrate the images into geography and history lessons.  News organizations have used the service to show the location of news stories, both local and distant.  There are very strong marketing and research capabilities with Street View.  Street View images can be incorporated on a web page by using Google Maps API (code.google.com/apis/maps).
     
    Google has a lot of useful features that are also fun to use.  The Google 411 service and Street Views are but two of the many benefits of using Google.  You should experiment also by entering your street address and dragging Pegman over your house or business, and viewing your location.  Try calling 1-800-GOOG-411 and asking for a business, just to become familiar with the service, and also program that number into your cell phone.  Have fun with and enjoy these services from Google.

     

    January 09 & 16, 2010 

     

    CrimeReports.com – The National Crime Map By Ira Wilsker:

     

    WEBSITES:

    http://www.crimereports.com

    http://www.crimereports.com/files/CommandCentralBrochure.pdf

    http://www.crimereports.com/files/CrimeReportsBrochure.pdf

    http://www.crimereports.com/iphone

    http://www.youtube.com/watch?v=hNX1YTOeU8U    iPhone demo

    http://www.youtube.com/watch?v=wtvKb4bEN9Y    TV Report

    http://www.youtube.com/user/CrimeReportsVideos

     

                At present, over 600 law enforcement agencies are participating in an online service, CrimeReports.com.  Claiming to be the largest crime mapping network in North America, CrimeReports.com gives people the information that subscribing cities was displayed.  Scrolling through the list, I found that my home city was not listed, but does display local registered sex offenders.  The closest participating city to my home is Jasper, Texas, so I clicked on the Jasper link on the pull down menu.  I zoomed in centering on the center of town, and the crime map was very easy to read.  I selected the most recent 14 day period, and the incidents were clearly displayed.  On the left margin of the map was a listing of offenses, which I sorted by date.  Alternatively, clicking on one of the displayed icons displayed the type of crime, the date, the address, time, and reporting agency.

                There is much more information available then just displaying a crime map.  Clicking on the Analytics tab on the top of the web page opens up a detailed crime analysis graphing utility.  On the top of the display the user first clicks on a state from the pull down menu, and then in the adjacent column clicks on a participating jurisdiction.  As with the maps, specific time periods can be easily selected.  The first graph displays the type and number of crimes as a bar graph. The second chart shows a pie chart showing types of crimes as a percentage of total crime.  The bottom of the web page shows crime trends, color coded by type of crime, and charted by date and number.  With the maps and analytical information, residents and businesses can be better aware of the criminal risks throughout an area.

                While all of the information on CrimeReports.com is freely available for anyone to access and use, it also offers several advantages to those law enforcement agencies that subscribe to the service.  The analytics can be used by neighborhood watch and community oriented policing activities to identify problem areas, allocate resources, set goals, and measure progress.  City councils may find the information very useful in terms of ordinances and budgetary planning.  The law enforcement agencies themselves may make use of the service with several non-public analysis tools called Command Central.  This service integrates with any existing CAD or RMS systems, and supports CompStat-style analysis.  While secured, authorized users can access the information online using any web browser.  The integral Roll Call feature can display crime maps and statistics on a precinct or district basis, alerting officers to potential crime patterns.  In researching this column, I found several complementary reviews by law enforcement personnel that explained how the system is used to maintain and disseminate crime reporting information.  A TrendCaster function … ccan be used to evaluate policy changes, beat assignments, and overall crime trends with a heat map that highlights areas where crime is on the rise and decline.

                Agencies can also use CrimeReports.com as a public information tool alerting residents of potential situations.  The website offers free email alerts which will deliver contemporary crime maps directly to the subscribers inbox.

    "Residents can sign up for automated emails that let them know where crime has happened near their home or place of work. All alerts are customizable by location and area. In addition, citizens can choose to receive daily, weekly, or monthly alerts, and they have the freedom to choose which crime types they want to track..  There is also a free iPhone application available for download that offers great functionality. The iPhone app will display crimes by location or address, crime type, and customizable date range; display data on the crime map or in a list view; show national sex offender data alongside crime in your neighborhood; and provide free, automated, email crime alerts.  CrimeReports.com also disseminates information in real-time on social networking services such as Twitter and Facebook.  There is also a free widget which can be installed on the agency website to give residents access to a local crime map without having to leave the agency website.

                Crime is something we all must be aware of and deal with. By using the capabilities of CrimeReports.com residents and law enforcement alike may benefit through increased information about local threats and trends. It is a very worthwhile service. 


     

    January 02, 2010

     

    What You Need for that New Christmas Computer By Ira Wilsker 

     

    WEBSITES:

    http://www.microsoft.com/security_essentials   FREE Security software

    http://www.cloudantivirus.com    Panda Cloud Antivirus

    http://free.avg.com    Free AVG

    http://www.avast.com   Free Avast!

    http://download.cnet.com/ZoneAlarm/3000-10435_4-10039884.html 

     

                Now that Christmas and Hanukkah are past, many of you have opened that new computer and delved deep into its features.  Preliminary estimates are that a huge number of new computers were purchased this holiday season, and a refresher is in order such that you have some idea of what you may need with that new computer in order to maximize your computing security and safety.

                Most new computers came with some edition of Windows 7 installed, which appears to be a vast improvement over the Vista which was installed on last year's holiday computers.  Despite its improvements, Windows 7 still has vulnerabilities that need to be addressed.  Contrary to some allegations floating in cyberspace, I am utterly convinced that some comprehensive security software is an absolute necessity.  Almost all new computers come with a limited trial version of security software, such as Symantec's Norton, or a McAfee security product.  While these trial versions are functional for their short life expectancies, the clear intent is to sell you a paid subscription, often at an un-discounted full retail price, once the limited version expires.  Be aware that it is not the unbiased recommendation of your computer manufacturer that you purchase that particular software, but a crass commercial activity, whereby the computer maker may have been paid to put that trial version on the computer, and may receive a hefty commission in the event that you pay for a subscription.  One major computer maker even offers not to install this commission bearing software on new computers for a $50 fee!  That should be an indication of its value to the computer maker.

                You need decent protective software, consisting, at a minimum, of antivirus, anti-spyware, and a firewall.  While you may be protected for a short time by the trial versions of the security software factory installed on your computer, you have time to shop around for deals on security software, or to try some of the free titles that are available.  Watch the Sunday sale books for the big box electronics stores and office supply companies, as many are offering deals, including high value rebates on major security titles.  As I type this, one big box store in particular has three major comprehensive security suites advertised for between free and $10 after rebates; each package is good for up to three licenses, meaning that you can legally install it on up to three computers.  Two of those three titles are the exact same products that are commonly installed as trial versions on new computers that offer an annual subscription for $40 to $70, but are available almost for free (after rebates) from the big box store.

                Maybe holiday bills are coming due, and you would like to save some money by using some of the free security software that is available.  There are some excellent freeware products available that will do as good a job protecting your new computer from cyber threats such as viruses, spyware, and malware as the expensive commercial software, and sometimes even better!  One such free product is Microsoft's new Security Essentials which is a no frills but competent security product that can protect that new computer from viruses, worms, Trojans, and most other malware attacks.  Fully compatible with Windows 7 (and Vista ), this product can be downloaded for free directly from Microsoft at www.microsoft.com/security_essentials.  Another excellent free product that can protect your new computer from malware threats is Panda's new Cloud Antivirus, available at www.cloudantivirus.com.  Other very reputable free products are AVG's AntiVirus Free Edition (free.avg.com) and Avast's Free Home Edition (www.avast.com).

                You need to have a firewall to protect your computer from intrusions by outsiders, such as hackers and crackers.  Users are often blissfully unaware that while online, inadequately protected computers are very commonly probed or attacked by miscreants looking for weak spots.  A good firewall makes this more difficult as it acts like a guarded and locked gate that greatly restricts unauthorized access from others in cyberspace.  The firewall built into Windows 7 is minimally adequate, and should be turned on unless supplanted by a third party firewall.  Many of the comprehensive security suites include a firewall, and there are several free firewalls available.  The most popular free firewall is ZoneAlarm Free Firewall, available for free download from CNet's Download.com download.cnet.com/ZoneAlarm/3000-10435_4-10039884.html.  With almost 50 million downloads from CNet alone, the ZoneAlarm Free Firewall is probably the world's most widely used free firewall, and it has well earned that distinction.

                One very strong warning is appropriate here; do not, under any circumstances, purchase security software that first appears as a popup window on your new computer and informs you that you are infected with a raft of viruses and Trojans, and that for a fee, you can download its product and forever rid yourself of the threats.  This is a scam known in the trade as scareware or scumware and is often worse than useless, as it often installs even more malware on your computer and protects you from nothing, and possibly even opens up your computer to a wider attack by key loggers, password stealing Trojans, and other terrible threats.

                Something that is often overlooked that is a threat to computers is the electricity that is essential to operate them.  In reality, we do not always receive clean electricity, but instead receive power that varies and has surges, spikes, and other forms of electrical noise.  Bad electricity, mostly in the form of power surges can kill a computer quicker than a bullet can.  Another imperative is a good quality surge suppressor which should infallibly be used between the computer's power plug and the wall socket.  A surge suppressor may look somewhat like a common power strip, but its internal electronics are dramatically different.  Look for a UL 1449 label indicating that the suppressor meets UL standards, and the higher the joule rating and faster the response time, the better.  I carry a small surge suppressor in my laptop case, and have a larger one (actually a UPS or Uninterruptible Power Supply) attached to my desktop computer.  Many surge suppressors also come with connections to protect phone (and fax) lines, network cables, and TV cables, all of which can carry electrical noise and power spikes to the equipment.  Bad electricity can instantly fry sensitive computer components, and a good suppressor offers some valuable protection.  Most of the time the user will never know that a suppressor just saved their precious electronic equipment from certain destruction, as it typically performs its tasks silently.  Suppressors do wear out and need to be replaced periodically, with failure often indicated by an LED showing that the suppressor is no longer protecting the equipment.

                There are other useful items for that new computer that will increase its functionality and longevity.  More memory will improve performance up to certain limits; 32 bit Windows 7 can use up to 4 gigs of memory, and the 64 bit Windows 7 can utilize much more than that.  Memory is readily available and can often be installed by the user, but may not be cheap.  I recently spent about $50 (after rebate; $75 before rebate) for 4 gigs of additional memory for my 64 bit Windows 7 machine, and there was an increase in performance.

                That new laptop really needs a good case to protect it from bumps and physical shocks.  Laptop and notebook computers are often fragile creatures, and need substantial protection from physical harm.  Get a good carrying case for your size laptop, and be sure that it has a lot of padding on all 6 sides and gives the computer adequate protection from all directions.  You may never know when that case protected you from a cracked screen or worse, which would have either been a very large repair bill, or an otherwise useless computer.  Play it safe, and get and use a good case for your laptop.

                My late grandmother Dora had an old-world expression that she said anytime anyone in my family made a major purchase or received a major gift, and I am wishing the same for you and your new computer, Use it in good health!