Receive Daily Spreadsheet Edit Agenda

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.

Spreadsheet Notifications.gif

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!

Advertisements

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

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

Reading Log multiple students

STEPS for ADDING MULTIPLE SHEET to a SPREADSHEET

  • Open Google Form
  • Click Response

step 1

  • Click Change Response Destination

Step 2-2

  • Click New Sheet in Exisiting Spreadsheet

Step 4

  • Select the Spreadsheet

Step 5

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

Screen Shot 2015-08-24 at 10.35.34 AM

The Power of Global Collaboration for Supporting Education…

Twitter Java

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

Screen Shot 2015-08-08 at 12.54.51 PM

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.

Screen Shot 2015-08-08 at 2.34.18 PM

Click here to download this template

Differentiate Learning Addition with a Google Sheet!

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.

Screen Shot 2015-08-03 at 7.04.13 AM

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?

  1. It differentiates the learning so all students can successfully find the sum
  2. Students can work independently at their own speed
  3. Provides the student with multiple ways to check their answer
  4. Growth data is provided through the revision history
  5. Can be used in multiple ways
    1. Whole Group
    2. Small Group
    3. Individually
  6. 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.