COURSE UNIT TITLE

: INFORMATION TECHNOLOGIES AND APPLICATIONS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BIL 1007 INFORMATION TECHNOLOGIES AND APPLICATIONS COMPULSORY 2 2 0 4

Offered By

Computer Science

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSISTANT PROFESSOR RESMIYE NASIBOĞLU

Offered to

Computer Science

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, internet, search engines, HTML and web site design basics, electronic computing tables..

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   Have ability to construct of simple web sites.

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 Menus and Toolbars, Writing and formatting paragraphs, Bullets and numbering, Tables, Styles, Page Layout
4 Microsoft Word Inserting/formatting figures and images, Header and footer, Table of contents, footnote, references, Templates
5 Microsoft Excel Data entry, Cell formatting, Borders and shadings
6 Microsoft Excel Formula syntax, built in functions Graphics
7 Microsoft Excel Pivot tables, data manipulation
8 Microsoft Powerpoint Presentations, slide formats, Header and footer, Inserting/formatting figures and images Transition and animations, sample presentations
9 Internet and Web Computer networks and servers DNS, http, smtp, ftp, IP addressing, ping Internet Explorer, Toolbars, Settings Search engines Basic HTML concepts Web site design
10 HTML Tables and Frames
11 HTML Forms
12 HTML simple web sites.
13 CSS
14 CSS

Recomended or Required Reading

Textbook(s): Green, B.C., Information Technology and Systems, Longman Scientific & Technical Publishers, England, 1994
Supplementary Book(s): 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 FCG FINAL COURSE GRADE MTE * 0.40 + FIN * 0.60
4 RST RESIT
5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + FIN * 0.60


*** Resit Exam is Not Administered in Institutions Where Resit is not Applicable.

Further Notes About Assessment Methods

None

Assessment Criteria

To be announced.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

resmiye.nasiboglu@deu.edu.tr

Office Hours

Will be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Tutorials 14 2 28
Lectures 14 2 28
Preparations before/after weekly lectures 14 2 28
Preparation for midterm exam 1 6 6
Preparation for final exam 1 10 10
Preparing assignments 0 0 0
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 104

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13
LO.132
LO.24443
LO.33453
LO.442
LO.555242