MCA 106: PC Software Lab

Lectures: 6 Periods/Week Sessional Marks: 20
University Exam: 3 Hours University Examination Marks: 80


Lab Cycle
MS-WORD

  1. Design an Invitation to invite Staff, students to a seminar on “Emerging Trends in Computers”.
  2. Assignment using Mail merge.
  3. Creation of Bio-Data: consisting Name, email-id, Contact Address, Carrier Objective, Educational qualifications, social activities, achievements.
  4. Assignment to implement macro operations.
MS-POWERPOINT
  1. Make a Power point presentation on your carrier planning.
  2. Make a Power point presentation on any Current affair.
  3. Make a Power point presentation to represent a Software Company Profile.
  4. Make a Power point presentation about things you learned during student life.

MS-ACCESS
  1. Create a database using MS-ACCESS with atleast 5 records TABLE1 STRUCTURE: EMPLOYEE NUMBER NAME DOB GENDER DEPARTMENT TABLE2 STRUCTURE: EMPLOYEE NUMBER BASIC HRA DA DEDUCTIONS GROSS SALARY Maintain the relationship between two tables with REGISTER NUMBER as a Primary Key and answer the following quarries: Show the list of Employees with the following fields as one query EMPLOYEE NUMBER NAME GENDER GROSS SALARY
  2. Maintain the relationship between above two tables with EMPLOYEE NUMBER as a Primary Key and generate following reports: Report 1 : EMPLOYEE NUMBER, NAME, BASIC HRA DA DEDUCTIONS Report 2 : EMPLOYEE NUMBER, DEPARTMENT, NET SALARY. Use forms to enter data in to tables
  3. Create a table and form with following fields Book Number, Book Name, Author, Publisher, Price Generate the report with following fields All Books with price between Rs.500 and Rs.1000

MS-EXCEL
  1. Create an electronic spreadsheet to convert
    1. Decimal Numbers to Hexa decimal, Octal, Binary
    2. Binary to Decimal, Octal, Hexadecimal
    3. Hexadecimal to Decimal, Octal, Binary
  2. The Cement Company shows the sales of different products for 5 years. Create column chart, Pie Chart and Bar chart for the following data
    YEAR PRODUCT-1 PRODUCT-2 PRODUCT-3 PRODUCT-4
    2004 1000 800 900 1000
    2005 800 80 500 900
    2006 1200 190 800 400
    2007 400 200 300 1000
    2008 1800 400 400 1200
  3. Demonstrate Hyper Linking in Excel.