STAT 440 Fall 2023 Syllabus

STAT 440 Statistical Data Management

3/4 Credit Hours - Major Elective

Sections 1UG/1GR and 2UG/2GR

Fall 2023 - Syllabus

Table of Contents


Course Description

Statistical Data Management (STAT 440) is a focused data wrangling course that aims to cover various types of data storage, manipulation, cleaning, and extractions and to apply these methodologies in R. This means that students must have a laptop that they bring to class each day. This course is not a traditional lecture format. Most lecture content will be distributed in video form at the beginning of the semester. Notes are reproducible documents that include examples and code. Videos and notes should be read and understood before (and outside of) class. The classroom space and time will be for application, practice, and assessment of course content in those videos and notes. The expectation is that students will gain competency in exploring, organizing, designing, creating, storing, cleaning, wrangling, sharing, and using data, all of which are commonly done prior to data analysis. Critical and creative thinking and efficient coding will be encouraged. Concepts covered in this course will build upon each other. Thus, students can expect all assessments to be cumulative. Students should be sufficient and comfortable in R prior to beginning this course. The RStudio offers reproducible documentation with Markdown syntax which will support long-term learning opportunities. Git propels students’ capacity for collaboration as well as version control of documentation and files.


Learning Objectives

These learning objectives are important because they connect the physical know-how with the technical knowledge of the course.

  • Students will assess effectiveness, organization, and intent from a published data set

  • Students will explore data sets of various types

  • Students must design well-organized, clean data sets for the purpose of data analysis

  • Students will present data management work in a reproducible document file using Markdown syntax and code chunks or cells. No local data files will be utilized.

  • Students must demonstrate critical thinking and creativity through asking questions about a given data set

  • Students must be able to explain and summarize data wrangling code

  • Students will share and discuss data management ideas, coding snippets, and other thoughts to aid in meaningful dialogue

  • Students must recall important data management concepts

  • Students will reflect on their own learning of data management principles

  • Students will build data wrangling tools, apps, and dashboards and store all work using git, a version control software.

  • Students will collaborate on lab assignments.

  • Students will reproduce and replicate data visualizations.


Course Staff

  • Instructor - Christopher Kinson (kinson2@illinois.edu)


Course Specifics

Course Website

The course website is https://github.com/illinois-stat440. This course is operating as an organization named illinois-stat440 within GitHub. Students should bookmark or save the link below in their browser for future use, because it contains access points to all repositories, course materials including notes, assignments, projects, and lecture videos.

Prerequisites

The prerequisites for this course are the following:

  • A laptop (not a netbook) with most up-to-date versions of R and RStudio installed. If using a netbook or Chromebook, please setup an RStudio Cloud account.

  • STAT 400 or STAT 409

  • Operating knowledge of computers such as locating a file, creating a directory, saving a file, compressing a file, extracting a compressed file, keyboarding, and fundamental troubleshooting

  • Operating knowledge of R such as understanding various objects, mathematical and logical operators, and value types and their coercion, as well as creating user-defined functions and fundamental R troubleshooting

Meeting Schedule and Expectations

  • For section 1UG/GR, the class meets at 10:00 am - 10:50 am in Room 32 of the Psychology building on Mondays, Wednesdays, and Fridays.

  • For section 2UG/GR, the class meets at 1:00 pm - 1:50 pm in Room 32 of the Psychology building on Mondays, Wednesdays, and Fridays.

  • There will be asynchronous lecture videos with links posted on the Course Website (in videos directory of the course_content repository). See the Instructional Activities section below for more details.

  • All students are expected to fully participate in class regularly.

  • All students are expected to do the following before coming to class each week: read the course notes, watch the lecture videos, and complete piloted practice assignments.

  • Course content - syllabus, notes, videos, exams, projects, and weekly schedules, discussion board (as Issues tab) - will be found on the Course Website via the course_content repository. Do check the course_content repo often for updates and announcements. Students are encouraged to clone and pull the course_content repository daily if accessing it remotely via git.

Office Hours

Any and all times listed in this document are in current US Central Time. Take care to adjust clocks when daylight savings time occurs.

