Posted inUncategorized

Task 2: To describe some benefits and features of word processing, spreadsheet, and PowerPoint presentation software, in a report format

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 ICTTo 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 softwareBenefits of word processing softwareKey features of word processing software (10 marks)Definition of presentation softwareBenefits of presentation softwareKey features of presentation software (10 marks)Definition of spreadsheet softwareBenefits of spreadsheet softwareKey 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)

Related posts:

  1. In this assignment, you will complete some major steps of the SDLC with different roles. Firstly, as a project manager, you will prepare a project plan for the prototype development based on the resources in your team and the time allocated to the assignment. Task deliverables include an overview of your project (a brief executive summary about project stakeholders, objectives, and deliverables), a work-breakdown structure, a PDM for activity definition and dependency, and a Gantt chart for scheduling and time estimation. Note: You are not required to plan for the whole software but only your prototype. Secondly, as a requirements analyst, you will model and analyse the requirements using different modelling techniques. Task deliverables include a use case diagram, an integrated behavior tree, and a requirement specification (using the FURPS framework or User Stories). Thirdly, as a developer, you will
  2. Go to www.bls.gov and perform a search for “systems analyst” and “business analyst” What is the employment outlook for this career? Review the links on IT Jobs in Broward County and Palm Beach County, wha
  3. Create a blog post and a 3-4 minute edited video that critically and creatively responds to one of the Digital Media Contexts from weeks 7-10 (this must be a different topic from what you chose for Portfolio Output 2). Your video is to be embedded into your blog post, and all media you submit must adhere to the assessment requirements when using visuals and sound. This document includes advice
  4. The use of kinesthetic empathy allows us to connect with others by participating in their movement or attuning to the sensory experience of their movement.
Last updated on