• 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. SK-II has already established as a leading brand within its' skin-care industry. By empowering ...

    * SK-II, in the mid-term, can develop a regional promotion strategy to advertise on the mobile device platform namely 3G-enabled-PDA-communication device, 3G-enabled mobile device: o Take advantages of the existing GPRS network and SMS service provided by tele-communication companies to provide SMS-promotion messages to targeted customers.

  1. This report gives the clear idea about current statistical situation in e-learning trends.Task 2 ...

    Digital multimedia creation tools Media types can include text, images, graphics, sound, animation, video and virtual reality. The only problem encountered in using multimedia in e-learning development on the Internet is bandwidth issues. Text creation tools HTML or Hyper Text Mark up Language is the native language read by most web browsers like Internet Explorer and Netscape.

  2. Development of a set of marketing recommendations, marketing mix campaign and customer care initiatives.

    PR Online editorials, newsletters, discussion groups, portals 5. Sponsorship Sponsoring online event, site or service 6. Direct Mail Opt-in e-mail and web response 7. Exhibitions Virtual exhibitions 8. Merchandising Shopping malls, e-tailing, the interface 9. Packaging Real packaging is displayed online 10.

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

    It is ok. Can be clearly understood. What do you feel about the presentation? Overall your presentation is really effective but including more sounds can make it more interesting. Your presentation is good and words can be made simpler to understand.

  2. Production Log.

    I can do this through gender, age group, class and nation. In may case the majority of my target audience would be males, that are in their teens to early/mid-twenties, who are working or middle class people that live in the richer countries in western civilisation e.g. Britain, America etc.

  1. Critical Path Analysis

    Plug-ins and forms are quite difficult to test offline. The person inserting these features into the site should be experienced in programming and HTML scripting. P Test for navigational and scripting errors - The whole site should be rigorously tested to see if links and scripts are working, images and tables are viewing correctly and to check consistency of design.

  2. OCR GCSE Business & Communication Task 7 Report

    Legal Issues: Whilst completing my database I had to follow the Data Protection Act (1998). This act was introduced to enforce strict punishment towards frauds and copyright. I ensured I stayed within this law by protecting files included inside the database.

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