WAEC SSCE - Computer Studies - 2021

What type of relationship can you deduce from the statement a department has many employees?

Answer Details

The type of relationship that can be deduced from the statement "a department has many employees" is a "one-to-many" relationship. In a one-to-many relationship, one entity in a database is related to many instances of another entity. In this case, the "department" entity is related to many instances of the "employee" entity. This means that a single department can have multiple employees working for it, but each employee can only be associated with one department at a time. For example, in a database that tracks employee information for a company, there might be a "departments" table and an "employees" table. The "departments" table would contain information about each department in the company, such as the department name and manager, while the "employees" table would contain information about each employee, such as their name, job title, and department ID. The department ID field in the "employees" table would be used to establish the one-to-many relationship between the "departments" and "employees" tables. Each employee record would have a department ID that corresponds to a department record in the "departments" table, allowing the database to link employees to their respective departments. Overall, the one-to-many relationship between departments and employees is a common type of relationship in many database systems, and is useful for organizing and managing large amounts of related data.

Use figure 4 to answer question 23

The basic problem with the flow chart is that it has 

The figure 2 in the number 1101\(_2\) is indicated in MS Word using a feature called 

Answer Details

The figure 2 in the number 1101\(_2\) is indicated in MS Word using the superscript feature. The superscript feature in MS Word is used to format text or numbers in a smaller font size and raised above the normal line of text. In this case, the superscript feature can be used to raise the number 2 above the rest of the binary number 1101, indicating its position as the second power or exponent of the base number 2. Therefore, to indicate the number 2 in the binary number 1101\(_2\) using MS Word, you can type "1101^2" where the superscript feature is used to raise the number 2. The resulting output will be "1101²" with the 2 raised and in a smaller font size.

Quantitative data can exist in 

Answer Details

Quantitative data can exist in both continuous and discrete forms. Continuous data can take on any value within a range, such as height or weight, and is typically measured using a scale. Discrete data, on the other hand, can only take on specific values, such as the number of children in a family or the number of pets someone has. Both forms of data can be used to perform mathematical operations and statistical analyses, and can provide valuable insights into a wide range of phenomena. For example, quantitative data can be used to study trends in population growth, track changes in consumer behavior, or explore the relationship between variables in scientific research.

The logical equation for the logic circuit in Figure 3 is

Answer Details

The logic circuit in Figure 3 has two inputs, A and B, and one input C. The output is Z. Looking at the circuit, we can see that the input C is connected directly to the output Z. This means that the value of C will always be present in the output Z, regardless of the values of A and B. The two inputs A and B are connected to an OR gate, and the output of the OR gate is connected to a NOT gate. The NOT gate inverts the output of the OR gate, which means that if the OR gate output is 0 (i.e., A and B are both 0), then the NOT gate output will be 1. Conversely, if the OR gate output is 1 (i.e., at least one of A or B is 1), then the NOT gate output will be 0. So, the overall logic equation for the circuit is: Z = \(\overline{A+B}\) \(\overline{C}\) In other words, the output Z is the logical NOT of the OR of A and B, ANDed with the logical NOT of C.

The use of natural language and symbols to write instructions for the computer is called

Answer Details

The use of natural language and symbols to write instructions for the computer is called "high level language programming". High level programming languages use human-readable instructions and structures to write programs that can be understood by both humans and computers. Examples of high level programming languages include Python, Java, and C++. In contrast, machine language programming and assembly language programming use low level instructions and binary code that are difficult for humans to read and understand. Algorithm language programming is not a commonly used term in programming and may refer to the use of algorithms in programming, rather than a specific language.

Which of the following stages of the SDLC is post operational stage?

Use the logic gate in Fig 2 to answer question 13.

Which of the following statements is true about logic gates X and Y?

The Slide Rule is accurate to 

Use Figure 4 to answer question 25

If N in the flowchart is represented by 10, which of the following conditions is not true?

Answer Details

The condition "If C = 10, stop picking orange" is not true based on the flowchart in Figure 4. If N is represented by 10, then when C is equal to 10, the flowchart shows that the next step is to "continue picking orange", not to "stop picking orange".

A collection of wires through which data are transmitted from one part of the computer to another is known as 

Answer Details

A collection of wires through which data are transmitted from one part of the computer to another is known as a bus. A bus is a set of wires that transfer data and information between different components in a computer. It acts like a highway for data to travel from one place to another within the computer. In simple terms, a bus is like a pathway that allows different parts of the computer to communicate and exchange information with each other.