Office hours will be in-person. If a student has a specific question, but cannot attend the office hours, then that student should post their question in the Issues board. If a student wants one-on-one assistance from the course staff at an alternative time, then that student should email the course staff in order to schedule a Zoom meeting.

  • Instructor in-person office hours:

    • Mondays and Wednesdays 11:30 am - 12:30 pm in Room 166 Computer Applications Building (CAB)

Textbooks

There is no required textbook, but students may find the texts below to be helpful. These are all free and accessible to students for further reading. The Instructor may refer to certain sections of these texts in the course content. The asterisk * means these are accessible from the University Library as E-books.

R

  • *Data Wrangling with R. Boehmke. Springer Cham. http://www.library.illinois.edu/proxy/go.php?url=http://dx.doi.org/10.1007/978-3-319-45599-0
  • *R for Data Science. Wickham and Grolemund. O’Reilly Media, Inc. https://learning.oreilly.com/library/view/-/9781491910382/?ar
  • Mastering Shiny. Wickham. https://mastering-shiny.org/

Markdown

  • The Markdown Guide. Cone. https://www.markdownguide.org/getting-started

RMarkdown

  • RMarkdown Cheat Sheet. RStudio. https://rstudio.com/wp-content/uploads/2015/02/rmarkdown-cheatsheet.pdf

Git and GitHub

  • Happy Git and GitHub for the useR. Bryan et al. https://happygitwithr.com/

Software

The course requires students to already have a fundamental and operational understanding of R. It is recommended that students with no familiarity in R understand that this course will not discuss fundamental and operational usage of R.

Calendar

Below is a calendar of topics and tentative assignment deadlines. Any deadlines apply to all sections of STAT 440 unless otherwise noted.

Week 2023 Dates Topics Covered
01 08/21 - 08/25 Introduce the course and software - Markdown, R/RStudio/RMarkdown and Git/GitHub, Git/GitHub tips
02 08/28 - 09/01 Loops and conditional execution, Apply family of functions, Vectorization
03 09/04 - 09/08 What is data, Structures of data, delimiters, and file extensions, Accessing and importing data, Exporting data, Handling dates and times
04 09/11 - 09/15 Assigning objects, Arranging data, Reshaping data, Data expansion, Data reduction
05 09/18 - 09/22 Regular expression and string manipulation, Summarizing data, Combining data
06 09/25 - 09/29 Validating data, Cleaning data
07 10/02 - 10/06 SQL queries and sub-queries
08 10/09 - 10/13 Midterm Exam 01 on Wednesday October 11, Reassessment Midterm Exam 01 on Friday October 13, Focus on Midterm Exam
09 10/16 - 10/20 Data visualization using base R
10 10/23 - 10/27 Data visualization using tidyverse
11 10/30 - 11/03 Accessing and importing data via web scraping, Accessing and importing data via an API
12 11/06 - 11/10 Shiny apps and dashboards
13 11/13 - 11/17 Midterm Exam 02 on Wednesday November 15, Reassessment Midterm Exam 02 on Friday November 17, Focus on Midterm Exam
14 11/20 - 11/24 Fall Break
15 11/27 - 12/01 Final Project Pre-Feedback Submission due at 11:59 pm Friday December 01, Final Project Help and Questions and Answers
16 12/04 - 12/08 Reading Day - December 07 (no more class or office hours), Data workers and responsibilities, Discussion about careers, graduate school, and the future post-STAT440, Focus on Final Project and Final Exam
17 12/11 - 12/15 Final Exam for section 1 UG/GR on Thursday December 14 8:00 pm - 11:00 pm, Final Exam for section 2 UG/GR on Wednesday December 13 7:00 pm - 10:00 pm, Final Project Post-Feedback Submission due at 11:59 pm Friday December 15

Grading Breakdown

15 Piloted Practices: 15 points total (1 point each)

  • PP01-PP16 are weekly comprehensive assignments due on Mondays (before class). No student receives credit for PP01. Credit is earned for PP02-PP16.

2 Lab Assignments: 8 points total (4 points each)

  • Lab01 series begins Week 04 (September 11) and ends Week 07 (October 06). Each student will be an in-person in-class driver only once in this series.
  • Lab02 series begins Week 09 (October 16) and ends Week 12 (November 10). Each student will be an in-person in-class driver only once in this series.

