Top 4 Places to Find Excel Lesson Plans for Middle School Blog Feature
Sarah Layton

By: Sarah Layton on August 22nd, 2019

Print/Save as PDF

Top 4 Places to Find Excel Lesson Plans for Middle School

Computer Applications | Microsoft Excel | Microsoft Office

Finding appropriate Microsoft Excel lesson plans for middle school students isn’t easy.

You need lessons that are made for the right age group, engaging, and meet your course standards — not to mention help you prep students for the MOS Excel certification!

While you could create your own lessons from scratch, that takes a lot of time (especially if you aren’t a spreadsheet whiz) and there’s always the risk the lesson falling flat in the classroom.

However, you can also pick up Excel lesson plans from the Internet to find the ones that work for you. 

On this page, you’ll find a list of the four best places to get Microsoft Excel lesson plans for middle school computer classes:

  1. Excel 2016 Tutorial from GCFLearnFree.org
  2. Microsoft Excel Spreadsheets Lesson Plan Bundle from Computer Creations
  3. Lessons & Activities Bundle for Microsoft Excel from TechCheck Lessons
  4. Microsoft Excel Curriculum from Business&ITCenter21

In this blog, you’ll learn about each resource to help you decide which one(s) will work best for you and your students!

1. Excel 2016 Tutorial from GCFLearnFree.org

gcflearnfree

GCFLearnFree.org is an education organization that helps students learn a variety of skills with more than 7,000 free lessons.

One of the most popular portions of the website is the Technology section, which has lessons to teach concepts and hands-on skills for computer applications.

As part of this section, you’ll find an Excel 2016 Tutorial dedicated to teaching students how to create Excel spreadsheets and manage data within them.

The Excel 2016 Tutorial includes 33 lessons organized into six units:

  1. Excel 2016 Basics
  2. Working with Cells and Sheets
  3. Formulas and Functions
  4. Working with Data
  5. Doing More with Excel
  6. Extras

Each tutorial lesson has the same layout, which provides an easy-to-follow and consistent learning experience for students.

Your students will see:

  • Lesson introductions
  • Overview videos
  • Step-by-step instructions
  • Screenshots depicting each step
  • Hints and tips for deeper learning

In addition, you’ll find a quiz at the end of the tutorial for students to measure how much they’ve learned about Excel.

Students can use this tutorial to learn and practice Excel at their own pace in class or at home.

On the flip side, the fact that the lessons are fully self-paced can make it tough for you to keep track of who is learning what (or if students are learning at all).

If you’re interested in a teaching option that lets students have free reign, the Excel 2016 Tutorial will be perfect for your situation.

If you want something geared toward a classroom, check out the next option!

2. Microsoft Excel Spreadsheets Lesson Plan Bundle from Computer Creations

computer-creations

Computer Creations is a well-known publisher on Teachers Pay Teachers (TpT), an online marketplace where educators share, sell, and buy resources.

Computer Creations has more than 340 products available to help teach technology topics, including a robust Microsoft Excel Spreadsheets Lesson Plan Bundle.

The bundle consists of more than 100 pages-worth of curriculum resources to help you teach your middle school students to use Excel!computer-creations-excel-spreadsheets-bundle

You’ll find resources such as:

  • Detailed lesson plans
  • Step-by-step instructions
  • Teacher PowerPoint presentations
  • Student worksheets
  • Spreadsheet exercises
  • “I Can” statements for student self-checks
  • Task cards for skills practice
  • Question cards to test student knowledge

These lessons and resources can help you fill two months-worth of classes while teaching students a variety of basic and advanced skills with Excel!

Overall, this Excel lesson plan bundle is an excellent option for a teacher who needs classroom-oriented resources to teach Excel.

The only potential downside of this bundle is the cost ($52.50), which is a bit pricey considering it will only help you teach one Microsoft Office application.

If you’re looking for something in a lower price range, the next option could be right up your alley.

3. Lessons & Activities Bundle for Microsoft Excel from TechCheck Lessons

techcheck-lessons

TechCheck Lessons is another publisher on TpT heavily focused on helping educators teach technology classes.

One of the most popular products from TechCheck Lessons is bundle of lessons and activities for Microsoft Excel.

This bundle costs $31.44, and it has more than 100 pages of content to help teach students how to work with Microsoft Excel spreadsheets.

The lessons include topics such as:techcheck-lessons-excel-bundle

  • Microsoft Excel vocabulary
  • Basic functions and formulas
  • Formatting cells
  • Working with tables
  • Inserting hyperlinks and images
  • Conditional formatting
  • And more!

Each lesson includes a teacher-led presentation, step-by-step activities, and sample answers to review student work.

Along with the lessons, you receive an MOS Excel 2016 Certification Exam Review resource that will help connect the dots between the lessons and the certification exam!

The only thing to keep in mind is that there are no specific forms of assessment to truly measure if your students are learning.

If you’re like most computer applications teachers, you need a resource that helps you teach and assess -- which is where the final option comes into play!

4. Microsoft Excel Curriculum from Business&ITCenter21

businessitcenter21-microsoft-excel-curriclum

Business&ITCenter21 is a digital curriculum system with hundreds of hours of lessons, activities, and assessments to teach computer applications in middle school.

Specifically, Business&ITCenter21 has four modules dedicated to teaching Microsoft Excel:

  1. Excel 1: Essentials
  2. Excel 2: Fundamentals
  3. Excel Skills Project
  4. Excel Business Project

The Excel 1: Essentials module introduces students to the essentials of Excel, such as rows, columns, and cells. In addition, students learn to enter data, use formulas and functions, and format data.

The module includes 10 hands-on lessons, one project, two quizzes, and one module test.

In total, the Excel 1: Essentials module contains 7.5 curriculum hours of content. That means your students will get an in-depth overview and a lot of practice getting to know Excel.

The Excel 2: Fundamentals module provides more detailed information on Excel, including cell references, formulas, functions, sorting, filtering, and spreadsheet formatting.

The module includes seven lessons, one project, three quizzes, and one module test.

In total, the Excel Fundamentals module has 13 curriculum hours of content to help your students become proficient with more advanced features in Excel.

Between these two modules, you get more than enough mileage to teach any middle school student to use Excel!

For students who already know their way around the application, the Excel Skills Project and Excel Business Project modules are great ways to promote deeper learning.

Overall, Business&ITCenter21 is the only resource on our list that includes a full Microsoft Excel curriculum of teacher resources, student learning materials, and full-fledged assessments.

The best part about Business&ITCenter21 is that you’ll find more than just Microsoft Excel lessons.

There’s a full Microsoft Office curriculum, plus modules to teach important technology topics like digital citizenship, email, and social communication.

Plus, because the system is digital, it’s regularly updated to keep your lessons up-to-date with the latest versions of Office!

Want to learn more about Business&ITCenter21?

Click below to see how it can work in your classroom!

Learn More about the Business&ITCenter21 Computer Curriculum

 

About Sarah Layton

Sarah has been with AES since 1998, first serving as a curriculum developer, and now as a customer support analyst and content creator. She is committed to helping instructors gain experience and confidence using our solutions and to providing excellent customer care.