• 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. 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. designing a website - report

    the gallery which says in the description that "Layout photos in a slideshow, with thumbnails across the top of a page and a large image underneath." The thumbnails were created automatically from the photos which I have chosen to use in the gallery.

  2. Problem Statement.

    the average test scores o Able to compare the average test scores among the three classes o Mail-merge She stated that she wanted the system given to her in three formats: o Copy on disk o Hard copy (printed copy)

  1. For this task I needed to type. I needed to type because then I ...

    Change fonts to italics For this task I needed to Change text to Italics. I needed to Change text to Italics because then it would look attractive and it will stand out and catch the peoples eyes. Change text to italics in the database you have to highlight the words

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

    - Spreadsheet has tools such as charts and graphs, which allow large quantities of data to be showed clearer. This would help JEM Bookshop, for example if you have a meeting, it would be easier for the audience to look at a chart or a graph with large data than a table, which would be harder to read and understand.

  2. Reviewing different multimedia presentations.

    Use of animation and/or video In this Multimedia Presentation there is a good use of animation as it shows each part of the car clearly in relation to its position in the car which makes the animation good in this Multimedia Presentation.

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