Revision Worksheet

Digital Documentation

One word questions

1. This is a model document to create a new document. – Template

2. ___________refers to the document that contains common contents for all recipients in Mail merge. –
main document
3. What is extension of a template file in Open Office Writer? - .ott
4. Which component in Mail Merge is used to store Recipient list? – Data Source
5. Which wrapping option the text is placed above, below and left side of the image? Before
6. This option is used to send the selected shape one place down in the stack in Writer. - Send backward
7. Which wrapping option the text will be wrapped around the four sides of an image.
- Parallel
8. Which wrapping option is used to place text above and below the image but not around it. – no wrap
9. Orientation, page size, margin are examples of which type of style? - page style
10. Which filter Increases the contrast of an image? - sharpen
11. Which option is used to change width and height of image with same proportion? – Keep Ration
12. Which arrangement option is used to send the selected shape on top of the stack in Writer? – bring to front
13. Which key is used to open Style and Format Dialog? – F11
14. “Indexes and Tables” option is available under which menu. – insert
15. Which button represents the start of a hyperlink while making TOC entry as hyperlink? - LS
16. Which button represents the end of a hyperlink while making TOC entry as hyperlink? - LE
17. Alignment and indentation are examples of which type of style? - paragraph

Theory Questions
1. What are styles? Explain different types of styles available in Open Office
Writer.
2. Differentiate image cropping and resizing.
3. What do you mean by flipping an image? List down flipping options.
4. What are mailing labels?
5. What is TOC? Write advantages of using TOC tool.
6. Write Qualities of a good TOC.
7. What is a template in Open Office Writer? Write advantages of using a
template.
8. Difference between Template and Styles
9. What is difference between Keep Scale and Keep Image size options while
cropping an image in a document?
10. Explaining different wrapping options available in Writer.
11. Explaining different image arrangement options available in Writer.
12. What is mail merge? Explain different components of mail-merge.
 Revision Worksheet
Electronic Spreadsheets
One word questions
1. Goal Seek is used to find the input value of a single cell to achieve target result.
2. Goal Seek option is available under Tools menu.
3. Consolidating data bring data from multiple sheets of the same Calc document.
4. Consolidate option is available under Data menu.
5. Multiple operations tool is used for creating a formula array that is used to test and
analyze the result.
6. Solver is used to find the input value of multiple cells to achieve target result.
7. Hyperlinks are cross references that are used in Calc to jump to another location.
8. Relative hyperlink contains the partial address of destination file.
9. Absolute hyperlink contains the full address of destination file.
10. Comments are the description of changes made in cell during the Record Change mode.
11. In review process Edit > Changes > Record menu option is used to record the changes
made in a spreadsheet.
12. Merging option is used to merge different versions or copies of a spreadsheet to make a
single spreadsheet.
13. The process of checking the validity of data entered by all users in a multi user
environment is called Reviewing.
14. Sharing enables multiple users to work on a single spreadsheet simultaneously in Open
Office Calc.
15. Colon : symbol is used to define range of multiple cells.
16. Comma (,) symbol is used as separator that we can specify between different function
arguments, while creating a function using Macro.
17. Semicolon (;) symbol is used as separator that we can specify between different function
arguments, while calling/ using a function using Macro.
18. Macro is a saved sequence of commands or keystrokes that are recorded for later use.
19. Arguments are used for passing input values to a Macro Function body to perform
calculations while creating a function.
20. Function and End Function statements are used to create function in Macro.
21. getCellByPosition functions is used to get reference of a specified cell by passing
Column Index and Row index as argument in Macro.
22. getByIndex function is used to get reference of a specific sheet from workbook.

Theory Questions
1. Explain all data analysis tools available in Calc.
2. Explain Relative and Absolute hyperlinks in detail.
3. What is purpose of sharing a spreadsheet?
4. Explain role of Accept/ Reject changes option available in Calc.
5. What is use of reviewing process in spreadsheet applications?
6. What is use of merging multiple spreadsheets?
7. What is hyperlink? Explain types of hyperlinks.
8. Explain functions used for accessing value of a cell directly by writing the Open Office
Basic code?
9. What is Macro Function? How can we create and call Macro Function in Open Office
Calc?
10. What are arguments in a Macro Function? How we can pass arguments in a function?
 Revision Worksheet
DBMS
One word questions
1. Auto Value field property in Base generates numeric values automatically starting from
ZERO.
2. Primary Key is used to reduce redundancy (repetition of records) from a table.
3. Distributed Database is a collection of multiple interconnected databases, which are
stored on different database server on a network.
4. Foreign key is available in child table and used to make relationship with parent table’s Primary
key.
5. Length field property decides how many maximum number characters we can fill in a field
6. Entry Required field property in Base decides whether the entry of data in the selected field
is mandatory of not.
7. Data View table view is used to edit the data of a table.
8. “Revoke” command belongs to DCL category.
9. “update” command belongs to DML category.
10. DDL commands deal with the structure of a table in a database.
11. In SQL “drop” command belongs to DDL category.
12. Like keyword is used to perform pattern search while using “select” command.
13. Order by clause is used to show the records in sorted form while using “select”
statement.
14. Desc keyword is used with “Order By” command to sort records in descending order.
15. F5 is the shortcut key to run a query.
16. Where clause is used to apply condition in SQL command.
17. Hyphen (-) wild card character deals with a range of characters.
18. # wild card character represents a single numeric character while writing select
command.
19. ? wildcard character represents any single character while writing select query.
20. Report is used to represent the data in printable format.
21. Form is a user friendly interface by using which we can perform different database
operations like adding record, deleting record, update and search records in an easy way

