OverviewIn this milestone you will import the Austin Animal Center (AAC) CSV file that you will be using for Project One into MongoDB. You will then formulate both a single and a compound index that will optimize the queries for the scenario. Recall that you can use the explain function to verify the use of indexes in your queries. Finally, you will be asked to create an admin and a user account in Mongo to address security needs.Note: Every time you connect to your Apporto environment, please start your MongoDB server with either of the command lines:#start mongo without authentication/usr/local/bin/mongod_ctl start-noauthCopy the port number given in the output, for example:Note: Be sure to begin working on your milestone early in the week. One natural stopping point would be after the completion of Part I.PromptPart I: Importing and Indexing a Data SetYou have been asked to import a file for the Grazioso Salvare project. In order to do so, you must complete the following steps:In Apporto, open the terminal window to access the Linux shell. Upload the Austin Animal Center (AAC) Outcomes data set into MongoDB by importing a CSV file using the appropriate MongoDB import tool. Use the database name “AAC” and collection name “animals”. Complete the import using the mongoimport tool and take screenshots of both the import command and its execution. Tip: How to import a CSV file is covered in the mongoimport documentation in the Module Three Resources. The Austin Animal Center (AAC) Outcomes data set has already been uploaded into Apporto in the /usr/local/datasets/ directory. The filename is “aac_shelter_outcomes.csv”.After importing your data set, start up the mongo shell. Create a simple index on the key “breed”. Show an example query that will use this index and verify that the index will be used with the explain function. Take screenshots of your example query.Create a compound index that will improve the performance of queries looking for breeds that have an “outcome_type” of “Transfer”. Show an example query that will use this compound index and confirm the index will be used with the explain function. Take screenshots of your example query.Part II: User AuthenticationTo comply with your client’s security needs, you have been asked to ensure user authentication to the database by setting up both administrator and user accounts. To achieve this, follow the steps below.Create an administrator account in the mongo shell by following steps #2–3 of the MongoDB Manual Enable Access Control tutorial. Then exit the mongo shell. IMPORTANT: Write down the password for the admin account and keep it somewhere safe. You will need to use this account later in the course.Enable user authentication for the database by typing the following commands exactly into the Linux shell in Apporto:<code>/usr/local/bin/mongod_ctl stop /usr/local/bin/mongod_ctl start </code>You can verify that you have enabled user authentication by accessing MongoDB with your new username/password. Type the following command into the Linux shell to start mongo:<code>mongo --authenticationDatabase "admin" -u "admin" -p </code>This will prompt you to enter your password. Then use the command to show databases to verify that you have set up authentication correctly. If you are not logged in with your admin account, no databases will be viewable. Note: These commands have been customized for the Apporto environment. If you are accessing MongoDB on your own machine, refer to the MongoDB Manual Enable Access Control tutorial. If you accidentally messed up user authentication, or if you forgot your password, you can disable user authentication with this set of commands:<code>/usr/local/bin/mongod_ctl stop /usr/local/bin/mongod_ctl start-noauth </code>Create a new user account called “aacuser” for the database AAC in the mongo shell. Refer to steps #6–7 of the MongoDB Manual Enable Access Control tutorial, linked above, to help you with this task. You will need to modify the commands so that the account name is “aacuser”. IMPORTANT: Write down the password for the aacuser account and keep it somewhere safe. You will need to use this account later in the course.Take a screenshot of your login process to MongoDB using the mongo shell. Be sure you can access MongoDB and list the databases using both the admin and aacuser accounts, as this will verify that your accounts are working. You should be able to include the login commands for both accounts in one screenshot, but if you can not, include two screenshots to show both login commands.Guidelines for SubmissionSubmit a Word document containing all of your screenshots. Use a screenshot tool, such as the Snipping Tool, for your screenshots and be sure to enlarge the images in the Word document before submitting. This will help make sure that your screenshots are an appropriate size for your instructor to be able to read them. Refer to this Use Snipping Tool to Capture Screenshots guide for help with taking screenshots.

Answer the following questions in a scholarly post of 300 words or more by the first Wednesday of the module period. Support your post with academic literature in the form of APA formatted cites and references: Why is it important to learn to plan - and to change plans - in today's world and work environment? Give examples from your experiences. Did you handle the change well? How could you have done a better job?

