• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

UKAB Remarking Database.

Extracts from this document...


UKAB Remarking Database. AS Level Computing Project By: Peter Spence Candidate Number: 7022 Centre Number: 66631 February\ March 2003 Table Of Contents Part 1 - Analysis (Page 3) Introduction Page 3 Objectives of the new system Page 3 Data Flows Page 4 Constraints and Limitations Page 5 Consideration of possible solutions Page 5 Part 2 - Design (Page 6) Overall System Design Page 6 Database Design Page 7 Definition of data requirements Page 7 Design of input forms Page 8 Report Design Page 9 Queries Page 9 Menu Design Page 10 Systems Flowchart Page 11 Security Page 11 Test Strategy Page 12 Part 3 - Testing (Page 12) Test Plan Page 12 Test Results Page 14 Part 4 - System Maintenance (Page 15) System Overview Page 15 Tables and relationships Page 15 Forms Page 15 Queries Page 16 Reports Page 16 Macros and general modules Page 16 Discussion of test results Page 16 Appendix 1 - Test Data (Page 17) PART 1 - ANALYSIS. A. Introduction The UKAB (United Kingdom Awarding Body) is a script remarking company. They aim to return examination scripts to candidates within three weeks of them receiving the request. The company produces a daily list of re-marks that have not been completed in the three-week period and a daily list of re-marks completed where the candidate's grade has changed. ...read more.


The 1997 version and the 2000 version as these are the two versions available to me. The final system however will be in the 2000 version as it is then easier to access from newer computers. Access will be the program I use to design my system as I can use visual basic with it for applications inside the system. Access also uses relational databases to work and this will be particularly useful as it means I can relate the Script, Centre and Candidate tables together. Hardware To be able to run access 2000 a windows based PC with Windows 2000 or higher with a minimum of 8Mb (Preferably 16Mb plus room for the database to be run at the same time). A fast processor such as P120 will be needed to speed up the movement between the different menus of the system. E. Consideration of possible solutions A database system would be ideal for tackling the UKAB problem, and Access 2000 should ideally be used because it is probably the most widely used version of access. It is possible to create parts of the system using visual basic or a similar programming language, but this is not really needed, as it would involve creating a higher cost for the UKAB because they would need to buy new software to run the system. ...read more.


Town Text (10) Centre Contact Number Text (12) Subject ID Text (5) Unique Primary Key A Grade Boundary Expressed as percentage Number (%) B Grade Boundary Expressed as percentage Number (%) C Grade Boundary Expressed as percentage Number (%) D Grade Boundary Expressed as percentage Number (%) E Grade Boundary Expressed as percentage Number (%) U Grade Below Expressed as percentage Number (%) D. Design of input forms. Three data entry forms are needed for this system to work: 1. frmAddEditCC This form will be used to add and edit Candidate remark details. It needs facilities to be able to: * Add new Candidates to the database. * Edit old Candidates already on the database. * Navigate back to the previous menu. * Print records. * Delete records. 2. frmCntrAddEdit This form will be used to add and edit Centre details, therefore it needs to be able to: * Add new Centres to the database. * Edit old Centre details. * Navigate back to the previous menu. * Print records. * Delete records. 3. frmSbjctAddEdit This form will be needed to input and change old details in the database. Therefore it needs to be able to do the following: * Add new Subjects to the database. * Edit old Subject details. * Navigate back to the previous menu. * Print records. * Delete Records Peter Spence Page 1 of 16 Computing Coursework ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Visual basic

    Then MsgBox "Player O wins", vbOKOnly, "The End" Timer2.Enabled = False lösch p2p = p2p + 1 Timer2.Enabled = True End If End Sub Private Sub Timer3_Timer() 'Update Score Labels Label3.Caption = p1p Label4.Caption = p2p End Sub Task 3 As you research these programs, comment on the programming, (such as selection or iteration, procedures, functions etc,)

  2. Computing Project

    The system has no way off knowing whether the user who has logged on is the person who is really authorised to use this system or not. An alternative method could be to use biometric recognition but implementing this requires a lot of money and may be time-consuming.

  1. GCSE I.T Security Case Study - Riverside Leisure Centre

    This prevents anyone suspicious from getting into the complex and therefore reduces the risk of any harm coming to its customers and their computer systems. Uniforms Also, staff in the complex wear uniform so they are easily recognisable from a member of the public.

  2. Computing Project

    the program is tested, every statement is executed, accuracy of the processing and that the program fits the original specification. This will make sure that the system is running correctly as this is basically using the whole system. I am also going to test the system in a beta testing method, although this will be a small scale.

  1. ICT Sample Work Welcome Centre Requirements

    Tony's role includes creating the rota of when his team are working, taking booking details from customers for future conferences and negotiating prices if applicable. Tony is also involved in creating quotations for a conference booking to inform the customer how much it will cost.

  2. Purposes and Features of a Relational Database

    do and the work on the actual data can be started quicker. Discover Data Discrepancy A database has validation rules in its tables. This means that data will correct, but also two records can be pulled up next to each other and double checked, in case of fraud and incorrect details.

  1. Basic Database Building

    been applicable to the programme and would have made it more informative, as an example though I created one. This can be seen below As said previously, this is accessed from the switchboard by clicking the view total uses button.

  2. AQA Computing CPT3

    The Lift Nozzle & Start Dispensing button starts the petrol pump timer, this will make the dispensed petrol clock (variable - fuelClock) start, incrementing 0.01 each time. It will also allow the customer to pay display (variable - totalToPay) to function correctly by calculating the amount the customer has to pay according to the price per litre (variable - pricePerLitre)

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