Guidance and Psychological Counseling
Bachelor	Length of the Programme: 4	Number of Credits: 240	TR-NQF-HE: Level 6	QF-EHEA: First Cycle	EQF: Level 6

ECTS Course Information Package

School/Faculty/Institute

Faculty of Education

Course Code

EDS 339

Course Title in English

Computer Programming for Educators (Python)

Course Title in Turkish

Eğitimciler için Bilgisayar Programlama (Python)

Language of Instruction

Type of Course

Flipped Classroom

Level of Course

Select

Semester

Fall

Contact Hours per Week

Lecture: 2

Recitation:

Lab: 2

Other:

Estimated Student Workload

109 hours per semester

Number of Credits

5 ECTS

Grading Mode

Standard Letter Grade

Pre-requisites

None

Co-requisites

None

Expected Prior Knowledge

Basic use of computer and mathematics knowledge

Registration Restrictions

Only Undergraduate Students

Overall Educational Objective

To be equipped with programming skills and knowledge that enhance and support counseling practices.

Course Description

This undergraduate course is tailored for prospective educators and school counselors seeking to develop programming skills specifically designed to enhance educational and counseling practices. Through this course, students will explore the application of programming in educational sciences and counseling, focusing on its potential to enhance their technology and counseling skills in the digital age. Students will engage in hands-on activities and projects, learning programming languages and techniques that enable them to design and develop educational software applications. Emphasis will be placed on creating interactive and engaging learning experiences that foster problem-solving, critical thinking, and creativity among students. By the end of the course, students will possess the necessary programming expertise to create online counseling tools and resources, empowering them to facilitate dynamic and innovative counseling environments for their future clients.

Course Learning Outcomes and Competences

Upon successful completion of the course, the learner is expected to be able to:
1) describe programming languages and tools commonly used in educational contexts
2) apply programming skills to enhance students' counseling skills to support their clients in their counseling journey;
3) utilize programming to create interactive and engaging educational resources that foster problem-solving, critical thinking, and creativity among students;
4) demonstrate skills in utilizing programming to analyze psychoeducational data and make data-driven decisions;
5) exhibit ethical and responsible use of programming in counseling, ensuring privacy, security, and inclusivity;
6) demonstrate effective communication skills in explaining programming concepts and their applications in psychoeducational contexts and;
7) increase clients' awareness of their issues, providing tailored tools in counseling.

Program Learning Outcomes/Course Learning Outcomes	1	2	3	4	5	6	7
1) Scientific competence, knowledge, skills and effective teaching methods and strategies in order to provide psychological help.
2) Knowledge that will enable students to develop the skills to cope with problems they encounter in the school environment.
3) Basic knowledge about developmental processes from early childhood to adulthood and the characteristics and issues unique to each stage.
4) Knowledge about the tools used in school counseling services and being equipped to develop relevant programs.
5) Competence in vocational guidance and counseling practices.
6) Understanding of human relations and interaction.
7) Knowledge, experience and skills in scientific methods in order to conduct research studies in behavioral sciences.
8) Awareness of the necessity of lifelong learning, accessing information, and monitoring developments in education, science, and technology. An ability to solve problems related to the field, continuously developing and renewing oneself, and having critical thinking and questioning skills. An ability to use information technologies.
9) Ability to communicate effectively in both verbal and written Turkish; ability to use English at least in the European Language Portfolio B2 General Level.
10) Knowledge about past and present regulations and legislations regarding professional applications of the field and being equipped to contribute to its further development.
11) Sensitivity for different cultures, values and democratic rights of individuals; the knowledge of national culture and history, and using that knowledge in increasing awareness and involvement in national and international social, cultural, artistic, and technological developments.
12) A sense of professional and ethical responsibility, and awareness of national and universal sensitivity expressed in the Basic Law of National Education.

Relation to Program Outcomes and Competences

N None	S Supportive	H Highly Related

	Program Outcomes and Competences	Level	Assessed by
