The Data Analytics Associate Degree is a 63 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.

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.

Condition: Accepted into the Business Management Associate Degree program, Data Analytics Associate Degree, or an IT Associate Degree program, Technical Diploma or Certificate, or with Dean or Associate Dean approval.

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

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:

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.

Pre/Corequisites: 10-152-500 IT DEVELOPMENT AND DESIGN FUNDAMENTALS or 10-154-104 FOUNDATIONS OF TECHNICAL SUPPORT or Accepted into the Business Analytics Associate Degree, Data Analytics Associate Degree or Data Analysis Specialist certificate.

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.

Pre/Corequisite: 10-152-531 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.

Pre/Corequisite: 10-152-532 DATA CONCEPTS B.

Industry Credentials Accepted:
  • Google Data Analytics Certificate

MATH & LOGIC (10804133)

3.00

Students will apply mathematical problem solving techniques. Topics will include symbolic logic, sets, algebra, Boolean algebra and number bases.

NTC Assessments Offered:

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:

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.

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.

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

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.

NTC Assessments Offered:

INTRO TO PSYCHOLOGY (10809198)

3.00

This introductory course in psychology is a survey of the multiple aspects of human behavior. It involves a survey of the theoretical foundations of human functioning in such areas as learning, motivation, emotions, personality, deviance and pathology, physiological factors and social influences. It directs the student to an insightful understanding of the complexities of human relationships in personal, social and vocational settings.

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

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.

Pre/Corequisite: 10-152-500 IT DEV & DESIGN FUNDAMENTALS or 10-156-100 DATA FUNDAMENTALS.

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.

Pre/Corequisite: 10-152-501 PROGRAMMING CONCEPTS 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.

Pre/Corequisite: 10-152-502 PROGRAMMING CONCEPTS B.

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.

Prerequisite: 10-152-533 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

Pre/Corequisite: 10-152-534 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.

Pre/Corequisite: 10-152-535 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.

Prerequisite: 10-152-533 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.

Pre/Corequisite: 10-156-113 DATA VISUALIZATIONS 1.

ORAL/INTERPERSONAL COMMUNICATION (10801196)

3.00

Focuses upon developing speaking, verbal and nonverbal communication and listening skills through individual presentations, group activities and other projects.

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.

Prerequisite: A score of 50 or higher on the Accuplacer for algebra or 18 or higher ACT score or 10-804-107 COLLEGE MATH or 10-804-123 MATH W/BUSINESS APPS or 10-804-133 MATHEMATICS AND LOGIC or 10-504-118 INTERMEDIATE ALGEBRA W/APPS or 10-804-195 COLLEGE ALGEBRA or 10-804-198 CALCULUS 1 with a grade of 'C' or better.

National Exams Accepted:
  • AP Statistics

DATA REPORTING (10152335)

3.00

Introduces database querying and reporting using leading tools and frameworks. Learners will design,create and publish reports that access diverse datasets using a variety of tools including Crystal Reports and Microsoft SQL Reporting Services. Additional topics include SQL, report distribution, data analysis, data security and ethical handling of sensitive data.

Prerequisites: 10-152-531 DATA CONCEPTS A, 10-152-532 DATA CONCEPTS B and 10-152-533 DATA CONCEPTS C.

NTC Assessments Offered:

ADVANCED DATA MANAGEMENT A (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.

10-152-570 Prerequisite: 10-152-536 DATABASE DESIGN AND SQL C.

ADVANCED DATA MANAGEMENT B (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.

Prerequisite: 10-152-536 DATABASE DESIGN AND SQL C.

ADVANCED DATA MANAGEMENT C (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.

Prerequisite: 10-152-536 DATABASE DESIGN AND SQL C.

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.

Prerequisites: 10-804-189 INTRODUCTORY STATISTICS and 10-804-133 MATH & LOGIC.

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.

Prerequisites: 10-804-189 INTRODUCTORY STATISTICS and 10-804-133 MATH & LOGIC.

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

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.

NTC Assessments Offered:

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.

Prerequisite: 10-156-109 DATA MINING & PREDICTIVE ANALYTICS 1.

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.

Prerequisite: 10-156-110 OPTIMIZATION AND SIMULATION 1.

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.

Pre/Corequisite: 10-156-111 DATA MINING & PREDICTIVE ANALYTICS 2.

OPTIMIZATON AND SIMULATION 3 (10156116)

1.00

TBD

Pre/Corequisite: 10-156-112 OPTIMIZATION AND SIMULATION 2.

QUANTITATIVE REASONING (10804135)

3.00

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.

ECONOMICS (10809195)

3.00

This course is designed to give an overview of microeconomics, macroeconomics, and international economics. Concepts include scarcity, resources, alternative economic systems, growth, supply and demand, monetary and fiscal policy, inflation, unemployment and global economic issues.

NTC Assessments Offered:
National Exams Accepted:
  • CLEP® Principles of Microeconomics
  • AP Macroeconomics
  • CLEP® Principles of Macroeconomics
  • AP Microeconomics

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.