• 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


    * I had to use the mail merge wizard to set up the mail merge fields and so it worked. Microsoft Access (for database) * I had to use the insert a button feature so the macro could be started easily * I used a macro to run the query and set up the appointment letters in word.

  1. AQA GCSE ICT Specification B

    For instance, a credit card number can only have 16 characters. If a user added an extra character by mistake, the system would recognise this as a 17th character and not allow it. Format Check Applies To Email Address Postcode Evidence of Implementation Justification A format check ensures that the

  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.


    Another disadvantage is the fact that it takes a considerable amount of time to switch you system to Linux. You might also find that a lot of the hardware might not be compatible with Linux Windows Vista Ultimate 800 MHz central processor 512 Mb RAM 15Gb free HDD space CD-ROM

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

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

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

    I selected 'Next' in step 2 then in step 3 I typed the chart title and labelled the X and Y axis. After clicking 'Finish' I right clicked on each separate bar of the chart and seleceted 'Format Data Series', which opened up the formatting dialogue box.

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