Desarrollo De Aplicaciones Multiplataforma

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 S. V. Agricultural College Tirupati

LECTURE OUTLINE Course No. STCA-301 Course Title: Introduction to Computer Applications THEORY S. No. 1 2 3 4 5 6 7 8 Topic/LessonIntroduction to Computers, Definition, Advantages & Limitations Anatomy of Computers – Components of Computers Overview of Input devices of Computer Overview of Output devices of Computer, Memory, Processors, Hardware, Software & Speed Types of Software – Operating System, Translators & Programming languages Types of Software – Application Programmes, Utility Programmes & General Purpose Programmes,Classification of Computers Operating System – Functions of OS – Types of OS-DOS and WINDOWS, Booting process Some fundamental DOS commands – FORMAT, DIR, COPY, PATH, LABEL, VOL, MD, CD, DEL and TREE 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 10 11 12 13WINDOWS Explorer , working with organization of files and folders, Copy, Move and Print files – setting time and date MSWORD: Word processing and units of document, features of wordprocessing packages MSWORD: Creating, Editing, Formatting and Saving a document in MSWORD – Features of File, Edit and Format menus MSEXCEL: Electronic Spreadsheets – concept, packages, creating, editing and saving aspreadsheet with MSEXCEL MSEXCEL: Use of in-built Statistical and other functions and writing expressions, Creating Graphs 14 15 16 MSACCESS: Concept of Database, Units of database MSACCESS: creating database Internet - World Wide Web (WWW), Concepts Data Analysis option in Tools Menu, Use of Data Analysis Tools – Correlation and Regression, t-test for two samples, Creating and its functions Credits: 2(1+1)

1

PRACTICALS S .No. 1 2 3 Down Practice of some fundamental DOS commands – TIME, DATE, DIR, MD, CD, RD, DEL, TREE, COPY, VOL and LABEL Practicing WINDOWS Operating System – Use of Mouse, Title Bar, Minimum, Maximum and Close Buttons, Scroll Bars, Menus and Tool Bars 4 5 6 7 8 9 10 11 12 13 14 15 16 WINDOWS Explorer – Creating Folders, COPY and PASTE functions MSWORD – Creating aDocument, Editing and Saving MSWORD: Use of options from the Tool Bars – Format, Insert and Tools (Spell Check), Alignment of paragraphs and Text MSWORD: Creating a Table, Merging of Cells, Columns and Row Width MSEXCEL: Creating a Spreadsheet, Alignment of Rows, Columns and Cells using Format Tool Bar MSEXCEL: Entering formula expression through the formula tool bar and use of inbuilt functions – SUM,AVERAGE and STDEV MSEXCEL: Data Analysis using inbuilt Tool Packs – Correlation and Regression MSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance MSEXCEL: Creating and Saving Graphs MSACCESS: Creating Database, structuring with different types of fields MSACCESS: use of Query facility for accessing the information Transforming the data of WORD and EXCEL to other formsMSEXCEL: Data Analysis using inbuilt Tool Packs – tests of significance Internet Explorer – Using Search Engines Topic Study of Computer Components – Booting of Computer and its Shut

2

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 ofdevices 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....