Microsoft Office 2010 – Illustrated Second Course

Instructor:  Kathleen Aiello

Office: Instructional Technology

Phone: 2285

E-mail: aiellok@lynnschools.org

Website:

 

 

Course Description:

As a student in this course, you will learn the most important topics of Microsoft Office 2010. You will be presented with an overview of Microsoft Excel, Access, Word, and PowerPoint.  You will learn to use Word to create and format tables as well as illustrated documents and work with themes. You’ll move onto Excel where you’ll analyze data using formulas and manage workbook data. You’ll also learn about using tables and analyzing table data. Access will be used to learn about modifying database structure and creating multiple table queries. You’ll also learn about PowerPoint and how to work with advanced tools and features as well as inserting illustrations, objects and media clips.  Along the way you’ll have lessons on how to integrate all the applications together.

 

Text/Materials:

Text: Beskeen/Cram/Duffy/Friedrichsen/Wermers, Microsoft Office 2010– Illustrated Second Course  Course Technology, 2011.

Software: Microsoft Office 2010.

Handouts: Additional handouts may be required. Instructor will provide information on obtaining this material.

 

Course Outline

Assignment Descriptions:

• Concepts Review – Includes screen identification, multiple choice, and matching questions.

 

• Skills Review – Provides additional hands-on exercises that mirror the progressive style of the lesson material.

 

• Independent Challenges 1, 2 and 3 – Case projects that require critical thinking and application of the unit skills.  The Independent Challenges increase in difficulty, with the first being the easiest (with the most step-by-step detailed instructions).  Independent Challenges 2 and 3 become increasingly more open-ended

 

• Real Life Independent Challenge – Using a real world focus to apply the unit skills, students create documents that will benefit their every day lives

 

• Advanced Challenge Exercises – Optional steps that are set within 2 of the 4 Independent Challenges for each unit.  They are designed to challenge more advanced students.  2 solution files are provided for easy grading.

 

• Visual Workshop – a practical, self-graded capstone project that requires independent problem solving.

 

Week	Topic	Assignment
	PowerPoint 2007 Unit E: Working with Advanced Tools and Masters	2 Independent Challenges
	PowerPoint 2007 Unit F: Enhancing Charts	Visual Workshop
	PowerPoint 2007 Unit G: Inserting Illustrations, Objects, and Media Clips	Concepts Review
	PowerPoint 2007 Unit H: Using Advanced Features (Part 1)	Skills Review
	Integration Unit F: Integrating Word, Excel, Access, and PowerPoint (part 1)	2 Independent Challenges
	Review	Visual Workshop
	Exam #3
	PowerPoint 2007 Unit H: Using Advanced Features (part 2)	Concepts Review
	Integration Unit F: Integrating Word, Excel, Access, and PowerPoint (part 2)	Skills Review
	Review	None
	Final Exam	None