|
| View All Microsoft Excel Misc Posts Ask A New Question |
|
Excel Spreadsheet |
Que posted on Saturday, November 07, 2009 7:51 AM
|
I am an educator and I would like to develop a spreadsheet that calculates
the percentage of student grades. For example, The students took a test and I
would like to know that 80% of the class did 80% or better on any assessment.
Please assist... |
 |
|
| |
|
|
Say the data was |
Gary''s Student posted on Saturday, November 07, 2009 8:50 AM
|
Say the data was like:
SMITH 51
JOHNSON 69
WILLIAMS 55
JONES 75
BROWN 65
DAVIS 83
MILLER 74
WILSON 81
MOORE 66
TAYLOR 83
ANDERSON 89
THOMAS 55
JACKSON 66
WHITE 74
HARRIS 84
MARTIN 79
THOMPSON 55
GARCIA 89
MARTINEZ 62
ROBINSON 67
CLARK 65
RODRIGUEZ 59
LEWIS 92
LEE 90
WALKER 73
HALL 90
ALLEN 95
YOUNG 59
HERNANDEZ 94
KING 89
WRIGHT 92
LOPEZ 94
HILL 72
SCOTT 57
GREEN 92
ADAMS 54
BAKER 73
GONZALEZ 74
NELSON 68
CARTER 83
MITCHELL 77
PEREZ 80
ROBERTS 90
TURNER 63
PHILLIPS 52
CAMPBELL 63
PARKER 63
EVANS 81
EDWARDS 62
COLLINS 93
STEWART 55
SANCHEZ 98
MORRIS 95
ROGERS 75
REED 57
COOK 62
MORGAN 66
BELL 62
MURPHY 83
BAILEY 71
RIVERA 61
COOPER 86
RICHARDSON 53
COX 76
HOWARD 97
WARD 76
TORRES 68
PETERSON 58
GRAY 56
RAMIREZ 72
JAMES 84
WATSON 52
BROOKS 82
KELLY 58
SANDERS 81
PRICE 100
BENNETT 78
WOOD 77
BARNES 98
ROSS 92
HENDERSON 91
COLEMAN 79
JENKINS 75
PERRY 63
POWELL 85
LONG 66
PATTERSON 74
HUGHES 93
FLORES 58
WASHINGTON 71
BUTLER 86
SIMMONS 94
FOSTER 78
GONZALES 69
BRYANT 67
ALEXANDER 66
RUSSELL 71
GRIFFIN 70 |
 |
|
|
|
|
| Previous Microsoft Excel Misc conversation. |