Monthly Archives: June 2023

Deliverable 6 – Kingston-Bryce FAQ

Competency

Distinguish project management methodologies and tools.

Scenario

As a Project Manager for Kingston-Bryce Limited, you have been assigned to create a Frequently Asked Questionnaire (FAQ) document on the methodologies used in project management. Now that the acquisition is almost done, the Board of Directors for Kingston-Bryce Limited (KBL) wants to document some of the project methodologies and tools for future projects.

Instructions

You will develop a project management methodologies and tools FAQ document in Microsoft Word or Excel that evaluates:

• various tools used in project management
• methodologies used in project management

An FAQ document typically provides brief and clear information regarding the subject in a question and answer format.Requirements:

1. You will include a total of 8 to 12 FAQs in your document.
2. The FAQ document should give the Board of Directors enough information to understand the various tools and methodologies used in project management.
3. Make sure to use audience-specific language and professional tone throughout the document.
4. Clear organization, APA formatting for the references list, and proper grammar, punctuation, and FAQ formatting are required.

Your FAQ should contain a title and a list of questions and answers. They do not need to be numbered, but you should apply formatting to make the questions stand apart.

  You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly import data from another source.

Start   Excel. Download and open the file named Exp19_Excel_AppCapstone_ComprehensiveAssessment- Manufacturing.xlsx. Grader has automatically added your last name   to the beginning of the filename. 

Group all the worksheets in the   workbook and fill the range A1:F1 from the Insurance worksheet across all   worksheets including the formatting. Ungroup the worksheets after the fill is   complete and ensure the Insurance worksheet is active.

Click cell I5, and enter a   function that determines the number of full-time employees, (FT).

Enter a database function in   cell I6 that determines the average salary of all full-time employees with at   least one dependent. Format the results in Accounting Number Format.

Enter a lookup function in cell   E5 that returns the tax deduction amount for the number of dependents listed   in the cell C5. Use   the table in range H13:I17 to complete the function. The maximum deduction is   $500.00; therefore, employees with more than four dependents will receive no   additional deductions.

Use Auto Fill to copy the   function down, completing column E. Be sure to use the appropriate cell   referencing. Format the data in column E with the Accounting Number Format.

Enter a logical function in cell   F5 that calculates employee FICA withholding. If the employee is full-time   and has at least one dependent, then he or she pays 7% of the annual salary   minus any deductions. All other employees pay 5% of the annual salary minus   any deductions. Copy the function down through column F. Format the data in   column F with Accounting Number Format.

Apply conditional formatting to   the range C5:C34   that highlights any dependents that are greater than 3 with Light Red Fill and Dark Red Text.

Click cell H10, and enter an   AVERAGEIFS function to determine the average salary of full-time employees   with at least one dependent. Format the results in Accounting Number Format.

Use Advanced Filtering to   restrict the data to only display full-time employees with at least one   dependent. Place the results in cell A37. Use the criteria in the range   H24:M25 to complete the function.

Ensure that the Facilities   worksheet is active. Use Goal Seek to reduce the monthly payment in cell B6   to the optimal value of $6000. Complete this task by changing the Loan amount in cell E6.

Create the following three   scenarios using Scenario Manager. The scenarios should change the cells B7, B8,   and E6.
 

Good   
  B7 = .0325
  B8 = 5
  E6 = 275000
 

Most   Likely
  B7 = .057
  B8 = 5
  E6 = 312227.32
 

Bad
  B7 = .0700
  B8 = 3
  E6 = 350000
 

  Create a Scenario Summary Report based on the value in cell B6. Format the   new report appropriately.

Ensure that the Facilities   worksheet is active. Enter a reference to the beginning loan balance in cell   B12 and enter a   reference to the payment amount in cell C12. 

Enter a function in cell D12,   based on the payment and loan details, that calculates the amount of interest   paid on the first payment. Be sure to use the appropriate absolute, relative,   or mixed cell references.

Enter a function in cell E12,   based on the payment and loan details, that calculates the amount of   principal paid on the first payment. Be sure to use the appropriate absolute,   relative, or mixed cell references.

Enter a formula in cell F12 to   calculate the remaining balance after the current payment. The remaining   balance is calculated by subtracting the principal payment from the balance   in column B.

Enter a function in cell G12, based on the payment   and loan details, that calculates the amount of cumulative interest paid on   the first payment. Be sure to use the appropriate absolute, relative, or   mixed cell references.

