Office Admin

COURSE DESCRIPTION

Are you interested in upgrading your business skills, finding new work, re-entering the workforce or earning a certificate for skills you already possess? This is the course for you! Course scheduling is entirely self-directed, meaning days or evenings,you choose. This course is similar to that at the day school, one-year Ontario University Certificate.

ADMISSION QUALIFICATIONS

General computing and keyboard abilities are helpful before beginning this course, but there are no admission prerequisites.

COURSE OF STUDIES

Effective as of fall semester 2012, the course of studies has been modified, but students that started the program before this time will be given opportunities and assistance for completion using similar classes. Consult with your instructor or counselor for help with completion.

Course Syllabus

(click on the module heading to reveal a lesson by lesson breakdown)

MICROSOFT WORD BEGINNER SKILLS

  • Microsoft Word and the Documents it can Create
  • Navigating the Word Screen
  • Open, Enter Text, Save and Print
  • Quiz 1: Word Introduction
  • Alternate Quiz 1.Form A: Word Introduction
  • Alternate Quiz 1.Form B: Word Introduction
  • Font: Basic Editing Features
  • Font Styles and the Clipboard
  • Project: Simulation
  • Quiz 2: Formatting Font
  • Alternate Quiz 2.Form A: Formatting Font
  • Alternate Quiz 2.Form B: Formatting Font
  • Paragraph Formatting Features
  • Page Setup Features
  • Backgrounds and Themes
  • Project: Simulation
  • Quiz 3: Formatting Paragraphs and Pages
  • Alternate Quiz 3.Form A: Formatting Paragraphs and Pages
  • Alternate Quiz 3.Form B: Formatting Paragraphs and Pages
  • Supplemental Project
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MICROSOFT WORD INTERMEDIATE SKILLS

  • Inserting Images into Documents
  • Inserting Shapes, SmartArt and Text Boxes
  • Special Parts in the Word Application
  • Project: Inserting and Modifying Content
  • Quiz 1: Word Intermediate Skills
  • Alternate Quiz 1.Form A: Word Intermediate Skills
  • Alternate Quiz 1.Form B: Word Intermediate Skills
  • Inserting Tables
  • Organizing Content in Tables
  • Project: Tables
  • Quiz 2: Working with Tables
  • Alternate Quiz 2.Form A: Working with Tables
  • Alternate Quiz 2.Form B: Working with Tables
  • Spell Check and Find and Replace
  • Insert Comments and Track Changes
  • Autocorrect Options
  • Project: Review Tab Skills
  • Quiz 3: Autocorrect Options
  • Alternate Quiz 3.Form A: Autocorrect Options
  • Alternate Quiz 3.Form B: Autocorrect Options
  • Project: Collaborating on a Word Document
  • Project: Supplemental Projects
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MICROSOFT WORD ADVANCED SKILLS

  • Merging to Create Labels
  • Merging to Create Letters
  • Project: Creating a Merge
  • Quiz 1: Word Advanced Skills
  • Alternate Quiz 1.Form A: Word Advanced Skills
  • Alternate Quiz 1.Form B: Word Advanced Skills
  • Endnotes and Footnotes
  • Hyperlinks
  • Table of Contents
  • Project: Inserting Special Report Features
  • Quiz 2: References
  • Alternate Quiz 2.Form A: References
  • Alternate Quiz 2.Form B: References
  • Share, Protect, and Modify Document Properties
  • Using and Creating a Template
  • Project: Creating a document template
  • Quiz 3: Backstage View
  • Alternate Quiz 3.Form A: Backstage View
  • Alternate Quiz 3.Form B: Backstage View
  • Project: Unit Simulation
  • Project: Supplemental Materials
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MICROSOFT PUBLISHER APPLICATION

  • Opening and Navigating Publisher
  • Designing Pages
  • Inserting Text
  • Project: Open Publisher, Browse, and Select a Template
  • Quiz 1: Publisher
  • Alternate Quiz 1.Form A: Publisher
  • Alternate Quiz 1.Form B: Publisher
  • Graphics
  • Tables and Building Blocks
  • Project: Inserting Enhancements
  • Viewing a Publication
  • Reviewing a Publication
  • Sharing and Printing Publications
  • Project: Modify and Share a Publication
  • Quiz 2: Publications
  • Alternate Quiz 2.Form A: Publications
  • Alternate Quiz 2.Form B: Publications
  • Project: Design, Edit and Share a Publication
  • Project: Supplemental Activities
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MICROSOFT POWERPOINT APPLICATION

  • PowerPoint Layout and Modifying Views
  • Entering Text and Formatting Slides
  • Quiz 1: PowerPoint Layout and Views
  • Alternate Quiz 1.Form A: PowerPoint Layout and Views
  • Alternate Quiz 1.Form B: PowerPoint Layout and Views
  • Images, WordArt, and SmartArt
  • Charts and Tables
  • Project: Simulation: Creating a Presentation
  • Quiz 2: Charts and Tables
  • Alternate Quiz 2.Form A: Charts and Tables
  • Alternate Quiz 2.Form B: Charts and Tables
  • Transitions and Animations
  • Set up Show and Timings
  • Presentation Tools
  • Saving, Printing, Sharing, and Protecting a Presentation
  • Project: Simulation: Modify, Share, and Deliver a Show
  • Quiz 3: Modify, Share, Deliver a Show
  • Alternate Quiz 3.Form A: Modify, Share, Deliver a Show
  • Alternate Quiz 3.Form B: Modify, Share, Deliver a Show
  • Project: Simulation: Design and Create a Presentation
  • Project: Supplemental Activities
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MIDTERM 1

  • Course Review
  • TestFinal Exam
  • Alternate Final Exam.Form A
  • Alternate Final Exam.Form B