2 Midterm Exams: 20 points total (10 points each)

  • Midterm Exam 01 is a 50-minute (student’s section’s class start and end time) in-person exam (October 11). It contains conceptual and applied problems.
  • Midterm Exam 02 is a 50-minute (student’s section’s class start and end time) in-person exam (November 15). It contains conceptual and applied problems.

1 Final Project Pre-Feedback Submission: 13 points total

  • Deadline for .R file pre-feedback submission into project repo is 11:59 pm Friday December 01. Students must work in pairs for final project. Grading rubric provided in course_content repo.

1 Final Project Post-Feedback Submission: 4 points total

  • Deadline for R file post-feedback submission into project repo is 11:59 pm Friday December 15. Grading rubric provided in course_content repo.

1 Final Exam: 20 points total

  • Final Exam is a 3-hour in-person exam containing conceptual and applied problems. This exam schedule is in alignment with the University Final Exam Schedule (see https://registrar.illinois.edu/courses-grades/final-exam-schedule-public/ for more information). Adjust your schedules and travel plans accordingly. Any undergraduate requests for a conflict exam will be denied.

Course Total Points: 80 points

Final Letter Grades

When computing final grades, students can add up their scores on the assignments. The resulting sum will determine which letter grade they earn when the course is completed. There is only one $+$ letter grade in this course. All other letter grades are without $+/-$. Points are not rounded.

Lower bound Upper bound Letter grade
80.000 points 88.000 A+
72.000 points 79.999 points A
64.000 points 71.999 points B
56.000 points 63.999 points C
48.000 points 55.999 points D
0.000 points 47.999 points F

Instructional Activities

Students should read the course notes, watch the lecture videos, and attempt the assignments. If or when students get stuck, then they should ask questions in the i) Issues Board, ii) Office Hours, or iii) via email (preference in this order). In addition to lecture videos and office hours, the following activities and tools will be useful for students.

Course Notes

The course notes perform the duty of a textbook for this course. Yes, there is a lot of information in the notes, but it is useful to read it for the important parts and return to it for details after attempting the assignments.

Issues

This discussion board, which exists as a tab on the course_content repository, is one of the best ways to communicate with classmates and course staff. Questions can be seen quickly and receive a rapid response. Students are encouraged to use this board, but there is no requirement to participate in the discussion board.

Do use the board to openly discuss ideas about the course such as questions about content, deadlines, notes, data, etc. If a student specifically wants the course staff to respond, then student should use the mention @staff when posting in the board. The things discussed here should be of a non-personal and non-private matter. If student has a personal or private matter to discuss with the Instructor, please send an email to kinson2@illinois.edu. Additionally, the conversation in the discussion board should be respectful of people’s differences and cannot be used to speak negatively about anyone or harm anyone.

The course staff will view and respond to content on Tuesdays and Thursdays (at a minimum). The course staff can be expected to spend at least 30 minutes on Tuesdays and Thursdays monitoring the Issues.

Grade Disputes

Please email the Instructor with your requests and disputes within 7 days (i.e. 1 week) of your grade being returned.

Assignments

Piloted Practices

These are guided comprehension assignments to be completed by each student as an individual as late as one hour before their class begins on Mondays. There are 15 piloted practices for the semester. The shortname for these assignments is PP. They are numbered by their corresponding week number. For example, PP04 corresponds to week 04 piloted practice and is due on Monday of Week 04.

These assignments are to be submitted in the student’s repository, which exists within the illinois-stat440 organization in GitHub. See Course Website for web links. These PPs are graded for completion, not correctness.

Lab Assignments

These are lab sessions that contain 4 problems and are due at the end of the class period on Mondays and Wednesdays by the “driver.” The course is located in an iFLEX classroom, which allows for ease of communication, collaboration, and displaying content on large screens at stations. Each week (beginning in Week 04), randomly chosen students (“drivers”) will complete the lab assignment seated at specified stations, while the remaining students (“passengers”) at the stations will help the drivers by giving them ideas and advice on how to complete the problems. Drivers must submit their labs. Passengers are not allowed to type on driver’s laptops. All students must bring their laptops to class each day. Lab assignments are intended to push students to apply concepts covered in the course notes and lecture videos and encourage students to work together as a team in a limited amount of time. Each student must complete two lab assignments as the driver by the respective lab due dates. A schedule will be give to students displaying exactly when each student is to be driver and which station number the driver should sit. Do not deviate from this schedule. Late submissions of lab assignments will not be accepted. There will be no make-ups for any missed labs. This policy applies to any students who add the course late to their registration.

