## In-Class Exercise 13.2: Simple Predictive Analytics

Here is the exercise.

And here is the spreadsheet you’ll need [In-Class Exercise 13.2 – VandelayOrdersAll.xlsx].

**Attention:**

Here is the driver you may need if legacy connection to the Excel file gives error in the second part of the assignment. You will install it.

## Third (Final) Exam & Study Guide

**Final Exam** will be on **Dec 19, 2018 Wednesday** between

**08:00am – 10:00am**in our regular classroom (

**Alter 232**)

Here is the study guide for the third (final) exam.

Here is the review that I will do in class. Caution that these items do not cover the entire set of subjects you will be responsible for in the exam.

## In-Class Exercise 13.1: Predicting Future Enrollment

Here is the exercise

## In-Class Exercise 12.2: 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.xlsm].

## In-Class Exercise 12.1: Manually Determining the Sentiment of Text Data

Here is the exercise.

## In-Class exercise 11.2: 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]

## In-Class Exercise 11.1: Creating a Database

Here is the exercise.

## Assignment 3: Final (Group) Project DUE Dec 3

Here are the assignment instructions. **The assignment is due Dec 3 beginning of the class. **We’ll do the presentations on Monday Dec 3 and Wednesday Dec 5.

This is a GROUP project so you may not do this assignment on your own.

## Extra Credit Assignment – Due Nov 30

Here is the **Extra Credit Assignment** that is due on Nov 30 by 11:59 PM. This is the **data dictionary** and this is the **data** (it is around ~2gb so be patient while first reading it into Tableau, you can use school’s computer labs if your laptop can’t handle).

Assignment has two parts (8 points each) and one bonus part (4 points). You can get a max of 20 points. Your score from this assignment will be distributed across your exams, meaning, your exam scores will be adjusted by the amount you receive from this assignment. For instance, if you get 15 points from this assignment and your exams are 90, 90, 95 then your exams will become 100 95 95 (because each exam has equal weight towards final score, it doesn’t matter which one receives this adjustment).

## 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]