A Collection of Lesson Plans for Teaching Microsoft Office

Ready-made Activities for Computer Skills in Word, Excel, or PowerPoint

Looking for fun, ready-made lesson plans for teaching Microsoft Office skills?

These resources help you teach your students programs such as Word, Excel, PowerPoint, OneNote, Access, and Publisher within the context of real-life scenarios. 

Find lesson plans for elementary, middle grade, or high school students. Some may even be appropriate for basic computer classes at the college level. Best of all, most of these are free!

of 11

First, Check Your School District's Site

Lessons Plans for Teaching Computer Skills and Microsoft Office
Hero Images / Getty Images

Most teachers know whether or not their school district offers computer skills curriculum or lesson plans.

Some school districts even post free resources online, so you can take a look and perhaps even download resources. I have included one such link in this list, but if you are new to a teaching position, you may want to check out your organization's resources first. That way, you know your curriculum aligns with district policies.

This is a great site for finding free lesson plans donated by a bunch of organizations, including Goodwill. Several address Microsoft Office programs.

On the left, you will notice a wide range of topics for improving computer literacy. More »

Get Microsoft Office computing lessons with fun topics for elementary school, middle school, and high school students.

You can also find free web quests and other technology-related lessons on this site, as well as overviews of how programs like Word, Excel, and PowerPoint are useful for students' learning in general as well as how they might need it in future pursuits. More »

Download free PDF curriculum complete with learning outcomes, images, and more for some versions of  Word, Excel, PowerPoint, and Access.

These have been created by Bernie Poole. Some activities require work files. To get those ready-made templates and resources, please know you will need to email Mr. Poole.  

The site also features many more topics for computer integration.  More »

Find resources for teachers such as the Common Core Implementation Kit and more. This extensive site includes courses, tutorials, resources for tools like Skype, and more. 

Badges, points, and certificates are also available to help motivate and organize your progress.For example, certify to be a Microsoft Innovative Educator (MIE).

Instructors can also share or find Learning Activites for a variety of ages, subjects, and computer programs. More »

You may also be interested in integrating Microsoft's own certifications with your curriculum. This prepares your students to be more marketable once they leave your class.

These might include the Microsoft Office Specialist (MOS), Microsoft Technology Associate (MTA), Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Developer (MCSD), and Microsoft Certified Solutions Expert (MCSE) certifications. More »

For a variety of free lesson plans in Word, Excel, and PowerPoint for middle school students, check out this site.

Another great tool on this site is a matrix showing how these lessons cross over into other subject areas such as science, math, language arts, and more.  More »

These free lesson plans feature fun applications for Word, Excel, and PowerPoint.

She also features fun ideas for teaching audio and visual programs, and a bunch of other computer-related topics.

Nicholson states on her site:

Technology assignments listed at this site utilize a distance learning approach in the delivery of instruction. All assignments include lesson plans aligned to benchmarks and grading rubrics to evaluate student performance.

More »

This site features an easy-to-use interface for viewing and using free lesson plans.

Most focus on Microsoft Word, with a few for Excel as well.   More »

This site offers premium lesson plans for Office 2007, 2010, or 2013 at affordable prices.

Lessons feature real-life applications your students will love. Here's a quote from their site:

"Promote an amusement park. Design posters in Word, surveys in Excel, ads in PowerPoint, and more!" 

More »

This site is another offering premium lesson plans for teaching Word, Excel, PowerPoint, Access, and Publisher, for some versions of the Microsoft Office suite. More »