# I Year General Subjects & Common subjects 2

## ENGINEERING DRAWING

Subject Title                          :           Engineering Drawing
##### Subject Code                         :           107 ( Common to all Branches)
Periods/Week                        :           06
Periods Per Year                   :           180

# Major Topics

No. of  Drawing plates

# Periods

### Questions

1
Importance of Engineering Drawing
--
01
-
-
-
2
Engineering Drawing Instruments
01
05
-
-
-
3
Free hand lettering & Numbering
01

06
5
1
-
4
Dimensioning Practice
01
09
5
1
-
5
Geometrical Constructions
03
21
15
1
1
6
Projection of points, Lines, Planes & Solids
03
21
10
-
1
7
Auxiliary views
01
06
5
1
-
8
Sectional views
04
27
10
-
1
9
Orthographic Projection
04
33
10
-
1
10
Pictorial drawing
04
30
10
-
1
11
Development of surfaces
03
21
10
-
1
Total
25
180
80
04
06

The course is aimed at developing basic graphic skills so as to enable them to use these skills in preparation of engineering drawings, their reading and interpretation

Pre-Requisite: Clear visualization and sound pictorial intelligence

OBJECTIVES
###### Upon completion of the subject the student shall be able to

1.0       Understand the basic concepts of Engineering Drawing
1.1       State the importance of drawing as an engineering communication
medium
1.2       State the necessity of B.I.S. Code of practice for Engineering Drawing.
1.3        Explain the linkages between Engineering drawing and other subjects of
study in diploma course.
2.0       Use of Engineering Drawing Instruments
2.1       Select the correct instruments and draw lines of different orientation.
2.2       Select the correct instruments and draw small and large Circles.
2.3       Select the correct instruments for measuring distances on the drawing.
2.4       Use correct grade of pencil for different types of lines, thickness and
given function.
2.5       Select and use appropriate scales for a given application.
2.6       Identify different drawing sheet sizes as per I.S. and Standard Lay- outs.
2.7       Prepare Title block as per B.I.S. Specifications.
2.8       Identify the steps to be taken to keep the drawing clean and tidy.

Drawing Plate 1: (Having two exercises)

3.0       Write Free Hand Lettering and Numbers
3.1  Write titles using slanting letters and numerals of 7mm, 10mm and 14mm height
3.2  Write titles using vertical letters and numerals of 7mm, 10mm and 14mm height
3.3  Select suitable sizes of lettering for different layouts and applications
3.4  Practice the use of lettering stencils.

Drawing plate 2: (Having 5 to 6 exercises)

4.0       Understand Dimensioning Practice
4.1       Define “Dimensioning.
4.2                   State the need of dimensioning the drawing according to accepted standards.
4.3       Identify notations of Dimensioning used in dimensioned drawing.
4.4       Identify the system of placement of dimensions in the given
dimensioned drawing.
4.5       Dimension a given drawing using standard notations and desired
system of dimensioning.
4.6       Dimension standard features applying necessary rules.
4.7       Arrange dimensions in a desired method given in the drawing.
4.8       Identify the departures if any made in the given dimensioned drawing
with reference to SP-46-1988, and dimension the same correctly.

Drawing Plate 3: (Having 08 to10 exercises)

5.0       Apply Principles of Geometric Constructions
5.1       Divide a given line into desired number of equal parts internally.
5.2       Draw tangent lines and arcs.
5.3       Use General method to construct any polygon.
5.4       Explain the importance of conics
5.5       Construct conics (ellipse, parabola and hyperbola) by general method
5.6       Construct ellipse by concentric circles method
5.7      Construct parabola by rectangle method
5.8       Construct rectangular hyperbola from the given data.
5.9       Construct involute from the given data.
5.10 Construct cycloid  and helix from the given data.
5.11     State the applications of the above constructions in engineering practice.
Drawing Plate -4: Having problems up to construction of polygon
Drawing Plate -5: Having problems of construction of conics
Drawing Plate -6: Having problems of construction of involute, cycloid and helix

