Examination on Computer Studies
Class: JSS 3
Term: Second Term
Time: 1 Hour
Total Marks: 70

SECTION A: OBJECTIVES (40 Marks)
Instruction: Answer all questions.

1. ________ is a visual representation of data. (a) Worksheet (b) Graph (c) Database (d) Spreadsheet
2. The process of entering data into cells is called ________. (a) data sorting (b) data entry (c) data analysis (d) data retrieval
3. A computer professional who specializes in designing and building software is a ________. (a) hardware engineer (b) network administrator (c) software developer (d) data entry clerk
4. Which of these is a basic logic gate? (a) XOR (b) NAND (c) AND (d) NOR
5. All of these are types of graphs except ________. (a) line graph (b) pie chart (c) bar chart (d) text graph
6. Which of the following is an advantage of computer games? (a) addiction (b) improved problem-solving skills (c) eye strain (d) social isolation
7. The main reason for formatting a worksheet is to ________. (a) delete data (b) make it more readable (c) perform calculations (d) save it
8. Which is NOT a quality of a good computer professional? (a) good communication skills (b) dishonesty (c) problem-solving ability (d) continuous learning
9. A truth table shows all possible input combinations and their corresponding ________. (a) errors (b) calculations (c) outputs (d) formulas
10. The correct step in creating a graph involves selecting the data range first, then ________. (a) printing the graph (b) entering new data (c) choosing the graph type (d) saving the worksheet
11. Which of these is not a career opportunity in computing? (a) Web Designer (b) Cook (c) System Analyst (d) Database Administrator
12. The NOT gate produces an output that is the ________ of its input. (a) same (b) inverse (c) sum (d) product
13. Playing computer games for too long can lead to ________. (a) increased physical activity (b) improved social skills (c) eye strain (d) better academic performance
14. Which of the following arithmetic operations can be performed in a worksheet? (a) singing (b) dancing (c) addition (d) painting
15. ________ is a professional body for computer professionals in Nigeria. (a) NCDC (b) CPN (c) INEC (d) JAMB
16. A histogram is a type of graph used to represent ________. (a) categorical data (b) numerical data distribution (c) text data (d) image data
17. Which of these is a disadvantage of computer games? (a) enhanced creativity (b) development of strategic thinking (c) poor academic performance (d) improved hand-eye coordination
18. The logical operation that produces an output of 1 only if all inputs are 1 is the ________ gate. (a) OR (b) NOT (c) AND (d) XOR
19. To save a worksheet, you typically click on the ________ menu. (a) Edit (b) View (c) File (d) Insert
20. An example of a career in computing related to securing computer systems is ________. (a) graphic designer (b) cybersecurity analyst (c) data entry operator (d) technical writer
21. The main function of the Computer Professionals (Registration Council of Nigeria) is to ________. (a) promote computer game development (b) regulate and control computer practice (c) sell computer hardware (d) organize computer competitions
22. Which of the following is used to remove existing data from a worksheet? (a) retrieving data (b) saving data (c) editing data (d) printing data
23. A line graph is best used to show ________. (a) parts of a whole (b) trends over time (c) frequency distribution (d) comparison between categories
24. Which is NOT a type of computer game? (a) Adventure games (b) Puzzle games (c) Spreadsheet games (d) Simulation games
25. The logical operation where the output is 1 if at least one input is 1 is the ________ gate. (a) AND (b) NOT (c) OR (d) NAND
26. Formatting a graph involves changing its appearance, such as ________. (a) deleting data (b) changing chart title and labels (c) adding new data (d) performing calculations
27. Failure to update skills can lead to a computer professional becoming ________. (a) highly sought after (b) obsolete (c) more efficient (d) well-paid
28. To calculate the average of a range of numbers in a worksheet, one would use the ________ function. (a) SUM (b) COUNT (c) AVERAGE (d) MAX
29. The purpose of a truth table for an AND gate with two inputs is to show ________. (a) only one possible output (b) all four possible outputs (c) only the inputs (d) only the errors
30. Which of these is not a common computer game genre? (a) Action (b) Strategy (c) Role-Playing (d) Document Processing
31. The process of arranging data in a worksheet in ascending or descending order is called ________. (a) filtering (b) sorting (c) counting (d) summing
32. All of these are qualities of a good computer professional except ________. (a) problem-solving skills (b) strong communication (c) ethical behavior (d) lack of technical knowledge
33. A pie chart is used to show ________. (a) changes over time (b) distribution of parts of a whole (c) relationship between two variables (d) frequency of data
34. The symbol ‘•’ or ‘&’ often represents the ________ logical operation. (a) OR (b) NOT (c) AND (d) XOR
35. The practice of using computers for professional work is regulated by ________. (a) the police (b) professional bodies (c) government ministries (d) local government
36. Which of the following is a common calculation function in a spreadsheet? (a) Drawing (b) Counting (c) Writing (d) Singing
37. A computer game that simulates real-world activities like flying a plane or building a city is a ________ game. (a) action (b) adventure (c) simulation (d) puzzle
38. The process of making a hard copy of a worksheet is known as ________. (a) saving (b) retrieving (c) printing (d) editing
39. The output of a NOT gate is 0 if its input is ________. (a) 0 (b) 1 (c) 2 (d) any number
40. Creating a graph makes numerical data ________ to understand. (a) harder (b) impossible (c) easier (d) confusing

