Expert Answer:Templates, Styles, and Macros

Answer & Explanation:just follow the instruction, finish it on the excel which is I give to you, please.
ex16xlch12gradercapas___teaching_schedule_11_instructions.docx

ren_e12c2schedule.xlsx

Unformatted Attachment Preview

Grader – Instructions
Excel 2016 Project
EX16_XL_CH12_GRADER_CAP_AS – Teaching Schedule 1.1
Project Description:
As the department head of the Information Systems Department at a university, you are responsible for developing the class
teaching schedules for your faculty. You have a tentative Fall 2015 schedule developed in sequence, but you want to ensure
that you are not double-booking classrooms or faculty. To help you review room and faculty schedules, you will need to sort
the original list in various ways. In addition, you want to create a model to use as a template for future semesters and to share
with other department heads.
Steps to Perform:
Step
Points
Possible
Instructions
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
Created On: 07/05/2019
1
EX16_XL_CH12_GRADER_CAP_AS – Teaching Schedule 1.1
Grader – Instructions
Excel 2016 Project
Points
Possible
Step
Instructions
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
Total Points
Created On: 07/05/2019
2
100
EX16_XL_CH12_GRADER_CAP_AS – Teaching Schedule 1.1
Fall 2015
ID
12346
12347
12348
12349
12350
12351
12352
12353
12354
12355
12356
12357
12358
12359
12360
12361
12362
12363
12364
12365
12366
12367
12368
12369
12370
12371
12372
12373
12374
12375
12376
12377
12378
12379
12380
12381
12382
12383
12384
12385
12386
12387
Prefix
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
INFO
Number
1100
1100
1120
1120
1120
1200
1420
1510
1510
2030
2050
2200
2450
2450
2660
2660
3010
3030
3050
3120
3120
3120
3120
3120
3120
3120
3400
3400
3050
3420
3430
3510
3630
3660
3800
4030
4050
4050
4550
4590
4590
459R
Section
601
701
001
601
801
001
001
001
601
001
001
001
001
701
001
801
001
001
001
001
002
003
004
601
602
701
001
701
002
001
601
601
001
601
601
001
701
001
601
601
602
603
Course Title
Introduction to Computers
Introduction to Computers
Information Systems Fundamentals
Information Systems Fundamentals
Information Systems Fundamentals
Computer Programming I (C#)
Comp Arch Systems Software
Intro to Sys Admin UNIX Linux
Intro to Sys Admin UNIX Linux
Business Data Communications
Database Fundamentals
Computer Programming II (C#)
Web Application Design
Web Application Design
Info Security Fundamentals
Info Security Fundamentals
Executive Lecture Series
Networks and Internetworking
Database Systems
Management Information Systems
Management Information Systems
Management Information Systems
Management Information Systems
Management Information Systems
Management Information Systems
Management Information Systems
Project Management
Project Management
Database Systems
Web Systems Development I
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
Days
TR
TBA
TR
W
S
TR
TR
MWF
TR
TR
TR
TR
TR
TBA
MWF
S
R
MWF
MWF
TR
MW
TR
MW
MW
TR
TBA
MWF
TBA
MWF
TR
MW
MW
MW
MW
TR
MW
TBA
TR
TBA
T
W
R
Start Time
5:30 PM
11:30 AM
5:30 PM
10:45 AM
4:00 PM
2:30 PM
1:00 PM
7:00 PM
4:00 PM
10:00 AM
2:30 PM
1:00 PM
9:00 AM
8:00 AM
11:30 AM
11:00 AM
10:00 AM
8:30 AM
1:00 PM
1:00 PM
2:30 PM
5:30 PM
5:30 PM
8:00 AM
1:00 PM
4:00 PM
4:00 PM
5:30 PM
3:30 PM
5:30 PM
2:30 PM
4:00 PM
2:30 PM
7:00 PM
7:00 PM
7:00 PM
End Time
6:45 PM
Room
CS 615
12:45 PM
8:00 PM
1:15 PM
5:15 PM
3:45 PM
1:50 PM
8:15 PM
5:15 PM
11:15 AM
3:45 PM
2:15 PM
CS 615
CS 615
CS 615
CS 614
CS 617
CS 614
CS 614
CS 708
CS 617
CS 614
CS 617
9:50 AM
10:30 AM
12:30 PM
11:50 AM
10:50 AM
9:45 AM
2:15 PM
2:15 PM
3:45 PM
6:45 PM
6:45 PM
8:50 AM
CS 708
CS 708
CS 404
CS 517
CS 617
CS 615
CS 615
CS 614
CS 615
CS 617
CS 614
TBA TBA
CS 617
1:50 PM
5:15 PM
5:15 PM
6:45 PM
4:45 PM
6:45 PM
3:45 PM
5:15 PM
CS 617
CS 510
CS 614
CS 614
CS 617
CS 510
CS 404
CS 510
3:45 PM
GT634
9:30 PM
9:30 PM
9:30 PM
CS 615
CS 510
CS 615
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
Mast, Kevin
Mast, Kevin
Olsen, Troy
Garcia, Max
Olsen, Troy
Wong, Tim
Garcia, Max
Bartholomew, Katrina
Grodsky, Philip
Grodsky, Philip
Mast, Kevin
Bartholomew, Katrina
Garcia, Max
Staff
Staff
Whitaker, Todd
Whitaker, Todd
Staff
Bastian, Vanessa
Bastian, Vanessa
McOmber, Mindy
Olson, Anita
Olson, Anita
Olson, Anita
Max
30
28
40
40
28
30
28
32
32
35
28
32
30
35
25
32
120
18
26
35
40
32
32
28
32
33
28
30
26
16
32
28
28
16
35
16
30
30
16
30
30
30
Fall 2015
Fall 2015

Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more