×
Your assignment consists of two tasks (worth 100% of the total marks for the assignment).
To calculate the total marks for English, Maths and ICT
To calculate the average marks for each student and state whether they received a pass or fail.
To describe some benefits and features of word processing, spreadsheet, and PowerPoint presentation software, in a report format.
Use the information in the table below to create a spreadsheet to complete all Task 1 instructions.
|
|
English |
Maths |
ICT |
|
|
|
|
|
|||
|
Student name |
Course work( out of 50) |
Exam ( out of 50) |
Course work ( out of 50) |
Exam ( out of50) |
Course work( out of 50) |
Exam ( out of50) |
English Final 100% |
Mths Final 100% |
ICTFinal 100% |
Average |
Pass/Fail |
|
A1 |
40 |
24 |
25 |
23 |
35 |
34 |
|
|
|
|
|
|
A2 |
25 |
34 |
35 |
40 |
23 |
22 |
|
|
|
|
|
|
A3 |
12 |
10 |
10 |
13 |
12 |
30 |
|
|
|
|
|
|
A4 |
40 |
45 |
12 |
10 |
34 |
32 |
|
|
|
|
|
|
A5 |
20 |
15 |
23 |
20 |
15 |
10 |
|
|
|
|
|
|
A6 |
32 |
20 |
10 |
20 |
32 |
34 |
|
|
|
|
|
|
A7 |
45 |
25 |
20 |
23 |
12 |
22 |
|
|
|
|
|
|
A8 |
30 |
45 |
34 |
22 |
10 |
14 |
|
|
|
|
|
|
A9 |
12 |
25 |
21 |
20 |
20 |
20 |
|
|
|
|
|
|
A10 |
10 |
8 |
20 |
20 |
34 |
23 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Place screenshots of your spreadsheet in data view and formula view in the Appendix of your report (Task 2). You must show both views to be marked.
In report format, you are required to research, review and highlight the benefits and features of word processing software, presentation software, and spreadsheet software
Prepare a report to answer the following questions. It should address the following topics:
How effective are Educational Interventions in increasing awareness and knowledge about prostate Cancer amongst Black men Dissertation,
Read MoreZoom Data Analysis Techniques Software Exercise Assignment
Read MoreAnalyse how partnership working impacts the chosen professional role in addressing the selected category of child abuse.
Read MoreEvaluate how the processes of employee selection or development affect organisational culture and behaviour in your organisation
Read More5HR01 Employment Relationship Management CIPD level 5 Diploma in People management Assignment
Read MoreUnit 504 CMI Level 5 Diploma Leadership and Management Assignment
Read MoreCIH Identify the consumer and producer subsidies for all types of housing tenures.
Read MoreExplain how health and safety measures in a scientific organization align with legislative requirements.
Read More7HR03 Understand the importance of organisational approaches to compliant and ethical reward practice
Read MoreH404 Customer Service in Housing CIH level 4 Essay
Read More
