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

ASSOCIATE PROFESSOR EMEL KURUOĞLU KANDEMIR

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, macros and Visual Basic.

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 2016 Menus and Toolbars, Writing and formatting paragraphs, Bullets and numbering, Tables, Styles, Page Layout
4 Microsoft Word 2016 Inserting/formatting figures and images, Header and footer, Table of contents, footnote, references, Templates
5 Microsoft Excel 2016 Data entry, Cell formatting, Borders and shadings
6 Microsoft Excel 2016 Formula syntax, built in functions Graphics
7 Microsoft Excel 2016 Pivot tables, data manipulation
8 Mid-term exam
9 Microsoft Powerpoint 2016 Presentations, slide formats, Header and footer, Inserting/formatting figures and images Transition and animations, sample presentations
10 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
11 HTML Tables and Frames
12 HTML Forms
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 ASG ASSIGNMENT
3 PAR PARTICIPATION
4 FIN FINAL EXAM
5 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + ASG * 0.10 + PAR * 0.10 + FIN * 0.40
6 RST RESIT
7 FCGR FINAL COURSE GRADE (RESIT) MTE * 0.40 + ASG * 0.10 + PAR * 0.10 + RST * 0.40


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)

emel.kuruoglu@deu.edu.tr
cagin.kandemir@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 13 2 26
Preparations before/after weekly lectures 12 1 12
Preparation for midterm exam 1 6 6
Preparation for final exam 1 10 10
Preparing assignments 2 8 16
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 102

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