Professional Development Lab Manual - New
Professional Development Lab Manual - New
MS EXCEL:
Create worksheets, insert and
format data
Work with different types of
data: text, currency, date,
numeric etc.
Split, validate, consolidate,
Convert data
Sort and filter data
Perform calculations and use
functions: (Statistical, Logical,
Mathematical, date, Time
etc.,) Work with Lookup and
reference formulae PO1,PO2,PO3,PO4,PO5,PO6,PO9
CO2 PSO1,PSO2,PSO3
Create and Work with different PO10, PO11, PO12
types of charts
Use pivot tables to summarize
and analyze data
Perform data analysis using
own formulae and functions
Combine data from multiple
worksheets using own
formulae and built-in functions
to generate results
Export data and sheets to other
file formats
Working with macros
Protecting data and Securing
2. the workbook
3. CO3 PO1,PO2,PO3,PO4,PO5,PO6,PO9 PSO1,PSO2,PSO3
MS POWERPOINT: PO10, PO11, PO12
Select slide templates, layout
and themes
Formatting slide content and
using bullets and numbering
Insert and format images,
smart art, tables, charts
Using Slide master, notes and
handout master
Working with animation and
transitions
Organize and Group slides
Import or create and use media
objects: audio, video,
animation
Perform slideshow
recording and Record
narration and create
presentable videos
Exhibit design and programming skills to build and automate business solutions using
PSO – I cutting edge technologies.
Ability to work effectively with various engineering fields as a team to design, build
PSO-III and develop system applications.
PROGRAMME OUTCOMES
Problem analysis: Identify, formulate, review research literature, and analyze complex
2 engineering problems reaching substantiated conclusions using first principles of
mathematics, natural sciences, and engineering sciences
Modern tool usage: Create, select, and apply appropriate techniques, resources, and
5 modern engineering and IT tools including prediction and modeling to complex
engineering activities with an understanding of the limitations.
The engineer and society: Apply reasoning informed by the contextual knowledge to
6 assess societal, health, safety, legal and cultural issues and the consequent responsibilities
relevant to the professional engineering practice.
8 Ethics: Apply ethical principles and commit to professional ethics and responsibilities and
norms of the engineering practice.
12 Life-long learning: Recognize the need for, and have the preparation and ability to engage
in independent and life-long learning in the broadest context of technological change.
SYLLABUS
EXPERIMENTS
MS WORD: 10 Hours
MS EXCEL: 10 Hours
RESULT:
Experiment 2: Date:
Working with Tables in MS Word
Objective: Understand how to insert, format, and manipulate tables.
Step-by-Step Instructions:
1. Open or Create a Document:
- Start with a new or existing document where you want to insert a table.
2. Insert a Table:
- Click on the "Insert" tab in the ribbon.
- Click on "Table" and then drag your cursor over the grid to select the number of rows
and columns you want.
- Release the mouse button to insert the table.
3. Format the Table:
- With the table selected, additional "Table Tools" tabs will appear in the ribbon.
- Use options in these tabs to format the table, such as changing the border style,
shading cells, adjusting alignment, and resizing rows and columns.
4. Enter Data:
- Click inside a cell and start typing to enter data into the table.
Experiment 3: Date:
Objective: Explore advanced formatting using styles, shapes, SmartArt, and charts.
Step-by-Step Instructions:
1. Apply Styles to Text: Type some text in your document.
- Select the text you want to format.
- In the Home tab, click on different styles in the "Styles" group to apply them to your
selected text.
2. Insert Shapes:
- Click on the "Insert" tab.
- Click on "Shapes" and select the shape you want to insert (e.g., rectangle, circle).
- Click and drag on the document to draw the shape.
3. Format Shapes:
- With the shape selected, additional "Drawing Tools" tabs will appear.
- Use options in these tabs to format the shape, such as changing the fill color, outline
color, and adding effects.
4. Create SmartArt:
- Click on the "Insert" tab.
- Click on "SmartArt" and choose a SmartArt graphic that fits your needs (e.g., process,
hierarchy).
- Enter text into the SmartArt shapes to describe your information.
5. Insert Charts:
- Click on the "Insert" tab.
- Click on "Chart" and select the type of chart you want to insert (e.g., column, pie,
line).
- A placeholder Excel sheet will open. Enter your data into this sheet and close it to
return to Word with your chart inserted.
6. Format Charts:
- With the chart selected, use options in the "Chart Tools" tabs to customize the chart's
design, layout, and data.
Experiment 5: Date:
Inserting Objects, Charts, and Importing Objects from Other Office Tools
Objective: Learn how to integrate objects and data from other Office tools into Word
documents.
Step-by-Step Instructions:
1. Insert Objects (e.g., Images):
- Click on the "Insert" tab.MS EXCEL
Experiment 6: Date:
7 Date:
Experiment: Date:
Create Worksheets, Insert and Format Data
Objective: Learn to create worksheets, insert data, and apply formatting in Excel.
Step-by-Step Instructions:
1. Open Excel:
- Click on the Excel icon on your desktop or find it in your Start menu.
2. Create a New Worksheet:
- Upon opening Excel, a new blank workbook will appear with one worksheet (Sheet1)
already present.
- To add more worksheets, right-click on the sheet tab (Sheet1) at the bottom left
corner of the window and select "Insert."
- Choose the number of worksheets you want to add and click "OK."
3. Insert Data:
- Click on a cell and start typing to enter data into the worksheet.
- Continue entering data across different cells as needed.
4. Format Data:
- Select the cells or range of cells you want to format.
- Use options in the Home tab such as font style, size, color, alignment, and number
formatting (currency, date, numeric).
- Explore additional formatting options in the Format Cells dialog box (right-click >
Format Cells).
8
Experiment:
Work with Different Types of Data: Text, Currency, Date, Numeric
Objective: Understand how to handle different types of data in Excel.
Step-by-Step Instructions:
1. Enter Different Types of Data:
- Type text directly into cells.
- Format cells as currency by selecting the cells and choosing the currency format from
the Number group in the Home tab.
- Enter dates by typing them in a recognizable format (e.g., mm/dd/yyyy) or use date
functions to generate dates.
- Input numeric data for calculations.
2. Apply Number Formatting:Select the cells containing numeric data.
- Click on the "Number Format" dropdown in the Home tab and choose the desired
format (e.g., General, Number, Currency, Date, etc.).
- Adjust decimal places and other formatting options as needed.
9 Date:
Experiment: Date:
Split, Validate, Consolidate, Convert Data
Objective: Learn techniques to split, validate, consolidate, and convert data in Excel.
Step-by-Step Instructions:
1. Split Data:
- Use text-to-columns feature under the Data tab to split data based on a delimiter (e.g.,
comma, space).
2. Validate Data:
- Select the cells you want to validate.
- Go to the Data tab and use Data Validation to set criteria for what can be entered into
a cell (e.g., whole numbers only, list of values).
3. Consolidate Data:
- Use the Consolidate feature under the Data tab to combine data from multiple ranges
or worksheets into one summary worksheet.
4. Convert Data:
- Convert text to columns using the Text to Columns feature under the Data tab.
- Convert dates to different date formats using custom number formats or the TEXT
function.
- Use formulas like VALUE, DATEVALUE, or functions like CONCATENATE to
convert and manipulate data.
10
Experiment: 11 Date:
Objective:
Sort and Filter Data
Understand how to sort and filter data in Excel.
Step-by-Step Instructions:
1. Sort Data:
- Select the range of cells you want to sort.
- Click on the Sort buttons in the Data tab to sort by one or multiple columns.
- Specify sorting options (e.g., ascending, descending).
2. Filter Data:
- Select the range of cells containing your data.
- Click on the Filter button in the Data tab to apply filter arrows to each column header.
- Use the filter arrows to sort or filter data based on specific criteria.
12 Date:
Experiment:
Objective:
Experiment: 12
Create and Work with Different Types of Charts
Objective: Explore creating and customizing different types of charts in Excel.
Step-by-Step Instructions:
1. Create a Chart:
- Select the data you want to include in the chart.
- Click on the Insert tab and choose the type of chart you want to create (e.g., Column,
Line, Pie).
- Excel will insert a default chart into your worksheet.
2. Customize the Chart:
- Click on the chart to select it.
- Use Chart Tools tabs (Design, Format, and Chart Tools) to customize elements such
as chart style, colors, labels, titles, and axes.
3. Switch Chart Types:
- Click on the chart to select it.
- Use the "Change Chart Type" button in the Design tab to switch to a different chart
type while retaining your data and formatting.
Experiment: 16 Date:
Objective:
Objective:
Objective:
Experiment: 19 Date:
Combine Data from Multiple Worksheets Using Own Formulas and Built-in
Functions to Generate Results
Objective: Learn to combine data from multiple worksheets in Excel.
Step-by-Step Instructions:
1. Reference Data from Another Worksheet:
- Enter a formula in a cell of the target worksheet.
- Use cell references to refer to data in another worksheet (e.g., ='Sheet2'!A1).
2. Use Built-in Functions:
- Use functions like SUM, AVERAGE, VLOOKUP across worksheets to consolidate
data.
- Utilize 3D references to perform calculations across multiple worksheets.
Experiment: 20 Date:
Objective:
Objective: Learn
Objective:
Experiment: 23 Date:
Objective: Learn
Protecting Data and Securing the Workbook
how to protect and secure data in Excel.
Step-by-Step Instructions:
1. Protect a Worksheet:
- Click on the Review tab.
- Click on "Protect Sheet."
- Enter a password (optional) and specify permissions for the protected sheet. - Click
"OK." 2. Protect the Workbook:
- Click on the File tab.
- Click on "Protect Workbook."
- Choose "Encrypt with Password" to require a password to open the workbook.
- Set permissions for sharing and editing as needed.MS PowerPoint
Experiment: 24 Date:
Objective:
Objective: Learn
Objective:
Experiment: 27 Date:
Objective:
Insert and Format Images, SmartArt, Tables, Charts
Learn how to insert and format visual elements in PowerPoint.
Step-by-Step Instructions:Insert Images:
Experiment:
Using Slide Master, Notes Master, and Handout Master
Objective: Understand how to utilize Slide Master, Notes Master, and Handout Master in
PowerPoint.
Step-by-Step Instructions:
1. Slide Master:
- Click on the View tab.
- Click on "Slide Master" to edit the master slide that controls the overall layout and
formatting of all slides in the presentation.
- Make changes to the master slide layout, such as adding placeholders for text, images,
or logos.
2. Notes Master:
- Click on the View tab.
- Click on "Notes Master" to edit the master slide layout for presentation notes pages.
- Customize the header and footer, and adjust the placement of placeholders for notes.
3. Handout Master:
- Click on the View tab.
- Click on "Handout Master" to edit the master layout for printed handouts.
- Customize the number of slides per page, header and footer, and other elements on the
handout.
Experiment: 29 Date:
Objective:
Objective:
Organize and Group Slides
Understand how to organize and group slides in PowerPoint.
Step-by-Step Instructions:
1. Organize Slides:
- Click on the View tab.
- Use the Slide Sorter view to rearrange slides by dragging them to new positions.
- Right-click on a slide thumbnail to cut, copy, paste, or delete slides.
2. Group Slides:
- Select multiple slides by holding down Ctrl and clicking on each slide thumbnail.
- Right-click on the selected slides and choose "Group" to group them together.
- Grouped slides can be moved and edited as a single unit.
Experiment: 32 Date:
Import or Create and Use Media Objects: Audio, Video, and Animation
Learn how to import or create and use media objects like audio, video, and
animation in PowerPoint.
Step-by-Step Instructions:
1. Insert Audio:
- Click on the slide where you want to insert audio.
- Go to the Insert tab and click on "Audio."
- Choose "Audio on My PC" to insert an audio file from your computer, or "Online
Audio" to search for audio online.
- Select the audio file and click "Insert."
2. Insert Video:
- Click on the slide where you want to insert video.
- Go to the Insert tab and click on "Video."
- Choose "Video on My PC" to insert a video file from your computer, or "Online
Video" to embed a video from a streaming site.
- Select the video file and click "Insert."
3. Insert Animation:
- Click on the slide object (text box, image, etc.) to which you want to apply animation.
- Go to the Animations tab and click on "Add Animation."
- Choose an animation effect (motion path, entrance, exit, emphasis) and adjust settings
using the Animation Pane.
Experiment: 33 Date:
Objective:
Perform Slideshow Recording and Record Narration and Create Presentable Videos
Objective: Understand how to record a slideshow and narrate presentations in PowerPoint.
Step-by-Step Instructions:
1. Slideshow Recording:
- Click on the Slide Show tab.
- Click on "Record Slide Show."
- Choose "Start Recording from Beginning" or "Start Recording from Current Slide."
- Speak into your microphone as you click through your slides. PowerPoint records
your voice and timing.
- To end the recording, right-click anywhere on the slide and select "End Show."
2. Record Narration:
- Click on the Slide Show tab.
- Click on "Record Slide Show."
- Check the box next to "Narrations and laser pointer."
- Choose "Start Recording from Beginning" or "Start Recording from Current Slide."
- Speak into your microphone as you click through your slides. PowerPoint records
your voice and timing along with slide transitions.
- To end the recording, right-click anywhere on the slide and select "End Show."
Experiment: 34 Date: