MCCCD Program Description

Major: 3212 Catalog Year: 2024-2025 Effective Term: 2024 Fall Last Admit Term: 9999 Award: AAS Total Credits: 62-70 CIP Code: 52.1301	Primary College: Chandler-Gilbert Community College Initiating College: Mesa Community College Program Availability: Not Found Program Availability: Shared Program Availability: MC Field of Interest: Computer and Information Technology Instructional Council: Computer Information Systems GPA: 2.00
SOC Code: Upon completion of this certificate, students may pursue a career as: 15-2031.00 Operations Research Analysts

Description: The Associate in Applied Science (AAS) in Data Analytics is designed to prepare students to apply principles and concepts in data analytics and model, synthesize, analyze, and present large data sets for business decision making. Courses will focus on the software development techniques and computer applications 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 recognized certifications such as the Microsoft Power BI Data Analyst, Tableau Certified Analyst, and Microsoft Office Specialist for Excel and Access. Graduates may pursue employment in a variety of information technology environments.

Learning Outcomes
1. Apply computer spreadsheet programs to create, store, analyze, modify, print and present electronic spreadsheets. (CIS105, CIS114DE, CIS214DA, CIS215, CIS260BI, CIS260TB) 2. Demonstrate the skills needed to create, design, maintain, and use a relational database to gather and analyze data. (CIS105, CIS117DM, CIS215, CIS276DA, CIS276DB) 3. Identify the fundamental characteristics and functions of modern business, including business principles, marketing, labor relations, and business risks through data analysis application. (CIS214DA, GBS151, GBS220, GBS221, SBU200, CRE) 4. Solve probability and statistical applications. (CIS256DA, GBS220, GBS221, MAT15+) 5. Interpret outputs obtained from descriptive and inferential statistical techniques for decision making. (CIS214DA, CIS256DA, GBS220, GBS221, MAT15+) 6. Apply data modeling techniques for data visualization and informed decision making. (CIS105, CIS214DA, CIS215, CIS256DA, CIS260BI, CIS260TB) 7. Perform data analysis to answer stakeholder questions using data mining and machine learning models. (CIS114DE, CIS214DA, CIS215, CIS256DA, CIS276DA, CIS276DB, GBS220, GBS221, MAT15+) 8. Construct Python programs that solve business problems. (CIS156, CIS256DA) 9. Communicate to stakeholders with diverse skillsets. (CIS260BI, CIS260TB, CIS224, COM225, CRE, FYE101, FYE103, SBU200, [FYC]) 10. Apply ethical principles to data handling. (CIS111, FYE101, FYE103, PHI103, SBU200, [SG], [SQ])

Program Notes
Students must earn a grade of C or better in all courses within the program. Courses within any of the following prefixes must be taken within five (5) years prior to completion of the program to be applied toward this award: AIM, BPC, CIS, CLD, CNT, CSC, ITS, and MST. Students who have completed GBS221 can use this course in lieu of GBS220.

Required Courses

CIS105 Survey of Computer Information Systems 3
CIS111 Ethics in Information Technology 3
CIS114DE Excel Spreadsheet 3
CIS117DM Microsoft Access: Database Management 3

+ CIS156 Python Programming: Level I 3
+ CIS215 Foundations of Data Analytics and Programming 3
+ CIS214DA Advanced Excel for Data Analytics 3

+ CIS276DA MySQL Database (3) OR
+ CIS276DB SQL Server Database (3) 3

CIS224 Project Management Microsoft Project for Windows 3
+ CIS256DA Python for Data Analysis 3

+ CIS260BI Data Visualization: Power Business Intelligence (BI) (3) OR
+ CIS260TB Data Visualization: Tableau (3) 3

+ COM225 Public Speaking 3

FYE101 Introduction to College, Career and Personal Success (1) OR
FYE103 Exploration of College, Career and Personal Success (3) 1-3

GBS151 Introduction to Business 3

+ GBS220 Quantitative Methods in Business (3) OR
+ GBS221 Business Statistics (3) 3

+ PHI103 Introduction to Logic 3
SBU200 Society and Business 3

Credits: 49-51

Restricted Electives
	Credits:

General Electives
	Credits:

General Education Requirements

General Education Requirement	Credits: 13-19

General Education Core	Credits: 9-15

First-Year Composition	Credits: 6
+ ENG101 First-Year Composition (3) OR + ENG107 First-Year Composition for ESL (3) AND + ENG102 First-Year Composition (3) OR + ENG108 First-Year Composition for ESL (3) OR + ENG111 Technical and Professional Writing (3) 6

Oral Communication	Credits: 0
Met by COM225 in Required Courses.

Critical Reading	Credits: 0-3
+ CRE101 College Critical Reading and Critical Thinking (3) OR Equivalent as indicated by assessment (0) 0-3

Mathematics	Credits: 3-6
+ MAT150 College Algebra/Functions (5) OR + MAT151 College Algebra/Functions (4) OR + MAT152 College Algebra/Functions (3) OR + MAT155 College Algebra/Functions with Review (5) OR + MAT156 College Algebra/Functions with Review (6) OR Any higher approved general education course in the Mathematics area (3-6) 3-6

General Education Distribution	Credits: 4

Humanities, Arts and Design	Credits: 0
Met by PHI103 Introduction to Logic in Required Courses.

Social-Behavioral Sciences	Credits: 0
Met by SBU200 Society and Business in Required Courses.

Natural Sciences	Credits: 4
Any approved course in the Natural Sciences area.

+ indicates course has prerequisites and/or corequisites.
++ indicates that any suffixed course may be selected.

MCCCD Governing Board Approval Date: February 27, 2024

All information published is subject to change without notice. Every effort has been made to ensure the accuracy of information presented, but based on the dynamic nature of the curricular process, course and program information is subject to change in order to reflect the most current information available.