Exp19_Excel_Ch03_CapAssessment_Movies

Exp19 Excel Ch03 CapAssessment Movies

Project Description:

You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for April 2021 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week.

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

You want to create a pie chart   to show the percentage each category contributes to the monthly movie   downloads.
 

  Select the ranges A5:A10 and F5:F10. Create a pie chart and move it to a   chart sheet named April Pie Chart.

The chart needs a descriptive   title that is easy to read.
 

  Type April   2021 Downloads by Genre as the chart title, apply bold, 18 pt font size, and Black, Text   1 font color.

Percentage and category data   labels will provide identification information for the pie chart.
 

  Add category and percentage data labels in the Inside End position. Remove   value data labels and the legend. Apply 14 pt font size and Black, Text 1   font color.

You want to focus on the comedy   movies by exploding it and changing its fill color.
 

  Explode the Comedy slice by 7% and apply Dark Red fill color.

A best practice is to include   Alt Text for accessibility compliance.
 

  Add Alt Text: The pie chart shows percentage of downloads by genre   for April 2021.   (including the period)

Next you want to create a combo   chart to depict the monthly totals and percentages by category.
 

  Display the Data sheet, select the ranges A4:A10 and F4:G10, and then create   a Clustered Column – Line on Secondary Axis combo chart.

You want to position the chart   below the data source.
 

  Cut the chart and paste it in cell A13. Change the height to 3.5″ and the width to 6″.

Change the combo chart title to April 2021   Downloads.   Apply Black, Text 1 font color to the chart title.

Axis titles will help   distinguish the number and percentage of downloads.
 

  Add a primary value axis title and type Number of Downloads. Add a secondary value axis   title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color   to both value axis titles.

Now that you added an axis title   for each vertical axis, you can remove the legend and format the secondary   value axis to display whole percentages.
 

  Remove the legend for the combo chart. Display 0 decimal places for the   secondary value axis.

You want to add some color to   the plot area for the combo chart.
 

  Apply Light Gradient – Accent 1 gradient fill color for the plot area.

A best practice is to include   Alt Text for accessibility compliance.
 

  Add Alt Text: The combo chart shows the number and percentage of   downloads by genre for April 2021. (including the period).

To provide a visual summary of   the weekly totals for each genre, you will insert sparklines.
 

  Select the range B5:E11. Insert Line Sparklines in the range H5:H11. Apply   Black, Sparkline Style Dark #4

Displaying the markers helps   identify the specific points on the sparklines. You will also change the high   point to a different color to stand out.
 

  Show the high point and markers for the sparklines. Change the high point   marker color to Red.

Your last major task is to   create a bar chart for weekly downloads.
 

  Select the range A4:E10. Create a stacked bar chart. Move the chart to new   chart sheet. Type Weekly Downloads for the sheet name. Apply Style 8 chart style.

Add a chart title above the bar   chart and type April 2021 Weekly Downloads by Genre. 

Increasing the font size will   make the chart elements easier to read.
 

  Apply 11 pt font size to the category axis, value axis, and the legend for   the bar chart.

Because the largest value is   less than 9,000, you can reduce the maximum bound in the chart. In addition,   you want to display the category labels in the same order that they are in   the worksheet.
 

  Change the maximum bounds for the value axis to 9000 and set the Major Units to 500 for the bar chart. Use the Axis   Options to format the category axis so that the category labels are in   reverse order in the bar chart.

Although the bar chart displays   major gridlines, minor gridlines could improve the appearance.
 

  Add primary minor vertical gridlines to the bar chart.

A best practice is to include   Alt Text for accessibility compliance for the bar chart.
 

  Add Alt Text: The stacked bar chart shows downloads by each week for   each genre.   (including the period).

Insert a footer with Exploring   Series on the   left, the sheet name code in the center, and the file name code on the right   on all the sheets. Change to Normal view.

Save and close Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.   Exit Excel. Submit the file as directed.

 #Exp19_Excel_Ch11_ML1_Internships 

 #Exp19 Excel Ch11 ML1 Internships 

 #Excel Chapter 11 Mid Level 1 Internship 

Project Description:

As the Internship Director for a regional university, you created a list of students who are currently in this semester’s internship program. You have some final touches to complete the worksheet, particularly in formatting text. In addition, you want to create an advanced filter to copy a list of senior accounting students. Finally, you want to insert summary statistics and create an input area to look up a student by ID to display his or her name and major.

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

You want to extract the last   four digits of the student’s ID.
 

  In cell B2 on the Students sheet, extract the last four digits of the first   student’s ID using the RIGHT function. Copy the function from cell B2 to the   range B3:B42.

After extracting the last four   digits of the ID, you want to align the data.
 

  Apply center horizontal alignment to the range B2:B42.

The first and last names are   combined in column C. You want to separate the names into two columns.
 

  Convert the text in the range C2:C42 into two columns using a space as the   delimiter.

You want to convert the text in   column F to upper and lowercase letters.
 

  Use a text function in cell G2 to convert the text in cell F2 into upper and   lowercase letters. Copy the function to the range G3:G42.

