Google Script - Assigning A Cell Value Based on Another Cell

When working with our counselors on an online scholarship form, we wanted a single question to ask which scholarships the students were applying for but then in our data spreadsheet we wanted that information separately so that we could score the applications appropriately for each scholarship type. 

Because we used a checkbox question on the form for students to select which scholarships they were applying for, in the results spreadsheet we ended up with what could be multiple answers separated by commas in a single cell.  I looked at several ways to separate this data out into individual cells, but in the end a short script used multiple times worked best. This ensured that there was consistency in how the data is displayed (using a split function did not do this as their first selection appeared in the first column, and not all of them selected the same scholarships).

The script I created looked for a match in the cell, then applied a set value in another cell if the match was fo…

2017 Michigan Notable Books from Library of Michigan

From the Library of Michigan:

"The Michigan Department of Education and the Library of Michigan are pleased to announce the 2017 Michigan Notable Books, 20 books celebrating Michigan people, places, and events. For more than 10 years the Library has been proud to sponsor this program, doing our part to help build a culture of reading here in Michigan."

 Check out this year's selection here.

 There are many books worth checking out!  If you want more, the site lists all the books selected each year from 1996 to this year. 

MI Moot 2017 - Registration Open!

Registration is now open for MI Moot 2017 - Transforming Classrooms.  This year's conference will be held August 1st and 2nd at Lansing Community College West.  Register today for this energizing and impactful event focused on best practices in blended learning! Here is a preview of some of the sessions... -Must-have Online Classroom Resources: Pre-service to Experienced Teachers -Building an Authentic Online Learning Community -How to Flip! -The Open Source Learning Stack -Moodle and Quality Online Resources for Blended Classrooms -Access Denied!  Is your Blended Learning Course Accessible? -and more! More information and the link to register can be found at http://mimoot.orgMI Moot 2017: Transforming Classrooms Flyer Thanks again! MI Moot 2017 Co-Chairs Kay Hauck Anne Thorp Melinda Waffle

MeL Minute: Test Prep. with LearningExpress

With so many schools looking to help prepare students for college tests, this is a timely resource from the Library of Michigan.  And, ytou don't need to purchase them, you get this as a Michigan resident!

From Deb Biggs at MeL - 

"Nobody would sit down to take an important test without at least some degree of preparation from studying the subject matter to actually practicing how to read the questions and answer within a set time limit.  Academic tests, professional licensing/certification, skill measurement, and high school equivalency, are all testing scenarios many people experience.  MeL database LearningExpress Library is available to all Michiganders and provides all these. Seven interactive learning centers provide resources beginning with Elementary School Grade 4 Mathematics and English Language Arts Skills Improvement, through standard college and graduate school tests, to adult learning and becoming a U.S. Citizen.  Three test modes are offered – practice (enabl…

#REMC12E #CISD Inspire Workshop - Branding for Schools

Branding for Schools
What is your school’s brand?  How do you convey it?  Who conveys it? These are of the few of the questions we will address in this session, which will be co-lead by Jerry Johnson, Assistant Superintendent for Legislation and Education Policy, and Melinda Waffle, Educational Technology Consultant.  
Purposes of the day’s activities -Define branding & understand why it mattersBegin a plan for management your brand to build vision & consistencyPlan for creating credibility with transparent communication on multi modes
This session is appropriate for superintendents, principals, teacher leaders, curriculum & technology personnel.
Date: March 30, 2017Time: 8:30 - 12:30 (lunch provided)Where: Calhoun ISD (Marshall)Cost: FREE to REMC 12E educators       $10 for those outside REMC 12EThe Morning’s AgendaPlease registerhere.
About the #CISDInspire Network
The goals of the #CISDInspire Network: