• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

ICT SPREADSHEET-ANALYSE

Extracts from this document...

Introduction

Analyse Hardware I will need a lot of hardware to create my spreadsheet. The main hardware the system will require are the essentials: the hard drive where the work will be saved and the monitor itself, where the output will be displayed in order to see what is happening. Also a keyboard will be needed to input data and a mouse for selecting data and dragging or merging cells. Finally I will need a basic processor which can do calculations in excel. Software The software I will use is Microsoft Excel (2007). This is the best known package and would be really good because I know how to use it well and suited to Mr. Geller's purpose rather than software lotus 1-2-3. In addition to this my end user Mr. Geller can also use it as it is very user-friendly and not as complicated as lotus 1-2-3 for instance formulas on Ms Excel can be done automatically while Lotus 1-2-3 needs to be done manually. ...read more.

Middle

Geller, he will also add any new test results straight into the spreadsheet and the spreadsheet will calculate the average and the graphs will be changed. The data will be in the form of numbers and letters. Data flow Mr. Geller will have to add new data and change the average for test results and student improvements. The new information will be added along with the new one this will involve the change in average and students improvements. Macros The macros that will be included in the spreadsheet will be used in the home page and every other page. The macros in the homepage will take me directly to the page that I want to go to by a press of a button and on every other page there is a macro that if pressed will take you back to the home page. This will be extremely useful as it saves a lot of time and is very easy to use. ...read more.

Conclusion

Back up The computer file containing the system must be backed up by a DVD and a USB. There should be two copies just in case one copy will be destroyed there will be a backup and the two copies should be stored away from each other. Any time the system changes it should be saved as a back up on the two USB's. Security There should be some form of security for the system so a password will be put on the system for added safety measures. This will prevent people from changing the system and corrupting some files. If anyone other than the end user wishes to change a formulae or change a worksheet a password will be asked for. The password should be reasonably long to be on the safe side, the password should be at least 5-10 letters and should not be a common name or a password easy to guess such as Geller etc. However it is crucial that My end user remembers this password or does not lose it because it could be potentially corrupted if in the wrong hands. ...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. Different types of technology How I use ICT at home and at school

    Although I haven't seen the effects yet, it could possibly mean that it'll affect my eyes in the future, thus possibly making me need glasses and, if I want to go through with it, laser eye surgery. But I don't really mind glasses too much, so maybe not.

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

    Sarah can use programs like Skype or hardware like a webcam or microphone to call or video call people. She can connect to people while also saving money on what would essentially be adding money on her phone bill. Instead, she can video call family and friends for free.

  1. In this (2b) report I am going to investigate software application, Input and Output ...

    The more memory the camera has, the more pictures can be taken before it is necessary to download onto a computer. On most digital cameras, Sainsbury can see the picture that has just been taken on a small screen at the back and, if the image is not suitable, can delete it straight away.

  2. GCSE Excel Project ICT

    Appropriate Hardware identified This is the computer and printer I believe is suitable for use now and in the future of the Maintenance and the running of this efficient system: Manufacturer: Packard Bell BV Processor: Intel(R) Core(TM) 2 CPU 6300 @ 1.86GHz (2 CPUs)

  1. ICT GCSE POWERPOINT ANALYSE

    Button Selection BMW logo; 9 buttons hyperlinked to sheets named in data section. A textbox with heading BMW. Picture as heading. Tables with specification of car. Two pictures. Large picture heading title. 7 M3 (S) "Button and tab layout as slide 1" Models available.

  2. DTP analyse

    You can insert column guides or guidelines to help position the frames. This keeps the document looking tidy and the layout consistent. Input: The data collected includes: * Pictures from a digital camera of the selected products (perfumes) from the shop * The price of each product * The logo,

  1. GCSE ICT Word - Analyse

    End user (Mr Fielding) will provide advise on which buttons to add. The user will select the appropriate button/option: Create a drop down menu and add buttons to a drop down menu so you can open each template. The VBA code will be needed to open each template as a new document.

  2. a level ict project

    However, Victor has advised me to provide a manual of minimal size and contents in order to avoid confusion and enable the employees to read it swiftly, so they can get on with the job as soon as possible. Hardware and software analysis of current system Currently the end user

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