Graphs and Groups

Task 1
Excel: Which types of graphs should be used for which types of data?

Task 2
become a member of this group:
http://groups.google.com/group/pcskills-ujep

Visit the Discussion, and present your blog URL there. Visit your friends' blogs!

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.

Project Checklist

Here you can check whether your project site features all requested items. The structure of the web remains free, it is you decisiona nd responsibility to make it user-friendly!

BTW, haven't you forgotten about your personal blog?

WEB SITE
1. personal information - with sufficient safety precaution!
2. Hot Potatoes index page or spot, with information about the target group, topic, objectives, links to the all three exercises
3. three interlinked HP exercises - practicing THE SAME 10 vocabulary items!
4. a page focused on a topic of your choice - preferably something you are good at; avoid the primitive pasting of information from other sites! write about your hobby, experience, share what you know and the others don't.
5. a gallery - 12 images (of your hometown) you shot yourself, with self-recorded audio comment
6. link to your personal blog an dother useful links (e.g. the class blog, reliable sites focused on teaching English, dictionaries...)
7. references (links to data and graphics you used)