International Trade (English) | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
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 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. |
The students who have succeeded in this course;
|
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 |
Course Notes / Textbooks: | Microsoft Excel 2010 Gürkan, Osman 2013 Nirvana Yayınları Published: 2013 ISBN: 978-975-8878-76-5 |
References: | Yok |
Learning Outcomes | 1 |
2 |
4 |
5 |
3 |
||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Program Outcomes | |||||||||||
1) To have theoretical and practical knowledge at the basic level supported by textbooks, application tools and other resources with current knowledge in the field based on the qualifications gained at the secondary level. | |||||||||||
2) - To gain the ability to use the theoretical and practical knowledge at the basic level at an advanced level or at the same level in the same field. - To be able to interpret and evaluate the data by using the basic knowledge and skills acquired in the field, to identify and analyze the problems, to develop solutions based on evidence. | |||||||||||
3) - To be able to convey his / her thoughts on basic knowledge and skills at the level of written and verbal communication. - To share his / her thoughts and solutions to the problems related to his / her field with experts and non-experts. - To be able to follow information in the field and communicate with colleagues by using a foreign language at least at a level of European Language Portfolio A2 General Level. - To be able to use information and communication technologies together with computer software at the basic level of European Computer Driving License required by the field. | |||||||||||
4) - To be able to evaluate the basic knowledge and skills acquired in the field with a critical approach, to determine and meet the learning needs. - To be able to direct his / her education to an advanced level of education in the same field or to a profession at the same level. - Not to have gained awareness of lifelong learning. | |||||||||||
5) - To have social, scientific, cultural and ethical values in the stages of collecting, applying and announcing the data related to the field. - To have sufficient awareness of the universality of social rights, social justice, quality and cultural values, environmental protection, occupational health and safety. | |||||||||||
6) - To be able to conduct a basic level study independently. - To be able to take responsibility as a team member to solve unforeseen complex problems encountered in the applications related to the field. - To be able to carry out activities for the development of employees working under their responsibility within the framework of a project. | |||||||||||
7) - To have advanced theoretical and practical knowledge supported by textbooks containing current information in the field, application tools and other resources. | |||||||||||
8) To be able to use the advanced theoretical and practical knowledge acquired in the field. - Interpret and evaluate data using the advanced knowledge and skills acquired in the field, identify problems, analyze, develop solutions based on research and evidence. | |||||||||||
9) - To be able to inform the relevant persons and institutions about the related subjects; transfer ideas and solutions to problems in written and orally. - To share his / her thoughts and solutions to the problems related to the field with the experts and non-experts by supporting them with quantitative and qualitative data. -To be able to organize and implement projects and activities for the social environment in which he / she lives with a sense of social responsibility. - To follow the information in his / her field and to communicate with his / her colleagues by using a foreign language at least at the European Language Portfolio B1 General Level. - To be able to use information and communication technologies together with computer software at the Advanced Level of European Computer Driving License required by the field. - To 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. - To have sufficient awareness about the universality of social rights, social justice, quality culture and protection of cultural values, environmental protection, occupational health and safety. | |||||||||||
10) - To be able to critically evaluate the advanced knowledge and skills acquired in the field, - Identify learning needs and direct learning. - To develop positive attitudes about lifelong learning. | |||||||||||
11) To 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. - To have sufficient awareness about the universality of social rights, social justice, quality culture and protection of cultural values, environmental protection, occupational health and safety | |||||||||||
12) - To be able to conduct an advanced study independently. - To be able to take responsibility as an individual and as a team member to solve unforeseen complex problems encountered in the applications related to the field. - To be able to plan and manage activities for the development of employees working under their responsibility. |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution | |
1) | To have theoretical and practical knowledge at the basic level supported by textbooks, application tools and other resources with current knowledge in the field based on the qualifications gained at the secondary level. | |
2) | - To gain the ability to use the theoretical and practical knowledge at the basic level at an advanced level or at the same level in the same field. - To be able to interpret and evaluate the data by using the basic knowledge and skills acquired in the field, to identify and analyze the problems, to develop solutions based on evidence. | |
3) | - To be able to convey his / her thoughts on basic knowledge and skills at the level of written and verbal communication. - To share his / her thoughts and solutions to the problems related to his / her field with experts and non-experts. - To be able to follow information in the field and communicate with colleagues by using a foreign language at least at a level of European Language Portfolio A2 General Level. - To be able to use information and communication technologies together with computer software at the basic level of European Computer Driving License required by the field. | |
4) | - To be able to evaluate the basic knowledge and skills acquired in the field with a critical approach, to determine and meet the learning needs. - To be able to direct his / her education to an advanced level of education in the same field or to a profession at the same level. - Not to have gained awareness of lifelong learning. | |
5) | - To have social, scientific, cultural and ethical values in the stages of collecting, applying and announcing the data related to the field. - To have sufficient awareness of the universality of social rights, social justice, quality and cultural values, environmental protection, occupational health and safety. | |
6) | - To be able to conduct a basic level study independently. - To be able to take responsibility as a team member to solve unforeseen complex problems encountered in the applications related to the field. - To be able to carry out activities for the development of employees working under their responsibility within the framework of a project. | |
7) | - To have advanced theoretical and practical knowledge supported by textbooks containing current information in the field, application tools and other resources. | |
8) | To be able to use the advanced theoretical and practical knowledge acquired in the field. - Interpret and evaluate data using the advanced knowledge and skills acquired in the field, identify problems, analyze, develop solutions based on research and evidence. | |
9) | - To be able to inform the relevant persons and institutions about the related subjects; transfer ideas and solutions to problems in written and orally. - To share his / her thoughts and solutions to the problems related to the field with the experts and non-experts by supporting them with quantitative and qualitative data. -To be able to organize and implement projects and activities for the social environment in which he / she lives with a sense of social responsibility. - To follow the information in his / her field and to communicate with his / her colleagues by using a foreign language at least at the European Language Portfolio B1 General Level. - To be able to use information and communication technologies together with computer software at the Advanced Level of European Computer Driving License required by the field. - To 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. - To have sufficient awareness about the universality of social rights, social justice, quality culture and protection of cultural values, environmental protection, occupational health and safety. | |
10) | - To be able to critically evaluate the advanced knowledge and skills acquired in the field, - Identify learning needs and direct learning. - To develop positive attitudes about lifelong learning. | |
11) | To 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. - To have sufficient awareness about the universality of social rights, social justice, quality culture and protection of cultural values, environmental protection, occupational health and safety | |
12) | - To be able to conduct an advanced study independently. - To be able to take responsibility as an individual and as a team member to solve unforeseen complex problems encountered in the applications related to the field. - To be able to plan and manage activities for the development of employees working under their responsibility. |
Field Study | |
Peer Review | |
Expression | |
Lesson | |
Lab | |
Homework | |
Problem Solving | |
Report Writing |
Written Exam (Open-ended questions, multiple choice, true-false, matching, fill in the blanks, sequencing) | |
Homework | |
Application | |
Observation | |
Presentation | |
Reporting | |
Bilgisayar Destekli Sunum |
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 |
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 |