• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

In a library all orders and details are recorded on paper and not every need is catered for on the forms given. As a result of this the librarian has asked me to do a spreadsheet to make it easier for her to record all the details of finance.

Extracts from this document...


Description of task The library has a set budget every year of �4,194. However all orders and details are recorded on paper and not every need is catered for on the forms given. As a result of this the librarian has asked me to do a spreadsheet to make it easier for her to record all the details of finance. She also asked me to make sure that I can be able to add to the balance given in case of cheques that may be given or additional money. To understand further the task in hand I was told to see Miss Mistry in the office as she handles all the financial details of the school. The task will prove to be more complicated than I initially suspected. Analysis Current System At the moment the current system is a manually based one, which is prone to error. All the expenditure is recorded on a sheet shown in appendix 1. This record sheet is provided by the office and used by the librarian whenever a new order is placed. It is prone to being misread and would be better of under a computer-based spreadsheet. ...read more.


Then she would go and write out the order in the order sheet and send off the order. Specification General Criteria � The system must be easy to use � The owner is computer literate but it would be more preferable for her if she had a straight-forward system that will cause little problem for her � The program should be easy to install Specific Criteria � The computer must have validation checks for things like spelling errors. � It must be able to calculate the additions and expenditure of the library budget � There should be formulas in the system that can be used by the librarian for working out budget calculations Specification � It will be a spreadsheet on Microsoft Excel 97 � It will deal with maths formulas � There may be problems if I design any of it at home as I have got Microsoft Excel XP � The system has to be clear and easy to use � I should not have to keep going to the library because the librarian doesn't understand a certain part of it. That would show that the system is too complex � The ultimate aim is to make sure that the program will calculate the income and expenditure of the library. ...read more.


Design [image002.gif] Implementation Resources The computer in the library is in the same network as the rest of the computers in the school and linked up with all of them via a bus network. The specification of it is the following: - Pentium 2 32 Meg ram 8 Gigabyte hard drive 10 - 100 Meg net cards 2 Meg Video card CD ROM drive Keyboard Bubble jet printer On the network there is file, Internet and printer sharing. There are 2 computers in the library, however the librarian uses one and the 6th formers who help her and other students use the other. Test Strategy It must be ensured that the initial design of an ICT system works, as it should. The system must process and output values correctly, and must also help the user to avoid unintended input by applying validation rules. The test strategy will involve the input of a variation of values, to test if the validation checks are functioning correctly. Faulty values will be input and it will be observed whether the user is prompted about these. It must also be checked that the user is not prompted when correct values are input. Test Prediction Result Evidence Make Date of order allow dates starting from beginning of 2003. Input older date Date will not be allowed as it is too old Error report Appendix 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. This project is designed to help non-computerized library to easily keep track of their ...

    The address, the telephone number and the name of the supplier is written. As the demand of the members rises the new books are bought. To meet the demands of the member. THE BORROWING SYSTEM Equipments: Issuing tray: wooden trays for filling the books ticket and readers card, this contains thirty-one pockets.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    I am going to start with the loans query, o this query we will retrieve from the system all the information on the DVDs that are on loan a this moment. I have set up two parameter for the search of this query, one of them is for the member id and the other one if for the DVD id.

  1. My task is to help Type a Flight travel agency to make their things ...

    I will use Microsoft word because this is the most sufficient application for me. 5. Writing reports at the end (User Guides) I can write a report at the end with my hand but I will not because I can make mistake.

  2. ICT notes

    The Use of Systems Flowcharts Flow diagrams are a way to work out the best order to do something. System flowcharts show exactly how the data moves e.g. the health centre could produce a system flowchart to create a new patient record.


    more time to focus on other school work and leisure time, also getting involved in family activities, like going out shopping with my mother and bonding with her. However the most important aspect in using word is that the teacher too is happy reading and marking my coursework in a

  2. System requirements analysis

    They will just need to click onto the button and a quick description of what the page contains is also included. This makes the software more easy to use. New receptionists and doctors can easily learn how to function the software which will save time.

  1. The end user of my program is for the people applying for the insurance ...

    the user the opportunity and chances to store customer details within the system for future reference. At present customers come into the office or phone and are asked a series of questions. Using their answers the relevant multipliers are assigned according to tables of ratings.

  2. Computer Studies Past paper definitions

    type, format, range, length, presence, control total, check digit [2] (d) polling testing a station/terminal/device in a multi-access system in a sequential order/in turn to establish whether it is holding data for transmission/collection to allow time sharing e.g. checking source of interrupt [2] (e)

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work