Today you are going to learn to make a budget on one excel spreed sheet. I suggest you open excel and build your spread sheet with the tutorials. Each tutorial is an example of a specific sheet. The first video tutorial demonstrates how to create a materials estimate sheet. The second video tutorial demonstrates how to create a labor estimate sheet. The third tutorial demonstrates how to create a totals page collecting information from your materials and labor sheets to create a totals sheet. This is the link to the three short videos for you to watch inside the tools tab.
Turn in the sheet you made in the assignment tab on black board: Excel 101 spreadsheet to earn your grade.
Grading rubric
Excel 101 assignment Rubric
| Description | Ignored=0 | attempted =5 | 50% done=10 | Completed= 20 | Total 100 points |
|---|---|---|---|---|---|
| Header on each page | event name on each page | PM name on each page | tab labeled | ||
| Totals sheet | information organized and labeled | formulas are correct and work | totals transferred from other pages | ||
| Sheet materials | information organized and labeled | formulas are correct and work | tab labeled | ||
| Sheet labor | information organized and labeled | formulas are correct and work | tab labeled | ||
| Excel sheet | PDF turned in | Completed sheet turned in late | Completed sheet turned in on time |
Watch Ted TAlk 2. Write an essay using the rubric provided with TED TALK 2.