TO GET CLASS ROSTERS INTO EXCEL GRADESHEET
-
Log on to the following web address:
https://www-sec.asu.edu/default.sph/roster.class.
-
Click the LOGIN button
-
Put in your ASURITE ID number and password and click the
LOGON button.
-
Before entering your course prefix, course number and schedule
line number, click the SET PREFERENCES button.
-
In the preferences, choose what information you want and
how you want it to look.
-
Go to the bottom of the preferences page and click on the
OK button to save your preferences and get back to the previous page.
-
Now type in the course prefix (MAT), course number, and schedule
line number (ask Bev if you don't know it) and click the BUILD ROSTER button.
-
Once your roster has appeared and you like the information
that you have, click the SAVE OUTPUT button.
-
You will then be given the choice of opening the roster in
Excel or saving it to an Excel file. Pick your choice.
Once you have the Excel file of your roster, you can just
copy and paste the names into the prepared Excel grade sheet.
-
To get these names and ID numbers into your ready-made grade
spreadsheet, you need to:
-
select the names and ID numbers
-
from the Edit menu select COPY
-
switch to the grade spreadsheet
-
click in the cell where you want the names to start
-
from the Edit menu select PASTE