microsoft exam
| Faculty ID | Postal Code | Home Phone | Cell Phone | Salary | Last Name | First Name | Address | City | Rank | State | Campus | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FAC-0393 | 78621 | (512) 555-5123 | (512) 555-6214 | [email protected] | ¤ 43,000.00 | Betancourt | Charles | 156 Zarogoza St | Elgin | Professor | TX | Northeast |
| FAC-0767 | 78602 | (512) 555-5143 | (512) 555-6240 | [email protected] | ¤ 56,899.59 | Soja | Binit | 660 Cypress St | Bastrop | Professor | TX | Southeast |
| FAC-1133 | 78732 | (512) 555-5207 | (512) 555-6304 | [email protected] | ¤ 54,000.00 | Bell | Dora | 1450 Horseback Hollow | Austin | Professor | TX | Northwest |
| FAC-1283 | 78641 | (512) 555-5140 | (512) 555-6237 | [email protected] | ¤ 56,000.00 | Hart-Rodriguez | Melanie | 623 Camino Alto | Leander | Professor | TX | Northwest |
| FAC-1772 | 78616 | (512) 555-5159 | (512) 555-6256 | [email protected] | ¤ 54,789.87 | Haq | Mark | 1234 Tumbleweed Trl | Dale | Professor | TX | Southeast |
| FAC-2234 | 78620 | (512) 555-4545 | (512) 555-2323 | [email protected] | ¤ 33,800.00 | Sweeney | Megan | 910 Oak Meadow Dr | Dripping Springs | Associate Professor | TX | Southwest |
| FAC-2245 | 78669 | (512) 555-5213 | (512) 555-6310 | [email protected] | ¤ 45,900.22 | Szulkin | Martin | 3730 Deer Trl | Spicewood | Professor | TX | Northwest |
| FAC-2289 | 78644 | (512) 555-5142 | (512) 555-6239 | [email protected] | ¤ 38,900.00 | Sideris | Dana | 550 Hondo St | Lockhart | Assistant Professor | TX | Southeast |
| FAC-2322 | 78610 | (512) 555-5124 | (512) 555-6215 | [email protected] | ¤ 59,500.00 | Briggs | Luis | 105 Bayou Bend Dr | Buda | Professor | TX | Southwest |
| FAC-2375 | 78626 | (512) 555-5141 | (512) 555-6238 | [email protected] | ¤ 32,000.00 | Torres | Robert | 190 Estancia Way | Georgetown | Associate Professor | TX | Northeast |
| FAC-2377 | 78653 | (512) 555-5148 | (512) 555-6245 | [email protected] | ¤ 37,900.00 | Kubzansky | Amy | 11640 Sunny Creek Ln | Manor | Associate Professor | TX | Northeast |
| FAC-2877 | 78640 | (512) 555-5132 | (512) 555-6227 | rtreiman@capcc c.edu | ¤ 41,000.00 | Treiman | Roger | 123 Moonlight Pl | Kyle | Professor | TX | Southwest |
| FAC-2998 | 78662 | (512) 555-5210 | (512) 555-6307 | [email protected] | ¤ 39,000.00 | Holland | Timothy-John | 156 Keirsey Ln | Red Rock | Professor | TX | Northwest |
| FAC-3433 | 78741 | (512) 555-5175 | (512) 555-6272 | [email protected] | ¤ 39,800.11 | Hackett | Jessica | 1265 Summit St | Austin | Professor | TX | Southeast |
| FAC-3567 | 78666 | (512) 555-5203 | (512) 555-6300 | [email protected] | ¤ 27,000.00 | Michaels | Payne | 333Encino Way | San Marcos | Associate Professor | TX | Southwest |
| FAC-3991 | 78657 | (512) 555-5165 | (512) 555-6262 | [email protected] | ¤ 54,890.22 | Capelle | Arturo | 476 Rivers St | Smithville | Professor | TX | Southeast |
| FAC-4901 | 78665 | (512) 555-5131 | (512) 555-6224 | [email protected] | ¤ 65,800.99 | Saguy | Vilma | 600 Lonesome Lilly Way | Pflugerville | Professor | TX | Northeast |
| FAC-6534 | 78602 | (512) 555-5168 | (512) 555-6265 | [email protected] | ¤ 32,111.00 | Lang | Phillippe | 125 Peach St | Bastrop | Assistant Professor | TX | Southeast |
| FAC-6543 | 78674 | (512) 555-5132 | (512) 555-6229 | [email protected] | ¤ 42,896.55 | Goldani | ZsuZsa | 256 Mill Race Ln | Wimberley | Professor | TX | Southwest |
| FAC-6678 | 78721 | (512) 555-5144 | (512) 555-6241 | [email protected] | ¤ 31,000.00 | Hasenfeld | Larthia | 6240 Stiles Cv | Austin | Assistant Professor | TX | Southeast |
| FAC-7223 | 78641 | (512) 555-5196 | (512) 555-6293 | [email protected] | ¤ 29,500.00 | Ong | Joel | 745 Northcreek Blvd | Leander | Assistant Professor | TX | Northwest |
| FAC-7342 | 78642 | (512) 555-5150 | (512) 555-6247 | [email protected] | ¤ 45,000.00 | Villareal | Jose Luis | 120 Blue Bonnet Ln | Liberty Hill | Instructor | TX | Northwest |
| FAC-8223 | 78616 | (512) 555-5163 | (512) 555-6260 | [email protected] | ¤ 39,500.00 | Kilbride | Thea | 188 Dale Ln | Dale | Assistant Professor | TX | Southeast |
| FAC-8375 | 78705 | (512) 555-5155 | (512) 555-6252 | [email protected] | ¤ 43,000.00 | Friend | Gyula | 2193 Rio Grande St | Austin | Instructor | TX | Southwest |
| FAC-8523 | 78669 | (512) 555-5191 | (512) 555-6288 | [email protected] | ¤ 29,000.00 | Abromsky | Alexandru | 25380 Pedernales Point Dr | Spicewood | Associate Professor | TX | Northwest |
| FAC-8662 | 78610 | (512) 555-5134 | (512) 555-6231 | [email protected] | ¤ 49,000.00 | Suh | Kingston | 290 Tobin Dr | Buda | Instructor | TX | Southwest |
| FAC-8727 | 78644 | (512) 555-5154 | (512) 555-6251 | [email protected] | ¤ 34,789.00 | Gilmore | Teshome | 1430 N Pecos St | Lockhart | Assistant Instructor | TX | Southeast |
| FAC-9005 | 78726 | (512) 555-5151 | (512) 555-6248 | [email protected] | ¤ 34,000.00 | Wazir | Paul | 11440 Sweet Basil Ct | Austin | Assistant Instructor | TX | Northwest |
| FAC-9119 | 78664 | (512) 555-5172 | (512) 555-6269 | [email protected] | ¤ 32,800.00 | Bowman | Nuzhut | 3208 Misty Oaks Way | Round Rock | Assistant Instructor | TX | Northeast |
| Major ID | Major Name | Lead Faculty ID |
|---|---|---|
| 105 | Diagnostic Medical Sonography | FAC-0393 |
| 158 | Emergency Medical Services | FAC-0767 |
| 158.100.07 | Emergency Medical Technician | FAC-1133 |
| 158.101.07 | Paramedic | FAC-1283 |
| 158.551.03 | Critical Care | FAC-1772 |
| 159 | Human Services | FAC-2234 |
| 160.330.33 | Financial Services | FAC-2245 |
| 200 | Automotive Technology | FAC-2289 |
| 213 | Business Administration | FAC-2322 |
| 215 | Nursing | FAC-2375 |
| 220.201.03 | Auto Parts Management | FAC-2377 |
| 220.233.05 | Automotive Brakes/Suspension/Inspections | FAC-2877 |
| 220.253.10 | Automotive Electrical and Electronics | FAC-2998 |
| 220.254.33 | Automotive Engine Diagnosis | FAC-3433 |
| 220.611.45 | Diesel and Industrial Machine Repair | FAC-3567 |
| 225.03.01 | American Sign Language | FAC-3651 |
| 298 | Horticulture | FAC-4901 |
| 298.05 | Greenhouse Production and Garden Center Management | FAC-6534 |
| 298.310.70 | Turfgrass Management | FAC-6543 |
| 298.67 | Landscape Design and Management | FAC-6678 |
| 300 | Accounting | FAC-7223 |
| 300.01 | Accounting Specialist | FAC-7223 |
| 300.302.01 | Accounting Technician | FAC-7223 |
| 303 | Administration of Justice | FAC-8375 |
| 320 | Paralegal Studies | FAC-8523 |
| 320.11 | Legal Assistant | FAC-8662 |
| 320.26 | General Practice Paralegal | FAC-8727 |
| 320.55 | Litigation Paralegal | FAC-9005 |
| 338.821.03 | Developmental Disabilities Specialist | FAC-9119 |
| 339 | Information Systems Technology | FAC-9116 |
| 339.123.78 | Database Specialist | FAC-6544 |
| 339.511.01 | Web Development Specialist | FAC-3434 |
| 339.781.23 | Network Engineer | FAC-3992 |
| 367 | Health Information Technology | FAC-4902 |
| 369 | Health Sciences | FAC-3347 |
| 400 | Administrative Support Technology | FAC-2178 |
| 400.01 | Medical Technology Support | FAC-3485 |
| 400.03 | Administrative Assistant | FAC-8524 |
| 415.01 | Graphic Design | FAC-6790 |
| 415.03 | Graphic Design for Advertising | FAC-6790 |
| 415.07 | Graphic Design for Multimedia | FAC-6790 |
| 421 | General Studies | FAC-5319 |
| 440.303.01 | Business Information Specialist | FAC-2312 |
| 551 | Civil Engineering | FAC-8723 |
| 551.003.55 | Civil Engineering Technician | FAC-3423 |
| 551.451.23 | Land Surveying | FAC-5423 |
| 551.887.62 | Laboratory Technology | FAC-1367 |
| 656 | Early Childhood Development | FAC-7823 |
| 656.01 | Early Childhood Instruction | FAC-6523 |
| 656.154.99 | Child Development | FAC-2865 |
| 656.332.23 | Youth Program Administration | FAC-3992 |
| 656.432.786 | Early Education Support Specialist | FAC-9313 |
| 700 | Computer Aided Drafting and Design | FAC-5412 |
| 729.03 | Architectural Drafting and Design | FAC-2342 |
| 729.33 | Mechanical Drafting and Design | FAC-4353 |
| 785 | Hospitality Management | FAC-6723 |
| 785.06 | Culinary Arts | FAC-8923 |
| 785.07 | Food Service Management | FAC-7612 |
| 785.070.87 | Catering | FAC-2371 |
| 785.45 | Lodging Management | FAC-5424 |
| 800 | Air Conditioning and Refrigeration | FAC-5136 |
| 800.03 | ACR Technician | FAC-7623 |
| 820 | Physical Therapist Assistant | FAC-6529 |
| 821 | Occupational Therapy Assistant | FAC-6245 |
| 900 | Electromechanical Controls Technology | FAC-8234 |
| 900.76 | Electrical Wiring | FAC-3245 |
| 900.78.65 | Electromechanical Controls | FAC-1284 |
| 951.03 | Electronics Technology | FAC-1165 |
| 951.06 | Electronics Engineering Technology | FAC-4523 |
| 965 | Welding | FAC-6343 |
| Scholarship ID | Scholarship Name | Amount | Type | Award Date | Student ID | Awarding Organization |
|---|---|---|---|---|---|---|
| S-01 | Wilson Memorial Scholarship | 300.0 | College | 9/30/18 | 2349535 | Texas Lakes CC Foundation |
| S-02 | TLCC Administrators Award | 100.0 | College | 5/23/18 | 2034834 | Texas Lakes CC Foundation |
| S-03 | TLCC President's Award | 500.0 | College | 5/1/18 | 2349535 | Texas Lakes CC Foundation |
| S-04 | Round Rock Country Club Award | 300.0 | Country Club | 5/23/18 | 2583697 | Round Rock Country Club |
| S-05 | Austin Sports Fellowship Award | 500.0 | College | 2/15/18 | 3128456 | Texas Lakes CC Foundation |
| S-06 | Franklin Memorial Scholarship | 750.0 | Foundation | 3/22/18 | 3458632 | Franklin Foundation |
| S-07 | Austin Country Club Award | 200.0 | Country Club | 6/25/18 | 3569325 | Austin Country Club |
| S-08 | Engineers Award | 500.0 | College | 1/16/18 | 3572184 | Texas Lakes CC Foundation |
| S-09 | Nursing Award | 300.0 | College | 10/30/18 | 3586943 | Texas Lakes CC Foundation |
| S-10 | Information Techology Award | 200.0 | Foundation | 5/6/18 | 3593653 | Texas Lakes Community Foundation |
| S-11 | Presidential Memorial Award | 200.0 | Foundation | 11/4/18 | 3768532 | Presidential Memorial Fund |
| S-12 | Texas Academic Award | 300.0 | College | 5/6/18 | 3852938 | Texas Lakes CC Foundation |
| S-13 | All American Academic Achievement Award | 200.0 | College | 8/4/18 | 3856930 | Texas Lakes CC Foundation |
| S-14 | Texas Science Achievement Award | 750.0 | College | 11/12/18 | 4352863 | Texas Lakes CC Foundation |
| S-15 | Texas IT Award | 500.0 | College | 1/25/18 | 4719238 | Texas Lakes CC Foundation |
| S-16 | Auto Body Award | 400.0 | Country Club | 5/23/18 | 4739502 | Texas Lakes Country Club |
| S-17 | Round Rock Rotary Club Award | 200.0 | Rotary Club | 7/29/18 | 4769304 | Rotary Club of Round Rock |
| S-18 | Pflugerville County Foundation Award | 250.0 | Foundation | 5/21/18 | 4852384 | Pflugerville County Foundation for Education |
| S-19 | Capital Cities Country Club Foundation Award | 200.0 | College | 12/6/18 | 5820384 | Texas Lakes CC Foundation |
| S-20 | Michael Fresch Foundation Award | 400.0 | Foundation | 4/14/18 | 5834924 | Michael Fresch Family Foundation |
| S-21 | Texas Science Competition Award | 100.0 | College | 7/12/18 | 5835035 | Texas Lakes CC Foundation |
| S-22 | San Marcos Rotary Club Award | 200.0 | Rotary Club | 2/22/18 | 4352863 | Rotary Club of San Marcos |
| S-23 | J. William Madison Memorial Award | 500.0 | College | 8/15/18 | 3458632 | Texas Lakes CC Foundation |
| S-24 | Mary Fell Memorial Award | 500.0 | College | 4/10/18 | 4852384 | Texas Lakes CC Foundation |
| S-25 | Academic Achievement Award | 400.0 | College | 12/22/18 | 2349535 | Texas Lakes CC Foundation |
| S-26 | Dolphin Club Award | 300.0 | College | 10/24/18 | 3569325 | Texas Lakes CC Foundation |
| S-27 | Joseph Ingram Memorial Award | 400.0 | College | 12/1/18 | 3128456 | Texas Lakes CC Foundation |
| S-28 | Elgin Rotary Club Award | 200.0 | Rotary Club | 3/27/18 | 3458632 | Rotary Club of Elgin |
| S-29 | Admin Assistant Award | 600.0 | College | 2/12/18 | 2349535 | Texas Lakes CC Foundation |
| S-30 | Student Government Award | 500.0 | College | 7/18/18 | 2349535 | Texas Lakes CC Foundation |
| Student ID | Last Name | First Name | Middle Initial | Address | City | State | Postal Code | Phone | Major ID | Amount Owed | Faculty ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2034834 | Miller | Kelly | J | 2024 Washington St | Red Rock | TX | 78662.0 | (512) 555-2017 | [email protected] | 300 | 84.25 | FAC-2245 |
| 2349535 | Adams | David | M | 316 Lincoln Dr | Spicewood | TX | 78669.0 | (512) 555-0302 | [email protected] | 220.253.10 | 178.25 | FAC-2377 |
| 2583697 | Mitchell | Clinton | E | 13273 Miller Dr | Austin | TX | 78753.0 | (512) 555-0305 | [email protected] | 303 | 15.15 | FAC-2289 |
| 3128456 | Smith | Wayne | Z | 14380 Adams Cir | Pflugerville | TX | 78660.0 | (512) 555-2329 | [email protected] | 200 | FAC-6543 | |
| 3458632 | Charles | Stacy | G | 1731 Primrose Trl | Round Rock | TX | 78665.0 | (512) 555-2330 | [email protected] | 158.551.03 | FAC-2245 | |
| 3569325 | Phillips | Cami | A | 28A 4th Ave | Smithville | TX | 78657.0 | (512) 555-0301 | [email protected] | 158 | FAC-9005 | |
| 3572184 | Riley | Stella | N | 715 Pampas Ricas Dr | Leander | TX | 78641.0 | (512) 555-2026 | [email protected] | 215 | 1232.0 | FAC-8223 |
| 3586943 | Campbell | Janice | C | 660 Bayou Bend Dr | Buda | TX | 78610.0 | (512) 555-9360 | [email protected] | 215 | 26.25 | FAC-8223 |
| 3593653 | Lopez | Maria | R | 2132 Mesquite Ln | Georgetown | TX | 78626.0 | (512) 555-0301 | [email protected] | 298.67 | FAC-6543 | |
| 3768532 | Bennett | Alexander | A | 218 Chapparral Trl | Red Rock | TX | 78662.0 | (512) 555-1017 | [email protected] | 220.253.10 | 541.85 | FAC-2234 |
| 3852938 | Your Last Name | Your First Name | O | 1172 Buffalo St | Bastrop | TX | 78602.0 | (512) 555-1018 | [email protected] | 700 | FAC-6543 | |
| 3856930 | Neal | Joseph | L | 444 E Alamo St | Elgin | TX | 78621.0 | (512) 555-1004 | [email protected] | 421 | 1.0 | FAC-8223 |
| 4352863 | Bradford | Cathy | Y | 2708 Kickapoo Cavern Dr | Pflugerville | TX | 78660.0 | (512) 555-2013 | [email protected] | 369 | 215.78 | FAC-2289 |
| 4719238 | Nickel | Abby | A | 1172 Buttonwood St | Dripping Springs | TX | 78620.0 | (512) 555-2319 | [email protected] | 785 | FAC-6543 | |
| 4739502 | English | Lauren | J | 3590 Longhorn Trl | Austin | TX | 78745.0 | (512) 555-2025 | [email protected] | 656.01 | FAC-2245 | |
| 4769304 | Hernandez | Joseph | E | 2251 Charolais Drive | Austin | TX | 78745.0 | (512) 555-2064 | [email protected] | 965 | FAC-6543 | |
| 4852384 | Nguyen | Wu | A | 105 E Myrtle St | Liberty Hill | TX | 78642.0 | (512) 555-2323 | [email protected] | 785 | 225.0 | FAC-2234 |
| 5820384 | Randolph | Elliot | N | 5634 Dodge St | Lockhart | TX | 78644.0 | (512) 555-2019 | [email protected] | 700 | 16.67 | FAC-2289 |
| 5834924 | Keys | Ella | B | 4822 Turtle Mound Bnd | Austin | TX | 78748.0 | (512) 555-2031 | [email protected] | 656 | 789.14 | FAC-2245 |
| 5835035 | Price | Lacey | F | 263 Caddis Cv | Elgin | TX | 78621.0 | (512) 555-0304 | [email protected] | 951.03 | 1002.78 | FAC-8223 |
| ID | Title | Start Time | End Time | Location | Description |
|---|---|---|---|---|---|
| 1 | Reducing Test Anxiety | 4/8/18 | 4/8/18 | Northeast Campus | Study Skills |
| 2 | Financial Aid | 4/14/18 | 4/14/18 | Southeast Campus | CC Info |
| 3 | Preparing for the Job Interview | 4/15/18 | 4/15/18 | Northwest Campus | Job Skills |
| 4 | Self Defense | 4/18/18 | 4/18/18 | Southeast Campus | Health & Safety |
| 5 | Managing Time and Stress | 4/18/18 | 4/18/18 | Southwest Campus | Study Skills |
| 6 | Preparing for Tests | 4/20/18 | 4/20/18 | Southeast Campus | Study Skills |
SELECT Students.*, Scholarships.*
FROM Students INNER JOIN Scholarships ON Students.[Student ID] = Scholarships.[Student ID];