1 / 42

CALCULATION MARKS LIST

CALCULATION MARKS LIST. MARK LIST FOR HALF-YEARLY EXAMINATION 2005. FIND THE TOTAL MARKS. Type the formula “=sum(C5:L5)” and enter to find the total marks for pupil 1. Go back to marks of pupil 1 and drag down to get the total marks for all the pupils. FIND THE AVERAGE MARKS.

shea
Télécharger la présentation

CALCULATION MARKS LIST

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CALCULATION MARKS LIST

  2. MARK LIST FOR HALF-YEARLY EXAMINATION 2005

  3. FIND THE TOTAL MARKS • Type the formula “=sum(C5:L5)” and enter to find the total marks for pupil 1.

  4. Go back to marks of pupil 1 and drag down to get the total marks for all the pupils.

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

  6. The function argument display,drag the marks from C5:CL in the excel to get the average marks and click “ok button”

  7. Go back to marks of pupil 1 and drag down to get the average marks for all the pupils.

  8. Go to format,click cells,format cells display.Click the number in category and click 2 in decimal places and ok button to exit.

  9. The average marks are in 2 decimal places.

  10. 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”.

  11. 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 2in coloum index to get the gred and 1 for range lookup.Click “ok” button to exit.

  12. Go back to fx(Vlookup(N5,T2:V9,2,1),highlight T2:V9 , click F4and enter.

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

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

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

  16. Go back to fx(Vlookup(N5,T2:V9,2,1),highlight T2:V9 , click F4and enter.

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

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

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

  20. Go back to fx(Rank(N5,N5:N34,0),highlight N5:N34, click F4 and enter.

  21. Drag down to get the position for all pupils from position of pupil 1.

  22. ANALYSE THE GRED • Type A,B,C and D to find the total of each gred.

  23. Type the formula “=countif(O5:O34, “A”)” and enter to find the total of gred A.

  24. Type the formula “=countif(O5:O34, “B”)” and enter to find the total of gred B.

  25. Type the formula “=countif(O5:O34, “C”)” and enter to find the total of gred C.

  26. Type the formula “=countif(O5:O34, “D”)” and enter to find the total of gred D.

  27. ANALYSE THE CLASS • Type A,B,C and D to find the total of each class.

  28. Type the formula “=countif(P5:P34, “CEMERLANG”)” and enter to find the total of cemerlang.

  29. Type the formula “=countif(P5:P34, “KEPUJIAN”)” and enter to find the total of kepujian.

  30. Type the formula “=countif(P5:P34, “LULUS”)” and enter to find the total of lulus.

  31. Type the formula “=countif(P5:P34, “GAGAL”)” and enter to find the total of gagal.

  32. PROTECT SHEET • Highlight unprotect area,click tools in Menu bar , find protection and click protect sheet.

  33. Protect sheet appears,tick “select locked cells” and “select unlockedcells”.Type the password if want to keep safely.

  34. The B in the gred cannot be changed because that had been protected.

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

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

  37. (Step 2):The line with marks displayed at each data value.

  38. (Step 3):Insert chart title, X axis and Y axis to define each category.Click “next” button to continue.

  39. (STEP 4):Click “as object in sheet 1” means the line chart will display in the same page.Then,click “finish”button.

  40. The Line Chart shows the result of half-yearly examination 2005 class 1C in same page.

  41. (Step 4):If choose “as new sheet”,the Line Chart will show to chart 12.

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

More Related