Computer Science Queuing Model

Solution

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),
It will show all calculations and formulas Automatically
Question:
14-11
The Rockwell Electronics Corporation retains a service crew to repair machine breakdowns that occur on an average of 𝜆=3 per day (approximately Poisson in nature), the crew can service an average of µ = 8 machines per day, with a repair time distribution that resembles the exponential distribution.
(a) What is the utilization rate of this service system?
(b) What is the average downtime for a machine that is broken?
(c) How many machines are waiting to be serviced at any given time?
(d) What is the probability that more than one machine is in the system? Probability that more than
two are broken and waiting to be repaired or being serviced? More than three? More than four?
Arrival rate (λ) 3 Per day
Service rate (μ) 8 Per day
(a) What is the utilization rate of this service system?
Solution: computation of the following
Utilization rate(U)=λ/μ
server utilization (U) 37.50%
(b) What is the average downtime for a machine that is broken?
Solution: computation of the following
The average down time is the time that the machine waits to be serviced plus the time taken to repair the machine.
The average down time is given by W
W=1/1(μ-λ)
W 0.2 Day
assuming 8 hrs/day 1.6 Hours
(c) How many machines are waiting to be serviced at any given time?
Solution: computation of the following
Lq=λ^2/μ(μ-λ)
Lq 0.225 Machines
(d) What is the probability that more than one machine is in the system? Probability that more than two are broken and waiting to be repaired or being serviced? More than three? More than four?
Solution: computation of the following
Pn>k=(λ/μ)^(k+1)
Pn>1 0.141
Pn>2 0.053
Pn>3 0.020
Pn>4 0.007

Solution 2

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),
It will show all calculations and formulas Automatically
Question:
From historical data, Harry’s car wash estimates that dirty cars arrive at the rate of 10 per hour all day Saturday. With a crew working the wash line, Harry figures that cars can be cleaned at the rate of one every five minutes. One car at a time is cleaned in this example of single-server waiting line. Assuming Poisson arrivals and exponential service times, find the
A) average number of cars in line
B) average time a car waits before it is washed
C) average time a car spends in the service system
D) utilization rate of the car wash
E) probability that no cars are in the system
Arrival rate 10 cars Per hour
Service rate One car at every 5 minutes
Service rate 12 cars per hour
Number of servers (s) 1
Entering above values in the Excelmodules Queuing models—->M/M/s, we get following results:
A) average number of cars in line
Avg no of cars in line(Lq) 4.1666666667
B) average time a car waits before it is washed
Avg waiting time in queue(Wq) 0.4166666667 hours
Avg waiting time in queue(Wq) 25 Mins
C) average time a car spends in the service system
Avg time in service system(W) 0.5 hours
Avg time in service system(W) 30 Mins
D) utilization rate of the car wash
Average utilization of service system 0.8333333333 83.33 Percent
E) probability that no cars are in the system
Probability of no car in the system(P(0)) 0.1666666667

Solution_Excel modules

