• 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)

    If it gets lost or stolen and goes unreported, people can take books and not return them all under your name, thus giving you the blame. Also, the library card is extremely harsh with overdue books. If a book goes overdue, you have to pay a large fine or you cannot use the loaning system any longer.

  2. Different types of technology How I use ICT at home and at school

    These can add up to quite a hefty sum. But with children and their peer pressure and their need to conform to what's the norm, they'll just keep on pestering until they get one, making their parents' money disappear like a cake at fat camp. The blackberry also makes you quite vulnerable to theft.


    = "" Then Rows("2:2").Select Selection.Delete Shift:=x1Up MsgBox "The new student has not been added to the system at this time. You failed to enter data in one of the required field!", vbOKOnly, "Student Entry Message:" End If If Range("B2") = "" Then Rows("2:2").Select Selection.Delete Shift:=x1Up MsgBox "The new student has not been added to the system at this time.

  2. Use of IT in schools

    Once they reach the secondary school, they are expected to be able to type essays, have a good working knowledge of word processors, and research information on the Internet. These skills would be needed at university as well. There are also specific uses for ICT in certain subjects.

  1. Introduction to information skills and system. An information system is a system that accepts ...

    Data are accessed directly without going through other things. Cache is another example of primary storage. It has the same functions are RAM, but is temporary storage for quick access. ROM read only memory, permanent memory where instructions are stored. These instructions are not to be edited or it may distract the processing of the computer.

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

    * Finally, click on Print. MICROSOFT ACCESS Open Access * First, you click on the Start menu. * Then, you click on All Programs. * After that, you click on Microsoft Office. * Finally, you click on Microsoft Access. Create table * First, you should go on Microsoft Access.

  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. GCSE Excel Project ICT

    Data input explained with details of validation. The information about the products sold will be written into tables, which will then be inserted into a respective spreadsheet. The table will have the product name, the Features, Size (be it physical or data storage), speed (if needed)

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