Activity 22 September

#	Name	Email	Major	Grade	IP Add.
1	afas	[email protected]	Digital Media	100	24.125.138.102
2	rrrrrrr	[email protected]	Security	25	24.125.138.102
3	wwwww	[email protected]	Other	75	24.125.138.102
4	dfg	[email protected]	Business	50	24.125.138.102
5	john	[email protected]	Software	50	168.28.22.146
6	Some Guy	[email protected]	Business	100	168.28.22.146
7	Alex Bui	[email protected]	Digital Media	100	168.28.22.146
8	asdf	[email protected]	Digital Media	0	50.147.203.70
9	asdf	[email protected]	Digital Media	25	50.147.203.70
10	asdf	[email protected]	Digital Media	25	50.147.203.70
11	sdf	[email protected]	Digital Media	25	50.147.203.70
12	sdf	[email protected]	Digital Media	25	50.147.203.70
13	asdf	[email protected]	Digital Media	100	50.147.203.70
14	asdf	[email protected]	Software	0	50.147.203.70
15	asdf	[email protected]	Digital Media	0	50.147.203.70
16	asdf	[email protected]	Business	0	50.147.203.70
17	asdf	[email protected]	Security	100	50.147.203.70
18	Carlos	[email protected]	Digital Media	100	168.28.22.146
19	Carlos	[email protected]	Digital Media	75	168.28.22.146
20	Carlos	[email protected]	Digital Media	50	168.28.22.146
21	Dude	[email protected]	Digital Media	75	168.28.22.146
22	Dude	[email protected]	Digital Media	100	168.28.22.146
23	hello	[email protected]	Digital Media	50	168.28.22.146
24	hello	[email protected]	Digital Media	50	168.28.22.146
25	carlos	[email protected]	Digital Media	100	168.28.22.146
26	carlos	[email protected]	Digital Media	75	168.28.22.146
27	carlos	[email protected]	Digital Media	75	168.28.22.146
28	carlos	[email protected]	Digital Media	0	168.28.22.146
29	carlos	[email protected]	Digital Media	0	168.28.22.146
30	Alvin	[email protected]	Digital Media	25	67.191.235.51
31	Alvin	[email protected]	Digital Media	100	67.191.235.51
32	carlos	[email protected]	Digital Media	0	99.141.154.74
33	carlos	[email protected]	Digital Media	25	99.141.154.74
34	asdasda	[email protected]	Security	0	98.192.41.27
35	asdasda	[email protected]	Security	0	98.192.41.27
36	asdasda	[email protected]	Security	100	98.192.41.27
37	Cameron	[email protected]	Digital Media	100	24.98.54.89
38	Cameron	[email protected]	Digital Media	0	24.98.54.89
39	Cameron	[email protected]	Digital Media	75	24.98.54.89
40	Cameron	[email protected]	Digital Media	75	24.98.54.89
41	Cameron	[email protected]	Digital Media	100	24.98.54.89
42	Cameron	[email protected]	Digital Media	100	24.98.54.89
43	Cameron	[email protected]	Digital Media	0	24.98.54.89
44	Cameron	[email protected]	Digital Media	0	24.98.54.89
45	Karl Kraus	[email protected]	Software	100	108.74.190.25
46	Karl Kraus	[email protected]	Software	75	108.74.190.25
47	Karl Kraus	[email protected]	Software	50	108.74.190.25
48	test	[email protected]	Digital Media	0	1.23.124.249
49	test	[email protected]	Digital Media	25	1.23.124.249
50	ertyui	[email protected]	Business	100	172.56.5.105
51	Fahd Quadri	[email protected]	Digital Media	100	172.56.4.213
52	Cameron	[email protected]	Digital Media	0	50.200.84.128
53	Karl Kraus	[email protected]	Software	50	108.74.190.25
54	sam	[email protected]	Other	100	168.28.22.10
55	f	[email protected]	Digital Media	0	168.28.2.98
56	ertyui	[email protected]	Digital Media	0	172.56.5.190
57	ladjkadjlkadsjdlk	[email protected]	Digital Media	25	168.28.22.41
58	ladjkadjlkadsjdlk	[email protected]	Software	100	168.28.22.41
59	abc	[email protected]	Digital Media	75	168.28.2.98
60	<span style="color:red">Someone</span>	[email protected]	Digital Media	0	168.28.22.59
61	asdfas	[email protected]	Digital Media	0	168.28.22.26
62	Samuel CHang	[email protected]	Digital Media	75	168.28.22.36
63	Samuel CHang	[email protected]	Other	75	168.28.22.36
64	abc	[email protected]	Digital Media	0	168.28.22.26
65	asdfa	[email protected]	Digital Media	0	168.28.22.26
66	[email protected]	[email protected]	Software	50	1.22.194.167
67	sadf	[email protected]	Digital Media	25	50.167.67.245
68	sadf	[email protected]	Security	25	50.167.67.245
69	Jacob	[email protected]	Software	100	168.28.22.40
70	Devora Lorenzo	[email protected]	Digital Media	25	168.28.22.44
71	potato	[email protected]	Digital Media	50	168.28.22.103
72	Devora Lorenzo	[email protected]	Digital Media	0	168.28.22.44
73	Dude	[email protected]	Digital Media	100	168.28.22.34
74	Dude	[email protected]	Digital Media	0	168.28.22.34
75	test	[email protected]	Software	0	1.22.88.169
76	test	[email protected]	Software	0	1.22.88.169
77	asdfa	[email protected]	Digital Media	0	168.28.22.120
78	Rodny Joseph	[email protected]	Digital Media	25	24.99.50.110
79	kuhku	[email protected]	Digital Media	0	24.99.50.110
80	kuhku	[email protected]	Digital Media	0	24.99.50.110
81	kuhku	[email protected]	Digital Media	25	24.99.50.110
82	kuhku	[email protected]	Digital Media	50	24.99.50.110
83	kuhku	[email protected]	Digital Media	50	24.99.50.110
84	dfgdf	[email protected]	Software	0	24.159.127.238
85	Travis Keating	[email protected]	Digital Media	25	96.32.85.89
86	sfdfd	[email protected]	Digital Media	0	24.99.247.234
87	sfdfd	[email protected]	Digital Media	0	24.99.247.234
88	sdf	[email protected]	Digital Media	100	4.15.179.163
89	goku	[email protected]	Digital Media	0	96.231.195.176
90	sdf	[email protected]	Digital Media	100	4.15.179.163
91	sdf	[email protected]	Digital Media	100	4.15.179.163
92	sdf	[email protected]	Digital Media	100	4.15.179.163
93	goku	[email protected]	Digital Media	0	96.231.195.176
94	sdf	[email protected]	Digital Media	100	50.167.67.245
95	sdf	[email protected]	Digital Media	100	50.167.67.245
96	Bria Rivers	[email protected]	Digital Media	100	24.125.233.10
97	sdf	[email protected]	Digital Media	100	50.167.67.245
98	goku	[email protected]	Digital Media	50	96.231.195.176
99	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
100	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
101	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
102	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
103	jack	[email protected]	Digital Media	100	50.160.207.11
104	Karl Kraus	[email protected]	Digital Media	0	168.28.22.86
105	Karl Kraus	[email protected]	Digital Media	0	168.28.22.86
106	Karl Kraus	[email protected]	Digital Media	25	168.28.22.86
107	dfg	[email protected]	Digital Media	100	168.28.16.100
108	Karina	[email protected]	Other	100	168.28.22.34
109	sdf	[email protected]	Digital Media	100	168.28.2.98
110	asdf	[email protected]	Software	100	24.159.127.238
111	Dude	[email protected]	Digital Media	100	168.28.22.34
112	Dude	[email protected]	Digital Media	100	168.28.22.34
113	Rebecca	[email protected]	Digital Media	25	71.204.64.171
114	Rebecca Tendean	[email protected]	Digital Media	0	71.204.64.171
115	Rebecca Tendean	[email protected]	Digital Media	0	71.204.64.171
116	Rebecca Tendean	[email protected]	Digital Media	25	71.204.64.171
117	Rebecca Tendean	[email protected]	Digital Media	25	71.204.64.171
118	Harry Potter	[email protected]	Software	100	71.204.64.171
119	sdf	[email protected]	Digital Media	100	50.167.67.245
120	sdf	[email protected]	Digital Media	100	50.167.67.245
121	sdf	[email protected]	Digital Media	100	50.167.67.245
122	abc	[email protected]	Digital Media	25	168.28.2.98
123	abc	[email protected]	Digital Media	25	168.28.2.98
124	abc	[email protected]	Digital Media	25	168.28.2.98
125	john joe	[email protected]	Digital Media	75	168.28.22.88
126	Fake	[email protected]	Digital Media	50	168.28.22.58
127	Joe	[email protected]	Digital Media	0	168.28.22.93
128	Miguel	[email protected]	Digital Media	100	168.28.22.96
129	Mike	[email protected]	Software	100	168.28.22.50
130	Fake	[email protected]	Digital Media	75	168.28.22.58
131	Fake	[email protected]	Digital Media	100	168.28.22.58
132	Joe	[email protected]	Digital Media	0	168.28.22.93
133	Mike	[email protected]	Software	100	168.28.22.50
134	jeff	[email protected]	Software	100	168.28.22.55
135	abf	[email protected]	Digital Media	0	168.28.2.98
136	john joe	[email protected]	Digital Media	75	168.28.22.88
137	Gloria Alvarenga	[email protected]	Digital Media	100	168.28.22.49
138	matthew	[email protected]	Business	75	168.28.22.49
139	Precious West	[email protected]	Digital Media	75	168.28.22.87
140	Mike	[email protected]	Software	100	168.28.22.50
141	Arthur	[email protected]	Digital Media	0	173.15.220.177
142	Jeff G	[email protected]	Software	25	65.5.11.253
143	a	[email protected]	Business	25	69.15.227.126
144	a	[email protected]	Business	25	69.15.227.126
145	a	[email protected]	Business	25	69.15.227.126
146	YMENG	[email protected]	Digital Media	25	168.28.2.98
147	a	[email protected]	Digital Media	0	107.167.116.228
148	4r4	[email protected]	Digital Media	0	168.28.16.100
149	4r4	[email protected]	Digital Media	0	168.28.16.100
150	er	[email protected]	Digital Media	25	96.32.85.3
151	adf	[email protected]	Digital Media	50	168.28.22.108
152	asdfads	[email protected]	Security	75	168.28.22.108
153	w	[email protected]	Digital Media	0	168.28.22.96
154	aef	[email protected]	Digital Media	0	73.207.104.73
155	a	[email protected]	Digital Media	0	24.125.222.199
156	dfg	[email protected]	Security	25	97.81.103.76
157	King Oruga	[email protected]	Software	100	50.167.235.114
158	King Oruga	[email protected]	Software	75	50.167.235.114
159	King Oruga	[email protected]	Software	75	50.167.235.114
160	dsf	[email protected]	Digital Media	0	73.207.104.73
161	dsf	[email protected]	Digital Media	100	73.207.104.73
162	Christan	[email protected]	Software	100	157.166.173.5
163	Chris	[email protected]	Digital Media	50	157.166.173.5
164	Chris	[email protected]	Digital Media	50	157.166.173.5
165	Chris	[email protected]	Digital Media	75	157.166.173.5
166	jay dizzle	[email protected]	Digital Media	25	168.28.22.95
167	jay dizzle	[email protected]	Digital Media	25	168.28.22.95
168	jay win	[email protected]	Digital Media	25	71.90.222.117
169	jay win	[email protected]	Digital Media	0	71.90.222.117
170	Joe Cox	[email protected]	Digital Media	25	159.63.144.227
171	Joe Cox	[email protected]	Digital Media	25	159.63.144.227
172	Joe Cox	[email protected]	Digital Media	0	159.63.144.227
173	blake	[email protected]	Digital Media	75	97.67.171.34
174	blake	[email protected]	Digital Media	75	97.67.171.34
175	mark	[email protected]	Digital Media	0	168.28.22.83
176	mark	[email protected]	Digital Media	0	168.28.22.83
177	mark	[email protected]	Security	25	168.28.22.83
178	mark	[email protected]	Security	50	168.28.22.83
179	Adam Printz	[email protected]	Digital Media	0	168.28.22.104
180	Adam Printz	[email protected]	Digital Media	0	168.28.22.104
181	Margaret Muse	[email protected]	Digital Media	25	168.28.22.108
182	mark	[email protected]	Security	100	168.28.22.83
183	Precious West	[email protected]	Digital Media	25	168.28.22.105
184	Jim Coburn	[email protected]	Digital Media	100	168.28.22.32
185	dwd	[email protected]	Digital Media	100	168.28.22.32
186	Carlan	[email protected]	Software	50	168.28.22.108
187	Carlan	[email protected]	Software	50	168.28.22.108
188	Carlan	[email protected]	Digital Media	75	168.28.22.108
189	Jim Coburn	[email protected]	Digital Media	100	168.28.22.32
190	mik	[email protected]	Digital Media	50	168.28.22.100
191	222	[email protected]	Digital Media	50	75.131.196.162
192	Miguel	[email protected]	Digital Media	0	75.131.192.68
193	Miguel	[email protected]	Digital Media	0	75.131.192.68
194	Dude	[email protected]	Digital Media	83	168.28.2.98
195	Dude	[email protected]	asdffffff	81	24.125.138.5

Total of 195 students/rows.

Total Security Majors = 11

Find all students with the Digital Media Major that also have 100 points on the test:

#	Name	Email	Major	Grade	IP Add.
1	afas	[email protected]	Digital Media	100	24.125.138.102
7	Alex Bui	[email protected]	Digital Media	100	168.28.22.146
13	asdf	[email protected]	Digital Media	100	50.147.203.70
18	Carlos	[email protected]	Digital Media	100	168.28.22.146
22	Dude	[email protected]	Digital Media	100	168.28.22.146
25	carlos	[email protected]	Digital Media	100	168.28.22.146
31	Alvin	[email protected]	Digital Media	100	67.191.235.51
37	Cameron	[email protected]	Digital Media	100	24.98.54.89
41	Cameron	[email protected]	Digital Media	100	24.98.54.89
42	Cameron	[email protected]	Digital Media	100	24.98.54.89
51	Fahd Quadri	[email protected]	Digital Media	100	172.56.4.213
73	Dude	[email protected]	Digital Media	100	168.28.22.34
88	sdf	[email protected]	Digital Media	100	4.15.179.163
90	sdf	[email protected]	Digital Media	100	4.15.179.163
91	sdf	[email protected]	Digital Media	100	4.15.179.163
92	sdf	[email protected]	Digital Media	100	4.15.179.163
94	sdf	[email protected]	Digital Media	100	50.167.67.245
95	sdf	[email protected]	Digital Media	100	50.167.67.245
96	Bria Rivers	[email protected]	Digital Media	100	24.125.233.10
97	sdf	[email protected]	Digital Media	100	50.167.67.245
99	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
100	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
101	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
102	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
103	jack	[email protected]	Digital Media	100	50.160.207.11
107	dfg	[email protected]	Digital Media	100	168.28.16.100
109	sdf	[email protected]	Digital Media	100	168.28.2.98
111	Dude	[email protected]	Digital Media	100	168.28.22.34
112	Dude	[email protected]	Digital Media	100	168.28.22.34
119	sdf	[email protected]	Digital Media	100	50.167.67.245
120	sdf	[email protected]	Digital Media	100	50.167.67.245
121	sdf	[email protected]	Digital Media	100	50.167.67.245
128	Miguel	[email protected]	Digital Media	100	168.28.22.96
131	Fake	[email protected]	Digital Media	100	168.28.22.58
137	Gloria Alvarenga	[email protected]	Digital Media	100	168.28.22.49
161	dsf	[email protected]	Digital Media	100	73.207.104.73
184	Jim Coburn	[email protected]	Digital Media	100	168.28.22.32
185	dwd	[email protected]	Digital Media	100	168.28.22.32
189	Jim Coburn	[email protected]	Digital Media	100	168.28.22.32

