Events

 
SMTWTFS
21
View all »

Tutoring

Microsoft Office Specialist Prep Certificate

Last updated 5/29/2014

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 — Information Processing  or  (1-3)
BE 145 A, B, C — Information Processing I, II, III
CIP 130 — Microsoft Excel (3)
CIP 126 — Microsoft Access (3)
CIP 201 — Microsoft Project (1)
CIP 127 — Microsoft Outlook (1)
CIP 190 — Microsoft SharePoint (3)
CIP 151 — Advanced Office Applications w/VBA (3)

Minimum total hours required for certificate (10)

Courses for this program include: »

BE 145  Information Processing
1-3 cr. hrs.;
1-3 lecture hours; 0 lab hours per week.
Prerequisites: BE 141 “C” or better or instructor consent.

Students learn word processing software most commonly found in area offices. This course is equivalent to BE 145A, 145B, and 145C.

BE 145A Information Processing 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  Information Processing 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  Information Processing III
1 cr. hr.;
1 lecture hour; 0 lab hours per week.
Students learn word processing software most commonly found in area offices.

CIP 126 Microsoft Access
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Analysis of procedures, personnel, and hardware necessary in electronic database processing. Topics covered include review of design, creation, and maintenance of databases including a study of tables and data validation, relationships, queries, forms, reports, macros, SQL, and normalization of tables.

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 130 Microsoft Excel
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
Spreadsheet analysis is designed for both the novice and experienced user of spreadsheets. Students learn a systematic procedure for formulating and solving business problems using current spreadsheet software.

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 CIP 130 or CIP 126 or CS 100 or ENGT 105 or instructor consent.
This is an advanced course in Microsoft Office applications that prepares students for Microsoft Certified Application Specialist (MCAS) certification exam in Word, Excel, and Access. Student will learn to automate Microsoft Office applications using VBA (Visual Basic for Applications).

CIP 190 Microsoft SharePoint
3 cr. hrs.;
3 lecture hours; 0 lab hours per week.
This course will prepare students for the Microsoft Office Specialist certification exam in SharePoint. Topics include creating and formatting content, managing SharePoint sites, using SharePoint for collaboration, searches, integration with Microsoft Office application.

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.