2025 Take-Home Exam Walkthroughs
These are walkthroughs for the 2025 take-home exam, written to help you work through it. Part 1 (Exercises 1–3) covers formulas and LAMBDAs on the AIMODEL and MATH datasets. Part 2 (Tasks 1–3) covers ExcelScript on the BIKE dataset. Each report walks the corresponding question end to end — what it's asking, how to approach it, what your answer should look like, and where to look in the lecture material if you get stuck. Open any report, use the contents sidebar to navigate, and take a shot at the “Pause” prompts before revealing.
Exercise 1 lives on the AIMODEL sheet of exam_part1.xlsx.
Open walkthrough →Exercise 2 pivots from pure LAMBDA work into charts.
Open walkthrough →Exercise 3 moves to the second dataset, MATH, which holds benchmark results on MATH Level 5 — high-school competition math — for a long list of AI models with their release dates.
Open walkthrough →Task 1 is the groundwork for everything that follows.
Open walkthrough →You have a long daily table (the BIKE table, 730-odd rows, one row per day across 2011 and 2012) and you need a short monthly table (24 rows, one per month) with two columns of averages: average temperature for the mo...
Open walkthrough →You've got the 24-month summary table from Task 2.
Open walkthrough →