• 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. using ICT to communicate

    On every page NatWest have used a text box on the bottom of every page giving three ways of getting in touch with the bank. The three ways are website, phone, and the nearest branch. For each way they have provided little images.

  1. OCR GCSE Business & Communication Task 7 Report

    By using letters to communicate to my clients, I am able to promote my corporate image my incorporating it into my letters as letterheads, company colours and the font used which can be used all over the company's products to show consistency.

  2. 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.

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

    The screen shot shows how I have inserted the header and footer. Was my information enough for the presentation? How was my slides organised? How was my information appropriate? How much text should I display on each slide ? How does my animation affects the slides ?

  2. 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.

  1. 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.

  2. Free essay

    Impact of ICT in Community

    she is at work or when she is sending her work to other member of the office. And also when Mary needs to stay in contact with her clients Mary needs to send them email daily so Braille keyboard helps her to type rather than using assistance.

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