Google Scripts - Adding a Template Table to the Top of a Meeting Agenda On Demand

That seems like a weird title for this post, but I was trying to be as descriptive as possible - though the script will work for other uses as well with some easy modifications. 

I was posed the following problem by a person at one of our local districts: "Looking for a way for teachers on a [district] Team to be able to click on a link so that this blank template shows up above their prior week's entries. Does this make sense?"  As I have not done much with using scripts in documents, I was eager to try this.

Surprisingly, I was able to craft this one in less than 24 hours!  And now, I see a myriad of ways that it could be used in other situations.
What this script does:   When opening the document, an additional menu is added (1).  When the user selects to "Add a Table" from the menu, it adds an additional template table (2) below the top level document table, but above everything else.   It also adds a horizontal rule between the tables. 
Here is the script: …

Google Forms - How to Stop Accepting Submissions

Sometimes you need to turn off a form - either temporarily or permanently.  This is very easy to do.  Simply follow these steps:

1. Open the form
2. Click on Responses
3. Look for the slider on the right - move it to the left:

4. A new window will appear with a message saying the form has been turned off.  You can customize this message if you wish:

Upcoming Professional Learning - Dive Into Using OER

A Professional Development Opportunity - Dive Into Using OERDive into using OER (Open Educational Resources) to meet your curriculum needs! This two-day event will build your comfort with finding, using and/or creating open educational resources, and then implementing them in your core curriculum area to create lessons that meet the needs of your students.

Location: Calhoun Intermediate School District; Marshall, MI
Dates: August 7 (Wednesday) and August 8 (Thursday)
Times: 8:00-3:00 - possible 9 total SCECH hours
Cost: $25 for the 2 days (only $10 for REMC12E members!)

Click here for the Registration Link  ~ Limited to 50 participants

Here is the agenda for the event.
There are 2 objectives for the 2 day event.
Participants will: 
build their knowledge and comfort with finding and using Open Educational Resources (OER) as curriculum resources create at least 1 lesson that incorporates OER for deeper, broader, or better student learning 

This event is supported by:

Upcoming Professional Learning - PLAYDATES for 2018-2019


The 2019-20 P.L.A.Y.D.A.T.E. schedule is now available! In addition to the traditional Playdates, there are a few theme focused events. Please share with other Michigan teachers. 
General P.L.A.Y.D.A.T.E. flier
Information on Themed PLAYDATEs:
New Teacher PlaydateAssistive Technology PlaydateCounselor Edition Playdate

2019-20 PLAYDATESREGISTER FOR A SESSION HERE REMC 6, Bay Arenac ISD, Focus: Counselor Edition, September 25, 2019 REMC 14E, Genesee ISD, October 4, 2019 REMC 5, GIRESD (Winding Brook), October 18, 2019 Battle Creek Math and Science Center, Focus: Assistive Technology, November 15, 2019 REMC 12W, Lenawee ISD, Focus: New Teacher Academy, January 29, 2020 - Flyer REMC 20, Wayne RESA, February 12, 2020 REMC 12W & REMC 8, Kent ISD, May 4, 2020
Sincerely, -the PLAYDATE team (Anthony, Keith, Justin, Joe & Kellie)
New to PLAYDATEs? This may help - 
WHAT IS PLAYDATE? PLAYDATE is a new kind of conference event.
NO presenters. NO agenda. Just P…

Promoting STEM Through Literature Project

Check out the Promoting STEM Through Literature project/books! Teachers can use these resources to integrate literature and STEM/Maker activities.  A Design Thinking workbook for students to use is one of the resources.
Current Book List: The Secret Subway - Shana CoreyCrayon Man - Natascha Biebow and Steven SalernoThe World Is Not a Rectangle: A Portrait of Architect Zaha Hadid – Jeanette WinterHow to Build a Hug - Amy Guglielmo & Jacqueline TourvilleAda’s Violin - Susan HoodBalloons Over Broadway - Melissa SweetBeauty and the Beak - Deborah Lee RoseThe Boy Who Harnessed the Wind - William Kamkwamba and Bryan MealerClaymates - Dev PettyThe Most Magnificent Thing - Ashley SpiresThe Marvelous Thing That Came From a Spring - Gilbert FordPapa’s Mechanical Fish - Candace FlemingOne Plastic Bag - Miranda PaulTicktock Banneker’s Clock - Shana KellerTwenty-One Elephants - April Jones PrinceWhoosh! - Chris Barton