Camosun logo for print

MS-Office

Program Courses

Develop your software skills

Starting with file management and MS-Office Starting Strong, you'll take 150 hours of required face-to-face courses, spend about 30 hours on take-home assignments before finishing up with your self-directed 36 hours completion project to showcase your new skills.

File Management or File Management for Mac • BSCM 504V or 505V (6 hours) Schedule

You know your files are in that computer, but can you find them easily? If you own a computer, then you need to really understand how and why to plan your e-filing system, and how to confidently move, copy, paste, rename and burn files and folders to CD. Learn these and many more time saving tips and tools. These skills are prerequisite to all other software courses. Applicable to all current versions of Windows. An electronic course manual (pdf) is included.

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Understand the files system of Windows: files, folders, drives/disks and paths
  • Identify the elements of a window
  • Expand/Compress folders and use view and folder commands/ options
  • Find data using search.  Customize a search – use wild cards and alter advanced options.  Sort a search
  • Identify file associations and extensions
  • Use program shortcuts to desktop/start menu
  • Select, arrange and sort files
  • Create, move, copy and backup files, folders, storage devices
  • Burn a CD – backup/duplication
  • Create compressed files (zip)
  • Rename and delete a file/folder
  • Restore/Empty the recycle bin
  • Create/change/delete shortcuts to data files and folders
  • Navigate between folders within a software application
  • Use disk management features: Scan disk and defragmentation

Prerequisite: BSCM 501G or BSCM 503G. You must be able to: identify parts of a window (title bar, status bar, tool bar, menu bar; ribbons, control buttons); cut and paste text between windows; save, open and close files; resize and switch between windows; confidently use a mouse to click, drag, double-click, and use right-click to access shortcut menus.


MS-Office Start Strong • BSCM 543V (6 hours) Schedule

Take a big-picture look at the mammoth MS-Office suite of software to see the impact that learning these software products will have on your business or career. Includes computer tips (e.g., file storage options including cloud, using dual monitors, and gathering resources and data from the web) and practical info on how to be successful in the MS-Office certificate program assignments and completion project (e.g., communicate effectively with your tutor, choosing a project topic, and how to access Camosun services). You will learn to use Acrobat Reader software to navigate and annotate electronic, PDF versions of courses manuals now provided to students in the program. You must have a web-based email account such as Gmail in place for use in class. An electronic course manual (pdf) is included.

Course Learning Outcomes

  • Plan for success with assignments and completion project
  • Know where and how to access Camosun services
  • Review of key Windows skills for PC and Mac users:
  • Identify the operating system and software versions on any computer
  • Discuss storage options
  • Manage multiple open windows
  • Gather resources and data from the Internet for the assignments and completion project
  • Effectively use Acrobat Reader with electronic course manuals
  • Set up, navigate and use tools within Adobe Reader
  • Annotate PDF documents
  • Use bookmarks and typewriter tool
  • Use a Drop Box to manage your files

Prerequisite: BSCM 504V or BSCM 505V


Word - Level 1 • BSCM 561V (12 hours) Schedule

You may have used Word before but are you getting the most you can from the software? Get a solid foundation with Word that will help you see when and how to use Word features to automate and accelerate your ability to enter and format text and data. You'll use these skills every time you open Word! Do graphics frustrate you? Learn how to position, size, and enhance pictures and images, then choose the right text wrapping options so your picture stays where you place it. An electronic course manual (pdf) is included.

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Understand and navigate the Word interface (ribbon, tabs, groups, help)
  • Create, print and save documents (includes system default file location, why and how to save in different formats)
  • Open and edit a document
  • Insert, delete, move, copy, find, replace and spell check text (includes Autocorrect, thesaurus, language and date features)
  • Format characters (includes adjust font and font size, change character format such as bold or italic, insert international characters)
  • Format paragraphs (includes indents, alignment, tabs, line spacing, borders, numbered and bulleted lists)
  • Format pages (includes page breaks, go to feature, margins, orientation, manual page breaks, page numbering)
  • Work with graphics (introduction to images and shapes and text boxes): Describe default settings for graphics in Word
    • Insert text boxes and images and edit using picture tools:
    • Move, copy, crop, adjust brightness and contrast
    • Position and size graphic, then select appropriate text wrapping
    • Select, group and order graphics and use the drawing canvas

Prerequisites: BSCM 504V


