• 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

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

# 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 Database Project ICT

can implement its templates: We then select a template provided in word: Then click 'OK'. The document is then updated to this state: We then choose the data source by clicking browse... ...and selecting the directory of where the database is situated: After selecting the database file, all the objects

1. ## ICT Project 1A

I had separated my information into 4 main folders, documentation, images, school sheets and webpage's. This made it very easy to access any information that I needed. Here is also a print screen of what each folder contains. I found that by being organised in the way I saved my work I was able to make my work more organised.

2. ## GCSE Excel Project ICT

In addition, a questionnaire-style form could be given to the customers, of which only one would be made (and photocopied), then they fill in the order and give it to him where he can total the price and charge accordingly.

1. ## Ict Powerpoint Coursework

Also it doesn't appeal to the visual substances as it would look boring for a fast food franchise which would eventually lose customers instead of gaining them. Leaflets , Posters , Letters - Distribution methods If Mr. Akram wanted to help his company manually he could do this by printed

2. ## In this (2b) report I am going to investigate software application, Input and Output ...

the CS jumper set, and the cable chooses the master and the slave. STORAGE DEVICES AND MEDIA Data is stored in an information system so that it can be utilised when required. It can be stored both temporarily, while a program is running, and long-term, so that it can be preserved while software and hardware is not in use.

1. ## ICT PROJECT

* Protections of cell so that user cannot accidentally delete information. Statement of Input, Processing & Output requirement The input would be: Personal Details: * First name * Surname * Gender * Date of Birth * Form * Roll number Student marks: * Assignment marks Maximum /minimum mark * Grade

2. ## GCSE ICT Coursework Write-up

It also enabled me to close crop the images so I could layer on other images on top of the background to the logo that I could create using Fireworks. Instead of this I could've used Paint Shop Pro or Paint, which have similar functions.

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