• 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
  • Level: GCSE
  • Subject: Maths
  • Word count: 4426

Information Technology Practical Exercise 2001: PostQuick Parcels

Extracts from this document...

Introduction

Information Technology Practical Exercise 2001: PostQuick Parcels DESIGN Requirements There are three main tasks that need to be dealt with in producing this new system: 1. It should check and price each parcel consignment 2. It should produce an itemised consignment note for each customer 3. It should produce daily management statistics on the number of parcels, total weight and total revenue Software With this in mind I have decided to use Excel to produce the PostQuick system. Excel is a widely known and used program, and thus there is greater security in using a system produced on this package. It is also likely to integrate with any existing software/any software that may later be added. Moreover, as Excel is so widely-known, if any enhancements need to be made in the future and the original designer and creator is not available to make these changes, then it is unlikely that the PostQuick management will have trouble finding a replacement to make the necessary alterations. The system will be easy to modify and add new functions to. As Excel is such an established package, it is also unlikely that the system produced on it will have many bugs that aren't simple to correct. It is also known to have good access times when retrieving data from a database. The files do not take up much disk space, and thus the hardware specification will not be hard to fulfil. Of course the better the hardware, the better the system's performance will be. As a spreadsheet package it performs the mathematical formulae needed to carry out tasks such as calculating prices and statistics. In addition to its mathematical usefulness Excel performs functions such as filter, subtotal and macros needed to produce the application. These functions will be necessary to produce the itemised consignment note for each customer. Lastly, Excel is easy to use - both to design a system and also for the users (even novices) ...read more.

Middle

Consignment Number Filtered, copy and paste Whole number; greater than or equal to 1. Date Filtered, copy and paste Date; greater than 01/01/2001 Weight Filtered, copy and paste The cells are formatted to 2 decimal places. Price per Parcel Filtered, copy and paste The cells are formatted as currency, and to 2 decimal places. End Address Filtered, copy and paste None Total (for weight and price only) Function 'SUBTOTAL-->SUM' The cells are formatted to 2 decimal places. The price total was also formatted to show currency. In addition, there will be a button called 'Produce Statement.' It will be assigned a macro, so that when a client ID is typed into cell A2 and the button is pressed it will produce the consignment note. The macro will delete the old statement and delete the old filter results on the Parcels worksheet. It will then produce a new filter ('copy to another location' [on Parcels worksheet], criteria is the ID that has just been typed in). It will select the columns mentioned in the table above from the filter results, and copy and paste them in the same order as above. Finally it will produce the subtotal as mentioned above. CONSIGNMENT NOTE (on system shortened to Con. Note) (See attached drawing of proposed design of worksheet [ATTACHMENT 6] and actual receipt [ATTACHMENT 7]) Column Formulae Validation Consignment Number Filtered, copy and paste Whole number; greater than or equal to 1. Weight Filtered, copy and paste The cells are formatted to 2 decimal places. Price per Parcel Filtered, copy and paste The cells are formatted as currency, and to 2 decimal places. Parcel Length Filtered, copy and paste None Parcel Breadth Filtered, copy and paste None Parcel Height Filtered, copy and paste None End Address Filtered, copy and paste None Total (for weight and price only) Function 'SUBTOTAL-->SUM' The cells are formatted to 2 decimal places. The price total was also formatted to show currency. In addition, there will be a button called 'Produce Consignment Note.' ...read more.

Conclusion

Looking at the design and working of the system I feel that the application created fulfils all the requirements set. The system does what it is supposed to do. The system designed: * will both checks and prices each parcel consignment * will produce an itemised consignment note for each customer * will produce daily management statistics on the number of parcels, total weight and total revenue The system reduces the time it would take to do the same tasks by hand. The consignment note especially shows this. It is much quicker to type in a name and press a button to get a receipt than it is to look up all the transactions of a particular customer and copy them out. Usability The system is easy to use. The validation ensures that there is minimum scope for error. Little or no training is required to use the system; it is all very self-explanatory. This shows the presence of a good user interface. As shown above the system reduces the amount of time it takes to carry out a task. It also cuts out tedious and repetitive tasks, which will result in far fewer mistakes being made. The system also gives users quick access to information they need, as shown by the Prices worksheet (quickly gives you access to a current price list which can easily be printed out) and the Daily Statistics worksheet (gives up-to-date information on daily transactions). Maintainability The system can be modified as needed without much trouble. This can be done by anyone with good knowledge of the package Excel. There are quite a few people that would fulfil this specification, so even if the original creator of the application were not around to make the modifications it would not be hard to find someone who could. As the system has been thoroughly documented this is especially true. Overall Overall, this is a very effective system. It fulfils - if not exceeds - the original requirements, is user-friendly and should be relatively easy to maintain. ?? ?? ?? ?? 1 ...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 Height and Weight of Pupils and other Mayfield High School investigations 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 Height and Weight of Pupils and other Mayfield High School investigations essays

  1. Maths Stats coursework

    It is measured on a table like this: Scatter graphs - A scatter graph is a diagram that is used to see if there is a connection between two sets of data. The equation of the line of best fit - The line of best fit is a strait line.

  2. mayfield statistics

    After I complete this, I shall write a conclusion to summarise my findings. Method There are 1183 students in Mayfield but I need to sample only 60 students. The population has been divided into strata according to their year group and gender too.

  1. mayfeild statistics

    I will use stratification to decide upon the no. of boys and girls. Boys: Boys in yr11 x sample size = 83 x 60 = 29.6 � 30 Students in yr11 168 Girls: Girls in yr11 x sample size = 85 x 60 = 30.4 � 30 Students in yr11 168 So I will choose 30 girls and 30 boys from the secondary data I have been given.

  2. Print this Document

    In order to draw the histogram I must calculate the frequency density of the bars. This is done by: Frequency density = frequency ?class width Boys Height (cm) Frequency Frequency density 130 < h < 140 1 0.1 140 < h < 150 4 0.4 150 < h < 160

  1. If Tesco found that they needed to recruit an office supervisor externally, after finding ...

    Female workforce change 1997 - 2010 Female workforce Change % 1997 2000 2010 97 - 00 00 - 10 16-24 25-34 35-44 45-59 60-64 65+ 15,300 23,500 25,400 31,700 3,300 1,300 15,400 21,900 27,000 32,900 3,700 1,200 16,500 19,500 23,200 34,600 4,900 1,300 +0.7 -6.8 +6.3 +3.8 +12.1 -7.7 +7.1 -11.0 -14.1 +5.2 +32.4 +8.3 Source: Cambridge Econometrics, 1997 3.

  2. height, weight, body mass index

    13 4 Male 1.55 43 17.9 68 8 13 9 Male 1.65 51 18.7 73 8 13 2 Male 1.52 43 18.6 102 8 13 2 Male 1.44 50 24.1 13 9 14 8 Female 1.48 47 21.5 20 9 14 8 Female 1.63 47 17.7 24 9 14 8

  1. Coursework: Investigating research questions in the Sport and Exercise Sciences

    men = 1, women = 2). Data is therefore nominal, as participants fall into two categories (dichotomous), either male or female. It is possible to assume from this data type that the researcher remained 'aloof' from the study, reducing the possibly of influencing the results.

  2. Introduction to arodynamics - Investigation into the design features of aircraft.

    These strakes, in conjunction with the upper surface of the engine air intakes will induce a vortex which will maintain lift to very high angles of attack. Figure 9. Lift gained due to strakes b. Intakes. As previously mentioned one important consideration in the design of the F-15 is to operate at high AoA.

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