• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  • Level: GCSE
  • Subject: ICT
  • Word count: 2980

This spreadsheet is designed for the use of the mathematics teacher to test the results of his/her pupils. It will enable the mathematics teacher to monitor the progress and to predict the results that the students will gain in the test.

Extracts from this document...

Introduction

This spreadsheet is designed for the use of the mathematics teacher to test the results of his/her pupils. It will enable the mathematics teacher to monitor the progress and to predict the results that the students will gain in the test. The column headings to be used will be 'Gender', 'Form', 'weeks 1-5', 'Average', and 'Total'. The data needed to complete the spreadsheet are the names of the students, the gender of the students, the form that the students are in, and the test results that they achieved each week. * It is important to know the names of the students because this will allow the teacher to identify the students who are struggling. * It is important to know the gender of the students because this will allow the teacher to identify which gender is making progress of bigger significance. * It is important to know the form of the students because this will allow the teacher to identify which form the students who need more help are in. * It is important to know the test results because this will allow the mathematics teacher to review the results of the students. I will gain my information from the math's teacher and school registry. I will be using 11 columns and 26 rows. The data needed in the first column is the first name of the students. The data needed in the second column is the surname of the students. The data needed in the third column is the gender of the students. The data needed in the fourth column is the form that the students are in. The data needed in the fifth column to the ninth column is the results that each student gained in the examinations. ...read more.

Middle

I then used some more formatting techniques: I centred the average and total columns and I AutoFit(r) the last four columns (double-clicking between the column letters to make the columns just the right size). Right now, I thought that the spreadsheet looked a bit dull, so I thought I would brighten it up by adding some colour to it: I added colour by highlighting all the cells that I wanted to colour pale blue, then clicking on the fill icon (as briefly explained on page 2) and then choosing the desired colour, then for sky blue followed through the same procedure. For the top row with the column headers, I used light blue, but the black font did not show up very clearly so I changed the font colour. I did this by highlighting the top row of the grid and then clicking on the 'font colour' icon (which is situated to the right hand side of the fill icon) and then I chose my desired colour which was light blue. When I changed the colour of the grid, I realised that the grid lines had disappeared. This made the grid a little more difficult to read, so I decided to move on to some more advanced formatting: I clicked on the format tab from the toolbar, I clicked on cells, and then this new window appeared: First of all, I clicked on the 'border' tab in the new window, then I chose the type of line from the selection on the right, then I clicked on all the parts of the cell where I wanted the lines to be placed in the middle part of the window and then I clicked on 'ok'. ...read more.

Conclusion

I am pleased with the end product and I hope that the mathematics teacher will find the data useful and also clear and easy to read. This is simply the ways in which I kept backup copies of the spreadsheet and how I check my data and system for errors I keep backup copies of my spreadsheet by saving my work on a regular basis. I can save my work by clicking on 'file' in the toolbar, then clicking on 'save as' and then choosing either a folder on your computer or a disk to save into. I check my data and system for errors by using a program called 'Norton System works 2003': This is a very reliable program and it keeps your computer running smoothly. These are the steps I took to keep my work accurate and safe. By taking part in this project, I feel that I have learnt an awful lot. These are just some of the things I learnt. First of all, I learnt how to take screenshots of what I was doing, I learnt how to make charts, I learnt about conditional formatting, I learnt about data validation and I also learnt some useful new formulas. I also experienced some ups and downs while working through this project, once, I saved my work to floppy from my home computer, and the work just didn't open up. I wasted a whole I.C.T lesson because of this and I came to the conclusion that I hadn't saved my work properly or completely. I think that this spreadsheet will prove very useful for the mathematics teacher because it is clear, easy to read, and it contains information very useful for reviewing the successes and requirements of his/her mathematics students. Name: Ashfaq Rasul School: Leytonstone School Centre Number: 13411 Candidate Number: U215991 - 1 - ...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

    It also makes me feel good at myself and also helps improve my own skills. I'm also a massive RPG fan and the Nintendo franchise provides the best RPGs in the gaming world. RPGs mean role-playing games and usually involve you taking on a character and going through the world strengthening yourself up.

  2. ICT PROJECT

    Enter cat To see how validation system reacts to erroneous data Data should not be accepted. User will be told to enter correct data As expected, warning message box appears Data entry form Test and data used Purpose for test Expected result Results after testing 11.

  1. GCSE Excel Project ICT

    allocation of the 'column index number'; we look at the table being referenced, if we remove the buttons, and look at the table with the 'hidden' numbers shown, we can see that it is actually column 2 we needed: Column 1 Column 2 Column 3 Column 4 Column 5 Column

  2. The impact of ICT on an adult in employment. The work of an Atif ...

    But for teaching, it has no other real use that isn't overshadowed by newer technology. Although without it, the interactive whiteboard wouldn't work so in that purpose, it is extremely useful. Swipe Card Machine The swipe card machine is a mechanism that is used to allow Mr.

  1. The impact of ICT on a students activities at home and at school.

    You can easily make and talk to new people online. * Websites are bad for my social needs because if someone sends me a hyperlink or videos/pictures/files, although they may not mean it, these all could come with viruses that can damage my computer/laptop.

  2. The impact of ICT on an adult in employment, including the effect on his/her ...

    day as he has family abroad and it is a free way of communicating to them instead of wasting a lot of money in making international calls. He also needs to be able to send some files to himself if he ever needs to.

  1. Testing and Test Strategy

    Logical This prevents invalid data from being entered into the system. 8 To check if default value is working Logical This makes data entry easier for the end user 9 To test if input mask works for Postcode Logical this ensures validatity of the field 10 To test if required

  2. System requirements analysis

    The system that the receptionist uses is one that was especially designed for the hospital and it came with all the data saved onto it so that it could be used straight away. The system has been in use for three years so it is fairly modern and it has

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