Changes

Jump to navigation Jump to search
m
Line 61: Line 61:  
While conducting the action research, you will collect data from your observations, interviews, group discussions etc. You may even conduct a survey. Quantitative  data collected from the action research can be tabulated and analysed using the spreadsheet software, such as [[Learn LibreOffice Calc|LibreOffice Calc]].
 
While conducting the action research, you will collect data from your observations, interviews, group discussions etc. You may even conduct a survey. Quantitative  data collected from the action research can be tabulated and analysed using the spreadsheet software, such as [[Learn LibreOffice Calc|LibreOffice Calc]].
   −
Supposing you have conducted a survey and gathered responses from your classmates or teachers or community members on a topic. You may have closed ended questions, requiring respondents to select one of multiple choices. You can record this information in a spreadsheet, using one column for one data element. For instance, the name of the respondent can be one column, demographic information (age, sex, religion etc) can be entered, one element per column. Responses chosen in closed ended questions can be entered, one question/response per column.
+
Supposing you have conducted a survey and gathered responses from your classmates or teachers or community members on a topic. You may have closed ended questions, requiring respondents to select one of multiple choices. You can record this information in a spreadsheet, using one column for one data element. For instance, the name of the respondent can be one column, demographic information (age, sex, religion etc) can be entered, one element per column. Responses chosen in closed ended questions can be entered, one question/response per column. Hence as many rows will be populated as there are records from the research.  
   −
This can be analysed using the 'Pivot Table' feature of the spreadsheet, to derive multi-variate tables.
+
This can be analysed using the '[https://dwmallisk.blogspot.in/2015/01/using-libreoffice-calc-to-create-pivot.html Pivot Table]' advanced feature of the spreadsheet, to derive multi-variate tables. If the Pivot table seems too complex to use, simple formulae for 'sum', 'count' can be used in the sheet to calculate the sum of amount fields and count of amount or text fields in the data. You can also generate graphs and charts of the data using Calc.
    
(images xxx-  
 
(images xxx-  

Navigation menu