Grading

DROP ROSTERS
Filter rows of dropped students to get column of remaining students

Paste into "Raw Student Roll"
New tab
A2 / Edit / Paste Special / Text
Remove "dropped" rows
Copy 1 column of names into RSR
Student Roll

EARLY ALERT ROSTERS
GRADE ROSTERS
POSITIVE ATTENDANCE ROSTERS

Populate roster and/or grading spreadsheets:

convert to 1 column of 'First Last':

Main method (source data from 'Class' link):
save all to gcc-roster-asp.rtf and run Unix script:
grep [0-9] gcc-roster-asp.rtf|tr '\' ' '|grep -v '/2009'|cut -c 11-80|grep -v [0-9]|sort|wc -l

Alternate method: (source data from 'View First Day Roster' link):
save all to gcc-roster-pdf.rtf and run Unix script:
grep , gcc-roster-pdf.rtf|cut -c 18-80|awk '{ print $2, $1 }'|tr ',' ' '|grep -v 'AURENE'|sort|wc -l

paste into .xls, adjust columns, and Save As...

Dad's spreadsheets:

• lookup table (other tab)