Program(s): Office Admin - Executive
Program Coordinator(s): Lisa Mendez
Course Leader or Contact: Leasa Steadman
Version: 8.0
Status: Approved - Under Rev (AREV)

Section I Notes: This course is offered in a hybrid version. The hybrid delivery is a combination of in-class instruction (2 hours) and online work (1 hour) per week. Students taking this course will need reliable access to the internet, and should have a basic level of comfort using computers as well as the self discipline to study online. Students can expect to spend an additional three hours per week for online activities such as postings, discussions, and homework. This is a web- based course offered online, using Sheridan's current LMS (Learning Management System). To take this course, students will need reliable access to the Internet and manage the virtual component to the course.

Detailed Description
Students apply advanced word processing features to create complex business documents for presentation and analysis. Students demonstrate proficiency in advanced word processing features to enhance the appearance of documents incorporating styles, themes, proofreading tools, form tools, and document automation. Multi-page business documents are organized through management of master documents; subdocuments and outlines. Documents are shared with others by inserting comments, tracking changes, accepting or rejecting changes made by multiple authors, combining documents and protecting documents. Visual appeal and accessibility is enhanced through development of eye-catching, web pages documents. Development of interactive, fill-in forms and form templates are created through introduction of form design and control fields. Students demonstrate proficiency in advanced document automation processes through use of macros and Visual Basic editor tools. Through demonstrations, hands-on learning, online tutorials, and simulated exercises, students prepare for the conceptual and practical aspects of word processing applications certification.

Program Context

 Critical Performance
By the end of this course, students demonstrate the ability to 
create, customize, edit, build, organize, analyze and present 
information in complex business documents using advanced word 
processing features.

Learning Outcomes
To achieve the critical performance, students will have demonstrated 
the ability to:

1. Create complex business documents which include numbers, bullets,
   headers/footers, and charts 
2. Apply appropriate formatting elements and styles to a range of
   business documents (letters, memos, multi-page reports).
3. Apply proofreading tools such as spelling and grammar check,
   thesaurus and readability statistics.
4. Customize word processing functions such as auto correct,
   toolbars, themes, styles, and dictionaries
5. Organize components of multi-page reports using a predesigned
   cover page, table of contents, index, table of authorities and
   table of contents, endnotes or footnotes, bibliography.
6. Work on shared documents by inserting comments, tracking
   changes, accepting or rejecting changes made by multiple authors,
   combining documents and protecting documents.
7. Insert customized bullets, charts, graphs, and themes to maintain
   a uniform appearance in documents.  
8. Simulate theory and practical features of testing of industry
   word  processing certification.

25%	Practical Skills Test 1:  Advanced Document Management 
25%	Practical Skills Test 2:  Form Management and Macros
10%	Online tutorials
10%	In Class Assignments
30%     Assignments/Projects
____
100%	Total

New Perspectives on Microsoft® Word 2010
APPL20000 Advanced Word Processing - Office Administration Executive 
Program, Custom Edition, Sheridan Institute of Technology and 
Advanced Learning

A Skills Assessment Manager (SAM) PIN is required in order to 
complete Tutorials and Exams.

RESOURCES:
Cengage Learning Student Textbook Companion Site Cengage Learning 
Skills Assessment Manager (SAM 2010) - http://sam2010.course.com/

New Perspectives on Microsoft® Office 2010, First Course,
1st Edition, Volume 1 (Custom Edition) Ann Shaffer, Patrick Carey, 
June Jamrich Parsons, Dan Oja, Kathleen T. Finnegan 
bundled with SAM Personal Identification Number and SAM e/book

SUPPLIES:
Internet cable and memory key or CD ROM for backup purposes.

WEEKS 1 & 2
Orientation to Course
Skills Assessment Manager (SAM 2010) Review
Benefits of Microsoft Office Specialist Certification (MOS) 

MODULE 1: WORKING WITH TEMPLATES, THEMES, AND STYLES
Creating a New Document from a Template
Inserting a Word File into a Document 
Customizing the Document Theme 
Changing Character/Paragraph Spacing 
Selecting a Style Set 
Creating/Modifying/Updating/Inspecting/Comparing Styles 
Creating a Table of Contents 
Using the Research Task Pane 
Translating Text 
Create/Use New Template

WEEKS 3 & 4:
MODULE 2: MAIL MERGE IN DEPTH
Learn about the mail merge process
Select a main document
Create a data source
Insert mail merge fields into a main document
Edit a main document
Preview a merged document
Complete a mail merge
Edit an existing data source
Sort and filter records
Create mailing labels and a phone directory
Convert tables to text and text to tables
Create multilevel lists

WEEKS 5 & 6:
MODULE 3: MANAGING LARGE DOCUMENTS
Insert subdocuments
Create subdocuments from text in a master document
Split, merge, and unlink subdocuments
Control text flow
Insert nonbreaking hyphens
Add automatic heading numbers and numbered captions
Create an Excel chart from within a document
Create cross-references
Protect a document with editing and formatting restrictions
Check a document for hidden data
Check a document for accessibility
Use synchronous scrolling to compare documents
Add highlighting to text
Use advanced page numbering techniques and style references
Create and update an index and a table of figures
Add an entry to a table of contents using a field
Update fields before printing
Check compatibility to earlier versions of Word
Protect a document with encryption
Mark a document as final

WEEK 7:
PRACTICAL TEST #1 (25%):  ADVANCED DOCUMENT MANAGEMENT
ACCUMULATED ONLINE TUTORIALS AND ASSESSMENTS (10%)
ACCUMULATED PROJECTS/ASSIGNMENTS (15%)

WEEKS 8 & 9:
MODULE 4: COLLABORATING WITH OTHERS AND CREATING WEB PAGES
Track changes in a document
Insert and delete comments
Accept and reject changes
Compare and combine documents
Embed and modify an Excel worksheet
Link an Excel chart
Modify and update a linked chart
Share files on SkyDrive
Create bookmarks
Insert and edit hyperlinks
Save a Word document as a Web page
Format a Web document
View a Web document in a Web browser

WEEKS 10 & 11:
MODULE 5: CUSTOMIZING WORD AND AUTOMATING YOUR WORK
Correct the color of photos
Learn about picture compression
Add a shape with text
Add a custom paragraph border
Create a watermark
Create columns of different widths
Insert a text box
Create and insert Quick Parts
Manage building blocks
Customize AutoCorrect
Add document properties
Insert fields
Learn about Trust Center settings
Record and run macros
Edit macros using Visual Basic
Import and run Visual Basic macros
Record an AutoMacro
Customize the Quick Access Toolbar and the Ribbon

WEEKS 12 & 13:
MODULE 6: WORKING WITH FORMS
Plan and design an online form
Merge and split cells
Move gridlines
Draw and erase borders
Align and rotate text
Format text and shade cells
Learn about content controls
Insert content controls
Modify placeholder text in a content control
Test content controls
Learn about cell referencing in formulas
Use formulas in a table
Protect a document 
Fill in an online form
Learn how to fax and email a form

WEEK 14:
PRACTICAL TEST #2 (25%):  AUTOMATING WORK & FORM MANAGEMENT
ACCUMULATED ONLINE TUTORIALS AND ASSESSMENTS (10%)
ACCUMULATED PROJECTS/ASSIGNMENTS (15%)