School

University of WaterlooDepartment

Computer ScienceCourse Code

CS100Professor

Frank TompaStudy Guide

FinalThis

**preview**shows pages 1-3. to view the full**14 pages of the document.**Review Package

Fall 2009

Overview

This review package was created by the tutors of CS 100. It is based on all the course material, some of

which may have been used in previous assignments. Make sure to study the material before you start on

this package. Also, be sure to note that this package is not intended to be a sample or practice exam, but to

supplement your own studying. We strongly encourage you to try to complete this package without any

outside help.

Excel Review

Explain the function of VLOOKUP and its four parameters.

VLOOKUP:

PARAMETERS:

1.

2.

3.

4.

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

2

Spreadsheets Exercise

Mr. Anderson wants you to create a spreadsheet so that he can track his students’ performance throughout

the semester. Look at the Review Worksheet spreadsheet at the end of this question.

You are given:

1) First Year Microeconomics: A table containing students’ marks for a midterm and final test.

2) Class Components: A table containing total marks available and weights for each class

component.

Complete the following chart using the information provided here:

(Remember to use flexible formulas, and name where appropriate.)

1) Top Mark: compute the value of the greatest mark final mark

2) Average Mark: compute the average final mark of the class

Format the cells within the Grade Calculations Table appropriately:

1) Midterm Test: return the students’ weighted marks

2) Final Test: return the students’ weighted marks

3) Final Mark: the final mark is the total of the midterm and final test.

4) Awards: determine what monetary award the student earned, if any. Awards go to the top three

students.

5) Course Credit: return “yes” if the student passed the course and “no” if the student failed the

course. A pass is considered a mark of 50% or greater in the course.

6) Averages: return the class average for all course components.

7) Party? : Count the number of final marks that are greater than or equal to 90. If there are 5

students who have a mark greater than or equal to 90, return “PARTY!” if not return “Study

More”.

Only pages 1-3 are available for preview. Some parts have been intentionally blurred.

3

In the spaces provided record what functions/formulas you would use for each cell.

B3

B4

B5

D5

B9

C9

D9

E9

B22

C22

In the spaces provided record any named cells, tables, ranges used.

Name

Range

###### You're Reading a Preview

Unlock to view full version