Office Assistant, Advanced

Update Workflow  -----------------------------------------------

Office Assistant Advanced Certificate Mapping

Certificate of Completion

Program #3P44476

Office Assistant, Advanced certificate is designed to build upon the skills learned in the Office Assistant, Introduction certificate program and to prepare students for the next level of office and administrative support positions, including administrative assistant, administrative associate, administrative secretary, administrative specialist, administrative technician, clerk typist, department secretary, office assistant, secretary, and staff assistant. Students can be expected to learn the following: basic oral and written communications; practical keyboarding skills; basic computer application skills, including beginning spreadsheets, word processing, databases, presentations, and Outlook; critical thinking and problem-solving skills; and hands-on practice integrating Microsoft Office software into real world simulations. Students completing this program will be eligible to take the Microsoft Office Specialist (MOS) certifications in Word, Excel, PowerPoint, and Outlook and the IC3 Digital Literacy certification, after completing the OTEC 301 Digital Literacy Preparation elective course. This training is also ideal for incumbent workers to be able to update their existing knowledge and skills relating to this field for more advanced career opportunities.

To earn a certificate, students complete the required and elective courses as listed with a grade of P (pass). For programs/courses that allow credit for prior learning, at least 75% of all coursework must be completed at North Orange Continuing Education. (Contact the CTE Office to learn more about which courses offer credit for prior learning)

Required Core Courses (210 Hours)
BMGR 415Written Communication - Business18
COMP 685Computer Keyboarding, Beginning36
COMP 510Computer Keyboarding, Mastery I30
COMP 511Computer Keyboarding Mastery II30
OTEC 100Office Essentials24
OTEC 110Business Math for Office Technology24
OTEC 105Microsoft Outlook Fundamentals12
OTEC 218Databases and Presentations for Business36
OTEC 225MS Office Integrated Projects36
Required Option (Hours 72-96)
Must select Option 1 or Option 272-96
OPTION 1
Windows and Word for Business36
Excel for Business36
OPTION 2
Computer Concepts and Applications IBEST96
Electives Course (27 Hours)
Must choose 0 of 1 Course0-27
Digital Literacy Preparation27
Total Hours318-369

Plan of Study

Option 1

First Year
First SemesterHoursSecond SemesterHours
COMP 68536BMGR 41518
OTEC 10024OTEC 11024
OTEC 10512OTEC 21736
OTEC 21636 
 108 78
Second Year
First SemesterHoursSecond SemesterHours
COMP 51030COMP 51130
OTEC 21836OTEC 22536
 66 66
Total Hours 318


Option 1 with Elective

First Year
First SemesterHoursSecond SemesterHours
COMP 68536BMGR 41518
OTEC 10024OTEC 11024
OTEC 10512OTEC 21736
OTEC 21636 
 108 78
Second Year
First SemesterHoursSecond SemesterHours
COMP 51030COMP 51130
OTEC 21836OTEC 22536
 OTEC 30127
 66 93
Total Hours 345


Option 2

First Year
First SemesterHoursSecond SemesterHours
COMP 68536BMGR 41518
OTEC 10024OTEC 21596
OTEC 10512 
OTEC 11024 
 96 114
Second Year
First SemesterHoursSecond SemesterHours
COMP 51030COMP 51130
OTEC 21836OTEC 22536
 66 66
Total Hours 342


Option 2 with Elective

First Year
First SemesterHoursSecond SemesterHours
COMP 68536BMGR 41518
OTEC 10024OTEC 21596
OTEC 10512 
OTEC 11024 
 96 114
Second Year
First SemesterHoursSecond SemesterHours
COMP 51030COMP 51130
OTEC 21836OTEC 22536
 OTEC 30127
 66 93
Total Hours 369

List of Courses

BMGR 415 Written Communication - Business 18 Hours

Provides extensive hands-on experience with all types of written business communications including letters, resumes, cover letters, memos, and reports.

COMP 510 Computer Keyboarding, Mastery I 30 Hours

Prerequisite(s): The student must be able to key 35 net words per minute (nwpm) timed writing or have completed COMP 685 Computer Keyboarding - Beginning with a pass grade

