I really want to learn Microsoft Office

If you have worked in educational professional development, at some point you have asked your audience this question.  “What technology would you like to know more about?”  I asked this question to my school district in the early 1990s.  Microsoft had just come out with Office 3.0 (the first version) which contained Word 2, PowerPoint 3 and Excel 4.  I think they averaged those numbers and gave it the version number three.

In my career, here are the word processors I have learned to use.  I have never attended a training to learn how to use a word processor.

For several years I repeated summer PD with my teachers and each year the same “technology” was requested.  Most teachers were interested in learning more about Microsoft Office.  Sometimes there would be a few teachers asking specifically for one application like Excel or PowerPoint, but it was always something to do with Office.

Times have changed.  The number one item I hear about now is the SmartBoard, but Office follows in a close second.  If a school does not own SmartBoards and does not plan to buy them, Office is still number one.

The funny thing is, I have never taken a class to learn any version of Office.  I have read several books and used assorted online resources, but I have never sat in a class for the purpose of learning how to use Office.  Yet, I have learned to use sixteen different word processors since my first job.

The technology standards for the state of Ohio have an indicator which states all ninth graders will:

Demonstrate proficiency in all productivity tools (e.g., word processing, spreadsheet, database, desktop publishing).

And these standards were adopted almost six years ago in 2003.

I am using Office 2007 right now.  Office 2010 will be out later this year.  The freshmen I have in class this fall will still be using the old version.  Long before they graduate and get jobs in schools, Office 2010 will be out and widely adopted.  By the time they teach ten years, few people will still be using Office 2007.

This is why a personal professional development plan is so important.  If we do not keep up with the basic technologies on our own, we will never master the use of advanced technology tools which really are exciting to use in the classroom.

Posted in edtech | Tagged , , , , , | Comments Off on I really want to learn Microsoft Office

Dell and Dead Pixels

This picture has five dead pixels.  Would you consider a display like this defective?

I have had a streak of bad luck that has placed Dell on my “do not recommend” list. It all started in 2003 when a brand new Dell Latitude arrived with a couple of dead pixels. I called Dell and they had someone at my house the next day to replace the screen. The technician did as good a job as he could have done, but there were pry marks on the lid. I still have this laptop and those marks are there to this day.

Fast forward to 2009. I needed to replace the aging Latitude so I purchased a Studio 17. The models at BestBuy did not include the back lit LED. I had to order the computer online. You guessed it.  The screen arrived with several dead pixels. I called customer care and after explaining the problems with the replaced screen in 2003 Dell agreed to send me a new machine instead of fixing the defective one. It took an extra week to get the replacement, but it was a new computer without defect.

This week I needed another computer. I ordered a Studio 15 from Dell and for the second time in as many months, the computer arrived with dead pixels. This time customer care was not as understanding. They explained that dead pixels were OK as long as there were not too many. According to Dell, five dead pixels on an LCD screen is OK and with today’s high resolution displays this number is recognized as an industry standard. Apparently the lucky people get LCDs with no dead pixels and I have not been lucky in my last two purchases.

I demanded my money back. I will not purchase goods and services from companies that peddle defective equipment. The customer care person transferred my call to the refund department. Those people could not help me. They transferred me to the people who process refunds. They could not help me either so they transferred me to someone else. Six transfers later, each one supposedly the one who could refund my money, I was told by Johnny that I would have to pay a 15% restocking fee since the computer was not defective.

This picture has five dead pixels.  Would you consider a display like this defective?

In the last fifteen years I have purchased more than 50 Dell computers. I have had a few problems along the way, but I have continued to purchase Dell computers because they have fixed things quickly without a hassle.

I have been hassled one too many times and will not be purchasing another Dell, nor will I be recommending Dell to my family, friends, school and PLN. I have already replaced the defective Dell with a competitor’s computer with no dead pixels.

If you are interested in Dell’s “Pixel Quality” policy, you can find it here.  Dell’s policy is difficult to find with Google because it does not contain the phrase “dead pixel.”  Dell uses “dark dot” instead.  If you have a screen with dark dots, you will have to have six of them before Dell considers the display defective.

This “dark dot” terminology could relate to the fact that each pixel consists of three small dots or sub-pixels.  Each dot is either red, green or blue.  Together, the dots make up a single pixel capable of showing any color.  Using this terminology, one completely dead pixel is actually three dark dots.

HP also uses “dark dots” to describe “minor cosmetic manufacturing anomalies or irregularities.”  HP’s policy (here) is subject to the resolution of the display.  At lower resolutions, HP’s policy is similar to Dell’s.  If a screen has more than 2.1 million pixels, HP requires a total of nine bright or dark dots to qualify the device as defective.  There is an exception if the dots are within 15mm of each other.  In that case, only 2 dark dots are required for replacement.

