Week 13

In week 13, my partner and me were asked to do the planning of the budget in year 2012 and 1 table to record the mark of the student.

STEP TO CREATE THE PLANNING OF THE BUDGET IN YEAR 2012 BY USING SPREADSHEET 
First, open 'OpenOffice' and click spreadsheet. Then, you can key in all the information that you want.

To get the total amount of each allowance and expenses, you must click on the total amount and then press the button of `sum`. Then you highlight all the boxes that you want to sum.

After we finish key in all the data, we need to change the name of title from 'sheet 1' to 'Jan 2012'. By doing so, we just need to put the 'mouse' on the sheet 1 and then right click it and chose the word of 'rename'

After rename the sheet then we need to copy for all the 12 months. You just need to put the 'mouse' on 'Jan 12' then right click it and click 'move/ copy sheet'

Lastly, you need to click at 'sheet 2' then copy it and click ok.

Then, you can repeat the same things or step with the rest of the month.

When you satisfied with the report then you can save it and change it to pdf.

STEP TO CREATE A TABLE TO RECORD THE MARK OF THE STUDENT.

First, you need to open Microsoft Excel.  

Then,enter the name of the student, subjects, marks and also the minimum require for the grades.

You need to highlight the prior grades before you enter the grades in the empty states.

Then, you need to click 'formula' and 'define name'

After that, you need to chose vlookup and then click 'ok'.

After the boxes of 'vlookup' appear then you need to fill in the details and click on the boxes of score for the first grade at the lookup value. You also require to type the word of 'true' for the 'range_lookup'.

When finish key in the data then just click 'ok'  and the grades for the score will come out automatically.

Then, click on the first grades and highlight it and pull it down till the last person and the grades for each person will come out easily. Then, you can repeat the step for all the subjects.

STEP TO CALCULATE THE STANDARD DEVIATION

First click 'insert formula' at STDEV. You can repeat the step for all the subjects.

STEP TO CALCULATE MAXIMUM MARK

First you need to click 'insert function' and click 'max' and you can keep on repeating the step for all the subjects.

STEP TO CALCULATE MINIMUM MARK

First you need to click 'insert function' and click 'min' and you can keep on repeating the step for all the subjects.

STEP TO CALCULATE AVERAGE

First you need to click 'insert function' and click 'average' and you can keep on repeating the step for all the subjects.

STEP TO COUNT THE AMOUNT OF GRADE GETTING BY STUDENT ACCORDING TO THE SUBJECTS

Fist click 'insert function' then click 'countif' and you can keep on repeat the step for all the subjects.

STEP TO CREATE GRAPH

First, highlight the total amount of grades getting by the students according to the subjects. Then, you just to click 'insert' follow by 'column'. Then, you can chose the type of the graph that you like.

Then, the graph will be appear.