GO16_XL_VOL1_GRADER_CAP_HW - Front Range Action Sports 1.3Project Description: In this project, you will work with multiple worksheets and enter formulas and functions to calculate totals, averages, maximum values, and minimum values. Additionally, you will create a summary sheet, format cells, insert charts, insert sparklines, and create a table in a workbook.Steps to Perform:StepInstructionsPoints Possible1Start Excel. Open the downloaded Excel file named GO_eV1_Grader_CAP.xlsx.02On the Net Sales worksheet, calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to the range B9:F9.53Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then apply Percent Style with no decimals. Fill the formula down through the range G5:G8.74In the range H4:H8, insert Line sparklines to represent the trend of each state across the four quarters. Do not include the totals. Add Markers and apply Sparkline Style Accent 2 (no dark or light).45Select the range A3:E8, and then use the Recommended Charts command to suggest an appropriate chart. Click the first Clustered Column chart that uses the state names as the category axis. Align the upper left corner of the chart inside the upper left corner of cell A11, and then size the chart so that its lower right corner is slightly inside cell H24. Apply chart Style 7. As the chart title, type Quarterly Net Sales by State.106To show the percent that each state contributes to the total sales, select the nonadjacent ranges that represent the state names and state totals. Insert a 3-D Pie chart, and then move the chart to a New sheet. Name the sheet Net Sales by State.67Change the Chart Title to Annual Net Sales by State and then change the chart title Font Size to 36. Remove the Legend from the chart, and then add Data Labels that display only the Category Name and Percentage positioned in the Center. Change the data labels Font Size to 14 and apply Bold and Italic. Change the Font color to White, Background 1.88Select the entire pie and display the Format Data Series pane. From the 3-D Format gallery, modify the 3-D options by changing the Top bevel and Bottom bevel to first bevel in the first row. Set all of the Width and Height boxes to 512 and then change the Material to the third Standard type—Plastic.09Insert a Custom Footer with the File name in the left section and then save your workbook.110On the Seattle Inventory worksheet, in cell B5, enter a function that will display the average retail price. In cell B6, enter a function that will display the median retail price. In cell B7, enter a function that will calculate the lowest retail price. In cell B8, enter a function that will calculate the highest retail price. Format the range B5:B8 with Accounting Number Format.511On the Seattle Inventory worksheet, in cell G14, enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should display OK. Copy the function down through cell G19.812Format the range A13:G19 as a table with headers and then apply Table Style Medium 5. Filter the table on the Sport column to display only the Skiing types. Display a Total Row in the table, and then sum the Quantity in Stock for Skiing items. Type the result in cell B11. Remove the total row from the table and then clear the Sport filter.513Add Gradient Fill Orange Data Bars to the range A14:A19. Add conditional formatting to the range G14:G19 so that the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table by Item # from Smallest to Largest.314Display the Inventory Summary sheet. In cell B4, enter a formula that references cell B4 in the Seattle Inventory sheet so that the Seattle Total Items in Stock displays in cell B4. In cell B5, enter a formula that references cell B5 in the Seattle Inventory sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7, and B8, enter similar formulas to reference the Median Price, Lowest Price, and Highest price in the Seattle Inventory sheet.515In cell C4, enter a formula that references cell B4 in the Denver Inventory sheet so that the Denver Total Items in Stock displays in cell C4. In cells C5, C6, C7, and C8, enter similar formulas to reference the Average Price, Median Price, Lowest Price, and Highest price in the Denver Inventory sheet.516On the Annual Expenses sheet, construct formulas to calculate Totals by Quarter in the range B10:E10 and the Annual Totals in the range F5:F10. Apply the Total cell style to the Totals by Quarter (B10:F10), and then center the column headings (B4:G4) and apply the Heading 4 cell style.517Using absolute cell references as necessary, in cell G5, construct a formula to calculate the % of Total by dividing the Sales Expense Annual Total by the Annual Totals by Quarter. Fill the formula down through the range G6:G9.218Using the data in the nonadjacent ranges B4:E4 and B10:E10, insert a Line with Markers chart. Position the upper left corner of the chart slightly inside the upper left corner of cell A12. Change the height of the chart to 1.75 inches and the width of the chart to 8 inches.Note, Mac users, change the height of the chart to 1.5 inches.619Apply chart Style 7. Change the chart title to 2016 Direct Expenses. Edit the Vertical (Value) Axis so that the Minimum is 8000000 and the Major unit is 1000000.420Use Format Painter to copy the formatting from cell A2 to A20. In cell B23, enter a formula that references the value in cell F10.221Using absolute cell references as necessary, in cell C23, construct a formula to calculate the projected expenses for 2018 after the Forecasted increase in cell B21 is applied. Fill the formula through cell F23.422Display the Sales Reps sheet. By using Flash Fill and deleting columns as necessary, place the last names in column A and the first names in column B. Widen both columns to 100 pixels, and then merge and center the title Sales Reps across the two columns. Apply the Heading 1 cell style to the title.Note, Mac users, select the range A2:A8 and, on the Data tab, click Text to Columns. Use Comma as the delimiter and accept the remaining default options. Change the width of the columns to 100 pixels and continue with the instructions.423Select the Net Sales, Seattle Inventory, Denver Inventory, Annual Expenses, and Sales Reps sheets. Change the Orientation to Landscape, center the worksheets Horizontally, and insert a footer in the left section with the file name.124Ensure that the worksheets are correctly named and placed in the following order in the workbook: Net Sales by State; Net Sales; Seattle Inventory; Denver Inventory; Inventory Summary; Annual Expenses; Sales Reps. Save the workbook. Close the workbook and then close Excel. Submit the workbook as directed.0Total Points100