Users:
The teacher will use the spreadsheet to make the questions and answers to them. Students might also use the spreadsheet, if the teacher wishes to make the students do the quiz on a computer rather than printing it out, and giving them it to fill in using a pencil or pen. The teacher might need to take some classes in order to fully understand how the spreadsheet works, and how to fill in the questions and answers.
Alternative solutions:
I could have just used paper, a database or just another manufactures software like Microsoft Excel. But I decided to use Microsoft Excel because a spreadsheet will do calculations with a great degree of accuracy. A spreadsheet takes up less room than a filing cabinet. A spreadsheet can automatically generate graphs. However, The disadvantage of computerised systems are that they require training to use and to produce, they rely on electricity and there are security concerns about systems on networks (people can "hack" them). I didn’t use paper because it would take too long, and have many loose papers. I didn’t use a database because it is hard to contain formulae and to keep record of it. I didn’t use another manufacturer software like Microsoft Excel because I only had Microsoft Excel on my computer.
Analyse
Software:
I will use Microsoft excel a spreadsheet package for making the spreadsheet. This is because Excel is an excellent application for producing graphs and charts and in Excel, you can "lock" certain areas of the spreadsheet to prevent misuse. I will use Microsoft Word, the desktop publishing for making notes. I will use Internet Explorer for research.
Hardware:
In this project, I will need a Standard PC, and Windows XP installed on it to make the spreadsheet. I will need a modem, to connect with the Internet for research. I will also use a colour monitor, keyboard, mouse and a colour laser printer.
Input:
It is the data that goes in and how. For example, I will input data for the quiz on Microsoft Excel. Some of it goes in by user formulae in cells, headers type etc. Some of input will be by cells by result of updated formulae (calculations)
Output:
It is the Screen for showing us what is happening on computer. Saving your work is also an output. Print outs of spreadsheets is also an output.
Process:
It is a formulae carrying out calculations and updating value of cells.
Validate:
To validate means for computer software to check that the data being input is sensible. An example is validating cells in correct type.
Verify:
Verification is the process of checking that input data is correct. It is normally carried out by a human who visually compares the data with the source document. To check spreadsheet, is an example of verification. Also user feedback is verification.
