Race Marshal opens each team’s official online map and Daily Data file.
Race Marshal sets rate.
Musher enters value on Rate sheet.
Race Marshal releases Day 1 wpm values for each team member via shared read-only Daily Data file to Wheels.
Wheels communicate individual miles to Musher.
Musher enters values on Data sheet, communicates Trail Position to Wheels.
Wheels relays exact Trail Position to Teams.
Teams relay Trail Position to Swings. Teams determine approximate location on online map and begin editing Checkpoint icons and placing pictures of progress-to-date. Swings determine exact position on official online map.
Swings and Lead pin exact position on online map. When completed, Musher approaches Race Marshal for verification. When Race Marshal verifies location, team has successfully completed Day 1.
Race Marshal releases Day 2 wpm values, and procedure repeats.
I am currently using this project on grades 3 through 6. The technology skills required are:
logging into an online typing skills website and completing timed tests
navigating through a multi-sheet Microsoft Excel workbook and entering data in appropriate places
acquiring relevant Checkpoint and Milepost positions from the Excel workbook
opening and editing a shared online Google Apps Map
using the Ruler tool to pinpoint exact location of each day’s position
editing Checkpoints to include relevant pictures and text
placing relevant pictures on the online map as the team progresses
researching relevant trail, geography, and weather information in order to fill out a shared Google Doc trail log for each day of the race
The activity is divided unto different stages. This article will explain how to get ready for the race by Typing Tests, Team Selection, Team Positions, Position Responsibilities and Seating Assignments, Creation of Official Map and Workbook, Creation of Google Earth files, and Creation of Shared Daily Data files.
Setup: Day One Student Prep
Students will need to have 14 one-minute typing tests; one for each day of the Iditarod. Timed tests must be completed with at least 95% accuracy to be counted. All of the tests must be completed within a single class period.
Setup: Day Two Pre-Race Teacher and Student Prep
I will pick equal teams based on students’ typing test scores. I will then create matched teams by splitting the two slowest typists, the next two faster typists, etc. The top typist of each team will be designated Musher. The second fastest typist will be Lead Dog. The next two fastest typists will be Swing Dogs, the two slowest will be Wheel Dogs, and the rest will be Team Dogs. The students will give themselves dog names. The team will be named after the musher.
The Race Marshal will prepare and share read-only Daily Data sheets for Wheel Dogs after each day’s position on the official online map has been verified.
The Musher will be responsible for the team’s Excel workbook. The Mushers will add their names and the dog names to the Data sheet. The Musher will be in position 1, the Lead Dog in position 2, Swing Dogs in 3 and 4, Team Dogs in 5 through 14, and Wheel Dogs in 15 and 16. The Musher will assign seating positions as follows:
The Lead Dog will be responsible for the official Google Map. The official map will be created in the Lead Dog’s Google Apps account, and shared with editing privileges with the other members on the team . The official map will be shared with the Race Marshal with viewing only privileges. The official map will also be shared with the opponents’ Musher, with viewing only privileges.
The Swing Dogs will assist the Lead Dog in maintaining the accuracy of the Google Map.
The Team Dogs will be responsible for determining the approximate position of the team after each day’s data has been entered. They will work in pairs on the online Google Map and pass that information on to Swing Dogs. The Team Dogs are also responsible for adding pins with embedded pictures and text as the race progresses.
The Wheel Dogs will receive each day’s data in a read-only document from the Race Marshal. The data will be recorded on a hard-copy document and handed to the musher.
The Musher will enter the daily data in the official Microsoft Excel workbook, then record on the hard copy the team’s exact position passed the last checkpoint. The Musher will return the document to the Wheel Dogs, who will pass it forward to the Team Dogs.
When the daily data sheet makes it up to the Swing and Lead Dogs, the Musher will hand-carry it to the Race Marshall once the exact position of the team has been verified on the official online map.
Additional rules and instructions will be discussed on Race Day by the Race Marshal.
A Summary of Team Responsibilities can be found here.
The Idita-Type Microsoft Excel workbook can be found here.
If you have chosen to publish your IditaRead project online, you can move team icons quite easily.
First of all, you need to note the difference between viewing the map and editing the map. If you’ve made the map public, anybody can view it. Since you are the creator of the map, you can also edit everything about it.
Click on the EDIT link to make changes.
In Edit mode, you can fully customize the appearance of your Routes, Checkpoints, and Teams.
The Iditarod Typing Race uses keyboarding words-per-minute instead of time spent reading to determine trail position. It uses all of the same features of the Excel workbook and Google Earth maps as the reading version.
The team aspect of this race works outstandingly well in a computer lab setting, as it allows for head-to-head competition while utilizing the benefits of cooperative learning. Every student in the class has an important, though differentiated, role in the race. All of the students use multiple higher-order cognitive and computer skills to move their team towards the finish. The technology component allows for real-time monitoring and display of team progress.
The students do not need to print or save any files. The teacher can download a csv file from their typing.com teacher account in the Reports section. I use a minimum accuracy criteria of 95% to qualify wpm and delete every score below 95%. The students ideally will have 14 qualifying tests; one for each day of the race.
Check out the following articles for more information:
The Microsoft Excel IditaRead workbooks have two macro buttons on the the last sheet of the workbook.
The Erase All Data macro is activated by clicking on the gas gauge. It will enable you to erase all the data entered in order to start a new race. I did NOT include the Save command in the macro to prevent unintentional file replacements.
The Random Number macro is activated by clicking on the square of numbers. It will generate random integers from 0-60 and place them in all of the teams and all of the members for all 14 days. You can test the functionality of the workbook and the results of the rate parameters you chose.