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:
Business Economics Assignment 3: Case Study Analysis on Price Controls in Pharma and Monopoly Power in Airline Industry
Read MoreCSC408 MIS Case Study Assignment Report: Analysis of Issues and Solutions in Information Systems
Read MoreScientific Research Review Assignment 4: Advancements and Ethical Practices in Your Study Area Literature Synthesis
Read MoreOrganizational Development Assignment: Tech Solutions Inc. Case Study on Engagement, Retention, and Inclusive Culture
Read MoreHPGD3103 Instructional Technology Assignment: ASSURE Model-Based Lesson Design in Google Classroom
Read MoreAI Deepfake Cybersecurity Assignment: Evaluating Security Risks and Detection Techniques for Safe Digital Environments
Read MoreMGT4216E Strategic Innovation Management Assignment: Exploring Innovation Capabilities, Strategy Stages, and Leadership for Business Transformation
Read MoreEmployee Engagement & HR Strategy Assignment: Case Analysis of Tech Solutions Inc. on Turnover, D&I, Performance, and Work-Life Balance
Read MoreHigher Education Reform Assignment: Curriculum Development Strategies for a Future-Ready Malaysia
Read MoreCross-Cultural Management Assignment Report: Importance, Challenges & Strategies in Global Teams
Read More