Description of Individual Course Units
Course Unit CodeCourse Unit TitleType of Course UnitYear of StudySemesterNumber of ECTS Credits
801001622009COMPUTER PRACTISESElective124
Level of Course Unit
First Cycle
Objectives of the Course
Because of information technology age, the aim of course is to teach Microsoft Excel and web design with HTML, which is basis of web design programmes to design of web site represented themselves.
Name of Lecturer(s)
Doç.Dr. İlknur Aydoğdu Karaaslan
Learning Outcomes
1Comprehension of cell application
2Making table
3Doing arithmetic application
4Showing data with graphics
5Making pivot table
6Designing web page
Mode of Delivery
Face to Face
Prerequisites and co-requisities
None
Recommended Optional Programme Components
None
Course Contents
Ms Office and designing programme
Weekly Detailed Course Contents
WeekTheoreticalPracticeLaboratory
1Recognizing Microsoft Excel WorksheetCase study
2Cell application, toolbarsCase study
3Making table and editingCase study
4Making equation and aritmetic applicationCase study
5ApplicationCase study
6Logical functions (sum, average, if)Case study
7Logical functions (if(and), if( or), Sum(if))Case study
8Quiz
9Making graphicCase study
10Creating pivot tableCase study
11Introduction web design and HTML Case study
12Adding Picture, Making LinkCase study
13Making tableCase study
14Listing tagsCase study
15General repeatCase study
16Final
Recommended or Required Reading
• Cox J.&Preppernau, J., Çeviri: Duygu Kayadelen, Selim Göksu vd. Adım Adım Microsoft Office 2007, Arkadaş Yayınları, Ankara, 2008. • Üçüncü H., Örnek Uygulamalı Excel 2007, Alfa Yayınevi, 2007 • Bal, Hasan Çebi, Bilgisayar ve internet Kullanımı XPTrabzon, ABP Yayınevi,2006 • Balaban, Erkan., Web Tasarım Klavuzu, Pusula Yayıncılık, İstanbul. 2005. • Çubukçu, Faruk, Microsoft Office, Alfa Yayınları, İstanbul, 1997. • Gürkan,O., Excel XP Nirvana Yayınevi. • Yolcu Mehmet, Adım Adım Excel, Arkadaş Yayınları,Ankara, 1997.
Planned Learning Activities and Teaching Methods
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight
SUM0
End Of Term (or Year) Learning ActivitiesQuantityWeight
SUM0
SUM0
Language of Instruction
Turkish
Work Placement(s)
None
Workload Calculation
ActivitiesNumberTime (hours)Total Work Load (hours)
Midterm Examination122
Final Examination122
Practice14342
Laboratory5315
Tutorial14342
Problem Solving224
TOTAL WORKLOAD (hours)107
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
LO1 3          53  
LO2 3          53  
LO3 3          53  
LO4 3          53  
LO5 3          53  
LO6 3          53  
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High
 
Ege University, Bornova - İzmir / TURKEY • Phone: +90 232 311 10 10 • e-mail: intrec@mail.ege.edu.tr