Masters of Public PolicyMPP 806 Research Techniques and Quantitative Methods
Course Homepage 
Kevin Wainwright Burnaby: Office:3689 West Mall Email:wainwrig@sfu.ca 

Fall 2009 
This course will spend some time on reviewing and strengthening your basic math skills. The first part of the course will focus on algebra, functions and the basics of constructing and interpreting graphs. The will be an overview of nonlinear functions and a discussion of simple calculus; how and why it is used however, this will not be a calculus course.
the second part of the course will combine the basics of statistics (mean, varience, distributions) with developing better excel skills. Besides learning to manipulate data in excel, students will be shown tools useful in preparing reports and presentations. this will include charts, plots, data filters and tricks for inserting data into Word documents and Power Point slides.
Fall 2009  Final Term Project  Due by 4 pm Dec 11, 2009 


Date  Lecture topics (HC 3000)  Excel (HC 7000)  Jacques  Additional notes  
1  9Sep09 
Introduction  
2  16Sep09 
Linear Equations 1  Lesson 1  1.1, 1.2, 1.3  
3  23Sep09 
Linear Equations 2  Lesson 2  1.4, 1.5, 1.6  Factoring practice 
4  30Sep09 
Nonlinear Equations  Lesson 3  2.12.4  Macro Simulator: HW notes and Excel file 
5  7Oct09 
Percents, Finance & Calculus 1  Lesson 4  3.1, 3.2 4.1,4.2  (Answer Key for Macro Simulator ) 
6  14Oct09 
Calculus 2  4.34.6  
7  21Oct09 
Midterm  
Date 
Lecture topics (HC 3000)  Freedman, Pisani & Purves  
8  28Oct09 
Descriptive Statistics  Lesson 5  Ch 3 FPP  
9  4Nov09 
Stnd. Dev. and Normal distributions  Lesson 6  Ch45  
10  11Nov09 
Correlation  Lesson 7  Ch 89  
11  18Nov09 
Regression  Lesson 8  Ch 1011  
12  25Nov09 
Tests of Significance  Ch 2628  
13  2Dec09 
Sampling and Hypothesis testing  Ch 1923  
14  9Dec09 
Catch up and Review 
Problem Sets 
Problem Set Answer Keys 
Linear Equation SystemsNonlinear Equation SystemsSingle Variable CalculusOptimization

Linear Equation SystemsNonlinear Equation SystemsSingle Variable Calculus
Optimization

Notes and Handouts  Statistics Lecture Notes & Readings 
One Variable CalculusMath Notes for Economics

The following sections are condenced readings on the basics of statistics and empirical techniques for social science

Statistics and Excel Lab Assignment 1 (Nov 18)
Lab Assignment 2 (Nov 25)
Lab Assignment 3 (Dec 2)


EXCEL TUTORIALS 
This page contains Hands On Exercises and EXCEL files that cover topics that are frequently needed for projects. In some cases there will be techniques that are new to you, and others may simply be a review. 
CHARTING Tutorial  Lesson One EXCEL FILE 
Filtering Tutorial  Lesson Two EXCEL FILE 
Elasticity Tutorial  Lesson three EXCEL FILE 
PARSING Tutorial  CONCATENATE Tutorial  Lesson Four EXCEL FILE 
Large Speadsheet Tutorial #1  Large Speadsheet Tutorial #2  Lesson Five EXCEL FILE #1 (Test Data.xls)  Lesson Five EXCEL FILE #2 (Test Data2.xls) 