Microsoft Applications Specialist Certificate

1.0 Unit

9 hours lecture/27 hours laboratory. This course is designed for those with little or no computer experience. Learners practice file management, email, instant messaging, and Internet browsing and searching. This course includes a brief introduction to industry standard word processing, spreadsheet, and presentation application programs. Computer terminology and identification of fundamental hardware and software applications are also introduced. (Formerly CSCI C070.)

3.0 Units
C-ID: BUS 140 Business Information Systems, ITIS 120 Computer Information Systems
Advisory: ENGL C101

36 hours lecture/54 hours laboratory. This course is an examination of information systems and their role in business. The course focuses on information systems, database management systems, networking, e-commerce, ethics and security, computer systems hardware, and software components.

3.0 Units
C-ID: BSOT 111 X MS Word I, BSOT 121 X MS Word II
Advisory: IT C101

36 hours lecture/54 hours laboratory. This course provides the learner with skills in word processing with Microsoft Word including document creation, formatting, editing, and inserting illustrations; table creation and formatting; using themes, styles, templates, and micros; and managing resources and using office collaborative features.

3.0 Units
C-ID: BSOT 112 X MS Excel I, BSOT 122 X MS Excel II
Advisory: IT C101

36 hours lecture/54 hours laboratory. This course provides understanding of Microsoft Excel features with spreadsheet design, creation, revision, formatting, and printing a workbook. Basic and intermediate formulas, functions, and syntax are introduced along with charts and graphs. The course also covers data analysis, multiple worksheets and functions, pivot tables, conflict resolution, change-tracking, data validation, chart formatting, template usage, and macro-operation.

3.0 Units
C-ID: BSOT 113 X MS Access I, BSOT 123 X MS Access II
Advisory: IT C101

36 hours lecture/54 hours laboratory. This hands-on computer course provides a beginning understanding of databases using the Microsoft Access database management program. Topics include fundamental relational database design and management as well as building and editing basic tables, forms, queries, and reports.

3.0 Units
C-ID: BSOT 114 X MS PowerPoint I, BSOT 124 MS PowerPoint II
Advisory: IT C101

36 hours lecture/54 hours laboratory. This course provides the learner with experience in planning, creating, editing, viewing, and printing PowerPoint presentations. Included is the development of skills to add and modify text, photographs, graphics, charts, audio, video, transitions, animations, templates, and speaker notes. Students also acquire skills in recording and delivering presentations effectively and collaborating with others about the content of a presentation.