Test Items for Teaching with Technology

A cell can contain
a. values
b. labels
c. formulae
d. all of the above
(d)

Number formats can include
a. powers
b. fractions
c. fixed
d. bold
(c)

Which of the following formulae would add the contents of cells F7 through  F10?
a. ADD (F7...F10)
b. SUM (F7...F10)
c. TOTAL (F7...F10)
d. SUM (F7 + F10)
(b)

Which of the following tasks would be most appropriately done with a spreadsheet?
a. keeping a science lab journal
b. recording data from science experiments
c. keeping track of science lab equipment
d. creating a circuit diagram
(b)

In tracking the stock market, a spreadsheet is helpful because it can
a. provide What If  scenarios
b. make accurate predications
c. complete stock transactions
d. identify stocks that will split
(a)

In a gradebook created on a spreadsheet you cannot
a. alphabetize student names
b. write a progress report to parents 
c. rank order grades
d. assign grades
(b)

Teachers can use spreadsheets for
a. teaching ESL
b. replacing calculators
c. creating math worksheets
d. math remediation
(b)

What kinds of decisions can students make when aided by a spreadsheet?
a. which movie is best
b. the most popular student
c. the best kind of car to buy
d. the car with the best gas mileage
(d)

A spreadsheet program can perform the following:
a. sorting
b. calculating
c. printing reports
d. all of the above
(d)

Which of the following can you do in a spreadsheet?
a. Alphabetize words
b. Sort numbers from high-to-low
c. Apply formulae
d. All of the above
(d)

Which of the following is the formula for adding cell C5 to C24?
a. @SUM(C5...C24)
b. Add (C5...C24)
c. +(C5...C24)  
d. @+(C5...C24)
(a)

Describe at least three ways you could use a spreadsheet program with your students (list grade level/subject matter).

Convince a fellow teacher that he/she should use a spreadsheet program.

Suppose the following data is in a spreadsheet:
         A               B               C              D
1       45              55              78
What formula/function should be placed in cell D1 to average cells A1 through C1?
(=AVERAGE(A1..C1))
What formula/function should be placed in cell D1 to add cells A1 through C1?
(=SUM(A1..C1))
Suppose cell D1 contains the formula =A1+B1. What number would actually appear in cell D1?
(100)

Top of page