Class NumberNC State University
FLL Computing Support

Support Home
Foreign Keyboards
FLL Network Drive
Antivirus Protection

LAU 214
LAU 216
Course Support
Web Publishing

"Simple" Posting of Grades

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



Comments to: despain@ncsu.edu