defter / katalog / MAN 102

MAN 102

Introduction to Business II

Despite the "business" label, this is really a computational toolkit course: you learn to turn messy data into decisions using spreadsheets, a bit of VBA, and introductory Python. Expect to spend most of your time in lab building Excel models, pivot tables, lookups, TVM calculations, Solver-based optimization, What-If scenarios, then automating the tedious parts with macros and finishing the semester writing small Pandas scripts in Jupyter. It pairs with MAN 101 to round out your first year and gives you the analytical muscle you'll lean on later in finance, operations, and any upper-level course where someone hands you a CSV and expects an answer.

Kredi3ECTS5FakülteFaculty of Business AdministrationBölümManagementÖn koşulMAN 101KoordinatörÖzgür Tolga BaycanMüfredatY1 Bahar

→ STARS müfredatı (resmi syllabus)

Haftalık müfredat 14 hafta

Hafta 114–20 Eyl

MS Word ve spreadsheet ile veri sunumu

Creating well-formatted and professional-looking documents by MS Word. Managing workbooks and worksheets. Importance of data readability, ways of formatting the necessary sections of a spreadsheet to represent data.

MS Wordworkbook ve worksheetformattingveri okunabilirliği

Hafta 221–27 Eyl

Built-in functions ve temel veri analizi

Basic and advanced usage of Built-in functions [CountIf(s), AverageIf(s), SumIf(s) etc.] Representing data graphically, customization of charts. Writing formulas to manage data & solve problems. Steps of basic data analysis based on emphasis, organization and grouping (Sorting, Conditional Formatting and Filtering)

CountIfSumIfconditional formattingcharts

Hafta 328 Eyl – 4 Eki

Filtering, pivot table ve grafiklerle veri analizi

Filtering vs Pivot Tables. Data analysis & interpretation with Pivot Tables & Charts.

filteringpivot tablechartveri analizi

Hafta 45–11 Eki

LookUp Fonksiyonlarıyla Veri Analizi

Data analysis & interpretation with simple and advanced LookUp functions. (VLookUp & HLookUp)

VLookUpHLookUpdata analysisyorumlama

Hafta 512–18 Eki

Boolean operatörler ve nested IF

Boolean Operators & Functions (AND/OR/NOT). Composing simple If Statements. Making decisions & predictions by forming NESTED IF statements.

Boolean operatorsAND/OR/NOTIF statementnested IF

Hafta 619–25 Eki

Excel'de temel finansal fonksiyonlar

MS Excel Basic Financial Functions (i.e. Time Value of Money). Usage of PV, FV, RATE, NPER, PMT functions. Making decisions with Multiple Cash Flow analyses and forming an Amortization Table.

time value of moneyPV, FV, RATE, NPER, PMTmultiple cash flow analiziamortization table

Hafta 726 Eki – 1 Kas

What-If Analysis ile veri tahmini

Analyzing and predicting data by different options of the What-If Analysis tool (Ex: Break-Even Analysis by one/two-variable data tables; Calculating exact break-even utilizing Goal Seek and preparing Best/Expected/Worst case scenarios by using Scenario Manager tool)

break-even analysisdata tablesGoal SeekScenario Manager

Hafta 82–8 Kas

Excel SOLVER ile Linear Programming

Linear Programming by Excel SOLVER add-in. Profit maximization/Cost minimization and optimization problems.

Excel SOLVERprofit maximizationcost minimizationoptimization

Hafta 99–15 Kas

VBA Macro I: Değişkenler ve Input Fonksiyonları

Data analysis, interpretation and presentation by VBA Macros I (Working with String and Integer type of variables, Input and MsgBox functions; Assigning macro codes to buttons)

VBA macroString ve IntegerInput ve MsgBoxbuton atama

Hafta 1016–22 Kas

VBA Macro II: If-Then-Else ve Döngüler

Data analysis, interpretation and presentation by VBA Macros II (Applications with If….Then….Else/Nested If statements and iteration by For Each…..Next statement)

VBA macronested IfFor Each…Nextiteration

Hafta 1123–29 Kas

VBA Macro III: Senaryo ve Karar Verme

Data analysis, interpretation and presentation by VBA Macros III (Preparing scenarios, making predictions and decision making by considering building blocks of algorithms)

VBA macrosenaryotahminalgoritma yapı taşları

Hafta 1230 Kas – 6 Ara

Python ortamı, Jupyter kurulumu ve modüller

PYTHON I - Introduction to Python Environment. Installation & set-up process of Jupyter Notebook. Declaring and using variables. Importing and working with Python modules such as Math, Random & Numpy.

Jupyter NotebookvariableMathNumPy

Hafta 137–13 Ara

Python'da döngüler ve koşullu ifadeler

PYTHON II - Understanding and developing iterative procedures (For and While loops), Boolean functions (AND, OR, NOT), and conditional statements (If, Elif, Else, and Nested If statements).

for loopwhile loopBooleanif-elif-else

Hafta 1414–20 Ara

Pandas ile Excel ve CSV analizi

PYTHON III - Analyzing and exploring MS Excel and CSV files by performing basic calculations (sum, average, max, min, etc.) and applying filters with the Pandas module.

PandasCSVMS Excelfiltreleme

Değerlendirme 100% · 4 adım

30%

10%

30%

Midterm Midterm 1, Midterm 2 60%

Lab work Lab Activities 10%

Final Final 30%

en büyük tek kalem %30 · sınav ağırlığı %90 · 41 dönem ortalaması 2.31 (4778 öğrenci) nasıl hesaplanıyor

Önerilen kaynaklar 3 kitap

📖

Önerilen

