H. B. Bhadka | Books Published

H. B. Bhadka
~ Books Published ~

Computer Applications And Basic Biostatistics
for Pharmacy

Authors: H. B. Bhadka, Dr. N. N. Jani, Dr. G. R. Kulkarni

For Business Inquiry, Contact at

AKSHAT PUBLICATION & DISTRIBUTORS

1-17 Brahmanand Chambers, Opp. M.P.Shah Arts & Science College,

Main Road, Surendranagar, Gujarat. India.

Web: http://www.akshatpublication.com n E: akshatpub@yahoo.com

Tele: +91-2752-699128, R-221570 n CELL: 098253-79977

Contents at a Glance

n n n

PART ONE: Computer Applications

Chapter 1: Computer Fundamentals......................................................... 3

Chapter 2: Microsoft DOS........................................................................... 29

Chapter 3: Microsoft Word 2007.............................................................. 49

Chapter 4: Microsoft Excel 2007............................................................ 101

Chapter 5: BASIC Programming............................................................. 155

Chapter 6: Internet................................................................................... 177

Chapter 7: Pharmacy Interested Websites and Softwares............... 185

Chapter 8: Excel Tutorials on Biostatistics.......................................... 189

n n n

PART TWO: Basic Biostatistics

Chapter 9: Biostatistics Introduction................................................... 197

Chapter 10: Measures of Central Tendency......................................... 215

Chapter 11: Probability............................................................................ 231

Chapter 12: Standard Probability Distributions................................ 247

Chapter 13: Correlation........................................................................... 265

Chapter 14: Linear Regression............................................................... 273

Chapter 15: Dispersion............................................................................ 285

Chapter 16: Sample and Sampling Methods....................................... 297

Chapter 17: Testing of Hypothesis......................................................... 301

Chapter 18: Analysis of Variance........................................................... 317

Interactive Internet Application
for Diploma Engineering

Authors: H. B. Bhadka, Dr. N. N. Jani, Prof. K. H. Wandra

For Business Inquiry, Contact at

AKSHAT PUBLICATION & DISTRIBUTORS

1-17 Brahmanand Chambers, Opp. M.P.Shah Arts & Science College,

Main Road, Surendranagar, Gujarat. India.

Web: http://www.akshatpublication.com n E: akshatpub@yahoo.com

Tele: +91-2752-699128, R-221570 n CELL: 098253-79977

Contents

n n n

n Chapter 1: Internet Introduction

Introduction........................................................................................................................ 1

What is Internet?................................................................................................... 1

History and Development of the Internet.................................................. 2

What makes the Internet work................................................................................... 2

What makes WWW work................................................................................. 3

Uniform Resource Locators (URLs)......................................................................... 3

Structure of an URL............................................................................................. 3

Domain Name..................................................................................................................... 4

Internet Service Provider (ISP)..................................................................... 5

Getting Access to the Internet......................................................................... 5

Protocol Layers................................................................................................................. 5

Network Diagram............................................................................................................. 6

Software and Services Supported by Internet..................................................... 7

Email.......................................................................................................................... 7

File Transfer Protocol (FTP)........................................................................... 7

Telnet......................................................................................................................... 8

News or Usenet...................................................................................................... 8

Internet Relay Chat (IRC).................................................................................. 8

http Protocol.......................................................................................................... 8

Cookies...................................................................................................................... 8

Browser................................................................................................................................ 9

Internet Explorer.................................................................................................. 9

Firefox....................................................................................................................... 9

Netscape Navigator.............................................................................................. 9

Avant Browser....................................................................................................... 9

Hotjava................................................................................................................... 10

Lynx......................................................................................................................... 10

Search Engines................................................................................................................ 10

Google..................................................................................................................... 10

Micorosoft............................................................................................................. 10

Yahoo...................................................................................................................... 10

Mahalo – The Human-Powered Search Engine..................................... 11

AltaVista................................................................................................................. 11

Ask............................................................................................................................ 11

AOL........................................................................................................................... 11

Intranet............................................................................................................................... 11

Exercises............................................................................................................................ 12

n Chapter 2: Fundamentals of HTML

Introduction..................................................................................................................... 13

HTML Page Structure....................................................................................... 13

Head Section..................................................................................................................... 14

Base.......................................................................................................................... 14

ISIndex.................................................................................................................... 15

Link.......................................................................................................................... 15

Meta......................................................................................................................... 16

NextID..................................................................................................................... 17

Title.......................................................................................................................... 17

Style......................................................................................................................... 17

Script....................................................................................................................... 18

Body Section.................................................................................................................... 18

Section Headings................................................................................................ 18

Marking Paragraph............................................................................................ 19

