Whoops! Something went wrong.

Click here to refresh the page

Google Sheets - School Grades Math Lesson

Google Sheets - School Grades Math Lesson
Google Sheets - School Grades Math Lesson
Google Sheets - School Grades Math Lesson
Google Sheets - School Grades Math Lesson
Google Sheets - School Grades Math Lesson
Google Sheets - School Grades Math Lesson
Google Sheets - School Grades Math Lesson
Google Sheets - School Grades Math Lesson
Grade Levels
Product Rating
3.8
5 ratings
File Type

Compressed Zip File

Be sure that you have an application to open this file type before downloading and/or purchasing.

5 MB|42 pages
Share
Product Description
Students enjoy learning how teachers figure out grades in this lesson aimed at beginners of Google Sheets. The math covered in this assignment is the review of the SUM and AVERAGE functions, and students are shown how to use division to calculate percentages for grades. Basic formatting is reviewed here, and the Paint Format button is introduced to demonstrate a valuable time saving shortcut for students. Students are also asked to create a second "Report Card" tab that displays overall grades for specific subjects.

A valuable shortcut called "Filling Down" is reviewed so that students can click and drag to quickly reuse the functions and avoid retyping.

The instructions come in the form of an interactive .pdf file, which allows students to navigate throughout the document by clicking buttons, click on a linked up Table of Contents, and toggle between full screen mode and normal viewing mode. Students enjoy this measure of control over how they get around the instructions, and they are quickly and easily able to backtrack and review information using the Table of Contents. Additionally, there are a couple of opportunities for differentiated learning where a "Show Me" button exists to expose students to skills selectively. This allows those students seeking a challenge the option to figure things out without being shown how.

Google Sheets is basically like an online version of Excel. It is a great alternative to Excel in that it allows for student collaboration and for students to access their work wherever they have an internet connection!

Please feel free to contact me with questions or comments regarding this assignment! I hope that you find it useful and I look forward to hearing from you.

Included in this package:
- a .pdf teacher instruction file with plenty of screenshots and clear instructions.
- a sample answer file (Excel format)

Tips:
- Take the time to do this activity yourself prior to presenting to the students so you are familiar with the steps.

Note:
This lesson is part of the Google Sheets Bundle that I offer which you can find at: Google Sheets Bundle - 8 Great Lessons for Beginners

Others you might like:
Google Sheets Bundle - 8 Great Lessons for Beginners
Google Sheets - Basic Math using SUM and Average
Google Docs Lesson Bundle - 4 Essential lessons for beginners
Excel 2010 Beginner Lesson Bundle

Total Pages
42 pages
Answer Key
Included
Teaching Duration
90 minutes
Report this Resource
Loading...
$3.99
Digital Download
More products from Cluney's Classroom
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
$3.99
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up