Lab practical file with sample format PDF

Preview

Summary

NICE QUESTION...

Description

Guru Gobind Singh Indraprastha University

LAB MANUAL OF COMPUTER APPLICATION B.Com-111

Submitted To:

Submitted By:

Mr. Shivam Agarwal

Student Name

(Assistant Professor)

(Enrollment No.)

B.Com (H)

Jims Engineering Management Technical Campus Greater Noida

Lab Manual of Computer Application lab (B.com-111)

S.no

Practical

1

8

Create a document containing text that should be properly aligned with proper format. Use of “Replace All” options in find and replace to replace each instance of some word. Save and protect your document. List down different components of computer along with their functionality & then sort its sequence & apply at least 5 different styles Create a document containing computer basic including advantages, disadvantages using header, footer, indentation etc. Create a invitation card for fresher’s party using the clip art facility of MS-Word Create the block diagram of computer using drawing facility in MS-Word. Insert a 7-column, 6-row table to create a calendar of current month and do:  Enter the names of days of the week in first row of the table.  Centre the day name horizontally and vertically.  Change the font and font size as desired.  Insert a row at the top of the table.  Merge the cells in the row and enter the current month and year using a large font size.  Shade the row.  Enter the right-align the dates for the month in appropriate cells of the table.  Change the outside border to a more decorative border. Identify two important dates in the calendar and shades them. Create a table in MS-Word with the following entries: S.No, Name, M1,M2,M3,M4 and M5 and apply the following operations on it.  Calculate the minimum marks in M1& M3  Calculate the Maximum marks in M2 & M5.  Find the sum of total marks obtained in each subject.  Insert a new column named grade in the table.  Sort the table with respect to column grade  Convert the table into text. Create a 3-page document. Using hyperlinks. Insert bookmark.

9

Write 5 mathematical equations.

10

Create a resume using the resume template facility and write down the steps for the same. Make a table of contents of Unit-I of the subject Computer Application. Send the fresher’s party invitation card created above 5 different people using Mail Merge. Write the steps corresponding to it. Create a spreadsheet of the purchases made by a customer in a super mart having the following fields:  S.no  Product ID

2 3 4 5 6

7

11 12 13

14 15

16

17

18

 Product Name  Product Type (food, clothes, toys etc)  Quantity  Price per unit Note: All the field names should be bold and underlined. Also insert the borders to the spreadsheet. For the spreadsheet created above, find the total bill, using the auto sum facility of MS-Excel. Create a student perform report using Conditional formatting in MS Excel the following Specifications:  Greater than  Less than  Equal to  Between  Data bar  Colour scales Create a record of ten students consisting of S.No, name and marks in two subjects (M1,M2) and perform the following operations:  Sort the records in ascending order of marks M1.  Sort the records in descending order of marks M2.  Sort the records according to descending order of names  Find the minimum marks and replace it by text “Put more efforts”. Create a column chart for the sales report of ABC Pvt Ltd. Apply the following properties of column chart such as:  Fill Colour  Border colour  Border style  Size Draw a pie chart for the sales report of ABC pvt. Ltd for last 3 years in MS excel and explore the properties such as add label, color etc.

19 20

Create the pivot chart for the sales laptop of KCL pvt. Ltd for the last 5 years. Create a Bar graph for 5 states for 3 years depicting the literacy rate. For the graph created above perform the following.  Switch Row/column  Fill color  Add borders  Change size

21

Create a student grade (A,B, C & D) report using IF and IF else condition in M.S. Excel. Now using the conditional formatting fill the A grade as – Pink, B- Blue, Cyellow, D- Red. Create a student record consisting of following entries: S.No, Name, M1,M2,M3,M4 and M5 and apply the following operations on it.  Calculate the minimum marks in M1& M3  Calculate the Maximum marks in M2 & M5.  Find the sum of total marks obtained in each subject.

22 23

 Find the average marks of each student  Sort the table according to total marks. Create a new field name “percentage ” and calculate it. 24

25

Create a record of ten companies consisting of columns:  S. No  Name of Company  Name of CEO  NO. of employees  Profit in year 2016  Profit in year 2017 For the above record, protect your worksheets by providing password  Hide/Unhide Cells  Allow users to select columns  Allow users to sort cells  Don’t allow users to delete cells.  Don’t allow users to format cells.

26

Create a record of BBA (1st Sem) consisting of the following fields  S. No  Name  Date of Birth  Age  Marks  Remarks For the above record, apply the appropriate data validation.

27

Create a presentation on types of Memory having a table for the types of memory and then create hyperlinks on the types of memory in master slide that opens new slides for it. Create a presentation on types of Operating Systems with different themes and apply animation effects on it. For the presentation created in the previous class apply the different slide show options and protect the presentation to restrict unauthorized access.

28 29

Sample for experiments

Experiment No. 1 Create a document containing text that should be properly aligned with proper format. Use of Replace all options in find and replace to replace each instance of some word. Save and protect your document.

On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look. You can easily change the formatting of selected text in the document text by choosing a look for the selected text from the Quick Design gallery on the Home tab. You can also format text directly by using the other controls on the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you specify directly. To change the overall look of your document, choose new Theme elements on the Page Layout tab. To change the looks available in the Quick Style gallery, use the Change Current Quick Style Set command. Both the Themes gallery and the Quick Design gallery provide reset commands so that you can always restore the look of your document to the original contained in your current template. On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document look.

We Replace the word Style with Design...