• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  • Level: GCSE
  • Subject: ICT
  • Word count: 1687

AQA ICT Modelling Coursework

Extracts from this document...


Description of Task. Lifestyle Personal Trainers Inc was established 10 years ago in Chepstow and is now a national company with 948 gyms nationwide. The company was recently bought Ms. Lass who is looking to modernise the company. Ms. Lass wishes to update their current system, which is at present a filing cabinet locked in the office. All files in the members are stored alphabetically, under surname, in a large filing cabinet, which is locked using one key and then the office in which it is kept is locked using another. The current system is a pen and paper system, with the personal trainer having to do all the calculations and filling out each client's personal plan. Both the personal trainer and the weight-loss client would use the system to keep track of their weight-loss. The personal trainer would use it to alter the exercises and diet plan, whilst club members would log onto it from home via the internet in order to communicate with the personal trainer between sessions. The new system needs to be able to perform calculations. They want to make it easier to enter, sort, find and store data on their weight-loss club members. At present, there are few problems with the pen and paper system that Ms. ...read more.


Also, using something like Excel would mean that the personal trainers wouldn't have to do the calculations for each client, instead; these would be done on a computer. However, it may be costly if the company does not already have sufficient equipment. Overall, Ms. Lass should store the data electronically because it solves all the current problems (the time taken to add or edit data being too long, the lack of backup copies, the lack of security, and the issues surrounding handwriting.). It would also mean that the calculations needed for each client's plan would be done quickly on a computer. However, in the short term, it may cause a few problems, one being the cost of setting up the new system, as the company may need to buy a computer etc, and the second being that the staff may need retraining in order to effectively use the new system. Whilst re-training the staff would solve a few problems, others, such as the security, would remain. Replacing the current pen and paper filling system would only add to the current problem of it being too time consuming. Specification Five things the new system should have are: 1. A password. This is important as it stops unauthorised access to client's personal weight-loss plans. ...read more.


It also a DVD Rewriter, meaning that although she may not be able to back up the data on a memory stick, she could use a DVD to store it. Another advantage of choosing the laptop is the fact that it will save space in the office and trainers can take it into the gym with them when they review their clients' plans. Peripherals. TBC Implementation - Software. Now the software Ms. Lass will use to create the database has to be considered. I have chosen to compare Microsoft Access and Microsoft Excel. Microsoft Access Advantages Disadvantages Can organise data easily. Some members of staff may not have used it before and will therefore require training. Easy to input data. Microsoft Excel Advantages Disadvantages Can organise data easily. Some members of staff may not have used it before and will therefore require training. Can put in formulas and do calculations. Easy to input data. Ms. Lass should use Microsoft Excel because it meets all her needs, she can organise data easily, can do calculation to work out a client's target weight etc and it is easy and quick to input the data. All of these advantages were things that Ms. Lass wanted in the specification. Also, the only disadvantage is the same as with Microsoft Access, the fact that some members of staff may not have used the software before and would need training. ?? ?? ?? ?? Page 1 of 9 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. GCSE Excel Project ICT

    to sheet1 select insert value '13' in D7 Pass Warlordtf5 Go to sheet1 select insert value '12' in D7 Pass Warlordtf500 Go to sheet1 select insert value '9' in D7 Pass Warlordtf750 Go to sheet1 select insert value '10' in D7 Pass WarlordtfGC10 Go to sheet1 select insert value '6'

  2. a level ict project

    "The user interface involves the way the receiver identifies the information conveyed to them. A consistent layout will allow comfortable usage for employees when using the system" A graphical user interface has been implemented to meet the requirement for an attractive user interface.

  1. Tennis Tournament UNIT 1 GCSE ICT coursework

    Excel has the ability to handle text for heading, text labels and numbers for the data. It also allows me to use a formula which is very useful for calculating profit, loss and markup. It will allow me to input validation which is also helpful because it will put restrictions

  2. The impact of ICT on a person with special/particular needs

    regular fans who use the technology a lot thus wearing out the battery or experiment with the insides. It is quite expensive but it's nothing too much. It doesn't use much charge and it's a one-time price as Sarah bought a pay-as-you-go phone.

  1. Testing for ICT A Coursework 2a

    Labelled printouts of all Mail Merge This is the start of the mail merge where i have selected all the fields that i need in order to send the mail merge letter. I then choose the list of mailings that i want to send to and then choose the data.

  2. ICT car insurance quotation System Coursework

    Stop recording. Also to make the system look professional as possible, I changed the header at the top of the system. I used the Visual Basic Editor to edit the Auto-open macro. I clicked: -Tools -Macro -Visual Basic Editor. I opened the macro Auto-open and inserted the line Application.Caption = "Cheshire's Vauxhall Insurance."

  1. GSCE ICT Microsoft Excel Coursework

    It's easy to view and will be the best and fairest solution. A well presented league will represent the positions of the fighters and it will display their points User Requirements Sensei Lee and sensei Mark have a clear idea in their heads of what they want the table to

  2. System requirements analysis

    * List and explain any further changes you think ought to be made to your system, indicating:- (a) What work would be involved (b) What benefits these changes would provide to users * Briefly list the main things you have learnt from developing your software system.

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