$10
weeklyor $40 for all content
Financial Spreadsheets
Completed by 9 learners
Ages 12-18
Self-Paced Course
8 pre-recorded lessons
4 weeks of teacher support
Choose your start date
1 year of access to the content
Enroll Now, Start Anytime
Go at your own pace
Your learner can start learning when they want and progress at the speed that works best for them.Start when you want.
Learn at your own pace
Access course material for a full year.
Get hands-on support from teacher.
What's included
8 pre-recorded lessons
4 weeks
of teacher support1 year access
to the contentHomework
1-2 hours per week. Students will create three financial spredsheets. There will also be four note pages to review and four optional homework documents. The optional homework will be provided via a Google Document. Students can print it out, fill it out and send back a picture OR students can type their answers right into the document and send it back to me via the classroom or message. I will provide feedback on all homework.Grading
Please let me know if you need specific grading for this course.Class Experience
US Grade 8 - 12
Beginner - Intermediate Level
In this eight-lesson, hands-on course, learners will use Google Sheets to learn about business balance sheets, income statements, and cash flows. They'll be introduced to basic accounting terms and formulas using templates. More details can be found in the 𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨 section. 𝗛𝗼𝘄 𝗱𝗼𝗲𝘀 𝘁𝗵𝗶𝘀 𝘀𝗲𝗹𝗳-𝗽𝗮𝗰𝗲𝗱 𝗰𝗹𝗮𝘀𝘀 𝘄𝗼𝗿𝗸? This is a self-paced class, so there are no live sessions, but learners have access to the materials below through eight lessons. I estimate that this will take about 1-1.5 hours (2 lessons) per week over 4 weeks, but can be completed sooner if desired. 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝗻𝗰𝗹𝘂𝗱𝗲𝗱? 𝟭) 𝗘𝗶𝗴𝗵𝘁 𝗿𝗲𝗰𝗼𝗿𝗱𝗶𝗻𝗴𝘀—During the recordings, I share slides to discuss key concepts about each financial statement focus. Five recordings are 18-25 minutes long and three are 6-15 minutes long. 𝟮) 𝗙𝗼𝘂𝗿 𝗚𝗼𝗼𝗴𝗹𝗲 𝗦𝗵𝗲𝗲𝘁𝘀 𝗙𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗦𝘁𝗮𝘁𝗲𝗺𝗲𝗻𝘁 𝗔𝘀𝘀𝗶𝗴𝗻𝗺𝗲𝗻𝘁𝘀--During recordings, we will use what the student has learned to fill out financial spreadsheet templates. I will share my screen so that students can see what I am doing in Google Sheets. Students should use Google Sheets on their laptop or computer in-order to follow along and get hands on experience during class. After the recording, the learner will be able to share their completed Google Sheets spreadsheet with me and receive feedback via messaging. 𝟯) 𝗙𝗼𝘂𝗿 𝘀𝘂𝗺𝗺𝗮𝗿𝘆 𝗻𝗼𝘁𝗲𝘀 𝗽𝗮𝗴𝗲𝘀--The notes pages will provide a quick summary of key vocabulary and concepts that I discussed during the recording. 𝟰) 𝗙𝗼𝘂𝗿 𝗿𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗲𝗱 𝗵𝗼𝗺𝗲𝘄𝗼𝗿𝗸 𝗱𝗼𝗰𝘂𝗺𝗲𝗻𝘁𝘀--In addition to the Google Sheets assignments, the optional homework is provided via a Google Document. I will provide feedback on all homework. 𝟱) 𝗙𝗲𝗲𝗱𝗯𝗮𝗰𝗸 from me on all submitted work and any questions. I will respond in 0-48 hours, but usually in less than 24. If you need longer than the four weeks to submit assignments, please let me know and I am happy to extend your access. In order to benefit from this course, students do not need to have used Google Sheets before, but should be able to use their mouse and keyboard.
Learning Goals
Students will be able to define assets, liabilities, income, expenses and profit.
Students will be able to discuss the importance of balance sheets, income statements and cash flows.
Syllabus
8 Lessons
over 4 WeeksLesson 1:
Balance Sheet Recording
𝗪𝗮𝘁𝗰𝗵 (23 minutes)--An introduction to assets, liabilities, equity and balance sheets. Includes one-page summary of notes.
Lesson 2:
Balance Sheet in Google Sheets
𝗪𝗮𝘁𝗰𝗵 (25 minutes)--A recording demonstrating how to fill in a balance sheet template in Google Sheets
1 assignment
Lesson 3:
Income Statement Recording
𝗪𝗮𝘁𝗰𝗵 (14.5 minutes)--An introduction to income statements. Includes one-page summary of notes.
Lesson 4:
Income Statement in Google Sheets
𝗪𝗮𝘁𝗰𝗵 (20.5 minutes)---A recording demonstrating how to fill in an income statement template in Google Sheets
1 assignment
Other Details
Supply List
Students will use Google Sheets and Google Docs. Please make sure the student has access to a free Google account in order to use Google Sheets and Google Docs.
Language of Instruction
English
External Resources
In addition to the Outschool classroom, this class uses:
Meet the teacher
Teacher expertise and credentials
Bachelor's Degree from Bucknell University
I have virtually taught over 1,300 young learners on Outschool over the past three years, but prior to that I enjoyed a thirteen-year corporate career, where I often examined balance sheets, budgets and income statements. I hold a Bachelor's of Science in Business Administration from Bucknell University.
Reviews
Colleen Smith suggests this class next...
Microsoft Excel Intermediate Level--Formulas & Functions
Colleen Smith
5.0
(333)
$10 per week
Self-Paced Class
4 weeks
12-18
Other classes by Colleen Smith
Other classes by Colleen Smith
Parents also liked
1:1 Microsoft Office (for beginners)
Ms. Katrena
$55 per session
1-on-1 Coaching
On Demand
11-14
Cruising for Skills on MS PowerPoint - Middle School - Camp
Ms. Ryan, M.S.
5.0
(62)
$19 per class
Next session at 3 PM on Mon 3/10
Group Class
1 wk, 4/wk, 50 min
10-13
Cruising for Skills on MS Excel - Pt 1 for Middle School - Camp
Ms. Ryan, M.S.
5.0
(62)
$19 per class
Next session at 3 PM on Mon 3/10
Group Class
1 wk, 4/wk, 50 min
10-13
Cruising for Skills on MS Excel - HS and College Prep - Camp
Ms. Ryan, M.S.
5.0
(62)
$18 per class
Next session at 2 PM on Mon 3/10
Group Class
1 wk, 5/wk, 50 min
14-18
Cruising for Skills on MS Word - Pt 1 - Camp for Middle School
Ms. Ryan, M.S.
5.0
(62)
$19 per class
Next session at 3 PM on Mon 3/10
Group Class
1 wk, 4/wk, 50 min
10-13
Computer Skills Elective: Microsoft Word, Powerpoint and Excel Part 1
Thrive Virtual Academy by Patch Kulp
4.9
(639)
$20 per class
Next session at 9 PM on Thursday
Group Class
6 wks, 1/wk, 45 min
12-16
Cruising for Skills on MS Word - High School and College Prep - Camp
Ms. Ryan, M.S.
5.0
(62)
$19 per class
Next session at 2 PM on Mon 3/10
Group Class
1 wk, 5/wk, 50 min
14-18
Computer Skills Elective: Microsoft Word, Powerpoint and Excel Level 2
Thrive Virtual Academy by Patch Kulp
4.9
(639)
$20 per class
Next session at 8 PM on Thu 4/3
Group Class
4 wks, 1/wk, 45 min
12-16
AI Software: A Kid's Guide
Daniel Solomon Kaplan
4.9
(394)
$9 per class
Group Class
4 wks, 1/wk, 30 min
8-12
Introduction to Microsoft PowerPoint
Brandon
4.9
(30)
$10 per class
Next session at 1:30 AM on Thursday
Group Class
1 wk, 1/wk, 55 min
13-18
Adobe Blast-Off: Private Lesson!
Bethanie Jones
4.8
(622)
$86 per session
1-on-1 Lessons
On Demand
10-15
Introduction to Microsoft Excel
Brandon
4.9
(30)
$10 per class
Next session at 2 PM tomorrow
Group Class
1 wk, 1/wk, 55 min
12-17
1-on-1 Microsoft PowerPoint Learning Session
Motivational Mario
5.0
(1)
$50 per session
1-on-1 Lessons
On Demand
13-18
Google Sheets for Beginners
Dan Hartman
4.9
(574)
$15 per class
Next session at 5 PM on Saturday
Group Class
1 wk, 1/wk, 30 min
9-14
Mastering Canva for School Projects: 1:1 Instruction for High Schoolers
Dr. Bridget Prichard
$25 per session
1-on-1 Lessons
On Demand
15-18
Introduction to Microsoft Word
Brandon
4.9
(30)
$10 per class
Next session at 2 PM on Monday
Group Class
1 wk, 1/wk, 55 min
12-16
More to explore
French 2
Group Reading
Teen Nature Journaling
Halloween Special
Adding Mixed Numbers With Common Denominators No Regrouping
History Ww2
Believe Achieve Read
A Key To Being A Social Magnet
Business 101 How To Start A Successful Business From Hobbies
Puberty 9-14
Ssat Analogies
Multiplication Drill
Millionaire Mindset
Fashion Designing
Spy Decoder
Smash Ultimate
Montessori Stamp Game
Survive The Wilds
Social
Traditional Animation