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.
Assignment Data:
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:
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.
How to Transfer Google Form Responses:
Instructional Video: https://youtu.be/4QtfS4j7xkA
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.
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.
How to Transfer Google Form Responses:
Instructional Video: https://youtu.be/4QtfS4j7xkA
- 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.
Providing Feedback
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.
|
|