If you're a master spreadsheet user and know how to set up formulas quickly and easily, you may not need help setting up the complex formulas you'll need to calculate and weight grades. But if your school hasn't invested in gradebook software, Google Sheets simplifies the process of tracking and calculating student grades. If your school uses gradebook software, it probably calculates your students' grades for you-you just have to enter the grade and assignment weights into the system. Calculate Grades and Gather Important Insights with Google Sheets This is the text that displays when students complete the quiz and is a good place for reminders like 'Make sure to print this page and turn it in tomorrow morning.'Ĭhoose when students should receive their grade by selecting the radio button next to either Immediately after each submission or Later, after manual review.Ĭheck the box next to Missed questions if you want students to be able to see which questions they answered incorrectly.Ĭheck the box next to Correct answer if you want students to be able to see the answer key after their quiz has been graded.Ĭheck the box next to Point values if you want students to be able to see how many points each question is worth.Ģ. When you're finished, click the Send button, and adjust your quiz's settings:Ĭheck the boxes next to Collect email addresses and Response receipts if you want your students to turn in a printed confirmation that they completed the quiz.Ĭheck the box next to Restrict to users in and trusted domains if you want to force your students to take the quiz from their school-provided Google accounts.Ĭheck the box next to Limit to 1 response if you don't want students to be able to take the quiz more than once.Ĭheck the box next to Show progress bar if you want students to see a visual indicator that shows how many more questions they have to answer.Ĭheck the box next to Shuffle question order if you want all of your students to receive the questions in random order.Ĭustomize the text in the Confirmation message box.

Repeat all of the steps above for each question you want to add to your quiz.

Google docs in the classroom