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
- Use a computer spreadsheet program to create, store, modify, and print electronic spreadsheets.
- Demonstrate the skills needed to set up, maintain, and use a database management program.
- Design and create database structures to store, retrieve, update, and display data in a relational database using SQL.
- Identify the fundamental characteristics and functions of modern business, including business principles, marketing, labor relations, and business risk.
- Solve probability applications.
- Distinguish between continuous and discrete variables for business intelligence.
- Calculate and interpret descriptive statistics for either raw or grouped data.
- Use descriptive and inferential statistical techniques and confidence levels for decision making when testing hypotheses.
- Use regression and correlation analysis to interpret the results.
- Apply data modeling techniques for data visualization and informed decision making.
Career statistics
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 Arizona-based 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
$78,330 Show expanded career information for Operations Research Analysts
* Career and wage information provided by Pipeline AZ using data, reports, and forecasts which are generated using government data sources. Sources
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
| 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
| 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
| 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
| 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
| Course Number | Course Name | Requisites | Notes | Area | Credits |
|---|---|---|---|---|---|
| CIS117DM | Microsoft Access: Database Management | 3 | |||
| GBS151 | Introduction to Business | 3 |
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
| 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.
Previous Catalog Years
The pathway map presented above is for the current catalog year and is the intended pathway map for new students. All previous catalog years for this pathway map are available at the link below.
Previous catalog years for Certificate of Completion (CCL) in Data Analytics