Administrative Assistant Certificate of Achievement

Program Description

The Administrative Assistant Certificate is designed to prepare students for employment in today’s modern office. Students will learn computer skills in Microsoft Office Applications and writing skills that are needed for successful business communication. Student will learn computer skills through hands-on practice and various business project simulations.

The pathway below represents an efficient and effective course taking sequence for this program.  Individual circumstances might require some changes to this pathway.  It is always recommended that you meet with an academic counselor to develop a personalized educational plan.

Division

Mathematics, Business & Computer Technology

Department

Computer Information Technology

Career and Academic Pathway (CAP)

Business, Information Technology, Hospitality

Program Learning Outcomes

  1. Use advanced Word Processing features for business applications.

  2. Type 60 words per minute.

  3. Use PC-based database management system.

Program Map

GE General Education
O Available Online
Program Requirement
P Program Prerequisites

1st Semester

10 units
CIT 021
Word Processing: Comprehensive Microsoft Word
This course focuses on the production of professional quality documents using Microsoft Word comprehensive features: creating office documents, set up tabs and margins, set text in columns or tables, apply graphic elements, perform mail merge, sorting, numbering, bullets, symbols, prepare multiple page documents, using headers and footers, quick parts, themes and styles, references, forms, table of content, indexing, macros, and preparing students for Microsoft Certified Application Specialist exam.

Course Details:

  1. Departmental Advisory: CIT 010
    2. or
  2. Departmental Advisory: CIT 100
CIT 100 or CIT 101
A survey course for the use of software tools such as word processing, spreadsheets, graphics, presentation and database using Microsoft Office.

Course Details:

OR
This course is an introduction to fundamental Information Technology / Information Systems concepts and Information Security. The course includes practical exercises with spreadsheet, database, and Internet applications.

Course Details:

  1. Departmental Advisory: CIT 010
    2. or
  2. Departmental Advisory: CIT 031
  • Transfers to CSU
    • CIT 116
    Database Management: Access
    This is a comprehensive course in the development and maintenance of a database. It provides a working knowledge of designing a database that includes: setting field properties, storing, retrieving, printing, and indexing records, creating informational and technical queries, developing customized forms and reports, establishing different types of relationships, and integrating Access with the Web. The course emphasis is on developing a practical ability to use a database in a Windows environment with full graphical user interface functionality.

    Course Details:

    1. Departmental Advisory: CIT 100
      2. or
    2. Departmental Advisory: CIT 101

    2nd Semester

    12 units
    CIT 013
    Intermediate Keyboarding
    This course provides instruction in touch control of the computer keyboard, and is designed to develop a keyboarding speed of 45 net words per minute for five minutes. In addition, students receive instruction in the preparation of basic business documents using word processing software.

    Course Details:

    1. Prerequisite: CIT 010
    CIT 031
    Business English
    This course is a review of basic grammar, punctuation, capitalization, vocabulary, and spelling. Emphasis is placed on grammar and vocabulary building for effective business communications.

    Course Details:

    CIT 114
    Spreadsheets: Excel

    In this course, students will learn how to create workbooks using Microsoft Excel, which integrates spreadsheet analysis, information management, and graphics. Content includes the design and use of worksheets, data entry, formulas, functions, and graph creation. Students will also learn how to professionally format worksheets, use Excel functions in different applications, use Excel financial functions and data tables, and understand the concept of data management in Excel.

    Course Details:

    1. Departmental Advisory: CIT 100
      2. or
    2. Departmental Advisory: CIT 101
    CIT 118
    Microsoft PowerPoint

    This is a comprehensive-level course in Microsoft PowerPoint. This course is designed for students to create effective and compelling presentations. Instructions include developing and customizing presentations by using charts, clip art, pictures, presentation templates, WordArt, and information and graphics from Word, Excel, and Access.

    Course Details: