APPL11139
Productivity Software
 
  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: Fall 2004
Prerequisites: N/A
Corequisites: N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A

Course Name (short): Delete Productivity Software
School:
All Sheridan Schools
Program(s): IT Support Services Coop
Program Coordinator(s): Ann Cadger
Course Leader or Contact: Ann Cadger
Originator: Judy Ross
Designate: Judy Ross
Version:
1.02
Status: Draft (DRAF)

Calendar Description
This course will cover many of the objectives outlined in the Microsoft Proficiency Guidelines to prepare students for certification in the latest versions of WORD, EXCEL and POWERPOINT. Students will develop the WORD skills needed to produce reports, form letters and promotional material such as newsletters and fliers. They will use EXCEL to create worksheets, charts and graphs, and create on-screen presentations with PowerPoint.

Typical Instructional Format

Mobile
42.0
Total hours: 42.0

Courses may be offered in other formats.

Section I Notes: N/A

 
 
Section II: Course Details

Detailed Description
N/A

Program Context

 
IT Support Services Coop Program Coordinator: Ann Cadger
This course is a core component of the Information Technologies Support Services. It links with other courses in software and hardware to develop an advanced level of skill in using current technology and solving computer-related problems.


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:

- Manage text, data and graphics using the 
  following Microsoft Office 2002 application 
  packages: EXCEL, POWERPOINT and WORD.
- Use WORD to create a variety of advanced 
  documents and customize and automate the user 
  interface.
- Use spreadsheets for decision-making and present 
  numerical data in a meaningful way with the use 
  of tables, charts and graphs.
- Create on-screen presentations using Microsoft 
  PowerPoint 2002
- Prepare for a Vendor certification test by 
  demonstrating the ability to understand the 
  objectives and perform the skills required by 
  Microsoft to pass the WORD 2002 Expert and EXCEL 
  2002 Core MOUS tests.
- Apply previously acquired knowledge in a 
  self-directed manner.
	

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

- Use a wide range of editing and formatting 
  features.
- Work with advanced WORD features needed to 
  produce large documents, including outline, 
  columns, headers/footers, endnotes/footnotes, 
  automatically generated table of contents and 
  indexes. 
- Create and modify WORD macros, styles, templates 
  and forms.  
- Produce promotional documents such as flyers, 
  newsletters and announcements using graphics, 
  lines, borders, and shading. 
- Use the merge mail features to customize   
  reports, letters and labels. 
- Create a WORD form template with text, checkbox and 
  drop-down fields.
- Use PowerPoint to create and modify a 
  presentation and add transition and animation 
  effects.
- Modify the template of an existing presentation 
  by changing its colour scheme and/or background 
  shading.
- Use EXCEL to manipulate functions, formulas, 
  charts, clip art, and maps
- Print large worksheets with formulas or values, 
  headers/footers and gridlines.
- Integrate Excel with other programs and use it 
  to create web pages.
- Use filtering, sorting, subtotalling and pivot 
  table to organize and summarize data.
- Work with shared documents.	


 
            Attitudes
			
Successful students will have demonstrated 
attitudes of:

- attention to detail when creating documents of 
  any kind
- the ability to remain calm when attempting to 
  solve computer-related problems
- confidence in his or her ability to learn a new 
  software application or package
- willingness to assist and teach other users when 
  appropriate
- an understanding of  time management as it 
  relates to the challenges of problem-solving 

Evaluation Plan
Students demonstrate their learning in the following ways:

 
Tests 		80%
Assignments     20%

Course Evaluation Practices:

Please note that the professors teaching this course have agreed to 
the following practices.  We wish to encourage behaviours that will 
help students to be successful in the workplace, and to ensure that 
students receive credit for their individual work.

1. For submission of assignments and projects, the professor will 
   specify, in writing:
	a) due dates and special instructions for submissions
	b) deductions for overdue submissions
2. All assignments must be completed as individual efforts unless the 
   professor states otherwise in writing.
3. Tests must be written as scheduled by the professor. A makeup test 
   will only be provided to students who have an acceptable 
   explanation for their absence, or students who provide acceptable 
   documentation, such as a medical certificate, explaining their    
   absence. These special situations must be arranged as soon as 
   possible with the professor. There may be limitations on timing for 
   makeups.
4. A student must average at least 50% on the tests combined in order 
   to receive credit for this course.

N.B.	Steps to appeal grades and evaluations are found in the 
Student Handbook.
Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

 

Generic Skills
Generic Skills emphasized in the course:

X communication - written   communication - oral   communication - visual
X analytical   creative thinking   decision making
  interpersonal   numeracy X organizational
X problem solving X technological   other (see below)

Notes: N/A

General Education
This General Education course relates to the following themes as specified by the Ministry of Training, Colleges and Universities.

  asthetic appreciation   social understanding
  civic life   understanding science
  cultural understanding   understanding technology
  personal development   work and the economy

Prior Learning Assessment and Recognition
PLAR Contact: Dorothy Marchildon

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: Fall 2004
Professor: Dorothy Marchildon
Textbook(s):
1) Microsoft Word 2002, Expert Certification with CD-ROM by 
Nita Rutkosky.  Publisher EMC Paradigm.  ISBN: 0-7638-14644

2) Microsoft Excel 2002, Core Certification, Mouse Ready CD ROM by 
Nita Rutkosky.  Publisher EMC Paradigm  ISBN:  0-7638-15071

Applicable student group(s): INFORMATION TECHNOLOGIES SUPPORT SERVICES STUDENTS
Course Details:
EXCEL 2002 Topics
7 Preparing and Formatting an Excel Worksheet
7 Maintaining and Enhancing a Worksheet
7 Maintaining Workbooks and Creating Web Pages
7 Moving Data within and between Workbooks
7 Inserting Formulas in a Worksheet
7 Creating a Chart in Excel
7 Integrated Topic:  Inserting Clip Art Images and 
  Creating Maps

WORD 2002 Topics

- Formatting with Special Features
- Merging Documents and Sorting and Selecting Data
- Working with Shared Documents
- Creating Tables and Indexes
- Recording, Running, and Editing Macros
- Creating Fill-In Forms
- Integrated Topic:  Adding Visual Appeal to 
  Documents

PowerPoint 2002 Topics

- Create, modify and view an existing 
  presentation.
- Use the Outline view to add or delete slides
- Add clip art to an existing slide
- Use the Rehearse Timings feature, the Meeting 
  Minder, Slide Navigator and Pen
- Apply a design template to a presentation
- Add transition effects to the slides in a 
  presentation; apply animation effects to the 
  bullets and graphical objects in a specific 
  slide.
- Modify the template of an existing presentation 
  by changing its colour scheme and/or background 
  shading.
- Use a slide master to format a presentation.


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.