Address Element................................................................................................. 20

Blockquote Element......................................................................................... 20

Div, Lists................................................................................................................. 21

Horizontal Rule................................................................................................... 21

Preformatted....................................................................................................... 21

Tables...................................................................................................................... 22

Hypertext Anchors............................................................................................ 27

Line Breaks........................................................................................................... 27

Comments.......................................................................................................................... 28

Images................................................................................................................................. 28

Placing an Image on Page............................................................................... 28

Image Formats..................................................................................................... 28

Activating an Image........................................................................................... 29

Frames................................................................................................................................ 29

Generic Frame Page.......................................................................................... 29

Frame Set............................................................................................................... 30

Frame Border and Frame Spacing............................................................... 30

Frame Name and Frame Target.................................................................... 31

Noresize and Scrolling..................................................................................... 31

HTML Formatting Tags................................................................................................ 32

Bold, Italic, SuperScript, SubScript............................................................. 32

Strikethrough....................................................................................................... 33

Marquee............................................................................................................................. 33

Special Character Tag................................................................................................... 33

Miscellaneous Tag.......................................................................................................... 33

<Blink> .. </Blink>............................................................................................. 33

<!Doctype HTML Public>............................................................................... 33

<Meta HTTP-Equiv=”***”>............................................................................ 34

Exercises............................................................................................................................ 34

n Chapter 3: HTML Forms

Introduction..................................................................................................................... 35

The HTML Form Tag..................................................................................................... 35

Action=”handlerpage”...................................................................................... 35

Method=”Get”|”Post”....................................................................................... 36

The Input Items................................................................................................... 36

Form Fields....................................................................................................................... 38

Text Field............................................................................................................... 38

Text Area................................................................................................................ 39

Check Box.............................................................................................................. 40

Radio Button........................................................................................................ 41

Drop Down Menu............................................................................................... 43

Submit Button..................................................................................................... 44

Password Field.................................................................................................... 45

Hidden Field......................................................................................................... 47

Reset Button......................................................................................................... 48

Image Button........................................................................................................ 49

Exercises............................................................................................................................ 50

n Chapter 4: Style Sheet

Introduction..................................................................................................................... 51

Rules .................................................................................................................................... 52

Selectors................................................................................................................. 52

Grouping................................................................................................................ 52

Inheritance............................................................................................................ 53

Comments.............................................................................................................. 53

Pseudo-Classes and Pseudo-Elements.................................................................. 53

Anchor Pseudo-Classes.................................................................................... 53

First Line Pseudo-Element............................................................................. 54

Properties.......................................................................................................................... 54

Font Properties................................................................................................... 54

Text Properties................................................................................................... 56

Color and Background Properties.............................................................. 57

Box Properties..................................................................................................... 59

Classification Properties................................................................................. 61

Linking Style Sheets to HTML................................................................................... 63

Linking to an External Style Sheet.............................................................. 63

Importing a Style Sheet.................................................................................... 63

Exercises............................................................................................................................ 64

n Chapter 5: Getting Started with ASP

Introduction..................................................................................................................... 65

ASP Environment............................................................................................... 65

Installing ASP....................................................................................................... 65

Installing ASP and IIS on Windows XP Professional.......................... 66

ASP and Web Server..................................................................................................... 66

Running an ASP Web Page............................................................................. 67

Where ASP file should store.......................................................................... 67

First ASP Script............................................................................................................... 67

ASP Tags................................................................................................................. 68

.asp File................................................................................................................... 68

Delimiters.............................................................................................................. 69

Statements............................................................................................................. 69

Including Other Files.................................................................................................... 71

The Virtual Keyword........................................................................................ 71

The File Keyword............................................................................................... 71

VBScript............................................................................................................................. 71

Interfacing VBScript with HTML................................................................. 72

Data Types............................................................................................................ 72

Variables................................................................................................................ 73

Constants............................................................................................................... 75

Operators............................................................................................................... 76

Special Characters.......................................................................................................... 77

String Concatenation: The Ampersand (&)............................................. 77

ASP Comments: The Apostrophe (‘)........................................................... 77

Spanning Multiple Lines: The Underscore (_)........................................ 77

Squishing onto a Line: The Colon (:).......................................................... 78

Calling Methods: The Period (.)................................................................... 78

Declaring ASP Code: The Percentage (%)............................................... 78

Write Shortcut: The Percentage Equal (%=)......................................... 78

Server-Side Includes (SSI).......................................................................................... 79

Exercises............................................................................................................................ 80

n Chapter 6: Object Basics

Built-in Objects............................................................................................................... 81

Application Object............................................................................................. 81

ASPError Object................................................................................................. 83

Response................................................................................................................ 83

