Create a computerised spreadsheet using Microsoft Excel (a quiz) for a school because in the school they have to make the quiz hand written, and lose it many times and there are too many papers. So to, solve this problem I will create a computerised spreadsheet.
* To have multiple spreadsheets to have different functions
* Contains formulae to carry out the calculations on data and update related cell values
* Need a look up function, in order to link between spreadsheets.
* Make it user friendly so it easy to navigate and clear to understand
* Include a logo
* Make spreadsheet password-protected fro security purposes
* To be able to create graphs based on the scores
* Use freeze panes to facilitate scrolling down records, clearly
* Have conditional formatting to react to the changes in the value in the spreadsheet
* Data Validation to format cells for your data-type (string, currency)
* Size check (shrink) in order for it to fit on the page
* Have commands to run macros for e.g. printing
* Must have a summary sheet (Quiz Questions – to let user have an overview or) in order to quickly be able to see the main trends or data (probably a chart)
* To have different font type, colour
* Have a border around the cells so it is clear
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.
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.
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.
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.
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)
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.
It is a formulae carrying out calculations and updating value of cells.
To validate means for computer software to check that the data being input is sensible. An example is validating cells in correct type.
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.