lOMoARcPSD|28235225
Introduction to Computer Applications by Sumathi
introduction to computer applications (Mount Kenya University)
Studocu is not sponsored or endorsed by any college or university
Downloaded by stephen juma ()
, lOMoARcPSD|28235225
ACHARYA N.G.RANGA AGRICULTURAL UNIVERSITY
LECTURE NOTES
Course No : STCA-301
Introduction to Computer Applications
Prepared by
P. Sumathi
M.Sc, M.Phil
Assistant professor
Department of Statistics & Mathematics
, lOMoARcPSD|28235225
LECTURE OUTLINE
Course No. STCA-301 Credits: 2 (1+1)
Course Title: Introduction to Computer Applications
THEORY
S. No. Topic/Lesson
1 Introduction to Computers, Definition, Advantages & Limitations
2 Anatomy of Computers – Components of Computers and its functions -
Overview of Input devices of Computer
3 Overview of Output devices of Computer, Memory, Processors, Hardware,
Software & Speed
4 Types of Software – Operating System, Translators & Programming languages
5 Types of Software – Application Programmes, Utility Programmes & General
Purpose Programmes, Classification of Computers
6 Operating System – Functions of OS – Types of OS-DOS and WINDOWS,
Booting process
7 Some fundamental DOS commands – FORMAT, DIR, COPY, PATH,
LABEL, VOL, MD, CD, DEL and TREE
8 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
9 WINDOWS Explorer , working with organization of files and folders, Copy,
Move and Print files – setting time and date
10 MSWORD: Word processing and units of document, features of word-
processing packages
11 MSWORD: Creating, Editing, Formatting and Saving a document in
MSWORD – Features of File, Edit and Format menus
12 MSEXCEL: Electronic Spreadsheets – concept, packages, creating, editing and
saving a spreadsheet with MSEXCEL
13 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
14 MSACCESS: Concept of Database, Units of database
15 MSACCESS: creating database
16 Internet - World Wide Web (WWW), Concepts
, lOMoARcPSD|28235225
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 MSACCESS: Creating Database, structuring with different types of fields
MSACCESS: use of Query facility for accessing the information
14 Transforming the data of WORD and EXCEL to other forms
15 MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of
significance
16 Internet Explorer – Using Search Engines
Introduction to Computer Applications by Sumathi
introduction to computer applications (Mount Kenya University)
Studocu is not sponsored or endorsed by any college or university
Downloaded by stephen juma ()
, lOMoARcPSD|28235225
ACHARYA N.G.RANGA AGRICULTURAL UNIVERSITY
LECTURE NOTES
Course No : STCA-301
Introduction to Computer Applications
Prepared by
P. Sumathi
M.Sc, M.Phil
Assistant professor
Department of Statistics & Mathematics
, lOMoARcPSD|28235225
LECTURE OUTLINE
Course No. STCA-301 Credits: 2 (1+1)
Course Title: Introduction to Computer Applications
THEORY
S. No. Topic/Lesson
1 Introduction to Computers, Definition, Advantages & Limitations
2 Anatomy of Computers – Components of Computers and its functions -
Overview of Input devices of Computer
3 Overview of Output devices of Computer, Memory, Processors, Hardware,
Software & Speed
4 Types of Software – Operating System, Translators & Programming languages
5 Types of Software – Application Programmes, Utility Programmes & General
Purpose Programmes, Classification of Computers
6 Operating System – Functions of OS – Types of OS-DOS and WINDOWS,
Booting process
7 Some fundamental DOS commands – FORMAT, DIR, COPY, PATH,
LABEL, VOL, MD, CD, DEL and TREE
8 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
9 WINDOWS Explorer , working with organization of files and folders, Copy,
Move and Print files – setting time and date
10 MSWORD: Word processing and units of document, features of word-
processing packages
11 MSWORD: Creating, Editing, Formatting and Saving a document in
MSWORD – Features of File, Edit and Format menus
12 MSEXCEL: Electronic Spreadsheets – concept, packages, creating, editing and
saving a spreadsheet with MSEXCEL
13 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
14 MSACCESS: Concept of Database, Units of database
15 MSACCESS: creating database
16 Internet - World Wide Web (WWW), Concepts
, lOMoARcPSD|28235225
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 MSACCESS: Creating Database, structuring with different types of fields
MSACCESS: use of Query facility for accessing the information
14 Transforming the data of WORD and EXCEL to other forms
15 MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of
significance
16 Internet Explorer – Using Search Engines
