D. Nixon: CS 12 > Week 5

Home (CS 12) | Assignments | Tutorials | Quizzes & Exam | Other Info

Computer Science 12


Week 5




Friday, September 23, 2011



Assignment 5 (due next week)

  1. Paper:

    2. Submit the second draft via Blackboard, by no later than noon on Tuesday, October 4. The file must have a filename with the following format:

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

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

  2. Excel Assignment:

    1. Create a spreadsheed listing at least 10 sales people who work for some particular company, to compute their rank as employees. The spreadsheet should have columns for the salespersons' names, the date that they were hired, the dollar amount of sales by each sales person during the past month, and the sales person's rank. Sales people have rank 3 if they have worked for the company for at least five years and sold at least $20,000 worth of goods during the past month. They have rank 2 if they have either worked for the company for at least five years or sold at least $20,000 during the past month. They have rank 1 if neither of the above is true. Format the spreadsheet as a table.

      2. You might find it helpful to include an additional computed column for the number of years an employee has worked for the company (computed from the date hired). This may make it easier for you to compute the person's rank.

      This spreadsheet should have a filename with the following format:

      • last-first-salesforce.xlsx

      Submit the above file in the appropriate area on Blackboard, and have access to the file in lab for all future weeks. We will use it again in future exercises both in lab and in homework.

    2. Continuing the invoice example from two weeks ago, let's say the store decides to start selling some food items, if it didn't already sell food, or, conversely, let's say that the store now decides to sell some non-food items, if it was already selling food. The point being, some items are now taxable and others aren't.

      3. Add some rows for the new items, and add the following two columns: (1) a column indicating whether a given item is taxable (e.g., a "T" if taxable, blank otherwise), and (2) the amount of sales tax on a given item (zero if it is not taxable). The total tax should then be computed by adding up the taxes on individual items, rather than based on the subtotal of all items.

      When computing tax, you will need to refer to a single cell holding the tax rate. You'll need to use absolute addressing (with the dollar signs) to refer to that cell.

      Begin from the next-to-last version of the invoice. Do not use a version of the invoice that has discounts, which will make your computations much more complicated.

      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.


    To all information for Week 5  |  To all homework assignments



    Excel tutorials

    On IF and other logical functions (AND, OR) and nested IF functions:

    Date functions:

    On range names and labels:

    It is recommended that you also use Excel's Help feature to get more information on all of the above.

    See also the Excel tutorials listed for Week 3.


    To all information for Week 5  |  To all LINK_TO_CATEGORY_TUTORIALS_Excel



    Microsoft Word tutorials

    Styles for headings (needed in table of contents):

    Table of contents:


    To all information for Week 5  |  To all tutorials about Word



    Study guide for next week's quiz

    On Tuesday, October 4, we will have our usual brief (10 to 20 minute) quiz at the beginning of class. (Please arrive on time or early.) The March 18 quiz will be an on-paper quiz having two parts:

    1. Excel: Similar to last week's Excel quiz problem, but probably more challenging.

      2. To prepare for the quiz, you will need practice using all the functions we've covered so far (listed in the previous study guide), plus AND and OR. To that end, it is recommended that you not only do the homework but also play with examples in the Excel tutorials for all four weeks up to now. Make sure, especially, that you get practice with IF, AND, and OR functions, including nested IF functions.

    2. Microsoft Word: One or two brief fill-in-the-blanks or multiple-choice questions on the use of heading styles and the generation of a table of contents.


    To all information for Week 5  |  To all quiz and exam study guides

D. Nixon: CS 12 > Week 5