APPL12850
Computers in the Office 2
Sheridan College Logo
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 
Section I: Administrative Information
  Total hours: 42.0
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

Program(s): Office Administration
Program Coordinator(s): Nancy Barrington
Course Leader or Contact: Nancy Barrington
Version:
6.0
Status: Approved (APPR)

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 (if course is PLAR-eligible) : Office of the Registrar

Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous relevant work/life experience, service, self-study and training on the job. 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


Sheridan Policies

All Sheridan policies can be viewed on the Sheridan policy website.

Academic Integrity: The principle of academic integrity 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 professor, or otherwise submitting work that is not the student's own, violates this principle and will not be tolerated. Students who have any questions regarding whether or not specific circumstances involve a breach of academic integrity are advised to review the Academic Integrity Policy and procedure and/or discuss them with the professor.

Copyright: A majority of the course lectures and materials provided in class and posted in SLATE are protected by copyright. Use of these materials must comply with the Acceptable Use Policy, Use of Copyright Protected Work Policy and Student Code of Conduct. Students may use, copy and share these materials for learning and/or research purposes provided that the use complies with fair dealing or an exception in the Copyright Act. Permission from the rights holder would be necessary otherwise. Please note that it is prohibited to reproduce and/or post a work that is not your own on third-party commercial websites including but not limited to Course Hero or OneNote. It is also prohibited to reproduce and/or post a work that is not your own or your own work with the intent to assist others in cheating on third-party commercial websites including but not limited to Course Hero or OneNote.

Intellectual Property: Sheridan's Intellectual Property Policy generally applies such that students own their own work. Please be advised that students working with external research and/or industry collaborators may be asked to sign agreements that waive or modify their IP rights. Please refer to Sheridan's IP Policy and Procedure.

Respectful Behaviour: Sheridan is committed to provide a learning environment that supports academic achievement by respecting 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, Academic Integrity and other academic policies are available on the Sheridan policy website.

Accessible Learning: Accessible Learning coordinates academic accommodations for students with disabilities. For more information or to register, please see the Accessible Learning website (Statement added September 2016)

Course Outline Changes: The information contained in this Course Outline including but not limited to faculty and program information and course description is subject to change without notice. Any changes to course curriculum and/or assessment shall adhere to approved Sheridan protocol. Nothing in this Course Outline should be viewed as a representation, offer and/or warranty. Students are responsible for reading the Important Notice and Disclaimer which applies to Programs and Courses.


[ Printable Version ]

Copyright © Sheridan College. All rights reserved.