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.
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.
|Description||Ignored=0||idea attempted=5||50% complete= 10||100%=20|
|Headers on all sheets||project name||PM name||Tab labeled|
|labor sheets||each page organized and labeled||formulas are correct||tab labeled|
|Materials sheets||each page organized and labeled||formulas are correct||tab labeled|
|Totals sheet||page is organized and labeled||formulas are correct||all totals transferred to totals page|
|Turned in||turned in as a pdf.||turned in 1 week late||turned in 2 days late||excel turned in on time|