Assignment 2

Home

Due Date: 4pm, Friday 2-May-08 (week 9)
Marks: 12%

Problem Description

Harvey Wallbanger Norman offer a choice of 1, 2, 3 or 4 year interest free repayment on purchases which cost $600 or more. The purchase cost can be repaid in a lump sum at the end of the interest free period or by regular monthly repayments. Cautious buyers use the regular monthly repayment option as interest of 23% per annum is charged if the full cost of the purchase has not been repaid by the end of the interest free period.

You are to use Access Basic to develop a product which is easy to use and maintain and which allows a user to enter the cost of a purchase and which displays the approximate regular monthly repayments for the 1, 2, 3 and 4 year interest free options. The product should allow the user to enter more than one purchase cost.

Example Run

The following is an example run with all input and output shown.

Run


*** Welcome to the Monthly Repayment Calculator ***

Do you wish to enter the cost of a purchase (Yes or No) ? Y
Your response must be Yes or No
Do you wish to enter the cost of a purchase (Yes or No) ? Yes
What is the cost of your purchase ($600 or more) $ ? 500
ERROR: Interest free terms are only offered on a purchase of $600 or more

Do you wish to enter the cost of a purchase (Yes or No) ? Yes
What is the cost of your purchase ($600 or more) $ ? 600

********    Monthly Repayments on $600   *********
1 Year        2 Year        3 Year        4 Year
  50            25            17            12

Do you wish to enter the cost of a purchase (Yes or No) ? OK
Your response must be Yes or No
Do you wish to enter the cost of a purchase (Yes or No) ? Yes
What is the cost of your purchase ($600 or more) $ ? 1000

********    Monthly Repayments on $1000   *********
1 Year        2 Year        3 Year        4 Year
  83            42            28            21
Do you wish to enter the cost of a purchase (Yes or No) ? No



*** Thanks for using the Monthly Repayment Calculator ***

Requirements

Assume that the purchase cost will be in whole dollars.

Display the monthly repayment amounts to the nearest dollar.

Use a Boolean variable and a While loop to validate the Yes or No response to the question "Do you wish to enter the cost of a purchase (Yes or No) ?"

Use a For loop to calculate the monthly repayments for the 4 different interest free options.

Sections Required

The assignment should be word processed with each page numbered. Suggested left margin 2.5cm, right margin a minimum of 1cm.

The following sections are required, (in this order).

1. Title Page

This should contain:

• your name
• subject name
• tutorial group
• tutor's name
• assignment number
• submission date

2. Statement of Authorship

This must contain:

• the standard text for a Statement of Authorship for the Department
• your name
• subject name
• assignment number
• your signature
• date signed

The work will not be marked without a signed statement of authorship.

3. Table of Contents

• List all the major sections in the assignment and the page numbers they occur on.

4. Defining Diagram

• As specified in class and the Defining Diagram Guide.

5. Pseudo Code

• As specified in class and the Pseudo Code Guide.

6. Data Dictionary

• As specified in class and the Data Dictionary Guide. Where possible the data dictionary should appear on the same page as the pseudo code.

7. Desk Check

• As specified in the Desk Check Guide.
• Provide Desk Checks for test run numbers 1 to 3 (test set 1)

8. Visual Basic Code

The code should:

• match the logic specified in the Pseudo Code
• the code should be easy to read and understand. It should be
  • well formatted (e.g. correct indentation, a blank line between sections)
  • well commented. This should include comments about the program: program name, purpose, author; comments describing each variable and comments on each section of the program.
  • have meaningful variable names
• have Option Explicit

Copy the code from Access and paste it into your word processed document.

The code listing should:

• be readable
• be in a monospaced (non-proportional) font (Courier New preferred)
• use a font size of 9 or10pt
• avoid line wrapping (use a small right margin if necessary)

You must include a statement indicating whether the code listed successfully compiled (no syntax errors).

Example statement: "The code listed below compiled successfully." or "The code listed below did NOT compile."

9. Test Plan & Runs

• Using the Test Plan below, cut and paste the table into your document, test the program and fill out the actual result and correct columns of the test plan
• Provide printouts of input and output for test run numbers 1 to 3
• To capture the current Window, ensure that the window is selected (e.g. place the cursor in the desired window) and press Alt+Print Screen. This can then be pasted from the Windows Cut/Paste buffer into the desired document (such as Word).
• To provide a printout of the test runs, capture each window separately. To capture the Immediate window rather than the whole Access window, you need to undock it. To do this Right mouse click on the Immediate window and select Dockable (only if it doesn't already have a tick next to it), the Immediate window should now be a floating separate window that can be captured by itself.

Your runs must be made using the program listed in the previous section. You must include a statement indicating that the program runs are for your program as listed in the previous section.

Example statement: "The program runs below are the output of the program listed in the previous section."

Test Plan

Test Set 1: Examples provided

Test Set 2: Incorrect purchase cost

Test Set 3: Yes/No validation

Guide to Marks

The following is a guide to the marks assigned to each section of the assignment.

Written by Chris Cope (and Tim Whitfort).