I NEED HELP PLEASE!
Sweet Pete's Spreadsheets
Pete has a bakery and wants to make a better organizational system to organize what he needs for his business as well as keep track of his finances. Make a mock spreadsheet that details his incoming and outgoing finances. in the spreadsheet Account for money moving with appropriate fields of data, and be sure to use a binary field to track whether it's an incoming or outgoing amount, use data fields to track and order the payments, and add at least five entries that may be common for a bakery (think about bulk orders for food that would bring money in or purchases of ingredients that would cost money, along with rent, etc.).
Next, make an organizational chart that covers the sort of improvements using Excel for his finances that can help him. Also, mention the principles of data analysis to Pete and help him understand the plan you created for him to run his business effectively.
TABLE Grading Rubric
Full Credit
The student came up with a coherent analysis of the kind of needs a bakery might have, provided a good organizational chart that covers the aspects of Excel, and also mentioned the principles of data analysis in order to help Pete out. The student also created an adequate mock spreadsheet using different types of fields and data and filled in at least five entries with example data. The student demonstrated a good understanding of the sort of business needs this type of business might have.
Partial Credit
The student came up with a good analysis of the kind of needs a bakery might have, provided a sufficient organizational chart that covers the aspects of Excel, and mentioned the principles of data analysis in order to help Pete out. The student also created a mock spreadsheet using different types of fields and data and filled in at least four entries with example data. The student demonstrated a basic understanding of the sort of business needs this type of business might have.
Little Credit
The student came up with an analysis of the kind of needs a bakery might have, provided a sufficient organizational chart that covers the aspects of Excel, and mentioned some of the principles of data analysis in order to help Pete out. The student also created a mock spreadsheet using different types of fields and data and filled in at least three entries with example data. The student demonstrated little understanding of the sort of business needs this type of business might have.