Printed on 10/30/2024

Data & Analytics Specialist

10-156-3 Associate Degree (AAS) Part Time, Full Time 60 Credits Financial Aid Eligible Location*: Online

*If general education courses are required, they may be available at multiple locations.

As a Data and Analytics Specialist, you’ll collect, structure, transform, quality check, and analyze data from numerous sources. You’ll collaborate with decision-makers and stakeholders to create processes for gathering, managing, and utilizing data using various technologies. These processes will enhance your ability to generate reports, visualizations, and predictive insights. You will also gain skills in artificial intelligence (AI), including machine learning, natural language processing (NLP), and predictive analytics, while considering the ethical implications of AI. With these tools and systems, Data Specialists support data scientists, data architects, and decision-makers, driving innovation and informed decisions across their organizations.

COURSE LIST

Print Page

Course list for reference only. Current students please refer to your individualized program plan or see your advisor.
**Outside effort hours are an estimate based on state standards, and may vary from person to person.

    Technical Studies (36 Credits)

    Course Title
    Course Number
    Credits
    Instructional Hours
    Outside Effort Hours**
    Prior Learning Credit Eligibility
  • IT Career Experience
    10-107-110
    2Credit
    54
    54

    • Instructional Hours: 54
    • Outside Effort Hours: 54
    • Course Number: 10107110
    • Credits: 2.00

    Examines and identifies job-seeking, job-keeping and interviewing techniques, strategies for identifying and meeting external and internal customer needs as well as good listening skills and techniques for dealing with difficult customers. Also covers time management, team dynamics, continual improvement processes and global business practices.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • Student must complete 13 Semester Units of IT Coursework at the Post Secondary Level. Catalog Numbers must begin with 1015x or 10107.

  • Linux Essentials - Just Enough Linux
    10-150-155
    1Credit
    18
    36
    N/A

    • Instructional Hours: 18
    • Outside Effort Hours: 36
    • Course Number: 10150155
    • Credits: 1.00

    Covers Basic Linux topics including operating system basics, file management, graphic user interfaces and the command line interface.

  • Network Essentials
    10-150-162
    2Credit
    54
    54

    • Instructional Hours: 54
    • Outside Effort Hours: 54
    • Course Number: 10150162
    • Credits: 2.00

    Provides an introduction to networking theory and technologies, including the basics of communication, common protocols, the OSI model, network topologies, local network media, network devices, network security and networking tools. Includes more in-depth study of the components of TCP/IP, Ethernet, and wireless networks. Involves considerable time developing troubleshooting skills.

  • Data Access for Programmers
    10-152-168
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10152168
    • Credits: 3.00

    Provides background in fundamental database concepts, design, documentation, implementation and distribution involving the relational database model. Students will create, query and update relational databases using Structured Query Language (SQL).

  • Data Administration Techniques
    10-152-170
    3Credit
    72
    90

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10152170
    • Credits: 3.00

    Covers the operation and management of client/server back-end relational databases. Topics include data definition language, table modification, creating views, indices, triggers, transactions, backup and recovery.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • COMPUTER 10152168 - Data Access for Programmers (Grade of C or better required)

  • Python Data Programming
    10-156-103
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156103
    • Credits: 3.00

    Introduction to programming using the Python language. Covers programming fundamentals including variables, datatypes, loops, conditionals, functions, and libraries. Examples focus on storage, retrieval, and manipulation of data.

  • Data Analytics, Introduction
    10-156-104
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156104
    • Credits: 3.00

    Technologies and techniques for identifying, collecting, preparing, processing, and analyzing data relevant to business questions.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • COMPUTER 10156103 - Python Data Programming

  • Data Analytics, Intermediate
    10-156-105
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156105
    • Credits: 3.00

    Additional technologies and techniques for analyzing data, including cloud cognitive services and simple machine learning. Also examines organizational processes surrounding data as well as business analysis for data projects.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • COMPUTER 10156104 - Data Analytics, Introduction

  • Programming in R
    10-156-106
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156106
    • Credits: 3.00

    Programming in the R statistical computing language. Examples cover data manipulation, analysis, and plotting.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • COMPUTER 10156104 - Data Analytics, Introduction

    • MATH 10804189 - Introductory Statistics

  • ETL & Data Warehousing
    10-156-107
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156107
    • Credits: 3.00

    Automating data pipelines. Code Extract, Transform, Load (ETL) procedures to connect a variety of data producers, repositories, and consumers. Explores various strategies and schemas for data warehousing as well as the overall flow of data through the organization and its systems.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • COMPUTER 10152170 - Data Administration Techniques

  • Business Intelligence & Data Visualization
    10-156-108
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156108
    • Credits: 3.00

    Technologies and techniques for communicating summaries, insights, and predictions gleaned from data analyses. Examines storytelling through report design, infographics, charts and graphs, purpose-built interactive dashboards, as well as custom visualizations and animations.

  • Big Data
    10-156-109
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156109
    • Credits: 3.00

    Explores the problems created by, strategies to tackle, and technologies to work with large data sets.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • COMPUTER 10156105 - Data Analytics, Intermediate

    • COMPUTER 10156107 - ETL & Data Warehousing

  • Data Analytics Capstone
    10-156-110
    3Credit
    72
    90
    N/A

    • Instructional Hours: 72
    • Outside Effort Hours: 90
    • Course Number: 10156110
    • Credits: 3.00

    Complete a data project modeled as a real-world scenario. Project phases include business analysis; designing, building, and automating data infrastructure; analysis; visualization; and presenting findings to decision-makers.

    Prereq: Student has completed or is in process of completing ALL of the following:

    • COMPUTER 10156105 - Data Analytics, Intermediate

    • COMPUTER 10156107 - ETL & Data Warehousing

    Coreq: Student has completed or is simultaneously enrolling in ALL of the following:

    • COMPUTER 10156109 - Big Data

  • College Success: On Course
    10-890-100
    1Credit
    18
    36

    • Instructional Hours: 18
    • Outside Effort Hours: 36
    • Course Number: 10890100
    • Credits: 1.00

    On Course helps you learn a number of proven strategies for creating greater academic, professional and personal success. You will discover how to create a rich, fulfilling life by developing new beliefs and behaviors. College Success: On Course empowers you to make wise choices in your academic and personal life which leads to improved experiences and outcomes.

    General Studies (21 Credits)

    Course Title
    Course Number
    Credits
    Instructional Hours
    Outside Effort Hours**
    Prior Learning Credit Eligibility
  • English Composition 1
    10-801-136
    3Credit
    54
    108

    • Instructional Hours: 54
    • Outside Effort Hours: 108
    • Course Number: 10801136
    • Credits: 3.00

    Learners develop and apply skills in all aspects of the writing process. Through a variety of learning activities and written documents, learners employ rhetorical strategies, plan, organize and revise content, apply critical reading strategies, locate and evaluate information, integrate and document sources, and apply standardized English language conventions.

    Prereq: Student has completed or is in process of completing ALL of the following:

    OR ALL of the following:

    • Student is not in progress in Associate Degree, Apprenticeship, or Technical Diploma (31 or 32 level)

  • Oral/Interpersonal Comm
    10-801-196
    3Credit
    54
    108

    • Instructional Hours: 54
    • Outside Effort Hours: 108
    • Course Number: 10801196
    • Credits: 3.00

    Focuses on developing effective listening techniques and verbal and nonverbal communication skills through oral presentation, group activity, and other projects. The study of self, conflict, and cultural contexts will be explored, as well as their impact on communication.

    Prereq: Student has completed or is in process of completing ALL of the following:

    OR ALL of the following:

    • Student is not in progress in Associate Degree, Apprenticeship, or Technical Diploma (31 or 32 level)

  • Math & Logic
    10-804-133
    3Credit
    54
    108

    • Instructional Hours: 54
    • Outside Effort Hours: 108
    • Course Number: 10804133
    • Credits: 3.00

    Students will apply problem solving techniques from discrete mathematics. Topics include symbolic logic, sets, algebra and base number systems.

    Prereq: Student has completed or is in process of completing ANY of the following options:

    • Accuplacer Arithmetic 263+ OR HS GPA 2.75+ OR ACT Math 18+ OR Arithmetic Level 2 Coursework

    • MATH 10804113 - College Technical Math 1A

    • MATH 10804115 - College Technical Math 1

    • Student is not in progress in Associate Degree, Apprenticeship, or Technical Diploma (31 or 32 level)

  • Quantitative Reasoning
    10-804-135
    3Credit
    54
    108
    N/A

    • Instructional Hours: 54
    • Outside Effort Hours: 108
    • Course Number: 10804135
    • Credits: 3.00

    This course is intended to develop analytic reasoning and the ability to solve quantitative problems. Topics to be covered may include: construction & interpretation of graphs; descriptive statistics; geometry & spatial visualizations; math of finance; functions and modeling; probability; and logic. Appropriate use of units and dimensions, estimates, mathematical notation, and available technology will be emphasized throughout the course.

    Prereq: Student has completed or is in process of completing ANY of the following options:

    • Accuplacer Arithmetic 263+ OR HS GPA 2.75+ OR ACT Math 18+ OR Arithmetic Level 2 Coursework

    • Student is not in progress in Associate Degree, Apprenticeship, or Technical Diploma (31 or 32 level)

  • Introductory Statistics
    10-804-189
    3Credit
    54
    108
    N/A

    • Instructional Hours: 54
    • Outside Effort Hours: 108
    • Course Number: 10804189
    • Credits: 3.00

    Students taking Introductory Statistics display data with graphs, describe distributions with numbers perform correlation and regression analyses, and design experiments. They use probability and distributions to make predictions, estimate parameters, and test hypotheses. They draw inferences about relationships including ANOVA.

    Prereq: Student has completed or is in process of completing ANY of the following options:

    • Accuplacer Algebra 250+ OR HS GPA 2.75+ OR ACT Math 18+ OR Algebra Level 1 Coursework

    • Student is not in progress in Associate Degree, Apprenticeship, or Technical Diploma (31 or 32 level)

  • Intro to Ethics: Theory & App
    10-809-166
    3Credit
    54
    108
    N/A

    • Instructional Hours: 54
    • Outside Effort Hours: 108
    • Course Number: 10809166
    • Credits: 3.00

    This course provides a basic understanding of the theoretical foundations of ethical thought. Diverse ethical perspectives will be used to analyze and compare relevant issues. Students will critically evaluate individual, social and professional standards of behavior, and apply a systematic decision-making process to these situations.

    Prereq: Student has completed or is in process of completing ALL of the following:

    OR ALL of the following:

    • Student is not in progress in Associate Degree, Apprenticeship, or Technical Diploma (31 or 32 level)

  • Intro to Psychology
    10-809-198
    3Credit
    54
    108
    N/A

    • Instructional Hours: 54
    • Outside Effort Hours: 108
    • Course Number: 10809198
    • Credits: 3.00

    This science of psychology course is a survey of multiple aspects of behavior and mental processes. It provides an overview of topics such as research methods, theoretical perspectives, learning, cognition, memory, motivation, emotions, personality, abnormal psychology, physiological factors, social influences, and development.

    Prereq: Student has completed or is in process of completing ALL of the following:

    OR ALL of the following:

    • Student is not in progress in Associate Degree, Apprenticeship, or Technical Diploma (31 or 32 level)

×

Expected Competencies


For more information visit our Credit For Prior Learning page.