Monthly Archives: June 2023

This week’s written activity is a three-part activity. You will respond to three separate prompts but prepare your paper as one research paper.

Start your paper with an introductory paragraph.

Prompt 1 “Data Warehouse Architecture” (2-3 pages): Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse. Also, describe in your own words current key trends in data warehousing. 

Prompt 2 “Big Data” (2-3 pages): Describe your understanding of big data and give an example of how you’ve seen big data used either personally or professionally. In your view, what demands is big data placing on organizations and data management technology? 

Prompt 3 “Green Computing” (2-3 pages):  The need for green computing is becoming more obvious considering the amount of power needed to drive our computers, servers, routers, switches, and data centers. Discuss ways in which organizations can make their data centers “green”. In your discussion, find an example of an organization that has already implemented IT green computing strategies successfully. Discuss that organization and share your link.

Conclude your paper with a detailed conclusion section. 

The paper needs to be approximately 7-10 pages long, including both a title page and a references page (for a total of 9-12 pages). 

Your paper should meet the following requirements:

• Be approximately seven to ten pages in length, not including the required cover page and reference page.

• Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

• Support your answers with the readings from the course, the course textbook, and at least three scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. 

 Exp19_Excel_Ch12_Cap_Bulldog_Collectibles 

 Exp19 Excel Ch12 Cap Bulldog Collectibles 

 Excel Chapter 12 Captsone – Inventory 

Project Description:

You are the operations manager for Bulldog collectables, a small start-up company that deals with sports memorabilia. As you prepare to document your inventory, you decide to utilize a template to save time. To complete this task, you will create a worksheet based on an Office.com template; you will also use the Macro Recorder and Visual Basic for Application to automate sorting and calculations within the workbook.

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

Delete the Inventory   Pick List and Bin Lookup worksheets.

Delete the INVENTORY   PICK LIST and BIN LOOKUP icons located respectively in cells E2 and F2. Then   Clear all existing Data Validation in the range A1:K15.

Delete the values in   the range B5:J15.

Record a macro named Sort, be sure to use   relative references. Ensure the macro sorts the data in the table in   ascending order based on SKU (column A). Stop the Macro Recorder and Save the   workbook as a Macro-Enabled Template.

Create a form control   button that spans the cell E2:E3. Assign the Sort macro and edit the button   text to Sort.

Use the VBA Editor to   create a new module.
 

  Type the following VBA code to create a custom Inventory Value function then   save and exit the VBA Editor (be sure to leave a blank line between each line   and before End Function):
 

Function InventoryValue (QTY, COST)
 

InventoryValue = QTY * COST
 

Click cell J5 and use   the newly created InventoryValue function to calculate the value of the   inventory for each item in column I.

Use the VBA Editor to   create a new module named ProtectWorkbook. Type the following VBA   statements to create the sub procedure (leave appropriate line spacing).
 

Sub ProtectWorkbook()
 

‘Protect workbook using the password eXploring
Worksheets(“Inventory List”).Protect   Password:=”eXploring”

Insert a new module   named UnprotectWorkbook. Type the following VBA   statements to create the sub procedure and then save and exit the VBA Editor   (leave appropriate line spacing).
 

Sub UnprotectWorkbook()
 

‘Unprotect workbook using the password eXploring
Worksheets(“Inventory List”).Unprotect Password:=”eXploring”

Insert a Form Control   Button spanning cells F2:F3 named Unprotect. Assign the UnprotectWorkbook   macro to the newly created Control Button.

Insert a Form Control   Button spanning the range G2:H3 named Protect. Assign the macro ProtectWorkbook.

Insert the comment Inventory   based on values in column J. in cell B3 (include the period).

Insert the comment Count   of items in column C. in cell C3 (include the period).

Inspect the document   for private information and hidden properties. Save the file when prompted   then remove Document Properties and Personal Information, and Headers and   Footers.
 

  Note: Mac users, from the Excel menu, open your preferences, click Security,   and then click the check box to Remove personal information from this file on   save. Delete any headers or footers in the workbook.

Check the document   for accessibility issues. Use the Accessibility Checker pane to change the   cell styles to Normal in order to repair the issue.

Check the document   for compatibility with Excel 2010, 2013, and 2016.
 

  Note: Mac users, skip this step.

