Gauhati University, located in Guwahati, Assam, is one of the prominent educational institutions in Northeast India. It offers a wide range of undergraduate and postgraduate courses to students across various disciplines. The Bachelor of Commerce (BCom) program at Gauhati University is highly regarded for its comprehensive curriculum and focus on practical applications in the business world. In this article, we will explore the Gauhati University BCom 3rd Sem Computer Applications in Business Solved Question Paper for the year 2022, shedding light on its importance and the Questions asked in Examinations.
Gauhati University BCom 3rd Semester (Honours)
Computer Application in Business Question Paper 2022
COMMERCE (Honours)
Paper COM-HC-3016
(Computer Applications in Business)
Full Marks: 40
Time: Two hours
The figures in the margin indicate full marks for the questions.
1. Choose the right alternative: (any four) 1x4=4
(i) What is the basic unit of a PowerPoint presentation ?
(a) Byte
(b) Slide
(c) Animation
(d) Slide transition
(ii) The extension of Microsoft Excel file is
(a) .docx
(b) .pdf
(c) .xlsx
(d) .pptx
(ii) In DBMS the association among entities is called
(a) a relationship
(b) a primary key
(c) an attribute
(d) None of the above
(iv) The formula in MS Excel starts with
(a) - (Minus)
(b) + (Plus)
(c) / (Divide)
(d) = (Equal)
(v) Which of the following is not a font style ?
(a) Bold
(b) Italic
(c) Times New Roman
(d) Superscript
(vi) MS PowerPoint is which type of software ?
(a) System software
(b) Application software
(c) Utility software
(d) None of the above
(vii) Which of the following SQL commands is used to retrieve data ?
(a) Select
(b) Delete
(c) Find
(d) None of the above
2. Answer the following questions in brief: (any three) 2×3=6
1. (i) Write the keyboard shortcuts for Print a page and Cut selected text in MS Word.
Answer: - Keyboard shortcut for Print: Ctrl + P
- Keyboard shortcut for Cut: Ctrl + X
(ii) What are the different views in PowerPoint?
Answer:- Different views in PowerPoint:
1. Normal View: Allows you to create and edit slides.
2. Slide Sorter View: Displays all slides in thumbnail form for easy organization.
3. Slide Show View: Presents the slideshow as a full-screen presentation.
4. Notes Page View: Shows slides along with speaker notes.
5. Reading View: Allows navigation through slides while seeing slide thumbnails.
(iii) What is cell reference in MS Excel?
Answer:- Cell reference in MS Excel is a way to identify and locate a specific cell within a worksheet. It is represented by the column letter and row number of the cell. For example, "A1" refers to the cell in column A and row 1.
(iv) What do you mean by DDL? State one SQL command under DDL.
Answer:- DDL stands for Data Definition Language. It is a subset of SQL (Structured Query Language) used to define and manage the structure of a database. One SQL command under DDL is "CREATE TABLE", which is used to create a new table in the database.
(v) What is the terminology?
Answer:- "Terminology" refers to the specific language, vocabulary, or terminology used within a particular field or domain. It includes the specialized terms, phrases, and jargon that are unique to that field or subject.
(vi) What is a spreadsheet?
Answer:- A spreadsheet is a software application or tool used to organize, analyze, and manipulate numerical data in a tabular form. It consists of rows and columns that intersect to form cells, where data can be entered and processed. Spreadsheets are commonly used for tasks such as budgeting, financial analysis, data tracking, and mathematical calculations. MS Excel is an example of a popular spreadsheet application.
3. Answer the following questions: (any two) 5×2=10
(i) Write about different page setup options in MS Word.
Ans: In MS Word, the Page Setup options allow you to customize and format the appearance of your document's pages. These options can be accessed from the "Layout" or "Page Layout" tab in the ribbon. Here are some of the different Page Setup options in MS Word:
1. Margins: Margins determine the blank space around the edges of the page. You can set the margin size for the top, bottom, left, and right sides of the page. MS Word provides predefined margin options or allows you to set custom margin sizes.
2. Orientation: Orientation refers to the layout of the page, whether it is in portrait (vertical) or landscape (horizontal) orientation. You can choose the desired orientation based on the content and layout of your document.
3. Paper Size: Paper size allows you to specify the size of the paper on which your document will be printed. Common paper sizes include letter, legal, A4, and others. You can select the appropriate paper size from the available options.
4. Page Breaks: Page breaks determine where the page ends and a new one begins. You can insert manual page breaks to control the page layout and ensure specific content starts on a new page. MS Word also provides automatic page breaks based on the content and margins.
5. Headers and Footers: Headers and footers are areas at the top and bottom of each page where you can add content such as page numbers, document title, author name, dates, etc. MS Word allows you to customize the headers and footers according to your preferences.
6. Columns: Columns option allows you to divide the page into multiple columns, similar to a newspaper layout. You can choose the number of columns and customize their width and spacing.
7. Page Borders: Page borders enable you to add decorative borders around the page. You can select different line styles, colors, and thickness to enhance the visual appeal of your document.
8. Page Background: Page background option allows you to add a background color or apply a watermark to the page. This can be useful for branding, adding visual elements, or enhancing the overall aesthetics of your document.
(ii) What are the different types of charts available in MS Excel? Write briefly.
Ans: Slide transition in MS PowerPoint refers to the visual effect or animation that occurs when transitioning from one slide to another during a presentation. It adds a dynamic and engaging element to the presentation, enhancing the overall flow and professionalism.
To apply transition effects in MS PowerPoint:
1. Open the PowerPoint presentation and navigate to the slide where you want to apply the transition effect.
2. Go to the "Transitions" tab in the PowerPoint ribbon, which is located at the top of the application window.
3. Choose a transition effect from the available options in the "Transition to This Slide" section. You can click on the effect to preview it.
4. Adjust the duration of the transition by entering the desired time in the "Duration" field. This determines how long the transition effect will last when you move to the next slide.
5. Customize the transition further by selecting options such as sound, direction, and advance slide settings. These options allow you to add sound effects, specify the direction of the transition (e.g., from left to right or from top to bottom), and control how the transition progresses (automatically or manually).
6. To apply the selected transition effect to multiple slides, select the slides in the slide thumbnail pane on the left side of the PowerPoint window and then choose the desired transition effect.
7. Repeat the above steps for other slides where you want to apply transition effects.
Some commonly used transition effects in MS PowerPoint include:
- Fade: The current slide fades out while the next slide fades in.
- Dissolve: The current slide dissolves into the next slide.
- Slide Left/Right/Up/Down: The current slide slides out in the specified direction, revealing the next slide.
- Zoom: The next slide zooms in from a specific area on the screen.
- Wipe: The next slide wipes over the current slide, revealing the content of the next slide.
(iii) What is slide transition in MS PowerPoint ? Briefly write how to apply transition effects. Also mention the name of few transition effects.
Ans: Slide transition in MS PowerPoint refers to the visual effect or animation that occurs when transitioning from one slide to another during a presentation. It adds a dynamic and engaging element to the presentation, enhancing the overall flow and professionalism.
To apply transition effects in MS PowerPoint:
1. Open the PowerPoint presentation and navigate to the slide where you want to apply the transition effect.
2. Go to the "Transitions" tab in the PowerPoint ribbon, which is located at the top of the application window.
3. Choose a transition effect from the available options in the "Transition to This Slide" section. You can click on the effect to preview it.
4. Adjust the duration of the transition by entering the desired time in the "Duration" field. This determines how long the transition effect will last when you move to the next slide.
5. Customize the transition further by selecting options such as sound, direction, and advance slide settings. These options allow you to add sound effects, specify the direction of the transition (e.g., from left to right or from top to bottom), and control how the transition progresses (automatically or manually).
6. To apply the selected transition effect to multiple slides, select the slides in the slide thumbnail pane on the left side of the PowerPoint window and then choose the desired transition effect.
7. Repeat the above steps for other slides where you want to apply transition effects.
Some commonly used transition effects in MS PowerPoint include:
- Fade: The current slide fades out while the next slide fades in.
- Dissolve: The current slide dissolves into the next slide.
- Slide Left/Right/Up/Down: The current slide slides out in the specified direction, revealing the next slide.
- Zoom: The next slide zooms in from a specific area on the screen.
- Wipe: The next slide wipes over the current slide, revealing the content of the next slide.
(iv) What is DBMS ? Write few applications
Ans: DBMS stands for Database Management System. It is software that allows users to efficiently store, manage, and retrieve data in a structured manner. A DBMS provides an interface between the user and the database, facilitating the creation, modification, and deletion of data.
Applications of DBMS:
1. Banking Systems: DBMS is extensively used in banking systems to manage customer accounts, transactions, and other financial data. It ensures data integrity, security, and efficient retrieval of customer information.
2. E-commerce: DBMS is crucial for e-commerce platforms to handle large volumes of product data, customer information, order processing, and inventory management. It enables seamless online transactions and personalized user experiences.
3. Healthcare Systems: In healthcare, DBMS is employed to store and manage patient records, medical histories, diagnostic reports, and other critical healthcare data. It helps healthcare professionals access and update patient information efficiently and securely.
4. Airlines and Reservation Systems: DBMS plays a vital role in airline reservation systems by managing flight schedules, seat availability, ticketing information, and passenger details. It ensures accurate and real-time data for reservations and facilitates smooth operations.
5. Human Resource Management Systems (HRMS): HRMS relies on DBMS to store and manage employee information, payroll data, attendance records, performance evaluations, and other HR-related data. It simplifies HR processes and enables efficient workforce management.
6. Educational Institutions: DBMS is utilized in educational institutions to store and manage student records, course details, class schedules, examination results, and administrative information. It provides a centralized platform for data management and facilitates smooth academic operations.
7. Supply Chain Management: DBMS is employed in supply chain management systems to handle inventory data, order processing, logistics information, and supplier details. It helps optimize the supply chain and improves operational efficiency.
4. Answer the following questions: (any two)
(i) What is entity relationship model? Explain the basic building blocks of an ER diagram. 5+5=10
Ans: The entity-relationship (ER) model is a conceptual model used in database design to represent the relationships between entities in a database system. It provides a graphical representation, known as an ER diagram, which depicts the entities, their attributes, and the relationships between them.
The basic building blocks of an ER diagram are:
1. Entity: An entity represents a distinct object, concept, or thing in the real world that is of interest to the database. It is represented as a rectangle in an ER diagram and is labeled with the entity name. For example, in a database for a university, entities could include students, courses, professors, and departments.
2. Attribute: An attribute represents a characteristic or property of an entity. It provides specific details about the entity being represented. Attributes are depicted as ovals connected to the corresponding entity rectangle. For example, for the student entity, attributes could include student ID, name, date of birth, and email address.
3. Relationship: A relationship represents an association or connection between two or more entities. It defines how entities interact with each other in the database. Relationships are depicted as diamonds connecting the related entities. For example, a relationship between the student and course entities could represent the enrollment of students in courses.
4. Cardinality: Cardinality specifies the number of instances of one entity that can be associated with the number of instances of another entity through a relationship. It defines the relationship's multiplicity. Common cardinality notations include "1" for one instance and "N" for many instances. For example, a student can be enrolled in multiple courses, so the cardinality between the student and course entities would be "1:N".
5. Relationship Attributes: Relationship attributes are additional properties or characteristics that describe the relationship itself. They provide additional information about the association between entities. Relationship attributes are depicted as ovals connected to the relationship diamond. For example, a relationship attribute for the enrollment relationship between student and course entities could be the enrollment date.
(ii) What is ratio analysis? Explain how with the help of MS Excel we can perform ratio analysis with ease. 2+8=10
Ans: Ratio analysis is a financial analysis technique used to evaluate the performance and financial health of a company by analyzing various ratios calculated from its financial statements. It involves comparing different financial metrics to assess trends, relationships, and strengths or weaknesses within a company.
MS Excel provides a powerful platform to perform ratio analysis with ease. Here's how you can use Excel to perform ratio analysis:
1. Gather Financial Statements: Collect the relevant financial statements of the company, such as the balance sheet, income statement, and cash flow statement.
2. Enter Data: Enter the financial data into Excel, ensuring that each statement is organized in separate worksheets. Use rows for each period (e.g., years or quarters) and columns for different financial line items.
3. Calculate Ratios: Use Excel's formula functions to calculate various financial ratios based on the data you have entered. Here are a few commonly used ratios and the corresponding Excel formulas:
- Current Ratio: Divide current assets by current liabilities. Use the formula "=Current Assets/Current Liabilities".
- Debt-to-Equity Ratio: Divide total debt by total equity. Use the formula "=Total Debt/Total Equity".
- Gross Profit Margin: Divide gross profit by net sales. Use the formula "=Gross Profit/Net Sales".
- Return on Investment (ROI): Divide net profit by total assets. Use the formula "=Net Profit/Total Assets".
These are just a few examples, and there are numerous other ratios that can be calculated based on the specific requirements of your analysis.
4. Format and Interpret Results: Format the calculated ratios to display them clearly and make them visually appealing. Use formatting options such as bolding, color-coding, or data bars to highlight favorable or unfavorable trends.
5. Create Charts: Use Excel's charting features to create visual representations of the ratios. Charts can help you spot trends, compare ratios over time, and present your analysis in a more understandable format.
6. Perform Comparative Analysis: Compare the calculated ratios across different periods or benchmark them against industry standards or competitors. This analysis will provide insights into the company's financial performance, strengths, weaknesses, and areas for improvement.
(iii) Describe five important mathematical and statistical spreadsheet (Excel) functions. 2×5=10
Ans: 1. SUM: The SUM function in Excel is used to add up a range of numbers. It allows you to quickly calculate the total of a series of values. For example, you can use "=SUM(A1:A5)" to add the values in cells A1 to A5.
2. AVERAGE: The AVERAGE function calculates the average (mean) of a range of numbers in Excel. It is useful for finding the typical value or central tendency of a set of data. For instance, "=AVERAGE(B1:B10)" will give you the average of the values in cells B1 to B10.
3. COUNT: The COUNT function counts the number of cells in a range that contain numerical values. It is handy for determining the total count of a dataset. For example, "=COUNT(C1:C10)" will provide the number of cells in the range C1 to C10 that contain numbers.
4. MAX: The MAX function returns the largest value in a range of cells. It is useful for finding the highest value within a dataset. For instance, "=MAX(D1:D20)" will give you the maximum value in the range D1 to D20.
5. MIN: The MIN function does the opposite of the MAX function; it returns the smallest value in a range of cells. It helps in finding the lowest value within a dataset. For example, "=MIN(E1:E15)" will provide you with the minimum value in the range E1 to E15.
These functions are just a few examples of the numerous mathematical and statistical functions available in Excel. They enable users to perform calculations, analyze data, and gain insights quickly and efficiently.
(iv) What do you mean by entity and attribute in database terminology? Also explain about different relationship types among entities. 4+6=10
Ans: In database terminology, an entity refers to a distinct object, concept, or thing that is represented in a database. Entities are typically nouns and can be tangible or intangible. For example, in a database for a university, entities could include students, courses, professors, departments, and so on. Each entity is uniquely identifiable and has attributes associated with it.
Attributes, on the other hand, are the characteristics or properties that describe an entity. They provide details and specific information about an entity. Attributes are represented by columns in a database table. For example, a student entity may have attributes such as student ID, name, date of birth, email address, and so on.
Different relationship types among entities in a database:
1. One-to-One (1:1) Relationship: In a one-to-one relationship, one instance of an entity is associated with only one instance of another entity. For example, in a database for employees and their personal information, each employee may have a unique employee ID, and that ID is linked to their personal details, such as address or contact information. In this case, each employee has a one-to-one relationship with their personal details.
2. One-to-Many (1:N) Relationship: In a one-to-many relationship, one instance of an entity is associated with multiple instances of another entity. For example, in a database for a company and its employees, one company can have multiple employees working for it. The relationship between the company and the employees is a one-to-many relationship since one company can be associated with many employees, but each employee is associated with only one company.
3. Many-to-Many (M:N) Relationship: In a many-to-many relationship, multiple instances of one entity are associated with multiple instances of another entity. This type of relationship is usually implemented using an intermediate table, known as a junction table or associative table. For example, in a database for students and courses, multiple students can enroll in multiple courses, and each course can have multiple students. The many-to-many relationship is represented by creating a junction table that links the student IDs with the course IDs.
4. Self-Referencing Relationship: A self-referencing relationship occurs when an entity is related to itself. This is common in hierarchical structures or when an entity has a relationship with other instances of the same entity. For example, in an employee database, an employee may have a manager who is also an employee within the same database. In this case, the employee entity has a self-referencing relationship.
(v) Explain advantages of using PowerPoint presentation in business and academic environments. Also write how to create a good PowerPoint presentation. 6+4=10
Ans: Advantages of using PowerPoint presentations in business and academic environments:
1. Visual Communication: PowerPoint presentations allow for effective visual communication, making it easier to present complex information or concepts in a clear and concise manner. Visual aids such as charts, graphs, images, and videos can enhance understanding and engagement among the audience.
2. Organization and Structure: PowerPoint provides a structured format with slides, allowing presenters to organize their content logically. This helps in presenting information in a systematic and coherent way, making it easier for the audience to follow the presentation.
3. Flexibility and Customization: PowerPoint offers a wide range of design options, including templates, themes, colors, and fonts. Presenters can customize the look and feel of their slides to align with their branding or personal style. Additionally, PowerPoint allows for animations, transitions, and interactive elements, adding dynamism and engagement to the presentation.
4. Time Management: PowerPoint presentations help manage time during a presentation. Presenters can set time limits for each slide, ensuring that the content is delivered within the allocated time frame. This promotes efficiency and prevents information overload.
5. Collaboration: PowerPoint presentations facilitate collaboration among team members or students. Multiple individuals can work on different slides simultaneously, allowing for collective input and seamless integration of content. This collaborative approach promotes teamwork and knowledge sharing.
6. Accessibility and Distribution: PowerPoint presentations can be easily shared and distributed electronically, enabling remote access and asynchronous learning. They can be converted into PDFs or shared via email, cloud storage platforms, or presentation-sharing websites, making it convenient to reach a wider audience.
Creating a good PowerPoint presentation:
1. Define your objective: Clearly identify the purpose of your presentation and define the key message you want to convey. This will help you structure your content effectively.
2. Plan and organize: Outline the main points you want to cover and create a logical flow for your presentation. Divide your content into sections or slides that represent distinct ideas or topics.
3. Keep it concise: Avoid overcrowding slides with excessive text. Use bullet points or concise phrases to convey information. Focus on key points and use visuals to support or illustrate your message.
4. Visual appeal: Choose an appropriate template or theme that complements your content. Use consistent fonts, colors, and formatting throughout the presentation. Incorporate visuals, such as images, graphs, and charts, to enhance understanding and engagement.
5. Use effective visuals: Visuals should be relevant, high-quality, and easy to comprehend. Limit the number of visuals per slide and ensure they support the information you are presenting.
6. Limit text and bullet points: Use bullet points sparingly and keep each point concise. Instead of reading directly from the slides, use them as visual aids to reinforce your verbal presentation.
7. Use animations and transitions wisely: Incorporate animations and transitions sparingly and purposefully to add emphasis or create smooth transitions between slides. Avoid using excessive or distracting effects.
8. Practice and rehearse: Familiarize yourself with the content and rehearse the presentation multiple times to ensure a smooth delivery. This will help you build confidence and maintain a good pace during the actual presentation.
-0000-