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) |
Describe the basic structure, development and normal mechanisms of the human in terms of molecules, cells, tissues, organs and systems |
|
2) |
Investigates the abnormal structures and mechanisms in the human body, explains with the information depending on high quality scientific research, evaluates the reason of the diseases regarding in the interaction of the individual with his environment |
|
3) |
Gain knowledge about basic and clinical medicine |
|
4) |
Apply the knowledge, skills and attitudes required by the patient management in accordance with the modern medical concept. |
|
5) |
Apply basic medical procedures necessary for diagnosis and treatment of diseases |
|
6) |
Perform first level treatment for common diseases in the community based on scientific data and by using highly effective methods |
|
7) |
Treat patients in emergency situations and transport the patient when needed |
|
8) |
Perform preventive medicine and forensic medicine applications |
|
9) |
Evaluate the effects of environmental factors on human health |
|
10) |
Gain knowledge about the structure and functioning of the National Health System |
|
11) |
Advocate for the health promotion, and development of health care services for the benefits of the individuals in the community |
|
12) |
Define legal responsibilities and ethical principles |
|
13) |
Act in accordance with professional values, ethical principles and legal regulations |
|
14) |
Take responsibility for lifelong learning and personal assessment |
|
15) |
Organize and attend to scientific meetings and conduct scientific projects |
|
16) |
Know at least one common foreign language sufficient to keep up with current medical literature and communicate with peers; and use statistics and computer programmes to evaluate scientific studies |
|