MCT102 - Office Applications - II
| Semester | |
| School | |
| Last revision date | 2025-09-22 01:49:29.646 |
| Last review date | 2025-11-10 00:15:14.307 |
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.
Academic Integrity
Seneca upholds a learning community that values academic integrity, honesty, fairness, trust, respect, responsibility and courage. These values enhance Seneca's commitment to deliver high-quality education and teaching excellence, while supporting a positive learning environment. Ensure that you are aware of Seneca's Academic Integrity Policy which can be found at: http://www.senecapolytechnic.ca/about/policies/academic-integrity-policy.html Review section 2 of the policy for details regarding approaches to supporting integrity. Section 2.3 and Appendix B of the policy describe various sanctions that can be applied, if there is suspected academic misconduct (e.g., contract cheating, cheating, falsification, impersonation or plagiarism).
Please visit the Academic Integrity website http://open2.senecac.on.ca/sites/academic-integrity/for-students to understand and learn more about how to prepare and submit work so that it supports academic integrity, and to avoid academic misconduct.
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@senecapolytechnic.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 Accessibility Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.
Camera Use and Recordings - Synchronous (Live) Classes
Synchronous (live) classes may be delivered in person, in a Flexible Learning space, or online through a Seneca web conferencing platform such as MS Teams or Zoom. Flexible Learning spaces are equipped with cameras, microphones, monitors and speakers that capture and stream instructor and student interactions, providing an in-person experience for students choosing to study online.
Students joining a live class online may be required to have a working camera in order to participate, or for certain activities (e.g. group work, assessments), and high-speed broadband access (e.g. Cable, DSL) is highly recommended. In the event students encounter circumstances that impact their ability to join the platform with their camera on, they should reach out to the professor to discuss. Live classes may be recorded and made available to students to support access to course content and promote student learning and success.
By attending live classes, students are consenting to the collection and use of their personal information for the purposes of administering the class and associated coursework. To learn more about Seneca's privacy practices, visit Privacy Notice.
Prerequisite(s)
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
Author: McFedries
Publisher: Microsoft Press
1st Edition
Book 978-0-13-662837-8
eBook 978-0-13-662844-6
MOS Study Guide for Microsoft Excel Expert Exam MO-201
Author: McFedries
Publisher: Microsoft Press
1st Edition
Book 978-0-13-662752-4
eBook 978-0-13-662754-8
MOS Study Guide for Microsoft Access Expert Exam MO-500
Author: McFedries
Publisher: Microsoft Press
1st Edition
Book 978-0-13-662832-3
eBook 978-0-13-662823-1
To find out the cost of books and learning material go here.
Any courses not listed on the bookstore webpage do not require any resources for purchase. All resources will be provided by your instructor.
Student Progression and Promotion Policy
http://www.senecapolytechnic.ca/about/policies/student-progression-and-promotion-policy.html
Grading Policyhttp://www.senecapolytechnic.ca/about/policies/grading-policy.html
| 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.senecapolytechnic.ca/about/policies/academics-and-student-services.html) or at Seneca's Registrar's Offices. (https://www.senecapolytechnic.ca/registrar.html).
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%.