Technology | Graded Assignment | Mobsters 4 Graded Assignment Mobsters 4 (20 points) You are nearing the end of your internship with the FBI. In this assignment, you are going to re-partition your data in your mobster spreadsheet. Start with the spreadsheet you submitted for the previous assignment, Mobster_3_Your_Name and save it as Mobster_4_Your_Name. 1. Create three new sheets. Name the original sheet Source Data. Name the remaining sheets By Mobster, By Crime, and Other. 2. Cut and paste the Analysis by Mobster table to the By Mobster tab. 3. Cut and paste the Analysis by Crime table to the By Crime tab. 4. Move the general questions/answers into the Other tab. Suggestion: Consider selecting your table by selecting the entire columns (use the column headers) and you’ll see the cell width formats move with the copy! Submit your spreadsheet, making sure it meets the guidelines below. 4 sheets total in the spreadsheet Mobster data in the Mobster tab Crime data in the Crime tab Other data in the Other tab Total Points © 2013 K12 Inc. All rights reserved. Copying or distributing without K12’s written consent is prohibited. Points Possible 5 5 5 5 20 Points Earned Page 1 of 1 Technology | Graded Assignment | Mobsters 2 Graded Assignment Mobsters 2 (20 points) In this assignment, you are going to add filtering to the spreadsheet you used in the previous assignment to answer the questions below. Save this assignment document as Mobsters_2_Your_Name. Open the spreadsheet Mobster_1_Your_Name. Highlight cells B2:D165 and apply the Auto Filter command. Answer the following questions, using the filter commands. Remember to Select All after you answer each question, so all of the data is included in the next filter. 1. 2. 3. 4. How many crimes were committed during the month of October? How many crimes were committed during the month of June that were extortion? How many crimes were committed that had a take of less than $60,000? How many extortion crimes were committed by mobsters whose last name starts with B? Submit the answers to your teacher. Question correct (5 points for each question) Total Points © 2013 K12 Inc. All rights reserved. Copying or distributing without K12’s written consent is prohibited. Points Possible 20 20 Points Earned Page 1 of 1 Technology | Graded Assignment | Mobsters 3 Graded Assignment Mobsters 3 (20 points) In this assignment, you are going to add conditional formatting to the spreadsheet you used in the previous two assignments. Open the spreadsheet Mobsters_1_Your_Name, and save it as Mobsters_3_Your_Name. 1. Add row shading to the Mobster Activity by Date table similar to how we described it for the ledger. Have every other row have a subtle coloring format, using a color of your choice. 2. Add conditional formatting to the Analysis by Mobster table to highlight all payouts greater or equal to $3,000,000 in one color and payouts greater or equal to $4,000,000 in a different color. (Hint: You will only be adding formatting to Column H.) Make sure your document meets the assignment goals below and submit it to your teacher. Ledger formatting correct for the left table Formatting for $3M and $4M correct for the middle table Total Points © 2013 K12 Inc. All rights reserved. Copying or distributing without K12’s written consent is prohibited. Points Possible 10 10 20 Points Earned Page 1 of 1 Technology | Graded Assignment | Mobsters 4 Graded Assignment Mobsters 4 (20 points) You are nearing the end of your internship with the FBI. In this assignment, you are going to re-partition your data in your mobster spreadsheet. Start with the spreadsheet you submitted for the previous assignment, Mobster_3_Your_Name and save it as Mobster_4_Your_Name. 1. Create three new sheets. Name the original sheet Source Data. Name the remaining sheets By Mobster, By Crime, and Other. 2. Cut and paste the Analysis by Mobster table to the By Mobster tab. 3. Cut and paste the Analysis by Crime table to the By Crime tab. 4. Move the general questions/answers into the Other tab. Suggestion: Consider selecting your table by selecting the entire columns (use the column headers) and you’ll see the cell width formats move with the copy! Submit your spreadsheet, making sure it meets the guidelines below. 4 sheets total in the spreadsheet Mobster data in the Mobster tab Crime data in the Crime tab Other data in the Other tab Total Points © 2013 K12 Inc. All rights reserved. Copying or distributing without K12’s written consent is prohibited. Points Possible 5 5 5 5 20 Points Earned Page 1 of 1 Technology | Graded Assignment | Mobsters 2 Graded Assignment Mobsters 2 (20 points) In this assignment, you are going to add filtering to the spreadsheet you used in the previous assignment to answer the questions below. Save this assignment document as Mobsters_2_Your_Name. Open the spreadsheet Mobster_1_Your_Name. Highlight cells B2:D165 and apply the Auto Filter command. Answer the following questions, using the filter commands. Remember to Select All after you answer each question, so all of the data is included in the next filter. 1. 2. 3. 4. How many crimes were committed during the month of October? How many crimes were committed during the month of June that were extortion? How many crimes were committed that had a take of less than $60,000? How many extortion crimes were committed by mobsters whose last name starts with B? Submit the answers to your teacher. Question correct (5 points for each question) Total Points © 2013 K12 Inc. All rights reserved. Copying or distributing without K12’s written consent is prohibited. Points Possible 20 20 Points Earned Page 1 of 1 Technology | Graded Assignment | Mobsters 3 Graded Assignment Mobsters 3 (20 points) In this assignment, you are going to add conditional formatting to the spreadsheet you used in the previous two assignments. Open the spreadsheet Mobsters_1_Your_Name, and save it as Mobsters_3_Your_Name. 1. Add row shading to the Mobster Activity by Date table similar to how we described it for the ledger. Have every other row have a subtle coloring format, using a color of your choice. 2. Add conditional formatting to the Analysis by Mobster table to highlight all payouts greater or equal to $3,000,000 in one color and payouts greater or equal to $4,000,000 in a different color. (Hint: You will only be adding formatting to Column H.) Make sure your document meets the assignment goals below and submit it to your teacher. Ledger formatting correct for the left table Formatting for $3M and $4M correct for the middle table Total Points © 2013 K12 Inc. All rights reserved. Copying or distributing without K12’s written consent is prohibited. Points Possible 10 10 20 Points Earned Page 1 of 1 Technology | Graded Assignment | Mobsters 4 Graded Assignment Mobsters 4 (20 points) You are nearing the end of your internship with the FBI. In this assignment, you are going to re-partition your data in your mobster spreadsheet. Start with the spreadsheet you submitted for the previous assignment, Mobster_3_Your_Name and save it as Mobster_4_Your_Name. 1. Create three new sheets. Name the original sheet Source Data. Name the remaining sheets By Mobster, By Crime, and Other. 2. Cut and paste the Analysis by Mobster table to the By Mobster tab. 3. Cut and paste the Analysis by Crime table to the By Crime tab. 4. Move the general questions/answers into the Other tab. Suggestion: Consider selecting your table by selecting the entire columns (use the column headers) and you’ll see the cell width formats move with the copy! Submit your spreadsheet, making sure it meets the guidelines below. 4 sheets total in the spreadsheet Mobster data in the Mobster tab Crime data in the Crime tab Other data in the Other tab Total Points © 2013 K12 Inc. All rights reserved. Copying or distributing without K12’s written consent is prohibited. Points Possible 5 5 5 5 20 Points Earned Page 1 of 1
Purchase answer to see full attachment