| Amrapali Institue |
| Department of
management Studies |
| Lesson Plan |
|
| Name of the faculty
Member: Karuna Bhandari |
|
|
| Subject/paper: Computer
Application |
Class/semester:B.B.A.III
Semester |
| Code: |
306 |
|
| Text Book |
Using
Microsoft Office 2000 (Prentice Hall of India) & Self Notes |
|
| Lecture No |
Topics |
Chapter
in the text Book |
| 1 |
Introduction to Word
Processing |
Chapter II (Using
MS-Office 2000)EED |
| 2 |
Need, Advantage of
Computer word processing |
Chapter II (Using
MS-Office 2000)EED |
| 3 |
Typing
Text,Editing,Formatting, |
Chapter II (Using
MS-Office 2000)EED |
| 4 |
Tabulation |
Chapter II (Using
MS-Office 2000)EED |
| 5 |
Spell Check,Mail
Merge |
Chapter II (Using
MS-Office 2000)EED |
| 6 |
Continued |
Chapter II (Using
MS-Office 2000)EED |
| 7 |
'Revision of Previous topics |
Chapter II (Using
MS-Office 2000)EED |
| 8 |
Continued -- 'Revision of
Previous topics |
Chapter II (Using
MS-Office 2000)EED |
| 9 |
Class Test |
Chapter II (Using
MS-Office 2000)EED |
| 10 |
Introduction to Worksheet (MS
- Excel) |
Chapter III (Using
MS-Office 2000)EED |
| 11 |
Part of Worksheet |
Chapter III (Using
MS-Office 2000)EED |
| 12 |
Data Entry Type Into Sheets |
Chapter III (Using
MS-Office 2000)EED |
| 13 |
Mathemetical Formulas , Functions |
Chapter III (Using
MS-Office 2000)EED |
| 14 |
Continued |
Chapter III (Using
MS-Office 2000)EED |
| 15 |
Sorting |
Chapter III (Using
MS-Office 2000)EED |
| 16 |
Formatting of Numbers |
Chapter III (Using
MS-Office 2000)EED |
| 17 |
Graphs/Chart making |
Chapter III (Using
MS-Office 2000)EED |
| 18 |
Continued |
Chapter III (Using
MS-Office 2000)EED |
| 19 |
'Revision of Previous topics |
Chapter III (Using
MS-Office 2000)EED |
| 20 |
Continued -- 'Revision of
Previous topics |
Chapter III (Using
MS-Office 2000)EED |
| 21 |
Class Test |
Chapter III (Using
MS-Office 2000)EED |
| 22 |
Introduction to MS -
Powerpoint |
Chapter IV (Using
MS-Office 2000)EED |
| 23 |
Presentation Making |
Chapter IV (Using
MS-Office 2000)EED |
| 24 |
Using
Transitions/Animation Effects |
Chapter IV (Using
MS-Office 2000)EED |
| 25 |
Continued |
Chapter IV (Using
MS-Office 2000)EED |
| 26 |
Introduction To Algorithms |
Handouts |
| 27 |
Flow Charts With Examples |
Handouts |
| 28 |
Continued |
Handouts |
| 29 |
'Revision of Previous topics |
Handouts |
| 30 |
Continued -- 'Revision of
Previous topics |
Handouts |
| 31 |
Class Test |
Handouts |
| 32 |
Introduction to
Database Management |
Handouts |
| 33 |
Data , Information ,
Database |
Handouts |
| 34 |
Database Management
System |
Handouts |
| 35 |
Creation of Database |
Handouts |
| 36 |
Adding , Deletion ,
Editing |
Handouts |
| 37 |
Querying |
Handouts |
| 38 |
Continued |
Handouts |
| 39 |
Sorting Records into
Database |
Handouts |
| 40 |
Application Areas of
Database Management System |
Handouts |
| 41 |
'Revision of Previous topics |
Handouts |
| 42 |
Continued -- 'Revision of Previous topics |
Handouts |
| 43 |
Class Test |
Handouts |
| 44 |
Introduction to
Internet |
Chapter V (Using
MS-Office 2000)EED NIIT-Internet |
| 45 |
Overview of
Internet(Http,URL,Websites) |
Chapter V (Using
MS-Office 2000)EED NIIT-Internet |
| 46 |
Browsing , Emails |
Chapter V (Using
MS-Office 2000)EED NIIT-Internet |
| 47 |
Revision of Previous topics |
Chapter V (Using
MS-Office 2000)EED NIIT-Internet |
| 48 |
Continued -- 'Revision of
Previous topics |
Chapter V (Using
MS-Office 2000)EED NIIT-Internet |
| 49 |
Class Test |
|
|
|
|
|
|
|
|
| List
of Reference Books |
|
| R1 |
Using Microsoft Office 2000 (Prentice Hall of India) |
|
| R2 |
Database Management System By Vipin Desai (BPB) |
|
|
|
|
|
| List
of Assignments |
Date of Submission |
| 1 |
Need, Advantage of Computer word
processing |
Third
week of August |
| 2 |
What is Mail Merge ?
Explain in Detail. |
Second week of Sep. |
| 3 |
Write Down the Steps
to create a table in MS-office. |
Third week of Sep. |
| 4 |
Explain the Print sub
Menu. |
Fouth week of Sep |
| 5 |
Explain the following
Functions , Sum, Max,Min, Average and count. |
Second
week of Oct. |
| 6 |
Create a Chart in
MS-Excel. |
Third week of Oct |
| 7 |
Create a Report In
Ms-Excel. |
Third week of Sep. |
| 8 |
What do u understand
By Algorithms.Expalin? |
first week of Nov. |
| 9 |
What are the
application Areas of DBMS. |
Second week of Nov. |
| 10 |
What do u understand
by Internet.Explain the following terms like WWW,HTTP,Search engines etc |
Third week of Nov, |
|
|
|
| List
of Projects |
|
| 1 |
Create a presentation on introduction to computers using Power
point |
Last week of Sep. |
| 2 |
Create a marks sheet on MS Excel |
Last week of Oct. |
| 3 |
Generate a payroll System on MS Access |
Last week of Nov. |
|
| Evaluation
Criteria
Weightage |
|
| Quiz |
3 |
|
| Mid Sem Exams(Avg.
of 2) |
5 |
|
| Tutorials(Best
of 5) |
5 |
|
| Project |
5 |
|
| Assignments |
3 |
|
| Class Participation |
4 |
|
| Attendence |
5 |
|
|
|
|