| 1. Week |
MS Excel - Introduction to Excel, page and cell concepts, cursor types. |
Interview
|
| 2. Week |
MS Excel - elements of the interface of the spreadsheet program, getting acquainted with the toolbars, working with files, navigating the worksheet. |
Interview, Presentation (Preparation), Practice
|
| 3. Week |
MS Excel - Data manipulation. |
Interview, Practice, Presentation (Preparation)
|
| 4. Week |
MS Excel - Row and column operations. |
Interview, Presentation (Preparation), Practice
|
| 5. Week |
MS Excel - Moving-copying and special paste operations. |
Presentation (Preparation), Practice, Interview
|
| 6. Week |
MS Excel - Autocorrect and fill options, find-replace-go, insert clip art and descriptions, use of image toolbar. |
Presentation (Preparation), Practice, Interview
|
| 7. Week |
MS Excel - Formatting operations. |
Practice, Presentation (Preparation), Interview, Preparation, After Class Study
|
| 8. Week |
MS Excel - Page settings and printing options. |
Presentation (Preparation), Interview, Practice, Preparation, After Class Study
|
| 9. Week |
MS Excel - Window settings. |
Practice, Presentation (Preparation), Interview
|
| 10. Week |
MS Excel - Formula writing, use of existing formulas and mathematical functions. |
Preparation, After Class Study, Practice, Interview
|
| 11. Week |
MS Excel - Formula writing, use of existing formulas and mathematical functions. |
Preparation, After Class Study, Practice, Interview
|
| 12. Week |
MS Excel - Statistical functions, date lookup and text functions. |
Presentation (Preparation), Practice, Interview
|
| 13. Week |
MS Excel- Graphic operations. |
Presentation (Preparation), Practice, Interview, Preparation, After Class Study
|
| 14. Week |
MS Excel - Data analysis. |
Interview, Presentation (Preparation), Preparation, After Class Study, Practice
|
