
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)
