Data Analytics

Catalog Description:  The certificate program provides students with a basic foundation in the fields of data analytics, and prepares them for a potential career in Data Science. The program is designed to prepare students for entry-level jobs such as Business Analytics Specialist, Data Analyst, Data Visualization Developer, Operations Research Assistant, and Market Research Assistant.  Students learn to use Cloud-based tools to manage, wrangle, and analyze data, and to use Python libraries to draw statistical inferences, which solve real-world problems.

 

Course Requirements:

CS 119 - Programming in Python 

CIS 192 - Introduction to Cloud Computing

CIS 193 - Database Essentials in AWS

             Prerequisite: CIS 192. Advisory: CO SCI 434 or CIS 219.

CIS 194 - Compute Engines in AWS

             Prerequisite: CIS 192

CIS 219 - Introduction to Oracle: SQL and PL/SQL

Core Courses:

CIS 124 - Data Analytics-Advanced Excel and Access (3)

CS 121 - Python Programming for Data Science (3)

                  Prerequisite:  CS 119

CS 159  - Foundations of Data Science

                   Prerequisite:  NONE

                   

Learning Outcomes: 

Upon completion of the program, students will be able to: 

• Utilize cloud database systems on AWS, as well as Oracle, and Access in order to manage databases, and respond dynamically to information and computing technology workloads
  
• Wrangle data using Excel, and Python libraries in order to communicate summaries of data using multiple representations including graphs, tables, numerical summaries, and words
• Identify Statistical methods, and models that represent, and describe real world data, and draw inferences that solve real-world problem using Python libraries

30 students per year.

Occupational skills, and employment.  The goal is to obtain employment within entry-level Data Analytics careers.

Data Analytics careers demand the ability to manage, and wrangle data, and to be able to utilize it in a way that helps answer industry-related questions.  The program tackles these skills first with a set of courses that introduce cloud-based tools for managing, and  wrangling data with AWS, SQL, and Access, and analytical computational tools such as Excel, and Python libraries such as Pandas, Numpy, SciPy, Matplotlib over the Jupyter notebook; and finally students develop knowledge of basic statistical techniques, and models that provide the foundations for understanding how to select the appropriate models, and techniques in order to provide real-world solutions.

Course	Title	Units	Year/Semester (Y1 or S1)
CIS 192	Introduction to Cloud Computing	3	S1
CIS 193	Database Essentials in Amazon Web Services	3	S1
CIS 194	Compute Engines in Amazon Web Services	3	S1
CS 119	Database Essentials in Amazon Web Services	3	S1
CIS 219	Database Essentials in Amazon Web Services	3	S2
CIS 124	Data Analytics-Advanced Excel and Access	3	S2
CS 159	Foundations of Data Science	3	S2
CS 121	Python Programming for Data Science and Machine Learning	3	S2

Mathematics, Engineering, and Computer Science

El Camino College: Data Science Program This is part of the regional data science program.

40

n/a