• 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

    Being a fan of something and having an interest gives me a greater platform of meeting new people with the same interest and the ability to talk about this interest. I can find out about something that intrigues me through TV, making me find out more about it.

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

    These might include sensors, light and heat sensors. Third generation-These are the latest robots under development in research laboratories that can 'learn' on the job. Robots operate under artificial intelligence software and can adapt and reason with the incoming data to improve their performance.

  1. GCSE Calculator Project

    Perform the basic arithmetic functions (of add, multiply, subtract and divide). 2. The font size should be big for people with peer eye sight. 3. The difference between the foreground and background colour should make it easy for the user to read.

  2. ICT PROJECT

    with cell references to the precise information on the main data store sheet. The user (student) will only need to select students name in the list box and whom the report will be created for. Sheet 1- Front-end menu The sheet will have a number of macros to navigate through the system.

  1. Computer project Alevels

    The following is a picture of a toolbox. * Add command buttons In order to add command buttons you must first the 'control wizards' button which is represented by a wand. Once you have selected this button you must then select the command button which looks like this.

  2. GCSE Excel Project ICT

    time as his archives size is increases by approximately 30-40 sheets per day. Manual Solution Considered The card providing the information about the component could be photocopied from one initial copy, or better still one handwritten copy laminated to increase the life of the paper.

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    Currently we use a cheap glue to stick it on and it is easy to rip it off.

  2. Ict coursework full

    The text navigation will be blue, in size 10 Tahoma. The image navigation will consist of 4 images, each representing (and linking to) each product page of the site. The copyright information will be black, in size 8 Arial. Home page #2: The logo will be in a green font colour, in size 20 Tahoma.

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