Topic E. Using a Spreadsheet
The illustrations in this Topic are from Excel, but all spreadsheets work similarly on the basic topics. Practice on whatever spreadsheet is available to you. Expect to have questions. Please allow time for that and make a place in your notebook to write those questions and the answers you find. And NEVER SPEND MORE THAN 5 MINUTES STUCK on something involving computer software. Instead, write down your question and ask it during the next class or office hours.
Objectives:
 Learn the details of the particular computer you’re using. Turn it on, find and open the program, open it.
 Basics:
 Enter data by typing it in.
 Enter patterned data efficiently (usually for the input values, or the xvalues)
 Enter a formula (usually for the output values, or the yvalues)
 Copy a formula into other cell.
 Print and/or save the worksheet.
 Copy a set of data from a table on the web into the spreadsheet.
 Relative cell locations versus absolute cell locations.
 Graphs
 Make a graph of a formula onto a rectangular coordinate system.
 Make a graph of two different formulas on the same axes, so that they can easily be compared.
 For a given input value, use the graph to estimate the output value.
 For a given output value, use the graph to estimate the input value that would give that output.
 Use the spreadsheet to look “more closely” at some particular portion of the graph.
 Optional: Changing the titles, labels, and scale along the axes.
 Formulas and functions.
 Know when and how to insert extra parentheses into formulas to make Excel compute correctly.
 Use these builtin functions: SQRT, AVERAGE, MAX, MIN, STDEV.
 Explore how the graphs of formulas change as the parameters change.
Section 1. Starting the program.
You’ll use the computer in the classroom and then a computer at home or in a computer lab to do your homework. Fill in this chart.
Classroom  Where I do homework  
Location


Login (Username / password)  
Name of the spreadsheet program 