Which of the following descriptions is not true about data?

Answer Details

The statement "data is unorganized" is not true. Data can be either organized or unorganized. Data refers to a collection of raw facts and figures that have not been processed or analyzed. However, this data can be organized into a more meaningful format, such as tables, charts, or graphs, that can make it easier to understand and analyze. Once data is organized and analyzed, it can be converted into information, which is used for decision making. Therefore, all the other descriptions are true: data can be converted to information, it is a collection of raw facts and figures, and it is used for decision making.

Which of the following options is not a similarity between computer file and manual file? Both can 

Answer Details

The option that is not a similarity between a computer file and manual file is "store multimedia." Both computer files and manual files can be accessed and retrieved to obtain the information contained within them. A manual file might refer to a physical document or record, while a computer file is a digital representation of data stored on a computer system, but in both cases, the information can be retrieved and accessed. Both types of files can contain information, such as text, numbers, or images. However, manual files may be limited in the type of information they can store, as they are physical documents, while computer files can store a wide range of information, including multimedia like videos, audio, and animations. Therefore, while both types of files share similarities in terms of accessibility, retrieval, and information storage, the ability to store multimedia is a feature that is unique to computer files.

The "/exams"in the web address; https;//www.waec.org.ng/exams is called 

The total possible combinations of th input variables for a logic gate containing three input variables is 

What factors will motivate a field engineer into choosing a notebook computer over a desktop computer?

Answer Details

Field engineers are professionals who perform their work outside the office or in the field. When it comes to choosing a computer, factors such as cost, size, convenience, and battery life are essential to consider. Among the given options, the factors that will most likely motivate a field engineer to choose a notebook computer over a desktop computer are size, convenience, and battery life. Size: A notebook computer is more portable and lightweight compared to a desktop computer. It can easily fit into a bag or backpack, making it easy to transport from one location to another. This is essential for field engineers who need to move around to different job sites. Convenience: A notebook computer is also more convenient than a desktop computer because it does not require a power outlet to function. A field engineer can use the notebook computer on the go without worrying about finding a power source. Additionally, a notebook computer allows for more flexibility when it comes to where work can be done, as it can be used in a car or at a remote job site. Battery life: A notebook computer's battery life is an important factor for field engineers who may not have access to a power source for an extended period. A notebook computer with a long battery life allows field engineers to work for extended periods without needing to recharge the device. Cost is also an important consideration for any professional, including field engineers. However, the convenience and portability of a notebook computer make it a more attractive option for field engineers who need to work on the go. Overall, the factors that are most likely to motivate a field engineer to choose a notebook computer over a desktop computer are size, convenience, and battery life.

Which of the following statements about URL is true? It is

Answer Details

The statement that is true about URL is that it is "the address of a document or 'page' on the World Wide Web". URL stands for Uniform Resource Locator and it is a reference to the web resource that specifies its location on the internet. In simpler terms, a URL is the web address of a specific page or document on the internet. URLs consist of several parts, including the protocol (such as http or https), the domain name or IP address of the server where the resource is located, and the path to the specific file or document. The other options are not true about URL. A URL is not a computer software program, a type of web server, or an acronym for unlimited resources for learning.

The part of the MS Word interface labelled II in Figure 10 is called 

Answer Details

The part of the MS Word interface labelled II in Figure 10 is called "Print Layout". This option allows users to view their document as it would appear on a printed page. It shows page margins, page breaks, headers and footers, and other elements that are important for formatting a printed document. Users can use this view to make sure their document looks the way they want it to before printing.

A computer system on the network that stores pages, takes request from clients as well as send out information is called a 

Answer Details

A computer system on the network that stores web pages, takes requests from clients, and sends out information is called a "web server". A web server is a program or a computer that stores, processes, and delivers web pages to clients on request. When a user enters a website's URL into a web browser, the browser sends a request to the web server asking for the website's content. The web server then responds by sending the requested web pages and files to the user's web browser, which displays them on the screen. Web servers use protocols like HTTP (Hypertext Transfer Protocol) to communicate with clients and deliver web pages. Examples of web servers include Apache, Nginx, and Microsoft IIS.

The part of the graphic interface in Figure 8 labelled V is called 

Answer Details

