Computer Science 152 – Spring 2003

03/24/03                 Midterm Exam #2                  Test Form A

 

Name:

 

Instructions:

                Answer all questions except the hands-on computer tasks on the answer sheet provided.

                Hand in TEST, Answer Sheet, and  Disk, each with your name on it.

                Remember to put the letter of your test form on your answer sheet.

 

Completion (3 points each)

 

  1. In many programs, including Microsoft Word, Excel, and PowerPoint, it is possible to put some key information at the bottom of each page below the main text. This ________ is just above the bottom margin, and may contain the title, author, page number, date, etc.

 

  1. A(n) ________ is an opening where a circuit board (or “card”) can be inserted into the main circuit board (the “motherboard”) of the system unit. This makes it possible to upgrade or add capabilities to a computer.

 

  1. Information is transferred inside a computer on a ________, for example from input to memory, memory to the CPU etc. The size of this determines how many  bits of data can be transmitted  at any one time, thus affecting the speed of the computer.

 

  1. In PowerPoint, you can edit the ________ in order to change every slide (except the title slide). This could be done to change the background shapes or various other details.

 

  1. In starting to create a presentation in PowerPoint, using ________ provides you with format – background colors, etc, but  no content or content suggestions.

 

 

Multiple Choice (3 points each)

 

  1. As you are typing in Microsoft Word, how do you know that you may have a spelling error?

A)     You can’t, you must run the spell checker using Tools/Spelling and Grammar to see spelling mistakes

B)      It is underlined with a green squiggly line.

C)      It is underlined with a red squiggly line.

D)      The word flashes, and a dialog box pops up asking you what word you were trying to type.

E)       None of the above.

 

  1. The microprocessor is located in the:

A)     hard disk

B)      system unit

C)      memory

D)      monitor

E)       keyboard

 

  1. Which of the following is NOT an input device?

A)     keyboard

B)      mouse

C)      scanner

D)      monitor

 

 

Short Answer (points as shown)

 

(5 points)

  1. How are letters represented as binary numbers inside a computer?

 

(6 points)

  1. What is “resolution”?  For a digital camera, how is it measured?  Why is it important?

 

 

Computer Tasks (points as shown)

 

(25 points)

  1. Using Microsoft PowerPoint, create a three slide presentation with the following contents:

 

Slide1: It’s Time to Care About Global Warming!

                Your name

 

Slide 2:   Global Warming is Everybody’s Problem !

                Changing Weather

                Rising Sea Levels

 

Slide 3:   Let’s Fix it!!

                Reduce Emissions

                                California Has Done It

                Write Your Congressperson

                Do It for Your Grandkids!

 

Plus:

Make sure you don’t misspell any words.

Make sure you save your document to a floppy disk. Make sure you hand in the disk with your text.

 

 

(40 points)

  1. Using Microsoft Word, create the document shown on the extra page, as described below:

a)       Change the left and right margins to 1.0 inches.

b)       The title is Bold, Centered, 18 point, Times New Roman

c)       The main text is Aligned Left, 10 point, Times New Roman.

d)       The start of paragraphs should be indented.

e)       The footnotes should be done using Microsoft Word’s footnote capabilities.

f)        The equation should be done with the equation editor. Then it should be centered.

g)       The page header and footer should be as illustrated – header containing “Filename and Path” and “Created On”; footer containing “Page x of y”. The values that you get will differ from those seen on the sample.

h)       The table should be done with Microsoft Word’s table capabilities. The formatting of the table does not have to be exactly the same as the printout, but it should be reasonably similar – I used Simple 1 auto-format.

i)         The table caption should be done with Microsoft Word’s caption capabilities.

j)         The “Teachers, do not have mercy …” sentence is bold.

k)       The word italics is in italics.

l)         The “several comments” listed are “bulletized”

m)      Put your name in place of the characters <your name here>. Underline your name.

 

Make sure you don’t misspell any words.

Make sure you save your document to a floppy disk. Print the document. Hand in the disk and the print out.

 


 

Test Exercise

 

My math teacher in whatever grade (8th?  10th?) would always tell us to always remember the quadratic formula, “in case somebody on the street stopped us and asked what it was”.[1] Nonetheless, I had to look it up for this exercise[2]. The idea is that if you want to find the roots of a quadratic polynomial with coefficients a, b, and c (in that order), then the formula is:

 

Table 1: Some Coefficients with Roots

a

b

c

Root 1

Root 2

1

2

1

-1

-1

2

8

-4

0.45

-4.45

 

Let’s now look at how this pans out with real numbers. Table 1 illustrates with a few values. Interestingly enough, the WWW site author for the page on which I found this had the following comment: Teachers, do not have mercy on students who do not remember the quadratic formula. In bold print and everything! (not just italics). Several comments are in order:

·         It is probably just my middle age memory that caused me to forget.

·         <YOUR NAME HERE> still remembers the quadratic formula.

·         The WWW page derives the formula, in case you are interested.

Well that’s enough for now, some people don’t type very fast!

 

 

 



[1] We knew he was joking.

[2] I found the formula at http://www.sosmath.com/algebra/factor/fac08/fac08.html