APPL12850
Computers in the Office 2
 
  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 2008
Prerequisites: (APPL19730)
Corequisites: N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A

Course Name (short): Computers in the Office 2
School:
All Sheridan Schools
Program(s): Office Administration
Program Coordinator(s): Nancy Barrington
Course Leader or Contact: Nancy Barrington
Originator: Linda Sutherland
Designate: Linda Sutherland
Version:
6.0
Status: Approved (APPR)

Calendar Description
This course prepares students for advanced word processing level certification. Extensive hands-on training is provided on networked mobile computers using word processing software.

Typical Instructional Format

Mobile
42.0
Total hours: 42.0

Courses may be offered in other formats.

Section I Notes: Successful completion of the following courses is mandatory for promotion to Year 2 of any Office Administration Program: Document Processing 1 (OADM12138), Document Processing 2 (OADM19216), Business Communications 1 (COMM11623), Business Communications 2 (COMM15334), Computers in the Office 1 (APPL19730), Computers in the Office 2 (APPL12850).

 
 
Section II: Course Details

Detailed Description
This course prepares students for advanced word processing level certification. Extensive hands-on training is provided on networked mobile computers using word processing software.

Program Context

 
Office Administration Program Coordinator: Nancy Barrington
This course is a required component of second semester Office Administration. Students will be able to use the skills acquired in the preparation of assignments and presentations for courses in the following semesters.


Course Learning Outcomes
Learning outcomes identify the critical performances, and the knowledge, skills and attitudes that successful students will have reliably demonstrated through the learning experiences and evaluation in the course. Successful students will have demonstrated the following:

 
 
            Knowledge
			
Successful students will have demonstrated knowledge of:

- The physical components of mobile computers

- Generating business documents

- File maintenance and backup procedures

- Microsoft Office User Expert Level Certification

 
            Skills
			
Successful students will have demonstrated further development in 
their abilities to:

- Use My Computer and Word to organize folders, back up and   
  manipulate files (copy, move, rename, delete, properties)

- Develop expert level in Word on an IBM mobile computer   
  including functions such as:

- merging documents (letters, envelopes, labels, directory)

- sorting text (paragraphs, columns, tables, data source)

- formatting with special features (Auto text, text flow, borders, 
  find/replace, page numbering, columns, etc.)

- adding visual appeal to documents (simple images, clip art, title 
  page)

- formatting with macros and styles

- working with shared documents (tracking changes, comments, 
  multiple versions, routing documents, creating master and
  subdocuments)

- creating special tables and indexes (table of contents, index, 
  table of figures, table of authorities)

- preparing and protecting forms (fill-in fields, customizing, 
  drop-down lists)

- accessing course materials electronically, from home or school, 
  using Sheridan's Webmail and WebCT Vista
 
            Attitudes
			
Successful students will have demonstrated attitudes of:

- An appreciation of Microsoft Word applications as vital tools in 
  their future success as a School of Business student and as a 
  program graduate.

- A desire to work independently, format documents and apply the  
  appropriate Microsoft Word functions and backup files regularly.

- A willingness to follow and show respect for Sheridan policies and 
  guidelines for laptop use.
Evaluation Plan
Students demonstrate their learning in the following ways:

 
Evaluation for the course will be based on word processing 
tests/assignments.

Tests(Hands On)	             60%
Quizzes (Theory)             20%
Assignments (Practical)      20%
                            ____
Total		            100%

TESTS/QUIZZES

All tests/quizzes are given once only.  A make-up may be given at the
end of the term based on the entire term's work.  The student may 
take this test/quiz to substitute for one missed test or quiz.

Word processing tests will be marked for accuracy, set-up, 
completeness, organization, knowledge of Microsoft Word Functions, 
timing, and the ability to follow instructions.

ASSIGNMENTS:

If a student is absent, it is the student's responsibility to find 
out assignment and test dates (including material covered in class) 
including accessing course materials in WebCT Vista.

Late assignments will not be accepted after the graded papers are 
returned. 

MARKING GUIDELINES:

1. Major: Minus 2 marks for each major inputting or formatting error 
   (proofreading, typographical, spelling, major set-up, i.e. 
   incorrect letter style, run-on sentence, etc.) 