1)	Scientific competence, knowledge, skills and effective teaching methods and strategies in order to provide psychological help.	H	HW
2)	Knowledge that will enable students to develop the skills to cope with problems they encounter in the school environment.	S	HW
3)	Basic knowledge about developmental processes from early childhood to adulthood and the characteristics and issues unique to each stage.	N
4)	Knowledge about the tools used in school counseling services and being equipped to develop relevant programs.	H	Project
5)	Competence in vocational guidance and counseling practices.	S	HW
6)	Understanding of human relations and interaction.	N
7)	Knowledge, experience and skills in scientific methods in order to conduct research studies in behavioral sciences.	S	Project
8)	Awareness of the necessity of lifelong learning, accessing information, and monitoring developments in education, science, and technology. An ability to solve problems related to the field, continuously developing and renewing oneself, and having critical thinking and questioning skills. An ability to use information technologies.	S	HW
9)	Ability to communicate effectively in both verbal and written Turkish; ability to use English at least in the European Language Portfolio B2 General Level.	S	HW
10)	Knowledge about past and present regulations and legislations regarding professional applications of the field and being equipped to contribute to its further development.	N
11)	Sensitivity for different cultures, values and democratic rights of individuals; the knowledge of national culture and history, and using that knowledge in increasing awareness and involvement in national and international social, cultural, artistic, and technological developments.	N
12)	A sense of professional and ethical responsibility, and awareness of national and universal sensitivity expressed in the Basic Law of National Education.	N

Prepared by and Date	TUNA ÇAKAR , February 2024
Course Coordinator	MELİKE ACAR
Semester	Fall
Name of Instructor	PAKER DOĞU ÖZDEMİR

Course Contents

Week	Subject
1)	Introduction to computer programming
2)	Fundamental concepts for algorithms
3)	Basic programming
4)	Variables
5)	Calculations
6)	Conditionals
7)	Loops
8)	Functions
9)	Methods
10)	Lists
11)	Using numpy for numeric calculations
12)	Using pandas for data tables
13)	Using matplotlib for data visualization
14)	General Review
15)	Final Project
16)	Final Project

Required/Recommended Readings

Python Book for Data Science, Jake VanderPlas https://jakevdp.github.io/PythonDataScienceHandbook/

Teaching Methods

Flipped Learning

Homework and Projects

Laboratory Work

yes

Computer Use

The course heavily requires use of computers, thus students are expected to bring their own computers to use.

Other Activities

Assessment Methods

Assessment Tools	Count	Weight
Attendance	14	% 15
Laboratory	14	% 25
Application	4	% 40
Project	1	% 20
TOTAL		% 100

Course Administration

cakart@mef.edu.tr

1. Active Participation: Student participation in every aspect of the course is essential. Active participation requires attendance, research, reading, reflection, participation in class discussions, sharing observations made in K-12 schools and classrooms, asking questions and giving feedback to students who are making presentations. 2. Attendance: Attendance in class activities is very important. Working collaboratively on projects/research/reports/presentations is an important part of a teacher/counselor's role. Class participation/collaborative produce grades will only be given to students who attend the class and work with their classmates on the projects. 3. Accommodations: Any student needing special accommodations (testing, seating, etc.) must notify the instructor within the first two weeks of class. 4. Academic Integrity: In meeting course requirements, honesty is essential and students are expected to abide by MEF policy of academic integrity, prohibiting cheating, plagiarizing, or otherwise falsifying results of any work. This applies to exams, papers, reports, and all other assignments. 5. Email Addresses: Emails assigned by the university must be used to communicate by the instructor and classmates. 6. If you miss more than 30% of the course (that is more than 12 hours), you forfeit your right to do the final project and will receive a grade of FC. Rules for attendance: The student must attend at least 70% of the classes. Statement on academic dishonesty and plagiarism: Law on Higher Education Article 54.

ECTS Student Workload Estimation

Activity	No/Weeks	Hours			Calculation
	No/Weeks per Semester	Preparing for the Activity	Spent in the Activity Itself	Completing the Activity Requirements
Course Hours	14	1	2	1	56
Laboratory	14	0	2		28
Homework Assignments	5	5	0.5		27.5
Total Workload					111.5
Total Workload/25					4.5
ECTS					5