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) |
It can manage nursing care in accordance with ethical principles and laws. |
4 |
2) |
Can transfer theoretical knowledge to nursing applications. |
3 |
3) |
Have basic psychomotor skills of nursing. |
3 |
4) |
Having basic psychomotor skills of your nursing. |
5 |
5) |
Individuals, families and the community have the knowledge to perform nursing roles and functions in meeting the health care needs. |
3 |
6) |
It can contribute to the formation of health policies. |
3 |
7) |
Can take responsibility as individual and team member in nursing applications. |
3 |
8) |
It can use health information systems in the maintenance. |
2 |
9) |
To have general cultural knowledge required to be a contemporary individual and a professional member. |
4 |
10) |
To be able to carry out projects and activities by cooperating among the sectors in social awareness consciousness. |
4 |
11) |
Using a foreign language, you can follow the information in the field and communicate with your foreign colleagues. |
1 |