Section I E Module Outline plan First Page Maharaja Surajmal Institute Affiliated to GGSIPU Delhi Course Bachelor of Business Administration Subject Module On Computer Applications Lab BBA111 Semester II Credit 2 Module Contributor s Mr Ajay Phogat Ms Neha Mathur Ms Priyanka Dhaka July 2021 1 SYLLABUS 2 Practical Lecture Objective Assignments To tell them about the various bars available like title bar status bar tabs groups etc in Ms Word To introduce them to Create a Document containing text that should be properly aligned with proper format Use the Replace All option in Find and Replace to replace each instance of some word Save and Protect your document Create a document containing generation of computer and use the formatting groups upto 3 heading levels in the document apply paragraph and the available formatting on each paragraph View document map of your formatting tools document P3 To introduce them to the usage functionality of header and footer Create a document containing generation of computer including characteristics advantages disadvantages using header footer indentation page margin etc To illustrate the use of clip art facility Create an invitation card for the fresher s party using the clip art facility of MS Word To demonstrate the use of shapes facility Create the Block diagram of Computer using drawing facility of MS Word available P6 To demonstrate the use of table group Insert a 7 column 6 row table to create a calendar for the current month and do Enter the names of the days of the week in the first row of the table Centre the day names 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 and right align the dates for the month in the appropriate cells of the table Change the outside border to a more decorative border Identify two important dates in the calendar and shade them Create a table in MS Word with the following entries S No 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 3 P7 To illustrate the use of table group Name M1M2 M3 M4 M5 and apply the following operations on No P1 P2 P4 P5 Insert a new column named grade in the Table Sort the table with respect to the column M5 Covert the table into text Create a 5 page document Use hyperlinks Insert Bookmarks the of Write 10 mathematics equations Create the resume using the resume Template facility and write down the steps for the same the of show To functionality bookmarks hyperlinks To show functionality symbols group To impart the usage importance of Page Layout Tab References Tab Layout Tab References Tab P11 To impart the usage Make a table of contents of unit I of the subject Introduction to importance of Page Information Technology P12 To demonstrate the use Send the Fresher s Party Invitation Card created above to 5 of Mailings tab different People using Mail Merge Write steps corresponding to To demonstrate function of count the Count the number of characters with without space word pages paragraph and lines using word count facility of M S To demonstrate the use of Review tab Check the spelling and grammar in an existing document and it should be properly aligned with proper format To demonstrate the use of View tab toolbar Write steps of the same Assignment on introduction to macros Create a macro using it Word 4 P8 P9 P10 P13 P14 P15 P16 Create a spreadsheet of the purchases made by a customer in a super mart having the following fields To tell them about the various bars available like title bar status bar tabs groups etc in Ms Excel S no Product ID Product Name Product type food clothes toys etc Quantity Price per unit Note All the field names should be bold and underlined Also Insert Borders to the spreadsheet P17 To tell them about the For the spreadsheet created above find the total bill using the various bars available auto sum facility of Ms Excel like title bar status bar tabs groups etc in Ms Excel P18 To demonstrate the use of for conditional formatting home tab Create a student performance report using Conditional formatting in M S Excel the following specifications Greater than Less than Equal to Between Data bar Colour Scales P19 To explain the use of Create a record of ten students consisting of S no name and home tab for editing marks in two subjects M1 M2 and perform the following sort find replace operations Sort the records in ascending order of marks M1 Sort the records in descending order of marks M2 Sort the record according to descending order of names Find the minimum marks and replace it by the text put more efforts Create the Column Chart for the sales report of the ABC Pvt Ltd Apply the following properties of Column Chart such as Fill Color Border colour Border Style Size Create a Column Chart for record of 3 years for 5 item P20 To demonstrate the use of Insert tab for column chart chart P21 To demonstrate the use of Insert tab for column P22 To demonstrate the use of Insert tab for Pie Draw the Pie Chart for the sales report of the ABC Pvt Ltd for last 3 years in M S Excel and explore the properties such as add Label Color etc 5 chart chart chart P23 To demonstrate the use of Insert tab for Pie Create the Pie Chart for the sales laptop of KCL Pvt Ltd for the last 5 years P24 To demonstrate the use of Insert tab for bar Create a Bar graph for 5 states for 3 years depicting the literacy rate For the graph created above perform the following fill colour Switch Row column add borders change size P25 Create the student grade A B C D report using IF and IF Else condition in M S Excel To demonstrate the use of Formula tab P26 To demonstrate the use of Formula tab Now using the conditional formatting fill the A grade as pink B grade as blue C grade as yellow and D grade as Red P27 To demonstrate the use of Formula tab Create the student record consisting of the following entries s no name marks in M1 M2 M3 M4 M5 Now for the table perform the following functions o Find the maximum marks in M2 o Find the minimum marks in M5 o Find the total marks obtained by each student o Find the average marks of each student o Sort the table according to total marks Create a new field named percentage and calculate it Create a record of ten companies consisting of columns Sno Name of company NAME OF CEO No Of employees Profit in year 2010