Microsoft Office Specialist – Certificate

Students completing this program are prepared to assume a variety of positions in an automated office setting. The program recognizes the increasingly important role of the personal computer in modern business and is designed to assist students in developing their skills in the use of graphing, personal management, project management and electronic presentations. The Microsoft® Office® Specialist program provides a framework for measuring student proficiency with Microsoft® Office® applications and prepares students for the industry recognized Microsoft® exams for measuring an individual’s mastery of Office® applications. Students completing the program could be hired at entry-level positions such as secretaries, help desk technicians, administrative assistants and stenographers. Students can continue and pursue an associate degree for the administrative assistant program.

Gainful Employment

Program Requirements

Minimum credits 33
Minimum cumulative GPA 2.0
Minimum grade in all courses 2.0
Minimum Jackson College credits 15

GENERAL EDUCATION REQUIREMENTS

Take the following:

Course # Course Name Credits Prerequisites Notes
ENG 131 Writing Experience I 3 ENG 085 and ENG 091

This is an intensive writing course. Narrative and descriptive modes are stressed. Basic research strategies are introduced. An end-of-the-semester portfolio is required.

ENG 232 Technical & Business Writing 3 ENG 131

A course designed to provide practice in a variety of written and oral communications to meet the requirements of the workplace. Projects may include descriptions, instructions, résumés, proposals, reports or online documents. It involves frequent writing, both in and out of class, as well as oral presentations, collaborative activities and individual conferences.

Choose one of the following:

Course # Course Name Credits Prerequisites Notes
COM 231 Communication Fundamentals 3 ENG 085, ENG 091

(FORMERLY SPH 231)

COM 240 Interpersonal Communication 3 ENG 085, ENG 091

(FORMERLY SPH 240) Students will learn to improve communication in one-on-one and small group situations. In this course, students will examine basic verbal and non-verbal elements affecting communication between individuals in family, peer group and work contexts. Specific units of discussion include intrapersonal perspective, conflict resolution, self-disclosure, message generation, intercultural messages and non-verbal communication.

Choose one of the following:

Course # Course Name Credits Prerequisites Notes
MAT 130 Quantitative Reasoning 4 MAT 030

Quantitative Reasoning develops student skills in analyzing, synthesizing and communicating quantitative information. Cultivates algebraic reasoning and modeling skills through a quantitative literacy lens. Emphasizes critical thinking and the use of multiple strategies in applied contexts. Topics include proportional and statistical reasoning, probability, and evaluation of bias and validity.

MAT 133 Introduction to Probability & Statistics 4 MAT 033* or MAT 131 or higher

(FORMERLY MTH 133) (SAME AS CIS 203 AND PSY 144) This course is an introduction to experimental design, data representation, basic descriptive statistics, probability theorems, frequency distributions and functions, binomial and normal probability distributions and functions, probability density functions, hypothesis testing, statistical inference, Chi-square analysis, linear regression, correlation and application of the above in making informed, data driven decisions in real-world contexts. Both graphing calculators and computer-based statistical software (Microsoft® Excel) will be used. If the prerequisite is more than two years old, then the mathematics department recommends the course placement exam be taken or the prerequisite be retaken to ensure the success of the student.

CORE REQUIREMENTS

Take the following:

Course # Course Name Credits Prerequisites Notes
CIS 104 Keyboard Speed/Accuracy 1

(FORMERLY CIS 011) At course entry your keyboarding speed and accuracy is measured. A diagnosis of your specific keyboarding problem is made. Your skill improvement goals will be established and appropriate practice lessons selected. Periodic program check timings will be administered to measure your progress.

CIS 117 Microsoft® Outlook® Workshop 1

(FORMERLY CIS 024) Learn to use Outlook® components to create and use the calendar feature to schedule meetings and multiple day events, establish a ”contacts” database, keep journals, notes and use the task manager for prioritizing jobs. This is an optional component of the Microsoft® Office® User Specialist Expert certification tests. Typing ability necessary to be successful in this course.

CIS 119 Microsoft® PowerPoint® – Windows® 2 ENG 085* and ENG 090*

Students will learn how to create electronic presentations using design templates, slide layouts, the outline tab, clip art, from other programs such as Microsoft® Word® and how to enhance slideshows with visual elements in presentation formats. Student will also learn how to create presentations for the web, self-running presentations, presentations containing interactive documents and how to collaborate work groups. Keyboarding skills are essential.

CIS 120 Microsoft® Word® Comprehensive – Windows® 3 ENG 085* and ENG 090*

Produce, store and revise letters, memos, tables and reports using Microsoft® Word®. Headers, footers, mail merge, document assembly, grammar and spell checker, thesaurus, and outlining are covered. Keyboarding skills are essential.

CIS 121 Microsoft® Excel® Comprehensive – Windows® 3 ENG 085,* ENG 090* and MAT 020* or higher

Learn Excel® components: charts, creating workbooks, using drawing tools, formatting and auditing worksheets, functions, Internet and intranet documents, modifying and printing workbooks, ranges, database queries, importing and exporting data, macros, working with multiple workbooks, working with existing and creating new templates, and advanced workgroup functions. Keyboarding skills are essential.

CIS 122 Microsoft® Access® Comprehensive – Windows® 3 ENG 085,* ENG 090* and MAT 020* or higher

Planning, creating and displaying databases, sorting and report preparation, data entry screens, data validation and selection, and multiple file operations. Keyboarding skills are essential.

CIS 125 Microsoft® Expression® Web 1 CIS 095*

This course will show how to create web sites with the Microsoft® Expression® Web program. Topics will include how to create a web site, managing and publishing a web site, and how to use views, table and frames. Previous keyboarding experience is necessary to be successful in this course.

