3 - Spreadsheet Modelling and System Design
Now that you have learned a range of skills using Excel for
creating spreadsheet models, it is time to put them to use creating
a business system.
A system is designed to:
- Have data like sales figures input
- Process the data, e.g. calculate total sales
- Output useful information such as a graph
showing sales trends
A system has very clear input, processing and output.
Systems are designed to help people make decisions for the future,
using reliable and clear information.
Step 1 - The Video Store
Use the worksheet below to make a system for a video store that
the owner can use to make decisions about their organisation.
Follow the step-by-step instructions to create a working system.
You will also need to download the video store spreadsheet.
Stage 2 - Creating Your Own System
Now that you have followed instructions to create a system,
it is time to create one of your own. You need to read your
client's instructions and also download the basic data to get
you started.
|