Request................................................................................................................... 86

Active Server Pages Objects...................................................................................... 89

Dictionary Objects......................................................................................................... 90

Handling of Files............................................................................................................. 91

Cookies............................................................................................................................... 93

How to Create a Cookie?................................................................................. 93

How to Retrieve a Cookie value?................................................................. 94

Multiple Values.................................................................................................... 94

Server Objects................................................................................................................. 95

Create Objects...................................................................................................... 95

HTML Encode...................................................................................................... 96

Map Path................................................................................................................ 96

URL Encode.......................................................................................................... 96

Session Object.................................................................................................................. 97

Session Object Collections.............................................................................. 97

Session Object Properties............................................................................... 97

Session Object Methods................................................................................... 97

Session Object Events...................................................................................... 97

The Global .asa File........................................................................................................ 98

The Input Box Function............................................................................................... 99

The MsgBox Function................................................................................................ 100

Exercises......................................................................................................................... 100

n Chapter 7: ASP Components

Introduction.................................................................................................................. 101

Ad Rotator Components............................................................................... 101

Content Linking................................................................................................ 102

Browser Capabilities...................................................................................... 103

Exercises......................................................................................................................... 104

n Chapter 8: Working with Connection and Data Sources

Database Introduction.............................................................................................. 105

Data Source Name (DSN)............................................................................. 105

Creating Connections with OLE DB and ODBC............................................... 106

ODBC Connection Strings............................................................................. 106

OLEDB Connection Strings.......................................................................... 106

Connecting with Microsoft SQL Server.............................................................. 107

Connecting with OLE DB.............................................................................. 107

Connecting with ODBC Connection......................................................... 107

Connecting with System DSN..................................................................... 110

Connecting with DSN-Less.......................................................................... 111

Connecting with Microsoft Access....................................................................... 111

Connecting with System DSN..................................................................... 112

Connecting with DSN-Less.......................................................................... 114

Create a Local DSN.......................................................................................... 114

Connecting to a Database with DSN........................................................ 117

Exercises......................................................................................................................... 118

n Chapter 9: Database Connection Object

Introduction.................................................................................................................. 119

Considering Performance............................................................................ 119

Executing a SQL Statement...................................................................................... 120

Creating a new Database Table.................................................................. 120

Inserting Data into a Database Table...................................................... 121

Updating Data in a Database Table.......................................................... 121

Deleting Data from a Database Table...................................................... 121

Selecting Data from the Database Table................................................ 122

Using Transaction....................................................................................................... 122

BeginTrans......................................................................................................... 123

CommitTrans..................................................................................................... 123

Connection Pooling........................................................................................ 123

Working with Record Sets....................................................................................... 124

Retrieving a Record Sets............................................................................... 124

Understanding ADO Cursors....................................................................... 124

Retrieving a Count of Records................................................................... 125

Paging through a Record Set................................................................................... 125

Limiting the Records...................................................................................... 127

Batch Updating Records............................................................................... 128

Exercises......................................................................................................................... 128

n Chapter 10: Database Command Object

Introduction.................................................................................................................. 129

Creating Stored Procedure.......................................................................... 130

Executing Stored Procedure....................................................................... 131

Destroying Stored Procedure.................................................................... 132

Parameter and Return Values.................................................................... 132

Input Parameters............................................................................................. 132

Output Parameters......................................................................................... 132

Identity Columns............................................................................................. 133

Exercises......................................................................................................................... 134

n Chapter 11: Debugging and Error Handling

Speeding Up ASP Page Execution......................................................................... 135

Disabling Session State.................................................................................. 135

Declaring Option Explicit............................................................................. 135

Enabling the Response Buffer.................................................................... 135

Functions and Collections............................................................................ 135

Only open a database connection one time per page....................... 136

Defensive Coding Techniques................................................................................ 136

Reduce source code complexity............................................................... 136

Source code reviews...................................................................................... 136

Software Testing.............................................................................................. 136

Intelligent source code reuse..................................................................... 136

The legacy problems...................................................................................... 136

Secure Input/Output Handling.................................................................. 137

Cononicalization.............................................................................................. 137

Error Handling.............................................................................................................. 137

Types of Error.................................................................................................. 137

Handling the Error.......................................................................................... 138

Error Handling and Database..................................................................... 139

More Advanced Error Page......................................................................... 140

Redirect with the Error Handlers............................................................. 141

Implement Error Logging........................................................................................ 141

ASP Errors...................................................................................................................... 142

Err Object....................................................................................................................... 143

Properties........................................................................................................... 143

Methods............................................................................................................... 144

Exercises......................................................................................................................... 145

n Glossary.............................................................................................................. 146

n Laboratory Experiments 151