COURSE UNIT TITLE

: COMPUTER APPLICATIONS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
IST 1111 COMPUTER APPLICATIONS COMPULSORY 2 2 0 5

Offered By

Psychology

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASISTANT PROFESSOR AYŞE ÖVGÜ KINAY

Offered to

Psychology

Course Objective

This course aims the basic information technology usage skills necessary and related specialties will be given. The students will learn about personal computers and applications in hardware and software, using and administration of Microsoft Windows operating system, file management, word processing, electronic computing tables, internet, search engines, HTML and web site design basics.

Learning Outcomes of the Course Unit

1   Have capability to use personal computers for personal and specific applications.
2   Have ability to create a document, presentation and a basic web site by using a computer.
3   Have ability to search any subject on the internet and following new technologies.
4   Have information about administrating Windows operating systems.
5   Having ability to make computations by constructing worksheets, graphics and tables.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 History of computers, Binary system, Computer components (software hardware)
2 Introduction to MS Windows, User interface, keyboard shortcuts, Personalization, Administration, Basic Windows applications
3 Microsoft Word 2007 Menus and Toolbars, Writing and formatting paragraphs, Bullets and numbering, Tables, Styles, Page Layout
4 Microsoft Word 2007 Inserting/formatting figures and images, Header and footer, Table of contents, footnote, references, Templates
5 Microsoft Excel 2007 Data entry, Cell formatting, Borders and shadings
6 Microsoft Excel 2007 Formula syntax, built in functions Graphics
7 Microsoft Excel 2007 Pivot tables, data manipulation
8 Midterm exam
9 Microsoft Powerpoint 2007 Presentations, slide formats, Header and footer, Inserting/formatting figures and images
10 Microsoft Powerpoint 2007 Transition and animations, sample presentations
11 Internet and Web Computer networks and servers DNS, http, smtp, ftp, IP addressing, ping
12 Internet Explorer Toolbars, Settings Search engines
13 Basic HTML concepts Frames and tables
14 Web site design CSS Examples

Recomended or Required Reading

1. Green, B.C., Information Technology and Systems, Longman Scientific & Technical Publishers, England, 1994.
2. Mansfield, R., Mastering VBA for Microsoft Office, Sybex, 2008

Planned Learning Activities and Teaching Methods

The course is taught in a lecture, class presentation and discussion format. Besides the taught lecture, group presentations are to be prepared by the groups assigned and presented in a discussion session. In some weeks of the course, results of the homework given previously are discussed.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 MTE MIDTERM EXAM
2 FIN FINAL EXAM
3 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + FIN * 0.60
4 RST RESIT
5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + RST * 0.60


Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

Students will come to the class in time. Attending the 70% of the classes are mandotary.

Contact Details for the Lecturer(s)

ovgu.tekin@deu.edu.tr

Office Hours

Will be announced

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 2 26
Tutorials 13 2 26
Preparations before/after weekly lectures 13 3 39
Preparation for midterm exam 1 10 10
Preparation for final exam 1 10 10
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 115

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.15
LO.25
LO.35
LO.45
LO.55