Steps to Perform:
| Step | Instructions | Points Possible |
| 1 | Download and open the file named exploring_e12c2Schedule.xlsx, and then save the file as e12c2Schedule_LastFirst, replacing LastFirst with your name. | 0 |
| 2 | On the Sequential worksheet, apply the Retrospect theme and the Aspect theme color. Apply Heading 3 cell style to the column labels in the range A4:K4. | 10 |
| 3 | Record a macro named RoomSort. Click and drag to select the range A4:K46 from the Sequential worksheet, then copy and paste the data in cell A4 of the Room worksheet. Do not stop the recording after this step. | 10 |
| 4 | With the macro still recording, click cell A4. On the Data tab, in the Sort & Filter group, click Sort. Using the Sort dialog box, sort the data by Room in alphabetical order. Add a second level sort that sorts the Days column using the following custom sort order: MWF, MW, M, W, TR, T, R, S. Add a third level sort that sorts the Start Time column from earliest to latest. Return to the Sequential worksheet, click cell A1 and stop the recording. Save the workbook as a Macro-Enabled Template. | 15 |
| 5 | With A1 of the Sequential worksheet selected, record a macro named FacultySort. Click and drag to select the range A4:K46 from the Sequential worksheet, then copy and paste the data in cell A4 of the Faculty worksheet. Do not stop the recording after this step. | 10 |
| 6 | With the macro still recording, click cell A4. Create a custom sort that does the following: Sort Instructor in alphabetical order, then by Days with the custom order created in the prior step (Step 4), then by Start Time from earliest to latest. After the sort is complete, return to cell A1 on the Sequential worksheet and stop recording. | 10 |
| 7 | Insert a form control button filling the range E1:E3 in the Sequential worksheet and assign it to the RoomSort macro. | 16 |
| 8 | Edit the text that appears on the button to display the text RoomSort. | 2 |
| 9 | Using the prior steps as a guide, create a second button that displays the text FacultySort filling the range F1:H3 and assign it to the FacultySort macro. Once completed, save the macro-enabled template. | 12 |
| 10 | Create a new worksheet named Code to the right of the Faculty sheet. | 5 |
| 11 | Open the VBA Editor and display the module containing the room sort. Copy the code beginning with the text Sub RoomSort () and ending with the first instance of the text End Sub. Paste the contents in cell A1 of the Code worksheet. Ensure that the copied code is formatted as Text. Do not close the VBA Editor. | 5 |
| 12 | Display the module containing the faculty sort. Copy the code beginning with the text Sub FacultySort () and ending with the final instance of the text End Sub. Paste the contents in cell F1 of the Code worksheet. Ensure that the copied code is formatted as Text. Close the VBA Editor. | 5 |
| 13 | Save the file as an Excel Workbook (not macro-enabled) with the name e12c1Schedule_solution. Ensure that the workbooks are displayed in the following order: Sequential, Room, Faculty, and Code. Close the workbook and exit Excel. Submit the e12c1Schedule_solution.xlsx workbook as directed. | 0 |
Room Section:
Faculty Section:
If you could please help with this, I would greatly appreciate it!
P6 X fo F G H J K L M Days TR Start Time End Time Room 5:30 PM 6:45 PM CS 615 Max 30 28 TR 40 W 40 S 28 TR 30 28 A B C D E 1 Fall 2015 2 31 4 ID Prefix Number Section Course Title 5 12346 INFO 1100 601 Introduction to Computers 6 12347 INFO 1100 701 Introduction to Computers 7 12348 INFO 1120 001 Information Systems Fundamentals 8 12349 INFO 1120 601 Information Systems Fundamentals 9 12350 INFO 1120 801 Information Systems Fundamentals 10 12351 INFO 1200 001 Computer Programming I(C#) 11 12352 INFO 1420 001 Comp Arch Systems Software 12 12353 INFO 1510 001 Intro to Sys Admin UNIX Linux 13 12354 INFO 1510 601 Intro to Sys Admin UNIX Linux 14 12355 INFO 2030 001 Business Data Communications 15 12356 INFO 2050 001 Database Fundamentals 16 12357 INFO 2200 001 Computer Programming II (C#) 17 12358 INFO 2450 001 Web Application Design 18 12359 INFO 2450 701 Web Application Design 19 12360 INFO 2660 001 Info Security Fundamentals 20 12361 INFO 2660 801 Info Security Fundamentals 21 12362 INFO 3010 001 Executive Lecture Series 22 12363 INFO 3030 001 Networks and Internetworking LET nen na1 Databaco Cueto Sequential Room Faculty + TR MWF 11:30 AM 12:45 PM CS 615 5:30 PM 8:00 PM CS 615 10:45 AM 1:15 PM CS 615 4:00 PM 5:15 PM CS 614 2:30 PM 3:45 PM CS 617 1:00 PM 1:50 PM CS 614 7:00 PM 8:15 PM CS 614 4:00 PM 5:15 PM CS 708 10:00 AM 11:15 AM CS 617 2:30 PM 3:45 PM CS 614 1:00 PM 2:15 PM CS 617 32 TR 32 Instructor Staff McOmber, Mindy Olsen, Troy McOmber, Mindy Garcia, Max Wong, Tim Busby, Linda Eberling, Amanda Busby, Linda Grodsky, Philip Mast, Kevin Wong, Tim Bartholomew, Katrina Bartholomew, Katrina Eberling, Amanda Busby, Linda Eberling, Amanda Grodsky, Philip maet Kanin TR 35 TR 28 TR 32 TR 30 35 MWF 25 S 9:00 AM 8:00 AM 11:30 AM 11:00 AM 10.00 AM R 9:50 AM CS 708 10:30 AM CS 708 12:30 PM CS 404 11:50 AM CS 517 CC-17 32 120 18 MWE MARIE EA 10.CAANA Select destination and press ENTER or choose Paste Clipboard Font Alignment Number Styles Cel P6 X fa F - L K S 32 120 R MWF 18 26 MWF TR MW 35 40 TR 32 MW 32 MW 28 TR 32 33 A B C D E 20 12361 INFO 2660 801 Info Security Fundamentals 21 12362 INFO 3010 001 Executive Lecture Series 22 12363 INFO 3030 001 Networks and Internetworking 23 12364 INFO 3050 001 Database Systems 24 12365 INFO 3120 001 Management Information Systems 25 12366 INFO 3120 002 Management Information Systems 26 12367 INFO 3120 003 Management Information Systems 27 12368 INFO 3120 004 Management Information Systems 28 12369 INFO 3120 601 Management Information Systems 29 12370 INFO 3120 602 Management Information Systems 30 12371 INFO 3120 701 Management Information Systems 31 12372 INFO 3400 001 Project Management 32 12373 INFO 3400 701 Project Management 33 12374 INFO 3050 002 Database Systems 34 12375 INFO 3420 001 Web Systems Development I 35 12376 INFO 3430 601 Systems Analysis and Design 36 12377 INFO 3510 601 Adv Sys Admin UNIX Linux 37 12378 INFO 3630 001 Adv Sys Admin Windows Server 38 12379 INFO 3660 601 Info Sec Network Def 39 12380 INFO 3800 601 Comp Forensics Cybercrime 40 12381 INFO 4030 001 Enterprise Network Arch Admin 41 12382 INFO 4050 701 Global Ethics-Information Systems 4212202 Ann 1601 Global Cubice Information Cuctome Sequential Room Faculty + G 8:00 AM 10:30 AM CS 708 Busby, Linda 11:30 AM 12:30 PM CS 404 Eberling, Amanda 11:00 AM 11:50 AM CS 517 Grodsky, Philip 10:00 AM 10:50 AM CS 617 Mast, Kevin 8:30 AM 9:45 AM CS 615 Mast, Kevin 1:00 PM 2:15 PM CS 615 Olsen, Troy 1:00 PM 2:15 PM CS 614 Garcia, Max 2:30 PM 3:45 PM CS 615 Olsen, Troy 5:30 PM 6:45 PM CS 617 Wong, Tim 5:30 PM 6:45 PM CS 614 Garcia, Max TBA TBA Bartholomew, Katrina 8:00 AM 8:50 AM CS 617 Grodsky, Philip Grodsky, Philip 1:00 PM 1:50 PM CS 617 Mast, Kevin 4:00 PM 5:15 PM CS 510 Bartholomew, Katrina 4:00 PM 5:15 PM CS 614 Garcia, Max 5:30 PM 6:45 PM CS 614 Staff 3:30 PM 4:45 PM CS 617 Staff 5:30 PM 6:45 PM CS 510 Whitaker, Todd 2:30 PM 3:45 PM CS 404 Whitaker, Todd 4:00 PM 5:15 PM CS 510 Staff Bastian, Vanessa 2.20 DMA 2:45 DMA C1621 Dactian Wanoce MWE MWF 28 30 26 TR 16 32 MW MW 28 MW 28 MW 16 TR 35 16 MW 30 INICO TD Clipboard Font Alignment Number Styles P6 A B D F G J K 001 TR 16 601 MW 32 601 MW 28 34 12375 35 12376 36 12377 37 12378 38 12379 39 12380 40 12381 INFO 3420 INFO 3430 INFO 3510 INFO 3630 INFO 3660 INFO 3800 001 H 5:15 PM CS 510 5:15 PM CS 614 6:45 PM CS 614 4:45 PM CS 617 6:45 PM CS 510 3:45 PM CS 404 5:15 PM CS 510 MW 4:00 PM 4:00 PM 5:30 PM 3:30 PM 5:30 PM 2:30 PM 4:00 PM 28 601 MW 16 TR E Web Systems Development Systems Analysis and Design Adv Sys Admin UNIX Linux Adv Sys Admin Windows Server Info Sec Network Def Comp Forensics Cybercrime Enterprise Network Arch Admin Global Ethics-Information Systems Global Ethics-Information Systems Senior Project Current Topic Mobile iPhone Dev Current Topic PHP Current Topic Cloud Computing 35 601 001 INFO 4030 Bartholomew, Katrina Garcia, Max Staff Staff Whitaker, Todd Whitaker, Todd Staff Bastian, Vanessa Bastian, Vanessa McOmber, Mindy Olson, Anita Olson, Anita Olson, Anita 16 INFO 4050 30 MW TR 701 001 2:30 PM 3:45 PM GT634 30 16 INFO 4050 INFO 4550 INFO 4590 INFO 4590 INFO 459R 601 601 41 12382 42 12383 43 12384 44 12385 45 12386 46 12387 47 48 49 T w 7:00 PM 7:00 PM 7:00 PM 30 30 602 603 9:30 PM CS 615 9:30 PM CS 510 9:30 PM CS 615 R 30 50 51 52 53 54 55 56 Sequential Room Faculty Arressibility: Good to B C D E F G 1 Fall 2015 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Sequential Room Faculty + Arcorribilitu and to an B C E F H 1 Fall 2015 N 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Room Faculty Sequential Accessibility: Good to go P6 X fo F G H J K L M Days TR Start Time End Time Room 5:30 PM 6:45 PM CS 615 Max 30 28 TR 40 W 40 S 28 TR 30 28 A B C D E 1 Fall 2015 2 31 4 ID Prefix Number Section Course Title 5 12346 INFO 1100 601 Introduction to Computers 6 12347 INFO 1100 701 Introduction to Computers 7 12348 INFO 1120 001 Information Systems Fundamentals 8 12349 INFO 1120 601 Information Systems Fundamentals 9 12350 INFO 1120 801 Information Systems Fundamentals 10 12351 INFO 1200 001 Computer Programming I(C#) 11 12352 INFO 1420 001 Comp Arch Systems Software 12 12353 INFO 1510 001 Intro to Sys Admin UNIX Linux 13 12354 INFO 1510 601 Intro to Sys Admin UNIX Linux 14 12355 INFO 2030 001 Business Data Communications 15 12356 INFO 2050 001 Database Fundamentals 16 12357 INFO 2200 001 Computer Programming II (C#) 17 12358 INFO 2450 001 Web Application Design 18 12359 INFO 2450 701 Web Application Design 19 12360 INFO 2660 001 Info Security Fundamentals 20 12361 INFO 2660 801 Info Security Fundamentals 21 12362 INFO 3010 001 Executive Lecture Series 22 12363 INFO 3030 001 Networks and Internetworking LET nen na1 Databaco Cueto Sequential Room Faculty + TR MWF 11:30 AM 12:45 PM CS 615 5:30 PM 8:00 PM CS 615 10:45 AM 1:15 PM CS 615 4:00 PM 5:15 PM CS 614 2:30 PM 3:45 PM CS 617 1:00 PM 1:50 PM CS 614 7:00 PM 8:15 PM CS 614 4:00 PM 5:15 PM CS 708 10:00 AM 11:15 AM CS 617 2:30 PM 3:45 PM CS 614 1:00 PM 2:15 PM CS 617 32 TR 32 Instructor Staff McOmber, Mindy Olsen, Troy McOmber, Mindy Garcia, Max Wong, Tim Busby, Linda Eberling, Amanda Busby, Linda Grodsky, Philip Mast, Kevin Wong, Tim Bartholomew, Katrina Bartholomew, Katrina Eberling, Amanda Busby, Linda Eberling, Amanda Grodsky, Philip maet Kanin TR 35 TR 28 TR 32 TR 30 35 MWF 25 S 9:00 AM 8:00 AM 11:30 AM 11:00 AM 10.00 AM R 9:50 AM CS 708 10:30 AM CS 708 12:30 PM CS 404 11:50 AM CS 517 CC-17 32 120 18 MWE MARIE EA 10.CAANA Select destination and press ENTER or choose Paste Clipboard Font Alignment Number Styles Cel P6 X fa F - L K S 32 120 R MWF 18 26 MWF TR MW 35 40 TR 32 MW 32 MW 28 TR 32 33 A B C D E 20 12361 INFO 2660 801 Info Security Fundamentals 21 12362 INFO 3010 001 Executive Lecture Series 22 12363 INFO 3030 001 Networks and Internetworking 23 12364 INFO 3050 001 Database Systems 24 12365 INFO 3120 001 Management Information Systems 25 12366 INFO 3120 002 Management Information Systems 26 12367 INFO 3120 003 Management Information Systems 27 12368 INFO 3120 004 Management Information Systems 28 12369 INFO 3120 601 Management Information Systems 29 12370 INFO 3120 602 Management Information Systems 30 12371 INFO 3120 701 Management Information Systems 31 12372 INFO 3400 001 Project Management 32 12373 INFO 3400 701 Project Management 33 12374 INFO 3050 002 Database Systems 34 12375 INFO 3420 001 Web Systems Development I 35 12376 INFO 3430 601 Systems Analysis and Design 36 12377 INFO 3510 601 Adv Sys Admin UNIX Linux 37 12378 INFO 3630 001 Adv Sys Admin Windows Server 38 12379 INFO 3660 601 Info Sec Network Def 39 12380 INFO 3800 601 Comp Forensics Cybercrime 40 12381 INFO 4030 001 Enterprise Network Arch Admin 41 12382 INFO 4050 701 Global Ethics-Information Systems 4212202 Ann 1601 Global Cubice Information Cuctome Sequential Room Faculty + G 8:00 AM 10:30 AM CS 708 Busby, Linda 11:30 AM 12:30 PM CS 404 Eberling, Amanda 11:00 AM 11:50 AM CS 517 Grodsky, Philip 10:00 AM 10:50 AM CS 617 Mast, Kevin 8:30 AM 9:45 AM CS 615 Mast, Kevin 1:00 PM 2:15 PM CS 615 Olsen, Troy 1:00 PM 2:15 PM CS 614 Garcia, Max 2:30 PM 3:45 PM CS 615 Olsen, Troy 5:30 PM 6:45 PM CS 617 Wong, Tim 5:30 PM 6:45 PM CS 614 Garcia, Max TBA TBA Bartholomew, Katrina 8:00 AM 8:50 AM CS 617 Grodsky, Philip Grodsky, Philip 1:00 PM 1:50 PM CS 617 Mast, Kevin 4:00 PM 5:15 PM CS 510 Bartholomew, Katrina 4:00 PM 5:15 PM CS 614 Garcia, Max 5:30 PM 6:45 PM CS 614 Staff 3:30 PM 4:45 PM CS 617 Staff 5:30 PM 6:45 PM CS 510 Whitaker, Todd 2:30 PM 3:45 PM CS 404 Whitaker, Todd 4:00 PM 5:15 PM CS 510 Staff Bastian, Vanessa 2.20 DMA 2:45 DMA C1621 Dactian Wanoce MWE MWF 28 30 26 TR 16 32 MW MW 28 MW 28 MW 16 TR 35 16 MW 30 INICO TD Clipboard Font Alignment Number Styles P6 A B D F G J K 001 TR 16 601 MW 32 601 MW 28 34 12375 35 12376 36 12377 37 12378 38 12379 39 12380 40 12381 INFO 3420 INFO 3430 INFO 3510 INFO 3630 INFO 3660 INFO 3800 001 H 5:15 PM CS 510 5:15 PM CS 614 6:45 PM CS 614 4:45 PM CS 617 6:45 PM CS 510 3:45 PM CS 404 5:15 PM CS 510 MW 4:00 PM 4:00 PM 5:30 PM 3:30 PM 5:30 PM 2:30 PM 4:00 PM 28 601 MW 16 TR E Web Systems Development Systems Analysis and Design Adv Sys Admin UNIX Linux Adv Sys Admin Windows Server Info Sec Network Def Comp Forensics Cybercrime Enterprise Network Arch Admin Global Ethics-Information Systems Global Ethics-Information Systems Senior Project Current Topic Mobile iPhone Dev Current Topic PHP Current Topic Cloud Computing 35 601 001 INFO 4030 Bartholomew, Katrina Garcia, Max Staff Staff Whitaker, Todd Whitaker, Todd Staff Bastian, Vanessa Bastian, Vanessa McOmber, Mindy Olson, Anita Olson, Anita Olson, Anita 16 INFO 4050 30 MW TR 701 001 2:30 PM 3:45 PM GT634 30 16 INFO 4050 INFO 4550 INFO 4590 INFO 4590 INFO 459R 601 601 41 12382 42 12383 43 12384 44 12385 45 12386 46 12387 47 48 49 T w 7:00 PM 7:00 PM 7:00 PM 30 30 602 603 9:30 PM CS 615 9:30 PM CS 510 9:30 PM CS 615 R 30 50 51 52 53 54 55 56 Sequential Room Faculty Arressibility: Good to B C D E F G 1 Fall 2015 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Sequential Room Faculty + Arcorribilitu and to an B C E F H 1 Fall 2015 N 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Room Faculty Sequential Accessibility: Good to go
