What others say
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.
There are a few options for instructions:
1) Online instructions - Rich, interactive instructions which include a linked Table of Contents available from every page, access to some video instruction, detailed screenshots, and excellent document navigation options. There is also some limited animation of titles to increase student interest in the instructions. These instructions are available from any device that connects to the internet and will work in any browser, so they would be accessible from home for the students. The link to the online instructions is included in the Teacher's Manual.
2) Interactive PDF instructions - Includes all the bells and whistles of the online instructions except for the limited animation and availability.
3) Paper instructions - The Interactive PDF instructions can be printed.
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 teacher's manual in PDF form which includes setup options, teacher tips (links to video tips included), and information about all lesson materials.
- access to the above mentioned online instructions from the teacher's manual.
- an interactive PDF version of the instructions.
- access to an example answer in Google Sheets from the teacher's manual.
Tips:
- Take the time to do this activity yourself prior to presenting to the students so you are familiar with the steps.
- Read through the teacher's manual for additional tips and tricks.
Note:
This lesson is part of the Google Sheets Bundle that I offer which you can find at:
Google Sheets Bundle - 10 Terrific Lessons for Beginners
It is also included in my Google Drive Bundle (Google Docs & Google Sheets bundles combined):
Google Drive - 14 Complete Lessons for Beginners
Others you might like:
Google Sheets Bundle - 10 Terrific Lessons for Beginners
Google Drive - 14 Complete Lessons for Beginners
EXCEL 2016 - 10 Complete Lessons for Beginners
Google Docs Lesson Bundle - 4 Essential lessons for beginners
Highlights
What others say
Save even more with bundles
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.
There are a few options for instructions:
1) Online instructions - Rich, interactive instructions which include a linked Table of Contents available from every page, access to some video instruction, detailed screenshots, and excellent document navigation options. There is also some limited animation of titles to increase student interest in the instructions. These instructions are available from any device that connects to the internet and will work in any browser, so they would be accessible from home for the students. The link to the online instructions is included in the Teacher's Manual.
2) Interactive PDF instructions - Includes all the bells and whistles of the online instructions except for the limited animation and availability.
3) Paper instructions - The Interactive PDF instructions can be printed.
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 teacher's manual in PDF form which includes setup options, teacher tips (links to video tips included), and information about all lesson materials.
- access to the above mentioned online instructions from the teacher's manual.
- an interactive PDF version of the instructions.
- access to an example answer in Google Sheets from the teacher's manual.
Tips:
- Take the time to do this activity yourself prior to presenting to the students so you are familiar with the steps.
- Read through the teacher's manual for additional tips and tricks.
Note:
This lesson is part of the Google Sheets Bundle that I offer which you can find at:
Google Sheets Bundle - 10 Terrific Lessons for Beginners
It is also included in my Google Drive Bundle (Google Docs & Google Sheets bundles combined):
Google Drive - 14 Complete Lessons for Beginners
Others you might like:
Google Sheets Bundle - 10 Terrific Lessons for Beginners
Google Drive - 14 Complete Lessons for Beginners
EXCEL 2016 - 10 Complete Lessons for Beginners
Google Docs Lesson Bundle - 4 Essential lessons for beginners
Reviews
