All assignments are to be submitted as text-only email or posted on
the web and submitted by email
containing the URL of the
assignment to:
with absolutely no attachments. Assignments will
in general not be accepted late. Three times in the semester, an
assignment may be submitted one week late for half credit.
No assignments will be accepted on paper. No assignments will be
accepted on diskettes.
You may use your Linux Accounts
to post assignments on the web as a means of submission. You can
transfer spreadsheets as if they were pictures.
An
assignment is late if the email is sent after the start of the class at
which it is due.
The grade for the assignment will be sent back to the email address from
which the
assignment email was sent. In the case of group assignments in which
multiple students
are involved, one student should be the sender of the email and the other
students should
be listed both in the email "CC:" list and in the body of the
message.
Students should check this page frequently for updates.
Assignments with an assignment date one week or more in the
future are subject to change.
Assignment #1, assigned Wednesday, 28 January 2009, due Wednesday,
4 February 2009.
Be certain to get the text books.
Read Gips, pages 1-89
Based on what you have read and/or by experimenting with Excel
or with Open Office Calc,
if cell A1 contains 5, cell B1 contains 3.5 and cell C1 contains
1.25 and cell D1 contains the formula =SUM(A1:C1), what will show
on the spreadsheet in cell D1?
Do exercises 4-1 and 4-2 on pages 70 - 71 in Gips
Email your answers to the instructor no later than the start of
class on 12 February 2008. Do not assume that you can stall a few minutes.
You also have a quiz to work on at the start of that class.
Assignment #2, assigned Wednesday, 4 February 2009, due Wednesday,
11 February 2009
In class today, you will have been shown a way to post your
assignments on the web. Try to post your answers to this assignment
on the web, and send an email to the instructor, with the URL
of your answers, or discussing the problems you had doing it.
If you were not able to post your answers that way, send the answers
as email.
If at all possible, form a study group for your work in this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Read Gips, pages 91-188.
Do exercise 6-12 on page 111 and copy out the completed
windchill table (not the formulas, but the resulting numbers).
Try to do exercise 11-17. If you are able to post files
to the web, post the workbook. If not, describe your solution
in detail and with formulae in the body of an email message.
Remember that you are free to work with others, and, especially
for this problem, are encouraged to do so. It is very important
that you work on this exercise. We will discuss it in detail
in class, and you will be expected to participate in the discussion.
Assignment #3, assigned Wednesday, 11 February 2009, due Wednesday,
18 February 2009
In class today, you will again have been shown a way to post your
assignments on the web. Try to post your answers to this assignment
on the web, and send an email to the instructor, with the URL
of your answers, or discussing the problems you had doing it.
If you were not able to post your answers that way, send the answers
as email.
Once again, if at all possible, form a study group for your work in this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Read Gips, pages 189-331.
Do and submit the pencil and paper exercise 15-1 on pp 261.
Do and submit exercise 15-9 on page 264.
Be sure you have the Mansfield text. You will need it for
next week's assignment.
Assignment #4, assigned Wednesday, 18 February 2009, due Wednesday,
25 February 2009
Try to post your answers to this assignment
on the web and send an email to the instructor, with the URL
of your answers, or discussing the problems you had doing it.
If you were not able to post your answers that way, send the answers
as email.
Once again, if at all possible, form a study group for your work in this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Read all of parts 1 and 2 in Mansfield, pages 1-1. Be prepared
to discuss part 1.
Try to do the Excel examples on pp 23-25 and pp 87-90. If you managed to
create something that you can save, post it on your web page and send the
URL to the instructor by email. If you fail, send an email describing
in detail the difficulties you had following the instructions.
Assignment #5, assigned Wednesday, 25 February 2009, due Wednesday, 4 March
2009
Try to post your answers to this assignment
on the web and send an email to the instructor, with the URL
of your answers, or discussing the problems you had doing it.
If you were not able to post your answers that way, send the answers
as email.
Once again, if at all possible, form a study group for your work in this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Read Chapter 1, pages 1-22, Chapter 5, pages 119-162 and Chapter 13,
pages 365-339 of the OOo Authors Team book.
Read Chapter 8 in Part 2 and all of part 3 in Mansfield, pages 155-271. Reread and be prepared
to discuss all of part 2.
Last time you tried to do the Excel examples on 23-25 and pp 87-90.
Try to apply what you did then and enter the code in listing 7.3 on
pages 150-151. If you managed to create something that you can save, post it on your
web page and send the URL to the instructor by email. If you fail, send an email
describing in detail the difficulties you had following the instructions.
Note: There is no class on Wednesday, 11 March 2009. Dowling is
on spring break that week.
Assignment #6, assigned Wednesday, 4 March 2009, due Wednesday,
18 March 2009
We will have looking in detail at Visual Basic syntax today.
Use the two weeks for this assignment to become thoroughly familiar
with how visual basic is written.
Try to post your answers to this assignment
on the web and send an email to the instructor, with the URL
of your answers, or discussing the problems you had doing it.
If you were not able to post your answers that way, send the answers
as email.
Once again, if at all possible, form a study group for your work in this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Read all of part 4 and part 5 in Mansfield, pages 273-493. Reread
and be prepared to discuss part III.
Do the example in listing 10.4 on page 221 and test it in Excel.
If you managed to create something that you can save, post it on your
web page and send the URL to the instructor by email. If you fail, send an email
describing in detail the difficulties you had following the instructions.
Assignment #7, assigned Wednesday, 18 March 2009, due Wednesday,
25 March 2009
We will have tried to catch up in looking at VBA syntax today
and will have discussed the use of modules
and VBA to add user-defined functions to a spread sheet. Write
and test a module with a VBA function that will compute the tax
for a married couple filing a joint return according the rules at
http://www.irs.gov/formspubs/article/0,,id=164272,00.html.
Post the resulting spreadsheet to your web site with the
module in the spread sheet. Call the function Y1MFJ.
Read all of part 6 in Mansfield, pages 495-738. Reread
and be prepared to discuss part 4 and 5.
Considering what you have read, attempt to create a form
or dialog box that will accept user input of the following information:
the date on which a bond was purchased; the dollar amount on the
face of the bond, the dollar amount of the purchase price; the
annual interest rate (the coupon) as a percentage, the maturity
date (the date at which you can be certain the bond will be redeemed)
and the first call date (the earliest date at which the bond issuer
can insist that you return the bond for redemption at face value).
Do as much of this exercise as you can by the next class and send
email with a URL pointing to as much as you can do by next class.
This assignment will not be accepted late -- we will be doing
this during the next class and building it into a spreadsheet.
Once again, if at all possible, form a study group for your work in
this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Assignment #8, assigned Wednesday, 25 March 2009, due Wednesday,
1 April 2008
In class today we will have discussed the use of forms
in VBA. Rewrite the module with a VBA function that will compute the tax
for a married couple filing a joint return according the rules at
http://www.irs.gov/formspubs/article/0,,id=164272,00.html to
use a form. Post the resulting spreadsheet to your web site with the
form in the spread sheet.
Reread chapters 22 and 23 in part 6 in Mansfield,
and be prepared to discuss.
Considering what you have read, take the form you did or
started for the last week's assigmment, and add the necessary code
so that the form will accept additional inputs -- the issue date
(the date on which the bond was originally issued), the interest
period in months (i.e. the number of months between interest
payments) with a default of 6 months, and the valuation date
(i.e. a date as of which we will compute some values) with a
default of the current date. The add to the form and the code
behind it whatever you need to provide the following outputs:
the dollar amount of each interest payment, the total amount
of interest that will have been paid from the issue date until
the valuation date, the total amount of interest that will
have been paid from the purchase date until the valuation date
and the total amount of interest remaining to be paid from the
valuation date until the first call date and until the
maturity date. Do not worry about fractional interest periods.
Assume that, if the end of an interest period has not arrived,
no interest will have been paid. We will deal the such
issues next time.
Once again, if at all possible, form a study group for your work in this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Assignment #9, assigned Wednesday, 1 April 2008, due Wednesday,
15 April 2008
In class today we will have discussed the use of controls on forms
in VBA. Last time for homework you were to rewrite the module with a VBA
function that computed the tax for a married couple filing a joint return
according the rules at
http://www.irs.gov/formspubs/article/0,,id=164272,00.html to
use a form. If you were not able to do that assignment, do it now. Notice
that the rules cover more cases, and that the
web page has 4 tables. Add the necessary controls to the form so
that a user can indicate which tax status applies to them and then
apply the correct tax table. Post the resulting spreadsheet to your web
site with the form in the spread sheet. We we not have
been done this example in class. We will have done examples with
bind interest instead. Next time we will, so, try very
hard to get caught up before 15 April.
Reread chapters 22 and 23 in part 6 in Mansfield,
and be prepared to discuss.
Take the bond-interest example we have been working on in
class and the mortgage interest example we will have worked on
today, and add the necessary controls to make a general loan
calculator that covers both bonds and mortgages. Try to lay it
out as a generally useful tool. Be creative.
Once again, if at all possible, form a study group for your work in
this class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Assignment #10, Wednesday Tuesday, 15 April 2009, due Tuesday,
22 April 2009
In class today we will have finished the income tax example
using 4 tables, with the correct one selected from a form. If you
did not complete that problem in HW9, update your website with
the completed assignment now.
In class today we will have gone over the code for Conway's
Life in VBA. Complete the implementation as a spreadsheet.
Reread chapters 20 and 21 in part 6 in Mansfield, and be prepared to
discuss.
Once again, if at all possible, form a study group for your work in this
class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Assignment #11, assigned Wednesday, 22 April 2009, due Wednesday,
29 April 2009
In class today we will have finished the income tax example
we did not get to last time,
using 4 tables, with the correct one selected from a form. If you
did not complete that problem in earlier, update your website with
the completed assignment now.
In class today we will have worked on amortization of
bond premium. Take what we did in class, and provide a completely
worked sample worksheet showing all interesting details about
the amortization of a $100,000 Treasury bond, issued on
15 May 1985 with a 5% coupon, sold on 15 May 1990 for $120,000
and maturing on 15 May 2015. The minimum you need to show
is the effective yield and the value of the bond each year.
Have your notebook ready for grading.
This is the time to catch up on all past assignments. Have
everyting you are able to do ready on your web site by the start
of class. Have questions ready on the assignments you were not
able to do.
Once again, if at all possible, form a study group for your work in
this class. You are free to work with others on the rest of this
assignment, but you must list all the people you work with on
your answers.
Assignmentment #12, assigned Wednesday, 29 April 2009, due Wednesday,
6 May 2009
In class today, we will have finished the amortization of bond
premium example. If you did not finish the assignment on this from last
time, do it now.
This is your last assignment before the final, and is actually an
extra-credit take-home part of your final. Take everything you have learned and
working by yourself but using code fragments you find on the web if you wish,
make a function that computes your body mass index as your weight in
kilograms divided by the square of your height in meters, or as
703 times your weight in pounds divided by the square of your height
inches (see
http://www.cdc.gov/healthyweight/assessing/bmi/adult_bmi/index.html).
Test the function as a formula in a spread sheet. Then create a form and
use the function to drive the form. Email the URL of your spreadsheet with
the macro and the form for full credit no later that 7:30 pm on 6 May
2009 and for half credit on the day of the final.
There will be an in-class, open book, open computer final in Wednesday,
13 May 2009.