Embed
Email

spreadsheet

Document Sample

Shared by: wanghonghx
Categories
Tags
Stats
views:
0
posted:
12/4/2011
language:
English
pages:
9
Demo School F.1A

Student No. Name Test 1 (20%) Test 2 (20%) Exam (60%) Average

1 Lucy 57 58 90 77

2 Moon 75 84 25 46.8

3 Nancy 72 95 82 82.6

4 O 76 25 84 70.6

5 Polly 53 53 63 59

6 Q 63 85 63 67.4

7 Roy 80 96 93 91

8 Susan 95 48 82 77.8

9 Yan 73 37 72 65.2

10 Ann 48 63 94 78.6

11 Bonnie 53 43 14 27.6

12 Candy 74 72 27 45.4

13 Don 63 62 82 74.2

14 E 69 55 16 34.4

15 F 55 94 37 52

16 GiGi 26 84 82 71.2

17 Helen 58 78 82 76.4

18 Ivy 94 64 72 74.8

19 John 41 52 93 74.4

20 Kary 22 64 26 32.8



Frequency Table

Grade Freq Curn. Freq Cun Freq. %

A 1 1 5

A- 1 2 10

B+ 7 9 45

B 2 11 55

B- 1 12 60

C+ 1 13 65

C 1 14 70

C- 0 14 70

D 1 15 75

F 5 20 100



Total 20







Frequency Distribution



8

6

4

No









2

4









No

2

0

A A- B+ B B- C+ C C- D F

Grade

A

PositionGrade Conversion Table for Total

5 B+ 0F

16 F 1F

2 A- 2F

11 B 3F

14 C 4F

12 B- 5F

1A 6F

4 B+ 7F

13 C+ 8F

3 B+ 9F

20 F 10 F

17 F 11 F

9 B+ 12 F

18 F 13 F

15 D 14 F

10 B 15 F

6 B+ 16 F

7 B+ 17 F

8 B+ 18 F

19 F 19 F

20 F

21 F

22 F

23 F

24 F

25 F

26 F

27 F

28 F

29 F

30 F

31 F

32 F

33 F

34 F

35 F

36 F

37 F

38 F

39 F

40 F

41 F

42 F

43 F

44 F

45 F

46 F

47 F

48 F

49 F

50 D

51 D

52 D

53 D

54 C-

55 C-

56 C-

57 C-

58 C

59 C

60 C

61 C

62 C+

63 C+

64 C+

65 C+

66 B-

67 B-

68 B-

69 B-

70 B

71 B

72 B

73 B

74 B+

75 B+

76 B+

77 B+

78 B+

79 B+

80 B+

81 A-

82 A-

83 A-

84 A-

85 A-

86 A

87 A

88 A

89 A

90 A

91 A

92 A

93 A

94 A

95 A

96 A

97 A

98 A

99 A

100 A

Demo School F.1A

Student No. Name Test 1 Test 2 Exam Aveage Position Grade

1 Ann 57 58 90 70.5 11 B

2 Bonnie 75 84 25 46.8 16 F

3 Candy 72 95 82 82.6 2 A-

4 Don 76 25 84 70.6 10 B

5 E 53 53 63 59 14 C

6 F 63 85 63 67.4 12 B-

7 GiGi 80 96 93 91 1 A

8 Helen 95 48 82 77.8 4 B+

9 Ivy 73 37 72 65.2 13 C+

10 John 48 63 94 78.6 3 B+

11 Kary 53 43 14 27.6 20 F

12 Lucy 74 72 27 45.4 17 F

13 Moon 63 62 82 74.2 8 B+

14 Nancy 69 55 16 34.4 18 F

15 O 55 94 37 52 15 D

16 Polly 26 84 82 71.2 9 B

17 Q 58 78 82 76.4 5 B+

18 Roy 94 64 72 74.8 6 B+

19 Susan 41 52 93 74.4 7 B+

20 Yan 22 64 26 32.8 19 F



Frequency Table

Grade Freq Curn. Freq Cun Freq. %

A 1 1 5

A- 1 2 10

B+ 6 8 40

B 3 11 55

B- 1 12 60

C+ 1 13 65

C 1 14 70

C- 0 14 70

D 1 15 75

F 5 20 100



Total 20







Frequency Distribution



8

8

6

4

No 2

0

A A- B+ B B- C+ C C- D F

Grade

1

wt. Of test wt. Of test wt. Of test 3

2

30% 30% 40%



63.635

Grand Average of the whole class:

Standard Deviation: 17.9099



Grand Average Test 2

63.635 10% 20% 30%

Test 1 10% 64.285 64.125 63.965

20% 64.12 63.96 63.8

30% 63.955 63.795 63.635



Standard Deviation Test 2

17.90987 10% 20% 30%

Test 1 10% 18.4013 18.23862 18.10278

20% 18.23396 18.09898 17.99146

30% 18.0952 17.98855 17.90987



Related docs
Other docs by wanghonghx
Chap005
Views: 150  |  Downloads: 0
AntivirusInstructions_parent_
Views: 0  |  Downloads: 0
Dear friends_
Views: 0  |  Downloads: 0
A Film By William Friedkin
Views: 1  |  Downloads: 0
計算機網路
Views: 5  |  Downloads: 0
Annonsebrev
Views: 0  |  Downloads: 0
Camp Tejas Release Form
Views: 1  |  Downloads: 0
iprseligibilitymatrix
Views: 0  |  Downloads: 0
Australian Percussion Eisteddfod
Views: 6  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!