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

Excel Project (Identify+Analyse)

Extracts from this document...


Identify Problem: Create a computerised spreadsheet using Microsoft Excel (a quiz) for a school because in the school they have to make the quiz hand written, and lose it many times and there are too many papers. So to, solve this problem I will create a computerised spreadsheet. Objectives: * To have multiple spreadsheets to have different functions * Contains formulae to carry out the calculations on data and update related cell values * Need a look up function, in order to link between spreadsheets. * Make it user friendly so it easy to navigate and clear to understand * Include a logo * Make spreadsheet password-protected fro security purposes * To be able to create graphs based on the scores * Use freeze panes to facilitate scrolling down records, clearly * Have conditional formatting to react to the changes in the value in the spreadsheet * Data Validation to format cells for your data-type (string, currency) ...read more.


The teacher might need to take some classes in order to fully understand how the spreadsheet works, and how to fill in the questions and answers. Alternative solutions: I could have just used paper, a database or just another manufactures software like Microsoft Excel. But I decided to use Microsoft Excel because a spreadsheet will do calculations with a great degree of accuracy. A spreadsheet takes up less room than a filing cabinet. A spreadsheet can automatically generate graphs. However, The disadvantage of computerised systems are that they require training to use and to produce, they rely on electricity and there are security concerns about systems on networks (people can "hack" them). I didn't use paper because it would take too long, and have many loose papers. ...read more.


Input: It is the data that goes in and how. For example, I will input data for the quiz on Microsoft Excel. Some of it goes in by user formulae in cells, headers type etc. Some of input will be by cells by result of updated formulae (calculations) Output: It is the Screen for showing us what is happening on computer. Saving your work is also an output. Print outs of spreadsheets is also an output. Process: It is a formulae carrying out calculations and updating value of cells. Validate: To validate means for computer software to check that the data being input is sensible. An example is validating cells in correct type. Verify: Verification is the process of checking that input data is correct. It is normally carried out by a human who visually compares the data with the source document. To check spreadsheet, is an example of verification. Also user feedback is verification. ...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

    Recalling Information From Archive When a customer returns Alex checks through the archive to see their previous order and purchase, this happens occasionally but mainly with the companies. Alex then gets his 'Archive' folder and searches through for the relevant sheets of paper however, this could potentially take a long

  2. ICT notes

    If something unexpected happens, the system may not be able to 'think for itself'. In the health centre the possible control systems are: � A security alarm system which may have an infra-red sensor which sends a signal when the beam is broken.

  1. a level ict project

    However, it may appear that 1st normal form hasn't been reached because of the repeating employee field, (i.e. employee 1 and employee 2); this isn't true because these two separate fields are required to show the names of the one or more employees who took part on that job.

  2. GCSE Calculator Project

    In access it's possible to allow privileges to different user groups. The groups can be "Users" and "Admin". This is very complicated process .For the purpose of this calculator it's acceptable to simply hide the design options from the silver surfers.

  1. GCSE Book DataBase Project

    or dates (e.g. 01/01/07, 01 Jan 2001, etc.) the field length can be changed. It is easy to change data in a field, which I will need when I reuse the data. I can set it to a default value for every field.

  2. GCSE Database Project ICT

    laminated the degradation issue would decrease greatly, but changing information would become a lot harder. The secretary should be forced to insert all patient information in block capitals to prevent confusion. The dentist could write the date on a post-it note or just simply tell the patient his/her next appointment date.

  1. Database project

    Text 20 TelNo Text 13 DOB Date/Time Short Date Address Text 45 tblPlanes Field Name Data Type Size / Format / Validation / Combo / other PlaneID AutoNo Primary Key PlaneType Text Combo box SeatNo Number Integer MpG Number Integer Fuelcap Number Integer Flytime Number Integer TblRentals Field Name Data

  2. ICT Project 1A

    And with an EMA award, 3 very successful singles and an amazing album, the world has to keep up with their quick rise to the stars! PEOPLE IN THE BAND Next I wanted to go into more detail about who was in the band.

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