School Bookstore Excel Project

As a Business Education Teacher, many times the school bookstore is run by the business classes so they get a hands on experience with a business.  Using Excel to track expenses, profits, and costs is a great tool that can be developed by the students to see how a business makes a profit.

WHAT TO DO….
Each student will create a spreadsheet using excel.  The layout is entirely up to the student.  The following cells must be included in the spreadsheet.


You will need to list each item in the school bookstore, list the cost and the retail price.  The items listed above that have and asterisk must have a formula to calculate the item.  To figure the Retail Cost the each item is multiplied by 2.

To get the data each month for the spreadsheet each student will be responsible collecting daily data that is posted on the bulletin board each day.  If a student is absent, they are responsible for getting the data from a classmate.  Every month the student will submit the spreadsheet on disk for 25 points.

To see an example of the spreadsheet click here.

This project could be revised for other classes such as accounting.  Have the students create a profit/loss statement for each month.
  1