Charles_Mcgill_Module 4 - Server Logs (1)
xlsx
keyboard_arrow_up
School
University of Alabama *
*We aren’t endorsed by this school
Course
200
Subject
Electrical Engineering
Date
Apr 3, 2024
Type
xlsx
Pages
11
Uploaded by MagistrateKoupreyPerson3084
Bandwidth Used (MB)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
8-10am
5
6
5
7
8
0
0
10-12pm
8
10
7
9
8
3
3
12pm-2pm
12
12
15
14
12
0
0
2pm-4pm
22
25
20
18
17
9
8
4pm-6pm
13
12
15
17
15
0
1
Total
60
65
62
65
60
12
12
Total Bandwidth (Line Graph)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Bandwidth Used (MB)
0
10
20
30
40
50
60
70
Chart Title
8-10am
10-12pm
12pm-2pm
2pm-4pm
4pm-6pm
Total
Module 4: Spreadsheet Application: Analyzing Server Traffic
Campus Travel has recently found that its internet connections between offices are becoming slow, especi
certain periods of the day. Since all the online traffic is maintained by another company, an increase in ban
requires a formal approval from the general manager. The IS manager has proposed to increase the bandw
the company’s network; in a few days, he must present the business case for this proposal at the weekly m
the department heads. You are asked to prepare graphs for the presentation to support the IS manager’s b
case. In this file, you will find information about the network traffic for a 1-week period. Update this spreadsheet tab to provide the following information:
1) Update the "Total" row (row 8) to include the total bandwidth used per day
2) Insert a line graph in the gray area starting in cell B15 that shows total bandwidth used each day. Name this line graph "Total_Bandwidth_By_Day" and format the graph professionallly.
Navigate to the "Total Bandwidth" tab. 3) Update the "Total" column (column I) to include the total bandwidth used per time period
4) Insert a line graph in the gray area starting in cell B15 that shows total bandwidth used each time period. Name this line graph "Total_Bandwidth_By_Time" and format the graph professionally.
Navigate to the "Average Bandwidth" tab. 5) Update the "Average" column (column I) to include the average bandwidth used per time period
6) Insert a line graph in the gray area starting in cell B15 that shows average bandwidth used each time period. Name this line graph "Average_Bandwidth_By_Time" and format the graph professionally.
ially during ndwidth width of meeting of business
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
97024
Bandwidth Used (MB)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022 Total
8-10am
5
6
5
7
8
0
0
31
10-12pm
8
10
7
9
8
3
3
48
12pm-2pm
12
12
15
14
12
0
0
65
2pm-4pm
22
25
20
18
17
9
8
119
4pm-6pm
13
12
15
17
15
0
1
73
Bandwidth per Period (Line Graph)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Total
Bandwidth Used (MB)
0
20
40
60
80
100
120
140
Chart Title
8-10am
10-12pm
12pm-2pm
2pm-4pm
4pm-6pm
97024
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Bandwidth Used (MB)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Average
8-10am
5
6
5
7
8
0
0
4.43
10-12pm
8
10
7
9
8
3
3
6.86
12pm-2pm
12
12
15
14
12
0
0
9.29
2pm-4pm
22
25
20
18
17
9
8
17.00
4pm-6pm
13
12
15
17
15
0
1
10.43
Average Bandwidth per Period (Line Graph)
9/1/2022
9/2/2022
9/3/2022
9/4/2022
9/5/2022
9/6/2022
9/7/2022
Average
Bandwidth Used (MB)
0
5
10
15
20
25
30
Chart Title
8-10am
10-12pm
12pm-2pm
2pm-4pm
4pm-6pm
97024
Questions
Score
Data in cell(s): B8:H8, in worksheet: Ch 4 ServerLogs
1
Data in cell(s): CHART EXISTS, in worksheet: Ch 4 ServerLogs
1
Data in cell(s): CHART PROPERTIES, in worksheet: Ch 4 ServerLogs
0
Data in cell(s): I3:I7, in worksheet: Total Bandwidth
1
Data in cell(s): CHART EXISTS, in worksheet: Total Bandwidth
1
Data in cell(s): CHART PROPERTIES, in worksheet: Total Bandwidth
0
Data in cell(s): I3:I7, in worksheet: Average Bandwidth
1
Data in cell(s): CHART EXISTS, in worksheet: Average Bandwidth
1
Data in cell(s): CHART PROPERTIES, in worksheet: Average Bandwidth
0
Total Score
6
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Max Points
1
1
1
1
1
1
1
1
1
9
Feedback
Great job adding the bandwidth for each day!
Nice work adding a chart that shows the total bandwidth per day!
Make sure that only your Total bandwidth row is the only data series selected when creating your line chart.
Great job finding the total bandwidth for each time period!
Excellent job creating a chart that shows the bandwidth used in each time period per day.
Make sure that you selected the entire table of bandwidth amounts when creating your line chart.
Great job finding the average bandwidth for each time period!
Awesome work finding the average bandwidth per time period.
Make sure that only your average bandwidth column is the only data series selected when creating your line chart.
66.6667%
Related Documents
Related Questions
Explain in words the relationship between m18 and m19
arrow_forward
Explain the relationship between M18 and M19?
arrow_forward
Identify which measurement this oscilloscope time difference reading is useful for.
Oscilloscope-XSC1
Time
250.000 us
1.261 ms
Channel_A
169.064 V
168.513 V
-550. 584 mV
Channel_B
89. 282 V
95.005 V
5.722 V
Reverse
T2-T1
1.011 ms
Save
Ext. trigger
Timebase
Scale: 200 us/Div : Scale: 100 V/Div
X pos. (Div): 0
Channel A
Channel B
Scale: 100 V/Div
Y pos. (Div): 0
Trigger
Edge: F
Level: 0
A B Ext
Y pos. (Div): 0
V
Y/T Add B/A
A/B
AC
DC
AC
DC
Single Normal
O period
O none of the above
O phase shift
arrow_forward
For which measurement is this oscilloscope time difference reading useful?
Ociloscope-XSC1
Time
250.000 us
Channel_A
Channel B
89.282 V
-91.176 V
Reverse
169.064 V
-168.880 V
753.788 us
503. 788 us
T2-T1
-337.944 V
-180.458 V
Save
Ext. trigger
Timebase
Scale: ko0 us/Div : Scale: 100 V/Div
Channel A
Channel B
Trigger
100 v/Dv
Y pos. (Div): 0
Scale:
Edge: F2 AB
X pos. (Div): 0
Y pos. (Div): 0
Level:
Y/T Add B/A A/B
AC O DC
AC0 DC
O Single Normal Auto None
O phase shift
O period
O none of the above
SE R RI NI E BII E
arrow_forward
Identify which measurement this oscilloscope time difference reading is useful for.
Ociloscope-XSC1
Channel_A
169.064 V
168.513 V
Channel_B
89.282 V
95.005 V
Time
Reverse
250.000 us
1.261 ms
1.011 ms
T2
T2-T1
-550. 584 mV
5.722 V
Save
Ext. trigger
Channel A
Timebase
Scale: ko0 us/Div
X pos. (Div): 0
Y/T Add B/A A/B
Channel B
Trigger
Scale: 100 V/Div
Y pos. (Div): 0
AC0 DC
100 V/Div
f 2 AB Ext
Scale:
Edge:
| Y pos.(Div): 0
AC 0 DC
Level:
V
Single Normal Auto None
arrow_forward
A Moving to another question will save this
respons
Question 8
Phosphorus(P15) atoms are trivalent.
O True
False
Moving to another question will save this respons
arrow_forward
Isolator
MCB
MCCB
RCD
BIE
Noark
D 20A
480Y/277V
50/60Hz
5000A E355391
CAUS
us
D-OFF
C
D-OFF
The shown protection device is
arrow_forward
For Type B chopper, Find the expersstion for maximum and minimum current.
I current
arrow_forward
In the following diagram:
0 120
02
o 910
O
GND O
021
AND O
CEC O
CES C
CEO O
25 O
04N?
$24.0
O EZ
GND O
0 95.
RED O
O EX
O AD'S
AD-S
(NDC
92.0
0.39
ET O
10
5.0
(330
(590.
31250
Oniso
Onost
AL-EC
22. C
£200
25+ C
END C
OF
OSCL
YES O
EAED
::::
The resistor on row #44 is a 1.3KQ resistor that is controlling the color
blue on the RGB LED.
O True
False
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Power System Analysis and Design (MindTap Course ...
Electrical Engineering
ISBN:9781305632134
Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. Sarma
Publisher:Cengage Learning
Related Questions
- Explain in words the relationship between m18 and m19arrow_forwardExplain the relationship between M18 and M19?arrow_forwardIdentify which measurement this oscilloscope time difference reading is useful for. Oscilloscope-XSC1 Time 250.000 us 1.261 ms Channel_A 169.064 V 168.513 V -550. 584 mV Channel_B 89. 282 V 95.005 V 5.722 V Reverse T2-T1 1.011 ms Save Ext. trigger Timebase Scale: 200 us/Div : Scale: 100 V/Div X pos. (Div): 0 Channel A Channel B Scale: 100 V/Div Y pos. (Div): 0 Trigger Edge: F Level: 0 A B Ext Y pos. (Div): 0 V Y/T Add B/A A/B AC DC AC DC Single Normal O period O none of the above O phase shiftarrow_forward
- For which measurement is this oscilloscope time difference reading useful? Ociloscope-XSC1 Time 250.000 us Channel_A Channel B 89.282 V -91.176 V Reverse 169.064 V -168.880 V 753.788 us 503. 788 us T2-T1 -337.944 V -180.458 V Save Ext. trigger Timebase Scale: ko0 us/Div : Scale: 100 V/Div Channel A Channel B Trigger 100 v/Dv Y pos. (Div): 0 Scale: Edge: F2 AB X pos. (Div): 0 Y pos. (Div): 0 Level: Y/T Add B/A A/B AC O DC AC0 DC O Single Normal Auto None O phase shift O period O none of the above SE R RI NI E BII Earrow_forwardIdentify which measurement this oscilloscope time difference reading is useful for. Ociloscope-XSC1 Channel_A 169.064 V 168.513 V Channel_B 89.282 V 95.005 V Time Reverse 250.000 us 1.261 ms 1.011 ms T2 T2-T1 -550. 584 mV 5.722 V Save Ext. trigger Channel A Timebase Scale: ko0 us/Div X pos. (Div): 0 Y/T Add B/A A/B Channel B Trigger Scale: 100 V/Div Y pos. (Div): 0 AC0 DC 100 V/Div f 2 AB Ext Scale: Edge: | Y pos.(Div): 0 AC 0 DC Level: V Single Normal Auto Nonearrow_forwardA Moving to another question will save this respons Question 8 Phosphorus(P15) atoms are trivalent. O True False Moving to another question will save this responsarrow_forward
- Isolator MCB MCCB RCD BIE Noark D 20A 480Y/277V 50/60Hz 5000A E355391 CAUS us D-OFF C D-OFF The shown protection device isarrow_forwardFor Type B chopper, Find the expersstion for maximum and minimum current. I currentarrow_forwardIn the following diagram: 0 120 02 o 910 O GND O 021 AND O CEC O CES C CEO O 25 O 04N? $24.0 O EZ GND O 0 95. RED O O EX O AD'S AD-S (NDC 92.0 0.39 ET O 10 5.0 (330 (590. 31250 Oniso Onost AL-EC 22. C £200 25+ C END C OF OSCL YES O EAED :::: The resistor on row #44 is a 1.3KQ resistor that is controlling the color blue on the RGB LED. O True Falsearrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Power System Analysis and Design (MindTap Course ...Electrical EngineeringISBN:9781305632134Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. SarmaPublisher:Cengage Learning
Power System Analysis and Design (MindTap Course ...
Electrical Engineering
ISBN:9781305632134
Author:J. Duncan Glover, Thomas Overbye, Mulukutla S. Sarma
Publisher:Cengage Learning