FIRST TERM EXAMINATION ON COMPUTER FOR JSS3 NEW

Welcome to your FIRST TERM EXAMINATION ON COMPUTER FOR JSS3 NEW

What is your name

What is the main function of Internet Search Engines?

a) Sending emails

b) Social networking

c) Finding documents and media on the internet

d) Online shopping

What is the web address for Google Search?

a) www.bing.com

b) www.google.com

c) www.yahoo.com

d) www.you.com

What does SERP stand for?

a) Search Engine Ranking Page

b) Search Engine Results Page

c) Search Engine Response Protocol

d) Search Engine Retrieval Process

What does "Digital Divide" refer to?

a) A gap in computer manufacturing

b) A divide between digital and analog devices

c) The gap in access to digital and information technology

d) A division within the technology industry

What was the primary focus of the old economy?

a) Industrialization

b) Agriculture

c) Service sector

d) Tourism

What is a limitation of the Old Economy compared to the New Economy?

a) Old Economy is slower and linear

b) New Economy has limited capital

c) Old Economy covers a large area

d) New Economy is capital-intensive

What is the definition of a database?

a) A collection of random data

b) An organized collection of data for easy access and use

c) A spreadsheet

d) A programming language

What does DBMS stand for?

a) Database Software

b) Data Backup System

c) DataBase Management System

d) Database Manipulation Software

Which of the following is not an example of a DBMS package?

a) MS Access

b) Oracle

c) Excel

d) PostgreSQL

What is a primary key in a database table?

a) A field that holds specific data

b) A field that uniquely identifies each record

c) The first field in a table

d) A field with no data

In a hierarchical database, how is data structured?

a) In the form of a tree

b) In a single table

c) In a network of records

d) In rows and columns

Which database model allows many-to-many relationships?

a) Hierarchical Model

b) Network Model

c) Relational Model

d) Spreadsheet Model

Which type of database structure is most commonly used?

a) Hierarchical Model

b) Network Model

c) Relational Model

d) Spreadsheet Model

What is the primary function of a spreadsheet application?

a) Storing images

b) Analyzing and tracking numeric information

c) Creating presentations

d) Sending emails

Which of the following is not an example of a spreadsheet package?

a) iWork Numbers

b) Lotus 1-2-3

c) Photoshop

d) Google Sheets

What is the active cell in a spreadsheet?

a) The cell currently selected for data entry

b) The first cell in the spreadsheet

c) The cell with the highest value

d) The cell where formulas are stored

What does a cell reference consist of in a spreadsheet?

a) Only the column letter

b) Only the row number

c) The column letter and the row number

d) The cell's color

How are columns labeled in an Excel spreadsheet?

a) With numbers

b) With letters of the alphabet

c) With a combination of letters and numbers

d) With symbols

What is the function of the Name Box in a spreadsheet application?

a) Displaying the current date and time

b) Showing the active cell's value

c) Displaying the name of the current cell or range

d) Highlighting cells

SECTION B Practical

1. (a) Using a database application program, create a database called SUPERMARKET. (b) Create a table called Beverages with the following data: Product Name Product ID Quantity Per Unit Unit Price (N) Tea 1 20 bags per box 120.00 Chocomilo 2 100 cubes per pack 300.00 Chocolate drink 39 750 ml per bottle 370.00 Decafe coffee 38 75g per bottle 263.00 Ovaltine 43 500g per tin 346.00 Nescafe 76 30g per tin 230.00 3 marks (c) (i) Create a report as shown below, Beverages Product Name Product ID Quantity Per Unit Unit Price (N) Tea 1 20 bags per box 120.00 Chocomilo 2 100 cubes per pack 300.00 Chocolate drink 39 750 ml per bottle 370.00 Decafe coffee 38 75g per bottle 263.00 Ovaltine 43 500g per tin 346.00 Nescafe 76 30g per tin 230.00

2. The table A1 below shows the performance of students in an end-of-term examination in a certain secondary school. TABLE A1 Index Number Name Physics Chemistry Biology English Language Total Average S001 Aminu 65 78 56 45 S142 Olabode 53 85 88 78 S024 Onuka 45 96 43 98 S114 Goddey 78 76 76 65 S115 Jang 23 54 74 36 S056 Dan-Sokoto 78 32 64 52 (a) Using a spreadsheet program, insert the heading “MARK SHEET FOR SS3 SCIENCE” and centre it. (b) Create Table A1 with gridlines. (c) Insert a row between index number S024 and S114, then add the following data: S007 Badamosi 23 45 72 40. (d) Using the appropriate formula, determine: (i) total mark for each student; (ii) average mark for each student: (iii) average for the class.

SECTION C ( THEORY)

Explain the concept of a primary key in a database and provide an example.

Define the term "Digital Divide"

List three characteristics of the Old Economy, and three characteristics of new economy

Define search engine and differentiate between search engine and web browser

Leave a Reply Cancel reply