Outschool
Open currency, time zone, and language settings
Log In

Trading Card Tracking with Microsoft Excel

This four-week, hands-on class will teach the basics of Excel, while logging students' trading cards, whether they're Pokemon, Baseball, or other cards! Learners will create spreadsheets, organize data and create formulas and graphs.
Colleen Smith
Average rating:
5.0
Number of reviews:
(330)
Star Educator
Class

What's included

4 live meetings
3 hrs 20 mins in-class hours
Homework
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
learning goal

Syllabus

4 Lessons
over 4 Weeks
Lesson 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.
Joined September, 2021
5.0
330reviews
Star Educator
Profile
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

Live Group Course
Share

$65

for 4 classes
1x per week, 4 weeks
50 min

Live video meetings
Ages: 10-14
3-7 learners per class

About
Support
SafetyPrivacyCA PrivacyLearner PrivacyManage Data PreferencesTerms
Financial Assistance
Get The App
Download on the App StoreGet it on Google Play
© 2024 Outschool