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






(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.




(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.


Column Graph Representing the Amount of Native Spanish Speakers in the World. Based on 7 Billion People (World Population Total)







Line Graph Representing the Amount of Native Spanish Speakers in the World. Based on 7 Billion People (World Population Total)







(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. By studying these GRE vocabulary words, which can be a cognate or a false cognate for a Spanish vocabulary word? 


In the column to the right (C), please state COGNANT/FALSE COGNANT or NEITHER. In column D, please justify your answer.




    2. Please click the small arrow by the word, "word" and select "descending order", since the words beginning with x,y,z are rarely viewed. Select the "contains" option and enter any suffix (-ate, -tion, -ous). With your new list of words, how  can you find out how many words begin with a vowel and how many begin with a consonant? How can you determine if you list has more first letter consonant words (cap) or first letter vowel words (eat) ?



\








The reason for doing this activity is to be able to see that many of the words used in the GRE are not words that begin with vowels, words that we are very accustomed to seeing and reading.












In Class Pollution Graph- Sara Rowe







30 Year Loan Interest Graph- Sara Rowe




 
Ĉ
Sara Rowe,
Nov 22, 2012, 11:18 PM
Ĉ
Sara Rowe,
Nov 22, 2012, 10:23 AM
Comments