Data Analytics

The Certificate of Completion (CCL) in Data Analytics is designed to prepare students to model, synthesize, analyze, and present large data sets for business decision making. Courses will focus on the techniques and computer software used in industry to extract data from various data sources, model and integrate that data, and then visualize this data for business decision making and intelligence gathering. This program prepares students for industry certification and is embedded (can be used to fulfill requirements) in the Associate of Applied Science (AAS) in Data Analytics available at MCCCD.

Details

Field of Interest
Computer and Information Technology
Degree Type
Certificate of Completion (CCL)
Academic Plan
Data Analytics (CER)
Academic Plan Code
5884
Total credits required
18-24
Catalog Year
2024-2025
Effective Term
Fall 2023
Notes

Students must earn a grade of C or better in all courses within the program.

CIS214DE is not equivalent to CIS214DA for the purposes of this certificate and should not be used to complete program requirements. Students who have completed GBS221 can use this course in lieu of GBS220.

Computer Information System (CIS) courses required by this program are not applicable if taken more than eight (8) years prior to the completion of the program of study. Consult with an Academic Advisor for complete information.

What You'll Learn

This pathway map will help you gain the expertise needed to:

  1. Use a computer spreadsheet program to create, store, modify, and print electronic spreadsheets.
  2. Demonstrate the skills needed to set up, maintain, and use a database management program.
  3. Design and create database structures to store, retrieve, update, and display data in a relational database using SQL.
  4. Identify the fundamental characteristics and functions of modern business, including business principles, marketing, labor relations, and business risk.
  5. Solve probability applications.
  6. Distinguish between continuous and discrete variables for business intelligence.
  7. Calculate and interpret descriptive statistics for either raw or grouped data.
  8. Use descriptive and inferential statistical techniques and confidence levels for decision making when testing hypotheses.
  9. Use regression and correlation analysis to interpret the results.
  10. Apply data modeling techniques for data visualization and informed decision making.

Successful completion of this certificate may lead to employment in a variety of different occupations and industries. Below are examples of related occupations with associated Maricopa County-based annual median wages* for this certificate. Education requirements vary for the occupations listed below, so you may need further education or degrees in order to qualify for some of these jobs and earn the related salaries. Please visit with an academic advisor and/or program director for additional information. You can click on any occupation to view the detail regarding education level, wages, and employment information.

Operations Research Analysts

$77,131

* Career and wage information provided by Lightcast using data, reports, and forecasts which are generated using government data sources and Lightcast’s proprietary analytical processes. Lightcast’s data covers multiple classes of workers including QCEW, non-QCEW, and those who are self-employed. Disclaimer

Course Sequence by Term

The following is the suggested course sequence by term. Please keep in mind:

  • Students should meet with an academic advisor to develop an individual education plan that meets their academic and career goals. Use the Degree Progress Report Tool in your Student Center to manage your plan.
  • The course sequence is laid out by suggested term and may be affected when students enter the program at different times of the year.
  • Initial course placement is determined by current district placement measures and/or completion of 100-200 level course and/or program requirements.
  • Degree and transfer seeking students may be required to successfully complete a MCCCD First Year Experience Course (FYE) within the first two semesters at a MCCCD College. Courses include FYE101 and FYE103. Course offerings will vary by college. See an academic, program, or faculty advisor for details.

Option 1 Sequence

This option may include variable full-time (12 to 18 credits per semester) and/or part-time (11 credit hours or less per semester) status by term due to course prerequisites and scheduling. Speak to an academic advisor for details

Term 1

A sequence of suggested courses that should be taken during Term 1
Course Number Course Name Requisites Notes Area Credits
MAT15+ College Algebra/Functions OR Satisfactory District math placement MA 0–6
CIS114DE Excel Spreadsheet 3
CIS117DM Microsoft Access: Database Management 3
GBS151 Introduction to Business 3

Term 2

A sequence of suggested courses that should be taken during Term 2
Course Number Course Name Requisites Notes Area Credits
GBS220 or
GBS221		 Quantitative Methods in Business or Business Statistics None or CS 3
CIS217AM or
CIS276DA or
CIS276DB		 Advanced Microsoft Access: Database Management or MySQL Database or SQL Server Database 3

Term 3

A sequence of suggested courses that should be taken during Term 3
Course Number Course Name Requisites Notes Area Credits
CIS214DA Advanced Excel for Data Analytics 3

Option 2 Sequence

Part-time status is 11 credit hours or less.

Term 1

A sequence of suggested courses that should be taken during Term 1
Course Number Course Name Requisites Notes Area Credits
MAT15+ College Algebra/Functions OR Satisfactory District math placement MA 0–6
CIS114DE Excel Spreadsheet 3

Term 2

A sequence of suggested courses that should be taken during Term 2
Course Number Course Name Requisites Notes Area Credits
CIS117DM Microsoft Access: Database Management 3
GBS151 Introduction to Business 3

Term 3

A sequence of suggested courses that should be taken during Term 3
Course Number Course Name Requisites Notes Area Credits
GBS220 or
GBS221		 Quantitative Methods in Business or Business Statistics None or CS 3
CIS217AM or
CIS276DA or
CIS276DB		 Advanced Microsoft Access: Database Management or MySQL Database or SQL Server Database 3

Term 4

A sequence of suggested courses that should be taken during Term 4
Course Number Course Name Requisites Notes Area Credits
CIS214DA Advanced Excel for Data Analytics 3
Course Area Key
  • CS = Computer/Statistics/Quantitative Application
  • MA = Mathematics
Disclaimer

Students must earn a grade of C or better for all courses required within the program.

Course Sequence total credits may differ from the program information located on the MCCCD curriculum website due to program and system design.

View MCCCD’s official curriculum documentation for additional details regarding the requirements of this award (https://aztransmac2.asu.edu/cgi-bin/WebObjects/MCCCD.woa/wa/freeForm11?id=179773).

At Maricopa, we strive to provide you with accurate and current information about our degree and certificate offerings. Due to the dynamic nature of the curriculum process, course and program information is subject to change. As a result, the course list associated with this degree or certificate on this site does not represent a contract, nor does it guarantee course availability. If you are interested in pursuing this degree or certificate, we encourage you to meet with an advisor to discuss the requirements at your college for the appropriate catalog year.