MCT101 - Office Applications

Outline info
Semester
School
Last revision date 2017-07-17 00:00:03.111
Last review date 2017-07-18 10:21:17.921


Subject Title
Office Applications

Subject Description
This subject examines the use of Microsoft Word, Excel and PowerPoint in today's business environment.

Credit Status
This subject is part of the Microsoft Office Recognition of Achievement Program.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Create, edit, save, open and print documents in Word.
2. Create, edit, save, open and print worksheets and charts in Excel.
3. Create, edit, save, open and print presentations in PowerPoint.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

Discrimination/Harassment
All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

Prerequisite(s)
MCT100 or equivalent experience.  

Topic Outline
Microsoft Word

Getting Started

  • Looking at the Screen
  • Working with Text
  • Working with Documents
  • Sharing Documents

 

Manipulating  Text
  • Changing the View 
  • Adjusting the Zoom
  • Working with Multiple Windows
  • Selecting Text
  • Editing Text

 

Working  with Tabs
  • Setting Tab Stops
  • Organizing List Information

 

Formatting Content
  • Formatting Characters
  • Formatting Paragraphs 
  • Using the Format Painter

 

Formatting Documents
  • Setting up the Documemt 
  • Using Headers and Footers
  • Working with Document Backgrounds
  • Using Themes

Getting Ready to Print 
  • Proofing Your Document
  • Preparing to Print

 

Using Tables
  • Working with Tables
  • Inserting a Table
  • Manipulating Tables
  • Sorting Lists of Data

 

Working with Illustrations
  • Inserting Pictures
  • Working with Shape Objects
  • Using SmartArt
  • Adding Captions
  • Using Screenshots

 

Creating Mass Mailing Documents
  • Creating Simple Mailing Documents

 

Sharing Documents
  • Understanding Building Blocks
  • Navigating with References
  • Protecting Documents
  • Recovering Document Versions

 

Microsoft Excel 

Introducting Excel

  • What is an Electronic Spreadsheet?
  • Looking at the Screen
  • Entering Data in a Worksheet
  • Working with Workbooks
  • Selecting Cells

 

Constructing Cell Data
  • Editing Cells and Undoing Changes
  • Copying and Moving Data
  • Inserting and Deleting Rows and Columns
  • Adjusting the Columns and Rows
  • Finding and Replacing Data
  • Using AutoFill
  • Managing Worksheets

Using Formulas
  • Using Formulas
  • Using Functions
  • Using Absolute and Relative Cell References
  • Displaying and Printing Formulas

Formatting the Worksheet
  • Formatting a Cell
  • Clearing Cell Contents and Formatting
  • Themes
  • Using Cell Styles
  • Conditional Formatting

Viewing and Printing Workbooks

  • Changing Worksheet Views
  • Printing and Previewing the Workbook
  • Customizing the Page Layout
  • Changing Excel Default Settings

 

Working with Charts

  • Creating a Basic Chart
  • Moving and Resizing Charts
  • Changing Chart Types
  • Working with Pie Charts
  • Changing the Chart Layout and Location
  • Using Sparklines
  • Printing Charts

 

Working with Graphics
  • Drawing Shapes
  • Modifying Graphics Objects
  • Using SmartArt Graphics

 

Analyzing, Organizing and Sharing Workbooks
  • Sorting Data
  • Filtering Information
  • Working with Named Ranges
  • Using Hyperlinks
  • Using Comments
  • Importing and Exporting Data
  • Sharing Workbooks

 

Microsoft PowerPoint 

Getting Started
  • Looking at the Screen
  • Creating New Presentations
  • Moving Around in Presentations
  • Managing Presentations
  • Creating and Formatting Slides
  • Organizing Slides

Working with Text
  • Adding Text
  • Using Bullets and Numbering
  • Formatting Text
  • Cutting, Copying and Pasting Text
  • Using Text Boxes
  • Using WordArt

 

Working with Illustrations and Other Media
  • Using Pictures
  • Modifying Pictures
  • Inserting Shapes
  • Inserting  Hyperlinks
  • Arranging Illustrations and Shapes
  • Inserting a Photo Album
  • Working with SmartArt
  • Modifying SmartArt Diagrams
  • Inserting Media Clips

 

Working with Charts and Tables
  • Inserting Charts
  • Using Tables

 

Enhancing Presentations
  •  
  • Using Animation
  • Using Slide Transitions
  • Using Slide Masters
  • Adding Presenter Notes

 

Reviewing Presentations
  • Reviewing Presentations
  • Protecting a Presentation
  • Using Document Properties
  • Printing Presentation Items

 

Delivering a Presentation
  • Sharing a Presentation
  • Saving in Other Formats
  • Running the Slide Show
  • Customizing the Slide Show
  • Using Presentation Tools
  • Rehearsing a Presentation
  • Recording a Presentation
  • Using Presenter View

Mode of Instruction
Classroom instruction and extensive hands-on experience will be provided with each participant having exclusive use of a computer. Additional modes of instruction will include class discussion, lecture and question and answer period. 

Prescribed Texts

MOS 2016 Study Guide Microsoft Word
Author:  Lambert
Publisher:  Microsoft Press
ISBN-13: 978-0735699410
ISBN-10: 0735699410


MOS 2016 Study Guide Microsoft Excel
Author:  Lambert
Publisher:  Microsoft Press
ISBN-13: 978-0735699434
ISBN-10: 0735699437


MOS Study Guide Microsoft PowerPoint
Author:  Lambert
Publisher:  Pearson
ISBN-13: 978-0735699403
ISBN-10: 0735699402

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
OR
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.


Modes of Evaluation
This subject is part of the Microsoft Office Program.  Those students choosing to pursue their Microsoft Office Recognition of Achievement must complete 3 tests consisting of:  Word test (25%), Excel test (25%), Word, Excel and PowerPoint final test (50%).  The passing grade for each test is 70% or over.  All courses are graded as SAT (Satisfactory) for students who achieve 70% or higher or UNSAT (Unsatisfactory) for students who achieve less than 70%.  

Approved by: Sharon Estok, Denis Gravelle