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 | 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 | X |
|---|---|
| Major Area Courses | |
| 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 | Acquiring the skills of understanding, explaining, and using the fundamental concepts and methods of economics | |||||
| 2 | Acquiring the skills of macro level economic analysis | |||||
| 3 | Acquiring the skills of micro level economic analysis | |||||
| 4 | Understanding the formulation and implementation of economic policies at the local, national, regional, and/or global level | |||||
| 5 | Learning different approaches on economic and related issues | |||||
| 6 | Acquiring the quantitative and/or qualitative techniques in economic analysis | |||||
| 7 | Improving the ability to use the modern software, hardware and/or technological devices | |||||
| 8 | Developing intra-disciplinary and inter-disciplinary team work skills | X | ||||
| 9 | Acquiring an open-minded behavior through encouraging critical analysis, discussions, and/or life-long learning | X | ||||
| 10 | Adopting work ethic and social responsibility | |||||
| 11 | Developing the skills of communication. | |||||
| 12 | Improving the ability to effectively implement the knowledge and skills in at least one of the following areas: economic policy, public policy, international economic relations, industrial relations, monetary and financial affairs. | |||||
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 | ||