×
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:
COM4007 – Identify design, usability and accessibility issues involved in delivering websites:
Read MoreUnderstand the components of creative environments: Creative Arts Practice for School-Aged Children,
Read MoreThis assignment aims to deepen students’ understanding of the fundamental principles of operations management and its evolution over time:
Read MoreAnalysis of Pay Structures & Legal Compliance: Strategic Reward Management,
Read MoreCritical assessment of the forms and environment of Employee Relations in Ireland : Strategic employee relations,
Read MoreDemonstrate a clear knowledge of the role that information technology and information systems play in the business world:
Read MoreCritically discuss the care of the surgical patients with regard to Atrial Fibrillation Ablation,
Read MoreIdentify what all insurance covers are essential for this company through a detailed analysis of the business risks which justify insurance cover.
Read MoreDemonstrate how different social determinants of health might intersect to create a unique picture of three individuals’ health and wellbeing :
Read MoreHow did you show effective communication with the client and other members of the team?
Read More
