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

For this project I will be constructing an I.T. solution for Castle Couriers. Castle Couriers is a company, which provides a number of courier services, mainly for car showrooms.

Extracts from this document...


Analysis 4 1.1 Statement of the problem 4 1.1.1 Introduction 4 1.1.2 User Requirements 4 1.1.3 Current system 4 1.1.4 Data Flow diagram of current system 5 1.1.5 Problems with the current system 5 1.1.6 Objectives of the new system 5 1.1.7 Performance indicators 6 1.1.8 Volume of data 6 1.1.9 Hardware and Software 6 1.1.10 End user skill level 6 2 7 Design 7 2.1 Consideration of solutions 7 2.1.1 Manual System 7 2.1.2 Spreadsheet System 7 2.1.3 A specifically designed courier system 7 2.1.4 Access database 7 2.2 Database Design 8 2.2.1 Entity-relationship diagram 8 2.2.2 Table Design 8 2.2.3 Form Design 10 2.2.4 Query Summary 10 2.2.5 Document Summary 10 2.2.6 Macro Summary 10 2.3 Templates 10 2.4 Data entry and Validation 10 2.5 Macros 10 2.6 Security and Disaster Recovery 10 2.7 IT tasks 11 2.8 Schedule of Activities 11 2.9 12 2.10 Test Strategy 12 2.11 Test Plan 13 2.11.1 Function testing 13 2.11.2 System testing 13 2.11.3 Disaster testing 13 2.11.4 End user testing 13 2.12 Test data and Expected Outcomes 13 3 13 Implementation and Testing 13 3.1 Test Results 13 3.1.1 Function testing 13 3.1.2 System testing 13 3.1.3 End user testing 13 4 13 Evaluation 13 5 13 User Manual 13 6 13 Technical Manual 13 Analysis 1.1 Statement of the problem 1.1.1 Introduction For this project I will be constructing an I.T. ...read more.


However, at home, where some aspects of the design will be carried out, I have a newer version of Microsoft Office, and therefore a newer version of Access. This should not cause any problems, however should I wish to incorporate functions not available in the school's version, I will have to do this last. All of the designing will be done in Microsoft Access, with some links to Word, for better quality documents, and Excel, for data interpretation. This is available on all three of the concerned systems. 1.1.10 End user skill level None of the people who will be using the system have any formal I.T. qualifications. Their only previous I.T. experience is based around the use of Lotus SmartSuite. This will be a problem for me because the system I will be designing for them will be entirely based within three programs, Microsoft Access, Microsoft Excel and Microsoft Word. It will therefore be necessary to make the project very simple to use with automatic functions. 2 Design 2.1 Consideration of solutions 2.1.1 Manual System This would be based around data being processed, stored and filed in the form of paperwork, with calculations being manual and documents handmade. -Easily the slowest -Higher risk of loss/damage to data -Complicated and tedious -Lower quality documents -High risk of mis-calculations We have therefore judged that this system would not be suitable for Castle Couriers, as it is far too slow and complicated and will not be better than the current system. ...read more.


Data will be inserted that is valid, invalid and extreme. Sufficient data will be inserted so that each table has at least one row of information. This will test to see if the different masks that have been used are correct or the different data types are correct. Subsequent data will continue throughout the test to make sure that the data is correct. System Testing When the system is complete, the whole range of tests will be repeated. This will ensure that no further problems have arisen. Recovery Testing The computer will be rebooted during procedures to see if data becomes corrupt or lost. If problems are found they can be corrected Acceptance Testing The end-user will be involved at this stage, they must test every aspect of the system to see if it fulfils the requirements that were set in the analysis section. They will be asked to check if each menu is correctly headed, if the system functions correctly and if it is user friendly. Any faults found at this stage can be corrected before the final version is passed on. 2.11 Test Plan 2.11.1 Function testing 2.11.2 System testing 2.11.3 Disaster testing 2.11.4 End user testing 2.12 Test data and Expected Outcomes 3 Implementation and Testing 3.1 Test Results 3.1.1 Function testing 3.1.2 System testing 3.1.3 End user testing 4 Evaluation 5 User Manual 6 Technical Manual Castle Couriers Sam Tibbitts Project Outline ...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. Marked by a teacher

    An introduction to Identity Theft

    4 star(s)

    A contact name of an employee has been acquired by the criminal via a brief telephone call to the receptionist of the company merely enquiring as to who would authorise any advertising. The invoice is then potentially followed up by any or all of the following; demand letters, threats of

  2. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    Many companies tend to just jump into the prototyping without bothering to retrain their workers as much as they should. A common problem with adopting prototyping technology is high expectations for productivity with insufficient effort behind the learning curve. In addition to training for the use of a prototyping technique,

  1. Computing Project

    borrowed Due Date Date 10 characters 16/02/2005 The date a DVD is Due back Rental cost 5 characters �2.00 The price of renting a DVD Data Dictionary - (Members) Name Data Type Length Validation Example Data Comment Title String 5 Characters Max Must Only Contain Letters Mr The title of

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    * Organizational Assignment infotype (0001) * Personal Data infotype (0002) * Payroll status infotype (0003) * Addresses infotype (0006) * Planned working time infotype (0007) * Basic pay infotype (0008) in which you can specify the wage types related to monthly earnings.

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

    Physical Security As well as protecting the data from potential viruses and unlawful use via software security, Riverside also realises it has to protect itself by physical use also. The following security measures are currently in operation at Riverside.

  2. System I designed in order to produce a promotion package for her newly formed ...


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

    a cheque or cash through the post or deliver it directly to Mr Hull. On the new system a simple yes/no check box will be used to verify that payment has been received. Mr Hull is also looking into making the company strictly a phone order company where the only

  2. Computing project - testing my library system

    EF04 was entered the message shown above was displayed since the book has already been issued to another member and it cannot be entered again until the book is returned. 1. Normal Testing 3(Book requested by another member) Test Data : Mcode: 1004 Bcode: DC01 Expected Result : Display Message ?Book has been requested by another member.

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