Creating an Electronic Grade Book in Excel
An electronic grade book is a quick and easy way to maintain student grades from semester to semester. Having your rosters available in MyCCRI make it even easier to get your students' transferred to the spreadsheet. After the initial steps to set up your grade book, all you have to do is enter the grades from week to week for the rest of the semester.
This tutorial will just cover copying and pasting your roster into a spreadsheet and plugging in new labels and grades. However once you get comfortable with this, you can also explore using the powerful Excel tools to calculate your grades by quiz and for the term.
- Viewing your roster in MyCCRI
- Copying your class roster into Excel
- Adding calculations into your Excel grade book