Math 11 Lab Page
Information about labs for Math 11 will be posted on this page as needed during the quarter
Both Finance Labs are due on Jan 31 - this is an extended deadline, changed from the original deadline of Jan 24.
PLEASE READ the instruction sheets for each lab. It will really help you to understand what I want you do to for each question.
Loan Schedule Lab:
You may choose to use Excel to do the loan amortization schedule, but you do not have to.
You can do it by hand.
The loan amount is the amount given you on your lab; we are assuming that Cindy's loan is a traditional student loan that does not accrue interest until the student leaves school, in Cindy's case by graduating.
For the Mortgage Lab, here are my responses to your frequently asked questions
POINTS: How to do loan origination fee (points): Look at the explanation for "3 points" on the instruction page
MISC FEES: Use $1000 for the misc fees for your lab.
TOTAL COST: At the bottom of the first side of the worksheet you are asked to find the "total cost": This is just adding up the following: all the mortgage payments you will have made over the entire lifetime of your loan, plus the downpayment, loan origination fee (points) and misc fees.
For the total of all the mortgage payments you will have made, think about the payment amount and how many payments there are in total.
Note that THERE IS NO INTEREST USED in adding up all the parts of the "TOTAL COST" question; JUST ADD!
I will not tell you how to do the bonus.
If you have tried it and you want to check if
your idea is correct, come see me individually.
(If you are OK I will tell you, but if you are not OK I will not tell you HOW to do it.)
Linear Models Lab: Due Thursday February 7
Lab instructions are on handouts distributed in class. If you did not get the handout, or need an extra copy of the worksheet to correct your graphs or other answers if you made errors or work is not neat enough, here's a link to the lab: http://nebula.deanza.fhda.edu/math/FT/Bloom/Math11/M11LinearModelLabW08.pdf
Graphing Hint. Plot the y intercept and one other point on the line. Use one of the high "x" values from the x axis for the other point. Then connect the two points. Its much easier and very much more accurate than trying to count boxes for the slope for these problems
Linear Programming Lab
This is the "double lab" 50 points instead of 25 points. Only "half" of this lab can be dropped - see course syllabus for details.
I will answer questions about your lab if you ask and I will check your optimal value (lower right corner) if you ask. If done correctly: there are 5 y variables and 3 x variables. Your simplex procedure will have 5 tableaus in total, with 4 pivot steps.
Use the special deck of cards I give you for all parts of this lab; yes - for BOTH sides of the lab handout page.
Do not use a complete deck of 52 cards for any part of this lab. If you use a complete deck of 52 cards, the game may continue past 3 draws and your tree and probabilities will be very complicated.
Remember to hand the cards in with the lab and to record your cards at the top of the first side of the page, where asked, so I can see your deck when I grade your lab.