Harry’s car wash
Queuing Model M/M/s (Exponential Service Times)
Input Data Operating Characteristics
Arrival rate (l) 10 Average server utilization (r) 0.8333
Service rate (m) 12 Average number of customers in the queue (Lq) 4.1667
Number of servers (s) 1 Average number of customers in the system (L) 5.0000
Average waiting time in the queue (Wq) 0.4167
Average time in the system (W) 0.5000
Probability (% of time) system is empty (P0) 0.1667
0
Probabilities
Number of Units Probability Cumulative Probability
0 0.1667 0.1667
1 0.1389 0.3056
2 0.1157 0.4213
3 0.0965 0.5177
4 0.0804 0.5981
5 0.0670 0.6651
6 0.0558 0.7209
7 0.0465 0.7674
8 0.0388 0.8062
9 0.0323 0.8385
10 0.0269 0.8654
11 0.0224 0.8878
12 0.0187 0.9065
13 0.0156 0.9221
14 0.0130 0.9351
15 0.0108 0.9459
16 0.0090 0.9549
17 0.0075 0.9624
18 0.0063 0.9687
19 0.0052 0.9739
20 0.0043 0.9783
Computations
n or s (lam/mu)^n/n! Cumsum(n-1) term2 P0(s) Rho(s) Lq(s) L(s) Wq(s) W(S)
0 1
1 0.8333333333 1 5 0.1666666667 0.8333333333 4.1666666667 5 0.4166666667 0.5
2 0.3472222222 1.8333333333 0.5952380952 0.4117647059 0.4166666667 0.175070028 1.0084033613 0.0175070028 0.1008403361
3 0.0964506173 2.1805555556 0.1335470085 0.432132964 0.2777777778 0.0221961787 0.855529512 0.0022196179 0.0855529512
4 0.0200938786 2.2770061728 0.0253817414 0.4343316753 0.2083333333 0.0029010774 0.8362344108 0.0002901077 0.0836234411
5 0.0033489798 2.2971000514 0.0040187757 0.434571213 0.1666666667 0.0003492888 0.8336826222 0.0000349289 0.0833682622
6 0.0004651361 2.3004490312 0.000540158 0.4345956968 0.1388888889 0.000037863 0.8333711963 0.0000037863 0.0833371196
7 0.0000553733 2.3009141673 0.0000628562 0.4345979946 0.119047619 0.0000036915 0.8333370248 0.0000003692 0.0833337025
8 0.0000057681 2.3009695406 0.0000064388 0.4345981918 0.1041666667 0.0000003254 0.8333336587 0.0000000325 0.0833333659
9 0.0000005341 2.3009753087 0.0000005886 0.4345982073 0.0925925926 0.0000000261 0.8333333594 0.0000000026 0.0833333359
10 0.0000000445 2.3009758428 0.0000000486 0.4345982084 0.0833333333 0.0000000019 0.8333333353 0.0000000002 0.0833333335
11 0.0000000034 2.3009758873 0.0000000036 0.4345982085 0.0757575758 0.0000000001 0.8333333335 0 0.0833333333
12 0.0000000002 2.3009758906 0.0000000003 0.4345982085 0.0694444444 0 0.8333333333 0 0.0833333333
13 0 2.3009758909 0 0.4345982085 0.0641025641 0 0.8333333333 0 0.0833333333
14 0 2.3009758909 0 0.4345982085 0.0595238095 0 0.8333333333 0 0.0833333333
15 0 2.3009758909 0 0.4345982085 0.0555555556 0 0.8333333333 1.34352048387924E-16 0.0833333333
16 0 2.3009758909 0 0.4345982085 0.0520833333 6.51218686419213E-17 0.8333333333 6.51218686419213E-18 0.0833333333
17 1.26721499130873E-16 2.3009758909 1.33253535168546E-16 0.4345982085 0.0490196078 2.98514163203532E-18 0.8333333333 2.98514163203532E-19 0.0833333333
18 5.86673607087373E-18 2.3009758909 6.15152908402294E-18 0.4345982085 0.0462962963 1.29778811625998E-19 0.8333333333 1.29778811625998E-20 0.0833333333
19 2.57312985564637E-19 2.3009758909 2.69116333526318E-19 0.4345982085 0.0438596491 5.36502185461152E-21 0.8333333333 5.36502185461152E-22 0.0833333333
20 1.07213743985266E-20 2.3009758909 1.1187521111506E-20 0.4345982085 0.0416666667 2.11394636204157E-22 0.8333333333 2.11394636204157E-23 0.0833333333
21 4.25451365020895E-22 2.3009758909 4.43031999939114E-22 0.4345982085 0.0396825397 7.95623609441516E-24 0.8333333333 7.95623609441516E-25 0.0833333333
22 1.61155820083672E-23 2.3009758909 1.67500537409801E-23 0.4345982085 0.0378787879 2.86596194812096E-25 0.8333333333 2.86596194812096E-26 0.0833333333
23 5.83897898853885E-25 2.3009758909 6.05848947682979E-25 0.4345982085 0.0362318841 9.89852884544816E-27 0.8333333333 9.89852884544816E-28 0.0833333333
24 2.02742325990932E-26 2.3009758909 2.10035215415067E-26 0.4345982085 0.0347222222 3.28348663103548E-28 0.8333333333 3.28348663103548E-29 0.0833333333
25 6.75807753303108E-28 2.3009758909 6.9911146893425E-28 0.4345982085 0.0333333333 1.04769859291578E-29 0.8333333333 1.04769859291578E-30 0.0833333333
26 2.16605049135612E-29 2.3009758909 2.23777401755996E-29 0.4345982085 0.0320512821 3.22030655322929E-31 0.8333333333 3.22030655322929E-32 0.0833333333
27 6.68534102270406E-31 2.3009758909 6.89824997247171E-31 0.4345982085 0.0308641975 9.54766585945925E-33 0.8333333333 9.54766585945925E-34 0.0833333333
28 1.98968482818573E-32 2.3009758909 2.05071810512395E-32 0.4345982085 0.0297619048 2.73386016760705E-34 0.8333333333 2.73386016760705E-35 0.0833333333
29 5.71748513846475E-34 2.3009758909 5.88664150350809E-34 0.4345982085 0.0287356322 7.56900547795275E-36 0.8333333333 7.56900547795275E-37 0.0833333333
30 1.58819031624021E-35 2.3009758909 1.6335671824185E-35 0.4345982085 0.0277777778 2.02841534558582E-37 0.8333333333 2.02841534558582E-38 0.0833333333
1. Both l and m must be RATES, and use the same time unit. For example, given a service time such as 10 minutes per customer, convert it to a service rate such as 6 per hour. 2. The total service rate (rate x servers) must be greater than the arrival rate.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Excel 2019 In Practice – Ch 2 Independent Project 2-4

Commissions

