ISTANBUL OKAN UNIVERSITY INFORMATION PACKAGE / COURSE CATALOGUE
| Business Administration (English) | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
General course introduction information
| Course Code: | BBA290 | ||||||||
| Course Name: | Advanced Excel Applications | ||||||||
| Course Semester: |
Spring |
||||||||
| Course Credits: |
|
||||||||
| Language of instruction: | EN | ||||||||
| Course Requisites: | |||||||||
| Does the Course Require Work Experience?: | No | ||||||||
| Type of course: | Faculty Elective | ||||||||
| Course Level: |
|
||||||||
| Mode of Delivery: | Face to face | ||||||||
| Course Coordinator : | Dr.Öğr.Üyesi İLKER CALAYOĞLU | ||||||||
| Course Lecturer(s): |
Dr.Öğr.Üyesi İLKER CALAYOĞLU |
||||||||
| Course Assistants: |
Course Objective and Content
| Course Objectives: | The aim of this course is to enable students to gain the ability to calculate, report, summarize and analyze excel skills. Thus they will be more functional at the internship and at the workplace. |
| Course Content: | Basic Excel use; working with worksheets and books; working with data lists; conditional and unconditional formatting; working with graphics; logical and mathematical functions; statistical functions; financial functions; subtotals, preparing tables and summary table analysis; pivot tables; macros; data analysis. |
Learning Outcomes
The students who have succeeded in this course;
|
||||||||||||||||||||||||||||||||||||
Lesson Plan
| Week | Subject | Related Preparation |
| 1) | • Describe to the course. • Define the course to the students • Syllabus • Discuss to course topics • Discuss to course outline | |
| 2) | • Saves the active document. • Change the type of file. • Recovery the Files • Document management • Saving types • Difference between save and save as | |
| 3) | • Conditional and unconditional cell formatting • Using of cell styles. • Working with name of cells • Adding, deleting and managing to row and columns • Adding, deleting and managing to worksheets • Formatting to cells • Formatting to worksheets • Data validation | Reads from book about cell and worksheet formatting. |
| 4) | • Makes transaction between workbooks. • Manages the workbook view. • Works with windows. • Work with workbook • Build a bridge | Reads from book about workbook. |
| 5) | • Sort and filter data. • Works with subtotals. • Data is grouped and leveling. • Transaction of database • Sort and filter data. • Get subtotals of data • Data grouping and leveling. | Reads from book about database |
| 6) | • Draw graphics. • Set the graphic design. • Creates graphic labels. • Graphic formats. • Working with Graphics | reads from book about graphics |
| 7) | • Creates pivot table • Filter Data • Creates alternative summary tables. • Creates pivot graph | Chapter 8 – Lecturing and practice |
| 8) | midterm exam | |
| 9) | • Analyze statistical functions. • Analyze financial functions. | Chapter 9 – Lecturing and practice |
| 10) | • Analyze the logical functions. • Analyze textual functions. | Reads from book about functions |
| 11) | • Applies the image adding program. • Comments to Vector draws • Saves the SmartArt graphic. • Records to pictures and drawings. | Reads from book about pictures and drawings. |
| 12) | • Creates a macro. • Make changes in the macro and comments. • Delete and rename to macro | Repeating what has been done |
| 13) | • To share documents. • Monitoring changes in the shared workbook. • Protects and encrypts to documents | Reads from book about workbook sharing and its protection |
| 14) | • General options • Formula options • Calculation options • Writing checking options • Save options • Advanced options • Customize the strip | Reads from book about to customize Excel 2010 |
| 15) | final exam |
Sources
| Course Notes / Textbooks: | Microsoft Excel 2010 Gürkan, Osman 2013 Nirvana Yayınları Published: 2013 ISBN: 978-975-8878-76-5 |
| References: | Yok |
Course-Program Learning Outcome Relationship
| Learning Outcomes | 1 |
2 |
4 |
5 |
3 |
||||
|---|---|---|---|---|---|---|---|---|---|
| Program Outcomes | |||||||||
| 1) Explain the essential body of knowledge in the area of business administration, including evolution of the discipline, the state-of-the-art concepts, scientific methodology, theories and models | |||||||||
| 2) Employ the appropriate tools and analytical techniques to collect and analyze quantitative and qualitative data in the related areas, interpret results and propose solutions | |||||||||
| 3) Recognize the importance of technological development, especially in information technologies, and utilize them in business administration | |||||||||
| 4) Evaluate the body of knowledge in the dynamic business world and business functional areas to asses needs, manage and lead change by using critical and innovative thinking | |||||||||
| 5) Discover and create entrepreneurial opportunities and expertise to successfully establish and develop their own ventures | |||||||||
| 6) Fulfill their responsibility in teamwork and projects in businesses, and act as a leader | |||||||||
| 7) Communicate in written and oral English with people from diverse backgrounds, and have the English proficiency to follow and interpret the global dynamics in the areas of business administration | |||||||||
| 8) Recognize individual and multi-cultural diversity, and can emphatically interact with individuals from diverse cultural backgrounds in social and professional settings | |||||||||
| 9) Identify standards of personal, professional, social and business ethics, evaluate the ethical implications of various practices in the related areas, and be aware the importance of ethical behavior in adding value to the society | |||||||||
| 10) Recognize interrelationship among business and other disciplines, and relate knowledge from diverse areas to formulate novel solutions in the area of business administration | |||||||||
Course - Learning Outcome Relationship
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Explain the essential body of knowledge in the area of business administration, including evolution of the discipline, the state-of-the-art concepts, scientific methodology, theories and models | |
| 2) | Employ the appropriate tools and analytical techniques to collect and analyze quantitative and qualitative data in the related areas, interpret results and propose solutions | |
| 3) | Recognize the importance of technological development, especially in information technologies, and utilize them in business administration | |
| 4) | Evaluate the body of knowledge in the dynamic business world and business functional areas to asses needs, manage and lead change by using critical and innovative thinking | |
| 5) | Discover and create entrepreneurial opportunities and expertise to successfully establish and develop their own ventures | |
| 6) | Fulfill their responsibility in teamwork and projects in businesses, and act as a leader | |
| 7) | Communicate in written and oral English with people from diverse backgrounds, and have the English proficiency to follow and interpret the global dynamics in the areas of business administration | |
| 8) | Recognize individual and multi-cultural diversity, and can emphatically interact with individuals from diverse cultural backgrounds in social and professional settings | |
| 9) | Identify standards of personal, professional, social and business ethics, evaluate the ethical implications of various practices in the related areas, and be aware the importance of ethical behavior in adding value to the society | |
| 10) | Recognize interrelationship among business and other disciplines, and relate knowledge from diverse areas to formulate novel solutions in the area of business administration |
Learning Activity and Teaching Methods
| Field Study | |
| Peer Review | |
| Expression | |
| Lesson | |
| Lab | |
| Homework | |
| Problem Solving | |
| Report Writing |
Assessment & Grading Methods and Criteria
| Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
| Homework | |
| Application | |
| Observation | |
| Presentation | |
| Reporting | |
| Bilgisayar Destekli Sunum |
Assessment & Grading
| Semester Requirements | Number of Activities | Level of Contribution |
| Midterms | 1 | % 50 |
| Final | 1 | % 50 |
| total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 50 | |
| PERCENTAGE OF FINAL WORK | % 50 | |
| total | % 100 | |
Workload and ECTS Credit Grading
| Activities | Number of Activities | Workload |
| Course Hours | 13 | 39 |
| Study Hours Out of Class | 13 | 94 |
| Midterms | 1 | 14 |
| Final | 1 | 18 |
| Total Workload | 165 | |