• 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


    Part 5 - Testing I need to test the features in my database so when a user is using the database nothing will go wrong. So here is a table of values showing the tests I took and what results I got from them.


    some of the new changes made to vista makes it hard for people to see if they are old or have problems with their eyes. VIDEO EDITING During this next page I will be explaining the table I have inserted on the following page.

  2. My final report - Spreadsheets.

    I was forced to ask for information from other members of the class and even the teacher, on how to obtain the right answers. However with much practice with these, I was able to master these formulas, and not help was required.

  1. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    I then selected the desired colours and clicked 'Ok'. 3. 'IF' Functions/Conditional Formatting =IF(F9="Pharmacist","0","") Above is an 'IF' Function with conditional formatting that was used in the 'Staff Finance' sheet to highlight those employees who are pharmacists as they are not allowed to do overtime hours.

  2. AQA GCSE ICT Specification B

    they must be lower case and upper case respectively. Were the user to input an email address in caps, the system would recognise the problem and create an error message.

  1. Software Report

    On the next few pages is a more in depth report on the software I used throughout the set up of the system. Brand Name of Software: Microsoft Office 2007 Name of software: Word Processing Description: A word processor is a software application used for the production, composition, formatting and

  2. a spreadsheet for a school trip

    will look like. This is what the Medical sheet will look like. It is a record of all pupils' medical conditions (if any), and consists of any other necessary information in case of emergency i.e. emergency contact numbers. The only cells you can type in are the light turquoise boxes.

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