Computing Basics for Kids

What is a record in computing?

• A record in computing is a physical disc used for data storage

• A record in computing is a type of computer virus

• A record in computing is a collection of data fields composed of one or more data items.

• A record in computing is a type of music album

Define a database in simple terms.

• A database is an unstructured collection of data stored in a shoebox

• A database is a random collection of data stored on paper

• A database is a structured collection of data that is stored and accessed electronically.

• A database is a chaotic collection of data stored in a filing cabinet

Explain what a field is in a database.

• A field in a database is a column in a table that stores a specific type of data, representing a single attribute of an entity.

• A field is a row in a table that stores data

• A field is a collection of tables in a database

• A field is a software used to manage databases

Name three common Excel functions.

• COUNT

• SUM, AVERAGE, VLOOKUP

• IF

• MAX

What are the different parts of an Excel spreadsheet?

• cells, rows, columns, worksheets, workbooks

• sheets

• tabs

• formulas

How do you manage records in a database?

• By using HTML code

• By sending emails to the database

• By writing in a physical notebook

• By using SQL commands like INSERT, SELECT, UPDATE, and DELETE.

Why is it important to organize data into records?

• It is important to organize data into records for efficient data management and retrieval.

• Organizing data into records is not important for data management

• Data organization into records leads to data loss

• Records make data retrieval slower and less efficient

List three examples of databases used in everyday life.

• Google, Netflix, Twitter

• Facebook, Amazon, Mobile phone contact list

• WhatsApp, Uber, Pinterest

• LinkedIn, Spotify, Snapchat

Describe the purpose of a field in a database.

• The purpose of a field in a database is to store only numeric values.

• The purpose of a field in a database is to define the data type and constraints for a specific piece of information within a table.

• Fields in a database are used for displaying images and videos.

• A field in a database is designed to limit the number of records in a table.

How can you filter data in an Excel spreadsheet?

• Apply conditional formatting to hide unwanted data in Excel.

• Use the 'Filter' function under the 'Data' tab in Excel.

• Manually delete unwanted data rows in Excel.

• Use the 'Sort' function under the 'Data' tab in Excel.