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