MS (BUS) Targeted Standards: Strand 4: Communication Topic 3: Written Communication, b: Business Messages. Standard 1: Prepare clear, complete, concise, correct, and courteous written messages for personal and professional uses.
BUS-L2.04.T3b.S1.14 Prepare charts and graphs.
Student Learning Targets for Grades 7/8 Computer Apps:
Skills (Performance) Targets
I can use the sum formula as needed. (7th grade)
I can use the sum, average, and if formulas as needed. (8th grade)
I can properly sort information in a spreadsheet. (8th grade)
Product Targets
I can prepare charts and graphs that are visually appealing (title, aligned columns, merged cells, proper formatting of cells and information in cells).
Proficiency Scale for Grade 7 Computer Apps:
Score
Description
Sample Activity
4.0
In addition to Score 3.0, the student demonstrates in-depth inferences and applications regarding more complex material that go beyond end of instruction expectations.
-
3.5
In addition to Score 3.0 performance, the student demonstrates in-depth inferences and applications regarding the more complex content with partial success.
3.0
“The Standard.” The student demonstrates no major errors or omissions regarding any of the information and processes that were end of instruction expectations.
The student can:
create and format pie and bar graphs.
prepare charts and graphs that are visually appealing (title, aligned columns, merged cells, proper formatting of cells and information in the cells).
use sum formula as needed.
-
2.5
The student demonstrates no major errors or omissions regarding the simpler details and processes (Score 2.0 content) and partial knowledge of the more complex ideas and processes (Score 3.0 content).
2.0
The student demonstrates no major errors or omissions regarding the simpler details and processes but exhibits major errors or omissions regarding the more complex ideas and processes (Score 3.0 content).
The student can:
prepare basic charts and graphs with minimal formatting.
have difficulty using the sum formula.
create incomplete pie and bar graphs.
-
1.5
The student demonstrates partial knowledge of the simpler details and processes (Score 2.0 content) but exhibits major errors or omissions regarding the more complex ideas and procedures (Score 3.0 content).
1.0
With help, the student demonstrates a partial understanding of some of the simpler details and processes (Score 2.0 content) and some of the more complex ideas and processes (Score 3.0 content).
-
0.5
With help, the student demonstrates a partial understanding of some of the simpler details and processes (Score 2.0 content) but not the more complex ideas and processes (Score 3.0 content).
Proficiency Scale for Grade 8 Computer Apps:
Score
Description
Sample Activity
4.0
In addition to Score 3.0, the student demonstrates in-depth inferences and applications regarding more complex material that go beyond end of instruction expectations.
-
3.5
In addition to Score 3.0 performance, the student demonstrates in-depth inferences and applications regarding the more complex content with partial success.
3.0
“The Standard.” The student demonstrates no major errors or omissions regarding any of the information and processes that were end of instruction expectations.
The student can:
prepare charts and graphs that are visually appealing (title, aligned columns, merged cells, proper formatting of cells and information in the cells.
use sum, average, and if formulas as needed.
create and format pie and bar graphs.
properly sort information in a spreadsheet.
-
2.5
The student demonstrates no major errors or omissions regarding the simpler details and processes (Score 2.0 content) and partial knowledge of the more complex ideas and processes (Score 3.0 content).
2.0
The student demonstrates no major errors or omissions regarding the simpler details and processes but exhibits major errors or omissions regarding the more complex ideas and processes (Score 3.0 content).
The student can:
prepare basic charts and graphs with minimal formatting.
have difficulty using the sum, average, and if formulas.
create incomplete pie and bar graphs.
cannot properly sort information in a spreadsheet.
-
1.5
The student demonstrates partial knowledge of the simpler details and processes (Score 2.0 content) but exhibits major errors or omissions regarding the more complex ideas and procedures (Score 3.0 content).
1.0
With help, the student demonstrates a partial understanding of some of the simpler details and processes (Score 2.0 content) and some of the more complex ideas and processes (Score 3.0 content).
-
0.5
With help, the student demonstrates a partial understanding of some of the simpler details and processes (Score 2.0 content) but not the more complex ideas and processes (Score 3.0 content).