Description of Individual Course Units
Course Unit CodeCourse Unit TitleType of Course UnitYear of StudySemesterNumber of ECTS Credits
3301001072019INFORMATION AND COMMUNICATION TECHNIQUESCompulsory112
Level of Course Unit
First Cycle
Objectives of the Course
To students; to teach basic computer usage features; Office applications (MsWord-Ms.Excel) and document-table and so on. To prepare; It is aimed to gain the ability of accessing the Internet and searching information from the Internet and using e-mail. It is aimed to gain practicality in preparing a presentation about a topic with Powerpoint.
Name of Lecturer(s)
Dr.Öğr.Üyesi Cihat Okan ARIKAN
Learning Outcomes
1Ability of the computer basic hardware elements
2Ability to start the Windows operating system, the basic functions of the program to run
3To understand the process of writing, and Word s basic functions using this application, curriculum vitae in the form of articles to prepare
4To understand the basic operations of Excel and using these functions to generate a list
5Using the list created in Excel to solve a problem, to perform calculations and to prepare reports based on the calculation results
6To be able to prepare presentations with PowerPoint and Sway applications
Mode of Delivery
Face to Face
Prerequisites and co-requisities
None
Recommended Optional Programme Components
None
Course Contents
1. To be able to recognize the basic elements and parts of computer 2. To be able to run programs using Windows operating system 3. To be able to comprehend the basic spelling of Word and to be able to prepare petitions and resumes using these functions 4. To be able to comprehend the basic operations of Excel and create a list 5. To be able to calculate and prepare reports for problem solving using Excel lists 6. To be able to prepare presentations with PowerPoint and Sway applications
Weekly Detailed Course Contents
WeekTheoreticalPracticeLaboratory
1Basic hardware elements of the computer
2Entering to the WindowsPetitions and writing CVs
3Inserting images in Word, Header-footer, Creating tables and propertiesCreating the document
4Creating Styles, Interrupts, and Auto table of contents in Word
5Introduction to PowerPoint, presentation, adding slides–deletion, using leveling, slideshow layouts, presentation options
6Formatting in P.Point, slide using, designs and transitions, Automatic timing settings
7Animations in P.Point, use of transitions, preparation of interactive presentations
8Midterm Examination
9Introduction of Excel, program description, page settings, main page and fill-cell characteristics, Excel data types, cut/copy/ paste, coloring, formatting
10Create Excel charts, graphics, setting up the constructionBasic mathematical operations to be performed by using of simple functions
11Introduction to Excel calculations and formulas, writing formulas and functions
12Presentation of the basic functions of Excel, the most commonly used parameters
13Continuing to Basic functions¶meters
14Transferring tables and graphs prepared in Excel to Word and solving the samplesCreating a graphic example with the table shown on the screen
15General repeat for the previous subjects about Word and Excel
16Final Examination
Recommended or Required Reading
1. Cihat Okan ARIKAN, 2017, Office365 platformunda Üniversite paylaşımları içerisindeki Insider Academy Kaynak kitap ve videoları 2. Mustafa Arslantunalı, Pusula Bilişim, “BT Uzmanları için Windows 10”, ISBN: 9786056460876 3. Olcay Büyükçapar, Kodlab Yayıncılık, “Bilişim Teknolojileri ve Yazılım”, ISBN: 9786052118085 4. Bayram Yıldız, Kodlab Yayınları, “Office 2016 Türkçe”, 2017, ISBN: 9786059118590 5. Ramazan Baykal, Ekin Kitabevi Yayınları, “Win 7-8.1 Office 2016”, ISBN: 9786053275381 6. Cenk İltir, Abaküs Kitap yayınları, “Office 2016 (Kitap+Video Eğitim Seti)”, 2016, ISBN: 9786059129466 7. Betül Bozyürük, "Microsoft Office Word 2007", Bilge Adam A.Ş., 2007 8. Güleser Çakmak, "Microsoft Office PowerPoint 2007", Bilge Adam A.Ş., 2007 9. Esra Öztürk, “Microsoft Office Excel 2007”, Bilge Adam A.Ş., 2007 10. Dodge, Mark; Stinson, Craig, 2001, "Microsoft Excel 2002 Inside Out", Microsoft Press, ISBN: 0-7356-1281-1 11. Curtis Frye, Kristen Crupi, Nuray Tekin, Buket Akkoyunlu; 2002, "Perspection, Inc., Online Training Solutions, Inc.", "Bilgisayar Kurs Kitabı"; Çeviren: K.Becerik, M.Derman, H.S.Kale, F.Hataçı, A.Konuralp, A.Pamukçu, N.Varol; ISBN: 975-509-329-X
Planned Learning Activities and Teaching Methods
Assessment Methods and Criteria
Term (or Year) Learning ActivitiesQuantityWeight
Midterm Examination1100
SUM100
End Of Term (or Year) Learning ActivitiesQuantityWeight
Final Sınavı1100
SUM100
Term (or Year) Learning Activities40
End Of Term (or Year) Learning Activities60
SUM100
Language of Instruction
Turkish
Work Placement(s)
None
Workload Calculation
ActivitiesNumberTime (hours)Total Work Load (hours)
Midterm Examination155
Final Examination155
Makeup Examination155
Attending Lectures14228
Self Study10220
TOTAL WORKLOAD (hours)63
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
LO1  4   23 5
LO2  1   11 5
LO3  1   1  4
LO4  1      2
LO5  1      5
LO6  1      5
* 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