Central Sierra Insurance Commission Sales and Bonuses
ID Last Name First Name Branch Commissions Bonus Rate Total Earnings
101 Lingle Bob Cameron Park $15,000
102 McCartney Lanita Folsom $12,000
103 Santos Eleesha Cameron Park $5,500
104 Baxter Roy Granite Bay $4,500
105 Alaro Jennifer Folsom $3,000
115 Chan Tami Cameron Park $3,000
117 Althouse Charlene Granite Bay $4,700
119 Taylor Juan Granite Bay $4,000
120 Reza Wayne Cameron Park $4,000
125 Nevens Cheryl Cameron Park $12,000
Branch Totals
Cameron Park
Folsom
Granite Bay
Total

Family Day

Central Sierra Insurance
Family Day Community Fundraiser
ID Last Name First Name Branch Source Goal Amount Goal Reached?
101 Lingle Bob Cameron Park Raffle tickets $750
102 McCartney Lanita Folsom Walk/run pledge $225
103 Santos Eleesha Cameron Park Cash donation $725
104 Baxter Roy Granite Bay Candy sales $450
105 Alaro Jennifer Folsom Pedometer sales $750
115 Chan Tami Cameron Park Raffle tickets $275
117 Althouse Charlene Granite Bay Walk/run pledge $275
119 Taylor Juan Granite Bay Walk/run pledge $325
120 Reza Wayne Cameron Park Cash donation $325
125 Nevens Cheryl Cameron Park Candy sales $215
102 McCartney Lanita Folsom Candy sales $350
103 Santos Eleesha Cameron Park Raffle tickets $825
117 Althouse Charlene Granite Bay Raffle tickets $900
104 Baxter Roy Granite Bay Pedometer sales $825
105 Alaro Jennifer Folsom Cash donation $1,000

Tables

Commission $3,000 $6,000 $9,000 $12,000 $15,000
Bonus 1.50% 1.75% 1.90% 2.25% 2.50%
Source Goal
Candy sales $300
Cash donation $500
Pedometer sales $500
Raffle tickets $500
Walk/run pledge $250
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

C Programming

C programming!!!!! Expert only
Compound interest.

 

(a) Write a function to compute and return the amount of money, A, that you will have in n years if you invest P dollars now at annual interest rate i. Take n, i, and P as parameters. The formula is

 

A = P(1 + i)n

 

(b) Write a function to compute and return the amount of money, P, that you would need to invest now at annual interest rate i in order to have A dollars in n years. Take n, i, and A as parameters. The formula is:

P =A / (1 + i)n

 

(c) Write a function that will read and validate the inputs for this program. Using call by value/address, return an enumerated constant for the choice of formulas, a number of years, an interest rate, and an amount of money, in dollars. All three numbers must be greater than 0.0.

 

(d) Write a main program that will call the input routine to gather the data. Then, depending on the user’s choice, it should call the appropriate calculation function and print the results of thecalculation.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

DIGITAL FORENSICS

TASK

Note: A Study Planner tool has been provided with this subject to support the assessment process. This tool provides information about the submission flexibility of assessment tasks, and a way to organise adjustments to submission dates. A link to the Study Planner can be found on the Interact2 site.

Task 1: Reflection on Hands-on Projects (5 marks)

Complete the following hands-on projects from your textbook:

1. Hands-on Project 1-1

2. Hands-on Project 1-2

3. Hands-on Project 1-4

4. Hands-on Project 1-5

5. Hands-on Project 1-6

Deliverable: Write a 500-1000 words (up to two A4 pages) report on lessons learned from these projects. Comment on each project individually within the two-page limit. You can write one lesson learned from each of the projects.

Task 2: Case Project (5 marks)
Complete the Hands-on Project 5-2 from your textbook (Nelson, Phillips, & Steuart, 6th edition, 2019, p. 260-261). In this project you will explore the MFT and learn how to locate time and date values in the metadata of a file you create during this project.
Deliverable: Write a 500-1000 words paper after completing this project and report what metadata you have discovered from the file you analysed using WinHex editor. Provide screen shots of the steps completed in the project showing the results of date and time values you have recorded. Briefly describe the main steps that you think are necessary and important to locate date and time values while analysing the file.

Task 3: Research Project (5 marks)

You have been assigned a digital forensics case to investigate involving a potential monetary fraud in an organisation. The CTO of the organisation has given you access to the workstation and other necessary hardware, e.g. USB, of one of his employees who she thinks is potentially involved in this fraud. Your job as a digital forensics examiner is to conduct this investigation. You are required to create a (investigation) plan and describe the standard practice procedure that is used in such investigations. Your plan must include the procedures for collecting the digital data, securing the evidence that you may collect and then describing the method to validate the collected data, e.g. calculating hash values and specifying the hash algorithm that you intend to use, e.g. SHA-3, MD5 etc. You can make some reasonable assumptions if required when describing your plan / procedures.

Deliverable: Write a 500-1000 word report that outlines the investigation plan, procedures to secure the digital evidence, and data validation methods.

Note: Combine deliverable’s of all three tasks mentioned above in a single document (only MS Word (preferable) or pdf, please note other formats e.g. *.zip, *.rar etc are NOT allowed) and then submit that one / single document through Turnitin

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Python Programming Assignments

ITM205

Module 2 – Case

Input, Output, and Built-in and Programmer-Defined Functions

Case Assignment

Study Halterman, R. “Learning to Program with Python”, chapter 7, and complete homework assignment: question 1-10 on page 156 under 7.8 exercises

Create a Word file named as “ITM205-Case 2-Exercises-YourFirstNameLastName”containing a copy of each of the IDLE source codes and running results with clear exercise numbers marked on the page.

You can use the Snipping tools or screen print (ctrl + Print Screen) to show the Pythons editor’s (IDLE) code and results and demonstrate that your program executed correctly.

Write a summary document in Microsoft Word format named as “ITM205-Case2-Summary-YourFirstNameLastName” to show what you have accomplished through the exercises.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Subnetting Worksheet

ITT-116 Subnetting Worksheet

Use the following tables as references for the remainder of the document.

IP Address Classes
Class A 1-127 Leading bit pattern 0 Network.Host.Host.Host
Class B 128-191 Leading bit pattern 10 Network.Network.Host.Host
Class C 224-239 Leading bit pattern 110 Network.Network.Network.Host
Class D 224-230 Reserved for multicast
Class E 240-255 Reserved for experimental, used for research.

 

Private Addresses
Class A 10.0.0.0 – 10.255.255.255
Class B 172.16.0.0 – 172.31.255.255
Class C 192.168.0.0 – 192.168.255.255
APIPA 169.254.0.1 – 169.254.255.254

 

 

 

Binary to Decimal Conversion

128 64 32 16 8 4 2 1 Answers
0 0 0 1 1 0 1 1  
0 0 1 1 1 0 1 1  
1 1 1 1 0 0 0 0  
0 0 1 1 0 0 0 1  
1 0 0 0 1 0 0 0  
1 0 1 0 1 0 1 0  
0 1 1 0 1 1 0 1  
1 0 0 1 1 0 0 1  
1 1 0 1 0 1 1 0  

 

Decimal to Binary Conversion

128 64 32 16 8 4 2 1 Problem
                200
                255
                107
                224
                192
                98
                242
                224
                172
                100

 

Address Classes

Address Class
148.17.9.1  
220.200.23.1  
177.100.15.4  
249.241.80.78  
198.155.72.56  
10.0.0.1  
192.168.123.42  
123.231.132.9  
42.42.42.42  
242.81.64.3  

 

 

 

Network Identification

Highlight the Network Portion:

117. 89. 56. 90
33. 0. 0. 2
10. 252 1. 1
150. 15. 16. 3
192. 168. 123. 1
199. 155. 66. 56
242. 200. 23. 1
158. 200. 45. 62
218. 155. 230. 41
100. 25. 1. 1

 

Highlight the Host Portion

117. 89. 56. 90
33. 0. 0. 2
10. 252 1. 1
150. 15. 16. 3
192. 168. 123. 1
199. 155. 66. 56
242. 200. 23. 1
158. 200. 45. 62
218. 155. 230. 41
100. 25. 1. 1

 

 

Network Addressing

Write the network addresses for the provided IP address/subnet mask.

10.10.48.80 255.255.255.0  
10.10.10.10 255.0.0.0  
27.125.200.151 255.0.0.0  
199.203.32.91 255.255.255.0  
186.31.32.110 255.255.0.0  
192.168.24.19 255.255.0.0  
15.30.20.20 255.255.255.0  
27.0.2.1 255.0.0.0  
164.42.3.4 255.255.255.0  
25.25.142.8 255.0.0.0  

 

 

 

 

Host Addresses

Using the IP address and subnet mask shown, write the host address

10.10.48.80 255.255.255.0  
10.10.10.10 255.0.0.0  
27.125.200.151 255.0.0.0  
199.203.32.91 255.255.255.0  
186.31.32.110 255.255.0.0  
192.168.24.19 255.255.0.0  
15.30.20.20 255.255.255.0  
27.0.2.1 255.0.0.0  
164.42.3.4 255.255.255.0  
25.25.142.8 255.0.0.0  

 

 

 

 

 

 

 

 

 

 

 

 

 

Default Subnet Mask

Write the correct default subnet mask for each

10.10.48.80 255.255.255.0  
10.10.10.10 255.0.0.0  
27.125.200.151 255.0.0.0  
199.203.32.91 255.255.255.0  
186.31.32.110 255.255.0.0  
192.168.24.19 255.255.0.0  
15.30.20.20 255.255.255.0  
27.0.2.1 255.0.0.0  
164.42.3.4 255.255.255.0  
25.25.142.8 255.0.0.0  

 

Custom Subnet Masks

Fill in the blanks

Required Subnets 14
Required Hosts 14
Network Address 192.10.10.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 10th Subnet Range?  
What is the subnet number for the 2nd Subnet?  
What is the broadcast address for the 12th Subnet?  
What are the usable addresses for the 10th Subnet?  

 

Required Subnets 1000
Required Hosts 60
Network Address 156.100.0.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 10th Subnet Range?  
What is the subnet number for the 2nd Subnet?  
What is the broadcast address for the 12th Subnet?  
What are the usable addresses for the 100th Subnet?  

 

 

Required Subnets 6
Required Hosts 28
Network Address 182.86.7.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 3rd Subnet Range?  
What is the subnet number for the 2nd Subnet?  
What is the broadcast address for the 1st Subnet?  
What are the usable addresses for the 6th Subnet?  

 

 

 

 

 

 

 

 

Required Subnets 2000
Required Hosts 15
Network Address 187.112.0.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 100th Subnet Range?  
What is the subnet number for the 200th Subnet?  
What is the broadcast address for the 42nd Subnet?  
What are the usable addresses for the 10th Subnet?  

 

 

Required Subnets 412
Required Hosts 1000
Network Address 128.47.0.0
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What is the 10th Subnet Range?  
What is the subnet number for the 42nd Subnet?  
What is the broadcast address for the 300th Subnet?  
What are the usable addresses for the 12th Subnet?  

 

 

 

 

 

 

Create the subnetting table for each subnet required for your corporate network.

Required Subnets  
Required Hosts  
Network Address  
Address Class  
Default Subnet Mask  
Custom Subnet Mask  
Total Number of Subnets  
Total Number of Host Addresses  
Number of Usable Addresses  
Number of Bits Borrowed  
What are the usable addresses for the 1st Subnet?  
What are the usable addresses for the 2nd Subnet?  
What are the usable addresses for the 3rd Subnet?  
What are the usable addresses for the 4th Subnet?  
What are the usable addresses for the 5th Subnet?  
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Excel Assignment

Documentation

Shelly Cashman Excel 2019 | Module 5: SAM Project 1a
Media Hub
CONSOLIDATE WORKBOOK DATA
Author: Brittany Thomas
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

United States

Media Hub Audio Books Date:
United States Price per book: $ 8.95
Downloads: January – April Download Projections
Book Type January February March April Total May
Adventure 2,193 2,282 2,130 2,215 8,820 Increase downloads to 14,000 in December
Literary 989 1,036 798 803 3,626 11,432 14,000
Mystery 2,405 2,788 2,239 3,011 10,443 Increase downloads by 3% per month
Romance 2,397 2,655 3,244 2,769 11,065 11,432
Science fantasy 1,873 1,869 1,904 1,874 7,520
Self-help 1,027 1,095 1,124 1,006 4,252
Total 10,884 11,725 11,439 11,678 45,726
Sales: January – April
Book Type January February March April Total
Adventure 19,627.35 20,423.90 19,063.50 19,824.25 78,939.00
Literary 8,851.55 9,272.20 7,142.10 7,186.85 32,452.70
Mystery 21,524.75 24,952.60 20,039.05 26,948.45 93,464.85
Romance 21,453.15 23,762.25 29,033.80 24,782.55 99,031.75
Science fiction 16,763.35 16,727.55 17,040.80 16,772.30 67,304.00
Self-help 9,191.65 9,800.25 10,059.80 9,003.70 38,055.40
Total $ 97,411.80 $ 104,938.75 $ 102,379.05 $ 104,518.10 $ 409,247.70

Canada

Media Hub Audio Books Date:
Canada Price per book: $ 9.95
Downloads: January – April Download Projections
Book Type January February March April Total May
Adventure 968 1,082 1,120 1,015 4,185 Increase downloads to 10,000 in December
Literary 689 836 708 640 2,873 5,972 10,000
Mystery 1,205 1,288 1,339 1,411 5,243 Increase downloads by 3% per month
Romance 1,097 1,055 1,144 1,469 4,765 5,972
Science fantasy 773 879 904 1,074 3,630
Self-help 707 795 824 866 3,192
Total 5,439 5,935 6,039 6,475 23,888
Sales: January – April
Book Type January February March April Total
Adventure 9,631.60 10,765.90 11,144.00 10,099.25 41,640.75
Literary 6,855.55 8,318.20 7,044.60 6,368.00 28,586.35
Mystery 11,989.75 12,815.60 13,323.05 14,039.45 52,167.85
Romance 10,915.15 10,497.25 11,382.80 14,616.55 47,411.75
Science fiction 7,691.35 8,746.05 8,994.80 10,686.30 36,118.50
Self-help 7,034.65 7,910.25 8,198.80 8,616.70 31,760.40
Total $ 54,118.05 $ 59,053.25 $ 60,088.05 $ 64,426.25 $ 237,685.60

Australia

