WAEC SSCE - Computer Studies - 2021
Question 1 Report
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.
Question 2 Report
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.
Question 3 Report
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.
Question 4 Report
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.
Question 6 Report
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.
Question 7 Report
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".
The type of network represented in Figure 7 is called Question 9 Report
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.
Question 11 Report
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.
Question 12 Report
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.
Question 13 Report
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.
Question 15 Report
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.
Question 16 Report
Use figure 4 to answer question 23
The basic problem with the flow chart is that it has
Answer Details
Question 17 Report
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.
Question 18 Report
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.
Question 19 Report
A computer program that gathers information about a person or organization without their knowledge or consent is known known as
Answer Details
Spyware is specifically designed to covertly collect information about a person or organization without their knowledge or consent. Unlike adware, which displays advertisements, a time bomb, which is a type of malware that is set to execute at a specific time, or a trojan horse, which disguises itself as a legitimate program but carries out harmful actions, spyware focuses on gathering sensitive information such as browsing habits, keystrokes, personal data, and other confidential information. This information is then typically transmitted to third parties without the user's consent, posing significant privacy and security risks. Therefore, spyware fits the description of a computer program that gathers information without the user's knowledge or consent, making it the correct choice for the given question.
Question 20 Report
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.
Question 21 Report
The "/exams"in the web address; https;//www.waec.org.ng/exams is called
Question 22 Report
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.
Question 23 Report
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.
Question 24 Report
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.
Question 26 Report
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.
Question 27 Report
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.
Question 28 Report
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.
Question 29 Report
Which of the following stages of the SDLC is post operational stage?
Answer Details
Question 30 Report
The screen background where icons and windows are displayed is GUI is called
Answer Details
Question 31 Report
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.
Question 32 Report
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?
Answer Details
Question 33 Report
Which of the following formulas will display the current seconds past the minute os the clock in MS Excel?
Answer Details
Question 34 Report
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.
Question 35 Report
What is the least number of 750 MB capacity CD-ROM discs needed to transfer 10 GB size file?
Answer Details
To transfer a 10 GB file, you need to find out how many 750 MB CD-ROM discs you would need. Each CD-ROM has a capacity of 750 MB, so you need to divide 10 GB by 750 MB to find out the number of discs required. 10 GB / 750 MB = 13.333 Since you can't have a fraction of a CD, you would need to round up to the nearest whole number. Therefore, you would need 14 CD-ROM discs to transfer a 10 GB file.
Question 36 Report
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.
Question 38 Report
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.
Question 39 Report
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.
Question 40 Report
Use Figure 4 to answer question 24
What activity is the flowchart made to represent?
Answer Details
Question 41 Report
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.
Question 43 Report
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.
The device is Figure 5 uses a transmission method called Question 45 Report
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.
Question 46 Report
Use the logic gate in Fig 2 to answer question 13.
Which of the following statements is true about logic gates X and Y?
Answer Details
Question 48 Report
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.
Question 49 Report
The part of the MS Access interface labelled X in Figure 9 is called
Answer Details
Question 50 Report
The total possible combinations of th input variables for a logic gate containing three input variables is
Answer Details
Question 51 Report
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
Question 52 Report
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.
To write a QBASIC program that grades a score as "Poor" or "Satisfactory", follow these steps:
- Start by declaring the necessary variables. We need a variable to store the score entered from the keyboard, and another variable to store the grade.
- Next, use the INPUT statement to prompt the user to enter a score. Then, use the VAL function to convert the input to a numerical value and store it in the score variable.
- Use an IF-THEN statement to check if the score is less than zero. If it is, the program should stop executing using the END statement.
- If the score is not less than zero, use another IF-THEN statement to check if the score is less than 50%. If it is, assign the grade "Poor" to the grade variable. If the score is 50% or greater, assign the grade "Satisfactory" to the grade variable.
- Finally, use the PRINT statement to display the grade to the user.
Here's the complete QBASIC program:
REM Program to grade a score as "Poor" or "Satisfactory"
DIM score AS INTEGER DIM grade AS STRING
DO INPUT "Enter score (enter a negative number to quit): ", score IF score < 0 THEN END END IF IF score < 50 THEN grade = "Poor" ELSE grade = "Satisfactory" END IF PRINT "Grade: "; grade LOOP
END
When the program is run, it will prompt the user to enter a score. If the score is less than zero, the program will stop executing. If the score is greater than or equal to zero, the program will grade the score as "Poor" or "Satisfactory" and display the grade to the user. The program will continue to prompt the user for scores until a negative number is entered.
Answer Details
To write a QBASIC program that grades a score as "Poor" or "Satisfactory", follow these steps:
- Start by declaring the necessary variables. We need a variable to store the score entered from the keyboard, and another variable to store the grade.
- Next, use the INPUT statement to prompt the user to enter a score. Then, use the VAL function to convert the input to a numerical value and store it in the score variable.
- Use an IF-THEN statement to check if the score is less than zero. If it is, the program should stop executing using the END statement.
- If the score is not less than zero, use another IF-THEN statement to check if the score is less than 50%. If it is, assign the grade "Poor" to the grade variable. If the score is 50% or greater, assign the grade "Satisfactory" to the grade variable.
- Finally, use the PRINT statement to display the grade to the user.
Here's the complete QBASIC program:
REM Program to grade a score as "Poor" or "Satisfactory"
DIM score AS INTEGER DIM grade AS STRING
DO INPUT "Enter score (enter a negative number to quit): ", score IF score < 0 THEN END END IF IF score < 50 THEN grade = "Poor" ELSE grade = "Satisfactory" END IF PRINT "Grade: "; grade LOOP
END
When the program is run, it will prompt the user to enter a score. If the score is less than zero, the program will stop executing. If the score is greater than or equal to zero, the program will grade the score as "Poor" or "Satisfactory" and display the grade to the user. The program will continue to prompt the user for scores until a negative number is entered.
Question 53 Report
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.
To perform the tasks outlined in the question, follow these steps:
(a) To make the lines R1, R2, and R3 different lengths: You can use the Shapes tool in Microsoft Word to draw each line. To do this, go to the Insert tab, click on Shapes, select a line shape, and draw it on the page. To adjust the length of the line, click on one of its ends and drag it to the desired length. Repeat the process for the other two lines, making sure each line has a different length.
(b) To label each line with a different font: Simply select the line and go to the Home tab. In the Font section, select a font from the drop-down menu and type in the label (e.g., R1, R2, or R3). Repeat the process for the other two lines, making sure each label has a different font.
(c) To complete Table 1: Simply follow the instructions provided in the question and fill in the appropriate information.
(d) To group the circles in Figure 1: Select all of the circles by holding down the Shift key while clicking on each one. Right-click on one of the selected circles and choose the Group option. This will group the circles together so that they can be moved and resized as a single object.
(e) To insert a text box: Go to the Insert tab, click on Text Box, and choose a text box style. Type in your full name in the text box.
(f) To insert a footer: Go to the Insert tab, click on Footer, and choose a footer style. Type in your full name and index number in the footer.
(g) To save your work: Go to the File tab, click on Save As, and choose a location (e.g., the folder created on the desktop). Give your file a name that includes your full name.
(h) To print your work: Go to the File tab, click on Print, and follow the instructions to print the document. After printing, submit the printed copy to the supervisor.
I hope these steps are helpful and simple to understand!
Answer Details
To perform the tasks outlined in the question, follow these steps:
(a) To make the lines R1, R2, and R3 different lengths: You can use the Shapes tool in Microsoft Word to draw each line. To do this, go to the Insert tab, click on Shapes, select a line shape, and draw it on the page. To adjust the length of the line, click on one of its ends and drag it to the desired length. Repeat the process for the other two lines, making sure each line has a different length.
(b) To label each line with a different font: Simply select the line and go to the Home tab. In the Font section, select a font from the drop-down menu and type in the label (e.g., R1, R2, or R3). Repeat the process for the other two lines, making sure each label has a different font.
(c) To complete Table 1: Simply follow the instructions provided in the question and fill in the appropriate information.
(d) To group the circles in Figure 1: Select all of the circles by holding down the Shift key while clicking on each one. Right-click on one of the selected circles and choose the Group option. This will group the circles together so that they can be moved and resized as a single object.
(e) To insert a text box: Go to the Insert tab, click on Text Box, and choose a text box style. Type in your full name in the text box.
(f) To insert a footer: Go to the Insert tab, click on Footer, and choose a footer style. Type in your full name and index number in the footer.
(g) To save your work: Go to the File tab, click on Save As, and choose a location (e.g., the folder created on the desktop). Give your file a name that includes your full name.
(h) To print your work: Go to the File tab, click on Print, and follow the instructions to print the document. After printing, submit the printed copy to the supervisor.
I hope these steps are helpful and simple to understand!
Question 54 Report
(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.
a) Reports in a database system are formatted outputs that present selected data from one or more tables in an organized and easily readable manner. They allow users to summarize and analyze data, track trends, and make informed decisions based on the information provided.
b) The four ways in which reports can be viewed in a database management system are:
- Print: Reports can be printed on paper for easy reference.
- Screen View: Reports can be viewed on a computer screen or monitor.
- Preview: Reports can be previewed on the screen to verify that they contain the desired information and to check the formatting.
- Export: Reports can be exported to other formats such as PDF or Excel for further analysis or sharing.
c) To print a report in MS Access, follow these steps:
- Open the database and navigate to the "Reports" section.
- Select the report you want to print.
- Click on the "Print" button in the "Print Preview" tab or the "Print" tab.
- In the "Print" dialog box, select the printer you want to use.
- Select the number of copies you want to print.
- Choose any additional print options you want, such as double-sided printing or collation.
- Click the "Print" button to start printing the report.
- Wait for the printer to finish printing the report.
- Collect the printed report from the printer and verify that it contains the desired information and is formatted correctly.
Overall, printing a report in MS Access is a straightforward process that involves selecting the report, choosing the printer and print options, and clicking the "Print" button. The resulting report can then be used for further analysis or distributed to other users for their reference.
Answer Details
a) Reports in a database system are formatted outputs that present selected data from one or more tables in an organized and easily readable manner. They allow users to summarize and analyze data, track trends, and make informed decisions based on the information provided.
b) The four ways in which reports can be viewed in a database management system are:
- Print: Reports can be printed on paper for easy reference.
- Screen View: Reports can be viewed on a computer screen or monitor.
- Preview: Reports can be previewed on the screen to verify that they contain the desired information and to check the formatting.
- Export: Reports can be exported to other formats such as PDF or Excel for further analysis or sharing.
c) To print a report in MS Access, follow these steps:
- Open the database and navigate to the "Reports" section.
- Select the report you want to print.
- Click on the "Print" button in the "Print Preview" tab or the "Print" tab.
- In the "Print" dialog box, select the printer you want to use.
- Select the number of copies you want to print.
- Choose any additional print options you want, such as double-sided printing or collation.
- Click the "Print" button to start printing the report.
- Wait for the printer to finish printing the report.
- Collect the printed report from the printer and verify that it contains the desired information and is formatted correctly.
Overall, printing a report in MS Access is a straightforward process that involves selecting the report, choosing the printer and print options, and clicking the "Print" button. The resulting report can then be used for further analysis or distributed to other users for their reference.
Question 55 Report
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.
To create an inventory for the supermarket using Microsoft Excel, follow these steps:
(a) In cell A1 to F1 respectively, type in the following headings: SN, Goods Cost Price, Selling Price, Gain/Loss, and Target.
(b) Populate the table with ten different items sold in the supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. List the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell 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 formulas or functions 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 using the formula: =D2-C2.
(ii) 110% of the cost price of each item from cells F2 to F11 using the formula: =C2*1.1.
(d) Determine whether the target is met or not by typing "target met" or "target not met" in cells H2 to H11 for each item. Note that the target is met when the selling price is 110% of the cost price or more; otherwise, the target is not met. Use the formula: =IF(D2>=F2,"target met","target 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 the file name.
(g) Print your work showing formulas and functions and submit it to the supervisor.
In summary, to create an inventory for a supermarket using Microsoft Excel, you need to add headings, populate the table with the necessary information, use formulas or functions to calculate the gain/loss and target, and insert a footer with your name and index number. Finally, save your work using your name as the file name and print your work showing formulas and functions before submitting it to your supervisor.
Answer Details
To create an inventory for the supermarket using Microsoft Excel, follow these steps:
(a) In cell A1 to F1 respectively, type in the following headings: SN, Goods Cost Price, Selling Price, Gain/Loss, and Target.
(b) Populate the table with ten different items sold in the supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. List the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell 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 formulas or functions 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 using the formula: =D2-C2.
(ii) 110% of the cost price of each item from cells F2 to F11 using the formula: =C2*1.1.
(d) Determine whether the target is met or not by typing "target met" or "target not met" in cells H2 to H11 for each item. Note that the target is met when the selling price is 110% of the cost price or more; otherwise, the target is not met. Use the formula: =IF(D2>=F2,"target met","target 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 the file name.
(g) Print your work showing formulas and functions and submit it to the supervisor.
In summary, to create an inventory for a supermarket using Microsoft Excel, you need to add headings, populate the table with the necessary information, use formulas or functions to calculate the gain/loss and target, and insert a footer with your name and index number. Finally, save your work using your name as the file name and print your work showing formulas and functions before submitting it to your supervisor.
