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

    If existing procedures are well established already, then the study of the procedure manuals will provide a perfect source of information on how procedures should be carried out. It is not likely that such procedures would be documented for smaller businesses like Fred's Car Rentals.

  2. Marked by a teacher

    Ecommerce Case Study

    This will also allow cuckoo games to stock more of a particular products that may be extremely popular such as the latest games or accessories. Using ecommerce cuckoo games will also be able to gain new customers that may have never heard of the company before simply by the use of search engines.

  1. Marked by a teacher

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

    Additionally there are some obvious financial problems within the company. After viewing the current system which deals in the various forms of costs and also expenditure. The current system does not take into account the current venue costs and takes an average cost of previous costs to now to work out costs.

  2. Applied ICT - How Comet Stores could use ICT and a CCTV system.

    will have around a 4 screen's split in one TV and when you go into that security room you will only be able to see the TV's front of you and there is usually 2 people who sits there and watch the TV's.

  1. A2 ICT CouseWork

    Rollover Buttons are very useful in many ways, as there can make the website seem more futuristic and even help customer's navigate from page to page in the website. � Client-"Mr Jane has insisted that the website must be displayed at the top of search engine."- We know this will

  2. Health Book

    Steam's 'Steam Cloud' feature is one of its major features attracting a lot of attention and being one of the foundations it is succeeding in the gaming industry. This feature allows gamers to upload their personalized settings, game saves and gamer profiles to an offshore central server, giving the gamer

  1. Feasibility Report

    With a backup system, all data from the formatted system can be viewed, accessed and saved onto another system. Conclusions And Recommendations Software Needed The Perfect Pie Company will need to invest in antivirus/spyware software, and integrated packages like Microsoft Office 2007.

  2. Features of database design

    It is also user friendly for people who don?t or find it difficult to use a computer. Navigating around a database is very simple when shown how.

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