| Topic |
Lecture |
Activity |
| Introduction to computers, intro to spreadsheets |
Lecture 1 -
introduction to computers Lecture
2 - data organization |
Basic
spreadsheet use |
| How computers represent analog traits |
Lecture
3 - digitizing the analog world |
Analog to digital pt 1,
Analog to digital pt 2
|
| Relational databases |
Lecture
4 - relational databases |
Relational
database (MS Access) |
| Visualizing data |
Lecture
5 - graphing |
Graphing
in Excel |
| Spreadsheet formulas and functions |
Lecture
6 - formulas and functions |
Spreadsheet
formulas and functions,Spreadsheet
data types |
| Array formulas |
Lecture
7 - array formulas |
Array
formulas |
| Optimization |
Lecture
8 - optimization |
Using
Solver to find numeric solutions - pt 1, Using
Solver to find numeric solutions - pt 2 |
| Least squares curve fitting |
Lecture
9 - least-squares curve fitting |
Least
squares curve fitting,Standard
errors for fitted parameters |
| Maximum likelihood estimation |
Lecture
10 - maximum likelihood |
Likelihood
- curve fitting, Likelihood
in DNA fingerprinting |
| Programming - loops |
Lecture
11 - loops |
Randomization
testing part 1, Randomization
testing part 2 |
| Programming - bootstrapping |
Lecture
12 - bootstrapping |
Bootstrapping
a confidence interval, Bootstrapping
an odds ratio, If-then
statements |
| Programming - controlling flow, making decisions |
Lecture
13 - making decisions |
|
| Simulation modeling |
Lecture
14 - simulation modeling |
|
| Genetic drift simulation - class project |
Lecture
15 - genetic drift simulation |
Genetic
drift simulation - steps 1 and 2 |
|
|
Genetic
drift simulation - steps 3 and 4 |