Excel for students

1. Basic statistical analysis is something every university student and every shool teacher should master. Let's work with a typical situation first, to organise our data, and then we will see what they tell us.

TASK 1
Download the file Excel_start.doc from http://prekladani.capsa.cz/.
The tasks are described in the file.


2. Co to je směrodatná odchylka?
Přečtěte si krátký článek a vypočtěte směrodatnou odchylku vybrané skupiny dat (např. známky jednoho studenta, známky z jednoho testu).

3. To be able to analyse data, first we have to get them. 

TASK 2
Go to http://oursurvey.biz/, login.
Choose a topic you are interested in; your research field is learning and teaching languages.
Prepare 3-5 survey questions and put them online using survey.biz.
Publish the link in your website - and in the comment to this blog.
Go to each other's sites and answer the questions. Prepare statistical survey for the next lesson.

Example of a link:
http://login.oursurvey.biz/dotaznik-8581
Example of exported results in capsa - ResearchResults.docx.
Example of survey in capsa - ResearchReport_2013_10_06.docx

Tips for making a valid questionnaire:
- think first; imagine what your respondents could answer
- be clear
- ask about one issue only in a single question

- avoid open-ended (txt) questions - prefer multiple choice
- be consistent - focus on a single topic or problem
- avoid spelling mistakes
- avoid ambiguous questions