Grade Sheet - Excel

Document Sample
Grade Sheet - Excel Powered By Docstoc
					IE 101
2009 Fall Grading:
Student ID

Orientation
Lower limit for A, if Curve:
MT1 MT2 Final Ass.1 Ass.2 Ass.3

Catalog
Name

85
Ass.4

1343177 1343178 1343179 1343180 1343181 1343182 1343183 1343184 1343185 1343186 1343187 1343188 1343189 1343190 1343191 1343192 1343193 1343194 1343195

A. Brown B. James A. Green P. Jackson M. Jordan S. Jackson H. Lee L. James P.J. Brown S. Watson A. Wine C. Wade S.Oneil A.Davids C.Cox C.Love L. James A.Brown K.Conolly

60 60 60 40 60 60 100 60 100 60 44 53 76 100 60 60 60 60 60

85 85 85 85 85 85 85 85 100 85 85 85 85 44 53 76 100 85 85

75 100 75 75 75 75 44 53 76 100 75 75 44 53 76 100 75 75 75

100 100 100 20 36 44 53 76 100 100 60 60 100 60 60 100 60 60 100

48 100 60 60 100 100 100 60 60 100 100 20 36 44 53 76 100 100 100

48 60 60 20 36 44 53 76 100 44 53 76 100 44 53 76 100 60 60

5 10 15 20 25 30 35 40 100 50 55 60 65 70 75 80 85 90 95

56.47

72.53

64.21

62.58

66.16

52.79

47.11

ation

J.Brown
# of Students: 19

Quiz 1

Quiz 2

Quiz 3

Quiz 4

Attended Lecture

Avg.

Letter

100 95 90 85 80 75 70 65 100 55 50 45 100 100 44 53 76 100 100

100 100 60 60 100 80 63 74 46 100 63 20 36 44 53 76 99 85 17

100 100 44 53 76 100 100 20 36 44 53 76 100 100 100 60 60 100 100

100 60 60 100 100 44 53 76 100 100 100 100 100 20 36 44 53 76 100

10 3 8 4 9 9 4 6 3 7 8 9 8 8 4 8 9 4 5

75.05 0.00 69.45 63.90 72.65 70.85 64.50 61.65 0.00 83.40 70.10 67.15 67.60 59.25 64.25 80.65 78.90 78.55 78.60

BNA C+ C BBC+ C NA B+ BC+ C+ C C+ B B B B

67.79

59.47

67.68

66.42

6.63

63.50

C

10% 19 1073
MT1

15% 1378
MT2

35% 1220
Final

39 45 51 57 63 69 75 81 87 94 100

0 40 46 52 58 64 70 76 82 88 95

F D D+ CC C+ BB B+ AA

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0

60 0 60 40 60 60 100 60 0 60 44 53 76 100 60 60 60 60 60 0 0 0 0 0 0 0 0 0 0 0

85 0 85 85 85 85 85 85 0 85 85 85 85 44 53 76 100 85 85 0 0 0 0 0 0 0 0 0 0 0

75 0 75 75 75 75 44 53 0 100 75 75 44 53 76 100 75 75 75 0 0 0 0 0 0 0 0 0 0 0

5% 1189
Ass.1

5% 1257
Ass.2

5% 1003
Ass.3

5% 895
Ass.4

5% 1288
Quiz 1

5% 1130
Quiz 2

5% 1286
Quiz 3

5% 1262
Quiz 4

126
Attended Lecture

100 0 100 20 36 44 53 76 0 100 60 60 100 60 60 100 60 60 100 0 0 0 0 0 0 0 0 0 0 0

48 0 60 60 100 100 100 60 0 100 100 20 36 44 53 76 100 100 100 0 0 0 0 0 0 0 0 0 0 0

48 0 60 20 36 44 53 76 0 44 53 76 100 44 53 76 100 60 60 0 0 0 0 0 0 0 0 0 0 0

5 0 15 20 25 30 35 40 0 50 55 60 65 70 75 80 85 90 95 0 0 0 0 0 0 0 0 0 0 0

100 0 90 85 80 75 70 65 0 55 50 45 100 100 44 53 76 100 100 0 0 0 0 0 0 0 0 0 0 0

100 0 60 60 100 80 63 74 0 100 63 20 36 44 53 76 99 85 17 0 0 0 0 0 0 0 0 0 0 0

100 0 44 53 76 100 100 20 0 44 53 76 100 100 100 60 60 100 100 0 0 0 0 0 0 0 0 0 0 0

100 0 60 100 100 44 53 76 0 100 100 100 100 20 36 44 53 76 100 0 0 0 0 0 0 0 0 0 0 0

10 3 8 4 9 9 4 6 3 7 8 9 8 8 4 8 9 4 5 0 0 0 0 0 0 0 0 0 0 0

NA?

FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

GRADE EVALUATION SYSTEM
Course Code Course Name Instructor's Name Year/Semester IE 101 Orientation J.Brown 2009

/

Fall

Grade Components Midterm1 Midterm2 Final Quizzes (up to 4) Number of quizzes Assignments (up to 4) Number of assignments Attendance Limit * Total 10% 15% 35% 5% 4 5% 4 4 100%

* If the student has an attendance lower than the attendance limit, he/she gets N/A. Grades of these students are not included in the average calculations.

0 43.7931 50.36207 56.93103 63.5 66.98649 70.47297 73.95946 77.44595 80.93243 85

Fall Spring Summer 2 Curve Catalog

1

F D D+ CC C+ BB B+ AA

MT1 MT2 MT3 MT4 MT5 Final Ass Quiz Project

Grade A AB+ B BC+ C CD+ D F

Grading Scale Catalog Curve 95 85 88 80.93243 82 77.44595 76 73.95946 70 70.47297 64 66.98649 58 63.50 52 56.93103 46 50.36207 40 43.7931 0 0

85 81.41667 77.83333 74.25 70.66667 67.08333 63.5 59.91667 56.33333 52.75 49.16667

21.50

3.583333

Follow the steps to enable your Grade Sheet.
>> 1) >> 2) This template is prepared for tracking and evaluating the grades of students easily. The template can be used for a class of up to 30 students. Provide the necessary information on the "GradeComponents" sheet. Your Grade Sheet is ready to use. Following steps are for online use. Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your Grade Sheet. 3) Visit the site below: http://trial.spreadsheetweb.com/spreadsheetweb/ Login to page with your new account information. 4) Click "Add Web Application" to upload this file. Check "Single Record Application", this will enable to save the grade sheet online. Your Grade Sheet will be created automatically. You can simply use the Grade Sheet from that link or place it on your website. >> >> Your Grade Sheet will look like: http://www1.spreadsheetweb.com/SpreadSheetWeb/Output.aspx?ApplicationId=7cfb4b81-abdb-4341-8380-fced334a8e1d In order to see more online applications created with SpreadsheetWEB, you can check the link below: http://www.spreadsheetweb.com/demos.htm

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

ave the grade sheet online.

1-8380-fced334a8e1d


				
DOCUMENT INFO
Description: First purpose of this template is keeping track of the grades of students. Grades of 2 midterms, 1 final, 4 attendances and 4 quizes may be stored. Also attandences may be followed. Secondly, this template helps to calculate the final grades of students easily. Weights of the grade components (midterms, final, etc.) are entered by the user. And the grades of students are calculated depending "Curve" or "Catalog" calculations.