Tag Archives: Macros

Iditarod Typing Race: Results of Typing Tests and Team Generation

The 5th and 6th graders have completed their typing tests in preparation for the race next week.  After running the team-generating macros, this is how the teams compare:

Screen shot 2016-03-02 at 12.02.44 AM
Grade 5: Team 1 and Team 2 data and profiles
Screen shot 2016-03-01 at 7.35.07 PM
Grade 6: Team 1 and Team 2 data and profiles

Some of the students were not able to complete fourteen timed typing tests with a minimum 95% accuracy.  This will result in a sharp decline in trail progress toward the end of the race.

After running a macro to  populate the test scores on the Data sheets, it became evident that in both grades, one of the teams would arrive in Nome before the other. However, team progress will also be determined by the efficiency and accuracy with which the teams’ official online maps are completed.

Macro-enabled Team Generator for Iditarod Typing Race

Here’s a three-sheet Microsoft Excel macro-enabled file that will quickly set up your two equal teams.  Included are four buttons:

  • Create Teams: If you have already entered your 14 days of typing test data, use this button to create two matched teams.
  • Reset Random: Use this button to create hypothetical data. To see how the Create Teams button works, use the Reset Random button, then the Create Teams button.
  • Reset Clear Data: Use this button to erase the data fields and sort the team list in alphabetical order.
  • Populate Teams: This macro will take all the team members and their daily data and put them into a tab for the appropriate team.

Once the teams have been populated, copy and paste their contents into the main workbook on the appropriate Team sheet.

Click here to download the Team Generator file.

IditaRead: Using the Excel Macros

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.

Screen shot 2016-02-26 at 1.31.03 PM
The macro buttons on the Restart sheet.

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.