When using Spreadsheets in Google Drive there is a wonderful tool called scripts that can really help the teacher. Spreadsheets may have been created directly or when we use a form as a way of assessing students or just to gather responses.

From the toolbar of the Spreadsheet, look for Tools.

Script 01

You will see a few script related choices, and the best way to start is by looking at the Script gallery.

Script 02

When Education is chosen, there are many scripts to choose from. There is one that comes with a Chinese title as you can see in the screenshot above. It is a simple and useful script for marking MCQ responses, and it does not matter that you cannot read Chinese. It is able to indicate which answers have been correctly answered, the scores for each student and also the score for each question.

Give scripts a try.


About pauseability

An educator at large and learner at heart. Founder of Pauseability. Encouraging everyone to learn to pause, and pause to learn.
This entry was posted in Google Ed App and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s