Excel and statistics for teachers - Part 1

Problem 1 : How should a teacher use excel for class evaluation and statistics?

Download two files (excel_start and excel_1) from http://prekladani.capsa.cz/, Folder PCSkills.
The "start" file shows erratic notes on Ss results, saved in WORD.

Task 1 - Editing
Follow the instructions in the word file - your task is to create a highly practical list of students ond their results in Excel format.

TIPS:

1. Consider which headings are missing, and add them.
2. Order the students alphabetically.
3. Find out how to transfer the sheet from word to excel without too much work :)

Task 2 - Statistics

1. Prepare some statistics – AVERAGE results of each test, of each student, the best and the worst mark of each test (MAX, MIN) and of each student.
2. Find out what MODE and MEDIAN mean. Use them.
3. Use the form COUNTIF for finding how many Ss got 1 during the whole term.
4. Express some of your statistical data in graphical forms. Which types of graphs should you use?

INSERT THE FINAL EXCEL FILE INTO YOUR WEBPAGE!

___________________________________

Problem 2 - Getting research data from online questionnaires

Choose a topic you are interested in; your research field is learning and teaching languages.
Formulate a Research Question or Hypothesis: e.g. "The commuting students have better study results."

Prepare several  survey questions to get data which will help answering your Research Question or confirm your Hypothesis. Include also questions mapping the profile of your respondents (age, field of study...). Write the questions into a text editor, reconsider and reedit.

Go to http://oursurvey.biz/, login.
Put the questions online using survey.biz.
Publish the link in your website - and in the comment to this blog.

Choose a real, interesting topic, be considerate! This task is not meant to become a mock-research. Try to imagine a topic you could develop into a bachelor thesis.


Go to each other's sites and answer the questions. Ask friends (best by email) to fill in your online questionnire. Each of you should have at least 25 respondents.

Prepare an attempt of 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