Now that you have converted text   from uppercase to upper and lowercase, you will hide the column containing   the majors in all capital letters.
 

  Hide column F.

You want to create a criteria   range for the dataset.
 

  Create a criteria range by copying the range A1:I1 and pasting it in cell   A44. Create conditions
  for   Senior Accounting   majors on row 45 and an OR condition for Junior Accounting majors in the respective cells   on row 46

You are ready to perform the   advanced filter.
 

  Create an output range by copying the range A44:I44 to cell A48. Perform the   advanced filter by copying data to the output range. Use the appropriate   ranges for list range, criteria range, and output range

On the Info worksheet, you want   to insert a database function based on conditions.
 

  Display the Info worksheet and insert the DSUM function in cell B2 to   calculate the total tuition for junior and senior accounting students. Use   the range A1:I42 for the database, Tuition for the field, and the criteria range.

You want to insert database   functions to perform calculations.
 

  In cell B3, insert the DAVERAGE function to calculate the average GPA for junior and senior   accounting students on the Students worksheet. Use mixed references in the   ranges.

You want to identify the highest   GPAs for junior and senior accounting majors.
 

  In cell B4, insert the DMAX function to identify the highest GPA for junior and senior   accounting students on the Students worksheet. Use mixed references in the   ranges.

In cell B5, insert the DMIN   function to identify the lowest GPA for junior and senior accounting students on the Students   worksheet. Use mixed references in the ranges.

In cell B6, insert the DCOUNT   function to count the number of junior and senior accounting
  students on the Students worksheet. Use mixed references in the ranges.

In cell B9, insert the DGET   function to retrieve the last name of the student who has the ID listed in   cell A9. Use the column number representing the Last Name column for the field   argument and use the criteria range A8:A9. Edit the function to make the   column letters absolute. Copy the DGET function from cell B9 to cell C9. Edit   the field number to represent the GPA column.

You want to format the results   of the database functions.
 

  Format the range B3:B6 with Comma Style. Decrease the number of decimal   places to zero
  for cell B6.

You want to identify the   location of a particular ID.
 

  Insert the MATCH function in cell B13 to identify the position of the ID   stored in cell B12. Use
  the range A2:A42 in the Students worksheet as the lookup_array argument and   look for exact
  matches only.

Insert the INDEX function in   cell B14 with Students!A$2:I$42 as the array, B$13 that contains
  the MATCH function as the row number, and 4 as the column number. Copy the function from cell   B14 to cell B15. Edit the function to change the column number to 7.

Change the ID in cell B12 to 11282378. The results of the MATCH and   INDEX functions
  should change.

You want to insert a function to   display other functions as text.
 

  Insert the FORMULATEXT function in cell D2 to display the formula that is   stored in cell B2.
  Copy the function to the range D3:D6 and to the range D13:D15. In cell D8,   insert the
  FORMULATEXT function to display the function that is stored in cell B9, and   in cell D9, insert
  the FORMULATEXT function to display the function that is stored in cell C9.

Increase the width of column D   to 50.

Create a footer with your name   on the left side, the sheet name code in the center, and the file name code   on the right side on all sheets.

Save and close Exp19_Excel_Ch11_ML1_Internships.xlsx.   Exit Excel. Submit the file as directed.

Part 1
Your author notes on page 117:  “in the complex project landscape effective integration requires management approaches that allow for a flexible creative and adaptive approach by the project team in response to the changing characteristics of the project, organization, and cultural environment and the dynamics of the organization”.  This week you learned about process groups used in the project management lifecycle.  In your experience, are all these deliverables necessary?  Provide two deliverables that all projects, regardless of methodology, should leverage and two deliverables that may not be necessary and why? 

Part 2:Choose an Agile framework and a project that can be completed using the Agile framework and answer the following:

1. Describe the model to include a pictorial review of the process
2. Describe the project
3. Why do you feel this model is better for this type of project?
4. What would be the impact of completing the project using a different approach? 

Text

A Guide to the Project Management Body of Knowledge (Pmbok(r) Guide) – Seventh Edition 

ISBN: 9781628256642 

Authors: Project Management Institute 

Publisher: Pmbok(r) Guide 

Publication Date: 2021-05-01

 What are some of the ways we can manage the distribution channel? After reviewing this week’s resources and your research, consider the various channels of distribution. In your own words identify at least two ways to better manage and an existing channel for a specific product you personally use? Be sure to explain your reasoning behind your selections.The criteria for responses are as follows:

• Your initial response to the discussion question should be 250-300 words. You must have at least one course (our text) and one non-course scholarly/peer reviewed source in your initial posting.  Sources require in-text citations and must be incorporated into the body of the post in addition to a full APA citation at the end of the post. 

Company Name: Walmart.

Product: Product should be used the same as mentioned in previous weeks work.

References: 

https://www.repsly.com/blog/consumer-goods/everything-you-need-to-know-about-product-distribution

Write a program that generates n random  integers between 0 and 9 and displays the count for each number. (Hint:  Use an array of ten integers, say count, to store the counts for the  number of 0s, 1s, . . . , 9s.)

