Receive Daily Spreadsheet Edit Agenda

07/13/201607/13/2016Leave a comment

Teachers you can receive a daily notifications agenda when students make changes to a collaborative Google spreadsheet. What is the value? If students are working as small groups on projects you can see who contributed information. The email provides a list of the Student and the time the edits occurred in a daily agenda notification. All the teacher has to do is go into the spreadsheet then look at the Revision History to see exactly what the students typed. It gives a whole new perspective on assessing student’s work.

Setup Google Spreadsheet Notifications

Choose Tools in the spreadsheet toolbar
Scroll down to Notifications Rules and click
Pop-up window opens for set notification rules
Click the blue edit in the upper right
Choose between:
- Any changes are made
- A user submits a form
Next you choose between a daily email or multiple emails
- Email daily digest (one email daily)
- Email right away (every time a student logins to make a change)
  - Gmail maybe flooded with email

NOTE: Timesaver for teacher prevents the need to sift through tons of email!

Yes! You Can Have One Sheet per Student in a Google Form Spreadsheet

08/24/201508/24/2015Leave a comment

I’m discovering not many teachers know multiple student sheets can be added to one spreadsheet. Due to the time it takes for setting this up I don’t recommend doing this for all Google Forms. However due to the nature of a reading log it is well worth taking the time to set up a sheet per student. The trick is you will need to create one Google Form per student, and then add a sheet into an existing Spreadsheet.

This is how to add multiple sheets to one spreadsheet

STEPS for ADDING MULTIPLE SHEET to a SPREADSHEET

Open Google Form
Click Response

Click Change Response Destination

Click New Sheet in Exisiting Spreadsheet

Select the Spreadsheet

IF ALL GOES WELL YOU SHOULD HAVE MULTIPLE SHEETS IN ONE SPREADSHEET

The Power of Global Collaboration for Supporting Education…

08/08/201508/08/2015Leave a comment

There I was sitting having my morning cup of java when my eyes fell upon this tweet from John Rouchka @jrouchka !

Immediately I put my cup of coffee down to click and see John’s YouTube video. I was amazed seeing the modification he made and knew right away the math interactive needed to go one step further. However I didn’t know enough about using Google Spreadsheets functions. Thanks to the internet I was able to correspond with John. I asked if he would mind sharing the template with me and making some slight adjustments. He complied with my requests and the below math interactive was created through global collaboration. I’m amazed with the power of collaboration this globally connected world has created for supporting educators and the future of education.

Click here to download this template

Differentiate Learning Addition with a Google Sheet!

08/03/2015Leave a comment

Prior to Google Educator Training I had a fear about using Google Sheets in that matter even a Microsoft Excel Spreadsheet. This fear is fading away since learning there is so much more one can do with a Sheet than I ever imagined. What I’m going to share is a support to help the elementary student with becoming independent as they learn how to add up to 1,000. Below is a screenshot of the Addition Practice Google Sheet Interactive.

Please feel free to use this link for copying the template: Addition Calculator Practice

I’ve created the following video to share how this interactive support works

WHY USE A SUPPORT LIKE THIS?

It differentiates the learning so all students can successfully find the sum
Students can work independently at their own speed
Provides the student with multiple ways to check their answer
Growth data is provided through the revision history
Can be used in multiple ways
1. Whole Group
2. Small Group
3. Individually
Assessable from home provided the student has internet access

Watch for a followup post on how this Interactive Math Manipulative was created. You could build interactives like this using Google Sheets for subtraction, multiplication, division and ? Please share what ideas you come up with in the comment section. I’m looking forward to hearing how you have incorporated the Google APPS for Education suite in the classroom.