Question
Instructions: Copy and paste the formulas below in the respected columns in excel and click enter. This should flow all the way down the rows
Instructions:Copy and paste the formulas below in the respected columns in excel and click enter. This should flow all the way down the rows once entered but if not, highlight and drag the cursor down until you get to row 56.
Calculation of venison meat: Q. 9 & 10
Total Meat Produced in 2012 (Insert into F2): =(B2*59)+(C2*85)+(D2*32.5)+(E2*60)
Total Meat Produced in 2013 (Insert into K2): =(G2*59)+(H2*85)+(I2*32.5)+(J2*60)
Total Meat Produced in 2014 (Insert into P2): =(L2*59)+(M2*85)+(N2*32.5)+(O2*60)
Total Meat Produced in 2015 (Insert into S2): =(Q2*85)+(R2*60)
Total Meat Produced in 2016 (Insert into V2): =(T2*85)+(U2*60)
Total Meat Produced in 2017 (Insert into Y2): =(W2*85)+(X2*60)
- How much venison meat is produced by Monongalia, Marion, and Preston Counties from 2012?
- Monongalia:
- Marion:
- Preston:
- How much venison meat was produced by Monongalia, Marion, and Preston Counties from 2017?
- Monongalia:
- Marion:
- Preston:
Instructions:To find the total amount of venison meat produced in a given year you will need to go to the bottom row where it says "Total", in each column of the "Total number of Deer Harvested" for each given year. Underneath the last data entered you will highlight the cell, notice that there is an arrow box to the right, click on that then select "SUM" to get the total amount of deer harvested for each year. If you do not have this option type "=SUM()" into that cell and select the whole column of the"Total number of Harvested Deer", close the parentheses then click enter.
- What is the Total meat produced by the state of West Virginia in 2012 to 2017?
Use your data to fill in the table below:
Table 1: Commercially Processed Red Meat in Appalachia
Year | Commercially Processed Red Meat | Total venison meat produced |
2012 | 7,400,000.0 lbs | |
2013 | 7,300,000.0 lbs | |
2014 | 6,700,000.0 lbs | |
2015 | 6,700,000.0 lbs | |
2016 | 7,300,000.0 lbs | |
2017 | 7,900,000.0 lbs |
(Hall, 2020)
- Compare your answers from question 11 to the total amount of beef produced by conventional methods between 2012 to 2017 (Table 1). Has the meat produced by both of these methods increased or decreased since 2012?
- Was your original hypothesis (question 9) supported by the data?
Instructions:Now to graph the total number of deer harvested in WV Counties we need to be in the "Total Deer Harvested" tab in excel sheet in the dataset for the next set of questions.
- Provide a graph of the total deer harvested of 2012 of all WV Counties. Expand the graph since they are 55 counties in the state.
Paste Graph Here
- Provide a graph of the total deer harvested of 2017of all WV Counties. Expand the graph since they are 55 counties in the state.
Paste Graph Here
Part C. Hunting in the Arctic. Indigenious people's way of life in the Arctic and conflicts with Food Security.
Instructions:Go to the Solutions Journal site on "The Continued Importance of Hunting for Future Inuit Food Security" here: https://www.thesolutionsjournal.com/article/continued-importance-hunting-future-inuit-food-security/ and read to answer the following questions
- What are the listed limitations for agricultural food production for Indigenious communities in the Arctic?
- What are the six themes for improving food security that the Nunavut Food Security Coalition identified?
- What is the difference in price to feed a family of four in Northern Canada compared to Southern Canada?
- What was one of the listed on the "on-the-land programs" that have been developed to support hunting knowledge sharing within communities?