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 12:30pm.
- 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]
Assignment 4: Final (Group) Project DUE April 24
Here are the assignment instructions. The assignment is due April 24. We’ll do the presentations on Tuesday (Apr 24) and Thursday (Apr 26).
This is a GROUP project so you may not do this assignment on your own.