Dokuz Eylül University Information Package / Courses Catalog

Description of Individual Course Units

Course Unit Code	Course Unit Title	Type Of Course	D	U	L	ECTS
FSH 0048	EXCEL FOR BUSINESS WORLD	ELECTIVE	2	0	0	2

Offered By

Faculty Of Science

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSOCIATE PROFESSOR ENGIN YILDIZTEPE

Offered to

Chemistry
Biology
Computer Science
Statistics
Mathematics (English)
Faculty Of Science
Physics

Course Objective

The aim of this course is to enable students to use the Excel tool effectively for data manipulation, tables and reporting.

Learning Outcomes of the Course Unit

1	To be able to organize data in spreadsheets
2	To be able to generate summary tables and graphs
3	To be able to use built-in functions

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week	Subject	Description
1	Introduction to Excel; ribbon interface, file types
2	Formatting Cells, Data Types
3	Managing worksheets, formulas
4	Using Excel as a database, to sort data, to filter data
5	Excel functions; math, statistical functions
6	Excel functions; text, date functions
7	Conditional expressions
8	List management and look up functions
9	Conditional Formatting
10	Creating charts
11	Creating pivot tables
12	Pivot tables and charts
13	Data validation
14	Data sharing with other applications

Recomended or Required Reading

Wayne L. Winston, Microsoft Excel 2019: Data Analysis and Business Modeling, 6th Ed., Microsoft Press, 2019
Supplementary source(s):
1. Karl W. Broman & Kara H. Woo, (2018) Data Organization in Spreadsheets, The American Statistician, 72:1, 2-10
2. Materials, Lecture slides

Planned Learning Activities and Teaching Methods

Lecture, presentations, applications in computer lab.

Assessment Methods

SORTING NUMBER	SHORT CODE	LONG CODE	FORMULA
1	MTE	MIDTERM EXAM
2	FIN	FINAL EXAM
3	FCG	FINAL COURSE GRADE	MTE * 0.50 + FIN * 0.50
4	RST	RESIT
5	FCGR	FINAL COURSE GRADE (RESIT)	MTE * 0.50 + RST * 0.50

Further Notes About Assessment Methods

None

Assessment Criteria

Evaluation of exams

Language of Instruction

Turkish

Course Policies and Rules

Attendance to at least 70% for the lectures is an essential requirement of this course and is the responsibility of the student. It is necessary that attendance to the lecture and homework delivery must be on time. Any unethical behavior that occurs either in presentations or in exams will be dealt with as outlined in school policy. You can find the undergraduate policy at https://fen.deu.edu.tr/

Contact Details for the Lecturer(s)

DEU Fen Fakültesi Istatistik Bölümü
e-mail: engin.yildiztepe@deu.edu.tr
Tel: 0 232 301 8604

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities	Number	Time (hours)	Total Work Load (hours)
Lectures	14	2	28
Preparations before/after weekly lectures	13	1	13
Preparation for midterm exam	1	4	4
Preparation for final exam	1	4	4
Midterm	1	1	1
Final	1	1	1
TOTAL WORKLOAD (hours)			51

Contribution of Learning Outcomes to Programme Outcomes

PO/LO	PO.1	PO.2	PO.3	PO.4	PO.5	PO.6	PO.7	PO.8	PO.9	PO.10	PO.11	PO.12	PO.13	PO.14
LO.1	1	1	1	1	1	2	1	2	1	1	1	1	1	1
LO.2	1	1	1	1	1	2	1	2	1	1	1	1	1	1
LO.3	1	1	1	1	1	2	1	2	1	1	1	1	1	1

COURSE UNIT TITLE

DEGREE PROGRAMMES

Description of Individual Course Units

Offered By

Level of Course Unit

Course Coordinator

Offered to

Course Objective

Learning Outcomes of the Course Unit

Mode of Delivery

Prerequisites and Co-requisites

Recomended Optional Programme Components

Course Contents

Recomended or Required Reading

Planned Learning Activities and Teaching Methods

Assessment Methods

Further Notes About Assessment Methods

Assessment Criteria

Language of Instruction

Course Policies and Rules

Contact Details for the Lecturer(s)

Office Hours

Work Placement(s)

Workload Calculation

Contribution of Learning Outcomes to Programme Outcomes

CONTACT INFORMATION