Here is the exercise.
And here is the Excel workbook you’ll need [Pew Story Data (Jan – May 2012).xlsx]
Reading Quiz #7: Complete by March 25
Some quick instructions:
- You must complete the quiz by the start of class on March 25.
- 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 for the week (data integration)
In-Class Exercise 8.2: Visualizing KPIs
Here is the exercise.
And here is the spreadsheet to complete the exercise [In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx].
In-Class Exercise 8.1: Identifying Key Performance Indicators
Here is the exercise.
Reading Quiz #6: Complete by March 18
Some quick instructions:
- You must complete the quiz by the start of class on March 18, 2019.
- 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 KPIs
Assignment 2: Cleaning a Data Set due March 15 3 p.m.
Here are the instructions (in Word) (and as a PDF). Make sure you read them carefully! This is an assignment that should be done individually.
And here is the data file you’ll need: VandelayOrders(Jan).xlsx.
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.