Google Spreadsheet Hack

I've been at the Google Apps for Education Summit this weekend! 


And I just HAD to share this because I am SO excited to figure out this little trick!!!

About a month ago I did two tutorials on how to create a Google Form to collect BTS info from parents, and on some tips & tricks to help you once the info is in Spreadsheets. Now...


Watch this short 3 minute video to see how to transfer the info from a Google Spreadsheet to a Google Doc! This can come in handy when you'd like to see all of the info from one responder without having to scroll over or wrap text! 


Hope you're having a great weekend!!!


0

Sit Spots & "Think Spots" + a Giveaway

HAPPY THURSDAY my friends! 
Thursday = 1 more day until Friday!!!

While in Vegas this summer, some of my amazing teacher friends and I came across Sit Spots! 

Molly, me!, Amber, Jen, & Angela (and Aris!!!)

Today, we're excited to bring you....


As a digital learning coach this year, I go into many different classrooms to work with lots of students and teachers (which I love!)- but it can be scary walking into someone else's classroom where you're not exactly sure of procedures. 

This is where Sit Spots, or "Think Spots" as I usually call them come in! 

Before I begin working with a class where I know we're going to need different, designated areas to work in teams, I place the Think Spots out around the classroom.


When it's time to go work, the kids LOVE finding a "Think Spot" to work at. Here they are working away, and it brings a sense of organized chaos to my life. 

***Thank you to Mrs. William's and her amazing 1st graders for sharing their classroom with me!!!***

Make sure to hop on over to my AMAZINGLY talented and ADORABLE friend Amber at Peppy Zesty Teacherista to see how she uses Sit Spots, and enter the giveaway below!!! 


a Rafflecopter giveaway

If you can't wait, you can use the code SITSPOTS6 to get a discount at Sit Spots now! 

5

Getting Started with iPads: Lesson #1

I had so much fun working in a second grade classroom this week to help the teacher introduce their iPads! The kids were of course ecstatic too!

We began by telling the students we were going to discuss iPad rules, why rules are important, etc. etc. etc. I allowed the kids to start brainstorming any idea they though might be a good rule for us to have when using the iPads. Any idea they had, I added to our Popplet- one of my favorite apps/websites! There is a free version & a paid version (only difference- the paid version allows you to create an unlimited amount of Popplet projects- very worth it!!!!).


As we are talking and discussing and and brainstorming and shouting out rules, I had students begin to learn how to Sketchnote. 


Basically you draw pictures, words, doodles, whatever, to help remember content. 

Here is an awesome one from Sylvia Duckworth :)


and I love this one too!


When students Sketchnote, they tend to really pay attention to the lesson or conversation, stay engaged longer, and retain the information better. 

Here are some of the Sketchnotes the 2nd graders created as we discussed iPad rules:







This was surprisingly difficult for students (I thought it would be easy...) because they were convinced there was a "right answer" for these papers, and if they completed one drawing they were all done. Students are used to getting worksheets, filling out one right answer, and then screaming "I'M DONE!" from across the room and moving on to the next assigned activity. With Sketchnoting, you're never really done is there is absolutely no right answer... So I kept having to remind them to keep drawing, keep writing, keep THINKING when they would tell me they were finished! :) This *for the most part* kept them engaged for the entire lesson while I led this discussion about rules #win.

Whenever students would magically come up with a rule I knew needed to be a rule, I had them come up with a hand motion to go with the rule, and we came up with a chant ("iPad Rule 1 is USE CLEAN HANDS!") and we just kept adding them on as we went. Here's a video of the chant I've used with my class in the past (start it at 14:04). :)

Feel free to download the iPad Rules Sketchnote paper {HERE!} I hope you and your students enjoy it!

And you can also find my editable iPad rule posters {HERE!} 


Have a great weekend!!!! 

1