MGM272

Business Applications of Technology

Assignment / Project   Number  06

Spreadsheet Conditional Statements

How is this project graded?

This project, like the others, is graded on the basis of a maximum ten points.    

Remember that a major goal of the project was to work with IF statements.  If you did not use IF statements, or if there was no evidence that you did, you received one point on this assignment as a holiday gift for whatever holiday is near.

If you did not use IF statements in calculating the current balances, or if there was no evidence that you did, but you did use IF statements in calculating the sums of withdrawals and deposits, then you lost five points.

If you did not calculate the withdrawals column and their sum (using IF statements and the SUM function), you lost two points.

If you did not calculate the deposits column and their sum (using IF statements and the SUM function), you lost two points.

If you did not calculate the MINIMUM BALANCE or the AVERAGE BALANCE, you lost one point each, assuming other things were correct. 

You needed to turn in the following to the instructor on the date this assignment was due (check the class schedule):
  1) PRINTOUT #1:  A printed copy of your spreadsheet, showing the numbers in each cell,
       with your name and course ID number in the upper left corner.
  2) PRINTOUT #2:  A printed copy of your spreadsheet, showing the formulas in each cell,
       with your name and course ID number in the upper left corner.
  3) DISK FILE:  A copy of the disk file on which you have saved your spreadsheet. 
       The name of the file on the disk should be "checks.xls"
       The label on the disk should have YOUR NAME, and the words:
       ASSIGNMENT #06 -- CONDITIONAL STATEMENTS
  4) OTHER:  The above items are all that is required for this assignment.