Enter a function in cell H12,   based on the payment and loan details, that calculates the amount of   cumulative principal paid on the first payment. Be sure to use the   appropriate absolute, relative, or mixed cell references.

Enter a reference to the   remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in   the prior steps down to complete the amortization table. 

Ensure the Sales worksheet is   active. Enter a function in cell B8 to create a custom transaction number.   The transaction number should be comprised of the item number listed in cell   C8 combined with the quantity in cell D8 and the first initial of the payment type in cell E8. Use   Auto Fill to copy the function down, completing the data in column B.

Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than   or equal to $4000. Otherwise, the function will display a blank cell. Use Auto   Fill to copy the function down, completing the data in column G. 

Create a data validation list in   cell D5 that displays Quantity, Payment Type, and Amount (in that order).

Type the Trans# 30038C in cell B5, and select Quantity from the validation list in   cell D5.

Enter a nested lookup function   in cell F5 that evaluates the Trans # in cell B5 as well as the Category in   cell D5, and returns the results based on the data in the range A8:F32.

Create a PivotTable based on the   range A7:G32. Place the PivotTable in cell I17 on the current worksheet.   Place Payment Type in the Rows box and Amount in the Values box. Format the   Amount with Accounting Number Format.

Insert a PivotChart using the   Pie chart type based on the data. Place the upper-left corner of the chart   inside cell I22. Format the Legend of the chart to appear at the bottom of   the chart area. Format the Data Labels to appear on the Outside end of the   chart.

Insert a Slicer based on Date.   Place the upper-left corner of the Slicer inside cell L8.

Use PowerQuery to connect to the   Access database Exp19_Excel_AppCapstone_Comprehensive_Inventory.accdb.   Load the Inventory table into a new worksheet named Inventory.
 

  Note, Mac users, download and import the delimited Inventory.txt file into a new worksheet named Inventory starting in cell A1.

Create a footer with your name   on the left, the sheet code in the center, and the file name on the right for   each worksheet.

Save the file Exp19_Excel_AppCapstone_ComprehensiveAssessment-   Manufacturing.xlsx. Exit Excel. Submit the file as directed.

  Please answer the questions below and submit as a Word document. 

1. Write your own description of what the term information systems hardware means.
2. The _____ is often the most senior role in information systems for an organization.
3. Name an application software that you use and the purpose that you use it for.
4. Name an operating system software that you use and the device you use it on.

database security 

 1.Discuss the five vectors of progress that can overcome barriers to blockchain’s adoption.

formate: Introduction, Question 1, Conclusion, References

Reference

1. Schatsky, D., Arora, A., & Dongre, A. (2018). Blockchain and the five vectors of progress. Deloitte Insights, 1-9. Retrieved September 5, 2019 from https://www2.deloitte.com/us/en/insights/focus/signals-for-strategists/value-of-blockchain-applications-interoperability.html

Include at least 250 words in your posting and at least 250 words in each of your two replies. 

Indicate at least one source or reference in your original post. Please see syllabus for details on submission requirements.

Question: 

Search “scholar.google.com” or your textbook. Include at least 250 words in your reply.  Indicate at least one source or reference in your original post.  Discuss ways organizations have built a CSIRT. What are the components to building an effective and successful CSIRT team?

This week’s journal article focuses on attribution theory and how it influences the implementation of innovation technologies.  Two types of employee attributions are noted in the article (intentionality and deceptive intentionality), please review these concepts and answer the following questions:

1. Provide a high-level overview/ summary of the case study
2. Note how constructive intentionality impacts innovation implementations
3. Find another article that adds to the overall findings of the case and note how attribution-based perspective enhances successful innovation implementations.  Please be explicit and detailed in answering this question.

 Journal articles

• Journal Article 3.1: Lucas, J.W. and Baxter, A.R. (2012) ‘Power, influence, and diversity in organizations’, The ANNALS of the American Academy of Political and Social Science, 639(1): 49–70.
• Journal Article 3.2: Martinez, A.D., Kane, R.E., Ferris, G.R. and Brooks, C.D. (2012) ‘Power in leader–follower work relationships’, Journal of Leadership & Organizational Studies, 19(2): 142–151.
• Journal Article 4.1: Petty, M.M., Beadles, N.A., Chapman, D.F., Lowery, C.M. and Connell, D.W. (1995) ‘Relationships between organizational culture and organizational performance,’ Psychological Reports, 76(2): 483–492.
• Journal Article 4.2: Bonavia, T. (2006) ‘Preliminary organizational culture scale focused on artifacts’, Psychological Reports, 99(3): 671–674.
• Journal Article 4.3: Walker, R.C. and Aritz, J. (2015) ‘Women doing leadership: leadership styles and organizational culture,’ International Journal of Business Communication, 52(4): 452–478.

 The paper should meet the following requirements:

