The Data Analytics Associate Degree is a 62 Credit program. The following is a typical semester breakdown of the courses within the program.

Get Started

The application takes just a few minutes to complete.

College 101 (10890165)

1.00

Examines proven strategies designed to help learners achieve greater personal, academic, and professional success. Learners will apply personal responsibility thinking and behaviors; self- management, awareness, and motivation strategies; as well as interdependence skills to develop a proactive life plan.

NTC Assessments Offered:

IT Development and Design Fundamentals (10152500)

1.00

Introduces the field of IT software development and design. Learners will explore degree and career paths, IT tools and processes and begin to demonstrate professional communication. Learners will create or modify a simple computer program using an integrated development environment.

NTC Assessments Offered:
National Exams Accepted:
  • National Exam Accepted: AP Computer Science A

Principles Of Information Security (10150114)

2.00

Discover the various technical and administrative aspects of information security and assurance. This course provides the foundation for understanding the key issues associated with protecting information assets, determining the levels of protection and response to security incidents and designing a consistent, reasonable information security system, with appropriate intrusion detection and reporting features.

Conditions

Students who specified one or more of these Programs of Study or Program Foci: Business Management, Data Analytics, IT - A+ Exam Preparation, IT - CCNA Exam Prep, IT - Computer Support Specialist, IT - Computer Support Technician, IT - Cybersecurity Specialist, IT-Help Desk Support Specialist, IT - Information Security, IT-Junior Developer, IT - Network Specialist, IT-Network Technician, IT - Software Developer, IT-Software Development Specialist, IT - Web Designer, IT-Web Design Specialist

NTC Assessments Offered:
Industry Credentials Accepted:
  • CompTIA® Security+ Certification

Intro To Python (10156102)

1.00

Introduces computer programming and terminology in the Python programming language. Special attention is paid to concepts essential to writing basic computer programs. These concepts include: Data Types, Expressions, Loops, File Interaction, Collections, and Functions. Additionally, several tools required to develop Python applications will be explored. Throughout the course learners will develop increasingly complex applications as new topics are introduced.

Python For Data Analytics (10156103)

1.00

Introduces topics and libraries related to data analytics in the Python programming language. Learners will explore reading, processing, and writing files in native Python. Then they will explore data analytics, processing and visualization using NumPy, Pandas, Matplotlib and Seaborn.

Conditions

Student has completed or is in process of completing all of the following course(s): ITDATA 10156102 - Intro To Python

Data Concepts A (10152531)

1.00

Introduces students to foundational concepts of data, information, and data management. Learners identify and use different types of data models. Learners use Microsoft Visio to create diagrams that illustrate how entities are related. Additional topics include eliminating data redundancy, explaining structures of relational tables, and compiling a data dictionary.

Conditions

Student has satisfied all of the following: [Students who specified one or more of these Programs of Study or Program Foci: Business Analyst, Data Analysis Specialist, Data Analytics, IT - Computer Support Specialist, IT-Junior Developer] And Student has satisfied all of the following: [Student has completed or is in process of completing any of the following course(s): MICROAPP 10154104 - Foundations Of Technical Supp, PROGRAMR 10152500 - IT Devel & Design Fundamentals with grade greater than or equal to C (Post Secondary Grading Scheme).]

Industry Credentials Accepted:
  • Google Data Analytics Certificate

Data Concepts B (10152532)

1.00

Learners describe primary keys and how to select them. Learners explain normalization and its role in the database design process. Learners apply normalization rules to evaluate and correct table structures. Learners use SQL Server and retrieve information from data tables. Learners use to SQL queries to join tables, aggregate data, and restrict data retrieval.

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152531 - Data Concepts A

Industry Credentials Accepted:
  • Google Data Analytics Certificate

Data Concepts C (10152533)

1.00

Create database models and database objects using T-SQL statements. Learners use data manipulation language (DML) to modify and create data. Learners manipulate the structure of existing tables to add, modify, and remove columns and constraints. Additional topics include foreign key relationships and indexes.

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152532 - Data Concepts B

Industry Credentials Accepted:
  • Google Data Analytics Certificate

Math & Logic (10804133)

3.00

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

NTC Assessments Offered:

Excel Level 1 (10103242)

1.00

Introduces learners to the basic concepts of using Microsoft Excel with hands-on, project based activities. Learners will develop foundational skills by applying concepts explored to effectively utilize the functions and features of Microsoft Excel including creating worksheets, entering/editing data, selecting cells/ranges, creating basic charts, formatting entries and creating/modifying basic formulas.

