Mechanical Engineering (English) | |||||
Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 |
Course Code: | ISLT290 | ||||||||
Course Name: | İleri Excel Uygulamaları | ||||||||
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) Sufficient knowledge in mathematics, science and engineering related to their branches; and the ability to apply theoretical and practical knowledge in these areas to model and solve engineering problems. | ||||||||||||
2) The ability to identify, formulate, and solve complex engineering problems; selecting and applying appropriate analysis and modeling methods for this purpose. | ||||||||||||
3) The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose. (Realistic constraints and conditions include such issues as economy, environmental issues, sustainability, manufacturability, ethics, health, safety, social and political issues, according to the nature of design.) | ||||||||||||
4) Ability to develop, select and use modern techniques and tools necessary for engineering applications; ability to use information technologies effectively. | ||||||||||||
5) Ability to design experiments, conduct experiments, collect data, analyze and interpret results to examine engineering problems or discipline-specific research topics. | ||||||||||||
6) The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill. | ||||||||||||
7) Effective communication skills in Turkish oral and written communication; at least one foreign language knowledge; ability to write effective reports and understand written reports, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions. | ||||||||||||
8) Awareness of the need for lifelong learning; access to knowledge, ability to follow developments in science and technology, and constant self-renewal. | ||||||||||||
9) Conform to ethical principles, and standards of professional and ethical responsibility; be informed about the standards used in engineering applications. | ||||||||||||
10) Awareness of applications in business, such as project management, risk management and change management; awareness of entrepreneurship, and innovation; information about sustainable development. | ||||||||||||
11) The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill. | ||||||||||||
12) In order to gain depth at least one, physics knowledge based on chemistry knowledge and mathematics; advanced mathematical knowledge, including multivariable mathematical and differential equations; familiarity with statistics and linear algebra. | ||||||||||||
13) The ability to work in both thermal and mechanical systems, including the design and implementation of such systems. |
No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
Program Outcomes | Level of Contribution | |
1) | Sufficient knowledge in mathematics, science and engineering related to their branches; and the ability to apply theoretical and practical knowledge in these areas to model and solve engineering problems. | |
2) | The ability to identify, formulate, and solve complex engineering problems; selecting and applying appropriate analysis and modeling methods for this purpose. | |
3) | The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose. (Realistic constraints and conditions include such issues as economy, environmental issues, sustainability, manufacturability, ethics, health, safety, social and political issues, according to the nature of design.) | |
4) | Ability to develop, select and use modern techniques and tools necessary for engineering applications; ability to use information technologies effectively. | |
5) | Ability to design experiments, conduct experiments, collect data, analyze and interpret results to examine engineering problems or discipline-specific research topics. | |
6) | The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill. | |
7) | Effective communication skills in Turkish oral and written communication; at least one foreign language knowledge; ability to write effective reports and understand written reports, to prepare design and production reports, to make effective presentations, to give and receive clear and understandable instructions. | |
8) | Awareness of the need for lifelong learning; access to knowledge, ability to follow developments in science and technology, and constant self-renewal. | |
9) | Conform to ethical principles, and standards of professional and ethical responsibility; be informed about the standards used in engineering applications. | |
10) | Awareness of applications in business, such as project management, risk management and change management; awareness of entrepreneurship, and innovation; information about sustainable development. | |
11) | The ability to work effectively in disciplinary and multidisciplinary teams; individual work skill. | |
12) | In order to gain depth at least one, physics knowledge based on chemistry knowledge and mathematics; advanced mathematical knowledge, including multivariable mathematical and differential equations; familiarity with statistics and linear algebra. | |
13) | The ability to work in both thermal and mechanical systems, including the design and implementation of such systems. |
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 |