Intermediate Excel - (Project-Based Learning Class)

Take Excel skills to the next level. With this project-based learning approach, students will learn Excel while developing critical thinking, problem-solving, creativity, and time management skills.

Class Experience

US Grade 9 - 12

Intermediate Level

This class is an intermediate Excel class. Topics covered include:
Week 1: The Countdown Project
•	Shade cells
•	Change font style and color
•	Adding a border around a cell range
•	Today formula
•	Subtraction formula

Week 2: The Dunder Mifflin Project
•	Data List (Drop Down)
•	Conditional Formatting
•	Create an Error Message
•	Freeze Rows
•	Concat Formula
•	Multiplication Formula
•	Year(Today) Formula
•	Subtraction Formula

Week 3: The Dice Project
•	If formula
•	Or formula
•	Randbetween...

This class is taught in English.

Students will work on the following Excel Skills:
•	Today formula
•	Subtraction formula
•	Freeze Rows
•	Concat Formula
•	Multiplication Formula
•	Year(Today) Formula
•	Subtraction Formula
•	Or formula
•	Randbetween formula
•      Vlookup Formula
•	Offset Formula
•	Macro Button
•	Data List (Drop Down)
•	Conditional Formatting
•	Format cells
•	Borders
•	Create an Error Message
•	Define Cell Range
•	Label Worksheets

Students will also practice critical-thinking, problem-solving, creativity, and time management skills

I have been a college professor for over 20 years, teaching more than 130 computer classes and over 3,000 students. 

My teaching experience gave me the knowledge and foresight to create a project-based learning approach for my own children while I homeschooled them for 15 years. My homeschool curriculum focused on research, critical thinking, problem-solving, and creativity over school subjects. 

Currently, I continue to work as a college professor while also assisting homeschool families. My specialization is in project-based learning, teaching essential skills through math, and providing guidance to families with profoundly gifted students. I hold a Bachelor's and Master's degree in Computer Information Systems.

Homework Offered
Every week, students will be assigned an Excel project to work on. They will have access to tutorial videos to teach them the necessary skills to complete the project. However, the videos will not provide a step-by-step guide for the project. On average, the projects will take about 1-3 hours per week to complete. If students have any questions, they can always email me, and I will happily answer them or direct them to a helpful resource.1 - 2 hours per week outside of class
Assessments Offered
Each project is an opportunity for students to showcase their skills and creativity. They will have one week to work on each project, and once it's done, email it to me for review. My feedback will be detailed and constructive, highlighting areas where they excelled and offering suggestions for improvement. 

If a parent requests, I will grade each project on a 50-point scale and provide a letter grade at the end of the four weeks. 
Grades Offered

Student will need Microsoft Excel. The tutorial videos will be for Windows 2019 Excel version.

In addition to the Outschool classroom, this class uses:Google Classroom
Youtube

To access and upload class projects, students will use Google Classroom. Students will also utilize YouTube to access my tutorial videos.

To access and upload class projects, students will use Google Classroom. Students will also utilize YouTube to access my tutorial videos.

Available times

Pacific

Table of available sections

Meet the teacher

Mindy Carson

Hi, I'm Mindy, and my expertise is in providing student-centered learning classes for homeschool students. My classes are designed to engage students by utilizing project-based learning, which encourages students to participate in research,...