|
|
|
|
spreadsheet
|
A
spreadsheet was originally designed to be the computerized equivalent
of an accountant’s ledger. However, spreadsheets have developed
into powerful tools that organize, manage, and calculate numerical
data for many different applications. A spreadsheet uses numbers
much like a word processor uses words. Where a word processor
enables the author to enter and edit words and paragraphs until
the composition is just right, a spreadsheet allows the user to
manipulate numbers and formulas to analyze numerical models. In
a school setting, spreadsheets are often used as grade books,
but they can also used by sports teams, or math or science teachers.
Depending upon the user's needs, spreadsheets can be simple or
complex.
Click
here to begin this module.
home
| course
calendar | glossary
| lab hours
| how
to
|
|
Spreadsheet
These exercises
explains the use of a spreadsheet document or frame to organize text and numbers
into rows and columns. Spreadsheets are the only environment in which you can
chart data. This module includes a:
Practice
Application: Learn these terms:
- Cell - the intersection
of a row and a column. Each cell stores data and formatting characteristics.
- Label - Alphabetic or
alphanumeric data the describes the values in various cells.
- Value - number used in
calculation
- Formula - a mathematical
expression developed yourself.
- Function - a small program
within the spreadsheet environment. You give this program values contained
in cells to achieve a calculation.
If you are having problems, use the
tutorials on the right, submit questions to the TeachNet 371 Questions folder,
or contact your instructor for a one-on-one session.
Below are the basic spreadsheet (SS)
skills needed.
Spreadsheet (SS) Skills needed for this module:
|
 |
Locate
and open AppleWorks spreadsheet document. |
|
Work
with formulas and functions and use fill right and fill down to duplicate
information. |
| |
Enter data, format
cells, edit cell information. |
|
Select, copy and
paste, duplicate, and move data. |
|
Chart data |
|
Use the library
clippings |
| |
Modify cell size,
move rows and columns, add/delete rows and columns |
|
Add, delete, and
edit fields |
| |
Know and use you
email address |
|
Sort records. |
When you feel competent in each area,
do the required application
and submit it to the Dropbox.
Be sure to check
the extensions section in case you plan on doing an
extra project.
Your grade
will be based on your successful completion of the above. Click here to read
the details in general evaluation.
Evaluation
| Practice Application | Application
| Extensions
