# SENARAI MARKAH MURID TAHUN SATU

Document Sample

```					CALCULATION MARKS LIST

1
MARK LIST FOR HALF-YEARLY
EXAMINATION 2005

2
FIND THE TOTAL MARKS

•   Type the formula “=sum(C5:L5)” and enter to find the total marks for pupil
1.
3
• Go back to marks of pupil 1 and drag down to get the total marks for
all the pupils.
4
FIND THE AVERAGE MARKS

• Click fx ,the box of insert function come out.Select “All” in
category.Then,select “average” in function and click “ok”button.
5
• The function argument display,drag the marks from C5:CL in the
excel to get the average marks and click “ok button”
6
• Go back to marks of pupil 1 and drag down to get the average marks
for all the pupils.
7
• Go to format,click cells,format cells display.Click the number in
category and click 2 in decimal places and ok button to exit.
8
• The average marks are in 2 decimal places.

9
FIND THE GRED

• Click fx ,the box of insert function come out.Select “Look up &
reference” in category.Then,select “Vlookup” in function and click
“ok”.
10
•   The function argument displayed,click average marks of pupil 1 to get lookup
value(N5).Highlight the table to get the table array(T2:V9).Type 2 in coloum
index to get the gred and 1 for range lookup.Click “ok” button to exit.
11
• Go back to fx(Vlookup(N5,T2:V9,2,1),highlight T2:V9 , click F4 and
enter.

12
• Drag down to get the gred for all pupils from gred of pupil 1.

13
FIND THE CLASS

•   Click fx ,the box of insert function come out.Select “Look up & reference” in
category.Then,select “Vlook up” in function and click “ok”button.
14
•   The function argument display,click average marks of pupil 1 to get lookup
value(N5).Highlight the table to get the table array(T2:V9).Type 3 in coloum
index to get the class and 1 for range lookup.Click “ok”button to exit.

15
• Go back to fx(Vlookup(N5,T2:V9,2,1),highlight T2:V9 , click F4 and
enter.

16
• Drag down to get the class for all pupils from class of pupil 1.

17
FIND THE POSITION

•   Click fx ,the box of insert function come out.Select “All” in category.Then,
select “Rank” in function and click “ok” button.

18
•   The function argument display,click average marks of pupil 1 to get
number:(N5) .Drag average marks for all pupils from N5 to N34 to get the
reference.Type “0” in order box.Click “ok” button to exit.
19
• Go back to fx(Rank(N5,N5:N34,0),highlight N5:N34, click F4 and
enter.
20
• Drag down to get the position for all pupils from position of pupil 1.

21
ANALYSE THE GRED

• Type A,B,C and D to find the total of each gred.
22
• Type the formula “=countif(O5:O34, “A”)” and enter to find the total
of gred A.
23
• Type the formula “=countif(O5:O34, “B”)” and enter to find the total
of gred B.
24
• Type the formula “=countif(O5:O34, “C”)” and enter to
find the total of gred C.
25
• Type the formula “=countif(O5:O34, “D”)” and enter to
find the total of gred D.
26
ANALYSE THE CLASS

• Type A,B,C and D to find the total of each class.
27
• Type the formula “=countif(P5:P34, “CEMERLANG”)”
and enter to find the total of cemerlang.
28
• Type the formula “=countif(P5:P34, “KEPUJIAN”)” and
enter to find the total of kepujian.
29
• Type the formula “=countif(P5:P34, “LULUS”)” and enter
to find the total of lulus.
30
• Type the formula “=countif(P5:P34, “GAGAL”)” and
enter to find the total of gagal.
31
PROTECT SHEET

• Highlight unprotect area,click tools in Menu bar , find
protection and click protect sheet.
32
• Protect sheet appears,tick “select locked cells” and “select unlocked
cells”.Type the password if want to keep safely.
33
•   The B in the gred cannot be changed because that had been protected.

34
MAKING CHART

• Highlight the gred of pupils,click chart wizard in tools bar.Chart
wizard will come out.

35
• (Step 1):Select chart type,chart sub-type and click next button.

36
• (Step 2):The line with marks displayed at each data value.
37
• (Step 3):Insert chart title, X axis and Y axis to define each
category.Click “next” button to continue.
38
• (STEP 4):Click “as object in sheet 1” means the line chart
will display in the same page.Then,click “finish”button.
39
• The Line Chart shows the result of half-yearly
examination 2005 class 1C in same page.
40
• (Step 4):If choose “as new sheet”,the Line Chart will show to chart 12.

41
• The Line Chart shows the result of half-yearly
examination 2005 class 1C in the other page.
42

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 7 posted: 9/15/2012 language: Unknown pages: 42
How are you planning on using Docstoc?