$79
for 5 classes
Class

Shoe Factory Spreadsheet Murder Mystery - Learn Excel While Solving a Mystery!

Completed by 2 learners
Ages 10-15
Live Group Class
In this 5 week class, we will learn about Excel, formulas, and spreadsheets to find clues and solve a whodunit mystery!
Average rating:
4.8
Number of reviews:
(1,188 reviews)

Live video meetings
1x per week, 5 weeks
1-6 learners per class
60 min

What’s included

5 live meetings
5 in-class hours

Class Experience

Welcome to Shoe Factory Spreadsheet Murder Mystery - Learn Excel While Solving a Mystery! This is a 5 week class where we solve puzzles to figure out who did it, with new data and suspects every week. In this class we will learn all about Microsoft Excel while solving puzzles, sorting through data, and eliminating suspects. Each module includes slides and an Excel sheet of data to sort through. Clues are provided as we work together in class to solve the puzzles. Each week we are going to work on a new puzzle that involves new formulas in Excel and new features to sort through complicated data. From going through list of suspects, narrowing down who could've done it, and learning many new options in Excel, this course will teach learners how to use Excel, work with formulas to sort data, and have fun solving puzzles. 

The course will focus on fun and interesting examples to help students understand concepts that can be applied elsewhere. Students will have the answers and how to find them by the end of each class.

Module 1: Introduction to the case and the data we will be using. This module covers the functions SUM, AVERAGE, MIN, and MAX. We will use these tools to sort through simulated demographic data of suspects, and solve five clues to narrow down the list of suspects. 

Module 2: Another victim! The mystery deepens as the police have a new (and connected?) case. In this module we will cover the Excel functions COUNT, PRODUCT, QUOTIENT, and TEXT. By filtering and sorting through clues, we will narrow down the suspects on the second data set.

Module 3: Did we make a mistake? We may need to go back to the drawing board with a new list of suspects. Police found a number of new clues that may show us which direction to go in. In this module we will work on logical functions in Excel including IF, COUNTIF, SUMIF and the TEXT function. By working through a new data set with these tools we should be able to narrow down the suspect list. 

Module 4: Is there an accomplice that we don't know about? In this module we will use more advanced functions to sort through our data and solve clues using IF, nested IF, COUNTBLANK, and TEXT.

Module 5: We finally caught everyone involved, but it seems that there was a mastermind working behind the scenes. In this module we are going to work through all of our tools and use SUM, PRODUCT, COUNT, IF, nested IF, and TEXT to find the mastermind!

Learning Goals

Students will learn how to use Microsoft Excel formulas while playing a fun and challenging mystery game.

Other Details

Parental Guidance
A recent version of Excel is required for this class, all formulas should work with Excel 2016 onwards. Shared files are shared with Sync, no login is required. You will need a computer with Microsoft Excel on PC or Mac. A keyboard and mouse are strongly recommended. It may be possible to complete the course using Google Sheets, but some features may not work properly.
Supply List
You will need a computer with Microsoft Excel on PC or Mac. Any version of Excel from 2016 onwards that can use .xlsx files should work. A keyboard and mouse are strongly recommended. It may be possible to complete the course using Google Sheets, but some features may not work properly.
Language of Instruction
English
External Resources
In addition to the Outschool classroom, this class uses:
Sources
Spreadsheets and slides are provided each week in addition to solutions.

Offered by

Joined October, 2020
4.8
1188reviews
Profile
Teacher expertise and credentials
I love teaching programming and data analysis using fun and interesting examples because it helps students go farther than learning hard to contextualize concepts. Understanding what we are doing and why means that students will be able to apply algebraic concepts (like x+y) having understood examples like (red bike + blue bike) in a way that has context and meaning. I have taught Excel to hundreds of college students and learners of all ages. In data analysis, Excel is often the first step to exploring data and figuring things out.

Reviews


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
(63)
$19 per class
Next session at 3 PM on Mon 7/7
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
(63)
$18 per class
Next session at 2 PM on Mon 7/7
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
(63)
$19 per class
Next session at 3 PM on Mon 7/7
Group Class
1 wk, 4/wk, 50 min
10-13
Computer Skills Summer Camp: Mastering Google Docs, Slides, and Sheets
Thrive Virtual Academy by Patch Kulp
4.9
(664)
$20 per class
Next session at 3 PM on Mon 6/16
Group Class
4 wks, 1/wk, 45 min
11-16
Cruising for Skills on MS Excel - Pt 1 for Middle School - Camp
Ms. Ryan, M.S.
5.0
(63)
$19 per class
Next session at 3 PM on Mon 7/7
Group Class
1 wk, 4/wk, 50 min
10-13
Cruising for Skills on MS Word - High School and College Prep - Camp
Ms. Ryan, M.S.
5.0
(63)
$19 per class
Next session at 2 PM on Mon 7/7
Group Class
1 wk, 5/wk, 50 min
14-18
Digital Basics for Beginners (in Spanish): Step-by-Step Technology Skills
Teacher Yazmin
$12 per class
Next session at 7:30 PM on Thu 6/12
Group Class
6 wks, 1/wk, 45 min
11-14
Computer Skills Summer Camp: Microsoft Word, Powerpoint and Excel Part 1
Thrive Virtual Academy by Patch Kulp
4.9
(664)
$20 per class
Next session at 3 PM on Mon 6/16
Group Class
6 wks, 1/wk, 45 min
12-16
AI Software Weekly Club
Daniel Solomon Kaplan
4.9
(400)
$12 per class
Next session at 5 PM on Friday
Group Class
1/wk, 55 min
10-14
Microsoft Excel (Beginning and Intermediate): 1-On-1, 55-Minute Custom Lessons
Athena McGhan
5.0
(4)
$60 per session
1-on-1 Lessons
On Demand
14-18
Introduction to Microsoft PowerPoint
Brandon
4.9
(37)
$10 per class
Next session at 2 PM on Friday
Group Class
1 wk, 1/wk, 55 min
13-18
Adobe Blast-Off: Private Lesson!
Bethanie Jones
4.8
(623)
$86 per session
1-on-1 Lessons
On Demand
10-15
Introduction to Microsoft Excel
Brandon
4.9
(37)
$10 per class
Next session at 4:30 PM on Thursday
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
Fun With Words & Pictures Summer Camp: Make a Colorful Story Book in MS Word!
Ghada
$40 per session
Next session at 7 PM on Tue 6/10
1-on-1 Lessons
On Demand
7-10
See More Classes
Home
Search
Give a Gift Card
Open currency, time zone, and language settings
Language & Region
Log In