Showing posts from 2019

UPDATE Google Admin - Whitelisting Domains

There are two situations that I have run across where a G Suite for Education School would need to whitelist a domain (or subdomain).  These are:
If your students and teachers are on two different domainsIf you are in a situation like me - as a support organization I want to provide training to teachers that are in their own Google Apps district It is quite easy to do this - it just has to be done by a Google Apps for Education Administrator. There are THREE parts to this, make sure all of them are set for it to work properly!
Part 1 - add the domains In the Google Admin Dashboard, click on Domain (if it doesn't show, click on the More at the bottom)

Once in the Domain management area, click on Whitelisted domains-

Click on Add new -

1. Type in the domain to whitelist, then
2. Click on Add Domain to Whitelist -

Part II - Set Classsroom Settings Go back to the Home level of the Google Admin panel - click on the Apps icon:
Click on the G Suite Core Service apps:
Click on Classroom:


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

Reading Campaign - Read a Story, Change Their Story

Save the Children has launched its inaugural summer reading campaign in the United States – Read a Story, Change Their Story – in celebration of the global nonprofit’s 100th anniversary. The 100-day campaign, which will conclude on September 8, World Literacy Day, encourages all children, parents, teachers, librarians, caregivers and adults to log their summer reading minutes at
Participants can positively impact the lives of children growing up in rural America who do not have adequate access to early education or children’s books, while also promoting literacy in all communities. Every minute logged helps raise awareness and supports Save the Children’s work to improve literacy and change lives. For more information, go to:

Upcoming Summer Professional Learning

Learn about REMC's Virtual Courses, and below that find several face-to-face professional learning opportunities -

REMC’s Virtual Courses
Summer is the perfect time to take advantage of REMC’s free Virtual Courses. These courses are specifically tailored for educators, by educators.  The classes provide a convenient way for education professionals to learn and collaborate while reducing the time and expense of traveling to a seminar or workshop. All REMC courses are open to all Michigan school personnel. No registration or SCECHs fees.

Seven courses are offered in June and begin on Monday, June 3.  Deadline for registration is Friday, May 31.  Each course is open for three weeks and consists of two (2) one-hour webinars and four (4) to eight (8) hours of resource review, assessment developments and written reflection.  SCECHs are available, ranging from 6 - 10, depending on the course.Enhancing Instruction for All LearnersIncreasing Efficiency and ProductivityAuthentic Student Learni…

FREE Prof Learning - Discovery Education Experience

Join Discovery Education and REMC 12W for a FREE Discovery Education Experience (DEXP), where Michigan educators can immerse themselves in an interactive day of professional development. 

Register to attend and earn 5 SCECHsfor the Discovery Education Experience: Instructional Strategies for Digital Learners sessionLearn what’s new and rediscover with Discovery Education instructional resources, strategies, and tools that help take your students anywhere – from the cities of China to the pen of a playwright. 

Google Script - Sync Google Calendar to Spreadsheet by Specific Date Range

(This is modified from Davepar’s project and examples at GitHub can do a sync either direction.)
I had a colleague ask if she could easily copy calendar events into a spreadsheet for a log. We discussed using the Agenda view in calendar, but she needed to do some calculations and data analysis with the information so a spreadsheet was the obvious landing place for the information. After finding (and previously using) Davepar's script to create Calendar events from a Sheet, it made sense to revisit it and break it down the other way. After doing that, it made sense to let the user input the desired date range on the spreadsheet.
Here's the result: (Feel free to grab the Script if you want to make your own modifications- this one is an easy one with only 1 line of code to update.)
Directions: Part 1 - Set Up the Calendar: Create a new Google Calendar (in the dropdown next to "My calendars" in the left sidebar of Calendar).Gi…

Next Gen Personal Finance - Curriculum and Resources

Next Gen Personal Finance is a great resource for teachers that are either teaching a Personal Finance course or incorporating personal finance topics into their curriculum

The site includes:

learning unitscourse mapping - from an 8 hour workshop, to a full semester courseresources (including "question of the day," activities and projects)  & case studiesprofessional development and networking opportunities All materials (excluding pictures) are licensed under a Creative Commons Attribution – Non-Commerical 3.0 Unported (CC BY-NC) License (  This means you can share and adapt the content following the terms of use (see note below) without seeking written permission.  

"The CC BY-NC License allows you to freely share and adapt CFCI Content, provided that: (i) you give proper attribution to CFCI in the manner specified by CFCI, but not in any way that suggests that CFCI endorse you or your use." (from the Terms of Us…

LearningExpress Resume Builder from MeL

If you’re in the job-seeking market, brush up your resume or write a new one with LearningExpress Job & Career Accelerator® available free at the Michigan electronic Library ( Under LearningExpress, click the Job & Career Accelerator Center. Select Tools to Get Hired, then launch the Build Your Resume career tool. The Resume Builder will help you create effective resumes in a step-by-step manner with expert advice, easy-to-follow instructions, and helpful resume samples. The Resume Builder helps you create new resumes from scratch or upload and edit an existing resume. The easy-to-follow format allows you to set up your resume profile once with your name and contact information, resume name, job category, description, job experience and current work situation, all saved for any additional resumes. When you create a new resume, you may select a first design or skip this step. Navigation takes you through the sections for a headline, job highlights and qualifications, …

Google Earth - Where in the World is Carmen Sandiego?

Carmen Sandiego is back - have your students use Google Earth to learn a bit of geography while chasing her down for the Crown Jewels!  Then have them research cities, landmarks and airports and create their own version of the game.

You can find the game 2 ways - if you go to Google Maps, a message will appear asking if you want to Catch Carmen Sandiego -

If you go straight to Google Earth, there is a new red button to begin the game -

First you will get a splash screen -

When you start the game, you get your assignment -

Then move into a split screen with Google Earth on the left, and the game elements on the right -

Gathering information, you then "fly" to the next city based on the clues -

Nostalgic for some, but it can still be a great way to introduce kids to some cities and landmarks they may have never heard of.

2019 #MACUL Conference Tipsheet #4 - Cobo layout & Getting Around Town

The MACUL Conference is this week!

(This is the third in a series of 4 to help you get ready and excited about going to the conference. Tipsheet #1 contains information about hydration, food considerations and special happenings at the conference. Tipsheet #2 contains information about planning for your conference - the conference app, choosing sessions. Tipsheet #3 contains information about registration, getting help, networking, and wearing comfortable shoes!)
Here are some other tidbits that might help you out as you arrive at the conference next week:

COBO Layout: COBO is now basically a big “L” with sessions dispersed over 3 or 4 levels on both sides of the L; the left side of the L faces the river.  
The end hallway overlooks the river since it has been renovated.They have added escalators and a huge staircase which help with traffic flow. Long time conference goers should know they dropped the old naming conventions - it's numbered by floor and area, and what used to be the ba…

Google Search - Advanced Searching Tips & Lessons

There has never been more information, more readily available, to more students than this moment and it will only continue to increase. Before beginning research with your students consider using some of the resources below to help our students find more useful results when searching for information.
Google Advanced Search (direct link)Google Search Help - Refine Web SearchesBetter Searches...Better Results (poster)Google Tips by Requirement (poster)Google's Search Literacy Lesson Plans (lesson plans/activities)A Google A Day Challenges (activities)Google Search Tips (infographic/poster)These resources were gathered and are shared by me (Melinda Waffle) and CJ Walker, educational technology colleague at Jackson County ISD.