Join our WikiEducator discussion group or Register now for free skills training

Analyzing Data

From WikiEducator

Jump to: navigation, search

Contents

ANALYSING DATA USING COMPUTER


Objectives

After going through this module and working out the activities given you will be able to use computer programmes for analysing large quantities of data which includes the following:

  1. Creating necessary worksheets
  2. Entering data
  3. Analysing data
  4. Creating graphs


We have already seen how data tables are created. Sometimes the data encoded in a table may have to be analysed for understanding a particular event. For example, we would like to know the achievement of the students of the district in the KSQAO tests. We would like to know the percentage of students who have not mastered even 40% of the competencies prescribed. How do we come to know of these? The computers provide a unique facility of analysing large quantities of data in a very short period of time. For preparing data sheets and analysing data we can use spreadsheets in excel or any other package like SPSS or Statistica. Through computers we will be able to merge all data regarding different aspects into one file and take up analysis in a very comprehensive way. Thus profiles of teachers in the district, the nature of student population, the rate of absenteeism, student enrolment etc can be keyed into the computer and analysed. Handling large quantities of data is no problem at all.

Creating Worksheets

Know how to create a worksheet by reading this attachment

  1. Creating Worksheets

In this section you will be introuduced to different ways of analysing data and interpretting the same. Keeping the requirements of DIETs, you will also work out some exercises to get a first hand experience of analysing data using the computer.

Analyzing Data

The link below will take you to a website which has a lot of information on using excel programme for analysing data. Please browse the site. [1]

Please see the following website for analysis of qualitative data [2]

Coding and analysis of Focus Group Discussion data [3]

You can join some online courses for learning more about data analysis. Search the web for the same. You can have a look at the following link. [4]

You can use the following link to know more about statistical analysis [5]

Send the Completed Activity Sheet to:

bhatvd@yahoo.co.in


Activity

Activity

Enter the scores of D Ed students in a worksheet and find out the average performance of students in your subject.

Find out by using 'help' how to proceed with further analysis of data.

Make a list of different analysis for which you can use MS Excel.





Personal tools