The first of two keyboarding courses designed to increase keying speed and accuracy to employment levels of 50+ nwpm.

COMP 511 Computer Keyboarding Mastery II 30 Hours

Prerequisite(s): The student must have completed COMP 510 Computer Keyboarding - Mastery I with a pass grade

The second of two keyboarding courses designed to increase and maintain keying speed and accuracy to employment levels of 50+ net words per minute (nwpm).

COMP 685 Computer Keyboarding, Beginning 36 Hours

Keyboarding is a basic skill that is mandatory for most industries. Our keyboarding class teaches the alpha/numeric keyboard with emphasis on correct technique, speed, and accuracy. Topics include speed and accuracy, using home keys alpha keys, punctuation, and number keys. Textbook Required.

OTEC 100 Office Essentials 24 Hours

A course that prepares students for an entry-level position in an office. Includes units on the office environment, becoming a professional, work ethics, and several elements of customer service. Textbook Required.

OTEC 105 Microsoft Outlook Fundamentals 12 Hours

This course introduces students to Microsoft Outlook. Students will learn how to organize and manage emails, schedule appointments, create and manage task and contact records, and customize Outlook.

OTEC 110 Business Math for Office Technology 24 Hours

Provides coverage of personal and business-related mathematics as well as reviewing the basic operations of arithmetic.

OTEC 215 Computer Concepts and Applications IBEST 96 Hours

This course introduces fundamental workforce skills in computers and information processing, hardware, system software; networks, security, and privacy; troubleshooting and maintenance; application software; the Internet, digital ethics and awareness, cloud computing, Windows, Microsoft Word and Excel. It also prepares students for the Microsoft Office Specialist (MOS) and IC3 Digital Literacy certifications.

OTEC 216 Windows and Word for Business 36 Hours

Recommended Preparation: Basic keyboarding skills This course introduces students to fundamental workforce skills necessary to succeed in an office environment: Windows operating system and Microsoft Word. This is the first of three courses (OTEC 216, 217, 218) and prepares students for the Microsoft Office Specialist (MOS) certification.

OTEC 217 Excel for Business 36 Hours

Advisory: Completion of OTEC 216 Windows and Word for Business

This is the second course in a series of three courses (OTEC 216, 217, 218) that serves as a foundation for working in the office environment and focuses on the entry level skills students need to succeed in the workforce. Part II introduces students to fundamental workforce skills in Microsoft Excel. The course series will also help prepare students for the Microsoft Office Specialist (MOS) and IC3 Digital Literacy certifications.

OTEC 218 Databases and Presentations for Business 36 Hours

Prerequisite(s): OTEC 211 Computer Concepts and Applications II or OTEC 215 Computer Concepts and Applications IBEST or OTEC 216 Windows and Word for Business and OTEC 217 Excel for Business

This is the third course in a series of three courses (OTEC 216, OTEC 217, and OTEC 218) that serves as a foundation for working in the office environment and focuses on the entry level skills students need to succeed in the workforce. Part III introduces students to fundamental workforce skills in using a database and presentations. The course series also helps prepare students for the Microsoft Office Specialist (MOS) and IC3 Digital Literacy certifications.

OTEC 225 MS Office Integrated Projects 36 Hours

Prerequisite(s): OTEC 211 Computer Concepts and Applications II, and OTEC 212 Computer Concepts and Applications III or OTEC 215 Computer Concepts and Applications IBEST or OTEC 216 Windows and Word for Business, OTEC 217 Excel for Business and OTEC 218 Databases and Presentations for Business

This course is designed to apply knowledge and skills gained from Computer Concepts and Applications II and III to the business environment by giving students the opportunity to work in real world simulations. This is the capstone course for those students completing the Administrative Professional certificate program.

OTEC 301 Digital Literacy Preparation 27 Hours

One of four courses that prepares learners for the IC3 Digital Literacy Certification exam. This course not only validates a learners' ability to do more than simply consume technology, it enables them to comprehend the possibilities and form the foundational set of skills necessary to support our modern digital economy. This course covers Level 1 certification: foundational understanding of computer hardware, software, operating systems, peripherals, and troubleshooting.