MICROSOFT EXCEL SPREADSHEETS BASICS

  • ReferenceCourse Overview
  • What is a Spreadsheet and What Are Its Uses?
  • Spreadsheet Design and the Microsoft Excel Screen
  • Quiz 1: Overview of Spreadsheet Basics
  • Alternate Quiz 1.Form A: Overview of Spreadsheet Basics
  • Alternate Quiz 1.Form B: Overview of Spreadsheet Basics
  • Navigating in a Worksheet
  • Microsoft Excel Workbook Views
  • Microsoft Excel Window Views
  • Project: Managing the Worksheet Environment
  • Quiz 2: Spreadsheet Basics
  • Alternate Quiz 2.Form A: Spreadsheet Basics
  • Alternate Quiz 2.Form B: Spreadsheet Basics
  • Workbook Properties
  • Saving and File Formats
  • Sharing Worksheet Data with Other Users
  • Managing Comments
  • Printing Worksheets and Workbooks
  • Project: Saving and Printing Microsoft Excel Files
  • Quiz 3: Managing File Settings
  • Alternate Quiz 3.Form A: Managing File Settings
  • Alternate Quiz 3.Form B: Managing File Settings
  • Supplemental Project
  • Supplemental Project
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

CREATING MICROSOFT EXCEL SPREADSHEETS

  • Microsoft Excel Data Types
  • Entering and Editing Cell Data
  • Selecting, Filling, Moving, and Copying Cell Data
  • AutoFill
  • Project: Stock Market Project Part 1 . Researching and Recording Stock Prices
  • Quiz 1: Data Entry
  • Alternate Quiz 1.Form A: Data Entry
  • Alternate Quiz 1.Form B: Data Entry
  • Cell Formats
  • Editing Cells, Rows, and Columns
  • Managing Worksheets
  • Project: Stock Market Project 2 . Formatting a Spreadsheet
  • Quiz 2: Formatting Cells and Worksheets
  • Alternate Quiz 2.Form A: Formatting Cells and Worksheets
  • Alternate Quiz 2.Form B: Formatting Cells and Worksheets
  • Order of Operations
  • Microsoft Excel Formulas
  • Types of Cell References in Formulas
  • Project: Stock Market Project 3 . Entering Formulas
  • Quiz 3: Creating Formulas
  • Alternate Quiz 3.Form A: Creating Formulas
  • Alternate Quiz 3.Form B: Creating Formulas
  • Functions in Microsoft Excel
  • Function Wizard and Linking Formulas
  • Analyzing Data by Sorting and Filtering
  • Project: Stock Market Project 4 . Entering Functions
  • Quiz 4: Utilizing Functions and Data Commands
  • Alternate Quiz 4.Form A: Utilizing Functions and Data Commands
  • Alternate Quiz 4.Form B: Utilizing Functions and Data Commands
  • Project: Budget Project . Career Search
  • Project: Budget Project . Housing Research
  • Project: Budget Project . Vehicle Research
  • Project: Budget Project . Utilities, Vacation, and Miscellaneous Expense Research
  • Project: Budget Project . Final
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MICROSOFT EXCEL GRAPHICAL REPRESENTATIONS

  • Why Use Graphical Representations of Data?
  • Creating Charts
  • Quiz 1: Creating Charts in Microsoft Excel
  • Alternate Quiz 1.Form A: Data Entry
  • Alternate Quiz 1.Form B: Data Entry
  • Formatting Charts
  • Enhancing Charts with Illustrations
  • Formatting Illustrations
  • Project: Stock Market Project Part 5 . Creating and Enhancing Charts
  • Quiz 2: Enhancing Microsoft Excel Charts
  • Alternate Quiz 2.Form A: Enhancing Microsoft Excel Charts
  • Alternate Quiz 2.Form B: Enhancing Microsoft Excel Charts
  • Creating Picture Charts
  • Sparklines
  • Project: Stock Market Project Part 6 . Creating Advanced Charts
  • Quiz 3: Advanced Charting Options
  • Alternate Quiz 3.Form A: Advanced Charting Options
  • Alternate Quiz 3.Form B: Advanced Charting Options
  • Project: Research and Chart Product Price Comparisons
  • Project: Chart Budget Expenses
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MICROSOFT ACCESS DATABASE BASICS

  • What is a Database and Its Uses?
  • Database Design
  • Field Names, Data Types, and Properties
  • Project: Designing a Customer Information Database
  • Quiz 1: Database Design
  • Alternate Quiz 1.Form A: Database Design
  • Alternate Quiz 1.Form B: Database Design
  • The Access Screen
  • Navigating in Table Datasheets, Forms, and Reports
  • Working in the Navigation Pane
  • Save Options and Compact and Repair
  • Project: Managing the Access Environment
  • Quiz 2: Managing the Access Environment
  • Alternate Quiz 2.Form A: Managing the Access Environment
  • Alternate Quiz 2.Form B: Managing the Access Environment
  • Creating an Access Database and Table
  • Entering Data
  • Modifying a Table
  • Importing Data from an Excel File
  • Sorting and Filtering
  • Creating Relationships
  • Project: Creating Customer Information Database
  • Quiz 3: Creating an Access Database
  • Alternate Quiz 3.Form A: Creating an Access Database
  • Alternate Quiz 3.Form B: Creating an Access Database
  • Project: Designing an Address List Database
  • Project: Creating an Address List Database
  • Project: Designing and Creating an Inventory Database
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MICROSOFT ACCESS FORMS, QUERIES, AND REPORTS

  • Creating Forms
  • Editing the Design of a Form
  • Creating Multi-table Forms
  • Editing Multi-table Forms
  • Project: Address List Forms
  • Quiz 1: Microsoft Access Forms
  • Alternate Quiz 1.Form A: Microsoft Access Forms
  • Alternate Quiz 1.Form B: Microsoft Access Forms
  • Creating Simple Queries
  • Creating Advanced Queries
  • Creating Multi-table Queries
  • Calculating Totals in a Query
  • Creating Calculated Fields in a Query
  • Project: Address List Queries
  • Quiz 2: Microsoft Access Queries
  • Alternate Quiz 2.Form A: Microsoft Access Queries
  • Alternate Quiz 2.Form B: Microsoft Access Queries
  • Creating Reports
  • Editing the Design of a Report
  • Sorting and Filtering Records in a Report
  • Creating Multi-table Reports
  • Editing the Design of a Multi-Table Report
  • Project: Address List Reports
  • Quiz 3: Microsoft Access Reports
  • Alternate Quiz 3.Form A: Microsoft Access Reports
  • Alternate Quiz 3.Form B: Microsoft Access Reports
  • Project: Creating Forms for the Address List Database
  • Project: Creating Queries for the Address List Database
  • Project: Creating Reports for the Address List Database
  • Special Project
  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B
  • Reference / Glossary and Credits

MIDTERM 2

  • Review
  • Test
  • Alternate Test.Form A
  • Alternate Test.Form B