BCOS-183: Computer Application in Business
Ignou solved assignment solution for 2022-23, if you are looking for bcos-183 ignou solved assignment solution for the subject computer application in business, you have come to the right place. bcos-183 solution on this page applies to 2022-23 session students studying in bcomg, bscg, bavtm, bag, bavmsme, bags, baech, bahih, bapsh, bapch, bapah, basoh, bscanh, baegh courses of ignou., looking to download all solved assignment pdfs for your course together, bcos-183 solved assignment solution by gyaniversity.
Assignment Code: BCOS-183/TMA/2022-23
Course Code: BCOS-183
Assignment Name: Computer Application in Business
Year: 2022-2023
Verification Status: Verified by Professor
Maximum Marks: 100
Note: Attempt all the questions.
Section – A
(This section contains five questions of 10 marks each)
Q.1) What are the Computer Networks? Explain their importance and various types. (10)
Ans ) Networks of nodes connected by communication routes are known as data networks or computer networks. These nodes allow for the receiving, sending, and exchanging of data between endpoints. Data can be transmitted via voice, video, or both.
Importance of Computer Networks
Users have remote access to information and programmes from the same organisation, from various businesses, or from public sources thanks to computer networks. Computer networks provide faster communication possibilities than conventional infrastructures. With these optimal information and communication opportunities, computer networks may hasten organisational learning, which is considered to be the single fundamental advantage in the present competitive environment.
Types of Computer Networks
There are numerous types of computer networks. The main distinctions between each group are the size of the geographic areas they serve and their main purpose. The various types of computer networks are described below:
Personal Area Networks (PAN) : A sort of networked technology known as a personal area network serves a single user in a single place. It is within 10 metres of the target and suited for small workplaces or houses. One example of an IT-enabled item is a phone. Other examples include computers, video games, and other peripherals.
Local Area Network (LAN) : Similar to a corporation, local area networks are limited to a single structure. It includes a particular area. It is used for sharing resources like file servers, printers, and data storage. Hubs and Ethernet cables are inexpensive to purchase and maintain as LAN hardware. Small LANs can only manage two or three computers, but large LANs can host hundreds of servers. Internet access comes in two flavours: wired and wireless. It is preferred by many establishments because of its speedier speed and less expensive setup.
Metropolitan Area Networks (MAN) : The coverage area of Metropolitan Area Network is significantly larger. MAN can be used to cover a town, city, or university utilising configured computers. Based on connections, MAN can connect two points together or a distance of several miles. A MAN is essentially a network made up of several connected local area networks, or LANs.
Wide Area Networks (WAN): Wide area networks have the ability to connect entire continents and are more geographically widespread than metropolitan area networks. The computers are linked together by a number of cables, optical fibres, or satellites. Users can connect to the network via modems. LANs and MANs were essentially the building blocks of WANs. The internet, which comprises of networks and gateways, is an example of a public WAN.
Home Area Network (HAN) : A home area network can only be used in a home office or other particular physical location. It is a type of wired or wireless IP-based local area network (LAN). Users using wired or wireless modems can access the HAN, a broadband link. It consists of equipment that is shared, such as fax machines, printers, scanners, etc.
Q.2) Explain the meaning of E-wallet. Discuss briefly the factors which have contributed to the adoption of E-wallets in India. (10)
Ans ) An "e-wallet," sometimes known as an "electronic wallet," is a type of electronic card that users can use to keep money similarly to savings accounts and is used to conduct digital transactions made possible via a computer or a smartphone. It is a prepaid facility with the same functions as a credit or debit card. A wide range of products, including groceries and airline tickets, are available for customers to buy.
Factors Contributing to the Adoption of E-wallets in India
Innovators : They are innovators and change agents since they have the original ideas. Mobile wallet technology was developed by younger people, primarily in the age range of 18 to 30, who live in large cities. They use mobile wallets to pay for services like cabs, DTH, phone bills, payments to shops, etc. These customers have a tendency to seek out cutting-edge solutions, and they can grow the user base by convincing others to use the product, thus businesses that offer mobile wallet services must constantly innovate to keep them as customers.
Early Adopters : These are curious individuals that are constantly looking for the most recent trends. They are between the ages of innovators, and according to consumer feedback, they are more likely to try new products if they appear to be useful and wise investments. They are also conversant with other electronic payment methods and mobile banking services. They mostly live in urban and Tier 2 locations. They are only attracted to these mobile wallets if they think they would be safe to use and would make good investments for them.
Early Majority : They are more circumspect users who wait until the technology is well-established. When using innovative products like mobile wallets, these customers search for discounts and spend their money on incredibly targeted offerings. They would employ fewer payment methods than normal because of their routines. The opening discounts offered by mobile wallet companies typically entice them.
Late Majority : These are the people who are waiting to adopt technology till it is unavoidable and accepted. These mobile wallet users are often in the 40 to 55 age range. Most of these users still lack much experience with mobile wallets and prefer debit cards or online transactions instead. Mobile wallet providers will need to enhance the conventional techniques of communicating these customers about their products and benefits in order to earn their trust.
Laggards : They are typically an older generation that never consciously adopts new technologies, making them the last to do so. These customers are older than 55 and struggle utilising smartphones. They prefer to pay in cash, therefore using mobile wallets is uncommon for them.
Q.3) What is multimedia? What are the advantages of learning multimedia? How it can be used in a PowerPoint presentation to make it more effective? (10)
Ans ) Text, images, sound, animation, and video are all combined in a multimedia presentation that the user can interact with electronically or digitally. Multimedia elements include things like text, audio, video, graphics, and animation. Learning about animation and multimedia benefits the work-from-home culture by enabling you to advance your knowledge and abilities as a freelancer rather than being forced to spend the most of your life in a traditional employment. One can make money even from their own home. And the entertainment and music industries account for the majority of its jobs.
Advantages of Learning Multimedia
User Friendly: It is possible to watch the demo while reading the text and listening to the sound when seated because fewer energy users are needed. It can be utilised for a range of audiences, from one person to the entire group.
Multi-Sensory: It makes advantage of several users' senses while using multimedia, such as hearing, seeing, and talking. It can be used with many different audiences, ranging from one individual to the full group.
Comprehensive and Interactive: Throughout the process of integrating digital technology through a number of media. Feedback and simple involvement are now considerably more likely. It is also highly flexible and simple to modify to fit different circumstances and audiences.
Deeper Sympathetic: Multimedia learning takes advantage of the brain's capacity to link verbal and visual representations of knowledge. Deeper thought is the result, and deeper thought encourages the use of what is learnt in varied circumstances.
Improved Problem Solving: In a multimedia learning environment, as opposed to one where instruction is only available through textbooks, students can identify and address issues more rapidly.
Access to a Vast Variety of Information: Thanks to computers, tablets, mobile devices, and the internet, students are better equipped than ever to look up and find the information they require.
Usage of Multimedia in Powerpoint Presentation
A multimedia presentation is a solo presentation that includes content delivered by slides, video, or digital representations in addition to sound, which could be speech, music, or sound effects. With the exception of touch and smell, it is essentially equivalent to face-to-face conversation, especially when presented on a high-resolution life-size screen.
A multimedia presentation often includes at least one of the following components:
Video or movie clip
Navigation structure
The first and most challenging part of the presentation is choosing the technology. There are only Microsoft PowerPoint and Adobe Flash left as viable choices. An overview of Microsoft PowerPoint and Adobe Flash is provided below:
Adobe Flash : Adobe Flash facilitates the development of presentations with effective animation thanks to its superior video compression technique. The ability to directly integrate presentations onto a website is Flash's strongest feature.
Microsoft PowerPoint : If you want to create a multimedia presentation quickly, try Microsoft PowerPoint. Depending on our requirements, we can add video, music, and a reasonable degree of animation to a Microsoft PowerPoint presentation. The main advantage of using PowerPoint to create multimedia presentations is how simple it is for anyone to edit the presentation.
Q.4) What is Software? Differentiate between system software and application software. (10)
Ans ) Software components are in charge of assigning tasks to the proper hardware. Data and other applications are two types of software. Hardware and software that are interconnected are necessary for the device to function. But without the creation of hardware to execute the commands given by software via the central processor unit, software would be meaningless.
Meaning of Software
The instructions that teach hardware how to carry out particular activities are collectively referred to as software, sometimes known as programmes or apps. These instructions are accepted by the platform (operating system + CPU) on which they are based in the format that a programmer provided them. Software may carry out a variety of tasks, in contrast to hardware, which is restricted to the mechanical tasks for which it was designed. Thanks to software, many different tasks can be completed using the same fundamental technology.
Differences between System Software and Application Software
System Software : System software is designed to control and communicate with computer hardware. Direct user interaction with hardware components like the device manager and a number of control panel utilities is made possible by this. On computers and cell phones, it is almost always pre-installed and includes operating systems, device drivers, diagnostic tools, etc. Windows 10, Linux, Macintosh, and Android are among examples.
bSoftware : Application software has the capacity to handle user inputs and help users complete tasks. It allows users to perform one or more tasks and sits on top of the operating system software. Both easy and challenging tasks are included into it. A single piece of software or a group of programmes can make up an application suite. Examples of application software include word processing programmes, web browsing, spreadsheet programmes, presentations, graphics, and multimedia. Modern technologies include things like YouTube, CAD/CAM, emailing, accounting software, specialised shopping apps, and cloud-based programmes like Google Docs, to name just a few.
Q.5) Explain the various components of the Excel screen. (10)
Ans ) The various components of the Excel screen are:
The Microsoft Office Button
It is the button in the top-left portion of the Excel Window. When you click the button, a menu with options for creating new Workbooks, accessing already created Workbooks, saving Workbooks, printing Workbooks, and more appears.
The Quick Access Toolbar
It is located near the Microsoft Office button at the top. You can utilise it to retrieve the commands you frequently use. The Quick Access Toolbar by default shows the following items:
Save : To save your file (you may also press keyboard button (Ctrl + S).
Undo : To roll back the action that you last took (Ctrl + Z).
Redo : To reapply the action you rolled back or to repeat an action (Ctrl + Y).
The Title Bar
It is situated above the Quick Access toolbar at the top. The name of the Workbook you are currently modifying is shown. The first new Workbook is assigned the name Book1 by default. With each new Workbook you open, the number increases by one.
Setting Up Your Excel Environment
You may want to set up your Excel environment and become acquainted with a few key tasks before beginning to work on your spreadsheet. These tasks include, for example, how to show or hide the formula bar, maximise and minimise the Ribbon, customise the Quick Access toolbar, and switch between page views.
Minimize and Maximize the Ribbon
Anywhere on the main menu, right-click.
Minimize the Ribbon can be selected from the pop-up menu. This will activate and deactivate the Ribbon.
Add Commands to Quick Access Toolbar
Select the arrow to the right of the toolbar to customise the fast access toolbar.
From the drop-down menu, select the appropriate command to be added. The command appears on the Quick Access Toolbar.
Display or Hide the Formula Bar
On the Ribbon, select the View tab.
To show or hide the formula bar, check or uncheck the box next to it in the Show/Hide group.
Expand Formula Bar
To expand or collapse the formula bar, click the button.
Customize the Status Bar
Anywhere on the Status Bar, right-click.
The menu that appears allows you to select the settings you want to appear on the Status Bar. Upon selection, a check mark appears in front of the option. Be sure to select the Zoom Slider and View Shortcuts options.
Zoom In and Out
The zoom bar can be seen in the bottom right corner.
To zoom in or out, left-click the slider and drag it to the right or left.
Change Page Views
In the lower right corner, you can see the page view options. To choose a choice, click on it. The many page view choices are:
Normal : This is the default view.
Page Layout : This viewpoint is quite advantageous for printing. When you select this view, the header block, all worksheet margins, the vertical and horizontal rulers, as well as the column and row titles, all change appearance. This image accurately represents how the Workbook would look printed out.
Page Break : You can use this view to observe where the page breaks when printing an Excel sheet that spans many pages.
Customizing the Environment Using Excel Options
You can adjust Excel to your liking by using the Options menu.
Select Microsoft Office from the menu.
The 'Excel Options' button is at the bottom of the menu; click it.
Section – B
(This section contains five short questions of 6 marks each)
Q.6) How are computers helpful to human beings? State the examples of real-world where computers are prominently being used these days. (6)
Ans ) Computers have made human life much faster and easier. It has several advantages:
Multitasking : Computers are capable of processing a trillion instructions per second. With the aid of computers, people may quickly execute a range of tasks, including challenging calculations.
Speed : Tasks that used to take a long time to complete can now be finished in a matter of seconds thanks to computers.
Storage : With the aid of computers, a substantial amount of data may be stored for a very low cost.
Accuracy : The ability of a computer to perform calculations rapidly and precisely is one of its key advantages.
Data Security : Computers can provide security from harmful forces and against unauthorised users' undesirable acts, such as access attacks or cyberattacks, through the use of technologies.
Education : Computers can be used to deliver audio-visual content, interactive exercises, and remote learning, including online instruction. To obtain educational material, they can use intranet, internet, and e-book resources.
Banking and Finance : Modern advanced countries do most of their banking online. You may mail money, pay off credit cards, and check your account balance using computers. To trade stocks, gather stock market data, and manage investments, one can use computer technology.
Q.7) Discuss the benefits and limitations of centralized and decentralized information in business organizations. (6)
Ans ) The benefits and limitations of centralized and decentralized information in business organizations are listed below:
Benefits of Centralization
Since everything is kept in proper order and the higher management authority takes all final decisions, centralization streamlines the decision-making and problem-solving processes.
Higher management levels receive reports from all middle- and lower-level employees. Every lower-level employee must answer to higher authority; thus, they monitor the tasks that higher-level management gives them. It is a factor in increased output and higher-calibre work.
Limitations of Centralization
Officials at higher levels oversee those at lower levels and have the power to take action when necessary.
They are unable to showcase their skills since they are required to follow the laws and instructions of higher authority. They lack motivation at work as a result of the slim chance they have of getting promoted.
Benefits of Decentralization
Decentralization helps to reduce the pressure on higher authorities. Higher authorities can easily concentrate on more important tasks rather than on minor decision-making processes.
Decentralization allows employees to showcase their ideas and expertise.
Limitations of Decentralization
Based on their work history and credentials, many employees must be hired in a decentralised organisation. Because it costs more to hire applicants who are best qualified for the position, this criterion raises the cost of the firm.
Decentralization prevents consistency because every manager has a unique strategy for inspiring workers.
Q.8) What is a cover page of the business report? How you can create one using MS word? (6)
Ans ) Microsoft Word is a great tool for writing reports efficiently. These Microsoft Word features are time-saving productivity tips that will make your work easier. On the first page, your reader will first meet you. Word includes a built-in gallery for the title page. Simply choose one of the available report covers to serve as the cover page for your report.
Creating a Business Report using MS Word
Go to Insert > Pages Group > Cover Page. The cover page appears at the beginning of the document by default.
Microsoft Word offers you 18 pre-formatted templates and three more on Office.com
Q.9) What do you understand by a business presentation? Explain various types of business presentations. (6)
Ans ) Any formal information meant to inform, educate, motivate, and persuade internal and external audiences about the organisation, its offerings, or operations is referred to as a business presentation. Use of audio or visual presentation equipment, such as statistical documents, projectors, flip charts, whiteboards, etc., is the traditional approach for presenting these presentations.
When giving presentations for sales, training, and internal communication programmes, businesses commonly use the power of words and images to capture audiences and maintain their attention. The two most common forms of company presentations are intraorganizational and sales.
Types of Business Presentations
Group Presentations : Team findings are effectively communicated through group presentations. In important business conferences, these are typically used when a senior executive initially presents the overall direction of the company, followed by a number of staff members who offer particular proposals.
Presentation Aids : Due of its simplicity, low cost, and ease of customization, PowerPoint presentations make for effective visual tools. Despite being more expensive, Flash presentations can benefit the audience by including video clips.
Persuasive Presentations : Persuasive presentations persuade the audience to embrace the presenter's recommended solution by providing evidence and examples from related business situations. A presentation to introduce a new product or service or to upgrade equipment could serve as an illustration.
Informative Presentations : An interesting corporate presentation includes status updates and descriptions of marketing plans. Typically, these presentations begin with a generalised goal statement or aim before moving on to specifics and action plans.
Q.10) Explain the various statistical functions available in MS Excel? (6)
Ans ) The various statistical functions available in MS Excel are:
AVERAGE : The average() function results in the arithmetic mean of the numbers entered as arguments to the function e.g. A2:A10 holds the values in numbers than the formula =AVERAGE(A2:A10) provides the average of the given numbers.
COUNT : The count() method does exactly what it says on the tin: it counts the number of arguments supplied to the function as range.
COUNTIF : The countif() function performs as promised by counting the number of arguments passed to the function as a component of the range indicated by the criterion.
FREQUENCY : The array-based frequency() method performs as promised by counting the number of parameters passed in as range in line with the function's requirements.
MAX, MIN : The greatest or least value from the range of input values is provided by these two functions.
(This section contains four short questions of 5 marks each)
Q.11) What is file storage and synchronization? Distinguish between one-way and two-way synchronization. (5)
Ans ) File-level or file-based storage are other names for file storage, which is a hierarchical format for storing data. The data is saved in files and directories, and both the system that stores it and the system that retrieves it show the data in the same way. Depending on the operating system, it can be accessed in a variety of ways, including through the Network File System in Unix or Linux and the Server Message Block protocol in Microsoft Windows.
A method for updating files that are held in many physical locations is file synchronisation. Either "two-way" or "one-way" synchronisation is possible.
The differences between one-way and two-way synchronization are:
One-Way Synchronization : One-way Other names for synchronisation include file backup, file replication, and file mirroring. It requires only one location for file changes. To reconcile the changes, the synchronisation process essentially replicates files in one direction. The target is in one place, while the source is at another. Files are pushed from the source to the target. This is a very practical and efficient backup technique because only changed or new files are replicated.
Two-Way Synchronization : Two-way Other names for synchronisation include bi-directional synchronisation and both-ways synchronisation. This synchronisation process moves files in both directions to allow for the necessary reconciliation of the modifications. The files should be updated in both locations. It is believed that the two locations are comparable.
Q.12) Explain the use of the Hash function in cryptography. (5)
Ans ) Deterministic means that a cryptographic hash function must consistently generate the same hash for a given message.
It should ideally also possess the following characteristics:
The hash value for any message may be determined quickly.
A message cannot be created that generates the desired hash value.
It is impossible to find two distinct messages that have the same hash value.
A small change to a message should cause a change in the hash value that is enough to make it look that the new hash value is unrelated to the old one.
Digital signatures, message authentication codes, and other forms of authentication are some of the information security applications for cryptographic hash functions. They can also be used as standard hash functions, to index data in hash tables, for fingerprinting, to recognise individual files or find duplicate data, and as checksums to find unintended data damage. In reality, although though these terms apply to more general functions with separate properties and objectives, cryptographic hash values are sometimes called fingerprints, checksums, or just hash values in information security contexts.
Q.13) Explain the different types of alignment available in MS Word. (5)
Ans ) The different types of alignment available in MS Word are:
Left-Aligning Text: To apply the left alignment, first choose the content, then choose the Left Alignment icon from the formatting toolbar.
Right-Aligning Text : To get the correct alignment, we must first choose the content and then choose the appropriate Alignment icon from the formatting toolbar.
Centre-Aligning Text : Prior to selecting the centre alignment option from the formatting toolbar, the content must be selected. Additionally, you can adjust the alignment by selecting the toolbar for paragraphs. From the Alignment drop-down list in the Paragraph tool, choose the option to get the desired effect.
Justification: Use the Justification tool to support the paragraph after the alignment is finished. To justify a paragraph, select it first, then select the Justify icon from the formatting toolbar.
Q.14) How is YouTube useful for businesses? (5)
Ans ) If YouTube is actively incorporated into the company's marketing efforts, it can aid in the growth of the company in an affordable manner. YouTube has a variety of applications, including:
Using YouTube for Brand Awareness: Advertisers commonly utilise YouTube to market their goods and spread awareness. Here, rather than promoting particular products or services, the objective is to sell the brand in a manner akin to that of television.
Using YouTube for Advertising Products : YouTube could be used for product promotion. For the category of content that highlights certain products, YouTube would be the best choice because it necessitates a direct strategy that results in videos that are both entertaining and educational.
Using YouTube for Retail Promotion : Several brands utilise YouTube to promote their retail locations. The videos produced in this situation could be general, specifically targeted, or used for brief advertisements.
Using YouTube for Sales : To attract traffic to the website and boost sales, it is best to provide a video of the product being used or a clip of a service that is pertinent to the viewer's question while using YouTube to market goods or services.
Using YouTube for Product/Customer Support : YouTube helps businesses in the support sector focus on something new. The choices include concentrating on client problems and solving them through videos and Q&A. It will benefit future marketers in addition to the clients.
Using YouTube for Training Purpose : For both internal and external purposes, such as product training for events like conferences and meetings, YouTube videos can be used. Additionally, folks who are unable to attend conferences for a number of reasons can purchase these instructive DVDs online from the proper retailers.
100% Verified solved assignments from ₹ 40 written in our own words so that you get the best marks!
Don't have time to write your assignment neatly? Get it written by experts and get free home delivery
Get Guidebooks and Help books to pass your exams easily. Get home delivery or download instantly!
Download IGNOU's official study material combined into a single PDF file absolutely free!
Download latest Assignment Question Papers for free in PDF format at the click of a button!
Download Previous year Question Papers for reference and Exam Preparation for free!
Download Premium PDF
Assignment Question Papers
Which Year / Session to Write?
Get Handwritten Assignments