Apple’s policy (here) does not state the specific number of dead pixels required to categorize an LCD screen as defective.  Apple states this:

If you suspect your display contains a high number of pixel anomalies, take your Apple product to an Apple Authorized Service Provider for closer examination. There may be a charge for the evaluation.

Not only does Apple not state how many pixels it takes, but they may also charge you a fee to have someone tell you your monitor is not defective.

This picture has five dead pixels.  Would you consider a display like this defective?

The manufacturing processes continue to improve, yet I am seeing more defects.  High resolution screens have been around for a long time.  My 2003 Latitude has a 1600 x 1050 screen.  I still do not have another machine with higher resolution and that Dell is six years old.  Manufacturers have cut every possible cost to make the lowest priced computers.  The problem is poor quality control.  Now the manufacturers are letting the defective devices slip into the production line, but still manage to pass the “cost” onto the customer.

If you want to avoid dead pixels, purchase your computer from a shop that will permit you to see the display before leaving the premises.  If you purchase a computer with no dead pixels, your chances are good that none will die before the warrantee expires.  In the last ten years only one of my laptops has “developed” a dead pixel and that was when the machine was eight years old.

If you purchase your computer online and have dead pixels, use the proper terminology when talking to tech support.  Use “dark dots” when describing the problem.  Also make sure you have six or more dark dots before you call for help.  HP describes a dot as one third of a pixel.  By their definition, two completely dead pixels is a total of six dark dots.  I’m not sure what kind of math each manufacturer uses.  Be ready to reduce terms to the lowest common denominator. Hopefully poor customer service does not become an industry standard.

Posted in edtech | Tagged , , , , | 1 Comment

Architecture Field Trip

Many early settlers of Findlay, Ohio built homes along two east-west streets. Front Street was next to the river and Back Street was the next street south, away from the noise and smoke generated by local factories. Later, Back Street became Sandusky Street. Findlay benefited from the oil and gas boom of the late 1800’s. Most of the benefactors of this wealth built extravagant homes on South Main Street which intersects Sandusky in downtown Findlay.

This week I chaperoned my daughter’s field trip.  For the past few weeks her class has been studying architecture.  In preparation for this field trip, the students identified many types of physical structures.  Each student used a pencil to draw examples of columns, arches and other building features.

We took a school bus to West Sandusky Street in the historical section of Findlay.  Starting at the Hancock Historical Museum, we walked several blocks examining the architecture of houses and other buildings.  We were led by local historian and author Linda Paul.  Linda lives in one of the houses on our tour and has researched most of the homes in the historical district of Findlay.

As we walked past each house, the architectural features were pointed out and students took pictures with digital cameras.  On a worksheet, students recorded the address of each home and categorized the type of architecture observed. We ended the first half of our tour at Corporate Research International headquarters on East Sandusky Street. This four story building was built in 1905 to function as a grocery distribution center.  We went from the basement all the way to the roof.  One of the main features of the building was a four-story slide that was used to “drop” groceries from each floor down to the first floor where horse-drawn wagons picked up supplies.

Here are the pictures from my group.

http://www.flickr.com/photos/trustypics/sets/72157617807271870/

http://www.flickr.com/photos/trustypics/sets/72157617807271870/map Geotagged Version

As you look through the pictures note the differences in the houses.  This is in striking contrast to our neighborhood where two other families live in houses almost identical to ours.

When we finished the tour, Linda passed out a Walking Tour pamphlet she developed for the museum.  Each historical home on Sandusky and Main Streets is listed with its architectural features, building and year of construction.  This gave the students a chance to check their work and ask the historian questions about specific houses.  It was a valuable learning experience for all.

Posted in edtech | Tagged , , | Comments Off on Architecture Field Trip

Univ of Findlay – Div II National Champs

Tyler Evans hit a three pointer at the buzzer to give UFindlay a wire to wire number one ranking.  No other team has ever gone 36-0 in division two NCAA basketball.  It was a true effort.

Throughout the season, all five starters managed to average double-digit scoring.  In the final two games, critical players fouled out before the overtime period.  Each time other players stepped up and more than filled the shoes of the starters.  A deep bench has enabled the Oilers to literally wear out opponents all year long.  When division two player of the year Josh Bostic fouled out, Tyler Evans came in and nailed the winning shot in the championship game.

