| "Design Your Own Spreadsheet" | ||||
| Project Grading Sheet | ||||
| Directions: Create your own spreadsheet using the skills you have learned in this unit. | ||||
| Skill | Description | Possible Points | Student Points | Comments (Explain why this is the score received for each item.) |
| Topic Choice Write spreadsheet topic here: | Is the idea approprate for a spreadsheet and is it a real-world example? Very Appropriate=10 Somewhat Appropriate=7 Not really a good use=5 Doesn't work for a spreadsheet=0 | 10 | ||
| Use of formulas - Have at least 3 different types! Circle the ones you used below: SUM AVG MIN MAX IF COUNT + - * / Other _________ | Must have 3 different formula types used correctly to get 30 points! 1 correct formula= 10 pts 2 correct formulas=20 pts 3 correct formulas=30 pts | 30 | ||
| Use of appropriate formatting | Note: formats must be appropriate to spreadsheet. | 20 | ||
| Circle any you used: | 1 format skill = 5 pts | |||
| Column Width, Bold, Centering, Dollar Signs, Font types, Color, Italics, Shading, Underline, Alignment, Row Height, Changing Decimal Places, Other Choice _________________ | 2 skills = 10 points | |||
| 3 skills = 15 points | ||||
| 4 skills = 20 points | ||||
| Must have 4 skills to get the full 20 points! | ||||
| Layout -- Is your spreadsheet easy to understand? Totals in correct places, Appropriate formatting, Neat and with title | Is the spreadsheet easy to understand? Totals appear in logical places so that I can easily tell what each total means=5 pts Formatting choices make the spreadsheet easy to read=3 pts Spreadsheet is neat & organized with a title at the top=2 pts | 10 | ||
| Graph of Data-Choose some of your data to make a graph. | Does the graph make sense? 5 pts Is the type of graph chosen appropriate for the data graphed? 5 pts | 10 | ||
| What does the graph tell us? (Answer below and be specific-draw conclusions.) | Clear answer = 10 points Somewhat clear =7 points Vague= 3 points No answer=0 points | 10 | ||
| Header w/Name & Login Code-Right Aligned | Use Header Function | 2 | ||
| Printout w/Formulas | Must be 1 page only | 3 | ||
| Printout w/Values | Must be 1 page only | 3 | ||
| Graph Printout | Must be 1 page only | 2 | ||
| Total Points | 100 | |||