ECTS - Worksheets and Computer Applications in Accounting
Worksheets and Computer Applications in Accounting (ISL354) Course Detail
| Course Name | Course Code | Season | Lecture Hours | Application Hours | Lab Hours | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| Worksheets and Computer Applications in Accounting | ISL354 | Area Elective | 3 | 0 | 0 | 3 | 5 |
| Pre-requisite Course(s) |
|---|
| N/A |
| Course Language | Turkish |
|---|---|
| Course Type | Technical Elective Courses |
| Course Level | Bachelor’s Degree (First Cycle) |
| Mode of Delivery | Face To Face |
| Learning and Teaching Strategies | Lecture, Demonstration, Drill and Practice. |
| Course Lecturer(s) |
|
| Course Objectives | This course aims to acquire students the skills required to conduct statistical analysis using the software packages Microsoft Excel and IBM SPSS. |
| Course Learning Outcomes |
The students who succeeded in this course;
|
| Course Content | Main computer applications in the issues such as budgeting, cost-volume- profit analysis, consolidation, capital budgeting and time value of money applications. |
Weekly Subjects and Releated Preparation Studies
| Week | Subjects | Preparation |
|---|---|---|
| 1 | Data summary, frequency distribution and histogram, scatter diagram and trendline, descriptive statistics in Excel | Course material on Moodle |
| 2 | Data coding, data transfer from Excel to SPSS, data labels, value labels, compute and recode variable | Course material on Moodle |
| 3 | Continuous variables, levels of measurement, independent and dependent variables, hypothesis construction, null and alternative hypotheses | Course material on Moodle |
| 4 | Hypothesis testing, one-tailed and two-tailed testing, one-sample t-test | Course material on Moodle |
| 5 | Independent samples t-test, paired samples t-test | Course material on Moodle |
| 6 | Single-factor ANOVA, two-factor ANOVA | Course material on Moodle |
| 7 | ANOVA interpretation, main and interaction effects | Course material on Moodle |
| 8 | Midterm Exam | |
| 9 | Likert scale, reliability analysis, factor analysis, KMO and Bartlett's tests | Course material on Moodle |
| 10 | Rotation, factorization, item elimination and improving results | Course material on Moodle |
| 11 | Calculating and saving factors as variables, interpreting factors | Course material on Moodle |
| 12 | Correlation analysis, bivariate regression, linear regression graph interpretation | Course material on Moodle |
| 13 | Multivariate regression, F-test, R-squared, value and significance of coefficients | Course material on Moodle |
| 14 | Categorical independent variables, dummy variables, coding of dummy variables, interpretation dummy variables in multivariate regression | Course material on Moodle |
Sources
| Other Sources | 1. MS Excel |
|---|---|
| 2. IBM SPSS |
Evaluation System
| Requirements | Number | Percentage of Grade |
|---|---|---|
| Attendance/Participation | - | - |
| Laboratory | - | - |
| Application | - | - |
| Field Work | - | - |
| Special Course Internship | - | - |
| Quizzes/Studio Critics | - | - |
| Homework Assignments | 5 | 35 |
| Presentation | 1 | 10 |
| Project | - | - |
| Report | - | - |
| Seminar | - | - |
| Midterms Exams/Midterms Jury | 1 | 25 |
| Final Exam/Final Jury | 1 | 30 |
| Toplam | 8 | 100 |
| Percentage of Semester Work | 70 |
|---|---|
| Percentage of Final Work | 30 |
| Total | 100 |
Course Category
| Core Courses | |
|---|---|
| Major Area Courses | X |
| Supportive Courses | |
| Media and Managment Skills Courses | |
| Transferable Skill Courses |
The Relation Between Course Learning Competencies and Program Qualifications
| # | Program Qualifications / Competencies | Level of Contribution | ||||
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 1 | Gains the ability to use knowledge by acquiring conceptual and practical understanding of all core functions of business. | |||||
| 2 | Identifies problems related to the field of business and effectively uses scientific approaches in problem-solving and decision-making processes. | |||||
| 3 | Demonstrates and analyzes the environmental, social, global impacts and legal consequences of practices related to core business functions. | |||||
| 4 | Analyzes information and reports relevant to businesses at national, regional, and global levels, and sets strategic goals based on the results obtained. | |||||
| 5 | Gains the ability to use, report, and interpret Business Information Systems and their sub-modules required for business management. | X | ||||
| 6 | Plans the necessary activities such as taking risks, securing resources, conducting market analysis, and preparing business plans for starting a new venture and ensuring its sustainability with innovative and creative thinking, and applies the acquired knowledge accordingly. | |||||
| 7 | Supports oneself and the organization in terms of innovation and continuous improvement, while being aware that the process of research and learning is lifelong and following scientific and technological developments related to business. | |||||
| 8 | Acquires the necessary leadership and managerial skills to achieve business objectives effectively and efficiently. | |||||
| 9 | Conducts scientific research in the field of business and reports the research findings to be used in managerial decision-making processes. | |||||
| 10 | Uses effective verbal, written, and visual communication methods to convey information related to the field of business in the language of instruction and professional English. | |||||
| 11 | Develops awareness of professional ethics, environmental sensitivity, sustainability, social responsibility, and cultural, societal, and universal values. | |||||
| 12 | Takes initiative in working effectively with different disciplines or multicultural teams, assuming responsibility, conducting risk analysis, adapting to change, and applying critical thinking and problem-solving skills. | |||||
| 13 | . | |||||
ECTS/Workload Table
| Activities | Number | Duration (Hours) | Total Workload |
|---|---|---|---|
| Course Hours (Including Exam Week: 16 x Total Hours) | 16 | 3 | 48 |
| Laboratory | |||
| Application | |||
| Special Course Internship | |||
| Field Work | |||
| Study Hours Out of Class | |||
| Presentation/Seminar Prepration | 1 | 15 | 15 |
| Project | |||
| Report | |||
| Homework Assignments | 1 | 35 | 35 |
| Quizzes/Studio Critics | |||
| Prepration of Midterm Exams/Midterm Jury | 1 | 15 | 15 |
| Prepration of Final Exams/Final Jury | 1 | 20 | 20 |
| Total Workload | 133 | ||