A modular program is expected – use Methods. The program specifications are as below. 

1. In the main() method, declare an int array of size 10, named count.
2. Implement a method populateCount(int[] cnt) that initializes the array to zero.
3.  Implement a method countNums(int[] cnt, int n) that accepts  the count array and an integer n. The method should generate n random  numbers in the range of 0 to 9. It should keep a count of how many times  each number, 0 to 9; is generated in the array count. 
4. Implement a method printNums(int[] cnt) to print the count  array.  Note, print “time” or “times” – which ever is appropriate. 
5. Use basic structured programming and procedural programming.
6.  Write a main() method that declares the count array. Invokes  the countNums() method with n = 10 followed by invoking the printNums().  Then invokes the countNums() method with n = 100 followed  by printNums(). And again, invokes the countNums() method with n =  1000 followed by printNums(). 
7. Make sure you invoke  the populateCount(int[] cnt) method at appropriate times. And write out  the heading for each set, n = 10, 100, and 1000.
8. Documentation. Includes your name, create date and purpose of lab.

Business case:  Hospital Patient processing system

You were tasked to improve the performance of the local hospital Patient processing system

There are three databases in the new IT system:

The patient database will record and authenticate each patient in the hospital

The employee database will record and authenticate each employee in the hospital

The ambulance database will record each ambulance

Database and Database management systems are on premises for all three (Patient, Employee, and Ambulance). Therefore, current data relating to patients and data related to Ambulances data will be on-premises.  Data related to Employees will be kept on the premises.  The hospital IT system will not keep old patient and Ambulance data on the premises.

Hospital managers would like

– Streamline the patient processing system (admitting and moving to room)

– Better response time for Ambulance to the emergencies

– Better service for the patient coming to the hospital with an Ambulance

– To be able to locate doctors when they are out of the hospital (for emergencies)

– Fast interaction with companies for medical equipment and supplies

QUESTION 1: List three applications of “web-accessible smart devices” in the new hospital that you would recommend for this business case.

QUESTION 2: How the cloud will influence future Operating Systems in the Severs of the Hospital IT system?   (Assume that the servers are in the Local Area networks in the hospital building)

QUESTION 3: How you can use location-aware applications in the new Hospital IT system?

QUESTION 4: How you could use cloud-enabled communication among smart devices in the new Hospital IT system?

Discuss operating systems: Practices and Trends with New Digital Technologies. Use a word processor, such as Word. Include bibliographic references in the writing.

1. How have Operating Systems changed over the past ten years?
2. What digital technologies do you feel are the most useful today?

Contribute a minimum of 3 pages. It should include at least 2 academic sources, formatted and cite in APA.

 After loading “Labor Market 2018 & Projected 2018–28” data set (you can download it in this assignment folder), please answer below questions. (Data is provided by U.S. Bureau of Labor Statistics, https://www.bls.gov/careeroutlook/2019/article/wages-and-openings.htm)
Create a scatter plot that shows “Median Annual Wage 2018” in Y axis and “Annual Average Openings, Projected 2018-2028” in X axis, bubble sized by number of records and colored by occupational group. Please create your title of this figure and copy and paste it on this below box
Q1) Please locate the jobs that are related to data systems in this data. What are the median annual wages in 2018 and annual average openings projected from 2018 to 2028?
Q2) After exploring the data, are you willing to have this job for your future career?  If you changed your mind, why? Then, locate the jobs that interest you for your future placements and lable them in your figure. Please elaborate on your decision.  

In Week 3, you conducted research into your academic program to learn more about what skills you would get from your courses, and how you might leverage what you learned to secure an internship or job in your field of interest. Last week you explored education and training requirements, job tasks, and other information about your career of interest. Now you will conduct research to find the current trends in your desired industry and provide a brief summary of your findings. This assignment will be in the form of a professional email to your supervisor, Ms. Smith.      

Scenario
Imagine that you work for a company directly related to your major. Your company is preparing for expansion and your boss, Ms. Smith, has been asked to design an orientation program for new employees. As part of this process, Ms. Smith has asked you to do some research into the trends in your organization’s industry that new employees will need to know about and understand.  

She has asked you to write a detailed email that identifies the three top emerging IT trends in your industry to incorporate into the new training, along with why they are the top three. If she likes your work on this initial research, she will ask you to take the lead on this portion of the training, allowing you to get leadership experience and name recognition within the organization.  

While you have been with the company for some time, you haven’t had much opportunity to focus on training others. You think you have a sense of the industry but know you need to do more research to be accurate in your analysis. The ability to spot emerging trends in your industry is an important skill, and your boss wants to ensure that new employees are up to speed as quickly as possible.   

Apa format & citations 350 words each questions and no plagiarism 

Question 1

Software systems are not isolated systems but are essential components of broader systems that have a human, social or organizational purpose.

Read Chapter 10  and review Lecture slides (posted under week 5), and reputable articles/journals and List and discuss The Sociotechnical Systems Stack. 

Question 2

Please read Chapter 11 of your textbook and review Lecture slides and IGU online library and reputable journals/resources and describe and explain Good practice guidelines for dependable programming.