Difference between revisions of "ICT student textbook/Spreadsheet for data analysis"
Jump to navigation
Jump to search
m (1 revision imported: from troer) |
|||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{Navigate|Prev= | + | {{Navigate|Prev=Data representation and processing level 3|Curr=Spreadsheet for data analysis|Next=Multi page text document}} |
| − | + | ||
| − | ''' | + | '''<u><big>{{font color|brown|Analyzing data with spreadsheets}}</big></u>'''<br> |
| + | '''In this activity, you will have large data sets on different items and you will learn methods of analyzing with spreadsheets.''' | ||
<div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;"> | <div class="noprint" style="float:right; border:1px solid blue;width:300px;background-color:#F5F5F5;padding:2px;"> | ||
{| cellspacing="0" | {| cellspacing="0" | ||
| [[File:Book.jpg|none|80px|Book image]] | | [[File:Book.jpg|none|80px|Book image]] | ||
| − | | style="padding-left:2px;"| Go to <br/> [[ICT teacher handbook/Audio visual communication|Teacher | + | | style="padding-left:2px;" | Go to <br /> [[ICT teacher handbook/Audio visual communication|ICT Teacher Handbook]] |
|}</div> | |}</div> | ||
===Objectives=== | ===Objectives=== | ||
| − | # | + | #Using a spreadsheet for data analysis |
| − | #Analyzing data and representing using charts and graphs | + | #Being able to identify how to group and view data |
| + | #Analyzing data and representing using charts and graphs; understanding what to analyze in a given data set | ||
| + | #Understanding the meaning of average, percentage difference, percentage share, growth rates, minimum and maximum and other such functionalities. | ||
| + | #Learning the use of different functionalities in spreadsheet for numerical analysis | ||
===What prior skills are assumed=== | ===What prior skills are assumed=== | ||
#Familiarity with ICT environment | #Familiarity with ICT environment | ||
| − | #Using spreadsheet | + | #Understanding of data organization |
| + | #Using spreadsheet for data inputs | ||
| + | #Making charts in spreadsheet | ||
| + | ===What resources do you need=== | ||
| + | # Working computer lab with [[Explore a computer|projector]] | ||
| + | # Computers installed with [[Learn Ubuntu|Ubuntu Operating System]] | ||
| + | #Student generated data sets | ||
| + | #Secondary data sets | ||
| + | #Handout for [[Learn LibreOffice Calc|LibreOffice Calc]] | ||
| + | #Handout for [[Learn LibreOffice Writer|LibreOffice Writer]] | ||
| − | === | + | ===What digital skills will you learn=== |
| + | #[[Learn LibreOffice Calc|Working with spreadsheets]] | ||
| + | #[[Learn LibreOffice Calc|Making plots and graphs]] | ||
| + | ===Description of activity with detailed steps=== | ||
| + | ====Teacher led activity ==== | ||
| + | '''''Analyzing data from tabulated data - Rainfall''''' | ||
| − | # | + | Your teacher will help you analyze the data of rainfall in Telangana, using available data. Click [[:File:Spreadsheet analysis teacher data file.ods|here]] for the file. Look at the data and discuss with your teacher what are the various data measures that can be calculated. For example, some questions from this data can be the following: |
| − | # | + | #What is the maximum rainfall amount? Which year? |
| − | # | + | #What is the minimum rainfall amount? Which year? |
| − | # | + | #What is the average rainfall in the last ten years? |
| + | #Is there any pattern of rainfall? | ||
| + | #Are there other data that you can study along with this data to understand the weather and climate in Telangana? For example, what could be the connection between rainfall data and temperature, crop production or floods? | ||
| + | #Which is the best way to represent this data as a graph? Why? | ||
| + | #What are the additional data sets you would collect? | ||
| + | '''''Analyzing data from tabulated data - Temperature''''' | ||
| − | === | + | Your teacher already discussed the rainfall data with you. You may have wondered about temperature. In the attached file (above), along with Telangana rainfall, you also have details of annual and seasonal, maximum and minimum temperature in India. Look at the data and discuss with your teacher what are the various data measures that can be calculated. Your questions may be: |
| − | + | #What is the maximum temperature by season? Which year was it? | |
| − | + | #Which year had the highest maximum temperature? Is there any connection between the two? | |
| + | #By how much does the maximum temperature vary across seasons? | ||
| + | #What is the difference between maximum and mean temperature? | ||
| + | #Which is the best way to represent this data as a graph? Why? | ||
| + | #What additional data sets would you collect? | ||
| + | #Can you conclude anything from this data set? | ||
| + | |||
| + | <gallery mode="packed" heights="300px" style="text-align:left"> | ||
| + | File:Rainfall data.png | ||
| + | File:Annual and seasonal mean temperature.png | ||
| + | </gallery> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
====Student activities==== | ====Student activities==== | ||
| + | Your teacher would have made different data sets for your analysis. Look in your folder on your computer for these data sets. For each of the data sets, identify how you would like to group the data, what to analyze, what measures are important to calculate (average, percentage share, percentage change, minimum, maximum, etc), and also plot the graphs. | ||
| + | #From time to time, the Indian government conducts census, from time to time, to understand how the population is growing as well as to get some information on how the population is distributed. Would you not like to know about yourself? Check the file [[:File:Simplifed_Census_Data_India_and_Telangana.ods|here]] for the census data. | ||
| + | #Some data on fruits and flowers and some horticulture products grown in India have been compiled across 10 years. Analyze the data for yourself to see how much more you can learn about flowers and fruits! Click [[:File:Spreadsheet analysis student data file.ods|here]] for the file. | ||
| + | #You are so familiar with the cellphone. Would you like to see how India's cell phone use compares with the world. Click [[:File:Mobile Connections Spreadsheet Analysis Student data file.ods|here]] for the file. | ||
| + | #Another interesting data is on the number and types of vehicles on the road in India. See what kinds of analysis is possible with this data. Click [[:File:Spreadsheet analysis student data file.ods|here]] for the file. | ||
===Portfolio=== | ===Portfolio=== | ||
| − | # | + | #In your continuing portfolio, you should create your own spreadsheets with the analysis. |
| − | # | + | #Your portfolio should also include a text document with a written description of the analysis. |
| − | # | + | #Your concept map with highlights of your analysis for presentation. |
| + | |||
| + | [[Category:Level 3]] | ||
| + | [[Category:Data representation and processing]] | ||
Latest revision as of 14:34, 28 June 2017
Analyzing data with spreadsheets
In this activity, you will have large data sets on different items and you will learn methods of analyzing with spreadsheets.
Objectives
- Using a spreadsheet for data analysis
- Being able to identify how to group and view data
- Analyzing data and representing using charts and graphs; understanding what to analyze in a given data set
- Understanding the meaning of average, percentage difference, percentage share, growth rates, minimum and maximum and other such functionalities.
- Learning the use of different functionalities in spreadsheet for numerical analysis
What prior skills are assumed
- Familiarity with ICT environment
- Understanding of data organization
- Using spreadsheet for data inputs
- Making charts in spreadsheet
What resources do you need
- Working computer lab with projector
- Computers installed with Ubuntu Operating System
- Student generated data sets
- Secondary data sets
- Handout for LibreOffice Calc
- Handout for LibreOffice Writer
What digital skills will you learn
Description of activity with detailed steps
Teacher led activity
Analyzing data from tabulated data - Rainfall
Your teacher will help you analyze the data of rainfall in Telangana, using available data. Click here for the file. Look at the data and discuss with your teacher what are the various data measures that can be calculated. For example, some questions from this data can be the following:
- What is the maximum rainfall amount? Which year?
- What is the minimum rainfall amount? Which year?
- What is the average rainfall in the last ten years?
- Is there any pattern of rainfall?
- Are there other data that you can study along with this data to understand the weather and climate in Telangana? For example, what could be the connection between rainfall data and temperature, crop production or floods?
- Which is the best way to represent this data as a graph? Why?
- What are the additional data sets you would collect?
Analyzing data from tabulated data - Temperature
Your teacher already discussed the rainfall data with you. You may have wondered about temperature. In the attached file (above), along with Telangana rainfall, you also have details of annual and seasonal, maximum and minimum temperature in India. Look at the data and discuss with your teacher what are the various data measures that can be calculated. Your questions may be:
- What is the maximum temperature by season? Which year was it?
- Which year had the highest maximum temperature? Is there any connection between the two?
- By how much does the maximum temperature vary across seasons?
- What is the difference between maximum and mean temperature?
- Which is the best way to represent this data as a graph? Why?
- What additional data sets would you collect?
- Can you conclude anything from this data set?
Student activities
Your teacher would have made different data sets for your analysis. Look in your folder on your computer for these data sets. For each of the data sets, identify how you would like to group the data, what to analyze, what measures are important to calculate (average, percentage share, percentage change, minimum, maximum, etc), and also plot the graphs.
- From time to time, the Indian government conducts census, from time to time, to understand how the population is growing as well as to get some information on how the population is distributed. Would you not like to know about yourself? Check the file here for the census data.
- Some data on fruits and flowers and some horticulture products grown in India have been compiled across 10 years. Analyze the data for yourself to see how much more you can learn about flowers and fruits! Click here for the file.
- You are so familiar with the cellphone. Would you like to see how India's cell phone use compares with the world. Click here for the file.
- Another interesting data is on the number and types of vehicles on the road in India. See what kinds of analysis is possible with this data. Click here for the file.
Portfolio
- In your continuing portfolio, you should create your own spreadsheets with the analysis.
- Your portfolio should also include a text document with a written description of the analysis.
- Your concept map with highlights of your analysis for presentation.