Instructions:   Be sure to save backup copies of your grades, just in case. 1. Fill in your school name, class info, student names, and student IDs (optional).   2. Adjust the Grade & GPA table below to match the typical scoring system you use. 3. Fill in the assignment or test names (e.g. "Quiz 1") starting in cell F15, along with the points that each assignment is worth. 4. Fill in the scores for each student on each assignment or test. The "Average", "Ltr Grade" and "GPA" columns are automatically calculated, but you can override them if you wish. To award extra credit points, simply give more points on an assignment than the total possible points listed for that assignment. Note: Use the "Print Area" command on the File menu if you want to change what area prints.		GRADE & GPA TABLE
	Average	0%	60%	63%	69%	70%	73%	79%	80%	83%	89%	90%	93%	97%
	Ltr Grade	F	D-	D	D+	C-	C	C+	B-	B	B+	A-	A	A+
	GPA	0.00	0.67	1.00	1.33	1.67	2.00	2.33	2.67	3.00	3.33	3.67	4.00	4.00
			Folsom Lake College Brett Austin Bio 440, Microbiology Spring 2004					Return to Index
				Assignment or Test Name	Exam 1	Quiz 3/18	Exam 2	Homework	Exam 3	lab unk	Exam 4	follow-upE4	Critical thinking	O&p EC	EC	Lab Practical	Research	Final
				Possible Points	72	5	95	20	48	25	88		0	0	0	91	100	100
				Total number of assignments and tests:	14
				Total possible points:	644
STUDENT NAME	STUDENT ID	Average	Ltr Grade	GPA	Exam 1	Quiz 3/18	Exam 2	Homework	Exam 3(15-18)	Lab unknown	Exam 4	follow-upE4	Critical thinking	O&p EC	EC	Lab Practical	Research	Final
Abbey, Callie	550512	92.00%	A-	3.67	62	15	70	20	40	25	66	12	10		25	69	100	77
Barber, Kristin	947602	85.00%	B	3	46	11	86	23	35	25	25	22	10			87	98	82
Blalock, Breyan	691434	93.00%	A	4	71	12	79	20	43	25	41	24				88	100	98
Burnett, Lisa	685343	100.00%	A+	4	83	14	82	20	46	25	88		10	10		68	100	99
Campora, Nancy	767177	93.00%	A	4	56	12	81	20	33	25	70	14	10	10		72	95	98
Carlson, Nanmarie	782152	97.00%	A+	4	79	2	81	20	34	25	77	5			25	82	100	92
Clerici, Yvette	706571	98.00%	A+	4	71	15	80	20	41	25	47	12	10	10	25	80	100	96
Eagle, Emily	579605	98.00%	A+	4	59	10	87	20	43	25	33	35	10		25	81	100	100
Edsberg, Healther	636837	90.00%	A-	3.67	74	5	73	20	40	25	38	25	10			72	100	97
Feerick, Bernadette	922884	102.00%	A+	4	66	14	89	30	37	25	63	13	10		25	86	100	97
Fitz, Kimberlee	417601	93.00%	A	4	70	12	73	20	30	25	73		10	10	25	59	95	95
Henricks, Theresa	752260	104.00%	A+	4	83	15	86	20	45	25	101		10			87	100	100
Leaman, Michelle	685248	99.00%	A+	4	63	10	70	22	39	25	50	21	10	10	25	91	100	100
Madeira, Kathy	853282	90.00%	A-	3.67	66	10	70	20	38	25	41	26	10	10		67	100	99
Menzies, Stephanie	922812	89.00%	B+	3.33	66	4	66	20	43	25	44				25	82	100	96
Nolan, Sharyn	729691	98.00%	A+	4	71	14	62	20	0	25	136	10	10			88	100	98
Powers, Beth	738302	86.00%	B	3	64	10	65	23	27	25	40	17	10			89	100	84
Pribus, Kathy	977962	90.00%	A-	3.67	68	13	77	20	37	25	59	13	10			60	100	95
Purdy, Elizabeth	789534	93.00%	A	4	64	1	86	20	39	25	62	15			20	77	95	93
Ralphs, Jason	689004	76.00%	C	2	45	0	65	22	37	25	18	24	10			73	75	94
Ramli, Natalie	713784	83.00%	B	3	29	12	50	20	25	25	63		10		35	72	95	98
Showalter, Stephanie	997033	90.00%	A-	3.67	87	0	64	20	40	25	84		10			78	75	94
Smith, Amanda	543876	73.00%	C	2	59	12	64	0	43	25	0		0			76	100	93
Smith, Holly	965514	89.00%	B+	3.33	67	10	65	0	34	25	48	25		10	25	67	100	95
Supple, Suzanne	545022	89.00%	B+	3.33	54	0	65	20	28	25	41	26	10		25	82	95	99
CLASS SUMMARY		Average	Ltr Grade	GPA	Exam 1	Quiz 3/18	Exam 2	Homework	Exam 3(15-18)	Lab unknown	Exam 4	follow-upE4	Critical thinking	O&p EC	EC
Average		91.60%	A-	3.57	65	9	73	19	36	25	56	19	10	10	25	77	97	95
Highest Score		104.00%	A+	4.00	87	15	89	30	46	25	136	35	10	10	35	91	100	100
Lowest Score		73.00%	C	2.00	29	0	50	0	0	25	0	5	0	10	20	59	75	77
		Return to top