• 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

    This can develop your interests and make you better informed about all you like. For example, the knowledge pack can give you all there is to know about wildlife, countries etc. Action pack can keep you up to date with the latest action movies or series and comedy can just make you laugh again and again.


    It will also used to summarise archive data for use in charts showing: 1. By gender 2. Form * Data entry form will be able to edit and delete student records. * Conditional formatting will allow automatic shading of cells to give visual message for highlighting grade attained and also table displaying student grades.

  1. Database Design Guideline

    Whipps Cross Hospital will need the different forms as it will be easy to find out any information about them and also updates their database system on the patients and doctors.

  2. Database design.

    I will draw up a table that will help you understand the entity types; Entity Types Example Costumer_ID Unique number Customer_First_Name Customers first name. Customer_Surname Customers surname Customer_Street Street they live at. Customer_Town Town they live in Customer_Post_Code Customers post code Customer_Phone_No Phone Number Video_ID ID Number Video_Name The Name

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

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

    Physical The company will use electronic locks. The second thing the company will use is Id-cards as part of the electronic locks. These id-cards will be used to access offices or the company's documents. The company will also use some kind of Monitoring as part of the data securing.

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

    PowerPoint will be used in creating and using the presentation. Excel is a software which is going to be used for the graph which is going to be put into the presentation. Paint will also be used for the manipulation of data which will be used in the presentation.

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

    With additional buttons and a scroll wheel, increasingly complex software, grouping, moving and deleting files, and even image editing with software like Photoshop. Sainsbury's I.T officer experience said: a mouse is better for fine movement and adjustments than most of the alternatives.

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