• 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. a level ict project

    Garage Job * The view should be set as Design * The data mode shall be set as Edit Macro design to find manufacturers of the vehicles registered in the database: * Macro Action is to be OpenQuery * The query name to select is Employee/Customer address search * The

  1. Tennis Tournament UNIT 1 GCSE ICT coursework

    In my previous system I used a calculator which took a very long time. There was also the risk of human error. Using a computer would save a lot of time and effort. It would tell me how much to charge for the event if only a few competitors turned up.

  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. The impact of ICT on a person with special/particular needs

    With all these things she can't do, TV is her escape. Sarah's main form of entertainment comes from television. It occupies her time and allows her to spend less time thinking or worrying about her problems. It's her leisure time and as Sarah cannot find much leisure elsewhere, it is very important in meeting the need to entertain Sarah.

  2. Computer Systems Assignment 2

    You can set your PC to auto backup, auto defragmentate and auto anti-virus, anti-spyware and all the other anti programmes. You can have programmes to create 3D models, and you can make Hollywood actresses look like they haven't eaten for a month.

  1. Ict Unit 2b

    This is a quicker process so, it makes it easier for Whipps Cross Hospital to send and receive documents.

  2. ICT car insurance quotation System Coursework

    Which will be calculated using formulas, and formulated to give a clear and professional Quote. �The system will be able to store customer details separately for future reference. �The system will use formulas which will be the most advanced formulas to give quick and accurately calculated quote.

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