Syllabus

DANL 299: Data Preparation and Management, Fall 2025

Author

Byeong-Hak Choe

Published

August 25, 2025

Course Information

Course Description

This course aims to provide overview of how one can manipulate, process, clean, crunch, and collect data with hands-on and practical case studies that show you how to solve a broad set of data analysis problems effectively. We will use a computing development environment, Jupyter Notebook, which is a shell and notebook for exploratory computing. This course will cover topics such as (1) loading, cleaning, transforming, merging, and reshaping data, (2) creating informative visualizations, (3) dataset slicing, dicing, and summarizing, and (4) collecting data via web scraping and application programming interfaces (APIs). We will cover these topics to solve real-world data analysis problems with thorough, detailed examples. Computing is done in Python. Throughout the course, students will gain hands-on experience with Python and its data analysis libraries (e.g., pandas, seaborn, requests, selenium), along with practical applications of git and GitHub. We will use Python in a Jupyter Notebook environment, along with practical applications of Git and GitHub.

School of Business Mission

The School of Business at SUNY Geneseo is committed to exceptional business and economics education within the context of a strong liberal arts tradition. The School is distinguished by a uniquely accomplished and dedicated faculty, motivated and capable students, a robust professional development program, and the engaged support of alumni, employers, and business leaders. Students acquire strong quantitative, analytical, and communication skills while preparing for professional success as socially conscious contributors. We strive for teaching excellence, and we recognize that high-quality faculty scholarship and professional activities increase our impact on knowledge, practice, and pedagogy.

Bachelor of Arts in Data Analytics Program Competency Goals

  • Competency Goal 1: Our learners will have strong analytical skills.
  • Competency Goal 2: Our learners will have strong quantitative skills.
  • Competency Goal 3: Our learners will have effective communications skills.
  • Competency Goal 4: Our learners will have a thorough understanding of various functional areas of business.
  • Competency Goal 5: Our learners will have a multidimensional understanding of social responsibility.

Course Learning Outcomes

  1. Understand methods and attributes of numerous data set objects represented in Python Programming;
  2. Know how to perform a multitude of data operations in Python Programming such as grouping, pivoting, and joining;
  3. Know how to manipulate, process, and clean all types of data sets (including broken and incomplete) in Python for data analytics applications;
  4. Know how to effectively present and visualize resulting data;
  5. Know how to effectively collect data;
  6. Understand how to solve broad set of data analytics problems and describe how Python Programming is used strategically and tactically for them.

Course Requirements

Project

  • Agenda: Unifying ESG Metrics with Financial Analysis
  • Deliverables: Code + write-up published on team websites
  • Grading based on: data collection, EDA, business/economic analysis, and website usage

Course Schedule

Week Dates Topic Notes
1 Aug 25–29 Installing Tools
2 Sep 2–5 Python Basics (Part 1) Labor Day (Sep 1)
3 Sep 8–12 Python Basics (Part 2) HW 1
4 Sep 15–19 DataFrame operations with pandas (Part 1)
5 Sep 22–26 DataFrame operations with pandas (Part 2)
6 Sep 29–Oct 3 DataFrame operations with pandas (Part 3) HW 2
7 Oct 6–10 DataFrame operations with pandas (Part 4) Midterm Exam I
8 Oct 15–17 Web scraping with pandas.read_html() Fall Break (Oct 13–14)
9 Oct 20–24 Web scraping with Selenium (Part 1)
10 Oct 27–31 Web scraping with Selenium (Part 2) HW 3
11 Nov 3–7 Web scraping with Selenium (Part 3)
12 Nov 10–14 Data Collection with APIs (Part 1) HW 4
13 Nov 17–21 Data Collection with APIs (Part 2) Midterm Exam II
14 Nov 24–25 DataFrame Group operations (Part 2) Thanksgiving Break (Nov 26–28)
15 Dec 1–5 DataFrame Group operations (Part 3)
16 Dec 8 DataFrame Group operations (Part 4) HW 5

