COMPUTER APPLICATION – COURSE MODULE
Content |
Spreadsheet Tool• Introduction to spreadsheet application• Features and function• Using formulas and functions• Data storingFeatures For Statistical Data Analysis• Generating charts/ graph and other features• Tools used may be Microsoft ExcelOpen office or simila tool |
Presentation Tool• Introduction to presentation tool• Features and function• Creating presentation• Customizing presentation• showing presentation• Tools used may be Microsoft power Point |
Writing Tool• M.S.Word• PDF format• LaTeX |
WEB SEARCH• Introduction to Internet• Use of internet and WWW• Using search engine like Google, Yahoo etc• Using advanced search techniques. |
DATABASE DESIGN• Database System & Evolution of Database technology, Evolution of Database technology,File-OrientedSystem, Client server Platforms• Database System in the Organization, Databases and data sharing,Strategic database planning• Management control, Risks and cost of database, Logical and Physical data representation.• Generalization, Relationalship, Cardinality, Attributes.• Relational Database Implementation• Data Definition language, Data Manipulation Language, Data Manipulation language,Data ControlLanguage, Transaction Control language, Schema and table definition.• SQL functions and View definition• Physical Database system |
• Structured query language using ORACLE-create tables, manipulate-tables, Datbases query processing, functions, integrity,indexing views. |
Use of SPSS• Overview on SPSS tools• Preparing data sheets• Entering data on characterization• Usage of statistical tools• Measures of Central tendency• Dispersion• Probability distribution- Normal, Binomial and Poisson distribution• Parametric and Non Parametric statistics• Confidence Interval |
Quantitative techniques• Levels of significance• Regression and Correlation coefficient• Use 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% |