Quiz 3 Answer key : 198:110 Intro to Computers Summer 2007

Part A

1. Excel 2. AppleWorks 3. Appleworks 4. FALSE 5. FALSE 6. TRUE

Part B

1. FALSE 2. A2:E4 3. B 4. D

Part C

1. = D7+D8+D9+D10

2. = MAX(C7:C10) 

3. = C7*$E$2 + D7*$E$3          (give only 1pt if they did not use $)

4. = COUNTIF(F7:F10,"=Y") (give only 1pt if they forget the "")  

5.  Chicago

Part D

1. San Diego 1769 1256951 Sanders CA 324.3 2.9 (only give 2pts if they did not write whole record out)

2. New York, San Diego, Philadelphia (1 point each. If they have all three but also some extra, give only 2pts.) 

3.

A] use New Request command (2pts)

B] State: PA; Budget: > 3 ; Founded: >1700  (only give 1pt if they got 1 or 2 of the third parts)

No others should be filled out (1pt off for each other filled out )

Part E

1.

I. STEP needed in FOR instead of BY
II. END IF not allowed because this is a single-line IF statement
III. NEXT Counter missing

2.

I. "DONE" must have quotes around it
II. Should be CASE ELSE not just ELSE
III. LOOP should end the loop, not NEXT 

Part F

1.

It ends with 200
 

(4 points for each line if perfect.  Only 1 pt if words there but number wrong.)

2.

Red
Blue
17
Purple

(1 points for each line if perfect; 1 point off for each extra line)

3.

One answer is 25
Another is 2


(2 pts per line if perfect; 1 point if words right but number wrong.)

4.

50
20
160
6

(1 pt for each line correct. 1 point off for each extra line.)


Part G

(here is one possible program)

LET AlanCount=0
LET BobCount=0
LET CarlCount=0
FOR Day = 1 TO 30
INPUT PROMPT "Who ghave out tickets this day?": Officer$
INPUT PROMPT "How many tickets did they issue? ": NumTickets
SELECT CASE Officer$
CASE "Alan
LET AlanCount = AlanCount + NumTickets
CASE "Bob"
LET BobCount = BobCount + NumTickets
CASE "Carl"
LET CarlCount = CarlCount + NumTickets
CASE ELSE
END SELECT
NEXT Day
LET TotalTickets = AlanCount+BobCount+CarlCount

PRINT "Alan gave out "; AlanCount; " tickets in June."
PRINT "Bob gave out "; BobCount; " tickets in June."
PRINT "Carl gave out "; CarlCount; " tickets in June."
PRINT "In June, the whole police force gave out ";TotalTicket; " tickets."

IF TotalTickets >=500 THEN PRINT "Quota reached." ELSE PRINT "Try harder."
END
 
12 Points if perfect. 10,11 points if minor syntax or logic errors. 6-9 if one significant piece missing or wrong. 3-5 if one or two parts right or close (INPUTs, PRINT, IF, structure of FOR, structure of SELECT CASE, END ) 0-2 if very little right, or if code uses little real BASIC.