COURSE UNIT TITLE

: COMPUTER APLICATIONS

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
UBY 1007 COMPUTER APLICATIONS COMPULSORY 3 0 0 4

Offered By

School of Applied Sciences

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSOCIATE PROFESSOR FIGEN KANGALGIL

Offered to

Tourism and Hotel Management
International Trade
Tourism Management

Course Objective

This course aims to provide an introduction to acquaint students with computers as tools of information processing and their applications. Students will be familiar with computer hardware, software and telecommunication devices. They may easily understand the features of the technological instruments used at the area of information technologies. They will be able to make applications related to the word processor, spreadsheets, and databases.

Learning Outcomes of the Course Unit

1   Demonstrate an understanding of basic concepts of computer software and hardware components.
2   Demonstrate an understanding of telecommunication devices.
3   Make applications related to the word processor, spreadsheets, and databases.
4   Demonstrate awareness of fundamental information technologies.
5   Generate applications from real data and events.
6   Be able to solve problems involving understanding of the functional and algebraic concepts in Excel.
7   Evaluate relationships among data entities to design integrated database.

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Fundamentals of IT
2 Operating system software and internet
3 Word processing applications: text properties, file options, constructing table, table properties.
4 Word processing applications: constructing figures, figure properties, equation editor
5 Presentation applications
6 Presentation applications
7 Midterm Exam
8 Midterm Exam
9 Spreadsheet applications: cell properties, general formulations
10 Spreadsheet applications: statistical formulations, conditional formatting options
11 Spreadsheet applications: statistical formulations, conditional formatting options
12 Spreadsheet applications: data filtering options, drawing charts
13 Database design and applications: database components
14 Database design and applications: database components
15 Final Exam
16 Final Exam

Recomended or Required Reading

Pearson MyITLab Platform. Students must purchase an access code to register to the online course platform at the begining of the semester.
E-Text Book: Exploring Microsoft Office 2013 (by Robert T. Grauer, Mary Anne Poatsy, Michelle Hulett,Cynthia Krebs, Keith Mast, Keith Mulbery, Lynn Hogan). This ebook will be freely provided upon getting access code to MyITLab.

Planned Learning Activities and Teaching Methods

Lecture by instructor, class discussion conducted by instructor, problem solving or case studies, question and answer teaching method

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 + RST * 0.60


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

Further Notes About Assessment Methods

None

Assessment Criteria

Skill in analysis, synthesis and critical thinking; skill in problem solving; skill in application via midterm and final exams

Language of Instruction

Turkish

Course Policies and Rules

The Regulation of Dokuz Eylul University on Education and Examination in Associate's and Bachelor's Degrees
The Codes of Practice of School of Applied Sciences on Education and Examination

Contact Details for the Lecturer(s)

e-mail adress of the lecturer
Associate Professor Figen Kangalgil
figen.kangalgil@deu.edu.tr

Office Hours

Meetings will be accepted every Friday between 13:00-14:00.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 12 3 36
Preparations before/after weekly lectures 12 3 36
Preparation for midterm exam 1 12 12
Preparation for final exam 1 12 12
Final 1 2 2
Midterm 1 2 2
TOTAL WORKLOAD (hours) 100

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14PO.15PO.16
LO.1
LO.2
LO.3
LO.4
LO.5
LO.6
LO.7