Computing Skills Assignment Help

Computing Skills Assignment Help

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.

Computing Skills Assignment Help, Computing Skills, Assignment Help, Assignment Help UK, Assignment Help Coventry, Assignment Help London, Online Assignment Help, HND Assignment Help

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

  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)

    Contact us

    Get assignment help from full time dedicated experts of BTEC HND & HNC assignments.

    Call us: +44 – 7497 786 317
    Email: support@locusassignments.com
     
    BTEC HND Assignment Experts