*Christopher I. Cobitz Ph.D.*

Spreadsheets
do math even if the student is not very good at arithmetic. But the student does need to understand some
algebra.

Although
the eight-grade test uses many scenarios, the important issue is the use of a
data set. Once a spreadsheet with data
set is produced it is a fruitful source of algebra activities.

Provide
the students with a spreadsheet containing random number for the data and
defined labels for the columns and rows.
An example would be to provide dummy data for student scores in a record
book. Be sure to designate certain
assignments in the grade book as tests, quizzes, or homework. Also on the last row provide the value of a
perfect score (for example on a given test the perfect score is 120). The spreadsheet only really needs to have
about 4 rows of dummy student scores.
(You could use the attached sheet)
Ask the students to calculate the best weighting of the assignments
types for each student’s grade. In a
sufficiently advanced math course, the students could be asked to figure the
percentages that would give the best scores for all involved.

This
activity will require the students to use relative and absolute cell
references, which are an expansion of the fundamental concepts of algebra. Be sure to check the formulas the students
to use to see that they actually are using symbolic references instead of
typing in the numbers that they are calculating.

Instead
of spending their time worrying about arithmetic errors the students can spend
their time goal seeking.

ã 1999 Christopher I. Cobitz Ph.D. Permission is granted for non-commercial use provided this copyright notice remains intact.