JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
Syllabus effective from 2010-2011
ENGLISH SYLLABUS FOR SEM. 1 & 2 of JNTU-K
Introduction
The major challenge ...of a language teaching in a technical institution is to prepare the student for employability through imparting language skills to develop communicative competence. The proficiency in English language is closely linked to ‘good communication skills’ more so in the recent times when employability is at stake for want of communication skills on the part of the students. Since skills and personal attributes are revealed through communication, the responsibility of grooming students in life skills is also emphasized as part of language teaching and learning.
The core key skills needed are:
Since the inception of the Board of Studies for English, effort to design a Course Structure that would cater to the needs of a wide range of learner groups has been made. It was felt by the Board that the Course Structure has to take into consideration the above criteria and therefore the objectives of the Language course ought to be much focused.
Objectives
1: To improve the language proficiency of technical under graduates in English with emphasis on LSRW skills.
1.1: To provide learning environment to practice listening, speaking, reading, and writing skills within and beyond the classroom environment.
1.2: To assist the students to carry on the tasks and activities through guided instructions and materials.
2: To effectively integrate English language learning with employability skills and training.
2.1: To design the main course material and exercises with authentic materials drawn from everyday use to cater to everyday needs.
The material may be culled from newspaper articles, advertisements, promotional material etc.
2.2: To provide hands-on experience through case-studies, mini-projects, group & individual presentations.
Each chapter will be structured with a short passage or collage of passages for reading. All further exercises and activities will draw upon the broad subject of the passage(s), and use functional and situational approach
Chapter 4. Disaster Management
Articles and punctuation:
• Understanding the uses of ‘a’, ‘an’, and ‘the’
• Understanding the uses of words/phrases expressing quantity, like ‘some’, ‘a bit of’, ‘more’, etc.
• Understanding and using correct punctuation to convey meaning
Functional grammar exercise:
Students may be asked to imagine that in the aftermath of a natural disaster, they are part of a relief team effort. When asked to effectively identify the needs of the situation, how do they plan to go about providing necessary aid? Is an ambulance to be arranged for? Or a medical tent set up? Areadequate first-aid supplies available? Do more rations need to be fetched? Could there be a tie-up withan overseas relief organization?
Reading and analysis of a short piece on the tsunami
Official letters and emails
Effectively using the format of official communication: providing one’s own address and contact details, documenting the date and place from which the communication is sent, the salutation used for the addressee, the main body of the letter or email (keeping it comprehensive but to the point), and signing off
Dialogues between:
1.a social worker and an earthquake
victim
2.two doctors working in an area afflicted
by natural disaster
3.two school students campaigning to
raise relief money
Communication, teamwork, problem solving, adaptability, stress management, reliability, integrity
Enhanced learner-participation, development of linguistic proficiency, functional approach to problem solving, enabling group work
[Both Teacher's Manual and Sample Test Questions will be provided]
Chapter 5 –Health Prepositions, conjunctions and exclamations:
• Understanding the use of prepositions – words that connect verbs with their objects
• Understanding that certain verbs
use certain prepositions
• Understanding the uses of common prepositions: to, for, at, by, of, and so on
• Understanding the uses of conjunctions and exclamations
Functional grammar exercise:
Students may be asked to propose ways in which healthier living might be attained – eating better andexercising,
drinking plenty of water, partaking fresh vegetables from the
Market, and so on. Possible exercises
may be framed around:
• Filling in blanks within sentences
• Distinguishing between different meanings possible through the use of different prepositions with the same verbs
Reading and analysis of three different kinds of writing, and comparisons between them:
1. A Government of India
report on the success of
nationwide campaigns for polio vaccination
2. A vegetarian's perspective on what makes for
healthy living
3. An athlete's say on the benefits of lifelong exercise
Reports
Learning the difference between an essay, for example, and a report; learning to identify the key points of an event or incident, and documenting them briefly but in a manner that conveys both the temper and the unfolding of the event; understanding what is meant by a 'target readership', and learning to tailor the piece to the needs of that readership
Brief exchanges between:
1. A father and his son/daughter, as he explains the importance of staying fit
2. A friends discussing the ideal diet
3. A campus counsellor and a student
Personal presentation, stress-management, commitment, enthusiasm,, self-motivation
Development of linguistic proficiency, functional approach to problem solving
[Both Teacher's Manual and Sample Test Questions will be provided]
Chapter 6 Sports :
Revision of all elements of grammar handled thus far, through evocative descriptions of State or national or international level sports stories, and discussion of them.
Functional grammar exercise:
Students may, in pairs, be asked to present an account of a memorable sports meet or game. The use of nouns pronouns, and adjectives should help to clarify exactly what event is being talked about. Judicious use of adjective will help provide the context: how important the game or match was, where it was held, and so on. In a brief account of the game, verbs and adverbs will be necessary to report exactly what happened. If the account has to be detailed and lively, students will be obliged to use the correct forms and tenses. Of course, throughout, not only will the right inflections and articles be necessary, so too will the precise use of prepositions.
Reading and analysis of two of four short pieces in depiction of:
1. Opportunities for men and women in sports
2. A decisive moment in a game
3. Expectation and failure
4. The attitude of sportsmanship
Presentations
Learning to identify the key elements of any issue and putting them down as succinct points; structuring the points so that they may be elaborated on according to necessity; understanding the progression of points so that no important element is missed out, but also, repetitions are avoided
Small conversations between:
1. A fitness instructor and a trainee
2. Two friends discussing a possible
career in sports
3. Two friends discussing their favorite
game
Teamwork, integrity, self-motivation, self-esteem, commitment
Development of linguistic proficiency, functional approach to problem solving
[Both Teacher's Manual and Sample Test Questions will be provided]
Test Book: Step by Step : Learning Language and Life Skills by Pearson Longman; Pearson Publishers
Lab Manual: Strengthen your Steps (A Multimodal course in communication skills) by Maruthi Publications
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
MATHEMATICS-II (Common to All branches)
Syllabus effective from 2010-2011
UNIT – I
Laplace transforms of standard functions –Shifting Theorems, Transforms of derivatives and integrals – Unit step function –Dirac’s delta function.
UNIT – II
Inverse Laplace transforms– Convolution theorem - Application of Laplace transforms to ordinary differential equations Partial fractions.
UNIT – III
Fourier Series: Determination of Fourier coefficients – Fourier series – even and odd functions – Fourier series in an arbitrary interval– Half-range sine and cosine series.
UNIT – IV
Fourier integral theorem (only statement) – Fourier sine and cosine integrals - Fourier transform – sine and cosine transforms – properties – inverse transforms – Finite Fourier transforms.
UNIT – V
Formation of partial differential equations by elimination of arbitrary constants and arbitrary functions –solutions of first order linear (Lagrange) equation and nonlinear (standard type) equations.
UNIT – VI
Method of Separation of Variables - Applications to wave equation, heat equation and Laplace Equation.
UNIT – VII
Z-transform – properties – Damping rule – Shifting rule – Initial and final value theorems -Inverse z-transform -Convolution theorem – Solution of difference equation by z-transforms.
UNIT – VIII
Gamma and Beta Functions – Properties – Evaluation of improper integrals.
TEXT BOOK:
BOOKS:
***
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING PHYSICS - II (Common to all branches)
Syllabus effective from 2010- 2011
UNIT-I
QUANTUM MECHANICS & QUANTUM COMPUTING: Introduction - Schrodinger Time Independent and Time Dependent wave equations - Particle in a box - Operator version -Suitability of Quantum system for Information Processing - Classical Bits and Qu-Bits - Bloch's Sphere - Quantum Gates - Multiple Qu-Bits - Advantages of Quantum Computing over classical Computation.
UNIT-II
ELECTRON THEORY OF METALS: Classical free electron theory - Mean free path - Relaxation time and drift velocity - Quantum free electron theory - Fermi - Dirac (analytical) and its dependence on temperature - Fermi energy - Electron scattering and resistance.
UNIT-HI
BAND THEORY OF SOLIDS: Bloch theorem (qualitative) - Kronig - Penney model - Origin of energy band formation in solids - Classification of materials into conductors, semi- conductors & insulators -Concept of effective mass of an electron.
UNIT-IV
MAGNETIC PROPERTIES: Permeability - Magnetization - Orgin of magnetic moment - Classification of Magnetic materials - Dia, para and ferro- magnetism -Domain and Weiss field theory - Hysteresis Curve - Soft and Hard magnetic materials.
UNIT-V
SUPERCONDUCTIVITY: General properties - Meissner effect - Penetration depth - Type I and type II superconductors - Flux quantization - DC and AC Josephson effect - BCS Theory - Applications of superconductors.
UNIT-VI
DIELECTRIC PROPERTIES: Introduction - Dielectric constant - Electronic, ionic and orientational polarizations - Internal fields in solids - Clausius-Mossotti equation - Dielectrics in alternating fields -frequency dependence of the polarizability - Ferro and Piezo electricity.
UNIT-VII
SEMICONDUCTORS: Introduction - Intrinsic semiconductor and carrier concentration - Equation for conductivity - Extrinsic semiconductor and carrier concentration - Drift and diffusion - Einstein's equation - Hall effect - Direct & indirect band gap semiconductors.
UNIT-VIII
PHYSICS OF NANO MATERIALS: Introduction - Properties and prepation of Nano Materials -Surface occupancy - Reduction of Dimensionality - 4D -Force vector - Quantum wires - Quantum dots and Quantum wells - Density of states and Energy spectrum - Nanotubes - Applications of nanomaterials.
Text book: Perspective of Engineering Physics - II by M Sri Ramarao, Nityananda Choudary, Daruka Prasad, ACME Learning.
Refernce books: 1. Solid State Physics – by A J Dekker , Mcmilan India Ltd.
***
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING CHEMISTRY – II (Common to all branches)
Syllabus effective from 2010- 2011
UNIT-I
POLYMERS: Introduction - Types of polymers – Classification - Methods of polymerisation – Stereo specific polymers - Ziegler Natta catalysis - Properties of polymers –Conducting Polymers- Engineering applications – Biodegradable polymers - Individual polymers(Preparation ,Properities,Uses of Poly Styrene, PVC, PTFE, Bakelite’s, Cellulose derivatives, Poly Carbonates)
UNIT-II
PLASTICS – Types –Compounding of plastics- Moulding(Four types)- Fiber reinforced , Glass fibre reinforced plastics –Bullet Proof Plastics– Properties of plastics – Engineering applications
UNIT-III
RUBBERS & ELASTOMERS: Introduction – Preparation – Vulcanization – Properties - Engineering applications.
Buna-S,Buna-N, - Poly Urethane - Engineering applications of Elastomers
UNIT-IV
NANO MATERIALS
Introduction to Nano materials-preparation of few Nano materials(Carbon Nano Tubes,Fullerenes etc)-Properities of Nano materials- Engineering applications.
UNIT-V
BUILDING MATERIALS(CEMENT,REFRACTOR
CEMENT
Introduction, Manufacturing of Portland Cement(Dry &We Process )-Chemistry of Setting and Hardening of Cement-Effect of Carbon dioxide,Sulphur Dioxide ,Chloride on Cement concrete.
REFRACTORIES
Introduction-Classificatio
CERAMICS
Introduction-Classificati
UNIT-VI
FUEL TECHNOLOGY
Introduction to Liquid Fuels-Classification of Crude Oil-Fractional Distillation-Cracking (Thermal &Catalytic), Polymerization-Refining &Reforming –Working of Internal Combustion Engine, Heated Chambers-Knocking –AntiKnocking Agents-Octane &Cetane Number.
LUBRICANTS
Definition and Explanation of Lubrication-Mechanism of Lubrication –Types of Lubricants-Properties of Lubricants-Engineering applications
UNIT-VII
CORROSION – Mechanism- Factors influence the rate of corrosion - Types of Corrosion -Protection methods (Anodic & Cathodic protection ), - Metallic Coatings - Paints, Varnishes, Enamels , Special paints.
UNIT-VIII
GREEN CHEMISTRY
Introduction-Concepts- Engineering Applications
Text Book : A Text book of engineering chemistry by Srinivasulu D. Parshva publications
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING DRAWING (Common to all Branches)
Syllabus effective from 2010- 2011
I B.Tech – II Semester
Unit-I
Polygons-Construction of Regular Polygons using given length of a side; Ellipse- Arcs of Circles and Oblong Methods; Scales-Vernier and Diagonal Scales.
Unit-II
Introduction to Orthographic Projections; Projections of Points; Projections of Straight Lines parallel to both planes; Projections of Straight Lines-Parallel to one and inclined to other plane.
Unit-III
Projections of Straight Lines inclined to both planes, determination of true lengths, angle of inclinations and traces.
Unit-IV
Projections of Planes; Regular Planes Perpendicular / Parallel to one Reference
Plane and inclined to other Reference Plane; inclined to both the Reference Planes.
Unit-V
Projections of Solids-Prisms and Cylinders with the axis inclined to one Plane.
Unit-VI
Projections of Solids- Pyramids and Cones with the axis inclined to one plane.
Unit-VII
Conversion of Isometric Views to Orthographic Views.
Unit-VIII
Conversion of Orthographic Views to Isometric Projections and Views.
TEXT BOOK:
REFERENCE BOOKS:
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENVIRONMENTAL STUDIES (Common to all Branches)
Syllabus effective from 2010 -2011
UNIT - I
Multidisciplinary nature of Environmental Studies: Definition, Scope and Importance – Need for Public Awareness.
UNIT - II
Natural Resources : Renewable and non-renewable resources – Natural resources and associated problems – Forest resources – Use and over – exploitation, deforestation, case studies – Timber extraction – Mining, dams and other effects on forest and tribal people – Water resources – Use and over utilization of surface and ground water – Floods, drought, conflicts over water, dams – benefits and problems - Mineral resources: Use and exploitation, environmental effects of extracting and using mineral resources, case studies. - Food resources: World food problems, changes caused by agriculture and overgrazing, effects of modern agriculture, fertilizer-pesticide problems, water logging, salinity, case studies. – Energy resources: Growing energy needs, renewable and non-renewable energy sources use of alternate energy sources. Case studies. Land resources: Land as a resource, land degradation, man induced landslides, soil erosion and desertification. Role of an individual in conservation of natural resources. Equitable use of resources for sustainable lifestyles.
UNIT - III
Ecosystems : Concept of an ecosystem. - Structure and function of an ecosystem. - Producers, consumers and decomposers. - Energy flow in the ecosystem - Ecological succession. - Food chains, food webs and ecological pyramids. - Introduction, types, characteristic features, structure and function of the following ecosystem:
a. Forest ecosystem
b. Grassland ecosystem
c. Desert ecosystem
d. Aquatic ecosystems (ponds, streams, lakes, rivers, oceans, estuaries)
UNIT - IV
Biodiversity and its conservation : Introduction - Definition: genetic, species andecosystem diversity. - Bio-geographical classification of India - Value of biodiversity: consumptive use, productive use, social, ethical, aesthetic and option values - . Biodiversity at global, National and local levels. - . India as a mega-diversity nation - Hot-sports of biodiversity - Threats to biodiversity: habitat loss, poaching of wildlife, man-wildlife conflicts. - Endangered and endemic species of India – Conservation of biodiversity: In-situ and Ex-situ conservation of biodiversity.
UNIT - V
Environmental Pollution : Definition, Cause, effects and control measures of :
a. Air pollution
b. Water pollution
c. Soil pollution
d. Marine pollution
e. Noise pollution
f. Thermal pollution
g. Nuclear hazards
Solid waste Management: Causes, effects and control measures of urban and
industrial wastes. - Role of an individual in prevention of pollution. - Pollution case studies. - Disaster management: floods, earthquake, cyclone and landslides.
UNIT - VI
Social Issues and the Environment: From Unsustainable to Sustainable development -Urban problems related to energy -Water conservation, rain water harvesting, watershed management -Resettlement and rehabilitation of people; its problems and concerns. Case Studies -Environmental ethics: Issues and possible solutions. -Climate change, global warming, acid rain, ozone layer depletion, nuclear accidents and holocaust. Case Studies. -Wasteland reclamation. – Consumerism and waste products. -Environment Protection Act. -Air (Prevention and Control of Pollution) Act. –Water (Prevention and control of Pollution) Act -Wildlife Protection Act -Forest Conservation Act -Issues involved in enforcement of environmental legislation. -Public awareness.
UNIT - VII
Human Population and the Environment: Population growth, variation among nations. Population explosion – Family Welfare Programme. -Environment and human health. -Human Rights. -Value Education. HIV/AIDS. -Women and Child Welfare. -Role of information Technology in Environment and human health. –Case Studies. Page 37 of 79
UNIT - VIII
Field work : Visit to a local area to document environmental assets River /forest grassland/hill/mountain -Visit to a local polluted site Urban/Rural/industrial/ Agricultural Study of common plants, insects, birds. -Study of simple cosystemspond, river, hill slopes, etc.
Text Books :
1. An Introduction to Environmental Studies by B. Sudhakara Reddy, T. Sivaji Rao,
U. Tataji & K. Purushottam Reddy, Maruti Publications.
Reference :
1. Text Book of Environmental Studies by Deeshita Dave & P. Udaya Bhaskar, Cengage Learning.
2. Environmental Studies by K.V.S.G. Murali Krishna, VGS Publishers, Vijayawada
3. Text Book of Environmental Sciences and Technology by M. Anji Reddy, BS Publications.
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING PHYSICS&CHEMISTRY LABORATORY- II
PHYSICS:
Electro-Magnetism and Electronics:
1.Determine the Planck's constant using Photo-Ceil.
2.Study the variation of Magnetic Field along the axis of a solenoid coil using Stewart - Gee's apparatus.
3.Draw the Frequency Response curves of L-C-R Series and Parallel Circuits.
4.Determine the Time Constant for a C-R Circuit.
5.Determine the Band Gap of a Semi conductor using a p-n junction diode.
6.Study of Characteristic curves (l/V) of a Zener diode to determine its Breakdown voltage.
7.Determine the Hall Coefficient of a Semiconductor.
8.Draw the characteristic curves and determine the Thermoelectric coefficient of a Thermistor
9.Study the Seebeck and Peltier - Thermoelectric Effects and to determine Coefficients and Thermo Electric Effect using Thermocouple.
10.Draw the Characteristic curves of a p-i-n and Avalanche Photo Diodes.
11.Determination of Numerical Aperture and Bending losses of an Optical Fiber.
Manual Cum Record Books :
1. Manual cum Record for Engineering Phaysics Lab- II, by Prof.Sri M. Rama Rao, Acme Learning.. .
2. Lab manual - II, of Engineering Physics by Dr. Y.Aparna and Dr. K.Venkateswara Rao (VGS Books links, Vijayawada )
CHEMISTRY LAB – II
1.PRODUCTION OF BIODIESEL.
INTRODUCTION TO BIO FUELS
The teacher has to perform the transesterfication reaction of FATTY ACID and the Biodiesel thus produced can be used for analysis.( Please give priority to production of Biodiesel from waste cooking oil)
2. Estimation of properties of oil:
a. Acid Number
b. Viscosity
c. Saponification value
d. Aniline point
e. Flash and Fire points
f. Pour and Cloud point
3.. PREPARATION OF PHENOL –FORMALDEHYDE RESIN
4. SOIL ANALYSIS:
pH, Determination of Zinc, Iron, Copper.
5.FOOD ANALYSIS:
Determination Saturated and Unsaturated Fatty Acids, pH,etc.
All the teachers are requested to focus on bio fuels ,soil analysis and food analysis as these are the need of 21 st century and these experiments are so desigened to encourage students to carry out lab to land process.
Lab Manual : Engineering chemistry laboratory manual &record By Srinivasulu . D. Parshva publications
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
I B.Tech I/II Semester
IT WORKSHOP (Common to all Branches)
Objectives:
The IT Workshop for engineers is a 6 training lab course spread over 45 hours.
The modules include training on PC Hardware, Internet & World Wide Web and Productivity tools including (word processor, spread sheet, presentation sw) Word, spread sheet Excel, Power Point and Publisher.
PC Hardware Identification of basic peripherals, assembling a PC, installation of system software like MS Windows, Linux and the device drivers. Troubleshooting Hardware and software _ some tips and tricks .
Internet & World Wide Web: Different ways of hooking the PC on to the internet from home and workplace and effectively usage of the internet, web browsers, email, newsgroups and discussion forums .Awareness of cyber hygiene( protecting the personal computer from getting infected with the viruses), worms and other cyber attacks .
Productivity tools Crafting professional word documents; excel spread sheets, power point presentations and personal web sites using the Microsoft suite of office tools and LaTeX.
(Note: Student should be thoroughly exposed to minimum of 12 Tasks)
PC Hardware
Task 1: Identification of the peripherals of a computer.
To prepare a report containing the block diagram of the CPU along with the configuration of each peripheral and its functions.
Task 2(Optional) : A practice on disassemble the components of a PC and assembling them to working condition.
Task 3 : Installation of MS windows and LINUX on a PC.
Task 4 : Exposure to Basic commands and system administration in Linux including: Basic Linux commands in bash, Create hard and symbolic links.
Task 5 :
Hardware Troubleshooting (Demonstration):
Students have to be given a PC which does not boot due to improper assembly or defective peripherals. Identification of a problem and fixing it for getting to working condition.
Software Troubleshooting (Demonstration): Students have to be given a malfunctioning CPU due to system software problems. Identification of a problem and fixing it for getting to working condition.
Internet & World Wide Web
Task 6 : Orientation & Connectivity Boot Camp and surfing the Web using Web Browsers : Students should get connected to their Local Area Network and access the Internet. In the process they should configure the TCP/IP setting and demonstrate how to access the websites and email. Students customize their web browsers using bookmarks, search toolbars and pop up blockers.
Task 7: Search Engines & Netiquette : Students should know what search engines are and how to use the search engines.
A few topics would be given to the students for which they need to search on Google.
Task 8 : Cyber Hygiene (Demonstration) : Awareness of various threats on the internet. To install an anti virus software and to configure their personal firewall and windows update on their computers.
LaTeX and Word
Word Orientation : Importance of LaTeX and MS/ equivalent (FOSS) tool Word as word Processors.
Details of the four tasks and features that would be covered in each, Using LaTeX and word – Accessing, overview of toolbars, saving files, Using help and resources, rulers, format painter in word.
Task 9 : Using LaTeX and word to create project certificate. Features to be covered:-Formatting Fonts in word, Drop Cap in word, Applying Text effects, Using Character Spacing, Borders and Colors, Inserting Header and Footer, Using Date and Time option in both LaTeX and Word.
Task 10: Creating project : Abstract Features to be covered:-Formatting Styles, Inserting table, Bullets and Numbering, Changing Text Direction, Cell alignment, Footnote, Hyperlink, Symbols, Spell Check , Track Changes, Images from files and clipart, Drawing toolbar and Word Art, Formatting Images, Textboxes and Paragraphs.
Excel
Excel Orientation : The mentor needs to tell the importance of MS/ equivalent (FOSS) tool Excel as a Spreadsheet tool, give the details of the four tasks and features that would be covered in each. Using Excel –
Accessing, overview of toolbars, saving excel files, Using help and resources
Task 11 : Creating a Scheduler - Features to be covered:- Gridlines, Format Cells, Summation, auto fill, Formatting Text
LOOKUP/VLOOKUP
Task 12 : Performance Analysis - Features to be covered:- Split cells, freeze panes, group and outline, Sorting, Boolean and logical operators, Conditional formatting
LaTeX and MS/equivalent (FOSS) tool Power Point
Task 13 : Students will be working on basic power point utilities and tools which help them create basic power point presentation. Topic covered during this week includes :- PPT Orientation, Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and Numbering, Auto Shapes, Lines and Arrows, Hyperlinks, Inserting –Images, Clip Art, Tables and Charts in both LaTeX and Powerpoint.
Task 14 : Concentrating on the in and out of Microsoft power point and presentations in LaTeX. Helps them learn best practices in designing and preparing power point presentation. Topic covered during this week includes: - Master Layouts (slide, template, and notes), Types of views (basic, presentation, slide slotter, notes etc), Inserting – Background, textures, Design Templates, Hidden slides.
REFERENCES :
1 Scott Mueller’s Upgrading and Repairing PCs, 18/e, Scott. Mueller, QUE, Pearson,2008
2 The Complete Computer upgrade and repair book,3/e,Cheryl A Schmidt, Dreamtech
Syllabus effective from 2010-2011
ENGLISH SYLLABUS FOR SEM. 1 & 2 of JNTU-K
Introduction
The major challenge ...of a language teaching in a technical institution is to prepare the student for employability through imparting language skills to develop communicative competence. The proficiency in English language is closely linked to ‘good communication skills’ more so in the recent times when employability is at stake for want of communication skills on the part of the students. Since skills and personal attributes are revealed through communication, the responsibility of grooming students in life skills is also emphasized as part of language teaching and learning.
The core key skills needed are:
- Communication
- Team Work
- Problem Solving
- Learning Skills
- Adaptability
- Commitment
- Enthusiasm
- Stress Management
- Integrity
- Sense of Humour
- Self-Motivation
- Reliability
- Self-esteem
- Personal Presentation
Since the inception of the Board of Studies for English, effort to design a Course Structure that would cater to the needs of a wide range of learner groups has been made. It was felt by the Board that the Course Structure has to take into consideration the above criteria and therefore the objectives of the Language course ought to be much focused.
Objectives
1: To improve the language proficiency of technical under graduates in English with emphasis on LSRW skills.
1.1: To provide learning environment to practice listening, speaking, reading, and writing skills within and beyond the classroom environment.
1.2: To assist the students to carry on the tasks and activities through guided instructions and materials.
2: To effectively integrate English language learning with employability skills and training.
2.1: To design the main course material and exercises with authentic materials drawn from everyday use to cater to everyday needs.
The material may be culled from newspaper articles, advertisements, promotional material etc.
2.2: To provide hands-on experience through case-studies, mini-projects, group & individual presentations.
Each chapter will be structured with a short passage or collage of passages for reading. All further exercises and activities will draw upon the broad subject of the passage(s), and use functional and situational approach
Chapter 4. Disaster Management
Articles and punctuation:
• Understanding the uses of ‘a’, ‘an’, and ‘the’
• Understanding the uses of words/phrases expressing quantity, like ‘some’, ‘a bit of’, ‘more’, etc.
• Understanding and using correct punctuation to convey meaning
Functional grammar exercise:
Students may be asked to imagine that in the aftermath of a natural disaster, they are part of a relief team effort. When asked to effectively identify the needs of the situation, how do they plan to go about providing necessary aid? Is an ambulance to be arranged for? Or a medical tent set up? Areadequate first-aid supplies available? Do more rations need to be fetched? Could there be a tie-up withan overseas relief organization?
Reading and analysis of a short piece on the tsunami
Official letters and emails
Effectively using the format of official communication: providing one’s own address and contact details, documenting the date and place from which the communication is sent, the salutation used for the addressee, the main body of the letter or email (keeping it comprehensive but to the point), and signing off
Dialogues between:
1.a social worker and an earthquake
victim
2.two doctors working in an area afflicted
by natural disaster
3.two school students campaigning to
raise relief money
Communication, teamwork, problem solving, adaptability, stress management, reliability, integrity
Enhanced learner-participation, development of linguistic proficiency, functional approach to problem solving, enabling group work
[Both Teacher's Manual and Sample Test Questions will be provided]
Chapter 5 –Health Prepositions, conjunctions and exclamations:
• Understanding the use of prepositions – words that connect verbs with their objects
• Understanding that certain verbs
use certain prepositions
• Understanding the uses of common prepositions: to, for, at, by, of, and so on
• Understanding the uses of conjunctions and exclamations
Functional grammar exercise:
Students may be asked to propose ways in which healthier living might be attained – eating better andexercising,
drinking plenty of water, partaking fresh vegetables from the
Market, and so on. Possible exercises
may be framed around:
• Filling in blanks within sentences
• Distinguishing between different meanings possible through the use of different prepositions with the same verbs
Reading and analysis of three different kinds of writing, and comparisons between them:
1. A Government of India
report on the success of
nationwide campaigns for polio vaccination
2. A vegetarian's perspective on what makes for
healthy living
3. An athlete's say on the benefits of lifelong exercise
Reports
Learning the difference between an essay, for example, and a report; learning to identify the key points of an event or incident, and documenting them briefly but in a manner that conveys both the temper and the unfolding of the event; understanding what is meant by a 'target readership', and learning to tailor the piece to the needs of that readership
Brief exchanges between:
1. A father and his son/daughter, as he explains the importance of staying fit
2. A friends discussing the ideal diet
3. A campus counsellor and a student
Personal presentation, stress-management, commitment, enthusiasm,, self-motivation
Development of linguistic proficiency, functional approach to problem solving
[Both Teacher's Manual and Sample Test Questions will be provided]
Chapter 6 Sports :
Revision of all elements of grammar handled thus far, through evocative descriptions of State or national or international level sports stories, and discussion of them.
Functional grammar exercise:
Students may, in pairs, be asked to present an account of a memorable sports meet or game. The use of nouns pronouns, and adjectives should help to clarify exactly what event is being talked about. Judicious use of adjective will help provide the context: how important the game or match was, where it was held, and so on. In a brief account of the game, verbs and adverbs will be necessary to report exactly what happened. If the account has to be detailed and lively, students will be obliged to use the correct forms and tenses. Of course, throughout, not only will the right inflections and articles be necessary, so too will the precise use of prepositions.
Reading and analysis of two of four short pieces in depiction of:
1. Opportunities for men and women in sports
2. A decisive moment in a game
3. Expectation and failure
4. The attitude of sportsmanship
Presentations
Learning to identify the key elements of any issue and putting them down as succinct points; structuring the points so that they may be elaborated on according to necessity; understanding the progression of points so that no important element is missed out, but also, repetitions are avoided
Small conversations between:
1. A fitness instructor and a trainee
2. Two friends discussing a possible
career in sports
3. Two friends discussing their favorite
game
Teamwork, integrity, self-motivation, self-esteem, commitment
Development of linguistic proficiency, functional approach to problem solving
[Both Teacher's Manual and Sample Test Questions will be provided]
Test Book: Step by Step : Learning Language and Life Skills by Pearson Longman; Pearson Publishers
Lab Manual: Strengthen your Steps (A Multimodal course in communication skills) by Maruthi Publications
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
MATHEMATICS-II (Common to All branches)
Syllabus effective from 2010-2011
UNIT – I
Laplace transforms of standard functions –Shifting Theorems, Transforms of derivatives and integrals – Unit step function –Dirac’s delta function.
UNIT – II
Inverse Laplace transforms– Convolution theorem - Application of Laplace transforms to ordinary differential equations Partial fractions.
UNIT – III
Fourier Series: Determination of Fourier coefficients – Fourier series – even and odd functions – Fourier series in an arbitrary interval– Half-range sine and cosine series.
UNIT – IV
Fourier integral theorem (only statement) – Fourier sine and cosine integrals - Fourier transform – sine and cosine transforms – properties – inverse transforms – Finite Fourier transforms.
UNIT – V
Formation of partial differential equations by elimination of arbitrary constants and arbitrary functions –solutions of first order linear (Lagrange) equation and nonlinear (standard type) equations.
UNIT – VI
Method of Separation of Variables - Applications to wave equation, heat equation and Laplace Equation.
UNIT – VII
Z-transform – properties – Damping rule – Shifting rule – Initial and final value theorems -Inverse z-transform -Convolution theorem – Solution of difference equation by z-transforms.
UNIT – VIII
Gamma and Beta Functions – Properties – Evaluation of improper integrals.
TEXT BOOK:
- Swamy,U.M., Vijayalaxmi, P.,Ravikumar, R.V.G., and Phani Krishna Kishore., Mathematics II, Excel Books, New Delhi.
BOOKS:
- 1. B.V.Ramana, Engineering Mathematics, Tata Mc Graw Hill.
- 2. Iyengar,T.K.V, Krishna Gandhi, et.al Engineering Mathematics Vol-II, S.Chand Co. New Delhi.
- 3. Erwin Kreszig, “Advanced Engineering Mathematics”, 8 Ed Wiley Student Edition.
***
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING PHYSICS - II (Common to all branches)
Syllabus effective from 2010- 2011
UNIT-I
QUANTUM MECHANICS & QUANTUM COMPUTING: Introduction - Schrodinger Time Independent and Time Dependent wave equations - Particle in a box - Operator version -Suitability of Quantum system for Information Processing - Classical Bits and Qu-Bits - Bloch's Sphere - Quantum Gates - Multiple Qu-Bits - Advantages of Quantum Computing over classical Computation.
UNIT-II
ELECTRON THEORY OF METALS: Classical free electron theory - Mean free path - Relaxation time and drift velocity - Quantum free electron theory - Fermi - Dirac (analytical) and its dependence on temperature - Fermi energy - Electron scattering and resistance.
UNIT-HI
BAND THEORY OF SOLIDS: Bloch theorem (qualitative) - Kronig - Penney model - Origin of energy band formation in solids - Classification of materials into conductors, semi- conductors & insulators -Concept of effective mass of an electron.
UNIT-IV
MAGNETIC PROPERTIES: Permeability - Magnetization - Orgin of magnetic moment - Classification of Magnetic materials - Dia, para and ferro- magnetism -Domain and Weiss field theory - Hysteresis Curve - Soft and Hard magnetic materials.
UNIT-V
SUPERCONDUCTIVITY: General properties - Meissner effect - Penetration depth - Type I and type II superconductors - Flux quantization - DC and AC Josephson effect - BCS Theory - Applications of superconductors.
UNIT-VI
DIELECTRIC PROPERTIES: Introduction - Dielectric constant - Electronic, ionic and orientational polarizations - Internal fields in solids - Clausius-Mossotti equation - Dielectrics in alternating fields -frequency dependence of the polarizability - Ferro and Piezo electricity.
UNIT-VII
SEMICONDUCTORS: Introduction - Intrinsic semiconductor and carrier concentration - Equation for conductivity - Extrinsic semiconductor and carrier concentration - Drift and diffusion - Einstein's equation - Hall effect - Direct & indirect band gap semiconductors.
UNIT-VIII
PHYSICS OF NANO MATERIALS: Introduction - Properties and prepation of Nano Materials -Surface occupancy - Reduction of Dimensionality - 4D -Force vector - Quantum wires - Quantum dots and Quantum wells - Density of states and Energy spectrum - Nanotubes - Applications of nanomaterials.
Text book: Perspective of Engineering Physics - II by M Sri Ramarao, Nityananda Choudary, Daruka Prasad, ACME Learning.
Refernce books: 1. Solid State Physics – by A J Dekker , Mcmilan India Ltd.
***
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING CHEMISTRY – II (Common to all branches)
Syllabus effective from 2010- 2011
UNIT-I
POLYMERS: Introduction - Types of polymers – Classification - Methods of polymerisation – Stereo specific polymers - Ziegler Natta catalysis - Properties of polymers –Conducting Polymers- Engineering applications – Biodegradable polymers - Individual polymers(Preparation ,Properities,Uses of Poly Styrene, PVC, PTFE, Bakelite’s, Cellulose derivatives, Poly Carbonates)
UNIT-II
PLASTICS – Types –Compounding of plastics- Moulding(Four types)- Fiber reinforced , Glass fibre reinforced plastics –Bullet Proof Plastics– Properties of plastics – Engineering applications
UNIT-III
RUBBERS & ELASTOMERS: Introduction – Preparation – Vulcanization – Properties - Engineering applications.
Buna-S,Buna-N, - Poly Urethane - Engineering applications of Elastomers
UNIT-IV
NANO MATERIALS
Introduction to Nano materials-preparation of few Nano materials(Carbon Nano Tubes,Fullerenes etc)-Properities of Nano materials- Engineering applications.
UNIT-V
BUILDING MATERIALS(CEMENT,REFRACTOR
CEMENT
Introduction, Manufacturing of Portland Cement(Dry &We Process )-Chemistry of Setting and Hardening of Cement-Effect of Carbon dioxide,Sulphur Dioxide ,Chloride on Cement concrete.
REFRACTORIES
Introduction-Classificatio
CERAMICS
Introduction-Classificati
UNIT-VI
FUEL TECHNOLOGY
Introduction to Liquid Fuels-Classification of Crude Oil-Fractional Distillation-Cracking (Thermal &Catalytic), Polymerization-Refining &Reforming –Working of Internal Combustion Engine, Heated Chambers-Knocking –AntiKnocking Agents-Octane &Cetane Number.
LUBRICANTS
Definition and Explanation of Lubrication-Mechanism of Lubrication –Types of Lubricants-Properties of Lubricants-Engineering applications
UNIT-VII
CORROSION – Mechanism- Factors influence the rate of corrosion - Types of Corrosion -Protection methods (Anodic & Cathodic protection ), - Metallic Coatings - Paints, Varnishes, Enamels , Special paints.
UNIT-VIII
GREEN CHEMISTRY
Introduction-Concepts- Engineering Applications
Text Book : A Text book of engineering chemistry by Srinivasulu D. Parshva publications
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING DRAWING (Common to all Branches)
Syllabus effective from 2010- 2011
I B.Tech – II Semester
Unit-I
Polygons-Construction of Regular Polygons using given length of a side; Ellipse- Arcs of Circles and Oblong Methods; Scales-Vernier and Diagonal Scales.
Unit-II
Introduction to Orthographic Projections; Projections of Points; Projections of Straight Lines parallel to both planes; Projections of Straight Lines-Parallel to one and inclined to other plane.
Unit-III
Projections of Straight Lines inclined to both planes, determination of true lengths, angle of inclinations and traces.
Unit-IV
Projections of Planes; Regular Planes Perpendicular / Parallel to one Reference
Plane and inclined to other Reference Plane; inclined to both the Reference Planes.
Unit-V
Projections of Solids-Prisms and Cylinders with the axis inclined to one Plane.
Unit-VI
Projections of Solids- Pyramids and Cones with the axis inclined to one plane.
Unit-VII
Conversion of Isometric Views to Orthographic Views.
Unit-VIII
Conversion of Orthographic Views to Isometric Projections and Views.
TEXT BOOK:
- Engineering Drawing by N.D. Bhat, Chariot Publications
REFERENCE BOOKS:
- Engineering Drawing by M.B. Shah and B.C. Rana, Pearson Publishers
- Engineering Drawing by Dhananjay A. Jolhe, Tata McGraw Hill Publishers
- Engineering Graphics for Degree by K.C. John, PHI Publishers
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENVIRONMENTAL STUDIES (Common to all Branches)
Syllabus effective from 2010 -2011
UNIT - I
Multidisciplinary nature of Environmental Studies: Definition, Scope and Importance – Need for Public Awareness.
UNIT - II
Natural Resources : Renewable and non-renewable resources – Natural resources and associated problems – Forest resources – Use and over – exploitation, deforestation, case studies – Timber extraction – Mining, dams and other effects on forest and tribal people – Water resources – Use and over utilization of surface and ground water – Floods, drought, conflicts over water, dams – benefits and problems - Mineral resources: Use and exploitation, environmental effects of extracting and using mineral resources, case studies. - Food resources: World food problems, changes caused by agriculture and overgrazing, effects of modern agriculture, fertilizer-pesticide problems, water logging, salinity, case studies. – Energy resources: Growing energy needs, renewable and non-renewable energy sources use of alternate energy sources. Case studies. Land resources: Land as a resource, land degradation, man induced landslides, soil erosion and desertification. Role of an individual in conservation of natural resources. Equitable use of resources for sustainable lifestyles.
UNIT - III
Ecosystems : Concept of an ecosystem. - Structure and function of an ecosystem. - Producers, consumers and decomposers. - Energy flow in the ecosystem - Ecological succession. - Food chains, food webs and ecological pyramids. - Introduction, types, characteristic features, structure and function of the following ecosystem:
a. Forest ecosystem
b. Grassland ecosystem
c. Desert ecosystem
d. Aquatic ecosystems (ponds, streams, lakes, rivers, oceans, estuaries)
UNIT - IV
Biodiversity and its conservation : Introduction - Definition: genetic, species andecosystem diversity. - Bio-geographical classification of India - Value of biodiversity: consumptive use, productive use, social, ethical, aesthetic and option values - . Biodiversity at global, National and local levels. - . India as a mega-diversity nation - Hot-sports of biodiversity - Threats to biodiversity: habitat loss, poaching of wildlife, man-wildlife conflicts. - Endangered and endemic species of India – Conservation of biodiversity: In-situ and Ex-situ conservation of biodiversity.
UNIT - V
Environmental Pollution : Definition, Cause, effects and control measures of :
a. Air pollution
b. Water pollution
c. Soil pollution
d. Marine pollution
e. Noise pollution
f. Thermal pollution
g. Nuclear hazards
Solid waste Management: Causes, effects and control measures of urban and
industrial wastes. - Role of an individual in prevention of pollution. - Pollution case studies. - Disaster management: floods, earthquake, cyclone and landslides.
UNIT - VI
Social Issues and the Environment: From Unsustainable to Sustainable development -Urban problems related to energy -Water conservation, rain water harvesting, watershed management -Resettlement and rehabilitation of people; its problems and concerns. Case Studies -Environmental ethics: Issues and possible solutions. -Climate change, global warming, acid rain, ozone layer depletion, nuclear accidents and holocaust. Case Studies. -Wasteland reclamation. – Consumerism and waste products. -Environment Protection Act. -Air (Prevention and Control of Pollution) Act. –Water (Prevention and control of Pollution) Act -Wildlife Protection Act -Forest Conservation Act -Issues involved in enforcement of environmental legislation. -Public awareness.
UNIT - VII
Human Population and the Environment: Population growth, variation among nations. Population explosion – Family Welfare Programme. -Environment and human health. -Human Rights. -Value Education. HIV/AIDS. -Women and Child Welfare. -Role of information Technology in Environment and human health. –Case Studies. Page 37 of 79
UNIT - VIII
Field work : Visit to a local area to document environmental assets River /forest grassland/hill/mountain -Visit to a local polluted site Urban/Rural/industrial/ Agricultural Study of common plants, insects, birds. -Study of simple cosystemspond, river, hill slopes, etc.
Text Books :
1. An Introduction to Environmental Studies by B. Sudhakara Reddy, T. Sivaji Rao,
U. Tataji & K. Purushottam Reddy, Maruti Publications.
Reference :
1. Text Book of Environmental Studies by Deeshita Dave & P. Udaya Bhaskar, Cengage Learning.
2. Environmental Studies by K.V.S.G. Murali Krishna, VGS Publishers, Vijayawada
3. Text Book of Environmental Sciences and Technology by M. Anji Reddy, BS Publications.
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
ENGINEERING PHYSICS&CHEMISTRY LABORATORY- II
PHYSICS:
Electro-Magnetism and Electronics:
1.Determine the Planck's constant using Photo-Ceil.
2.Study the variation of Magnetic Field along the axis of a solenoid coil using Stewart - Gee's apparatus.
3.Draw the Frequency Response curves of L-C-R Series and Parallel Circuits.
4.Determine the Time Constant for a C-R Circuit.
5.Determine the Band Gap of a Semi conductor using a p-n junction diode.
6.Study of Characteristic curves (l/V) of a Zener diode to determine its Breakdown voltage.
7.Determine the Hall Coefficient of a Semiconductor.
8.Draw the characteristic curves and determine the Thermoelectric coefficient of a Thermistor
9.Study the Seebeck and Peltier - Thermoelectric Effects and to determine Coefficients and Thermo Electric Effect using Thermocouple.
10.Draw the Characteristic curves of a p-i-n and Avalanche Photo Diodes.
11.Determination of Numerical Aperture and Bending losses of an Optical Fiber.
Manual Cum Record Books :
1. Manual cum Record for Engineering Phaysics Lab- II, by Prof.Sri M. Rama Rao, Acme Learning.. .
2. Lab manual - II, of Engineering Physics by Dr. Y.Aparna and Dr. K.Venkateswara Rao (VGS Books links, Vijayawada )
CHEMISTRY LAB – II
1.PRODUCTION OF BIODIESEL.
INTRODUCTION TO BIO FUELS
The teacher has to perform the transesterfication reaction of FATTY ACID and the Biodiesel thus produced can be used for analysis.( Please give priority to production of Biodiesel from waste cooking oil)
2. Estimation of properties of oil:
a. Acid Number
b. Viscosity
c. Saponification value
d. Aniline point
e. Flash and Fire points
f. Pour and Cloud point
3.. PREPARATION OF PHENOL –FORMALDEHYDE RESIN
4. SOIL ANALYSIS:
pH, Determination of Zinc, Iron, Copper.
5.FOOD ANALYSIS:
Determination Saturated and Unsaturated Fatty Acids, pH,etc.
All the teachers are requested to focus on bio fuels ,soil analysis and food analysis as these are the need of 21 st century and these experiments are so desigened to encourage students to carry out lab to land process.
Lab Manual : Engineering chemistry laboratory manual &record By Srinivasulu . D. Parshva publications
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY KAKINADA
I B.Tech I/II Semester
IT WORKSHOP (Common to all Branches)
Objectives:
The IT Workshop for engineers is a 6 training lab course spread over 45 hours.
The modules include training on PC Hardware, Internet & World Wide Web and Productivity tools including (word processor, spread sheet, presentation sw) Word, spread sheet Excel, Power Point and Publisher.
PC Hardware Identification of basic peripherals, assembling a PC, installation of system software like MS Windows, Linux and the device drivers. Troubleshooting Hardware and software _ some tips and tricks .
Internet & World Wide Web: Different ways of hooking the PC on to the internet from home and workplace and effectively usage of the internet, web browsers, email, newsgroups and discussion forums .Awareness of cyber hygiene( protecting the personal computer from getting infected with the viruses), worms and other cyber attacks .
Productivity tools Crafting professional word documents; excel spread sheets, power point presentations and personal web sites using the Microsoft suite of office tools and LaTeX.
(Note: Student should be thoroughly exposed to minimum of 12 Tasks)
PC Hardware
Task 1: Identification of the peripherals of a computer.
To prepare a report containing the block diagram of the CPU along with the configuration of each peripheral and its functions.
Task 2(Optional) : A practice on disassemble the components of a PC and assembling them to working condition.
Task 3 : Installation of MS windows and LINUX on a PC.
Task 4 : Exposure to Basic commands and system administration in Linux including: Basic Linux commands in bash, Create hard and symbolic links.
Task 5 :
Hardware Troubleshooting (Demonstration):
Students have to be given a PC which does not boot due to improper assembly or defective peripherals. Identification of a problem and fixing it for getting to working condition.
Software Troubleshooting (Demonstration): Students have to be given a malfunctioning CPU due to system software problems. Identification of a problem and fixing it for getting to working condition.
Internet & World Wide Web
Task 6 : Orientation & Connectivity Boot Camp and surfing the Web using Web Browsers : Students should get connected to their Local Area Network and access the Internet. In the process they should configure the TCP/IP setting and demonstrate how to access the websites and email. Students customize their web browsers using bookmarks, search toolbars and pop up blockers.
Task 7: Search Engines & Netiquette : Students should know what search engines are and how to use the search engines.
A few topics would be given to the students for which they need to search on Google.
Task 8 : Cyber Hygiene (Demonstration) : Awareness of various threats on the internet. To install an anti virus software and to configure their personal firewall and windows update on their computers.
LaTeX and Word
Word Orientation : Importance of LaTeX and MS/ equivalent (FOSS) tool Word as word Processors.
Details of the four tasks and features that would be covered in each, Using LaTeX and word – Accessing, overview of toolbars, saving files, Using help and resources, rulers, format painter in word.
Task 9 : Using LaTeX and word to create project certificate. Features to be covered:-Formatting Fonts in word, Drop Cap in word, Applying Text effects, Using Character Spacing, Borders and Colors, Inserting Header and Footer, Using Date and Time option in both LaTeX and Word.
Task 10: Creating project : Abstract Features to be covered:-Formatting Styles, Inserting table, Bullets and Numbering, Changing Text Direction, Cell alignment, Footnote, Hyperlink, Symbols, Spell Check , Track Changes, Images from files and clipart, Drawing toolbar and Word Art, Formatting Images, Textboxes and Paragraphs.
Excel
Excel Orientation : The mentor needs to tell the importance of MS/ equivalent (FOSS) tool Excel as a Spreadsheet tool, give the details of the four tasks and features that would be covered in each. Using Excel –
Accessing, overview of toolbars, saving excel files, Using help and resources
Task 11 : Creating a Scheduler - Features to be covered:- Gridlines, Format Cells, Summation, auto fill, Formatting Text
LOOKUP/VLOOKUP
Task 12 : Performance Analysis - Features to be covered:- Split cells, freeze panes, group and outline, Sorting, Boolean and logical operators, Conditional formatting
LaTeX and MS/equivalent (FOSS) tool Power Point
Task 13 : Students will be working on basic power point utilities and tools which help them create basic power point presentation. Topic covered during this week includes :- PPT Orientation, Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and Numbering, Auto Shapes, Lines and Arrows, Hyperlinks, Inserting –Images, Clip Art, Tables and Charts in both LaTeX and Powerpoint.
Task 14 : Concentrating on the in and out of Microsoft power point and presentations in LaTeX. Helps them learn best practices in designing and preparing power point presentation. Topic covered during this week includes: - Master Layouts (slide, template, and notes), Types of views (basic, presentation, slide slotter, notes etc), Inserting – Background, textures, Design Templates, Hidden slides.
REFERENCES :
1 Scott Mueller’s Upgrading and Repairing PCs, 18/e, Scott. Mueller, QUE, Pearson,2008
2 The Complete Computer upgrade and repair book,3/e,Cheryl A Schmidt, Dreamtech
