In-Class Exercise 7.2: Finding Bad Data in Excel
Here is the exercise.
And here is the dataset you’ll need [Vandelay Orders by Zipcode.xlsx].
In-Class Exercise 7.1: How Data Gets Dirty
Here is the exercise.
Reading Quiz #5: Complete by Oct. 15
Some quick instructions:
- You must complete the quiz by the start of class on Oct. 15, 2018.
- When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. It will then take you to the quiz.
If it says you don’t have access, make sure you’re signed out of your regular Gmail (non-TUMail) account! - You can only do the quiz once. If you submit multiple times, I’ll only use the first (oldest) one.
- This is “open book” – you can use the articles to answer the questions – but do not get help from anyone else.
Ready? Take the quiz by clicking this link.
Your reading list for dirty data, 7.1, 7.2
Analytics Challenge extra credit
For 5 points on your lowest scored exam, here’s the assignment for the Analytics Challenge. This is good practice for the group project as well as an opportunity to compete and maybe win some money. I will look these over the Friday Oct. 26 before the Challenge is due on Oct. 31.
Form teams of anywhere from 2 to 4 and download the challenge specs and data from the site once you choose one.
Study Guide for Exam 1
Here is the study guide for the first midterm exam. Here is also a more detailed version based on notes from class.
In-Class Exercise 5.2: Creating Infographics
Here is the exercise.
And here is the graphic file you’ll need: Philadelphia Area Obesity Rates.png.
Right-click on the file and save it to your computer.
In-Class Exercise 5.1: Telling a Story Through Visualization
Here is the exercise.
Before you start, save this Tableau file and the studentloans2013 Excel workbook to your computer. Remember, to save the file right-click on the link and choose “Save As…” (don’t just left-click on the link).
Reading Quiz #4: Complete by Oct. 1
Some quick instructions:
- You must complete the quiz by the start of class on Oct. 1, 2018.
- When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. It will then take you to the quiz.
If it says you don’t have access, make sure you’re signed out of your regular Gmail (non-TUMail) account! - You can only do the quiz once. If you submit multiple times, I’ll only use the first (oldest) one.
- This is “open book” – you can use the articles to answer the questions – but do not get help from anyone else.
Ready? Take the quiz by clicking this link.