Microsoft Office Lesson Plans Your Students Will Love Blog Feature
Bri Stauffer

By: Bri Stauffer on April 1st, 2020

Print/Save as PDF

Microsoft Office Lesson Plans Your Students Will Love

Computer Applications | Microsoft Office | Microsoft Office Specialist (MOS)

Do you teach middle or high school computer applications classes? If so, it's likely that your standards include requirements on teaching Microsoft Office.

As a computer applications curriculum developer, teachers often ask how we help teach Microsoft Office and prepare students for MOS certification.

While we provide a Microsoft Office curriculum system, our solution may not be the best fit for everyone.

Some teachers are only looking for supplemental resources or tips on improving their existing lessons.

If that's the type of information you're looking for, you're in the right place!

In this article, you'll discover best Microsoft Office teaching tips and lesson ideas for:

  1. Microsoft Word
  2. Microsoft Excel
  3. Microsoft PowerPoint
  4. Microsoft Access
  5. Microsoft Publisher
  6. Microsoft Office Specialist Certification

For each of these topics, we'll share a list of recommended resources to help you teach the best Microsoft Office lessons possible.

1. Microsoft Word Lessons & Activities


Microsoft Word is often the first jumping off point for many computer applications classes.

Rather than spend hours creating your own Microsoft Word lesson plans and activities, wouldn’t you like some that you can just integrate into your existing curriculum?

That’s where this post can help: Microsoft Word Lesson Plans to Wow Your Students

It’s got a number of resources that you can use to teach your middle or high school students to use Microsoft Word.

Want more than just Microsoft Word lesson plans to supplement your existing curriculum?

Business&ITCenter21 has lessons, quizzes, and projects to teach your students all about Microsoft Word.

The curriculum begins with Microsoft Word Essentials, which introduces your students to the basics of the application.

Next, you can use the Microsoft Word Fundamentals lessons to give students a more in-depth look about formatting content within a Word document.

It starts off with Microsoft Word Fundamentals, giving your students the basics of the application.

Once they have mastered the basics, your students can move onto the Microsoft Word Skills Project which puts their skills to the test, requiring them to start from scratch and fully create a document.

If you want to take it one step further, you can assign the Microsoft Word Business Project, which requires the students to create a Job Description booklet using more advanced skills.

Looking for additional tips? Read this article: How to Teach Microsoft Word in Middle School

2. Microsoft Excel Lesson Plans


Let’s face it — Excel isn’t the most exciting Microsoft application out there. So what can you do to spice up your Microsoft Excel lesson plans? Make them relevant to your students!

So where can you find engaging, relevant Microsoft Excel lesson ideas?

Start by reviewing these popular Microsoft Excel lesson plan resources:

  • Excel 2016 Tutorial from
  • Microsoft Excel Spreadsheets Lesson Plan Bundle from Computer Creations
  • Lessons & Activities Bundle for Microsoft Excel from TechCheck Lessons

Each of those resources can help supplement any teacher's lessons on Microsoft Excel.

But what if you need more than a few extra spreadsheet activities?

Our computer applications curriculum has you covered with Excel, too!

The first module in the sequence is Microsoft Excel Essentials, which provides an overview of working with spreadsheets and working with cells, rows, and columns. Students also learn about using basic functions and formulas.

Next, students can work through Microsoft Excel Fundamentals. This module provides an overview of the fundamentals of Microsoft Excel, including relative and absolute cell references, common functions, and formatting.

If you need to cover more advanced skills and features within Excel, you can assign the Microsoft Excel Skills Project or Microsoft Excel Business Project.

3. Microsoft PowerPoint Lesson Plans


PowerPoint is sometimes considered to be overused in schools, both by instructors and students. Because of this, it’s important that your Microsoft PowerPoint lesson plans are right on par (or above and beyond!)

Your PowerPoint lessons should be more than just a How-To. You must make sure that your students understand how a presentation can effectively (and ineffectively) be used.

So how can you teach your students to effectively use Microsoft PowerPoint?

We recommend you start with four topics on Microsoft PowerPoint:

  • An Introduction to Microsoft PowerPoint
  • The Basics of Building a PowerPoint Presentation
  • More Features in PowerPoint
  • Do’s & Don’ts of Effective Presentations

To find teaching tips and activity outlines, read this article: Best PowerPoint Lessons for Middle School

Need more structure and resources to teach Microsoft PowerPoint?

In Business&ITCenter21, the Microsoft PowerPoint Essentials module provides an overview of Microsoft PowerPoint essentials, themes, templates, and adding and inserting a variety of items into a presentation

Then in the Microsoft PowerPoint Fundamentals students learn about creating effective presentations that are interesting, engaging, and functional.

Once your students have the basics down, you can move onto more advanced concepts and features with the Microsoft PowerPoint Skills Project and Microsoft PowerPoint Business Project.

4. Microsoft Access Lesson Plans


Microsoft Access can be a challenging subject for middle school and high school students. So it’s no surprise that Microsoft Access lesson plans are a challenge for computer applications teachers.

To help you save time , we put together a list of popular Microsoft Access teaching resources:

  • GCF Learn Free
  • Tonya Skinner's Website
  • Teachers Pay Teachers

Each of these websites has a variety of materials to help you teach Microsoft Access skills.

In addition, check out the Microsoft Access Fundamentals module within Business&ITCenter21.

This module provides an overview of database theory as students gain practical experience with Microsoft Access.

5. Microsoft Publisher Lesson Plans

Do you give Microsoft Publisher its fair share of attention? Many computer applications educators avid including Microsoft Publisher lesson plans in their curriculum.

We've found that's often because they don’t know where to find good Microsoft Publisher lessons!


To help you get started, we put together a list of popular Microsoft Publisher lessons and activities:

  1. Teachers Pay Teachers
  2. Tangipahoa Parish School System
  3. Cape May County Technical School District
  4. Council Rock High School South
  5. Rochester Hills Public Library
  6. Instructables
  7. Shawano School District
  8. Microsoft Office Support
  9. Business&ITCenter21

Each of these resources can help you introduce Microsoft Publisher to your students when added to your existing Microsoft Office curriculum.

But are you looking for a more structured resource on Publisher? If so, check out the Microsoft Publisher Fundamentals module within Business&ITCenter21.

This module provides an overview of the fundamentals of Microsoft Publisher through the creation of a number of desktop publishing documents.

6. Microsoft Office Certification Prep


In our experience, we've found that teachers searching for Microsoft Office lesson plans are often also interested in preparing their students for the Microsoft Office Specialist certification exams.

To help your students prepare for certification, you most likely need more than just a lesson or two. It might be beneficial to also include test prep material to help your students prepare.

For tips on how to best prepare your students for MOS certification, read these articles:

Start Teaching Microsoft Office Skills Today!

All of the resources and ideas listed on this page can help you put together a great Microsoft Office curriculum.

However, if you're like most computer applications teachers you don't have much time to spare for piecing together a hodgepodge of lessons and activities.

If you need a curriculum solution that helps you teach all of the Microsoft Office applications, consider looking into Business&ITCenter21.

Business&ITCenter21 is used by thousands of teachers every year to teach Microsoft Officedigital literacy skills, coding fundamentals, and more.

Overall, it helps teachers like you save time with planning, assessing, and grading student work all while maximizing student understanding and information retention.

To see if Business&ITCenter21 is a good fit for your classroom, watch the demo video:

Watch Your Demo Video >>


About Bri Stauffer

Bri collaborates with others at AES to create content that answers your questions about teaching classes, preparing students for certifications, and making the most of the AES digital curriculum.

  • Connect with Bri Stauffer