Monthly Archives: June 2023

Discussion 1

Discussion 2

PROJECT STEPS

1. Takara Hiyashi is on the board of the Green Lake Sports Camp, a recreational summer camp in Syracuse, New York. She is using an Excel workbook to analyze the camp’s financials and asks for your help in correcting errors and solving problems with the data.
Go to the Teams worksheet. Takara asks you to correct the errors in the worksheet. Correct the first error as follows:

a. Use the Trace Precedents arrows to find the source of the #VALUE! error in cell C8.

b. Use the Trace Dependents arrows to determine whether the formula in cell C8 causes other errors in the worksheet.

c. Correct the formula in cell C8, which should add the baseball registration fee per person (cell C4) and the equipment fee (cell C7), and then multiply the result by the minimum number of campers (cell C6).

d. Remove the trace arrows.

2. Correct the Name error in cell C22 as follows:

a. Use any error-checking method to determine the source of the error in cell C22, which should calculate the average revenue per week.

b. Correct the error by editing the formula in cell C22.

3. Correct the divide by zero errors as follows:

a. Evaluate the formula in cell C18 to determine which cell is causing the divide by zero error.

b. Correct the formula in cell C18, which should divide the revenue per session (cell C16) by the minimum number of campers (cell C6).

c. Fill the range D18:G18 with the formula in cell C18. 

4. Takara suspects that the remaining divide by zero errors and the two negative values in the range E16:E18 are related to the zero value in cell E6. She wants to make sure that anyone entering the minimum number of campers enters a number greater than zero.
Add data validation to the range C6:G6 as follows:

a. Set a data validation rule for the range C6:G6 that allows only whole number values greater than 0.

b. Add an Input Message using Number of Campers as the Input Message Title and the following text as the Input message:
Enter the minimum number of campers for this session. 

c. Add an Error Alert using the Stop style, Campers Error as the Error Alert Title, and the following text as the Error message:
The minimum number of campers must be greater than 0. 

5. Identify the invalid data in the worksheet and correct the entry as follows:

a. Circle the invalid data in the worksheet.

b. Type 10 as the minimum number of campers for the lacrosse sessions (cell E6).

c. Verify that this change corrected the remaining divide by zero errors and resulted in positive values in the range E16:E18.

6. Go to the Private Lessons worksheet. This worksheet analyzes financial data for private and semi-private lessons, which the camp runs throughout the day. Takara has already created a scenario named Current Campers that calculates profit based on the current number of campers enrolled for each session. She also wants to calculate profit based on the maximum number of campers.
Add a new scenario to compare the profit with maximum enrollments as follows:

a. Use Max Campers as the scenario name.

b. Use the enrolled campers per day data (range C9:G9) as the changing cells.

c. Enter cell values for the Max Campers scenario as shown in bold in Table 1, which are the same values as in the range C8:G8.

Table 1: Cell Values for the Max Campers Scenario

Cell

Value

Baseball_Campers (cell C9)

10

Basketball_Campers (cell D9)

12

Lacrosse_Campers (cell E9)

10

Soccer_Campers (cell F9)

12

Volleyball_Campers (cell G9)

15

7. Takara also wants to calculate profit based on the minimum number of campers.
Add another new scenario to compare the profit with low session enrollment as follows: 

a. Add a scenario to the worksheet using Min Campers as the scenario name.

b. Use the enrolled campers per day data (range C9:G9) as the changing cells.

c. Enter cell values for the Min Campers scenario as shown in bold in Table 2.

Table 2: Cell Values for the Min Campers Scenario

Cell

Value

Baseball_Campers (cell C9)

8

Basketball_Campers (cell D9)

8

Lacrosse_Campers (cell E9)

7

Soccer_Campers (cell F9)

8

Volleyball_Campers (cell G9)

7

8. Show the Min Campers scenario values in the Private Lessons worksheet.

9. Go to the Revised Fees worksheet. Takara is considering whether to change the coaching fees for the private lessons. She has created three scenarios on the Revised Fees worksheet showing the profit with a $5 or $10 increase or a $5 decrease to the coaching fees.
Compare the average profit per session based on the scenarios as follows:

a. Create a Scenario Summary report using the average profit per session (range C11:G11) as the result cells to show how the average profit changes depending on the coaching fee changes. 

b. Use Revised Fees Scenario Report as the name of the worksheet containing the report.

10. Takara also wants to focus on one or two types of private lessons at a time when comparing the average profit per session. Return to the Revised Fees worksheet and create another type of report as follows:

a. Create a Scenario PivotTable report using the average profit per session (range C11:G11) as the result cells to compare the average profit depending on the fee changes in a PivotTable.

