lOMoARcPSD| 51944000
Computer packages
Topic
1 Introduction to Computers, Definition, Advantages & Limitations
2 Anatomy of Computers – Components of Computers and its functions -
3 Introduction to Computers, Definition, Advantages & Limitations
4 Anatomy of Computers – Components of Computers and its functions -
Software & Speed
5 Types of Software – Operating System, Translators & Programming languages
6 Types of Software – Application Programmes, Utility Programmes & General
Purpose Programmes, Classification of Computers
7 Operating System – Functions of OS – Types of OS-DOS and WINDOWS,
Booting process
8 Some fundamental DOS commands – FORMAT, DIR, COPY, PATH,
LABEL, VOL, MD, CD, DEL and TREE
9 WINDOWS:GUI, Desktop and its elements, Anatomy of a window – Title
Bar, Minimize, Maximize, Restore and Close Buttons, Scroll Bars, Menus and
Tool - Starting and shutting down of windows
10 WINDOWS Explorer, working with organization of files and folders, Copy,
, lOMoARcPSD| 51944000
Move and Print files – setting time and date
11 MSWORD: Word processing and units of document, features of word processing packages
12 MSWORD: Creating, Editing, Formatting and Saving a document in
MSWORD – Features of File, Edit and Format menus
13 MSEXCEL: Electronic Spreadsheets – concept, packages, creating, editing and saving a spreadsheet with
MSEXCEL
14 MSEXCEL: Use of in-built Statistical and other functions and writing expressions,
Creating Data Analysis option in Tools Menu, Use of Data Analysis Tools –
Correlation and Regression, t-test for two samples, Creating
Graphs
15 Internet - World Wide Web (WWW), Concepts
, lOMoARcPSD| 51944000
PRACTICALS
S .No. Topic
1 Study of Computer Components – Booting of Computer and its Shut
Down
2 Practice of some fundamental DOS commands – TIME, DATE, DIR,
MD, CD, RD, DEL, TREE, COPY, VOL and LABEL
3 Practicing WINDOWS Operating System – Use of Mouse, Title Bar, Minimum,
Maximum and Close Buttons, Scroll Bars, Menus and Tool
Bars
4 WINDOWS Explorer – Creating Folders, COPY and PASTE functions
5 MSWORD – Creating a Document, Editing and Saving
6 MSWORD: Use of options from the Tool Bars – Format, Insert and Tools
( Spell Check), Alignment of paragraphs and Text
7 MSWORD: Creating a Table, Merging of Cells, Columns and Row
Width
8 MSEXCEL: Creating a Spreadsheet, Alignment of Rows, Columns and
Cells using Format Tool Bar
9 MSEXCEL: Entering formula expression through the formula tool bar and use of
inbuilt functions – SUM, AVERAGE and STDEV
10 MSEXCEL: Data Analysis using inbuilt Tool Packs – Correlation and
Regression
11 MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance
12 MSEXCEL: Creating and Saving Graphs
13 Transforming the data of WORD and EXCEL to other forms
14 MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance
15 Internet Explorer – Using Search Engines
, lOMoARcPSD| 51944000
INTRODUCTION
Definition : A Computer is an electronic device that can perform activities that involve Mathematical, Logical and
graphical manipulations. Generally, the term is used to describe a collection of devices that function together as a
system.
It performs the following three operations in sequence.
1. It receives data & instructions from the input device.
2. Processes the data as per instructions.
3. Provides the result (output) in a desired form.
Data : It is the collection of raw facts, figures & symbols.
Ex : Names of students and their marks in different subjects listed in random order.
Information : It is the data that is processed & presented in an organized manner.
Ex : When the names of students are arranged in alphabetical order, total and average marks are calculated &
presented in a tabular form, it is information.
Program : Set of instructions that enables a computer to perform a given task.
Advantages of computers :
1. High speed : Computers have the ability to perform routine tasks at a greater speed than human beings. They
can perform millions of calculations in seconds.
2. Accuracy : Computers are used to perform tasks in a way that ensures accuracy.
3. Storage : Computers can store large amount of information. Any item of data or any instruction stored in the
memory can be retrieved by the computer at lightning speeds.
4. Automation : Computers can be instructed to perform complex tasks automatically ( which increases the
productivity).
Computer packages
Topic
1 Introduction to Computers, Definition, Advantages & Limitations
2 Anatomy of Computers – Components of Computers and its functions -
3 Introduction to Computers, Definition, Advantages & Limitations
4 Anatomy of Computers – Components of Computers and its functions -
Software & Speed
5 Types of Software – Operating System, Translators & Programming languages
6 Types of Software – Application Programmes, Utility Programmes & General
Purpose Programmes, Classification of Computers
7 Operating System – Functions of OS – Types of OS-DOS and WINDOWS,
Booting process
8 Some fundamental DOS commands – FORMAT, DIR, COPY, PATH,
LABEL, VOL, MD, CD, DEL and TREE
9 WINDOWS:GUI, Desktop and its elements, Anatomy of a window – Title
Bar, Minimize, Maximize, Restore and Close Buttons, Scroll Bars, Menus and
Tool - Starting and shutting down of windows
10 WINDOWS Explorer, working with organization of files and folders, Copy,
, lOMoARcPSD| 51944000
Move and Print files – setting time and date
11 MSWORD: Word processing and units of document, features of word processing packages
12 MSWORD: Creating, Editing, Formatting and Saving a document in
MSWORD – Features of File, Edit and Format menus
13 MSEXCEL: Electronic Spreadsheets – concept, packages, creating, editing and saving a spreadsheet with
MSEXCEL
14 MSEXCEL: Use of in-built Statistical and other functions and writing expressions,
Creating Data Analysis option in Tools Menu, Use of Data Analysis Tools –
Correlation and Regression, t-test for two samples, Creating
Graphs
15 Internet - World Wide Web (WWW), Concepts
, lOMoARcPSD| 51944000
PRACTICALS
S .No. Topic
1 Study of Computer Components – Booting of Computer and its Shut
Down
2 Practice of some fundamental DOS commands – TIME, DATE, DIR,
MD, CD, RD, DEL, TREE, COPY, VOL and LABEL
3 Practicing WINDOWS Operating System – Use of Mouse, Title Bar, Minimum,
Maximum and Close Buttons, Scroll Bars, Menus and Tool
Bars
4 WINDOWS Explorer – Creating Folders, COPY and PASTE functions
5 MSWORD – Creating a Document, Editing and Saving
6 MSWORD: Use of options from the Tool Bars – Format, Insert and Tools
( Spell Check), Alignment of paragraphs and Text
7 MSWORD: Creating a Table, Merging of Cells, Columns and Row
Width
8 MSEXCEL: Creating a Spreadsheet, Alignment of Rows, Columns and
Cells using Format Tool Bar
9 MSEXCEL: Entering formula expression through the formula tool bar and use of
inbuilt functions – SUM, AVERAGE and STDEV
10 MSEXCEL: Data Analysis using inbuilt Tool Packs – Correlation and
Regression
11 MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance
12 MSEXCEL: Creating and Saving Graphs
13 Transforming the data of WORD and EXCEL to other forms
14 MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance
15 Internet Explorer – Using Search Engines
, lOMoARcPSD| 51944000
INTRODUCTION
Definition : A Computer is an electronic device that can perform activities that involve Mathematical, Logical and
graphical manipulations. Generally, the term is used to describe a collection of devices that function together as a
system.
It performs the following three operations in sequence.
1. It receives data & instructions from the input device.
2. Processes the data as per instructions.
3. Provides the result (output) in a desired form.
Data : It is the collection of raw facts, figures & symbols.
Ex : Names of students and their marks in different subjects listed in random order.
Information : It is the data that is processed & presented in an organized manner.
Ex : When the names of students are arranged in alphabetical order, total and average marks are calculated &
presented in a tabular form, it is information.
Program : Set of instructions that enables a computer to perform a given task.
Advantages of computers :
1. High speed : Computers have the ability to perform routine tasks at a greater speed than human beings. They
can perform millions of calculations in seconds.
2. Accuracy : Computers are used to perform tasks in a way that ensures accuracy.
3. Storage : Computers can store large amount of information. Any item of data or any instruction stored in the
memory can be retrieved by the computer at lightning speeds.
4. Automation : Computers can be instructed to perform complex tasks automatically ( which increases the
productivity).
