• 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...

Introduction

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.

Middle

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.

Conclusion

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. ICT PROJECT

    * Protections of cell so that user cannot accidentally delete information. Statement of Input, Processing & Output requirement The input would be: Personal Details: * First name * Surname * Gender * Date of Birth * Form * Roll number Student marks: * Assignment marks Maximum /minimum mark * Grade

  2. Computer project Alevels

    the employee is needed and when needed editing the information keyed in. Every time the data is edited it is being updated and stored. An error report is produced when an error is detected while validation step is performed. This diagram shows the process and procedures which takes place when

  1. ICT notes

    It may contain a company logo, search box etc Menu System This area provides navigation around the site Content Area The main content of the web page is here. It may contain, text, images, sound etc. Footer This area will often contain copyright notices, terms and conditions etc.

  2. GCSE Database Project ICT

    and mail merge a letter informing the child that they can book for appointment with the relevant doctor to fit braces (Dr Bragg). Analyse (9 marks) Appropriate Software identified The software being used is part of the Microsoft Office suite (Microsoft Access and Microsoft Word and Microsoft Excel)

  1. GCSE Excel Project ICT

    Human Error In addition, after the customer has specified the parts he/she wants into the computer, sometimes, when he is copying the name of a product down, he could make a mistake (E.g. RAM 1 GB could be an error for RAM 2 GB).

  2. Database project

    Using range check validation This controls he range of data that can be entered so there can't be mistake like giving a customer extra time. Input, processing and output needs Inputs This is the data that I will be processing: tbl Customers CustomerID FirstName SurName TelNo DOB Address 1 Farhat

  1. ICT Project 1A

    it has been said that when the boys were younger they would have to wear t-shirts with their names on for people to tell them apart! Bill and Tom now have very different styles, with Bill being renowed for his dark 'Emo' look and Tom seeming to be much more known for his layed back almost Hip Hop look.

  2. ICT GCSE POWERPOINT ANALYSE

    A textbox with heading BMW. Picture as heading. Tables with specification of car. Two pictures. Large picture heading title. 6 M6 (C) "Button and tab layout as slide 1" Models available. Specifications; Price, Fuel, CO2 Tax, Engine, Eu4, Fuel Consumption, 0-62mph and colours available. 2 pictures of M series BMW Logo from www.bmw.com Pictures from; www.bmw.com Information on car details from old system.

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