K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Excel - Lunch Expenses for Two

Create an Expense Chart showing the Cost of Lunch for Two

Instructions: Students have one gift card for $15.00 for the school cafeteria called the "Munch Box". Students choose lunch items from the Munch Box Menu provided.

Students select enough items to get food and drinks for themselves and one very hungry and thirsty friend for lunch. Students purchase as many items as they can without going over budget. Students create an expense chart showing the costs of their purchases.

Grade 3+

 

 

Download: excel-munch-box-lunch-menu.pdf

 

Download: excel-lunch-expenses-spreadsheet-for-two-finished-example.xlsx

 

 

Download: student-instructions-lunch-expenses-for-two.pdf

 

Download: rubric-for-spreadsheet-with-chart.pdf

 

 

Munch Box Lunch Menu Example:

Explain the scenario to the students and make this menu available for them to view. Students should select several items from the menu, and enter their choices and the prices into their spreadsheet.

Excel - Munch Box Lunch Menu

 

Students should already have previous experience entering data, and creating basic charts.

This exercise requires of formatting the numbers (values) with the dollar sign value (currency) and using autosum to total the costs.

 

1) Student enter their item names in column A and the costs in column B.

2) Students select all of the number values and apply $ dollar sign formatting.

Dollar Sign Formatting

3) Students write "Total Cost:" under the last items in column A, then use the "AutoSum" formatting

button to calculate the total amount in column B

Autosum.

4) Students create a column chart by selecting the food items in column A and the expenses in Column B.


Vocabulary words: Columns, Rows, Labels, Values, Cells, Autosum, Spreadsheet.

 

 

Munch Box Lunch Expenses Finished Example:

Excel Munch Box Lunch Expenses Chart

 

 

Student Instructions - Lunch Expenses for Two

Student Instructions - Excel L

 

 

Excel Spreadsheet Rubric for Grading Assignments:

Spreadsheet Rubric

 

 

Make a Chart in Excel - A Two Minute Tutorial

This video shows you how to make a chart like the one in this assignment. It shows you how to increase the font size, widen a column, merge and center the title, format numbers with the dollar sign, total a column of numbers with autosum, create the chart, and change the colors of the chart column bars.

This video is available in HD.

 

 

 

More Ideas
For PC's and Microsoft Office

  • Excel
    Bar Chart
  • Excel Bar Chart
  • Thanksgiving
    Copy and Paste
  • Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing
  • Green Screen Photo Editing
  • Computer Lab
    Rules
  • Computer Lab Rules Essentials
  • California Regions
    Brochure
  • California Regions Brochure
  • Amazing Animals
    PowerPoint
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
    Animation
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
    Practice
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
    Template
  • Newspaper Template