Excel 101

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.

Rubric

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