6.0       Apply Principles of Projection of points, lines, planes & solids
6.1       Visualize the objects
6.2       Explain the I-angle and III-angle projections
6.3       Practice the I-angle projections
6.4       Draw the projection of a point with respect to reference planes (HP&VP)
6.5       Draw the projections of straight lines with respect to two reference
Planes (up to lines parallel to one plane and inclined to other plane)
6.6       Draw the projections of planes (up to planes   perpendicular to one plane and inclined to other plane)
6.7       Draw the projections of solids (up to axis of solids parallel to one plane and inclined to other plane)

Drawing Plate -7: Having problems up to projection of points and Lines (15 exercises)
Drawing Plate -8: Having problems of projection of planes (6 exercises)
Drawing Plate -9: Having problems of projection of solids (10 exercises)

7.0       Understand the need of auxiliary views
7.1    State the need of Auxiliary views for a given engineering drawing.
7.2    Draw the auxiliary views of a given engineering component
7.3    Differentiate between auxiliary view and apparent view

Drawing plate No.10: (Having 4 exercises)

8.0       Appreciate the need of Sectional Views
8.1     Explain the need to draw sectional views.
8.2     Select the section plane for a given component to reveal maximum
information.
8.3    Explain the positions of section plane with respect to reference planes
8.4     Differentiate between true shape and apparent shape of section
8.5     Draw sectional views and true sections of regular solids discussed in 6.0
8.6     Apply principles of hatching.

Drawing Plate–11: Having problems of section of solids (6 exercises)

9.0      Apply principles of orthographic projection
9.1   Explain the principles of orthographic projection with simple
sketches.
9.2   Draw the orthographic view of an object from its pictorial drawing.
9.3   Draw the minimum number of views needed to represent a given
object fully.
Drawing Plate 12 : (Having 10 to 12 exercises)

10.0     Prepare pictorial drawings
10.1     State the need of pictorial drawings.
10.2     Differentiate between isometric scale and true scale.
10.3     Prepare Isometric views for the given orthographic drawings.
Drawing plate 13: (Having 10 to 12 exercises)
11.0     Interpret Development of surfaces of different solids
11.1     State the need for preparing development drawing.
11.2     Prepare development of simple engineering objects (cubes, prisms, cylinders, cones, pyramids) using parallel line and radial line methods.
11.3     Prepare development of surface of engineering components like trays,
funnels, 900 elbows & rectangular ducts.
Drawing plate No. 14:  (Having 05 exercises)

KEY competencies to be achieved by the student
 S.No List of Practical Key Competency 1. Importance of Engineering Drawing Explain the linkages between Engineering drawing and other subjects of study in Diploma course. 2. Engineering Drawing Instruments Select the correct instrument to draw various entities in different orientation 3. Free hand lettering & Numbering Write titles using slanting and vertical letters and numerals as per B.I.S (Bureau  of Indian standards) 4. Dimensioning Practice Dimension a given drawing using standard notations and desired system of dimensioning. 5. Geometrical constructions Construct ellipse, parabola, rectangular hyperbola, involute, cycloid and helix from the given data. 6. Projection of Points, Lines, Planes & Solids Draw the projection of a point, straight lines, planes & solids with respect to reference planes (HP& VP) 7. Auxiliary views Draw the auxiliary views of a given Engineering component Differentiate between Auxiliary view and apparent view 8. Sectional views Differentiate between true shape and apparent shape of a section. Use conventional representation of Engineering materials as per B.I.S. Code. Apply principles of hatching. Draw simple sections of regular solids. 9. Orthographic Projection Draw the minimum number of views needed to represent a given object fully. 10. Pictorial drawing Differentiate between isometric scale and true scale. Draw the isometric views of given object. 11. Development of surfaces ·        Prepare development of Surface of             Engineering components like trays,             funnels, 900 elbows & rectangular ducts.

COURSE CONTENT
NOTE
1.        B.I.S Specifications should invariably be followed in all the topics.
2.        A-3 Size Drawing Sheets are to be used for all Drawing Practice Exercises.

1.0       The importance of Engineering Drawing
Explanation of the scope and objectives of the subject of Engineering Drawing, Its importance as a graphic communication -Need for preparing drawing as per standards – SP-46–1988 – Mention B.I.S - Role of drawing in engineering education – Link between Engineering drawing and other subjects of study.

