During this class, students will learn the basic functions of Google Sheets and get hands-on practice. We will begin by discussing real-world uses for Google Sheets and related vocabulary. We will then dive in and begin using the program. 

In this class, students will imagine they are starting their very own pet-sitting company!  In order to manage multiple animals' appointments, they will create a schedule using Google Sheets. Next, they will create a basic earnings tracker in order to track how much their business has earned.

I will share my screen so students can watch me using the program as I describe its functions.  Students should have Google Sheets pulled up on their computer prior to starting class, so they can use the program and follow along as I teach the class.  As time allows, the students will have the ability to share their screen in order to ask questions and share their work.  

𝗣𝗿𝗲-𝗥𝗲𝗾𝘂𝗶𝘀𝗶𝘁𝗲𝘀 𝗮𝗻𝗱 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗡𝗲𝗲𝗱𝗲𝗱:
Students do not need any experience with Google Sheets, but should have basic desktop or laptop knowledge, such as the ability to use a mouse, use a keyboard and open a program. Google Sheets is available online at: https://docs.google.com/spreadsheets/u/0/?tgif=d

𝗧𝗼𝗽𝗶𝗰𝘀 𝗰𝗼𝘃𝗲𝗿𝗲𝗱 𝘄𝗶𝗹𝗹 𝗶𝗻𝗰𝗹𝘂𝗱𝗲:
•	Vocabulary (cell, column, row, worksheet, formula, revenue, sum)
•	Organizing data
•	Auto-populating cells
•	Gridlines
•	Formatting cells (color, dates, time, currency)
•	Sum function

𝗧𝗿𝗼𝘂𝗯𝗹𝗲𝘀𝗵𝗼𝗼𝘁𝗶𝗻𝗴 𝗱𝘂𝗿𝗶𝗻𝗴 𝗰𝗹𝗮𝘀𝘀:
Occasionally, learners may need additional help in completing a task in Google Sheets. I am able to give students the ability to share their screen so that I can see exactly what they are looking at. Usually, this works very well, and I am able to talk them through the task. (This will not work if the learner is using Google Sheets on a separate device than their Outschool class.) If the learner is still not able to complete the task, I am able to explain how they can grant me remote access so that I can complete the task for them. This allows us to move and cover all material in the class. If the learner is not able to grant remote access, I will ask they skip the step we are troubleshooting, and we will move on. At the end of class, I will revisit the skipped step and further troubleshoot with the learner.


Google sheets icons created by Freepik - Flaticon
<a href="https://www.flaticon.com/free-icons/google-sheets" title="google sheets icons">