|
Basic Information
Required Materials
Excel for Dummies, ISBN: 1-568-84050-0 (recommended)
Computer Use Policy
This class meets in the computer lab. Use of e-mail, or IM, and web surfing (with the exception of when you are directed to do so) is prohibited. You may think that you are good at multi-tasking. Experimental evidence strongly suggests otherwise. Each instance in which I observe you misusing computers during class will cost you 10% points from your final course grade.
Exams and Homework Assignments
Assignment #4: Assigned 2/22, Due 2/24. Using this version of the Social Security benefits workbook, write a macro that generates a table of present discounted values of Social Security benefits for starting incomes from $10,000 to $100,000 (in increments of $1,000) and salary growth rates from 3% to 5% in increments of 0.5%.
Assignment #3: Assigned 2/17, Due 2/19. This data set comes from the Steelers website. I have copy/pasted it into this excel workbook (see the Raw Data sheet). Using what you have learned, arrange the data according to the example on the Cleaned Data sheet.
Assignment #2: Assigned 1/11, Due 1/15. Using the latest version of the Social Security benefits workbook, write a macro that generates a table of present discounted values of Social Security benefits for starting incomes from $10,000 to $100,000 (in increments of $1,000) and salary growth rates from 3% to 5% in increments of 0.5%.
Assignment #1: Assigned 1/5, Due 1/11. Complete the column for Social Security benefits.
Handouts and On-Line Help
Data Sets Used in Class Latest version of in class projects
Other Stuff A comprehensive dictionary of statistical measures Glossary of Statistical Terms I Glossary of Statistical Terms II Encyclopedia of Probability and Statistics
|
|
Advanced Excel Modeling |
