BST152 IT ApplicationsIstanbul Okan UniversityDegree Programs Sport ManagementGeneral Information For StudentsDiploma SupplementErasmus Policy StatementNational Qualifications
Sport Management
Bachelor TR-NQF-HE: Level 6 QF-EHEA: First Cycle EQF-LLL: Level 6

General course introduction information

Course Code: BST152
Course Name: IT Applications
Course Semester: Fall
Course Credits:
Theoretical Practical Credit ECTS
3 0 3 6
Language of instruction: TR
Course Requisites:
Does the Course Require Work Experience?: No
Type of course: University Elective
Course Level:
Bachelor TR-NQF-HE:6. Master`s Degree QF-EHEA:First Cycle EQF-LLL:6. Master`s Degree
Mode of Delivery: Face to face
Course Coordinator : Dr.Öğr.Üyesi İLKER CALAYOĞLU
Course Lecturer(s):



Course Assistants:

Course Objective and Content

Course Objectives: The aim is to prepare professional documents using computer use, file management, word processing, presentation and number processing software.
Course Content: Creating text, formatting, creating and managing tables, pictures and shapes using word processing programs; addressing with number processing programs, calculating with formulas, basic data analysis, performing pivot table and graphic operations.

Learning Outcomes

The students who have succeeded in this course;
Learning Outcomes
1 - Knowledge
Theoretical - Conceptual
2 - Skills
Cognitive - Practical
1) Can use word processing software effectively.
2) Can use presentation processor software effectively.
3) Can use number processing software effectively.
3 - Competences
Communication and Social Competence
Learning Competence
1) Compiles, organizes and summarizes data.
2) To analyzes the data by reaching the desired ones from the mass data.
Field Specific Competence
Competence to Work Independently and Take Responsibility

Lesson Plan

Week Subject Related Preparation
1) Word 2019 – File and View Tab, Window Applications
2) Word 2019 – Home, Insert and Design Tab
3) Word 2019 – Page Layout, References and Mail Tab
4) Word 2019 – Review, View and Developer Tab
5) Power Point 2019 – Insert, Design, Transitions and Animation Tabs
6) Excel 2019 - Basic Excel Usage, Creating Tables and Formatting Cells
7) Excel 2019 - Doing Four Operations/Working with Worksheets and Books and Absolute Addressing
8) Excel 2019 - Logical and Mathematical Functions
9) Excel 2019 – Working with Search Formulas
10) Excel 2019 – Working with Data Lists, Data Validation, and Conditional Formatting
11) Excel 2019 – Working with Data Lists, Data Validation, and Conditional Formatting
12) Excel 2019 - Chart Types, Creation and Formatting
13) Excel 2019 – Pivot Chart and Advanced Charting
14) Excel 2019 – Working with Solver

Sources

Course Notes / Textbooks: Öğretim üyesinin belge paylaşımları
References: Microsoft Office 2016, Osman Gürkan, Nirvana Yayınları
Microsoft Word 2010 Step by Step (Step By Step (Microsoft)) by Joyce Cox and Joan Lambert III (Jun 23, 2010)

Course-Program Learning Outcome Relationship

Learning Outcomes

1

2

3

4

5

Program Outcomes
1) Sports management students have advanced level theoretical and practical knowledge supported by textbooks, application tools and other resources which contain up-to-date information in the field.
2) Sport management students can transfer their opinions and suggestions for solutions to problems in written and orally, and share their ideas and solutions with problems by supporting them with qualitative and quantitative data.
3) Sports management students act in accordance with social, scientific, cultural and ethical values in the stages of collecting, interpreting, applying and announcing the data related to the field.
4) Sports management students can use the advanced theoretical and practical knowledge gained in the field and use the advanced knowledge and skills in the field to interpret and evaluate the data, to identify problems, to analyze problems, to develop solutions based on research and evidence.
5) Sports management students can conduct an advanced study independently and take responsibility as an individual and team member in order to solve unforeseen complex problems encountered in the applications related to their field.

Course - Learning Outcome Relationship

No Effect 1 Lowest 2 Low 3 Average 4 High 5 Highest
           
Program Outcomes Level of Contribution
1) Sports management students have advanced level theoretical and practical knowledge supported by textbooks, application tools and other resources which contain up-to-date information in the field.
2) Sport management students can transfer their opinions and suggestions for solutions to problems in written and orally, and share their ideas and solutions with problems by supporting them with qualitative and quantitative data.
3) Sports management students act in accordance with social, scientific, cultural and ethical values in the stages of collecting, interpreting, applying and announcing the data related to the field.
4) Sports management students can use the advanced theoretical and practical knowledge gained in the field and use the advanced knowledge and skills in the field to interpret and evaluate the data, to identify problems, to analyze problems, to develop solutions based on research and evidence.
5) Sports management students can conduct an advanced study independently and take responsibility as an individual and team member in order to solve unforeseen complex problems encountered in the applications related to their field.

Learning Activity and Teaching Methods

Expression
Lesson
Lab
Homework
Problem Solving

Assessment & Grading Methods and Criteria

Homework
Application

Assessment & Grading

Semester Requirements Number of Activities Level of Contribution
Homework Assignments 1 % 40
Final 1 % 60
total % 100
PERCENTAGE OF SEMESTER WORK % 40
PERCENTAGE OF FINAL WORK % 60
total % 100

Workload and ECTS Credit Grading

Activities Number of Activities Duration (Hours) Workload
Course Hours 15 3 45
Study Hours Out of Class 14 6 84
Homework Assignments 1 24 24
Final 1 12 12
Total Workload 165