Ordu University Lifelong Learning Programme

Description of Individual Course Units

Course Unit Code	Course Unit Title	Type of Course Unit	Year of Study	Semester	Number of ECTS Credits
BIM218201291280	COMPUTER APPLICATIONS - II	Compulsory	2	4	3

Level of Course Unit

Short Cycle

Objectives of the Course

To create various types of tables To calculate To convert the digital data to the chart table

Name of Lecturer(s)

Öğr. Gör. Dr. Devrim Karademir

Learning Outcomes

1	To use MS Excel 2010 program.
2	To write formulas in MS Excel
3	To create a table in the program.
4	To perform data analysis in the program.
5	To create a chart from a table.

Mode of Delivery

Formal Education

Prerequisites and co-requisities

None

Recommended Optional Programme Components

None

Course Contents

Features of MS Excel, Creating Excel Workbook, To make control over Worksheets, To use formatting, Introduction of the formula used in the program, Formula writing rules, To create a table, To perform data analysis, To convert tables

Weekly Detailed Course Contents

Week	Theoretical	Practice	Laboratory
1	Introduction to Excel 2010 program.
2	To format cells and worksheets
3	To work with Worksheets and Workbooks.
4	To work with functions.
5	To work with functions.
6	To work with functions.
7	To work with functions.
8	Midterm Exam
9	To create table
10	To review on the tables
11	Database Operations
12	Data analysis
13	Data analysis
14	To work with Graphics.
15	PivotTable and Chart
16	Final Exam

Recommended or Required Reading

- Basılmamış Ders Notları - Elektronik Tablolama Modülü, MEGEP - Microsoft Excel 2010, Osman GÜRKAN

Planned Learning Activities and Teaching Methods

Assessment Methods and Criteria

Term (or Year) Learning Activities	Quantity	Weight
SUM		0
End Of Term (or Year) Learning Activities	Quantity	Weight
SUM		0
Yarıyıl (Yıl) İçi Etkinlikleri		40
Yarıyıl (Yıl) Sonu Etkinlikleri		60
SUM		100

Language of Instruction

Turkish

Work Placement(s)

None

Workload Calculation

Activities	Number	Time (hours)	Total Work Load (hours)
Midterm Examination	1	1	1
Final Examination	1	3	3
Attending Lectures	14	2	28
Practice	14	1	14
Project Preparation	1	3	3
Self Study	14	1	14
Individual Study for Homework Problems	10	1	10
Individual Study for Mid term Examination	3	2	6
Individual Study for Final Examination	5	2	10
TOTAL WORKLOAD (hours)			89

Contribution of Learning Outcomes to Programme Outcomes

	PO 1	PO 2	PO 3	PO 4	PO 5	PO 6	PO 7	PO 8	PO 9	PO 10	PO 11	PO 12	PO 13	PO 14	PO 15	PO 16	PO 17	PO 18	PO 19	PO 20
LO1				5	3	5			2	3				4						3
LO2				5	3	5			2	3				4						3
LO3				5	3	5			2	3				4						3
LO4				5	3	5			2	3				5						3
LO5				5	3	5			2	3				5						3

* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High