Class Test_SpreadsheetContent
In: gradesheet-rows.rb
Parent: Object

Testing of SpreadsheetContent

Takes an old grade sheet, some standard rows, and makes the column number for the secret id be the column number for student name.

The values here should not work except on my system, so if you want to try the SpreadsheetContent class, fill in your own constants.

Methods

main  

Constants

TEST_FILE = "~/earth/grade301-F03/gradesheet.sxc"   A file that I happen to have sitting around
FIXED_ROWS = [1,2,20,21]   Rows to be output in any use of this program:
 1 - column header
 2 - point count per assignment
 20 - number handing in assignment
 21 - mean in this particular spreadsheet
ID_COLUMN = 0   The id column is the column to be matched against a student’s input to determine the row of the spreadsheet containing the student’s data.

Note that the text to match aginst must be passed to the application securely and the text should be known only to the student that the text identifies

Public Class methods

Use the constants to test SpreadsheetContent functionality

[Validate]