Download OU B.Com (Important Questions) B.Com I Year (CBCS) Fundamentals of Information Technology Practical Question Bank

FACULTY OF COMMERCE

OSMANIA UNIVERSITY

Practical Question bank for B.Com Comp Applications (CBCS) I-Semester w.e.f 2019

--- Content provided by​ FirstRanker.com ---

Subject: Fundamentals of Information Technology

Total Marks: 35

MS-Word

1. Create a word document to generate the following output:
   (a+b)²=a²+2ab+b²
   

   --- Content provided by‌ FirstRanker.com ---

   H2SO4, H2O, CO2, MnO2
   N2+H2 ? NH3
2. Create a news paper model with multi columns.
3. Type a paragraph and perform the following task.
   1. Make five lists of numbering which contains details of the courses offered in your college.
   2. Make the five list of bullets having hand symbol which describes about facilities in your college.

   --- Content provided by FirstRanker.com ---

   3. Keep a footnote to any one of the word of the first paragraph.
   4. Center the heading of your document.
4. Create a word document to display the Time Table of your class. Use all the features of Table Formatting.
5. Use Mail Merge feature to send invitation letters to ex-students of your college inviting them to attend the Alumni meet in your college.

--- Content provided by FirstRanker.com ---

6. Create letterhead of any company or institution that you got and insert the Watermark with that company name in the document.
7. Create a MACRO taking your own data and run it.
8. Create a document on Features of computers and apply different themes. www.FirstRanker.com
9. Create Super Script at Subscript as CO²; x².
10. Create a word document consisting of 5 pages describing about your college. Insert headers and footers and page numbers in all the pages.

--- Content provided by‍ FirstRanker.com ---

MS-Excel

11. Enter the Student details with the following columns:
    Sno, Sname, Subjects marks in first semester.
    Calculate the Total Marks, Average and Result.
    Result should be displayed as “Pass/Fail”. Take your own criteria for result.

--- Content provided by‍ FirstRanker.com ---

12. Enter the Student details with the following columns:
    Sno, Sname, Subjects marks in first semester.
    1. Calculate the Total Marks, Average.
    2. Find the maximum and minimum of marks in Total Marks column.
    3. Count the number of students whose Average score is > 70.

--- Content provided by⁠ FirstRanker.com ---

13. Enter the Student details with the following columns:
    Sno, Sname, Subject marks in first semester.
    1. Calculate the Total Marks, Average.
    2. Use conditional formatting to display the students marks whose score in a particular subject is greater than 90.
    3. Use conditional formatting to display the students whose marks are greater than 90 in all the subjects.

--- Content provided by‍ FirstRanker.com ---

14. Consider the following columns:
    Sno, Sname, Total marks obtained in first semester. Represent this data using a Bar diagram.
15. Consider the following columns:
    Month, Sales (Rs.). Plot the data using a line chart.
16. Consider the following student data with columns:
    

    --- Content provided by‍ FirstRanker.com ---

    Firstname, Lastname, Score(out of 100)
    1. Sort the above data on Firstname column.
    2. Sort the above data on Firstname and then by Lastname (use multilevel sorting)
17. Consider the following student data with columns:
    Firstname, Lastname, Score(out of 100)
    1. Filter the above data by displaying the student details where score > 70.

    --- Content provided by‌ FirstRanker.com ---

    2. Filter the above data by displaying the student details where score between 50 and 70.
18. Consider the following Sales data with columns:
    Date, Salesman Name, Region(North/South/East/West), Sales in Rs.
    Generate a pivot table to calculate the Total Sales Region wise. Also calculate the average sales made region wise.

--- Content provided by‌ FirstRanker.com ---

19. Consider Employee details data with the columns:
    Emp. ID, Employee name, Department and Salary.
    Generate Department wide sub-totals.
20. Following are the scores of 10 students in an exam:
    44, 56, 89, 94, 43, 32, 11, 55, 99, 44.
    

    --- Content provided by FirstRanker.com ---

    Use functions to calculate Mean, Median and Mode.

MS-Powerpoint

21. Create a presentation of 5 slides to describe the facilities available to students in your college.
22. Create a presentation of 5 slides to describe the benefits of Yoga in human life. Apply different slide transitions.
23. Create a presentation of 5 slides using different slide layouts to describe about Global Warming.

--- Content provided by⁠ FirstRanker.com ---

24. Create a presentation of 5 slides describing the side effects of overuse of Smart Phones and apply design templates.
25. Create a presentation of 5 slides describing about the Side effects of smoking using custom animations.

MS-DOS

26. Create the following directory structure:
    1. Create a directory with your college name.
    2. Create sub directories with course names under your college name folder.

    --- Content provided by FirstRanker.com ---

    3. Within each course create sub directories for First, Second and Final years.
27. Create the following directory structure:
    1. Create a directory with your college name.
    2. Create sub directories with course names under your college name folder.
    3. Display the above folder structure in the form of a tree.

    --- Content provided by⁠ FirstRanker.com ---

28. Create the following directory structure:
    1. Create a directory with your college name.
    2. Create sub directories with course names under your college name folder.
    3. Create text files describing about each course in respective course names.

--- Content provided by‍ FirstRanker.com ---

29. Create the following directory structure:
    1. Create a directory with your college name.
    2. Create sub directories with course names under your college name folder.
    3. Create text files describing about each course in respective course names.
    4. Copy the text files into college name directory.
    5. Delete the sub directories under college name directory.

    --- Content provided by FirstRanker.com ---

30. Demonstrate the use of any 5 internal and external DOS commands with your own data.