• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 8112

ICT Coursework (MarcoS)

Extracts from this document...

Introduction

I.C.T. Project Identify Project idea 4: Keeping Accounts Middle East Construction Company (MECC) MECC is an U.S.A. company that sells properties, it was introduced in 1984, and it became one of the most important in the U.S.A., and in Europe, and now they are working also in the Middle East. The owner is Mr. Jackson. The company makes villas and small buildings. They also produce desalination implants, which are very useful, especially in Dubai, where now the company has a lot of work. The company also sells properties in Dubai. Many engineers, architects and laborers works for makes buildings, but in the company there are also people that have to takes the accounts and register the property selling. There are 20 people that do this, they have to follow all the money transfers. For example when they have to buy the materials such as concrete, bricks and steel, invoices are sent to the company that produces these materials, and then when MECC purchase the materials, all the money spent are recorded. For the properties, they have to contact the customers interested on buy one and make an invoice and at same time keep There are 2 people that follow the transaction for each material, 8 people that follow the management of the salary, and 5 people that record the entry of money. The payment for a project is recovered into two parts: firstly, before starting building, the company receives 60% of the final price and the other 40% when the work is finished. But most of the time the company makes a building, and then they sell the property to a person, so they can earn much more. All of these data are stored into folders, and only these 20 people can have access to them. Every week they make a balance of the company's situation, to check how the company is working. Questionnaire to the manager 1. What's your name? 2. How old are you? 3. Do you like your job? 4. ...read more.

Middle

displayed 77 Formula in cell G7 in the Materials sheet The result of D7 x F7 is displayed 78 Formula in cell G9 in the Materials sheet The result of D9 x F9 is displayed 79 Formula in cell G11 in the Materials sheet The result of D11 x F11 is displayed 80 Formula in cell G13 in the Materials sheet The result of D13 x F13 is displayed 81 Formula in cell G15 in the Materials sheet The result of D15 x F15 is displayed 82 Formula in cell G17 in the Materials sheet The result of D17 x F17 is displayed 83 Formula in cell G20 in the Materials sheet The result of G5+ G7+ G9+ G11+G13+G15+ G17 is displayed 84 Formula in cell C5 in the sheet Loss The result C3 x 4 is displayed 85 Formula in the cell C13 in the Loss sheet The amount in the cell G20 in the Materials sheet is displayed 86 Formula in the cell C17 in the Loss sheet The result C15 x 500 is displayed 87 Formula in the cell C19 in the Loss sheet The result of C17+C5 is displayed 88 Formula in the cell C4 in the Profit & Loss sheet The month is displayed in the cell 89 Formula in the cell G6 in the Profit & Loss sheet The mobile No of the employer chosen is displayed 90 Formula in the cell G7 in the Profit & Loss sheet The e-mail address of the employer chosen is displayed 91 Formula in the cell C23 in the Profit & Loss sheet The tot. between the loss and the incoming is displayed 92 Formula in the cell F23 in the Profit & Loss sheet The tot. between the loss and the incoming is displayed 93 Formula in the cell I23 in the Profit & Loss sheet The tot. between the loss and the incoming is displayed 94 Formula in the cell M23 in the Profit & Loss sheet The tot. ...read more.

Conclusion

Then stop recording. * For the arrow named as "Back to top", while recording it as macro, move the vertical scroll bar all up, and then stop recording. * In the cell C23 type in: =C13-(C17+C18+C19+C20+C21) * In the cell F23 type in: =F13-(F17+F18+F19+F20+F21) * In the cell I23 type in: =I13-(I17+I18+I19+I20+I21) * In the cell M23 type in: =M13-(M17+M18+M19+M20+M21) * In the cell C37 type in: =C27-(C31+C32+C33+C34+C35) * In the cell F37 type in: =F27-(F31+F32+F33+F34+F35) * In the cell I37 type in: =I27-(I31+I32+I33+I34+I35) * In the cell M37 type in: =M27-(M31+M32+M33+M34+M35) * In the cell C51 type in: =C41-(C45+C46+C47+C48+C49) * In the cell F51 type in: =F41-(F45+F46+F47+F48+F49) * In the cell I51 type in: =I41-(I45+I46+I47+I48+I49) * In the cell M51 type in: =M41-(+M45+M46+M47+M48+M49) * In the cell F62 type in: =C23 * In the cell F63 type in: =F23 * In the cell F64 type in: =I23 * In the cell F65 type in: =M23 * In the cell F66 type in: =C37 * In the cell F67 type in: =F37 * In the cell F68 type in: =I37 * In the cell F69 type in: =M37 * In the cell F70 type in: =C51 * In the cell F71 type in: =F51 * In the cell F72 type in: =I51 * In the cell F73 type in: =M51 * To create a graph, first select the cell F62,then follow the instructions in the picture: * Now then graph will appear on the page, then select as shown in the picture below * Now click on the white background of the graph, then right click on it, choose select data and a new window will open: * To change the color of the graph background, right click on the graph background and select "Format chart area". Then choose Fill to have the possibility to change different colors and patterns. * Remember then to create the macro buttons to link this worksheet to the others as shown in the picture below: TESTING: Test 1 ?? ?? ?? ?? IGCSE ICT Project Candidate No. Centre No. 91516 1 Marco Sittnig Teacher: Ms. Rai ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. GCSE Excel Project ICT

    table array and returns a value in the same row from another column in the table array. In addition, 'Conditional Formatting' can be placed on cells to change cell properties based on the cell contents. Microsoft Access The Second solution available in the Microsoft office 2007 suite is Microsoft Access, which hold many advantages.

  2. The use of ict has changed the way in which people work. Explain the ...

    There are However disadvantages with this method of production including large amounts of money are tied up in the thousands of cars waiting to be sold. customers buying cars are becoming increasingly particular about the options they require. It is quite possible, even with the thousands of cars waiting to

  1. a level ict project

    The speed of which data is entered for the current system is discouraging the employees, information is being entered repeatedly and is encouraging mistakes and misrepresentation of data. The information of the transaction has to be recorded every time a customer has been dealt with.

  2. Tennis Tournament UNIT 1 GCSE ICT coursework

    D Design of the ICT system 4 No Yes No Yes Key The flow chart above shows how my system works. First of all it will load up from the hard drive. The user then types in the mark up they want but it must be between 20 and 80, otherwise it will take them back a step.

  1. The impact of ICT on a person with special/particular needs

    The motion capture feature of the camera which is integrated due to its high quality allows the blur to be minimised from the unsteadiness of Sarah's hands. Sarah can also call her friends and family. But not only that, she can also video call them.

  2. Testing for ICT A Coursework 2a

    As you can see the data can be entered easily enough and shows on the interface. As you can also see on the datasheet the data is shown there and is shown correctly so that the user can identify and search the data for their certain needs.

  1. task2-report-template 3

    This Film Transistor Monitor (TFT) size 17 To display information on the screen. RAM (3 GB) To have the ability to open more than one application at once and switch between them quickly. Keyboard, mouse and Scanner To input data. Magnetic tape To backup data Software Reason of using it Database To solve the business

  2. ICT car insurance quotation System Coursework

    Setting up the input controls onto the quotes worksheet. This is the major worksheet of the system, and takes information from the groups and multipliers sheets and works out the quotation. I entered the labels for the customer's title, forename, surname, address, postcode and telephone, In C2 to C8.

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