In-class Exercises (ICEs)

Here are the files you will need:

1. Guideline
2. Dataset
3. Driver (software) if Tableau gives error. 

This is a graded ICE!

Here is the guideline: Sentiment Analysis Using Excel

Here is the file for analysis: Sentiment Analysis Tools

This is a graded ICE!

Here is the ICE details: ICE 12.1 Manually Determining the Sentiment of Text Data.docx

This is not graded.

Here is the guideline: ICE 11.2 Working with Pivot Tables in Tableau

Here is the data: NCAA 2013-2014 Player Stats

Here is the guideline: ICE 11.1 Creating a Database

This is not graded

1. Guideline is here: ICE 9.2 Creating Interactive Dashboards
2. Data file for Tableau: Pew Story Data (Jan – May 2012)

On Canvas submit your Tableau file along with answers to the four questions given at the end of the guideline (you can type your answers in the comment box on Canvas after submission)

1. Here is the guideline: ICE 9.1 Connecting Data Sets.docx
2. First dataset: 2012 Presidential Election Results by District.xlsx
3. Second dataset: Portrait 113th Congress.xlsx 

This is a graded ICE. 

1. Here is the guideline you will need: ICE 8.2 word doc
2. Here is the data file you will use: OnTime Airline Stats excel file

This is a graded ICE–will be counted towards your attendance. 

Here is the guideline: ICE 8.1 

This is not graded. 

Here is your guideline:  Finding Bad Data in Excel.docx

Here is the dataset: Vandelay Orders by Zipcode.xlsx

This is a graded ICE