Collegiate Seminars
Author
Phillip Cunningham
Date
11/16/2017
Purpose
To track seminar bookings
Field Description Data Type Notes
Seminar ID Seminar ID Number
Topic Seminar Topic Text Accounting, Finance, Marketing, Management, Undecided
Type Type of Seminar Text General Interest, Graduate, Post Grad, and Undergrad
Instructor Instructor Name Text
Data Definition Table
Length Length of seminar (days) Number Use Number format with one decimal place
Location Location of Seminar Text Main, Downtown, Beltway (all buildings of Collegiate Seminars)
Cost Cost of Seminar Number Use Accounting format with two decimal places
Max Maximum Enrollment Number Use Number format with no decimal places
Sum of Cost Column Labels
Row Labels General Interest Graduate Post Grad Undergrad Grand Total
Accounting 1,050$ 3,000$ 1,500$ 300$ 5,850$
Finance 525$ 3,000$ 4,500$ 300$ 8,325$
Type
General Interest
Information Systems 700$ 2,100$ 1,800$ 750$ 5,350$
Management 3,150$ 2,400$ 9,600$ 900$ 16,050$
Marketing 2,625$ 4,000$ 9,600$ 900$ 17,125$
Grand Total 8,050$ 14,500$ 27,000$ 3,150$ 52,700$
Row Labels Average of Cost Count of Seminar ID
Beltway 865$ 23
Downtown 900$ 17
Grand Total 798$ 66
Seminar ID Topic Type Instructor Length Location Cost Max
101 Marketing Undergrad Wheeler 3 Beltway 300$ 30
102 Accounting Graduate Connor 5 Beltway 1,000$ 30
115 Marketing Undergrad Vinson 3 Main 300$ 25
116 Management Post Grad Teague 4 Downtown 1,200$ 20
117 Management Graduate Moir 4 Beltway 800$ 30
118 Marketing Post Grad Vinson 4 Main 1,200$ 25
119 Marketing General Interest Wheeler 3 Beltway 525$ 30
120 Accounting Graduate Hamilton 5 Main 1,000$ 25
121 Information Systems Graduate Conn 3.5 Main 700$ 25
122 Accounting Undergrad Connor 3 Beltway 300$ 30
123 Information Systems Undergrad Flores 2.5 Main 250$ 25
124 Information Systems Graduate Flores 3.5 Main 700$ 25
126 Marketing Post Grad Parker 4 Downtown 1,200$ 20
127 Marketing Graduate Parker 4 Downtown 800$ 20
128 Management Post Grad Teague 4 Downtown 1,200$ 20
129 Marketing General Interest Vinson 3 Main 525$ 25
130 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
131 Finance Post Grad Suiter 5 Beltway 1,500$ 30
133 Information Systems Post Grad Ginder 3 Main 900$ 25
134 Accounting General Interest Hamilton 3 Main 525$ 25
135 Management Undergrad Nguyen 3 Main 300$ 25
136 Finance Undergrad Welker 3 Downtown 300$ 20
137 Accounting Post Grad Connor 5 Beltway 1,500$ 30
138 Management Graduate Nguyen 4 Main 800$ 25
139 Marketing Post Grad Vinson 4 Main 1,200$ 25
140 Marketing Undergrad Wheeler 3 Beltway 300$ 30
141 Management Graduate Teague 4 Downtown 800$ 20
143 Marketing General Interest Vinson 3 Main 525$ 25
144 Marketing Post Grad Parker 4 Downtown 1,200$ 20
145 Management Undergrad Moir 3 Beltway 300$ 30
147 Management General Interest Nguyen 3 Main 525$ 25
149 Marketing Post Grad Parker 4 Downtown 1,200$ 20
103 Information Systems Undergrad Ginder 2.5 Main 250$ 25
104 Marketing General Interest Wheeler 3 Beltway 525$ 30
105 Information Systems Graduate Ginder 3.5 Main 700$ 25
106 Management Post Grad Moir 4 Beltway 1,200$ 30
108 Marketing General Interest Vinson 3 Main 525$ 25
109 Management Post Grad Nguyen 4 Main 1,200$ 25
110 Finance Graduate Welker 5 Downtown 1,000$ 20
112 Management General Interest Moir 3 Beltway 525$ 30
113 Information Systems Undergrad Conn 2.5 Main 250$ 25
114 Management Undergrad Moir 3 Beltway 300$ 30
150 Management Post Grad Moir 4 Beltway 1,200$ 30
151 Marketing Graduate Vinson 4 Main 800$ 25
152 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
164 Management Post Grad Moir 4 Beltway 1,200$ 30
165 Management General Interest Teague 3 Downtown 525$ 20
169 Management Post Grad Moir 4 Beltway 1,200$ 30
171 Finance Graduate Suiter 5 Beltway 1,000$ 30
175 Management General Interest Teague 3 Downtown 525$ 20
176 Accounting General Interest Connor 3 Beltway 525$ 30
178 Finance General Interest Welker 3 Downtown 525$ 20
179 Finance Post Grad Suiter 5 Beltway 1,500$ 30
180 Marketing Graduate Parker 4 Downtown 800$ 20
153 Marketing Graduate Parker 4 Downtown 800$ 20
154 Marketing Post Grad Vinson 4 Main 1,200$ 25
155 Accounting Graduate Hamilton 5 Main 1,000$ 25
156 Marketing Graduate Wheeler 4 Beltway 800$ 30
157 Information Systems General Interest Flores 2 Main 350$ 25
158 Information Systems General Interest Ginder 2 Main 350$ 25
159 Finance Graduate Suiter 5 Beltway 1,000$ 30
160 Management General Interest Nguyen 3 Main 525$ 25
161 Management General Interest Teague 3 Downtown 525$ 20
163 Management Post Grad Teague 4 Downtown 1,200$ 20
Seminar ID Topic Type Instructor Length Location Cost Max
102 Accounting Graduate Connor 5 Beltway 1,000$ 30
120 Accounting Graduate Hamilton 5 Main 1,000$ 25
122 Accounting Undergrad Connor 3 Beltway 300$ 30
134 Accounting General Interest Hamilton 3 Main 525$ 25
137 Accounting Post Grad Connor 5 Beltway 1,500$ 30
155 Accounting Graduate Hamilton 5 Main 1,000$ 25
176 Accounting General Interest Connor 3 Beltway 525$ 30
Accounting Total 5,850$
110 Finance Graduate Welker 5 Downtown 1,000$ 20
Finance Total 8,325$
103 Information Systems Undergrad Ginder 2.5 Main 250$ 25
105 Information Systems Graduate Ginder 3.5 Main 700$ 25
113 Information Systems Undergrad Conn 2.5 Main 250$ 25
121 Information Systems Graduate Conn 3.5 Main 700$ 25
123 Information Systems Undergrad Flores 2.5 Main 250$ 25
133 Information Systems Post Grad Ginder 3 Main 900$ 25
146 Information Systems Post Grad Conn 3 Main 900$ 25
157 Information Systems General Interest Flores 2 Main 350$ 25
158 Information Systems General Interest Ginder 2 Main 350$ 25
Information Systems Total 5,350$
106 Management Post Grad Moir 4 Beltway 1,200$ 30
109 Management Post Grad Nguyen 4 Main 1,200$ 25
112 Management General Interest Moir 3 Beltway 525$ 30
114 Management Undergrad Moir 3 Beltway 300$ 30
116 Management Post Grad Teague 4 Downtown 1,200$ 20
117 Management Graduate Moir 4 Beltway 800$ 30
128 Management Post Grad Teague 4 Downtown 1,200$ 20
135 Management Undergrad Nguyen 3 Main 300$ 25
138 Management Graduate Nguyen 4 Main 800$ 25
141 Management Graduate Teague 4 Downtown 800$ 20
145 Management Undergrad Moir 3 Beltway 300$ 30
147 Management General Interest Nguyen 3 Main 525$ 25
150 Management Post Grad Moir 4 Beltway 1,200$ 30
161 Management General Interest Teague 3 Downtown 525$ 20
163 Management Post Grad Teague 4 Downtown 1,200$ 20
125 Finance Post Grad Welker 5 Downtown 1,500$ 20
131 Finance Post Grad Suiter 5 Beltway 1,500$ 30
136 Finance Undergrad Welker 3 Downtown 300$ 20
159 Finance Graduate Suiter 5 Beltway 1,000$ 30
171 Finance Graduate Suiter 5 Beltway 1,000$ 30
178 Finance General Interest Welker 3 Downtown 525$ 20
179 Finance Post Grad Suiter 5 Beltway 1,500$ 30
Management Total 16,050$
101 Marketing Undergrad Wheeler 3 Beltway 300$ 30
104 Marketing General Interest Wheeler 3 Beltway 525$ 30
108 Marketing General Interest Vinson 3 Main 525$ 25
115 Marketing Undergrad Vinson 3 Main 300$ 25
118 Marketing Post Grad Vinson 4 Main 1,200$ 25
119 Marketing General Interest Wheeler 3 Beltway 525$ 30
126 Marketing Post Grad Parker 4 Downtown 1,200$ 20
127 Marketing Graduate Parker 4 Downtown 800$ 20
129 Marketing General Interest Vinson 3 Main 525$ 25
130 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
139 Marketing Post Grad Vinson 4 Main 1,200$ 25
140 Marketing Undergrad Wheeler 3 Beltway 300$ 30
143 Marketing General Interest Vinson 3 Main 525$ 25
144 Marketing Post Grad Parker 4 Downtown 1,200$ 20
149 Marketing Post Grad Parker 4 Downtown 1,200$ 20
151 Marketing Graduate Vinson 4 Main 800$ 25
152 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
153 Marketing Graduate Parker 4 Downtown 800$ 20
154 Marketing Post Grad Vinson 4 Main 1,200$ 25
156 Marketing Graduate Wheeler 4 Beltway 800$ 30
180 Marketing Graduate Parker 4 Downtown 800$ 20
Marketing Total 17,125$
Grand Total 52,700$
164 Management Post Grad Moir 4 Beltway 1,200$ 30
165 Management General Interest Teague 3 Downtown 525$ 20
169 Management Post Grad Moir 4 Beltway 1,200$ 30
175 Management General Interest Teague 3 Downtown 525$ 20
Seminar ID Topic Type Instructor Length Location Cost Max
101 Marketing Undergrad Wheeler 3 Beltway 300$ 30
102 Accounting Graduate Connor 5 Beltway 1,000$ 30
103 Information Systems Undergrad Ginder 2.5 Main 250$ 25
104 Marketing General Interest Wheeler 3 Beltway 525$ 30
105 Information Systems Graduate Ginder 3.5 Main 700$ 25
125 Finance Post Grad Welker 5 Downtown 1,500$ 20
108 Marketing General Interest Vinson 3 Main 525$ 25
131 Finance Post Grad Suiter 5 Beltway 1,500$ 30
110 Finance Graduate Welker 5 Downtown 1,000$ 20
112 Management General Interest Moir 3 Beltway 525$ 30
113 Information Systems Undergrad Conn 2.5 Main 250$ 25
114 Management Undergrad Moir 3 Beltway 300$ 30
106 Management Post Grad Moir 4 Beltway 1,200$ 30
109 Management Post Grad Nguyen 4 Main 1,200$ 25
127 Marketing Graduate Parker 4 Downtown 800$ 20
116 Management Post Grad Teague 4 Downtown 1,200$ 20
129 Marketing General Interest Vinson 3 Main 525$ 25
118 Marketing Post Grad Vinson 4 Main 1,200$ 25
126 Marketing Post Grad Parker 4 Downtown 1,200$ 20
133 Information Systems Post Grad Ginder 3 Main 900$ 25
134 Accounting General Interest Hamilton 3 Main 525$ 25
135 Management Undergrad Nguyen 3 Main 300$ 25
136 Finance Undergrad Welker 3 Downtown 300$ 20
128 Management Post Grad Teague 4 Downtown 1,200$ 20
138 Management Graduate Nguyen 4 Main 800$ 25
130 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
140 Marketing Undergrad Wheeler 3 Beltway 300$ 30
141 Management Graduate Teague 4 Downtown 800$ 20
143 Marketing General Interest Vinson 3 Main 525$ 25
139 Marketing Post Grad Vinson 4 Main 1,200$ 25
145 Management Undergrad Moir 3 Beltway 300$ 30
146 Information Systems Post Grad Conn 3 Main 900$ 25
147 Management General Interest Nguyen 3 Main 525$ 25
144 Marketing Post Grad Parker 4 Downtown 1,200$ 20
115 Marketing Undergrad Vinson 3 Main 300$ 25
137 Accounting Post Grad Connor 5 Beltway 1,500$ 30
117 Management Graduate Moir 4 Beltway 800$ 30
179 Finance Post Grad Suiter 5 Beltway 1,500$ 30
119 Marketing General Interest Wheeler 3 Beltway 525$ 30
120 Accounting Graduate Hamilton 5 Main 1,000$ 25
121 Information Systems Graduate Conn 3.5 Main 700$ 25
122 Accounting Undergrad Connor 3 Beltway 300$ 30
123 Information Systems Undergrad Flores 2.5 Main 250$ 25
124 Information Systems Graduate Flores 3.5 Main 700$ 25
158 Information Systems General Interest Ginder 2 Main 350$ 25
159 Finance Graduate Suiter 5 Beltway 1,000$ 30
160 Management General Interest Nguyen 3 Main 525$ 25
161 Management General Interest Teague 3 Downtown 525$ 20
154 Marketing Post Grad Vinson 4 Main 1,200$ 25
163 Management Post Grad Teague 4 Downtown 1,200$ 20
165 Management General Interest Teague 3 Downtown 525$ 20
164 Management Post Grad Moir 4 Beltway 1,200$ 30
171 Finance Graduate Suiter 5 Beltway 1,000$ 30
175 Management General Interest Teague 3 Downtown 525$ 20
176 Accounting General Interest Connor 3 Beltway 525$ 30
178 Finance General Interest Welker 3 Downtown 525$ 20
169 Management Post Grad Moir 4 Beltway 1,200$ 30
180 Marketing Graduate Parker 4 Downtown 800$ 20
149 Marketing Post Grad Parker 4 Downtown 1,200$ 20
151 Marketing Graduate Vinson 4 Main 800$ 25
150 Management Post Grad Moir 4 Beltway 1,200$ 30
153 Marketing Graduate Parker 4 Downtown 800$ 20
152 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
155 Accounting Graduate Hamilton 5 Main 1,000$ 25
156 Marketing Graduate Wheeler 4 Beltway 800$ 30
157 Information Systems General Interest Flores 2 Main 350$ 25
Seminar ID Topic Type Instructor Length Location Cost Max
101 Marketing Undergrad Wheeler 3 Beltway 300$ 30
113 Information Systems Undergrad Conn 2.5 Main 250$ 25
104 Marketing General Interest Wheeler 3 Beltway 525$ 30
115 Marketing Undergrad Vinson 3 Main 300$ 25
112 Management General Interest Moir 3 Beltway 525$ 30
119 Marketing General Interest Wheeler 3 Beltway 525$ 30
118 Marketing Post Grad Vinson 4 Main 1,200$ 25
161 Management General Interest Teague 3 Downtown 525$ 20
120 Accounting Graduate Hamilton 5 Main 1,000$ 25
121 Information Systems Graduate Conn 3.5 Main 700$ 25
165 Management General Interest Teague 3 Downtown 525$ 20
123 Information Systems Undergrad Flores 2.5 Main 250$ 25
124 Information Systems Graduate Flores 3.5 Main 700$ 25
175 Management General Interest Teague 3 Downtown 525$ 20
176 Accounting General Interest Connor 3 Beltway 525$ 30
178 Finance General Interest Welker 3 Downtown 525$ 20
117 Management Graduate Moir 4 Beltway 800$ 30
129 Marketing General Interest Vinson 3 Main 525$ 25
127 Marketing Graduate Parker 4 Downtown 800$ 20
141 Management Graduate Teague 4 Downtown 800$ 20
133 Information Systems Post Grad Ginder 3 Main 900$ 25
134 Accounting General Interest Hamilton 3 Main 525$ 25
135 Management Undergrad Nguyen 3 Main 300$ 25
Location
Beltway
114 Management Undergrad Moir 3 Beltway 300$ 30
103 Information Systems Undergrad Ginder 2.5 Main 250$ 25
122 Accounting Undergrad Connor 3 Beltway 300$ 30
105 Information Systems Graduate Ginder 3.5 Main 700$ 25
136 Finance Undergrad Welker 3 Downtown 300$ 20
108 Marketing General Interest Vinson 3 Main 525$ 25
109 Management Post Grad Nguyen 4 Main 1,200$ 25
140 Marketing Undergrad Wheeler 3 Beltway 300$ 30
145 Management Undergrad Moir 3 Beltway 300$ 30
Downtown
159 Finance Graduate Suiter 5 Beltway 1,000$ 30
146 Information Systems Post Grad Conn 3 Main 900$ 25
147 Management General Interest Nguyen 3 Main 525$ 25
171 Finance Graduate Suiter 5 Beltway 1,000$ 30
106 Management Post Grad Moir 4 Beltway 1,200$ 30
151 Marketing Graduate Vinson 4 Main 800$ 25
116 Management Post Grad Teague 4 Downtown 1,200$ 20
126 Marketing Post Grad Parker 4 Downtown 1,200$ 20
154 Marketing Post Grad Vinson 4 Main 1,200$ 25
155 Accounting Graduate Hamilton 5 Main 1,000$ 25
128 Management Post Grad Teague 4 Downtown 1,200$ 20
157 Information Systems General Interest Flores 2 Main 350$ 25
158 Information Systems General Interest Ginder 2 Main 350$ 25
130 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
160 Management General Interest Nguyen 3 Main 525$ 25
144 Marketing Post Grad Parker 4 Downtown 1,200$ 20
149 Marketing Post Grad Parker 4 Downtown 1,200$ 20
150 Management Post Grad Moir 4 Beltway 1,200$ 30
152 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
163 Management Post Grad Teague 4 Downtown 1,200$ 20
164 Management Post Grad Moir 4 Beltway 1,200$ 30
169 Management Post Grad Moir 4 Beltway 1,200$ 30
125 Finance Post Grad Welker 5 Downtown 1,500$ 20
131 Finance Post Grad Suiter 5 Beltway 1,500$ 30
137 Accounting Post Grad Connor 5 Beltway 1,500$ 30
179 Finance Post Grad Suiter 5 Beltway 1,500$ 30
153 Marketing Graduate Parker 4 Downtown 800$ 20
156 Marketing Graduate Wheeler 4 Beltway 800$ 30
138 Management Graduate Nguyen 4 Main 800$ 25
139 Marketing Post Grad Vinson 4 Main 1,200$ 25
180 Marketing Graduate Parker 4 Downtown 800$ 20
102 Accounting Graduate Connor 5 Beltway 1,000$ 30
143 Marketing General Interest Vinson 3 Main 525$ 25
110 Finance Graduate Welker 5 Downtown 1,000$ 20
104 Marketing General Interest Wheeler 3 Beltway 525$ 30
108 Marketing General Interest Vinson 3 Main 525$ 25
112 Management General Interest Moir 3 Beltway 525$ 30
119 Marketing General Interest Wheeler 3 Beltway 525$ 30
129 Marketing General Interest Vinson 3 Main 525$ 25
134 Accounting General Interest Hamilton 3 Main 525$ 25
143 Marketing General Interest Vinson 3 Main 525$ 25
147 Management General Interest Nguyen 3 Main 525$ 25
160 Management General Interest Nguyen 3 Main 525$ 25
155 Accounting Graduate Hamilton 5 Main 1,000$ 25
159 Finance Graduate Suiter 5 Beltway 1,000$ 30
171 Finance Graduate Suiter 5 Beltway 1,000$ 30
117 Management Graduate Moir 4 Beltway 800$ 30
127 Marketing Graduate Parker 4 Downtown 800$ 20
138 Management Graduate Nguyen 4 Main 800$ 25
141 Management Graduate Teague 4 Downtown 800$ 20
151 Marketing Graduate Vinson 4 Main 800$ 25
153 Marketing Graduate Parker 4 Downtown 800$ 20
156 Marketing Graduate Wheeler 4 Beltway 800$ 30
180 Marketing Graduate Parker 4 Downtown 800$ 20
105 Information Systems Graduate Ginder 3.5 Main 700$ 25
121 Information Systems Graduate Conn 3.5 Main 700$ 25
124 Information Systems Graduate Flores 3.5 Main 700$ 25
125 Finance Post Grad Welker 5 Downtown 1,500$ 20
161 Management General Interest Teague 3 Downtown 525$ 20
165 Management General Interest Teague 3 Downtown 525$ 20
175 Management General Interest Teague 3 Downtown 525$ 20
176 Accounting General Interest Connor 3 Beltway 525$ 30
178 Finance General Interest Welker 3 Downtown 525$ 20
157 Information Systems General Interest Flores 2 Main 350$ 25
158 Information Systems General Interest Ginder 2 Main 350$ 25
102 Accounting Graduate Connor 5 Beltway 1,000$ 30
110 Finance Graduate Welker 5 Downtown 1,000$ 20
120 Accounting Graduate Hamilton 5 Main 1,000$ 25
131 Finance Post Grad Suiter 5 Beltway 1,500$ 30
137 Accounting Post Grad Connor 5 Beltway 1,500$ 30
179 Finance Post Grad Suiter 5 Beltway 1,500$ 30
106 Management Post Grad Moir 4 Beltway 1,200$ 30
109 Management Post Grad Nguyen 4 Main 1,200$ 25
154 Marketing Post Grad Vinson 4 Main 1,200$ 25
163 Management Post Grad Teague 4 Downtown 1,200$ 20
164 Management Post Grad Moir 4 Beltway 1,200$ 30
169 Management Post Grad Moir 4 Beltway 1,200$ 30
133 Information Systems Post Grad Ginder 3 Main 900$ 25
146 Information Systems Post Grad Conn 3 Main 900$ 25
101 Marketing Undergrad Wheeler 3 Beltway 300$ 30
114 Management Undergrad Moir 3 Beltway 300$ 30
115 Marketing Undergrad Vinson 3 Main 300$ 25
122 Accounting Undergrad Connor 3 Beltway 300$ 30
135 Management Undergrad Nguyen 3 Main 300$ 25
136 Finance Undergrad Welker 3 Downtown 300$ 20
140 Marketing Undergrad Wheeler 3 Beltway 300$ 30
145 Management Undergrad Moir 3 Beltway 300$ 30
103 Information Systems Undergrad Ginder 2.5 Main 250$ 25
113 Information Systems Undergrad Conn 2.5 Main 250$ 25
123 Information Systems Undergrad Flores 2.5 Main 250$ 25
116 Management Post Grad Teague 4 Downtown 1,200$ 20
118 Marketing Post Grad Vinson 4 Main 1,200$ 25
126 Marketing Post Grad Parker 4 Downtown 1,200$ 20
128 Management Post Grad Teague 4 Downtown 1,200$ 20
130 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30
139 Marketing Post Grad Vinson 4 Main 1,200$ 25
144 Marketing Post Grad Parker 4 Downtown 1,200$ 20
149 Marketing Post Grad Parker 4 Downtown 1,200$ 20
150 Management Post Grad Moir 4 Beltway 1,200$ 30
152 Marketing Post Grad Wheeler 4 Beltway 1,200$ 30