Page 289 - Computer - 10(A&B)

c. Yes

d. Original Author

Q. 18 A Class X student is participating in a school competition where they need to analyse the performance of
different sports teams based on match scores and statistics. The student has collected data over several
matches and needs to calculate averages, determine rankings, and generate charts for a presentation.

a. How are Macros in Calc helpful to him?
b. How to enable Macro in Calc?

c. Is solution*word a valid macro name? Justify

d. Mention any one operation which cannot be recorded by macro.
Ans: a. Repetitive tasks like calculating average scores, ranking teams based on performance, and generating
graphs could be done with macros. It will save time and effort.

b. Tools > Options > LibreOffice > Advanced. Observe the Optional Features. Two options are not
check marked. Put the checkmark on the option “Enable macro recording”

c. No, solution*word is not a valid macro name. Macro names cannot include special characters such
as asterisks (*) or spaces. Valid characters typically include letters, numbers, and underscores.
d. Opening or switching of windows

Q. 19 A health clinic is developing a patient management system to streamline patient intake, appointments,
and medical records. They need to implement forms for various purposes, including new patient

registration, appointment scheduling, and updating medical histories.
a. What is the use of form in DBMS?

b. What are the different ways to create forms in DBMS?
c. Where can we find various tools to add or edit controls on the form?

d. What is the use of the Records Toolbar in a form?
Ans: a. A form is an object of the database that has a user-friendly interface where data can be entered and

seen in an attractive and easy-to-read format. For any database, it is the front end for data entry and
data modification
b. There are two ways to create a form: • Using a wizard • Using the Design View

c. Forms Control Toolbar
d. The Records toolbar contains the navigation control buttons in the extreme left. With the help of

these buttons, we can traverse and view the records in the file

Q. 20 What points should be included in Fire Prevention Plan in the office?
Ans: • All employees must know where the fire extinguishers are located, and how to properly use them.

• Fire extinguishers and First Aid Stations should be clearly marked with signs.
• Never block access to Exits, fire extinguishers, electric switches and panels.

• Do not block or stack material against doors, which would prevent them from operating properly in
event of a fire.
171