Word - Level 2 • BSCM 562V (18 hours) Schedule

Are you using the most powerful features of Word? This course is filled with ways to economize your time, organize your data and glamorize your documents. Automate repetitive text entry by creating building blocks with AutoText, AutoFormat and Macros. Generate a Table of Contents in three steps. Really take advantage of the power of styles to generate consistent formatting without needless repetition for small and very large documents. Maximize and advance your use of tables to organize data, create forms and catalogues. Fine tune the look of your documents using column and layout options, section breaks, WordArt, themes and templates. An electronic course manual (pdf) is included.

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Manage multi-page documents including efficient use of section breaks
  • Understand when, why and how to use styles (includes modify, rename and select themes)
  • Add a Table of Contents (includes mark text, apply different page numbering, add chapter numbers and other customization)
  • Insert and edit tables (includes create; format; modify; sort; rotate; split cells, rows, and tables; prevent row splitting; control text alignment; apply styles; convert table to text and text to table)
  • Sort a document (by paragraph, column or specific word)
  • Use the Track Changes feature effectively (includes balloons and accept/reject changes)
  • Add and edit headers and footers (includes odd/even and first page settings, insert fields such as file name and path, page numbering options)
  • Work with columns (includes adjust and control balance, length, force text to next column, add graphic line and change spacing between columns)
  • Create and modify  WordArt
  • Plan, create, control and edit a mail merge (includes main document and data source, including databases external to Word)
  • Customize the Word ribbon tabs, groups and commands (e.g., add or change the order of command icons)
  • Eliminate or automate repetitive text entry (includes AutoFormat, Building Blocks, AutoText, Signature)
  • Understand when, why and how to create and run a macro
  • Add and edit footnotes and convert to end notes (includes number styling)
  • Remove confidential information
  • Locate, select, edit or create templates

Prerequisites: BSCM 561V. You must be able to format fonts; customize paragraph formats (indents, alignments, bullets, numbering, borders); modify margins, orientation and borders; add page numbers; insert section breaks.


Excel - Level 1 • BSCM 511V (12 hours) Schedule

Whether you manage your own finances, run a business or a large organization, this course will give you the skills you need to have Excel do your calculations. Each topic is designed to save you time and ensure the integrity of your data. Use AutoFill, number styles, relative and absolute cell referencing, and many more commands to reduce typing and increase accuracy. Know how and when to apply functions (e.g. average, sum, count, min, max) to calculate your data; simplify your formatting, and create charts to visually represent your numbers. An electronic course manual (pdf) is included.

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Understand and navigate the Excel interface (workbooks vs. worksheets, ribbon, tabs, groups, help)
  • Create, save, close, open, rename and delete workbooks and worksheets
  • Select and modify cells (adjacent and non-adjacent) and define cell and range references
  • Enter and edit text, values, dates, times, symbols, special characters and functions
  • Use AutoFill and other fill commands
  • Understand and apply the order of mathematical operations (BEDMAS)
  • Manage worksheets:
    • Insert, hide, delete and adjust rows and columns
    • Switch between open workbooks
    • Group worksheets
  • Apply character, number and cell formatting, and understand how themes work
  • Define number styles (accounting, comma, percent, date)
  • Use  Format Painter to copy formatting
  • Apply page set up and printing layout options:
    • Preview and print worksheets/workbooks
    • Customize printing and add headers/footers
  • Understand and use relative, absolute and mixed cell references in formulas:
    • Describe when and how to use relative vs. absolute references
  • Use introductory Excel functions (sum, average, count, max, min, round)
  • Create and modify introductory charts (column, pie, line and other chart types)
  • Document a workbook

Prerequisites: BSCM 504V.


Excel - Level 2 • BSCM 512V (18 hours) Schedule

