- The exam is closed book, closed notes. The exam will be a combination of multiple-choice and short-answer questions.
- Exam # 3 covers all the lectures from “Introduction to Advanced Analytics”. We will have a review session on Tuesday (4/22).
- You will need a calculator.
- Study Guide for Exam 3 (word)
- Study Guide for Exam 3 (ppt)
- I will hold additional office hours on Wednesday (4/23) from 2 to 3 pm on Zoom.
Review and Exam Study Guides
Exam #2 Study Guide: Semi-structured Data, Python Basics/JSON/Pandas, ETL, Hypothesis Testing, Data Visualization [During class time on 3/27]
- The exam is closed book, closed notes. The exam will be a combination of multiple-choice and short-answer questions.
- Exam # 2 covers all the lectures from “Semi-structured data” to “Data visualization”.
- Study Guide for Exam #2 (word)
- Study Guide for Exam #2 (ppt)
- Additional practice questions covered on 3/25
Exam #1 Study Guide: Data&Information/Schema/SQL [During class time on 2/13]
- The exam is a closed book, closed notes. The exam will be a combination of multiple-choice and short-answer questions.
- Exam # 1 covers all the lectures up to “SQL 2: Getting Information Out of a Database – Advanced Queries”. We will have a review session on 2/11.
- Study Guide for Exam #1 (word)
- Study Guide for Exam #1 (ppt)
- Here are some practice questions, in case you want more exercise.