The part of the graphic interface labelled V in Figure 8 is called "fit to window". This option allows you to automatically adjust the size of the image or graphic to fit within the boundaries of the window or screen. For example, if you have an image that is too large to be displayed on your screen without scrolling or resizing, you can select the "fit to window" option and the image will be automatically scaled down to fit within the dimensions of the window or screen. This can be a helpful feature for working with large images or graphics, as it allows you to view them in their entirety without having to scroll or zoom in and out manually.

The binary number 0.1101 in decimal is 

Evaluate 10011\(_2\) - 1111\(_2\) 

The file access method shown in Figure 12 is called 

The type of network represented in Figure 7 is called 

Use Figure 4 to answer question 24

What activity is the flowchart made to represent?

The part of the MS Access interface labelled X in Figure 9 is called 

The windows shortcut key for closing an active application is

Answer Details

The windows shortcut key for closing an active application is Alt+F4. When you press the Alt+F4 keys on your keyboard, it sends a signal to the currently active application that you want to close it. This can be useful when you want to quickly exit a program that you are no longer using. The Alt+F4 shortcut is designed to work with most applications in Windows, including web browsers, text editors, and media players. When you press Alt+F4, the program will usually ask if you want to save any changes you've made before closing. It's important to note that Alt+F4 will only close the active application, which means that if you have multiple programs open, you'll need to switch to each one and press Alt+F4 individually to close them. In summary, Alt+F4 is a simple and convenient shortcut key that can help you quickly close applications in Windows.

A single character in an EBCDIC encoding system can be represented using 

Answer Details

A single character in an EBCDIC encoding system is represented using 8 bits. This means that each character is represented by a unique combination of 8 binary digits, or bits. 8 bits provides enough combinations to represent a wide range of characters, including letters, numbers, and special symbols. This allows EBCDIC to support a variety of character sets and languages, making it a flexible and widely-used encoding system.

COBOL was developed for 

Answer Details

COBOL (Common Business Oriented Language) was developed specifically for business operations. It was created in the late 1950s and early 1960s, during a time when computers were becoming more prevalent in the business world. COBOL was designed to handle large amounts of data, particularly data related to business transactions and financial records. It was intended to be an easy-to-learn language that could be used by non-technical people, such as business analysts and accountants, to write computer programs. Today, COBOL is still used by many organizations for legacy systems that were developed using the language.

What is the least number of 750 MB capacity CD-ROM discs needed to transfer 10 GB size file?

Changing the default settings or appearance of the Taskbar in windows by a user is known as 

Answer Details

The correct answer is "customization." Customization refers to the process of changing the default settings or appearance of the Taskbar in Windows by a user. This can include changing the position of the Taskbar, resizing it, changing its color or transparency, and adding or removing icons. Customizing the Taskbar allows users to personalize their computing experience and make their workflow more efficient by tailoring the Taskbar to their specific needs and preferences.

The fundamental purpose of the BIOS is 

Which of the following formulas will display the current seconds past the minute os the clock in MS Excel?

The following actions are the effects of virus infection in a system except

Answer Details

Virus infections can cause various harmful effects on a computer system, but among the given options, the action that is not an effect of virus infection is hard disk failure. A virus is a malicious software program that can infect a computer system, replicate itself and spread to other systems. Once a virus infects a system, it can cause various problems such as deleting files, slowing down the system's operation, and displaying unwanted messages. Deletion of files: A virus can delete important files or programs on a system, making it difficult or impossible to use certain applications or access certain data. Slow operation: A virus can consume a significant amount of a system's resources, which can cause the computer to operate slowly and inefficiently. This can cause frustration and hinder productivity. Display of unwanted messages: A virus can display pop-up messages or advertisements that are unwanted and can be distracting or harmful. These messages may also try to trick the user into downloading more harmful software. Hard disk failure: While a virus can cause data loss and corruption, it is not typically the direct cause of hard disk failure. Hard disk failure is usually due to physical damage or wear and tear over time. In summary, a virus infection can cause several negative effects on a computer system, including file deletion, slow operation, and display of unwanted messages. However, hard disk failure is not typically caused by a virus.

Use the logic gate in Fig 2 to answer question 12.

Which of the logic gates will give an output opposite to the input state?

In Figure 6 the signals from modem X to modem Y is 

Answer Details

