Vmou ba part 01 Internal Assignment – Introduction to Computer Science (Paper Code: IT-02)

### Internal Assignment – Introduction to Computer Science (Paper Code: IT-02)

Section-A (Very Short Answer Type Questions)

(Note: Answer all questions in one word, one sentence, or up to 30 words. Each question carries 1 mark.)

1. Give any two valid examples of cell address in MS Excel.

• Answer: A1, B2.

1. Give one difference between workbook and worksheet.

• Answer: A workbook is an Excel file containing multiple worksheets; a worksheet is a single sheet within the workbook.

1. What is the shortcut key for save operation in MS Word?

• Answer: Ctrl + S.

1. Define slide in the context of PowerPoint.

• Answer: A slide is an individual page in a PowerPoint presentation used to display information.

Section-B (Short Answer Questions)

(Note: Answer any two questions. Each answer should not exceed 200 words. Each question carries 4 marks.)

1. What is Lists in MS-Word? Discuss different types of lists in MS Word.

• Answer: Lists in MS Word are used to organize information in a structured manner. There are three main types:
  • Bulleted Lists: Use symbols such as dots or arrows to list items without a particular order.
  • Numbered Lists: Use numbers to list items in a specific order.
  • Multilevel Lists: Combine both bullets and numbering to create hierarchical lists. These are useful for outlining documents with multiple levels of detail.

1. Briefly describe the features and usage of Master slides in MS PowerPoint with example.

• Answer: Master slides in MS PowerPoint allow users to maintain a consistent design throughout the presentation. They can be used to set layouts, fonts, colors, and background styles for all slides. For example, if a logo is placed on the master slide, it appears on all slides. Master slides simplify formatting and ensure uniformity. Changes made to the master slide affect all corresponding slides, saving time and ensuring a cohesive look.

1. Write a short note on action queries in DBMS.

• Answer: Action queries in a DBMS are used to perform tasks such as inserting, updating, deleting, and creating tables. Examples include:
  • Insert Query: Adds new records to a table.
  • Update Query: Modifies existing records.
  • Delete Query: Removes records from a table.
  • Make Table Query: Creates a new table based on data from other tables. These queries are essential for data manipulation and database management tasks.

1. Write steps to schedule calendar various items in MS Outlook also explain with a suitable example.

• Answer: To schedule calendar items in MS Outlook:
  • Open Outlook and navigate to the Calendar.
  • Click on “New Appointment” or “New Meeting” for events.
  • Fill in details like title, location, start and end time.
  • Set reminders and recurrence if needed.
  • Save and send invites if it’s a meeting.
  • Example: Scheduling a weekly team meeting every Monday at 10 AM with reminders set 15 minutes before the meeting. This helps ensure all participants are aware and prepared for the meeting.

Section-C (Long Answer Questions)

(Note: Answer any one question. Each answer should not exceed 500 words. Each question carries 8 marks.)

1. What is the chart in MS Excel? Describe the various types of charts with suitable examples.

• Answer: Charts in MS Excel are graphical representations of data used to make complex data easy to understand. They help in visualizing trends, comparisons, and patterns in data. Various types of charts include:
  • Column Charts: Used to compare values across categories. For example, displaying monthly sales data for a year.
  • Line Charts: Show trends over time. For example, illustrating stock prices over a year.
  • Pie Charts: Represent proportions of a whole. For example, showing the market share distribution among different companies.
  • Bar Charts: Similar to column charts but with horizontal bars, useful for comparing quantities across different categories.
  • Scatter Plots: Show relationships between two variables. For example, depicting the correlation between height and weight data.
  • Area Charts: Highlight the magnitude of change over time, similar to line charts but with the area under the line filled. For example, representing population growth over decades.
    These charts enable users to present data clearly and make informed decisions based on visual analysis.

1. Explain the working of footnotes in MS Word with suitable example.

• Answer: Footnotes in MS Word provide additional information or citations at the bottom of the page where the reference is made. To insert a footnote:
  • Place the cursor where the reference number should appear.
  • Go to the “References” tab and click on “Insert Footnote”.
  • Type the footnote text at the bottom of the page.
  • Example: In a document discussing climate change, a footnote can be used to cite the source of a specific statistic mentioned in the text. This helps in providing credibility and additional context without cluttering the main text. Footnotes are automatically numbered and can be formatted to match the style of the document, making it easy to maintain a professional and organized appearance.