Practice Final Exam Release Notes

This set of problems is curated from past semesters to indicate the types of problems you can expect to see on the final exam. Where available we will provide details such as the time limit, points required for 100%, etc. There are 12 problems in all. They are listed below in groups indicating their similarity to the upcoming exam. Note: there are no problems with the "test case variables" feature in this set. However, this feature will be used in the upcoming exam.

Tier 1 Problems

Similar format (with exception of test case variables)
Exercises are independent. Test cells use randomized inputs. Similar time constraints (between 3-4 hours for each exam).

22
9 exercises; 20 available points; 17 points required for 100%
Topic: Analyzing product reviews
Skills: Nested data, Numpy, Pandas

21
6 exercises; 13 available points; 13 points required for 100%
Topic: The legacy of "redlining"
Skills: Pandas, Numpy, basic Python data structures, regex

Tier 2 problems

Similar time constraint
Exercises may depend on earlier exercises. Test cases may or may not be randomized. Similar time constraints (between 3-4 hours for each exam).

Note Problems 19 and 20 were given together as a single exam. 10 points total were required for 100% between the two problems.
20
5 exercises; 10 available points
Topic: Key sentences
Skills: Regex, basic Python data structures, Numpy/Scipy

19
3 exercises; 5 available points
Topic: Click-through balancing act
Skills: Basic Python, Pandas, Numpy

Note Problems 17 and 18 were given together as a single exam. The point total required for 100% is lost to time, but it was slightly less than the combined total for both problems.
18
5 exercises; 10 available points Topic: Data Jobs
Skills: Nested data, regex, Pandas

17
6 exercises; 10 available points
Topic: Specteral graph clustering
Skills: Pandas, Numpy

Tier 3

Good problem solving practice
Exercises may depend on earlier exercises. Test cases are not randomized. Significantly different time constraints.

15
7 exercises; 10 available points
Topic: Semi-supervised learning
Skills: Numpy, Pandas

13
4 exercises; 10 available points
Topic: Traveling salesperson
Skills: Basic Python data structures

12
3 exercises; 10 available points
Topic: Snowball poem generator
Skills: Basic Python data structures

8
4 exercises; 10 available points
Topic: Triangle counting in a graph
Skills: Numpy, basic Python data structures

4
6 exercises; 10 available points
Topic: DBSCAN
Skills: Numpy, Pandas

2
4 exercises; 10 available points
Topic: "But her emails..."
Skills: Pandas, SQL

Updated: 2022-12-16