GAZI UNIVERSITY INFORMATION PACKAGE - 2019 ACADEMIC YEAR

COURSE DESCRIPTION
EXCEL AND SPSS APPLICATIONS BASIC STATISTICS/1310019
Course Title: EXCEL AND SPSS APPLICATIONS BASIC STATISTICS
Credits 3 ECTS 6
Course Semester 1 Type of The Course Elective
COURSE INFORMATION
 -- (CATALOG CONTENT)
 -- (TEXTBOOK)
 -- (SUPPLEMENTARY TEXTBOOK)
 -- (PREREQUISITES AND CO-REQUISITES)
 -- LANGUAGE OF INSTRUCTION
  Turkish
 -- COURSE OBJECTIVES
 -- COURSE LEARNING OUTCOMES
STUDENTS ACCOMPLISHED THIS COURSE explain the basic statistical concepts, correlation coefficients,
organize the data in SPSS programme,
calculate some statistical parameters by using SPSS,
calculate the correlation coefficients and interpret them SPSS outcome.
 -- MODE OF DELIVERY
  face to face
 --WEEKLY SCHEDULE
1. Week  Introduction of the course. Introduction of SPSS and EXEL and basic application. The importance of quantitative research in education
2. Week  Test application in SPSS
3. Week  Split-File, Select Case, Compute, Recode Commands and applications in SPSS
4. Week  Population, Sample, Variable, qualitative variable, quantitative variable/ numeric variable, continuous variable, discrete variable, dependent variabl
5. Week  Mean, Median, Mode, Variance, Standard deviation, Range, Skewnes and Kurtosis
6. Week  SPSS and EXEL applications about Mean, Median, Mode, Variance, Standard deviation, Range
7. Week  Midterm exam
8. Week  Correlation coefficients and hypothesis tests of them
9. Week  V correlation coefficients
10. Week  Gamma correlation coefficients
11. Week  Eta correlation coefficients
12. Week  Correlation
13. Week  General application of correlation coefficients
14. Week  Final Exam
15. Week  
16. Week  
 -- TEACHING and LEARNING METHODS
 -- ASSESSMENT CRITERIA
 
Quantity
Total Weighting (%)
 Midterm Exams
0
40
 Assignment
0
0
 Application
0
0
 Projects
0
0
 Practice
0
0
 Quiz
0
0
 Percent of In-term Studies  
40
 Percentage of Final Exam to Total Score  
60
 -- WORKLOAD
 Activity  Total Number of Weeks  Duration (weekly hour)  Total Period Work Load
 Weekly Theoretical Course Hours
14
3
42
 Weekly Tutorial Hours
0
 Reading Tasks
14
3
42
 Searching in Internet and Library
14
4
56
 Material Design and Implementation
0
 Report Preparing
0
 Preparing a Presentation
0
 Presentation
0
 Midterm Exam and Preperation for Midterm Exam
1
1
1
 Final Exam and Preperation for Final Exam
1
1
1
 Other (should be emphasized)
0
 TOTAL WORKLOAD: 
142
 TOTAL WORKLOAD / 25: 
5.68
 Course Credit (ECTS): 
6
 -- COURSE'S CONTRIBUTION TO PROGRAM
NO
 PROGRAM LEARNING OUTCOMES
1
2
3
4
5
1Improves, deepens and uses knowledge in the field of education with science-related theories, laws, cases, models and concepts.X
2integrates the knowledge about science and science education with the information coming from different disciplines functionally.X
3exposes a problem situation in the field of science education, develops solutions by using quantitative and qualitative research methods, collects data for it, analyzes and reports data by using appropriate techniques.X
4follows the literature related to science and science education, the current debates, projects and developments critically, and applies a lifelong learning policy to real life.X
5shares the findings of studies in the field of science education at the national and international level in an oral and written way.X
6uses computer software, information and communication technologies at advanced level in order to get and share knowledge about his/her area.X
7interprets national strategies, policies and implementation plans about science education and evaluates the results obtained.X
8conducts research considering social, scientific and ethical values.X
9uses a foreign language to follow the international literature, to share and report oral and written information about his/her area.X
10conducts studies related to science education as an individual or takes responsibility in a team work.X
 -- NAME OF LECTURER(S)
   (Prof. Dr. İlbilge DÖKME)
 -- WEB SITE(S) OF LECTURER(S)
   (http://websitem.gazi.edu.tr/site/ilbilgedokme)
 -- EMAIL(S) OF LECTURER(S)
   (ilbilgedokme@gazi.edu.tr)