Chapter Summary

Due Sep 12, 11:59pm, PT…………20 hours left

Need to write about 2 pages (1.5 line spacing and 11 or 12 font size) of summary of chapter, so that it contains:

(part 1) important concepts of the chapter

(part 2) experience/application/opinions of the chapter.  

Exp19_Excel_Ch10_CapAssessment_Movie_Rentals

 

Exp19_Excel_Ch10_CapAssessment_Movie_Rentals

 

Project Description:

You are the systems manager for Blue City Movies Rentals and you have  been asked to create a report on historical sales data. To complete  your task you will combine and edit data from multiple sources using  Excel’s Power add-ins, XML, and text functions.

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

Use Get & Transform (Power   Query) to load the file e10c2Movies.txt   to the existing worksheet starting in cell A1. Be sure to load the   information to the data model.

Rename the worksheet Movies.

Use Get & Transfrom (Power   Query) to load the Account table from the xml file e10c2Contacts.xml into a new worksheet. Be sure to add the   information to the data model.

Rename the worksheet Contacts.

Use Get & Transfrom (Power   Query) to load the Rates table from the file e10c2Rates.xlsx into a new worksheet. Be sure to add the   information to the data model.

Rename the worksheet Rates.

Use Get & Transfrom (Power   Query) to load the StoreInfo table located in the database e10c2Transactions.accdb into a new   worksheet. Be sure to add the information to the data model.

Rename the worksheet StoreInfo.

Use Get & Transform (Power   Query) to load the Transactions table located in the database e10c2Transactions.accdb  in the Power   Query Editor. Use the Power Query Editor to change the  format of the Date   column from Date and Time to Date. Load the edited  data to a new worksheet   making sure to add the information to the data  model.

Rename the worksheet Transactions.

Create a relationship between   the Transactions table Account field and the Account table Account field. 

Create a relationship between   the Transactions table Store# and the StoreInfo table Store#.

Use PowerPivot to create a   PivotTable and clustered column PivotChart Horizontal on a new worksheet.   Name the worksheet TotalEarnings.  Use the Transactions table Date field in the   Filters area, Account  table Type field and Last field in the Rows area, and   Transactions  table Total field in the Values area. 

Add the chart title Total   Earnings.

Use 3D Maps (Power Maps) to   create a geographical visualization of  sales data by store. Use the Store Zip   as the location dimension and  the Transactions Total as the height dimension.   Zoom in as needed to  view results.

Save and close Exp19_Excel_Ch10_CapAssessment-MovieRentals.xlsx.   Exit Excel. Submit the file as directed.

Ds 604

I need someone to help me doing the homework for the DS 604 online class

risk analysis

 Risk Identification, Risk Analysis and Risk Evaluation. These phases allow you to focus  specific groups of people on specific tasks. In this assignment, we will review risk  identification tools and why they are important. Instructions: • Review five tools for identifying risk in an organization. For each tool: o Identify each tool. o Describe its importance in the risk identification process for an  organization. o Give a situation where the tool can be applied. o Discuss the results of the application. Requirements: • Submit a Word document in APA format. • At least three pg in length, excluding the Title and Reference . • At least two resources, k. 

React app – dynamic circle

Create a React.js application that has 3 circles components. 

These circles can be created in any way you like, but needs to be centered on the page.

The circles will need an onclick feature that increases the size of the circle that is being clicked.

The size of the circle will increase with every click.

Hint: Assigning a number value to each circle that, when clicked, will update the number and grows the size of the circle. 

IT Strat Plan – Wk5

  Q1. 275 words 

 Discuss an organization’s need for physical security. What methods, approaches, and models can be used by organizations when designing physical security needs? Lastly, explain how these security measures will safeguard the organization.  

Q2. Research paper: 5 pages ——- Separate Document

You have been hired as the CSO (Chief Security Officer) for an organization. Your job is to develop a computer and internet security policy for the organization that covers the following areas:

  • Computer and email acceptable use policy
  • Internet acceptable use policy
  • Password protection policy

Make sure you are sufficiently specific in addressing each area. There are plenty of security policy and guideline templates available online for you to use as a reference or for guidance. Your plan should reflect the business model and corporate culture of a specific organization that you select. 

 Include at least 3 scholarly references in addition to the course textbook.  At least Five of the references cited need to be  peer-reviewed scholarly journal articles from the library.

 Your paper should meet the following requirements: 

  • Be approximately 5 full 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 and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
  • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Q3: Practical Connection – 550 words ——- Separate Document

 Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. Requirements:

  • Provide a 2 full pages double spaced minimum reflection.
  • Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.
  • Share a personal connection that identifies specific knowledge and theories from this course.
  • Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

Rewrite this program

The c++ file attached has to be rewritten to look different but still, be the same.

Must be completed by Sunday Night May 9th 2021

GSR: Week#2 Scholarly Abstract Assignment – Quantitative and Qualitati

 2.1 Scholarly Abstract Assignment – Quantitative

 

Create a 1-2 page single-spaced Analysis of Research abstract published scholarly articles related to a topic you selected in Week 1. This article should reflect a quantitative research method.

Brevity and being concise are important as this analysis is intended to be a brief summation of the research.

Each abstract must therefore consist of the following in this order:

1. Bibliographic Citation – use the correctly formatted APA style citation for the work as the title of your abstract, displaying the full citation in bold font.

2. Author Qualifications – name the qualification of each author conducting the research

3. Research Concern – one paragraph summary of the reason for the overall research topic

4. Research Purpose Statement AND Research Questions or Hypotheses – specific focus of the research

5. Precedent Literature – key literature used in proposing the needed research (not the full bibliography or reference list)

6. Research Methodology – description of the population, sample, and data gathering techniques used in the research

7. Instrumentation – description of the tools used to gather data (surveys, tests,interviews, etc.)

8. Findings – summation of what the research discovered and the types of analysis that were used to describe the findings (tables, figures, and statistical measures)

9. Conclusions – what did the findings show and how does that relate to current research

10. Suggestions for further research – based on the conclusions of the study, what additional research is needed

2.2 Scholarly Abstract Assignment – Qualitative

Create a 1-2 page single-spaced Analysis of Research abstract published scholarly articles related to a topic you selected in Week 1. This article should reflect a qualitative research method.

Brevity and being concise are important as this analysis is intended to be a brief summation of the research.

Each abstract must therefore consist of the following in this order:

1. Bibliographic Citation – use the correctly formatted APA style citation for the work as the title of your abstract, displaying the full citation in bold font.

2. Author Qualifications – name and qualification of each author conducting the research

3. Research Concern – one paragraph summary of the reason for the overall research topic

4. Research Purpose Statement AND Research Questions or Hypotheses – specific focus of the research

5. Precedent Literature – key literature used in proposing the needed research (not the full bibliography or reference list)

6. Research Methodology – description of the population, sample, and data gathering techniques used in the research

7. Instrumentation – description of the tools used to gather data (surveys, tests,interviews, etc.)

8. Findings – summation of what the research discovered and the types of analysis that were used to describe the findings (tables, figures, and statistical measures)

9. Conclusions – what did the findings show and how does that relate to current research

10. Suggestions for further research – based on the conclusions of the study, what additional research is needed