Third (Final) Exam & Study Guide
Final Exam will be on May 3, 2018 between 10:30am – 12:30pm 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 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]