DATA MENU :
E. g In result sheet we have to see only those rows
which contains “Science” as a stream then it should be possible with filter option.
E.g. In mark sheet , percen- tage must be between 1 to 100 so if any one can enter Above or below value , it display error like “The val- ue you entered is not valid. APPLICATION To create mark sheet etc.
SUMMARY It is very easy to arrange , format and represent data and save our time and energy.
ASSIGNMENT/ QUESTION
1. Explain Conditional Formatting in EXCEL. 2. Explain sort and Filter facility and it’s advantage. 3. Explain macro facility.
REFERENCE Internet.
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:.: Lesson no. : 35
Trade : COPA Impl. Date: Time :
Topic / Aim : Introduction to various function in all categories. Objective : (1) Formula Bar
Aids : Chalk, Duster, Pointer. Preparation :
* Review : * Intoduction :
Motivation : Window & dos base program like typing tutor ,Ms-Office etc. Presentation :
Topics Information Points Tell Spot hints /
Question (Ask) Formula in excell
--> Formula Bar: Sets whether or not you wish to display the Formula Bar, which displays the formula (if any) or unformatted contents of the currently selected cell.
--> What is use of Formula Bar?
--> Explain header and footer.
APPLICATION : SUMMARY : ASSIGNMENT/ :
QUESTION (1) Explain mostly used formula bar menu in excel. REFERENCE :
NEXT LESSON : Function in excell
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:.: Lesson no. : 36
Trade : COPA Impl. Date: Time :
Topic / Aim : Function in excell Objective : (1) Various function Aids : Chalk, Duster, Pointer. Preparation :
* Review : * Intoduction :
Motivation : Window & dos base program like typing tutor ,Ms-Office etc. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / View menu Various function- ex- addition, Substraction etc
Function: Launches the Function Wizard to insert a function based on given given data within your Worksheet. Picture: Inserts a Clip Art, an image file, WordArt or acquires a new file from a scanner.
--> Formula Bar: Sets whether or not you wish to display the Formula Bar, which displays the formula (if any) or unformatted contents of the currently selected cell.
Function: Launches the Function Wizard to insert a function based on given given data within your Worksheet. Picture: Inserts a Clip Art, an image file, WordArt or acquires a new file from a scanner.
--> What is use of page break preview?
--> Explain header and footer.
APPLICATION : SUMMARY : ASSIGNMENT/ : QUESTION
(1) Explain Various function in excell. REFERENCE :
NEXT LESSON : Concept of sorting and filtering and validating
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:.: Lesson no. : 37
Trade : COPA Impl. Date: Time :
Topic / Aim : Concept of sorting and filtering and validating Objective : Sorting, Filtering, Validating
Aids : Chalk, Duster, Pointer. Preparation :
* Review : * Intoduction :
Motivation : Window & dos base program like typing tutor ,Ms-Office etc. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Sorting, Validating -
--> Find.:Locates a given text string within your selection.
--> Replace: Locates and replaces a given text string in your selection with another specified string (or with nothing at all).
--> Go To.:Takes you to a cell specified by column and row, or specified by name.
--> What is the use of find,replace and goto?
APPLICATION : SUMMARY : ASSIGNMENT/ : QUESTION
(1) Explain Find,replace and goto option ? REFERENCE :
NEXT LESSON : Analysing Data using chart
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:.: Lesson no. : 38
Trade : COPA Impl. Date: Time :
Topic / Aim : Analysing Data using chart Objective : Explain data with graphical Aids : Chalk, Duster, Pointer. Preparation :
* Review : * Intoduction :
Motivation : Window & dos base program like typing tutor ,Ms-Office etc. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Analyse data with
chart
--> Worksheet: Inserts a new Worksheet, with its tab to the left of that of the selected
Worksheet.
--> Chart... Launches the Chart Wizard to help you insert a chart based on given data within your Worksheet.
--> Object: Inserts an object such as a Windows Media Player video or other OLE (Object Linking and Embedding) compatible file. --> Fill: Lets you fill selected cells with the contents of the first cell in the range (in white). --> Clear: Removes formatting (e.g. bold), contents, or all of the above. Note that the little "Del": key clears contents but not formats or comments.
--> Find.:Locates a given text string within your selection.
--> Replace: Locates and replaces a given text string in your selection with another specified string (or with nothing at all).
--> Go To.:Takes you to a cell specified by column and row, or specified by name.
What is use of chart? --> What is use of pagebreak?
--> What is the use of function?-
--> What is the use of find,replace and goto?
APPLICATION : SUMMARY : ASSIGNMENT/ :
QUESTION (1) Explain mostly used commands of edit menu in excel.(2) Explain mostly used commands of view menu in excel. (3) Explain mostly used commands of insert menu in excel. REFERENCE :
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:.: Lesson no. : 39
Trade : COPA Impl. Date: Time :
Topic / Aim : Introduction to table and its feature Objective : Data in table format
Aids : Chalk, Duster, Pointer. Preparation :
* Review : * Intoduction :
Motivation : Window & dos base program like typing tutor ,Ms-Office etc. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Insert table menu --> Table- Inserts new cells into your worksheet,
prompting you to ask how you would like to move the surrounding cells out of the way. --> Rows : Inserts a new row above the selected cell(s).
-->Columns: Inserts a new column to the left of the selected cell(s).
--> Worksheet: Inserts a new Worksheet, with its tab to the left of that of the selected
Worksheet.
--> Chart... Launches the Chart Wizard to help you insert a chart based on given data within your Worksheet.
--> Page Break: Inserts a page break above the selected cell(s).
--> What is use of chart? --> What is use of pagebreak?
--> What is the use of function?
APPLICATION : SUMMARY : ASSIGNMENT/ :
QUESTION (1) What is row(2) What is column REFERENCE :
NEXT LESSON : Introduction to report
Instructor Group Instructor Principal
INDUSTRIAL TRAINING INSTITUTE LESSON PLAN
Name : Patil Dinesh B. Unit/Block No.: Proposed
date .:.: Lesson no. : 40
Trade : COPA Impl. Date: Time :
Topic / Aim : Introduction to report Objective : Final work report Aids : Chalk, Duster, Pointer. Preparation :
* Review : * Intoduction :
Motivation : Window & dos base program like typing tutor ,Ms-Office etc. Presentation :
Topics Information Points Tell Question (Ask)Spot hints / Report How to make report --> What is use of report?
--> What is use of pagebreak?
--> What is the use of function?
APPLICATION : SUMMARY : ASSIGNMENT/ : QUESTION
(1) What is report & make report REFERENCE :
NEXT LESSON : Introduction to properties and editing image
Trade : COPA Impl. Date: Time : Topic / Aim Introduction to properties and editing image
Objective 1. A universally designed presentation enhances student learning by