• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1304

The aim of this project will be to design and implement a spreadsheet for Mrs Coston, the maths teacher at kelmscott school.

Extracts from this document...


The aim of this project will be to design and implement a spreadsheet for Mrs Coston, the maths teacher at kelmscott school. Her reqirements include one interactive secure document which contains information that can easily be amended at any time. Due to time constraints e.g preperation for exams, homework etc, the document should also contain automatic mathematical calculations to save time and improve accuracy. Advantages of implementing a computerised system includes the folowing: 1) It takes up less space and there is no need for extra cabinets 2) More than one person at a time can access the data from their network 3) The data will not get lost or misfiled unless someone deletes it 4) Reports can be generated very quickly. Disadvantages of using a paper-based system these are: 1) Takes up a lot of space 2) Searching for data can take a long time to find 3) Only one person at a time can access the data 4) Data can easily get lost or misfiled Based on my requirements, I have decided to use Microsoft Excel 2000, this will allow me to incorporate all the requirements above and additionally provide added features, e.g. ...read more.


2) Once the formulas have been added it is used to define the percentage grade (e.g. points divided by total points available x 100) 3) When the percentage has been established this is then compared to the grading list to define the final grade. 4) Depending on the grades, the teacher will therefore declare if the pupil has failed or passed. The diagram below illustrates what data will be the input and what will be the output: In looking at the input of the data I will need all the information from the teacher to add to the spreadsheet so I can give her an accurate outcome. The output will all depend on me, as I will need to be very careful when adding all the data, as all the information will need to be accurate and correct to get the right outcome. (E.g. if I have a small mistake when entering the pupils marks it will the effect the whole process and the teacher will get the wrong grade for the students.) Hardware needed In order for me to make a spreadsheet I will need all the hardware below VDU - This will be used to show me all the information in the computer I have entered and use the Windows Icons Menus and Pointers. ...read more.


From the formulas in my design I prepared my a spreadsheet not making a lot of changes to my first idea but taking in context Mrs Coston's requirement and comments when I did a questionnaire on her. My first design looked like this: In looking at my design I can see that some errors have occurred, even when I did this using my formulas. I received the errors in the grade column as when I entered the input data of the percentages then the grade column should have automatically filled in but this did not happen. When I did one of my tests as I entered data from column 9 and downwards I received errors, these were not expected so I had to alter my formula a little in order for the output data to occur fast. The way I corrected this was by placing the dollar sign ($) in front of specific numbers when doing the calculations e.g. my previous formula for working out the pupil's grades was =LOOKUP (D2, H2:H10, I2:I10) this formula produced the mistakes shown in the screenshot above so I modified the formula to: =LOOKUP (E2, I$2: I$10, J$2: J$10), the new formulas outcome is shown below in the second screen shot. The dollar sign is an absolute cell this is used so the computer can refer to one particular cell. ...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

    of moral values from shows with sex, violence and other inappropriate material * Shows rated above my age group can still be easily viewed * Gives a skewed vision on reality such as unrealistic teen drama * My analogue TV will become redundant after the digital switchover Conclusion Overall, television is an extremely bad and addictive piece of technology.


    * Chart /Graph: can be used to display output of information such as averages, predicted grades etc. * The user wants the system to be as error-free as possible. Excel's Validation facility will allow me to set up range validation to control data input when entering student personal details, overall mark etc.

  1. GCSE Excel Project ICT

    there are many other programs that could substitute for the MS Suite, but we use MS Suite because it is easy-to-use and is the 'typical´┐Ż choice of program to use. Excel will be used for the invoice function, which will enable the customer to select the parts and put them to order.

  2. Database Design Guideline

    if I want to find out certain type of illness witch maybe 'ENT' I will enter this information in the criteria row like this, ="ENT" (without leaving any gaps). o Query 2 Table Used Doctor and Patient Query Criteria A doctor who's treating a patient in blue ward suffering from heart damage.

  1. Database design.

    Each entity has zero or more attributes that describe it, and each attribute describes exactly one entity. Each entity instance has exactly one value - possibly NULL - for each of its attributes. An attribute value can be a numeric, a character string, a date, a time or some other basic data value.

  2. Computer project Alevels

    This diagram shows the process and procedures which takes place when displaying the information about the items and updating when items are bought by the company. Also this diagram shows how the purchase orders are printed and sent to the suppliers when items are needed.

  1. Producing documents for a company. Spreadsheet, Invoice and Website.

    This program also provides me to do graphs and to look up products. Data collection Every time a customer buys something their details will be entered into a database. General data flow The data required from the customers are: (From customer)

  2. I am creating and producing an online interactive guide presentation on Chelmsford to help ...

    Additional hardware also includes :- a sound recorder to use for the initial presentation and to use for future updates. Additionally a digital camera and a video camera are required. These will be used when the presentation needs to be updated such as the videos or pictures and for self taking videos and pictures required for the presentation.

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