# 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 3 0 0 3 5
Pre-requisite Course(s)
-
Course Language Turkish N/A Bachelor’s Degree (First Cycle) Face To Face Lecture, Demonstration, Drill and Practice. Asst. Prof. Dr. Neslihan Turguttopbaş This course aims to acquire students the skills required to conduct statistical analysis using the software packages Microsoft Excel and IBM SPSS. The students who succeeded in this course; To recognize the spreadsheet program in computer environment, create the desired document by learning Using the spreadsheet program in computer environment, calculations can be made in the tables and repeat them able to arrange Using the spreadsheet program in computer environment, create graphs linked to tables and edit as desired. Using the spreadsheet program in computer environment, use ready functions and when required You will be able to change. 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

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 30 100

### Course Category

Core Courses X

### The Relation Between Course Learning Competencies and Program Qualifications

# Program Qualifications / Competencies Level of Contribution
1 2 3 4 5
1 Having the conceptual and applied knowledge about the basic functions of the business and gaining the ability to use the knowledge
2 To be able to diagnose the problems related to the field of business, to use scientific approaches effectively in the solution of problems and decision-making processes.
3 To be able to reveal and analyze the environmental, social, global effects and legal consequences of the applications related to the basic functions of the business.
4 To be able to analyze information and reports that concern businesses at the national, regional and global level, to set strategic goals according to the results obtained
5 Gain the ability to use, report and interpret Business Information Systems and sub-modules required by business management X
6 Planning necessary activities such as starting a new business with innovative and creative thinking and taking risks for the sustainability of the business, finding resources, making market analysis, preparing a business plan, and using the learned information in this direction.
7 Being aware of the fact that the research and learning process continues throughout life, to be able to follow the scientific and technological developments related to the business, to support oneself and the organization in innovation and continuous development.
8 To have the necessary leadership and managerial skills to achieve business objectives effectively and efficiently.
9 To be able to conduct scientific research in the field of business and report the results of the research to be used in managerial decision-making processes.
10 To be able to transfer information about the field of business using effective verbal, written and visual communication methods in the language of learning and professional English
11 To be aware of professional ethics, environmental awareness, sustainability, social responsibility, cultural, social and universal values
12 Working effectively with different disciplines or multicultural teams, taking responsibility, making risk analysis, adapting to change, critical thinking and using initiative in problem solving
13 .

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