Here is the guideline: ICE 8.1
This is not graded.
Instructor
ICE 7.1 Locating Bad Data Using Excel
Here is your guideline: Finding Bad Data in Excel.docx
Here is the dataset: Vandelay Orders by Zipcode.xlsx
This is a graded ICE
Assignment 2 is posted
Here is the Assignment 2 details.
Exam 1 Study Guide and Exam Info
Here is the exam study guide: Exam 1 Study Guide.docx
Exam Date: Feb 20, 2020 (Thursday)
Exam Time: Class Time
Exam Location: Alter 607
ITAs’ Review Sessions:
- Oviya: Wednesday Feb 19 from 1pm – 2pm in Alter 236B – Breakout Room
Post your own exam question !
I ask you to come up with a question from the materials we covered as part of the Exam 1. You can work with a group of friends or individually to form your question. You will then post your question below in the comment box and indicate your name(s). I will then select one or two of these posted questions and use them in Exam 1.
Question format should be multiple choice, question should have a clear single answer and relate to our Exam 1 materials.
We will spare last 10 minutes of our class today to this activity. Due date to post your question is 2/18 @ 11:59PM.
ICE 5.2 Creating Infographics
- Step-by-step guideline: ICE 5.2 Telling a Story Through Visualization.docx
- Finished Tableau workbook: In-Class Exercise 5.2 – Food Atlas Finished.twb
- Data for Tableau workbook: In-Class Exercise 5.2 – FoodAtlas.xlsx
- Additional graph that you will need: In-Class Exercise 5.2 – Philadelphia Area Obesity Rates.png
This is a GRADED ICE. Due by the end of this class.
ICE 5.1 Telling a Story through Visualization
- Here is the guideline: ICE 5.1 Telling a Story through Visualization
- Here is the dataset: studentloans2013.xlsx
- Here is the Tableau workbook: Student Loan by State – 2013.twb
- Post your group’s response below. One per group will be sufficient. Include all the names and your section number in your response and be brief.
ICE 4.2 Gotta Catch Em All
Here is the guideline: ICE 4.2 – Gotta Catch Em All.docx
Here is the data: pokemon.xlsx
This is a GRADED ICE!
ICE 4.1 – The Day the Music Died
Here is the guideline: ICE 4.1 – The Day the Music Died
Here is the data: musicrevenue.csv
This is a GRADED ICE!
Assignment 1 is posted
Assignment 1 details can be reached here: Assignment 1
ICE 3.2 Getting Familiar with Tableau
- Here is the guideline: ICE 3.2 Getting Familiar with Tableau
- Here is the dataset you need to download: FoodAtlas.xlsx
- This is a GRADED ICE. Follow the instructions in the guideline to submit on Canvas.
- IIF Function logic briefly described here: IIF Function logic