| Course Type | Elective Course |
|---|
| Course Level | Associate Degree |
|---|
| Year of Study | - |
|---|
| Semester | - |
|---|
| ECTS | 4 |
|---|
| 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 | This is a technical course that examines the processes of systematically storing, managing, and analyzing data. Within the scope of the course, SQL querying, data modeling, security protocols, and big data management are addressed. The primary objective is to provide students with the skill to professionally manage complex data structures in digital systems and transform them into strategic information. |
|---|
| 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 |
8 |
2 |
16 |
| Preparation for Final exam |
1 |
25 |
25 |
| Course hours |
14 |
3 |
42 |
| Preparation for Midterm exam |
1 |
20 |
20 |
| Laboratory (including preparation) |
|
|
|
| Final exam |
1 |
1 |
1 |
| Homework |
|
|
|
| Performance Practice |
1 |
15 |
15 |
| Total Work Load | 120 |
| Total Work Load / 30 (h) | 4 |
| ECTS Credit of the Course | 4 |
|
| Language of Instruction | Turkish |
|---|
| Work Placement(s) | No |
|---|
