BBA Online Assessment: End User Computing
Uploaded by
Guardian AlphaBBA Online Assessment: End User Computing
Uploaded by
Guardian AlphaFINAL ONLINE SUMMATIVE ASSESSMENT
Bachelor of Business Administration
Bachelor of Public Administration
Bachelor of Commerce in Accounting
Bachelor of Commerce in Project Management
Bachelor of Commerce in International Business
PROGRAMME
Bachelor of Commerce in Corporate Communication
Bachelor of Commerce in Marketing Management
Bachelor of Commerce in Supply Chain Management
Bachelor of Commerce in Human Resource Management
Bachelor of Commerce in Tourism and Hospitality Management
MODULE End User Computing
YEAR One (1)
INTAKE January 2023 Semester 1
DATE 21 June 2023
SECTION A [100 MARKS]
Answer ALL the questions in this section.
QUESTION ONE (30 Marks)
1.1 Open up an MS Excel blank workbook and save the document as your student number. (2 Marks)
1.2 Copy the following information: (3 Marks)
SALES FOR THE MONTH OF AUGUST 2022
ITEM PRICE VAT
Noodles 20
Luxury Soap 11
Incense sticks 95
5lt H2O 15
1.3 Format the columns to RANDS. (3 Marks)
1.4 Create a formula to calculate 14% VAT on each item. (3 Marks)
1.5 Add a column for the TOTAL and SUM the PRICE and VAT columns. (6 Marks)
1.6 CENTER the table (columns and rows). (3 Marks)
1.7 Insert a bar graph with the information from the table. (5 Marks)
1.8 Insert the graph title as AUG 2022 and axis title as PRICE (2 Marks)
1.9 MERGE and CENTER the table heading. (3 Marks)
NB: Save and Upload the answer document as an Excel document. DO NOT save as a .pdf.
QUESTION TWO (20 Marks)
Information and Communication Technology (ICT) plays a significant role in our daily lives in all that we do.
ICT also impacts many other facets of life. Discuss the effect that ICT has and plays in:
2.1 Industry (10 Marks)
2.2 Education (10 Marks)
QUESTION THREE (30 Marks)
Contrast the following and provide THREE (3) examples of each:
3.1 Primary and secondary memory (10 Marks)
3.2 Input and Output devices (10 Marks)
3.3 System software and Application software (10 Marks)
QUESTION FOUR (20 Marks)
Explain the following concepts and provide examples:
4.1 Web browser (5 Marks)
4.2 Hardware (5 Marks)
4.3 Wide Area Network (WAN) (5 Marks)
4.4 Uniform Resource Locator (URL) (5 Marks)
END OF PAPER
Common questions
Powered by AIA Wide Area Network (WAN) is a telecommunications network that extends over a large geographic area for the primary purpose of computer networking. It connects multiple local area networks (LANs) and is often established via leased telecommunications circuits. An example is the internet, which connects users globally .
The implementation of ICT can radically shift the competitive landscape by allowing businesses to innovate, optimize supply chains, and improve customer interactions through data analysis and digital marketing. It can lead to new business models, such as subscription services and online marketplaces, and facilitate global reach, thus intensifying competition and demanding agility from companies to sustain their market positions .
Input devices allow users to enter data into a computer system, such as keyboards, mice, and scanners. Output devices, however, facilitate the extraction of processed data from a computer, like monitors, printers, and speakers. Both types play essential roles in user interaction with computer systems .
Primary memory, or RAM, is the main memory used by computers to store data temporarily while tasks are being processed. It is fast but volatile, meaning it loses data when power is off. Examples include DDR4 and DDR5 RAM. Secondary memory, conversely, stores data permanently and is non-volatile, such as hard drives, SSDs, and DVDs, ensuring data retention without power .
ICT enhances education by providing access to a vast range of information and learning resources, enabling interactive learning environments, and facilitating distance learning through online platforms. It also encourages collaboration through shared digital tools and improves administrative efficiency within educational institutions .
A Uniform Resource Locator (URL) specifies the location of a resource on the internet, allowing browsers to retrieve it for user access. It typically includes a protocol (such as HTTP), a domain name, and a path to the resource. For example, 'http://www.example.com/page' directs users to a specific web page .
A web browser is a software application used to retrieve, present, and traverse information on the World Wide Web. It enables users to access websites, view content, and perform various online tasks. Examples of web browsers include Google Chrome and Mozilla Firefox .
System software manages the hardware and software resources of the computer, providing a platform for application software to run. Examples include operating systems like Windows and Linux. Application software, however, is designed to perform specific tasks for users, such as word processors or web browsers like Microsoft Word and Chrome, respectively .
ICT significantly impacts the industry by improving efficiency, reducing costs, and enabling innovations in production processes. It facilitates automation, enhances communication within and between businesses, supports data management and analysis, and promotes e-commerce. As a result, companies can achieve higher productivity levels and competitive advantages .
Automating processes in industries through ICT streamlines operations, reduces human error, and increases production speed. It allows for precise control over manufacturing processes and enables the efficient allocation of resources. This leads to higher quality products and reduced operational costs, thereby enhancing a company's market competitiveness .