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

(52 cards)

1
Q

What is the meaning of word processing?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Define a word processor.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Give examples of word processors.

A
  • Microsoft Word
  • Lotus WordPro
  • Microsoft Write
  • WordStar
  • Apple iWork
  • OpenOffice Write
  • Professional Write
  • InCopy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the Ribbon in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a Tab in the context of Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are Groups in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a dialog launcher in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How do you create a document in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is Word Wrap in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How do you select a word in Microsoft Word?

A

Double-click the word.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Press Ctrl + A.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Define editing in the context of word processing.

A

Correcting textual mistakes in a document.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does formatting involve in word processing?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How do you change font size in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are the four text alignment options in Microsoft Word?

A
  • Align Left
  • Align Right
  • Align Centre
  • Justify
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is a Watermark in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is line spacing in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is a Drop Cap in Microsoft Word?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What is a database?

A

A structured collection of interrelated data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Define Database Management System (DBMS).

A

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

22
Q

What is the extension of an MS Access database?

23
Q

What is the smallest unit of data representation?

24
Q

What is a record in a database?

A

A collection of related fields.

25
List the benefits of a DBMS.
* 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
26
Give examples of DBMSs.
* Microsoft Access * Oracle * IBM Dbase (III & IV) * Informix * Ingress * MS SQL Server * MySQL * FoxBase * Paradox
27
What is a database object?
A data structure used to either store or reference the data.
28
What is a Table in a database?
The most important database object that consists of rows and columns, storing records about a particular entity.
29
What is a Form in a database?
An object that provides a convenient way to enter and view records in a table.
30
What is a Query in a database?
An object that enables the user to locate records that match specified criteria.
31
What is a Report in a database?
An object that allows you to format, organize, and summarize all or a portion of the data in a database.
32
What is a primary key in a database?
A field that contains unique values for each record in the table.
33
What are the available data types in MS Access?
* Text * Memo * Number * Date/Time * Currency * AutoNumber * Yes/No * OLE Object * Hyperlink * Attachment * Lookup Wizard
34
What does querying a database mean?
Asking the database to extract a subset of the information saved in it based on specified criteria.
35
What is the purpose of the Student_Record table?
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.
36
What are the steps to create the Students table in Design View?
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.
37
How can the captain extract information about female students?
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.
38
List three types of views that can be used to extract information.
* Datasheet View * Design View * Form View ## Footnote Each view offers different functionalities for interacting with the data.
39
What are the steps to convert the table to a report with a footer?
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.
40
Describe the procedure to convert the table to a form with navigation buttons.
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.
41
Define computer ethics.
A set of moral principles that regulates the use of computers ## Footnote It addresses issues like intellectual property rights and privacy concerns.
42
What are the key components of computer room management ethic?
* Maintaining a dust-free environment * Appropriate ventilation * Appropriate lighting system * Setting up computers before student arrival ## Footnote These components ensure a conducive learning environment.
43
List the rules for computer laboratory safety.
* 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.
44
What are computer safety measures for users?
* 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.
45
What is a cyber-crime?
Any crime committed through the internet ## Footnote This includes activities like hacking and identity theft.
46
What does data modeling involve?
Structuring and organizing data for implementation in a database management system ## Footnote It defines data flow and interrelationships among data elements.
47
What are the approaches in data modeling?
* Conceptual Data Modeling * Logical Data Modeling * Physical Data Modeling ## Footnote Each approach serves a different purpose in the data modeling process.
48
What is the flat data model?
A single, two-dimensional array of data elements ## Footnote All members of a column are similar values, and rows are related.
49
Describe the hierarchical data model.
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.
50
What is the relational model?
A database model based on first-order predicate logic ## Footnote It describes databases as collections of predicates over finite sets of variables.
51
Define the star schema.
A database structure optimized for data warehouses with a central fact table and smaller dimensional tables ## Footnote It facilitates efficient data analysis and reporting.
52
What is a standard data model?
A widely applied data model in an industry shared among competitors ## Footnote It enables faster information sharing and standardizes vocabulary and quality.