COURSE SYLLABUS

COMPUTER II

1	Course Title:	COMPUTER II
2	Course Code:	BIL1052
3	Type of Course:	Optional
4	Level of Course:	First Cycle
5	Year of Study:	1
6	Semester:	2
7	ECTS Credits Allocated:	2
8	Theoretical (hour/week):	2
9	Practice (hour/week) :	2
10	Laboratory (hour/week) :	0
11	Prerequisites:	None
12	Recommended optional programme components:	None
13	Language:	Turkish
14	Mode of Delivery:	Face to face
15	Course Coordinator:	Prof. Dr. AYSAN ŞENTÜRK
16	Course Lecturers:	Şehnaz Baltacı Göktalay, Erhan Şengel, Semiral Öncü, Adem Uzun, Neşe Erses, Mustafa Balay, Yunus Alyaz, Erdoğan Kartal, Özgür Sağlam
17	Contactinformation of the Course Coordinator:	aysan@uludag.edu.tr, 224 2942231, Uludağ Üniversitesi Eğitim Fakültesi, A Blok, BÖTE Bölümü, 16059 Nilüfer,Bursa
18	Website:
19	Objective of the Course:	This course aims to make students use electronic spreadsheet and presentation programs effectively.
20	Contribution of the Course to Professional Development

Learning Outcomes:

1	Making operations related to worksheets in an electronic spreadsheet.;
2	Data input into cells and adjusting cells in an electronic spreadsheet.;
3	Creating basic formulas in an electronic spreadsheet.;
4	Creating formulas using a certain address in an electronic spreadsheet.;
5	Using simple mathematical functions (Sum, average..etc.) in an electronic spreadsheet.;
6	Using logical functions (if..etc.) in an electronic spreadsheet.;
7	Making graphics in an electronic spreadsheet.;
8	Editting slides (adding, deleting, copying, moving) in the presentation program.;
9	Selecting a design template in the presentation program.;
10	Adding picture, automatic shape, sound, video in the presentation program.;

22	Course Content:

Week	Theoretical	Practical
1	Introduction to Course content, importance, requisites and rules of the course.	Introduction
2	Worksheets in electronic spradsheet program.	Lecture
3	Data input into cells in electronic spradsheet program.	Presentation and application
4	Simple formulas in electronic spradsheet program.	Presentation and application
5	Formulas using a certain address in an electronic spreadsheet.	Presentation and application. Studying with worksheets.
6	Simple mathematical functions (Sum, average..etc.) in an electronic spreadsheet.	Presentation and application. Studying with worksheets.
7	Logical functions (if..etc.) in an electronic spreadsheet	Presentation and application. Studying with worksheets.
8	Graphics in an electronic spreadsheet.	Presentation and application. Studying with worksheets.
9	Editting slides (adding, deleting, copying, moving) in the presentation program.	Presentation and application. Studying with worksheets.
10	Design templates, pictures, automatic shapes, sound and video in the presentation program.	Presentation and application. Studying with worksheets.
11	Slide transition in the presentation program.	Presentation and application. Studying with worksheets.
12	Special animation effects for the objects in the presentation program.	Studying with worksheets individually.
13	Making presentations.	Studying with worksheets individually.
14	Review of the course.	Collecting students’ views about the course verbally or in written form.

23	Textbooks, References and/or Other Materials:	Şentürk, Aysan (ed.2011) Temel Bilgi Tenolojileri ve Bilgisayar Kullanımı, Ekin Yayınevi, Bursa. Güneş, Ali (ed.).(2007). Bilgisayar I-II: Temel Bilgisayar Becerileri. Ankara: PegemA Yayıncılık. Bilgisayar Kurs Kitabı, Arkadaş Yayınları, 2008, Ankara. MEB Eğitim Teknolojileri Genel Müd. (2003). Eğitim Teknolojileri: Bilgisayar. Ankara: MEB EğiTek, Yay.No-9.
24	Assesment

TERM LEARNING ACTIVITIES	NUMBER	PERCENT
Midterm Exam	1	40
Quiz	0	0
Homeworks, Performances	0	0
Final Exam	1	60
Total	2	100
Contribution of Term (Year) Learning Activities to Success Grade		40
Contribution of Final Exam to Success Grade		60
Total		100
Measurement and Evaluation Techniques Used in the Course
Information

ECTS / WORK LOAD TABLE

CONTRIBUTION OF LEARNING OUTCOMES TO PROGRAMME QUALIFICATIONS

LO: Learning Objectives

PQ: Program Qualifications

Contribution Level:

1 Very Low

2 Low

3 Medium

4 High

5 Very High