ISTANBUL OKAN UNIVERSITY INFORMATION PACKAGE / COURSE CATALOGUE
| Public Relations and Advertising | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
General course introduction information
| Course Code: | ISLT290 | ||||||||
| Course Name: | Advanced Excel Applications | ||||||||
| Course Semester: | Spring | ||||||||
| Course Credits: |
|
||||||||
| Language of instruction: | TR | ||||||||
| Course Requisites: | |||||||||
| Does the Course Require Work Experience?: | No | ||||||||
| Type of course: | University 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) 1. Comprehending theories of interpersonal communication, 2. Know the basic concepts and practices of public relations and advertising, | |||||
| 2) 1. Understanding the basic principles and principles of communication and developing a point of view in this direction, 2. Be able to understand and interpret theoretical approaches in the field of communication, 3. Mass communicaiton theories and their comprehension and discussion to relation between the activities of professional communicators, 4. Use of information related to the fields of communication science, business management, marketing, sociology, organizational behavior, economics, political science, law, scientific research and cultural studies into public relations and advertising discipline, 5. Knowing all elements of marketing communication; strategy development, research, planning and application in issues advertisement, public relations, sales, direct marketing and e-communication, 6. Data compilation, application, analysis and interpretation of results, 7. Apply to the field and solve problems of basic behavioral sciences, 8. Ability to plan, define, model and solve related to public relations campaigns, 9. Understanding the interaction between public relations and management which is a business function, 10. Necessary research for a successful public relations application, definition of objectives, identifying target groups and corresponding messages to these, choosing the right councils and evaluating the results, 11. Related to advertising campaigns planning, definition, modelling and ability to solve, 12. Acquire and use managerial skills in the advertising sector, 13. Media research, planning and purchasing knowledge and skills, 14. Design and implement to the advertisement materials for various advertisement channels | |||||
| 3) 1. Make active presentations using appropriate announcement texts and visual aids for speeches and meetings; be able to express oneself and present a project, 2. Working as a team member and taking responsibility, 3. Resolve possible crises in institutions by assessing political, economic and technological all developments that will affect the field of public relations and to produce parallel strategies to the new situation, 4. Recognizing, understanding and designing elements of successful corporate communication, 5. Supply the stated or felt requirements, public relations services development in accordance with accepted professional standards, 6. Apply creative thinking methods and techniques, | |||||
| 4) 1. Comprehending media literacy skills in the news taking process, 2. Comprehension of conceptual connections between public relations, advertising and politics, 3. Having knowledge and interpretation about the periodical processes of advertising, 4. Identify market research required for advertisement implementations and be able to evaluate in terms of advertising, | |||||
| 5) 1. Ability to follow the development of education, science and technology and to recognize and describe the interaction of these elements with communication processes, 2. Applying to public relations, advertising and communication fields following new methods and technologies, 3. To use information communication technologies strategically within advertising and marketing, 4. To be able to comprehend and use contemporary techniques and software in the field of visual design, 5. To be able to follow national and international the contemporary problems, threads in the field of advertising, 6. To create a true dialectic mental, psychological and moral conditions with the Public Relations practices and acknowledging that the parties have the right to disclose their own situation and views, 7. Take care of the truth in Public Relations practices, to disseminate of information that is not based on sustainable and preconceived facts, 8. In Public Relations messages prepared for the promotion of products with regard to young people and children, they will damage their trust feelings, taking care to avoid no content that will affect psychological and physical weaknesses, 9. When practicing their profession, take care to ensure fair representation of the views of all interested parties, 10. Respecting the principle of confidentiality of confidential information that can be obtained by professions, 11. Pay attention to the fact that communication by their profession is based on open, correct, bi-directional and fully informed. 12. Where it is necessary to compete in a personal or institutional level, disuses the personal / institutional links that would unfairly affect competition; secondary undertaken tasks etc. as it will serve this purpose, 13. To prevent discrimination and promote the development of positive discrimination in intra-agency communication, 14. Supporting precautionary approaches to environmental problems in the business world, 15. To support all kinds of activities and formation that will increase environmental responsibility, 16. To support the development and diffusion of environmental friendly technologies, | |||||
| 6) 1. Understand social organizations and institutions, family, religious institutions and their relationship with communication, 2. Carry out public relations and advertising practices based on a common and broad knowledge base, academic studies, researchs, ethical principles and performance auditing, 3. To know and understand the quality concept in public relations and advertisement, 4. In Turkey and in the world of brand management strategy evaluation, implement brand strategies and analyze various campaigns, 5. Targeting to receive a quality certificate, performance audit and to apply continuously systems to improve the quality, 6. Applying the Public Relations profession not only to the institution but also to oversee the benefit of collecting, 7. Identify messages that are appropriate for the target audience in the advertisement and choosing the right councils and evaluating the results, 8. To be able to interpret legal regulations intented for communication and advertisement field, 9. To recognize the basic principles of concord, manage the processes of concord or to work get a job in these processes, 10. Recognition of ethical principles in the International Advertising Practice Guidelines; in this respect, advertising applications integrity, honesty, social responsibility, protection of children and young people, respect for personal rights, sensitivity to health and environment, to be able to evaluate in terms of subjects such as the protection of the consumer, 11. To design, plan, implement and evaluate communication activities with the belief that all individuals should benefit from the rights arising from the Universal Declaration of Human Rights, 12. Protecting and respecting human dignity in communication activities, ensuring that everyone has their own judgment, 13. Under all conditions, in public relations practies, to behove in shape of protecting mutuall interests are served both by this assocation and by this assocation of public societies, 14. Performing public relations and advertising profession so as not to damage the public interest, 15. Observing that the communication they establish by aiming to create mutual understanding during their professional activities is not harmful attribution to the cultural values and beliefs of society in terms of both legal and ethical, 16. Acting in harmony with articles the Idea and Artworks Law during the works, 17. Do not accept tasks that are contrary to the principles of professional ethics, 18. Work to protect and upgrade the reputation and prestige of the profession, 19. Do not be in comments and behaviors that would damage the reputation of your colleagues, 20. Respect for the Press Professional Principles with the freedom of the media to receive information and to inform the public, 21. The blogs, forums, video and photo sharing sites and similiar social media tools are enriching in the sense of changing and reflecting public opinion therefore in those channels professional activities the identity of the representatives in these meetings in terms of transparency principle, 22. Do not mislead public opinion or its representatives, 23. Do not use blackmail, bribe and repression, 24. As a public relations expert, do not sign a contract with a client or employer that guarantees quantitative results, 25. Not to be included in the initiatives and commitments in feature that are contradictory to social rules, dishonest, damage human dignity and character, 26. To promote and respect human rights declared in the business world, 27. Not being complicit of human rights violations in the business world, 28. To oppose all kinds of child labor, 29. Fighting corruption in the business world, 30. To struggle with corruption in the business world, 31. To carry out professional practices in order to not violate the ethical principles in purview public relations and advertising. | |||||
Course - Learning Outcome Relationship
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | 1. Comprehending theories of interpersonal communication, 2. Know the basic concepts and practices of public relations and advertising, | |
| 2) | 1. Understanding the basic principles and principles of communication and developing a point of view in this direction, 2. Be able to understand and interpret theoretical approaches in the field of communication, 3. Mass communicaiton theories and their comprehension and discussion to relation between the activities of professional communicators, 4. Use of information related to the fields of communication science, business management, marketing, sociology, organizational behavior, economics, political science, law, scientific research and cultural studies into public relations and advertising discipline, 5. Knowing all elements of marketing communication; strategy development, research, planning and application in issues advertisement, public relations, sales, direct marketing and e-communication, 6. Data compilation, application, analysis and interpretation of results, 7. Apply to the field and solve problems of basic behavioral sciences, 8. Ability to plan, define, model and solve related to public relations campaigns, 9. Understanding the interaction between public relations and management which is a business function, 10. Necessary research for a successful public relations application, definition of objectives, identifying target groups and corresponding messages to these, choosing the right councils and evaluating the results, 11. Related to advertising campaigns planning, definition, modelling and ability to solve, 12. Acquire and use managerial skills in the advertising sector, 13. Media research, planning and purchasing knowledge and skills, 14. Design and implement to the advertisement materials for various advertisement channels | |
| 3) | 1. Make active presentations using appropriate announcement texts and visual aids for speeches and meetings; be able to express oneself and present a project, 2. Working as a team member and taking responsibility, 3. Resolve possible crises in institutions by assessing political, economic and technological all developments that will affect the field of public relations and to produce parallel strategies to the new situation, 4. Recognizing, understanding and designing elements of successful corporate communication, 5. Supply the stated or felt requirements, public relations services development in accordance with accepted professional standards, 6. Apply creative thinking methods and techniques, | |
| 4) | 1. Comprehending media literacy skills in the news taking process, 2. Comprehension of conceptual connections between public relations, advertising and politics, 3. Having knowledge and interpretation about the periodical processes of advertising, 4. Identify market research required for advertisement implementations and be able to evaluate in terms of advertising, | |
| 5) | 1. Ability to follow the development of education, science and technology and to recognize and describe the interaction of these elements with communication processes, 2. Applying to public relations, advertising and communication fields following new methods and technologies, 3. To use information communication technologies strategically within advertising and marketing, 4. To be able to comprehend and use contemporary techniques and software in the field of visual design, 5. To be able to follow national and international the contemporary problems, threads in the field of advertising, 6. To create a true dialectic mental, psychological and moral conditions with the Public Relations practices and acknowledging that the parties have the right to disclose their own situation and views, 7. Take care of the truth in Public Relations practices, to disseminate of information that is not based on sustainable and preconceived facts, 8. In Public Relations messages prepared for the promotion of products with regard to young people and children, they will damage their trust feelings, taking care to avoid no content that will affect psychological and physical weaknesses, 9. When practicing their profession, take care to ensure fair representation of the views of all interested parties, 10. Respecting the principle of confidentiality of confidential information that can be obtained by professions, 11. Pay attention to the fact that communication by their profession is based on open, correct, bi-directional and fully informed. 12. Where it is necessary to compete in a personal or institutional level, disuses the personal / institutional links that would unfairly affect competition; secondary undertaken tasks etc. as it will serve this purpose, 13. To prevent discrimination and promote the development of positive discrimination in intra-agency communication, 14. Supporting precautionary approaches to environmental problems in the business world, 15. To support all kinds of activities and formation that will increase environmental responsibility, 16. To support the development and diffusion of environmental friendly technologies, | |
| 6) | 1. Understand social organizations and institutions, family, religious institutions and their relationship with communication, 2. Carry out public relations and advertising practices based on a common and broad knowledge base, academic studies, researchs, ethical principles and performance auditing, 3. To know and understand the quality concept in public relations and advertisement, 4. In Turkey and in the world of brand management strategy evaluation, implement brand strategies and analyze various campaigns, 5. Targeting to receive a quality certificate, performance audit and to apply continuously systems to improve the quality, 6. Applying the Public Relations profession not only to the institution but also to oversee the benefit of collecting, 7. Identify messages that are appropriate for the target audience in the advertisement and choosing the right councils and evaluating the results, 8. To be able to interpret legal regulations intented for communication and advertisement field, 9. To recognize the basic principles of concord, manage the processes of concord or to work get a job in these processes, 10. Recognition of ethical principles in the International Advertising Practice Guidelines; in this respect, advertising applications integrity, honesty, social responsibility, protection of children and young people, respect for personal rights, sensitivity to health and environment, to be able to evaluate in terms of subjects such as the protection of the consumer, 11. To design, plan, implement and evaluate communication activities with the belief that all individuals should benefit from the rights arising from the Universal Declaration of Human Rights, 12. Protecting and respecting human dignity in communication activities, ensuring that everyone has their own judgment, 13. Under all conditions, in public relations practies, to behove in shape of protecting mutuall interests are served both by this assocation and by this assocation of public societies, 14. Performing public relations and advertising profession so as not to damage the public interest, 15. Observing that the communication they establish by aiming to create mutual understanding during their professional activities is not harmful attribution to the cultural values and beliefs of society in terms of both legal and ethical, 16. Acting in harmony with articles the Idea and Artworks Law during the works, 17. Do not accept tasks that are contrary to the principles of professional ethics, 18. Work to protect and upgrade the reputation and prestige of the profession, 19. Do not be in comments and behaviors that would damage the reputation of your colleagues, 20. Respect for the Press Professional Principles with the freedom of the media to receive information and to inform the public, 21. The blogs, forums, video and photo sharing sites and similiar social media tools are enriching in the sense of changing and reflecting public opinion therefore in those channels professional activities the identity of the representatives in these meetings in terms of transparency principle, 22. Do not mislead public opinion or its representatives, 23. Do not use blackmail, bribe and repression, 24. As a public relations expert, do not sign a contract with a client or employer that guarantees quantitative results, 25. Not to be included in the initiatives and commitments in feature that are contradictory to social rules, dishonest, damage human dignity and character, 26. To promote and respect human rights declared in the business world, 27. Not being complicit of human rights violations in the business world, 28. To oppose all kinds of child labor, 29. Fighting corruption in the business world, 30. To struggle with corruption in the business world, 31. To carry out professional practices in order to not violate the ethical principles in purview public relations and advertising. |
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 |
| Attendance | 14 | % 10 |
| Midterms | 1 | % 40 |
| 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 | |