ECTS - Worksheets and Computer Applications in Accounting
Worksheets and Computer Applications in Accounting (MAN354) Course Detail
| Course Name | Course Code | Season | Lecture Hours | Application Hours | Lab Hours | Credit | ECTS |
|---|---|---|---|---|---|---|---|
| Worksheets and Computer Applications in Accounting | MAN354 | Elective Courses | 3 | 0 | 0 | 3 | 5 |
| Pre-requisite Course(s) |
|---|
| N/A |
| Course Language | English |
|---|---|
| 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, total variance explained, | Course material on Moodle |
| 10 | Rotation, factorization, improving results, item elimination and improving results | Course material on Moodle |
| 11 | Calculating and saving factors as variables | 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 | 0 |
|---|---|
| Percentage of Final Work | 100 |
| Total | 100 |
Course Category
| Core Courses | |
|---|---|
| Major Area Courses | |
| Supportive Courses | X |
| 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 | Understanding and explaining the concepts regarding to the main fields of Management (Management, Production, Marketing, Accounting- Finance) and gaining the ability to apply these skills in management. | |||||
| 2 | Gaining the ability to use technology required for buseiness administration | |||||
| 3 | An ability to analyze the information and reports of the markets and businesses and setting goals with respect to results of the analysis. | |||||
| 4 | An ability to trace and evaluate the global, local and/or regional developments related to businesses and making strategic decisions. | |||||
| 5 | An ability to set a innovative business or an ability to use the knowledge in the operations of management(taking risk, finding resources, making market research, and preparing business plans etc.) | |||||
| 6 | An ability to apply knowledge regarding functions of management. | |||||
| 7 | An ability to have oral and written communication skills particular to management and use these skills effectively in professional relations | |||||
| 8 | Compliance with rules of Socials and business ethics and to the principles of social responsibility | |||||
| 9 | An ability to use life-long learning approach in order to adapt constantly changing environmental factors (technological, political ,economical, and socio cultural etc.) | |||||
| 10 | An ability to conduct research on management and reporting the outcomes with the related parties. | |||||
| 11 | Taking responsibility within the teamwork, thinking critically and taking initiative in problem solving. | |||||
| 12 | Using professional English in written and verbal communication. ("European Language Portfolio Global Scale", Level B1) | |||||
| 13 | Having knowledge about law required by management. | |||||
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 | ||