The correct answer is either "analogue" or "digital," depending on the type of signal being transmitted. Analog signals are continuous, meaning they can take on any value within a range of values, whereas digital signals are discrete, meaning they can only take on specific, predetermined values. Without more information or context about the specific signals being transmitted in Figure 6, it is impossible to determine whether the signals are analogue or digital. However, it is safe to assume that they are one of these two types, as these are the most common types of signals used for communication between modems. In summary, the answer to the question "In Figure 6 the signals from modem X to modem Y is?" is either "analogue" or "digital," depending on the type of signal being transmitted.

Data created by the user is called 

Answer Details

Data created by the user is called primary data. This refers to information that is collected directly by the person or organization that needs it, typically through surveys, experiments, or observations. Primary data is unique to the specific research question or problem and is tailored to meet the specific needs of the user. It is usually more accurate and reliable than secondary data, which is data that has been collected and reported by someone else for another purpose. Examples of primary data include customer feedback surveys, laboratory experiments, and field observations.

The device is Figure 5 uses a transmission method called 

Which of the following statements is true about super computers? They

Answer Details

The statement that is true about supercomputers is that they can process billions of operations in a second. Supercomputers are designed to perform complex and sophisticated computations that are beyond the capabilities of regular computers. They are capable of processing enormous amounts of data and performing multiple calculations simultaneously, which allows them to solve complex problems that regular computers cannot. However, they are typically large, expensive machines that are used in specialized fields such as scientific research, engineering, and weather forecasting, among others. They are not commonly found in homes and offices due to their high cost and specialized nature.

The sequence of operation of a computer is 

Answer Details

The sequence of operation of a computer is as follows: 1. Input: The computer accepts data or information from input devices such as a keyboard, mouse, microphone, or scanner. 2. Processing: The computer processes the input data by performing operations on it using its central processing unit (CPU), memory, and other components. The processing involves performing arithmetic and logical operations on the data, manipulating it, and storing it in memory. 3. Output: After processing the data, the computer produces output in the form of information or results. The output can be displayed on a screen, printed on paper, or sent to other devices such as a speaker or a network. In summary, the sequence of operation of a computer involves accepting input data, processing it using the CPU and memory, and producing output in the form of information or results.

The part of the computer system shown in Figure 11 is used to 

Answer Details

The part of the computer system shown in Figure 11 is used to power on or off the computer. The figure shows a power button symbol, which is typically used to turn on or off the computer. When you press the power button, the computer's power supply sends electricity to the motherboard, which then initializes the various components in the computer and starts up the operating system. Pressing and holding the power button for a few seconds can force the computer to shut down in case it's not responding or has frozen. Therefore, the power button is an essential component of any computer system, allowing users to turn it on and off as needed.

The IF... THEN statement in BASIC is called 

The operation of a computer and peripherals attached to it is controlled by

Answer Details

The operation of a computer and its peripherals is controlled by the system software. System software, also known as the operating system, is the software that manages and controls the computer hardware and other software programs. It acts as a bridge between the computer hardware and the user, allowing the user to interact with the computer and run different applications. Examples of popular operating systems are Windows, MacOS, and Linux. The operating system manages the computer's memory, processing power, and input/output operations, ensuring that all components work together smoothly and efficiently.

The screen background where icons and windows are displayed is GUI is called 

To prevent unforeseen data loss, a user must 

Answer Details

To prevent data loss, a user must backup the data. This means making a copy of important files and storing them in a safe place, such as an external hard drive or cloud storage. This way, if the original data gets lost or damaged, the user still has a copy that they can use to restore the data.

A computer program that gathers information about a person or organization without their knowledge or consent  is known known as

The logic gates represented in Figure 1 is called 

Answer Details

The logic gates represented in Figure 1 are called NAND gates. A NAND gate is a digital logic gate that gives an output of "low" (logic 0) only when all of its inputs are "high" (logic 1). In all other cases, the output of a NAND gate is "high" (logic 1). In Figure 1, there are two inputs connected to a NAND gate symbol (which looks like an AND gate with a small circle at the output). This indicates that the gate performs the NAND function on its inputs.

The expression 5 + 3*4/2 - 3^2 in QBASIC evaluate to

The operating system performs the following operations except  

Answer Details

The operating system does not perform the operation of "creation of data". This operation is typically performed by the user or other software programs running on the system. The operating system's role is to manage and organize the data and resources of the computer, but it does not create new data.

In MS Excel, the cell that contains the pointer or cursor is called

Answer Details