Midterm Exam

Each midterm exam contains 10 problems and is in-class and in-person. The exam will be closed notes, closed book. Each midterm file must be submitted on the Course Website via a student’s repo. The midterm exam will be graded for correctness and completeness. Students can expect the midterm exam to include a structure similar to lab assignments with a possible mixture of completion, correct/incorrect, and open-ended questions. Late submissions on any Midterm Exam submission will not be accepted or graded. There will be no make-ups for any missed Midterm Exam submission. There is one Reassessment Midterm Exam for each original Midterm Exam to give students who struggle with the original Midterm Exam submission a second opportunity to review course content and improve their score: Reassessment Midterm Exam 1 and Reassessment Midterm Exam 2. The Reassessment Midterm Exams take place on the Friday following the original Midterm Exam. The Reassessment Midterm Exam grade may be used to replace the original Midterm Exam grade, for the respective exam number. For example, a student’s Reassessment Midterm Exam 1 grade of 10 points may only be used to replace the grade of the original Midterm Exam 1 grade of 0 points. All exams (original or reassessment) are in-person exams. For students who do not wish to take the reassessment, they may use the reassessment exam date as a study at home day.

Final Exam

The final exam is one in-person exam with 20 problems. The exam will be open notes, open resources, and take up to 3 hours to complete. The final exam will be graded for both correctness and completeness. Students can expect the final exam to include a structure similar to labs and the midterm exams with a possible mixture of completion, correct/incorrect, and open-ended questions. Students should not expect solutions to be provided for the final exam. Late submissions on any Final Exam will not be accepted or graded. There will be no make-ups for any missed Final Exam.

Final Project

The Final Project in this course is the creation of a single Shiny app or dashboard in R. This Shiny app or dashboard is an opportunity for students to demonstrate the statistical data management concepts covered this semester and apply them along with version control for collaboration. The final project requires students to work in groups of 2 (pairs). Individual final projects will be considered only if there is an odd number of enrolled students on November 13 and/or there is conflict within a student group.

The final project will have two submissions and both submissions must be a single .R file; no other file extension will be permitted. The Pre-Feedback submission is the group’s well-thought-out and successfully running Shiny app or dashboard. The deadline to submit this .R file is December 01. Students will review the feedback from the course staff and incorporate that into the second submission of the Shiny app or dashboard, called the Post-Feedback submission. The deadline to submit this new .R file is December 15.

Students should read the accompanying grading rubrics for both submissions. A new repo specific to the student’s group will be created by the Instructor in GitHub to permit collaboration. Groups must consist of students in the same section; no cross-section collaboration. Ideas and coding must be your own code. Late contributions will not be accepted. There will be no make-ups for any missed Final Project. If there is group conflict, notify the Instructor immediately so that the group will be split. Thus the two students will now work as individuals each with a new topic (different from original group’s topic) for the shiny app or dashboard.

The Shiny dashboard must contain data directly accessed from an API. The app (or dashboard) must contain an actionbutton (or submitbutton) allowing the user to click it such that clicking this button triggers the app (or dashboard) to show results. Any change the user makes, such as selecting variables and specific options, should not cause the app (or dashboard) to show new results. Instead, the app or dashboard should only show new results when the actionbutton (or submitbutton) is clicked. The results must include at least 1 data visualization and at least 1 summary table or summary tibble returned. A summary table or tibble is one that computes a new statistic based on by-group processing.

The Pre-Feedback grading rubric is (maximum total of 13 points):

  Needs Much Improvement 3 Satisfactory 4 Impressive 5
