Course Outline

BUSI 444 - Advanced Computer Assisted Mass Appraisal

General Objective : This course applies advanced statistical modeling and geographic information systems to improve the consistency and quality of real property assessments.

Course structure : Weekly multiple choice assignments (10% of final grade), three term projects (50% of final grade, in total), and a take-home final examination (40%). Course requires extensive hands-on computer work with statistical software (e.g., PASW/SPSS, NCSS).

Prerequisites : BUSI 121 and 344. Recommend BUSI 330 and BUSI 443.

Software: Requires either PASW/SPSS or NCSS. See the Statistical Software webpage for more information.

Syllabus:

Lesson 1: Review of Statistical Software and Valuation Modeling Basics
Lesson 2: Preliminary Data Screening – Preparing Data for Modeling
Lesson 3: Land Value Modeling
Lesson 4: Cost-Based Modeling
Lesson 5: Sales-Based Modeling
Lesson 6: Advanced Sales-Based Modeling – Non-Linear Models
Lesson 7: Income-Based Modeling
Lesson 8: Integrating Geographic Information Systems and CAMA
Lesson 9: Neural Networks Applications in Real Estate
Lesson 10: The Canadian CAMA Experience

Projects:

Project 1: Modeling Land Value and Cost Case Study (20% of final grade)
Project 2: Sales-Based Modeling Case Study (20% of final grade)
Project 3: Income-Based Modeling Case Study (10% of final grade)

Comprehensive Case Study final examination (take-home) (40%): Completes BUSI 444 course requirement. Also eligible for credit towards IAAO's demonstration report requirement for its CAE and RES designations or AIC's guided case study requirement for its CRA designation. Please note: students who complete BUSI 444 with a partner institution (e.g., Lakeland College, Seneca College) will receive course credit for their final examination, but in order to receive demonstration report credit, students must submit their examination to the UBC Real Estate Division for review along with a $100 review fee.

Additional Resources

See Table of Contents for the texbook for this course: