Homework Assignmet

/in /by

These instructions are compatible with both Microsoft Windows and Mac operating systems.

San Diego Sailing keeps data about its fleet of rental and charter boats. One of the sheets is missing a piece of data and another sheet has circular reference errors. You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals.

[Student Learning Outcomes 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7]

File Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-SanDiegoSailing-02.xlsx

Skills Covered in This Project

  • Create and copy formulas.
  • Use formula auditing tools.
  • Set mathematical order of operations.
  • Use relative, mixed, and 3D cell references.
  • Use COUNTIF and SUMIF functions.
  • Build an IF formula.
  • Insert the TODAY function.

NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

  1. Open the SanDiegoSailing-02.xlsx workbook.
  2. If the workbook opens in Protected View, click the Enable Editing button so you can modify it.
  3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  4. Review a formula.
    1. Click the New Prices sheet tab and review the Formula bar.
    2. Click cell D5. The formula begins with 1+D4.
  5. Edit and copy a formula with mixed references.
    1. Edit the formula in cell D5 to show D$4 instead of “D4.” The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105).The formula is =(1+D$4)*Fleet!$H5Figure 2-105 Mixed reference in the edited formula
    2. Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border.
    3. Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19.
    4. Click cell E6. The formula is adjusted to use the percentage value in cell E4 in place of cell D4. Note also that the reference on the Fleet sheet ($H6) is adjusted to show the correct row.
  6. Build a formula with mixed references.
    1. Click cell F5 and type =(1+ to start the formula.
    2. Select cell F4 and make it an absolute reference to the row but not the column.
    3. Type )* for the closing parenthesis and multiplication.
    4. Click cell I5 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2-106).The formula is =(1+F$4)*Fleet!$I5Figure 2-106 Mixed references in the new formula
    5. Copy the formula down column F without formatting to preserve the border.
    6. Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19.
  7. Build an IF function formula.
    1. Click the Fleet sheet tab and select cell G5. Rental boats with a stove in the galley must seat 8 or more people.
    2. Create an IF function in which the logical_test argument determines if there are 8 or more seats.
    3. Use Yes for the value_if_true argument. Use No for the value_if_false argument. (If you type the formula, enclose the text arguments within quotation marks.)
    4. Copy the formula to cells G6:G19 without formatting and then center the data in column G.
  8. Insert the TODAY function in cell B21. Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020).
  9. Create a division formula.
    1. Click the Bookings sheet tab and select cell F5. Calculate average revenue per passenger by dividing the fee by the number of passengers.
    2. Build the division formula.
    3. Copy the formula in cell F5 to cells F6:F19.
  10. Create and copy a COUNTIF function to count bookings by boat manufacturer.
    1. Select cell D27.
    2. Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group.
    3. Use cells $C$5:$C$19 as the Range argument.
    4. Set a Criteria argument that will select all boats in the “Beneteau” group. The criteria is ben*. If you type the formula, include quotation marks.
    5. Copy the formula in cell D27 to cells D28:D30.
    6. Edit the criteria in each copied formula in cells D28:D30 to reflect the boat make.
  11. Create and copy a SUMIF function to calculate total revenue by boat make.
    1. Select cell E27.
    2. Start the SUMIF function with cells $C$5:$C$19 as the Range.
    3. Set the Criteria argument to ben*.
    4. Set the Sum_range argument to cells $E$5:$E$19.
    5. Copy the formula in cell E27 to cells E28:E30.
    6. Edit the criteria in each copied formula in cells E28:E30 as needed.
  12. Complete formatting.
    1. Apply the Currency format to all values that represent money.
    2. Format the labels in cells A1:A2 as 18 point.
    3. Select cells A1:F2 and click the Alignment launcher [Home tab, Alignment group]. Center the labels across the selection.
    4. Merge and center the label in cell C25 over cells C25:E25 and format it at 16 points.
    5. Bold and center the labels in rows 4 and 26.
    6. Select cells A4:F19 and apply All Borders. Do the same for cells C25:E30.
    7. Center the page horizontally.
  13. Save and close the workbook (Figure 2-107).Excel 2-5 completedFigure 2-107 Excel 2-5 completed
  14. Upload and save your project file.
  15. Submit project for grading.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

BRD Document

/in /by
Project Name Version: <x.y>
Business Requirements Document Date:
BRD

 

Project Name

Business Requirements Document

Version <x.y>

 

 

 

Company Logo

 

 

Revision History

Date Version Description Author
Dd/mm/yyyy <0.1> First Draft Name
Dd mm yyyy 0.2 2.2 UML Diagrm updates  
       
  1.0 Client signed off on 23 Jan 2020  
  1.1 7.1 Added Email standatrd templates

5.3 New user story abt Regulatory req ia added

  
  2.0 Approval from client taken on mail  

 

Table of Contents

1. Introduction 4

1.1 References 4

1.2 Business Requirements Index 4

2. Gap Analysis 4

2.1 As-Is Process 4

2.2 To-Be Process 4

2.3 Strategy or project approach to be followed 4

3. Product Overview 4

3.1 Solution Scope 4

3.2 Assumptions and Dependencies 5

4. Requirements (Detailed) 5

5. Non-Functional Requirements 6

Business Requirements Document

Introduction

The purpose of this document is to collect, analyze, and define high-level needs and features of the AP Exception Handling project. It focuses on the capabilities needed by the stakeholders and the target users, and why these needs exist. The details of how the AP Exception Handlingproject fulfills these needs are detailed in the use-case and software requirements specifications.

References

Type Name Source
Input    
Non-artifact resource    
Non-artifact resource    

 

Business Requirements Index

ID Short Description
BR001 User story title
BR002  
BR003  
BR005  
BR006  
BR007  
BR009 Min 9

Gap Analysis

As-Is Process

 

Detail about as-is process and current shortcoming or what is reason to have this project.

As-is process flow

To-Be Process

To be process and complete UML diagram or process flow or process modeling diagram. This is very important

 

Strategy or project approach to be followed

………………………………………..

 

Product Overview

Solution Scope

Scope of Project

Ideally, this will be represented as a set of high-level bullet points that correspond to high level requirements.

Each bullet Requirement here will or should have a corresponding set of detailed Requirements elsewhere within or outside the document.

As the name implies, Out of Scope sub-section explains what NOT will be delivered by this project, and (usually) why. This is important to manage expectations of your stakeholders (assumptions about scope are, as you will be aware, a major source of heartburn during implementation sign-off).

On Agile projects, high level requirements usually correspond to Epics and the big User stories that make up these epics.

For most non-project stakeholders, the Overview and Scope sections provide sufficient information about the project, so it is important to be both concise and precise at the same time.

 

Assumptions and Dependencies

Type Description
Assumption  
Dependency  
Deliverables  
Risks & Constraints  

 

Requirements (Detailed)

ID Requirement      
BR001 Write User Story, details and acceptance criterion
BR002  

Document the requirements that your Business Sponsor or Product Owner need to be delivered by this project/initiative. Requirements can be classified under several headers – the internet provides a variety of responses for the search string ‘types of requirements. What we need is a standard format that you can use to document all requirements.

 

A cookie cutter format for documenting requirements would be:

· Index – can start from 1, 2, 3… for high level requirements and go on to 5.1, 5.2, 5.1.1, 5.1.2 and so on for lower level requirements. You can apply such numbering conventions to Agile user stories

· Title Description – brief description of the high-level requirement.

· Detailed Description – self-explanatory. User stories in the form of ‘As a customer, I can… so that…’ fit here.

· Owner – usually the Business Sponsor or the Product Owner. Can also be stakeholders like IT, Marketing, Legal, Compliance etc. depending on the requirement.

· Priority – High, Medium, Low (or a variation of this)or number 1 to 9. 1 means most imp

 

Non-Functional Requirements

Usually,  Non Functional Requirements  (NFRs) find their own section in a Requirements Document template. If you are familiar with this topic, you’ve heard about Performance, Reliability, Scalability, Maintainability etc.

Why do they have their own sections? This is because NFRs are often stated in measurable terms, and hence need to be stated differently to other requirements.

For example: when a customer logs on to the mobile app, logon should complete and dashboard should load in less than 2 seconds; the system should never go offline, except for scheduled maintenance periods, etc.

 

 

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

Computer Science Queuing Model

/in /by

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

/in /by

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

/in /by

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

/in /by

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

/in /by

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

/in /by

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

/in /by

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

/in /by

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!