Next Generation Excel

Isaac Gottlieb

Second Edition · John Wiley & Sons Singapore Pte. Ltd.

📖

Önerilen

Succeeding in Business with Microsoft Office Excel 2013: A Problem-Solving Approach

Debra Gross, Frank Akaiwa

Karleen Nordquist · 2013

📖

Önerilen

VBA for Modelers: Developing Decision Support Systems Using Microsoft® Excel

S. Christian Albright

2013 · Cengage Learning

Bu dersi alınca · 7 öğrenme çıktısı

Students will be able to effectively use word processing tools in order to create well-formatted and professional-looking documents.Lab Activities
Students will be able to make meaningful inferences and decisions by analyzing and reporting with the given data.Midterm 1, Lab Activities
Students will be able to retrieve required data from simple and complex tables using functions and tools.Midterm 1, Lab Activities
Students will be able to make predictions and estimations about future cases using tools.Midterm 2, Lab Activities
Students will be able to solve optimization problems with a linear programming approach by using Excel add-ins and practice financial functions for both calculation and decision making.Midterm 2, Lab Activities
Students will be able to apply their understanding of an algorithmic structure by generating and customizing VBA macro codes to conduct automated tasks.Lab Activities, Final
Students will be able to work with the Python environment and use its instruments (modules) by applying basic programming concepts.Lab Activities, Final

Bilkent'in resmî syllabus'ünden. Sağdaki etiket o çıktının hangi değerlendirmeyle ölçüldüğünü söylüyor.

🤖 GenAI politikası

The students enrolled in MAN102 - Introduction to Business II course are required to use AI tools during the lab and when studying at home, specifically when solving self-study tasks, to address problems related to formulas and functions (e.g., using the wrong delimiter) that they have generated. Additionally, they are expected to utilize appropriate AI tools for correcting or updating erroneous code when implementing programming tasks related to VBA and Python.

Ders notları · henüz yok

MAN 102 için defter ekibi henüz not yazmadı.

İlk dosyayı sen atarsan: not, slayt, geçmiş sınav, çözüm, cheat-sheet, ne varsa. defter ekibi öğrenci paylaşımlarından bu dersin notlarını yazar. Drive linki / PDF / ZIP, hepsi olur.

← katalog

Geçmiş GPA dağılımı 41 dönem · ort. 2.31

Dönem	Course CPA
2025-2026 Fall	2.21	6 sec · 110 öğr
2024-2025 Fall	2.41	6 sec · 120 öğr
2024-2025 Summer	2.22	1 sec · 23 öğr
2024-2025 Spring	2.06	5 sec · 154 öğr
2023-2024 Fall	2.16	4 sec · 95 öğr
2023-2024 Summer	1.92	1 sec · 24 öğr
2023-2024 Spring	1.81	7 sec · 176 öğr
2022-2023 Fall	2.10	4 sec · 81 öğr
2022-2023 Summer	2.14	1 sec · 24 öğr
2022-2023 Spring	1.87	7 sec · 160 öğr

Aggregate course GPA · Bilkent STARS'tan public data. Hoca-bazlı per-section detayı için STARS evaluation report →. Öğrenci anket cevapları KVKK kapsamında defter'de tutulmaz. Tüm derslerin ortalamaları →

Bu dönem · 2026-2027 Güz · 6 şube · 120 kontenjan

haftada 3 saat ders

Haftalık ızgarada 4 saat görünüyor, kayıt sistemi dersi 3 saat yazıyor. Aradaki 1 saat yedek saat: Bilkent programlarında derse genelde bir fazla saat ayrılır ve çoğu zaman kullanılmaz. Hangisinin düşeceği dönem başlayınca belli olur.

Ceren Aydoğmuş

Sal08:30–10:20Per13:30–15:20

kişilik

Ceren Aydoğmuş

Sal10:30–12:20Per15:30–17:20

kişilik

Ceren Aydoğmuş

Pzt13:30–15:20Per08:30–10:20

kişilik

Tolga Baycan

Pzt10:30–12:20Çar15:30–17:20

kişilik

Tolga Baycan

Sal13:30–15:20Cum08:30–10:20

kişilik

Tolga Baycan

Sal15:30–17:20Cum10:30–12:20

kişilik

programıma ekle → CGPA'ya ekle kayıt tarihleri

Her dönem açılıyorSon yıllarda 14 güz ve 20 bahar döneminde açılmış. Yaz okulunda da 9 kez açılmış. Kaçırırsan bir sonraki dönem tekrar bulabilirsin.

⚠️ FZ engelleyen şartlar

Students who do not score 30 out of 70 on the pre-final activities will be unable to take the final exam and will automatically receive an FZ Grade.

Hocalar 2 bu dönem · 11 geçmiş

Bu dönem (2026-2027 Fall) · 6 section

Ceren Aydoğmuş ×3, Tolga Baycan ×3

Geçmişte ders veren (11 kişi)

Özgür Tolga Baycan, Lale Gümüşlüoğlu, Sibel Uğurlubilek, Frederick Joseph Woolley, Kadire Zeynep Sayım Yazal, Murat Özsoy, Lori Rae Russell Dağ, Nejat Çapar, Erdal Erel, Geoff Holmes, Carmen Olsen

Bu ders 1 bölümün müfredatında zorunlu.

İşletme1. sınıf Bahar

Kutulardaki sınıf ve dönem, o bölümün müfredatının dersi hangi sırada önerdiği. Dersin fiilen hangi dönem açıldığı ayrı bir şey.

Bunu alınca açılanlar · 1 ders MAN 102'i ön koşul sayıyor

MAN 335Fundamentals of Marketing