image
image

Data Analytics Program

62 Credits | 17-18 Academic Year

Transform data into decisions and solve today’s most challenging business problems with our new Associate Degree in Data Analytics.

Technology is everywhere, and the volume of data available in the business world is exploding. Enroll today and gain the skills to turn raw data into valuable insights, propel your career within a rising industry, and be confident in knowing that the education you receive will prepare you for success.

First Semester | 15 credits

CodeTitleCredits
CISW 201Object Oriented Programming I 3.00
CISW 214Database Principles & Applications 3.00
DATA 100Survey of Information Science 3.00
OFFT 125Microsoft Excel-MOS Expert Cert 3.00
WRIT 101English Composition 3.00

Second Semester | 16 credits

CodeTitleCredits
CISW 202Object Oriented Programming II 3.00
CISW 215Database: Report Writer 3.00
DATA 110Fundaments of BI and DA 3.00
DATA 120Data Staging 3.00
MATH 126Statistics 4.00

Third Semester | 15 credits

CodeTitleCredits
BUSC 220Team Development 3.00
BUSM 105Introduction to Business 3.00
DATA 210Applied Data Analytics 3.00
DATA 220Data Science Applications 3.00
WRIT 103Writing For Business/Tech 3.00

Fourth Semester | 16 credits

CodeTitleCredits
COMM 201Public Speaking 3.00
DATA 230Visualization and Storytelling 3.00
DATA 240Data Analytics Capstone 3.00
MATH 155Pre-Calculus 4.00
PSYC 101General Psychology 3.00
 Or 
SOCI 101Principles of Sociology 3.00

Course Descriptions

CISW 201 - Object Oriented Programming I

The Object-Oriented computer programming course emphasizes concepts using JAVA as the primary object-oriented programming language. Students learn how to write, debug and execute programs in a variety of developmental environments. This course is a project-based class where object-oriented programming techniques are used to develop applications. Projects requiring control structures, methods in classe are included in the course curriculum. Data structures are introduced as arrays. 3-0-3

CISW 214 - Database Principles & Applications

Database Principles and Applications is a project-based course intended to teach students how to create, implement and maintain complex database systems. A variety of industry standard DBMS software applications are used to learn to model, design, create and maintain a relational database in a business environment. Students learn relational database schemas, SQL, functions, stored procedures, transaction management and database connectivity. Data analytics techniques are used to best meet the information needs of modern decision makers. An overview of advanced distributed database systems is introduced including Data Warehousing, Data Mining, GIS, OLAP, Big Data, Business Performance Management (BPM) and others. 3-0-3

DATA 100 - Survey of Information Science

Survey of Information Science is a course that serves as an introduction to the cynergy between business concepts, information technology and data management. Relational and distributed database systems are used to learn how to use data to support corporate operations. Students are introduced to MIS concepts by studying industry standard systems in a variety of professional fields and regulatory environments. Business ethics and privacy law are explored using case studies. 3-0-3

OFFT 125 - Microsoft Excel-MOS Expert Cert

The student will learn how to create worksheets, work with charts, pivot tables and use 'what if' analysis. At completion of the course, the student will be eligible for the MOS Expert Certification exam. 2-2-3

WRIT 101 - English Composition

Students will practice expository writing and learn the academic form of the essay and research paper. Students will focus on the development of an academically sound and challenging thesis and resulting essay. The mechanics of writing will be reviewed as needed. 3-0-3 Pre-requisite: Placement testing; successful completion of DEVS012 Reading and DEVS015 Introduction to College Writing if required, permission of the Division Director.

CISW 202 - Object Oriented Programming II

This second course in the Object-Oriented Programming sequence continues exploring object-oriented programing techniques, building on the student's basic understanding and knowledge of JAVA, advanced concepts relating to arrays, inheritance, polymorphism and recursion are examined. Searching and Sorting concepts are developed. Stacks,Trees and Queues are introduced. Finally, the course concludes by expanding graphics and programming skills. 3-0-3 Prerequisite: CISW201

CISW 215 - Database: Report Writer

Distributed database systems explores key data analytics as applied to large data - intensive problems enabling real-time decision making in distributing environments. This course examines the paradigm shift occurring as information systems gather more and more data. Theories and techniques that allow for efficient extractiion, interpretation and learning from large data sets scattered in a distributed data system are explored. A review is conducted of current applications commonly used in distributed database systems, such as, NoSQL (not SQL), DBaaS (Database as a service), Hadoop and Spark. 3-0-3 Prerequisite: CISW214 Database Principles and Applications

DATA 110 - Fundaments of BI and DA

Fundamentals of Business Intelligence and Data Analytics is an introduction to the fundamental concepts and technologies in business intelligence, data analytics and data science. Students are exposed to various analytic techniques underlying distributed storage and efficient analysis of large amounts of data. An overview of approaches used to extract information and knowledge from data, verification, testing and presentation of results. Software tools are used to provide decision-makers with accurate and timely information. Current data and analytics tools are examined. 3-0-3 Co-Requisite: MATH126

