Posts

Showing posts with the label write

Technology Tidbit - Learn to Draw...

(Part of our Stay-At-Home series focused on practical ways you can use a resource to foster creativity, connections, and collaboration.) ...or another new skill! There are many artists sharing weekly or daily lessons that anyone can access. Here are a few that you might want to check out: Draw Everyday with JJK - author & illustrator Jarrett J. Krosoczka has created a YouTube channel where he is sharing drawing lessons every day.   Lunch Doodles with Mo Willems - this Kennedy Center Education Artist-in-Residence at Home; he even has some episodes where he shares what kids have drawn and shared back with him! Si ght Reading Factory - get your music on! Practice that instrument or sing a song - they are providing unlimited exercises!  Take Art Lessons - Artyfactory's free art lessons share the knowledge and understanding of art and design to improve your artistic skills and to increase your enjoyment in creating artworks. DIY Film School - impr...

Technology Tidbit - Keep them writing!

(Part of our Stay-At-Home series focused on practical ways you can use a resource to foster creativity, connections, and collaboration.) Continuing to write can be very important for students (and adults) right now, not just for learning but also for our social/emotional health.  Writing can help all of us work through emotions, and deal with the uncertainty of the situation many of us find ourselves in currently.  Yet, as many teachers can attest, it can be HARD getting students to start writing. Here are some ideas/resources that can help encourage your child to write: Multi-day writing Journaling example-  COVID-19 Pandemic : "chronicle the changes you observe as your community, the country, and the world respond to Covid19" This document includes a variety of modification for elementary, students with special needs, and even one with added social-emotional reflection questions.  It can be helpful for students to process through their experiences and...

Competition - Write Michigan Short Story Competition

Image
It's time for the Write Michigan Short Story Contest! ELA Teachers - encourage your students to submit their short stories -  From the Write Michigan website : One short story per author Maximum story length: 3,000 words Entry fee: $10 for ages 18 and older ( free for ages 17 and younger ) Contest open to Michigan residents only Complete contest guidelines available in English and en Español Deadline is November 30!

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 m...