Calculate the average marks for each student

Reference no: EM131151174

Learning outcomes to be examined in this assessment

- Demonstration of the fundamentals of operating a computer system to restore, retrieve, analyse and present data.

- Describe the ways in which information technology can contribute to increased productivity and enhance the quality of management.

- Describe the scope of hardware & software currently in use and the technological advances taking place.Assignment Tasks

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

Task 1:

A. To calculate the total marks for English, Maths and ICT

B. 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

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 of* *50)*	Course work ( out of 50)	Exam ( out of 50)	English Final 100%	Maths Final 100%	ICT Final 100%	Average	Pass/Fail
Mark	40	24	25	23	35	34
Henry	25	34	35	40	23	22
Rose	12	10	10	13	12	30
Yasmeen	40	45	12	10	34	32
Suzen	20	15	23	20	15	10
Ahmed	32	20	10	20	32	34
Deven	45	25	20	23	12	22
Dan	30	45	34	22	10	14
Ann	12	25	21	20	20	20
Tina	10	8	20	20	34	23

Task 1 Instructions

1) Rename the first worksheet in your spreadsheet to "Student Results".

2) Add the title "Students Record" at the top of your worksheet.

3) Format the title Q consider font style, font size, text colour, cell background colour, text alignment or merged cells.

4) Use an appropriate function to calculate today's date.

5) For each subject (English, Maths, ICT), write a formula to calculate the total marks.

6) For each student, calculate the average mark for the three subjects (English, Maths, and ICT)

8) Using an IF function, output the words "Pass" where the average is greater than 40%, or "Fail" otherwise

Task 2: Report

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

4. Definition of presentation software
5. Benefits of presentation software
6. Key features of presentation software

7. Definition of spreadsheet software
8. Benefits of spreadsheet software
9. Key features of spreadsheet software

10. Describe two commands in Microsoft 2010 from any applications you have used to increase your own productivity as a student

Structure your report using the appropriate word processing tools: Cover page
Table of contents, and headings (5 marks) Referencing and Bibliography

Appendix section

Suggested report structure

Cover Page
Assignment title, module code, student name, student number and submission date.

Table of Contents
A list of headings and page numbers.

Introduction (about 5% of word count)
? What question/topics are you going to explore? Why?
? Explain the steps you will take to address the question.

Analysis and Evaluation (about 80% of word count)
Separate your analysis into topics - create a subheading per topic.

Create a chain of paragraphs under each subheading (1 idea per paragraph). In each paragraph, the reader is asking you to explain:
? What idea is this paragraph about?
? What are your evidences on this idea? What do these evidences tell us?
? How does this paragraph link to the report title?
? How does it link to the topic in the next paragraph?

It is not sufficient simply to describe a situation. Analysis and a critical approach are essential. Charts, diagrams and tables can be used to reinforce your arguments.

Recommendations (about 10% of word count)
Based on your analysis, outline your recommendations.

Conclusion (about 10% of word count)
? Do not introduce any NEW material here.
? Restate what you consider the main points.
? Make it clear why those conclusions are important or significant.
? In your last sentence, link your conclusions or recommendations back to the title. Did you answer your main question? What was the answer?

Bibliography
An alphabetically ordered list of the references cited in your report, in Harvard style.

Must be in UK english and £ currency

Reference no: EM131151174

Questions Cloud

Explain what key points would you address to boss and why : Your boss indicated to you not to worry as these are not material. However in your view they are! What key points would you address to your boss and why?

Explain why viscosity is an important property in fluid : 2. (a) (i) Define dynamic viscosity and give the mathematical formula for Newton's law of viscosity.(ii) How does kinematic viscosity differ from dynamic viscosity?(b) Explain why viscosity is an important property in Fluid Mechanics.

What are the advantages and disadvantages of each technique : Curves can be established by occupying cL or offset stations and then turning off appropriate deflection angles, or curves can be established by occupying a central control station and then turning off angles and measuring out distances-as determi..

How many kilowatt can alternator supply for same kva loading : If the power factor is raised to unity, how many more kilowatts can alternator supply for the same kVA loading ?

Calculate the average marks for each student : 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.

Company suppliers for its new geared turbofan : Pratt & Whitney has bet billions on its commercial jet engine market, but first, it has to get parts delivered on time. The Wall Street Journal (June 8, 2016) reports that half of the company’s suppliers for its new “geared turbofan” engines aren’t d..

Definition of characteristic impedance : At resonance, a series RLC circuit will be:- definition of characteristic impedance? -When moving from the source to load, current and voltage traveling waves move:

Benefits of businesses working together on a global scale : Write a 300 word discussion on the benefits of businesses working together on a global scale to survive and discuss the three main aspects of business that companies need to successfully understand before entering a foreign market. The three aspe..

User Account

All Pages