• 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. Free essay

    Impact of ICT in Community

    Mary can also stay in contact with her clients when they need helps instead of writing email. The OWASYS 22c mobile phone has all the features that Mary needs to make calls and receives calls. 5. Too what extent does it meet Mary needs?

  1. Information Security.

    Ask For Plain Text. If You Receive A .Doc, .Wpd, .Xls Or Or Other Unsafe File Type As An Attachment, Even From Someone You Know, Ask Them If They Will Convert It To .Rtf, .Txt Or .Cvs And Then Resend It To You.

  2. SK-II has already established as a leading brand within its' skin-care industry. By empowering ...

    * Enforcement/redress - some way of enforcing privacy and seeking remedy if it is violated. 6.2 Dynamic Pricing: As contrasted to the fixed pricing strategy Future e-business successful for SK-II will depend on how it charges its' customers. If SK-II sets prices too high, web customers will stay away.

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

    Such developments will increase the use of the Internet. * Email could also be used Subscription emails, manufacturers collect personal information from competition and web site registrations, and send direct mails with information that is relevance to them. Emails also allow the use of viral marketing whereby consumers pass information on to friend's etc.

  2. ict ocrnational unit 2 - creating website

    After doing this to every button, this is how a button will look like after hovering the mouse cursor over it: I have used the home button as an example. Here are details of each of the Onstate buttons: Home Button: File Type: .GIF Physical Size: 296 X 109 File

  1. OCR GCSE Business & Communication Task 7 Report

    I also had to insure my form included all required fields as attempts were stopped due to errors, which were found whilst completing the form. I made sure these problems were not-recurrent by insuring the ink was properly installed before printing my work, I also made sure I concentrated whilst

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

    2% Consultant 10% Other * 40% of respondents occupy management or executive positions. * 35% of respondents are designers or developers * 8% of respondents are in an instructional role. Size of organization * 47% respondent's organizations have more than 2, 500 employees.

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