COMPUTER APPLICATIONS IN PHARMACY

UNIT – I 

Number system: 

• Binary number system, 
• Decimal number system, 
• Octal number system, 
• Hexadecimal number systems, 
• Conversion decimal to binary, binary to decimal, octal to binary etc, 
• Binary addition, binary subtraction – One’s complement ,Two’s complement method, binary multiplication, binary division 

Concept of Information Systems and Software :

• Information gathering 
• Requirement and feasibility analysis 
• Data flow diagrams
• Process specifications 
• Input/output design 
• Process life cycle
• Planning and managing the project 

UNIT –II  

Web technologies: 

• Introduction to HTML,  XML, CSS and Programming languages
• Introduction to web servers and ServerProducts 
• Introduction to databases
• MYSQL
• MS ACCESS
• Pharmacy Drug database 

UNIT – III  

Application of computers in Pharmacy 

• Drug information storage and retrieval
• Pharmacokinetics 
• Mathematical model in Drug design
• Hospital and Clinical Pharmacy
• Electronic Prescribing and discharge (EP) systems 
• Barcode medicine identification and automated dispensing of drugs
• Mobile technology and adherence monitoring 
• Diagnostic System
• Lab-diagnostic System
• Patient Monitoring System 
• Pharma Information System

UNIT – IV 

Bioinformatics: 

• Introduction
• Objective of Bioinformatics 
• Bioinformatics Databases 
• Concept of Bioinformatics
• Impact of Bioinformatics in Vaccine Discovery 

UNIT-V 

Computers as data analysis in Preclinical development: 

• Chromatographic data analysis (CDS)
• Laboratory Information management System (LIMS)
• Text Information Management System(TIMS)

Practical

1. Design a questionnaire using a word processing package to gather information about a particular disease. 

2. Create a HTML web page to show personal information. 

3 Retrieve the information of a drug and its adverse effects using online tools 

4 Creating mailing labels Using Label Wizard , generating label in MS WORD 

5 Create a database in MS Access to store the patient information with the required fields Using access 

6. Design a form in MS Access to view, add, delete and modify the patient record in the database 

7. Generating report and printing the report from patient database 

8. Creating invoice table using – MS Access 

9. Drug information storage and retrieval using MS Access 

10. Creating and working with queries in MS Access 

11. Exporting Tables, Queries, Forms and Reports to web pages 

12. Exporting Tables, Queries, Forms and Reports to XML pages 

Recommended books (Latest edition)

1. Computer Application in Pharmacy – William E.Fassett –Lea and Febiger, 600 South Washington Square, USA, (215) 922-1330. 

2. Computer Application in Pharmaceutical Research and Development –Sean Ekins – Wiley-Interscience, A John Willey and Sons, INC., Publication, USA 

3. Bioinformatics (Concept, Skills and Applications) – S.C.Rastogi-CBS Publishers and Distributors, 4596/1- A, 11 Darya Gani, New Delhi – 110 002(INDIA)

4. Microsoft office Access - 2003, Application Development Using VBA, SQL Server, DAP and Infopath – Cary N.Prague – Wiley Dreamtech India (P) Ltd., 4435/7, Ansari Road, Daryagani, New Delhi - 110002