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:
MPOM7103 Assignment: Strategic Decision-Making and Operational Resilience in Petronas Amid Energy Transition
Read MoreMPIB7103 Assignment: Critical Perspectives on International Business Strategies and Regional Integration
Read MoreMPHR7113 Assignment: Strategic HR Analysis of Golden Heritage Café (HRM)
Read MoreTHEA1013 assignment: Theatrical Storytelling: Exploring the Unique Power of the Stage
Read MoreBusiness Strategy Assignment: Strategic Expansion: A Business Outlook
Read MoreGSGM7324 Assignment: Organisational Development and Change Management
Read MorePHY098 LOD 2, C4 Assignment: Mitigating Damage to Electrical Appliances from Lightning Strikes
Read MoreBM070 Business Research Assignment: Business Report Framework for Corporate Development
Read MoreHBET1203 Assignment: Comparing Pronunciation of Selected Words in Text and Reading to Standard British English
Read MoreIdentify key technological challenges affecting e-invoicing adoption in Malaysia.
Read More