NTC Assessments Offered:
Industry Credentials Accepted:
  • Microsoft Office Specialist - Office Excel 2019

Written Communication (10801195)

3.00

Develops writing skills which include prewriting, drafting, revising and editing. A variety of writing assignments are designed to help the learner analyze audience and purpose, research and organize ideas and format and design documents based on subject matter and content. Also develops critical reading and thinking skills through the analysis of a variety of written documents. Keywords: Written Comm, Comm, Writing

NTC Assessments Offered:
National Exams Accepted:
  • CLEP® College Composition
  • AP English Language & Composition

English Composition 1 (10801136)

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.Keywords:English Comp, Comp 1, E Com, English 1, English

NTC Assessments Offered:
National Exams Accepted:
  • CLEP® College Composition
  • AP English Language & Composition

Programming Concepts A (10152501)

1.00

Introduces programming concepts and terminology using an object-oriented approach, with a focus on iterative development and testing. This course uses C# .NET, the Unified Modeling Language (UML) and other tools to present concepts from a variety of perspectives. Learners will create UML diagrams and write/debug C# .NET applications that incorporate classes, fields, methods and variables. Additional topics include: utilization of an Integrated Development Environment (IDE), value and reference types, object instantiation/lifetime/scope and mathematical/conditional/logical expressions.

Conditions

Student has completed or is in process of completing any of the following course(s): ITDATA 10156100 - Data Fundamentals, PROGRAMR 10152500 - IT Devel & Design Fundamentals with grade greater than or equal to C (Post Secondary Grading Scheme).

National Exams Accepted:
  • National Exam Accepted: AP Computer Science A

Programming Concepts B (10152502)

1.00

Reinforces programming concepts and standards, building on the object-oriented approach introduced in 10-152-501 Programming Concepts A, with a focus on iterative development and testing. This course uses C# .NET, the Unified Modeling Language (UML) and other tools to present concepts from a variety of perspectives. Learners will create UML diagrams and write/debug C# .NET applications, applying the object-oriented basics of abstraction and encapsulation. Additional topics include: utilization of a debugger, object multiplicity and constructors.

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152501 - Programming Concepts A with grade greater than or equal to C (Post Secondary Grading Scheme).

National Exams Accepted:
  • National Exam Accepted: AP Computer Science A

Programming Concepts C (10152503)

1.00

Emphasizes programming concepts and standards, building on the object-oriented approach of 10-152-502 Programming Concepts B, with a focus on iterative development and testing. This course uses C# .NET, the Unified Modeling Language (UML) and other tools to present concepts from a variety of perspectives. Learners will create UML diagrams and write/debug C# .NET applications, applying the object-oriented basics of abstraction, encapsulation, inheritance.

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152502 - Programming Concepts B with grade greater than or equal to C (Post Secondary Grading Scheme).

Database Design And SQL A (10152534)

1.00

Builds upon the basic database principles learned in Data Concepts, further exploring database design/normalization and introducing more complex and varied SQL statements. Learners will create/modify data objects and populate/retrieve data using SQL. Additional topics include: understanding constraints and keys on tables.

Conditions

Student has completed all of the following course(s): PROGRAMR 10152533 - Data Concepts C

Industry Credentials Accepted:
  • Google Data Analytics Certificate

Database Design And SQL B (10152535)

1.00

Builds on Database Design and SQL 1, learners use data manipulation language and data definition language to create and update more complex tables and data. Learners build views, indexes, and functions. Additional topics include database performance and SQL

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152534 - Database Design And SQL A

Industry Credentials Accepted:
  • Google Data Analytics Certificate

Database Design And SQL C (10152536)

1.00

Focus on error handling and database security. Learners engage with data from disparate sources in order to understand basics of extract, transform, load (ETL) procedures. Learners will build a database and move data from source to target and also build simple data reports to illustrate what is in the database.

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152535 - Database Design And SQL B

Industry Credentials Accepted:
  • Google Data Analytics Certificate

Data Visualizations 1 (10156113)

1.00

Design charts, graphs, dashboards, and other visualizations with an understanding of color and chart type. Learners use the appropriate types of chart based on the data that is being presented and the audience that is viewing the presentation and also build charts for the purpose of exploratory data analysis.

Conditions

