Community College of Rhode Island

Go to 50th Anniversary website

Get Adobe Reader

*PDF files require Adobe Acrobat Reader to view - Download here

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.

Go to top of page

This page developed and maintained by Information Technology. Send comments and suggestions to .


Last Updated: 11/19/13