Google Sheets Holiday “Shopping”

Teach an introductory lesson to Google Sheets by doing some holiday shopping!

Link to Template (Click TEMPLATE in the right corner to make a copy)

Screen Shot 2018-12-18 at 5.23.07 PM

What will students learn?

Students will learn how to enter data, enter basic formulas, use FUNCTIONS, and create a graph by following the directions in the second tab. They can even checkoff the items as they work using the checkboxes.

Screen Shot 2018-12-18 at 5.25.38 PM.png

Where do students “shop”?

Students shop using this imaginary inventory. Shop for toys, household items, electronics, or even clothes and personal items!

Screen Shot 2018-12-18 at 5.38.40 PM

How can I differentiate for different learners?

This activity is geared towards students in Grades 3-5. You may differentiate the activity by using different templates linked using the Tabs at the bottom of the Sheet. For example, if you want a template with the formulas or headings already inserted, you could use the tab labeled “Differentiation with Formulas”.

Screen Shot 2018-12-18 at 5.27.59 PM

What do students graph?

I added this easy activity for students to graph sales of popular toys. Then, use the checklist below to analyze the data and enter formulas!

Screen Shot 2018-12-18 at 5.39.53 PM.png

How may I assess learning?

Use this nifty exit ticket to assess learning! Add questions, tasks and activities as needed! You can pretty much turn Google Sheets into an activity pack! Or, add a rubric on a new tab!

(Example Exit Ticket Tab)

Screen Shot 2018-12-18 at 5.31.31 PM.png

Do your students do any “holiday shopping” using Google Sheets? I’d love to see your lesson!

 

Integrating Flipgrid Across All Content Areas

Educators across all content areas and grade levels are easily able to integrate this Flipgrid into their curriculum while tremendously enhancing their lessons. 

Flipgrid is a FREE video discussion platform used by millions of students and educators across the globe! Teachers post a topic in a grid (alongside any resources or links) and students may leave detailed video responses. You may also search the Disco Library and find activities already created by other educators and then modify and share them with your students. I love Flipgrid so much that I became a Flipgrid Ambassador a couple years ago!

Why Flipgrid?

Flipgrid is a fabulous tool for promoting student thinking, offering instant feedback and providing students with an authentic audience. Students are so engaged by creating these video responses. Paired with the digital stickers and the social media features (such as the many different “like” buttons and video replies) it’s a guaranteed success!

Newer Updates:

  1. AR capabilities: Scan the QR code in the Flipgrid app and see your responses become augmented reality.
  2. Video Shorts: Login to your educator account. Go to Navigate Shorts in your dashboard. Click “Record a Short”. Share the link to your short anywhere!
  3. Microsoft’s Immersive Reader: The Immersive Reader now works in the assignment description and also the student feedback area.
  4. Supercharged Replies: Students may now add titles and attachments to their replies.
  5. Closed Captions: Closed captions are now added to every video response. Now you may even edit the captions!
  6. Filters: There are now a variety of filters allowing students to modify the video appearance. The pixelated filter is an amazing option for students that are reluctant to record their faces.
  7. Whiteboard: There is now a whiteboard feature allowing students to draw and type information in their video.
  8. Epic: Flipgrid now works with the popular reading app, Epic! Students may read a story and then reflect on their reading using Flipgrid.

What other apps work with Flipgrid? 

If you search the Disco Library you will find activities that integrate with Epic, Wonderopolis, Tynker, Skype, Pebble Go,  Code.org, Flowcabulary, Nearpod, and more! Find your favorite activity and share it with students by simply copying and pasting the link into your desired app. Or, have students join by entering a code a Flipgrid.com.

How may I integrate Flipgrid into my curriculum?

Flipgrid provides a HUGE integration library and also an amazing ebook guide for educators.  Here are some of my ideas for integrating Flipgrid in your curriculum. (I used Google’s Autodraw program to create the images.)

Flipgrid infographic

Collaborate with educators from around the world!

Flipgrid makes it easy to collaborate with like-minded educators around the world. Simply click on #GridPals in your dashboard and search for an educator. You may choose to allow educators to search your profile and connect with you. You may also filter by grades and subject area.

Have you tried using Flipgrid? How are you using it with your students?

10 Tools to Promote Number Talks

