Computer Application in Pharmacy – B. Pharma 2nd Semester PDF Notes

Scope: Computer Application in Pharmacy B. Pharma Notes deals with the introduction of Databases, Database Management systems, computer application in clinical studies, and the use of databases.

Objectives: Upon completion of the course the student shall be able to

1. Know the various types of applications of computers in pharmacy

2. Know the various types of databases

3. Know the various applications of databases in pharmacy

Course content: Computer Application in Pharmacy Notes

Computer Application 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

Computer Application in Pharmacy UNIT –II

Web technologies: Introduction to HTML, XML, CSS, and Programming languages, introduction to web servers and Server Products

Introduction to databases, MYSQL, MS ACCESS, Pharmacy Drug database

Computer Application in Pharmacy 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

Computer Application in Pharmacy UNIT – IV

Bioinformatics: Introduction, Objective of Bioinformatics, Bioinformatics Databases, Concept of Bioinformatics, Impact of Bioinformatics in Vaccine Discovery

Computer Application in Pharmacy UNIT-V

Computers as data analysis in Preclinical Development:

Chromatographic data analysis (CDS), Laboratory Information management

System (LIMS) and Text Information Management System (TIMS)

Computer Application in Pharmacy Short Notes:

1. Number System:

Understanding number systems is essential for computer applications in pharmacy.

The decimal system (base 10) is commonly used, but binary (base 2) and hexadecimal (base 16) systems are also important.

Computers operate using binary digits (bits) that represent information as 0s and 1s.

2. Concept of Information Systems and Software:

Information systems in pharmacy involve the use of computer hardware, software, and data to manage and process information effectively.

Software refers to the programs and applications that run on computers, enabling various tasks and functionalities.

Pharmacy software can include inventory management systems, prescription processing software, and electronic health records.

3. Web Technologies:

Web technologies play a crucial role in pharmacy by enabling online communication, information sharing, and e-commerce.

Websites and web applications provide platforms for patients to access medication information, make online purchases, and communicate with pharmacists.

Technologies such as HTML, CSS, JavaScript, and server-side scripting are used to develop web-based pharmacy applications.

4. Introduction to Databases:

Databases are organized collections of data that store and manage information efficiently.

In pharmacy, databases are utilized to store patient records, medication information, drug interactions, and clinical research data.

Structured Query Language (SQL) is commonly used to query, retrieve, and update data in pharmacy databases.

5. Application of Computers in Pharmacy:

Computers are extensively used in pharmacies for tasks such as prescription processing, inventory management, and drug interaction checks.

Computer systems automate various pharmacy processes, reducing errors and improving efficiency.

Electronic prescribing systems, barcode scanning, and automated dispensing machines are examples of computer applications in pharmacies.

6. Bioinformatics:

Bioinformatics combines computer science, statistics, and biological data to analyze and interpret biological information.

In pharmacy, bioinformatics is used to study drug interactions, molecular modeling, genomics, and proteomics.

Computational tools and algorithms aid in drug discovery, target identification, and personalized medicine.

7. Computers as Data Analysis in Preclinical Development:

Computers play a significant role in analyzing and interpreting data generated during preclinical development in pharmacy.

Data from experiments, clinical trials, and research studies are processed and analyzed using statistical software and algorithms.

Computer-based data analysis helps in identifying patterns, making predictions, and evaluating the safety and efficacy of pharmaceutical products.

Computer Application in Pharmacy (Practical)

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

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

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

4. Creating mailing labels Using Label Wizard, generating labels 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 reports and printing the report from the 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

Computer Application in Pharmacy 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