• 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
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  • Level: GCSE
  • Subject: ICT
  • Word count: 5846

AQA GCSE ICT Specification B

Extracts from this document...

Introduction

AQA GCSE ICT Specification B Name: Duncan Hicklin Candidate Number: [Enter Number Here] Centre Number: 51347 Contents Description of the task to be attempted 3 Initial Problem Definition 3 Background to the company 4 Details of the task to be attempted 5 Analysis 6 The Current System 6 Results of discussion with user 7 Possible Solutions 9 Specification of Solution 11 System Overview 11 Operational Scenario 12 Evaluation Criteria 13 Design of the ICT System 14 Table Design 14 Table Relationships Error! Bookmark not defined. Query Design 16 System Navigation 20 System Tasks 21 Implementation 22 Hardware and Software Required 22 Data collection, data capture and input 25 Data verification and/or validation 27 Data and/or program structures 28 Output format 30 Testing 30 Evaluation Criteria 33 Test Plan 34 Testing Against The Test Plan 38 Evaluation 39 Criteria 1 45 Criteria 2 46 Criteria 3 47 Criteria 4 48 Criteria 5 49 Criteria 6 50 Description of the task to be attempted Initial Problem Definition Initial Fault Potential risks/difficulties if fault remains unresolved A lot of space is needed. Space for system backups is also required. Company growth will use yet more space, money is wasted. Further space is needed in order to store backups for the system. Time is wasted. Many man hours are wasted because of inadequate filing systems and vast amounts of paper to sort through in order to find each document. More staff are needed. Staff are needed to man and maintain the system, this costs money. Human error is made much more likely. Human error, for example under-pricing an item, can reduce profits and bring the company into disrepute. Accessing the system is difficult. Only one person can access a document at a time, this can waste time. There is a risk of losing records. Potential risks, for example a fire, could completely destroy the system. Files can be lost or filed in the wrong place. ...read more.

Middle

- Email Table 1 - Yes - - - Price Table 1 - Yes - - - Personalization Table 1 - Yes - - - Colour Table 1 - Yes - - - PaymentType Table 1 - Yes - - - CC Number Table 1 - Yes - - - PersLength: IIf(IsNull([Personalization])=True,0,Len([Personalization])) - - Yes - - - PersCost: [PersLength]*0.25 - - Yes - - - NetCost: [PersCost]+[Price] - - Yes - - - One Customer Query type: Select Tables included Table 1 Purpose of query: Creates records for the order lookup, delivery note and receipt. Field Table Sort Show Criteria Or Or Order ID Table 1 - Yes [Forms]![Order Form]![OrderID] - - CustomerFirstName Table 1 - Yes - - - Date Table 1 - Yes - - - CustomerSurname Table 1 - Yes - - - CustomerTitle Table 1 - Yes - - - Address1 Table 1 - Yes - - - Address2 Table 1 - Yes - - - Address3 Table 1 - Yes - - - Address4 Table 1 - Yes - - - Postcode Table 1 - Yes - - - PhoneHome Table 1 - Yes - - - PhoneMobile Table 1 - Yes - - - Email Table 1 - Yes - - - Price Table 1 - Yes - - - Personalization Table 1 - Yes - - - Colour Table 1 - Yes - - - PaymentType Table 1 - Yes - - - CC Number Table 1 - Yes - - - PersLength: IIf(IsNull([Personalization])=True,0,Len([Personalization])) - - Yes - - - PersCost: [PersLength]*0.25 - - Yes - - - NetCost: [PersCost]+[Price] - - Yes - - - Dates Query type: Select Tables included Table 1 Query 1 Purposes: Provides data for the sales summary report Field Table Sort Show Criteria Or Or Order ID Table 1 - Yes - - - CustomerFirstName Table 1 - Yes - - - Date Table 1 - Yes Between [Forms]![Dates Entry]![StartDate] And [Forms]![Dates Entry]![EndDate] - - CustomerSurname Table 1 - Yes ...read more.

Conclusion

