Google Sheets for Beginners
This self-paced class will teach the basics of Google Sheets. Students will be given real-life scenarios in which they can use Google Sheets. They'll create and format a weekly schedule, a budget with formulas, and sort Olympics statistics.
Colleen Smith
Average rating:
5.0
Number of reviews:(330)
Star Educator
What's included
6 pre-recorded lessons
3 weeks
of teacher support1 year access
to the contentAssignments
2-4 hours per week. Students will watch six recordings and will work in Google Sheets during each recording. They can send me a link to their Google Sheet for review. Feedback will be given on all assignments within 48 hours, although I aim to make it even sooner.Grading
I provide feedback on all work that is turned in. Please let me know if you need specific grading.Class Experience
US Grade 4 - 7
Beginner - Intermediate Level
During this class, students will learn the basic functions of Google Sheets and get hands-on practice. More details can be found in the 𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨 and 𝙇𝙚𝙖𝙧𝙣𝙞𝙣𝙜 𝙂𝙤𝙖𝙡𝙨sections. 𝗛𝗼𝘄 𝗱𝗼𝗲𝘀 𝗮 𝘀𝗲𝗹𝗳-𝗽𝗮𝗰𝗲𝗱 𝗰𝗹𝗮𝘀𝘀 𝘄𝗼𝗿𝗸? This is a Self-Paced, so there are no live sessions. Students will have access to six pre-recorded lessons that I created exclusively for Outschool. During the recordings, I share my screen so students can watch me using Google Sheets as I describe its capabilities. Learners are encouraged to use Google Sheets as they watch the recording, so that they can follow along and gain hands-on practice. The recordings are about 9-15 minutes, but may take longer to complete, depending on if the student pauses or rewinds as they watch and complete their tasks in Google Sheets. Students can submit their work for feedback and reach out with questions. 𝗪𝗵𝗮𝘁 𝗱𝗼 𝘀𝘁𝘂𝗱𝗲𝗻𝘁𝘀 𝗻𝗲𝗲𝗱 𝗳𝗼𝗿 𝘁𝗵𝗶𝘀 𝗰𝗹𝗮𝘀𝘀? 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 or touch pad, be able to use a keyboard and open a program. They must have access to a free Google account in order to access Google Sheets. The account should be created prior to class, as this is not covered.
Learning Goals
Students will comprehend Google Sheets vocabulary (cell, column, row, worksheet, formula, budget, sum)Students will be able to implement formatting (color, font, number type for currency and time, gridlines)
Syllabus
6 Lessons
over 3 WeeksLesson 1:
Create a Schedule
I'll begin by discussing real-world uses for Google Sheets and related vocabulary. I'll then dive in and begin using the program. Learners will use Google Sheets while watching my recording to create their own weekly schedule. Topics covered will include auto-populating days and times and naming and sharing a Google Sheet. 15 mins of video lessons
Lesson 2:
Format Your Schedule
Learners will learn how to add gridlines and change fonts, sizes and colors. 11 mins of video lessons
Lesson 3:
Create a Budget
Learners will imagine they are going grocery shopping. We will use Google Sheets to create a budget. New topics covered will include formatting for currency and writing a multiplication formula. 16 mins of video lessons
Lesson 4:
More Formulas for Your Budget
Learners will learn the difference between Static and Cell Reference formulas and write addition, subtraction and division formulas and use the SUM function. 12 mins of video lessons
Other Details
Parental Guidance
Learners will use Google Sheets, which is an Outschool-approved third party tool, but does require a free Google account.
Supply List
In addition to the Outschool classroom, this class uses: Google Sheets Students should have a Google account setup prior to starting class, so they can use the program and follow along as they watch my recordings.
Language of Instruction
English
Joined September, 2021
5.0
330reviews
Star Educator
Teacher expertise and credentials
Bachelor's Degree from Bucknell University
I have virtually tutored over 1,300 young learners on Outschool, but prior to that I enjoyed a thirteen-year corporate career, where I used spreadsheets to make my work more efficient and effective on a daily basis. I hold a Bachelor's of Science in Business Administration from Bucknell University. Reviews
Self-Paced Course
$7
weekly or $20 for all content6 pre-recorded lessons
3 weeks of teacher support
Choose your start date
1 year of access to the content
Completed by 1 learner
Choose your start date
Ages: 10-13
Financial Assistance
Get The App
Tutoring
More to Explore
Dungeons And Dragons 059 Learn How To Be The Dungeon Master TrainingWhat Do You Believe A World ReligionConversational MandarinPods Complete 12-14Craft EssaySafeProof Reading GeometryThinking GamesAround The World WithAloneGeneral PsychologyFrench Intermediate LevelFairytale DanceTutor Math PrecalculusDrawing Fruits