Dec 11, 2021

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

Computing Skills Assignment Help

Assignment Tasks

Task 1:

Task 2:

Task 1: Spreadsheet (40% of total marks)

Task 1 Instructions

How to submit your spreadsheet:

Task 2: Report (60% of total marks)

Order this Assignment now

Our Office

Services

Quick Links

Quick Links