Assessments index
This folder contains all graded and practice assessments for ALT/FNDATA's academic program. Every assessment is built on the same three access surfaces used throughout the course: the no-code sandbox at sandbox.altfndata.com, the documentation and tutorials at docs.altfndata.com, and the production REST API at api.altfndata.com. Students complete coursework in the sandbox unless a problem explicitly calls for the API, in which case an instructor supplies a shared class API key (students never self-serve a key).
Every graded item that has a scoring answer ships as two files: a STUDENT version with no answers, and a separate KEY (or KEY_and_Rubric) file for instructors. Keep the two files apart when distributing coursework so students never receive the key by accident.
How assessments map to the sixteen modules
| Module | Title | Assessment |
|---|---|---|
| 1 | Alternative data in finance | Problem Set 1: Alternative Data |
| 2 | Data science and SQL | Problem Set 2: Data Science and SQL |
| 3 | Consumer and luxury economics | Problem Set 3: Consumer and Luxury Economics |
| 4 | Investments and equity research | Problem Set 4: Investments and Equity Research |
| 5 | Library data literacy workshop | Problem Set 5: Library Data Literacy |
| 6 | FinTech and data products | Problem Set 6: FinTech and Data Products |
| 7 | The business of the art market | Problem Set 7: Art Business |
| 8 | Data visualization and storytelling | Problem Set 8: Data Visualization |
| 9 | Machine learning on auction data | Problem Set 9: Machine Learning |
| 10 | Time series and market indices | Problem Set 10: Time Series |
| 11 | Auction theory and behavioral economics | Problem Set 11: Auction Theory |
| 12 | Data engineering and the API | Problem Set 12: Data Engineering |
| 13 | Data ethics, quality, and coverage bias | Problem Set 13: Data Ethics |
| 14 | The auction business model | Problem Set 14: Auction Business Model |
| 15 | Art market fundamentals | Problem Set 15: Art Market Fundamentals |
| 16 | Data science for art market research | Problem Set 16: Art Market Data Science |
| All | Cumulative review, any module order | Quiz bank |
| Modules 1 to 7 | Midpoint checkpoint | Midterm exam |
| Modules 1 to 13 | End of term | Final exam |
| Optional, any module | Independent applied project | Capstone brief |
All sixteen modules now have a dedicated problem set and key. Modules 14 to 16 form an art-business extension track that deepens Module 7 into the auction business model, art market fundamentals, and quantitative art market research. The midterm covers Modules 1 through 7, the first half of the core program, leaving the more advanced Modules 8 through 16 to be assessed through their problem sets, and Modules 8 through 13 additionally through the cumulative final.
Assessment descriptions
Problem sets (Problem_Sets/). One pair of files per module across all sixteen modules, each problem set holding four to six problems worth a stated point total (60 to 100 points depending on module). Every problem is sandbox first: students write SQL against the named table and fields, or in the API-oriented modules (4, 6, 7, 9, 12, 14, and 16) construct an API request body. Problems reference only the documented fields (designer, model, item_title, sale_date, usd_price_decimal, sale_estimates_high_usd_price, status, vendor, stock_ticker) and instruct students to confirm exact table names with GET /v1/tables before querying, since the schema browser in the sandbox and the API discovery endpoint are the source of truth, not a memorized table list. Key files give full worked SQL, worked API JSON bodies where relevant, and the expected shape of the result (what columns come back, what the aggregate should represent, how to sanity check it) rather than fabricated exact row counts or dollar figures.
Quiz bank (Quiz_Banks/). A single reusable bank of 60 multiple choice questions and 23 short answer questions, grouped into seventeen topics that cut across all sixteen modules: access and schema, SQL and filters, pricing power, sell through, demand index, brand to ticker, data literacy and caveats, art market and league tables, data visualization and storytelling, machine learning on auction data, time series and market indices, auction theory and behavioral economics, data engineering and the API, data ethics and coverage bias, the auction business model, art market fundamentals, and data science for art market research. Instructors can draw a subset for a five minute warm up quiz, a review session, or a randomized online quiz pool. The KEY gives the correct choice and a one to two sentence rationale for every item, plus model short answers.
Midterm and final (Exams/). The midterm covers Modules 1 through 7 (alternative data, SQL fundamentals, consumer and luxury economics, investments and equity research, library data literacy, FinTech, and the business of the art market), runs 100 minutes, and adds a plain-language communication section. The final is cumulative across all sixteen modules and runs 150 minutes, adding investments, library data literacy communication skills, FinTech product thinking, the business of the art market, and the newer topics (data visualization, machine learning, time series and indices, auction theory, data engineering and the API, data ethics and coverage bias, the auction business model, art market fundamentals, and data science for art market research). Both exams mix three sections: conceptual short answer, a query writing section (sandbox SQL and, in the final, an API JSON body), and an applied mini analysis that asks students to interpret a result rather than just produce one. Each KEY_and_Rubric file gives point allocations per section, model answers, and partial credit guidance for the query writing section (since minor syntax variants that reach the same correct SELECT should still earn most of the credit).
Capstone brief (Capstone/). An optional independent project for students who want to go beyond the graded problem sets. A student chooses either a brand or a listed company and builds a short demand analysis using the sandbox and the tutorials notebook, culminating in a two to three page brief plus supporting queries. Includes a grading rubric and three worked example directions (Richemont via CFR.SW, Van Cleef and Arpels pricing power, and a sell through comparison across two competing brands) to show the range of acceptable projects without dictating a single answer.
Shared conventions across every assessment in this folder
- Access model. Students query the no-code sandbox at sandbox.altfndata.com, which they reach by self-registering with a work or school email address (auto-approved, no waiting on an instructor). No API key is required for sandbox work. Where an assessment calls for the production API, the instructor supplies one shared class API key; students never request their own.
- Discovery first. Any problem that touches the API opens with GET /v1/tables and GET /v1/tables/{name}/schema before writing a query, so students confirm exact table and column names rather than guessing.
- Documented fields only. All problems draw from the fields called out in the course materials: designer, model, item_title, sale_date, usd_price_decimal, sale_estimates_high_usd_price, status, vendor, and stock_ticker. No assessment invents a field that is not in that list.
- Stable metrics, not year over year trend claims. Ingestion of the most recent quarters lags, so recent-period aggregates should never be read as a market appreciation or depreciation signal. Every problem, quiz item, and exam question that touches a demand index or a time bucketed metric frames it as a methodology exercise (building a demand index for learning purposes) and calls out this caveat explicitly rather than asking students to conclude that a brand is "up" or "down" year over year.
- No natural language search. ALT/FNDATA's AI natural language query feature is still in development and does not appear in any assessment; every query exercise uses SQL in the sandbox or a structured JSON filter body against the API.
- Sentence case titles, no em or en dashes. All assessment files in this folder follow the same house style as the rest of the course materials.
- Contact. Any assessment that references support routes students and instructors to info@altfndata.com.