Microsoft Excel Application Specialist (ME21)  Technical Certificate of Credit


The certificate program provides students with the knowledge and skill to perform intermediate and advanced Microsoft Excel. Prepares students with skills necessary to obtain the expert user certification.

Occupational Courses (9 Credits)
Required Courses: (6 Credits)
COMP 1000

Introduces the fundamental concepts terminology and operations necessary to use computers. Emphasis is placed on basic functions and familiarity with computer use. Topics include an introduction to computer terminology the Windows environment Internet and email word processing software spreadsheet software database software and presentation software.

3
CIST 2128

This course provides students with knowledge in spreadsheet software. Spreadsheet topics include creating and manipulating data, formatting data and content, creating and modifying formulas, presenting data visually, and collaborating on and securing data.

3
Select ONE CIST elective below: (3 Credits)
CIST 2129

This course provides a study of databases beginning with introductory topics and progressing through advanced development techniques. Topics include: advanced database concepts, advanced development techniques, data integration concepts, and troubleshooting and supporting databases.

4
CIST 1130

Provides an overview of modern operating systems and their use in home and small business environments. Activities will utilize the graphical user interface (GUI) and command line environment (CLI This will include operating system fundamentals; installing configuring and upgrading operating systems; managing storage file systems hardware and system resources; troubleshooting diagnostics and maintenance of operating systems; and networking.

3
CIST 1210
Prerequisite: CIST 1001

This course provides an introduction to the Oracle database management system platform and to Structured Query Language (SQL). Topics include database vocabulary normalization Oracle DML and DDL statements SQL Statements views and constraints.

4
CIST 1401

Introduces networking technologies and prepares students to take the CompTIA*s broad-based vendor independent networking certification exam Network +. This course covers a wide range of material about networking including local area networks wide area networks protocols topologies transmission media and security. Focuses on operating network management systems and implementing the installation of networks. It reviews cabling connection schemes the fundamentals of the LAN and WAN technologies TCP/IP configuration and troubleshooting remote connectivity and network maintenance and troubleshooting. Topics include: basic knowledge of networking technology network media and topologies network devices network management network tools and network security.

4
CIST 2921

IT Analysis Design and Project Management will provides a review and application of systems life cycle development methodologies and project management. Topics include: Systems planning systems analysis systems design systems implementation evaluation and project management.

4
Up one level
Programs of Study