• 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. GCSE I.T Security Case Study - Riverside Leisure Centre

    These are not very expensive and can quickly alert the police of a break in. Security alarms could also be used on all emergency exits so that if they are opened with force the alarm will be triggered and the intruder will either be scared off or caught before any damage is done.

  1. Computing Project

    The measures I am putting in place to prevent data loss or corruption is that I will be outlining to the user to make regular backups so that if in any circumstance the data becomes corrupt or lost he can retrieve the data from a backup.

  2. ICT Sample Work Welcome Centre Requirements

    Customers use the services provided by the Welcome Centre for various reasons from large conferences, to small meetings and training days. 2. Who are the staff at the Welcome Centre and what do they do? Tony Williams is the General Manager, whose role includes creating the rota of when his

  1. Smart Card System

    With lock-and-key, we can specify which users are permitted access to which source/destination hosts. These users must pass a user authentication process before they are permitted access to their designated host(s). Lock-and-key creates dynamic user access through a firewall, without compromising other configured security restrictions.

  2. Computing Project

    Student number Number, 8 A Unique number given to each student for easy reference. Student address Text, 50 Full address of student, including postal address. Lesson code Number 5 A code that determines what sort of lesson they take,

  1. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    * The last type of testing will be to see whether the system meets the end user's (Mr Hull's) requirements. Test Plan: I will now carry out a variety of tests on as many menu options as possible without going hugely over my word limit.

  2. Purposes and Features of a Relational Database

    This means that business can keep track of certain aspects for example: Overdue payments, currently loaned books, and when membership expires. If any of these things were to happen, the database can automatically flag this up for the business. This means the business will get any money they are owed

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