• 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
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  • Level: GCSE
  • Subject: ICT
  • Word count: 7709

Spreadsheet Technical report. My task was to produce a grade book for primary school teachers; the aim of this spreadsheet was to allow teachers to input scores and record student progress.

Extracts from this document...


Spreadsheet Technical Report - Teacher Grade book. My task was to produce a grade book for primary school teachers; the aim of this spreadsheet was to allow teachers to input scores and record student progress. In this report I will attempt to explain the processes I went through to produce the grade book. Step 1 In order to create a professional, user friendly grade book, I firstly wrote a list of the items I wanted to include in my spreadsheet using Microsoft Word, before I started creating it. I did this so that I could make sure I had included all the functions required, as I changed their colour from red to black once I had completed that function. Step 2 Once I had completed this, I wrote down what functions/data each individual page would contain, and the order each worksheet should go in, in Microsoft Word. I did this because it allowed me to have a chance to analyse the amount of information and functions which were needed on each worksheet. It also have me the ability to understand the order in which my worksheets should follow, for example, if I had put the maths report after the english worksheet instead of the maths one, then it would not have run in a logical sequence of events, and would have most likely confused the user (the teacher.) I did the worksheet layout before creating my spreadsheet, as if I had not prepared and gave a structure to my Spreadsheet beforehand, I may have made numerous mistakes and I would have had to of gone back and changed it afterwards, or more unfortunate, maybe I would have had to of started a new spreadsheet altogether. Step 3 Once I had finished and knew what I was going to include, I was then ready to tie it all together and form a professional grade book in Microsoft Excel; the reason why I decided to create a grade book in Excel is because It is ...read more.


High-lighting the cell I want to create the list in, and clicking "data" in the top toolbar. A list then appeared offering me different options, I then selected "validation." 2) Under the validation criteria, I clicked the arrow next to the "allow" box and selected "list." Then I scrolled down to the source box and entered in the cell range which beheld the information I wanted in my drop down list, and pressed ok. My drop down list then appeared in my selected cell. The reason I made a drop down list was because it saves the teacher time and effort in typing a students name into the lookup table, every time she wants to search for a particular pupil. Furthermore, if two pupils had the same name, it would allow the teacher to look at both students by displaying the two surnames and allowing the teacher to click one depending on which child she wanted to look at, whereas if I did not have a drop down menu and just a VLookup table, then it would not have displayed both student records. The reason I did not create a student number for each child is because the teacher probably will not be able to remember the number each child is, and will have to go to the top of the worksheet to find out what number that particular child is, so it is easier to have the "Surname" as the main column and lookup value, as the teacher will know the child's surname. Also the teacher may not know how to spell a particular name so instead of guessing or looking through the list of student names to try and find the spelling, she can just look at the drop down list and click the one she wants. The reason I decided to include a VlookUp table in my spreadsheet was because it allows the teacher to look at a particular student, without having to scan through the student names and look across ...read more.


In conclusion, I thought my spreadsheet was appropriate for my target audience. The only area, during the production of the spreadsheet, which I found difficult, was the VLookUp, as I did not realise that the first column of my table array started at 1, I thought that column A was always 1 even if it was not the first column in the table array. If I was to create an improved spreadsheet, I would use INDEX/MATCH functions instead of a VLOOKUP, as an index/match function is stronger than a VLooup and it allows you to search for more than one criteria, whereas a Vlookup does not, and the teacher may want to look up more than one student. INDEX/MATCH functions are used together as a tool to extract data from a table, so this would be more suitable than a VLOOKUP. Moreover, I am glad I later created a macro so that the teacher did not have to go back to the top of the filter on the annual report worksheet, every time she wanted to undo the filter; the macro allowed the teacher to easily undo the filter without consuming time. Furthermore, I am also pleased that I chose to use an Autofilter rather then an advanced filter, as with an Autofilter it easily allows you to change what you want to search for via a drop down menu, whereas on an advanced filter you would have to keep changing the criteria for the filter. So I believe the Autofilter is the best option considering the target audience, as it is easier to use and you need functions which are user friendly. Additionally if I was the improve the spreadsheet, I would make the subject worksheets look more presentable with colour as at the moment the background is plain white, so I would format the cells to a particular colour, although I would still make sure it still looked professional. Finally, I believe that the spreadsheet is user friendly and fit for purpose. ?? ?? ?? ?? Laura Jayne Ford 10JB Spreadsheet Technical Report Archbishop Blanch CE High School ...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 Software 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 Software essays

  1. Planning a spreadsheet database for a gun shop.

    The business is running more smoothly and the accounts are arranged much well than before. I appreciate your hard work. Now the customers won't have to wait and we won't be losing customers. it is also easier for me and my colleagues and we are more organised, thank you for creating the spreadsheet for me.

  2. The aim of my project is to make the task of the allocation of ...

    It will show clearly whether or not the show has been a success (as a profit). 4) Most choices can easily be selected via drop down menus which will change the whole sheet according to the pre-determined pricing of the item selected.

  1. Design a spreadsheet that can be used by a school tuck shop.

    10 =G16*F16 7 10 =G17*F17 5 9.89 =G18*F18 VAT 17.5 cost of order VAT =G3*F3 =H3/100*$I$1 =G4*F4 =H4/100*$I$1 =G5*F5 =H5/100*$I$1 =G6*F6 =H6/100*$I$1 =G7*F7 =H7/100*$I$1 =G8*F8 =H8/100*$I$1 =G9*F9 =H9/100*$I$1 =G10*F10 =H10/100*$I$1 =G11*F11 =H11/100*$I$1 =G12*F12 =H12/100*$I$1 =G13*F13 =H13/100*$I$1 =G14*F14 =H14/100*$I$1 =G15*F15 =H15/100*$I$1 =G16*F16 =H16/100*$I$1 =G17*F17 =H17/100*$I$1 =G18*F18 =H18/100*$I$1 VAT total cost of

  2. Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve ...

    - They can calculate sum easily and correctly (as long as there aren't any human errors made). This makes it more reliable and accurate. Especially if it is a business, Because JEM Bookshop could make a great loss if it was done manually which would be less reliable, whereas using

  1. Reviewing different multimedia presentations.

    Navigation This Multimedia Presentation is quite easy to navigate but there is a problem with going back. This is an issue as it takes time to find out how you go back in the Multimedia Presentation. 5. Improvements to the multimedia website/product to help meet the product's aims.

  2. Appropriate Software To do this project I am going to use excel because ...

    This is the money made from all the products over the past week. Income: This is calculated by multiplying the selling price by the no. of units sold. This is the money made from a product over the past week without subtracting its buying-in price.

  1. AQA GCSE ICT Specification B

    Address3 Table 1 - Yes - - - Address4 Table 1 - Yes - - - Postcode Table 1 - Yes - - - PhoneHome Table 1 - Yes - - - PhoneMobile Table 1 - Yes - -

  2. Logo Report

    It also has many unique features e.g. the magic wand and exciting paintbrush options like; fluid splatter, confetti etc. I will make 3 logos using this software and then I will choose which one is the most effective, compact, bold and attractive logo but I will also need to remember

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