The Hebrew University Logo
Syllabus COMPUTERS IN SOCIAL RESEARCH (SPSS+EXCEL) - 51108
עברית
Print
 
close window close
PDF version
Last update 26-09-2016
HU Credits: 2

Degree/Cycle: 1st degree (Bachelor)

Responsible Department: psychology

Semester: 1st Semester

Teaching Languages: Hebrew

Campus: Mt. Scopus

Course/Module Coordinator: Dr. Benjamin Czaczkes

Coordinator Email: msbc@mscc.huji.ac.il

Coordinator Office Hours: See Moodle

Teaching Staff:
Dr. Roie Knaanie
Mr. Adi Rivlin

Course/Module description:
Excel
Creating and working with Workbooks, using the ribbon, formatting, Excel functions, statistical data analysis using excel, Graphical information display, moving data to SPSS.
SPSS
Data definition and data file manipulation, missing values, t-test, pairwise t-test, one way analysis of variance, planed contrasts, post hoc analysis, ANOVA, regression analysis, selecting partial data for analysis, creating new variables and changing old variables.

Course/Module aims:
Using excel and SPSS to organize and analyze data

Learning outcomes - On successful completion of this module, students should be able to:
Analyse data using SPSS and Excel
Summarize data using SPSS and Excel
Compute descriptive statistics on numerical data
Classify populations of data
Apply the statistical argument to the outcome of a quantitative investigation
Carry out commonly used bivariate tests of difference
Use the basic form of the general linear model in SPSS and Excel
Use SPSS to conduct T-test, and Analysis of Variance

Attendance requirements(%):
100

Teaching arrangement and method of instruction: Lectures, Lab work

Course/Module Content:
Excel
Creating and working with Workbooks.
using the ribbon.
formatting.
Excel functions. Statistical data analysis.
Graphical information display.
Moving data to SPSS.

SPSS
Data definition.
Data file manipulation. Missing values.
t-test, pairwise t-test, One Way Analysis of Variance.
Contrasts.
Post hoc analysis.
ANOVA.
Regression Analysis.
Selecting partial data for analysis.
Creating new variables and changing old variables.

Required Reading:
None

Additional Reading Material:
None

Course/Module evaluation:
End of year written/oral examination 100 %
Presentation 0 %
Participation in Tutorials 0 %
Project work 0 %
Assignments 0 %
Reports 0 %
Research project 0 %
Quizzes 0 %
Other 0 %

Additional information:
 
Students needing academic accommodations based on a disability should contact the Center for Diagnosis and Support of Students with Learning Disabilities, or the Office for Students with Disabilities, as early as possible, to discuss and coordinate accommodations, based on relevant documentation.
For further information, please visit the site of the Dean of Students Office.
Print