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

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

    JEM Bookshop could use these methods to be more organized and sort by Alphabet; Price; Name or Surname, to find something with a certain criteria. Disadvantage of using spreadsheet to JEM bookshop: - If you insert the wrong data or figures in the cell, all the calculations or other things, will lead to a wrong result.

  2. Reviewing different multimedia presentations.

    Another improvement that needs to be made to the Multimedia Presentation is that they sort out the way that you go back as it took me some time to realise that you had to press the word car to go back so they need to make a clear button for

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

  2. AQA GCSE ICT Specification B

    * XP Professional Operating system * 512MB Memory * 80GB Hard Drive �329.99 HP Deskjet D1460 - Inkjet Printer �18.99 Software Required Windows XP Professional comes with the hardware. Which includes Microsoft Access Justification of Hardware Choices The hardware represents the best value business computer available.

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

  2. designing a website - report

    This allowed me to easily put the navigation buttons on my page. Then I pressed Next >. Then the following window has appeared: Then I clicked Next > again to go to the next step. The last window which has appeared was one where I could choose the properties of the link bars.

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