Grade Rubric

Fast Food Fun

To earn a D you must complete the following:

To earn a C you must complete the following:

To earn a B you must complete the following:

To earn an A you must complete the following:

Target Objective 1

 

Manipulate a spreadsheet: enter and format data and use formulas and functions.

Level 1 Indicator

 

Entered most data correctly, some incorrect formatting, attempted to use formulas and functions

Level 2 Indicator

 

Entered all data correctly, was able to format data, attempted to use formulas and functions

Level 3 Indicator

 

Entered all data correctly, completed required formatting, used formulas and functions correctly

Level 4 Indicator

 

Entered all data correctly, completed required formatting, used formulas and functions correctly, used advanced formatting techniques to design spreadsheet

Target Objective 2

 

Create bar charts to analyze data

.

Level 1 Indicator

 

Created minimal charts lacking correct chart elements; incorrect data displayed

Level 2 Indicator

 

Created minimal charts lacking correct chart elements; correct data displayed

Level 3 Indicator

 

Created required charts swith correct elements including title, names of axes, legend, and data labels; correct data displayed

Level 4 Indicator

 

Created required charts swith correct elements including title, names of axes, legend, and data labels; correct data displayed; used advanced charting techniques to design charts beyond requirements

Target Objective 3

 

Create pie charts to analyze data

.

Level 1 Indicator

 

Created minimal charts lacking correct chart elements; incorrect data displayed

Level 2 Indicator

 

Created minimal charts lacking correct chart elements; correct data displayed

Level 3 Indicator

 

Created required charts swith correct elements including title, legend, and data labels; correct data displayed

Level 4 Indicator

 

Created required charts with correct elements including title, legend, and data labels; correct data displayed; used advanced charting techniques to design charts beyond requirements

Target Objective 4

 

Summarize findings using a word processor and incorporating data and charts from spreadsheet

.

Level 1 Indicator

 

Able to copy chart from spreadsheet; brief summary with few details; no attempt to draw conclusions about data; did not meet requirements for length; did not used correct format

Level 2 Indicator

 

Able to copy chart from spreadsheet; brief summary with few details; some attempt to draw conclusions about data; made some attempt to meet length and format requirements

Level 3 Indicator

 

Able to copy chart from spreadsheet; summary included required details; was able to meet length and format requirements

Level 4 Indicator

 

Able to copy chart from spreadsheet; detailed summary with additional information beyond required elements; met or exceeded length and format requirements