Mid-Term Assessment: Computer Studies JSS 3 Assessment Components Computer Studies JSS 3 First Term Lesson Notes Week

Mid-Term Assessment: Computer Studies JSS 3

Assessment Components

Part A: Objective Questions

Instructions: Fill in the blanks with the correct option (a, b, c, or d).

1. A __________ is a vertical line of cells in a spreadsheet.
   a) row
   b) column
   c) worksheet
   d) cell
2. The basic unit of data entry in a spreadsheet is called a __________.
   a) table
   b) cell
   c) range
   d) row
3. __________ is the term used to describe a selection of two or more cells.
   a) Cell
   b) Range
   c) Column
   d) Row
4. The __________ menu in spreadsheet software is used to open existing files.
   a) Home
   b) File
   c) Edit
   d) View
5. A __________ allows users to visualize data trends in spreadsheets.
   a) chart
   b) formula
   c) table
   d) cell
6. The __________ divides the new economy from the old economy.
   a) digital divide
   b) information divide
   c) data divide
   d) technology divide
7. Digital literacy is defined as the ability to effectively and critically __________ information.
   a) memorize
   b) ignore
   c) communicate
   d) evaluate
8. The __________ economy is characterized by mechanical operations and labor-based systems.
   a) new
   b) digital
   c) old
   d) informational
9. __________ allows businesses to create new jobs and opportunities with lower capital investments.
   a) Old economy
   b) New economy
   c) Digital divide
   d) Flat file
10. A __________ is a file that contains multiple worksheets.
    a) workbook
    b) spreadsheet
    c) document
    d) presentation
11. In a spreadsheet, the __________ is the horizontal line identified by a number.
    a) row
    b) column
    c) cell
    d) range
12. __________ systems are limited by space and time.
    a) Digital
    b) Old economy
    c) New economy
    d) Spreadsheet
13. A __________ is a page within a workbook.
    a) chart
    b) worksheet
    c) cell
    d) formula
14. The intersection of a row and a column in a spreadsheet is known as a __________.
    a) range
    b) cell
    c) row
    d) column
15. The __________ of a database includes fields, records, and keys.
    a) structure
    b) definition
    c) content
    d) terminology
16. To __________ data in a spreadsheet, you need to double-click on the cell.
    a) view
    b) enter
    c) delete
    d) copy
17. __________ literacy is crucial for navigating and utilizing technology effectively.
    a) Digital
    b) Physical
    c) Analytical
    d) Historical
18. The new economy is often referred to as __________.
    a) digital economy
    b) traditional economy
    c) mechanical economy
    d) agricultural economy
19. A __________ database organizes data in a hierarchical structure.
    a) relational
    b) flat file
    c) hierarchical
    d) network
20. A __________ is an application used for calculations and data analysis.
    a) word processor
    b) database
    c) spreadsheet
    d) presentation software

Part B: Theory Questions

Instructions: Provide short answers to the following questions.

1. Define digital literacy.
2. What are the main characteristics of the new economy?
3. Explain the concept of the digital divide.
4. List three benefits of using spreadsheets.
5. Describe the function of fields in a database.
6. What is a flat file database?
7. Explain the difference between a row and a column in a spreadsheet.
8. What is a workbook in spreadsheet applications?
9. List two uses of search engines.
10. Describe how to open an existing database application.
11. What are records in a database?
12. Define what a worksheet is in spreadsheet software.
13. How does the new economy differ from the old economy?
14. Explain the role of charts in spreadsheet applications.
15. What is the purpose of using a data range in spreadsheets?
16. Describe the importance of evaluating information in digital literacy.
17. What are the limitations of the old economy?
18. Explain the term “knowledge-based” in the context of the new economy.
19. How can digital literacy impact employment opportunities?
20. Describe how to input data into a spreadsheet cell.

Part C: True or False Questions

Instructions: Indicate whether each statement is True (T) or False (F).

1. A row is identified by a letter in a spreadsheet.
2. Digital literacy only applies to computer skills.
3. The old economy is characterized by digital processes.
4. A spreadsheet is primarily used for text documents.
5. Hierarchical databases organize data in a flat structure.
6. Worksheets can contain formulas for calculations.
7. Charts can help visualize trends in data.
8. A workbook can only contain one worksheet.
9. Rows are organized vertically in a spreadsheet.
10. Digital literacy includes critical thinking about online information.
11. Columns are identified by numbers.
12. The digital divide refers to the gap between those who have and do not have access to technology.
13. Flat file databases are more complex than relational databases.
14. Cells can contain both text and numbers.
15. The new economy is limited by physical resources.
16. All spreadsheet software includes charting capabilities.
17. Fields in a database refer to the specific categories of information.
18. A cell can only hold one type of data at a time.
19. Search engines help users find information on the internet.
20. Digital literacy is not necessary for today’s workforce.

Part D: Fill-in-the-Gaps Questions

Instructions: Complete the sentences by filling in the blanks.

1. A __________ is a collection of related data stored in a structured format.
2. In a spreadsheet, each __________ can contain a different type of data.
3. The __________ economy is known for its reliance on information technology.
4. A __________ is a visual representation of data trends.
5. The __________ of a spreadsheet can be used for calculations and data analysis.
6. __________ literacy is essential for navigating the modern workplace.
7. A __________ database is simpler than relational databases.
8. __________ allows businesses to operate with lower capital investments.
9. A __________ is necessary for opening existing files in spreadsheet software.
10. The __________ refers to the difference in access to technology among different groups.
11. Each __________ in a database holds a single piece of data.
12. Rows in a spreadsheet are identified by __________.
13. __________ allows for better organization of data in spreadsheets.
14. The __________ of a database includes the terms fields, records, and keys.
15. A __________ is a horizontal collection of cells.
16. A __________ worksheet can contain formulas for automatic calculations.
17. The __________ is the main interface for entering data in a spreadsheet.
18. __________ literacy empowers individuals to use technology effectively.
19. __________ can be created to summarize data in a spreadsheet.
20. The ability to __________ information is crucial in the digital age.