Realistic examples will be used to demonstrate ways to build on your basic knowledge of Excel to increase your productivity. Use powerful logic functions such as "IF" to identify conditions met or not met for specific criteria. Determine if you can afford a loan with financial payment functions. Use conditional formatting tools to easily identify key indicators for your business such as top 10, or highest average, based on your unique criteria. Link and group worksheets, use named ranges to quickly locate data, and use powerful database techniques that include data validation, sorting and filtering and many more Excel topics. You must be familiar with AutoSum, AutoFill, how to create a basic chart and understand the difference between relative and absolute referencing. An electronic course manual (pdf) is included.

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Create and modify charts (includes format titles, axis, scale, areas and data labels)
  • Use functions including conditional formatting with:
  • Financial functions for future value, payment, interest and principle payments (FV, PMT, IPMT, PPMT)
  • Review of Statistical functions (AVG, COUNT, MIN, MAX, SUM) (taught in-depth in Excel 1)
  • Median and Logical functions (IF, COUNTIF, SUMIF, AND, NOT, OR)
  • Date and time functions (NOW, TODAY)
  • Text functions (TRIM, UPPER, LOWER, CONCATENATE) and vertical lookup (VLookup)
  • Create and edit hyperlinks to text and graphics within a workbook and to other files
  • Link and group worksheets and workbooks
  • Use Excel tables as a database:
  • Create tables and data forms
  • Sort with single and multiple fields
  • Filter and subtotal within databases
  • Create pivot tables and pivot charts (overview only)
  • Apply data validation:
  • Restrict cell entries to the data from a list
  • Use a formula to validate data
  • Find cells with data restrictions
  • Work effectively with large worksheets (includes freeze panes, adjust page order, print titles, display row and column headings, insert page breaks and define print areas)
  • Create and edit templates
  • Protect and hide worksheets and workbooks
  • Use advanced options (includes custom lists)
  • Name ranges and use paste special
  • Work with themes
  • Understand when, why and how to create and run a macro
  • Apply and create web queries

Prerequisites: BSCM 511V You must be familiar with autosum, autofill, how to create a basic chart and understand the difference between relative and absolute referencing.


Access - Level 1 • BSCM 521V (18 hours) Schedule

Databases play a vital role in the business operations of most organizations. They are the central repository for critical information on products, customers, suppliers, sales, and a host of other essential information. Learn how a relational database works while learning to use Microsoft Access. Plan and build tables (naming conventions, data types, primary keys, importing, and table relationships). Learn how to find and sort records. Work with forms to ease data entry and design reports to make your data readable and professional. Not a developers course (data modelling not included). Purchase the required textbook before the first class at Lansdowne bookstore (closed Saturdays).

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Navigate the Access interface (ribbon, tabs, groups, help)
  • Explain how a relational database management system works (overview only)
  • Explain database objects (tables, forms, reports and queries)
  • Manage database files (includes opening, saving, publishing and backing up a database)
  • Use the navigation pane (view, copy, rename and delete objects)
  • Build tables from an existing database model (includes planning, naming rules and conventions, data types, creating/modifying in design view, primary keys, table relationships, entering records, importing data, working with records)
  • Retrieve data (includes find and sort records, create and modify queries and lookup queries, add query criteria, concatenation and perform calculations in queries)
  • Create, modify and apply formatting to form types and views.
  • Create, modify and apply formatting to reports.

Prerequisites: BSCM 511V or BSCM 561V


PowerPoint - Level 1 • BSCM 531V (12 hours) Schedule

Be kind to your audience – no more "death by dull PowerPoint!" In this course you will learn to consider your target audience, and then plan a dynamic, engaging presentation with-appropriate background theme, graphics, transitions, animation and sound. You will create consistency by designing your slide master for repeat elements. Use picture tools to position, size and enhance images including SmartArt, WordArt and the insertion of tables and charts from Excel or Word. Confidently save/package your presentation so that it opens perfectly when it's time to present, even on a different computer. An electronic course manual (pdf) is included.

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Define the target audience for your PowerPoint presentation, and choose designs/themes/content appropriate to your audience
  • Understand and navigate the PowerPoint interface (ribbon, tabs, groups, help)
  • Apply presentation layout features (includes select, edit and change slide layouts; use placeholders)
  • Create and modify themes using the Slide Master to manipulate all slides
  • Arrange and print a presentation (includes use slide views, print slides including notes and handout pages, create handouts in Word)
  • Edit presentation (includes apply and change themes, customize slide backgrounds and colour, use slide numbering and footer features)
  • Create, edit and label tables and charts
  • Update presentation
  • Work effectively with graphics within PowerPoint:
  • Understand common types of graphic files (e.g., bitmap, jpg, gif – overview only)
  • Use picture tools to resize, move, copy, crop, adjust brightness and contrast
  • Download graphics safely and legally from the Internet
  • Create and manipulate SmartArt and WordArt (includes how to convert bullets to SmartArt)
  • Insert, edit, format, and manipulate text boxes, shapes and objects
  • Use grid lines, save slides as images, insert hyperlinks and assign actions to graphics
  • Customize formatting
  • Apply transitions, animation and sound (includes custom animation, build bullets, change animation order)
  • Automate a presentation
  • Create speaker notes
  • Package a presentation to CD or thumb drive

