1. Topic-
Excel Party Budget
 
2. Content-
Excel, spreadsheets, cells, rows, columns, labels, pie chart, values
 
3. Goals: Aims/Outcomes-
1.Demonstrate an understanding of the spreadsheet as a tool to record, organize, and graph information.

2.Identify and explain terms and concepts related to spreadsheets (i.e., cell, column, row, values, labels, chart, graph).

3. Use menu/tool bar functions in a word processing program (i.e., font size/style, line spacing, margins) to format, edit, and print a document.
 
4. Objectives-
1.Learn how to use the sum function to calculate a total from a column of values and to input a simple formula for subtracting expenses in a budget.

Learn how to create a pie chart with a budget

 
5. Materials and Aids-
Excel
 
6. Procedures/Methods-

A. Introduction-

1. Review images of charts and budgets and the many options that Excel has to create these.
2. Review of toolbar, columns, rows, cells
 

B. Development-

1. Demonstration of creating a list complete with using the formula functions.
2. Demonstrate how to create a pie chart with the information provided from the list
 

C. Practice-

1.Enter your chart title in Cell C1.
2.Click in cell C1 and drag mouse to cell H1. In the Home tab, alignment group, find and apply "Merge and Center: to the title.
3.With the title still selected, on the Home tab, Font group, apply a new font color, for size and font style.
4.Enter " Allowance"¯ in cell A3. Enter ""¯Shopping Expenses"¯ in cell A5.
5.Enter Items to purchase beginning in cell A6 ending in cell A10. Enter 200.00 in cell B3. Enter cost. Values beginning in cell B6 ending in cell B10.
6.Type "Total Expenses"¯ in cell A12. Type "Money Left Over"¯ in cell A14.
7.Click in cell B12 and then click the Formulas tab on the menu bar. Find and click " AutoSum"¯ in the Function Library group and then press enter to get the expenses total.
8.Click in cell B14 and enter the formula =B3-B12. Press Enter.
9.Click in B3 and drag the mouse down to cell B14. On the Home tab, number group, find and click the $ sign to convert the number values to currency.
10.Click in cell A6 and drag mouse down to select all the labels down to cell A10. Continue to drag across to select the adjacent numerical values in Column B.
11.Create a pie chart. Go to Insert tab > Chart group > Pie > 3D Pie.
12.Click on the chart. Go to Design tab > Chart layouts group > choose a chart layout that will produce labels and number values in the pie pieces.
13.Add a Chart Title. Click on the chart. Go to layout tab > labels group > choose chart title "Above Chart"¯. Enter your chart's title.
14.Click once on the chart to select it. Click a second time on an individual chart piece to select it for a color change. Right click on the selected chart piece and choose Format Data Point. Go to Fill > Solid Fill > Color. Choose a color for your chart piece. Repeat process for each chart piece.
 

Accommodations (Differentiated Instruction)-

Students who may need accommodations may have additional time for their assignment, as well as more one on one time with the teacher.
 

F. Checking for understanding-

1. Checking assignment as they are working
2. Following instructions
 

G. Closure-

Students should have the list and chart complete

 
7. Evaluation-
1. Students should have the list and chart complete
2. Students should know have an understanding of formulas, charts, etc.
3. Students should now understand how to use the sum function to calculate a total from a column of values and to input a simple formula for subtracting expenses in a budget.
 

This Lesson Plan is available at (www.teacherjet.com)