• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49
  50. 50
  51. 51
  52. 52
  53. 53
  54. 54
  55. 55
  56. 56
  57. 57
  58. 58
  59. 59
  60. 60
  61. 61
  62. 62
  63. 63
  64. 64
  65. 65
  66. 66
  67. 67
  68. 68
  69. 69
  70. 70
  71. 71
  72. 72
  73. 73
  74. 74
  75. 75
  • Level: GCSE
  • Subject: ICT
  • Word count: 5603

ICT Final Project (complete)

Extracts from this document...


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.


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.


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 tool is helpful as it helps towards to professional aspect towards my company and can help to support the needs for my business regarding important emails. Word Count is an available tool within my programme, this can help me to realise if my letter is too long, too short or requires more attention.

  1. special needs

    Firstly, the technology is meeting her personnel needs because she is able to communicate with family members at any gap between 24 hours/7 days a week. This keeps her alert of how her family members are and she can clearly see her family members on the monitor of her computer through a webcam.

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

    Image colour format Previous after The contrast Before After The brightness Before After Crop Deletion of images in the slides This is how I deleted an image from a slide. T o delete an image from a slide, move the mouse over the image and then press the left mouse button.

  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

    I will select that page as it is the page which the Home button will link to. I did the same with all the other Navigation Bar Buttons, as I Hyperlinked them all to the Correct pages for them to link to.

  1. Free essay

    Impact of ICT in Community

    The software meets Mary needs she can contact her family and friends using the MSN the software helps her as she can feedbacks the software talks to you as you're having a conversion with another person. She can also use to check her emails and reply back.

  2. I.T Evaluation of Hardware

    The leaflet was satisfactory however it could have explained more detail in some areas of the leaflet. Aim 3 - Mail Merge Letter I need to create a mail merge letter that will be sent out to current member, informing them about new offers and discounts.

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