D. Nixon: CS 12 > Week 4

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

Computer Science 12


Week 4




Sunday, February 28, 2010



Assignment 4 (due next week)

  1. Paper:

    2. Continue work on your paper, as follows: (1) If you have not done so already, email me your paper topic and list of sources ASAP. (2) Submit the first draft via Blackboard, by no later than the beginning of class on Sunday, March 7.

    The file must have a filename with the following format:

    • last-first-roster.docx

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

  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. 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 an earlier week, 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 a column indicating whether a given item is taxable, so that sales tax can be computed.

      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.

  3. HTML Assignment:

    1. Make sure you can access, in lab next week, a graphics file that you legally own and have the right to publish on a website, e.g. a digital photo of yourself. During the last hour of lab next week, you'll be shown how to display your graphics file on one of the pages discussed in the next item below.

    2. If you have not done so already, create at least three HTML pages that you've written, one of which has the name index.html and links to the other two (or more), all of which, in turn, link back to index.html, which will be the main page of your forthcoming website. (See these HTML tutorials.) The pages need not be long or fancy, but they should contain the beginnings of an actual intended website. Links between your pages should use relative pathnames, assuming the files are all in the same directory. At least one of the pages should also contain links to at least three outside websites. Submit your HTML pages in a single ZIP file via Blackboard, and make sure you can access them in lab next week.

    3. Continue to develop the text of the above-discussed three pages into something you would actually like to display on a website, and re-submit them. Your HTML files should now contain "real" text, not just demo text.

    As before, your ZIP file must have a filename of the form  last-first-website.zip ,  where  last  and  first  should be replaced by your own last name and first name, respectively.


To all information for Week 4  |  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 4  |  To all tutorials about Excel



Study guide for next week's quiz

The March 7 quiz will be an on-paper quiz having two parts:

  1. Excel: Given a picture of a portion of an Excel spreadsheet, you will be expected to write appropriate formulas for the specified cells. The formulas will involve some of the functions that have been covered in lab and/or in tutorial material. These may include SUM, COUNT, AVERAGE, MIN, MAX, and especially IF, AND, and OR. They may also include the basic arithmetic operations (addition, subtraction, multiplication, and division), plus the relational operators, (such as  < ,  > ,  <= , and  >= ),  which we've often seen used within logical expressions. Also you will need to know the difference between absolute and relative addressing of cells (e.g. $A$2 vs. A2).

    2. To prepare for the quiz, you will need practice using all the above-named functions. 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 functions, including nested IF functions.

  2. HTML: As on the previous quiz, you will be expected to write out the HTML for a trivially short page which will be dscribed on the quiz. You will be expected to know all the HTML we have covered in class so far. You will be expected to know how to create HTML links using the  a  tag with the  href  attribute, and you will be expected to know how to use the  body ,  p  (paragraph),  head ,  title , and  html  tags. (See the HTML tutorials.)


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

D. Nixon: CS 12 > Week 4