There is something else unique about this group when compared to other division two teams.  All the UF talent came from Ohio and every player started as a freshman at Findlay (no transfers). With only 3500 students, we have a greater opportunity to get to know our athletes.  I have had three of the basketball players in class as well as four of the cheerleaders.  Congratulations to all of them!!!

Here’s a picture from the celebration today outside Croy. Tyler Evans is wearing the black hat.

Here are the links I’ve collected from the championship run.

http://delicious.com/atrusty/UFindlayNCAAChamps

Posted in leisure | Tagged | Comments Off on Univ of Findlay – Div II National Champs

Backup Plan

More and more our personal and professional information is stored in digital format.  This is great because we can easily make copies and backups of our information and prevent accidental loss.  The reality of the situation is that many people do not make regular backups of digital data and often lose everything when one hard drive crashes.  Backups take time and most people do not take the time every day to manually make copies of important files.  Personally, I cannot spare the time to do backups every day.  That is why I have automated the entire process and it happens either in real time, or while I sleep.Quantum Fireball [15/52]

When asked, I tell people that my computer does more while I sleep than most computers do all day long.  Truthfully, my computer probably does more while I sleep than 90% of the people I know do at any time.  I did not pull that number out of the air.  Over the years I have determined nine out of ten people that I know do not backup computer files regularly.  I know this because I am the person that gets the call when their hard drives fail.  In 2008 I had more than a dozen of these calls.  They always start with, “I know I should be backing my files up, but…”  Finish that with some story involving a lack of “time.”

To take the time constraint out of the equation I have a two-pronged approach to my backups.  I start with Microsoft Mesh (blog post here and here).  I have four computers (office, Dell laptop, Macbook, home desktop) on my mesh.  When I create or update a file on any one of these computers, the file is automatically pushed to all other computers in my Mesh.  In addition, a copy is uploaded to my Mesh web page.

Here is a typical example of how the process works.  I use my Dell laptop in class.  Many times I have edited a PowerPoint (added or updated a slide) immediately before class starts.  As soon as I hit “save” on my Dell laptop, the updated file is copied to my office computer and to my Macbook and desktop computer at my house.  Without the Mesh, I would have at least two copies (one on my Dell laptop and another everywhere else) of that PowerPoint file and at some point I would have to figure out which one is the “best” one to use in the future.

There is a downside to the Mesh.  When I updated that PowerPoint file, the old version of that file was destroyed forever on all four of my computers and replaced with the new version.  This is why I have a second automated backup of everything.  This is a full backup of my data files stored in a classic grandfather-father-son rotation.  By this, I mean I have three separate and complete sets of backup files.  I create a complete backup on Monday.  On Tuesday another full backup is created in such a way that Monday’s files are not touched.  Finally, on Wednesday a third complete backup set is created leaving both Monday and Tuesday sets intact.   On Thursday the process starts over and the Monday set is erased to make room for the Thursday backup.  Friday replaces Tuesday and Saturday replaces Wednesday.  I do not run backups on Sunday because I do not normally work on Sunday.  More importantly, I have three external hard drives and adding Sunday would mean purchasing a fourth drive.

At one time I used Cobain Backup to automate my backups at night.  Last year I switched to Microsoft’s SyncToy.  Cobain and SyncToy are both free.  To make this process work, I did have to spend a little money.  I bought three USB hard drives.  You can pick up 250 GB hard drives online for as little as $50 each.  The size of the drives you need is dependent on how much data you have to backup.  I use three 500 GB drives for my backups.  On any given night I backup about 180 GB (docs, databases, photos, music and videos) and that amount is growing all the time.

SyncToy does not have a built-in scheduling tool, but the operating system scheduling tool can be used to automate sync’ing.  In the Help file of SyncToy read the section called “Learn How to Schedule SyncToy.”  I switched to SyncToy to make recovery easier.  All the files are copied over “as-is” to my external hard drives.  Cobain created one big archive file which made recovering a single file more complicated.  SyncToy also has a “contribute” mode.  Using this does not actually wipeout older backups.  The software compares what is already backed up and adds anything new.  If I delete a file from my desktop, the file is not deleted from the sync’ed hard drive.  Because of this, any deleted files will still be on the backup even after the three-day recycle period has started.

The beauty of my system is the amount of my time it takes.  Backup files are created for me as I work (Mesh) without any interaction on my part.  While I sleep full duplicate archives (SyncToy) are created for me.  Each morning, the first thing I do on my computer is check the previous night’s backup to make sure they were created.  It takes less than a minute to do that check and that is the total amount of time I spend on backups.  It is time well spent.

Posted in edtech, efficiency | Tagged , , , | 1 Comment