March 9, 2011 Eric Rasmusen, erasmuse@indiana.edu This file is now at http://www.rasmusen.org/a/iu-rasmusen.txt This file is for IU software commands I might want to look up. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX REPORTING GRADES. (1) Half-semester course grade can't be reported in mid-semester--wait till the end. (2) Below is a spreadsheet formula for when I have a column of numerical student grades that I want Oncourse to turn into a letter course grade. These should be in a column labelled Oncourse-Required-Score [100] . =IF((G2=1 ),10,0)+IF((G2=1.3),61,0)+IF((G2=1.7),64,0)+IF((G2=2 ),68,0)+IF((G2=2.3),71,0)+ IF((G2=2.7),78,0)+IF((G2=3),85,0)+IF((G2=3.3),88,0)+IF((G2=3.7),91,0)+IF((G2=4.0),94,0)+IF((G2=4.3),98,0) XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX GRADES IN ONCOURSE For my spreadsheet, label every column with a name like "Quiz-1 [nc]" so Oncourse won't try to put it into a course grade. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Rosters. Onestart, faculty systems, has course rosters with student majors listed. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX