Microsoft Office Specialist Prep Certificate

Last updated 6/2/2015

Certificate Code: 5858

Program Contacts:
QC Campus
Debbie Collins, 309-796-5316, collinsd@bhc.edu
Jamie Hill, 309-796-5284, hillj@bhc.edu


The Microsoft Office Specialist Prep certificate prepares the students for Microsoft’s MOS certification exam in the selected office application. Courses in this certificate align with the learning objectives of the exam. A MOS certificate demonstrates to employers your expertise in the software.

Microsoft Office Specialist Prep Certificate
Certificate Code: 5858
Course of Study Outline – Suggested Courses (Credit Hours)
First Semester
Select 10 credits from the following courses
BE 145 — Microsoft Word or (1-3)
BE 145 A, B, C — Microsoft Word I, II, III
BE 146 — Excel for Business (3)
BE 164 — Introduction to Database Management (3)
CIP 201 — Microsoft Project (1)
CIP 127 — Microsoft Outlook (1)
CIP 190 — Team MS Office/Sharepoint (3)
CIP 151 — Advanced Office Applications w/VBA (3)

Minimum total hours required for certificate (10)

Courses for this program include: »

BE 145 Microsoft Word
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Students learn word processing software most commonly found in area offices.

BE 145A Microsoft Word I
1 cr. hr.;
1 lecture hour; 0 lab hours per week.
Students learn word processing software most commonly found in area offices.

BE 145B Microsoft Word II
1 cr. hr.;
1 lecture hour; 0 lab hours per week.
Students learn word processing software most commonly found in area offices.

BE 145C Microsoft Word III
1 cr. hr.;
1 lecture hour; 0 lab hours per week.
Students learn word processing software most commonly found in area offices.

BE 146 Microsoft Excel
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Use of current spreadsheet software on microcomputers.

BE 164 Introduction to Database Management
1 cr. hr.;
1 lecture hour; 0 lab hours per week.
Includes features of current Windows-based database management software.

CIP 127 Microsoft Outlook
1 cr. hr.;
1 lecture hours; 0 lab hours per week.
This course will prepare students for the Microsoft Office Specialist certification exam in Outlook. Topics include managing the Outlook environment, creating and formatting content, working with tasks, notes, and journal entries, and managing e-mail, contacts, and calendar objects.

CIP 151 Adv Office Applications w/VBA
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Prerequisites: CIP 101 or CIP 104 and CS 100 or ENGT 105 or CIP 190 or instructor consent.
Students will learn to automate Microsoft Office applications using VBA (Visual Basic for Applications).

CIP 190 Team MS Office/SharePoint
3 cr. hrs.;
2 lecture hours; 2 lab hours per week.
This course introduces Cloud computing applications with the Microsoft Office 365 documents, SharePoint, Outlook, and Lync creating and managing SharePoint web sites, creating and sharing documents created in Office 365.

CIP 201 Microsoft Project
1 cr. hr.;
1 lecture hours; 0 lab hours per week.
Prerequisite: Working knowledge of Microsoft Windows OS.
Develop an understanding of and ability to use Microsoft project in managing projects. Case studies will be Information Technology focused projects.