Google Sheets - Balance Sheet Lesson

Google Sheets - Balance Sheet Lesson
Google Sheets - Balance Sheet Lesson
Google Sheets - Balance Sheet Lesson
Google Sheets - Balance Sheet Lesson
Google Sheets - Balance Sheet Lesson
Google Sheets - Balance Sheet Lesson
Google Sheets - Balance Sheet Lesson
Google Sheets - Balance Sheet Lesson
Product Rating
4.0
1 rating
File Type

Compressed Zip File

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

6 MB|47 pages
Share
Product Description
Students learn a practical, real-life skill in this lesson. They discover how to create a balance sheet similar to what you would see in a bank statement. Fictional debit and credit transactions are typed in and students create a custom math function to calculate a running bank balance. This lesson also explores some data validation techniques to make data entry more accurate. Specifically, students use a date picker control to ensure that date formats are consistent. Also, they learn to use drop-down lists that contain all the categories of expenses/credits they would use.

Students also review how to create charts in the lesson based on data they select from their data populated sheets. A valuable shortcut called "Filling Down" is demonstrated so that students can click and drag to quickly reuse the functions and avoid retyping. Students also review basic formatting in Google Sheets including changing fonts, colors, etc...

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.

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 text file which contains a link to a viewable version of the answer in Google Sheets 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 - 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
Google Sheets - School Grades Math Lesson
Google Docs Lesson Bundle - 4 Essential lessons for beginners
Excel 2010 Beginner Lesson Bundle
Total Pages
47 pages
Answer Key
Included
Teaching Duration
2 hours
Report this Resource
Loading...
$6.50
Digital Download
More products from Cluney's Classroom
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
$6.50
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