The time-consuming task of monitoring student grades can be very overwhelming. Especially when a teacher has multiple classes and grades their students on multiple assignments. This is why Sheetgo created the Gradebook template in Google Sheets. It is designed to automate the consolidation of all Gradebooks to one Master spreadsheet. This Master file is provided with a dashboard to clearly see which students performed well and which students need more follow up. Take a look at the diagram below to see how the system works.
Now let’s get you started
Step 1. Install the Gradebook template
Install the Gradebook template in Google Sheets by clicking the button below. Login with your Google account and your
Sheetgo has now automatically created the system by connecting the Google Drive folder “Classes”, which holds spreadsheets for each class and monitors the students’ performance on each assignment, to the master file “Gradebooks Management”.
Step 2. Open all spreadsheets
Open the “Classes” folder and the “Gradebooks Management” spreadsheet by clicking on their icons as seen in the Network View above. Inside the “Classes” folder you will find 3 Classes spreadsheets, provided with dummy data. If you teach more than 3 classes, simply copy one of these spreadsheets and make sure to store them in the same folder.
Step 3. Fill out the information
Inside the “Class #” spreadsheets, you will find instructions on how to use the template. List the names of all students assigned to that class. You can also fill out their given assignments and of course grade each student accordingly.
Step 4. Configure the Gradebook template
After filling out all the information for each class, go back to the Sheetgo Web Application to update the Consolidate connection between your Classes spreadsheets and the “Gradebooks Management” spreadsheet. In this spreadsheet, you will find a list of all grades of your students of all your classes, and also a list of all the assignments performed. Easily monitor your classes’ performance in the “Dashboard” tab.
You’ve configured your Gradebook template. We hope to make the teacher’s life a bit easier by providing you with a simple solution to follow up on your students’ grades.