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

  2. Aids and Barriers to Communication

    that stops unauthorized access, which makes this an advantage for the company because it keeps information private meaning it can help employees improve on their work. Presentation The purpose of a presentation is showing and explaining the content of a topic to an audience in short sharp notes that catch

  1. Database design for a games shop.

    Walcott's letter. Blockgamester main problem was losing data about the game due to the fact he wrote on paper, now Mr. Walcott can easily input data in to the system in a more organized way. Furthermore he can now reply to customers quickly with the customer detail search, with regards to their game overdue.

  2. Reviewing different multimedia presentations.

    not rush through, this means that the pace is variable to what you want it to be. User interaction The user interaction in this Multimedia Presentation is really good as what you have to do is put the body parts where they go in the body which is making you

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    be password protected for extra security; this can be created directly in the Excel file. This is also an advantage as the teacher may want to keep the data safe and protected, so nobody can change or delete data within the file by accident.

  2. Information and Communical technology

    You can use a variety of Font sizes and Font styles in a database, and you can bold them or change the colour. In the database, you can also create reports. Reports are summaries of the data held on a database.

  1. AQA GCSE ICT Specification B

    Combo Box Based On Table- 'CustomerTitle' Doctor Address1 Text 50 Characters - - - - Yes No No - 25 Warfield RD Address2 Text 50 Characters - - - - No Yes No - Bracknell, Berkshire Address3 Text 50 Characters - - - - No Yes No - South East

  2. Graphics Review - Unit 21 OCR

    A good use of colour schemes; as it fits well with the overall atmosphere of the website. Arrows help viewers identify that they are links. Size Details Does not take up much space: small, readable font; options are sparse. ~246*128 pixels; 8.27KB Shows a menu of the most accessed features with the option to view more.

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