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.

Task 1: Spreadsheet (This is 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 considers 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 (This is 60% of total  marks)

In report format, you are required to research, review and highlight the benefits and features of word processing softwarepresentation 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 
  • Definition of presentation software
  • Benefits of presentation software
  • Key features of presentation software 
  • Definition of spreadsheet software
  • Benefits of spreadsheet software
  • Key features of spreadsheet software
  • Describe two commands in Microsoft 2010 from any applications you have used to increase your own productivity as a student 
RELATED COURSES & ASSIGNMENT SERVICE!!


COMMENTS(0)

LEAVE A COMMENT


Captcha

 

 

Are You Looking for Computing Skills Assignment Help?


PLANNING TO BUY COMPUTING SKILLS ASSIGNMENT SOLUTION AT MIRACLESKILLS?

We at Miracleskills offer high quality computing skills assignment help service at cost effective price. The writers associated with us, prepare each assignment from scratch and develop high quality plagiarism free solution document as per the specifications and requirement.  We provide well formatted solution document along with valid referencing and text - citations. The computing skills assignment writers are holding masters and post graduation degree and they make error free solutions to assessment which is not having any grammar and spelling mistakes.

WHY SHOULD YOU CHOOSE MIRACLESKILLS FOR COMPUTING SKILLS ASSIGNMENT HELP?

  • Quality Original Content - Each computing skills assignment order is prepared from scratch. We provide well researched original content which passes every test at Turntin.
  • Free Turntin Report:- We provide free turntin report along with solution. We do not charge extra for it, its free of cost.
  • Guaranteed Satisfaction: We assure you guaranteed satisfaction under our computing skills assignment help service. You get 100% accurate assignment as per specification of the requirement.
  • Never miss your deadline:- You have option to choose your deadline and we always try to meet with no fail.
  • Cost Effective Rate:- Our computing skills assignment help service is cost effective and every scholar can afford this service to get high satisfactory writing service from UK writers.
  • Well written format:- You get well formatted solution document in computing skills assignment help service which is easily editable if you need further changes. We provide solution file in Microsoft word document and pdf file as per your demand.
  • Valid referencing and text-citations:- We include valid text-citation and referencing in report which are authentic sources and all these are considered in academic writing.
  • No grammar and spelling mistakes: - Our writers provide the error free solution document; you never see any grammar and spelling mistakes in the solution document.
  • Unlimited revisions:- If you need further changes in solution document of computing skills assignment or report then we provide it with no extra charges, We work till you are satisfied.
  • Easy order placing and tracking system:- You can easily order computing skills assignment using "order now" button. You can further track your order status inside in your Miracleskills account.
  • Communicate directly with writer:- The writer who has been prepared for your computing skills assignment solutions, you have option to talk directly with writer via using Miracleskills account.
  • Money back guarantee: - if you are not satisfied with our computing skills assignment help service then its easy to get money back. We work till you are satisfied.
  • Experienced writers:- The writers who are preparing assignments are holding long experience almost 7-8 years and they know how to score in computing skills assignments. They prepare assignment as per university specifications and provide you A++ grade solutions.
  • A++ grade assured:- We promise to get A++ grade in our written computing skills assignment and our commitment never fails.

Are you still looking for more searches? We at Miracleskills offer most trusted and reliable online computing skills assignment help service and our service assures you to get higher grade in computing skills assignment and classroom homework.

WHAT ELSE WE PROVIDE UNDER COMPUTING SKILLS ASSIGNMENT HELP?

  • Computing Skills Assignment Writing Service
  • Computing Skills Assessments Work
  • Tutorials And Online Classes
  • Computing Skills Paper Writing And Editing Service
  • Research Reports Writing Service
  • Proofread assignment help
  • Thesis and dissertation writing service

Dont wait to save higher marks now! Get extreme quality computing skills assignment help and writing service under budget.