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 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 todays 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)
