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 |
|
|
Program Outcomes |
Level of Contribution |
1) |
1. Acquainting oneself with technologic developments which have effect on new media area.
2. Gaining the theoretical infrastructure controling the influence flow within social media, society and digital culture.
3. Implementing digital communication on productive and strategic projects by using the right applications.
4. Wining theoretical and factual infrastructure to use data which can reach the right information in an ethical way. |
|
2) |
1.Designing, strategizing and managing related processes as an active actor of the new media at the center of all transformations and changes, especially production, marketing, journalism, social relations.
2.Being able to comprehend the interdisciplinary structure of the new media and the tendency to work with traditional media such as newspapers, radio and TV, and to produce interactive content in this direction.
3.Generating a new generation of news in the context of news gathering and writing transformations; to be a new media correspondent, editor or producer in newspapers, radio or TV institutions carrying publishing activities on the Internet and mobile media.
4.Designing, producing and implementing content for public and private organizations with disciplines as public relations, trade, advertising for effective reach to target audience, productivity and competitive advantage.
5. Solving the crisis based new media at the institutions and to produce parallel strategies to the new situation.
6.Portal management, learning and implementation of stages in web design areas. |
|
3) |
1.Entrepreneurship that to be able to present thoughts and creativity in all new media platforms like web, newspaper, blog, e-commerce.
2.Informative, entertaining content production based on social existence, sharing and interaction in social media.
3.To be able to perform the profession as a team member and fulfill the responsibilities, while remaining committed to ethical values.
4.Paying attention to the fair representation of the views of all parties within the framework of accountability, equal approach to the parties and not misleading. |
|
4) |
1. Comprehension of media literacy skills in the process of news gathering.
2. Learning how to effectively use and develop new media platforms.
3. Comprehension of conceptual connections between media and politics
4. To be able to understand and question the basic principles of mass communication and the place and importance of mass communication.
5. Developing a perspective of being able to analyze and tired of economic politics, social, political and cultural influences of mass communication. |
|
5) |
1. communicating with digital agencies about new media projects in order to be a part of the solution.
2. Sharing the solution suggestions on communication area using qualitative and quantitative research.
3. Organizing and implementing projects and events for one'ssocial environment using the digital communication formats in a creative way. |
|
6) |
1. Understanding the basic principles and doctrines of communication and foprming a point of view.
2. Understanding and evaluating theoritical approach on communication.
3. Comprehension of criticism on media theories.
4. In Turkey and in the world assessing industry 4.0 strategies, Making the analysis of the practices.
5. Solving possible crises in the institutions by evaluating all technological, political and economic developments that will affect the new media field and producing parallel strategies to the new situation |
|