COMPUTER APPLICATION – COURSE MODULE

COMPUTER APPLICATION – COURSE MODULE

 

Content
Spreadsheet ToolIntroduction to spreadsheet applicationFeatures and functionUsing formulas and functionsData storingFeatures For Statistical Data AnalysisGenerating charts/ graph and other featuresTools used may be Microsoft ExcelOpen office or simila tool
Presentation ToolIntroduction to presentation toolFeatures and functionCreating presentationCustomizing presentationshowing presentationTools used may be Microsoft power Point
Writing ToolM.S.WordPDF formatLaTeX
WEB SEARCHIntroduction to InternetUse of internet and WWWUsing search engine like Google, Yahoo etcUsing advanced search techniques.
DATABASE DESIGNDatabase System & Evolution of Database technology, Evolution of Database technology,File-OrientedSystem, Client server PlatformsDatabase System in the Organization, Databases and data sharing,Strategic database planningManagement control, Risks and cost of database, Logical and Physical data representation.Generalization, Relationalship, Cardinality, Attributes.Relational Database ImplementationData Definition language, Data Manipulation Language, Data Manipulation language,Data ControlLanguage, Transaction Control language, Schema and table definition.SQL functions and View definitionPhysical Database system

 

Structured query language using ORACLE-create tables, manipulate-tables, Datbases query processing, functions, integrity,indexing views.
Use of SPSSOverview on SPSS toolsPreparing data sheetsEntering data on characterizationUsage of statistical toolsMeasures of Central tendencyDispersionProbability distribution- Normal, Binomial and Poisson distributionParametric and Non Parametric statisticsConfidence Interval
Quantitative techniquesLevels of significanceRegression and Correlation coefficientUse of Computers in Quantitative analysis

ASSESSMENT DETAILS FOR COMPUTER APPLICATION

 

Assessment Topics for Computer Application

 

Seminar Presentation – 2

 

Seminar Presentation 1: Objective of using IT tools in Research

 

Seminar Presentation 2: Utilizing Statistical Analysis tools for Scientific Research

 

Assignment -2

 

Assignment 1: Application of Regression Analysis in Advance Research

 

Assignment 2: Efficacy of advanced statistical methods, used to ascertain the progress of the society.

 

Type Percentage
Presentation 50%
Assignment 50%
Total 100%