2.0       Engineering drawing Instruments
Classification: Basic tools, tools for drawing straight lines, tools for curved lines, tools for measuring distances and special tools like mini drafter & drafting machine – Mention the  names under each classification and their brief description -Scales: Recommended scales reduced & enlarged scales-Lines: Types of lines, selection of line thickness - Selection of Pencils -Sheet Sizes: A0, A1, A2, A3, A4, A5, Layout of drawing sheets in respect of A0, A1, A3 sizes, Sizes of the Title block and its contents - Care and maintenance of Drawing Sheet, Drawing plate:
Lay out of sheet – as per SP-46-1988 to a suitable scale.
Simple Exercises on the use of Drawing Instruments. Importance of Title Block.

3.0       Free hand lettering & numbering
Importance of lettering – Types of lettering -Guide Lines for Lettering-
Practicing  letters & numbers of given sizes (7mm, 10mm and 14mm)
Advantages of single stroke or simple style of lettering - Use of lettering stencils

4.0       Dimensioning practice
Purpose of engineering Drawing, Need of B.I.S code in dimensioning -Shape
description of an Engineering object -Definition of Dimensioning size
description -Location of features, surface finish, fully dimensioned Drawing -
Notations or tools of dimensioning, dimension line, extension line, leader line,
arrows, symbols, number and notes, rules to be observed in the use of above
tools -Placing dimensions: Aligned system and unidirectional system ( SP-46-
1988)-Arrangement of dimensions Chain, parallel, combined, progressive, and
dimensioning by co-ordinate methods-The rules for dimensioning standard
features “Circles (holes) arcs, angles, tapers, chamfers, and dimensioning of
narrow spaces.

5.0       Geometric Constructions
Division of a line: to divide a straight line into given number of equal parts
Internally and it’s examples in engineering applications.
Construction of tangent lines: to draw tangent lines touching circles
internally and externally.
Construction of tangent arcs
i) To draw tangent arc of given radius to touch two lines inclined at given
angle (acute, right and obtuse angles).
ii)Tangent arc of given radius touching a circle or an arc and a given line.
iii)Tangent arcs of radius R, touching two given circles internally and
externally.
Construction of polygon: Construction of any regular polygon of given side length using general method.

Conical Curves: Explanation of Ellipse, Parabola, Hyperbola, as sections of a
double cone and  loci of a moving point, Eccentricity of above curves – Their
Engg. applications viz.   Projectiles, reflectors, P-V Diagram of a
Hyperbolic process,
Construction of any conic section of given eccentricity by general method
Construction of ellipse by concentric circles method
Construction of parabola by rectangle method
Construction of rectangular hyperbola
General Curves: Involute, Cycloid and Helix, explanations as locus of a
moving point, their engineering applications, viz, Gear tooth profile, screw
threads, springs etc. - their construction.

6.0       Projection of points, lines, planes & solids.
Projecting a point on two planes of projection -Projecting a point on three
planes of projection -Projection of straight line
(a)   Parallel to both the planes.
(b)   Perpendicular to one of the planes.
(c)   inclined to one plane and parallel to other planes
Projection of regular planes
(a)  Plane perpendicular to HP and parallel to VP and vice versa.
(c)  Plane perpendicular to HP and inclined to VP and vice versa.

Projection of regular solids
(a)   Axis perpendicular to one of the  planes
(b)   Axis parallel to VP and inclined to HP and vice versa.

7.0       Auxiliary views
Need for drawing auxiliary views -Explanation of the basic principles of
drawing  auxiliary views, explanation of reference plane and auxiliary plane -
Partial auxiliary view.

8.0       Sectional views
Need for drawing sectional views – what is a sectional view - Location of cutting plane – Purpose of cutting plane line – Selection of cutting plane to give maximum information (vertical and offset planes) - Hatching – Section of regular solids  inclined to one plane and parallel to other plane.

9.0       Orthographic Projections
Meaning of orthographic projection -Using a viewing box and a model – Number of views obtained on the six faces of the box, - Legible sketches of only 3 views for describing object -Concept of front view, top view, and side view, sketching these views for  number of engg objects - Explanation of first angle projection. – Positioning of three views in First angle projection -      Projection of points as a means of locating the corners of the surfaces of an object – Use of miter line in drawing a third view when other two views are given -Method of representing hidden lines -Selection of minimum number of views to describe an object fully.

