Crowdsourcing Resources with Google Sheets

Google Sheets is a great platform for collecting, processing, and sharing student resources. I have produced a tool using Google Sheets that will allow teachers to enter their objectives and share the sheets with their students so that students can post, search, and rate resources for each objective.

The Resource

The heart of the resource tool is the student sheet shown above. This is where students are able to search resources that other students have posted (Find Resource), post resources they have found (Enter Resource), and rate resources that have been posted (Rate Resource).

Resource Tool Tutorial

Click on the video below to take a tour of the resource tool.

Demo Assignment

Step 1: Find an online resource on Media Literacy that either explains why media literacy is important or explains what people need to know/do/think in order to become media literate.

Step 2: Click on the image to the right to open the Resource Tool. Use the tool to

Enter Your Resource
Find a New Resource posted by another students
Rate the New Resource

Note for 897 Class, others can ignore: If another person is using the sheet at the same time as you and interfering with your work, simply make a copy of the student sheet for yourself. (Click on the drop-down arrow next to the "Student Resource Sheet" Tab at the bottom of the screen and click "Duplicate") See GIF to the right.

Click on the picture above to open the Resource Tool

Report abuse