Computer Science 12:

Study guides for quizzes and the final exam

• Study guide for quiz 1, to be given March 3, 2012
• Study guide for quiz 2, to be given March 10, 2012
• More later

Study guide for Quiz 1, to be given March 3, 2012

Beginning on Saturday, March 3, 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 March 3 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).

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 three 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

Study guide for Quiz 2, to be given March 10, 2012

The March 10 quiz will be an on-paper quiz having two or three parts, covering the following topics:

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 the IF function. 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), and you will need to the date formulas we covered in class (the DATE, TODAY, and DAYS360 functions, and the use of simple subtraction to compute the number of days between two dates).

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. Word 2007/2010: There may be one or two fill-in-the-blanks or multiple choice questions about heading styles and automatically-generated tables of contents.

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