The Potter's School
Microsoft Office Applications 2
Two Semester Course: September through May
- Instructor: Bob Madison
- Prerequisite is completion of Microsoft Office Applications 1 or permission of the instructor.
- Required Software: Microsoft Office 2010 to include:
- Word 2010
- Excel 2010
- Access 2010
- Books required! If you are purchasing used books, you might NOT get 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 book.
- Level 2 Microsoft Word 2010, with CD Nita Rutkosky et al, EMCParadigm Pub., ISBN: 978-0-76384-301-4.
- Level 2 Microsoft Excel 2010, with CD Nita Rutkosky et al, EMCParadigm Pub., ISBN: 978-0-76384-315-1.
- Level 1 Microsoft Access 2010, with CD Nita Rutkosky et al, EMCParadigm Pub., ISBN: 978-0-76384-306-9.
Special Information on Software
You must have the 2010 versions of the Office applications of Word, Excel, and Access. Most Office suites come WITHOUT Access. Please check to ensure you have Access.
Course Content Information
We will cover one chapter per week from the text books. 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 six of these timed performance evaluations: two in Word, two in Excel, and two in Access.
Level 2 Word 2010
When the students finish the Word portion of the course, they will have used all of the skills necessary to take the official Microsoft Office Specilaist (MOS) exam (Expert Level) in Word. The MOS exams are optional. For more information on certification exams, click here.
Level 2 Word Topics (Eight Chapters)
- Creating and Customizing Documents
- Formatting Content
- Organizing Content
- Reviewing Documents
- Sharing and Securing Content
Level 2 Excel 2010
When the students finish the Excel portion of the course, they will have used all of the skills necessary to take the official Microsoft Office Specilaist (MOS) exam (Expert Level)in Excel. The MOS exams are optional. For more information on certification exams, click here.
Level 2 Excel Topics (Eight Chapters)
- Creating and Manipulating Data
- Formatting Data and Content
- Creating and Modifying Formuals
- Presenting Data Visually
- Collaborating and Securing Data
Level 1 Access 2010
When the students finish the Access portion of the course, they will still need to cover Level 2 of Access in order to have used the skills necessary to take the MOS exam in Access.
Level 1 Access Topics (Eight Chapters)
- Structuring a Database
- Creating and Formatting Database Elements
- Entering and Modifying Data
- Creating and Modifying Queries
- Presenting and Sharing Data
- Managing and Maintaining Databases
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.