Exam Schedule

  • Midterm Exam 1: during class time in the week 7 (Oct 6–10)
  • Midterm Exam 2: during class time in the week 13 (Nov 17–21)
  • Final Exam: To be determined

Attendance

Students are allowed up to four absences without penalty. Additional absences may affect your grade unless they are formally excused. If you must miss class for a standard excused reason (e.g., illness, family emergency, transportation issues), please notify me at bchoe@geneseo.edu so the absence can be recorded appropriately.

Regular attendance is expected, as discussions, activities, and projects are central to your learning. If you anticipate challenges that may affect your attendance, please reach out—I am happy to work with you to help you stay on track.

Grading

  • Total Percentage Grade
    • Attendance: 5%
    • Homework: 20% (single lowest homework score dropped)
    • Project: 25%
    • Exams: 50%

\[ \begin{align} \quad\\ &\text{(Total Percentage Score)} \\ = &\quad\; 0.05 \times \text{(Attendance)} \\ &+ 0.05 \times \text{(Quiz \& Participation)}\\ &+ 0.20 \times \text{(Homework)}\\ &+ 0.20 \times \text{(Project)}\\ &+ 0.50 \times \text{(Exams)} \end{align} \]

  • Exam Score Calculations

\[ \begin{align} &\quad(\text{Midterm Exam Score})\\ &= \max\left\{0.50 \times \text{(Midterm 1 Score)} + 0.50 \times \text{(Midterm 2 Score)},\right.\\ &\qquad\quad\;\;\,\left.0.33 \times \text{(Midterm 1 Score)} + 0.67 \times \text{(Midterm 2 Score)}\right\}. \end{align} \]

  • The Midterm Exam Score will be the higher of the following two calculations:

    1. The simple average of Midterm Exam 1 and Midterm Exam 2
    2. The weighted average, with one-third weight on Midterm Exam 1 and two-thirds weight on Midterm Exam 2

\[ \begin{align} &\quad(\text{Total Exam Score})\\ &= \max\left\{0.50 \times \text{(Midterm Exam Score)} + 0.50 \times \text{(Final Exam Score)},\right.\\ &\qquad\quad\;\;\,\left.0.25 \times \text{(Midterm Exam Score)} + 0.75 \times \text{(Final Exam Score)}\right\}. \end{align} \]

  • The Total Exam Score will be the higher of the following two calculations:

    1. The simple average of Midterm Exam and Final Exam
    2. The weighted average, with one-fourth weight on Midterm Exam and three-forth weight on Final Exam.

  • Letter Grade Scale
    Total percentage scores are converted to letter grades according to the following ranges:

\[ \begin{align} 100 &≥ A ≥ 93 > A− ≥ 90\\ 90 &> B+ ≥ 87 > B ≥ 83 > B− ≥ 80\\ 80 &> C+ ≥ 77 > C ≥ 73 > C− ≥ 70\\ 70 &> D ≥ 60 > E \end{align} \]

Policies

Make-up Exams

Make-up exams will not be given unless you have either a medically verified excuse or an absence excused by the University. For religious obligations, notify the instructor by email at least two weeks in advance to set an alternative time. A missed exam without an excused absence earns a grade of zero.

Artificial Intelligence (AI)

Unless AI tools are explicitly permitted for homework or in-class quizzes, you must complete your work independently. Using tools like ChatGPT for any aspect of coursework is a form of academic dishonesty and undermines the development of your own skills. If you have questions, please ask.

📝 If you use AI for a particular assignment and/or project, you must also:
  • 📝 You must document which AI platforms and tools you used.
  • 📤 You must include your prompts and AI outputs with your assignment submission.
  • 🧠 You must include a reflection on your AI usage and learning process.

Academic Integrity and Plagiarism

