Continue work on your paper, as follows: Submit the first draft via Blackboard, by no later than noon on Friday, September 23. It should have the following filename:

• last-first-paper.docx

The first draft must contain at least three pages and must be divided into at least three sections, with headings. It is strongly recommended, also, that the first draft contain quotes from at least some of your sources. (The second draft will be required to contain at least one quote from all of your sources, which must include at least two websites and at least one physical offline source such as a book.)

In our next class we will show you how to style the headings, which you will need to be able to do in order to create a table of contents later.

1. Continuing the grade roster assignment from last week:

Add columns for the total score and "pass/fail." The total score will be based on the following formula: 40% final exam, plus 15% first in-class exam, plus 15% second in-class exam, plus 30% of ten times the quiz average with lowest score dropped. (The quiz score needs to be multiplied by ten to scale it up from a range of 0 to 10 to a range of 0 to 100, to be consistent with the exam scores.) The "pass/fail" column will say "pass" if the total score is at least 65, "fail" if the total score is less than 65.

Fix all errors mentioned in the feedback you got on Blackboard from your previous version.

As before, your Excel spreadsheet should have a filename having the following format:

• last-first-roster.xlsx
2. Continuing the invoice assignment from last week:

Continuing the invoice example from last week, add a cell which computes discounts as follows: (1) No discount for the first $100. (2) For subtotals above $100, five percent of the amount that the subtotal exceeds $100. For subtotals above $500, an additional five percent of the amount that the subtotal exceeds $500.

There should be separate cells for (1) the original subtotal, (2) the discount, (3) the subtotal with discount subtracted, and (4) the total with sales tax added.

As before, the invoice should have a filename with the following format:

• last-first-invoice.xlsx

where "last" and "first" should be replaced by your own last and first name.

Your invoice must be unique, containing a store name, product names, and prices different from those in files submitted by other students in Computer Science 12.

Submit BOTH of the above files in the appropriate area on Blackboard, and have access to the files in lab next week. (The two files should be sumitted separately in the same area on BlackBoard, not in a ZIP file. You must submit both at once, not separately.) We will use them again in future exercises both in lab and in homework.