Course Code : DBBC-25-101

Title of the Course : BASICS OF COMPUTER

L T P
3 0 0

Course Outcomes:
By completing this course, students can:

CO1: Know the basic components of the computer and working of each device.
CO2: Understand the representation of data in computer
CO3: Know the difference between Assembly and High level programming Languages.
CO4: Basics of MS office tools andFundamentals of Computer Networking
CO/PO Mapping
(S-Strong Correlation, M- Medium Correlation, W-Weak Correlation)
Cos Programme Outcomes (Pos)
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
CO1 S W M S M W S M S W M W
CO2 S W M M M W S M M W M W
CO3 S W M S M S M M M S M S
CO4 S S S M M S S M S W S S

Unit Course Outlines Hour(s)

Historical Evolution of Computer: Block Diagram of computer,
characterisation of computers, types of computers, the computer
1 7
generations.
Basic Anatomy of Computers: Memory Unit, Input-Output Devices
Computer Software: Introduction, types of software, systems software,
GUI, operating system, high level languages, assemblers, compilers
2 and interpreters. 10
Applications of Information Technology and Trends, E-Commerce:
Meaning, its advantages & limitations
Applications of Information Technology in Railway, Airline, Banking,
Insurance, Inventory Control, Hotel Management, Education, Mobile
Phones, Weather Forecasting.
Data Network and Communication: Network types, Transmission
3 13
Modes, Network topologies.
Internet: Evolution of Internet, E-mail WWW, FTP, Video
Conferencing.

4 Ms-Word:Elements of Word screen – menu bar, formatting tool bar, 15

 rules, title bar, status bar and scroll bar, editing documents ,selecting
the text, deleting, undo features, moving and copying, using cut, copy,
paste, searching text and replacing, spell check , print formatting, using
different fonts, bold, italic, underline, changing cases, Text formatting .
Ms- Excel:Basics of Excel screen – menu bar, formatting tool bar,
rules, title bar, status bar and scroll bar.
Ms -Powerpoint: Creating a new slide, Slide editing, menu bar, title
bar& formatting tools of MS Power point.

Text Books:
1. P.K. Sinha and P. Sinha, Foundations of Computing, First Edition, 2002, BPB.
2. ChetanSrivastva, Fundamentals of Information Technology, Kalyani Publishers.
3. Turban Mclean and Wetbrete, Information Technology and Management, Second
Edition, 2001, John Wiley & Sons.
Course Code : BCAS-25-101
Title of the Course : Basics of Computer- LAB

L T P Credits
0 0 4 2

Course Outcomes:

Upon completion of this course, the student will be able to:

CO1. Understand Window Operating System and MS-Office.
CO2. Create, store, manipulate data needed for accomplishing basic tasks.
CO3. Optimize the existing office procedures by saving time, money and human efforts.
CO4. Understand Computer Communication and Internet.

CO/PO Mapping
(S/M/W indicates strength of correlation ) S – Strong, M – Medium, W – Weak
Cos Programme Outcomes (Pos)
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
CO1 S M S M W W M S M M S M
CO2 S W S M W M M S S M S M
CO3 M W S W W M M S M M S M
CO4 S M S M M M M S M M M M

PRACTICAL

P. No. Name of the Practical P. Hour

MS-WORD 2

Working with Files: Creating and opening documents, Saving documents, 2

1 Renaming documents, working on multiple documents.
2
2 Working with Text - Formatting, Moving, copying and pasting text

Styles: Apply a style, Apply from the Style dialog box, Create a new style from a 2
model, Modify or rename a style, Delete style. Lists - Bulleted and numbered lists,
3 Nested lists, Formatting lists.

Table Manipulations: Graphics - Adding clip Art, Add an image from a file, 2
4 Editing graphics, Spelling and Grammar, AutoCorrect
 Page Formatting: Page margins, page size and orientation, Header and footers,
page numbers, Mail Merge. Macros - Recording a macro, Running a macro- Web 2
wizard - Using the Web Wizard, Creating & Saving web pages, Hyper links.Mail
5 Merge.
MS-EXCEL 2
Modifying a Worksheet: Moving through cells, Adding worksheets, rows and
columns Resizing rows and columns, Selecting cells, Moving and copying cells, 2
6 Freezing panes -
Macros - recording cells, Moving and copying cells, Freezing panes - Macros -
recording cells, Moving and copying cells, Freezing panes - Macros - recording 2
7 and running.

Formatting Cells: Formatting toolbar, Dates and times, Auto formatting. Formula 2
8 and Functions. Linking worksheets - Relative,absolute and mixed referencing

Sorting and Filling: Basic ascending and descending sorted, Complex sorts, 2
9 Alternating text and numbers with Auto fill, Autofilling functions.
Graphics: Adding clip art, add an image from a file, Charts - Using chart Wizard, 2
10 Copy a chart to Microsoft Word
MS-POWER POINT 2
11 Create a Presentation from a Template: Working with Slides - 2
2
12 Insert a new slide, Applying a design template, Changing slide layouts.

Slides: Reordering slides, Hide slides, Create a Custom slide show. Adding 2
13 Content - Resizing a text box, Text box properties, Delete a text box.
14 Video and Audio Effects: Color Schemes & Backgrounds 2
2
15 Adding clip art, Adding an image from a file, Save as a web page.

REFERENCE BOOK(S):
1. Microsoft Office : Introductory Course By William R. Pasewark,Cengage Learning
2. Computer Basic with Office Automation, Archanakumar
3. Computer Fundamental and Office Automation, RimplePundir
4. Office Automation, Charless
5. Introduction to Office Automation, Charlene w.Sox
6. Office Automation, Andrew Doswell
E-BOOKS:
https://www.swayamprabha.gov.in/
https://nptel.ac.in/course.html
www.pdfdrive.net
www.scienceebookonline.info
www.digitallibraries.com
www.ebooksdirectory.com