iRubric: Travel Project, Part 3 - Excel spreadsheet rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...

Travel Project, Part 3 - Excel spreadsheet

Rubric Code: K5W42A

By dandeschaine

Ready to use

Public Rubric

Subject: Computers

Type: Assignment

Grade Levels: Undergraduate

Travel Project Spreadsheet
	Poor 0 pts	Fair 0.5 pts	Good 1 pts
Sheets 1 & 2:
Row 1 title 1 pts vacation destination	Poor	Fair	Good
Row 2 title 1 pts Week in March/October	Poor	Fair	Good
Row 1 & 2 titles 1 pts - larger font, bold	Poor	Fair	Good
Row 1 & 2 titles 1 pts - merge & center over data	Poor	Fair	Good
Row 4 (column headings) 1 pts - add bold	Poor	Fair	Good
Column A 1 pts - add contact names	Poor	Fair	Good
Column B 1 pts - enter number of travelers	Poor	Fair	Good
Column C 1 pts - enter insurance cost	Poor	Fair	Good
Column E 1 pts - enter down payment	Poor	Fair	Good
Column D - calculate Subtotal 2 pts =B5**3200+C5	Poor	Fair	Good
Column F - calculate Amount Due 2 pts =D5-E5	Poor	Fair	Good
Row 12 - use AutoSum 2 pts to total columns: = sum(b5:b10)	Poor	Fair	Good
Row 13 - Use Average 2 pts to average columns: =average(b5:b10)	Poor	Fair	Good
Row 14 2 pts Use Min to find minimum of columns: =min(b5:b10)	Poor	Fair	Good
Row 15 2 pts Use Max to find maximum of columns: =max(b5:b10)	Poor	Fair	Good
B5:F15 2 pts Apply Comma format with 0 dec places	Poor	Fair	Good
Chart:
Created a 3-D bar chart 1 pts	Poor	Fair	Good
Used Name & Amount Due Columns from 1 pts	Poor	Fair	Good
Moved chart to separate sheet 1 pts	Poor	Fair	Good
Added a chart title 1 pts	Poor	Fair	Good
Used online file name convention 2 pts	Poor	Fair	Good
Spell checked and proofread data 1 pts	Poor	Fair	Good