Psych 3LL3E
General Experimental Psychology Laboratory
(Fall 1999)
INSTRUCTORS:
TUTORIAL LEADERS:
OFFICE HOURS:
Room 145 or 146, Psychology Building, Ext. 24824
- Vicki LeBlanc: Tuesdays 3-4 pm
- Chan Kulatunga-Moruzi: Thursdays 2-3 pm
COURSE BULLETIN BOARD
CLASS NOTES
Module 1, Drs. Norman and Sun
1st week, Sept 15, 1999
Introduction to the course: Dr. Brooks, Psychology building Room 155
Lecture by Dr. Norman, Psychology building Room 155
Excel Tutorials by Dr. Hongjin Sun, Burke Science Bldg. (BSB) Room 244
- Lecture: Excel Basics
- Hand-on Excel Exercise 1 (file name: exercise1.xls). There are three ways to access to the file:
- You can also download the excel version of this exercise
- point your mouse to the link, click the right button of your mouse and then
- choose Save Target As... (in Internet Explore), or
- choose Save Link as... (in Netscape)
- You can open the file from a campus computer, e.g. a computer in BSB 244/245
- logon (you have to have a CIS lab account to do this, if not, see http://www.mcmaster.ca/dataserv-htm/mcss0001.htm)
- double click on My Computer icon on top left corner of your screen
- double click on driver K: [possibly labelled as: Course$ -n 'Bsbs1' (K:)]
- double click on folder: psyc 3LL3e folder
- double click on icon: exercise1.xls (will open both excel program and the file)
- You can also view the data for exercise 1 on the web
2nd week, Sept 22, 1999
Lecture by Dr. Norman (PC 155)
Excel Tutorials by Dr. Hongjin Sun (BSB 244)
- Continuation of lecture in the 1st week
- formulas and functions
- relative and absolute addresses
- creating graph
- Histogram
- Classroom exercise 2
- Take a look at the question and then
- Download the data file (in excel format, file name: exercise2.xls) for this exercise,
- Tips for this exercise
3rd week, Sept 29, 1999
Lecture by Dr. Norman (PC 155)
Excel Tutorials by Dr. Hongjin Sun (BSB 244)
Demo
- running statistical tests in excel (see demo file)
Classroom exercise 3
- Take a look at the question and then
- Download the data file (in excel format, file name: exercise3.xls) for this exercise
- Tips for this exercise
- Description in Word or in Word Perfect file
- Please note that this is a revised version of the description (available at 2 pm on Sept 30, 1999). The few words that were modified (from the previous file) were displayed in bold, italic and underline font.
- data (in excel format)
Module 2, Dr. Hong-Jin Sun
1st week, Oct 6, 1999
Introduction to the project (PC 155)
Perform the experiment and collect the data (BSB 244)
2nd week, Oct 13, 1999
Data analysis Tutorials (BSB 244)
- Reformat the data
- Pivot table
- Statistical tests and plots
3rd week, Oct 20, 1999
How to write a lab report (PC 155)
Experimental Design issues (PC 155)
MIDTERM, SAMPLE QUESTIONS
Module 3, Dr. Lee R. Brooks
Module 4, Drs. Norman & Brooks