The Potter's School

Microsoft Office 2010 Applications 3

Course Description

HS Microsoft Office 3. This is the final course in the Microsoft Office series. Access Level 2, Publisher, and OneNote are the topics of this class. Students will need to have Office 2010 Professional. The course will begin with Level 2 of Access. After completing this portion of the course, students will have used the necessary skills to sit for the Microsoft Office Specialist (MOS) exam in Access. We'll next cover Publisher, the most underrated of all of the Microsoft Office applications, and we'll end the course with the outstanding application of OneNote. Most people are amazed at what Publisher and OneNote can do. Prerequisite. Completion of Microsoft Office 2 with an average of 80 percent or higher.

• Instructor: Bob Madison
• Prerequisite is completion of Microsoft Office Applications 2
• Required Software: Microsoft Office 2010 to include:
1. Word 2010
2. Excel 2010
3. Access 2010
4. PowerPoint 2010
5. Publisher 2010
6. OneNote 2010
• Books required! Pay close attention to the ISBNs. NOTE: You need three books: the Access book, the Publisher book, and the OneNote book. Also, if you are purchasing a used Access book, inform the bookstore that you need the CD that comes with the book. This CD is NOT the MS Office software. It contains all of the files you need to complete the projects and assessments in the Access book.
• Benchmark Series: Microsoft Access 2010 Level 2. Nita Rutkosky et al, EMCParadigm Pub., ISBN: 978-0-76384-307-6. You may purchase the eBook if you prefer. This is the link for the eBook.
• Using Microsoft OneNote 2010. Michael C. Oldenburg, Que Publishing,
  ISBN-13: 978-0-7897-4292-6.
  ISBN-10: 0-7897-4292-6.
• Using Microsoft Publisher 2010. Brien Posey, QUE,
  ISBN-13: 978-0-7897-4296-9.
  ISBN-10: 0-7897-4296-4

Course Content Information

We will cover one chapter per week from the Access text book. For each class there will be assessments for the students to do and to submit to me via studyplace. Every four chapters, there will be a performance evaluation which is a timed, open-book set of assessments that will be monitored by a parent. There will be two of these timed performance evaluations in Access.

Level 2 Access 2010

When the students finish the Access portion of the course, they will have used all of the skills necessary to take the official Microsoft Office Specilaist (MOS) exam in Access. They might want to review the Level 1 objectives from the second of the MS Office courses before taking the MOS exam. The MOS exams are optional. For more information on certification exams, click here.

Level 2 Access Topics (Eight Chapters and two Performance Evaluations).

Unit 1: Advanced Tables, Relationships, Queries, and Forms

• Designing the Structure of Tables
• Designing and Building Relationships and Lookup Fields
• Advanced Query Techniques
• Creating and Using Custom Forms
• Unit 1 Performance Evaluation

Unit 2. Advanced Reports, Access Tools, and Customizing Access

• Creating and Using Custom Reports
• Using Access Tools and Managing Objects
• Automating, Customizing, and Securing Access
• Integrating Access Data
• Unit 2 Performance Evaluation

Microsoft Publisher 2010

I feel that Publisher is the most highly underrated application within the Microsoft Office fleet of programs. When you finish this course, I am confident that you will believe the same as I do. The topics follow:

• Introduction to Publsiher 2010
• Getting Started with Publisher 2010
• Working with Visual Elements
• Designs and Layouts
• Working with Longer Documents
• Tables
• Finalizing Your Publisher Document
• Printing Your Documents
• Publishing Online
• Bulk Mailing Techniques

Microsoft OneNote 2010

This is an extremely powerful and fun program. You're going to be amazed at what it can do.

Here are the chapter titles from the book

• Chapter 1: What is OneNote and Why Do I Need It
• Chapter 2: Quick Start Tips
• Chapter 3: A Tour of the OneNote Workspace
• Chapter 4: Working with Notebooks, Pages and Sections
• Chapter 5: Taking and Formatting Notes
• Chapter 6: Doing Research with OneNote
• Chapter 7: Organizing and Searching Your Notes
• Chapter 8: Sharing Notes with Other People
• Chapter 9: Using OneNote with Other Programs
• Chapter 10: Security Features in OneNote
• Chapter 11: Using OneNote on the Go using Web App, Windows Phone, iPhone
• Chapter 12: Customizing the OneNote Interface

How Much Time Will You Spend Per Week in This Course?

This is the most popular question that I get. The honest answer is I don't have a clue. The reason is that all of you are different in the way that you learn. Some of you will need more time than others, and some will need less. But, if I really needed to put an amount of time to this, I would say you will spend 2 to 4 hours per week in this course outside of class.

Hope to "See" you in September! God Bless!