Functionality 1 The app (or dashboard) lacks much functionality. The buttons, selections, and options do not work properly. The app (or dashboard) completely disregards instructions. The app (or dashboard) contains reasonable functionality. The buttons, selections, and options do work properly. The app (or dashboard) follows the instructions. The app (or dashboard) incorporates much functionality and runs smoothly without hiccups. The buttons, selections, and options work precisely, quickly, and with fantastic efficiency. The app (or dashboard) completely follows the instructions and goes above and beyond to deliver impressive performance.
Beauty 1 The app (or dashboard), data visualization, and summary table used are least visually appealing and have minimally readability rendering them not easily interpretable. The app (or dashboard) incorporates almost no visual design principles. The app (or dashboard), data visualization, and table used are commonly visually appealing and have decent readability rendering them moderately interpretable. The presentation incorporates a few visual design principles. The app (or dashboard), data visualization, and table used are most visually appealing and have superior readability rendering them quickly and completely interpretable. The presentation incorporates several visual design principles.
Minimum requirements met 0.6 No minimum requirements are met. Submission ignores all requirements detailed in instructions. At least one but not all minimum requirements are met. Submission ignores some requirements detailed in instructions. All minimum requirements are met. Submission ignores none of the requirements detailed in instructions.

The Post-Feedback grading rubric is (maximum total of 4 points):

Category Points
Feedback was incorporated to improve the Functionality of dashboard 0 (disagree), 1 (unclear), 2 (agree)
Feedback was incorporated to improve the Beauty of dashboard 0 (disagree), 1 (unclear), 2 (agree)

Maximum Total Final Project is 17 points.

For more information about Shiny apps and how to create one, check out the following videos and docs:

  • How to start a Shiny app https://vimeo.com/rstudioinc/review/131218530/212d8a5a7a/#t=0m0s

  • Getting started with Shiny dashboards https://rstudio.github.io/shinydashboard/get_started.html

  • Effective Reactive Programming Part 1 https://rstudio.com/resources/shiny-dev-con/reactivity-pt-1-joe-cheng/

  • Effective Reactive Programming Part 2 https://rstudio.com/resources/shiny-dev-con/reactivity-pt-2/

  • Mastering Shiny (textbook). Wickham. https://mastering-shiny.org/

  • Interactive Graphics with Shiny https://resources.rstudio.com/webinars/interactive-graphics-winston

  • Understanding Shiny Modules https://resources.rstudio.com/shiny-developer-conference/shinydevcon-modules-garrettgrolemund-1080p

  • Debugging Techniques https://resources.rstudio.com/shiny-developer-conference/shinydevcon-debugging-jonathanmcpherson-1080p

  • Welcome to Shiny https://shiny.rstudio.com/tutorial/written-tutorial/lesson1/


University Specifics

Disability Accommodations

To obtain disability-related academic adjustments and/or auxiliary aids, students with disabilities must contact the course instructor and the Disability Resources and Educational Services (DRES) as soon as possible. To contact DRES, student may visit 1207 S. Oak St., Champaign, call 333-4603, e-mail disability@illinois.edu or go to the DRES website at http://disability.illinois.edu/

Academic Integrity and Generative Artificial Intelligence Tools

It is expected that all students abide by the campus regulations on academic integrity http://studentcode.illinois.edu/article1_part4_1-401.html. Intentional violations of academic integrity can be found at http://studentcode.illinois.edu/article1_part4_1-402.html and include, but are not limited to, copying any part of another student’s assignment and allowing another student to copy any part of student’s own assignment.

Generative artificial intelligence tools are relatively new to the general public and can be useful in learning and studying. If students use generative AI tools in this course, do so outside of class as a means of studying and learning accurate information relevant to this course’s content. Students should not use generative artificial intelligence tools as a means to perform (on graded assignments and submissions) in this course. Doing so is an intentional violation of academic integrity.

Safety Protocol

We have been asked by Public Safety https://police.illinois.edu/emergency-preparedness/run-hide-fight/ to share the following information in case of weather or security emergencies. See the links:

Sexual Misconduct Policy and Reporting

The University of Illinois is committed to combating sexual misconduct. Faculty and staff members are required to report any instances of sexual misconduct to the University’s Title IX and Disability Office. In turn, an individual with the Title IX and Disability Office will provide information about rights and options, including accommodations, support services, the campus disciplinary process, and law enforcement options.

A list of the designated University employees who, as counselors, confidential advisors, and medical professionals, do not have this reporting responsibility and can maintain confidentiality, can be found at https://wecare.illinois.edu/resources/students/#confidential. Other information about resources and reporting is available at https://wecare.illinois.edu.


The Last Word

The Instructor reserves the right to make any changes considered to be academically advisable. Any changes will be announced in class and on the Course Website. It is the student’s responsibility to attend the class and keep track of the changes.