Google Drive is meant to make instruction and collaboration more efficient. There are many ways for instructors to gather data and provide feedback using Google Classroom tools. Not only does this allow instructors to combine all their data in one place, but it can also help to notice trends within students.
Google Classroom Assignments: Data can be gathered from graded Google Classroom assignments. As long as a score is provided for the assignment in the “Classwork” tab, the data for individual assignments can be transferred into a Google Sheet. This spreadsheet provides a resource that includes student names and grades for any Google Classroom assignment. The assignments are organized by the due date and posting’s name. The sheet creates tabs for each class with an easy access link back to Google Classroom.
How to Transfer Google Classroom Assignment Data:
Select the graded assignment from the “Classwork” tab on Google Classroom. Ensure that every student has a grade for the assignment.
At the top right, click the “Settings” gear and select “Copy all grades to Google Sheets.” This will open one tab with the class grades. In order to add all classes, access the assignment in each Google Classroom and create a new tab in the Google Sheet.
Google Form Responses: Instructors can also easily transfer data from Google Forms. Once all students complete a response to the Google Form, the teacher can access the responses from their editing version of the form. In the “Responses” tab, instructors can see graphs that break down responses to each question. Instructors can view the results as a class summary, individual breakdown, or question breakdown.
The data can also be transferred to a Google Sheet. This Google Sheet includes all responses to the given Google Form, including a timestamp, student email, overall score, and all responses to each question.
Open the Google Form through the instructor’s editing document in Google Drive.
Select the “Responses” tab and ensure all students have completed the form.
View the Google Form data by individual student or whole class.
Transfer the data to a Google Sheet by selecting the green Google Sheet icon at the top of the page. A new window will open with all responses.
After grading student assignments, it is important to include feedback. The easiest way to respond to student work is to leave private comments within their submission. These private comments can only be viewed by the individual student and not the entire class. By leaving private comments, you can make suggestions about the overall assignment, allowing students to improve for the future.
If you want to provide more structured feedback, you can create a rubric in the Google Classroom assignment. This rubric is completely customizable and can be saved for future assignments. In order to create a rubric, first create an assignment within the “Classwork” tab of Google Classroom. At the bottom right of the window, click “+ Rubric.” Here, you have the option to use an existing rubric on Google Classroom or Sheets, or you can create a brand new document. As students submit there assignments, you can use the rubric to click the score they fall into for each category. The rubric will provide an overall score once the rubric is completed.