K5 Computer Lab Lesson Plans

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


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.




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

    Computer Lab Rules Essentials
  • California Regions

    California Regions Brochure
  • Amazing Animals

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"

    I Can Float Animation
  • Copy and Paste

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper

    Newspaper Template