Expected Paper

In mathematics, the Fibonacci numbers are the following sequence of numbers:

By definition, the first two Fibonacci numbers are 0 and 1, and each remaining number is the sum of the previous two. Some sources omit the initial 0, instead beginning the sequence with two 1s.

.(a) Draw the weekly time-table schedule of your MCA – I Year I – Semester in MS-Word ? (b) Create a Power-point presentation with a minimum of 3 slides ? 2.(a) Prepare a Table use MS-Excel for MCA-I Year I Semester marks with additional fields of total marks, percentage of marks and division of pass. (b) Illustrate MS-Word Search, Search and Replace Options with an example. 3.(a) Draw a flow chart for printing fibonacci numbers upto 1000 in MS-Word ? (b) Create MS-Excel worksheet which illustrates simple sorting. 4.(a) Create MS-Excel worksheet with the following format : Emp. No Emp. Name Basic Pay TA DA HRA Gross Pay IT PF Net Pay Perform the calculation as follows : DA is 30% Pay, HRA is 20% of Basic Oat. Gross Pay is sum of Basic Pay, TA, DA and HRA and Net pay = Gross Pay – Deductions (IT + PF). (b) Create a Power Point presentation with minimum of three slides. 5.(a) Create MS-Word document which illustrate multi-level sort with paragraph text and tables . (b) Illustrate creation of Pie-chart using MS-Excel . 6.(a) Create an MS-Excel worksheet with the following fields. Roll No. , Name, Marks in three subjects, Total marks, percentage of marks, and division of Pass. (b) Illustrate creation of Bar –chart using MS-Excel. 7.(a) Create an MS-Excel worksheet with the following fields.

Product Id, Product Name, Price, Quantity and Totals. (b) Create a marks, table for MCA-I Year I Semester students using MS-Access. Create a report to list the names of students in the order of merits. 8.(a) Create a html page to display MCA I Year marks of a student in a tabular form. (b) With an example show how we can protect MS-Excel's worksheet with password? 9.(a) Create a Power Point presentation having at least 5 slides describing about Andhra Pradesh. (b) Create a Pie-chart for monthly sales of Cars of XYZ make with the following monthly sales, using MS-EXCEL. (300, 200, 100, 50, 100, 500, 600, 700, 100, 200, 150, 20) ..2 ..2.. 10.(a) Demonstrate Mail-Merge feature available in MS-Word with an example. (b) Create a Power-Point presentation with three slides about your college. 11.(a) Create a table in MS-WORD with the following format. Product ID Product Description Sales Quantity (in number) South North

(b) Create a Power-Point presentation with five slides, describing your College. 12.(a) Draw a Flow Chart for finding the biggest of n numbers in MS-Word. (b) Create a Power-point presentation with minimum of 3 slides describing about Andhra Pradesh State. 13.(a) Create an Excel Work sheet with the following data. Name of the Employee Total Income Income Tax Surcharge

Income Tax is calculated as follows : Income < 1,00,000 , Tax = 0 1,00,000 < income < 2,00,000, Tax = 20% for the amount above 1,00,000 Income > 2,00,000, Tax = 20,000 + 30% for the amount above 2,00,000. Surcharge is calculated as follows : Surcharge = 0, if the Income Tax < 40,000 Surcharge = 5 % of Income tax, if income Tax > 40,000. (b) Create a time table for M.C.A. I Year Semester Exams, Using MS-WORD. 14.(a) Illustrate Bar-Chart creation using MS-Excel for the monthly sales of a product. (b) Demonstrate the Search, Search and Replace Options in MS-Word. 15.(a) Demonstrate the usage of MS-Word Macros with an example which

records a macro and another by Running that Recorded macro. (b) With an example illustrate the conception of adding comments to a cell in MSExcel.

