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.

Related GCSE ICT Systems and Application essays

It doesn't have much of a disadvantage and to make the most of watching television, some sort of digital box is expected and Sky is the best of the best. However, Sky+ can be quite expensive to maintain and it does make you even more addicted to watching TV as it gives you a wider range to watch from.

Boots uses USB ports to its fullest extent, connecting via the ports many useful components e.g. printers, scanners, mice, scientific data acquisition devices, modems, speakers, telephones and so forth. However, the USB port can be hassle some because it allows up to 127 components to be connected to a computer

I would select one of the two tables and then click 'add' and I have to do the same for the other remaining table and then close that table. Then the patients and doctors table would appear. After that, I will have to find out what the two tables have in common.

The employer always said that if he got a computer in again he wouldn't know much about the software or hardware to buy. Aims My aims are * To provide an easy to work database for the users. * To design an organised database.

voice recognition app that displays all the voice commands she needs to say to open the right file. This also works not just for the things mentioned but also to navigate through a lot of the other menus and options.

Feedback from User guide The user guide was decent however I would have been fond of it more if it included screenshots or images because it would have made it less complicated for me. Positive * Most of the things I tested were accurate.

The font colour can also be edited. I will also edit larger image files, through using graphics packages to reduce the file size, or through cropping, to speed up the loading process. I may also have to use a scanner to convert images from a paper based format, to a computer recognisable format such as jpeg.