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.