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

    One can study all the forms and documents in a business to discover what information will be required by the new system. A thorough examination of the documents in Fred's Car Rentals will ensure that each of the documents actually fulfils a purpose and that the information that is recorded or transmitted is actually used at some stage.

  2. Marked by a teacher

    Information Age

    3 star(s)

    On the top of the website 4 different types of ITV categories links are given that navigate to different sections of ITV. Just below that link other links such as catch up, TV guide, news, sport, SOAPS, drama, entertainment, TV classics, lifestyles and games are given.

  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

    back up copy, so if the copy on paper was to be misplaced or lost, the scanned document can be easily accessed and reprinted. Possible Constraints With Hardware And Software There will be many possible constraints with the Perfect Pie Company becoming computerised, as well as the design of the

  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

    this contains contact details and how to contact them if there are any complaints or for claims procedures. On the reverse of these four pages are three more pages of information that are set out exactly the same as pages three and four using the numbered sections and subheadings.

  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

    The correct pseudo codes must be entered in to the command button. The command button will clear the previous customer's information after it is initiated. Add the time (self updating). Add the time to the actual receipt, make sure the time updates regularly.

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