Theory Questions
1. Explain Data and Information briefly.
2. Explain Flat File database and Relational Database.
3. What is Redundancy? How we can avoid redundancy from a table.
4. Explain different field properties available while creating table in Open Office Base.
5. Explain the concept of Primary key and Foreign key in DBMS.
6. What is importance of data types available in Open Office Base? List down names of any
two types to store text type of data.
7. List down alphanumeric data types.
8. List down integer data types.
9. List down fractional data types.
10. Explain DDL, DML, DCL, and TCL briefly. List down queries available under each category.
11. Explain Primary key, Composite key and Foreign keys in detail.
12. What are Forms?
13. What are Reports?
 14. Consider following table and write SQL queries for the following:

1. Add the given record into TEACHERS table:

101, Gagandeep, 25, Computer, 1/1/2001, 40000, F

Ans insert into teachers values(101, „Gagandeep‟, 25, „Computer‟, „1/1/2001‟, 40000, „F‟)

2. Display the Name and subject of the teacher having salary more than 25 thousand.

Ans: select name, subject from teachers where salary>25000

3. Decrease the salary of each teacher by 500.

Ans: Update teachers set salary=salary-500

4. Update salary of all teachers to 50000 having age more than 40

Ans: Update teachers set salary=50000 where age>40

5. Remove the records of those teachers who teach Hindi.

Ans: Delete from teachers where subject=‟Hindi‟

6. Display complete record of teachers whose name ends with “A”.

Ans: Select * from teachers where name like „*A‟

7. Display complete record of teachers whose name starts with “A”.

Ans: Select * from teachers where name like „A*‟

 Part-A (Employability Skills) – Revision Questions

Theory Questions

Unit- 2 Self-Management

1. What is stress? Explain different reasons of stress. (Page – 39, 40)

2. Explain stress management techniques. (Page – 41)
3. Explain advantages of stress management. (Page - 40)
4. Explain advantages of working independently.(Page – 43 )
5. Explain methods to enhance ability to work independently. (Page – 44 )
6. Explain importance of working independently? (Page – 43 )

Unit- 3 ICT Skills

1. Briefly explain GUI (Graphical User Interface) and CUI (Character user Interface)/
Command Line Interface base Operating systems. (Page – 51)
2. Explain types of operating systems. (Page – 52)
3. Explain any two desktop components in Windows Operating System. (Page – 53)
4. Explain different types of viruses. (Page – 61)
5. What is Antivirus? Explain features of Antivirus software. ( Page – 63)
6. Explain cyber security technologies. (Page – 65,66)

Unit- 4 Entrepreneurial Skills

1. Explain impact of entrepreneurship on society. (Page – 72)

2. Explain two types of entrepreneurship. (Page – 75)
3. Explain any two qualities of Entrepreneur. (Page – 76)
 Unit 2: Self-Management
Skills – II

Quiz Time (Pg. 41)

c.

Let’s Review (Pg. 43)

c.

Quiz Time (Pg. 44)

c.

Let’s Review (Pg. 45)Fill in the blanks.

1. time 2. emotional intelligence
3. Self-regulation 4. prioritise

Exercises (Pg. 46-49)

A. Tick (✓) the correct answers.
1. b. 2. a. 3. b. 4. b. 5. c.
6. a. 7. c. 8. a. 9. b. 10. a.
B. Fill in the blanks.
1. Depression 2. Hormonal 3. Recreational
4. creativity 5. stressors 6. self-management
7. positive 8. Stress management 9. self-awareness
10. Right attitude
C. Write T for True and F for False.
1. F 2. F 3. T 4. T 5. T
6. F 7. T 8. T 9. T 10. T
 Unit 3: ICT Skills
– II

Quick Guess (Pg. 52)

Real-time Operating System (RTOS)

Let’s Review (Pg. 58)

Write T for True and F for False.

1. F 2. T 3. F 4. F

Let’s Review (Pg. 62)

Answer in one word.
1. Virus 2. Polymorphic
3. Melissa 4. Polymorphic virus

Let’s Review (Pg. 65)

Write T for True and F for False.

1. F 2. T 3. T

Exercises (Pgs. 69-71)

A. Tick (✓) the correct answers.
1. b. 2. c. 3. c. 4. a. 5. b.
6. b. 7. b. 8. a. 9. b. 10. a.

B. Fill in the blanks.

1. Interactive 2. taskbar 3. File infectors
4. interface 5. sub-folder 6. Boot Sector
Virus
7. Malware 8. Cookies 9. Graphical
10. Files and folder
C. Write T for True and F for False.
1. T 2. F 3. F 4. F 5. T
6. T 7. T 8. T 9. F 10. T
 Unit 4: Entrepreneurial
Skills – II

Quick Guess (Pg. 74)

Society

Let’s Review (Pg. 75)

Tick (✓) the correct answers.

1. b.
2. c.

Quiz Time (Pg. 77)

c

Quiz Time (Pg. 81)

b.

AI Review (Pg. 82)

Write T for True and F for False.

1. F
2. F

AI Review (Pg. 82)

Write T for True and F for False.

1. T 2. T 3. F 4. T 5. F

Exercises (Pgs. 87-89)

A. Tick (✓) the correct answers.
1. c. 2. b. 3. c. 4. b. 5. b.
6. a. 7. c. 8. a. 9. c. 10. b.
B. Fill in the blanks.
1. value 2. creativity 3. Perseverance
4. promotional 5. Marketing 6. franchisee, franchiser
7. entrepreneur 8. Self-confidence. 9. coordinator’s
10. Financing
C. Write T for True and F for False.
1. T 2. F 3. F 4. F 5. T
6. T 7. F 8. T 9. T 10. T