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.
What's included
4 live meetings
1 hrs 40 mins in-class hoursHomework
1-2 hours per week. 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.Assessment
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.Grading
includedClass 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 formula • Macro button • Borders Week 4: The Caesar Cipher Project • Vlookup Formula • Offset Formula • Define Cell Range • Cell Formatting • Label Worksheets How is this class Taught? This is a project-based learning class. On the first day of class: • Provide all 4 projects we will work on in class • Show the class where to find all the tutorial videos needed for class Each week we will meet online for about 20 minutes. During our meeting, I will: • Show and explain the week’s project • Review the written project requirements • Show where to find all the resource tutorial videos • Explain anything that might challenge students on the project • Answer all student’s questions Students will be given a week to complete the project and are welcome to email me if they have any questions. The completed project must be submitted to me at least one day before our next meeting. After reviewing the project, I will provide constructive feedback to encourage the students. Why I do not show how to do the projects step-by-step? Empowering students with the confidence to tackle any Excel-related problem is crucial. By presenting them with Excel tasks, students can develop their Excel skills and confidence and other important skills such as research, critical thinking, and problem-solving, which are helpful in both academic and real-life settings. Simply memorizing information is not an effective way to learn Excel or most other subjects. Instead, students should focus on learning how to locate and process information in order to create practical solutions. Why do I have students add something extra to each project? More than 1 billion people worldwide use a Microsoft Office product. Although many can discover online solutions for MS Office, creativity is what sets individuals apart. In today's world, being able to think beyond the conventional and develop innovative solutions is what separates one from the crowd. Are there prerequisites? This is an intermediate Excel class. Before starting class, students should know how to add data to a worksheet, do simple formulas (add, subtract, multiply), for format cells.
Learning Goals
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
Other Details
Parental Guidance
To access and upload class projects, students will use Google Classroom. Students will also utilize YouTube to access my tutorial videos.
Supply List
Student will need Microsoft Excel. The tutorial videos will be for Windows 2019 Excel version.
Language of Instruction
English
External Resources
In addition to the Outschool classroom, this class uses:
Sources
To access and upload class projects, students will use Google Classroom. Students will also utilize YouTube to access my tutorial videos.
Joined November, 2023
Teacher expertise and credentials
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.
Reviews
Live Group Class
$40
for 4 classes1x per week, 4 weeks
25 min
Completed by 1 learner
Live video meetings
Ages: 13-18
1-18 learners per class
