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) |
Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied information in these areas to model and solve engineering problems. |
|
2) |
Ability to identify, formulate, and solve complex engineering problems; ability to select and apply proper analysis and modelling methods for this purpose. |
|
3) |
Ability to design a complex system, process, device or product under realistic constraints and conditions, in such a way so as to meet the desired result; ability to apply modern design methods for this purpose. (Realistic constraints and conditions may include factors such as economic and environmental issues, sustainability, manufacturability, ethics, health, safety isuues, and social and political issues according to the nature of the design.) |
|
4) |
Ability to devise, select, and use modern techniques and tools needed for engineering practice; ability to employ information technologies effectively. |
|
5) |
Ability to design and conduct experiments, gather data, analyse and interpret results for investigating engineering problems. |
|
6) |
Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually. |
|
7) |
Ability to communicate effectively i Turkish, both orally and in writing; knowledge of a minimum of one foreign language. |
|
8) |
Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself. |
|
9) |
Awareness of professional and ethical responsibility. |
|
10) |
Information about business life practices such as project management, risk management, and change management; awareness of entrepreneurship, innovation, and sustainable development. |
|
11) |
Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of engineering solutions. |
|