Prerequisites: BSCM 504V and BSCM 561V


Publisher • BSCM 532V (12 hours) Schedule

Do you want your work to look more professional than a Word document? Learn to do your own desktop publishing to create graphically rich newsletters, advertisements, brochures, business cards, postcards, calendars and many other types of branded publications. Build master pages, create and modify templates, design new objects once then save for reuse in your building blocks gallery, insert "pull quotes" and side bars, manage linked text boxes, use automated visual inspection tools, use bulk mail merge techniques and create single web pages fast. An electronic course manual (pdf) is included.

  • Create and modify publications from templates and from scratch including newsletters, postcards, calendars, flyers and business cards
  • Consider basic principles of design (overview only)
  • Work effectively with graphics within Publisher:
  • Understand common types of graphic files (e.g., bitmap, jpg, gif – overview only)
  • Insert, edit, format and manipulate a wide variety of objects including text boxes, tables, shapes and objects
  • Resize, move, copy, crop, adjust brightness and contrast pictures and graphics
  • Layer and group objects
  • Use and design objects and add to building blocks gallery
  • Manipulate and customize color and font schemes
  • Manipulate text (e.g., flowing text from one text box to another) and set defaults for objects such as text boxes, so they are drawn with default colors and size
  • Create Master Pages (includes headers/footers and background content)
  • Use Visual Inspection tools (Design Checker and Graphics Manager)
  • Use bulk mail techniques using merge with a new or existing database created in MS-Office (Word, Excel )
  • Create web pages and email newsletters (includes hyperlinks)

Prerequisite: BSCM 561V


OneNote • BSCM 544V (6 hours) Schedule

Complex projects can have relevant information spread across many different sources: the Web, Word and Excel documents, PDFs, video clips, and more. OneNote is a free-form information gathering tool that lets one or more people work on a document that pulls from many different sources. Learn to create, organize and search notes, templates, sub pages and tags; integrate with Outlook, and share data with those who don't have OneNote. Purchase required textbook before first class at Lansdowne Bookstore, 250-370-3080 (closed Saturdays). You will need your web accessible Email account/password in class. 

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Understand and navigate the OneNote interface (ribbon, tabs, groups, help)
  • Create Notebooks and Pages in Notebooks
  • Gather, edit and format data (includes bulleted and numbered lists, Quick Styles, Note Containers; attach, insert and link MS-Office files, including Excel and PowerPoint integration) and  insert web content, pictures, audio, video, tables, and screen clippings
  • Organize Notes (includes apply Notebook Templates, use SubPages, create sections by project or topic, use unfiled notes section, move Notes between sections, navigate sections, apply section groups)
  • Use search options effectively
  • Use OneNote Tools (Calculator, Drawing Tools, Password Protection)
  • Use OneNote with Outlook (includes create Outlook Tasks from OneNote, create linked notes for meetings and contacts, send email to OneNote, email Notes from OneNote)
  • Send OneNote data to others who don't have OneNote, publish as PDF, send to Word
  • Tag Items effectively (includes use tags to find items, tag content in MS-Office files, create custom tags, annotate printouts)
  • Share Notebooks (includes merge changes, highlight unread changes, find edits by date or author)

Prerequisites: BSCM 561V


Outlook - Beyond Email • BSCM 545V (12 hours) Schedule

