WAEC SSCE - Computer Studies - 2022 (Essay)
Question 1 Report
(a) Create a;
(i) database and save as WASSCE in the folder on the desktop.
(i) table with headings as shown in Table 2 (11 rows).
Define the fields appropriately. Save the table as the customers.
Set CustomlD as primary key
| Custom ID | first name | last name | telephone | address |
[iii] form from the customers and save as REFORM
[b] Enter ten records of your choice using the
Form created in (a)(ii).
(c) Write a query to retrieve the First Name and Telephone.
(d) Design a report using (c).
(e) Insert a footer and type in your full name
This question is asking you to create a database with a table called "customers" and define the fields appropriately with the "Custom ID" as the primary key. Then, you need to create a form from the "customers" table and save it as "REFORM". After that, you will enter ten records of your choice using the form. Next, you will write a query to retrieve the "First Name" and "Telephone" fields from the "customers" table. You will then use the retrieved data to design a report. Finally, you will insert a footer into the report and type in your full name.
In summary, this question is testing your knowledge of database creation, table design, form creation, query writing, report designing, and footer insertion. It is important to pay attention to the details and follow the instructions carefully to successfully complete this task.
Answer Details
This question is asking you to create a database with a table called "customers" and define the fields appropriately with the "Custom ID" as the primary key. Then, you need to create a form from the "customers" table and save it as "REFORM". After that, you will enter ten records of your choice using the form. Next, you will write a query to retrieve the "First Name" and "Telephone" fields from the "customers" table. You will then use the retrieved data to design a report. Finally, you will insert a footer into the report and type in your full name.
In summary, this question is testing your knowledge of database creation, table design, form creation, query writing, report designing, and footer insertion. It is important to pay attention to the details and follow the instructions carefully to successfully complete this task.
Question 2 Report
4[a][i] What is slide master in power point presentation
[ii] outline the steps to rename the slide master in ms power point
[b] explain the following features in Ms power point;
[i] handout master
[ii] notes master
a) i) The slide master in PowerPoint is a feature that allows users to customize and format the layout and design of slides in a presentation. By editing the slide master, users can create a consistent and professional look throughout their presentation, with changes made to the master applying to all slides in the presentation. ii) To rename the slide master in MS PowerPoint, follow these steps: 1. Open the PowerPoint presentation containing the slide master you wish to rename. 2. Click on the "View" tab in the PowerPoint ribbon. 3. Click on "Slide Master" to open the slide master view. 4. In the left-hand pane, right-click on the slide master you wish to rename. 5. Select "Rename Master" from the drop-down menu. 6. Type in the new name for the slide master and press enter. b) i) The handout master in PowerPoint is a feature that allows users to customize the layout and design of handouts that are printed or distributed to audience members. By editing the handout master, users can add logos, headers, footers, page numbers, and other elements to create a professional-looking handout. ii) The notes master in PowerPoint is a feature that allows users to customize the layout and design of speaker notes that accompany each slide. By editing the notes master, users can add logos, headers, footers, and other elements to create a consistent and professional look for their speaker notes. Additionally, users can format the font, color, and size of the speaker notes text to enhance readability during a presentation.
Answer Details
a) i) The slide master in PowerPoint is a feature that allows users to customize and format the layout and design of slides in a presentation. By editing the slide master, users can create a consistent and professional look throughout their presentation, with changes made to the master applying to all slides in the presentation. ii) To rename the slide master in MS PowerPoint, follow these steps: 1. Open the PowerPoint presentation containing the slide master you wish to rename. 2. Click on the "View" tab in the PowerPoint ribbon. 3. Click on "Slide Master" to open the slide master view. 4. In the left-hand pane, right-click on the slide master you wish to rename. 5. Select "Rename Master" from the drop-down menu. 6. Type in the new name for the slide master and press enter. b) i) The handout master in PowerPoint is a feature that allows users to customize the layout and design of handouts that are printed or distributed to audience members. By editing the handout master, users can add logos, headers, footers, page numbers, and other elements to create a professional-looking handout. ii) The notes master in PowerPoint is a feature that allows users to customize the layout and design of speaker notes that accompany each slide. By editing the notes master, users can add logos, headers, footers, and other elements to create a consistent and professional look for their speaker notes. Additionally, users can format the font, color, and size of the speaker notes text to enhance readability during a presentation.
Question 3 Report
use microsoft power point application to create the presentation on the topic computer systems
[a] use title slide and type computer systems with font type arial black and size 44 points
[b] use title and content layout slide and type the following passage with font type:
[i] title in algerian and size 40 points ;
[ii] content in times new roman and size 30 points.
passage: Definition of computer
A computer is a device that accepts information in the form of digitized data and manipulates it for some results based on a program or sequence of instructions on how the data is to be processed
[c] Insert next slide and type the following using the same font type and size as in (b)
CLASSIFICATION OF COMPUTERS
i By type, ii By Size: iii By Purpose: iv By Generation.
[d] insert next slide and type the following using the same font type and size in 1b
CLASSIFICATION BY TYPE
Digital Computer, Analogue Computer, Hybrid Computer. (Note: use bullet list for the items)
(e) Insert next slide and type the following using the same font type and size as in 1 (b).Mini
Computer, Mainframe Computer, (Note: use a different list type for the Micro Computer, Super Computer items)
CLASSIFICATION BY GENERATION
First Generation eg UNIVAC
Second Generation eg HAVARD MARKII
Third Generation eg IBM 360
Fourth Generation eg Microcomputer (Note: use a different list type for the items)
(g) Using Footer tool, insert your full name and index number with font size of 14 points and bold.
(h) Save your work in the folder created on the desktop using your full name as the file name.
[i] Print your work and submit to the supervisor.
To create a presentation on the topic of computer systems using Microsoft PowerPoint, follow these steps: 1. Open Microsoft PowerPoint. 2. Select the "Blank Presentation" option to start with a new presentation. 3. Slide (a): - Choose the "Title Slide" layout from the "Layout" options. - In the title text box, type "Computer Systems." - Select the title text and choose the font type "Arial Black" with a size of 44 points. 4. Slide (b): - Insert a new slide using the "New Slide" option or by pressing Ctrl+M. - Choose the "Title and Content" layout from the "Layout" options. - In the title text box, type "Definition of computer." - Select the title text and choose the font type "Algerian" with a size of 40 points. - In the content text box, type the following passage: "A computer is a device that accepts information in the form of digitized data and manipulates it for some results based on a program or sequence of instructions on how the data is to be processed." - Select the content text and choose the font type "Times New Roman" with a size of 30 points. 5. Slide (c): - Insert a new slide. - Choose the "Title and Content" layout. - In the title text box, type "CLASSIFICATION OF COMPUTERS." - Select the title text and use the same font type and size as in slide (b). - In the content text box, type the following points: - By type - By Size - By Purpose - By Generation - Select the content text and use the same font type and size as in slide (b). 6. Slide (d): - Insert a new slide. - Choose the "Title and Content" layout. - In the title text box, type "CLASSIFICATION BY TYPE." - Select the title text and use the same font type and size as in slide (b). - In the content text box, type the following bullet list: - Digital Computer - Analogue Computer - Hybrid Computer - Select the content text and use the same font type and size as in slide (b). 7. Slide (e): - Insert a new slide. - Choose the "Title and Content" layout. - In the title text box, type "CLASSIFICATION BY GENERATION." - Select the title text and use the same font type and size as in slide (b). - In the content text box, type the following list: - First Generation (e.g., UNIVAC) - Second Generation (e.g., HAVARD MARKII) - Third Generation (e.g., IBM 360) - Fourth Generation (e.g., Microcomputer) - Select the content text and use the same font type and size as in slide (b). 8. Slide (g): - Go to the "Insert" tab and click on "Footer" in the "Text" section. - In the Footer dialog box, enter your full name and index number. - Choose a font size of 14 points and make the text bold. - Click "Apply to All" to add the footer to all slides. 9. Save your work in a folder on the desktop using your full name as the file name. - Go to the "File" tab and select "Save As." - Choose the desired location and enter your full name as the file name. - Click "Save" to save the presentation. 10. To print your work and submit
Answer Details
To create a presentation on the topic of computer systems using Microsoft PowerPoint, follow these steps: 1. Open Microsoft PowerPoint. 2. Select the "Blank Presentation" option to start with a new presentation. 3. Slide (a): - Choose the "Title Slide" layout from the "Layout" options. - In the title text box, type "Computer Systems." - Select the title text and choose the font type "Arial Black" with a size of 44 points. 4. Slide (b): - Insert a new slide using the "New Slide" option or by pressing Ctrl+M. - Choose the "Title and Content" layout from the "Layout" options. - In the title text box, type "Definition of computer." - Select the title text and choose the font type "Algerian" with a size of 40 points. - In the content text box, type the following passage: "A computer is a device that accepts information in the form of digitized data and manipulates it for some results based on a program or sequence of instructions on how the data is to be processed." - Select the content text and choose the font type "Times New Roman" with a size of 30 points. 5. Slide (c): - Insert a new slide. - Choose the "Title and Content" layout. - In the title text box, type "CLASSIFICATION OF COMPUTERS." - Select the title text and use the same font type and size as in slide (b). - In the content text box, type the following points: - By type - By Size - By Purpose - By Generation - Select the content text and use the same font type and size as in slide (b). 6. Slide (d): - Insert a new slide. - Choose the "Title and Content" layout. - In the title text box, type "CLASSIFICATION BY TYPE." - Select the title text and use the same font type and size as in slide (b). - In the content text box, type the following bullet list: - Digital Computer - Analogue Computer - Hybrid Computer - Select the content text and use the same font type and size as in slide (b). 7. Slide (e): - Insert a new slide. - Choose the "Title and Content" layout. - In the title text box, type "CLASSIFICATION BY GENERATION." - Select the title text and use the same font type and size as in slide (b). - In the content text box, type the following list: - First Generation (e.g., UNIVAC) - Second Generation (e.g., HAVARD MARKII) - Third Generation (e.g., IBM 360) - Fourth Generation (e.g., Microcomputer) - Select the content text and use the same font type and size as in slide (b). 8. Slide (g): - Go to the "Insert" tab and click on "Footer" in the "Text" section. - In the Footer dialog box, enter your full name and index number. - Choose a font size of 14 points and make the text bold. - Click "Apply to All" to add the footer to all slides. 9. Save your work in a folder on the desktop using your full name as the file name. - Go to the "File" tab and select "Save As." - Choose the desired location and enter your full name as the file name. - Click "Save" to save the presentation. 10. To print your work and submit
Question 4 Report
[a] Define the term output device.
[b] Give the two types of printers.
[c] [i] Construct a truth table for an AND gate with two input signals.
[ii] State the output of an OR gate with the signals 0 and 1.
[d] list two types of an logic gate that gives an output of 1 when all of its input signals are 1.
a. An output device is a hardware component of a computer system that displays or prints the results or output of a computer's processing or data manipulation. b. The two types of printers are: - Impact printers: These printers produce printed characters or images by striking an inked ribbon against paper. Examples include dot-matrix printers. - Non-impact printers: These printers produce printed characters or images without striking the paper. Examples include inkjet printers and laser printers. c. i. A truth table for an AND gate with two input signals is as follows: | Input 1 | Input 2 | Output | |---------|---------|--------| | 0 | 0 | 0 | | 0 | 1 | 0 | | 1 | 0 | 0 | | 1 | 1 | 1 | ii. The output of an OR gate with the signals 0 and 1 is 1. An OR gate produces a logic 1 output when either or both of its input signals are 1. d. Two types of logic gates that give an output of 1 when all of its input signals are 1 are: - AND gate: An AND gate produces a logic 1 output only when all of its input signals are 1. - NAND gate: A NAND gate is the opposite of an AND gate, and produces a logic 0 output only when all of its input signals are 1. However, by adding an inverter to the output of an AND gate, a NAND gate can be created.
Answer Details
a. An output device is a hardware component of a computer system that displays or prints the results or output of a computer's processing or data manipulation. b. The two types of printers are: - Impact printers: These printers produce printed characters or images by striking an inked ribbon against paper. Examples include dot-matrix printers. - Non-impact printers: These printers produce printed characters or images without striking the paper. Examples include inkjet printers and laser printers. c. i. A truth table for an AND gate with two input signals is as follows: | Input 1 | Input 2 | Output | |---------|---------|--------| | 0 | 0 | 0 | | 0 | 1 | 0 | | 1 | 0 | 0 | | 1 | 1 | 1 | ii. The output of an OR gate with the signals 0 and 1 is 1. An OR gate produces a logic 1 output when either or both of its input signals are 1. d. Two types of logic gates that give an output of 1 when all of its input signals are 1 are: - AND gate: An AND gate produces a logic 1 output only when all of its input signals are 1. - NAND gate: A NAND gate is the opposite of an AND gate, and produces a logic 0 output only when all of its input signals are 1. However, by adding an inverter to the output of an AND gate, a NAND gate can be created.
Question 5 Report
3(a) Table 1 shows the actions perfomed by a company on its stored files.
Tick the actions that will ensure that the files are kept confidential and secured
| S/N | ACTIONS | TICK |
| 1 | use of anti virus | |
| 2 | use of backup | |
| 3 | use of biometrics | |
| 4 | use of folder | |
| 5 | use of manual file | |
| 6 | use of password |
(b) list two disadvantages of computer files as compared to manual files.
(c)(i) define charts as its relates to Ms Excel
(ii) give two types of charts in Ms Excel
(a) The actions that will ensure that the files are kept confidential and secured are: - Use of folder - Use of password - Use of biometrics (if available) (b) Two disadvantages of computer files as compared to manual files are: - Computer files are vulnerable to hacking, viruses, and other security threats. - If a computer crashes or there is a power outage, the files may be lost or corrupted. (c) (i) In Microsoft Excel, charts refer to graphical representations of data. They are used to visually display data in a way that makes it easier to understand and analyze. (ii) Two types of charts in Microsoft Excel are: - Column chart: This type of chart displays data as vertical columns. It is useful for comparing values across different categories or time periods. - Pie chart: This type of chart displays data as slices of a circle. It is useful for showing the proportion of different values in a dataset.
Answer Details
(a) The actions that will ensure that the files are kept confidential and secured are: - Use of folder - Use of password - Use of biometrics (if available) (b) Two disadvantages of computer files as compared to manual files are: - Computer files are vulnerable to hacking, viruses, and other security threats. - If a computer crashes or there is a power outage, the files may be lost or corrupted. (c) (i) In Microsoft Excel, charts refer to graphical representations of data. They are used to visually display data in a way that makes it easier to understand and analyze. (ii) Two types of charts in Microsoft Excel are: - Column chart: This type of chart displays data as vertical columns. It is useful for comparing values across different categories or time periods. - Pie chart: This type of chart displays data as slices of a circle. It is useful for showing the proportion of different values in a dataset.
Question 6 Report
2(a) Use appropriate labelled diagrams to illustrate the following network topologies.
i Startopology (ii) bustopology (iii) ring topology.
(b) State one advantage of: i Star topology ii Bus topology.
(c) Give one disadvantage of: (i) Bus topology: (i)Ring topology.
2(a)
(i) Star topology
(ii) Bus topology
(iii) Ring topology
(b)
- Star topology: Failure of one workstation or its connecting cable does not affect the other workstations on the network.
- Bus topology: It is cheap to install because it uses comparatively little cable.
(c)
- Bus topology: A break or fault in the main backbone cable can bring down the whole network.
- Ring topology: Failure of one workstation or a break in the ring cable can disrupt communication throughout the network.
Answer Details
2(a)
(i) Star topology
(ii) Bus topology
(iii) Ring topology
(b)
- Star topology: Failure of one workstation or its connecting cable does not affect the other workstations on the network.
- Bus topology: It is cheap to install because it uses comparatively little cable.
(c)
- Bus topology: A break or fault in the main backbone cable can bring down the whole network.
- Ring topology: Failure of one workstation or a break in the ring cable can disrupt communication throughout the network.
Question 7 Report
2. Daniel James and three of his friends came up with the idea of starting a travel agency for college students in Nigeria. They invested sixty thousand naira each and started their dream company, SUMMER BREAK
TRAVELS INC.
As sales continued to grow, the management of Summer Break Travels Inc. realised they need a better tracking system for First Quarter
Sales.
Prepare a First Quarter Sales Worksheet that shows the sales for the first quarter using the details in the table below
Markerting outlets[#]
| location[vacation place] | campus | telephone | internet | |
| bar beach | 5,297.23 | 3,871.35 | 4,720.45 | 2,998.65 |
| trans amusement park ibadan | 2,823.23 | 4,840.53 | 2,703.56 | 4,911.16 |
| agodi gardens | 6,256.25 | 7,256.12 | 2,436.86 | 7,709.32 |
| obudu park calabar | 2,856.15 | 437.20 | 4,997.60 | 1,201.45 |
| total |
[a] (a) Using function or fomula, compute the total:
[i] sales at each marketing outlet; (ii)
[ii] amount of money made for each vacation place. (Note: create another column "total")
(b) Format the table using the instruction below: ) the title "Summer Break Travels, Inc.
First Quarter Sales" should be Bold and in Upper Case;
(ii) fill the table with white background 1 darker-25"
[c] Create two charts for the first quarter sales: )
[i] a pie chart stating the most effective sales method;
[ii] a bar chart stating the most popular vacation place.
[d] Type in the formula used in calculating total for each location below your table
(enclosed in"")
[e] Save, print out your work and submit to the supervisor.
To prepare the First Quarter Sales Worksheet for Summer Break Travels Inc., we need to perform the following steps:
a) Calculate the total sales at each marketing outlet and the amount of money made for each vacation place: To calculate the total sales at each marketing outlet, we need to add up the sales from all the four methods (mail, campus, telephone, and internet) for each vacation place. Similarly, to calculate the amount of money made for each vacation place, we need to add up the sales from all the four methods for each location. We can use the SUM function in Excel to calculate these totals. Here's how the table will look after calculating the totals:
b) Format the table as follows: - Bold and uppercase the title: "SUMMER BREAK TRAVELS, INC. FIRST QUARTER SALES" - Fill the table with a white background of 1 darker-25"
c) Create two charts:
- Pie chart: To create a pie chart, we need to select the sales data for each marketing outlet (i.e., mail, campus, telephone, and internet) and insert a pie chart from the "Insert" tab. We can then format the chart by adding data labels and a legend to show which method is most effective.
- Bar chart: To create a bar chart, we need to select the sales data for each vacation place and insert a bar chart from the "Insert" tab. We can then format the chart by adding axis labels and a title to show which vacation place is the most popular.
d) Type in the formula used in calculating total for each location below your table (enclosed in ""): For example, the formula used to calculate the total sales for Bar Beach is "=SUM(B2:E2)".
e) Save, print out your work, and submit to the supervisor. In summary, the First Quarter Sales Worksheet for Summer Break Travels Inc. involves calculating the total sales at each marketing outlet and the amount of money made for each vacation place using Excel's SUM function, formatting the table with a bold and uppercase title and a white background, creating a pie chart and a bar chart to visualize the sales data, and typing in the formulas used to calculate the totals. The final output should be saved, printed out, and submitted to the supervisor.
Answer Details
To prepare the First Quarter Sales Worksheet for Summer Break Travels Inc., we need to perform the following steps:
a) Calculate the total sales at each marketing outlet and the amount of money made for each vacation place: To calculate the total sales at each marketing outlet, we need to add up the sales from all the four methods (mail, campus, telephone, and internet) for each vacation place. Similarly, to calculate the amount of money made for each vacation place, we need to add up the sales from all the four methods for each location. We can use the SUM function in Excel to calculate these totals. Here's how the table will look after calculating the totals:
b) Format the table as follows: - Bold and uppercase the title: "SUMMER BREAK TRAVELS, INC. FIRST QUARTER SALES" - Fill the table with a white background of 1 darker-25"
c) Create two charts:
- Pie chart: To create a pie chart, we need to select the sales data for each marketing outlet (i.e., mail, campus, telephone, and internet) and insert a pie chart from the "Insert" tab. We can then format the chart by adding data labels and a legend to show which method is most effective.
- Bar chart: To create a bar chart, we need to select the sales data for each vacation place and insert a bar chart from the "Insert" tab. We can then format the chart by adding axis labels and a title to show which vacation place is the most popular.
d) Type in the formula used in calculating total for each location below your table (enclosed in ""): For example, the formula used to calculate the total sales for Bar Beach is "=SUM(B2:E2)".
e) Save, print out your work, and submit to the supervisor. In summary, the First Quarter Sales Worksheet for Summer Break Travels Inc. involves calculating the total sales at each marketing outlet and the amount of money made for each vacation place using Excel's SUM function, formatting the table with a bold and uppercase title and a white background, creating a pie chart and a bar chart to visualize the sales data, and typing in the formulas used to calculate the totals. The final output should be saved, printed out, and submitted to the supervisor.
Question 8 Report
A palindrome is a word which can be written in reversed order and it retains its meaning and spelling,Examples are lawal,ada,abba,etc
Write a simple QBASIC instruction that will accept a word from the keyboard and check if it is a palindrome or not. The palindrome must display a message showing if the word is palindrome or not.
Here's a simple QBASIC program that accepts a word from the keyboard and checks if it is a palindrome or not: ``` CLS INPUT "Enter a word: ", word$ n = LEN(word$) FOR i = 1 TO n / 2 IF MID$(word$, i, 1) <> MID$(word$, n - i + 1, 1) THEN PRINT word$; " is not a palindrome" END END IF NEXT PRINT word$; " is a palindrome" ``` Explanation: - `CLS` clears the screen before the program runs. - `INPUT` prompts the user to enter a word and stores it in the variable `word$`. - `n = LEN(word$)` gets the length of the word and stores it in the variable `n`. - The `FOR` loop checks each character of the word from the beginning to the middle of the word (i.e., `n/2`). If a character does not match its corresponding character from the end of the word, then the program prints a message saying that the word is not a palindrome and ends the program. - If the loop finishes without finding any mismatch, then the program prints a message saying that the word is a palindrome.
Answer Details
Here's a simple QBASIC program that accepts a word from the keyboard and checks if it is a palindrome or not: ``` CLS INPUT "Enter a word: ", word$ n = LEN(word$) FOR i = 1 TO n / 2 IF MID$(word$, i, 1) <> MID$(word$, n - i + 1, 1) THEN PRINT word$; " is not a palindrome" END END IF NEXT PRINT word$; " is a palindrome" ``` Explanation: - `CLS` clears the screen before the program runs. - `INPUT` prompts the user to enter a word and stores it in the variable `word$`. - `n = LEN(word$)` gets the length of the word and stores it in the variable `n`. - The `FOR` loop checks each character of the word from the beginning to the middle of the word (i.e., `n/2`). If a character does not match its corresponding character from the end of the word, then the program prints a message saying that the word is not a palindrome and ends the program. - If the loop finishes without finding any mismatch, then the program prints a message saying that the word is a palindrome.
