Search form

Microsoft Office Teacher Tutorials: 2007, 2010 and 2013

Bernie Poole

EducationWorld is pleased to present these resources shared by technology educator and EducationWorld columnist Bernie Poole. The tutorials help pre-service and in-service teachers learn the suite of applications included in Microsoft Office 2007, 2010 and 2013.

Skill consolidation exercises are designed to teach Word (including mail merge), Excel (including formulas, graphing, charting and Lookup Tables), Access (including reporting), and PowerPoint (including many of the relevant skills that apply to teachers) in the context of the teacher in the K-12 classroom.  They also include a lesson on the Office drawing tools.

PLEASE NOTE: In addition to each tutorial document, you will need a copy of several work files. Email Bernard Poole at [email protected] to request these (and ensure that your email address will not block emails that contain zipped attachments). Also make sure to read Tips for Using the Tutorials.

 

Office 2007

Lesson1: Word - Writing a Conference Call Letter
Lesson 2: Word - Working With Larger Documents
Lesson 3: Office Drawing Tools
Lesson 4: Excel - Preparing a Grade Book
Lesson 5: Excel - Making Changes to Existing Spreadsheets
Lesson 6: Access - Keeping Student Records
Lesson 7: Access - Form Letters and Mailing Labels
Lesson 8: Access - Manipulating the Data in the Database
Lesson 9: PowerPoint - Creating Slideshows and Related Teaching Materials
Lesson 10: PowerPoint - Making Interactive Slideshows and Enhancing Formatting
 

Office 2010

Lesson1: Word - Writing a Conference Call Letter
Lesson 2: Word - Working With Larger Documents
Lesson 3: Office Drawing Tools
Lesson 4: Excel - Preparing a Grade Book
Lesson 5: Excel - Making Changes to Existing Spreadsheets
Lesson 6: Access - Keeping Student Records
Lesson 7: Access - Form Letters and Mailing Labels
Lesson 8: Access - Manipulating the Data in the Database
Lesson 9: PowerPoint - Creating Slideshows and Related Teaching Materials
Lesson 10: PowerPoint - Making Interactive Slideshows and Enhancing Formatting

 

Office 2013

Lesson1: Word - Writing a Conference Call Letter
Lesson 2: Word - Working With Larger Documents
Lesson 3: Office Drawing Tools
Lesson 4: Excel - Preparing a Grade Book
Lesson 5: Excel - Making Changes to Existing Spreadsheets
Lesson 6: Access - Keeping Student Records
Lesson 7: Access - Form Letters and Mailing Labels
Lesson 8: Access - Manipulating the Data in the Database
Lesson 9: PowerPoint - Creating Slideshows and Related Teaching Materials
Lesson 10: PowerPoint - Making Interactive Slideshows and Enhancing Formatting

 

 

About the Author

Associate Professor Emeritus Bernie Poole taught education and instructional technology at the University of Pittsburgh at Johnstown, Pennsylvania. A teacher since 1966, during the first 15 years of his career Poole taught English, history, French, or English as a foreign language primarily to middle-school children in England, Nigeria and Saudi Arabia. Poole has published several books related to instructional technology. Access them and learn more at http://www.pitt.edu/~poole/.

 

Education World®    
Copyright © 2013 Education World