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

    this will allow video publishers to ditch URLs and replace them with something more memorable. The second is you tube music, a new section that allows musicians to post their music videos. This is most likely to fit in with YouTube's plan to host music video that was ever created.

  1. Marked by a teacher

    Ecommerce Case Study

    It may also be an idea for Cuckoo to have a free return post address in order to help customers with returns. This may also backfire that customers are more encouraged to return products that they may not have before.

  2. Marked by a teacher

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

    Examples of what he has to do are to organise letters to be sent to customers and other tasks as such. Lastly James Whitmore plays a key role in the company. He is in charge of publicising key events within the company.

  1. System Analysis and Design Assignment

    This informs them that they will be liable for paying the full cost of the borrowed book if it is not returned immediately, at the cost price which the Learning Centre originally paid for the book. The Learning Centre also has a fine procedure in place which will fine members

  2. A2 ICT CouseWork

    I test these different processes for any anomalies, as problems could occur such as loss of information or nothing being sent, this could be due to problems with my PHP code, meaning that our form's do nothing on the website and are pointless.

  1. ict as level coursework

    The calculations are done behind the user form with the use of formulas which inhibits the likelihood of error. This overcomes all the negative attributes of the old system such as time consuming and lack of professionalism. Catalogue Of Products The spreadsheet below is my catalogue of my products.

  2. Unit 1 business at Work How ICT is used within the Organisation

    This could also make deliveries from suppliers be more efficient. * Intranet - Suppliers will have access to Sainsbury's intranet site and they will be able to view stock levels so as they know how good or bad things are selling in the market place.

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