|
|
|
|
|
Task 1 |
|
Q2 |
Task 2 |
|
|
|
|
|
|
|
|
|
|
|
|
Part II: Excel Problem Solving |
TOTAL |
Curve |
Curve |
|
|
|
|
DP |
Time |
Time |
Multiple Choice |
Q1
most to least BASE CASE |
Q1
Data Connect |
Q1
Bar Labels |
Q1
Xaxis |
Q1
Title |
Q1
Overall |
Your Code |
Q2 |
Q3
Base |
Q3
Data Connect |
Q3
Colum Labels |
Q3
Xaxis |
Ben fordian Explain |
Q3 Overall |
Task 1 |
|
Task 2 |
|
Task 3 |
|
|
After
Take Home |
In Class |
In Class & Take home |
Part
1 & Part 2 |
|
|
Task 1 Notes |
Task 2 |
Task 3 Notes |
|
|
1st |
2nd |
10 |
10 |
10 |
2 |
2 |
2 |
4 |
5 |
10 |
10 |
10 |
2 |
2 |
7 |
4 |
35 |
|
10 |
|
35 |
|
80 |
0.8 |
0.4 |
64% |
67% |
7% |
74% |
|
|
|
Saidainuphos |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0% |
|
|
|
|
|
|
|
tinkerbell |
D |
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0% |
|
|
|
|
|
|
|
Skelar |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0% |
|
|
|
|
|
|
|
Omryn |
D |
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0% |
|
|
|
|
|
|
|
Morycha |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0% |
|
|
|
|
|
|
|
The Sweet Magnolia |
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0% |
|
|
|
|
|
|
|
Happy Gilmore |
|
10:04AM |
12:17PM |
9 |
10 |
10 |
2 |
2 |
2 |
4 |
5 |
10 |
10 |
10 |
2 |
2 |
4.2 |
4 |
31 |
89% |
10 |
100% |
32.2 |
92% |
77.2 |
97% |
80% |
109% |
103% |
|
110% |
|
|
Corrected uniform v1 to correct
distribution, Benfordian explaination not deep enough. |
Beyonce |
|
10:07AM |
4:52PM |
10 |
10 |
10 |
2 |
2 |
2 |
4 |
4 |
10 |
8 |
8 |
2 |
2 |
7 |
4 |
34 |
97% |
10 |
100% |
31 |
89% |
75 |
94% |
43% |
92% |
95% |
|
102% |
Q1: not clear, but it looks like
result was arrived by sorting. Analysis, need to be more conclusive. |
|
Countif - not working correctly,
uniform instead of Benfordian, analysis good. |
Elton McKnight |
|
10:07AM |
10:26AM-SAT |
6 |
10 |
8 |
2 |
2 |
2 |
4 |
3 |
10 |
10 |
8 |
2 |
2 |
5.6 |
4 |
31 |
89% |
10 |
100% |
31.6 |
90% |
72.6 |
91% |
82% |
105% |
90% |
|
97% |
Q1: not improved. |
|
Q2, messed up raw data. Also
data is not aligned to the correct leading digit. Analysis of Benford not dep enough. |
Miss New Booty |
|
10:06AM |
11:06AM |
9 |
7 |
0 |
2 |
2 |
2 |
2 |
0 |
10 |
10 |
10 |
2 |
2 |
6 |
4 |
15 |
43% |
10 |
100% |
34 |
97% |
59 |
74% |
74% |
89% |
89% |
|
96% |
Q1: Tallied result from image?
Not connection to workbook, no deep analysis of 4 digit code. |
|
|
Robin Sparkles |
|
10:05AM |
10:27AM |
8 |
10 |
10 |
0 |
2 |
2 |
4 |
2 |
10 |
10 |
10 |
0 |
1 |
7 |
4 |
30 |
86% |
10 |
100% |
32 |
91% |
72 |
90% |
51% |
93% |
88% |
|
95% |
Evaded 4 digit code question, no
analysis. |
|
X-Axis not labeled properly. No
labels on columns |
Bulldawg |
|
10:13AM |
3:04PM |
9 |
10 |
10 |
2 |
2 |
0 |
4 |
0 |
10 |
10 |
10 |
2 |
1 |
0 |
4 |
28 |
80% |
10 |
100% |
27 |
77% |
65 |
81% |
45% |
83% |
85% |
|
92% |
|
|
SUMIF, no analysis |
Georgia Moto |
|
10:05AM |
4:12PM |
6 |
8 |
10 |
2 |
2 |
2 |
3 |
0 |
10 |
9 |
10 |
1 |
2 |
3 |
4 |
27 |
77% |
10 |
100% |
29 |
83% |
66 |
83% |
75% |
96% |
84% |
|
91% |
Q1: Same as V1. |
Q3 Same as V1 |
Q3: used theoretical values for
percentte, looked at shape, no written analyss. |
Kileli |
|
3:07PM |
1:05AM |
8 |
10 |
10 |
2 |
2 |
2 |
4 |
3 |
10 |
10 |
10 |
2 |
2 |
7 |
4 |
33 |
94% |
10 |
100% |
35 |
100% |
78 |
98% |
18% |
85% |
83% |
|
90% |
2nd attempt, clear data
connection via sorting. |
|
|
Brerk Samson |
|
10:04AM |
3:45PM |
9 |
7 |
0 |
2 |
2 |
2 |
4 |
5 |
10 |
10 |
10 |
2 |
2 |
7 |
4 |
22 |
63% |
10 |
100% |
35 |
100% |
67 |
84% |
23% |
76% |
81% |
|
88% |
Frequency is not connected to
data in workbook. Hardcoded. |
|
|
Asparagus |
|
10:14AM |
11:47PM |
10 |
10 |
10 |
2 |
2 |
2 |
4 |
0 |
10 |
7 |
9 |
2 |
1 |
0 |
4 |
30 |
86% |
10 |
100% |
23 |
66% |
63 |
79% |
18% |
70% |
80% |
|
87% |
Q1: Used, Max, LARGE instead of
sort - OK. Don't need series legend. Handwritten X labels |
Done During Inclass Exam |
Countif - not working correctly,
uniform instead of Benfordian, X-axis not labeled correctly |
Annie |
|
10:13AM |
12:03AM-SAT |
8 |
10 |
10 |
2 |
2 |
2 |
4 |
5 |
6 |
10 |
9 |
2 |
2 |
7 |
4 |
35 |
100% |
6 |
60% |
34 |
97% |
75 |
94% |
8% |
78% |
79% |
|
86% |
Q1: Nicely done. |
Used/INT/RIGHT |
Q3: Missed a row for 1 leading
digit. |
Batman |
|
10:13AM |
2:46PM |
10 |
7 |
0 |
2 |
2 |
2 |
2 |
0 |
10 |
10 |
8 |
2 |
2 |
0 |
4 |
15 |
43% |
10 |
100% |
26 |
74% |
51 |
64% |
31% |
64% |
76% |
|
83% |
Q1: Tallied result from image?
Not connection to workbook, no deep analysis of 4 digit code. |
|
Q3 Percentage not computed (hard
coded). No analysis. |
DARCY 8808 |
|
10:04AM |
11:35AM |
7 |
5 |
0 |
2 |
2 |
2 |
2 |
3 |
10 |
10 |
10 |
2 |
1 |
5.6 |
4 |
16 |
46% |
10 |
100% |
32.6 |
93% |
58.6 |
73% |
46% |
77% |
75% |
|
82% |
Q1: Tallied result from image?
Not connection to workbook, no deep analysis of 4 digit code. |
Parameterized, filled all the way |
SUM |
Captin
Silverfox |
|
10:07AM |
10:59PM |
7 |
10 |
9 |
2 |
2 |
2 |
4 |
0 |
10 |
7 |
9 |
2 |
1 |
0 |
4 |
29 |
83% |
10 |
100% |
23 |
66% |
62 |
78% |
38% |
77% |
75% |
|
82% |
Q1: Used, Max, LARGE instead of
sort - Selection however is offset. |
|
Countif - not working correctly,
uniform instead of Benfordian, X-axis not labeled correctly |
Chicken Little |
|
10:14AM |
|
9 |
5 |
0 |
2 |
2 |
2 |
3 |
3 |
10 |
8 |
8 |
0 |
0 |
0 |
2 |
17 |
49% |
10 |
100% |
18 |
51% |
45 |
56% |
55% |
67% |
75% |
|
82% |
|
|
|
peanut |
|
10:02AM |
11:31PM |
6 |
10 |
10 |
2 |
2 |
2 |
4 |
5 |
10 |
10 |
6 |
2 |
1 |
7 |
4 |
35 |
100% |
10 |
100% |
30 |
86% |
75 |
94% |
13% |
80% |
73% |
|
80% |
Q1: Outstanding! |
Q2: Same as v1 |
Q3: Computation is not clear,
uniform distribution (used countif perhaps - nbut not clear), presentation is
very nice. X-axis are incorrectly labeled |
Vyeshnost |
|
10:04AM |
10:32PM |
8 |
5 |
0 |
2 |
2 |
2 |
2 |
2 |
10 |
10 |
8 |
2 |
1 |
7 |
4 |
15 |
43% |
10 |
100% |
32 |
91% |
57 |
71% |
26% |
68% |
72% |
|
79% |
Q1: Tallied result from image?
Not connection to workbook, no deep analysis of 4 digit code. |
Hardcoded 3. |
Q2 Formatting error for 4th
digit. Data connectivity using SUM. Percent is not computed in data sheet. |
Disney World |
|
10:21AM |
9:12PM |
8 |
10 |
10 |
2 |
2 |
2 |
4 |
0 |
6 |
10 |
10 |
2 |
1 |
0 |
4 |
30 |
86% |
6 |
60% |
27 |
77% |
63 |
79% |
8% |
66% |
71% |
|
78% |
INDEX, MATCH, no analysis,
nicely done! |
Used/INT/LEFT not working |
X-axis not preoperly labeled.
Leading digit 0 and 1 confused, no analysis. |
Claire |
|
9:59AM |
6:50PM |
10 |
5 |
0 |
2 |
2 |
2 |
3 |
3 |
10 |
5 |
0 |
2 |
2 |
4 |
3 |
17 |
49% |
10 |
100% |
16 |
46% |
43 |
54% |
30% |
55% |
70% |
|
77% |
|
|
|
Jamie |
|
10:05AM |
3:23PM |
7 |
10 |
10 |
2 |
2 |
2 |
4 |
0 |
10 |
10 |
6 |
2 |
2 |
0 |
4 |
30 |
86% |
10 |
100% |
24 |
69% |
64 |
80% |
13% |
69% |
69% |
|
76% |
Q1: No analysis of personal 4
digigt passcodes |
|
Q3: No analysis (Benfordian) |
Golden
Sunshine |
|
10:08AM |
10:35PM |
10 |
7 |
0 |
0 |
1 |
2 |
2 |
5 |
10 |
4 |
0 |
2 |
1 |
2 |
2 |
17 |
49% |
10 |
100% |
11 |
31% |
38 |
48% |
24% |
48% |
65% |
|
72% |
Q1: Tallied result from image?
Not connection to workbook, x-axis not properly labeled. |
Hardcoded 3. |
Q3: Tallied result from image?
Don't see any connectivity of data in workbook and plot. X-axis not labeled
properly. Analysis does not reflect plot? |
Peter Parker |
|
10:07AM |
Sun |
7 |
0 |
0 |
2 |
0 |
2 |
4 |
0 |
10 |
10 |
10 |
2 |
1 |
5.6 |
4 |
8 |
23% |
10 |
100% |
32.6 |
93% |
50.6 |
63% |
23% |
60% |
63% |
|
70% |
Frequency plot is not connected
to the submitted workbook. |
Done During Inclass Exam |
X-axis not preoperly labeled.
Leading digit 0 and 1 confused. |
Eva Unit 02 |
|
10:04AM |
|
8 |
5 |
0 |
2 |
2 |
2 |
2 |
5 |
10 |
|
|
|
|
7 |
|
18 |
51% |
10 |
100% |
7 |
20% |
35 |
44% |
44% |
53% |
62% |
|
69% |
|
|
|
Tootsie |
|
9:56AM |
|
8 |
7 |
10 |
0 |
2 |
2 |
3 |
0 |
10 |
|
|
|
|
|
|
24 |
69% |
10 |
100% |
0 |
0% |
34 |
43% |
44% |
52% |
61% |
|
68% |
|
|
|
Aldo Raine |
|
|
SUN |
5 |
10 |
10 |
2 |
1 |
0 |
4 |
0 |
10 |
10 |
10 |
2 |
1 |
0 |
4 |
27 |
77% |
10 |
100% |
27 |
77% |
64 |
80% |
0% |
64% |
59% |
|
66% |
LARGE |
|
|
Barbra Walters |
|
10:31AM |
5:13PM |
6 |
6 |
0 |
0 |
2 |
2 |
2 |
3 |
10 |
6 |
4 |
0 |
1 |
7 |
4 |
15 |
43% |
10 |
100% |
22 |
63% |
47 |
59% |
21% |
56% |
57% |
|
64% |
|
Parameterized, filled all the way |
Indicated use of Countif
eventhought that work is not demonstrated in the worksheet. |
Eustyru |
|
10:03AM |
10:40PM |
8 |
6 |
0 |
0 |
0 |
0 |
2 |
0 |
10 |
6 |
10 |
0 |
0 |
4 |
2 |
8 |
23% |
10 |
100% |
22 |
63% |
40 |
50% |
13% |
45% |
57% |
|
64% |
Q1: Data from image of test? No
Data connecdtion in worksheet. Plot is confusing? |
|
Q3: Computed via Counif -
uniform distribution, no plot, no plot, no analysis |
Rusty
Shakleford |
|
10:06AM |
|
7 |
|
|
|
|
|
|
|
10 |
7 |
10 |
0 |
2 |
0 |
4 |
0 |
0% |
10 |
100% |
23 |
66% |
33 |
41% |
41% |
50% |
56% |
|
63% |
|
|
|
Ms.SnakeyK |
|
10:07AM |
9:29PM |
8 |
|
|
|
|
|
|
|
10 |
6 |
10 |
|
|
|
|
0 |
0% |
10 |
100% |
16 |
46% |
26 |
33% |
33% |
39% |
53% |
|
60% |
No attempt |
Parameterized, filled all the way |
Attempt, but no result. |
Tyaralrin |
|
10:04AM |
|
6 |
10 |
10 |
0 |
2 |
0 |
3 |
0 |
5 |
|
|
|
|
|
|
25 |
71% |
5 |
50% |
0 |
0% |
30 |
38% |
38% |
45% |
50% |
|
57% |
No |
Wrong forula, not displayed
correclty |
|
Mysterious
Dr.X |
|
10:09AM |
|
7 |
7 |
0 |
0 |
1 |
2 |
2 |
4 |
6 |
|
|
|
|
|
|
16 |
46% |
6 |
60% |
0 |
0% |
22 |
28% |
28% |
33% |
45% |
|
52% |
Q1: Tallied result from image?
Not connection to workbook, x-axis not properly labeled. |
No formula, looks like it is
manualluy enered, not filled in to bottom |
Not attempted |
Boots and cats |
|
9:57AM |
|
8.5 |
|
|
|
|
|
|
|
10 |
|
|
|
|
|
|
0 |
0% |
10 |
100% |
0 |
0% |
10 |
13% |
13% |
15% |
38% |
|
45% |
No attempt |
Parameterized, filled all the way |
No attempt |
Jesse Pinkman |
|
10:42AM |
|
9 |
|
|
|
|
|
|
2 |
|
|
|
|
|
4.2 |
|
2 |
6% |
0 |
0% |
4.2 |
12% |
6.2 |
8% |
8% |
9% |
36% |
|
43% |
Q1: not attempted, image
snapshot from web site. |
Not correct. |
Q3: not attempted. |
MinionNinja |
|
10:12AM |
|
5 |
|
|
|
|
|
|
|
7 |
|
|
|
|
|
|
0 |
0% |
7 |
70% |
0 |
0% |
7 |
9% |
9% |
11% |
24% |
|
31% |
No 2nd submission |
No submission |
No 2nd submission |
Sauce Boss |
|
10:00AM |
|
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
0% |
0 |
0% |
0 |
0% |
0 |
0% |
0% |
|
20% |
|
27% |
No submission |
No submission |
No submission |