TEMPLATE
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. Make a budget worksheet form. Fill in as much as you can.
3. Fill in a time sheet at this link. Use your name rather than a company. Make as many changes as you can.
4. Create this very simple spreadsheet _ favorite animals. Use a partner if you want.
Watch and recreate the spreadsheet.
1. It will be good if you pick a partner for upcoming assignments
2. Make a budget worksheet form. Fill in as much as you can.
Watch and recreate the spreadsheet.
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:
Complete 1-4
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.
0_No work attempted
more info below
steve read/watch use
Google Sheets Tutorial - Designed for Beginners
good one??????
Watch until 8:47. Stop and do what the presenter did.
Add formats as currency.
About 10:00
Watch until about 12:56. Do the SUM function
Do the average function which ends at 14:24
Skip to 17:00 if you want to.
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 and next class:
1. Vocabulary in Notes: Database
2. Label a spreadsheet
3.Write meaning of these terms from Quizlet https://quizlet.com/878645/spreadsheet-vocabulary-flash-cards/
Scroll down to see all terms at once:
Active cell, Alignment, Autosum, Cell, Column,
Format, Formula, Freeze, Function, Label, Range,
Row, Sort, Spreadsheet, Value, Workbook,
Worksheet
4. Create a schedule in Google Sheets
Active cell, Alignment, Autosum, Cell, Column,
Format, Formula, Freeze, Function, Label, Range,
Row, Sort, Spreadsheet, Value, Workbook,
Worksheet
4. Create a schedule in Google Sheets
https://www.youtube.com/watch?v=3qiOVJbdzPo
https://www.youtube.com/watch?v=V7IFY8HgdnI
5. Following class
spreadsheet
more complex and thorough
https://www.youtube.com/watch?v=TzblMvTNWEg
Ultimate guide to Google Sheets. Good for following written text.
Sketch a blank spreadsheet
Spreadsheet terms
•
Cell: A single data point or element in a spreadsheet.
•
Column: A vertical set of cells.
•
Row: A horizontal set of cells.
•
Range: A selection of cells extending across a row, column, or both.
•
Function: A built-in operation from the spreadsheet app, which can be used to
calculate cell, row, column, or range values, manipulate data, and more.
•
Formula: The combination of functions, cells, rows, columns, and ranges used to
obtain a specific result.
•
Worksheet (Sheet): The named sets of rows and columns making up your
spreadsheet; one spreadsheet can have multiple sheets
•
Spreadsheet: The entire document containing your worksheets
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)
Today's Assignment directions:
Follow the steps on your handout and this link. Create your own order form or copy this one on the handout.
https://docs.google.com/spreadsheets/d/1eZ45ob4U1cGKztlJS7q2fKJTL8rBJgNucnkwSu_gqOA/edit?usp=sharing
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.
0_No work attempted