CIS 201 Advanced Information Technologies 3 ENG 085*, ENG 090* and CIS 101*

(SAME AS ECM 201) This course enhances electronic communication skills and computer concepts essential to using current advanced information technologies. Topics include web collaboration, web conferencing, web 2.0 applications, social media, mobile computing, file conversions and cross-platform compatibility.

CIS 210 Office Administration Systems 4 CIS 101

Develop and integrate administrative support skills in communication, information technologies, administrative procedures and problem solving. Topics include: records management, information/communication systems, including electronic, space management and ergonomics, quality and productivity improvement techniques, meeting/ travel planning, records preparation/presentation and employment skills. Keyboarding skills are essential.

Sample Course Map

The following is a sample course map for informational purposes and will not suit every student’s situation. A detailed, individualized course map will be created when a student meets with their Student Success Navigator.

SEMESTER 1

Course # Course Name Credits Prerequisites Notes
CIS 110 Keyboarding/Document Processing 3

Students are introduced to the computer keyboard and are given instruction in proper typing technique. Student are also introduced to basic Microsoft® Word® operations to create business letters and envelopes, business and academic reports, tables and other business and academic related documents

CIS 119 Microsoft® PowerPoint® – Windows® 2 ENG 085* and ENG 090*

Students will learn how to create electronic presentations using design templates, slide layouts, the outline tab, clip art, from other programs such as Microsoft® Word® and how to enhance slideshows with visual elements in presentation formats. Student will also learn how to create presentations for the web, self-running presentations, presentations containing interactive documents and how to collaborate work groups. Keyboarding skills are essential.

CIS 120 Microsoft® Word® Comprehensive – Windows® 3 ENG 085* and ENG 090*

Produce, store and revise letters, memos, tables and reports using Microsoft® Word®. Headers, footers, mail merge, document assembly, grammar and spell checker, thesaurus, and outlining are covered. Keyboarding skills are essential.

CIS 121 Microsoft® Excel® Comprehensive – Windows® 3 ENG 085,* ENG 090* and MAT 020* or higher

Learn Excel® components: charts, creating workbooks, using drawing tools, formatting and auditing worksheets, functions, Internet and intranet documents, modifying and printing workbooks, ranges, database queries, importing and exporting data, macros, working with multiple workbooks, working with existing and creating new templates, and advanced workgroup functions. Keyboarding skills are essential.

ENG 131 Writing Experience I 3 ENG 085 and ENG 091

This is an intensive writing course. Narrative and descriptive modes are stressed. Basic research strategies are introduced. An end-of-the-semester portfolio is required.

SEM 140 Seminar in Life Pathways 3

Seminar in Life Pathways is a gateway course to Jackson College. This course is designed to help all students develop the skills, inner qualities and external behaviors needed to take charge of their academic and career success. Students will be guided through an extensive process in making career choices and selecting an academic program of study at Jackson College and beyond. With the exception of second-admit programs, SEM 140 is required of all students.

SEMESTER 2

Course # Course Name Credits Prerequisites Notes
CIS 117 Microsoft® Outlook® Workshop 1

(FORMERLY CIS 024) Learn to use Outlook® components to create and use the calendar feature to schedule meetings and multiple day events, establish a ”contacts” database, keep journals, notes and use the task manager for prioritizing jobs. This is an optional component of the Microsoft® Office® User Specialist Expert certification tests. Typing ability necessary to be successful in this course.

CIS 118 Microsoft® Publisher® Windows® 2 ENG 085* and ENG 090*

This course presents design techniques and the proper procedures necessary to create electronic documents in Microsoft® Publisher®. Students explore the use of Publisher’s® extensive design templates to create documents such as flyers, brochures and newsletters. Publications are also created from scratch. An emphasis is placed on good design principles and the creative aspects of desktop publishing.

CIS 122 Microsoft® Access® Comprehensive – Windows® 3 ENG 085,* ENG 090* and MAT 020* or higher

Planning, creating and displaying databases, sorting and report preparation, data entry screens, data validation and selection, and multiple file operations. Keyboarding skills are essential.

CIS 147 Web Page Design I (Dreamweaver®) 1

(FORMERLY CIS 045) This course covers the fundamental concepts of web page design using Adobe® Dreamweaver®. This course will instruct students in all the basic functions of Adobe® Dreamweaver® in regards to understanding how to get a website up and running.

CIS 210 Office Administration Systems 4 CIS 101

Develop and integrate administrative support skills in communication, information technologies, administrative procedures and problem solving. Topics include: records management, information/communication systems, including electronic, space management and ergonomics, quality and productivity improvement techniques, meeting/ travel planning, records preparation/presentation and employment skills. Keyboarding skills are essential.

MAT 131 Intermediate Algebra 4 MAT 039*

(FORMERLY MTH 131) This course emphasizes simplifying expressions, solving equations, and graphing functions, including linear, quadratic, polynomial, rational, radical, exponential and logarithmic. Problem solving and mathematical modeling are integrated throughout. Appropriate technology includes a graphing calculator. The mathematics department recommends the prerequisite not be more than two years old. If the prerequisite is more than two years old the recommendation is the course placement assessment be taken or the prerequisite be retaken to ensure the success of the student.

SEMESTER 3

Course # Course Name Credits Prerequisites Notes
CIS 201 Advanced Information Technologies 3 ENG 085*, ENG 090* and CIS 101*

(SAME AS ECM 201) This course enhances electronic communication skills and computer concepts essential to using current advanced information technologies. Topics include web collaboration, web conferencing, web 2.0 applications, social media, mobile computing, file conversions and cross-platform compatibility.

COM 231 Communication Fundamentals 3 ENG 085, ENG 091

(FORMERLY SPH 231)