• 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. Financial Model to help organise the year eleven prom

    This was the original formula that had caused the obstacle of my aim. So I then changed it, and found that the new formula had solved my previous problem. * However the total at the bottom of the screen (picture 3)

  2. Different types of technology How I use ICT at home and at school

    An analogue signal is essentially a broadcast signal which is continuous in terms of amplitude or frequency. These are very inefficient and require an aerial to pick up the signal and can often result in the picture being unclear. These were the main form of television until digital television was discovered.

  1. GCSE Excel Project ICT

    6 Make Features Size Price 1 Aixam Standard 25x25x15 �35 2 Divine Standard 30x30x15 �45 3 AlienWARE Water Cooler 31x31x16 �55 4 WarlordTF Special Water Cooler, Neon Lights 35x35x20 �70 Now, with the formula corrected, we can see the correct result of the VLOOKUP: We repeat the formula to the

  2. Advantages & disadvantages of ICT

    It should be destroyed if it is no more necessary. Computers can be used to store data & keep it secure from Internet fraud. The data collected by a company from the customers should be accurate so as to comply with the data protection act.

  1. ICT Coursework (MarcoS)

    Hardware and Software The new system will use Microsoft Office Excel 2007, because it is easy to use, and also one of the best way to manage the profit and loss account. There will be 6 desktop computers, all accessible from all the employee by using their own username and password.

  2. GCSE ICT Coursework Write-up

    Inputting Data Input devices are devices used to give instructions to a computer, for example, a keyboard or mouse. Accuracy is important when inputting data as if it is inputted incorrectly, then it may affect other parts of tasks as well as being incorrect and so affecting the task.

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

    She can also send SMS messages by saying 'SMS', then saying the name of the contact, then using word prediction she can either spell out letters, say whole words or use an increased text size to write words, made easier via word prediction.

  2. Ict Powerpoint Coursework

    Apple Desk set This is a top of the range Microsoft keyboard and mouse desk set bundle. It has customized shortcuts of your choice at the top of the keyboard for anyone's ease and the mouse has six-axis control making it easier to control and easier to use a computer.

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