Submit the second draft via Blackboard, by no later than the beginning of class on Saturday, March 10. The file must have a filename with the following format:

• last-first-paper.docx

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

The second draft, like the first draft, should be at least three pages long. It must contain at least one quote from each of your four sources. The second draft must also be divided into at least three sections, with section headings.

The second draft must also use a heading style for each of the three section headings, and must also contain an automatically generated table of contents at the beginning, right after the paper's title and author. (Note that the automatically generated table of contents, in order to recognize section headings, needs those headings to be styled using heading styles.)

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.

Your Excel files must be submitted by no later than the beginning of class next week. Because we will be using them in class next week, the deadline is final and absolute; no late submissions will be accepted.