×
Home Gr. Level Lesson Plans Page Generators Student Award Generators Opinion Paragraph Generators Narrative Paragraph Generators Informative Generators FlipBooks Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple / Mac Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Excel Lesson Plan
Lemonade Stand Profit or Loss

Assignment: Students create a profit or loss spreadsheet and chart for a lemonade stand with 6 days of sales and expenses. Students use the random number generator to get their sales and expenses numbers for each day.

Students enter their data in the spreadsheet for each day. Students use a formula (sum) to calculate expenses. Students use a simple formula to calculate profits or losses (sales - total expenses = profit ).

Download: lemonade-stand-profit-or-loss-spreadsheet-finished-example.xlsx

Lemonade Stand Profit or Loss Finished Example:

Lemonade Stand Profit or Loss Finished Example

Lemonade Stand Random Number Generator

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

Download: lemonade-stand-profit-or-loss-spreadsheet-instructions.pdf

Lemonade Stand Spreadsheet Instructions:

Lemonade Stand Profit or Loss Instructions

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

Excel Spreadsheet Rubric for Grading Assignments

Excel Spreadsheet Rubric for Grading Assignments

Excel Spreadsheets and Charts

  • Simple
    Bar Chart

    Excel Simple Bar Chart
  • Thanksgiving
    Dinner Shopping

    Thanksgiving Dinner Shopping Comparison Spreadsheet
  • Clothes
    Shopping Budget

    Excel Clothes Shopping Budget
  • Learn Excel
    in Minutes

    Learn Excel in Minutes
  • Excel Back
    to School

    Excel Back to School
  • Excel Pet
    Adoption

    Excel Pet Adoption
  • Excel
    Sports Budget

    Excel Sports Budget
  • Excel
    M & M Chart

    Excel M & M Chart
  • Excel
    Lemonade Stand

    Excel Lemonade Stand Spreadsheet and Chart