An experimental course in Fall, 2005 team taught by RJ Banis and RM Nauss
The YRBSS Project and a proposal for the final project are due Thursday, November 17.Tentative description of Final Project:Projects will be presented on Dec 1, 6, and 8.Projects may be either team or individual. If a Team project, responsibility for separate sections or aspects of the project should be identified clearly, as two people may not get the same grade on a joint project. A project should consist of application of tools studied in this course to some reallife case related to work, volunteer activity, or selected observed situation in everyday life. A project should involve quantitative analysis and work proportional to the number of participants. Maximum of 2 students on a project. 25 minute presentation each person with roles of each clearly defined. Students not presenting on a given day will produce "suggestions on the presentation/project" assignment that contributes to the grade to asssure everybody gets a hearing. Comments must be strictly positive, and will go to the presenters anonymously at the end of the course. tools they should use, e.g.:
Participants' sections of each report will receive grades based
on criteria such as novelty, clarity, correct application,

You may need access to a computer where you can install the software from the book to do the exercises. You should also have a copy of Microsoft Office on your computer so you can do the EXCEL assignments at home. Try the bookstore for the Academic version Office Pro at a very reasonable price.
There will be Videos and other course materials on CD This is different from the CD that comes with the book.
Suggested supplementary texts, not required. No need to buy these, but they are good books for reference in this area:
Week one:
Overview and EXCEL
Basics
Participant Survey
Example: A practical thinking problem, "How
to take exams" part 1see mygateway course documents.
given points and times for questions on an exam in which there is not
time to do it all, what sequence should you use to maximize total score?
initially assume partial credit proportional to time spent for the last
question that would be only partially completed.
How would the sequence change if there were no partial credit?
Examples: Some online data:
Missouri Sex Offender Database (MSHP, requires Internet Explorer)
Unfortunately, since the start of the course, Missouri has made
it more difficult to access these data. You can't easily download the the
whole dataset. You can, however, search it a small piece at
a time online if you have the patience,
http://www.mshp.dps.missouri.gov/MSHPWeb/PatrolDivisions/CRID/SOR/SORPage.html
Document NPV Chapter 8
NPVexample.xls ( 23040 Bytes )
Document IRR example Chapter 9
Internal_rate_of_return.xls ( 21504 Bytes )
Document Ch 10 Financial Functions
Chapter_10_financial_functions.xls ( 67584 Bytes )
Document Solution to Assn. 1
Assignment_1_NPV_solution.xls ( 16896 Bytes )
Document Solution to Assn. 2
Assignment_2_IRR_solution.xls ( 19456 Bytes )
Document IRR assignment due 9/20
IRR_assignment.xls ( 14848 Bytes )
Document NPV assignment due 9/22
NPV_assignment.xls ( 13824 Bytes )
Document Baseball simulation due 1230 on Tuesday 10/18
Assignment_10_04__baseball_.xls ( 51712 Bytes )
Example: GoalSeek
Example: Optimizing with EXCEL SOLVERDocument Ch 16 Lemonade Goal Seek
Ch_16_lemonadegstemp.xls ( 15360 Bytes )
Document Ch 16 Mortgage Goal Seek
Ch_16_Mortgage_example_and__4.xls ( 15360 Bytes )
Example: Youth Risk Behavior Surveillance Survey data, Pivottables & PivotchartsFiles from the book available on mygateway:Document Solver intro 10112005
solverintro10_11_05.xls ( 29184 Bytes )
Document Ch 25 Production Mix Example
Ch_25_production_mix_10_11_05.xls ( 33792 Bytes )
Document Ch 26 transportation problem 10132005
Ch_26_transport_Oct_13_2005.xls ( 32768 Bytes )
Document Ch 26 example: Transportation extension
Chapter_26_extension.xls ( 20480 Bytes )
Document Ch 26 #3 HLOOKUP function
Ch26_num_3_Hlookup_function.xls ( 20480 Bytes )
Document Ch 27 example workforce scheduling
Ch_27_employee_scheduling.xls ( 19968 Bytes )
Document Ch27 cost and overtime
cH27__2_COSTS_AND_OT.xls ( 18432 Bytes )
Document Ch27 scheduling TV ads
ch27__4_scheduling_TV_ads.xls ( 20480 Bytes )
Document Ch 28 capital budgeting
Ch_28_text_capbudget.xls ( 36352 Bytes )Document Assignment Due Nov 1
ch26num4.xls ( 18432 Bytes )
Navigating in large datasets (15,000 rows, 100 columns) Importing and parsing fixed length datafiles we will work with the 2003 data so you get experience with importing
 e.g These are FLASH video files survey crosstabulations with PivotTables
 Percent of males and females who smoke
 Who weighs moresmokers or nonsmokers? pivchvar
Preview of BA3300 statistics: Statistics will allow significance analysis (though we won't do it here)
Workbooks:
 Sudoku helper written with formulas in EXCEL I don't know where this came from. when I find it I'll put it up as a reference
 Others solvers written in VBA and other helpers with formulas alone
 Forms for efficient data entry Data Form Tool for entering data
 Forms Tool barinteractivity
 recording macros example: repetitive sampling from airplane empty seats
 Note that VBA data analysis tools are required if referenced in macros, and that relative macros may not work with data analysis tools. Work around by moving the data between cycles. Make 20 samples of n=25 from the 1000member dataset.
 make histograms of sample means and original raw data and measure means and standard deviations of population vs. sample means. how are they different?
Charting: Different types of charts
Scatter Chart and Simple Regression using YRBSS height and weight
Histograms (not usually taught in computer courses!)
Dynamic histograms (function) vs. Static histograms (procedure in Data analysis tools) the varsorc model
Charting Stock indexes, unemployment and Market analysis
Some Really BAD Forecasts
How bad was unemployment during the last election campaign? See historical and current unemployment statistics from the Current Population Survey Statistics . Here are data converted to EXCEL, unemp.xlsDid the economy go into a tailspin after 9/11/01 ?
Historical Stock index data free from Finance.YAHOO.com:
Dow Jones Index monthly from 19282005, note dates should be resorted ascending and that dates before 1930 are wrong century. How do you fix this? Note the problem in dates before 1930. these, for some reason, have the wrong century!!
See the videos from BA3300 about downloading data and time series analysis http://www.umsl.edu/~rbanis/3300/3300vids/3300vid.htmPreview multiple regression & time series (CAPM model and estimating
Beta's e.g., p369374 in Winston & Albright, 2001)
Intro to Macros (VBA: simulation models with macros)
 Random extinction of family names http://www.umsl.edu/~rbanis/3320/docs/namsim2.xls