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

Submit Your Work With 100% Confidence. 

Stop guessing. Get a full Turnitin report or let us manually rewrite your work to bypass AI and plagiarism detection..

Computing Skills Assignment Help

Assignment Tasks

Your assignment consists of two tasks (worth 100% of the total marks for the assignment).

Task 1:

1. To calculate the total marks for English, Maths and ICT
2. 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.

ESSAY WRITING AGENCY

Get the exact same Turnitin report your professor uses. Join 50,000+ students who submitted their essays with confidence this semester.

Get Turnitin Score Report Request Human Rewrite

Task 1: Spreadsheet (40% of total   marks)

Use the information in the table below to create a spreadsheet  to complete all Task  1 instructions.

Task 1 Instructions

1. Rename the first worksheet in your spreadsheet to “Student Results”. (1 mark)
2. Add the title “Students Record” at the top of your worksheet. (1 mark) 
3. Format the title Q consider font style, font size, text colour, cell background colour, text alignment or merged cells.  (2 mark)
4. Use an appropriate function to calculate today’s date. (5 marks)
5. For each subject (English, Maths, ICT), write a formula to calculate the total marks. (10 marks)
6. For each student, calculate the average mark for the three subjects (English, Maths, and ICT) (12 marks).
7. 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:

1. Definition of word processing software
2. Benefits of word processing software
3. Key features of word processing software (10 marks)
4. Definition of presentation software
5. Benefits of presentation software
6. Key features of presentation software (10 marks)
7. Definition of spreadsheet software
8. Benefits of spreadsheet software
9. Key features of spreadsheet software (10 marks)
10. Describe two commands in Microsoft 2010 from any applications you have used to increase your own productivity as a student (8 marks)

The post 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 appeared first on Question Paper- Academic Writing, Editing & Turnitin Plagiarism Checker.