The B.S. in Data Management/Data Analytics is designed to prepare science professionals who can set up a database environment, design databases, acqiure data, wrangle it, analyze it, and visualize it to different audiences as part of the decision-making process.
Information Technology Fundamentals
Introduction to IT
Introduction to IT examines information technology as a discipline and the various roles and functions of the IT department as business support. Students are presented with various IT disciplines including systems and services, network and security, scripting and programming, data management, and business of IT, with a survey of technologies in every area and how they relate to each other and to the business.
IT Foundations is the first course in a two-part series preparatory for the CompTIA A+ exam, Part I. Students will gain an understanding of personal computer components and their functions in a desktop system, as well as computer data storage and retrieval; classifying, installing, configuring, optimizing, upgrading, and troubleshooting printers, laptops, portable devices, operating systems, networks, and system security; recommending appropriate tools, diagnostic procedures, preventative maintenance and troubleshooting techniques for personal computer components in a desktop system; strategies for identifying, preventing, and reporting safety hazards and environmental/human accidents in a technological environments; and effective communication with colleagues and clients as well as job-related professional behavior.
IT Applications is a continuation of the IT Foundations course preparatory for the CompTIA A+ exam, Part II. Students will gain an understanding of personal computer components and their functions in a desktop system. Also covered is computer data storage and retrieval, including classifying, installing, configuring, optimizing, upgrading, and troubleshooting printers, laptops, portable devices, operating systems, networks, and system security. Other areas include recommending appropriate tools, diagnostic procedures, preventative maintenance and troubleshooting techniques for personal computer components in a desktop system. The course then finished with strategies for identifying, preventing, and reporting safety hazards and environmental/human accidents in a technological environments, and effective communication with colleagues and clients as well as job-related professional behavior.
Critical Thinking and Logic
Reasoning and Problem Solving helps students internalize a systematic process for exploring issues that takes them beyond an unexamined point of view and encourages them to become more self-aware thinkers by applying principles of problem identification and clarification, planning and information gathering, identifying assumptions and values, analysis and interpretation of information and data, reaching well-founded conclusions, and identifying the role of critical thinking in the disciplines and professions.
Introduction to Communication
This introductory communication course allows students to become familiar with the fundamental communication theories and practices necessary to engage in healthy professional and personal relationships. Students will survey human communication on multiple levels and critically apply the theoretical grounding of the course to interpersonal, intercultural, small group, and public presentational contexts. The course also encourages students to consider the influence of language, perception, culture, and media on their daily communicative interactions. In addition to theory, students will engage in the application of effective communication skills through systematically preparing and delivering an oral presentation. By practicing these fundamental skills in human communication, students become more competent communicators as they develop more flexible, useful, and discriminatory communicative practices in a variety of contexts.
English Composition I
English Composition I introduces learners to the types of writing and thinking that are valued in college and beyond. Students will practice writing in several genres with emphasis placed on writing and revising academic arguments. Instruction and exercises in grammar, mechanics, research documentation, and style are paired with each module so that writers can practice these skills as necessary. Comp I is a foundational course designed to help students prepare for success at the college level. There are no prerequisites for English Composition I.
Survey of United States Constitution and Government
This course is an introduction to the U.S. Constitution and the U.S. government. Topics include (1) structure and relevance of the U.S. Constitution, (2) structure and function of governmental branches, and (3) political participation and policy making.
This course provides an introduction of algebraic concepts and the development of the essential groundwork for College Algebra. Topics include: A review of basic mathematical skills, the real number system, algebraic expressions, linear equations, graphing, exponents and polynomials.
Introduction to Humanities
This introductory humanities course allows students to practice essential writing, communication, and critical thinking skills necessary to engage in civic and professional interactions as mature, informed adults. Whether through studying literature, visual and performing arts, or philosophy, all humanities courses stress the need to form reasoned, analytical, and articulate responses to cultural and creative works. Studying a wide variety of creative works allows students to more effectively enter the global community with a broad and enlightened perspective.
Introduction to Geography
This course will discuss geographic concepts, places and regions, physical and human systems and the environment.
This course provides further application and analysis of algebraic concepts and functions through mathematical modeling of real-world situations. Topics include: real numbers, algebraic expressions, equations and inequalities, graphs and functions, polynomial and rational functions, exponential and logarithmic functions, and systems of linear equations.
Introduction to Probability and Statistics
In this course, students demonstrate competency in the basic concepts, logic, and issues involved in statistical reasoning. Topics include summarizing and analyzing data, sampling and study design, and probability.
Network and Security
Network and Security – Foundations
This course introduces students to the components of a computer network and the concept and role of communication protocols. The course will cover widely used categorical classifications of networks (i.e CAN, LAN, MAN, WAN) as well as network topologies, physical devices, and layered abstraction. The course will also introduce students to basic concepts of security, covering vulnerabilities of networks and mitigation techniques, security of physical media, and security policies and procedures.
Networks focuses on: network topologies including: protocols, ports, addressing schemes, routing, and wireless communication standards; physical and logical topologies, including wiring standards; differentiating, installing, and configuring network devices; and troubleshooting network connectivity. This course prepares students for the following certification exam: CompTIA Network+.
Scripting and Programming
Scripting and Programming - Foundations
This course provides an introduction to programming covering data structures, algorithms, and programming paradigms. The course presents the student with the concept of an object as well as the object-oriented paradigm and its importance. A survey of languages is covered and the distinction between interpreted and compiled languages is introduced.
Introduction to Programming in Python
Introduction to Programming in Python provides a foundation for programming in Python, including the fundamentals of the language and features to control program flow and manipulate data sets. This course builds on Scripting and Programming applications and paired with the knowledge gained in Web Development Foundations will prepare the student develop Python scripts that extract and manipulate data from unstructured data sources. This course also covers Python libraries including acquisition and configuration.
Scripting and Programming - Applications
This course provides an introduction to programming. It covers data structures, algorithms, and programming paradigms. It presents the concept of an object as well as the object-oriented paradigm and its importance. A survey of languages is covered and the distinction between interpreted and compiled languages is introduced.
General Science Content
Integrated Physical Sciences
This course provides students with an overview of the basic principles and unifying ideas of the physical sciences: physics, chemistry, and Earth sciences. Course materials focus on scientific reasoning and practical and everyday applications of physical science concepts to help students integrate conceptual knowledge with practical skills.
Web Development Foundations
This course prepares students for the CIW Site Development Associate certification. The course introduces students to web design and development by presenting them with HTML5 and CSS, the foundational languages of the web, by reviewing media strategies, and by using tools and techniques commonly employed in web development.
The Spreadsheets course will help students become proficient in using spreadsheets to analyze business problems. Students will demonstrate competency in spreadsheet development and analysis for business/accounting applications (e.g., using essential spreadsheet functions, formulas, charts, etc.)
Data Management - Foundations
This course introduces students to the concepts and terminology used in the field of data management. They will be introduced to Structured Query Language (SQL) and will learn how to use Data Definition Language (DDL) and Data Manipulation Language (DML) commands to define, retrieve, and manipulate data. This course covers differentiations of data—structured vs. unstructured and quasi-structured (relational, hierarchical, XML, textual, visual, etc); it also covers aspects of data management (quality, policy, storage methodologies). Foundational concepts of data security will be included.
Data Management - Applications
This course covers conceptual data modeling and provides an introduction to MySQL. Students will learn how to create simple to complex SELECT queries including subqueries and joins, and will also learn how to use SQL to update and delete data. Topics covered in this course include exposure to MySQL; developing physical schemas; creating and modifying databases, tables, views, foreign keys/primary keys (FKs/PKs), and indexes; populating tables; and developing simple Select-From-Where (SFW) queries to complex 3+ table join queries.
Structured Query Language
This course focuses on structured query language (SQL). It starts with a review of the basic statements and continues on to the creation of complex queries that affect multiple tables and utilize SQL functions. Data manipulation language (DML) and data definition language (DDL) are also covered, thus enabling the student to create and maintain database objects and modify data by using SQL commands.
Database Server Administration
This course covers the installation, configuration, and administration of database servers. Students will be introduced to all the logical and physical components of a database server and learn to set up a server in a network environment. Tools and strategies for access and space management will be covered, as well as backup, restoration, and upgrade techniques.
Data Wrangling with MongoDB
This course elaborates on concepts covered in Introduction to Data Science, helping to develop skills crucial to the field of data science and analysis. It explores how to wrangle data from diverse sources and shape it to enable data-driven applications—a common activity in many data scientists' routine.
Topics covered include gathering and extracting data from widely-used data formats, assessing the quality of data, and exploring best practices for data cleaning. This course also introduces MongoDB, covering the essentials of storing data and the MongoDB query language together with exploratory analysis using the MongoDB aggregation framework.
Students will learn the fundamentals of dynamic data structures, such as bags, lists, stacks, queues, trees, hash tables, and their associated algorithms, using object-oriented design and abstract data types as a design paradigm. The course emphasizes problem solving and techniques applied to the design of efficient, maintainable software applications. Students will implement simple applications using the techniques learned.
This course covers basic elements of technical communication, including professional written communication proficiency; the ability to strategize approaches for differing audiences; and technical style, grammar, and syntax proficiency.
Business of IT
Business of IT – Project Management
This course introduces the student to the project management & business analysis process within the context of an IT project. Fundamental concepts of project management will be covered including all phase of project management during a system life cycle including business analysis, requirements capturing, issue tracking, and release planning. Additional topics to include: development environments (dev, integration, QA, production), help desk and support, IT planning for business continuity. This course prepares students for the following certification exam: CompTIA Project+.
Business of IT – Applications
This course introduces IT students to information systems (IS). The course includes important topics related to management of information systems (MIS), such as system development, and business continuity. The course also provides an overview of management tools and issue tracking systems.
Introduction to Data Science
This Introduction to Data Science course introduces the data analysis process and common statistical techniques necessary for the analysis of data. Students will ask questions that can be solved with a given data set, set up experiments, use statistics and data wrangling to test hypotheses, find ways to speed up their data analysis code, make their data set easier to access, and communicate their findings.
This course presents the end-to-end process of investigating data through a machine learning lens. Topics covered include: techniques for extracting data, identifying useful features that best represent data, a survey of commonly-used machine learning algorithms, and methods for evaluating the performance of machine learning algorithms.
Data Analysis with R
This course focuses on exploratory data analysis (EAD) utilizing R. EAD is an approach for summarizing and visualizing the important characteristics of a data set. Exploratory data analysis focuses on exploring data to understand the data’s underlying structure and variables to develop intuition about the data set, to consider how that data set came into existence, and to decide how it can be investigated with more formal statistical methods.
This course covers the application of design principles, human perception, color theory, and effective storytelling in the context of data visualization. It addresses presenting data to others, facilitating aspirations to be an analyst or data scientist, and advancing technology with visualization tools. Additionally, this course focuses on how to visually encode and present data to an audience.
This course covers the most common tools, techniques, and procedures involved in data analytics. Students will review all the disciplines involved with data analytics learned in previous courses and get a better understanding of how they all relate to one another.