Order Now

Expert answer:excel assignment

Uncategorized

Expert answer:I attached 2 files below. The Excel file is where to do the work. Word file contains questions. Please use my file to do the work……
ex16xlch12gradercapas___teaching_schedule_11_instructions.docx

duong_e12c2schedule.xlsx

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Excel 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.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
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.000
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.000
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.000
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.000
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.000
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.000
7
Insert a form control button filling the range E1:E3 in the Sequential worksheet and assign it
to the RoomSort macro.
16.000
8
9
Edit the text that appears on the button to display the text RoomSort.
2.000
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.
Updated: 10/18/2017
1
12.000
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
10
Create a new worksheet named Code to the right of the Faculty sheet.
5.000
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.000
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.000
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.000
Total Points
Updated: 10/18/2017
2
100.000
Current_Instruction.docx
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

How it works

  1. Paste your instructions in the instructions box. You can also attach an instructions file
  2. Select the writer category, deadline, education level and review the instructions 
  3. Make a payment for the order to be assignment to a writer
  4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades

Continue to order Get a quote
Place your order
(550 words)

Approximate price: $22

Recent Comments

No comments to show.

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

Order your essay today and save 20% with the discount code ESSAYHELP

Get a plagiarism free paper now