You are to create the consolidated workbook and SmartArt graphic for Vegas Tourism shown in Figure 7–121 .Perform the following tasks: 1.Open a File Explorer window and double-click the file named SC_EX_7-6.xlsx from the Data Files.  2.Add a second sheet to the workbook, named SmartArt Graphic. Color the tab red.  3.To import a text file:a.Make the Vegas Tourism worksheet active, and then select cell A5. Use the Data tab to import the text file named, Support_EX_7_AirlineA.csv, from the Data Files.b.When Excel displays the dialog box, click the Load arrow and then click Load To.c.When Excel displays the Import Data dialog box, click the Existing Worksheet option button to select it. Click OK (Import Data dialog box).d.Click the new table and then use the Table Tools Design tab to remove the banded rows and the header row. If Excel displays a dialog box, referencing the header row, click Yes. Close the Queries & Connections pane.e.Select cells A5:E5. Right-click the selection and then click Delete on the shortcut menu. When Excel displays the Delete dialog box, click the ‘Shift cells up’ option button, if necessary. Click OK (Delete dialog box).f.Use a separate area of the worksheet to trim the extra spaces from cells B5:B8. Copy the trimmed values back to the range. Delete the data you no longer need. 4.To import an Access table:a.Select cell A9. Import the Access file named, Support_EX_7_AirlineB.accdb, from the Data Files. b.When Excel displays the dialog box, click the Las Vegas Flights February table. Notice that the table has no airline column. Click the Load arrow and then click Load To.c.When Excel displays the Import Data dialog box, click the Existing Worksheet option button and then choose to import into cell B9, as the data does not contain the airline designation. Click OK (Import Data dialog box).d.Remove the banded rows and the header row. If Excel displays a dialog box, referencing the header row, click Yes. Close the Queries & Connections pane. Delete the resulting empty row.e.Type   B   in cell A9. Copy cell A9 to cells A10:A12. 5.To paste data from Word:a.Select cell A20. Start Word and open the file named, Support_EX_7_AirlineC.docx. In the Word table, select all of the data in columns 2 through 5 and copy it. Close Word.b.Return to Excel and use the Paste Special command to paste the data as Text (Paste Special dialog box) in cell A20.c.Copy the Excel range A20:D23. Click cell A13 and transpose the data while pasting it.d.Delete the original imported data in cells A20:D23.e.Cut the data in cells B13:D16 and paste it to cell C13 to move it one column to the right.f.Select cells A13:A16. Click the ‘Text to Columns’ button (Data tab | Data Tools group). In the Convert Text to Columns Wizard dialog box, choose the Fixed Width option button, and then click Finish. 6.To import Web data:a.Select cell A17. Click the From Web button (Data tab | Get & Transform Data group). In the URL box, enter the location of the HTML data file, such as c:\users\username\documents\cis 101\data files\Support_EX_7_AirlineD.html, and then press enter.b.When Excel displays the Navigator dialog box, click the name of the table, February Flights to Vegas – Top Four Cities, and click the Web View tab. Click the Edit button (Navigator dialog box) to open the Power Query Editor Window. c.Remove the Airport column. Click the ‘Close & Load’ arrow (Power Query Editor Home tab | Close group) and then click the ‘Close & Load To’ command to close the Power Query Editor Window.d.When Excel displays the Import Data dialog box, if necessary, click the Existing worksheet option button, and then click OK. e.Remove the banded rows and the header row. If Excel displays a dialog box, referencing the header row, click Yes.f.Delete the blank row. Close the Queries & Connections pane. 7.Use the fill handle to replicate cell F4 to F5:F20. 8.Copy the formatting from C4:F4 to C5:F20. 9.Delete row 4. 10.Select cells F4:F19. Click the Quick Analysis button and create a total in cell F20. In cell A20, type the word,   Total. 11.Adjust column widths as necessary. If directed by your instructor, insert your name and course number in cell A21. 12.Go to the SmartArt Graphic sheet. Click the Gridlines check box (View tab | Show group) to turn off gridlines. 13.Click the ‘Insert a SmartArt Graphic’ button (Insert tab | Illustrations group). Click List in the left pane (Choose a SmartArt Graphic dialog box) and then click Picture Strips in the middle pane. Click the OK button to insert the graphic. 14.Click the Add Shape button (SmartArt Tools Design tab | Create Graphic group). 15.One at a time, using the Text Pane, replace the word, Text, with the words, Denver, Newark, Chicago, and Los Angeles, respectively. 16.Change the SmartArt style to Brick Scene. 17.One at a time, click the picture icon in each part of the graphic, and search the web for a graphic related to the city. Make sure you review the license to ensure you can comply with any copyright restrictions. 18.Resize the graphic to fill the area D1:L24..