Are your students struggling to explain their strategies? Did your students receive low scores on the open response portion of a digital test? If so, increase student achievement by talking about math using technology!

Encourage students to:

  • Express their thoughts, ideas, solutions, and questions
  • Observe their peers
  • Receive and give constructive feedback
  • Revise and edit their responses while elaborating
  • Use technology to produce not consume information
  • View written transcripts of their audio recordings
  • Become more familiar with basic technology skills and keyboarding
  • Finally, construct their own detailed and accurate written responses

Here are 10 technology tools that will help your students increase their ability to share and expand their ideas about math:

copy-of-number-talk-tools-2.jpg3.jpg

How do you encourage your students to talk about math? Do you use technology?

Google Keep: Talking About Math: #MathSnaps

Some educators are referring to annotated digital images of student math problems as #mathsnaps. You can capture and archive student thinking within minutes! Google Keep is such an easy way to accomplish this!

Why Use Google Keep?

Student may:

  • Take a photograph
  • Add annotations to the image
  • Record their thinking
  • Receive a transcript to edit and revise
  • Share with a teacher
  • Collaborate with a colleague
  • Add links to websites or documents
  • Receive feedback
  • Insert Keep Notes into Google Docs, Drawings or Slides
  • Save in The Cloud

Video Tutorial

I used the FREE screen recorder on IOS 11 to create this short video tutorial.

In Summary

The next time you distribute student tests or quizzes, or just want a quick formative assessment, consider asking students to demonstrate their understanding and corrections by using Google Keep. It’s free. It’s easy. And, it’s fun! The more students talk about math the more they will increase their understanding and their standardized test scores! And, I know how much students care about those test scores 😉

 

HyperDrawings: Creating AMAZING Flipped and Blended Learning Activities for Math Class.

Over the last few months, Twitter has been erupting with posts from educators that are excited about HyperDocs. However, as I started coaching my teachers in best practices for creating and using HyperDocs, I discovered that Google Drawings seems to be my preferred G Suite app to use for math instruction. There are so many possibilities when it comes to creating amazing flipped or blended learning materials!

Here’s why I prefer HyperDrawings:

  1. You can embed YouTube Videos! Yes! Just copy video inserted into Google Slides into your Google Drawing! (See tutorial video below)
  2. You can add the directions and assignments in the blank space next to the canvas.
  3. The canvas is an amazing area for students and teachers to demonstrate understanding, solve problems, create screencasts, and use virtual manipulatives.
  4. You can easily add Bitmoji stickers and clipart by dragging them into the blank space next to the canvas.
  5. Students can collaborate and receive feedback using the Comment and Share Tools.
  6. Students can research using the Explore Tool.
  7. Google Keep is now integrated into Google Drawings.

Example of a HyperDrawing used for Flipped or Blended Learning

Screen Shot 2017-04-26 at 7.52.32 PM

(Click here to View/Make a Copy of Example HyperDrawing)

HyperDrawings: Not Just a Drawing with Links

When I think of using HyperDrawings in the math classroom, I am NOT just talking about creating a drawing and adding hyperlinks. They HyperDrawings should be engaging!

HyperDrawing activities should ask students to use the following skills:

Skill

Example Tool

1) Activate Prior Knowledge Vocaroo, QR Codes, Google Docs, Padlet
2) Explore YouTube, screencasts, posters, websites
3) Create Google Drawings! Add links to: Google Slides, Powtoon, WeVideo, BrainPOP Make-A-Movie, screencasts, Popplet
4) Share Padlet Wall, Google Classroom, SeeSaw, Comments, Email, Google Slides, Google Drive
5) Self-Assess  Google Forms, Padlet Wall, Google Docs, blog post, portfolios, rubrics, surveys, Kahoot, Quizziz, Formative

 

Rubric for Evaluating Your HyperDocs/HyperDrawings

Here is a new rubric I created for evaluating your HyperDocs

Screenshot 2017-10-07 at 10.30.05 AM

More Resources:

Getting Started with Google Drawings and Math

Eric Curts has an AMAZING screencast and blog post with so much information on integrating Google Drawings into the math curriculum. Check out Eric’s Google Doc filled with resources. And, Kasey Bell at Shake Up Learning has a fabulous Google Drawing Cheat Sheet! What more do you need?

Have you ever created or used HyperDrawings?