$65
for 4 classesTrading Card Tracking with Microsoft Excel
New class
Ages 10-14
Live Group Course
Live video meetings
1x per week, 4 weeks
3-7 learners per class
50 min
What's included
4 live meetings
3 hrs 20 mins in-class hoursHomework
1-2 hours per week. I will give short optional homework assignments after the first three classes and will provide feedback on all submitted work.Grading
Please let me know if you need specific grading.Class Experience
US Grade 4 - 7
Beginner - Intermediate Level
In this class, students will learn how to use Microsoft Excel, discovering its powerful capabilities by tracking their own trading cards. Students should have at least ten trading cards that they will log in an Excel spreadsheet, whether they're Pokemon, baseball, Magic, Yu-Gi-Oh or other cards. This class will not only teach the basics of Excel, but it will excite students to discover ways they can use Excel in their everyday lives. The course kicks off by introducing essential terminology and discussing the many uses of the program. From there, students will get hands-on experience creating their own spreadsheets, guided by a live demonstration on my screen. To fully engage, it's crucial that students have Microsoft Excel already installed on their computers, enabling them to follow along and experiment as I lead the way. Throughout the course, students are encouraged to participate. For a list of weekly topics, please see the "𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨" section. 𝗣𝗿𝗲𝗿𝗲𝗾𝘂𝗶𝘀𝗶𝘁𝗲𝘀 𝗮𝗻𝗱 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗡𝗲𝗲𝗱𝗲𝗱: --To ensure a seamless learning experience for all, please have your learner signed into Excel before the class begins. While no prior Excel experience is necessary, basic computer knowledge (using a mouse, keyboard, and launching programs) is recommended. --Learners should bring at least ten trading cards to class. They can be one type of card (example: all Pokemon cards) or a mix of cards (example: baseball and Yu-Gi-Oh cards). 𝗧𝗿𝗼𝘂𝗯𝗹𝗲𝘀𝗵𝗼𝗼𝘁𝗶𝗻𝗴 will be integrated into the class. In instances where learners face challenges, learners will be able to share their screens or grand me remote access. This approach guarantees that all topics are covered, even if certain steps need to be revisited at the end of the class to troubleshoot with individual learners.
Learning Goals
Learners will be able to define Excel vocabulary, such as cell, row, column, and SUM
Learners will be able to format cells for number type, font and color
Syllabus
4 Lessons
over 4 WeeksLesson 1:
Formatting and Filtering
After discussing terminology, we will begin to create our spreadsheet. Through this task, we'll explore data organization, cell formatting, and filtering techniques.
50 mins online live lesson
Lesson 2:
Sorting and Formulas
We will continue to use our spreadsheet from Week 1. In this phase, new topics will encompass currency formatting, data sorting, utilizing the SUM function, and creating math formulas.
50 mins online live lesson
Lesson 3:
Conditional Formatting and More Formulas
We will review all that we learned in the first two weeks, while learning more advanced functions, such as AVERAGE and conditional formatting.
50 mins online live lesson
Lesson 4:
Creating Graphs
We'll use our trading card spreadsheets to delve into graph creation, covering pie charts, bar graphs, and line graphs.
50 mins online live lesson
Other Details
Parental Guidance
Learners should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as I teach the class. We will not be using any external websites or apps.
Supply List
Learners should bring at least ten trading cards to class. They can be one type of card (example: all Pokemon cards) or a mix of cards (example: baseball and Yu-Gi-Oh cards). Learners should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as I teach the class. We will not be using any external websites or apps.
1 file available upon enrollment
External Resources
Learners will not need to use any apps or websites beyond the standard Outschool tools.
Meet the teacher
Teacher expertise and credentials
Bachelor's Degree from Bucknell University
I have taught over 1,300 learners on Outschool over the past three years. Prior to that, I enjoyed a thirteen-year corporate career, where I used Microsoft Excel 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
Colleen Smith suggests this class next...
Microsoft Excel Intermediate Level: Formulas & Functions, 3-Week Class
Colleen Smith
5.0
(333)
$17 per class
Group Class
3 wks, 1/wk, 50 min
12-16
Other classes by Colleen Smith
Other classes by Colleen Smith
Parents also liked
Art Class-Design Your Own Pokemon Trading Cards: Exclusive 1-On-1 For Your Child
Einsteins Square: Chess, Coding, Math, Art, Games
4.8
(5,741)
$35 per session
1-on-1 Lessons
On Demand
5-12
One on One Private Pokemon Tutoring
Joanna Ansari
4.7
(160)
$45 per session
1-on-1 Lessons
On Demand
7-12
Let’s Play Yugioh! Master Duel Gaming Club (Elementary)
Alexander Rivas
5.0
(3)
$15 per class
Next session at 12:30 AM on Wednesday
Group Class
1/wk, 1 hr
7-10
Let’s Play Yugioh! Master Duel Gaming Club (Middle)
Alexander Rivas
5.0
(3)
$15 per class
Next session at 11:30 PM on Thu 3/20
Group Class
1/wk, 1 hr
11-13
Vintage & New Pokemon Card Collecting Club: Show & Tell/ Pro Card Tips!
Sarah Schram M.Ed
4.9
(68)
$10 per class
Next session at 11:40 PM tomorrow
Group Class
1/wk, 20 min
9-14
Pokemon Card Fan Discussion Club
Teacher Amanda
4.9
(41)
$3 per month
Chat Group
Unlimited Access
8-13
Sports Card Investing Tips & Tricks
Lance Davis B.S. Criminal Justice
5.0
(102)
$40 per class
Next session at 9 PM on Thu 3/27
Group Class
1 wk, 1/wk, 45 min
14-18
Pokémon Card Creator! Let's Make Our Own Pokémon Cards! Draw, Learn & Chat!
Jenny
4.9
(563)
$9 per class
Next session at 7 PM on Monday
Group Class
1/wk, 30 min
7-11
Let's Talk About Baseball Cards
Mr. Hino
5.0
(2)
$20 per class
Next session at 7 PM on Mon 3/10
Group Class
1 wk, 1/wk, 45 min
10-14
Sports Card Collecting (Ages 9+)
Lance Davis B.S. Criminal Justice
5.0
(102)
$20 per class
Next session at 7 PM on Mon 3/24
Group Class
1 wk, 1/wk, 45 min
9-14
Make Your Own Pokemon Card Club
Gabbi - Art-In-Motion
4.8
(89)
$5 per class
Next session at 11 PM on Thursday
Group Class
1/wk, 20 min
7-10
The Pokémon Hour (Weekly Card Pack Opening!)
Coach Joe Teaches (Special Education/Admin)
4.9
(654)
$17 per class
Next session at 11 PM on Friday
Group Class
1/wk, 1 hr
6-11
One on One Private Pokemon Class! (Learn to Play the Card Game or Talk Pokemon)
Coach Joe Teaches (Special Education/Admin)
4.9
(654)
$30 per session
1-on-1 Coaching
On Demand
5-10
Art Class - Create Your Own Pokemon Trading Cards
Einsteins Square: Chess, Coding, Math, Art, Games
4.8
(5,741)
$18 per class
Next session at 6 PM on Tue 3/11
Group Class
1/wk, 50 min
5-9
9 - 12 Yrs; Magic the Gathering; Commander Club
Wes H
5.0
(17)
$20 per class
Next session at 12 AM on Tuesday
Group Class
1/wk, 1.50 hr
9-12
Pokemon Social Club - Discussions, Virtual Battle, Show & Tell!
ThriveMind Academy
4.9
(1,208)
$15 per class
Next session at 12 AM on Monday
Group Class
1/wk, 45 min
7-11
More to explore
Private Writing Tutor
Power Point
Sew 101
Architecture Career Discovery
Pastry
Animation 3d
Daily Skills Practice With Reading Spelling Vocabulary
Intro Photography
Brain Teasers
Comedy Writing
Magnificent Math
Intro To Flying
Chef
Literature Mythology
Cell
American Doll
Shakespeares Acting
Chess for Sparrows
Experiment
Addition Facts