• 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

    Technology used at school For technology I use for school, I will be covering the following: * School computer and censoring system * Interactive Whiteboard * Swipe Card Machine School computer and censoring system Our school computers run on Windows XP. The thing that sticks out is the censoring system.

  2. ICT Report 2b: ICT in Organisations

    a Boots store all the way to its Headquarters where the master computer handles all data exchange and transmits data back to the individual cash register. Fibre optics is very fast because, as light is used, the data effectively transmits at the speed of light.

  1. Database Design Guideline

    the two tables is, to click on the 'start', and go to programmes to find 'Microsoft Access'. After, this document is open I will have to select the button which says 'open existing files' then click 'ok'. After this stage, I will have to go on the file where I

  2. ICT Coursework (MarcoS)

    On the second sheet, there will be inserted all the data about loss of money with a chart and the total amount of loss. The third sheet will be about incoming money, also here there will be inserted all the data about it and there will be a graph and the total amount of incoming.

  1. ICT GCSE POWERPOINT ANALYSE

    A textbox with heading BMW. Picture as heading. Tables with specification of car. Two pictures. Large picture heading title. 6 M6 (C) "Button and tab layout as slide 1" Models available. Specifications; Price, Fuel, CO2 Tax, Engine, Eu4, Fuel Consumption, 0-62mph and colours available. 2 pictures of M series BMW Logo from www.bmw.com Pictures from; www.bmw.com Information on car details from old system.

  2. gcse ict unit 2a

    Pay silps are essential as they show how much the worker ahs made and how much tax has been taken away from the worker. Once again the reason why Microsoft Word is used for this task is to make it look more professional and also save ime because the finance

  1. GCSE ICT Coursework Write-up

    Type in what u wish the document to be called (indicated by no.3) then when you have done that press "s" "enter" or click on the "save" button (indicated by no.4). P.S. You may also use Save As... if you wish to save a document that you have already saved

  2. Database design.

    When printing it, it will be professional looking. User Friendly. Take up less space. Visit To The Video Store I went to the video store and gave them a questionnaire to answer. The questionnaire is in Appendix one. From the questionnaire I found out that the owner is only there on a weekly basis.

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