• 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. GCSE Excel Project ICT

    Alternative methods of output considered Display (on Screen) There are many alternate methods of how the data on screen can be displayed to the user and the secondary user (the customer). The information can be displayed on screen, e.g. the user makes his order and saves it on the computer so that Alex can view later.

  2. a level ict project

    The query function is so easy and effective to use training is not necessary to do it, the help provided in the software package will suffice. Data Flow Diagram of proposed solution Normalisation For the database, I have used normalisation to formulate the most effective design possible for a relational database.

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

    Design (refer to hand drawn designs) Person 1 Person 2 Person 3 Design 1 This design is very good. It's easy to follow and it's clear. And the colours are perfect This design is okay .It's clear and simple. looks like normal invoice This design looks perfect and it is very clear.

  2. System requirements analysis

    When you click on the images next to the doctors', it takes you to the appointments page with the aid of macros. On the appointments page, there are several forms of input. When choosing an appointment, the information is being inputted into the system.

  1. Database Design Guideline

    making mistakes in my database this is why I think a validation rule is important in my database. ==> Relationship- A relationships works when you extract information from both of the tables. It is a common link between the two tables.

  2. GCSE Calculator Project

    So now I will be saving my work on to a memory stick. I will purchase a 128mb memory stick as it is cheaper than the others and I don't need much memory to hold the work. The one I'm going to purchase is underneath.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    entire book, date of the arrival of the book is written, date of purchase, accession date are written.. When the new books are bought under the demand of the member the stock file is updated. SUPPLIER FILE: Contains the details of the supplier of the books bought.

  2. Different types of technology How I use ICT at home and at school

    text due to the fact that they can see how much I use and who I call. MSN not only takes away this limit but makes it completely free. It gives me privacy to do what I want and is completely free for what otherwise takes money to do.

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