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. 

HOMEWORK
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


Students' Questionnaires:
Sůva Michal
http://login.oursurvey.biz/questionnaire-10560

Ondřej Kurz
http://login.oursurvey.biz/dotaznik-10538

Bláhová Zuzana
http://login.oursurvey.biz/dotaznik-10552

Robert Sluka
http://login.oursurvey.biz/dotaznik-10557

Lucie Salačová
http://login.oursurvey.biz/dotaznik-10553

Veronika Gunárová
http://login.oursurvey.biz/dotaznik-10555

Richard Záhrobský
http://login.oursurvey.biz/dotaznik-10559

Pospíšilová
http://login.oursurvey.biz/dotaznik-10558

Karolína Birnerová
http://login.oursurvey.biz/dotaznik-10554 

Krausová Zuzana
http://login.oursurvey.biz/questionnaire-10550

Philip Rudorfer
http://login.oursurvey.biz/dotaznik-10534

Josefína Juhasová
http://login.oursurvey.biz/questionnaire-10556