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

    which the current system operates and thus calculate will be required of the new one, several methods can be used to obtain facts regarding the system. These methods include structured interviews, unstructured interviews, questionnaires, a study of all forms and documents, an examination of records and procedure manuals and direct observation.

  2. Marked by a teacher

    Information Age

    3 star(s)

    Below that are different sections that customers are willing to browse. On the bottom of the page is the help link given through which customer can access if they are confused, and just next to it are given the options of TV's various channel.

  1. Marked by a teacher

    Ecommerce Case Study

    worry when starting up an online business and once they become confident enough they then edge away from it and become independent. Cuckoo Games should use PayPal in the beginning in order to ease stress and worry and also to gain customer trust.

  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. Feasibility Report

    new system, various amounts of hardware and software will have to be purchased in order for the Perfect Pie Company to get the most of the new system; this will put a strain on the financial budget. Although Antivirus and Spyware software can remove nearly any virus that steps in

  2. 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

  1. 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.

  2. ict as level coursework

    Buy products. 10% deduced from the total of purchased items 11 Ensure VLOOKUP works correctly for product name on 'buy products' user form and invoice. Make an order by selecting a catalogue number. The name of product from the selected catalogue number should appear.

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