Course outline

CHEM-8103 Computer Applications & Statistical Analysis. Cr. 03
MS Words: Text & Paragraph-editing, formatting, indenting, sectioning, headerfooter,
insertions (Figures & Tables); MS Excel: Formula manipulation, Graphs—
scatter, line and bar, Regression; MS Power Point: Presentation preparation,
animations, applications of different tools; Chemdraw: Structures, equations,
schemes, basic drawing tools; Chemsketch: Structures, equations, schemes, basic
drawing tools; Adobe Acrobat applications of reader and writer; Internet: Databases
(Chemical Abstract, Drug Bank, IUCr, Journal-Publisher-Search Engines); Statistical
Analysis: mean, median, mode, standard deviation, t-test, f-test, Analysis of Variance
(ANOVA), Regression, Factorial design and response surface methodology.
Reference Books
1. Learning C. Chemoffice: Drawing, Modeling and Information: User's Guide: Version
2.0 for Microsoft Windows, Cambridge Soft Corporation, CS ChemDraw Ltd, ,
ISBN: 0030156149, (1995).
2. Steffen L. Kraig.Using Chemoffice with Brown: Organic Chemistry, Harcourt
Canada, Limited, 110, ISBN 0030179599, (1995).
3. Soucie R. Learn Microsoft Excel Now: A Step-by-step Guide to Microsoft Excel that
Includes Hands-on Tutorials, Practical Ideas for Spreadsheets, Charts, and Databases,
Time-saving Tips, Microsoft Press, 328, ISBN: 1556152086, (2011).
199
4. Richard C. Basic Statistical Analysis,. Sprint hall, Edition 7, Cram101
Incorporated, 108, ISBN: 1428814248, (2006).
5. Cowan G. Statistical Data Analysis, , Clarendon Press, 212, ISBN: 0191583340,
(1998).