• 3-5 pages in length (not including title page or references)
• APA guidelines must be followed.  The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.
• A minimum of five peer-reviewed journal articles.

1. For this assignment you will be submitting your progress on your final project.  Specifically you will submit a document addressing the following topics.

Milestone 1

• Domain Structure
• DNS Server Plan
• DHCP Server Plan

While there is not a formal format for this submission and you are not expected to have everything for these items implemented in your proof of concept,  if you work through the project logically for each milestone you will have completed a large quantity of the work by the end of the course.

2.  For this assignment you will be submitting your progress on your final project.  Specifically you will submit a document addressing the following topics.

Milestone 2

• Central Update Server planlayout
• File and Print Server structure and security plans
• Security Group layout
• Naming conventions
• OU Structure

GUIDE( So, you are simply breaking down the final project and covering what you will be including in your final project based on the list that is in the Milestone 1 assignment. Explain the items and how you will be suggesting that they be set up in the organization that you are proposing to. The idea is to do the final prject in Milestones. So the only thing you would need to do after completing all of the Milestones is to add or subtract and clean up the material that will make up the final project by moving all of them together and making a report out of it. )

Reservation Calculator

Enter the arrival month (1-12): 5

Enter the arrival day (1-31): 16

Enter the arrival year: 2018

Enter the departure month (1-12): 5

Enter the departure day (1-31): 18

Enter the departure year: 2018

Arrival Date: May 16, 2018

Departure Date: May 18, 2018

Price: $145.00 per night

Total price: $290.00 for 2 nights

Continue? (y/n): n

Bye!

Specifications

Create a class named Reservation that  defines a reservation. This class should contain instance variables for  the arrival date and departure date. It should also contain a constant  initialized to the nightly rate of $145.00.

The Reservation class should include the following methods:

• public LocalDate getArrivalDate()
• public String getArrivalDateFormatted()
• public setArrivalDate(LocalDate arrivalDate)
• public LocalDate getDepartureDate()
• public String getDepartureDateFormatted()
• public setDepartureDate(LocalDate departureDate)
• public int getNumberOfNights()
• public String getPricePerNightFormatted()
• public double getTotalPrice()
• public String getTotalPriceFormatted()

Assume  that the dates are valid and that the departure date is after the  arrival date. You must allow the user to enter the date in the  MM/DD/YYYY format.

Reservation class

Create a class named Reservation that defines a reservation





This criterion is linked to a Learning OutcomeInstance variables

Reservation class should contain instance variable for the arrival date.

Reservation class should contain instance variable for the departure date.



Nightly rate constant

Reservation class should also contain a constant initialized to the nightly rate of $145.00.



Entry format for dates

Allow the user to enter the date in the MM/DD/YYYY format.



This criterion is linked to a Learning Outcomepublic instance methods

The Reservation class should include the following methods:



public LocalDate getArrivalDate()



public String getArrivalDateFormatted()



public setArrivalDate(LocalDate arrivalDate)



public LocalDate getDepartureDate()



public String getDepartureDateFormatted()



public setDepartureDate(LocalDate departureDate)



public int getNumberOfNights()



public String getPricePerNightFormatted()



public double getTotalPrice()



public String getTotalPriceFormatted()

Week 3 Quiz

Answer each these questions in a paragraph with at least five sentences: Include the question and number your responses accordingly. Provide a citation for each answer.  1. What is privacy?2. What risks, if any, does facial recognition software raise?3. How much information about you can be found on-line with a simple google search? 4. How much information about you can be found by searching government and commercial databases?5. Describe informed consent. 6. Should secondary use of consumer provided data be available without notice to the consumer?7. How do data mining and predictive analytics work? 8. Watch this Science Friday video by Ira Flatow. And, offer your opinion – Are advancing algorithms taking our free will? 9. Should Facebook be regulated, at least as far as it’s privacy and data policies? 10. How many public cameras is too many?