GRADE 10 THIRD TERM DATA PROCESSING NOTES FOR WEEKS 1-4-1 (1)

Question 1

What is the meaning of word processing?

Answer 1

The art of typing, editing, and formatting a document through the use of a computer program.

Question 2

Define a word processor.

Answer 2

An application software capable of creating, editing, formatting, and producing documents that contain textual or/and graphical information.

Question 3

Give examples of word processors.

Answer 3

• Microsoft Word
• Lotus WordPro
• Microsoft Write
• WordStar
• Apple iWork
• OpenOffice Write
• Professional Write
• InCopy

Question 4

What is the Ribbon in Microsoft Word?

Answer 4

A band of functional tabs across the top of the screen that replaces the menus and toolbars from earlier versions.

Question 5

What is a Tab in the context of Microsoft Word?

Answer 5

Contains a group of commands that are loosely related to core tasks.

Question 6

What are Groups in Microsoft Word?

Answer 6

Sets of commands that fall under the umbrella of that tab’s core task.

Question 7

What is a dialog launcher in Microsoft Word?

Answer 7

Small arrows located in the lower-right corner of certain groups that activate a dialog box containing all commands available for that group.

Question 8

How do you create a document in Microsoft Word?

Answer 8

Click Start > All Programs > Microsoft Office > Microsoft Word or double-click the MS Word icon on the desktop.

Question 9

What is Word Wrap in Microsoft Word?

Answer 9

The feature that automatically wraps words to form sentences and sentences to form paragraphs.

Question 10

How do you select a word in Microsoft Word?

Answer 10

Double-click the word.

Question 11

How do you select the whole content of a document in Microsoft Word?

Answer 11

Press Ctrl + A.

Question 12

What is the procedure to save a document for the first time in Microsoft Word?

Answer 12

Click Save or Save As or press F12, then give the document a desired name.

Question 13

Define editing in the context of word processing.

Answer 13

Correcting textual mistakes in a document.

Question 14

What does formatting involve in word processing?

Answer 14

Changing the look and feel of the content in the document, including font size, type, and alignment.

Question 15

How do you change font size in Microsoft Word?

Answer 15

Select the text, click the Font size button, and choose the appropriate size.

Question 16

What are the four text alignment options in Microsoft Word?

Answer 16

• Align Left
• Align Right
• Align Centre
• Justify

Question 17

What is a Watermark in Microsoft Word?

Answer 17

A faded background image that displays behind the text in a document.

Question 18

What is line spacing in Microsoft Word?

Answer 18

The amount of vertical space between the lines of text in a paragraph.

Question 19

What is a Drop Cap in Microsoft Word?

Answer 19

A large capital letter used as a decorative element at the beginning of a paragraph or section.

Question 20

What is a database?

Answer 20

A structured collection of interrelated data.

Question 21

Define Database Management System (DBMS).

Answer 21

An application software used to create, maintain, and manage a database.

Question 22

What is the extension of an MS Access database?

Answer 22

.accdb

Question 23

What is the smallest unit of data representation?

Answer 23

Bit

Question 24

What is a record in a database?

Answer 24

A collection of related fields.

Question 25

List the benefits of a DBMS.

Answer 25

* Creation of database * Efficient data access * Data administration * Data integrity and security * Concurrent access and crash recovery * Data manipulation * Data transformation/modification/editing * Report generation/presentation

Question 26

Give examples of DBMSs.

Answer 26

* Microsoft Access * Oracle * IBM Dbase (III & IV) * Informix * Ingress * MS SQL Server * MySQL * FoxBase * Paradox

Question 27

What is a database object?

Answer 27

A data structure used to either store or reference the data.

Question 28

What is a Table in a database?

Answer 28

The most important database object that consists of rows and columns, storing records about a particular entity.

Question 29

What is a Form in a database?

Answer 29

An object that provides a convenient way to enter and view records in a table.

Question 30

What is a Query in a database?

Answer 30

An object that enables the user to locate records that match specified criteria.

Question 31

What is a Report in a database?

Answer 31

An object that allows you to format, organize, and summarize all or a portion of the data in a database.

Question 32

What is a primary key in a database?

Answer 32

A field that contains unique values for each record in the table.

Question 33

What are the available data types in MS Access?

