D. Nixon: CS 12 > Week 3

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

Computer Science 12


Week 3




Friday, September 9, 2011



Assignment 3 (list of sources due Tuesday, September 13, 2011; Excel and HTML parts due Friday, September 16, 2011)

  1. Paper:

    2. Continue work on your paper, as follows: (1) By no later than Tuesday, September 13, email me your list of sources. (2) Submit the first draft via Blackboard, by no later than noon on Friday, September 23. It should have the following filename:

    replacing "last" and "first" with your actual last and first names.

  2. Excel assignment:

    1. Continuing the grade roster assignment from last week:

      2. Below the rows for the students, add rows for (1) the class average for each quiz, exam, or calculated result, (2) the class's lowest score for each quiz, exam, or calculated result, and the class's highest score for each quiz, exam, or calculated result.

      Below the grade roster, create a column chart showing the lowest, average, and maximum scores for each quiz, exam, and calculated result. (The easiest way to do this will be to create a column chart for your entire roster, then right click on it and click "Select Data" to edit the chart, then delete unwanted parts. Also, before you create the chart, it is recommended that you temporarily remove any heading you have at the top of the column for students' names, so that the other column headings will be recognized as headings.) See this week's Excel tutorials for step-by-step instructions on creating charts.

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

      • last-first-roster.xlsx

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

    2. Continuing the invoice assignment from last week:

      3. Pretty it up. Among other things, it should now display a date.

      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.

    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.

  3. HTML assignment:

    Begin creating three HTML pages that would actually be appropriate to display on a personal website. The three 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..


To all information for Week 3  |  To all homework assignments



Excel tutorials

On Excel charts:

On Excel tables:

Date functions:

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 1.


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



Study guide for next week's quiz

Beginning on Friday, September 16, 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 September 16 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).

    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