K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators 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 Lesson Plan - Lemonade Stand Expenses

Students Create an Lemonade Stand Expense Budget

 

Students create an expense budget for a lemonade stand with 6 days of expenses.

Students use the random number generator to get their item expenses for each day.

 

Students enter their data in the spreadsheet for each day. Students use a formula (sum) to calculate the total expenses for each day.

Grades 4 +

 

 

 

 

Lemonade Stand Expenses Finished Example

Download: excel-lemonade-stand-expenses-finished-example.xlsx

 

 

Lemonade Stand

 

 

Random Number Generator for the Lemonade Stand Sales and Expenses

Students can use this online random number generator to help them create the numeric values for their spreadsheet. Simply click the "Get Numbers Now!" button to generate random sales and expense numbers for the lemonade stand.

Lemonade Stand Random Number Generator

 

 

Excel - Lemonade Stand Instructions:

Basic guide to creating the lemonade stand expenses spreadsheet. The basic excel skills used here are entering data in cells, using "merge and center" for the title, "autofill" for the days of the week, and "autosum" to calculate the total expenses.

Download: excel-lemonade-stand-instructions.pdf

 

 

Excel Lemonade Stand Instructions

 

Popular for iPads - iWork

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
    Chart
  • Excel Pie Chart
  • NewsPaper
    Template
  • Newspaper Template