• 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. Different types of technology How I use ICT at home and at school

    This meets my need to tackle my awkwardness and just talk about something I enjoy. Watching TV also lets me develop an interest in something and make it a hobby of mine. Discovering anime also made me delve further into it and become a fan, which made me also start reading manga.

  2. GCSE Excel Project ICT

    Also the archive could be sorted in two ways either a) alphabetical order with a filing cabinet ordering the customers records in some order; however this is only slightly improving the system as error and discombobulating can arise, as some records could be misplaced due to a number of other limiting factors.

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

    Three types of actuator are commonly used to control the movements of a robot. These are Hydraulic systems ,Pneumatic systems ,Electric motors. The three types of actuator are: Hydraulic systems, Pneumatic systems and electric motors. Hydraulic Systems-Here, the output from the computer controls the movement of hydraulic rams by pumping oil through pipes.

  2. a level ict project

    The employees are becoming so annoyed by this they are more likely to not fill out the information sheet to avoid dealing without the archives. As a result if a customer or legal representative wanted to see a specific transaction, Victor would face a discomfiting situation because they would be unable to do so.

  1. Tennis Tournament UNIT 1 GCSE ICT coursework

    If you used a manual system like a calculator you would have a large calculation, whereas using a spreadsheet it lets you break down a large calculation in to lots of smaller parts. C Specification 3 Performance Criteria My solution for The Lawn Tennis Association will have to meet the

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

    Sarah's sister and carer helps set everything up for her, which is extremely easy to do thanks to the iPhone's user-friendly system. Sarah can then send calls by going to her address book by saying 'Contacts' and then saying the name of the contact she wants to call.

  1. Testing for ICT A Coursework 2a

    there is a lot of information and this is also shown on the user interface so the user interface is correct in displaying all of the information. Test 4 This is the user interface for my Sales form and this is the table that is the main table which is connected to everything else.

  2. task2-report-template 3

    number * Customer address * Customer name * Date * A little text telling customer about his/her order 2.3.2 Hardware and Software Requirements [3] Hardware Reason of using it Laser printer To print letter, report and so on. This Film Transistor Monitor (TFT)

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