CHANDIGARH UNIVERSITY Institute of Distance and Online Learning Course Development Committee Prof. (Dr.) R.S.Bawa Pro Chancellor, Chandigarh University, Gharuan, Punjab Advisors Prof. (Dr.) Bharat Bhushan, Director – IGNOU Prof. (Dr.) Majulika Srivastava, Director – CIQA, IGNOU Programme Coordinators & Editing Team Master of Business Administration (MBA) Bachelor of Business Administration (BBA) Coordinator – Dr. Rupali Arora Coordinator – Dr. Simran Jewandah Master of Computer Applications (MCA) Bachelor of Computer Applications (BCA) Coordinator – Dr. Raju Kumar Coordinator – Dr. Manisha Malhotra Master of Commerce (M.Com.) Bachelor of Commerce (B.Com.) Coordinator – Dr. Aman Jindal Coordinator – Dr. Minakshi Garg Master of Arts (Psychology) Bachelor of Science (Travel &TourismManagement) Coordinator – Dr. Samerjeet Kaur Coordinator – Dr. Shikha Sharma Master of Arts (English) Bachelor of Arts (General) Coordinator – Dr. Ashita Chadha Coordinator – Ms. Neeraj Gohlan Academic and Administrative Management Prof. (Dr.) R. M. Bhagat Prof. (Dr.) S.S. Sehgal Executive Director – Sciences Registrar Prof. (Dr.) Manaswini Acharya Prof. (Dr.) Gurpreet Singh Executive Director – Liberal Arts Director – IDOL © No part of this publication should be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording and/or otherwise without the prior written permission of the authors and the publisher. SLM SPECIALLY PREPARED FOR CU IDOL STUDENTS Printed and Published by: TeamLease EdtechLimited www.teamleaseedtech.com CONTACT NO:01133002345 For: CHANDIGARH UNIVERSITY Institute of Distance and Online Learning
OFFICE AUTOMATION LAB Course Code: 21BCA105 Credit: 4 Course Objectives: 1. To provide knowledge of text formatting. 2. To make students familiar with data representation ways. 3. To equip students with ways of text representation. EXPERIMENT 1 ADDING TEXT, EDITING TEXT, FINDING AND REPLACING TEXT, FORMATTING TEXT, CHARACTER/LINE/PARAGRAPH SPACING, WORKING WITH STYLES AND TEXT INDENTATION. 1. Adding text 1. Go to the Startmenu 2. Click on the Microsoft Word icon to open the Microsoft Word 3. Click on the blank document 4. A blinking cursor or insertion point will appear in the text area below the ribbon 5. Now, start typing and the words will appear on the screen in the text area *In below screen added text Office Automation LAB
2. Editing text 1.Select the text you want to replace. • To select a single word, double-click it. • To select a line, click to the left of it. *below screen select word LAB 2. Enter the new word. *below screen edited LAB to Practical
3. Finding And Replacing Text 1. Find 1.Click the Home tab 2.Click the Editing icon and then click the Find command. The Find and Replace dialog box appears. 3.Click in the Find What text box 4.Type a word or phrase to find.
2.Replace 1. Click the Editing icon and then click the Replace command. The Find and Replacedialog box appears. 2. Enter your new text in the Replace box. 3. Select Find Next until you come to the word you want to update. 4. Choose Replace. To update all instances at once, choose Replace All. 5. To specify only upper or lowercase in your search, select More > Matchcase. Word Practical is Replaced with LAB
4. Formatting Text 1. Select the text want to format. 2. Select an option to change the font, font size, font colour, or make the text bold, italics, or underline.
5. Character/Line/Paragraph Spacing 1. Select the text want to format. 2.On the Home tab, click the Line and Paragraph pacing command. A drop-down menu will
appear. 3. Move the mouse over the various options. A live preview of the line spacing will appear in the document. Select the line spacing you want to use.
4.The line spacing will change in the document. *Text is appearing in the middle of the screen after changing the alignment 6. Working With Styles And Text Indentation 1. To underline the text do as follow 1. Select the desired text. 2. Click on the “U” button in the ribbon. (if it doesn’t exist, click the “Home” tab on the ribbon, and you will find it in the “Font” group).
2. Changing the size of the font (the text): 1. Select the desired text. 2. Move the mouse cursor towards the mini toolbar, and it will become active. If the mini toolbar doesn’t appear, right click inside the selected area, and it will appear. 3. Clicking the “A” buttons repeatedly will make the font gradually bigger or smaller. 4. Font to a specific size can be set by opening the drop down menu, and choosing the desired size. The numbers in the menu represent the font size by pixel units. 3. Applying the font type: 1. Select the desired text. 2. Open the fontsdrop down menu in the mini toolbar, and choose the font type.
4. Applying colour to the text 1. Select the desired text 2. Click the small arrow next to the A button in the mini toolbar. An array of colors appears. Choose one by clicking it. 3. Cancel the selection by clicking somewhere, to see the color on the white background.
5. First-line indent 1. Put the cursor anywhere in the paragraph. 2. On the Home tab, right-click the Normal style, and choose Modify. 3. Select Format, and then choose Paragraph. 4. On the Indents and Spacing tab, under Indentation, select First line.
5. Select OK.
EXPERIMENT 2 WORKING WITH PAGE LAYOUT, PAGE SETUP I.E. SETTING MARGINS, CHANGING PAGE SIZE, CHANGING PAGE ORIENTATION AND APPLYING PAGE BACKGROUND. 1. Setting Margins 1.Open the Word document in which want to set the margin 2. Click on Layouttab 3.Select the desired margin measurements For custom margins below option can be selected
2. Changing page size 1.Open the Word document to change page size 2.Click on Layouttab 3.In Page Setupgroup click the Size command 4.Paper size menu will appear
5.With a left click select the desired paper size 6.To customize page size click the 'More Paper Sizes' option 3 Changing page orientation 1.Open the Word document to change page size 2.Click on Layouttab 3.In Page Setup group click the Orientationcommand 4.It displays two options, Portraitand Landscape
5.Select the desired page orientation 4 Applying page background
1.Open the Word document 2.Go to design tab 3.Go to Page Background group 4.Select Watermark Option 5.Go to Custom Watermark
6.Select a picture for picture water mark
EXPERIMENTS 3WRITE A C PROGRAM TO PERFORM POST AND PRE-INCREMENT, POST AND PRE-DECREMENT OPERATIONS. 1. Write a C program to perform post and pre-increment #include<stdio.h> #include<conio.h> int main() { int i; i = 10; printf(\"C program to perform post and pre-increment\"); printf(\"\\n\\nNumber is :- %d\", i); ++i; printf(\"\\n\\nNumber after pre increment by 1 :- %d\", i); printf(\"\\n\"); i++; printf(\"\\nNumber after post increment by 1 :- %d\", i); printf(\"\\n\"); return 0; } Output:
2. Write a C program to perform post and pre-decrement operations #include<stdio.h> #include<conio.h> int main() { inti; i = 10; printf(\"C program to perform post and pre-decrement\"); printf(\"\\n\\nNumber is :- %d\", i); --i; printf(\"\\n\\nNumber after pre decrement by 1 :- %d\", i); printf(\"\\n\"); i--; printf(\"\\nNumber after post decrement by 1 :- %d\", i); printf(\"\\n\"); return 0; } Output:
EXPERIMENT 4 CREATING AND WORKING WITH TABLE OF CONTENT. 1. Creating and working with table of content. 1. Select each chapter in document and apply Heading Styles to them. Mark up the section headers so that Word can recognize them. 2. Go to Ribbon >Home >Styles. Select the text and apply headings for all the text you want to include in the table of contents. 3. Place the cursor on the specific position where want the table of content to appear in document. This is commonly somewhere at the beginning of the document. 4. Go to Ribbon >References >Table of Contents. Choose from one of the two automatic types available. The only difference between the two is the heading of \"Contents\" or \"Table of Contents\" at the top 5. Word scans the document and uses the heading styles to construct the order of the sections and subsections and their page numbers.
6. Table of Contents that has been created automatically is updatable. Update the table if you change the heading styles, rearrange the contents, or change the text. Also, update it if you make any changes to the content that affects the page numbers. 7. To create a manual table, go to References >Table of Contents > Click the dropdown to reveal the option for Manual Table.
EXPERIMENT 5 INSERTING PAGE NUMBERS, HEADERS AND FOOTERS, FOOTNOTE, ENDNOTE, DATE AND TIME, PICTURES, OBJECTS, SHAPES ETC. 1 Inserting page numbers 1.Open the MS word document 2. Go to Insert > Page Number. 3.Choose the desired option from the drop-down 4. Choose a location. 5. Select an alignment style. 2 Headers and footers 1.Open the MS word document 2. Go to Insert.
3.Choose header or footer option 4.Choose the header style you want to use. 5.Add or change text for the header or footer. 6. Select Close Header and Footer or press Esc to exit.
3 Footnote, endnote 1. Click on the place to add footnote or endnote for reference. 2.Click on the References tab 3. Select Insert Endnote. 4. Enter the desired content in the footnote or endnote. 5. Return to your place in the document by double-clicking the number or symbol at the beginning of the note. 4 Date and time 1.Open the MS word document 2.Go to Insert tab 3.Click on Date & Time 4.Select the desired format and click OK
5 Pictures 1.Go to Insert tab 2.Go to Illustrations group 3.Select Pictures
4.Select a picture from system and click on Insert button 6 objects, shapes 1.Go to Insert tab 2.Go to Illustrations group
3.Click on Shapes 4.Select Desired shape
EXPERIMENT 6 CREATING CUSTOM LISTS, USING AUTO FILL, FIND AND REPLACE AND EDITING TEXT (CUT, COPY, PASTE AND PASTE SPECIAL). 1. Creating custom lists 1.Open Ms Excel 2.Go to File->Options 3.Go to Advanced -> Edit Custom Lists 4. To create custom list, type some list entries, and click Add.
5.Click on OK Using auto fill For indexing 1 to 10 1.Enter 1 into cell A1 and 2 into cell A2 2. Select cell A1 and cell A2 and drag the fill handle down. The fill handle is the little green box at the lower right of a selected cell or selected range of cells.
3.Numbers will be filled automatically Same for days of weeks
2. Find and replace and editing text 1.Go to Home->Editing 2.Select find & select 3.various options will be visible as per requirement
User can 1.Replace all the text appeared in sheet 2.Replace single value 3.Find single value 4.Find all the values 3. Editing text (cut, copy, paste and paste special). 1. Go to File tab 2.Go to Options 3.Select advanced option 4 Under Cut, copy, and paste, select the down arrow for the setting to change. Pasting within the same document When you paste content into the same document from which you copied the content.
Pasting between documents When you paste content that was copied from another Word document. Pasting between documents when style definitions conflict When you paste content that was copied from another Word document, and the style that is assigned to the copied text is defined differently in the document where the text is being pasted. Pasting from other programs When you paste content that was copied from another program, such as a browser. 5. There are options in each setting Keep Source Formatting Merge Formatting Keep Text Only 6. Select OK. 4. Editing text (cut, copy, paste and paste special).
Can also be done from Clipboard group 1.Go to Home tab 2.Select Clipboard group
EXPERIMENT 7 WORKING WITH FORMULAE AND FUNCTIONS AND APPLYING CONDITIONAL FORMATTING TO DATA. 1. For this experiment we will try to find total marks of a students appeared for 5 examination papers To find total marks obtained by each student 1.Added formula on desired sell
2. To find the marks between, greater than etc. using Conditional Formatting 1.Go to Home->Styles 2.Click on Conditional Formatting 3. We will try to find how many students got marks more 65
4.Numbers obtained between 65 and 90
EXPERIMENT 8 WHAT-IF-ANALYSIS USING GOAL SEEK, SCENARIOS AND SOLVER. 1. Goal Seek is a What-If Analysis tool that helps user to find the input value that results in a target value that user wants. Goal Seek requires a formula that uses the input value to give result in the target value. We will use Goal Seek function to calculate marks of missing third paper 1. Put some formula in total section on the basis of which marks will be calculated.
2.To apply goal seek function on 3rd paper Go to Data->Forecast 3.Select Goal Seek 4.Apply it on total marks
5. Marks will be calculated on the basis of a approx. marks given in “To value” textbox. So “To value” is our target value on basis of which Goal seek function will be applied on out calculation. 2. What-If-analysis using Scenarios and solver 1.Go to Data tab 2. Go to Data->Forecast 3.There is a Sales report
4.Need to changes the Actual values using Scenario Manager 5. Select Scenario Manager 6.Add new values 7.
8.All the old values are replaced by new using Scenario values
EXPERIMENT 9 PIVOT TABLES AND DATA TABLES (ONE AND TWO TABLE INPUT). 1. A pivot table is a table of statistics that summarizes the data of a more extensive table (such as from a database, spread sheet, or business intelligence program). In this experiment we import SQL data to Excel 1.Go to Data->Get External Data 2.Click on “From Other Sources” 3.Select “From SQL Server”
4.Type name and Login credentials of the Server 5.Select name of the Database-> Click on next 6.Select the table name and click on next 7.Click on Finish 8.Select “PivotTable Report”
9.Select the columns 10.Data Imported from SQL server 2. Experiment for selection of multiple tables from import SQL data to Excel 1.Enable selection of multiple tables
Search
