COURSE UNIT TITLE

Offered By

Statistics

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ASSISTANT PROFESSOR ENGIN YILDIZTEPE

Offered to

Statistics
Statistics(Evening)

Course Objective

This course aims to learn students the VBA macro development, to use Excel effectively in data manipulation, tabulation and reporting.

Learning Outcomes of the Course Unit

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Recomended or Required Reading

Textbook(s):
Wayne L. Winston, Microsoft Excel 2019: Data Analysis and Business Modeling, 6th Ed., Microsoft Press, 2019.
Supplementary Book(s):
1. Alexander, M., & Kusleika, D. (2016). Excel 2016 power programming with VBA. Wiley.
2. Held, B., Moriarty, B., & Richardson, T. (2019). Microsoft Excel Functions and Formulas. Stylus Publishing, LLC.
3. Karl W. Broman & Kara H. Woo (2018) Data Organization in Spreadsheets, The American Statistician, 72:1, 2-10
4. Materials, Lecture slides

Planned Learning Activities and Teaching Methods

Lecture, homework assignments, examples and PC laboratory exercises.

Assessment Methods

Further Notes About Assessment Methods

None

Assessment Criteria

Evaluation of exams and homeworks

Language of Instruction

English

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 http://web.deu.edu.tr/fen

Contact Details for the Lecturer(s)

DEU Faculty of Science Department of Statistics
e-mail: engin.yildiztepe@deu.edu.tr
Phone:+90 232 301 86 04

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Contribution of Learning Outcomes to Programme Outcomes