1 / 32

Roster and Grade Sheet Template for Excel.

Roster and Grade Sheet Template for Excel. WWW.SCCOLLEGE.EDU Navigation pane: Programs and Courses. Academic & Career Technical Programs. Arts, Humanities & Social Sciences. A.H.S.S. Division Web Page. Navigation Pane: Roster/Grade Template. Two Excel templates are available for MS Office:

talib
Download Presentation

Roster and Grade Sheet Template for Excel.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Roster and Grade Sheet Template for Excel.

  2. WWW.SCCOLLEGE.EDUNavigation pane: Programs and Courses

  3. Academic & Career Technical Programs

  4. Arts, Humanities & Social Sciences

  5. A.H.S.S. Division Web Page.Navigation Pane: Roster/Grade Template • Two Excel templates are available for MS Office: • Class Roster Template_Office2003 • Class Roster Template_Office2007

  6. Open template.

  7. Login Dialog Box.Cancel command button.

  8. Excel template with 3 worksheets. • Fill-in Sheet. • Locked Class Roster • Locked Grade Sheet

  9. Click on the Locked Class Rostertab located on bottom of Excel page.

  10. Verify formatting.

  11. Print Preview

  12. Verify the format. If document fits neatly on all three pages, use this template. If document does not fit and margins are off, try the second available template. Second template should work with your computer. Repeat steps to verify fit.

  13. Populate Roster/Grade Sheet Note: Only fields in yellow will populate in the locked templates. Select the Fill-in Sheet tab at bottom of Excel page.

  14. From Web Advisor:Intranet Rosters (Excel Format)

  15. Intranet Roster Login • Intranet • Username: Goodwill_John (last name _first name) • Default Password: Nov111976 • Default Pin No: Last four (4) of SSN#

  16. Intranet Rosters

  17. Intranet Rosters Cont. View Fall 2009 Class Roster.

  18. Intranet Pin Entry

  19. Intranet Rosters to Excel

  20. Saving Intranet rosters

  21. Renaming the roster

  22. Opening the Excel version

  23. Intranet Excel Rosters Warning Message: Yes

  24. Roster in Excel

  25. Position your mouse pointer over the first name you want to copy. • Press and hold down your left mouse button. While holding the left mouse button down, drag the pointer to the right to highlight the ID text. Then release the mouse button. • Scroll down the page to the last student name. Position your mouse pointer over the last name on the list. While holding the “Shift” key down, press and hold down your left mouse button. While holding the left mouse button down, drag the pointer to the left to highlight the ID text. Then release the mouse button. All students and ID’s should be highlighted. • Move the pointer to anywhere within the highlighted text and click the right mouse button. • Move to and left click Copy Copy

  26. Taskbar:Running Apps...Excel Select Excel Template

  27. Position your pointer in the first cell under the Nameheading. (e.g.C11) • Right click your mouse button while pointing in Name field. • Left click and Paste. Paste

  28. Populated Name and Student ID columns. Manually type course information in rows 2 and 4.

  29. Right click on either Locked Class Roster or Locked Grade Sheet.

  30. Print Roster and/or Grade Sheet

  31. Save Roster/Grade Sheet. Renaming the roster

  32. Need Assistance! • Alan Casas • Phone: (714)628-4741 – • Email: casas_alan@sccollege.edu • Room #: D-209

More Related