MCT101 - Office Applications I
| Semester | |
| School | |
| Last revision date | 2025-09-22 01:49:36.189 |
| Last review date | 2025-11-10 00:15:14.295 |
Subject Title
Office Applications I
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.
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)
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 Study Guide for Microsoft Word Exam MO-100
Author: Lambert
Publisher: Microsoft Press
1st Edition
Book 978-0-13-662804-0
eBook 978-0-13-662796-8
MOS Study Guide for Microsoft Excel Exam MO-200
Author: Lambert
Publisher: Microsoft Press
1st Edition
Book 978-0-13-662715-9
eBook 978-0-13-662722-7
MOS Study Guide for Microsoft PowerPoint Exam MO-300
Author: Lambert
Publisher: Microsoft Press
Published 9/4/2020
1st Edition
Book 978-0-13-662810-1
eBook 978-0-13-662812-5
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 must complete 3 tests consisting of: Word test (25%), Excel test (25%), Word, Excel and PowerPoint final test (50%).