Type: Individual Project Unit: Evaluation of Data Governance Due Date: Wed,9/16/20 Grading Type: Numeric Points Possible: 150 Points Earned: Points Earned not available Deliverable Length: 3–4 pages of new content View objectives for this assignment Go To:Assignment DetailsScenario Learning MaterialsReading Assignment My Work: Online Deliverables: Submissions Looking for tutoring? Go to Smarthinking Details Scenario Learn Read My Work Online Deliverables: Submissions Assignment DetailsAssignment DescriptionKey Assignment DraftCase Study: Problem 4The case study company received the design document for the new content management processes and infrastructure from the enterprise content management (ECM) consultant, and is pleased with the plan. Some substantial changes are included in the plan, but the benefits are clear. The chief information officer (CIO) has been through a similar process in a previous company and correctly points out that the new processes and infrastructure are great, but if there is no governance in place, the new ECM system will quickly fail. The ECM consultant agrees wholeheartedly and suggests a plan to establish a data governance plan to go along with the new ECM system. The data governance plan will be created in two stages, with the first being an evaluation of the company’s current data governance policies and procedures in the areas of data quality, data management, data policies, business process management, and risk management. Where can information be obtained regarding a company’s data governance policies and procedures, and how should this information be summarized? AssignmentThus far in the creation of a new enterprise content management manual, the processes and tools used for content management have been examined and improved. The next step is to examine the governance and control policies used within the enterprise content. Data governance strives to ensure that the valuable content of an organization is formally managed. This includes management of data quality, data management, data policies, business process management, and risk management. The key term is formal management, and for this project, you will document the data governance currently in place in your selected organization and evaluate the strengths and weaknesses of the governance. Note that the existing governance may be informal and will require an examination of the processes and control systems that are used to make policy decisions in these areas.The following are the project deliverables:Update the Enterprise Content Management and Data Governance Policies and Procedures Manual title page with a new date and project name. Update the previously completed sections based on instructor feedback. Data Governance Evaluation Data Quality Document the governance currently in place related to data quality in the organization. Strengths and weaknesses of this area should be noted. Data Management Document the governance currently in place related to data management in the organization. Strengths and weaknesses of this area should be noted. Data Policies Management Document the governance currently in place related to data policies management in the organization. Strengths and weaknesses of this area should be noted. Business Process Management Document the governance currently in place related to business process management in the organization. Strengths and weaknesses of this area should be noted. Risk Management Document the governance currently in place related to risk management in the organization. Strengths and weaknesses of this area should be noted. Be sure to update your table of contents before submission. Name the document "yourname_IT621_IP4.doc." Note: This is the Key Assignment draft that you are also submitting to the Discussion Board. Worked Example Please refer to the Worked Example below for an example of this assignment based on the Problem-Based Learning Scenario. The worked example is not intended to be a complete example of the assignment but will illustrate the basic concepts required for completion of the assignment and can be used as a general guideline for your own project. Your assignment submission should be more detailed and specific and should reflect your own approach to the assignment rather than just following the same outline provided in the worked example.Note that the worked example includes material from previous worked examples. The new material will be found under the Week 4 sections of the Table of Contents. The worked example is provided here to help with this assignment.Please submit your assignment.For assistance with your assignment, please use your text, Web resources, and all course materials