Are you drowning in email? Learn many ways to save time with Outlook software. Use rules, alerts and QuickSteps effectively. Organize your addresses and contacts into categories and groups, and activate the business card feature. Use powerful functions to more easily schedule group meetings when everyone is available. Adjust settings and permissions to display other's calendars, assign delegates, use signature and voting options in messages, use merge to automate and personalize large mailings, and archive effectively without fear of losing your data. An electronic course manual (pdf) is included.

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Understand and navigate the Outlook interface (ribbon, tabs, groups, help)
  • Create and send email (includes mail format, read receipts, voting buttons, spell check, set default options, manage attachments including zipping, signature blocks, recall unread messages, use auto reply, set permissions to inbox [overview only], use forms templates, create and use Out of Office replies)
  • Manage read messages (includes save attachments; sort, filter and arrange fields; select categories; create, move, sort and search folders; find messages; set rules; use flags; delete and retrieve deleted mail)
  • Work with addresses and contacts (includes change views; create, add and edit contacts, categories, activities, business cards and groups [previously called distribution lists]; customize company information)
  • Use Calendar (includes change views; add, edit and remove appointments including recurring appointments; set work hours; add statutory holidays; set permissions; assign delegates; display and share another's calendar; use schedule functions; request and accept meetings; request notifications)
  • Use Tasks and Journals (includes create, edit, display, add, assign tasks with reminders; add, display and record Journal items manually and automatically; use notes)
  • Direct email automatically with rules, alerts and QuickSteps (includes create and manage QuickSteps, create and manage rules)
  • Manage Outlook data (includes use mailbox cleanup, archive, import and export data)
  • Merge email with Outlook (includes understand the merge feature and merge contacts from Word)

Prerequisites: BSCM 561V


MS-Office Integration • BSCM 550V (12 hours) Schedule

Unleash the power of MS-Office by sharing content seamlessly between applications using linking and embedding features. Here are a few of the many skills you will learn: use Word or Publisher to design your report, and Excel to do the math; take data from Access and analyze it in Excel; use PowerPoint to graphically enhance your financial data and Excel charts; use Outlook, Access or Excel as a data source in a merge with Word. Purchase the required textbook (approx. $45) before the first class at Lansdowne Bookstore (closed Saturdays).

Course Learning Outcomes

Upon completion of this course, learners will be better able to:

  • Define and compare linking to embedding
  • Define objects
  • List linking and embedding procedures
  • Maintain compatibility with previous versions of Office
  • Integrate Word with other programs
  • Embed and link Excel objects
  • Use Excel as a Mail Merge data source
  • Integrate Word with PowerPoint (includes use Word Outline view and add a PowerPoint presentation to a Word document)
  • Create web pages from Word documents
  • Integrate Excel with other programs
  • Check Excel version compatibility
  • Convert workbooks to other file formats
  • Share Excel data with Access
  • Insert Excel charts in PowerPoint
  • Import external data
  • Save workbook elements as a web page
  • Integrate PowerPoint with other programs
  • Create a presentation outline and handouts in Word
  • Embed an Excel worksheet
  • Integrate Access with other programs
  • Integrate Access with Word (includes merge Access data with Word, publish data to Word, copy data from Access to Word)
  • Integrate Access with Excel (includes import from Excel, export Access data to Excel, link Excel worksheet to Access database)
  • Collect data using Outlook (includes set up to collect data, send a request for data - overview only)
  • Display Access data on the web and import  HTML file

Prerequisites: Level 1 skills in Word, Excel, Access and PowerPoint.


MS-Office Course Assignments • BSCM 559V (30 hours - self directed) Schedule

For those pursuing the MS-Office Certificate program, a take home assignment is required after completing each course. Knowledge, questions and exercises will reinforce your learning and help you prepare for the completion project. Fee includes all assignments for up to two years. Please submit a College application form with your registration fee: $41. Start anytime! Schedule Details


MS-Office Completion Project • BSCM 540V (36 hours - self directed) Schedule

This exciting self-directed project is the final requirement in the MS-Office program and requires that you integrate the skills you have developed throughout your training. You will choose a business (fictitious or real) and build a portfolio of documents for the business that demonstrate your ability to use and integrate Word, Excel, PowerPoint, Publisher, Outlook, OneNote and Access. A handbook that lists all required elements is provided, and a tutor is available by email to answer your questions. Your project must be completed within two months of registering. Proof of completion of all courses in the program is required prior to registering. Email sofbus@camosun.ca or call 250.370.4565 for details. Start anytime.

This excerpt is a small sample from the completed project of a recent MS-Office Certificate program graduate.

Prerequisites: Completion of all the above course and assignments.

Contact Us
Camosun College Lansdowne
3100 Foul Bay Rd
Victoria BC V8P 5J2
Camosun College Interurban
4461 Interurban Rd
Victoria BC V9E 2C1
  • 250–370–3000
  • 1–877–554–7555 (toll-free)

©1996–2017 Camosun College | Victoria BC, Canada | Printed: November 19, 2017 at 8:20 pm Change Everything logo for print