• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1849

computerised spreadsheet for pupil attendance data

Extracts from this document...


Coursework A Teacher's Class Attendance Register And Mark Book Spreadsheet Project Plan GCSE Information, Communication and Technology 2005 NAME OF STUDENT TABLE OF CONTENTS Identify Analysis Design Implementation Evaluation IDENTIFY My friend's class teacher named Dave has to take a register every day and has to keep marks that students have achieved on a regular basis. Dave finds it very hard to keep all his papers organised, as they tend to overflow and get messy. Because of this it can be an agonising process trying to find a students set of results or attendance marks when they are needed. He recently received a new computer from his Dad as a present. My friends wants me to create a computerised spreadsheet for him whereby he could keep attendance of pupils and their grades and also create graphs out of the information to simplify it. The more primitive way to solve this problem would be to create a more organised and effective manual system, like a folder with various sections in it to identify different pupils and grades that they have. However it is not the ideal way of solving this certain problem as it may prove to be just like his previous method. Another way by which the problem could be solved would be to create a spreadsheet system. The types of software packages I am considering for the use of this project are as follows: Database, DTP, Word Processing and Spreadsheet Each piece of software has its downsides and its positives. ...read more.


My software requirements are as follows: Microsoft Word Microsoft Excel I will use the software above as they are the best suited for my requirements and is what is needed for a spreadsheet. On the spreadsheet I will use two sheets, one to record students' attendance and one to record the students' marks. On the attendance sheet I will set up: A column that incorporates a formula to calculate the attendance of each student as a percentage at the end of each half term. The names of the students in the class The dates of when the lessons take place A column that incorporates a function to calculate a running total of the number of sessions attended by each student each half term On the marks sheet I will set up: The names of the students in the class The titles of the Units A row that incorporates a function to calculate the minimum mark for each unit A row that incorporates a formula to calculate the range of marks for each unit Columns, which use the IF.... THEN function to produce a final grade. A column, which calculates using a function the running total of marks for each student A row that incorporates a function to calculate the average mark for each unit A row that incorporates a function to calculate the maximum mark for each unit The spreadsheet is designed to be accessed on the computer and to be upgraded on the computer. ...read more.


EVALUATION Through out this project I have learnt a great deal and in evaluating what I have done I believe that I completed the objectives that I was given, by Dave my friends class teacher, to the fullest of my ability. I have learnt how to test a spreadsheet and the various aspects that I should focus on. I have learnt how to design and create a spreadsheet, applying formulas to cells in order to work out calculation for me. However to get a clearer picture if the spreadsheet worked appropriately I had to get some feedback from the user. I sent an E-mail to Dave asking him what he thought of the spreadsheet and if it worked better then his manual system. I asked him to send me his reply and it said: "Thanks kid, that new spreadsheet thing works wonder, when I get the hang of this ill use it in the future because it saves me a lot of time" The improvements and extensions that I could have made to the coursework would have been to have made a printable version of the spreadsheet so that the teacher could use it in his folder if he was not used to his new computer. After reading the letter from Dave I have decided that numerous spreadsheets should be used all around for a much easier way of doing things efficiently and I believe that I have learnt a substantial amount in this project and I hope to use those skills in the future. ?? ?? ?? ?? Information, Communication and Technology ...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.

    for the product but instead of re-tying the formulae and functions I can drag the bottom right hand corner of an active cell in the correct column and the formulae will duplicate itself into the cell providing the correct equation for the cell.


    See if a form will be created with these fields - Address 1st name, Address 2nd name and Surname and ID. I expected to see a form produced with the Address 1st name, Address 2nd name and Surname and ID.


    There are several good reasons for why they're both good but the Dell Precision T7400 is more high spec and that's what makes it stand out in quality and quantity. The hard drives are tremendously different in size the Dell Precision T7400 has a 750GB hard drive where as the

  2. AQA GCSE ICT Specification B

    It is new, which means parts and servicing will be readily available, it has enough running capacity to work fast and safely- not crashing. It is of a similar design to the average home PC, making it very easy to use.

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

    To do this we will simply look over the many formulas which prevents the user from requiring a calculator, these include the simple formulas like the total amount of people multiplied by the price of sitting in a certain place and their class e.g.

  2. Payments Spreadsheet task. - formulas and fomatting

    Flights Spreadsheet a) Where and how the data was obtained:- To obtain the data I searched on Google for "flights from Belfast to London" and ended up with three main websites which were www.expedia.co.uk, www.opodo.co.uk and finally www.kelkoo.co.uk.

  1. Selecting the best software for a theatre business.

    This can mean they he could have more information shown in a smaller space. Performance indicators Excel is fit for purpose; it will fulfill the needs of the task. This software will be the easiest to use in this particular case because it meets the needs of the user.

  2. Graphics Review - Unit 21 OCR

    Suitable since everything is located on the homepage. All the user has to do is navigate through the options to go anywhere around the site. Suitable as the nav.bar contains all of Windows products. All user has to do is scroll over 'Windows Family'.

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