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

    data mode shall be set as Edit Macro design to find a vehicle by its registration: * Macro Action is to be OpenQuery * The query name to select is Vehicle License Plate search * The view should be set as Design * The data mode shall be set as

  2. Tennis Tournament UNIT 1 GCSE ICT coursework

    It would also be easier to find out how much profit I will be making. When I come to order food and drink or other products, if some stock didn't arrive I could easily change the price of other products to make up for the loss.

  1. System requirements analysis

    The doctor can view the patient records and sort them in whatever way he/she wishes. The doctor can transfer any additional data that he/she may have entered by connecting it to the computer and using the 'sync' function. Map of Software- Spider diagram Map of Software-contents of booking software at the bottom of the booking software, the tabs (shown above)

  2. The impact of ICT on a person with special/particular needs

    Technology used for social use For technology Sarah uses for her own social use, I will be covering the following: * iPhone 4 * Facebook IPhone 4 The iPhone 4 is the latest upgrade of the iPhone series. The iPhone is a touchscreen smartphone developed my apple.

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

  2. Ict Unit 2b

    patients in Whipps Cross Hospital and there families. > Fax Machines is a device that sends and receives printed pages or images over telephone lines by converting them to and from electronic signals. . Fax machines are very essential in hospitals because that way the doctors can send the patient's

  1. ICT car insurance quotation System Coursework

    �The font of the text wills all be New Times Roman; but size may vary between worksheets. �The system will be able to add VAT onto the final price to give a Total Cost. � VAT is 17.5 % multiplied by the total cost to give a final cost.

  2. Developing the Mathematics Curriculum: Using ICT to teach angles

    I would use the 'make the angle game' in this resource. It would be a group activity whereby, in groups of 2-4, they have to send a member of their team to the board. The pupil is then not allowed to look at the angle, but has to create an angle as close as possible to the desired (and stated)

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