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 Tuesday, 5 February 2008, due Tuesday,
12 February 2008.
Be certain to get the text books.
Read Gips, pages 1-86
Based on what you have read and/or by experimenting with Excel,
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 67 - 69 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 Tuesday, 12 February 2008, due Tuesday,
19 February 2008
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 87-188.
Do exercise 6-12 on page 109 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 Tuesday, 19 February 2008, due Tuesday,
26 February 2008
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-330.
Do and submit the pencil and paper exercise 15-1 on pp 262-262.
Do and submit exercise 15-9 on page 265.
Be sure you have the Guy Hart-Davis text. You will need it for
next week's assignment.
Assignment #4, assigned Tuesday, 26 February 2008, due Tuesday,
4 March 2008
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 I and II in Hart-Davis, pages 1-152. Be prepared
to discuss part I.
Try to do the Excel examples on 19-20 and pp 80-83. 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 Tuesday, 4 March 2008, due Tuesday,
11 March 2008
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 III in Hart-Davis, pages 153-242. Reread and be prepared
to discuss part II.
Last time you tried to do the Excel examples on 19-20 and pp 80-83.
Try to apply what you did then and enter the code in listing 7.3 on
pages 130-131. 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 Tuesday, 18 March 2008. Dowling is
on spring break that week.
Assignment #6, assigned Tuesday, 4 March 2008, due Tuesday,
25 March 2008
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 IV and part V in Hart-Davis, pages 243-438. Reread
and be prepared to discuss part III.
Do the example in listing 10.4 on pp 194-195 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 Tuesday, 25 March 2008, due Tuesday,
1 April 2008
In class today we 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 VI in Hart-Davis, pages 439-657. Reread
and be prepared to discuss part IV and V.
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 Tuesday, 1 April 2008, due Tuesday,
8 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 VI in Hart-Davis,
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 Tuesday, 8 April 2008, due Tuesday,
15 April 2008
In class today we will have discussed the use of controls on forms
in VBA. Last time for homework you rewrote the module with a VBA function
that will 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. 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 have intentionally not
been doing this example in class. Next time we will, so, try very
hard to get caught up before next week.
Reread chapters 22 and 23 in part VI in Hart-Davis,
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 #9, assigned Tuesday, 15 April 2008, due Tuesday,
22 April 2008
In class today, we will have finished the work on mortage interest
we had hoped to complete last time. Therefore the assignment from
last time to "take 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." is actually due
on 22 April, rather than on 15 April.
In class today we will have worked with a form for taxes, and
we will have looked at manipulating spreadsheet cells from within
a VBA procedure. Adapt your form so that you can use the controls
on the form to select the correct tax table, but so that the
results will be placed in a cell specified. You will need VBA 6
to do this exercise properly with a non-modal form. If you do
not have VBA 6, use a spreadsheet command button to start the
form.
Reread chapters 23 in part VI in Hart-Davis, 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 #10, assigned Tuesday, 22 April 2008, due Tuesday,
29 April 2008
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 VI in Hart-Davis, 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 Tuesday, 29 April 2008, due Tuesday,
6 May 2008
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.
In class today we will have worked with creating charts from
within VBA code. Make a form that accepts up to 300 numeric grades,
using one text box and two buttons, one button to accept the next grade
from the text box and one that plots a histogram of all the grades
that have been accepted.
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.
There will be an in-class open books, open notes, open
computer, cummulative final on Tuesday, 13 May 2008. Don't be late.