• 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

    The television is also extremely important for games as it provides the medium to connect my Playstation with, thus allowing me to engage in high-end gaming. Without a television, I wouldn't be able to play my Playstation at all or experience Playstation Network.

  2. GCSE Excel Project ICT

    After =G4+G7+G10+G13+G16+G19 has been inserted the sheet should look like this: This sheet is completed in the context of construction, bar the insertion of a button to the final invoice page and naming cell range A3:G19, 'FinalTBL'. The final table looks like this: On sheet7, the only thing that is

  1. ICT GCSE POWERPOINT ANALYSE

    Fade In Timing 2 Textbox (Data Describing Car Information) Unfold Timing n/a Picture 2 (Car Exterior) n/a Picture 1 (Car Interior) 3 Textbox (Car Spec) Entrance: Fade In Emphasis: Shimmer Timing Slide 8: M3 Saloon Order Object Animation Timing or mouse click 1 Header (Picture)

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

    But while Facebook helps, it's also a big web that takes people's concentration away. Sarah now has trouble doing any of her work as she often becomes distracted by Facebook. It not only stops her doing work but also wastes a lot of her time 'apparently socialising'.

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

    And this technology fulfil Sainsbury's purposes and now there are Kroger self checkout are in Sainsbury, Kroger self checkout is also same self checkout, but in self-checkout Sainsbury's staff scan the foods/goods, tools for us, in Kroger self checkout we do it with own ourselves, and now most of the customers use Kroger self-checkout, and me as well.

  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

    has no computer system therefore I am unable to include a brief specification of the hardware nor can I list the relevant software on the system. The first problem is that the end user possesses no system to put the solution on.

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