• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11

ICT investigation

Extracts from this document...

Introduction

ICT Coursework Definition, Investigation, Analysis Background to the company The Canterbury Karate club is a club that teaches students, of a range of ages, karate. It is run by Sandra and Joe Ellis. Sandra and Joe are the main day to day employees but there are 2 vice chairmen involved in operations. And teaches in venues including Canterbury, Ashford and Margate, There are approximately 20-30 pupils per class, and there are 7 classes a week, 4 of which are for adults, 3 are for children. The records held on pupils, venues and events are all paper based. It is hard, due to the number of students to keep accurate records of fees and pupils. It is also hard to notify pupils of any changes to venues or new competitions. Lessons do not have to be booked in advance with many pupils simply turning up to the classes; this can lead to overcrowded lessons. Definition of the problem The main problem with the current system is that it is unorganized, as it is paper based records and updated very frequently it is hard to get information from the documents as items are written and rewritten. It is also difficult to carry around as pupils and staff are also kept as it is too difficult to rewrite the entire page with one pupil removed from it. There is also no way to distinguish between pupils of the same name, as there is no unique key Also as there are multiple instructors they all need to have a copy of the pupils records, this means that each pupil that joins has to be copied onto several sets of records for each members of staff they have. It is also hard to collect money that is due from previous lessons as every 4 weeks a new page is started so if there is money owed the instructor needs to carry around another file. ...read more.

Middle

6. What outputs are required during the application process? The system will need to generate a monthly report containing the pupil's details, the lessons they have attended and any outstanding payments they have due 7. What should other users be able to do to the database? Pupil's will be able to have access to the database using a login but will only have access to their own details 8. What happens when someone leaves the club? The details that are stored will need to be removed from the database, but will be kept on any backups in case the pupil needs to rejoin. 9. Do you want the system available on the internet? It should be as the database will need to be available on more than one computer at one time, so the database will be stored and edited on a central location so that data cannot be entered or changed twice. 10. Will you require a desktop pc for the database or a laptop? Me and my wife will require either a PDA or laptop for the day to day usage, and A desktop computer for the offices 11. How many records will the database need to store? At least 250 for pupils to start with, but the number may be larger or smaller because new pupils join and quit The lessons will need to be stored for at least a 6 months as they contain the records of due payment, so there should be range for several thousand lessons. 12. Will there need to be any limits on the amount of money a pupil can owe? Yes there should be a limit of 5 unpaid lessons before a pupil is refused to attend any more classes until they settle the money owed. 13. How often will you require backups of the system? There should be two backups, an archive of all data older than 6 months, and a daily backup that stores all of the day to day information stored, this ...read more.

Conclusion

on a low spec computer if the spreadsheet holds lots of data or has complicated expressions & calculations Ease Of learning The access database will be quite hard to learn how to use with novice users as it can be quite complex The spreadsheet package is easier to learn how to use as it has less powerful & appropriate functions Ease Of Use Once the user is taught how to use the database it will be easier for the user to use the database Once the user is taught how to use the spreadsheet it will be easy to use Technical Support Microsoft provides a high level of technical support, although it can be expensive Microsoft provides a high level of technical support, although it can be expensive Speed The package will be quick and efficient on most computers The package will be quick and efficient on most computers Hardware Specification Here you need to have a list of all the items of hardware that the system needs Including * Processor- AMD Sempron 64 2800+ 1.6GHz (�45) o This gives the system more than adequate performance whilst allowing the user to upgrade the software without having to upgrade the hardware * Memory- 256mb Ram o This meets the minimum requirements for the software required * Storage- 40gb Hard drive o This means that the user can store the software and the database whilst allowing them plenty of storage for other files & backups * Inputs o Keyboard, mouse. These are the basic inputs required for the system, as the user will not need to use any other input devices, none are required * Outputs o Screen, Printer, Speakers. These are the outputs required, the screen and speakers are basic required outputs, and the printer allows hard copy backups of the database to be produced, as well as mail merges & reports to be printed * Graphics- On board VGA o This is all non graphic intensive programs require ?? ?? ?? ?? Ryan Bebbington ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication 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 AS and A Level Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    These documents can include things such as source documents, customer invoices and delivery notes, which will enable me to construct an image of the information flows between input and output. The records and procedure manuals of the business can also be examined.

  2. Marked by a teacher

    Information Age

    3 star(s)

    Face book has a number of features for users to interact with. They include a wall a space on every users profile page that allows friends to post messages for the user to see. Pokes, which allows user to send virtual "poke" to each other, photos where users can upload

  1. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    This si done through manual calculations within his office. Ellis Redding as head of administration is in charge with all of the paperwork which comes through EVDOP Live. With the current system that EVDOP Live employs, Mr. Redding has o use a paper based system to complete the various forms of administration that he needs to do.

  2. Feasibility Report

    As a computerised system can easily crash, get viruses, spyware and Trojans, which can result in important files being deleted, for example, files containing details about customers orders, and also payments received by customers. In turn up to date antivirus and spyware software must be installed.

  1. System Analysis and Design Assignment

    30p for every day that a book is overdue, up to a maximum of �3.00. This is used by the Learning Centre to encourage members to return books on time and avoid the fine. Problems associated with this: The loans file could become disorganised and determining which books are overdue and for how long could become difficult to manage.

  2. Using ICT to communicate

    documents and the recipient needs to know exactly what the terms and conditions are. The leaflet needs to get the information across to the recipient as clearly and as informatively as possible so that the recipient knows exactly how to claim on the pet insurance and under what conditions it can be done.

  1. ict as level coursework

    Should be able to delete information This will be tested by deleting a customer in the customer details spreadsheet. Data should be able to be accessed again once saved by user The system will be closed down and then opened to see whether the data can be retrieved again.

  2. ICT AS-Level Coursework

    29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 In A7 I will be inserting the heading "Product ID" In B7 I will be inserting the heading "Name" In C7 I will be inserting the heading "Colour"

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