2. Minor: Minus 1 mark for each minor error (minor punctuation i.e.,  
   missing comma, minor set-up, i.e. missing reference initials or 
   enclosure notation, etc.)

3. Timing: Minus 10% may take place for tests not completed within 
   the designated time frame.

Unless otherwise specified, assignments are to be completed on your 
own.  See the Student Handbook for collaboration/cheating details.


Note:  Students are responsible for completing the exercises, 
       assessments and offline thinking exercises for each chapter.  
       Students are also expected to back up all work, including the 
       pre-recorded exercises on the CD-ROM which accompanies the 
       text.
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
  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 2008
Professor: Multiple Professors
Textbook(s):
Benchmark Word 2003 Expert Text/CD by Nita H. Rutkosky, EMC Paradigm 
Publishing, 2006

Publisher's website:  http//:www.emcp.com

Applicable student group(s): Students in the Office Administration program.
Course Details:
Chapter 1:  Merging Documents and Sorting Selecting Data

Merging:

- Preparing envelopes, labels and a directory using the mail merge 
  wizard

- Completing a merge using Outlook information as the data source

- Editing merge documents using the mail merge wizard and toolbar

Sorting:

- Sorting text in paragraphs, columns, tables and records in a data 
  source

- Changing sort options and selecting records


Chapter 2:  Formatting with Special Features

- Using Auto Text (saving, inserting, editing and deleting)

- Inserting a nonbreaking space and a manual line break

- Affecting text flow (widow/orphan control, keeping paragraphs 
  together)

- Revealing formatting

- Adding borders, shading, horizontal lines and page borders

- Finding and replacing (text, formatting, characters, special 
  characters) 

- Footnotes and endnotes ** 

- Formatting pages in a document:  page borders, page numbers, 
  headers/footers ** 

- Creating and balancing columns 


Chapter 3:  Adding Visual Appeal to Documents 

- Brief introduction to inserting, customizing, downloading 
  images, watermarks and word art 

- Creating a simple title page 

- Creating dropped capital letters

- Customizing toolbars and menus


Chapter 4:  Formatting with Macros and Styles
 

Macros:

- Creating macros (recording, running, pausing, deleting, editing, 
  fill-in-fields)

- Assigning a macro to a keyboard and toolbar


Styles:

- Formatting text with styles (autoformat, style gallery)

- Creating, applying and modifying styles (by example, new style 
  dialog box)

- Assigning a shortcut key combination to a style

- Removing and deleting styles

- Creating a cross-reference

- Navigating in a document (in outline view, with document map, using 
  bookmarks) 

Chapter 5:  Working with Shared Documents

- Tracking Changes to a Document
- Creating Multiple Versions of a Document
- Protecting Documents
- Searching for Specific Documents
- Creating a Template

Chapter 6:  Sharing Data

- Importing Data
- Creating, Filling in and Printing a Form
- Editing a Form Template
- Customizing Form Field Options
- Creating Tables in a Form Template
- Creating a Master Document and Subdocuments

Chapter 7: Creating Specialized Tables and Indexes
 
- Creating a Table of Contents
- Creating an Index
- Creating a Table of Figures
- Creating a Table of Authorities
 

WEEKLY OUTLINE:
 
This is a guideline only. Topics and order in which they are 
presented may vary according to instructor preference, student 
ability, hardware/software technicalities, network access and 
unforeseen circumstances.

Week

1-2     Ch. 1 - Merging Documents and Sorting and Selecting Data

3       Ch. 2 - Formatting with Special Features

4       Ch. 3 - Adding Visual Appeal to Documents

5       Test 1 (Ch. 1-3, Merge, Sort, Formatting)

6-7     Ch. 4 Formatting with Macros and Styles
        Independent Study:  Expert Unit 1 - Performance Assessments
         
8-9     Ch. 5 - Working with Shared Documents

10      Ch. 6 - Sharing Data and Forms

11-12   Ch. 7 - Creating Specialized Tables and Indexes

13      Review

14      Test 2


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 ]

Copyright © Sheridan College. All rights reserved.