1. Create a presentation for the department using PowerPoint (Use Image, Sound, Word Art and Animation). 2. Find the EMI for the following data using PMT, PPMT and IMPT in Excel Loan Amount : 5,00,000 Interest : 0.02 Period : 24 3. Create the employee table with the following fields: Empno, ename, designation, department, salary a. Insert 5 records for the above created table. b. Add one more field phone in the existing table. c. Update the phone number for existing records. d. Select the employees who got the salary 12500 and above.
1. Create a presentation for the BAS Lab syllabus using PowerPoint (Use Image, Sound, Word Art and Animation).
2. Find the EMI for the following data using PMT, PPMT and IMPT in Excel Loan Amount : 2,00,000 Interest : 0.01 Period : 24 3. Create the student table with the following fields: Rollno, sname, dob, sex, branch a. Insert 5 records for the above created table. b. Add one more field phone in the existing table. c. Update the phone number for existing records. d. Select the students who born in the month of June.
1. Create a presentation for the College infrastructure using PowerPoint (Use Image, Sound, Word Art and Animation).
2. Find the EMI for the following data using PMT, PPMT and IMPT in Excel Loan Amount : 3,00,000 Interest : 0.03 Period : 24
3. Create the voter table with the following fields: Voterid, Vname, age, constituency a. Insert 5 records for the above created table. b. Add one more field votestatus in the existing table. c. Update the votestatus for existing records. d. Delete the voters who polled the vote.
1. Create a spread sheet to analyze the marks of the 10 students and create appropriate charts. 2. Create the following entries in Tally and display the Balance Sheet and Profit and Loss Account (Super Computers – Hard Disks Sales Company). Sl. No. 1 2 3 4
Date 1-Apr-2007 1-Apr-2007 1-Apr-2007 2-Apr-2007
5
2-Apr-2007
6 7 8 9 10 11 12
2-Apr-2007 1-May-2007 1-May-2007 1-May-2007 2-May-2007 2-May-2007 2-May-2007
13
2-May-2007
Description Babu’s investment as cash Company expense Starts a bank account in SBI Hard disk purchased from Samsung Co. as credit Sold hard disk to Supreme Computers as credit Sold hard disk as cash Salaries paid to staff members Sold hard disk as cash Cash deposited in SBI Paid Cheque to Samsung Co. Printing expense Received cheque from Supreme Computers Closing Stock
Amount (in Rs.) 2,00,000 1,000 10,000 50,000 35,000 10,000 5,000 20,000 50,000 25,000 5,000 15,000 10,000
3. Create a VB application to perform all the arithmetic operations.
1. Create a spread sheet to analyze the scores of a match between India and Pakistan and create appropriate charts.
2. Create the following entries in Tally and display the Balance Sheet and Profit and Loss Account (Super Silks – Saree Sales Company). Sl. No. 1 2 3 4
Date 1-Apr-2007 1-Apr-2007 1-Apr-2007 2-Apr-2007
5
2-Apr-2007
6 7 8 9 10 11 12
2-Apr-2007 1-May-2007 1-May-2007 1-May-2007 2-May-2007 2-May-2007 2-May-2007
13
2-May-2007
Description Ramu’s investment as cash Company expense Starts a bank account in SBI Saree purchased from Binny Mills as credit Sold hard disk to Kumaran Silks as credit Sold Sarees as cash Salaries paid to staff members Sold Sarees as cash Cash deposited in SBI Paid Cheque to Binny Mills Printing expense Received cheque from Kumaran Silks Closing Stock
Amount (in Rs.) 1,00,000 1,000 5,000 50,000
3. Create a VB application to find the factorial of the given number.
35,000 15,000 5,000 25,000 50,000 25,000 5,000 25,000 15,000
1. Create a spread sheet to analyze the sales of the two companies (Samsung and Onida) and create appropriate charts.
2. Create the following entries in Tally and display the Balance Sheet and Profit and Loss Account (Kamatchi Gas Services – HP Cylinder Sales Company). Sl. No. 1 2 3 4
Date 1-Apr-2007 1-Apr-2007 1-Apr-2007 2-Apr-2007
5
2-Apr-2007
6 7 8 9 10 11 12
2-Apr-2007 1-May-2007 1-May-2007 1-May-2007 2-May-2007 2-May-2007 2-May-2007
13
2-May-2007
Description Kamatchis investment as cash Company expense Starts a bank account in SBI Cylinders purchased from HP as credit Sold Cylinders to Hotel Saravana Bhavan as credit Sold Cylinders as cash Salaries paid to staff members Sold Cylinders as cash Cash deposited in SBI Paid Cheque to HP Printing expense Received cheque from Hotel Saravana Bhavan Closing Stock
Amount (in Rs.) 1,50,000 2,000 15,000 30,000 10,000 15,000 5,000 20,000 50,000 10,000 5,000 5,000 15,000
3. Create a VB application to check whether the given age is belongs to teen age or not.
1. Create an interview call letter as the main document and create 5 records. Use mail merge to create letter for the 5 persons. 2. Create the employee table with the following fields: Empno, ename, designation, department, salary, phone a. Display the table structure. b. Drop the column phone. c. Insert 5 records for the above created table. d. Delete the records and retrieve. 3. Using SPSS define the variable, insert the values for the variable and calculate chi-square value.
1. Create a progress report letter as the main document and create 5 records. Use mail merge to create letter for the 5 student.
2. Create the student table with the following fields: Rollno, sname, dob, sex, branch, phone a. Display the table structure. b. Drop the column phone. c. Insert 5 records for the above created table. d. Delete the table. 3. Using SPSS define the variable, insert the values for the variable and calculate ANNOVA.
1. Create an invitation letter as the main document and create 5 records. Use mail merge to create letter for the 5 VIPs.
2. Create the voter table with the following fields:
Voterid, Vname, age, constituency a. Insert 5 records for the above created table. b. Delete the record whose voterid is 2. c. Display all the records in ascending order. d. Delete the table.
3. Generate payroll statement of employees and calculate income tax using VLOOKUP function in Excel.
1. Use the following data and find out the employees whose age is 25 and above and getting salary 15000 and above by using Advance Filter in Excel. Empno 101 102 103 104 105
Age 23 25 28 27 29
Salary 12500 17500 15000 12000 18000
2. Using SPSS define the variable, insert the values for the variable and calculate chi-square value. 3. Create a VB application to perform all the arithmetic operations.
1. Use the following data and find out the player whose got 5000 and above in Runs and 150 and above in Wickets by using Advance Filter in Excel. Playerid 1 2 3 4 5
Runs 7500 10900 6156 5005 6800
Wickets 250 175 100 85 90
2. Using SPSS define the variable, insert the values for the variable and calculate ANNOVA. 3. Create a VB application to find the factorial of the given number.
1. Use the following data and find out the player whose got 5000 and above in Runs and 150 and above in Wickets by using Advance Filter in Excel. Playerid 1 2 3 4 5
Runs 7500 10900 6156 5005 6800
Wickets 250 175 100 85 90
2. Using SPSS define the variable, insert the values for the variable and calculate chi-square value.
3. Create a VB application to check whether the given age is belongs to teen age or not.
1. Find the EMI for the following data using PMT, PPMT and IMPT in Excel Loan Amount : 5,00,000 Interest : 0.02 Period : 24 2. Using SPSS define the variable, insert the values for the variable and calculate ANNOVA. 3. Create the employee table with the following fields: Empno, ename, designation, department, salary a. Insert 5 records for the above created table. b. Add one more field phone in the existing table. c. Update the phone number for existing records. d. Select the employees who got the salary 12500 and above.
1. Use the following data and find out the student whose got 60 and above in Theory and 80 and above in Practical by using Advance Filter in Excel. Rollno 200611001 200611002 200611003 200611004 200611005
Theory 60 75 60 68 71
Practical 85 90 86 75 88
2. Using SPSS define the variable, insert the values for the variable and calculate chi-square value. 3. Create the student table with the following fields: Rollno, sname, dob, sex, branch a. Insert 5 records for the above created table. b. Add one more field phone in the existing table. c. Update the phone number for existing records. d. Select the students who born in the month of June.
1. Find the EMI for the following data using PMT, PPMT and IMPT in Excel Loan Amount : 3,00,000 Interest : 0.03 Period : 24 2. Using SPSS define the variable, insert the values for the variable and calculate ANNOVA.
3. Create the voter table with the following fields: Voterid, Vname, age, constituency a. Insert 5 records for the above created table. b. Add one more field votestatus in the existing table. c. Update the votestatus for existing records. d. Delete the voters who polled the vote.