|
Student Grade Level
|
Skill
|
Response
|
|
6-8
|
4.1 Interpret and communicate information in an existing spreadsheet |
|
- Understanding of
the concept of a spreadsheet
|
|
- Understanding of how to use a spreadsheet to make calculations
|
|
|
7-8
|
4.2 Enter data in an existing spreadsheet |
|
|
|
|
- Use the entry (formula) bar for data entry and editing
|
|
- Print a spreadsheet (with no text formatting, etc.)
|
|
- Manipulate data within
an existing spreadsheet in order to solve a
problem
|
|
|
9-12
|
4.3 Create a spreadsheet with rows, columns, headings |
|
|
9-12
|
4.4 Create/copy formulas and functions to perform calculations |
|
- Understanding of the three basic types of cells (label, value, and formula)
|
|
- Format a cell or range of cells to currency, date, time,
percentage, or fixed decimal
|
|
- Protect a cell or range of cells
|
|
- Create spreadsheet with labels and values
|
|
- Create a formula using a formula indicator symbol, cell references, and
operations symbols (=+-*/)
|
|
- Create a formula using functions (SUM and AVERAGE) and a range
of
cells
|
|
- Awareness of other functions available
|
|
- Awareness of look-up tables and their use
|
|
- Copy values using fill
down and fill across
|
|
- Copy formulas using fill down and fill across
|
|
- Awareness of relative and absolute value as it relates to copying formulas
|
|
- Change the appearance of a spreadsheet by inserting columns and
rows
|
|
- Change the appearance of a spreadsheet using column width and row height
|
|
- Change the appearance of a spreadsheet using gridlines, headers, and
footers
|
|
- Change the appearance of a spreadsheet using text features for label
cells
|
|
- Change the appearance of a spreadsheet by splitting or merging cells
|
|
|
9-12
|
4.5 Create a graph from spreadsheet
data
|
|
- Knowledge of the three basic types of graphs (bar, pie, line) and their
uses
|
|
- Using previously created data, select a range of data and choose
the
appropriate graph
|
|
- Change and refine a graph's appearance to include headers, legend,
labels,
series, axes, color, etc.
|
|
|
|
|
|
9-12
|
4.6 Insert a spreadsheet into
a word processing document
|
|
- Open a word processing document and insert an existing spreadsheet
into
the document
|
|
- Print a word processing document with an inserted spreadsheet
|
|
- Insert a pre-existing graph into a word processing document
|
|
- Insert headers and footers
|
|
|
6
|
4.7 Knowledge of terms such
as spreadsheet, cell, data entry bar, formula, function, sort/arrange,
mail merge |
|
|
9-12
|
5.5 Insert spreadsheet cell
values into word processing document |
|
- Create a word processing
document with inserted spreadsheet cell values
|
|
- Print a merged word processing/spreadsheet
document
|
|