First Month Free — use code BTS40. Offer valid for 80 credits plan.Learn More
This class is no longer available, but we found something similar!
34
Spreadsheet Skills (Level 1): From Basics to Building Formulas
Completed by 41 learners
Ages 8-13
Live One-Time Class
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 hoursClass 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
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
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?
Financial Assistance
Homeschool Resources
Tutoring
More to Explore
Classes by Age
Classes by Grade
Get The App