The cell in MS Excel that contains the pointer or cursor is called the "Active Cell". An active cell is the cell that is currently selected and ready to accept input. It is the cell in which you can type or edit data. The active cell is surrounded by a border and is the cell that is currently in use in the worksheet. This makes it easy to identify and is the cell that will be affected by any actions you take in the worksheet.

TEST OF PRACTICAL KNOWLEDGE QUESTION

Use Microsoft Word application to reproduce the circles with lines R\(_{1}\), R\(_{2}\) and R\(_{3}\) as shown in Figure 1 and perform the following tasks.
(a) Lines R\(_{1}\), R\(_{2}\) and R\(_{3}\) should be of different lenght.
(b) Label R\(_{1}\), R\(_{2}\) and R\(_{3}\) should be of different fonts.
(c) You are provided with Table 1. Complete the table.

(d) Group the circles in Figure 1.
(e) Insert a text box and type in your full name as the file name 
(f) Insert a footer and type in your full namd and index number
(g) Save your work in the folder created on the desktop using your full name as the file name.
(h) Print your work and submit to the supervisor.

Answer Details

None

TEST OF PRACTICAL KNOWLEDGE QUESTION

(a) Using the star shape tool in CorelDraw, draw a 30 pts star of diameter 18 cm and fill it with grey colour.

(b) Use sharpness tool to adjust the corner sharpness of the star by 25 pts.

(c) Place three circles; circle 1, circle 2 and circle 3 with diameters 10 am, 7.6 cm and 5.4 cm respectively inside the star.

(d) Use Text tool to type ARISE AND SHINE and place it in-between circle 2 and 3.

(e) Fill cicle2 with lemon colour and circle 3 with white colour.

(f) Place five stars inside circle 3.

(g) Group your drawing.

(h) Type in your full name as a footer.

(i) Save and print your work.

(j) Submit your printout to the supervisor.

Answer Details

None

(a)(i) Define computer graphics.

(ii) List two applications of computer graphics in advertising.

(b) Give one use of the following computer graphics application tools;

(i) Interactive Fill Tool (ii) Texture Fill Tool (iii) Envelops Tool (iv) Extrude Tool 

(c) Name one Fill Tool in computer graphic application which is needed to (i) create a background that is faded from light blue to white (ii) fill an object with two colours that blend from one to another.

Answer Details

None

TEST OF PRACTICAL KNOWLEDGE QUESTION

A supermarket listed ten items on sale.
Use Microsoft Excel application to create an inventory for the supermarket.
(a) Type in the following headings from cell A1 to F1 respectively.
SN, Goods Cost Price, Selling Price, Gain/Loss and Target.

(b) Populate the table by supplying ten different items sold in a supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. Similarly, list the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell B2 to B11. Supply Cost Price and Selling Price from cells C2 to C11 and D2 to D11 respectively. Note that it is possible to have some selling prices lower than the cost price. Create borders around the table.

(c) Use formula or function to calculate; (i) the gain (if the selling price is higher than the cost price) or the loss (if the cost price is higher than the selling price) of each item from cells E2 to E11 
(ii) 110% of the cost price of each item from cells F2 to F11.

(d) Determine whether target is met or not by typing "target met" or "target not met" in cells H2 to H11 for each item.
Note that target is met when the selling price is 110% of the cost price or more otherwise target is not met.

(e) Insert a footer and type in your full name  and index number.

(f) Save your work in the folder created on the desktop using your full name as th file name.

(g) Print your work showing formulas and functions and submit to the supervisor. 
 

Answer Details

None

Perform the following conversions in the stated number bases;

(a) AB1\(_{16}\) to Octal system

(b) 1110111.101\(_2\) to Denary system 

(c) 507\(_2\) to Binary system.

Answer Details

None

Write a QBASIC program to grade any score entered from the keyboard as either "Poor" for a score that is below 50% or "Satisfactory" for a score that is equal to or above 50%. The program execution should stop as soon as a score that is less than zero is entered.

Answer Details

None

(a) What are "Reports" in a database system?

(b) List four (4) ways in which Reports can be viewed in database management system.

(c) Outline the steps to prints a Report in MS Access.

Answer Details

None

(a)(i) What is Universal Serial Bus (USB)?

(ii) State two benefits of using USB connection between a computer and another device.

(b) In Table 1, three storage devices are described, Use it to answer questions 3(b)(i) and 3(b)(ii).

(i) In column 2, name the storage device being described in column 1.

(ii) Show the category of storage device being described in column 1 by ticking in any of the column 3, 4 or 5

Answer Details

None