BASIC PROGRAMMING IN BUSINESS ADMINISTRATION

BUS492

Course Code: BUS492
Semester: -
Theory+Practice: 3 + 0
ECTS: 5

Course Type

Elective Course

Course Level

Bachelor's Degree

Year of Study

Semester

ECTS

Name of Lecturer(s)

Learning Outcomes

At the end of this course, the students;

Learn to use all the features of the spreadsheet software at a high level.
Learn to design solutions for business administiration with advanced excel spreadsheets.
Learn to use the basic features of Python programming.
Learn to design solutions for business domain with Python programming language.

Mode of Delivery

Face to face

Prerequisites

Recommended Optional Programme Components

Course Description

The aim of this course is to teach basic computer programs and python programming language that are important for their education and professional life. With this course students will gain a new skills and tools for solving problems and analysis. Students who miss more than 30% of total class hours receive an F2 grade.

Course Contents

WEEK	TOPICS
1^st Week	Introduction, Installation of Spreadsheet Processing Application
2^nd Week	Spreadsheet Processing - Basic Applications, Formulas and Functions
3^rd Week	Spreadsheet Processing - Charts and Table Preparation
4^th Week	Spreadsheet Processing - Advanced Formulas and Functions
5^th Week	Spreadsheet Processing - Advanced Formulas and Functions II
6^th Week	Spreadsheet Processing - Advanced Formulas and Functions - III
7^th Week	Midterm
8^th Week	Spreadsheet Processing - Examples and Applications
9^th Week	Introduction to Python
10^th Week	Programming with Python I
11^th Week	Programming with Python II
12^th Week	Programming with Python III
13^th Week	Python Programming - Examples and Applications
14^th Week	General Review

Recommended or Required Reading

Microsoft Office 365: In Practice, 2019 Edition, Randy Nordell, McGraw-Hill Education, 2019.
Starting Out with Python Fifth Edition Global Edition, Tony Gaddis, Pearson, 2021.
İşletmeler İçin Python Uygulamaları, Can Aydın, Nobel Akademik Yayıncılık, 1.Baskı, 2019.
İleri Düzey Excel 2019, Ömer Bağcı, Seçkin Yayıncılık, 9.Baskı, 2020.
Python 3 Veri Yapıları, Timur Karaçay, Kuban Matbaacılık, 2013.

Planned Learning Activities and Teaching Methods

Lecture
Questions/Answers
Problem Solving
Discussion

Assessment Methods and Criteria

	Quantity	Percentage (%)
Mid-term	1	30
Quiz	3	30
Total(%)		60
Contribution of In-term Studies to Overall Grade(%)		60
Contribution of Final Examination to Overall Grade(%)		40
Total(%)		100

ECTS Allocated Based on Student Workload

Activities	Quantity	Duration (Hour)	Total Workload (Hour)
Midterm exam	1	2	2
Preparation for Quiz
Individual or group work	14	4	56
Preparation for Final exam	1	20	20
Course hours	14	3	42
Preparation for Midterm exam	1	20	20
Laboratory (including preparation)
Final exam	1	2	2
Homework	3	1	3
Total Work Load			145
Total Work Load / 30 (h)			4.83
ECTS Credit of the Course			5

Language of Instruction

English

Work Placement(s)

Programme Qualifications / Learning Outcomes

	LO1	LO2	LO3	LO4
K1	X	X	X	X
K2				X
K3				X
K4
K5
K6
K7
K8		X	X	X
K9
K10
K11
K12
K13