10.0     Pictorial Drawings
Brief description of different types of pictorial drawing viz., Isometric, oblique,
and perspective and their use - Isometric drawings: Iso axis, angle between
them, meaning of  visual distortion in dimensions - Need for an isometric scale, difference between Isometric scale, and  ordinary scale- difference between Isometric  view and Isometric projection - Isometric and Non-isometric lines -Isometric drawing of  common features like rectangles, circular  shapes, non-isometric lines - Use of box and offset methods.

11.0     Development of Surfaces
Need for preparing development of surface with reference to sheet metal work
-Concept of true length of a line with reference to its orthographic
projection when the line is (i) parallel to the plane of projection (ii)  inclined to one principal and parallel to the other -Development of simple  solids like cubes, prisms, cylinders, cones, pyramids (sketches only) -Types of development: Parallel line and radial line development -Procedure of drawing development, drawings of trays, funnels, 90elbow pipes and rectangular ducts.

REFERENCE BOOKS

Engineering Graphics by P I Varghese – ( McGraw-hill)
Engineering Drawing by  Basant  Agarwal & C.M Agarwal - ( McGraw-hill)
Engineering Drawing by  N.D.Bhatt.
T.S.M. & S.S.M on “ Technical Drawing” prepared by T.T.T.I., Madras.
SP-46-1998 – Bureau of Indian Standards.

PHYSICS LAB PRACTICE

Subject Title                          :           Physics Lab Practice
Subject Code                         :           Common -109 A
Periods per week                 :           03
Total periods per year          :           45

TIME SCHEDULE
 S.No Name of the Experiment No. of Periods 1. Hands on practice on Vernier Calipers 03 2. Hands on practice on Screw gauge 03 3. Verification of Parallelogram law of forces and Triangle law of forces 03 4. Simple pendulum 03 5. Velocity of sound in air – (Resonance method) 03 6. Focal length and Focal power of convex lens (Separate & Combination) 03 7. Refractive index of solid using traveling microscope 03 8. Surface tension of liquid using traveling microscope 03 9. Coefficient of viscosity by capillary method 03 10. Boyle’s law verification 03 11. Meter bridge 03 12. Mapping of magnet lines of force 03 Revision 06 Test 03 Total: 45

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

1.0      Practice the Vernier caliper to determine the volume of a cylinder and sphere
2.0      Practice the Screw gauge to determine thickness of a glass plate and cross section
of a wire
3.0      Verify the parallelogram law and Triangle law
4.0      Determine the value of acceleration due to gravity using Simple Pendulum
5.0      Determine the velocity of sound in air at room temperature
6.0      Determine the Focal length and focal power of convex lenses using U-V method
7.0      Determine the refractive index of a solid using travelling microscope
8.0      Determine the surface tension of a liquid using travelling microscope
9.0      Determine the viscosity of a liquid using capillary method
10.0    Verify the Boyle’s law employing a Quill tube
11.0    Determine the specific resistance of wire material using Meter Bridge
12.0    Practice the mapping of magnetic lines of force
Competencies and Key competencies to be achieved by the student

 Name of the Experiment Competencies Key competencies 10. Boyle’s law verification (03) Note the atmospheric  pressure Fix the quill tube to retort stand Find the length of air column Find the pressure of enclosed air Find  and compare the calculated value P x l Find the length of air column Find the pressure of enclosed air Find the value P x l 11. Meter bridge(03) Make the circuit connections Find the balancing length Calculate unknown resistance Find the radius of wire Calculate the specific resistance Find the balancing length Calculate unknown resistance Calculate the specific resistance 12. Mapping of magnet lines of       force(03) Draw magnetic meridian Placed the bar magnet in NN and NS directions Draw magnetic lines of force Locate the neutral points along equatorial and axial lines ·                   Draw magnetic lines of       force ·                   Locate the neutral points       along equatorial and       axial lines

Chemistry LAB PRACTICE

Subject Title                          :           Chemistry Lab Practice
Subject Code                         :           Common  -109 B
Periods per week                 :           03
Total periods per year          :           45

TIME SCHEDULE
S.No
Name of the Experiment
No. of Periods
1.
Familiarization of methods for Volumetric analysis

03

