This paper circulates around the core theme of Computing Skills Assignment Help together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Computing Skills Assignment Help
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)
