ND2 Notes
Complete notes for your ND2 courses. Read, study, and download.
Effect of Water on Group II Elements
The Group II elements are Beryllium (Be), Magnesium (Mg), Calcium (Ca), Strontium (Sr), Barium (Ba) and Radium (Ra). They are called alkaline earth metals and react vigorously with cold water except Beryllium which does not react with water.
In each reaction, hydrogen gas is given off and the metal hydroxide is produced. Calcium and magnesium dissolved in water are the two most common minerals that make water hard. The degree of hardness becomes greater as the calcium and magnesium content increases.
Reactions of Mg and Ca with Water
Reactivity increases down the group.
- Magnesium: No reaction occurs with cold water. However in a reaction with steam, it forms MgO and hydrogen gas.
- Calcium: More reactive. Reacts with cold water to produce an alkaline solution of calcium hydroxide and hydrogen gas is released.
Hard Water and Soft Water
Definitions
- Soft Water: Gives ready and permanent lather with soap. Examples: rain water, distilled water.
- Hard Water: Does not give ready and permanent lather with soap. Examples: sea water, river water, tap water.
Soaps are sodium salts of higher fatty acids. They react with Ca²⁺ and Mg²⁺ ions present in hard water to form salts and produce a curdy precipitate. Hence they are not suitable for washing purposes.
Origin and Definition of Hardness
Hardness of water is a measure of the amount of calcium and magnesium salts in water. Hard water contains high concentrations of dissolved calcium and magnesium. The more calcium and magnesium in water, the harder the water. Hardness is usually expressed in milligrams per liter (mg/L) of dissolved calcium and magnesium carbonate.
Types of Hardness
- Temporary Hardness (Carbonate Hardness): Due to dissolved hydrogen carbonates of calcium and magnesium. When the water is boiled, it decomposes to form calcium carbonate (precipitation) and CO₂.
- Permanent Hardness (Non-carbonate Hardness): Due to the presence of calcium or magnesium sulfates, chlorides and nitrates. Cannot be removed by boiling.
Removal of Temporary Hardness
Temporary hardness is caused by dissolved carbonate minerals (calcium carbonate and magnesium carbonate). When dissolved, these minerals yield calcium and magnesium cations (Ca²⁺, Mg²⁺) and carbonate/bicarbonate anions.
Method 1: Boiling
On boiling, the bicarbonates of Ca and Mg decompose into insoluble carbonates, which are removed by filtration.
Method 2: Clark's Process
Lime (calcium hydroxide) is added to precipitate calcium carbonate and magnesium hydroxide, which are removed by filtration.
Removal of Permanent Hardness
Permanent hardness is mainly due to calcium and magnesium ions in the form of soluble sulfate and chloride salts. Hard water leaves white deposits on kettles and builds up in hot water pipes.
Method 1: Adding Washing Soda (Na₂CO₃)
Ca and Mg ions are precipitated as insoluble carbonates which are removed by filtration.
Method 2: Ion Exchange Method
Ions responsible for hardness are exchanged with ions that do not cause precipitation.
- (a) Permutit Method (Inorganic Ion Exchange): Sodium aluminium silicate (Na₂Al₂Si₂O₈.xH₂O) known as zeolites or permutit (Na₂Z). When hard water is passed through zeolites, Na⁺ ions from the zeolites replace Ca²⁺ and Mg²⁺ ions.
- (b) Organic Ion Exchangers: Organic polymers having -COOH or -SO₃H or -NH₃⁺OH⁻ groups act as ion exchange resins. When hard water is passed through tanks filled with resins successively, the resins exchange the ions that cause hardness.
Estimation of Ca²⁺ and Mg²⁺ in Water
The ions involved in water hardness can be determined by titration with EDTA (ethylenediaminetetraacetic acid), usually in the form of the disodium salt (H₂Y²⁻).
Eriochrome Black T is commonly used as an indicator for this titration. At pH 10, the Ca²⁺ ion first complexes with the indicator as CaIn⁺(aq) which is wine red. As EDTA is added, the CaIn⁺ complex is replaced by CaY²⁻ which is blue. The endpoint is indicated by a sharp colour change from wine red to blue.
Advantages and Disadvantages of Hard Water
Advantages
- Helps animals such as snails and crabs to make their shells (made mainly of calcium carbonate).
- Tastes better than soft water because of the dissolved minerals in it.
- Helps build strong teeth and bones due to the presence of calcium salt.
- Does not dissolve lead, so it does not lead to lead poisoning if lead pipes are used.
- Generally safer for drinking than soft water.
Disadvantages
- Requires a lot of soap before it can form a lather — wasteful.
- Does not lather freely with soap; produces sticky scum on bath-tubs and the body.
- Causes furring of kettles and boilers (annoying limescale in containers, pots, pipes).
- Elevates the boiling point of water due to dissolved hardness salts.
- Not advisable to use for washing white fabrics as it tends to make them appear grey.
- Cannot be used in dyeing and tanning as the salts interfere with the process.
- Corrodes boilers.
Group III Elements (Boron Group)
Group III elements have 3 valence electrons. The chemistry of these elements is dominated by the +3 oxidation state formed by losing all three valence electrons. They are highly electropositive metals.
Members of the Boron Group
- Boron (B), Aluminium (Al), Gallium (Ga), Indium (In), Thallium (Tl)
Physical Properties
- Metallic character: Increases down the group. All are metals except Boron which is a non-metal (metalloid). Ununtrium has not been confirmed.
- Softness: Hardness decreases down the group; softness increases. All elements of Group 3A are soft except Boron which is relatively hard. Thallium is the softest natural element in the group.
- Electropositive character: Less electropositive than alkaline earth metals due to smaller size and higher ionisation enthalpies. First increases from B to Al then decreases from Ga to Tl due to poor shielding by d and f orbitals.
- Reducing character: Decreases down the group from Al to Tl because of increase in electrode potential value. Order: Al > Ga > In > Tl.
Oxidation State
The valence electron configuration of Group 3A elements is ns²np¹, and their primary oxidation state is +3. Heavier elements also exhibit a +1 state due to the inert pair effect. The tri-oxidation state becomes less stable going down the group, while the mono-oxidation state becomes more stable.
Chemical Properties of Group 3 Elements
- Action of air: Crystalline boron is unreactive; amorphous boron reacts at 700°C: 4B + 3O₂ → 2B₂O₃. Aluminium is stable in air due to protective oxide film: 4Al + 3O₂ → 2Al₂O₃.
- Oxides: Except Tl, all Group 13 elements form oxides of general formula M₂O₃ on heating with oxygen.
- Nature of oxides: On moving down the group, there is a change from acidic to amphoteric then to basic character.
Anomalous Behaviour of Boron
Boron shows anomalous behaviour due to: smallest size in the group, high ionisation energy, highest electronegativity in the group, and absence of vacant d-orbitals.
- It is a non-metal while other members are metallic.
- Shows allotropy while other members do not.
- Has the highest melting point and boiling point in Group 13.
- Forms only covalent compounds while others form both ionic and covalent.
- Halides of boron exist as monomers while AlCl₃ exists as a dimer.
- Oxides and hydroxides are weakly acidic while Al is amphoteric and others are basic.
Diagonal Relationship Between Boron and Silicon
- Both B and Si are non-metals and semiconductors.
- Both form covalent hydrides (boranes and silanes).
- Both form covalent, volatile halides which fume in moist air.
- Both form solid oxides that dissolve in alkalis forming borates and silicates.
Group IV Elements (Carbon Group)
Group IV elements have 4 valence electrons. The non-metals in this family react by gaining 4 extra electrons through covalent bonds.
Members: Carbon (C), Silicon (Si), Germanium (Ge), Tin (Sn) and Lead (Pb).
General Physical Properties
- Belong to the p-block; valence shell electronic configuration is ns²np².
- Metallic character: C and Si are non-metals, Ge is a metalloid, Sn and Pb are metals.
- Appearance: C is black, Si is light-brown, Ge is greyish, Sn and Pb are silvery white.
- Oxidation state: They exhibit +2 and +4 oxidation states. Pb in +4 state is a powerful oxidising agent since +2 state of Pb is more stable (inert pair effect).
Chemical Properties
- Hydrides: All members form covalent hydrides. Hydrides of carbon are called hydrocarbons (alkanes, alkenes, alkynes). Hydrides of Si and Ge are silanes and germanes. Hydrides of Sn and Pb are stannane (SnH₄) and plumbane (PbH₄). Thermal stability decreases and reducing character increases down the group.
- Oxides: Form two types: monoxides (MO) and dioxides (MO₂). CO₂ is a linear gas; solid CO₂ is known as dry ice or drikold. SiO₂ is a solid with a three-dimensional network in which Si is bonded to four oxygen atoms tetrahedrally.
Kieselguhr is a mass of hydrated silica (SiO₂) formed from skeletons of minute plants called diatoms. It is a highly porous material used in the manufacture of dynamite.
Spectrophotometry
Spectrophotometry is a technique that refers to the use of light to measure chemical concentrations that a sample absorbs. Its instrument is known as a Spectrophotometer, which contains a prism or grating monochromator that permits a continuous choice of wavelength.
Instruments exist for measurements in the ultraviolet, visible and infrared regions. The basic design of a spectrophotometer is largely independent of wavelength.
Key Relationships
The relationship between frequency and wavelength for electromagnetic waves is defined by:
Wavenumber is the reciprocal of wavelength:
Particle Properties of Radiation
Energy of electromagnetic radiation requires considering radiation as packets of energy called photons or quanta. The energy of a photon depends upon the frequency of the radiation:
In terms of wavelength and wavenumber:
The relationship between wavelength and energy is inverse, while the relationship between energy and frequency is direct.
Practice Exercises
- Calculate the frequency and wavenumber of infrared light of wavelength λ = 15.5 μm. Express the wavenumber in both m⁻¹ and cm⁻¹.
- Calculate the wavelength, wavenumber and frequency of radiation having an energy of 1.6 × 10⁻¹² J.
- Calculate the energy in kJ/mol of an electromagnetic radiation with a wavelength of 676 nm.
Electromagnetic Spectrum
The electromagnetic spectrum is a continuum of all electromagnetic waves arranged according to frequency and wavelength. Waves of different wavelengths give rise to light of different colours; a mixture of these wavelengths constitutes white light. White light covers the entire visible spectrum: 400 to 700 nm.
X-rays and gamma-rays have very short wavelengths, whereas UV, visible, infrared and radio waves have progressively longer wavelengths.
Interactions of Electromagnetic Radiation with Matter
- Absorption
- Emission
- Fluorescence
Matter exists in two primary forms:
- Atomic: When interaction exists within one atom.
- Molecular: When interaction exists between atoms that are polyatomic.
Atomic Absorption Spectrophotometry (AAS)
AAS is a spectroanalytical procedure for the quantitative determination of chemical elements using the absorption of optical radiation (light) by free atoms in the gaseous state. AAS can be used to determine over 70 different elements in solution or directly in solid samples.
Beer-Lambert's Law
The technique relies on the Beer-Lambert's Law, which is the heart of spectrophotometry. The law states that the absorbance of a given solution is directly proportional to the concentration of the absorbing species at a constant path length.
The electrons of the atoms in the atomizer can be promoted to higher orbital (excited state) for a short period of time (nanoseconds) by absorbing a defined quantity of energy. Each element has a specific wavelength significant to its particular electron transition.
Criteria for Satisfactory Spectrophotometry
- There must be proportionality between colour and concentration. Beer's Law works for dilute solutions.
- The reactions must be made specific.
- The colour of the solution must be sufficiently stable over a period.
- The reaction and procedure must give reproducible results under specific experimental conditions.
- The coloured reaction must be highly sensitive to allow trace analysis.
- There should be no presence of particles — the solution must be free from precipitate or suspended particles.
Limitations of Beer's Law
- Real deviation
- Instrumental deviation
- Chemical deviation
AAS Instrumentation
Five basic components of an atomic absorption instrument:
- The light source that emits the spectrum of the element of interest.
- A monochromator for light dispersion.
- An absorption cell in which atoms of the sample are produced.
- A detector which measures the light intensity and the signal.
- A read-out device (display) that shows the reading after processing.
Single-Beam Instrument
Provided with interchangeable radiation sources (deuterium or hydrogen discharge tube for lower wavelengths; tungsten filament lamp for visible or near infrared regions). The light source must be electronically modulated or mechanically chopped. Suited for absorbance measurement at a single wavelength. Advantages: simplicity and ease of maintenance.
Double-Beam Instrument
The light source is divided into two identical beams — one passes through the reference or solvent cell and the other passes through the sample cell. The beams are recombined and focused on a single detector. The read-out represents the ratio of sample and reference beam. Advantages: greater speed and convenience of measurement. Analyses can be performed with no lamp warm-up.
Atomic Absorption Spectroscopy — Principle
The principle involves the measurement of resonance radiation absorbed by a free ground-state atom in a flame. Absorptions involving the ground state are known as resonance lines, while radiation resulting from emission from the first excited state to ground state is known as resonance radiation. The more powerful the radiation source, the greater the sensitivity of the technique.
Radiation Sources
- Flame: Used for absorption technique. Product of combustion of fuel and oxidant.
- Plasma and Electrothermal Furnace: Used for emission technique and non-flame methods.
The most common source for atomic absorption measurement is the Hollow Cathode Lamp. Ionization of the gas occurs when potential is applied across the electrodes and a current flows as ions migrate to the electrodes. Sputtering occurs when gaseous cations acquire enough kinetic energy to dislodge metal atoms from the cathode surface, producing an atomic cloud.
Atomic Emission Spectroscopy (AES)
AES is similar to AAS, but no light source is needed. Some atoms in the flame are promoted to excited electronic states by collision with other atoms. The excited atoms emit their characteristic radiation as they return to their ground state.
The greater the energy of the exciting source, the higher the energy of the excited electrons, and the greater the number of lines that may appear. In AES, the emission intensity at a characteristic wavelength of an element is nearly proportional to the concentration of the element in the sample.
Since each element exhibits its characteristic spectrum, elements in an unknown spectrum may be identified by comparing with the spectrum of a known element.
Flame Emission Spectroscopy (FES) and Flame Photometry
Two Main Methods for FES
- Flame Photometry: Original method; used mainly for analysis of alkali metals, particularly in biological fluids and tissues.
- Flame Atomic Absorption Spectrometer in emission mode.
FES can be more sensitive than Flame Atomic Absorption Spectrometer.
Flame Photometer
An instrument for measuring light emission in a flame. Principle: measures emitted radiation by excited ground-state atoms in an air-butane or propane flame (relatively cool flame), using an optical filter, then converted to an electrical signal by the photodetector (a photomultiplier).
- Spectral selection device in photometer: optical filters.
- Spectral selection in spectrophotometer: prisms and diffraction gratings.
- Can be used to analyse alkaline and alkaline earth metals e.g. Na, K, Ca.
Mode of Operation of a Flame Photometer
- Open the gases and mix in the right proportion to obtain a blue flame. No other colour is desirable.
- Aspirate distilled or deionised water.
- Adjust galvanometer reading to zero (read-out).
- Aspirate solutions of standards and analyte of interest.
Electronic Structure of Elements
Electrons revolve only in permitted orbits identified using letters K, L, M, N, P etc., starting from the nucleus outwards. The shells are known by their principal quantum number n (n=1 for K shell, n=2 for L shell, n=3 for M shell). Maximum electrons per shell = 2n².
Covalent Bond
Covalent bonds are formed by sharing of electrons. Each valence electron of an atom forms a direct bond with the valence electron of an adjacent atom. This can occur between two similar or dissimilar atoms.
Energy Bands
Valence Band: The range of energies possessed by valence electrons. May be completely or partially filled but cannot be empty.
Conduction Band: The range of energies possessed by conduction electrons. All electrons in the conduction band are free electrons. Insulators have an empty conduction band.
Forbidden Energy Gap: The separation between conduction band and valence band on the energy level diagram. The greater the energy gap, the more tightly valence electrons are bound to the nucleus.
Conductors, Semiconductors and Insulators
Conductors: Allow easy passage of electric current. The valence and conduction bands overlap each other.
Semiconductors: Electrical conductivity lies between conductors and insulators. Valence band is almost filled and conduction band is almost empty. Energy gap is very small (~1eV).
Insulators: Do not allow electric current. Valence band is full, conduction band is empty. Energy gap is very large (~15eV).
Intrinsic & Extrinsic Semiconductors
Intrinsic Semiconductor: A semiconductor in an extremely pure form. Silicon and Germanium are the two most common types, both having four valence electrons.
Extrinsic Semiconductor: A semiconductor that has been doped with impurities to increase and control conductivity. Two types: n-type (pentavalent impurity added, more free electrons) and p-type (trivalent impurity added, more holes).
Doping: The process of adding impurities to an intrinsic semiconductor to increase and control conductivity.
P-N Junction Diode
When a P-N junction is formed, free electrons from the n-type diffuse into the p-type to fill holes. The region on either side of the junction becomes free of majority charge carriers — this is called the Depletion/Barrier Layer.
Forward Bias: Positive terminal connected to p-type, negative to n-type. Cancels the potential barrier, allowing current flow.
Reverse Bias: Negative terminal connected to p-type, positive to n-type. Increases the potential barrier, preventing current flow.
Types of Diodes & Applications
Zener Diode: Used as voltage regulators, fixed reference voltage, calibrating voltmeters, peak clippers.
Tunnel Diode: Used in logic memory storage, as amplifier, microwave oscillator (~10GHz), relaxation oscillator, ultrahigh-speed switch.
LED (Light Emitting Diode): Used as indicator lamps, seven-segment displays, numeric displays in calculators.
Photodiode: Used as fast counters, in switching circuits, encoders, optical communication equipment, demodulation.
Varactor Diode: Used as automatic frequency control device, FM modulator, adjustable band pass filter.
Rectification
Half-Wave Rectification: When the sine wave goes positive, the diode is forward biased and conducts current through the load resistor. Only positive half-cycles appear at the output.
Full-Wave Rectification: Uses centre-tap configuration with two diodes. Both halves of the AC cycle appear at the output.
Breakdown Mechanisms
Avalanche Breakdown: Carriers accelerate and gain enough energy in the electric field to knock loose valence electrons, causing an avalanche of carriers and a massive increase in reverse current.
Zener Breakdown: In heavily doped regions, the depletion layer becomes very narrow and the intense electric field breaks covalent bonds directly, generating hole-electron pairs and causing reverse current to rise abruptly.
Thermionic Valves
Triode: Three electrodes — cathode, anode, and control grid. The anode current is controlled by varying the p.d between the grid and cathode. A small change in grid voltage produces a large change in anode current.
Tetrode: Four electrodes — cathode, anode, control grid, and screen grid. The screen grid provides electrostatic shielding between anode and control grid, minimizing feedback effects. Anode current remains nearly constant over large variation of anode voltage.
Pentode: Five electrodes — adds a suppressor grid between anode and screen grid. Prevents secondary electrons from reaching the screen grid, eliminates feedback action, and increases amplification factor.
Lecturer: Mr. Moses N. James
Electronic Structure of Elements
Electrons can revolve only in permitted orbits and not in arbitrary ones. The orbits are identified using alphabetical letters: K, L, M, N, P etc., starting from the nucleus outwards. The shells are known by their principal quantum number n, with values n=1 for K shell, n=2 for L shell, n=3 for M shell.
Silicon atom has 14 electrons: first shell = 2, second shell = 8, third shell = 4 (partially occupied). Similarly, germanium atom has its first three orbits fully occupied while the 4th orbit is partially filled.
Covalent Bond
Covalent bonds are formed by sharing of electrons. Each valence electron of an atom forms a direct bond with the valence electron of an adjacent atom. This can occur between two similar or dissimilar atoms.
In silicon, each tetravalent silicon atom shares one electron each with four surrounding atoms, thereby completing 8 electrons in its outermost orbit. Germanium behaves similarly.
Pure germanium has more free electrons than silicon and therefore higher conductivity. However, silicon is the favoured semiconductor material and is far more widely used because silicon can be used at a much higher temperature than germanium.
Energy Bands
Valence Band
The range of energies possessed by valence electrons is known as the valence band. It may be either completely filled or partially filled with electrons but cannot be empty. Inert gases have valence bands that are full; for other materials, it is only partially filled. The partially filled band can accommodate more electrons.
Conduction Band
The conduction band is the range of energies possessed by conduction band electrons. All electrons in the conduction band are free electrons. Generally, insulators have empty conduction bands, hence current is not possible in the conduction band.
Forbidden Energy Gap
The forbidden energy gap is the separation between the conduction band and the valence band on the energy level diagram. The width of the forbidden energy gap is a measure of the bondage of valence electrons to the atom. The greater the energy gap, the more tightly the valence electrons are bound to the nucleus.
To push an electron from the valence band to the conduction band, external energy equal to the forbidden energy gap must be supplied.
Conductors, Semiconductors and Insulators
Conductors
Substances which easily allow the passage of electric current. In the energy band structure, the valence and conduction bands overlap each other. There is no forbidden energy gap.
Semiconductors
Substances whose electrical conductivity lies between conductors and insulators. The valence band is almost filled and the conduction band is almost empty. The forbidden energy gap between valence and conduction bands is very small (approximately 1 eV).
Properties of Semiconductors:
- All are tetravalent — they have four electrons at the outermost shell.
- They have two charged carriers — positive and negative charges.
- They have a negative temperature coefficient: as temperature increases, resistance decreases.
- They all undergo covalent bonding.
- When a suitable metallic impurity (e.g. arsenic, gallium) is added, current conducting properties change appreciably.
Insulators
Substances which do not allow the passage of electric current. The valence band is full while the conduction band is empty. The energy gap between valence and conduction bands is very large (approximately 15 eV).
Common Semiconductor Materials
Two types of widely used semiconductor materials are silicon (Si, 14 protons) and germanium (Ge, 32 protons). Both have four valence electrons.
Intrinsic and Extrinsic Semiconductors
Intrinsic Semiconductor
A semiconductor in an extremely pure form is known as an intrinsic semiconductor. Conduction in an intrinsic semiconductor is known as intrinsic conduction.
Extrinsic Semiconductor
Intrinsic semiconductor has little current conduction capability at room temperature. To be useful in electronic services, the pure semiconductor must be altered to significantly increase conducting properties. This is achieved by adding a small amount of suitable impurity — this is known as doping.
- n-type semiconductor: When a pentavalent impurity is added, a large number of free electrons are produced. Negative carriers (electrons) are the majority carriers.
- p-type semiconductor: When a trivalent impurity is added, a large number of holes are created. Positive carriers (holes) are the majority carriers.
Effect of Temperature on Semiconductors
At absolute zero temperature, all electrons are tightly held by semiconductor atoms. Covalent bonds are very strong and there are no free electrons, so no current is possible. When temperature is raised, some covalent bonds break due to thermal energy. The breaking of bonds sets electrons free, and a tiny electric current can constitute if potential difference is applied.
P-N Junction Diode
Formation of Depletion Region
As soon as the junction is produced, free electrons near the junction in the n-type material move (by diffusion) across the junction into the p-type material where they fill holes. At the same time, holes diffuse from p-type to n-type, capturing electrons there.
The exchange soon stops because negative charges in the p-type material oppose the further flow of electrons, and the positive charges in the n-type oppose the further flow of holes. The region on either side of the junction becomes fairly free of majority charge carriers — this is called the Depletion Layer or Barrier Layer. A junction potential is created across this layer.
Forward Biasing
To apply forward bias, connect the positive terminal of the battery to the p-type and the negative terminal to the n-type. When the external voltage applied to the junction is in such a direction that it cancels the potential barrier, thus permitting current flow, it is called forward biasing.
Reverse Biasing
To apply reverse bias, connect the negative terminal of the battery to the p-type and the positive terminal to the n-type. When the external voltage applied to the junction is in such a direction that the potential barrier is increased, it is called reverse biasing. Current is blocked.
Types of Diodes and Their Applications
Zener Diode
Applications: voltage regulators, fixed reference voltage in a network, calibrating voltmeters, peak clippers in waveform shaping circuits, meter protection against damage from accidental application of excessive voltage.
Tunnel Diode
Applications: logic memory storage device, amplifier, microwave oscillator at a frequency of about 10 GHz, relaxation oscillator circuits, ultrahigh-speed switch (tunneling essentially takes place at the speed of light).
Light Emitting Diode (LED)
Applications: indicator lamps, seven-segment displays, numeric displays in handheld or pocket calculators.
Photodiode
Applications: fast counters (generate a current pulse every time a beam of light is interrupted), switching circuits, encoders, optical communication equipment, demodulation.
Varactor Diode
Applications: automatic frequency control device, FM modulator, adjustable band-pass filter.
Rectification
Half-Wave Rectification
When the sine wave goes positive, the diode is forward biased and conducts current to the load resistor R_L. The current develops a voltage across the load which has the same shape as the positive half-cycle. During the negative half-cycle, the diode is reverse biased and no current flows. The output contains only positive half-cycles.
Full-Wave Rectification (Centre-Tap)
Uses two diodes D₁ and D₂. During the positive half-cycle, D₁ conducts. During the negative half-cycle, D₂ conducts. The total output is continuous positive pulses — a full-wave rectified output.
Breakdown Mechanisms in Semiconductor Diodes
Avalanche Breakdown
Occurs when carriers accelerate and gain enough energy due to intense electric field in the depletion layer to collide with valence electrons and knock them loose. This causes an avalanche of carriers and the reverse current flow increases tremendously.
Zener Breakdown
Occurs when the p and n regions are heavily doped. The depletion layer of the p-n junction becomes very narrow and the electric field strength in the depletion layer increases sufficiently to break covalent bonds and generate hole-electron pairs. Consequently, the reverse current rises abruptly.
Bipolar Junction Transistor (BJT)
The bipolar junction transistor is constructed with three doped semiconductor regions separated by two PN junctions. The three regions are called emitter, base, and collector. Two configurations exist: PNP and NPN.
For the transistor to operate properly as an amplifier, the two junctions must be correctly biased with external voltages. There are three possible ways to connect a transistor within an electronic circuit arrangement.
Thermionic Valves
The Triode Valve
Three electrodes: cathode, anode, control grid. In a triode, the potential of the anode is always positive with respect to the filament, so that electrons tend to be attracted towards it from the space charge surrounding the cathode.
- Making the grid positive attracts more electrons from the space charge. Most pass through gaps between grid wires, but some are caught by the grid.
- Making the grid negative neutralizes, partially or wholly, the effect of the positive anode potential.
- The magnitude of anode current can be controlled by varying the p.d. between the grid and the cathode. A variation of 1 volt in grid potential produces a far greater change of anode current than the same variation in anode potential.
The Tetrode Valve
Four electrodes: cathode, anode, control grid, screen grid. The screen grid is situated between the control grid and the anode. Main function of screen grid: to provide an electrostatic shield between the anode and control grid, minimizing feedback effects. An additional function: to reduce the effect of the anode voltage on the space charge at the cathode. Consequently, the anode current remains nearly constant over a large variation of anode voltage.
The Pentode Valve
Five electrodes: cathode, anode, control grid, screen grid, suppressor grid. The suppressor grid is inserted between the anode and the screen grid. Functions of suppressor grid:
- Prevents secondary electrons released from the anode from reaching the screen grid. Eliminates the kink in the tetrode characteristic.
- Provides further electrostatic shielding of the anode from the control grid, increasing amplification factor.
- Reduces grid to anode capacitance, eliminating feedback action.
CONTROL OF MICRORGANISMS
Microorganisms are abundant in the environment, living in soil, in water, on the surfaces of plants and animals and inside many types of multicellular organisms, including humans. Fortunately, most microorganisms live freely in the environment without causing harm to humans or other organisms; in fact most of them are beneficial in a variety of ways. For these reasons, humans seek to control only certain types of microorganisms and under relatively few specific circumstances. We exert control over microorganisms associated with food materials, so that foods can be stored and made available for human consumption without being consumed by microorganisms first. We seek to control microorganisms that might cause damage to agricultural crops, forest trees and ornamental plants maintained for our purposes, and we seek to control potential pathogens that threaten our health or the health of animals we consider important for various reasons. Microbial control methods vary considerably depending on where and on what types of microorganisms they are being applied.
Microbial control means to inhibit or prevent growth of microorganisms. This control is affected in two basic ways: 1.by killing microorganisms or 2.by inhibiting growth of microorganisms. Control of microbial growth involves use of chemical and physical agents which either kill or prevent growth of microorganisms.
The effective control of microorganisms is required.
1. To prevent transmission of disease and infection,
2. To prevent spoilage of food,
3. To prevent interference of contaminating microorganisms in industrial processes and
4. To prevent contamination of materials used in pure culture work in laboratories.
Many terms are associated with the control of microorganisms.
6.1 Definition of terms
a) Sterilization: It is a process of destroying all forms of life by physical and chemical agents. Objects that are sterile are free from all living cells, spores and viruses.
b) Disinfection: Disinfectant kills vegetative cells of organisms capable of causing infection but not spores. Disinfection is done by chemical agents called disinfectants. Disinfectant is normal applied to inanimate objects such as floors, utensils and equipments etc.
c) Antiseptic: Any substances which prevent sepsis either by killing microorganisms or inhibiting their growth and activity is designated as antiseptic. The antiseptic can be applied to body tissues without causing injury to tissue.
d) Sanitizer: It is an agent that reduces the microbial population to safe level. Sanitizers are applied to inanimate objects such as equipments and utensils used in dairy and food industry.
e) Germicide: It is an agent that kills vegetative cells but not spores.
f) Bacteriocide: is identical term that kills bacterial cells but not spores. Likewise terms fungicide, viricide are used that kills fungi and viruses respectively.
g) Microbiostatic: It is a condition in which growth of microorganisms is prevented by using micro biostatic agent.
h) Bacteriostatic and fungistatic agents are those agents which stops the growth of bacteria or fungi respectively.
i) Antimicrobial agent: It is an agent that interferes with growth and activity of microbes. When its action is directed against bacteria, agent is designated as antibacterial and when its action is directed against fungi,
h) Preservative: It prevents growth of microorganisms.
6.2 Control methods
The control of microorganisms can be achieved by a variety of chemical and physical methods. Sterilisation is generally achieved by using physical means such as heat, radiation and filtration. Chemical methods, whilst effective at disinfection, are generally not reliable for achieving total sterility.
A variety of microbial control methods involve physical factors such as temperature, pressure and radiation. Variations exist within these categories, and in some cases, more than one factor can be applied simultaneously. Some specific examples are listed below.
Temperature
Moist heat & Dry heat are the two categories of heat which are commonly employed for the control of microorganisms.
Moist Heat
Moist heat sterilization using moist heat is called moist heat sterilization. Moist Heat kills organisms by denaturation or coagulation of cellular proteins. In following methods moist heat is used for sterilization:
1) Boiling: Objects (Glass-wares instruments) are exposed to boiling water (at temperature 1000C) for 10 minutes. Boiling kills vegetative forms of bacteria & many viruses within about 10 minutes. Endospores and some viruses are not destroyed so quickly (Within 10 minutes) e.g. Hepatitis virus can survive up to 30 minutes of boiling and some bacterial spores can survive for more than 20 hours. Boiling is therefore not a reliable sterilization procedure. This method is not recommended for the sterilization of instruments used for surgical procedures and should be regarded only as a mean of disinfection.
2) Fractional sterilization (Tyndallization): In tyndallization, objects, media which decompose at high temperature are exposed to free flowing steam at a temperature of 1000C for 20 minutes for three consecutive days with an incubation period of 24 hours at Room Temperature. John Tyndall has first proposed this method of sterilization. This method is also called Fractional sterilization. Arnold steamer is used for this type of sterilization. Arnold steamer consists of tinned copper cabinet. The lid is conical, enabling drainage of condensed steam and a perforated tray filled above the water level ensures that the material placed on it is surrounded by steam.
First exposure of media to steam, kills all vegetative bacteria and but not spores. After 1st exposure of media to steam, medium is incubated at room temperature for 24 hours. During incubation, spores will germinate which are not killed after 1st exposure. Again after 1st incubation period, medium is exposed to steam to kill vegetative cells derived from germination of spores. After second exposure, again medium is incubated to germinate remaining spores. This process is repeated one more time to sterilize the medium completely. This method fails to sterilize the media if: 1) The medium is unsuitable for the germination of spores. 2) Spores of anaerobic bacteria will not germinate if the material is in contact with air and spores of aerobic bacteria will not germinate, if the material is not freely exposed to air. 3) It is a time consuming method for sterilization.
3) Pasteurization
Pasteurization is developed by Louis Pasteur to prevent the spoilage of beverages, milk, juices, etc. In pasteurization, the product is subjected to controlled heat treatment where specific types of microorganisms are killed but does not kill all organisms. Temperature used for the pasteurization depends upon the product to be pasteurized and method of pasteurization. In the case of pasteurization of milk, it is heated to 71.60C for at least 15 seconds in the high temperature short time method or 62.90C for 30 minutes in the low temperature holding method. In ultra-pasteurization, also known as ultra high temperature (UHT) pasteurization, the milk is brought into contact with steam at 140°C for one or two seconds. Pasteurization reduces the number of microorganisms in a product or food. It kills pathogens that are transmitted in milk, i.e., Staphylococci, Streptococci, Mycobacterium tuberculosis and many spoilage organisms therefore increases the shelf life of milk especially at refrigeration temperatures (below 100C).
4) Autoclaving (Steam under pressure):
In this method of sterilization, moist heat (steam under pressure) having temperature above boiling water is used for sterilization. Saturated steam under pressure has more penetration power and higher temperature than boiling water. Autoclave is most commonly used instrument for autoclaving. Water boils at 1000C when placed in open vessel but in autoclave water does not boil even at 1000C because it is a closed vessel. In autoclave, sterilization by steam under pressure is carried out at temperature between 1080C and 1470C. By increasing steam pressure (or vapour pressure of steam), steam temperature can be increased. In autoclave, steam comes into contact with cooler surface and condenses into water on it, thus causes the release of latent heat from water to that surface of item and increase temperature of item. The condensed water provides moist condition for killing cells. Steam at a pressure of about 15 Psi (1210C) will kill all organisms and their endospores in about 15 minutes, when the organisms either contact the steam directly or are contained in small volume of aqueous medium. Sterilization of medium in large containers also requires extra time.
The Laboratory Autoclave
The laboratory autoclave consists of a vertical or horizontal cylinder of gun or stainless steel metal. The lid is fastened by screw clamps and made air tight by an asbestos washer. The autoclave has on its lid, a discharge tap for air and steam, pressure gauge and safely valve that can be set to blow off at any desired pressure. Heating is done by gas or electricity. For autoclaving of materials, at first sufficient water is put in the cylinder then the material to be sterilized is place on the tray and heating is started. The lid is screwed tight with the discharge tap open. The safety valve is adjusted to required pressure (but in most of the cases it is self-adjusted by manufacturer). The steam and air mixture is allowed to escape freely till all air has been replaced. This can be tested by observing accumulation of water droplets at the outlet of discharge tap and then the discharge tap is closed. The steam pressure rises inside and when it reaches the desired set level, the safely valve opens and the excess steam escapes. From this point, the heating period is calculated. When holding period is over the heater is turned off and autoclave is allowed to cool till the pressure gauge indicates that the inside pressure is at atmospheric pressure. The discharge tap is opened slowly and air is allowed to enter the autoclave. If the tap is opened when pressure inside has fallen below atmospheric pressure, an excessive amount of water will be evaporated and lost from the media. If air is not completely removed, the desired temperature will not be attained at specified pressure. To sterilize glassware’s, bandages, care must be taken to ensure that steam contacts all surfaces. Aluminum foil is impervious to steam and should not be used to wrap materials that are to be sterilized, paper should be used instead. There is no facility for drying the drying the load after sterilization before taking it out. The collection of water upon cooler surfaces during autoclaving causes metal rust. Corrosion inhibitor like sodium benzoate is applied to metallic items before autoclaving to prevent rusting.
Autoclaving is used to sterilize culture media, instruments, dressings, solutions, syringes and other items that can withstand high temp and pressure. It is also used to sterilize bacteriological media and destroy pathogenic cultures. The autoclave is equally valuable for sterilization of glassware and metal ware, and is most basic instrument of every microbiology laboratory. Today’s autoclaves are equipped with the devices to maintain proper pressure and record internal temperature during operations. Irrespective of these developments, it is necessary to keep watch on pressure and maintain it appropriately. Some plastic wares cannot be sterilized as they melt in the high heat, and sharp instruments often become blunt. Many substances breakdown during the sterilization process and oily substances cannot be sterilized in autoclave because they do not mix with water. Commercially available tapes are used as sterility indicators where color of the tape changes due to chemical reaction when the proper times and temperatures have been reached. Normally such sterilization indicators are kept near the center of autoclave surrounding materials to be sterilized to ensure proper penetration of heat. Another widely used method for sterility testing is preparations of specified species of bacterial endospores such as Bacillus stearothermophilus, impregnated into paper strips or present in an ampule of medium enclosed in a soft plastic vial. The vial is placed in the center of the material to be autoclaved. These spores are then aseptically inoculated into culture media after autoclaving and incubated. Sterilization is ensured by absence of growth in the culture media (indicates survival of the endospores).
Dry heat
Dry heat acts mostly by oxidizing or burning the cell constituents. Dry heat dehydrates cells, resulting in lack of water thus reduces the probability of protein coagulation. Penetration power of dry heat is low thus It is less effective as killing agent than moist heat. Different types of dry heat sterilization are
Incineration (Direct Flaming)
Incineration is the method where material to be sterilized is directly burnt in the flame. During the laboratory experiments, inoculating needles, forceps, etc are sterilized by incineration in which inoculating needle and forceps are directly introduced into a flame of burner till they become red hot. However, care should be taken to prevent spattering, because the droplets which fly off are likely to carry viable organisms. This problem can be reduced by inserting needle inside the tube. The method is 100% effective for sterilization. No known living organisms can withstand treatment given in incineration.
2) Hot air sterilization
The apparatus used for this type of sterilization is electric or gas hot air oven. The oven is usually heated by electricity with heating elements in the wall of chamber and it must be fitted with fan to ensure even distribution of air. It should not be overloaded. The material should be arranged in the manner which allows free circulation of air in between. Glass wares should be dry before being placed in oven. Test tubes, flasks etc should be plugged with cotton wool other glass wares such as petri- dishes and pipettes should be wrapped in Kraft paper. The oven must be allowed to cool slowly for about two hours before the door is opened since, the glass wares may get cracked by sudden or uneven cooling. Oven is operated at 1600C for one hour. In oven to sterilize items, longer period and higher temperature than autoclave because in autoclave heat in water is transferred to cool body and in oven the heat in air is transferred to cooler body. Heat in water is transferred to cool body more readily. It is used to sterilize glass wares, forceps, scissors, swabs, fats, greases etc.
Oven is used for sterilization of instruments used in ophthalmic surgery but a sterilization time of 2 hrs at 1500C is recommended. Rubber materials will not stand the temperature normally used for sterilization in oven.
Freezing (exposure to low temperatures) – Freezing is a bacteristatic physical control method applied frequently in a wide variety of settings. Freezing is used extensively to control microorganisms associated with food materials, drugs, research chemicals, etc. Freezing effectively inhibits the growth of most microorganisms by stopping metabolic processes, but is rarely cidal to bacteria because most of them are psychroduric. Bacteria culture collections are typically maintained in ultra low freezers (at temperatures of minus 72 to minus 80o C) and remain fully viable. It is important to remember when thawing large frozen food items (e.g., turkeys) that the external surfaces can reach temperatures suitable for microbial growth long before the center is thawed. Microorganisms and nutrients are typically abundant on skin surfaces and growth will occur if moderate temperatures are maintained for any length of time. Cold temperatures commonly maintained within refrigeration units slow metabolic processes and effectively prevent the growth of some types of microorganisms, but not all. Potential pathogens including Campylobacter and Listeria can grow on food materials maintained at temperatures commmon within most refrigerators
Sterilisation by irradiation
Certain types of irradiation are used to control the growth of microorganisms. These include both ionising and non-ionising radiation. The most widely used form of non-ionising radiation is ultraviolet (UV) light. Wavelengths around 260 nm are used because these are absorbed by the purine and pyrimidine components of nucleic acids, as well as certain aromatic amino acids in proteins. The absorbed energy causes a rupture of the chemical bonds, so that normal cellular function is impaired
UV lamps are commonly found in food preparation areas, operating theatres and specialist areas such as tissue culture facilities, where it is important to prevent contamination. Because they are also harmful to humans (particularly the skin and eyes), UV lamps can only be operated in such areas when people are not present. UV radiation has very poor penetrating powers; a thin layer of glass, paper or fabric is able to impede the passage of the rays. The chief application is therefore in the sterilisation of work surfaces and the surrounding air, although it is increasingly finding an application in the treatment of water supplies. Ionising radiations have a shorter wavelength and much higher energy, giving them greater penetrating powers. The effect of ionising radiations is due to the production of highly reactive free radicals, which disrupt the structure of macromolecules such as DNA and proteins. Surgical supplies such as syringes, catheters and rubber gloves are commonly sterilised employing gamma (γ ) rays from the isotope cobalt 60 (60Co). Gamma radiation has been approved for use in over 40 countries for the preservation of food, which it does not only by killing pathogens and spoilage organisms but also by inhibiting processes that lead to sprouting and ripening. The practice has aroused a lot of controversy, largely due to concerns about health and safety, although the first patent applications for its use date back nearly a hundred years! Although the irradiated product does not become radioactive, there is a general suspicion on the part of the public about anything to do with radiation, which has led to its use on food being only very gradually accepted by consumers. Gamma radiation is used in situations where heat sterilisation would be inappropriate, because of undesirable effects on the texture, taste or appearance of the product. This mainly relates to fresh produce such as meat, poultry, fruit and vegetables. Irradiation is not suitable for some foodstuffs, such as those with a high fat content, where unpleasant tastes and odours result. Ionising radiations have the great advantage over other methods of sterilisation that they can penetrate packaging.
Filtration:
Many liquids such as solutions of antibiotics or certain components of culture media become chemically altered at high temperatures, so the use of any of the heat regimes described above is not appropriate. Rather than killing the microorganisms, an alternative approach is simply to isolate them. This can be done for liquids and gases by passing them through filters of an appropriate pore size. Filters used to be made from materials such as asbestos and sintered glass, but have been largely replaced by membrane filters, commonly made of nitrocellulose or polycarbonate (Figure 13.3). These can be purchased ready-sterilised and the liquid passed through by means of pressure or suction. Supplies of air or other gases can also be filter-sterilised in this way. A pore size of 0.22µm is commonly used; this will remove bacteria plus, of course, anything bigger, such as yeasts; however, mycoplasma and viruses are able to pass through pores of this size. With a pore size 10 times smaller than this, only the smallest of viruses can pass through, so it is important that an appropriate pore size is chosen for any given task. A drawback with all filters, but especially those of a small pore size, is that they can become clogged easily. Filters in general are relatively expensive, and are not the preferred choice if alternative methods are available. High efficiency particulate air (HEPA) filters create clean atmospheres in areas such as operating theatres and laboratory laminar-flow hoods.
Figure2: Membrane filtration. Membrane filters are used to sterilise heat-labile substances. They are available in a variety of pore siz
Control of microrganisms by chemicals
Chemical agents that control microbial growth Chemical agents are used to reduce the growth of microorganisms of inanimate objects and on living tissue.
Phenol and Phenolic compounds
Lister first introduced phenol in aseptic surgery in 1867. Phenols are derivatives of benzene and have a hydroxyl group (-OH) attached to the benzene ring. Phenol kills microorganisms by denaturing proteins and destabilizing cell membranes. It is bacteriocidal, fungicidal, and virucidal at high concentrations, but is not effective against bacterial endospores, and is effective against many potential pathogens. It is used to disinfect garbage cans, surgical operating facilities, laboratory equipment, feces, urine, and sputum. Phenol is now no more used as a disinfectant because phenol is very expensive, fumes are lethal and derivatives of phenol are less expensive and more effective than phenol. An antimicrobial action of phenolic compounds is directed to inactivation of cellular enzymes. Phenolic compounds are antimicrobial because they increase membrane permeability, precipitate of cell proteins, and inactivate of enzymes and cause cell death. The most commonly used phenolic derivatives are cresols and bisphenols. Cresols are formed by adding methyl groups to phenol. Para-cresol is used for the preservation of wood products. Bisphenols are produced by combining two phenol molecules. Lysol is a combination of cresol and soap, which has about the same spectrum of activity as phenol, but is much less toxic to skin. Lysol is used for the disinfection of inanimate objects. Other cresols include resorcinol, hexylresorcinol, and hexachlorophene. Hexachlorophene soaps were once widely utilized as antiseptic soaps by health-care personnel for hand washing and the bathing of newborn infants, but have been now discarded, since it was found that this phenolic could be absorbed through the skin and potentially cause birth defects. The mixture of hexylresorcinol, glycerin and water is widely used as general antiseptics in mouth wash, gargles and cough drops. It is also used in the body care products such as soaps, oils and creams to control the skin microflora
b) Halogens Halogen elements:, iodine (I2), chlorine (CI2), bromine and fluorine in the Free State as well as their compounds are effective antimicrobial agents. Most commonly used halogens for the control of organisms are iodine and chlorine. Bromine and fluorine are strong irritants and very difficult to handle. a) Iodine: Iodine one of the oldest and most effective antiseptic. Iodine is effective against all kinds of bacteria, many endospores, various fungi and some viruses. It is usually applied to skin surface before surgical procedure & also used for wound treatment. Iodine kills bacteria as it combines with amino acid tyrosine of enzymes & inhibits their function. Iodine kills bacteria as it oxidizes– SH (sulfa hydryl) groups of certain amino acids those are important for maintaining structure of proteins. Following iodine preparations are available in market: Tincture: It is a solution of iodine in aqueous alcohol. Tincture, stains tissues and may causes local skin irritation and allergic reactions occasionally. It is topical antiseptic used prior to surgery, sometimes for burned and injured skin. Betadine: It is a combination of iodine and surface active agents. It release iodine slowly, non-stain forming and less irritating (Ex :) but it is effective like tincture as antimicrobiial agent. It is used to disinfect equipments and to prevent sepsis in burn wounds.
b) Chlorine: The several forms of chorine E.g. chlorine gas, sodium hypochlorite (NaOCl) and calcium Hypochlorite (Ca (OCl)2) are used for the purification drinking water. Chlorine gas is greenish greenish yellow in colour and very toxic. It is heavier than air and will therefore sink to the ground when released. It a very good disinfectant, but it is also toxic to humans. Chlorine gas is available as a compressed liquid, which is amber in color. Chlorine gas is the very cheaper form of chlorine. It causes respiratory irritation and it also irritates skin and mucus membranes. Exposure to high volumes of chlorine gas fumes can cause serious health problems leading to death. However, it is important that when chlorine gas enter the water, changes into hypochlorous acid and hypochlorite ions which are nontoxic forms to human. The typical dose of chlorine gas required for water treatment is 1-16 mg/L. Dose depends upon the quality of water to be treated however higher dose of chlorine is required. A compressed chlorine gas is used for disinfecting municipal drinking water, water in swimming polls and sewage. Calcium hypochlorite (CaOCl) is made up of the calcium salts of hypochlorous acid. It is produced by dissolving chlorine gas (Cl2) into a solution of calcium oxide (CaO) and sodium hydroxide (NaOH). Calcium hypochlorite is a white powder that comes either in tablet form as well as in a granular powder and is very stable. The chemical is very corrosive and requires proper handling. Calcium hypochlorite must also be kept away from moisture because the tablets/granular powder readily absorb moisture and will form (toxic) chlorine gas. Only 0.5-5 mg/L of calcium hypochlorite is required in the treatment of water. When calcium hypochlorite is added to water, hypochlorite and calcium ions are produced. Ca(OCl)2 --- Ca+2 + 2 OCl. Unlike chlorine gas which decreases pH, calcium hypochlorite increases the pH of the water (making the water less acidic). Calcium hypochlorite solution is used to disinfect equipments used in dairy and restaurant. Sodium hypochlorite (NaOCl) is made up of the sodium salts of hypochlorous acid that can be used as a disinfectant. It is produced when chlorine gas is dissolved into a sodium hydroxide solution. It is in liquid form, clear with a light yellow color, and has a strong chlorine smell. Sodium hypochlorite is extremely corrosive and must be stored in a cool, dark, and dry place. Sodium hypochlorite will naturally decompose; therefore it has less storage time i.e. not more than one month. It is very easier to handle as compare to other forms of chlorine. The amount of sodium hypochlorite required for water treatment is much less than the other two forms of chlorine, with 0.2-2 mg of NaOCl/L of water. NaOCl will also increase the pH of the water through the formation of hypochlorite ions. NaOCl = Na+ + OClHouse hold bleach contains 5. 25% sodium hypochlorite. This bleach is effective against AIDS viruses. Sodium hypochlorite (NaOCI) is house hold disinfectant. In houses for treatment of water for drinking, two drops of bleach are added to a liter of water (Four drops if water is cloudy) and the mixture is allowed to stand for 30 minutes. Thus, such treated water is considered safe for drinking under emergency conditions.
The chloramines are chlorine compounds used as disinfectants, sanitizers and antiseptics. The commonly used chloramine compounds are chloramine T and azochloramine. Chloramines are very stable and remain active in water for longer time slowly releasing chlorine giving prolonged action. Chloramine T Azochloramine Chloramine reacts with organic matter present in water. When large amounts of organic matter are present in the water, organic nitrogen reacts with chloramine forming organic chloramines. These compounds do not possess the disinfection property. Thus making it ineffective. Advantages of Chloramines as disinfectant are: it do not produce any off taste or smell and are relatively safe. The germicidal action of chlorine and its compounds is due to the formation of hypochlorous acid when free chlorine reacts with water. CI2 + H2O HCI + HOCI (Hypochlorous acid) NaOCl + H2O NaOH + HOCI (Hypochlorous acid) The hypochlorous acid formed is unstable molecule and further decomposed. HOCI HCI + [O] (Nascent oxygen) The nascent oxygen released in this reaction brings about microbial destruction by oxidation of cellular enzymes. Hypochlorous acid is most effective form of chlorine because it is neutral in electrical charge annd diffuses as rapidly as water through the cell wall.
3) Alcohols
Three aliphatic alcohols used as germicide includes methanol, ethanol & isopropanol. The germicidal action of alcohol is dependent on the molecular weight of the alcohol i.e. germicidal action increases with increase in molecular weight. Methanol is less germicidal than ethanol and ethanol is less germicidal than isopropyl alcohol and so on. But alcohols with molecular weight more than propyl alcohol are immiscible in water hence they are not used as disinfectant . The germicidal power of isopropanol is maximum because the rule is germicidal value increases with increase in molecular weight and is miscible in water. In practice solutions of 70 to 80 % alcohol in water is employed as germicide & percentage above 90% & below 50% is less effective.
High concentration of alcohol (above 80%) removes so much of water from cell so that the alcohol is unable to penetrate the cell. As the alcohol cannot penetrate in cell due to severe dehydration, high concentration of alcohol cannot kill the bacterial cells but can stop the multiplication. Thus high concentration of alcohol is microbiostatic. Whereas low concentration of alcohol partially dehydrates the cell wall and the penetration of alcohol in cell becomes easier. As a result cellular proteins precipitate and kill the bacterial cells. Spores are not destroyed by alcohol because water content of spores is less. Aliphatic alcohols are effective antimicrobial agents they are used for disinfection and also used as antiseptic. Alcohols are protein denaturant and solvents for lipids. Protein denaturation in cell is because alcohol is dehydrating agent and it remove water from cell. Removal of water from cell causes, protein denaturation & enzyme inactivation in cell. Due to denaturation of proteins of bacterial cell membrane and inactivation of enzymes, cells are killed. Lipids of membrane dissolve in alcohol which alters permeability of membranes and kills bacterial cells. Alcohols are unsatisfactory antiseptics because when applied to wounds they cause a coagulation of a layer of protein under which bacteria continues grow. Alcohol is used to reduce microbial flora of skin (to degerm skin) before hypodermic injections and, for disinfection of clinical thermometer.
4) Detergents (Surface active agents) Compounds which are primarily used for cleaning surface are called surface active agents (surfactants) .Surfactants reduce surface tension of water, For ex: common soaps & detergents (Synthetic detergents). Now – a- days synthetic detergents were developed in order to replace soap for cleaning . Soap has inability to form lather in hard or acidic water.
Soaps are prepared by boiling vegetable oil and fat with NaOH or KOH. The process of making soap is called saponification. Detergent or soap molecule has hydrophilic tail and hydrophobic head . During washing , tail go into grease and head go into water . When water is shaken, all tail molecules will go into grease and head dissolve in water. When water is shaken, all detergent molecules will remove the grease (dirt) away. Detergents are widely used in laundry, dish washing powder, shampoos, and many other preparations which are used for washing purpose. Now synthetic detergents consisting of cationic and anionic compounds have replaced soaps for many cleansing jobs. Soaps are lethal to spirochetes e.g. Treponema palladium. Detergents have strong surface tension reducing action; therefore they are microbicidal and microbiostatic. They are classified by their ionic (electrical charge) properties in water: anionic (negative charge), cationic (positive charge) and nonionic (no charge) detergent. a. Anionic detergent – They ionize and their detergent property resident in anion. e.g. Formula: [RSO3] - Na + (Sodium lauryl sulphate)
b. Cationic detergent
They ionize and their detergent property resident in cation. Most of cationic detergents are quaternary ammonium compounds. A group of cationic detergents which are Quaternary ammonium compounds is called quaternaries or quats. Zephiran, Cepacol are trade names of preparations of Quaternary ammonium compounds found in laboratory spray bottles. Quaternaries are more germicidal than anionic and non-ionic detergent. They are highly bactericidal against gram +ve bacteria and only less effective against gram –ve bacteria. These compounds are also active against fungi and protozoa but inactive against bacterial spores and viruses. Quaternaries have little toxicity for skin; they are extensively used as skin antiseptics and sanitizing agents in food industry. They are used for sterilization of surgical instruments since they are harmless to tissues. Quaternaries have some disadvantages i.e. they form foam, organic matter interferes with their effectiveness and they are neutralized by soaps and anionic detergents Quaternaries react with lipid of microbial cell membrane altering the permeability of cell membrane and causing leakage of essential cellular compounds. In addition denaturation of proteins and inactivation of enzymes by quaternaries plays role in its antimicrobial activity. They are used in the preparations of agents applied on skin for disinfection. They are also added as preservative in the ophthalmic and cosmetic preparations. They are used for the disinfection of floor, walls and other surfaces in hospitals and public utility places. They are also used in dairy, food and allied industries for effective sanitization. c. Non- ionic detergent – Those which do not ionize and does not possess significant antimicrobial property.
5) Heavy Metals: Mercury, silver and copper is the most commonly used heavy metals. The ability of very small amounts of heavy metals to exert antimicrobial activity is called oligodyanmic action (oligo means few). This action can be demonstration in laboratory by placing a clean piece of metal or a coin containing copper, silver or copper on a plate inoculate with microorganisms. After incubation, a zone of inhibition (no growth) surround the metal is seen. In a zone of inhibition heavy metal ions diffused from coin combine with –SH groups of enzymes of microbial cells and denature enzymes this kills the growth of microorganism. Most heavy metals either alone or in chemical compound are germicidal because they denature enzyme and other essential proteins of cell. Similarly, silver inactivates enzymes by binding with sulfhydryl groups , disrupts cell membranes, and inhibits disables proteins causing cell damage and death. Similarly, copper ion distorts the cell wall by bonding to negatively charged groups. Similarly mercury binds with sulfhydryl group of enzyme thus inactivating enzyme. Both gram positive and negative bacteria are affected by the oligodyanmic action of heavy metals. SilverSilver in a 1% concentration silver nitrite can be used to prevent possible gonococcal and certain bacterial infection of newborns. The chemical is placed in the eyes of infant immediately after birth, because if pathogens are present birth canal, resulting infection can cause blindness of newborn (Ophthalmia neonatorum). Since silver nitrate has been found not to be effective against number of potential bacterial pathogen, it is now replaced by antibiotic erythromycin. MercuryMercuric chloride an inorganic mercury compound has broad spectrum activity. It is used as antifungal in paints. CopperCopper sulphate is used to destroy algae that grow in water reservoirs. Copper compound (ß-hydroxyquinoline) is used as antifungal in paints.
6) Gaseous Chemosterilizers
Material that is adversely affected by heat and liquid are sterilized by gases. Sterilization by gases is called fumigation. Commonly used gases were SO2, Chlorine and formaldehyde which were widely employed for disinfection of rooms occupied by sick people. SO2 and chlorine are poisonous and damage the materials; they are now replaced by formaldehyde, ethylene oxide and ß-propiolactone. Formaldehyde (HCHO): This gas is generated by heating a concentrated solution of formaldehyde. Formaldehyde in aqueous solution is formalin. Vaporization of formaldehyde from formalin is used to sterilize an enclosed area. The fumes of formaldehyde are harmful and cause irritation of tissues and eyes. Since it penetrates only slightly it acts as surface disinfectant. It kills both vegetative cells and spores. It is a strong reducing agent and inactivates enzymes and cell constituents. It is used for the sterilization of certain instruments. Important use of formaldehyde is in the disinfection or sterilization of enclosed area such as operation theatre, working area in pharma and food industry. Ethylene oxide It is a liquid at a temperature below 10.80C, its boiling point. Above this temperature it vaporizes rapidly. In pure state, it is very toxic if inhaled and cause blisters, if its vapours remain in contact with skin. It is highly flammable even at low concentration. This problem is overcome by mixing it with CO2 or Freon; commercially a mixture of 10% ethylene oxide and 90% CO2 is sold as carboxide. Ethylene oxide acts by alkylation with many organic compounds including enzymes and many other proteins by replacing active H- atom of organic compound by an alkyl group. Alkylation of enzymes leads to inactivation of enzymes. + Enz-SH Enz-SH-CH2 CH2OH Active Inactive Ethylene oxide is very effective against microorganisms and their spores. The important property of Ethylene oxide is its penetration power; it can sterilize the material even after packaging without causing any damage to the material. Ethylene oxide is preferred over formaldehyde because of following reasons, 1. Although it is an expensive but readily available 2. It exhibit deep penetration. 3. It does not polymerise or condense on surfaces. 4. It is quickly removed by simple airing of treated materials. It has slow action upon microorganisms thus treatment is time consuming and is expensive. Ethylene Oxide (EtO) sterilization is mainly used to sterilize medical and pharmaceutical products that cannot support conventional high temperature steam sterilization - such as devices that incorporate electronic components, plastic packaging or plastic containers, disposable medical devices. Spices, herbs, condiments and some biological preparations can be sterilized by EtO within the purview local federal law. ß--PropiolactoneIt is colorless, pungent liquid at ambient temperature. Its boiling point is 167.30C and it is atomized into air. It is not flammable but causes blisters on the skin and irritation of eyes. It is an alkylating agent and acts through alkylation of carboxyl- and hydroxyl- groups causing inactivation of enzymes as like ethylene oxide. It kills microorganisms including spores. It is not explosive, non-corrosive and does not condense on surfaces. It has low penetration power and is a carcinogen. It has broad-spectrum activity as well as effective sporicidal agent. 0.2% is used to sterilize biological products. It is more effective in fumigation than formaldehyde. It is used to sterilize surgical instruments, vaccines and enzymes. 7) Chlorhexidine: Chlorhexidine is a cationic polybiguanide (bisbiguanide).
Chlorhexidine belongs to a group of medicines called antiseptic antibacterial agents. It is broad-spectrum antimicrobial drug (effective bactericidal agent against all categories of microbes, including bacteria, yeast, and viruses). It is an important antimicrobial in oral hygiene. Chlorhexidine molecules are positively charged (cations) and most bacteria and surface structures in the oral cavity including the surfaces of teeth and mucous membranes are negatively charged (anions). Thus chlorhexidine binds strongly to all these surface structures. When chlorhexidine binds to microbial cell walls it induces changes, damaging the surface structure, leading to an osmotic imbalance with consequent precipitation of cytoplasm causing cell death. It destroys all categories of microbes, not just bacteria, and there is little risk for the development of opportunistic infections. It is used to clean the skin after an injury, before surgery, or before an injection. Chlorhexidine is also used to clean the hands before any medical procedure. It works by killing or preventing the growth of bacteria on the skin. It is used as preservative in eye drops, active substance in wound dressings and antiseptic mouthwashes. It is also added as additive to creams, toothpaste, deodorants, and antiperspirants.
8) Aldehydes
Formaldehyde and glutaraldehydes are commonly used aldehydes for disinfection. Glutaraldehydes (CH2 (CH2CHO)2):It is used to disinfect medical and dental equipment. It is also used for industrial water treatment and as a preservative. It inhibit bacterial growth by combining with nucleic acids and proteins . It is used to disinfect hospital and laboratory equipments. Disinfection is achieved within 10 minutes but about 12 hours are required to kill spores.
Introduction to Control of Microorganisms
Microorganisms are abundant in the environment, living in soil, in water, on the surfaces of plants and animals, and inside many types of multicellular organisms including humans. Fortunately, most microorganisms live freely in the environment without causing harm — in fact most are beneficial in various ways.
Microbial control means to inhibit or prevent the growth of microorganisms. This is affected in two basic ways: (1) by killing microorganisms, or (2) by inhibiting their growth. Control involves use of chemical and physical agents which either kill or prevent growth.
Reasons Why Effective Control is Required
- To prevent transmission of disease and infection.
- To prevent spoilage of food.
- To prevent interference of contaminating microorganisms in industrial processes.
- To prevent contamination of materials used in pure culture work in laboratories.
Definition of Terms
- Sterilization: A process of destroying all forms of life by physical and chemical agents. Objects that are sterile are free from all living cells, spores and viruses.
- Disinfection: Kills vegetative cells of organisms capable of causing infection but not spores. Done by chemical agents called disinfectants. Applied to inanimate objects such as floors, utensils and equipment.
- Antiseptic: Any substance which prevents sepsis either by killing microorganisms or inhibiting their growth and activity. Can be applied to body tissues without causing injury to tissue.
- Sanitizer: An agent that reduces the microbial population to a safe level. Applied to inanimate objects such as equipment and utensils used in dairy and food industry.
- Germicide: An agent that kills vegetative cells but not spores.
- Bacteriocide: Kills bacterial cells but not spores. Similarly, fungicide kills fungi and viricide kills viruses.
- Microbiostatic: A condition in which growth of microorganisms is prevented using a microbiostatic agent.
- Bacteriostatic and Fungistatic Agents: Stop the growth of bacteria or fungi respectively.
- Antimicrobial Agent: An agent that interferes with growth and activity of microbes. Directed against bacteria = antibacterial; directed against fungi = antifungal.
- Preservative: Prevents growth of microorganisms.
Physical Methods of Control
Moist Heat Methods
Moist heat kills organisms by denaturation or coagulation of cellular proteins.
- Boiling: Objects are exposed to boiling water (100°C) for 10 minutes. Kills vegetative forms of bacteria and many viruses. NOT reliable for complete sterilization — endospores and some viruses (e.g. hepatitis virus survives up to 30 minutes, some bacterial spores more than 20 hours) are not destroyed. Should be regarded only as disinfection.
- Fractional Sterilization (Tyndallization): Objects or media are exposed to free-flowing steam at 100°C for 20 minutes for three consecutive days with a 24-hour incubation period at room temperature between exposures. Invented by John Tyndall. Uses an Arnold steamer. Fails if: medium is unsuitable for spore germination; anaerobic bacterial spores will not germinate if material is in contact with air.
- Pasteurization: Developed by Louis Pasteur. Product subjected to controlled heat treatment. For milk: High Temperature Short Time (HTST) = 71.6°C for at least 15 seconds. Low Temperature Holding (LTH) = 62.9°C for 30 minutes. Ultra-pasteurization (UHT) = 140°C for one or two seconds. Kills pathogens transmitted in milk (Staphylococci, Streptococci, Mycobacterium tuberculosis) and increases shelf life.
- Autoclaving (Steam Under Pressure): Uses saturated steam under pressure with temperature above boiling water. Most commonly used instrument is the autoclave. Sterilization carried out at temperatures between 108°C and 147°C. Steam at about 15 psi (121°C) kills all organisms and their endospores in about 15 minutes. Cannot be used for: plastic wares (they melt), sharp instruments (they become blunt), substances that breakdown during the process, oily substances (they don't mix with water).
Dry Heat Methods
Dry heat acts mostly by oxidizing or burning the cell constituents. It dehydrates cells. Penetration power of dry heat is low, so it is less effective than moist heat.
- Incineration (Direct Flaming): Material is directly burnt in the flame. During laboratory experiments, inoculating needles, forceps, etc. are sterilized by incineration until they become red hot. This method is 100% effective — no known living organisms can withstand it.
- Hot Air Sterilization: Uses an electric or gas hot air oven fitted with a fan to ensure even distribution of air. Operated at 160°C for one hour. Used to sterilize glassware, forceps, scissors, swabs, fats, greases etc. Glass wares should be dry before being placed in oven. The oven must be allowed to cool slowly for about two hours before the door is opened to prevent cracking of glassware.
Freezing (Low Temperatures)
Freezing is a bacteriostatic physical control method. Effectively inhibits growth of most microorganisms by stopping metabolic processes. Rarely cidal to bacteria because most are psychroduric. Bacteria culture collections are maintained in ultra-low freezers (minus 72 to minus 80°C) and remain fully viable.
Sterilization by Irradiation
UV Light (Non-Ionising Radiation)
Wavelengths around 260 nm are used because these are absorbed by the purine and pyrimidine components of nucleic acids, as well as certain aromatic amino acids in proteins. The absorbed energy causes rupture of chemical bonds so that normal cellular function is impaired. UV lamps are found in food preparation areas, operating theatres and tissue culture facilities. UV radiation has very poor penetrating powers — a thin layer of glass, paper or fabric can impede the rays. Chief application: sterilization of work surfaces and surrounding air.
Ionising Radiation
Have shorter wavelengths and much higher energy, giving greater penetrating powers. The effect is due to the production of highly reactive free radicals, which disrupt the structure of macromolecules such as DNA and proteins. Surgical supplies such as syringes, catheters and rubber gloves are commonly sterilised using gamma rays from cobalt-60. Gamma radiation has been approved in over 40 countries for food preservation. Has the advantage of being able to penetrate packaging.
Filtration
Many liquids such as solutions of antibiotics or certain components of culture media become chemically altered at high temperatures. Rather than killing microorganisms, an alternative approach is to isolate them by passing them through filters of appropriate pore size. Membrane filters are commonly made of nitrocellulose or polycarbonate.
- Pore size 0.22 μm removes bacteria and anything bigger (yeasts), but mycoplasma and viruses can pass through.
- Pore size 10 times smaller — only the smallest viruses can pass through.
- HEPA (High Efficiency Particulate Air) filters create clean atmospheres in operating theatres and laboratory laminar-flow hoods.
Chemical Methods of Control
Phenol and Phenolic Compounds
Lister first introduced phenol in aseptic surgery in 1867. Phenols are derivatives of benzene with a hydroxyl group (-OH) attached to the benzene ring. Phenol kills microorganisms by denaturing proteins and destabilizing cell membranes. It is bactericidal, fungicidal, and virucidal at high concentrations, but not effective against bacterial endospores. Now no longer used as disinfectant because it is very expensive and its fumes are lethal. Derivatives of phenol are less expensive and more effective.
Commonly used phenolic derivatives: cresols and bisphenols. Lysol is a combination of cresol and soap — used for disinfection of inanimate objects. Hexachlorophene soaps were once widely used as antiseptic soaps but were discarded because they can be absorbed through the skin and potentially cause birth defects.
Halogens
- Iodine: One of the oldest and most effective antiseptics. Effective against all kinds of bacteria, many endospores, various fungi and some viruses. Usually applied to skin surface before surgical procedure. Kills bacteria by combining with amino acid tyrosine of enzymes and inhibiting their function. Available as: Tincture (solution of iodine in aqueous alcohol) and Betadine (combination of iodine and surface active agents — releases iodine slowly, non-stain forming, less irritating).
- Chlorine: Forms include chlorine gas, sodium hypochlorite (NaOCl) and calcium hypochlorite (Ca(OCl)₂). Used for purification of drinking water. Germicidal action is due to the formation of hypochlorous acid when free chlorine reacts with water: Cl₂ + H₂O → HCl + HOCl. Hypochlorous acid decomposes to release nascent oxygen: HOCl → HCl + [O]. Nascent oxygen brings about microbial destruction by oxidation of cellular enzymes.
Alcohols
Three aliphatic alcohols used as germicides: methanol, ethanol and isopropanol. Germicidal action increases with increase in molecular weight. The germicidal power of isopropanol is maximum among the miscible alcohols. In practice, solutions of 70 to 80% alcohol in water are employed as germicide. High concentration of alcohol (above 80%) is microbiostatic — it removes so much water that alcohol cannot penetrate the cell. Low concentration of alcohol partially dehydrates the cell wall, making penetration easier, causing protein precipitation and killing the cells. Alcohols are protein denaturants and solvents for lipids.
Detergents (Surface Active Agents)
Surfactants reduce surface tension of water. Classified by ionic properties in water:
- Anionic detergents: Ionize and their detergent property resides in anion (e.g. sodium lauryl sulphate).
- Cationic detergents (Quaternary Ammonium Compounds / Quats): More germicidal. Highly bactericidal against gram-positive bacteria, only less effective against gram-negative bacteria. Active against fungi and protozoa but inactive against bacterial spores and viruses. Used as skin antiseptics and sanitizing agents in food industry. Mechanism: react with lipid of microbial cell membrane, altering permeability and causing leakage of essential cellular compounds.
- Non-ionic detergents: Do not ionize and do not possess significant antimicrobial property.
Heavy Metals (Oligodynamic Action)
The ability of very small amounts of heavy metals to exert antimicrobial activity is called oligodynamic action. Heavy metal ions combine with -SH groups of enzymes of microbial cells and denature enzymes, killing the growth of microorganisms.
- Silver: 1% silver nitrate prevents gonococcal and certain bacterial infections of newborns. Now replaced by antibiotic erythromycin.
- Mercury: Mercuric chloride has broad-spectrum activity. Used as antifungal in paints.
- Copper: Copper sulphate destroys algae in water reservoirs. Copper compound (β-hydroxyquinoline) used as antifungal in paints.
Gaseous Chemosterilizers
- Formaldehyde (HCHO): Generated by heating a concentrated solution. Fumes are harmful — irritation of tissues and eyes. Kills both vegetative cells and spores. Strong reducing agent. Used for sterilization of enclosed areas such as operation theatres.
- Ethylene Oxide: Very effective against microorganisms and their spores. Important property: deep penetration power — can sterilize material even after packaging without damage. Commercially sold as carboxide (10% ethylene oxide, 90% CO₂). Preferred over formaldehyde for: deep penetration, does not polymerize, quickly removed by simple airing. Used to sterilize medical devices with electronic components, plastic packaging, disposable medical devices.
- β-Propiolactone: Colorless, pungent liquid. Alkylating agent. Kills microorganisms including spores. Not explosive, non-corrosive. Has low penetration power and is a carcinogen. Used to sterilize surgical instruments, vaccines and enzymes.
Chlorhexidine
A cationic polybiguanide. Broad-spectrum antimicrobial drug effective against bacteria, yeast and viruses. Important in oral hygiene. Chlorhexidine molecules are positively charged and most bacteria and oral surfaces are negatively charged — so it binds strongly to all surface structures. When it binds to microbial cell walls, it induces changes damaging the surface structure, leading to osmotic imbalance with consequent precipitation of cytoplasm causing cell death.
Aldehydes
Glutaraldehyde (CH₂(CH₂CHO)₂): Used to disinfect medical and dental equipment. Also used for industrial water treatment and as a preservative. Inhibits bacterial growth by combining with nucleic acids and proteins. Disinfection is achieved within 10 minutes but about 12 hours are required to kill spores.
INTRODUCTION TO MICROSOFT EXCEL
Microsoft Excel is a specific type of spreadsheet software developed by Microsoft. It is the industry standard for spreadsheets and is part of the Microsoft 365 (formerly Office) suite of productivity tools. While many spreadsheet programs exist (like Google Sheets or LibreOffice Calc), Excel is distinguished by its depth of features and widespread adoption in the business world.
A spreadsheet software is a computer application software that allows its user to organize, analyze, store and calculate data in a tabular format. It is used to develop personalized reports involving the use of extensive mathematical, financial, statistical and logical processing. It functions as a digital version of a paper accounting worksheet. The core structure of the interface consists of a grid made up of rows, columns and cells.
Uses of Spreadsheet
1. Create budgets,
2. Tabulate expenses,
3. Analyze survey results, and
4. Perform just about any type of financial analysis you can think of.
5. Create a variety of highly customizable charts.
6. Compiling mailing lists by using the row-and-column layout to store lists efficiently.
7. Accessing other data Import data from a variety of sources.
8. Creating graphical dashboards Summarize a large amount of business information in a concise format.
9. Creating graphics and diagrams
10. Use shapes and SmartArt to create professional-looking diagrams.
11. Automating complex tasks: Perform a tedious task with a single mouse click with Excel’s macro capabilities.
Microsoft Excel Interface/Ribbon
Excel interface revolves around the ribbon. The excel ribbon comprises of tabs, which contain groups of controls. The commands available in the Ribbon vary, depending upon which tab is selected. The Ribbon is arranged into groups of related commands. Here’s a quick overview of Excel’s tabs:
Home You’ll probably spend most of your time with the Home tab selected. This tab contains the basic Clipboard commands, formatting commands, style commands, commands to insert and delete rows or columns, plus an assortment of worksheet editing commands.
Insert Select this tab when you need to insert something into a worksheet—a table, a diagram, a chart, a symbol, and so on.
Page Layout This tab contains commands that affect the overall appearance of your worksheet, including some settings that deal with printing.
Formulas Use this tab to insert a formula, name a cell or a range, access the formula auditing tools, or control the way Excel performs calculations.
Data Excel’s data-related commands are on this tab, including data validation commands.
Review This tab contains tools to check to spell, translate words, add comments, or protect sheets.
View The View tab contains commands that control various aspects of how a sheet is viewed. Some commands on this tab are also available in the status bar.
Developer This tab isn’t visible by default. It contains commands that are useful for programmers. To display the Developer tab, choose File ➪ Options and then select Customize Ribbon. In the Customize the Ribbon section on the right, make sure that Main Tabs is selected in the drop-down control and place a checkmark next to Developer.
Help This tab provides ways to get help, make suggestions, and access other aspects of Microsoft’s community.
Add-Ins This tab is visible only if you loaded an older workbook or add-in that customizes the menu or toolbars. Because menus and toolbars are no longer available in Excel 2019, these user interface customizations appear on the Add-Ins tab. The preceding list contains the standard Ribbon tabs. Excel may display additional Ribbon tabs based on what’s selected or resulting from add-ins that are installed.
Structure of an Excel Workbook
A workbook is an excel file with atleast one worksheet, worksheet is inside a workbook and it is used in Excel documents which is a collection of cells organized in rows and columns. The worksheet is the working surface you interact with to enter data. It is one spreadsheet in a workbook. You perform the work you do in Excel in a workbook. The worksheet is divided into rows and columns
Rows: Horizontal lines identified by numbers (1, 2, 3...).
Columns: Vertical lines identified by letters (A, B, C...).
Cells: The intersection of a row and a column (e.g., A1, B2) where data is entered. All positions on the worksheet are identified as cells where we have cell A1, A2, A3 etc and each one is referred to as a Cell Address.
A cell holds a single unit of information and an entry to a worksheet is value, label or formula.
Active Cell: Is the selected cell where data is entered when typing commences
A value is an actual numeric data content of a cell.
A label is a string of characters entered into a cell to serve as a heading
A formula is an expression consisting of cell addresses, numeric values and arithmetic operators
Chart: Any object that presents data in a visualor graphic manner
Range: Selected set of multiple cells.
Sort: Rearrangement of rows or columns according to certain criteria
Value: Any data in a one cell. It can also refer to the result of any formula
Zoom: Reduction or enlargement of screen of entire worksheet.
It is important to emphasise that in Excel each workbook contains one or more worksheets, and each worksheet consists of individual cells. Each cell can contain a number, a formula, or text. A worksheet also has an invisible drawing layer, which holds charts, images, and diagrams. Objects on the drawing layer sit over the top of the cells, but they are not in the cells like a number or formula. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window.
Other examples of spreadsheet packages are Lotus 1-2-3, Quattro, Multiplan, Framework, VisiCalc.
& How to open a new Workbook
Click the start icon on the left down of your pc. and if you cannot find the start icon then click all programs to see all programs. The Excel Starter startup screen appears, and a blank spreadsheet is displayed. In Excel Starter, a spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook. Workbooks can have one or more worksheets in them. Click on blank workbook.
& How to save your workbook
1. Click the Save button on the Quick Access toolbar. (This button looks like an old-fashioned floppy disk, popular in the previous century.) Because the workbook hasn’t been saved yet and still has its default name, Excel responds with a Backstage screen that lets you choose the location for the workbook file. The Backstage screen lets you save the file to an online location or your local computer.
2. Click Browse. Excel displays the Save As dialog box.
3. In the File Name field, enter a name (such as Monthly Sales Projection). If you like, you can specify a different location.
4. Click Save or press Enter. Excel saves the workbook as a file. The workbook remains open so that you can work with it some more. (Foulkes, L.(2020)
Under the Save dialogue box, you can Save or Save As
Click the file and then the Save As, under the Save As, select the place you want to save your document to. In the file name box, write the name you want to save the document with and then save. When you Save, Excel assumes that the destination where the work will be saved is already predetermined.
WORKING WITH SUM() FUNCTION
The sum function adds values. you can add individual values, cell references or ranges, or a mix of all three. to do this, select a cell next to the numbers you want to sum, click auto sum on the home tab, press enter, and you're done. Remember to alight the whole figures you want to sum before clicking the sum button at the right corner of the ribbon.
WORKING WITH MIN() & MAX() FUNCTION
Excel MIN or MAX function returns the smallest or largest numeric value in a range of values respectively.MIN will return the minimum value in a given list of arguments while MAX will return the highest value in a given list of argument from a given set of numeric values, it will return the smallest or highest value respectively. To do this, select a cell below or to the right of the numbers for which you want to find the smallest or highest number. On the Home tab, in the Editing group, click the arrow next to AutoSum., click Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.
WORK WITH AVERAGE()AND COUNT() FUNCTION
The same process as discussed earlier, after highlighting the fields you want to work on, click the arrow next to AutoSum > Average, and then press Enter.
Count function returns the count of numeric values (includes numbers and dates); To do this, the COUNT function will get the number of entries in a number field that is in a range or array of numbers.
Use the =count function to do this operation and highlight the fields you want to perform this function on and click ENTER. Count gives you the number of cells you are working on.
Introduction to Microsoft Excel
Microsoft Excel is a specific type of spreadsheet software developed by Microsoft. It is the industry standard for spreadsheets and is part of the Microsoft 365 (formerly Office) suite of productivity tools. Excel is distinguished by its depth of features and widespread adoption in the business world.
A spreadsheet software is a computer application software that allows its user to organize, analyze, store and calculate data in a tabular format. It is used to develop personalized reports involving extensive mathematical, financial, statistical and logical processing. It functions as a digital version of a paper accounting worksheet.
Other examples of spreadsheet packages: Lotus 1-2-3, Quattro, Multiplan, Framework, VisiCalc.
Uses of Spreadsheet
- Create budgets and tabulate expenses.
- Analyze survey results and perform financial analysis.
- Create a variety of highly customizable charts.
- Compile mailing lists using row-and-column layout.
- Import data from a variety of sources.
- Create graphical dashboards to summarize business information.
- Use shapes and SmartArt to create professional-looking diagrams.
- Automate complex tasks using Excel's macro capabilities.
Microsoft Excel Interface / Ribbon
Excel interface revolves around the ribbon. The ribbon comprises of tabs, which contain groups of controls. Here is a quick overview of Excel's main tabs:
- Home: Basic Clipboard commands, formatting commands, style commands, commands to insert and delete rows or columns, plus worksheet editing commands. Most frequently used tab.
- Insert: Insert something into a worksheet — a table, diagram, chart, symbol, etc.
- Page Layout: Commands that affect the overall appearance of your worksheet, including printing settings.
- Formulas: Insert a formula, name a cell or range, access formula auditing tools, or control how Excel performs calculations.
- Data: Excel's data-related commands, including data validation commands.
- Review: Tools to check spelling, translate words, add comments, or protect sheets.
- View: Commands that control various aspects of how a sheet is viewed.
- Developer: Not visible by default. Contains commands useful for programmers.
- Help: Ways to get help, make suggestions, and access Microsoft's community.
Structure of an Excel Workbook
- Workbook: An Excel file with at least one worksheet. You perform all work in Excel inside a workbook.
- Worksheet: One spreadsheet inside a workbook. The working surface you interact with to enter data. Divided into rows and columns.
- Rows: Horizontal lines identified by numbers (1, 2, 3...).
- Columns: Vertical lines identified by letters (A, B, C...).
- Cells: The intersection of a row and a column (e.g., A1, B2) where data is entered. All positions are identified as cells, each referred to as a Cell Address.
- Active Cell: The selected cell where data is entered when typing commences.
- Value: An actual numeric data content of a cell.
- Label: A string of characters entered into a cell to serve as a heading.
- Formula: An expression consisting of cell addresses, numeric values and arithmetic operators.
- Range: Selected set of multiple cells.
- Chart: Any object that presents data in a visual or graphic manner.
How to Open a New Workbook
- Click the Start icon on the bottom left of your PC.
- If you cannot find the Start icon, click All Programs to see all programs.
- The Excel Starter startup screen appears, and a blank spreadsheet is displayed.
- Click on Blank Workbook.
How to Save Your Workbook
- Click the Save button on the Quick Access toolbar (looks like an old-fashioned floppy disk).
- Excel responds with a Backstage screen that lets you choose the location for the workbook file.
- Click Browse. Excel displays the Save As dialog box.
- In the File Name field, enter a name (such as Monthly Sales Projection).
- Click Save or press Enter. Excel saves the workbook as a file.
Under the Save dialogue box, you can choose Save or Save As. When you click Save, Excel assumes the destination is already predetermined.
Key Excel Functions
SUM() Function
Adds values. You can add individual values, cell references or ranges, or a mix of all three. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter.
MIN() and MAX() Functions
MIN returns the smallest numeric value in a range. MAX returns the highest value. On the Home tab, in the Editing group, click the arrow next to AutoSum, then click Min or Max, and press Enter.
AVERAGE() Function
Calculates the average (arithmetic mean) of selected values. Click the arrow next to AutoSum, select Average, and press Enter.
COUNT() Function
Returns the count of numeric values (includes numbers and dates) in a range. Gives you the number of cells you are working on that contain numbers.
Sample Exercise Table
| S/N | Names | COM 111 | COM 121 | COM 125 | TOTAL | AVG | MIN | MAX |
|---|---|---|---|---|---|---|---|---|
| 1 | Modupe | 68 | 81 | 70 | =SUM(C2:E2) | =AVERAGE(C2:E2) | =MIN(C2:E2) | =MAX(C2:E2) |
| 2 | Tolani | 62 | 85 | 69 | =SUM(C3:E3) | =AVERAGE(C3:E3) | =MIN(C3:E3) | =MAX(C3:E3) |
| 3 | Aina | 83 | 79 | 63 | =SUM(C4:E4) | =AVERAGE(C4:E4) | =MIN(C4:E4) | =MAX(C4:E4) |
| 4 | Isaika | 57 | 90 | 60 | =SUM(C5:E5) | =AVERAGE(C5:E5) | =MIN(C5:E5) | =MAX(C5:E5) |
| 5 | Kabiru | 90 | 54 | 69 | =SUM(C6:E6) | =AVERAGE(C6:E6) | =MIN(C6:E6) | =MAX(C6:E6) |
MEANING OF RESEARCH
Research in common parlance refers to a search for knowledge. Once can also define research as a scientific and systematic search for pertinent information on a specific topic.
In fact, research is an art of scientific investigation.
The Advanced Learner’s Dictionary of Current English lays down the
meaning of research as “a careful investigation or inquiry specially through search for new facts inany branch of knowledge
Research is an academic activity and as such the term should be used in a technical sense. According to Clifford Woody research comprises defining and redefining problems, formulating hypothesis or suggested solutions; collecting, organising and evaluating data; making deductions and reaching conclusions; and at last carefully testing the conclusions to determine whether they are fit for formulating hypothesis
OBJECTIVES OF RESEARCH
The purpose of research is to discover answers to questions through the application of scientific procedures. The main aim of research is to find out the truth which is hidden and which has not been discovered as yet.
Though each research study has its own specific purpose, we may think of research objectives as falling into a number of following broad groupings:
1. To gain familiarity with a phenomenon or to achieve new insights into it (studies with this objective in view are termed as exploratory or formulative research studies);
2. To portray accurately the characteristics of a particular individual, situation or a group (studies with this object in view are known as descriptive research studies);
3. To determine the frequency with which something occurs or with which it is associated with something else (studies with this object in view are known as diagnostic researchstudies);
4. To test a hypothesis of a causal relationship between variables (such studies are known as hypothesis-testing research studies
MOTIVATION IN RESEARCH
What makes people to undertake research? This is a question of fundamental importance. The possible motives for doing research may be either one or more of the following:
1. Desire to get a research degree along with its consequential benefits;
2. Desire to face the challenge in solving the unsolved problems, i.e., concern over practical problems initiates research;
3. Desire to get intellectual joy of doing some creative work;
4. Desire to be of service to society;
5. Desire to get respectability.
However, this is not an exhaustive list of factors motivating people to undertake research studies.
Many more factors such as directives of government, employment conditions, curiosity about new things, desire to understand causal relationships, social thinking and awakening, and the like may as well motivate (or at times compel) people to perform research operations.
TYPES OF RESEARCH
The basic types of research are as follows:
Descriptive vs. Analytical: Descriptive research includes surveys and fact-finding enquiries of different kinds. The major purpose of descriptive research is description of the state of affairs as it exists at present.
In social science and business research the term Ex post facto research is used for for descriptive research studies. The main characteristic
of this method is that the researcher has no control over the variables; he can only report what has happened or what is happening. Most ex post facto research projects are used for descriptive studies in which the researcher seeks to measure such items as, for example, frequency of shopping, preferences of people, or similar data. Ex post facto studies also include attempts by researchers to discover causes even when they cannot control the variables. The methods of research utilized in descriptive research are survey methods of all kinds, including comparative and correlational methods.
In analytical research, on the other hand, the researcher has to use facts or information already available, and analyze these to make a critical evaluation of the material.
(ii) Applied vs. Fundamental: Research can either be applied (or action) research or
fundamental (to basic or pure) research. Applied research aims at finding a solution for an immediate problem facing a society or an industrial/business organisation, whereas fundamental research is mainly concerned with generalisations and with the formulation of a theory.
“Gathering knowledge for knowledge’s sake is termed ‘pure’ or ‘basic’ research.”4 Research concerning some natural phenomenon or relating to pure mathematics are examples of fundamental research. Similarly, research studies, concerning human behaviour carried on with a view to make generalisations about human behaviour, are also examples of fundamental research, but research aimed at certain conclusions (say, a solution) facing aconcrete social or business problem is an example of applied research.
Research to identify social, economic or political trends that may affect a particular institution or the copy research (research to find out whether certain communications will be read and understood) or the marketing research or evaluation research are examples of applied research.
Thus, the central aim of applied research is to discover a solution for some pressing practical problem,
whereas basic research is directed towards finding information that has a broad base of applications and thus, adds to the already existing organized body of scientific knowledge.
(iii) Quantitative vs. Qualitative: Quantitative research is based on the measurement of quantity or amount. It is applicable to phenomena that can be expressed in terms of quantity.
Qualitative research, on the other hand, is concerned with qualitative phenomenon, i.e., phenomena relating to or involving quality or kind. For instance, when we are interested in investigating the reasons for human behaviour (i.e., why people think or do certain things), we quite often talk of ‘Motivation Research’, an important type of qualitative research.
This type of research aims at discovering the underlying motives and desires, using in depth interviews for the purpose.
Conceptual vs. Empirical: Conceptual research is that related to some abstract idea(s) or theory. It is generally used by philosophers and thinkers to develop new concepts or to reinterpret existing ones. On the other hand, empirical research relies on experience or observation alone, often without due regard for system and theory. It is data-based research, coming up with conclusions which are capable of being verified by observation or experiment.
We can also call it as experimental type of research. In such a research it is necessary to get at facts firsthand, at their source, and actively to go about doing certain things to stimulate the production of desired information. In such a research, the researcher must first provide himself with a working hypothesis or guess as to the probable results.
SIGNIFICANCE OF RESEARCH
All progress is born of inquiry. Doubt is often better than overconfidence, for it leads to inquiry, and inquiry leads to invention” is a famous Hudson Maxim in context of which the significance of research can well be understood. Increased amounts of research make progress possible.
Research inculcates scientific and inductive thinking and it promotes the development of logical habits of thinking and organization
2 .Research provides the basis for nearly all government policies in our economic system. For instance, government’s budgets rest in part on an analysis of the needs and desires of the people and on the availability of revenues to meet these needs.
3. Research is equally important for social scientists in studying social relationships and in seeking answers to various social problems. It provides the intellectual satisfaction of knowing a few things just for the sake of knowledge and also has practical utility for the social scientist to know for the sake of being able to do something better or in a more efficient manner
4. Research has its special significance in solving various operational and planning problems of business and industry. Operations research and market research, along with motivational research, are considered crucial and their results assist, in more than one way, in taking business decisions.
5. Research is the bedrock of all scientific and technological inventions and innovations
6. To those students who are to write a master’s or Ph.D. thesis, research may mean a careerism or a way to attain a high position in the social structure;
(7) To professionals in research methodology, research may mean a source of livelihood;
(8) To philosophers and thinkers, research may mean the outlet for new ideas and insights;
(9) To literary men and women, research may mean the development of new styles and creative work;
(10) To analysts and intellectuals, research may mean the generalisations of new theories.
Research Process
Before embarking on the details of research methodology and techniques, it seems appropriate to
present a brief overview of the research process. Research process consists of series of actions or
steps necessary to effectively carry out research and the desired sequencing of these steps.
Formulating the research problem:
There are two types of research problems, viz., those
which relate to states of nature and those which relate to relationships between variables. At the very outset the researcher must single out the problem he wants to study, i.e., he must decide the general area of interest or aspect of a subject-matter that he would like to inquire into. Initially the problem may be stated in a broad general way and then the ambiguities, if any, relating to the problem be resolved.
The best way of understanding the problem is to discuss it with one’s own colleagues or with those having some expertise in the matter.
Extensive literature survey:
Once the problem is formulated, a brief summary of it should be
written down. At this juncture the researcher should undertake extensive literature survey connected with the problem. For this purpose, the abstracting and indexing journals and published or unpublished bibliographies are the first place to go to. Academic journals, conference proceedings, government reports, books etc., must be tapped depending on the nature of the problem. In this process, it should
be remembered that one source will lead to another. The earlier studies, if any, which are similar to the study in hand should be carefully studied. A good library will be a great help to the researcher at this stage.
3. Development of working hypotheses: After extensive literature survey, researcher should state in clear terms the working hypothesis or hypotheses. Working hypothesis is tentative assumption made in order to draw out and test its logical or empirical consequences. As such the manner in which research hypotheses are developed is particularly important since they provide the focal point for research.
. Preparing the research design:
The research problem having been formulated in clear cut terms, the researcher will be required to prepare a research design, i.e., he will have to state the conceptual structure within which research would be conducted. The preparation of such a design facilitates research to be as efficient as possible yielding maximal information. In other words, the function of research design is to provide for the collection of relevant evidence with minimal expenditure of effort, time and money.
Meaning of Research
Research in common parlance refers to a search for knowledge. Research can also be defined as a scientific and systematic search for pertinent information on a specific topic. Research is an art of scientific investigation.
According to Clifford Woody, research comprises defining and redefining problems, formulating hypotheses or suggested solutions, collecting, organizing and evaluating data, making deductions and reaching conclusions, and carefully testing the conclusions to determine whether they are fit for formulating a hypothesis.
Objectives of Research
- To gain familiarity with a phenomenon or to achieve new insights into it (exploratory or formulative research studies).
- To portray accurately the characteristics of a particular individual, situation or a group (descriptive research studies).
- To determine the frequency with which something occurs or with which it is associated with something else (diagnostic research studies).
- To test a hypothesis of a causal relationship between variables (hypothesis-testing research studies).
Types of Research
- Descriptive vs. Analytical: Descriptive research includes surveys and fact-finding enquiries. The researcher has no control over variables; can only report what has happened or is happening. Analytical research uses facts or information already available to make a critical evaluation.
- Applied vs. Fundamental: Applied research aims at finding a solution for an immediate practical problem. Fundamental (basic/pure) research is mainly concerned with generalisations and formulation of theory.
- Quantitative vs. Qualitative: Quantitative research is based on measurement of quantity or amount, applicable to phenomena expressed in terms of quantity. Qualitative research is concerned with qualitative phenomena — investigating reasons for human behaviour.
- Conceptual vs. Empirical: Conceptual research relates to abstract ideas or theory; used by philosophers to develop new concepts. Empirical research relies on experience or observation, data-based, coming up with conclusions verifiable by experiment.
Research Design
A research design is a strategy for answering your research question using empirical data. Creating a research design means making decisions about:
- Your overall aims and approach.
- The type of research design you will use.
- Your sampling methods or criteria for selecting subjects.
- Your data collection methods.
- The procedures you will follow to collect data.
- Your data analysis methods.
Types of Quantitative Research Designs
- Experimental: Tests causal relationships. Manipulates an independent variable and measures its effect on a dependent variable. Subjects randomly assigned to groups. Usually conducted in a controlled environment (lab).
- Quasi-experimental: Tests causal relationships but without random assignment. Often involves comparing outcomes of pre-existing groups. Often conducted in a natural environment.
- Correlational: Tests whether variables are related. Variables are measured without influencing them.
- Descriptive: Describes characteristics, averages, trends. Variables measured without influencing them.
Types of Qualitative Research Designs
- Case Study: Detailed study of a specific subject. Data collected using various sources. Focuses on holistic understanding.
- Ethnography: Detailed study of the culture of a specific community or group. Data collected by extended immersion and close observation.
- Grounded Theory: Aims to develop a theory inductively by systematically analysing qualitative data.
- Phenomenology: Aims to understand a phenomenon by describing participants lived experiences.
Sampling Methods
- Probability Sampling: Sample selected using random methods. Mainly used in quantitative research. Allows strong statistical inferences about the population.
- Non-probability Sampling: Sample selected in a non-random way. Easier to achieve but greater risk of bias.
Basic Statistics
The basics of statistics include the measure of central tendency and the measure of dispersion. The central tendencies are mean, median and mode. Dispersions comprise variance and standard deviation.
Measures of Central Tendency
- Mean: The average of the observations. Calculated by dividing the sum of given numbers by the total number of numbers.
Example: Mean of 2, 4, 6, 8 and 10 = (2+4+6+8+10)/5 = 30/5 = 6
- Median: The middle value of the given list of data when arranged in ascending or descending order.
Example 1: Median of 14, 63 and 55 → arranged: 14, 55, 63 → Median = 55.
Example 2: Median of 1.79, 1.61, 2.09, 1.84, 1.96, 2.11, 1.75 → arranged: 1.61, 1.75, 1.79, 1.84, 1.96, 2.09, 2.11 → Median = 1.84.
- Mode: The value that is repeatedly occurring in a given set. The value that appears the most number of times.
Example: Mode of {3, 7, 8, 8, 9} is 8. Mode of {2,2,2,3,4,4,5,5,5} is 2 and 5 (bimodal).
- Bimodal: two modes in a data set.
- Trimodal: three modes in a data set.
- Multimodal: more than three modes.
- No mode: when no value appears more than once (e.g. 3, 6, 9, 16, 27, 37, 48).
Measures of Dispersion
- Variation: The measure of spread out of the collection of data.
- Standard Deviation: The measure of the dispersion of data from the mean.
- Variance: The square of standard deviation.
Types of Statistical Tests
- Summary statistics (e.g. mean, standard deviation).
- Two-sample differences tests (e.g. t-test): Used to determine if there is a statistically significant difference between the means of two groups.
- Non-parametric tests (e.g. U-test): Makes minimal assumptions about the underlying distribution. Often used when the assumptions of parametric tests are evidently violated.
- Matched pairs tests (e.g. Wilcoxon): Used to detect discrimination in the offering of goods and services.
- Association tests (e.g. Chi-squared).
Parametric vs. Non-Parametric Tests
Parametric tests make assumptions about the data distribution. Non-parametric tests make minimal assumptions — often infinite-dimensional models. Both are used to make inferences about a population based on a sample.
Representation of Data
- Bar Graph: Represents grouped data with rectangular bars with lengths proportional to the values they represent. Bars can be plotted vertically or horizontally.
- Pie Chart: A circle divided into sectors. Each sector represents a proportion of the whole.
- Line Graph: A series of data points connected with a straight line. The data points are called markers.
- Pictograph: Shows data with the help of pictures or pictorial symbols.
- Histogram: Rectangles whose area is proportional to the frequency of a variable and whose width is equal to the class interval.
- Frequency Distribution: The frequency of a data value is often represented by "f." A frequency table is constructed by arranging collected data values in ascending order with their corresponding frequencies.