2.
Preparation of Std Na2 CO3 and making solutions of different dilution solution.

03
3.
Estimation of HCl solution   using Std.   Na2 CO3 solution
03
4.
Estimation of NaOH using Std. HCl solution
03
5.
Estimation of  H2SO4  using Std. NaOH solution
03
6.
Estimation of Mohrs Salt  using Std. KMnO4
03
7.

 4

Determination of acidity of water sample
03
8.
Determination of alkalinity of water sample
03
9.
Determination of total hardness of water using Std. EDTA solution
03
10.
Estimation of Chlorides present in water sample
03
11.
Estimation of Dissolved Oxygen (D.O) in water sample
03
12.
Determination of pH using pH meter
03
13.
Determination of conductivity of water and adjusting ionic strength  required level.
03
14.
Determination of turbidity of water
03
15.
Estimation of total solids present in water sample
03

Total:
45

Objectives:

Upon completion of the course the student shall be able to

1.0       Practice volumetric measurements (using pipettes, measuring jars, volumetric flask, burettes) and gravimetric measurements (using different types of balances), making dilutions, etc.
2.0       Practice making standard solutions with pre weighed salts and to make solutions of desired dilutions using appropriate techniques.
3.0       Conduct titrations adopting standard procedures and using Std. Na2 CO3 solution for estimation of HCl
4.0       Conduct titrations adopting standard procedures and using Std. HCl solution for estimation of NaOH
5.0       Conduct titrations adopting standard procedures and using Std. NaOH solution for estimation of H2SO4
6.0     Conduct titrations adopting standard procedures and using Std. KMnO4 solution for estimation of Mohrs Salt
7.0       Conduct titrations adopting standard procedures to determine the acidity of given samples of water (One ground water and one surface / tap water, and rain water if available)
8.0       Conduct titrations adopting standard procedures to determine the alkalinity of given samples of water (One ground water and one surface / tap water)
9.0       Conduct titrations adopting standard procedures to determine the total hardness of given samples of water (One ground water and one surface / tap water) using Std. EDTA solution
10.0     Conduct titrations adopting standard procedures to determine the chlorides present in the given samples of water and wastewater (One ground water and one surface / tap water)
11.0     Conduct the test using titrometric / electrometric method to determine Dissolved Oxygen (D.O) in given water samples (One sample from closed container and one from open container / tap water)
12.0     Conduct the test on given samples of water / solutions (like soft drinks, sewage, etc.) to determine their pH using standard pH meter
13.0     Conduct the test on given samples of water / solutions
a)         To determine conductivity
b)         To adjust the ionic strength of the sample to the desired value
14.0     Conduct the test on given samples of solutions (coloured and non coloured) to determine their turbidity in NTU
15.0     Conduct titrations adopting standard procedures to determine the total solids present in given samples of water (One ground water and one surface / tap water)

Competencies and Key competencies to be achieved by the student

Name of the Experiment
(No of Periods)
Competencies
Key competencies
Familiarization of methods for Volumetric analysis  (03)

--
--
Preparation of Std Na2 CO3 and making solutions of different dilution (03)
§  Weighing the salt to the accuracy of .01 mg
§  Measuring  the water with volumetric flask, measuring jar, volumetric pipette and graduated pipette
§  Making appropriate dilutions
§  Weighing the salt to the accuracy of .01 mg
§  Measuring  the water with volumetric flask, measuring jar, volumetric pipette and graduated pipette
§  Making appropriate dilutions
Name of the Experiment
(No of Periods)
Competencies
Key competencies
Estimation of HCl solution   using Std.   Na2 CO3 solution  (03)
§ Cleaning the glassware and rinsing with appropriate solutions
§ Making standard solutions
§ Measuring accurately the standard solutions and titrants
§ Filling the burette with titrant
§ Fixing the burette to the stand
§ Effectively Controlling the flow of the titrant
§ Identifying the end point
§ Making accurate observations
§ Calculating the results

§ Making standard solutions
§ Measuring accurately the standard solutions and titrants
§ Effectively Controlling the flow of the titrant
§ Identifying the end point
§ Making accurate observations
Estimation of NaOH using Std. HCl solution  (03)
Estimation of  H2SO4  using Std. NaOH solution  (03)
Estimation of Mohrs Salt  using Std. KMnO4  (03)

 4

