Excel 2013 Assignment

profileehstudent
student_excel.zip
Home>Computer Science homework help>Excel 2013 Assignment

Student Instructions.JPG

Student.xlsx

Documentation

CBA
Author
Date
Purpose To track data on active students at CBA
Data Definition Table
Field Description Data Type Notes
SID Student ID Number
Last Name Student's last name Text
Gender Student's gender Text Male, Female
Major Student's major Text Accounting, Finance, Marketing, Management, Undecided
GPA Student's GPA Number Format to two decimal places
Scholarships Student's receiving scholarship Number Accounting format, no decimal places
Residence Student's residence Text In state, Out of state
Class Student's class Text Freshman, Sophomore, Junior, Senior

CBA Data

SID Last Name Gender Major GPA Scholarships Residence Class
101 Mccawley Male Marketing 2.69 Out of state Senior
102 Tatrai Female Accounting 2.99 In state Sophomore
103 Amukamara Male Undecided 2.95 In state Freshman
104 Simonsen Female Marketing 2.86 Out of state Senior
105 Larralde Male Undecided 2.01 Out of state Sophomore
106 Shearer Male Management 2.32 In state Junior
107 Otto Female Undecided 2.39 In state Freshman
108 Belloff Female Marketing 2.88 In state Senior
109 Brizendine Male Management 2.28 In state Junior
110 Breitenbach Female Finance 3.27 In state Sophomore
111 Fuller Female Undecided 2.98 In state Freshman
112 Pomerenke Male Management 2.88 In state Senior
113 Johnson Male Undecided 2.78 In state Freshman
147 Lopez Male Management 2.96 $ 2,000 In state Senior
118 Thomas Male Marketing 2.98 $ 2,000 Out of state Junior
137 Luna Female Accounting 3.23 $ 2,000 In state Junior
117 Hull Male Management 2.97 In state Sophomore
115 Loertscher Male Marketing 3.25 $ 2,000 In state Senior
119 Richardson Male Marketing 3.85 In state Senior
120 Romero Female Accounting 2.96 Out of state Sophomore
121 Agbebaku Male Undecided 2.99 Out of state Freshman
122 Bocskay Male Accounting 2.27 Out of state Senior
123 Connolly Female Undecided 3.18 Out of state Freshman
124 Cruz Female Undecided 2.07 In state Freshman
125 Jeffress Female Finance 2.29 In state Junior
126 Kang Female Marketing 2.65 Out of state Junior
127 Kreisher Female Marketing 3.27 In state Sophomore
128 Lesinski Female Management 2.85 Out of state Junior
129 Rich Male Marketing 2.92 In state Senior
130 Santillan Female Marketing 2.26 In state Junior
114 Nkol Male Management 3.59 $ 2,000 In state Senior
132 Llanes Female Undecided 2.07 Out of state Freshman
133 Brezina Male Undecided 3.26 Out of state Freshman
134 Thurow Female Accounting 2.30 In state Senior
135 Burns Female Management 2.66 Out of state Senior
136 Lucchesi Male Finance 2.32 In state Junior
175 Davey Female Management 3.81 $ 2,000 Out of state Senior
138 Schornack Male Management 2.61 Out of state Sophomore
139 Gomez Female Marketing 2.57 In state Junior
140 Skaar Male Marketing 2.86 In state Senior
141 Rubino Female Management 2.59 In state Sophomore
142 Decarlo Female Undecided 2.95 In state Freshman
143 Mcclelland Female Marketing 2.65 Out of state Senior
144 Supan Male Marketing 2.66 In state Junior
145 Winkler Female Management 2.96 In state Senior
146 Gallegos Male Undecided 2.96 Out of state Freshman
131 Sandoval Female Finance 3.82 $ 2,500 Out of state Junior
148 Waldron Male Undecided 2.93 In state Freshman
149 Perkins Female Marketing 2.57 In state Junior
150 Sapp Female Management 2.91 Out of state Junior
151 Licano Female Marketing 2.03 In state Sophomore
152 Gonzalez Female Marketing 2.97 In state Junior
153 Matozevich Male Marketing 2.95 Out of state Sophomore
154 Bowen Female Marketing 3.54 Out of state Junior
155 Staffler Female Accounting 2.07 Out of state Sophomore
156 Rawls Female Marketing 2.40 Out of state Sophomore
157 Porter Male Undecided 2.69 In state Freshman
158 Trevino Female Undecided 2.00 Out of state Freshman
159 Rivera Female Finance 2.67 In state Sophomore
160 Walker Male Management 2.85 In state Senior
161 Mcdaniel Male Management 2.99 Out of state Senior
162 Christ Male Undecided 3.58 In state Freshman
163 Danielson Female Management 2.98 In state Junior
164 Starkey Male Management 2.90 Out of state Junior
165 Sinclair Female Management 2.58 In state Senior
166 Strickman Female Undecided 2.89 Out of state Freshman
167 Holladay Female Undecided 3.48 Out of state Freshman
168 Bishop Female Undecided 3.50 In state Freshman
169 Strocks Male Management 2.99 Out of state Junior
170 Peoples Male Undecided 3.22 In state Freshman
171 Gadberry Male Finance 2.37 Out of state Sophomore
172 Auga Male Undecided 2.99 In state Freshman
173 Price Male Undecided 2.57 Out of state Freshman
174 Scroggins Female Undecided 2.04 Out of state Freshman
116 Stone Male Management 3.90 $ 2,500 Out of state Junior
176 Nguyen Male Accounting 2.60 In state Senior
177 Painter Female Undecided 2.32 Out of state Freshman
178 Roe Male Finance 2.68 Out of state Senior
179 Qi Female Finance 2.07 Out of state Junior
180 Carrillo Male Marketing 2.07 In state Sophomore

Sort by Major

SID Last Name Gender Major GPA Scholarships Residence Class
116 Stone Male Management 3.90 $ 2,500 Out of state Junior
119 Richardson Male Marketing 3.85 In state Senior
131 Sandoval Female Finance 3.82 $ 2,500 Out of state Junior
175 Davey Female Management 3.81 $ 2,000 Out of state Senior
114 Nkol Male Management 3.59 $ 2,000 In state Senior
162 Christ Male Undecided 3.58 In state Freshman
154 Bowen Female Marketing 3.54 Out of state Junior
168 Bishop Female Undecided 3.50 In state Freshman
167 Holladay Female Undecided 3.48 Out of state Freshman
110 Breitenbach Female Finance 3.27 In state Sophomore
127 Kreisher Female Marketing 3.27 In state Sophomore
133 Brezina Male Undecided 3.26 Out of state Freshman
115 Loertscher Male Marketing 3.25 $ 2,000 In state Senior
137 Luna Female Accounting 3.23 $ 2,000 In state Junior
170 Peoples Male Undecided 3.22 In state Freshman
123 Connolly Female Undecided 3.18 Out of state Freshman
102 Tatrai Female Accounting 2.99 In state Sophomore
161 Mcdaniel Male Management 2.99 Out of state Senior
169 Strocks Male Management 2.99 Out of state Junior
121 Agbebaku Male Undecided 2.99 Out of state Freshman
172 Auga Male Undecided 2.99 In state Freshman
163 Danielson Female Management 2.98 In state Junior
118 Thomas Male Marketing 2.98 $ 2,000 Out of state Junior
111 Fuller Female Undecided 2.98 In state Freshman
117 Hull Male Management 2.97 In state Sophomore
152 Gonzalez Female Marketing 2.97 In state Junior
120 Romero Female Accounting 2.96 Out of state Sophomore
147 Lopez Male Management 2.96 $ 2,000 In state Senior
145 Winkler Female Management 2.96 In state Senior
146 Gallegos Male Undecided 2.96 Out of state Freshman
153 Matozevich Male Marketing 2.95 Out of state Sophomore
103 Amukamara Male Undecided 2.95 In state Freshman
142 Decarlo Female Undecided 2.95 In state Freshman
148 Waldron Male Undecided 2.93 In state Freshman
129 Rich Male Marketing 2.92 In state Senior
150 Sapp Female Management 2.91 Out of state Junior
164 Starkey Male Management 2.90 Out of state Junior
166 Strickman Female Undecided 2.89 Out of state Freshman
112 Pomerenke Male Management 2.88 In state Senior
108 Belloff Female Marketing 2.88 In state Senior
104 Simonsen Female Marketing 2.86 Out of state Senior
140 Skaar Male Marketing 2.86 In state Senior
128 Lesinski Female Management 2.85 Out of state Junior
160 Walker Male Management 2.85 In state Senior
113 Johnson Male Undecided 2.78 In state Freshman
101 Mccawley Male Marketing 2.69 Out of state Senior
157 Porter Male Undecided 2.69 In state Freshman
178 Roe Male Finance 2.68 Out of state Senior
159 Rivera Female Finance 2.67 In state Sophomore
135 Burns Female Management 2.66 Out of state Senior
144 Supan Male Marketing 2.66 In state Junior
126 Kang Female Marketing 2.65 Out of state Junior
143 Mcclelland Female Marketing 2.65 Out of state Senior
138 Schornack Male Management 2.61 Out of state Sophomore
176 Nguyen Male Accounting 2.60 In state Senior
141 Rubino Female Management 2.59 In state Sophomore
165 Sinclair Female Management 2.58 In state Senior
139 Gomez Female Marketing 2.57 In state Junior
149 Perkins Female Marketing 2.57 In state Junior
173 Price Male Undecided 2.57 Out of state Freshman
156 Rawls Female Marketing 2.40 Out of state Sophomore
107 Otto Female Undecided 2.39 In state Freshman
171 Gadberry Male Finance 2.37 Out of state Sophomore
136 Lucchesi Male Finance 2.32 In state Junior
106 Shearer Male Management 2.32 In state Junior
177 Painter Female Undecided 2.32 Out of state Freshman
134 Thurow Female Accounting 2.30 In state Senior
125 Jeffress Female Finance 2.29 In state Junior
109 Brizendine Male Management 2.28 In state Junior
122 Bocskay Male Accounting 2.27 Out of state Senior
130 Santillan Female Marketing 2.26 In state Junior
155 Staffler Female Accounting 2.07 Out of state Sophomore
179 Qi Female Finance 2.07 Out of state Junior
180 Carrillo Male Marketing 2.07 In state Sophomore
124 Cruz Female Undecided 2.07 In state Freshman
132 Llanes Female Undecided 2.07 Out of state Freshman
174 Scroggins Female Undecided 2.04 Out of state Freshman
151 Licano Female Marketing 2.03 In state Sophomore
105 Larralde Male Undecided 2.01 Out of state Sophomore
158 Trevino Female Undecided 2.00 Out of state Freshman
Average 78 2.80

Filter by class

SID Last Name Gender Major GPA Scholarships Residence Class
101 Mccawley Male Marketing 2.69 Out of state Senior
102 Tatrai Female Accounting 2.99 In state Sophomore
103 Amukamara Male Undecided 2.95 In state Freshman
104 Simonsen Female Marketing 2.86 Out of state Senior
105 Larralde Male Undecided 2.01 Out of state Sophomore
106 Shearer Male Management 2.32 In state Junior
107 Otto Female Undecided 2.39 In state Freshman
108 Belloff Female Marketing 2.88 In state Senior
109 Brizendine Male Management 2.28 In state Junior
110 Breitenbach Female Finance 3.27 In state Sophomore
111 Fuller Female Undecided 2.98 In state Freshman
112 Pomerenke Male Management 2.88 In state Senior
113 Johnson Male Undecided 2.78 In state Freshman
147 Lopez Male Management 2.96 $ 2,000 In state Senior
118 Thomas Male Marketing 2.98 $ 2,000 Out of state Junior
137 Luna Female Accounting 3.23 $ 2,000 In state Junior
117 Hull Male Management 2.97 In state Sophomore
115 Loertscher Male Marketing 3.25 $ 2,000 In state Senior
119 Richardson Male Marketing 3.85 In state Senior
120 Romero Female Accounting 2.96 Out of state Sophomore
121 Agbebaku Male Undecided 2.99 Out of state Freshman
122 Bocskay Male Accounting 2.27 Out of state Senior
123 Connolly Female Undecided 3.18 Out of state Freshman
124 Cruz Female Undecided 2.07 In state Freshman
125 Jeffress Female Finance 2.29 In state Junior
126 Kang Female Marketing 2.65 Out of state Junior
127 Kreisher Female Marketing 3.27 In state Sophomore
128 Lesinski Female Management 2.85 Out of state Junior
129 Rich Male Marketing 2.92 In state Senior
130 Santillan Female Marketing 2.26 In state Junior
114 Nkol Male Management 3.59 $ 2,000 In state Senior
132 Llanes Female Undecided 2.07 Out of state Freshman
133 Brezina Male Undecided 3.26 Out of state Freshman
134 Thurow Female Accounting 2.30 In state Senior
135 Burns Female Management 2.66 Out of state Senior
136 Lucchesi Male Finance 2.32 In state Junior
175 Davey Female Management 3.81 $ 2,000 Out of state Senior
138 Schornack Male Management 2.61 Out of state Sophomore
139 Gomez Female Marketing 2.57 In state Junior
140 Skaar Male Marketing 2.86 In state Senior
141 Rubino Female Management 2.59 In state Sophomore
142 Decarlo Female Undecided 2.95 In state Freshman
143 Mcclelland Female Marketing 2.65 Out of state Senior
144 Supan Male Marketing 2.66 In state Junior
145 Winkler Female Management 2.96 In state Senior
146 Gallegos Male Undecided 2.96 Out of state Freshman
131 Sandoval Female Finance 3.82 $ 2,500 Out of state Junior
148 Waldron Male Undecided 2.93 In state Freshman
149 Perkins Female Marketing 2.57 In state Junior
150 Sapp Female Management 2.91 Out of state Junior
151 Licano Female Marketing 2.03 In state Sophomore
152 Gonzalez Female Marketing 2.97 In state Junior
153 Matozevich Male Marketing 2.95 Out of state Sophomore
154 Bowen Female Marketing 3.54 Out of state Junior
155 Staffler Female Accounting 2.07 Out of state Sophomore
156 Rawls Female Marketing 2.40 Out of state Sophomore
157 Porter Male Undecided 2.69 In state Freshman
158 Trevino Female Undecided 2.00 Out of state Freshman
159 Rivera Female Finance 2.67 In state Sophomore
160 Walker Male Management 2.85 In state Senior
161 Mcdaniel Male Management 2.99 Out of state Senior
162 Christ Male Undecided 3.58 In state Freshman
163 Danielson Female Management 2.98 In state Junior
164 Starkey Male Management 2.90 Out of state Junior
165 Sinclair Female Management 2.58 In state Senior
166 Strickman Female Undecided 2.89 Out of state Freshman
167 Holladay Female Undecided 3.48 Out of state Freshman
168 Bishop Female Undecided 3.50 In state Freshman
169 Strocks Male Management 2.99 Out of state Junior
170 Peoples Male Undecided 3.22 In state Freshman
171 Gadberry Male Finance 2.37 Out of state Sophomore
172 Auga Male Undecided 2.99 In state Freshman
173 Price Male Undecided 2.57 Out of state Freshman
174 Scroggins Female Undecided 2.04 Out of state Freshman
116 Stone Male Management 3.90 $ 2,500 Out of state Junior
176 Nguyen Male Accounting 2.60 In state Senior
177 Painter Female Undecided 2.32 Out of state Freshman
178 Roe Male Finance 2.68 Out of state Senior
179 Qi Female Finance 2.07 Out of state Junior
180 Carrillo Male Marketing 2.07 In state Sophomore