DANN 2000 Proseminar in Data Analytics I

[1 credit hour]

Students are introduced to the academic and professional nature of the data analytics major. Topics covered include professional socialization, honor theses, portfolio construction, preparation for graduate studies, and career development.

Term Offered: Spring, Fall

DANN 4000 Proseminar in Data Analytics II

[2 credit hours]

Discussion among faculty and students in the data analytics major with a special focus on the development of a professional portfolio for graduate work or career.

Prerequisites: DANN 2000 with a minimum grade of D-

Term Offered: Spring, Fall

DANN 4500 Applied Data Analytics 1 – Foundations and Automation with Excel VBA

[3 credit hours]

This course is designed for students with little to no prior programming experience in Excel VBA (Visual Basic for Applications). The course begins with Excel VBA basics and gradually builds toward automating processes using VBA. From basic spreadsheet operations to advanced task automation, students will learn how to design and execute an automation project, manage data, build custom solutions, and streamline repetitive tasks in real-world contexts. Topics include working with cells and ranges, input/output interactions, variables and arrays, logic and control structures, data cleaning, pivot tables, debugging, creating custom functions, user forms, handling files and events, security features, building dashboards, data visualization, and exporting reports.

Term Offered: Spring, Summer, Fall

DANN 4600 Applied Data Analytics 2 – Python Programming and Version Contro

[3 credit hours]

This hands-on, project-based course introduces students to the fundamentals of Python programming and version control using Git and GitHub. Designed for students with prior experience in Excel VBA or similar scripting, the course builds on existing logic and automation skills to explore more powerful tools for data manipulation, automation, and collaborative coding. Students will learn core Python concepts including data types, control structures, unctions, file input/output, working with Excel files, and Python standard libraries. Simultaneously, students will develop practical Git skills for tracking changes, collaborating with others, and managing real-world coding projects. Through individual and team-based projects, students will apply Python and Git to solve real-world problems, automate tasks, and work collaboratively using GitHub repositories. By the end of the course, students will be able to write clean, functional Python code and manage coding workflows in a collaborative environment.

Term Offered: Spring, Summer, Fall

DANN 4940 Data Analytics Internship

[1-4 credit hours]

A prearranged work-study experiential learning course where students gain practical experience applying their data analytics knowledge with a specific firm, government agency, or nonprofit group.

Prerequisites: DANN 2000 (may be taken concurrently) with a minimum grade of D- and (PSY 2100 (may be taken concurrently) with a minimum grade of D- or SOC 3290 (may be taken concurrently) with a minimum grade of D- or GEPL 4420 (may be taken concurrently) with a minimum grade of D- or MATH 2600 (may be taken concurrently) with a minimum grade of D-) and (ECON 2810 (may be taken concurrently) with a minimum grade of D- or GEPL 4110 (may be taken concurrently) with a minimum grade of D-)

Term Offered: Spring, Summer, Fall