D. Nixon: CS 12 > Quizzes & Exam

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

Computer Science 12:


Study guides for quizzes and the final exam




Study guide for Quiz 1, to be given March 4, 2011

Beginning on Friday, March 4, 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 4 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



Study guide for Quiz 2, to be given March 11, 2011

The March 11 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 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).

    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



Study guide for Quiz 3, to be given March 18, 2011

On Friday, March 18, 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. HTML: There will be a few multiple choice questions on copyright issues and the proper use of free downloadable graphics. (See Copyright issues and policies of "free" graphics download sites.)


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



Study guide for Quiz 4, to be given March 25, 2011

Regarding the quiz to be given on Friday, March 25, see the study guide for the March 18 quiz, which was cancelled. All the topics mentioned there will be covered in the manner indicated.

The quiz will also cover the addtional topic of HTML colors. Know how the colors white, black, brightest red, brightest green, brightest blue, and brightest yellow are represented using hexadecimal notation.


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



Study guide for Quiz 5, to be given April 1, 2011

The April 1 quiz will be an on-paper quiz, mostly about Excel formulas involving the functions that have been covered in lab and/or in tutorial material. These include SUM, COUNT, AVERAGE, MIN, MAX, IF, AND, OR, COUNTIF, SUMIF, and AVERAGEIF, and also the basic arithmetic operations (addition, subtraction, multiplication, and division), plus the date functions. Given an on-paper picture of an Excel spreadsheet, you will be expected to be able to write appropriate formulas for specified cells.

There will also be some multiple-choice and fill-in-the-blanks questions. Likely topics covered include the Excel date functions and the difference between absolute and relative cell references.

To prepare for the quiz, the main thing you will need is practice using all the above-named Excel functions. To that end, it is recommended that you not only do the homework but also play with examples in the tutorials. Make sure, especially, that you are comfortable with COUNTIF, SUMIF, and AVERAGEIF, and also with nested IF functions and logical expressions involving AND and OR.


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



Study guide for Quiz 6, to be given April 8, 2011

The April 1 quiz will be an on-paper quiz, mostly about Excel formulas involving the functions that were covered in lab this week, i.e. the SMALL, LARGE, PMT, PV, and FV functions. It may also involve other functions we've covered in the past, including the SUM, COUNT, AVERAGE, MIN, MAX, IF, AND, OR, COUNTIF, SUMIF, and AVERAGEIF, and also the basic arithmetic operations (addition, subtraction, multiplication, and division), plus the date functions. Given an on-paper picture of an Excel spreadsheet, you will be expected to be able to write appropriate formulas for specified cells.

There will be some fill-in-the-blanks questions, and possibly some multiple-choice questions, on database terminology. Any of the basic database concepts covered in class will be fair game. Know the meaning of the following terms, in the context of databases: "table," "record" (a.k.a. "tuple"), "field" (a.k.a. "attribute"), "key," "foreign key," "referential integrity," "query," "form," and "report."

To prepare for the quiz, the main thing you will need is practice using all the above-named Excel functions. To that end, it is recommended that you not only do the homework but also play with examples in the tutorials. Make sure, especially, that you are comfortable with COUNTIF, SUMIF, and AVERAGEIF, and also with nested IF functions and logical expressions involving AND and OR.

You should also study your class notes and the tutorials on the database concepts we are introducing this week.


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



Study guide for Quiz 7, to be given April 15, 2011

The April 15 quiz will be an on-paper quiz.

Thre will be an Excel spreadsheet problem, and possibly also some multiple-choice and/or fill in the blanks questions regarding Excel as well. You will be responsible for all concepts learned thus far.

There will also be some questions about Goal Seek and how it could be used with various Excel functions we've covered so far. You might first be given a picture of a spreadsheet and asked to write a formula appropriate to some problem, along with fill-in-the-blanks and/or multiple-choice questions about how Goal Seek could then be used with that formula. To be prepared for these questions, you must practice using Goal Seek with a variety of Excel functions.

There will be some fill-in-the-blanks questions, and possibly some multiple-choice questions, on database terminology. Any of the basic database concepts covered in class will be fair game. Know the meaning of the following terms, in the context of databases: "table," "record" (a.k.a. "tuple"), "field" (a.k.a. "attribute"), "key," "foreign key," "referential integrity," "query," "form," and "report."


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



Study guide for Quiz 8, to be given April 29, 2011

The April 29 quiz will be an on-paper quiz.

There will probably be some questions about Excel's VLookup function. The questions may include fill-in-the-blanks and/or multiple choice questions and/or a problem in which you are given a picture of a spreadsheet and asked to write an appropriate formula to go into some specified cell.

There will probably be a spreadsheed problem involving one or more of the previously-covered Excel functions, including LARGE, PMT, FV, PV, SUM, COUNT, AVERAGE, MIN, MAX, the date functions (DATE, TODAY, DAYS360, and simple difference in days), and especially IF, AND, OR, COUNTIF, SUMIF, and AVERAGEIF.


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



Study guide for Quiz 9, to be given May 6, 2011

The May 6 quiz will be an on-paper quiz.

There will be an Excel spreadsheet problem, which may involve any of the topics covered so far.

There will be some fill-in-the-blanks mail merge and Linux/Unix file permissions.

On the latter topic, you will expected to know the meaning of the symbols  d , r , w , x , and  -  in the output when you type  ls -l  or  ls -la  on a Unix/Linux system.

Regarding mail merge, there will probably be a few fill-in-the-blanks and/or multiple-choice questions on matters you should be familiar with if you've used mail merge a few times.

There will probably be some questions about Excel's VLookup function. The questions may include fill-in-the-blanks and/or multiple choice questions and/or a problem in which you are given a picture of a spreadsheet and asked to write an appropriate formula to go into some specified cell.


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



Study guide for Final Exam, to be given May 13, 2011

The final exam will be given on Friday, May3, at our usual class time, in B-131.

The final exam will be similar to the quizzes, only longer. It will cover all the material covered on all the quizzes, plus mail merge, plus various matters covered in previous quiz study guides though not on the actual quizzes themselves.

To prepare, review all your past quizzes and review everything else you were asked to review in all the quiz study guides.


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

D. Nixon: CS 12 > Quizzes & Exam