Sheridan Course Outlines

APPL20000
Advanced Word Processing Applications

I: Administrative Information II: Course Details III: Topical Outline(s) Printable Version Public

Section I: Administrative Information

Credit Value: 3.0
Credit Value Notes: N/A
Effective: Winter 2014
Prerequisites: (APPL19730)
Corequisites: N/A
Equivalents: APPL70052
Pre/Co/Equiv Notes: N/A

Course Name (short): Advanced Word Processing Appls
School: Business
Program(s): Office Admin - Executive
Program Coordinator(s): Lisa Mendez
Course Leader or Contact: Leasa Steadman
Originator: Cheryl-Anne Shirley
Designate: Cheryl-Anne Shirley
Version: 8.0
Status: Approved - Under Rev (AREV)

Calendar Description
Students apply advanced word processing features to create complex business documents for presentation and analysis. Students demonstrate proficiency in advanced word processing features such as styles, themes, proofreading tools, form tools, and document automation.

Typical Instructional Format

Lecture	42.0
Total hours:	42.0

Courses may be offered in other formats.

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.

Section II: Course Details

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

Office Admin - Executive

Program Coordinator: Lisa Mendez

This course is a required course in Year 2 of the Office Administration Executive program. Students further develop word processing skills learned in Year 1 of the program. Through demonstrations, hands- on learning, online tutorials, and simulated exercises, students prepare for the conceptual and practical aspects of Microsoft Office Specialist (MOS) certification.

Course Critical Performance and Learning Outcomes

 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.

Evaluation Plan
Students demonstrate their learning in the following ways:

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

Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

Essential Employability Skills
Essential Employability Skills emphasized in the course:

X	Communication	X	Critical Thinking & Problem Solving		Interpersonal
X	Numeracy	X	Information Management		Personal

Notes: N/A

Prior Learning Assessment and Recognition
PLAR Contact: Nancy Barrington
Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous life and work experiences. This course is eligible for challenge through the following method(s):

Challenge Exam	Portfolio	Interview	Other	Not Eligible for PLAR
X

Notes: N/A

Section III: Topical Outline

Some details of this outline may change as a result of circumstances such as weather cancellations, College and student activities, and class timetabling.
Effective term: Winter 2014
Professor: Multiple Professors
Textbook(s):

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.

Applicable student group(s): Office Administration Executive Diploma (Year 2)
Course Details:

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 ﬁelds into a main document
Edit a main document
Preview a merged document
Complete a mail merge
Edit an existing data source
Sort and ﬁlter 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 ﬂow
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 ﬁgures
Add an entry to a table of contents using a ﬁeld
Update ﬁelds before printing
Check compatibility to earlier versions of Word
Protect a document with encryption
Mark a document as ﬁnal

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 ﬁles 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 ﬁelds
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%)

Academic Honesty
The principle of academic honesty requires that all work submitted for evaluation and course credit be the original, unassisted work of the student. Cheating or plagiarism including borrowing, copying, purchasing or collaborating on work, except for group projects arranged and approved by the faculty member, or otherwise submitting work that is not the student's own violates this principle and will not be tolerated. Instances of academic dishonesty, including assisting another student to cheat, will be penalized as detailed in the Student Handbook.

Students who have any questions regarding whether or not specific circumstances involve a breach of academic honesty are advised to discuss them with the faculty member prior to submitting the assignment in question.

Discrimination and Harassment
Sheridan is committed to provide a learning environment that respects the dignity, self esteem and fair treatment of every person engaged in the learning process. Behaviour which is inconsistent with this principle will not be tolerated. Details of Sheridan's policy on Harassment and Discrimination are available in the Student Handbook.

[ Printable Version ]