b. Use Revised Fees PivotTable as the name of the worksheet containing the PivotTable.

c. Format cells B4:F6 in the Revised Fees PivotTable worksheet using the Accounting number format with 0 decimal places and $ as the symbol.

11. Go to the Games worksheet. Takara wants to determine the number of games the camp can hold on Fridays and Saturdays to make the highest weekly profit without interfering with practices, which are also scheduled for Fridays and Saturdays and use the same resources.
Use Solver to find this information as follows:

a. Use the total weekly profit (cell H17, named Total_Weekly_Profit) as the objective cell in the Solver model, with the goal of determining the maximum value for that cell.

b. Use the number of Friday and Saturday games for the five sports (range C5:G6) as the changing variable cells.

c. Determine and enter the constraints based on the information provided in Table 3.

d. Use Simplex LP as the solving method to find a global optimal solution.

e. Save the Solver model in cell B27.

f. Solve the model, keeping the Solver solution.

Table 3: Solver Constraints

Constraint

Cell or Range

Each game is scheduled at least once on   Friday and once on Saturday

C5:G6

Each Friday and Saturday game value is   an integer

C5:G6

Each sport is scheduled for a game 1   time per week or more

C7:G7

Each sport is scheduled for a game 3   times per week or less

C7:G7

The total number of Friday games is 10   or less

Total_Friday_Games (H5)

The total number of Saturday games is   15 or less

Total_Saturday_Games (H6)

The total number of games per week is   13

Total_Weekly_Games (H7)

The total number of Friday practices is   2 or less 

Friday_Practices (E21)

The total number of Saturday practices   is 2 or less

Saturday_Practices (E22)

The total number of practices per week   is 5 or less

Total_Practices (E23)

12. Takara wants to document the answer Solver found, including the constraints and a list of the values Solver changed to solve the problem. Produce an Answer report for the Solver model as follows:

a. Solve the model again, this time choosing to produce an Answer report.

b. Use Games Answer Report as the name of the worksheet containing the Answer report.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then 

refer to the attached document for details

1 page 

Search the United States Computer Emergency Readiness Team (US-CERT) website at http://www.us-cert.gov/ for information about buffer overflow attacks. How many programs or operating systems can you identify that are vulnerable to this type of attack? 

Discussion: 2

Project: 1

All details Attached.

Attached Files:

•  Course Project Ph2 VIDEO.mp4 (170.056 MB) 

Summary:Produce an ER Model for the following scenario (presented in Step 1 below) and business need, for the Pythagoras Math Academy.  Reference the attached video (Course Project Ph2 Video.mp4), for a full introduction and demonstration and expectations for this project.Deliverables:

• ER Model for the scenario presented. 
• You have the option to use MS Visio (if you have the software) to produce your ER Model.  
• Alternatively, if you do not have MS Visio, you can use the ERD PLUS (Open source ER Modeling Software) and produce your ER Model. 

***The submission is a Word document with the ER Model diagram copied.  Do not send any type of image.  The submission must be the image copied into a Word document.  Please include a cover sheet with your full name, the class and  the university spelled correctly.  Please include any details necessary to describe the results. 
Required Software:

• MS Visio by Microsoft OR
• ERD PLUS, Open Source Offering. This offering is cloud-based, and you do not need to download any clients. You will need to create an account (username and password), link to this offering follows: https://erdplus.com 

Lab Steps:Step 1: Read and understand the Scenario and Business needs presented below. Define and document the ENTITIES, and RELATIONSHIPS, required to address the business needs. The nouns in the scenario below will give the ENTITIES that you will need. Finally, the verbs will describe the RELATIONSHIPS.Scenario and Business Need The Pythagoras Math Academy is in need to develop a database to keep track and control of his students, teachers, and classes offered. Teachers are able to teach multiple courses. But they are required to be certified on the course they are teaching. For example, only a group of teachers are certified to teach Algebra, and other Geometry. Students can take multiple courses. Courses are taught by teachers with the proper certification and have multiple certs as needed.  Courses are taught in one of the classrooms at one of the School’s several sites.Each classroom is optimized to serve the needs for a course (for example some courses might require computer labs and whiteboards). The school needs to keep track of the math courses delivered in each of the sites.Step 2: For this project, you are required to use MS Visio or ERD PLUS to produce the deliverables.If you are using MS Visio follow the steps below:

• Reference the Course Project Ph2 VIDEO.mp4, for a short demonstration and tutorial of this tool, and project overview/ expectations.
• Open MS Visio
• Click on the Software Database Template in the main window
• Select the Database Model Diagram Template to open a new file.
• Save the File and ensure to have in your file name PROJECT2_LastName_FistInitial.

If you are using ERD PLUS.

• Watch the recorded short tutorial for this tool. Reference the attached video as follows: Course Project Ph2 VIDEO.mp4.
• From the ERP PLUS main interface, select DOCUMENTS –> NEW DIAGRAM (NAME YOUR DIAGRAM) –>ER DIAGRAM –> CREATE
• Reference demonstration video for how to navigate tool, how to create entities, add attributes, relationships, and Cordiality. Demonstration video attached as follows: Course Project Ph2 VIDEO.mp4

Step 3: Define and Database ENTITIES

• Add an entity for each Table you identified in the Scenario and Business Need.
• You will use the MS Visio tool, or the ERD PLUS open source offering to complete this step.

Step 4: ADD the required ENTITY ATTRIBUTES  

• Add the required Attributes for each Entity that you feel would help to define each Entity as needed.
• Select one of the attributes to be PRIMARY KEY (PK)

Step 5: Define RELATIONSHIPS

• Use the Crow’s Feet Notation.
• Reference recorded demonstrations on how to use these notations, for MS Visio and ERD PLUS. Reference attached video as follows: Course Project Ph2 VIDEO.mp4
• Drag and drop (draw) relationships between the entities you defined.
• Connect the ends to the two entities for each relation.
• Defined the Primary Key for the parent entity.

Step 6: Define CARDINALITY RELATIONSHIPSet the cardinality for each of your relationships defined in Step 5.  For MS Visio: select a relationship line in the drawing area that is connecting two entities. In the Database Properties window, select the miscellaneous category. Select the cardinality for the selected relationship.Step 7: Upload your Work 

• Save the File and ensure to have in your file name PROJECT2_LastName_FistInitial. 

***The submission is a Word document with the ER Model diagram copied.  Do not send any type of image.  The submission must be the image copied into a Word document.  Please include a cover sheet with your full name, the class and  the university spelled correctly.  Please include any details necessary to describe the results. Rubric:

• 10 points: ER Model (MS Visio OR ERD PLUS)
• 10 points: Entities: Minimum of Three entities are represented
• 10 points: Attributes: Minimum of Two attributes for each Entity. Most would require more than two attributes, and I am only requiring two per entity.
• 10 points: Relationships: Minimum Three relationships are presented.
• 10 points: Cardinality is defined and specific for each relationship with Crow’s foot notation.

 Find a paper presenting a topic related to cryptography and/or cybersecurity and prepare a brief overview. 

Any topic from here.

• Digital signature
• Biometric data encryption
• Data breach
• Vulnerabilities based on using old cryptographic technology

 Hide Folder InformationInstructions

Find a paper presenting a topic related to cryptography and/or cybersecurity and prepare a brief overview.

• Potential topics could come from Chapters 11-13, but don’t have to
  • Digital signature
  • Biometric data encryption
  • Data breach
  • Vulnerabilities based on using old cryptographic technology

Include the following in your overview.

Paper Title and Citation.

•Authors and Affiliations.

• Paper Overview.

•Key methods, technologies used.

•Major Results.

•What I learned or is interesting these findings.

•What fields of cryptography are related to the paper.

 Select one type of cryptography or encryption and explain it in detail. Include the benefits as well as the limitations of this type of encryption 

You have just received two emails, one from your boss or supervisor and one from a coworker. The two emails address the same situation. A minor problem has occurred that you may be responsible for creating. Your boss/supervisor has asked you for a resolution to the problem. Your coworker, who has been affected by this problem, is angry with you and has written an inflammatory email accusing you of creating this problem on purpose.

1. Using word, write an email as a reply to both of the emails that you have received. You should attempt to resolve the problem as efficiently as possible. Since your email will be received both by a supervisor and a coworker, consider all aspects of your communication including the formality of the language you use, grammar, and all aspects of formal communication. Your goal is to solve the problem and maintain your professionalism at the same time.
2. On the same document, analyze the conflict that has happened. What was the cause of the conflict? How did you attempt to resolve the conflict? What did you need to address in terms of your supervisor’s concerns, and how were these different from your coworker’s concerns? Do you think your supervisor and coworker handled the conflict well in their emails to you? How effective are these emails?

• 6.2 What protocols comprise TLS?
• 6.3 What is the difference between a TLS connection and a TLS session?
• 6.4 List and briefly define the parameters that define a TLS session state.
• 6.5 List and briefly define the parameters that define a TLS session connection.
• 6.6 What services are provided by the TLS Record Protocol?
• 6.7 What steps are involved in the TLS Record Protocol transmission?
• 6.8 What is the purpose of HTTPS?
• 6.9 For what applications is SSH useful?
• 6.10 List and briefly define the SSH protocols.

Complete your answers on a WORD Document