Google Script - Create Calendar Events from Spreadsheet Data

Yesterday I shared how I added reminder dates to a spreadsheet for a person in my department who keeps track of software subscriptions.  Today I'm sharing how we take the entries on that spreadsheet and create calendar events, so the reminders are built into her calendar.
Here are the steps to create calendar events from spreadsheet data:

1. Either open the spreadsheet with the data (or create a new spreadsheet & populate it with data).
This is the spreadsheet where I first added the script to add a "remind date" (yesterday's post).

2.  Open the Script Editor
Go to the Tools Menu and select Script editor

3. Replace the Code
Replace the default code -

with this - (all the text highlighted in gray -  including the final bracket)

function createCalendarEvent() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var calendar = CalendarApp.getCalendarById('calendarID');

  var startRow = 2;  // First row of data to process - 2 exempts my header row
  var numRows = sh…

Google Script - Setting up Reminder Dates

A person in my department keeps track of software subscriptions, and asked if there was a way to automatically have it provide a reminder 45 days prior to the renewal dates.  I said sure! Once I set up the addition of a "reminder date", I modified an existing script to have it write that to her calendar.  So now she simply inputs the vendor information, purchase date & renewal date, and then the scripts calculate the reminder date and adds it to the calendar.  It seems to work pretty slick!

Here are the steps to create the reminder dates with a script -

1. Create the spreadsheet where your data will reside.
This can be a stand-alone spreadsheet, or it can be one that is populated by a form.  Here is my sample-

2. Open up the Script editor
Go to the Tools Menu and select Script editor

3.  Replace the code
Replace the default code -

with this - (all the text highlighted in gray include the final bracket)
var dateIndex = 6; //cell with reference date

var ss =…

Google Forms - Interactive User Experience

This is a really cool video on how to make your Google Form interactive - or, if you will, "Choose Your Own Adventure!"  I can think of so many applications for this...both as a teacher, and as a learning activity for students.

From MeL: Using MeL for Country Reports

From Sonya Norris at Michigan electronic Library:

Do you have students asking for resources to write country reports? MeL has several student-friendly resources for this oft-requested topic.
Britannica and World Book both will allow you to compare basic facts and figures about countries but Britannica is definitely more full-throated when it comes to articles. They do a great job with articles at scalable reading levels including images and video to augment the text that is freely available for students to include in their reports with attribution.
Kids InfoBits is geared for preK-5 and while they don’t do side-by-side country comparisons or list every country recognized by the UN, they do have in-depth data on approximately 90 countries. They have resources from many sources that they break down into books, biographies, pictures, magazines and news. For Brazil, for example, they have over 500 news articles beginning at middle school reading levels as well as dozens of …

Upcoming #REMC12E Professional Learning Opportunities

There are several upcoming professional learning opportunities that are low-cost/free for educators from #REMC12E districts!

#CISD Inspire Workshop: Online & Blended Learning
Join us as we explore what opportunities exist for school districts, questions you should be asking during implementation, and legislative impacts concerning pupil accounting/FTE.  Jill Slaught from the Pupil Accounting team will be joining us with her expertise. This workshop will be8:30-noon on June 1, 2017 at Calhoun ISD; for more information refer to this flyer.
#REMC12E BreakoutEDU WorkshopWe are holding a BreakoutEDU Workshop - experience a Breakout game, then develop one of your own! The first 18 to sign up will leave with their own BreakoutEDU kit - complete with box, set of locks, hint cards and more, a $125 value!

When: 8:30-2:30, June 20, 2017
Where: Calhoun ISD
Cost: $25 (includes lunch)
Limited to the first 18 people from #REMC12E - a Breakout EDU kit!
Flyer and Registration
Sponsored by: #REMC Asso…