Stop Motion Slides

There are multiple options for creating animations (GoAnimate, Scratch, etc.) but my favorite way to do it is creating Stop Motion Slides.  I like that I can make it exactly how I want it in this format.  I think this has tons of potential in all subject areas (Please comment or share on Twitter with the hashtag #StopMotionSlides if you come up with any cool uses for it).

There are two main steps:

  1. Create a Google Slideshow where each slide is an incremental change from the previous one (like a flipbook).
  2. Open the slideshow up in Presenter view and use a screencasting tool (i.e., Camtasia, Screencastify, Screencast-o-matic) to record it as a video.

Here are a few of my tips for making it quick:

  • Ctrl+D or ⌘+D to Duplicate Slides
  • Use Arrows to Move Smoothly & Incrementally
  • Move in groups when appropriate
  • Rotate things incrementally
  • Change Colors gradually
  • Use Transparency
  • Use Ordering

Add Customizable Columns to Google Docs

One of the complaints from Day 1 with Google Docs was the inability to add columns.  Not too long ago, Google added this functionality, but it’s still sorely lacking in customizability.  So, here’s a workaround:

  1. Insert a Table
  2. Enter your text and images
  3. Make the table’s border 0 point (a.k.a., invisible)
  4. Find a microphone
  5. Drop it

Exploring the Number pi with Google Sheets & Forms

What better way to celebrate Pi Day than with a hands-on, tech-on exploration activity that helps students build their own understanding of what pi really is?  Well, probably a good piece of pie, but this is awesome nonetheless.

Here’s what you do:

  1. Get a bunch of fabric tape measures (using string and then measuring lengths on the string works too).
  2. Get a bunch of circular objects.
  3. Have kids measure the circumference and diameter of different circular objects.
  4. Instruct the kids to submit their measurements to a Google Form
    (note: my form doesn’t collect names, but it would be best to collect them so you can help kids who have measurement errors).
  5. Setup a QUERY formula to find the circumference/diameter for each entry.
    =QUERY(B2:C1000, “select B/C”)
  6. Fix that pesky 2 in the Query formula after the first submission – when the first entry inserts a row, it changes B2 to B3.  Change it after the first entry and you’re good to go.
  7. Setup an AVERAGE formula to find the mean of the circumference/diameter calculations.
  8. Project the spreadsheet as entries are recorded.  See what your kiddos notice about the numbers they see on their screen!

Adding Images with Captions in Google Docs

Years ago, I heard plenty of complaints about how Google Docs just didn’t measure up to Microsoft Word.  My response always centered around the ways that Google Docs could change the way we worked and students learned.  Most people have bought in, but I still occasionally hear complaints about missing features.  One of them is adding captions to pictures – a major informational text skill in the English Language Arts standards.

Check out the GIF below to see how to use the “Insert > Drawing” tool to perform this task.

I should note, as has been pointed out that me on Twitter, that this process will reduce the quality of the image. I think that, for a student’s project it’s still okay. Just, you know, maybe not for your doctoral research paper or school yearbook. 

Trying out FlipGrid

After seeing Amy Roediger‘s post about FlipGrid, I had to try it.

FlipGrid is a platform where (1) teacher poses a prompt or question, (2) students access that “grid” with a code, (3) students record their response, (4) students view each other’s responses and (5) students can comment on or like classmate’s response(s).

Amy’s example of the students showing, describing and explaining Chemistry lab experiments/demonstrations was phenomenal.  On her first attempt out of the gate, she went above and beyond the “record a video response” format.

So, I’m getting in on the action.  At this link, you’ll see a prompt from me.  Hopefully, you’ll also see other professionals’ responses.  And, even more hopefully (if that makes sense), you’ll record you response.  I can’t want to hear what you share!!

STEM Practices

In a training webinar for the PEAR (Partnerships in Education and Resilience) Institute’s DoS (Dimensions of Success) Observation Tool, the facilitators discussed how the 3rd of their 4 domains – STEM Knowledge and Practices – was based on the STEM Practices outlined by the NGSS‘ (Next Generation Science Standards) “A Science Framework for K-12 Science Education.”  I think that these 8 practices are fantastic and that schools should place a focus on integrating into the curriculum maps for all content areas, not just science.  Here they are: Continue reading STEM Practices

Exploring Measures of Center with Google Sheets

My obsession with Google Sheets is no secret. I loooove spreadsheets.  And I think that they have a big place in education, especially in math (but elsewhere as well).

Recently, I posted about how you can prove the mean (or average) formula using Google Sheets.  In this post, I’d like to share with you how you can find all 3 measures of center (or measures of central tendency) and explore them in Google Sheets.  I love to change or add numbers in the data set and ask students to make predictions about what will happen.  It really is a great–and relevant–way for students to become more familiar with these statistical measures.

Proving the Algorithm for Mean (Average) in Google Sheets

I am a huge spreadsheets nerd and a huge advocate of the use of spreadsheets in mathematics instruction.  If you keep an eye on my site (or Twitter feed or YouTube Channel) you’ll see plenty of my reasons why I feel this way.  Here’s one:

Spreadsheets are a great tool for proving mathematical algorithms and formulas.  In this post . . . how we can use a Google Sheet to prove the formula for the mean (which, in spreadsheet land, is known as the average).

Check out this post about finding and exploring all 3 measures of central tendency with Google Sheets.