Please enable JavaScript.
Coggle requires JavaScript to display documents.
Sports Centre Scenario - Coggle Diagram
Sports Centre Scenario
-
Create formulas in order to automatically calculate item costs, profits and losses.
Ways to represent data
Graphs
Easily interpretable to an audience who knows nothing about data spreadsheets,
-
-
Record macros that will copy information entered into a form and paste it into a database where that data will be stored and eventually used.
Multiple inputs are also required from the user, which are copied and pasted by the macro, like activities data.
Formats
Cash - Ensure cash suffixes are always to 2 decimal places along with being formatted as GBP (£ - Great British Pounds) using the accounting format.
-
-
Independent values – Any values that are calculated should be rounded to the nearest whole number unless the numbers an average then it should be to one decimal place unless specified elsewhere.
Formulas
Simple addition, subtraction, multiplication and division. E.g. (R + O) (D - N) (E x Y) (L / A)
SUM – To add up multiple values in the same row or column together in order to create a total value for the row or column.
VLOOKUP – We would need to use this for finding the number of children in an activity along with finding the corresponding cost for the activity they’re doing. Lastly, we would need to find the instructors hourly wage and add that to the price. May also be used to search for the names of the youth clubs.
AVERAGE – To add up all the values in a row column or a certain area then divide the total value by the amount of values to get an average of those values.
-