## Third (Final) Exam & Study Guide

**Final Exam** will be on **May 3, 2018** between **1:00pm – 3:00pm** 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.2: 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.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.

## Study Guide for Exam 2

Here is the study guide for the second exam.

Couple of items for your attention:

**Exam #2**is on**March 29, Thursday**at**2:00pm**.- I will hold an exam review during our regular class time on March 27th, Tuesday. No other review session has been planned as of now.

Suggested study approach:

- Review the Study Guide first, then:
- Start with the slides
- Look at the major concepts
- Where a slide is associated with a reading, review the reading that covers the major concept
- Understand how the reading is associated with the slide, and the reading’s key concepts

- Then look at the quizzes
- Review the questions and answers to the quizzes
- Understand where all the answers came from, review those readings

- Then review the In-Class Exercises
- If we did it in an exercise, it’s probably important.
- Focus on topics we emphasized in the Exercises.

- Then, review your Assignments.
- Lastly, re-read any readings you didn’t review in the prior study steps.

## 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.1: Connecting Diverse Data

Here is the exercise.

And here are the workbooks [2012 Presidential Election Results by District.xlsx and Portrait 113th Congress.xlsx]