KATE'S MATH LESSONS
  • Home
  • LESSONS
    • Pre-Algebra
    • Algebra 1
    • Geometry
    • Algebra 2
  • About
  • Contact
  • Blog
  • Shop
  • Courses
  • Home
  • LESSONS
    • Pre-Algebra
    • Algebra 1
    • Geometry
    • Algebra 2
  • About
  • Contact
  • Blog
  • Shop
  • Courses
Picture

Welcome to Kate's Math Lessons!

My mission is to make life easier for secondary math teachers.

How to Make Self-Checking Math Activities in Google Sheets

2/16/2021

3 Comments

 

Google Forms™ vs. Google Sheets​™

With distance learning, I know many of you have made the switch to using more digital activities this year and I'm guessing you may already know how to make math activities in Google Forms.  These are great because Google can grade them for you and it's so easy to see student results (you can try one of my math activities for Google Forms for free to test it out).
Free Self-Grading Math Activity for Google Classroom

​I love using digital activities with Google because they're so easy to assign with just a link and students love the automatic feedback they get.  I also love how easy it is to see which questions students are getting wrong as you make remediation plans.

​Did you know that you can set up activities to be graded automatically in Google Sheets​ as well
?  This spreadsheet style of activity can be set up to give students instant feedback on their answers.  Students type in their answers and it's set to automatically let students know when their answer is correct.  I love how you can quickly glance around the room and see the colors changing on students' screens as they work.  
Picture

​The great thing about this type of activity is that they're 
editable!  You can type in your own questions or insert a picture and I'll show you how to edit the answer so the color changes automatically.

How to Make Your Own Self-Grading Math Activities

Step 1: Copy my template
  The easiest way to start making your own is to make a copy of one of mine as a template.  Don't worry if it's not the topic you want, I'll show you how to change the questions in the next steps.
​
Click on the picture below to download a free template. 
Free template to make self-graded math activities in Google Sheets
​
​Step 2: Edit the Questions

​You can double click on any question and type in your own.  You can also insert an image to use as a question, just click on Insert at the top and select Image.  You'll likely have to adjust the size of the cells if you choose this option.

Note:  You should get a "Heads Up! You’re trying to edit part of this sheet that shouldn’t be changed accidentally. Edit anyway?" message when you go to edit.  I set up this notification so that students don't accidentally delete the questions as they work on the activity.

Step 3: Edit the Answers
Start by right-clicking in cell C5 (the first green correct cell).  Choose Conditional Formatting.  Double click on the right where it says Custom formula is 
=$B$5=7
This is set up to accept 7 as the correct answer.  Delete the number 7 and type in the answer for your new question that you created in cell A5.  Then hit Done.

Next, click in cell D5.  This is the cell that will show up as orange and say Incorrect if the answer is incorrect.  Right click and choose Conditional Formatting again.  Double click on the right where it says the Custom formula is =$B$5<>7.  This is set up to turn the cell orange if the answer is not 7.  Delete the 7 and type in the new correct answer.  Hit Done when ready.

You can also edit the colors of the cells and change the Correct and Incorrect wording if you'd like.

Step 4: Assign to Students
When you're ready, send to students!  See the directions in the free download for more details on this step.

How Will You Use These Self-Grading Math Activities?

I'd love to hear your thoughts on how you can use this type of activity in your classroom.  Let me know what you think!

If you're interested in more pre-made activities, you can check out my entire collection of math activities for Google Drive to see more activities like these.
Triangle Sum Theorem Math Activity for Google Sheets - perfect for distance learning
How to Create Digital Math Activities in Google Sheets - Distance Learning
3 Comments
view sonic link
3/16/2021 08:34:53 am

Great information ! Thank you for sharing this article.

Reply
Sue Wilkes
5/12/2021 05:26:29 pm

I am trying to make an activity (using your template) with exponents. Is that possible? I don't see how to insert anything to let me type exponenets.
Thanks

Reply
Kate's Math Lessons
9/20/2021 08:57:16 am

Google doesn't have a built-in editor to add exponents, but I recently posted a work around here:
https://www.katesmathlessons.com/blog/using-subscripts-and-superscripts-in-google-sheets

Reply



Leave a Reply.

Want to try one of my digital math activities for free?  Click the link to grab the teacher version or student version.

Home

About

Privacy Policy

Lessons

Contact

Copyright © 2015 - 2021 Kate's Math Lessons