Embedded Files
In this hands-on one-hour session, we will cover the following:
What are Apps Scripts?
Flubaroo - Simplify Grading [Old version with Scripts]
Doctopus - Share, organize, and assess student work in Google Drive [Old version with Scripts]
And even more scripts! http://cloudlab.newvisions.org/home
And the new "Add Ons" for the new version of spreadsheets
Explore these if you have some time
gClass Folders - Create and share folders with your students
It is recommended that attendees have:
a basic understanding of creating Google Forms and how Forms & Spreadsheets interact before joining this session.
A laptop. Your mileage may vary on an iPad--or you may not be able to get hands-on.
Looking for Hands on With Google Apps Scripts Part II?
Flubaroo
After completion of this, we'll take a look at the workflow of Flubaroo before you get started on it yourself.
Create your own form with the following question fields
Last name
First name
Email address
Question 1 (Multiple Choice)
Question 2 (Multiple Choice)
Question 3 (Multiple Choice)
Create your key by submitting to the form with KEY in the Last name, First name, and Email fields.
Send the link to your form by email to an elbow partner; have him/her complete the form.
Install the Flubaroo script and then run through the steps for grading the responses.
Celebrate with a victory dance!
Doctopus
Tasks
please visit this spreadsheet and make a copy of the spreadsheet
Install the Doctopus script from the script gallery and then run the script
Share a document with your "students"
Install the Goobric plugin (Chrome only) and then make a copy of this rubric
Attach the rubric to the document you shared with your students. Test out using the rubric to give feedback.
Want to read up more on Doctopus? Then head over here
gClass Folders
Follow me over to the gClass Folders website
Select Instructions > Teacher Mode
We'll work through the steps together to create and distribute folders to students. If you would like some sample student email addresses & names (that are attached to live email addresses), then please visit this spreadsheet and copy the student information over.
Celebrate with your awesomeness!
Page updated
Google Sites
Report abuse