MCT102 - Office Applications - II

Outline info
Last revision date 2018-07-20 11:58:19.755
Last review date 2018-07-20 11:58:28.672

Subject Title
Office Applications - II

Subject Description
Further your experience using Microsoft Word and Excel plus an introduction to Access.

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. Use intermediate features of Word.
2. Use intermediate features of Excel.
3. Use introductory features of Access.

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 for further information regarding cheating and plagiarism policies and procedures.

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

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.

Office Applications I - MCT101 or equivalent experience.

Topic Outline

Microsoft Word 

Sharing and Maintaining Documents

  • Changing Word Options
    • Changing the Proofing Tools
  • Working with Templates
    • Managing Templates
    • Restricting Document Access
    • Using Protected View

Formatting Content
  • Formatting with Styles
    • Using Quick Styles
    • Creating Styles
  • Using Quick Parts
  • Working with Tables
    • Inserting Formulas 
  • Working with Charts
    • Adding Chart Elements
    • Saving a Chart as a Template
  • Working with Text Boxes
    • Linking Text Boxes

Tracking and Reviewing Documents
  • Reviewing Documents
    • Setting Tracking Options
    • Tracking Changes
    • Reviewing a Document from Others
    • Comparing or Combining Documents
  • Referencing Information Sources
    • Inserting Citation Sources
    • Working with Captions
    • Listing Your Sources
    • Inserting a Bibliography
    • Managing Your Sources
    • Using Cross References
  • Creating an Index
    • Marking Index Entries
    • Generating an Index
    • Updating and Editing an Index

Merging Documents

  • Merging with Forms
    • Merging with Outlook Contacts
    • Merging to Envelopes
    • Merging to Labels
    • Setting Rules for Merges

Using Forms and Macros

  • Creating Online Forms
    • Locking the Form
    • Filling in Forms
  • Explaining Macros
    • Recording Macros
    • Running Macros
    • Editing Macros
    • Applying Security for Macros
    • Assiging Macros to the Quick Access Toolbar
    • Assigning Macros to Ribbon Buttons

Microsoft Excel 

Presenting Data Visually 

  • Customizing Charts
  • Using sparklines
  • Creating and Using Chart Templates
  • Using Trendlines
  • Using Custom Cell Formats
  • Using Tables
  • Using Dynamic Charts

Sharing and Protecting Workbooks

  • Working with Templates
  • Using XML
  • Workgroup Functions
  • Protecting Your Workbook

Applying formulas and Functions

  • What are Functions?
  • Using Math and Trigonometric Functions
  • Using Statistical Functions
  • Working with Financial Functions
  • Using Logical Functions
  • Using Date and Time Functions
  • Using Text Functions
  • Using Information Functions
  • Converting Data Types
  • Using Advanced Functions
  • Auditing a Worksheet

Data Analysis

  • What-If Analysis
  • Using the Goal Seek Tool
  • Using the Solver
  • Using a Data Table
  • Working with Scenarios
  • Analysis ToolPak 
  • Using Array Formulas
  • Outlining
  • Advanced Filtering
  • Using PivotTables
  • Using Data Slicer with a PivotTable
  • Using Slicers on Exrernal Data Connections
  • Using Cube Functions

Macros, Forms, and Data Consolidation

  • Macros
  • Adding Form Controls
  • Data Validation
  • Using Pick Lists
  • Circling Invalid Data
  • Removing Duplicate Rows
  • Setting Advanced Excel Options

Microsoft Access 

Exploring the Access Environment

  • An Introduction to Databases
  • What is Access?
  • Database Objects
  • Components of the Access User Interface
  • Looking at the Screen
  • The Access Startup Screen
  • Managing Database Files
  • Using the Navigation Pane
  • Setting Access Options

Building Tables

  • Table Basics
  • Data Types
  • Creating Tables in Design View
  • Modifying Tables in Design View
  • Primary Keys
  • Creating Tables in Datasheet View
  • Reusing Design Elements
  • Entering Records in Datasheet View
  • Importing Data
  • Working with Records
  • Table Relationships
  • Viewing Related Data

Retrieving the Data You Want

  • Retrieving Data
  • Finding Records
  • Sorting Records
  • Filtering Records
  • Creating Queries
  • Modifying Queries
  • Adding Query Criteria
  • Working with Joined Tables
  • Performing Calculations in Queries
  • Creating Action Queries
  • Creating Crosstab Queries

Working with Forms

  • Why Use Forms?
  • Form Types
  • Form View
  • Creating Forms Using Automated Form Tools
  • Subforms
  • Using the Form Wizard
  • Creating Forms from Scratch
  • Modifying Forms
  • Adding Controls from the Ribbon
  • Applying Formatting and Design Options
  • Navigation Forms

Designing Reports

  • What is a Report?
  • Report Views
  • Creating Reports
  • Creating a Report Using the Report Wizard
  • Creating a Blank Report
  • Working with Reports in Layout View
  • Working with Reports in Design View
  • Adding Finishing Touches to Reports
  • Sorting and Filtering Records for Reporting
  • Previewing and Printing Reports

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 Expert
Author:  Pierce
Publisher:  Pearson Education
ISBN-13: 978-0735699359
ISBN-10: 0735699356

MOS 2016 Study Guide Microsoft Excel Expert
Author:  Dodge
Publisher:  Microsoft Press
ISBN-13: 978-0735699427
ISBN-10: 0735699429

MOS 2016 Study Guide Microsoft Access
Author:  Pierce
Publisher:  Pearson Education
ISBN-13: 978-0735699397
ISBN-10: 0735699399

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)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online ( 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 are required to complete 3 tests consisting of:  Word test (25%), Excel test (25%), Word, Excel and Access 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