A. Generate a column of random numbers

1. Keep your grades in a spread sheet
2. Create a new column to the right of the names
3. Generate a list of random numbers
4. Paste the numbers generated into the numbers column

B. Sort your grades

1. Select the header row then click on the DATA and FILTER option in Excel
2. Each column now has a drop-down button that allows you to sort your grades using any column
3. Sort your grades by random number, grade, etc., but not by name

C. Post your grades

1. Copy the columns into a web page or a text file
2. Save the file to your web space
3. Resort your grades by nameSet

D. Repeats step C weekly