Page 12 - IT_V1.0_Class10
P. 12
UNIT-2 ELECTRONIC SPREADSHEET (ADVANCED) USING LIBREOFFICE CALC 143–203
Chapter 4: Analyse Data Using Scenarios and Goal Seek 143
Consolidating Data Group and Outline
Subtotals What-If Scenarios
What-If Analysis Goal Seek
Solver Difference Between Goal Seek and Solver
Chapter 5: Using Macros in Spreadsheet 159
Macro Sorting Columns Using Macro
Chapter 6: Linking Spreadsheet Data 175
Link Data and Spreadsheets Cell Reference Hyperlink
Chapter 7: Share and Review a Spreadsheet 191
Sharing a Spreadsheet Recording Changes
Add, Edit and Format Comment Reviewing Changes
Comparing Versions of a Document Merging Versions
UNIT-3 DATABASE MANAGEMENT SYSTEM USING LIBREOFFICE BASE 204–276
Chapter 8: Introduction to Database Management System 204
Database Database Management System (DBMS)
Data Model Elements of Database
Relational Database Management System (RDBMS) Key Field
Database Objects
Chapter 9: Starting with LibreOffice Base 216
Data Type Starting LibreOffice Base
Closing the Database and Quitting From LibreOffice Open an Existing Database
Creating a Table Inserting Data in a Table
Editing Data in a Table
Chapter 10: Working with Multiple Tables 232
Editing and Deleting Tables Relationship
Chapter 11: Queries in Base 243
Query
Chapter 12: Forms and Reports 254
Forms Report
UNIT-4 MAINTAIN HEALTHY, SAFE AND SECURE WORKING ENVIRONMENT 277–310
Chapter 13: Health, Safety and Security at Workplace 277
Introduction to Health, Safety, and Security at Workplace Policies and Procedures for Health, Safety, and Security
Workplace Safety Hazards Case Studies of Hazards/Accident Due to Avoidable Situations
Chapter 14: Workplace Quality Measures 286
Air and Water Quality Monitoring Process Office Ergonomics
Occupational Overuse Syndrome Health and Safety Requirements for Computer Workplace
Cautions While Working on the Computer
Chapter 15: Prevent Accidents and Emergencies 297
Accidents and Emergencies Fire Hazard in the Workplace
Electrical Shocks and its Effects Healthy Living
C
Part Practical Work & Part D Project Work
Practical Work 311–315
Viva Voce Questions 316–317
Project Work 318–319
CBSE Sample Question Paper 320–323
Glossary 324
(x)