Media Hub Audio Books Date:
Australia Price per book: $ 10.95
Downloads: January – April Download Projections
Book Type January February March April Total May
Adventure 652 705 759 812 2,928 Increase downloads to 5500 in December
Literary 189 227 265 303 984 3,742 5,500
Mystery 805 928 1,052 1,175 3,960 Increase downloads by 3% per month
Romance 497 610 652 736 2,495 3,742
Science fantasy 712 799 886 973 3,370
Self-help 227 281 335 389 1,232
Total 3,082 3,551 3,948 4,388 14,969
Sales: January – April
Book Type January February March April Total
Adventure 7,139.40 7,723.40 8,307.40 8,891.40 32,061.60
Literary 2,069.55 2,485.65 2,901.75 3,317.85 10,774.80
Mystery 8,814.75 10,165.25 11,515.75 12,866.25 43,362.00
Romance 5,442.15 6,679.50 7,139.40 8,059.20 27,320.25
Science fiction 7,796.40 8,749.05 9,701.70 10,654.35 36,901.50
Self-help 2,485.65 3,076.95 3,668.25 4,259.55 13,490.40
Total $ 33,747.90 $ 38,879.80 $ 43,234.25 $ 48,048.60 $ 163,910.55

All Locations

Media Hub Audio Books
All Locations
Downloads: January – April
Book Type January February March April Total
Adventure – 0
Literary – 0
Mystery – 0
Romance – 0
Science fantasy – 0
Self-help – 0
Total – 0 – 0 – 0 – 0 – 0
Sales: January – April
Book Type January February March April Total
Adventure $ – 0
Literary $ – 0
Mystery $ – 0
Romance $ – 0
Science fiction $ – 0
Self-help $ – 0
Total $ – 0 $ – 0 $ – 0 $ – 0 $ – 0
Total sales last year (Jan-Apr)
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Simple Excel Homework

EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.3

 

Project Description: You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston. You will format a list of memorials in DC, add Sparklines to compare the number of visitors over a 15-year period, and create a bar chart to illustrate annual visitors at each memorial. In addition, you will create a table of sightseeing locations, sort and filter the data, apply conditional formatting, and add a total row to display average time needed to spend at each memorial. Finally, you will complete a worksheet by adding formulas to compare estimated major expenses for each city.

 

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 0.000 2 On the DC worksheet, select the range A4:G4, wrap the text, apply Center alignment, and apply Blue, Accent 5, Lighter 60% fill color. 6.000 3 On the DC worksheet, merge and center the title in the range A1:G1. Apply Accent5 cell style and bold to the title. 6.000 4 On the DC worksheet, change the width of column A to 34. 3.000 5 On the DC worksheet, select the range C5:F10 and insert Line Sparklines in the range G5:G10. 4.000 6 On the DC worksheet, select the range G5:G10, display the high point sparkline marker, and change the color of the high point markers to Dark Blue. 4.000 7 On the DC worksheet, select the range G5:G10, apply Same for All Sparklines for both the vertical axis minimum and maximum values. 2.000 8 On the DC worksheet, select the ranges A4:A10 and C4:F10 and create a clustered bar chart. Apply the Monochromatic color that is a blue gradient, light to dark. Apply the gradient fill to the plot area. Do not change the default gradient options. 5.000 9 Position the top-left corner of the chart in cell A13. Change the chart height to 6 inches and the chart width to 7 inches. 6.000 10 Change the chart title to Annual Visitors. Apply Blue, Accent 5, Darker 25% font color to the chart title and category axis labels. Change the value axis display units to Millions. 5.000 11 Apply data labels to the 2015 data series. Apply Number format with 1 decimal place to the data labels. 4.000 12 Click the Places sheet tab, convert the data to a table, and apply Table Style Medium 6. 5.000 13 On the Places worksheet, sort the data by City in alphabetical order and then within City, sort by Sightseeing Locations in alphabetical order. 4.000 14 On the Places worksheet, add a total row to display the average of the Time Needed column. Apply Number format with zero decimal places to the total. 4.000 15 On the Places worksheet, select the values in the Time Needed column and apply conditional formatting to highlight cells containing values greater than 60 with Green Fill with Dark Green Text. 4.000 16 On the Places worksheet, apply a filter to display only fees that are less than or equal to $10. 4.000 17 On the Cities worksheet, click cell F4 and enter a formula that will subtract the Departure Date (B1) from the Return Date (B2) and then multiply the result by the Rental Car per Day value (F3). 5.000 18 On the Cities worksheet, click cell E13. Depending on the city, you will either take a shuttle to/from the airport or rent a car. Insert an IF function that compares to see if Yes or No is located in the Rental Car? Column for a city. If the city contains No, display the value in cell F2. If the city contains Yes, display the value in the Rental Car Total (F4). Copy the function from cell E13 and use the Paste Formulas option to copy the function to the range E14:E18 without removing the border in cell E18. 7.000 19 On the Cities worksheet, click cell F13. The lodging is based on a multiplier by City Type. Some cities are more expensive than others. Insert a VLOOKUP function that looks up the City Type (B13), compares it to the City/COL range (A7:B10), and returns the COL percentage. Then multiply the result of the lookup function by the Total Base Lodging (B5) to get the estimated lodging for the first city. Copy the function from cell F13 and use the Paste Formulas option to copy the function to the range F14:F18 without removing the border in cell F18. 7.000 20 On the Cities worksheet, click cell H13 and enter the function that calculates the total costs for the first city. Copy the function in cell H13 and use the Paste Formulas option to copy the function to the range H14:H18 without removing the border in cell H18. 3.000 21 On the Cities worksheet, select the range E14:H18 and apply Comma Style with zero decimal places. Select the range E13:H13 and apply Accounting Number format with zero decimal places. 3.000 22 On the Cities worksheet, in cell I2, enter a function that will calculate the average total cost per city. In cell I3, enter a function that will identify the lowest total cost. In cell I4 enter a function that will return the highest total cost. 6.000 23 On the Cities worksheet, select Landscape orientation, set a 1-inch top margin, and center the worksheet data horizontally on the page. 3.000 24 Ensure that the worksheets are correctly named and placed in the following order in the workbook: DC, Places, Cities. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0.000 Total Points 100.000

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Word SAM Capstone Project 1

Shelly Cashman Word 2016 | Modules 1–3: SAM Capstone Project 1a

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png Shelly Cashman Word 2016 | Modules 1–3: SAM Capstone Project 1a

Used Book Sale

completing a flyer

 

GETTING STARTED

Open the file SC_WD16_CS1-3a_FirstLastName_1.docx, available for download from the SAM website.

Save the file as SC_WD16_CS1-3a_FirstLastName_2.docx by changing the “1” to a “2”.

· If you do not see the .docx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

To complete this Project, you will also need to download and save the following support files from the SAM website:

· Support_SC_WD16_CS1-3a_Book_Tree.png

· Support_SC_WD16_CS1-3a_Bookshelves.png

With the file SC_WD16_CS1-3a_FirstLastName_2.docx still open, ensure that your first and last name is displayed in the footer.

· If the footer does not display your name, delete the file and download a new copy from the SAM website.

 

PROJECT STEPS

As the publicity manager for your local library’s used book sale, you need to format a one-page flyer announcing the event. Start by changing the document margins to Normal.

To make the text easier to read, modify the Normal style by changing the font size to 12 pt.

In the first paragraph, type the word Used so that the heading reads “Giant Used Book Sale!”

Format the heading “Giant Used Book Sale!” as follows:

a. Center the heading.

b. Increase the font size to 36 pt.

c. Change the font to Times New Roman.

d. Use the Text Effects and Typography button to apply the Fill–Gray-50%, Accent 1, Shadow text effect. (Hint: Depending on your version of Office, the text effect may display as Fill: Gray, Accent color 1; Shadow.)

 

Apply the default Bottom Border paragraph border to the heading “Giant Used Book Sale!”

Insert and format a picture as follows:

e. Move the insertion point to the left of the “G” in the heading “Giant Used Book Sale!”, and then insert the picture Support_SC_WD16_CS1-3a_Book_Tree.png, available for download from the SAM website.

f. Resize the picture so it has a height of 0.75″. The width should automatically adjust to approximately 0.75″.

g. Apply Square text wrapping.

h. Recolor the picture using the Gray-80%, Text color 2 Dark option in the Color gallery. (Hint: Depending on your version of Office, the text effect may display as Dark Gray, Text color 2 Dark.)

i. Add a Brown, Accent 6 border to the picture.

Find the two instances of the word “VHS” and replace them with DVD. (Hint: Do not type the period.)

Format the first body paragraph (which begins “It’s time for the annual…”) as follows:

j. Change the Before paragraph spacing to 12 pt.

k. Change the After paragraph spacing to 18 pt.

In the first sentence of the body paragraph, format the text “New Clintonville Public Library” with the Intense Emphasis style to make the library’s name stand out from the surrounding text.

After the period at the end of the first body paragraph, insert a footnote with the following sentence:

Show your library card for a free donut.

Format the paragraph “Thursday, May 19 through Monday, May 23” as follows:

l. Center the paragraph.

m. Change the font size to 16 pt.

n. Apply White, Background 1, Darker 50% paragraph shading (1st column, 6th row of the Shading palette).

o. Apply the White, Background 1 font color (1st column, 1st row of the Theme Colors palette).

Format the text beginning “Mass-market paperbacks” and ending “Romances” as a bulleted list.

 

Insert and format a second picture as follows:

p. Move the insertion point to the beginning of the first bulleted list item, to the left of the “M” in “Mass-market paperbacks”, and then insert the picture Support_SC_WD16_CS1-3a_Bookshelves.png, available for download from the SAM website.

q. Resize the picture so it has a height of 2.9″. The width will automatically adjust to 3.49″.

r. Apply Square text wrapping.

s. Apply the Simple Frame, White picture style.

Modify the table below the “WE’RE STILL ACCEPTING DONATIONS!” heading as follows:

t. Insert a new row below the “Books” row.

u. In the new row, enter the text shown in Table 1 below.

 

Table 1: Text for New Row

 

Format the table below the “WE’RE STILL ACCEPTING DONATIONS!” heading as follows:

v. Apply the Grid Table 4 – Accent 1 table style.

w. Resize the table using AutoFit Contents.

x. Center the table on the page.

In the last blank paragraph in the document, below the paragraph that reads “We especially need children’s picture books this year.”, insert a second table as follows:

