D. Nixon: CS 12 > Week 3

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

Computer Science 12


Week 3




Sunday, February 21, 2010



Assignment 3 (due next week)

  1. Paper:

    2. Continue work on your paper, as follows: If you have not done so already, email me your paper topic and list of sources ASAP. Begin work on your first draft.

  2. Excel assignment:

    3. 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:

    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:

    Begin creating three HTML pages that you would actually like to display on a website you'll be creating later in the semester. The two pages must be:

    1. A file named  index.html ,  which will briefly introduce your site and contain links to your other pages.

    2. At least two other pages on any topics you like, within reason. (The topic does not need to be computer-related. The topics can be any hobby of yours, for example, as long as it stays within Queens College's computer use policies. Or your site could be about you. For exampple, one of the pages could be your resume (minus street address, to protect your privacy).The two or more pages other than your index page must each contain a link back to your index page.

    In addition to the local links amongst your pages, at least one of your pages must also contain links to other websites.

    When you are finished, put all your HTML files into a ZIP file with the following filename:

    • last-first-website.zip

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

    Submit the ZIP file in the appropriate area on Blackboard, and have access to the files in lab during our next class session. (The two files should be sumitted separately in the same area on BlackBoard, not in a ZIP file.) We will use them again in future exercises both in lab and in homework.


To all information for Week 3  |  To all homework assignments



Excel tutorials

On the Excel IF function:

See also the Excel tutorials listed for Week 2.


To all information for Week 3  |  To all LINK_TO_CATEGORY_TUTORIALS_Excel



HTML tutorials

Here are tutorials on HTML links:

Ses also the general HTML tutorials for week 1.


To all information for Week 3  |  To all tutorials about HTML



Study guide for next week's quiz

Beginning on Sunday, February 28, we will have brief (10 to 20 minute) quizzes at the beginning of each lab session. (Please arrive on time or early.) The quizzes will be on paper.

The February 28 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 the various functions involving dates. They may also include the basic arithmetic operations (addition, subtraction, multiplication, and division). Also you will need to know the difference between absolute and relative addressing of cells (e.g. $A$2 vs. A2). The functions IF, AND, and OR will not yet be covered in Quiz 1, but will be covered in Quiz 2.

    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.

  2. HTML: You will be expected to write out the HTML for a trivially short page which will be described 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 3  |  To all quiz and exam study guides

D. Nixon: CS 12 > Week 3