| Course Type | Elective Course |
|---|
| Course Level | Associate Degree |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 5 |
|---|
| Name of Lecturer(s) |
- |
| Learning Outcomes |
At the end of this course, the students;
- To develop database MS Access database management application database,
- To explain basic concepts of database,
- To develop tables using MS Access, perform relations with developed tables,
- To perform queries using MS Access,
- To explain data types, creates database, table using SQL commands,
- To perform basic queries with records using SQL commands,
- To perform form pages to enter data to the tables, to update tables and to delete tables.
|
| Mode of Delivery | Face to face |
|---|
| Prerequisites | No |
|---|
| Recommended Optional Programme Components | None |
|---|
| Course Description | 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 |
|
| Recommended or Required Reading | - Özseven, T. Veritabanı Yönetim Sistemleri I |
|---|
| Planned Learning Activities and Teaching Methods |
|
|---|
| 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 Allocated Based on Student Workload |
| Activities |
Quantity |
Duration (Hour) |
Total Workload (Hour) |
| 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 Work Load | 157 |
| Total Work Load / 30 (h) | 5.23 |
| ECTS Credit of the Course | 5 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
