First Month Free — use code BTS40. Offer valid for 80 credits plan.Learn More
34
credits per class
Class
Play

Spreadsheet Skills (Level 1): From Basics to Building Formulas

Completed by 41 learners
Ages 8-13
Live One-Time Class
In this class, students will go from learning basics to building formulas that can be used in both Google Sheets & Excel while helping Mark the Shark with his bookkeeping. This is level 1 in a series of 3, one-time classes.
Average rating:
4.9
Number of reviews:
(531 reviews)
Popular
Rising Star

Live video meetings
Meets once
1-8 learners per class
55 min

What’s included

1 live meeting
55 mins in-class hours

Class Experience

Students will help Mark the Shark open his dream underwater shop while learning spreadsheet basics. 

Is your learner an Excel or Google Sheets newbie? Do they thrive in a fun and interactive environment? Are they someone who learns best by getting their hands dirty? If so, I’ve got the most interactive course currently available on using spreadsheet programs!

In this course, we will use Google Sheets, which has functions that allow me to directly collaborate with students as we work through a series of confidence-building exercises. Although my approach is all about fun and creativity, I’m also keen to waste no time in developing essential skills that will give your learner a step up for high school, post-secondary and future workplace excellence. I’ve not only designed my course to ensure that no student gets left behind but that they are inspired and hungry to learn more about this powerful tool.

Class Focus: Basics, building formulas, cell referencing, graphs, tables, functions (see "learning goals" for more detail.)

Learning Goals

Students will build increasingly complex formulas in order to solve real-world problems such as finance tracking and help the gnomes run their mining company. In addition to basic terminology, students will learn how to reference cells, use operators, write their first function, and automatically populate their formulas. 

Through these exercises, learners will gain a fundamental understanding of how to correctly set up their spreadsheets, tables, and formulas in order to achieve the best results possible in their work. Although this course utilizes Google Sheets for interactive abilities, I’ve made sure that all concepts are directly translatable for use with Excel or Numbers.

Topics Covered: Basics of navigation and terminology, using cells to calculate math problems, cell referencing, building formulas using different operators, auto-populating formulas, creating a graph, best practices for creating tables including alternating colors and formatting numbers, and an introduction to the SUM function.

Other Details

Supply List
Although this course is structured to work with a single monitor, a second monitor or tablet (hosting our zoom session,) would be of great benefit to students. A mouse is also highly recommended.
External Resources
In addition to the Outschool classroom, this class uses:

    Meet the teacher

    Joined February, 2021
    4.9
    531reviews
    Popular
    Rising Star
    Profile
    Teacher expertise and credentials
    I have been an energy analyst for the past 6-years using Excel and Google Sheets on a daily basis. I am particularly proficient at coding in Excel and my colleagues call me the Excel Wizard. In addition to my professional experience, I have developed and delivered workshops teaching basic spreadsheet skills over a remote platform for youth ages 13 to 17. In the majority of cases, my students had no prior experience with spreadsheet software. 

    Reviews

    5 total ratings, 3 with reviews

    Was so impressive getting squared away with the coding in advance of the... 
    Joleen O.on Jan 17
    My son loves his private coding lessons and looks forward to it every... 
    An Outschool parenton Nov 18, 2020
    Lauren is fantastic.  She is patient and encouraging.  She seems to know... 
    Hopi H.on Nov 12, 2020



    Parents also liked
    Programming on Minecraft: One-on-One Coding Sessions
    Sprout Academia
    4.9
    (256)
    $65 per session
    1-on-1 Lessons
    On Demand
    6-15
    Scratch Coding
    Mehrab Ahmad
    5.0
    (3)
    $20 per class
    Next session at 9 PM tomorrow
    Group Class
    1/wk, 55 min
    7-12
    All About Python Coding for Teenagers | Python Coding Class for Beginners
    David Sofield
    4.9
    (881)
    $10 per week
    Self-Paced Class
    8 weeks
    12-18
    Scratch Programming: One-On-One Coding Sessions
    Sprout Academia
    4.9
    (256)
    $65 per session
    1-on-1 Lessons
    On Demand
    6-13
    Python Programming for Beginners: One-on-One Coding on Minecraft
    Sprout Academia
    4.9
    (256)
    $70 per session
    1-on-1 Lessons
    On Demand
    7-17
    Make Coding Fun: Learn To Do Block-Based Coding Projects
    Coach Joe Teaches (Special Education/Admin)
    4.9
    (679)
    $10 per week
    Self-Paced Class
    4 weeks
    7-14
    Beginner Coding Class With Minecraft: Level 1 - The Basics of Programming
    Playful Digital Learning
    4.8
    (611)
    $36 per class
    Next session at 8 PM on Monday
    Group Class
    1 wk, 5/wk, 1.50 hr
    8-13
    Make Coding Fun: Three Block-Based Coding Projects (Autism, ADHD, Neurodiverse)
    Coach Joe Teaches (Special Education/Admin)
    4.9
    (679)
    $10 per week
    Self-Paced Class
    4 weeks
    7-13
    Scratch Video Game Coding: Fun Programming
    Michelle Lewis Scratch Coding STEM Educator
    5.0
    (22)
    $49 per session
    1-on-1 Lessons
    On Demand
    7-17
    [One on One] Private Tutoring JAVA Coding - Introduction to Programming in JAVA
    Ziad Ghazi
    4.6
    (10)
    $59 per session
    1-on-1 Lessons
    On Demand
    7-18
    Java Programming
    Charles, a Two-Time MIT Graduate
    4.0
    (1)
    $300 per session
    1-on-1 Lessons
    On Demand
    10-18
    Beginner Coding Camp With Minecraft: Level 3 - The Basics of Programming
    Playful Digital Learning
    4.8
    (611)
    $36 per class
    Next session at 11 PM on Monday
    Group Class
    1 wk, 5/wk, 1.50 hr
    8-13
    Python Programming Essentials for Kids: Hands-On Project-Based Beginner Coding!
    Faruk Hasan
    4.8
    (157)
    $6 per week
    Self-Paced Class
    10 weeks
    9-15
    Coding With My Agent - Block Coding
    Ms. Mareeka
    4.8
    (139)
    $14 per class
    Next session at 12 AM on Thursday
    Group Class
    24 wks, 1/wk, 1 hr
    9-13
    Scratch Coding 1-On-1: Personalized Projects & Programming for Kids
    Bloom
    4.8
    (155)
    $40 per session
    1-on-1 Lessons
    On Demand
    6-13
    Scratch Coding for Kids (on-Going)
    Paul Yiu
    4.8
    (400)
    $18 per class
    Next session at 3:30 PM on Sat 10/4
    Group Class
    1/wk, 55 min
    7-12
    See More Classes
    Are you planning to use state funding, such as an Education Savings Account (ESA), Micro-grant or scholarship to help pay for your learner’s education?
    Back