-8.6 C

This Google Sheets Hack Will Have Math Lecturers Celebrating



What have been your math lessons like? Mine was like this: image 12-year-old me sitting in school listening to a lecture from Mr. Smith.  Like all good scholar, I accomplished my homework that night and turned it within the subsequent day (hoping it was appropriate). In a number of days, I’d obtain my paper again with some pink “x” marks exhibiting what I hadn’t mastered. However by that point, we had moved on to a brand new mathematical idea, so it was too late to revisit what I didn’t perceive.  And so forth went the maths classes, till it was time to take a check.  

Sadly, that is nonetheless the case in lots of math lessons right now on the secondary degree. Nevertheless, it doesn’t must be this fashion. Throughout my coaching as a Google Licensed Educator, I found that Google Sheets can present fast and straightforward suggestions to college students and lecturers.  This has been particularly useful to me with restricted prep time and a myriad of different school-related duties.  Such is the lifetime of a busy instructor! 

Right here’s how my Google Sheets hack works. Not too long ago, I launched a brand new idea to my math seventh-grade math college students: fixing one-step equations. Throughout impartial apply, I present them with a chunk of paper, after which I ask them to open the digital task from the digital math classroom.  College students write down the equations on the paper and resolve them.  Lastly, they “verify” every answer utilizing a Google Sheet.  See the image beneath. As college students enter an answer, the cell will reveal a inexperienced coloration whether it is appropriate.  If the answer is wrong, the field will stay yellow.  My college students are directed to offer the issue a second strive.  If college students are nonetheless struggling, they might request assist from their math companion or me.  

As an alternative of spending your treasured time grading or checking work do much less work forward of time. Create a self-checking Google Sheet utilizing conditional formatting and let an algorithm do the grading for you.

Wish to strive it for your self?  Right here’s how:

1. Discover math issues that you really want your college students to unravel.  

You should definitely have the options as properly.  On the primary day of the lesson, I like to make use of primary math issues, comparable to these proven in determine A. 

2. Open a brand new Google Sheet. 

Use column A to point the issue quantity, column B to sort the maths drawback, and column C for the options (solutions). 

3. Format your Options column.

When you’ve entered the issue and drawback quantity, spotlight the answer cells, go to Format in your toolbar, and choose the conditional formatting function. Right here, you possibly can present the proper reply for the Resolution column and coloration code responses as wanted.  

Are you extra of a visible learner? Right here’s a step-by-step video together with an instance: 

Video Self-Verify 4.2

Self Verify 4.2

For the previous two college years, this hack has helped my college students speed up by way of the maths curriculum faster and extra completely. I’ve discovered that utilizing these self-checking assessments, my college students are performing higher on requirements. Much more importantly, they’ve adopted a “do that once more” perspective as an alternative of ready days for suggestions that’s already too late.  This hack is not only for math class.  This formative technique can be utilized in different content material areas as properly!  Maybe for vocabulary apply, checking spelling phrases, or figuring out areas on a map for social research.  The probabilities are limitless!

What do you consider this hack? Tell us within the feedback.

Searching for extra articles like this? You should definitely subscribe to our newsletters!

Subscribe to our magazine

━ more like this

55+ Actual-World Mission-Based mostly Studying Concepts for All Pursuits

Mission-based studying is a scorching matter in many faculties lately, as educators work to make studying extra significant for college students. As college...

Ed Tech Digest | Larry Ferlazzo’s Web sites of the Day…

  Ten years in the past, in one other considerably futile try to cut back the backlog of sources I wish to share, I...

Federal funds to fight pandemic studying loss do not mirror want

Different instructional reforms – resembling instructor coaching and curriculum modifications – could have tamped studying loss in some states. “You didn’t see as...

Inside The On-line Neighborhood The place House-Schoolers Study How To Flip Their Children Into ‘Fantastic Nazis’

On Nov. 5, 2021, a married couple calling themselves “Mr. and Mrs. Saxon” appeared on the neo-Nazi podcast “Achtung Amerikaner” to plug a...


Please enter your comment!
Please enter your name here