Upcoming classes

PCC Spring 2009
---------------------------------------------
xxx
---------------------------------------------
GCC Spring 2009
---------------------------------------------
xxx
---------------------------------------------

LMI creds

Matthew's computer (OpenPro)

• matthewreiser@yahoo.com
  

Dad's computer (GRANT-Desktop):

• grannel@verizon.net

Print rosters

Pasadena City College
MIS.pasadena.edu
Staff
00640711
02198537
ROSTER for a Class Section


Glendale Community College
internal
mnelson
ligriv123

rosters (Firefox or Safari)
54884
8537

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)