In Class Exercises
In-Class Exercise 13.3: Simple Predictive Analytics
Here is the exercise.
And here is the spreadsheet you’ll need [In-Class Exercise 13.2 – VandelayOrdersAll.xlsx].
In-Class Exercise 13.2: Predicting Future Enrollment
Here is the exercise.
Here is the link for Temple’s academic policy.
In-Class Exercise 12.3: Sentiment Analysis Using Excel
Here is the exercise.
And here is the spreadsheet you’ll need for the exercise [In-Class Exercise 12.2 – Sentiment Analysis Tools.xlsx].
In-Class Exercise 12.2: Manually Determining the Sentiment of Text Data
Here is the exercise.
In-Class exercise 11.3: Working with ‘Pivot Tables’ in Tableau
Here is the exercise.
Here is the excel spreadsheet you will need to complete this exercise [In-Class Exercise 11.2 – NCAA 2013-2014 Player Stats]
Here is the solution.
In-Class Exercise 11.2: Creating a Database
Here is the exercise.
In-Class Exercise 9.2: Creating Interactive Dashboards
Here is the exercise.
And here is the Excel workbook you’ll need [Pew Story Data (Jan – May 2012).xlsx]
In-Class Exercise 9.2: Connecting Diverse Data
Here is the exercise.
And here are the workbooks [2012 Presidential Election Results by District.xlsx and Portrait 113th Congress.xlsx]
In-Class Exercise 8.3: 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.2: Identifying Key Performance Indicators
Here is the exercise.