Student has completed all of the following course(s): PROGRAMR 10152533 - Data Concepts C

Data Visualizations 2 (10156117)

1.00

Builds on Data Visualizations 1 and emphasizes choosing proper charts for quantitative and time-series analysis. Learners build effective dashboards and tell effective stories based on audience needs and analytical comfort. Learners contrast the ways in which data visualization can be used to tell truthful and untruthful stories.

Conditions

Student has completed or is in process of completing all of the following course(s): ITDATA 10156113 - Data Visualizations 1

Oral/interpersonal Communication (10801196)

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.  Keywords: Oral, Oral Comm, Comm, Speech

NTC Assessments Offered:

Introductory Statistics (10804189)

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. Keywords: Stats, Intro to Stats, Data

Conditions

Student has completed any of the following course(s): MATH 10804107 - College Mathematics, MATH 10804118 - Intermediate Algebra W/Apps, MATH 10804123 - Math W Business Apps, MATH 10804133 - Math & Logic, MATH 10804195 - College Algebra W/Apps, MATH 10804198 - Calculus 1

National Exams Accepted:
  • AP Statistics

Excel Level 2 (10103247)

1.00

Examines the intermediate level Microsoft Excel skills which build upon the basic Microsoft Excel concepts. Learners will demonstrate their ability to perform a number of hands-on, project based Excel intermediate level activities including but not limited to working with multiple worksheets and workbooks, creating, sorting and querying a table, importing data, working with SmartArt, images and screenshots, and financial functions.

Conditions

Student has completed all of the following course(s): MICROCOM 10103242 - Excel Level 1

NTC Assessments Offered:

Advanced Data: Management (10152570)

1.00

Introduces learners to a variety of tools to upload data. Learners organize tables and databases through partitioning and creating backups. Learners use SQL tools to improve the performance of database tables. Additional topics include writing proper stored procedures and using SQL Server agents to schedule stored procedures.

Conditions

Student has completed all of the following course(s): PROGRAMR 10152536 - Database Design And SQL C

Advanced Data: ETL (10152571)

1.00

Introduces learners to ETL (extract, transform, load) using SQL Server Data Tools. Learners use variables and parameters to write data to tables. Learners ensure that data is not duplicated or deleted when employing tools to load data to tables. Additional topics include scheduling ETL deployments.

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152570 - Advanced Data: Management

Advanced Data: Cloud and BI (10152572)

1.00

Introduces learners to Business Intelligence tools and Cloud Storage. Learners distinguish between star and snowflake schema in order to leverage capacities in OLTP and BI systems. Learners create views and visualizations of data tables. Additional topics include use of Power BI, Amazon Web Services, and Google Cloud.

Conditions

Student has completed or is in process of completing all of the following course(s): PROGRAMR 10152571 - Advanced Data: ETL

It Project Management (10156104)

3.00

Introduces terminology, roles, and processes that are used in modern, successful project management. Learners design projects and work with project specific items including product backlogs, product owners, sprint planning, and scrum meetings. Learners compare and contrast project management strategies.

Data Mining & Predictive Analytics 1 (10156109)

1.00

Employs RapidMiner, R, and Orange software packages in order to facilitate exploration of clustering, association, and text mining algorithms. Learners import a variety of data and use the algorithms in the various software products to extract meaningful information. Learners demonstrate their findings via PowerPoint and short video presentations.

Conditions

Student has completed all of the following course(s): MATH 10804133 - Math & Logic, MATH 10804189 - Introductory Statistics

Optimization And Simulation 1 (10156110)

1.00

Use a variety of optimization models to analyze data in order to make decisions. Learners will use Excel to employ linear, non-linear, network, and integer optimization models. Learners will use these models to optimize a variety of use-cases including scheduling, financial plans, capital budget plans, logistics, and pricing.

Conditions

Student has completed all of the following course(s): MATH 10804133 - Math & Logic, MATH 10804189 - Introductory Statistics

Intro To Ethics: Theory & App (10809166)

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/or professional standards of behavior and apply a systematic decision-making process to these situations. Keywords: Ethics

NTC Assessments Offered:

Intro To R (10156114)

1.00

Introduce learners to the foundational concepts of data programming in the open-source language R. Learners explore ways to visualize data, examine data structures, and model the relationship between variables using commands in R. Learners incorporate problem-solving and critical thinking skills as they write commands to support their work with data analysis.

Industry Credentials Accepted:
  • Google Data Analytics Certificate

