Excel for Teachers

Problem One: How can you share one (rather large) file with more people,
especially if you do not know all their email addresses?

Possibilities:
capsa.cz
dropbox.com


Problem Two: 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.

Tasks:

1. Consider which headings are missing, and add them.
2. Order the students alphabetically.
3. 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.
4. Find out what MODE and MEDIAN mean. Use them.
5. Use the form COUNTIF for finding how many Ss got 1 during the whole term.
6. Express some of your statistical data in graphical forms. Which types of graphs should you use?

HOMEWORK:

Find out how to create contents (obsah) in a Word file, e.g. a diploma thesis.