This assessment is designed to test students’ understanding of the topics covered during the mid-term, reinforcing their knowledge and skills in computer studies.

Examination malpractices may lead to a repeat of the subject or suspensions don’t be involved.

 Subject: I.C.T                    

  Duration: 1HR 30MINS   

Class: JSS 2

1. This sign * in BASIC means __________(a) asterisks (b) double (c) sum (d) multiply
2. All are ICT gadgets except _______ (a) computer (b) chainsaw (c) TV (d) satellite
3. BASIC language uses the _______________ arithmetic principle (a) BODMAS (b) BEDMAS (c) all mighty formulae (d) Pythagoras theorem
4. One of the disadvantages of ICT is (a) Access to information is cheaper (b) ICT increase the speed of transactions (c) It helps in creating interactions among people (d) painful eyes are caused from prolong use of PC.
5. _______  are languages that are closer to human languages  (a) high level language  (b)  machine language  (c)  low level language  (d)  programming language.
6. MS Paint and Corel draw are examples of ______________ package (a) word processing (b) spreadsheet (c) graphics (d) movie
7. Telephone is a __________ device (a) telecommunication (b) multicomm (c) monocommunication (d) intercomm
8. A device used in the ICT world to solve human problem is called _____ (a) instrument (b) gadget (c) tool (d) none
9. The following are computer programming languages except (a) C (b) C++ (c) Basic (d) Master
10. The letter ‘A’ in the acronym BASIC means (a) automatic (b) array (c) all purpose (d) arranged
11. BASIC was an _______ programming language that is still among the simplest and most popular of programming languages.  (a)  late (b)  famous  (c)   early  (d)  initial.
12. ______are the data or the values in a program that cannot be changed during the program execution.  (a)  variables  (b)  constant  (c)  keyword  (d)  character sets.
13. A _______ is a symbol use for addition, subtraction, multiplication, division, or other calculations  (a)  bodmas  (b)  math operator  (c)  exponentiation  (d)  modulus.
14. A drawing package produces______  that are made up from coloured lines and shapes such as circles, squares and rectangles.  (a)  pictures  (b)  photograph  (c)  images  (d)  graphics.
15. Drawing straight lines and ‘freehand’ lines are common features of _____  (a)  images  (b)  design   (c)  molding  (d)  graphics.
16. A _______  from which different colours and patterns can be chosen.  (a)  title bar  (b)  menu bar  (c)  paint pallete  (d)  tool bar
17. _________  comprises of different colours for your drawing  (a)   paint pallete   (b)  colour pallete  (c) menu bar  (d)  title bar.
18. machine language is a collection of binary digits or bits that the _________  reads and interprets.  (a)  internet   (b)  computer  (c)  metre  (d)  thermometer.
19. A ________  translates the entire program written in a high-level language to machine language prior to execution.   (a)  translator   (b)  fortran   (c)  compiler   (d)  interpreter
20. A painting package is a _______  application that can be used for processing photographs by manipulating features like colors, effects and brightness.   (a)   colour  (b)   paint pallete  (c)  colour pallete  (d)  graphic.
21. A GSM phone has the following service except ______(a) Calls (b) Text messages (c) MMS (d) programming
22. Fax stands for ______ (a) facsimile (b) facsimetre (c) facsimore (d) facsimine
23. Fax is used to send and receive ____ and _____ over the telephone line. (a) text/images (b) text/videos (c) text/mp3 (d) image/memo
24. Telephone transmits and receives sounds ,most commonly the ________ (a) Robot voice (b) human voice (c) digital voice (d) data voice
25. The letter ‘M’ in GSM means ____________  (a) menu (b) mobile (c) manual (d) mechanical
26. _________ is where our drawing and pictures are manipulated and placed for printing. (a) manipulation area (b) printable area (c) placement area (d) none of the above 
27. A thin, rectangular window containing dropdown menus is ______  (a) title bar (b)  tool bar  (c) menu bar (d) bar chart.  
28. ______ is used to zoom in on a section of your picture.   (a)  air brush  (b)  fill (c)  magnifier  (d)  enlarger.  
29. High languages need to be _________ before execution (a) amplified (b) translated (c) detached (d) discarded
30. Study the Code below

   LET A 10

   LET B 20

   LET C A+B

   PRINT C

   What will be the displayed result (a) 20 (b) 30 (c) 40 (d) 10

Section 2

Fill in the gaps 

1. The full meaning of C.D.M.A is _______________________________________________.
2.  Give the name of following BASIC math operators symbols.

1.    ^   _______________________________
2.    /   _____________________________
3. . MOD.  ________________________________
4. \   ____________________
5. ______________________ is a bar located at the top of a window.
6. The full meaning of G.S.M is _______________________________________.
7. The menu bar contains the _____________________ items.
8. The statement “REM” stands for ________________________
9.  The full meaning for BASIC IS _______ 

Theory. :  Answer three questions in all. 

1. Define the following      
   • Computer Programming Language
   • Machine Language
   • Low level language
   • High level language
2. Define the Graphic Packages
   • State the two types of graphic packages and explain each
   • State any five examples of graphic package software 
3. Define ICT         
   • State 5 examples ICT gadgets
   • State 5 benefits of ICT 
4. Define the following
   • GSM
   • Subscriber
   • Base Station
   • Network subsystem
   • Telephone
5. State 2 uses of GSM