Assignments‎ > ‎

12-Spreadsheets

(1) Using Existing Spreadsheets

  • Watch video part 1- Using an Existing Spreadsheet (17 minutes) - make sure to watch full screen!
  • Use Microsoft Excel or other spreadsheet program to analyze the file entitled budget.xls. Assume that one of the wage-earners in this family looses his or her job. Create a second budget that shows "reasonable" cuts that may be made to balance the family budget. Include a printout of the budget

For this assignment I made some drastic, and some hopeful, reductions to the budget:
As you can see, I cut out much at the bottom. Of course this is only advisable if the IRA does not have a monthly minimum contribution. This is also only possible if the mortgage can be refinanced.

Before Revised
Mortgage 1055 800
Insurance 75 75
Property taxes 100 100
Life 80 80
Auto 110 55
Homeowners 40 40
Medical 110 110
Ford-gas 60 40
Ford-payment 147 147
Ford-repair 40 40
Van-gas 70 0
Van-repair 25 0
Groceries 360 250
Gas & Electric 140 140
Telephone 45 45
Water 30 25
Garbage 15 15
Vacation Savings 100 0
Miscellaneous 350 0
Church/charity 360 0
Clothing 125 0
Pocket Money 70 10
IRAs 333 0
Entertainment 110 0



(2) Creating Spreadsheets

  • Watch video part 2- Developing a Spreadsheet (21 minutes) - make sure to watch full screen!
  • Create a new spreadsheet file or a new worksheet in an existing educational spreadsheet file. Your worksheet should include a variety of calculations based upon cells in your new worksheet and/or associated ones in your modified spreadsheet file. Include a printout of your new spreadsheet in your portfolio.

For this assignment, I took data from the U.S. Census on the number of speakers of Indigenous Languages. Since these are endangered languages, the numbers are quite small. I calculated the percentage of each language population over the total number of speakers of indigenous languages in the US. I also calculated the percentage of each group from the total US Population. The spreadsheet is posted below (google docs):

Native American Languages Spreadsheet



(3) Graphing Data

  • Watch video part 3- Graphing Data (27 minutes) make sure to watch full screen!
  • Graph and chart creation and interpretation are part of the academic language of many subjects. Create two or more graphs (charts) from a spreadsheet files related to your discipline. Make sure the graphs are meaningful and are fully and correctly labeled. Include a screen-shot of the graph in your portfolio and explain its significance.

For this assignments, I graphed data from the spreadsheet that I created in 2 above.
I also have examples of graphs made from spreadsheets in my thesis posted in the File Cabinet. Since the topic is populations of speakers of a language, pie charts made the most sense as a representation of the data. 

Chart 1 is of the percent of speakers of an indigenous language in the US out of all speakers of indigenous languages.


Chart 2 looks at how many speaker os indigenous languages in the U.S. live on reservations.


_______________________________________________________________________________________

(4) Electronic Spreadsheets in Teaching

  • Develop two questions that can be answered from a spreadsheet file in your field. Chose another field if there are no relevant files posted. Include screen captures that show the answers to these questions as calculated by the spreadsheet program.

1. Endangered languages disappear everyday around the world. The size of the population of native speakers is a factor in the survival of an endangered language. Using the spreadsheet in No. 2 above, compare the population size of Navajo, Dakota, Cherokee, and Apache with Cocomaricopa, Cahuila, Wichita, and Mono. 
What role do you think these languages' population size has on their futures?

Answer: Navajo, Dakota, Cherokee, and Apache have large populations as compared to Cocomaricopa, Cahuila, Wichita, and Mono. The languages with larger population populations have a better chance of maintaining their speech community.

2. Look at the percent of speakers that live on the reservation. What role do you think having a cohesive speech community has? What languages have the most cohesive speech communities?

Answer: Caddo, Chatemacha, Osage, and Jicarilla are at the top of the list.  These languages have a better chance of maintaining their language than other languages with similar number of speakers. Here is a screen grab of the sorted chart:




Comments