Since publishing the IditaRead KMZ map and the corresponding Microsoft Excel workbooks, I’ve had the opportunity to introduce them to several of my computer lab classes, and two teachers who are implementing them.
The 6th grade, 5th grade, and 4th grade classes learned how to download the KMZ file and save it in their Documents folder or flash drive. They then uploaded the file into their Anchorage School District Google Apps accounts. and imported the file into a new Google map.
Generally the process was smooth, complicated only by glitches in the lab computers, which were of two types: dysfunctional browsers and restricted file-saving permissions. As is the case with all technology idiosyncrasies, we worked around the problems and the students all have their own version of the map.
The 3rd grade class is doing a little different project. The classroom teacher downloaded his own KMZ file, uploaded it to his Google map, added individual student names to the Team icons and assigned them a checkpoint to research. He then shared the map with me, I uploaded a copy to my Project Documents page, the students downloaded their own copy and imported the file into their own Google map.
For those classes and schools who want to track individual rather than team scores, I’ve adapted the IditaRead workbook to handle up to 200 students. If you need more than 200, you can simply use the Fill Down technique to add as many lines as you need.
The IditaRead Microsoft Excel workbook is set up to calculate trail progress at 60 minutes per 10 miles. Use the Rate sheet to adjust how fast your teams make progress on the trail. Entering the rate you decide will affect all calculations on the Data sheet.
Also included is a macro button to erase all data when you want to start a new race. If you are not comfortable with downloading a file with a macro in it, I’ve included two non-macro-enabled versions.
If you use the non-macro-enabled workbooks, you will either have to:
manually delete the times that students have read in order to start a new race
OR download a new, fresh copy of the workbook
OR keep a blank copy on hand and do a SAVE AS to duplicate it with a new name.
The Iditarod Typing Race has a more detailed Rate calculation sheet. It enables you to accurately predict team progress based on students’ typing wpm.
Step 1: Download the KMZ file from my Project Documents page. Look for the Iditarod folder and click on the Download link for Iditarod Gee Read.kmz. The direct link link to the download file is here. Pay attention to where you are saving the file on your computer or flash drive.
Step 2: Log in to your Google account. Anchorage School District students and teachers can use their Google Apps account. Go here if you do not have a Google account.
Here’s a Microsoft Excel workbook that converts the amount of time that students read into trail miles. Workbooks are available for teams of up to 16 readers, or as individual readers.
The workbook has a Standings sheet (shown above); a Data sheet for entering minutes read per day and converting time into distance; a Team Progress sheet that converts distance into relevant checkpoint position; a Trail Position sheet; tables of checkpoints and distances for the Southern, Northern, and Fairbanks routes; and a restart sheet containing macro-enabled buttons.
In the example above, minutes are converted to miles at the rate of 60 minutes of reading to 10 trail miles.
The Team Progress page adds up the total miles per day achieved by all members of the team, calculates the last checkpoint passed, and ranks the teams by total distance. This information is then summarized on the Team Standings sheet.
Finally, the Trail Position sheet uses a formula to calculate how far a team has travelled passed the last checkpoint. Using the Measuring Tool, the exact position of the team icons can be placed on the trail.
I’ve made workbooks for the Southern Route and the Northern Route. These files can be downloaded on this page. Look for the Iditarod folder. Be advised that the “macro-enabled” (.xlsm) workbooks have a button on the “Restart” sheet that will clear all the data, enabling you to easily start a new race. If you are not comfortable with a macro-enabled workbook, disable the macros at the opening prompt.
The Google Earth .kml file can be downloaded here.
Information | Automation | Innovation | Instruction