UQO Course Material
Real-Estate Valuation Courses, Built on Real Data
Complete UQO course material for two real-estate appraisal courses: 28 Beamer lectures, 6 practical assignments with Excel templates, and a 106-page Quebec market report.
28
Beamer lecture decks
6
practical assignments
6
Excel Dashboard templates
106
market report pages
67
figures
2
full courses
Overview
This is the full public course material for two undergraduate courses in UQO's business administration program (real-estate appraisal concentration): IMM1003 — Elements of Real Estate Appraisal (Fall 2026), covering the Quebec professional framework, market economics and the three valuation approaches; and IMM1033 — Cost Approach Methods (Winter 2026), covering land valuation, construction cost estimation and full depreciation breakdown.
Every practical assignment pairs a LaTeX case brief with a formula-driven Excel Dashboard workbook — pre-filled data, answer cells, dropdowns, KPIs, native charts and conditional formatting — personalized by each student's permanent code. Cases are anchored in real, cited data: actual MLS listings in Gatineau, Aylmer and Hull, Bank of Canada rates, CMHC, Statistics Canada indices and real construction permits.
The material is explicitly designed for teaching in the AI era: take-home work where AI use is tolerated and framed, per-student personalized data, answers that must be grounded in the case file (generic answers score nothing), formula-chained workbooks, and a mandatory tool-use declaration. This public version excludes all exams, solution keys and grading rubrics.
Key Features
Two complete course packages
Syllabi, 28 fully compiled Beamer lecture decks with sources and bibliographies, six graded assignments and supporting resources for IMM1003 and IMM1033.
Cases built on real listings
Assignments cite actual MLS listings — an Aylmer residence, a Hull triplex, vacant land parcels for sale — plus real Gatineau construction permits.
Formula-driven Excel dashboards
Each assignment ships a Dashboard workbook with pre-filled data, formula answer cells, dropdowns, KPIs, native charts and conditional formatting.
Personalized per student
Workbooks and data are customized by each student's permanent code, and answers must be anchored in the case file — generic responses earn nothing.
106-page Quebec market report
The Rapport immobilier Quebec covers HPI indices, regions, property types, macro conditions and affordability, with 67 figures and its full Python analysis code.
Verified, cited, reproducible
LaTeX compiles with zero errors, Excel formulas were recalculated in Microsoft Excel with zero error cells, and every source carries a URL and consultation date.
Designed for the AI era
Take-home assignments tolerate and frame AI use, require case-grounded answers, chain workbooks by formulas, and mandate a tool-use declaration.
Anchored in official sources
APCIQ, Bank of Canada, CMHC, Statistics Canada, Realtor.ca, City of Gatineau, GCR, CCQ, CBRE, Altus and the TAL — all cited with access dates.
Fully regenerable toolchain
One latexmk command rebuilds any deck or brief, one Python script regenerates each Excel template, and the market report rebuilds from CREA/FRED data.
How It Works
Course trees (IMM1003 / IMM1033)
Each course directory holds the syllabus, lecture sources and compiled PDFs, the practical assignments with briefs and Excel templates, and shared resources.
Assignment pairs
Every TP couples an 8–12 page LaTeX brief — professional scenario, tables, figures, 8–10 cell-referenced questions on a /100 scale — with its matching Excel Dashboard workbook.
Quebec market report
A 106-page report with PDF, LaTeX source, 67 figures and the Python HPI analysis pipeline that regenerates it from CREA and FRED data.
Tooling layer
A shared UQO LaTeX style, openpyxl scripts that generate each Excel template deterministically, and per-folder autonomous latexmk builds.
Tech Stack
Typesetting
Data & tooling
Data sources
Highlights
- Assignments progress from market dashboards through comparison grids and income approach to full depreciation breakdown, weighted from 10% to 20% of the course grade.
- All real data was consulted and date-stamped on August 4, 2026; anything not freely accessible is flagged as calibrated pedagogical data — never silently invented.
- Excel templates were verified inside Microsoft Excel with a full recalculation and zero error cells.
- The public repo deliberately excludes exams, solution keys and grading rubrics, which live in a separate private teaching repository.
- Raw CREA/ACI data is not redistributed per its terms of use; the report's README documents how to obtain it and reproduce every figure.
- Depreciation cases draw on professional-grade references: Statistics Canada indices, ASHRAE/InterNACHI service lives, CBRE and Altus cost data.
Explore UQO Course Material
Real-estate appraisal & cost methods — the full source is on GitHub.