Task 1: 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
Assignment Tasks
Your assignment consists of two tasks (worth 100% of the total marks for the assignment).
Task 1:
- 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.
Task 2:
To describe some benefits and features of word processing, spreadsheet, and PowerPoint presentation software, in a report format.
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 of 50) | Course work ( out of 50) | Exam ( out of 50) |
English Final 100% |
Maths Final 100% |
ICT Final 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 consider font style, font size, text colour, cell background colour, 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)
How to submit your spreadsheet:
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.
Task 2: Report (60% of total marks)
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:
- 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)