y. Insert a table with two columns and four rows.

z. Merge the cells in row 1.

aa. Enter the text shown in Table 2 on the next page.

 

Table 2: Text for New Table

Format the table as follows:

ab. Apply the Grid Table 4 – Accent 1 table style.

ac. Right-align the text in column 2, rows 2–4.

Add a header to the document as follows:

ad. Insert a blank header at the top of the page.

ae. Center the header paragraph.

af. Enter Approved for posting in the library. as the header text. (Hint: Type the period.)

ag. Close Header & Footer Tools.

Finish the flyer by adding a page border as follows:

ah. Select a border style of your choosing. (Hint: To match the Final Figure on the following page, select the Box border from the border Setting list.)

ai. Change the border width to 2 ¼ pt.

aj. Change the border color to Olive Green, Accent 3, Darker 25% (7th column, 5th row of the Theme Colors palette).

Check the Spelling & Grammar in the document to identify and correct any spelling errors. (Hint: You should find and correct at least three spelling errors.)

Your document should look like the Final Figure on the following page. Save your changes, close the document, and then exit Word. Follow the directions on the SAM website to submit your completed project.

Final Figure

© Cienpies Design /Shutterstock.com; © donatas1205/Shutterstock.com

2
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Security

A program manager questions why information from a legacy technology system is still classified. You explain the technology system will be declassified when the program is supported is declassified. This is an example of which type of declassification system?

 

a. Systematic Declassification

b. Scheduled Declassification

c. Automatic Declassification

d. Petitioned Declassification

 

A new junior member of your security team wants to learn about physical security planning and implementation. Which of the following would you identify for her as components of physical security planning and implementation?

 

a. the risk management process

b. facility installation construction

c. physical security planning documents

d. oversight

 

C only

B, C and D only

B and C only

A, B, C, and D

 

You are working with a contractor and are reviewing the document that outlines in detail what be required to complete the contract. You are reviewing the _______________.

 

a. DD form 254: DD contract Security Classification Specification

b. DD form 441: DOD Security Agreement

c. Statement of Work (SOW)

 

As the newly-appointed physical security officer for a government facility you are informed that a register of the combination for all the various secured areas and storage containers that use combination locks are stored in a file cabinet in the executive assistants office. Is this compliant with combination control requirements?

 

a. No, No register combination should be created.

b. No. Combination should be posted on the exterior of their respective containers.

c. Yes. It is imperative that all employee can access the combination

d. No. Only a minimum number of authorized persons should know the combination to a given container

 

The physical security officer requests your assistance in conducting a Risk Management assessment. As part of the process, you note that increased physical security measures should be implemented. This is an example of which step in the Risk management process?

 

a. Assess vulnerabilities

b. Assess Assets

c. Determine countermeasures options

 

The contracting officer’s Representative (COR) sent a draft copy of a Statement of Work for contractor support to be performed on the installation. The project does not require access to classified information. He included a list of possible requirements to be followed by the contractor. Which of the following is required of contractor personnel working on a government installation?

 

a. Submit to a minimal background investigation for installation access.

b. Sign an SF 312 Classified Information Nondisclosure Agreement

c. Submit to a background investigation for access to government information systems.

 

A and C only

A,B, and C

A and B only

A only

 

An engineer at your facility questions the marking on classified diagram. Which of the following markings are required on classified diagrams?

 

a. The agency, officer of origin, and date of the diagram

b. Classification challenge procedures

c. The overall classification of the diagram

 

A, B, and C

B and C only

A and C only

C only

 

The installation commander has tasked you with evaluating the security measure implemented to protect a nuclear weapon storage facility on the installation. You find the facility uses a variety of security measures, including perimeter fencing and signage, continuous and emergency lighting, active barriers and the pedestrian and vehicle points of entry, guards, and manual and automated access control measures. The security measures employed at this facility are an example of ________________.

 

a. Enclaving

b. Operation security

c. Security in depth

d. Point security

 

You are reviewing classification requirements. In order to be classified, information must meet which of the following criteria?

 

a. The information must be owned by, produced by, produced for, or under the strict control of the U.S government.

b. The information must be determined that its unauthorized disclosure could cause damage to national security.

c. Disclosure of the information could cause undue stress to relations with friendly nations.

d. The classification level of the information must be designated.

 

You are conducting a Risk Management assessment. Which of the following activities are are required to support the Risk Management Process?

a. Conduct a cost analysis

b. Conduct a benefits analysis

c. Make Risk Management Decisions

 

A and C only

B and C only

A and B only

A, B, and C

 

As the newly appointed physical security officer for a government facility, you are informed that the keys for all the various secured areas and storage containers that use keyed locks are stored in a locked file cabinet in the security office along with the key and lock control register. Is this compliant with key control requirements?

 

a. Yes, all keys should be stored with the lock and key register.

b. No. All keys should be secured with the lock and key register.

c. Yes, It is imperative that access to keys be restricted to only security personnel.

d. No. Keys should be stored at the same level of protection as required for the material to which they provide access.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!