At the end of this course, the students; 1) To develop database MS Access database management application database, 2) To explain basic concepts of database, 3) To develop tables using MS Access, perform relations with developed tables, 4) To perform queries using MS Access, 5) To explain data types, creates database, table using SQL commands, 6) To perform basic queries with records using SQL commands, 7) To perform form pages to enter data to the tables, to update tables and to delete tables.
MODE OF DELIVERY
Face to face
PRE-REQUISITES OF THE COURSE
No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT
None
COURSE DEFINITION
Understanding development of database and its basic concepts, database design using database management systems (DBMS) visual interface and create database using SQL, having data processing and query ability.
COURSE CONTENTS
WEEK
TOPICS
1st Week
General information about the course and the evaluation methods
2nd Week
Purpose of accounting, Generally Accepted Accounting Principles. Financial Statements; Balance Sheet. Effects of business transactions upon the Balance Sheet.
3rd Week
Concept of Account. Assets, Liabilities and Owner's Equity.
4th Week
Preparing Balance Sheet, Journal, Debit and Credit Entries, Double-Entry Accounting,Recording transactions to Jornal, The use of Ledger Accounts,
5th Week
Adjusting entries, Preparing monthly and adjusted Trial Balance,
6th Week
End of year balance sheet and income statement. Closing and re-opening the accounts
7th Week
Tangible assets, cash and bank transactions.
8th Week
Midterm exam
9th Week
Checking accounts, recording the outstanding checks
10th Week
Accounts Recaivable, Notes Receivable.
11th Week
Inventories, and Cost of Goods Sold, Periodic and Perpetual Inventory Methods. Value Added Tax (KDV) Account
12th Week
Intangible accounts, Plant and Equipment
13th Week
Depreciation and Amortization.
14th Week
Accounts payable and notes payable
RECOMENDED OR REQUIRED READING
- Özseven, T. Veritabanı Yönetim Sistemleri I
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS
Lecture,Practice
ASSESSMENT METHODS AND CRITERIA
Quantity
Percentage(%)
Mid-term
1
30
Practice
1
20
Other
1
10
Total(%)
60
Contribution of In-term Studies to Overall Grade(%)
60
Contribution of Final Examination to Overall Grade(%)
40
Total(%)
100
ECTS WORKLOAD
Activities
Number
Hours
Workload
Midterm exam
1
1
1
Preparation for Quiz
Individual or group work
14
2
28
Preparation for Final exam
1
30
30
Course hours
Preparation for Midterm exam
1
20
20
Laboratory (including preparation)
14
3
42
Final exam
1
1
1
Homework
7
5
35
Total Workload
157
Total Workload / 30
5,23
ECTS Credits of the Course
5
LANGUAGE OF INSTRUCTION
Turkish
WORK PLACEMENT(S)
No
KEY LEARNING OUTCOMES (KLO) / MATRIX OF LEARNING OUTCOMES (LO)