The print button from the order form is therefore still visible. Evidence Limitations The outputs do not have print buttons on them. Refinements This could be done easily using macros and the option which ensures that the button does not appear on the printed version. Criteria 7 Criteria Details Each page must display the company's logo Evaluation The criterion was met fully. Evidence Limitations - Refinements - Criteria 8 Criteria Details The 'Sales Summary' page must display an 'Enter Two Dates' box before opening Evaluation The criterion was successfully met. The 'Enter Two Dates' form opens as a small window over the main menu, when the user enters their two dates, they press enter. If either date is left out, an error message appears. Evidence Limitations The 'Create Sales Summary' form remains open when the Sales List opens. Refinements A setting in the options pane allows a window to automatically close when a new one opens. Criteria 9 Criteria Details Drop down boxes must show every option, and not be hidden by other boxes. Evaluation The criterion was met successfully. More items can be added and still will be shown fully in the drop down box. Evidence Limitations - Refinements - Criteria 10 Criteria Details Receipt and Delivery Note must include all relevant data. Evaluation The criterion was met successfully. No information was included that was not necessary, and no essential fields were left out. Evidence Limitations - Refinements - Criteria 11 Criteria Details There must be a 'Total Cost' box on the order sheet, calculating the sum of 'Personalization' and 'Duck' costs. Evaluation Te criterion was met fully. Evidence Limitations - Refinements - Criteria 12 Criteria Details Each button on the main menu must have a simple explanation. Evaluation The criterion was met successfully. Each button has a simple explanation of what it does. Evidence Limitations - Refinements - ?? ?? ?? ?? Duncan Hicklin (Enter Candidate Number Here) GCSE ICT Coursework - AQA Specification B Short Course Dhick Coursework (Revision 7) Sunday, 15 March 2009 Page 39 of 56 ...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 Software 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 Software essays

  1. Software used in my created system. To begin with, the one software I must ...

    Other spreadsheet software I could use range from online spreadsheets such as Google Spreadsheet to more feature-full ones such as EasyOffice, Framework and Apple iWork Numbers (Mac). They're similar on the whole but Microsoft Excel has better functionality with the other software I've already chosen, because the Microsoft software prefers

  2. Documentation of a database for a sports centre.

    are needed. When a company desires a database they need to provide the business needs for the database developers and also the system requirements. The organisation that is creating the database needs to know what kind of data/information is going to be stored in the database and this can only

  1. Database design for a games shop.

    Also the data is stored in tables this will ensure I make few mistake as possible. I can easily access sub menus and input data so you have achieved this task with full marks. The main problem with my company was the overdue rentals, I could not keep up, however you have solved this problem.

  2. GCSE IT Evaluation of word processing template documents for the Extreme Sports Club.

    for Improvements based on End User feedback Homepage * It was suggested by the end user that I could decrease the size of the font because it looks too bold and large * It was also suggested by the end user that I could make the picture of the manager

  1. Selecting the best software for a theatre business.

    The disadvantages in my investigation between open office calc and excel: 1. I did discover that there were some slight differences in how formulas were structured. For example, in an Excel If statement the format is " =if(A1=10,1,0)" meaning if cell A1 equals 10 then put 1 in the target cell, otherwise put a zero in the target cell.

  2. Testing database. Test plan 1 I am going to check my data restriction. ...

    So I will be selecting 0 in the drop down menu which means the stock would change to No. In the screen shot below the result have changes and I have achieved my expected result which means my lookup wizard works Test plan 5 Now I would be carrying out my testing on my criteria which I have set upped.

  1. Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve ...

    This could be a great advantage for JEM Bookshop, because it would allow them to produce a report e.g. on their profit and loss account, on Microsoft office for their shareholders or staff. If data, table or graph is needed in the report, you can mail merge it into Microsoft

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    This then showed all the border options. I chose the border which showed all the lines coloured black; the reason I chose to put a black box around each cell in the table is because it made the table stand out more and made it easily recognisable, especially once I had included the other 2 tables.

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