Answer 33

* Text * Memo * Number * Date/Time * Currency * AutoNumber * Yes/No * OLE Object * Hyperlink * Attachment * Lookup Wizard

Question 34

What does querying a database mean?

Answer 34

Asking the database to extract a subset of the information saved in it based on specified criteria.

Question 35

What is the purpose of the Student_Record table?

Answer 35

To store student information including ID_Number, Full_Name, Date_of_Birth, Gender, and Home_Address ## Footnote This table is essential for maintaining organized records of students.

Question 36

What are the steps to create the Students table in Design View?

Answer 36

1. Open the database software 2. Select 'Create' and then 'Table Design' 3. Add fields: ID_Number, Full_Name, Date_of_Birth, Gender, Home_Address 4. Set data types for each field 5. Save the table as 'Students' ## Footnote Design View allows for detailed customization of the table structure.

Question 37

How can the captain extract information about female students?

Answer 37

1. Open the Students table 2. Use the query function 3. Set criteria for the Gender field to 'Female' 4. Execute the query to view results ## Footnote This process allows for targeted data retrieval based on specified criteria.

Question 38

List three types of views that can be used to extract information.

Answer 38

* Datasheet View * Design View * Form View ## Footnote Each view offers different functionalities for interacting with the data.

Question 39

What are the steps to convert the table to a report with a footer?

Answer 39

1. Open the Students table 2. Select 'Create' and then 'Report' 3. Customize the report layout 4. Add the candidate’s name and number to the footer 5. Save the report ## Footnote This allows for presentation-ready documentation of student data.

Question 40

Describe the procedure to convert the table to a form with navigation buttons.

Answer 40

1. Open the Students table 2. Select 'Create' and then 'Form' 3. Add buttons for navigation: Next, Previous, First, Last 4. Set button actions to navigate through records 5. Save the form ## Footnote This enhances user interaction with the database.

Question 41

Define computer ethics.

Answer 41

A set of moral principles that regulates the use of computers ## Footnote It addresses issues like intellectual property rights and privacy concerns.

Question 42

What are the key components of computer room management ethic?

Answer 42

* Maintaining a dust-free environment * Appropriate ventilation * Appropriate lighting system * Setting up computers before student arrival ## Footnote These components ensure a conducive learning environment.

Question 43

List the rules for computer laboratory safety.

Answer 43

* Do not move equipment * Do not load software * Do not change settings * No bags, food, or drinks * Turn off computers after use * Keep the lab clean * Internet for educational use only * Report problems * Do not attempt repairs ## Footnote These rules help maintain a safe and functional laboratory environment.

Question 44

What are computer safety measures for users?

Answer 44

* Comfortable arrangement of tables and chairs * Proper monitor positioning * Good illumination * Dust management * Keep liquids away * Use antiglare protectors * Install fire safety equipment * Professional cleaning service for systems ## Footnote These measures help prevent accidents and ensure user safety.

Question 45

What is a cyber-crime?

Answer 45

Any crime committed through the internet ## Footnote This includes activities like hacking and identity theft.

Question 46

What does data modeling involve?

Answer 46

Structuring and organizing data for implementation in a database management system ## Footnote It defines data flow and interrelationships among data elements.

Question 47

What are the approaches in data modeling?

Answer 47

* Conceptual Data Modeling * Logical Data Modeling * Physical Data Modeling ## Footnote Each approach serves a different purpose in the data modeling process.

Question 48

What is the flat data model?

Answer 48

A single, two-dimensional array of data elements ## Footnote All members of a column are similar values, and rows are related.

Question 49

Describe the hierarchical data model.

Answer 49

Data organized into a tree-like structure with parent-child relationships ## Footnote Each child record relates to one parent, but a parent can relate to multiple children.

Question 50

What is the relational model?

Answer 50

A database model based on first-order predicate logic ## Footnote It describes databases as collections of predicates over finite sets of variables.

Question 51

Define the star schema.

Answer 51

A database structure optimized for data warehouses with a central fact table and smaller dimensional tables ## Footnote It facilitates efficient data analysis and reporting.

Question 52

What is a standard data model?

Answer 52

A widely applied data model in an industry shared among competitors ## Footnote It enables faster information sharing and standardizes vocabulary and quality.