14) Use a spreadsheet program to create and format academic and business documents for the
purposes of tabulating and calculating numerical and/or textual data (e.g., statistics, historical
data, measurements), such as budget calculations, sales reports, lab data, and related analyses.
(Reading 1, 3, 4, 5, 7, 9; TN Writing 4, 6; TN Math N-Q, S-ID)
15) Craft documents using a spreadsheet program using features and methods such as:
a. Cells, columns, and rows
b. Formulas and functions
Approved April 10, 2015
Page 4
c. Copy, move, delete, and fill
d. Cell-value formats (numerical and text) and alignment
e. Column and row width/height, insert/delete, move
f. Printing to a selected printer
g. Saving with a file format that can be shared and/or transported
(TN Reading 3, 4, 5; TN Writing 4, 6; TN Math N-Q, S-ID)
16) Create new formulas to analyze data by calculating with, extracting from, presenting, and/or
summarizing, including:
a. Basic arithmetic calculations
b. Basic mathematic (e.g., SUM, AVG, MIN, MAX) and text (e.g., LEN, LEFT, RIGHT, MID)
functions
c. Copying formulas that include both relative and absolute cell references
d. Sorting in ascending/descending order
e. Filtering data to retrieve specific values
f. Basic conditional formatting (e.g., red for negative values)
(TN Reading 3, 4, 5; TN Writing 6; TN Math N-Q, S-ID)
17) Create and format for optimal clarity a variety of types of graphs and charts, including bar
charts, line charts, pie charts, and X-Y graphs, based on tabulated data. (TN Reading 3, 4, 7;
Writing 4, 5, 6; TN Math N-Q, S-ID)
18) Retrieve a spreadsheet template (from those installed with the program or from the Internet)
and customize it for a particular assignment approved by the instructor. For example, prepare a
“timecard” of one’s daily hours spent on a month-long job assignment. (TN Writing 6)