…3 ..3.. 16.(a) Create a Pie-Chart in MS-Excel to depict monthly sales of a product. Assume appropriate data. (b) Create an html page with the following contents. Dept. of Computer Science Engineering Uni. College of Engineering Osmania University Course offered Intake Year of commencement B.E 60 1985 M.C.A. 60 1991 M. Tech. 30 1981 M.S.I.T. 30 2001 Each of the above courses should be made as hyperlinks. 17.(a) Demonstrate MS-Word's Spelling and Grammar Options with an example. (b) Create a Power-Point presentation with minimum of five slides describing about your College. 18.(a) Create a letter in MS-Word indicating that your college is conducting a National Seminar on Mobile Computing. Illustrate the usage of mail merge, if this letter has to be mailed to all the principals of MCA colleges. (b) Demonstrate the creation of Pie-chart in MS-Excel for the monthly sales of a product with the following monthly sales. (20, 40, 30, 100, 200, 300, 200, 100, 50, 30, 70, 30) 19.(a) Illustrate the creation of Pie-chart in MS-Excel for the monthly accidents in Hyderabad city.

(30, 20, 5, 7, 20, 30, 40, 50, 20, 30, 70, 30) (b) Illustrate with an example usage of Spelling and Grammar option in MSWord. 20.(a) Create MS-Excel worksheet with the following format : Emp. No Emp. Name Basic Pay TA DA HRA Gross Pay IT PF Net Pay Enter the details of Emp. No., E. Name and Basic Pay only and use formulate to find the TA, DA, HRA, GROSS PAY, IT, PF and NET PAY and RA = 17.5% of Basic Pay, DA = 35% of Basic Pay HRA=10% of Basic Pay, IT = 15% of Basic Pay, P.F. = 12.5% of Basic Pay and GROSS PAY = Basic Pay + TA + DA + HRA and NET PAY = GROSS PAY – IT – PF. (b) Create a Power Point presentation with minimum of five slides describing Osmania University. 21.(a) Create MS-Word document with three pages using a different header and footer on the first page of the document, and different header and footers on odd and even pages. (b) Create a Power-Point presentation with minimum of three slides describe about M.C.A. course. 22.(a) Create a letter indicating that your college is conducting a seminar on Mobile Computing. Illustrate the usage of mail merge feature, if this letter has to be mailed to all the principals of MCA Colleges. (b) Illustrate the creation of Bar-Chart in MS-Excel. ..4 ..4.. 23.(a) Creation a time table for MCA I Year I Semester Exams. In MS-Word. (b) Create a Power-Point presentation with minimum of three slides describing the Hyderabad city. 24.(a) Create a table to enter the student roll no., name, date-of-birth, sex, address fields, using MS-Word. Illustrate the add / delete rows and column features. (b) Creation a Power-Point presentation with minimum five slides with animation describing about your College. 25.(a) Illustrate the creation of Bar-Chart and Pie-Chart using MS-Excel for

monthly sales of a product. Assume appropriate data. (b) Create a Power-Point presentation with minimum of five slides describing about Osmania University. 26.(a) Demonstrate with an example about Simple Sorting and Complex Sorting in MS-Excel. (b) Create a home page for your College. The home page should have three frames. First frame should provide a brief introduction to your College. Second frame should list the Courses offered by your College and the third frame should list the events that take place in your College. 27.(a) Create an html page for displaying M.C.A. I Year examination time table, (b) Create an MS-Excel to generate pay slips. 28.(a) Create a home page for yourself. Apart from other information, the page should have a table providing your academic record in a tabular form as shown below. Exam. Passed Year of Pass Division Institution of Study S.S.C. Inter Degree

The entries in the last column i.e. the names of the Institutions where you have studied should be made hyperlinks. (b) Create a power point presentation with a minimum of five slides with animation describing about your College. 29.(a) Create an html page to displays the following : University College of Engineering Osmania University Department Detail Name of the Department No. of Faculty members No. of Students Civil Engineering 20 300 Mechanical Engineering 22 400 CSE 15 440 ECE 12 300 Bio-Medical 3 200 Electrical 8 400

The Department names should be made hyperlinks. (b) Create a time table for M.C.A. I Year I Semester Examinations in MS-Word. 30.(a) Create an html page to display information about a book in a tabular form . Title of the Books ISBN No. Authors (s) Publisher Year Price The Publisher should be made as a hyperlink. (b) Create a power point presentation with a minimum of five slides describing events happened in your College during the First Semester.