DU Computer Applications in Business Solved Question Paper’ 2023 [Dibrugarh University BCOM 4th SEM Hons]

 

DU Computer Applications in Business Solved Question Paper’ 2023 [Dibrugarh University BCOM 4th SEM Hons]


Computer Applications in Business Question Solved Paper’ 2023 (May/June)
COMMERCE (Core)
Paper: C 410 (Computer Applications in Business)
Full Marks: 80
Pass Marks: 32
Time: 3 hours

The figures in the margin indicate full marks for the questions

1. Answer the following questions:                         1x8=8

(a) What is Entity?

Ans: An entity is a distinct real world thing, such as a person, a place, or a concept, that can be uniquely identified. It's an object that stands out from the crowd.

(b) What is Database?

Ans: A database is an electronically stored, systematic collection of data. It can contain any type of data, including words, numbers, images, videos, and files.

(c) What is SQL?

Ans: SQL (Structured Query Language) is a programming language designed for managing and manipulating relational databases. It provides a standardized way to communicate with and perform operations on databases.

(d) What do you mean by Slideshow?

Ans: A slide show is a presentation of a series of still images on a projection screen or electronic display device, typically in a prearranged sequence. The changes may be automatic and at regular intervals or they may be manually controlled by a presenter or the viewer.

(e) Define the term template in Word Processing.

Ans: A design template or template is a file created with an overall layout to be used with one or more documents. For example, a word processor may have a template for a resume. With a resume template, the overall layout is designed with placeholder text that you can replace with information relevant to you.

(f) What do you mean by Autocorrect?

Ans: AutoCorrect is a specific feature in MS Word which fixes common spelling mistakes and typing errors automatically while you type. It replaces misspelled or mistyped words with the correct versions.

(g) What is Worksheet?

Ans: A worksheet also known as a spreadsheet consists of cells in which we can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.

(h) What is Active Cell in MS Excel?

Ans: The active cell is the selected cell in which data is entered when we begin typing. Only one cell is active at a time. Data can only be entered into the active cell.

2. Answer the following questions:                         2x8=16

(a) What are the different views in MS PowerPoint?

Ans: Microsoft PowerPoint has three main views: normal view, slide sorter view, and slide show view. Normal View is the main editing view, which is used to write and design a presentation.

(b) What is paragraph formatting in MS Word?

Ans: Paragraph formatting is a process of organizing and arranging texts in a document to follow a stipulated pattern. Paragraph formatting is a change in the format of text that affects an entire paragraph or is different from other paragraphs in a document.

(c) Write the steps to add background to a slide.

Ans: Adding a background picture to a slide:

1. Select the slide you want to add a background picture to.

2. Select Design > Format Background.

3. In the Format Background pane, select Picture or texture fill.

4. Select File.

5. In the Insert Picture dialog box, choose the picture you want to use and then select Insert.

6. Make adjustments to the background picture to make sure text is visible and it's positioned where you want.

  Use Transparency to make the picture lighter.

  Use the Offset settings to adjust the position of the picture.

  Use Tile picture as texture to repeat the picture across the slide.

7. If you want the background picture on every slide, select Apply to All.

(d) What is Header and Footer in a document?

Ans: The header is a section of the document that appears in the top margin, while the footer is a section of the document that appears in the bottom margin. Headers and footers will help keep long documents organized and make them easier to read

(e) Describe two functions used in MS Excel.

Ans: Mathematical functions in excel are used to perform various mathematical calculations like sum, average, count etc. For example:  A) Sum (): This is used to find sum of the values within a given range of cell.

Logical Functions: Logic Functions in Excel check the data and return the result «TRUE» if the condition is true, and «FALSE» if not.

For Example: A) Logical Function IF (): Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.

(f) How will you show a text vertically in a cell?

Ans: Steps to show a text vertically in a cell:

  Select the cells containing the text you want to make vertical.

  Click on the "Alignment" tab in the "Format Cells" dialog box.

  Under "Text alignment," select the "Vertical" dropdown list.

  Select the "Rotate text up" or "Rotate text down" option.

(g) What is Relational Data Model?

Ans:  Relational data model is the primary data model, which is used widely around the world for data storage and processing.  It makes data sorting and data access easier and Provides a standard way to organize data in databases.

(h) Write the names of two popular DBMS, software.

Ans: Popular DBMS Software examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro.

3. (a) Explain the different components/symbols of an E R model.           6

Ans;

(a) An Entity-Relationship (ER) model is a conceptual data model that represents the entities, attributes, and relationships between them in a database system. The main components/symbols of an ER model include:

1.     Entity: An entity represents a real-world object, such as a person, place, thing, or event, which can be distinguished from other objects. In an ER diagram, an entity is represented by a rectangle with its name written inside.

2.     Attribute: An attribute is a property or characteristic of an entity that describes it. Attributes are represented within ovals connected to their respective entities. For example, for an entity "Student," attributes could include "Name," "Age," and "Student ID."

3.     Relationship: A relationship describes how entities are related to each other. It illustrates the connections between entities in a database. Relationships are represented by diamond shapes connecting two or more entities. They also have cardinality and participation constraints that define how many instances of one entity can be associated with instances of another entity.

·        Cardinality: Describes the maximum number of instances of one entity that can be associated with instances of another entity.

·        Participation: Describes whether the participation of entities in a relationship is mandatory (total) or optional (partial).

4.     Primary Key: A primary key is a unique identifier for each record in a table. It ensures that each row in a table is uniquely identifiable. In an ER diagram, a primary key is underlined within an entity.

5.     Foreign Key: A foreign key is a field in a table that refers to the primary key in another table. It establishes a relationship between two tables. In an ER diagram, a foreign key is depicted as an attribute in one entity that references the primary key of another entity.

 (b) Write the advantages and disadvantages of DBMS. 6

Ans; Advantages and disadvantages of DBMS:

Advantages:

1.     Data Independence: DBMS provides abstraction between the logical structure of data and its physical storage, allowing changes in one level without affecting the other.

2.     Data Consistency and Integrity: DBMS enforces data integrity constraints to ensure that data remains accurate and consistent across the database.

3.     Security: DBMS offers mechanisms for authentication, authorization, and access control to ensure that only authorized users can access and manipulate data.

4.     Concurrent Access and Transaction Management: DBMS supports concurrent access to the database by multiple users while maintaining data consistency through transaction management.

5.     Backup and Recovery: DBMS provides features for backup and recovery to protect data against loss or corruption due to hardware failures, software bugs, or human errors.

6.     Data Sharing and Centralized Management: DBMS facilitates data sharing among multiple users and applications while providing centralized management of data resources.

Disadvantages:

1.     Cost: Implementing and maintaining a DBMS can be expensive in terms of software licenses, hardware infrastructure, and personnel training.

2.     Complexity: DBMS systems are complex software packages that require expertise to design, implement, and manage effectively.

3.     Performance Overhead: DBMS introduces overhead in terms of processing and memory consumption, which can impact the performance of database operations.

4.     Database Failure: Despite backup and recovery mechanisms, database failures can still occur, leading to data loss or downtime.

Vendor Lock-In: Organizations may become dependent on a specific DBMS vendor, limiting

CREATE TABLE student (

    RegNo INT PRIMARY KEY,

    Name VARCHAR(50),

    Address VARCHAR(100),

    Marks FLOAT,

    Email VARCHAR(50)

);

1.     their flexibility to switch to alternative solutions.

2.     Security Risks: DBMS can be vulnerable to security threats such as unauthorized access, data breaches, and SQL injection attacks if not properly configured and managed.

 (c) Write SQL to create a table named student with attributes Reg. No., Name, Address, Marks, email.                  5

Ans; To create a table named "student" with attributes "Reg. No.", "Name", "Address", "Marks", and "email" in SQL, you can use the following SQL query:

sql
CREATE TABLE student ( RegNo INT PRIMARY KEY, Name VARCHAR(255), Address VARCHAR(255), Marks FLOAT, email VARCHAR(255) ); 

This SQL query creates a table named "student" with the specified attributes. Here's a breakdown of the attributes:

·        RegNo: This attribute represents the registration number of the student. It is defined as an integer data type and is designated as the primary key of the table using the PRIMARY KEY constraint. The primary key constraint ensures that each row in the table has a unique registration number.

·        Name: This attribute represents the name of the student. It is defined as a variable-length string data type (VARCHAR) with a maximum length of 255 characters.

·        Address: This attribute represents the address of the student. It is also defined as a VARCHAR data type with a maximum length of 255 characters.

·        Marks: This attribute represents the marks obtained by the student. It is defined as a floating-point numeric data type (FLOAT).

·        email: This attribute represents the email address of the student. It is defined as a VARCHAR data type with a maximum length of 255 characters.

4. (a) What is mail merge? Write the steps for mail merge in MS Word. 1+5=6

Ans: Mail merge is a specific feature of MS Word, which enables users to send a similar email or document to more than one recipient at a time. It enables connecting a single form template with a data source that contains information about the recipient’s name, address and other predefined and supported data.

Benefits of Mail Merge: With the help of mail merge feature, one mail is sent to more than one recipient at a time which saves times and efforts. It simplified producing mass mailing.

Steps in Mail Merge:

1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge.

2. Click Step by Step Mail Merge Wizard.

3. Select your document type. (Letters, E mail, Envelopes, Labels, Directory etc.)

 4. Select the starting document. Select Use the current document and then click Next: Select recipients.

5. Create new list of recipients by adding address list of various recipients or select from outlook contacts or type a new list. Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can edit the list and select or unselect records. Click OK to accept the list as is.

6. Then Click Next: Write your letter.

7. Click Address block to add the recipients' addresses at the top of the document. In the Insert Address Block dialog box, check or uncheck boxes and select options on the left until the address appears the way you want it to.

8. Then, preview your letter and click Next: Complete the merge.

(b) Write the steps for using ‘chart’ in Excel.       4

Ans: Creating a chart in Microsoft Office Excel is quick and easy. Excel provides a variety of chart types that you can choose from when you create a chart. For most charts, such as column and bar charts, you can plot the data that you arrange in rows or columns on a worksheet in a chart. Some chart types, however, such as pie and bubble charts, require a specific data arrangement.

Steps of inserting a chart in MS Excel

a)       On the worksheet, arrange the data that you want to plot in a chart.

b)      Select the cells that contain the data that you want to use for the chart.

c)       On the Insert tab, in the Charts group, Click the chart type, and then click a chart subtype that you want to use.

(c) Write the steps for using slide animation in MS PowerPoint.                5

Ans: Using slide animation in Microsoft PowerPoint can enhance the visual appeal of your presentations and help you deliver content in a more engaging manner. Here are the steps to use slide animation in MS PowerPoint:

1.     Open PowerPoint: Launch Microsoft PowerPoint and open the presentation file where you want to add slide animation.

2.     Select a Slide: Navigate to the slide where you want to apply animation.

3.     Access Animation Pane:

·        In PowerPoint 2010 and later versions: Go to the "Animations" tab on the ribbon.

·        Click on the "Animation Pane" option. This will open a pane on the right side of the window.

4.     Choose Animation Effects:

·        Select the object (text, image, shape, etc.) on the slide that you want to animate.

·        In the "Animations" tab, click on the "Add Animation" dropdown menu to choose from various animation effects.

5.     Apply Animation:

·        Click on the desired animation effect from the dropdown menu. This will apply the selected animation to the selected object.

·        You can adjust the animation settings such as duration, delay, and direction using the options in the "Animation" tab.

6.     Preview Animation:

·        To preview the animation, click on the "Preview" button in the "Animation" tab. This will show you how the animation will appear during the slideshow.

7.     Repeat for Other Objects:

·        Repeat steps 4-6 for other objects on the slide that you want to animate.

8.     Customize Animation Order and Timing:

·        In the Animation Pane, you can see a list of all animated objects on the slide.

·        You can reorder the animations by dragging them up or down in the Animation Pane to change their sequence.

·        To adjust the timing of animations, click on an animation in the Animation Pane, and then modify the "Start," "Duration," or "Delay" options as needed.

9.     Apply Slide Transition (Optional):

·        You can also add slide transition effects between slides to enhance the flow of your presentation.

·        Go to the "Transitions" tab on the ribbon.

·        Choose a transition effect from the gallery and set its duration, sound, and other options as desired.

10.  Preview Slideshow:

·        Once you've added animations and transitions to your slides, preview the entire slideshow to ensure everything looks as intended.

·        Click on the "Slideshow" tab on the ribbon and select "From Beginning" to start the slideshow from the beginning.

11.  Save Your Presentation:

·        After you've applied animations and transitions, make sure to save your presentation to preserve your changes.

 5. (a) Write the steps to perform the following (any four):           3x4=12

(1) Change the size of a font in MS Word.

Ans: Steps to change the size of a font:

  Select the text that you want to change.

  Click the Format tab under Text Box Tools, and then type or select a point size in the Font Size list Button image.

 (2) Change the line spacing in MS Word.

Ans: Change the line spacing in a portion of the document

  Select one or more paragraphs to update. Press Ctrl + A to select all.

  Go to Home > Line and Paragraph Spacing.

  Select Line Spacing Options and choose an option in the Line spacing box.

  Adjust the Before and After settings to change spacing between paragraphs.

  Select OK.

(3) Change the height of a row in an Excel.

Ans: Steps to change the height of a row in an excel:

  Select the row or rows that you want to change. 

  Go to Home > Cells > Format. 

  Under Cell Size, select Row Height. 

  In the Row height box, type the value that you want, and then select OK.

(4) Enclose a cell in a shadow box in an Excel.

Ans: Steps to enclose a cell in a shadow box:

  Select the cells that you want to add a shadow effect to.

  Right click on the selected cells and choose "Format Cells" from the context menu.

  In the "Format Cells" dialog box, go to the "Fill" tab.

  Click on the "Effects" button at the bottom of the dialog box.

  Check the box next to "Shadow" to enable the shadow effect.

  Adjust the settings for the shadow effect, such as the color, size, and direction.

  Click "OK" to apply the shadow effect to the selected cells.

(5) Convert existing text to Word Art in PowerPoint.

Ans: Convert existing text to WordArt

  Select the text to convert to WordArt.

  On the Insert tab, click WordArt, and then pick the WordArt style you want.

(6) Hide a slide from slide show.

Ans: Steps to Hide a slide:

  In the left navigation pane, select the thumbnail image of the slide you want to hide.

  Right click the slide, then select Hide Slide. The slide now shows a slash through the slide number to indicate that it's hidden:

(b) Write short notes on (any three):                      4x3=12

(1) Ratio analysis.

Ans: Ratio analysis is the method or process of expressing relationship between items or group of items in the financial statement are computed, determined and presented. It is an attempt to draw quantitative measures or guides concerning the financial health and profitability of an enterprise. It can be used in trend and static analysis. It is the process of comparison of one figure or item or group of items with another, which make a ratio, and the appraisal of the ratios to make proper analysis of the strengths and weakness of the operations of an enterprise.

According to Myers, “Ratio analysis of financial statements is a study of relationship among various financial factors in a business as disclosed by a single set of statements and a study of trend of these factors as shown in a series of statements."

(2) Using DBMS in the area of accounting.

 (3) The importance of using spread sheets’ in Business application.

 (4) Windows Operating System.

Ans: The Windows Operating System, developed by Microsoft, is a user friendly platform renowned for its graphical interface. It features the Start Menu, Taskbar, and Control Panel for easy navigation, supporting multitasking for running multiple applications simultaneously. Regular updates enhance security, and its broad compatibility accommodates various software and hardware. Seamless integration with Microsoft services facilitates access to applications, cloud storage, and productivity tools. Widely used across personal computers, laptops, and servers, Windows excels in gaming with DirectX support. Its versatility, user friendly updates, and extensive compatibility contribute to its pervasive use in diverse computing environments, meeting the needs of both casual users and professionals.

(5) Word Processing.

Ans: Word processing refers generally to the creation, editing, formatting, storage, and output of both printed and online or electronic documents. Word processing is undoubtedly the most used business application for personal computers, perhaps alongside World Wide Web browsers and electronic mail (e mail) applications.

Word processing software includes basic applications designed for casual business or home users and powerful, advanced applications capable of meeting the most demanding needs of businesses. Many word processing applications are designed for use as part of a suite or integrated group of word processing, spreadsheet, and presentation programs. For example, Microsoft Word, probably the most widely used word processing software, is part of the Microsoft Office suite, which includes Microsoft's PowerPoint presentation program and Excel spreadsheet program.

Features of MS word or Word processing

The main features are:

a) We can create professional documents fast using custom templates.

b) We easily manage large documents using various features like the ability to create table of contents, index, and cross references.

c) We can easily add, remove and copy text in a word file.

d) We can work on multiple documents simultaneously.

e) We can easily conduct spelling and grammar check.

 

-000-


0/Post a Comment/Comments