Computing Skills Assignment Help
Assignment Objectives
Your assignment consists of two tasks (worth 100% of the total marks for the assignment).
Task 1:
- Calculate the total marks for English, Maths, and ICT
- Calculate the average marks for each student and state whether they received a pass or fail.
Task 2:
Describe some benefits and features of word processing, spreadsheet, and PowerPoint presentation software, in a report format.
Computing Skills Assignment Help
Task 1: Spreadsheet (40% of total marks)
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% |
Maths 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Task 1 Instructions
- Rename the first worksheet in your spreadsheet to “Student Results”. (1 mark)
- Add the title “Students Record” at the top of your worksheet. (1 mark)
- Format the title Q considering font style, font size, text color, cell background color, text alignment, or merged cells. (2 mark)
- Use an appropriate function to calculate today’s date. (5 marks)
- For each subject (English, Maths, ICT), write a formula to calculate the total marks. (10 marks)
- For each student, calculate the average mark for the three subjects (English, Maths, and ICT) (12 marks).
- Using an IF function, output the words “Pass” where the average is greater than 40%, or “Fail” otherwise (9 marks)
Computing Skills Assignment Help
How to submit your spreadsheet:
Place screenshots of your spreadsheet in the data view and formula view in the Appendix of your report (Task 2). You must show both views to be marked.
Task 2: Report (60% of total marks)
In report format, you have 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:
- Definition of word processing software
- Benefits of word processing software
- Key features of word processing software (10 marks)
- Definition of presentation software
- Benefits of presentation software
- Key features of presentation software (10 marks)
- Definition of spreadsheet software
- Benefits of spreadsheet software
- Key features of spreadsheet software (10 marks)
- Describe two commands in Microsoft 2010 from any applications you have used to increase your own productivity as a student (8 marks)