Students learn how to create a spreadsheet with this module;
they will open a new spreadsheet, enter text, numbers, and formulas in cells.
They will come to understand the different between a column and a row, identify
cell addresses, adjust column sizes, surround sections with borders, center
text within a cell and across cells by merging cells, and learn how to execute
copy, paste, and fill in commands.
Open the spreadsheet program by double-clicking on the appropriate
icon on the desk top, or find the program through the program menu.
Save the file as Find the Rule by clicking on "File",
then "Save As". Type "Find the Rule" in the "File
Name" section, then click on "Save."
Locate and ensure that the cursor is in the cell address
"A1".
Type "Find the Rule" in cell address "A1".
Center the text in cell "A1" across cells A1
through I1"
Look at the example and
type in the information in columns "A" and "B", and in
row "3". You will enter formulas in columns "C" throug
"I".
In cell address "C5" enter the appropriate formula
to get the desired result by following the rule as listed in cell "A5",
i.e. Add 2. Continue the formula for cell addresses "D5" through
"I5"
Repeat the process above for the rest of the spreadsheet,
entering formulas to get the desired result by following the rules as listed
in rows 8, 11, 14, 17, 20, and 23.
Looking at the example,
place borders around the appropriate cells.
Upon completion of the spreadsheet the teacher will provide you with new
data for the "Start" column. You are to insert the new data and your spreadsheet
should calculate new results that replicates the new results in the
example spreadsheet.
Computer Lab West 