Total of 39 students/rows.

Find all software students with 0 points:

#	Name	Email	Major	IP Add.
14	asdf	[email protected]	Software	50.147.203.70
75	test	[email protected]	Software	1.22.88.169
76	test	[email protected]	Software	1.22.88.169
84	dfgdf	[email protected]	Software	24.159.127.238

Total of 4 students/rows.

Comb Through Duplicate IPs:

#	Name	Email	Major	Grade	IP Add.
1	afas	[email protected]	Digital Media	100	24.125.138.102
5	john	[email protected]	Software	50	168.28.22.146
8	asdf	[email protected]	Digital Media	0	50.147.203.70
30	Alvin	[email protected]	Digital Media	25	67.191.235.51
32	carlos	[email protected]	Digital Media	0	99.141.154.74
34	asdasda	[email protected]	Security	0	98.192.41.27
37	Cameron	[email protected]	Digital Media	100	24.98.54.89
45	Karl Kraus	[email protected]	Software	100	108.74.190.25
48	test	[email protected]	Digital Media	0	1.23.124.249
50	ertyui	[email protected]	Business	100	172.56.5.105
51	Fahd Quadri	[email protected]	Digital Media	100	172.56.4.213
52	Cameron	[email protected]	Digital Media	0	50.200.84.128
54	sam	[email protected]	Other	100	168.28.22.10
55	f	[email protected]	Digital Media	0	168.28.2.98
56	ertyui	[email protected]	Digital Media	0	172.56.5.190
57	ladjkadjlkadsjdlk	[email protected]	Digital Media	25	168.28.22.41
60	<span style="color:red">Someone</span>	[email protected]	Digital Media	0	168.28.22.59
61	asdfas	[email protected]	Digital Media	0	168.28.22.26
62	Samuel CHang	[email protected]	Digital Media	75	168.28.22.36
66	[email protected]	[email protected]	Software	50	1.22.194.167
67	sadf	[email protected]	Digital Media	25	50.167.67.245
69	Jacob	[email protected]	Software	100	168.28.22.40
70	Devora Lorenzo	[email protected]	Digital Media	25	168.28.22.44
71	potato	[email protected]	Digital Media	50	168.28.22.103
73	Dude	[email protected]	Digital Media	100	168.28.22.34
75	test	[email protected]	Software	0	1.22.88.169
77	asdfa	[email protected]	Digital Media	0	168.28.22.120
78	Rodny Joseph	[email protected]	Digital Media	25	24.99.50.110
84	dfgdf	[email protected]	Software	0	24.159.127.238
85	Travis Keating	[email protected]	Digital Media	25	96.32.85.89
86	sfdfd	[email protected]	Digital Media	0	24.99.247.234
88	sdf	[email protected]	Digital Media	100	4.15.179.163
89	goku	[email protected]	Digital Media	0	96.231.195.176
96	Bria Rivers	[email protected]	Digital Media	100	24.125.233.10
99	Jack Cantrell	[email protected]	Digital Media	100	50.160.207.11
104	Karl Kraus	[email protected]	Digital Media	0	168.28.22.86
107	dfg	[email protected]	Digital Media	100	168.28.16.100
113	Rebecca	[email protected]	Digital Media	25	71.204.64.171
125	john joe	[email protected]	Digital Media	75	168.28.22.88
126	Fake	[email protected]	Digital Media	50	168.28.22.58
127	Joe	[email protected]	Digital Media	0	168.28.22.93
128	Miguel	[email protected]	Digital Media	100	168.28.22.96
129	Mike	[email protected]	Software	100	168.28.22.50
134	jeff	[email protected]	Software	100	168.28.22.55
137	Gloria Alvarenga	[email protected]	Digital Media	100	168.28.22.49
139	Precious West	[email protected]	Digital Media	75	168.28.22.87
141	Arthur	[email protected]	Digital Media	0	173.15.220.177
142	Jeff G	[email protected]	Software	25	65.5.11.253
143	a	[email protected]	Business	25	69.15.227.126
147	a	[email protected]	Digital Media	0	107.167.116.228
150	er	[email protected]	Digital Media	25	96.32.85.3
151	adf	[email protected]	Digital Media	50	168.28.22.108
154	aef	[email protected]	Digital Media	0	73.207.104.73
155	a	[email protected]	Digital Media	0	24.125.222.199
156	dfg	[email protected]	Security	25	97.81.103.76
157	King Oruga	[email protected]	Software	100	50.167.235.114
162	Christan	[email protected]	Software	100	157.166.173.5
166	jay dizzle	[email protected]	Digital Media	25	168.28.22.95
168	jay win	[email protected]	Digital Media	25	71.90.222.117
170	Joe Cox	[email protected]	Digital Media	25	159.63.144.227
173	blake	[email protected]	Digital Media	75	97.67.171.34
175	mark	[email protected]	Digital Media	0	168.28.22.83
179	Adam Printz	[email protected]	Digital Media	0	168.28.22.104
183	Precious West	[email protected]	Digital Media	25	168.28.22.105
184	Jim Coburn	[email protected]	Digital Media	100	168.28.22.32
190	mik	[email protected]	Digital Media	50	168.28.22.100
191	222	[email protected]	Digital Media	50	75.131.196.162
192	Miguel	[email protected]	Digital Media	0	75.131.192.68
195	Dude	[email protected]	asdffffff	81	24.125.138.5

Total of 69 students/rows.

Major	# of students	Percentage
Digital Media	146	74.87%
Security	11	5.64%
Software	25	12.82%
Business	8	4.1%
Other	4	2.05%