• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  • Level: GCSE
  • Subject: ICT
  • Word count: 3036

For my GCSE Modelling assignment I have decided to design a Marking system.

Extracts from this document...

Introduction

GCSE Modelling Assignment State of Problem For my GCSE Modelling assignment I have decided to design a Marking system. I have chosen this as Mrs Gerrard (an ICT teacher at Bramhall High School) has trouble entering in every mark of every pupil by hand after each ICT exam or piece of coursework. It is my job to design a system that would speed up this process easily and accurately. I intend to do this by collecting all the relevant typical information that Mrs Gerrard would encounter and then apply it into a working system that she could use. I intend to look at and analyse the current data capture form for collecting marks and design an improved data capture form for my system. My system would act as an "electronic markbook" for a teacher. It would be able to work out final grades based on a set of marks. It would work out averages and even provide graphs and charts to assist the teacher. It would be clear and well presented and would be easy to operate. I intend to achieve this by designing a system that is quick, easy to read and efficient. Investigation and Analysis Mrs Gerrard and the rest of the ICT unit at Bramhall High School need an efficient system that will save time and effort in recording and storing pupils marks. This of course could be applied to any subject department in any school that requires a Marking System. Mrs Gerrard and the rest of the ICT teachers teach 3 GCSE ICT classes. This is what they will have to mark and what I will have to collect in order to design a good marking system: * 1 piece of coursework at the end of Year 10(around August 2002) * 1 piece of coursework in the Spring term of Year 11(around January 2003) * A mock GCSE examination in November 2002. ...read more.

Middle

The important parts of the form are clearly underlined and in bold for easy accessibility. The sections where you write the information have plenty of space for the longest name or surname. In other parts where information is required I have put tick boxes ( ) next to several options where the teacher will have to tick either one. Most of the information needed for the form is required in the form of text but for such fields as exam marks and coursework marks require numeric data. Validation While the data capture form is being filled out and the spreadsheet is being set up mistakes are sometimes inevitable. Therefore validation is necessary to prevent important information being mistyped. In my data capture form you are, at first, advised to fill out the form in pencil to prevent mistakes that cannot be erased. In the actual creating of the spreadsheet errors can be avoided if a validation rule is entered in the appropriate box whilst making a table. You can use the validation rule to specify requirements for data entered into a cell. When data is entered that violates the validation rule setting, you can use the validation text property to specify the message to be displayed to the user. Data that has been entered into the data capture form, which is invalid, can be corrected by my spreadsheet through a simple validation rule. This can be seen here: Possible problems could be resolved when if the operator enters a validation rule saying that certain letters or numbers that refer to a specific field can be entered only. E.g. the "Sex" field, a simple "M" or "F" could be typed instead of "Male" or "Female". This is entered because it saves time and prevents spelling errors. A validation rule would avoid such mistakes. The validation rule can be applied to any field and check any part of the information. ...read more.

Conclusion

For the convenience of the operator my spreadsheet can also be exported onto other operating systems in different formats. My spreadsheet can be made into a Microsoft Access Report or put into a Query where the search function may operate. This can easily be done using these instructions: 1) Close the Microsoft Excel workbook that contains the data you want to use in Microsoft Access. If the Microsoft Excel worksheet contains column labels in the first row, Microsoft Access uses the labels as field names in the new table it creates to contain the imported data. 2) On the File menu in Microsoft Access, point to Get External Data, and then click Import. 3) In the Import dialog box, click Microsoft Excel in the Files of type box. 4) In the Look in list, locate the file you want to import, and then double-click the file. 5) Follow the directions in the Import Spreadsheet Wizard. A sample of this output format can be found in a printout on the next page. By using Microsoft Access I can also create a report by exporting my spreadsheet into Microsoft Access. This can be done by using the methods above. This way a handy professional report can be printed so that the teacher can use it as a formal printout. It could also be used to display averages or totals. A sample of this output format can be found in a printout on the next page. By using Microsoft Access I can also create query which would allow the operator to perform a search as this function is not available on Microsoft Excel. This has many advantages as the teacher can now produce certain statistics, such as: * How many children got grades A-C * How many children got grades D-U * What grades people in a certain Form Group got * Which sex got better overall grades This function can be done using the above method. Except the operator should make a query and then use the following method to perform a search: * Dominic Feargeieve 11B ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Different types of technology How I use ICT at home and at school

    And that's what's special about our school computers and how they run. They also have a variety of programs to use, however, which are extremely useful. How it affects my needs Advantages (How it meets my needs) The main advantage would be the access to any of the computers in all the computer suites with your own password protected account.

  2. System requirements analysis

    Verification It is vital that all the data entered is accurate, it is important that the information/ data entered is double-checked. However, verification does not check if the data entered is correct, if the data that was supplied is incorrect then the entered data will pass a verification check despite being incorrect.

  1. Database design.

    * To design an organised database. * To make user names and passwords for them. * I want to keep it secure so I won't let them have access to any options to be able to edit or delete the whole database. * I will try to keep a paperless shop.

  2. I will be analysing the problems defined by the management in the old system ...

    This is just for reference and statistics. This table will have important details of the customer, the items he has purchased, total price and the method of payment. * A table to hold the different types of items in the company e.g. TV, PC etc. In all these tables a very important feature is validation.

  1. Ict coursework full

    if they want to know, for example, the price of a particular skateboard deck. * The product name, or * The product number (via scanning of a barcode), or * The make of the product. This will allow the staff to search the database for said product, and find out information about it.

  2. ICT Report 2b: ICT in Organisations

    Change the voltage, and the amount of light is changed. There are two ways to produce a liquid-crystal image with such cells: the segment driving method and the matrix driving method. The segment driving method displays characters and pictures with cells defined by patterned electrodes.

  1. GCSE ICT Coursework Booklet

    * Staff will be encouraged to take regular breaks to ensure that they do not get eye strain. * Suitable lighting conditions should be put in place to avoid possible eye problems. * Care should be taken to ensure that staff members' fitness is not adversely affected by sitting at the computer for long periods.

  2. Camelot Restaurant Bookings System - computer system design

    I have used instead a program called access administrator that requires a password to get onto the spreadsheet therefore stopping customers from entering a booking when they come into a restaurant. Test Strategy My test strategy will include the following: * Testing to check that each of my constructed macro's

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