Google Sheets - Six Super Lessons for Intermediate Learners

Google Sheets  - Six Super Lessons for Intermediate Learners
Google Sheets  - Six Super Lessons for Intermediate Learners
Google Sheets  - Six Super Lessons for Intermediate Learners
Google Sheets  - Six Super Lessons for Intermediate Learners
Google Sheets  - Six Super Lessons for Intermediate Learners
Google Sheets  - Six Super Lessons for Intermediate Learners
Google Sheets  - Six Super Lessons for Intermediate Learners
Google Sheets  - Six Super Lessons for Intermediate Learners
Grade Levels
Product Rating
File Type

Compressed Zip File

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

61 MB|369 pages
Share
Product Description
If you have exposed your students to the basics of using Google Sheets and would like to take it a step further, this six-lesson bundle could be just the ticket. It is priced to save you over 33% off buying each of the products individually. Each lesson comes with detailed step by step instructions with plenty of screenshots. This bundle would be perfect after an introduction to the fundamentals is in place, or as a supplementary work package for those fast finishing, independent, challenge seekers in your class who are always itching for more learning.

The instructions come in the form of interactive .pdf files, which allow students to navigate throughout the documents by clicking buttons, click on linked 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.

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

Included in this package:

Google Sheets - Endangered Species Project

This project is a great vehicle for exposing students to some neat little formatting tricks to make their sheets look great. The premise is for students to research and present 10 animals that are on the endangered species list. Students will list each of the species in the main sheet, and also create an individualized tab (or sheet) that lists more information about the species. The subject matter (animals) appeals to a broad range of students, so it keeps them focused. It is a fantastic project that will likely take a few classes to complete.

Students learn to quickly use alternating rows of color to give their data tables organization and a punch of color. They also learn to use links to allow for fluid navigation within their project. On the main sheet, students make use of a drop-down list which lists the status of the animals. This drop-down list exposes the students to the concept of data validation, the idea of minimizing typos and human error when possible. This project allows for differentiated learning, as suggested extensions are provided for those fast finishers or students who are looking for a challenge


Google Sheets - Activity Time Tracker

In this comprehensive project, students enter in fictional data for some students relating to how they spend their time when not in school. Time is broken into the following categories; homework, reading, exercise, watching TV and playing video games. The data is on a per-week basis.

A summary sheet, which is separate from the time tracker data sheet, provides summary information at a glance. The goal is to mine the activity tracker sheet which contains the data for some interesting nuggets such as a Count of the number of boys and girls, and the average of time spent on "healthy habits", and many tidbits. This project allows for differentiated learning, as suggested extensions are provided for those fast finishers or students who are looking for a challenge.

Students learn to quickly use alternating rows of color to give their data tables organization and a punch of color. On the main sheet, students make use of a drop-down list for gender. This drop-down list exposes the students to the concept of data validation, the idea of minimizing typos and human error when possible.


Google Sheets - Employee Information Sheet

In this engaging project, students really learn how to use some cool text manipulation functions to expedite their work and minimize typing.

The idea is that students work at a medium sized t-shirt manufacturing company called “Tim’s Tees”. The company accepts online orders, then designs and sends t-shirts to customers. The company has grown rapidly and has had to hire a bunch of new employees. Unfortunately, the only information on employees is contained in a poorly organized Excel spreadsheet that is full of errors and needs updating. The mistakes include names not being capitalized, extra spaces, and a lack of information. The "boss" wants students to move the spreadsheet from Excel to Google Sheets. He also wants them to “clean up the data”. In other words, remove spaces and make sure capitalization is on point.

Students are expected to split the names into first and last names, to add company email addresses, usernames and passwords for the company computer network, employee numbers, start dates, department names, and also to add a field which determines if the employees are eligible for bonuses or not.
Since the "boss" needs this done in an afternoon students need to act fast. They need shortcuts, and they will use some functions in Google Sheets, as well as an add-on, to speed things up.


Google Sheets - Fun with Date functions

In this one, 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 workflow that much more efficiently. Who wants to do more typing than they need to, right?


Google Sheets - Frank's Catering Invoice Math

In this activity, the concept is that the students have just been hired at a new catering company called “Frank’s Catering”. The company is so new they literally have had just one job, to cater a retirement party for a local family doctor. Your job is to organize the paper copy (a screen shot of the "paper" is provided) of an invoice into a digital invoice constructed in Google Sheets. Essentially, students will need to type in the data and set up the Sheet so that the calculations happen automatically.

Along the way students will learn many skills, including the following:
- Using built in Math functions such as PRODUCT for multiplication and MINUS for subtraction
- Creating custom functions to calculate tax, total, discount and grand total
- Using "Named ranges" instead of cell references to simplify the process of creating functions
- Formatting tips and shortcuts


Google Sheets - Intro to Pivot Tables

This detailed, comprehensive activity is perfect for late beginner to intermediate level Google Sheets users. Students take on the role of fitness instructors who are creating a multi-table Google Sheet to better organize their client, service, and billing information. Additionally, students learn useful real-world tricks and tips to promote accurate data entry and simple data analysis.

Along the way students will learn many skills, including the following:
- Using Named Ranges and drop-down lists to create better data entry and validation
- Making use of the powerful VLOOKUP function to simplify and automate parts of the data entry process
- Creating Pivot Tables to create valuable alternate views of important information
- Formatting tips and shortcuts


Tips:
- Take the time to do these exercises yourself prior to presenting to the students so you are familiar with the steps.
- I find it helpful to demo a finished answer and then click on another tab that contains a partially completed copy of the finished answer. I then show students how to complete new or challenging skills.

Others you might like:
Google Sheets Bundle - 10 Terrific Lessons for Beginners
Google Docs Lesson Bundle - 4 Essential lessons for beginners
Excel 2010 Beginner Lesson Bundle

Total Pages
369 pages
Answer Key
N/A
Teaching Duration
1 month
Report this Resource
Loading...
$22.00
Digital Download
List Price:
$33.02
You Save:
$11.02
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
$22.00
Digital Download
List Price:
$33.02
You Save:
$11.02
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