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

Information Technology for a school Detention System

Extracts from this document...


Analysis of Own Project Introduction Dr. Watkins and Mr. Cameron (The defaulter administrators) both deal with boys' defaulters and detentions. They currently have a spreadsheet-based system however it has many limitations. These limitations mainly relate to a lack of data validation functions, which disallow the entering of bad or invalid data. Also, as I have included under the heading 'The current system', it relies on manual input too much. They have asked me to design and make a new system which will be much more user friendly so that it can be more readily accessible to other staff. It must also include more automatic features, which will for example automatically create reminder slips for pupils who have overdue defaulters. Interview For my research, I interview Dr. Watkins, one of the schools' defaulter administrators, about the current system and what he would like to see in the proposed system. Me: Hello Dr. Watkins, first of all I would like to ask you how you rate your computing skills? Dr. Watkins: I regard my self as fairly competent when it comes to ICT, after all, I designed the current spreadsheet based system but unfortunately my colleague, Mr. ...read more.


There should be a tool, which will automatically print out these slips for all outstanding defaulters and detentions. Deletion At the end of each year all of the defaulters are removed from the system. Times Defaulters and detentions can be done at lunchtime on Monday, Tuesday, Thursday and Friday and after school on Tuesday, Thursday and Friday and it must be possible to select the chosen time from a list when a pupil comes to arrange a time. Hardware and Software Dr. Watkins and Mr. Cameron both currently have computers with the following specification: * Microsoft(r) Millennium Edition(r) (ME) Operating System * Intel(r) Celeron(r) 755MHz processor * 128 Mb RAM * A 16 Gb hard disk with 7 Gb of free space * Floppy disk drive * CD-ROM drive The computer currently has the following key software installed: * Microsoft(r) Excel(r) * Microsoft(r) Access(r) * Microsoft(r) Word(r) * Microsoft(r) Internet Explorer(r) Users skill level Dr. Watkins is very familiar with IT problem solving as he produced the current, Excel(r)-based system although he has not used Access(r) before Data Flow Diagram The following diagram illustrates in outline the processes of adding and the management of defaulters and detentions: Objectives of the new system The system must perform ...read more.


This would be a good way, which would produce a very effective program, but the only problem would be that it would be very expensive which would not be cost effective, as the defaulter department does not have a budget assigned to it. 4. Using a package and customize - this would be ideal because Dr. Watkins already has suitable packages installed on his machine and I could customize it to the needs of the new system with my current computing knowledge. Chosen Solution My chosen solution will be to customize one of the programs, which Dr. Watkins already has installed of his machine. The options are to use either Microsoft(r) Excel(r) or Microsoft(r) Access(r). These are both available on Dr. Watkins' machine. Microsoft(r) Excel(r) offers the following features: * Data Validation * H Lookup tables Entering Free Data Microsoft(r) Access(r) offers the following features: * Macros * Queries * Data Relationships * Interaction with Visual dBase I think that Microsoft(r) Access(r) 2000 will be the best package because it enables me to meet all of the performance criteria using all of the tools available on it. Testing Plan I will test my system by defaulting a pupil and then printing out reminder slips and record sheets to ensure that their names appear on them. ?? ?? ?? ?? ...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. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    People are also easy targets to being mugged. If you are seen coming from an ATM machine, people assume you are carrying a mystery amount of money on you. This puts you as an ideal target for thieves who see you coming from an ATM machine. That's why it is very dangerous to use one in a secluded area.

  2. Use of IT in schools

    The principal school in the foundation, Mill Hill, has 3 computer laboratories, as well as computers in the Art and DT departments, and some in the library. The school, as would be expected, is on a Client/Server network, which every student and member of staff has access to.

  1. a level ict project

    Accepted and saved T5 Delilayabejabablesans (boundary) Accepted and saved T6 To make sure data subject data can be reached in less than 5 clicks Use user interface to access information an employee Information reached in 3 clicks T7 Make sure all date fields allow only long dates 12 March 2007 (typical)

  2. Creating a computer system.

    It should take no longer than 2 minutes to enter the data into each invoice 2. The monthly sales summary and chart will be produced using a menu item or button 3. The system should be easy to use for anyone with a basic knowledge of Excel 4.

  1. System requirements analysis

    This software has a range of features that would be needed for the Howard Health Centre. Here is a list of The features that would be needed for the health centre, that the company claim to offer: * Provides improved internal and/or public access to services and assets for customers

  2. Benefits of using my IT system in the Travel Agents.

    Finally I will start creating my form. The forms were created successfully. The only change should be that it would be easier if there was screenshots or images and besides that it doesn't need any changes. Creating switchboard I will open Microsoft access then I am going to click on create and select form.

  1. Planning a system to handle school records.

    is not visible in one page and the examiner and the teacher has to search User requirement: Mr. Ahmed wants me to develop a system which can perform following functions. * Develop a system for recording and storing all the assessments undertaken by students.

  2. This report I will be writing, will be on the way I do activities ...

    How the technology meets my Personal Needs My personal needs are met by this technology; it allows me to communicate with my family while I am not around with them. I can call any of my contacts which are saved in my contact list, by accessing the database of contacts on my mobile phone.

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