DATA 120 - Data Staging

Data staging employs an intermediate data storage area used for data processing during the extract, transform and load (ETL) process. Basic data formats are transformed into data that is staged for use in more advanced analytic tools. Practical, hands-on experience is gained using software including Excel, PowerBI and Tableau. 2-2-3 Pre-requisite: OFFT125

MATH 126 - Statistics

This course is an introduction to a field whose ideas and concepts pervade modern society and whose importance in business, technology, science and research in general is considerable and ever growing. The course consists of three parts, namely, descriptive statistics, probability and inferential statistics. Prerequisite: "C" or better in PREP021, appropriate placement score or high school records. 4-0-4

BUSC 220 - Team Development

This course provides the student with the understanding and skills necessary to communicate effectively in various group situations. Specifically, the course will prepare the student for intensive team and group interaction that they will experience in both personal and career scenarios. It will also provide a firm foundation of team-oriented theory and practical application, experience in developing group problem-solving skills, and a resource for future use. 3-0-3

BUSM 105 - Introduction to Business

Introduction to Business introduces students to modern business concepts and practices. The course focuses on basic business strategies, economics systems, management and marketing. Fundamental concepts of accounting and finance are introduced by examining financial documents, communication and research skills are reinforced by working with hands-on projects. 3-0-3

DATA 210 - Applied Data Analytics

Applied Data Analytics uses hands-on projects to expand the student's knowledge gained in the Fundamentals of Business Intelligence and DataAnalytics course. Practical skills using Excel's analytic add-ins are developed while explanding on introductory concepts. Descriptive, predictive and prescriptive analytics techniques are developed using large data sets to produce interactive dashboards. 2-2-3 Pre-Requisite: DATA110

DATA 220 - Data Science Applications

Applied programming for Data Science combines database concepts with programming techniques. Students first survey some of the most common languages commonly used in data analytics. Python and R are used for the hands-on project development assignments. Data cleansing, manipulation and abstraction techniques are used to produce informational reports used in decision-making scenarios. Python is commonly used for data visualization and R programming is used to link statistics together with programming. Both applications produce robust information based on particular data sets. 2-2-3 PreRequisites: DATA120 & CISW201

WRIT 103 - Writing For Business/Tech

Designed to train the student in effective writing, this course aims to increase the student’s ability to write with unity, coherence, and logic. It provides additional study and practice in writing letters, proposals, manuals, and reports of a business or technical nature as well as in professional and contemporary research methods. Prerequisite: WRIT101 3-0-3

COMM 201 - Public Speaking

The emphasis is on speech preparation and delivery in a variety of speaking experiences designed to improve the speaker’s capability through the application of correct speech practices. Honors Option Available Public Speaking Honors emphasizes speech preparation, and delivery, with special attention paid to crafting effective academic and professional presentations on global and international issues. Speeking experiences and presentations will be designed by individuals and groups and presented to the CCBC community, the public and other appropriate audiences. 3-0-3

DATA 230 - Visualization and Storytelling

Data Visualization and Storytelling teaches the fundamentals of how to communicate effectively using data visualization. Students learn how to go beyond conventional tools to reach the roots of data to create engaging, informative, compelling data stories. Students design, implement and maintain visualization systems using real-world data sets within practical business scenarios. Industry-standard software applications are used to manipulate data into information for stakeholders. 2-2-3 Pre-Requisite: DATA210

DATA 240 - Data Analytics Capstone

Data Analytics Capstone is interdisciplinary combining data science, business intelligence, data analytics, statistics and programming. This course offers a platform for students to apply classroom learning to business problems that challenge students to use the power of data to provide valuable insights. SAS is used to transform data into information used to make data-driven decisions. Data and code quality are stressed as students learn how to develop story visualizations using SAS software. 2-2-3 Prerequisite - DATA210

MATH 155 - Pre-Calculus

This course is designed to give students a firm background in algebra and trigonometry in preparation for calculus. Topics include detailed study of polynomial, rational, exponential, and logarithmic and trigonometric functions, along with an introduction to matrices and conic sections. Prerequisite: "C" or better in MATH129 OR MATH130, appropriate placement score, appropriate high school records or permission of the faculty. 4-0-4

PSYC 101 - General Psychology

This course examines the scientific study of behavior and mental processes and provides a survey of the major areas of psychology. Important topics and findings from psychology are reviewed. Topics include the role of science in the study of behavior, the biological foundations of behavior, learning, information processing, stress and health, social interaction, development, motivation, emotion and psychological disorders. 3-0-3

SOCI 101 - Principles of Sociology

This course provides the student with a general survey of the theories and concepts utilized in the field of sociology which contribute to a basic understanding of modern society and its structures. Key elements addressed within the course include the three foundational theoretical perspectives utilized in sociology, Functionalism, Conflict Theory and Symbolic Interactionism, the process of socialization, social institutions, such as family, marriage and religion, as well as an introduction to the basic research methods utilized in the field. 3-0-3