Program Requirements

Program Requirements

IT - Data Analyst

Associate Degree  |  10-156-3

www.cvtc.edu
1-800-547-2882

Start Dates: August, January

Effective: August 2024

First Semester

Course #Course TitleCreditsPrerequisites/Comments

103-170Microsoft Excel1This course incorporates Microsoft Office Excel skills and how it is used in academic and business environments. Students will apply software features to the successful completion of business-related projects and scenarios.

152-118Intro to Computers & Progrmmng31st 8 weeksEmpower your future with computing! Explore the fundamental knowledge and skills you'll need for success in Information Technology. Learn to navigate operating systems like an ace, solve problems like a pro, and stay secure like a whiz. Plus, get a head start with programming concepts and JavaScript. Go ahead and open the door to exciting career opportunities.

152-132Database 132nd 8 weeks | Program studentThis course is designed as a first database course, this course introduces students to the concepts of relational database management and beginning SQL. Students explore the history and evolution of databases and investigate current database usage in industry. This relational model is examined and utilized as students' practice creating, populating, manipulating, and querying multi-table relational databases using the SQLite database.

156-101Systems Analysis and Design3Systems Analysis and Design is a broad term for describing methodologies for developing high quality Information System which combines Information Technology, people, and data to support business requirement. In this course you will learn the system development life cycle.

801-136English Composition 13This course is designed for learners to develop knowledge and skills in all aspects of the writing process. Planning, organizing, writing, editing, and revising are applied through a variety of activities. Students will analyze audience and purpose, use elements of research and format documents using standard guidelines. Individuals will develop critical reading skills through analysis of various written documents.

804-133Math & Logic3Students will apply problem solving techniques from discrete mathematics. Topics include symbolic logic, sets, algebra, and base number systems.

TOTAL CREDITS:16 

Second Semester

Course #Course TitleCreditsPrerequisites/Comments

102-109Business Analytics3103-170 or 103-102Students will utilize common business software to analyze datasets present in typical business management situations, translate the analysis into business recommendations that will improve business performance, and effectively create and present analysis recommendations to decision-makers.

152-101Programming Fundamentals32nd 8 weeks | Program student; 152-118 or concurrentThis course is designed to be a student's second programming course. It provides an in-depth look into fundamental computer programming concepts including: variables, input-processing-output, if- then-else logic, for loops, while loops, array processing, and functions. With an emphasis on hands-on activities, students use pseudocode and flowcharting tools to build problem-solving skills. Programming concepts and problem-solving skills are synergized and applied through the completion of a variety of programming exercises using the JavaScript programming language. The course will culminate with a Final Project lab.

152-136Database 231st 8 weeks | 152-132This course provides a more in-depth study of SQL (Structured Query Language) and introduces database design. Students practice with database design methodologies, tools, and techniques via hands-on activities covering SQL, data normalization, Entity-Relationship Diagrams, and relational data modeling. Tools like Dia and MySQL are used to give students practical experience with the creation, documentation, and testing of relational databases.

156-103BI Data 1-Paginated3152-132Presenting useful information from a system's database is at the heart of any Information System. In this course you will learn the basics of report writing utilizing SQL and a reporting application.

801-196Oral/Interpersonal Comm3Focuses 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.

TOTAL CREDITS:15 

Third Semester

Course #Course TitleCreditsPrerequisites/Comments

102-188Project Management3The learner applies the skills and tools necessary to design, implement, and evaluate formal projects. Each learner will demonstrate the application of the role of project management by developing a project proposal, using relevant software, working with project teams, sequencing tasks, charting progress, dealing with variations, budgets and resources, implementing a project, and assessing the outcome.

156-102Python Data Programming32nd 8 Weeks | 152-101 and 152-136SQL and other ETL techniques are effective for most data conversions but sometimes you need the functionality of a programming language to loop through data to effectively populate a database table. In this course you will learn the basics of the Python programming language with an emphasis on the database and reporting capabilities of the language.

156-106BI Data 2-Interactive3156-103Online analytical processing, or OLAP, is an approach to answer multi-dimensional analytical (MDA) queries swiftly in computing. OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. In this course you will be introduced to an OLAP reporting application.

156-109Introductory ETL31st 8 weeks | 152-136 and 103-170Extract, Transform, and Load is an essential technique for moving data between computer systems. In this course you will learn various techniques to move and integrate data between systems and databases.

809-196Intro to Sociology3This course introduces students to the basic concepts of sociology, including culture, race, socialization, gender, group behavior, deviance, social stratification, and social change. Students will use the sociological perspective to analyze major social institutions, multiculturalism, and social issues affecting our selves and society. Students will participate in a variety of experiences to strengthen and demonstrate these perspectives and skills. Critical thinking skills are emphasized, and learning activities include applying sociological theory to current issues in society. The focus is on how social factors and forces influence beliefs and behaviors, both in our personal lives and at work.

TOTAL CREDITS:15 

Fourth Semester

Course #Course TitleCreditsPrerequisites/Comments

156-115BI Data 3-Visualization31st 8 Weeks | 156-106 and 152-136Business intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis of business information. BI technologies provide historical, current, and predictive views of business operations. Visualizations are often incorporated into executive dashboards for optimal business decisions. In this course you will be exposed to elements of Business Intelligence emphasizing visualizations.

156-119Machine Learning3152-136 and 156-106 and (156-102 or 152-140)Machine learning (ML) is the study of computer algorithms that can improve automatically through experience and by the use of data. It is seen as a part of artificial intelligence. Machine learning algorithms build a model based on sample data, known as training data, in order to make predictions or decisions without being explicitly programmed to do so. In this course you will be exposed to introductory techniques of machine learning to analyze data.

156-123Data Security and Privacy3152-136 and 156-103Data Security and Privacy is the protection of personal data from those who should not have access to it and the ability of individuals to determine who can access their personal information. In this course you will explore the various data privacy laws and techniques to security an organizations data.

156-130Data Analytics Capstone32nd 8 Weeks | 152-136 and 156-109; Corequisite: 156-115The Data Analytics Capstone culminates and assesses the students experience in the Information Technology – Data Specialist program. This advanced course provides further hands-on experience in business intelligence. Students will work in small groups to create a database with supporting reporting objects. Students will be required to use project management techniques during the development process.

809-198Intro to Psychology3This 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. Additional topics include research methods, biological and environmental impacts, development, sensation and perception, consciousness, intelligence and stress. This course directs the student to an insightful understanding of the complexities of human relationships in personal, social, and vocational settings.

TOTAL CREDITS:15 

Close this window.

Course Title

###-### | # Credits

Course Description

Find Upcoming Sections

Minimum Program Credits Required: 61

A Grade of "C-" or Higher is Required in All Courses.

2.0 Minimum Program Cumulative GPA Required for Graduation
If a student does not enroll in any courses at CVTC for two or more consecutive semesters, the student will be required to reapply with Admissions. Students must abide by any changes in admission requirements and degree requirements.

Updated: 7/15/2024 12:10 p.m.  |  Printed: 12/21/2024 7:21 p.m.

Print Page

Join Us To

Experience CVTC for Yourself

Explore CampusAttend an EventSchedule a Visit
I'm a(n)