ECTSComputer Applications in Business

Computer Applications in Business (ISL354) Ders Detayları

Course Name Corse Code Dönemi Lecture Hours Uygulama Saati Lab Hours Credit ECTS
Computer Applications in Business ISL354 Elective Courses 3 0 0 3 5
Pre-requisite Course(s)
-
Course Language Türkçe
Course Type Technical Elective Courses
Course Level Lisans
Mode of Delivery Face To Face
Learning and Teaching Strategies Lecture, Demonstration, Drill and Practice.
Course Coordinator
Course Lecturer(s)
  • Prof. Dr. Kamil Büyükmirza
Course Assistants
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;
  • 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.
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 0
Percentage of Final Work 100
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 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. X
2 Gaining the ability to use technology required for buseiness administration X
3 An ability to analyze the information and reports of the markets and businesses and setting goals with respect to results of the analysis. X
4 An ability to trace and evaluate the global, local and/or regional developments related to businesses and making strategic decisions. X
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.) X
6 An ability to apply knowledge regarding functions of management. X
7 An ability to have oral and written communication skills particular to management and use these skills effectively in professional relations X
8 Compliance with rules of Socials and business ethics and to the principles of social responsibility X
9 An ability to use life-long learning approach in order to adapt constantly changing environmental factors (technological, political ,economical, and socio cultural etc.) X
10 An ability to conduct research on management and reporting the outcomes with the related parties. X
11 Taking responsibility within the teamwork, thinking critically and taking initiative in problem solving. X
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