For jahguy

profiledevilmycry1
pedagogy-experiment-2015_1.xlsx
Home>Computer Science homework help>For jahguy

Sheet1

Data for New Math/Science Pedagogy Experiment
LN here FN here Note in comment
Zhang, Yue: Zhang, Yue: Apply ALL of the following Excel skills in this spreadsheet: (0) use proper references; (1) AVG, MAX, MIN, StDev, Median; (2) COUNTIF, IF with threshold; (3) VLOOKUP, + IF to determine the lookup table and column - "DWP"-type of question; (4) IF (for comparison), with VLOOKUP to find the right values to compare - "LA Health Dept"-type of question; (5) Pivot table If you feel some parts difficult, you can leave those parts off, but with point deductions. PLEASE TRY YOUR BEST. Part (3) has a little bit extra thinking, when the search is done with student's name, since the 2nd half of the spreadsheet only has ID but no name - so tolookup the math-science group pf subjects you have to first lookup the corresponding ID using the name entered.
No StudID Student Cat Code
Zhang, Yue: Zhang, Yue: 1 - California 2 - Other US states 3 - International		 English History Am Govmt Sociology Human/ Social StudID Math Bio Physics Chem Math/ Sci Comparison
Grp I Grp II Grp III Grp I Grp II Grp III Grp I Grp II Grp III
Zhang, Yue: Zhang, Yue: Group III is the average of the two subjects in the group
Zhang, Yue: Zhang, Yue: 1 - California 2 - Other US states 3 - International
Zhang, Yue: Zhang, Yue: Apply ALL of the following Excel skills in this spreadsheet: (0) use proper references; (1) AVG, MAX, MIN, StDev, Median; (2) COUNTIF, IF with threshold; (3) VLOOKUP, + IF to determine the lookup table and column - "DWP"-type of question; (4) IF (for comparison), with VLOOKUP to find the right values to compare - "LA Health Dept"-type of question; (5) Pivot table If you feel some parts difficult, you can leave those parts off, but with point deductions. PLEASE TRY YOUR BEST. Part (3) has a little bit extra thinking, when the search is done with student's name, since the 2nd half of the spreadsheet only has ID but no name - so tolookup the math-science group pf subjects you have to first lookup the corresponding ID using the name entered.		 Hu/So vs Mth/Sci
1 1683597 Adms 1 41 63 61 73 331135 42 61 55 41
2 5465371 Brown 2 76 47 89 80 481389 76 60 63 58
3 3679959 Chandler 2 96 71 90 73 774705 63 67 53 94
4 3489027 Chen 1 89 49 67 93 806959 76 43 48 83
5 6187026 Davis 2 89 60 76 41 816496 71 91 81 68
6 481389 Davidson 1 68 58 78 54 942860 76 64 73 69
7 8345338 Edwards 2 94 30257 87 88 1683597 74 84 96 71
8 331135 Fong 3 45 54 62 83 2499778 61 46 88 80
9 3652128 Gonzalez 1 75 72 69 79 3489027 63 63 41 63
10 806959 Hanks 2 53 87 89 88 3652128 68 61 80 98
11 3927555 Imhoff 1 72 49 84 77 3679959 66 46 57 65
12 4452553 Jung 2 53 77 92 52 3927555 52 45 97 66
13 942860 Kim 3 72 46 70 76 4452553 72 78 54 71
14 816496 Kachakian 1 79 46 84 76 5465371 65 88 54 91
15 8179707 Lawrence 2 70 90 98 84 6187026 53 64 95 74
16 8066204 Liu 1 46 71 78 66 6311521 54 62 66 62
17 2499778 Maxwell 2 81 63 57 46 7545029 55 90 54 54
18 7545029 Park 1 89 53 90 88 8066204 49 64 67 70
19 774705 Perez 1 81 42 58 88 8179707 76 88 69 83
20 6311521 Wang 3 44 73 80 64 8345338 42 63 79 49
Note: just use the space given
StudId match them
Comapre Gr1 left and right
Compare gr2 left and right
Lookup Convert Name to StudID so lookup inside lookup
StudID Name English History Am Govmt Sociology Human/Social Math Bio Physics Chemistry Math/Sci