Rosters to Excel Instructions
Instructions for Using Rosters+ Grade Template
►INTRODUCTION
Using the Rosters+ Download Roster XML option you will be able to:
• Export your class rosters to an excel spreadsheet
• Download your attendance sheet
• Calculate grades by using the Innovation Center’s Rosters+ Grade Template
• Print a final grade sheet to post Final Grades
►BEFORE YOU BEGIN
In order to keep all Excel spreadsheets organized make the following adjustments through “My Computer”. Open your Z:/ drive and create a general folder called “Excel”. Inside the “Excel” folder, create a subfolder and give it a descriptive name such as: Rosters+_Spreadsheets. Inside that folder create others and name them according to the semester.
Ex.
You may now close all windows and begin saving the Innovation Center templates into the folders.
Hint: You may save the templates as masters and every time a new student roster is pasted on,
save it under a different name so that your master always remains blank and can be
reused each semester instead of downloading from the website.
►DOWNLOADING TEMPLATES FROM IC PAGE
Open your web browser (Internet Explorer or Netscape Navigator) and visit the following website: https://www.cerritos.edu/ic
Click on the “
” link of the Innovation Center’s webpage. Read the instructions and click on the
Rosters + Grade Template link.
At the “File Download” window, click the “Save” button and save the file on the folders created previously or any other destination of your choice.
Once download and saving is complete, click “Open”.
Your Excel template will look like the one below. Minimize your window by clicking the minus on the upper right-hand corner and launch Rosters+.
►FINDING ROSTERS+
Open your web browser (Internet Explorer or Netscape Navigator) and visit the following web site: http://psrosters.cerritos.edu from anywhere you have access to the Internet.
OR
You may go to the Cerritos College web site: https://www.cerritos.edu and click on the Faculty & Staff button on the left hand side of the screen. Then, click on the second link titled: Rosters+ Login.
►LOGIN TO ROSTERS+
Sign on to Rosters+ using your Email address and your Network password.
(1) Enter your username
(2) Enter your Network password
(3) Click here to login
►LIST OF CLASSES
Upon entering Rosters + the first panel will look like the panel below. Your name and a list of your current courses will be displayed on the screen. You will only be able to access your own classes.
Select the class for which you need a roster by clicking the appropriate class and
pressing the “Get Roster” button.
The class roster will display all students in your class by name and student number.
►DOWNLOAD ROSTER
Downloading as an XML Excel File:
Click on the “Download Roster” tab. Click “Download as an XML Attendance Template”.
Click the open button to display the class spreadsheet.
►COPYING THE ROSTER
Highlight the information you want to use. In the example below only student numbers and student names are selected.
Right click inside the highlighted area and select “Copy” from the pull down menu.
►PASTING THE ROSTER
Go back to your previously minimized Excel template and right click where it says “paste here” and select “Paste” from the pull down menu. Your student information will be displayed like the example below.
Click on the 1st tab on the bottom left hand side of the spreadsheet. The tab is labeled “CCP Grade Report.” All student information will be displayed.
Make sure to logout Rosters+ as soon as you are done working on your class rosters.
To logout click on the red logout button located on the upper right hand side of your
Rosters+ screen.
Hint: Use the Task Bar to switch between applications.
►SAVING THE ROSTER
After pasting all information and switching to the 1st tab, click “File” and from the drop down menu select “Save As…”. Rename the file to ensure that the original template remains blank so that it could be reused to download other classes or future semesters. Don’t forget to save it in the folders created earlier on your Z:/ drive.
NOTE: Follow the same procedures to download and save the Rosters+ Grade Template.
Hint: Remember that the Z:/ drive cannot be accessed from home. So, if you are planning
to work from
home or a remote location; make sure to make a back-up copy of the files
on a floppy or zip disk to
take with you.
► EDITING THE TEMPLATE
After copying, pasting, renaming and saving your class spreadsheet, you are now ready
to edit or personalize the Excel file. After pasting all class information under the
“StudentDetails” tab, make sure to switch to the “CCP Grade Report” when using the grading template.
Fill out class information and make changes as desired.
Below is an example of a completed grading spreadsheet. You may change assignment titles and total points accordingly. The formula will update itself as you modify the assigned points.
DownloadRosters + Grade Template
For technical questions call the IT Help Desk at (562) 860-2451 x2166.
For training questions call the Innovation Center at (562) 860-2451 x2799.
Stay Connected