Insert a new   worksheet named Code.

Open the VBA Editor,   open Module 1, and copy the code. Paste the code in the Code worksheet   starting in cell A1. 

In the VBA Editor,   open Module 2, and copy the code. Paste the code in the Code worksheet   starting in cell A22. 

In the VBA Editor,   open the ProtectWorkbook, and copy the code. Paste the code in the Code   worksheet starting in cell A28. 

In the VBA Editor,   open the UnprotectWorkbook module, and copy the code. Paste the code in the   Code worksheet starting in cell A35. 

Close the VBA Editor   and save the workbook as an xlsx file (not Macro-Enabled).

Close EXP19_Excel_Ch12_CAP_Inventory.xlsx.   Exit Excel. Submit the file as directed.

Assigned Readings:Chapter. 11 Managing Project TeamsChapter. 12 Outsourcing: Managing Interorganizational RelationsInitial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1. Assume that you have the following decision-making options: (1) make the decision on your own with available information, (2) consult others before making a decision, and (3) call a meeting and reach a consensus, seeking to arrive at a final decision everyone can agree on. Which approach would you use to make each of the following decisions and why?
   • You are the project leader for Casino Night on campus, a charitable event organized by your group to raise money for the homeless. The event was a big success, garnering a net profit of $3,500. Before the event your team researched nearby organizations that support the homeless and to whom the money could be given. You narrowed the choices to the “Chunk of Coal House” and “St. Mary’s Soup Kitchen.” Eventually your group decided that the funds be given to Chunk of Coal. You are about to write a check to its director when you read in the local newspaper that the Chunk of Coal House has terminated operations. What should you do with the money? 
   • You are the leader of a new product development project. Your team has worked hard on developing a third-generation product that incorporates new technology and meets customer demands. The project is roughly 50 percent complete. You have just received a report from the marketing department detailing a similar product that is about to be released by a competitor. The product appears to utilize radical new design principles that expand the functionality of the product. This poses a serious threat to the success of your project. Top management is considering canceling your project and starting over again. They want you to make a recommendation.

Text

Title: Project Management: The Managerial Process 

ISBN: 9781260238860 

Authors: Clifford F. Gray, Erik W. Larson 

Publisher: McGraw-Hill Education 

Publication Date: 2020-01-09

need complete in 5days 

please see document

Exercises 6.1, 6.2, and 6.3 using Hive. 

1. Review the articles from 3.2 Discussion:
   1. IT Governance 
   2. Governance Over IT Service Management Processes Using COBIT 5.0
   3. Lean IT Governance
2. In the discussion linked below, respond to the following prompts:
   1. Provide a summary of IT governance and the use of COBIT. How would using a framework like COBIT help enhance the concerns for managing an IT infrastructure and enforcing best practices? Can you identify another governance framework and compare it to COBIT?
   2. Compare and contrast lean IT governance practices to those of a standard governance framework.
   3. Considering the current governance frameworks, discuss change and improvement in the governance program, such as key points when the plan should be modified.
3. Your initial post should be a minimum of 250 – 300 words. 

To successfully complete this week’s discussion, you will need to:

• Refer to Project Management Foundations: Requirements [27 min]. 
• Review the instructions and scoring guide for the Business Requirements assignment due this week.

Please respond to the following in a substantive post ( 3–4 paragraphs):

• Describe the functional business requirements (scope) and scope control for your hypothetical start-up e-commerce company.
• Describe the technical requirements necessary to integrate various e-commerce infrastructure components.

1. What things do you think make up the Web?
2. When arriving at a crime scene, is it better to shut down the computer immediately or insure it stays on? What are the tradeoffs?

For Task:

1. Review software license agreements in your textbook and research them online.
2. Create a report of your recommendations to be presented to senior management and the product lawyer.

• For your recommendations, consider all types of licenses and the delivery method.

For each license type, you considered, provide a rationale for why you selected or rejected that type of license agreement type for your product.

 Dependencies and Normalization
Discuss the impact of dependency diagrams on the process of normalization of database tables. Provide examples of the violations of 1NF, 2NF, and 3NF. Minimum 300 words

 
Textbook:

Printed Textbook: Database Systems: Design, Implementation, and Management, 13th
edition, Coronel and Morris.