All homework assignments and exams must be your original work. Academic dishonesty will not be tolerated. Examples include:

  • Representing the work, thoughts, or ideas of another person as your own
  • Allowing others to represent your work, thoughts, or ideas as theirs
  • Being complicit in academic dishonesty by suspecting or knowing of it and not taking action

See: Academic Dishonesty Policy and Procedures and Plagiarism Tutorial Brightspace Link

Accessibility

SUNY Geneseo is dedicated to providing an equitable and inclusive educational experience for all students. The Office of Accessibility (OAS) will coordinate reasonable accommodations for persons with disabilities to ensure equal access to academic programs, activities, and services offered by SUNY Geneseo.

Students with approved accommodations may submit a semester request to renew their academic accommodations. More information on the process for requesting academic accommodations is on the OAS website.

Questions? Contact the OAS by email, phone, or in-person:

Office of Accessibility Services
Erwin Hall 22
585-245-5112
access@geneseo.edu

Public Health and Class Attendance

If you are experiencing symptoms associated with COVID on a day that class meets in-person, do not attend. Communicate proactively about absences and contact the Dean of Students if you expect to be out for an extended period.

Religious Observations and Class Attendance

New York State Education Law 224-a stipulates that “any student in an institution of higher education who is unable, because of [their] religious beliefs, to attend classes on a particular day or days shall, because of such absence on the particular day or days, be excused from any examination or any study or work requirements” (see General Classroom Policies for more information). SUNY Geneseo has a commitment to inclusion and belonging, and I want to stress my respect for the diverse identities and faith traditions of students in my class. If you anticipate an absence due to religious observations, please contact me as soon as possible in advance to discuss your needs and arrange make up plans. The New York State Department of Civil Service maintains a calendar of major religious observations.

Military Obligations and Class Attendance

Federal and New York State law requires institutions of higher education to provide an excused leave of absence from classes without penalty to students enrolled in the National Guard or armed forces reserves who are called to active duty. If you are called to active military duty and need to miss classes, please let me know and consult as soon as possible with the Dean of Students.

Personal Health, Well-being, and Basic Needs

Well-Being

Prioritizing well-being can support the achievement of academic goals and alleviate stress. Eating nutritious foods, getting enough sleep, exercising, avoiding drugs and alcohol, maintaining healthy relationships, and building in time to relax all help promote a healthy lifestyle and general well-being. Your health and wellbeing are foundational to your ability to learn, and if you find that you are feeling unwell (physically or mentally) and it is impacting your ability to complete your coursework, please reach out. In a similar way, I will occasionally ask for some patience and flexibility on your part.

If I am slow responding to an email, if I take some time to grade an assignment, or if I am a bit late posting course materials, please be patient (and feel free to send me a ‘nudge’; I will not be offended). You will never suffer any disadvantage in the course because of delays on my part. Remember that we are all in this together.

Basic Needs Statement

In order to foster a sense of belonging and connection, a state of financial, mental, emotional and physical stability must be achieved. If you are facing food insecurity, displacement, an emergency, crisis, or health-related or medical expense, you are not alone. Concerns about academic performance, health situations, family health and wellness (including the loss of a loved one), interpersonal relationships and commitments, and other factors can contribute to stress. Students are strongly encouraged to communicate their needs to faculty and staff and seek support if they are experiencing unmanageable stress or are having difficulties with daily functioning. The Dean of Students (585-245-5706) can assist and provide direction to appropriate campus resources. For more information, visit the Dean of Students Office website.

Mental Health

As a student, you may experience a range of challenges that can impact your mental health and thus impact your learning; common examples include increased anxiety, shifts in mood, strained relationships, difficulties related to substance use, trouble concentrating, and lack of motivation, among many others. These experiences may reduce your ability to participate fully in daily activities and affect your academic performance.

SUNY Geneseo offers free, confidential counseling for students through Student Health and Counseling, and seeking support for your mental health can be key to your success at college. You can learn more about the various mental health services available on campus online. To request a counseling appointment, please complete the online form.

Guidelines for Attendance and Public Health