Determination of acidity of water sample  (03)
Determination of alkalinity of water sample  (03)
Determination of total hardness of water using Std. EDTA solution  (03)
Estimation of Chlorides present in water sample  (03)
Estimation of Dissolved Oxygen (D.O) in water sample (By titration method)  (03)
Estimation of Dissolved Oxygen (D.O) in water sample (By electrometric method)  (03)
§ Familiarize with instrument
§ Choose appropriate ‘Mode’ / ‘Unit’
§ Prepare standard solutions / buffers, etc.
§ Standardize the instrument with appropriate standard solutions
§ Plot the standard curve
§ Make measurements accurately

§ Prepare standard solutions / buffers, etc.
§ Standardize the instrument with appropriate standard solutions
§ Plot the standard curve
§ Make measurements accurately
Determination of pH using pH meter  (03)
Determination of conductivity of water and adjusting ionic strength to required level  (03)
Determination of turbidity of water  (03)
Name of the Experiment
(No of Periods)
Competencies
Key competencies
Estimation of total solids present in water sample  (03)
§  Measuring the accurate volume and weight of sample
§  Filtering and air drying without losing any filtrate
§  Accurately weighing the filter paper, crucible and filtrate
§  Drying the crucible in an oven

§  Measuring the accurate volume and weight of sample
§  Filtering and air drying without losing any filtrate
§  Accurately weighing the filter paper, crucible and filtrate

##### COMPUTER FUNDEMENTALS LAB PRACTICE
(Common to all Branches)
Subject Title                 : Computer Fundamentals Laboratory Practice
Subject Code               : Common-110
Periods/Week               : 03
Periods/Year                : 90
 S. No. Major Topics No. of sessions  each of 3 periods duration No. of Periods I. Computer hardware Basics 01 03 II. Windows Operating System 02 06 III. MS Word 09 27 IV. MS Excel 09 27 V. MS PowerPoint 09 27 Total 30 90

Time Schedule

Rationale:  The knowledge of Computer usage has become a must for everyone, due to wide spread computer usage and related applications in all fields. This laboratory is designed to give the students hands on practice of Windows Operating System and MS Office to enable the students to use these skills in future courses.

I.  Computer Hardware Basics (Not for end examination)
1.   a) To familiarize with a Computer System and its hardware connections.
b) To Start and Shutdown a Computer correctly.
c) To check the software details of the computer
2.   To check the hardware present in your computer
II. Windows’s operating system (Not for end examination)
3. To Explore Windows Desktop
4.  Working with Files and Folders
III. Practice with MS-WORD
6. To familiarize with Ribbon layout of MS Word
Home - Insert - Page layout – References – Review - View
7. To practice Word Processing Basics
8. To practice Formatting techniques
9. To insert a table of required number of rows and columns
10. To insert Objects, Clipart and Hyperlinks
11. To use Mail Merge feature of MS Word
12. To use Equations and symbols features
IV. Practice with MS-EXCEL
13. To familiarize with MS-EXCEL layout
14. To access and Enter data in the cells
15. To edit a spread sheet- Copy, Cut, Paste, and selecting Cells
16. To use built in functions and Formatting Data
17. To create Excel Functions, Filling Cells
18. To enter a Formula for automatic calculations
19. To practice Excel Graphs and Charts
20. To format a Worksheet in Excel, Page Setup and Print
V. Practice with MS-POWERPOINT
21. To familiarize with Ribbon layout features of PowerPoint 2007.
22. To create a simple PowerPoint Presentation
23. To set up a Master Slide in PowerPoint
24. To insert Text and Objects
25. To insert a Flow Charts
26. To insert a Table
27. To insert a Charts/Graphs
28. To insert video and audio
29. To practice Animating text and objects
30. To Review presentation

