At the end of this course, the students; 1) Learn to use all the features of the spreadsheet software at a high level. 2) Learn to design solutions for business administiration with advanced excel spreadsheets. 3) Learn to use the basic features of Python programming. 4) Learn to design solutions for business domain with Python programming language.
MODE OF DELIVERY
Face to face
PRE-REQUISITES OF THE COURSE
No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT
No
COURSE DEFINITION
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.
COURSE CONTENTS
WEEK
TOPICS
1st Week
Introduction, Installation of Spreadsheet Processing Application
2nd Week
Spreadsheet Processing - Basic Applications, Formulas and Functions
3rd Week
Spreadsheet Processing - Charts and Table Preparation
4th Week
Spreadsheet Processing - Advanced Formulas and Functions
5th Week
Spreadsheet Processing - Advanced Formulas and Functions II
6th Week
Spreadsheet Processing - Advanced Formulas and Functions - III
7th Week
Spreadsheet Processing - Examples and Applications
8th Week
Mid Term
9th Week
Introduction to Python
10th Week
Programming with Python I
11th Week
Programming with Python II
12th Week
Programming with Python III
13th Week
Python Programming - Examples and Applications
14th Week
General Review
RECOMENDED 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.