SUNY Geneseo is a residential liberal arts college where we all learn together in a shared space. This classroom community is vital for engaging in discussions, solving problems, and answering questions together. Learning is an active process, and it requires engagement - on my part and yours. I promise to create an interactive and collaborative classroom space, and in return I expect you to attend and engage in the activities.

It’s possible that some of you may get sick over the course of the semester. Because we want you to be successful and because we value your contribution to the course, we expect you to prioritize attendance. If you are not feeling well and your symptoms do not allow you to attend class, stay home (except to go to the health center), rest, and take care of yourself. You can find more guidelines from the Center for Disease Control for precautions when sick which cover flu, COVID, and other illnesses.

I expect you to communicate with me directly about your absences. I can support you to keep up with class if you are out for an illness, but I need you to take responsibility for being transparent and clear in letting me know when you are out and why. Although I can work with you on keeping up, you may miss some course content and extended absences may impact your ability to realize your full potential in this class. For extended absences (i.e., more than a couple of days of classes), you should contact the Dean of Students who can assist with reaching out to your faculty.

Food Security for SUNY Geneseo Students

SUNY Geneseo is committed to supporting students who are experiencing food insecurity. If you’re unfamiliar with the phrase “food insecurity,” you can learn more at the following link on Feeding America’s website: Understanding Food Insecurity.

Knights’ Harvest Pantry, our on-campus food pantry, is a collaborative initiative supported by Campus Auxiliary Services (CAS) and facilitated by trained student volunteers. The program is advised by the Assistant Director of Student Volunteerism and Community Engagement in partnership with the Geneseo Opportunities for Leadership Development (GOLD) program.

Students who are in need can confidentially request a bag of food and basic hygiene supplies through our website. These bags typically include non-perishable items and, when available, fresh fruits, vegetables, meat, and dairy products. Pickups take place at the GOLD Leadership Center in MacVittie College Union, Room 114.

We are committed to protecting student privacy and promoting dignity, while also working to destigmatize food insecurity on our campus. If Knights’ Harvest Pantry does not fully meet your needs or if you’d prefer to discuss your situation privately, please reach out to Cheyenne DeMarco, Assistant Director of Student Volunteerism and Community Engagement, at cdemarco@geneseo.edu for a one-on-one consultation.

Please note that Knights’ Harvest Pantry is closed during official SUNY breaks, including Fall Break, Winter Intersession, Spring Break, and summer between semesters. During these times, students are encouraged to access the Geneseo-Groveland Emergency Food Pantry, located at 31 Center Street, Geneseo, NY 14454. For updates on pantry hours, events, and additional support opportunities, follow us on Instagram or Facebook: @knightsharvestgeneseo. For questions or support, contact Cheyenne DeMarco at cdemarco@geneseo.edu or (585) 245-5893.

Emergency Funding

The college has three sources of emergency funding for students experiencing short-term financial crises. The Camiolo Student Emergency Loan Fund (SELF) provides short-term loans to students for situations both temporary and beyond their control. The SELF was established with the expectation that students who use the fund seek to “pay it forward” as soon as they are able by contributing to the fund so other students can be helped, too. While there is not a legal obligation, the donors hope that student loan recipients respect and honor the value of community and helping others in their time of crisis. The One Knight Student Aid Emergency Fund assists Geneseo students who are facing financial emergencies mainly related to the COVID-19 pandemic. The fund offers grants (one-time award) depending on a student’s documented financial need. For those students expecting a refund from financial aid, a Temple Hill loan of up to $500 can be offered prior to the approved loan dispersal. If you are experiencing financial hardship, please contact the Dean of Students (585-245-5706), who can assist and provide direction to appropriate campus resources.

SUNY Geneseo’s Commitments, Mission and Values

SUNY Geneseo has several core documents that articulate our shared commitments and learning objectives. These include:

Disclaimer

The syllabus may be subject to change during the semester. If it is changed, you will be notified via email and Brightspace.

Back to top