Daily procedures
1. Get assignment sheet and write today's assignment
2.When I am giving instructions,
be in a seat
3. When I am giving instructions, electronic devices should be invisible
4. Do not interfere with instructions
or disrupt class
5. Turn in your assignment sheet at the end of class
Computers & electronic devices are for classwork only
Do Today:
1. It will be good if you pick a partner for upcoming assignments
2. Create an order form
1. It will be good if you pick a partner for upcoming assignments
2. Create an order form
Standards:
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)
Assignment directions:
Follow the steps on your handout and this link. Create your own order form or copy this one on the handout.
Follow the steps on your handout and this link. Create your own order form or copy this one on the handout.
Your grade:
4_advanced_93-100 points. A strong amount of work has been completed. All instructions & specifications met. A comprehensive and wide-ranging exploration of visual qualities, the representation of ideas, media experiments, and technical practice is demonstrated. The work reflects superior thought and imagination.
3_proficient_85-92 points. A reasonable amount of work has been completed. Most instructions and specifications met. The work illustrates satisfactory exploration of visual qualities, and the representation of ideas. There is satisfactory evidence of work on images, media experiments, and technical practice.
2_basic_75-84 points. A small amount of work has been completed. Some instructions and specifications met. The work illustrates some exploration of visual qualities, the representation of ideas. There is some evidence of work on images, media experiments and technical practice.
1_below basic_74 and below. A less than adequate amount of work has been completed. There is little evidence of work on images, media, and technical practice.