Psychology Of Human Relations (10809199)

3.00

Explores the relationship between the general principles of psychology and our everyday lives. Students are given the opportunity to achieve a deepened sense of awareness of themselves and others. This understanding enables students to improve their relationships with others at work, in the family and in society. Keywords: Psych, Relationships, Human Relations, Hr psych

NTC Assessments Offered:

Intro To Psychology (10809198)

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. Keywords: Psych, Intro to Psych

NTC Assessments Offered:
National Exams Accepted:
  • CLEP® Introductory Psychology
  • AP Psychology

Data Capstone (10156105)

3.00

Applies all previous data analytics knowledge into one project. Learners perform (ETL) extraction, transformation, and loading of data. Learners query and analyze data. Learners create reports and visuals. Learners communicate results and findings to stakeholders.  

Conditions

Student has completed all of the following course(s): ITDATA 10156109 - Data Mining & Predictive Analy, ITDATA 10156113 - Data Visualizations 1, PROGRAMR 10152571 - Advanced Data: ETL

Modeling And Machine Learning (10156106)

3.00

Introduces learners to machine learning using Python. Learners process data and construct visualizations. Learners write Python code to classify data. Learners use various Python libraries to perform both supervised and unsupervised learning. Learners use Python to perform natural language processing, build neural networks, and understand deep learning.

Conditions

Student has completed all of the following course(s): ITDATA 10156109 - Data Mining & Predictive Analy, ITDATA 10156113 - Data Visualizations 1, PROGRAMR 10152571 - Advanced Data: ETL

Data Mining & Predicitve Analytics 2 (10156111)

1.00

Employs RapidMiner, R, and Orange software packages in order to explore text mining using classification algorithms. Uses k-nearest neighbor and decision trees to further explore classification on structured data. Lastly, learners evaluate time series data using forecasting algorithms. Learners demonstrate their findings via PowerPoint and short video presentations.

Conditions

Student has completed or is in process of completing all of the following course(s): ITDATA 10156109 - Data Mining & Predictive Analy

Data Mining & Predictive Analytics 3 (10156115)

1.00

Employs Python, Excel, R, and other GUI software to explore a variety of algorithms that fall under the umbrella of predictive analytics and data mining. Learners derive meaning from data using neural networks. Learners apply statistical models including linear and logistic regression. Lastly, learners evaluate data using Naïve Bayes and Bayesian Networks. Learners demonstrate their findings via PowerPoint and short video presentations.

Conditions

Student has completed or is in process of completing all of the following course(s): ITDATA 10156111 - Data Mining & Predicitve Ana 2

Optimization And Simulation 2 (10156112)

1.00

Analyze data in order to make decisions using decision trees and simulations. Learners use a variety of software tools to build decision trees in order to solve problems that involve high levels of uncertainty. Learners use a variety of tools to run simulations to solve problems including queuing, production, and games of chance.

Conditions

Student has completed or is in process of completing all of the following course(s): ITDATA 10156110 - Optimization And Simulation 1

Optimizaton And Simulation 3 (10156116)

1.00

Introduces learners to optimization and simulation from the perspective of operations research. Learners classify and optimize performance of basic operations research concepts such as: goods and services, wants and needs, strategic planning, and supply chains. Learners use SimQuick (a special Excel spreadsheet) to perform differing simulations for manufacturing, inventory, and waiting line processes. 

Conditions

Student has completed or is in process of completing all of the following course(s): ITDATA 10156112 - Optimization And Simulation 2

Quantitative Reasoning (10804135)

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.

Microeconomics (10809143)

3.00

Examines the behavior of individual decision makers, primarily consumers and firms. Topics include choices of how much to consume and to produce, the functioning of perfectly and imperfectly competitive markets, the conditions under which markets may fail, and arguments for and against government intervention. The student applies the fundamental tools of economics to real world problems.

Test-Out Option Term Definitions

Test

An exam that is scored by faculty or staff in NTC’s Testing Center.

Skill Demonstration

A performance of your expertise that is evaluated by faculty.

Combination: Test & Skill Demonstration

A combination of both a test and a skill demonstration.

Portfolio

A collection and explanation of your past learning through work or life experience.

Have Questions?

If you have questions about this program, please contact our Career Coaches at 715.803.1645.

If you have further questions regarding our Credit for Prior Learning options, please contact Student Records at studentrecords@ntc.edu or 715.803.1796.