COURSE PLAN

Name of the Faculty: Academic Year:2024-2025

Subject Code & Name: Semester/ Year:

COURSE OUTCOMES

On Successful completion of the course, the student will be able to

 CO1: Understand the basics of computer systems and its components.
 CO2: Understand and apply the basic concepts of word processing package.
 CO3:Understand and apply the basic concepts of electronic spread sheet
software.
 CO4: Understand and apply the basic concepts of database management system.
 CO5: Understand and create a presentation using PowerPoint tool.

Unit-I 10 Hours

Introductory concepts: Memory unit–CPU-Input Devices: Key board,

Mouseand Scanner. Output devices: Monitor, Printer. Introduction to
Operating systems & its features: DOS–UNIX–Windows. Introduction to
Programming Languages.

Remarks
Proposed Actual Page
Period Topics to be Delivery ( Assignment /
Date Date Reference Number
covered Method Seminar /Test)
Introductory
1 concepts :Memory C&T T1
unit
CPU-Input
2 Devices:Key C&T T2
board
Mouseand
3 Scanner
C&T T2 Assignment

4 Output devices C&T T2

5 Monitor C&T T2
 6 Printer C&T T2
Introduction to
7 Operating C&T T1
systems

8 DOS–UNIX C&T T1

9 Windows C&T T1
Introduction to
10 Programming C&T T2
Languages

Unit II 10 Hours
Word Processing: Open, Save and close word document; Editing text – tools,
formatting, bullets; Spell Checker - Document formatting – Paragraph alignment,
indentation, headers and footers, numbering; printing–Preview, options, merge.
Remarks
Topics to be Proposed Actual Delivery
Period Reference Page Number Assignment /
covered Date Date Method
Seminar /Test)
Word C&T T2
Processing:
1 Open, Save
and close word
document
2 Editing text C&T T2
Formatting, C&T T1
3 bullets
3 Spell Checker C&T T1 Conducting test
Document C&T T2
4 formatting
Paragraph C&T T2
5 alignment
6 Indentation C&T T2
Headers and C&T T2
7 footers
8 Numbering C&T T2
Printing– C&T T1
9 Preview
10 Options, merge C&T T2

Unit III 10 Hours

 Spreadsheets: Excel– opening, entering text and data, formatting,
navigating ;For mulas–entering, handling and copying; Charts– creating,
formatting and printing ,analysis tables,
preparation of financial statements, introduction to data analytics.

Remarks
Topics to be Proposed Actual Delivery Page
Period Reference (Assignment /
covered Date Date Method Number
Seminar /Test)
Spreadsheets: C&T T2
1 Excel
opening, C&T T2
2 entering text
and data
3 formatting C&T T2
navigating ;Fo C&T T2
4 r mulas–
entering
handling and C&T T1
5 copying
Charts– C&T T2
6 creating
Formatting C&T T2
7 and printing

8 analysis tables C&T T2

preparation of C&T T2
9 financial Assignment
statements
introduction to C&T T2
10 data analytics

Unit IV 10 Hours

Database Concepts:
The concept of database Management system; Datafield, records,and files,
Sorting and indexing data; Searching records. Designing queries, and reports;
Linking of data files; Understanding Programming environment in DBMS;
Developing menu drive applications in query language(MS–Access).

Remarks
Delivery Reference Assignment
Topics to be Proposed Actual Page
Period Method /
covered Date Date Number
Seminar
/Test)
 Manageme T1
1 ntsystem
C&T
2 Data field, C&T T1
records T2
3 and files
C&T
Sorting T2
and
4 indexing
C&T
data
Searching T2
5 records
C&T
Designing T2
6 queries
C&T
7 reports C&T T2
Linking of T1
8 data files
C&T
Understan
ding
Programmi T2
9 ng
C&T
environme
nt in DBMS
Developing
menu drive
application T2
s in query
10 language( C&T
MS–
Access).

Unit V 10 Hours

Power point: Introduction to Power point - Features – Understanding slide

typecasting & viewing slides – creating slide shows. Applying special object –
including objects & pictures – Slide transition– Animation effects ,audio
inclusion, timers.

Delivery Reference Remarks

Topics to be Proposed Actual Page
Period Method Assignment /
covered Date date Number
Seminar /Test)
T2
Introductio
1 n to Power C&T
point
 Power T2
2 point - C&T Conducting Test
Features
Understan T1
ding slide
3 typecastin
C&T
g
viewing T2
4 slides
C&T
creating T2
5 slide C&T
shows
Applying T2
6 special C&T
object
including T1
7 objects
C&T
8 pictures C&T T1
Slide C&T T1
9 transition
Animation C&T T1
effects ,au
10 dio
inclusion,
timers

Delivery Method: C&T – Chalk and Talk, PPT and Live Demonstration
Reference Books:
Reference Books:

1. JenniferAckermanKettel,GuyHat-
Davis,CurtSimmons,“Microsoft2003”,TataMcGraw-Hill.
2. PeterNorton,“IntroductiontoComputers”–TataMcGraw-Hill..

Prepared by Approved by
Signature
Name
Designation ASST. PROFFESSOR
Submission Date