Course Description: To fully utilize the capabilities of Microsoft Office, students will need to address the process, or system side, of how this technology is being used to enhance productivity in the workplace. Throughout this text, students are expected to develop and execute strategies for solving information processing and management problems using Word, for solving numeric and mathematical problems using Excel, for organizing, querying, and retrieving data using Access, and for writing, creating and producing presentations using PowerPoint.

Text – Marquee Series, Microsoft® Office 2007, Brief Edition, Rutkosky, Seguin, Rutkosky, Copyright 2008.

Units	Section Topics
Windows XP	1) Exploring Windows XP 2) Maintaining Files and Customizing Windows
Internet Explorer 7.0	1) Browsing the Internet Using Internet Explorer 7.0.
Word 2007	1) Creating and Editing a Document 2) Formatting Characters and Paragraphs 3) Formatting and Enhancing a Document
Excel 2007	1) Analyzing Data Using Excel 2) Editing and Formatting Worksheets 3) Using Functions, Setting Print Options, and Adding Visual Elements
Access 2007	1) Maintaining Data in Access Tables 2) Creating Tables and Relationships 3) Creating Queries, Forms, and Reports
PowerPoint 2007	1) Preparing a Presentation 2) Editing and Enhancing Slides
IP	1) Integrating programs: Word, Excel, Access, and PowerPoint.

Course Objectives:

The Student will:

1. Analyze, synthesize, and evaluate school, work, or home situations and use application software to complete information-processing tasks efficiently and effectively.

2. Access the Internet and use the browse, search, and hyperlink capabilities of Web Browsers.

3. Prepare, manage, and print documents using application software.

4. Learn strategies for merging and integrating source data from different applications.

5. Create, design, and produce professional documents using basic word processing software. Topics include design options for formatting and layout, strategies for working with multiple documents, and techniques for using templates and pre-designed styles.

6. Process, manipulate and represent numeric data using the basic functions of spreadsheet software. Functions include: using formatting techniques for preparing a spreadsheet, creating and testing formulas, using multiple worksheets, exploring what-if scenarios, and converting to chart formats.

7. Design and create informational and motivational slides using presentation software and images that contain hyperlinks, tables, clip art and animation.

Breakdown of Grading

45% Average of all graded assignments (skill assessments)

15% Average of all concepts checks

25% Theory Tests

15% Workmanship/Attendance

Letter Grade	Percentage	Letter Grade	Percentage
A	93-100	C	73-76
A-	90-92	C-	70-72
B+	87-89	D+	67-69
B	83-86	D	63-66
B-	80-82	D-	60-62
C+	77-79	NC	59 or below

Contact Information:

Mr. Todd Tumberg

Email: ttumberg@pp.k12.mn.us

Phone: 218-338-6011, x102

I am available to meet with students via appointment only.