Google Sheets - Fun with Date functions

Google Sheets - Fun with Date functions
Google Sheets - Fun with Date functions
Google Sheets - Fun with Date functions
Google Sheets - Fun with Date functions
Google Sheets - Fun with Date functions
Google Sheets - Fun with Date functions
Google Sheets - Fun with Date functions
Google Sheets - Fun with Date functions
Grade Levels
Product Rating
Product Q & A
File Type

Compressed Zip File

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

10 MB|64 pages
Share
Product Description
In this project, students will learn all about how to work with dates in Google Sheets. The idea is to type in some fictional students from a school. Students will see how they can use the built in functionality of Google Sheets to quickly figure out date calculations. To start students will enter only 2 pieces of information; student name and birthday. Then they use date functions to let Google Sheets do the thinking on the following columns: Age(Years), Age (Days), Age (Months), Month Year school started, graduation date, and days until graduation. Functions are like little pieces of built in code that do very specific jobs. Along the way, the students will also learn how to tell Google Sheets to format the dates just as they want to see them, how to add formatting to make the table and sheet look good, and how to format text vertically. As always they will use the nifty “fill down” shortcut to make their work flow that much more efficiently. Who wants to do more typing than they need to, right?

This lesson would be appropriate for experienced beginners to intermediate level users of Google Sheets. If you would like to check out more beginner level material I have compiled, please feel free to check out Google Sheets Bundle - 10 Great Lessons for Beginners

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 links to the answer files

Tips:
- Take the time to do this activity yourself prior to presenting to the students so you are familiar with the steps. This is especially true in this case as there are no sample excel answers provided. The reason no excel answer files are available this time is because when I downloaded the Sheets version of the completed answer to Excel, there were many inconsistencies and errors created. Basically, Excel does things differently when it comes to date functions.



Others you might like:
Google Sheets Bundle - 10 Great 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
64 pages
Answer Key
N/A
Teaching Duration
90 minutes
Report this Resource
Loading...
$4.99
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
$4.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