Competencies and Key Competencies to be achieved by the students

 Exp No. Name of the Experiment Competencies Key Competencies Working with Files and Folders Continued.... c.   Arrange icons – name wise, size, type, Modified d.   Search a  file or folder and find its path e.   Create shortcut for files and folders (in other folders) on Desktop f.    Familiarize with the   use of My Documents g.   Familiarize with the   use of Recycle Bin b.  Restore deleted files from Recycle bin 5. To use Windows Accessories: Calculator – Notepad – WordPad – MS Paint a.   Familiarize with the use of   Calculator b.   Access  Calculator using  Run  command c.   Create Text Files using Notepad and  WordPad and observe the difference in file size d.   Use MS paint and  create .jpeg, .bmp files using MS Paint a.  Use windows accessories and select correct text editor based on the situation. b.  Use MS Paint to create /Edit pictures and save in the required format. 6. To familiarize with Ribbon layout of MS Word. –  Home – Insert- Page Layout- References-Review-View a.   Create/Open a document b.   Use Save and Save as features c.   Work on two documents simultaneously d.   Choose correct  Paper size and Printing options a.  Create a Document and name appropriately and save b.  Set paper size and print options 7. To practice Word Processing Basics a.   Typing text b.   Keyboard usage c.   Use mouse (Left click / Right click / Scroll) d.   Use Keyboard shortcuts e.   Use  Find and Replace  features in MS- word f.    Use Undo and Redo Features g.   Use spell check to correct  Spellings and Grammar a.  Use keyboard and mouse to enter/edit text in the document. b.  Use shortcuts c.  Use spell check/ Grammar features for auto corrections. 8. To practice Formatting techniques a.   Formatting Text b.   Formatting Paragraphs c.   Setting Tabs d.   Formatting Pages e.   The Styles of Word f.    Insert bullets and numbers g.   Themes and Templates h.   Insert page numbers, header and footer a.  Format Text and paragraphs and use various text styles. b.  Use bullets and numbers to create lists c.  Use Templates /Themes d.  Insert page numbers date, headers and footers

 Exp No. Name of the Experiment Competencies Key Competencies 9. To insert a table of required number of rows and columns a.   Edit the table by adding the fields – Deleting rows and columns –inserting sub table –marking borders. Merging and splitting of cells in a Table b.   Changing the background colour of the table c.   Use table design tools d.   Use auto fit – fixed row/ column height/length – Even  distribution of rows / columns features e.   Convert Text to table and Table to Text f.    Use Sort feature of  the Table to arrange data in ascending/descending order a.  Insert table in the word document and edit b.  Use sort option  for arranging data. 10. To Insert objects, clipart and Hyperlinks a.   Create a 2-page document. &Insert hyperlinks and Bookmarks. b.   Create an organization chart c.   Practice examples like preparing an Examination schedule notice with a hyperlink to Exam schedule table. a.   Insert hyperlinks &Bookmarks b.   Create organization charts/flow charts 11. To Use Mail merge feature of MS Word a.   Use mail merge to prepare individually addressed letters b.   Use mail merge to print envelopes. Use Mail merge feature 12. To use Equations and symbols features. a.  Explore various symbols available in MS Word b.  Insert a symbol in the text c.  Insert mathematical equations in the document Enter Mathematical symbols and Equations in the word document 13. To Practice with MS-EXCEL a.   Open /create an MS Excel spreadsheet and  familiarize with MS Excel 2007 layout like MS office  Button- b.   Use Quick Access Toolbar- Title Bar- Ribbon-Worksheets- Formula Bar-Status Bar a.  Familiarize with excel layout  and use b.  Use various features available in toolbar 14. To access and Enter data in the cells a.   Move around a Worksheet- Quick access -Select Cells b.   Enter Data-Edit a Cell-Wrap Text-Delete a Cell Entry-Save a File-Close Excel a.  Access and select the required cells by various addressing methods b.  Enter data and edit
 Exp No. Name of the Experiment Competencies Key Competencies 15. To edit  spread sheet Copy, Cut, Paste, and selecting cells a.   Insert and Delete Columns and Rows-Create Borders-Merge and Center b.   Add Background Color-Change the Font, Font Size, and Font Color c.   Format text with Bold, Italicize, and Underline-Work with Long Text-Change a Column's Width Format the excel sheet 16. To use built in functions and Formatting Data a.   Sort and filter data in a worksheet b.   Perform Mathematical Calculations verify -AutoSum c.    Perform Automatic Calculations-Align Cell Entries Use built in functions in Excel 17. To enter a Formula for automatic calculations a.   Enter formula b.   Use Cell References in Formulae c.   Use Automatic updating function of Excel Formulae d.   Use Mathematical Operators in Formulae e.   Use Excel Error Message and  Help Enter formula for automatic calculations 18. To Create Excel Functions, Filling Cells a.   Use Reference Operators b.   Work with  sum, Sum if , Count and  Count If  Functions c.   Fill Cells Automatically a.  Create Excel sheets involving cross references and equations b.  Use the advanced functions for conditional calculations 19. To Practice Excel Graphs and Charts a.   Produce an Excel Pie Chart b.   Produce an Excel Column Chart c.   Practice creating any Chart a.  Use data in   Excel sheet to Create technical charts and graphs Produce Excel Line Graph b.  Produce a Pictograph in Excel 20. To format a Worksheet in Excel, page setup and print a.   Shade alternate rows of data b.   Add currency and percent symbols c.   Change height of a row and width of a column d.   Change data alignment e.   Insert Headers and Footers f.    Set Print Options and Print a.  Format Excel sheet b.  Insert headers &footers  and print 21. To familiarize with Ribbon layout &features of PowerPoint 2007. Use various options in Home, insert, design, animation , slideshow, Review &View in the PowerPoint Access required options in the tool bar

 Exp No. Name of the Experiment Competencies Key Competencies 22. To create a simple PowerPoint Presentation a.   Insert a New Slide into PowerPoint b.   Change the Title of a PowerPoint Slide c.   PowerPoint Bullets d.   Add an Image to a PowerPoint Slide e.   Add a Textbox to a PowerPoint slide a.  Create simple PowerPoint presentation with photographs/ClipArt and text boxes b.  Use bullets option 23. To Set up a Master Slide in PowerPoint and add notes a.   Create a PowerPoint Design Template b.   Modify themes c.   Switch between Slide master view and Normal view d.    Format a Design Template Master Slide e.    Add a Title Slide to a Design Template f.    The Slide Show Footer in PowerPoint f.    Add Notes to a PowerPoint Presentation a.  Setup Masterslide and format b.  Add notes 24. To Insert Text and Objects a.   Insert Text and objects b.   Set Indents and line spacing c.   Insert  pictures/ clipart d.   Format pictures e.   Insert shapes and WordArt f.    Use 3d features g.   Arrange objects Inset Text and Objects Use 3d features 25. To insert a Flow Chart / Organizational Charts a.   Create a Flow Chart in PowerPoint b.   Group and Ungroup Shapes c.   Use smart art Create organizational charts and flow charts using smart art 26. To insert a Table a.   PowerPoint Tables b.   Format the Table Data c.   Change Table Background d.   Format Series Legend Insert tables and format 27. To insert a Charts/Graphs a.   Create 3D Bar Graphs in PowerPoint b.   Work with the PowerPoint Datasheet c.   Format a PowerPoint Chart Axis d.   Format the Bars of a Chart e.   Create PowerPoint Pie Charts f.    Use Pie Chart Segments g.   Create 2D Bar Charts in PowerPoint h.   Format the 2D Chart e.   Format a Chart Background Create charts and Bar graphs, Pie Charts and format.

 Exp No. Name of the Experiment Competencies Key Competencies 28. To  Insert audio &video, Hyperlinks  in a slide Add narration to the slide a.    Insert sounds in the slide and hide the audio symbol b.   Adjust the volume in the settings c.    Insert video file in the format supported by PowerPoint in a slide d.   Use automatic and on click options e.    Add narration to the slide f.    Insert Hyperlinks a.     Insert Sounds and Video in appropriate format. b.     Add narration to the slide c.     Use hyperlinks to switch to different slides and files 29. To Practice Animation effects a.    Apply transitions to slides b.   To explore and practice special animation  effects like Entrance, Emphasis, Motion Paths &Exit Add animation effects 30. Reviewing presentation a.   Checking spelling and grammar b.   Previewing presentation c.   Set up slide show d.   Set up resolution e.   Exercise with Rehearse Timings feature in PowerPoint f.    Use PowerPoint Pen Tool during slide show g.   Saving h.   Printing presentation (a) Slides (b) Handout a.      Use Spell check and Grammar feature b.      Setup slide show c.      Add timing to the slides d.      Setup automatic slide show

Labels: