IT-Data and Analytics Specialist Associate Degree

Program Overview

The IT-Data and Analytics Specialist program at Madison College equips students with practical skills in data engineering and analytics, preparing them for employment in the rapidly-growing field of data analytics. The program emphasizes valuable skills sought by employers, such as Python programming, relational database technologies/programming, and data-related cloud expertise. Graduates are prepared for careers as Data Analysts and Data Wranglers, with opportunities for employment in various industries and competitive salaries and benefits.

Program Outline

Degree Overview:

Overview:

The IT-Data and Analytics Specialist program at Madison College provides students with practical skills in data engineering and analytics, preparing them for employment in the rapidly-growing field of data analytics. The program emphasizes valuable skills sought by employers, such as Python programming, relational database technologies/programming, and data-related cloud expertise.

Objectives:

• Train students in the technical skills required for data-centric jobs in various industries, including information technology, government, insurance, medicine, marketing, manufacturing, service, software development, wholesale and retail sales, utilities, banking, and academics.
• Equip students with the knowledge and abilities to prepare data for analysis, discover trends, solve analytics tasks through machine learning, and communicate findings effectively.

Outline:

Program Content and Structure:

• Core Classes:
• Excel Beginning
• Excel Intermediate
• Exploration of Information Technology
• IT Security Awareness
• Website Development
• Python for Developers
• AI Fundamentals
• Introduction to Databases
• SQL Database Programming
• Data Visualization
• Data Engineering
• Written Communication
• Math of Finance
• Job Search Preparation
• Cloud for Developers
• UIUX and Web Accessibility
• Predictive Analytics
• Contemporary American Society
• Psychology of Human Relations
• Agile Practices
• Applied Analytics in the Cloud
• Data Analytics Internship
• Oral/Interpersonal Communication
• Elective

Course Schedule:

• First Semester: Excel Beginning, Excel Intermediate, Exploration of Information Technology, IT Security Awareness, Website Development, Python for Developers, AI Fundamentals, Introduction to Databases
• Second Semester: SQL Database Programming, Data Visualization, Data Engineering, Written Communication, Math of Finance
• Third Semester: Job Search Preparation, Cloud for Developers, UIUX and Web Accessibility, Predictive Analytics, Contemporary American Society, Psychology of Human Relations

Careers:

Potential Career Paths:

Graduates of the IT-Data and Analytics Specialist program are prepared for the following career paths:

• Data Analyst
• Data Wrangler

Opportunities and Outcomes:

• Employment in the rapidly-growing field of data analytics
• Competitive salaries and benefits
• Opportunities for career advancement in various industries