SECTION B: THEORY (30 Marks)
Instruction: Answer any THREE questions.

Question 1
(a) Define what a worksheet is in the context of computer applications. (2 marks)
(b) List and explain two common arithmetic calculations that can be performed using a worksheet. (3 marks)
(c) State three advantages of using graphs to represent data. (3 marks)
(d) Give two examples of computer careers that involve working with data in spreadsheets. (2 marks)

Question 2
(a) What is a logic gate? (2 marks)
(b) Draw the truth table for an AND gate with two inputs (A and B). (3 marks)
(c) Explain why continuous learning is an important quality for a computer professional. (3 marks)
(d) Name two types of computer games. (2 marks)

Question 3
(a) Differentiate between a line graph and a pie chart based on their primary use. (2 marks)
(b) Outline the basic steps involved in creating a graph from data in a worksheet. (3 marks)
(c) Discuss two disadvantages of excessive computer game playing. (3 marks)
(d) State two career opportunities available in the field of computer studies. (2 marks)

Question 4
(a) What is data entry in a worksheet? (2 marks)
(b) Describe how you would retrieve a saved worksheet. (3 marks)
(c) Explain the function of the Computer Professionals (Registration Council of Nigeria) (CPN). (3 marks)
(d) Construct the truth table for a NOT gate. (2 marks)

Objective Marking Scheme

Question 1 – ✅ (b) Graph
Question 2 – ✅ (b) data entry
Question 3 – ✅ (c) software developer
Question 4 – ✅ (c) AND
Question 5 – ✅ (d) text graph
Question 6 – ✅ (b) improved problem-solving skills
Question 7 – ✅ (b) make it more readable
Question 8 – ✅ (b) dishonesty
Question 9 – ✅ (c) outputs
Question 10 – ✅ (c) choosing the graph type
Question 11 – ✅ (b) Cook
Question 12 – ✅ (b) inverse
Question 13 – ✅ (c) eye strain
Question 14 – ✅ (c) addition
Question 15 – ✅ (b) CPN
Question 16 – ✅ (b) numerical data distribution
Question 17 – ✅ (c) poor academic performance
Question 18 – ✅ (c) AND
Question 19 – ✅ (c) File
Question 20 – ✅ (b) cybersecurity analyst
Question 21 – ✅ (b) regulate and control computer practice
Question 22 – ✅ (c) editing data
Question 23 – ✅ (b) trends over time
Question 24 – ✅ (c) Spreadsheet games
Question 25 – ✅ (c) OR
Question 26 – ✅ (b) changing chart title and labels
Question 27 – ✅ (b) obsolete
Question 28 – ✅ (c) AVERAGE
Question 29 – ✅ (b) all four possible outputs
Question 30 – ✅ (d) Document Processing
Question 31 – ✅ (b) sorting
Question 32 – ✅ (d) lack of technical knowledge
Question 33 – ✅ (b) distribution of parts of a whole
Question 34 – ✅ (c) AND
Question 35 – ✅ (b) professional bodies
Question 36 – ✅ (b) Counting
Question 37 – ✅ (c) simulation
Question 38 – ✅ (c) printing
Question 39 – ✅ (b) 1
Question 40 – ✅ (c) easier