• 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
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63
  64. 64
    64
  65. 65
    65
  66. 66
    66
  67. 67
    67
  68. 68
    68
  69. 69
    69
  70. 70
    70
  71. 71
    71
  72. 72
    72
  73. 73
    73
  74. 74
    74
  75. 75
    75
  • Level: GCSE
  • Subject: ICT
  • Word count: 5603

ICT Final Project (complete)

Extracts from this document...

Introduction

GCSE ICT - 2008 Final Project Title: Exchange Calculator Name: Daniel Thomas State a working title for your project: Live-updating currency converter Who is your end-user? A travel agent. What is the current problem? When customers would like to exchange money for their upcoming holiday, the staff at the agency have to manually look up and convert the required currencies by hand using a calculator, and then apply an extra % to the total depending on the amount wanted. They also have to keep a log of the transactions. Why has this problem arisen? The agency does not currently use a computer system, and the current solution is very time consuming. What do you currently see as the objectives (or user requirements)? * Create and develop a computer system that can aid with the conversion of currencies. * Use a simple and efficient user interface. * The system must keep itself up to date. * The inputs and outputs must be clearly displayed. * The system must not be time consuming for the end user. * The system must work. * The system must have corporate image * The system must calculate the % added by the company and the profit from that. * The system must keep an accurate log of past transactions * The system must produce an invoice State the different ways in which you might produce a solution: * Using Microsoft Word - a list of pre-chosen values and the correct totals for those amounts. * Using Microsoft Access - a list of pre-chosen values and the correct totals for those amounts, searchable using a query. * Using Microsoft Excel - a spreadsheet that will calculate the correct amount for any given total automatically, automatically updating itself when new rates exist. A front end will be used to display the information, hiding the rest from the end user. How do you currently think that data will be collected? ...read more.

Middle

The currency calculation will work both ways, so the user can specify either how much money they want to convert, or how much they want converted. Worksheet 2 This page will be a simple page that contains clients' information in a simple table. See below for draft layout. Using the below interface I will create a button that will allow the user to edit a clients' data by inputting the client's reference number and then clicking the edit button. The user will also be able to print an invoice directly from the page by entering the client's reference number and then pressing print invoice. The invoice will then be automatically printed using the default printer without the users input. Worksheet 3 This worksheet will contain the temporary invoice created by the button on worksheet 2, and will then be printed. The macro on worksheet 2 will automatically fill the page with the required information and will then print the page. The page below contains placeholders for where client's information will be placed. Worksheet 4 This page will not be seen by the end user. It will contain the exchange rates that have been automatically downloaded from the internet. It will also contain any temporary values created by calculations and macros if necessary. I will set up a web query using the web query wizard in the menu. I will use the website www.x-rates.com as the travel agent already used the same source of information. All spreadsheets will be protected where user input is not necessary to the worksheet. Detailed Design for User Interface The user interface will be mostly comprised of macros. This will make the interface as simple as possible. Below is a mock-up of a possible design. The current interface does not have any logos, names etc - the company's corporate identity has not yet been included. Re-usability The user interface is re-useable as it can be automatically cleared and then made available for the next customer. ...read more.

Conclusion

This will require no modification to the system itself. User Guide User Guide for Exchange Calculator Installation To install the system simply copy the system from the supplied CD, and then paste it into an available and empty folder on the computer that will be used with the system. Running To run the system, open Microsoft excel. Then click 'File' and then 'Open'. Browse to the location the system is stored, highlight 'Exchange Calculator.xls' (Do not select 'Backup of Exchange Calculator.xlk'), and then click open. Navigation The system has 2 different pages that you will see, the interface, and the database. This is the interface: The other page is the database: Creating an Order Moving Orders to Database Once you have finished filling in the form, press the 'Send to Database'. This will move all of the client's information to the database. Printing an Invoice To print an invoice, first navigate to the database page. You will then need to find out the clients unique reference number. This can be found by looking through the database until the client's information is found. The most recent addition to the database will be at the top. Then fill in the Order reference number at the top of the page. Once this information has been filled in simply press 'Print Invoice', and an invoice will be prepared and then printed. Ensure that the required printer is switched on at the time. Modifying Mistakes in the Database To modify a mistake in the database, you must simply find the customers information (if they have their reference number, the process is made much easier). Then simply edit the cell as you would any other cell in Microsoft excel. Starting a New Client Just press the 'New Client' button. Saving the System To save the system, just press file on the bar at the top of excel, and then press save. ?? ?? ?? ?? Name: Daniel Thomas GCSE ICT - Examination 2008 Final Project Page 1 of 75 ...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 Communications 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 Communications essays

  1. In this piece of coursework I will be looking at how Tesco uses ICT ...

    Communication Tesco sees communication with its customers as a big priority, it proves that they care about what their customers think and want. Via the Tesco Clubcards they can communicate with their customers and send them rewards for shopping at their store.

  2. OCR GCSE Business & Communication Task 7 Report

    This includes stabilising the reports usage as users may be able to manipulate or change the data used in the report. Examples of this problem have been seen on sites such as Wikipedia where viewers have the control to change statistics which are shown on the website.

  1. special needs

    Specialized ICT hardware's enable Maria to move around with joy and to any rooms at her house. She can use her wheelchair to grab hold of anything she wants to by moving around using her joystick. Maria Korelli's- Social use of her electronic wheelchair.

  2. GNVQ ICT: unit 7 presenting information multimedia individual work

    You can also add sound under Modify transitions. I added slide transitions because it affects the way one slide changes into the next and the viewers come to know that a slide has been changed to the other. In the all the slides in the presentation I used wheel clockwise, 8 spokes in slow speed.

  1. ICT Final Project (Complete)

    - To create a pop up screen where people can order tickets easily. - To create a seating plan of the hall to make it easy for the user to see how well tickets are selling. - To show the total profit - To show how much money can be spent.

  2. ict ocrnational unit 2 - creating website

    After doing so I had completed doing the first part of the Navigation Bar Background. Here are details of each of the graphics: Navigation Bar Background: File Type: .GIF Physical Size: 800 X 171 File Size: 12.7KB Home Button: File Type: .GIF Physical Size: 303 X 101 File Size: 10.3KB

  1. Free essay

    Impact of ICT in Community

    online or when she is sending an email to her family members or friends. This will also improve her accuracy so if she get's use to using the Braille keyboard she will remember where a specific letter is so that would make her type the correct letter.

  2. Report on an ICT system and how it meets the Organisation's needs

    This can help them make sure they can check if a customer returns with an item. The printer is very fast at printing and can print about 127mm of paper a second. This shortens queues which keeps customers happy and helps Marks & Spencers sell more products in a shorter time.

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