U-3 DBMS/ Class 10th IT (402)

 Class – 10^th

IT (402)

Book : Domestic Data Entry Operator

UNIT 3: DATABASE MANAGEMENT SYSTEM

Fill in the blanks

SESSION 1: APPRECIATE THE CONCEPT OF DATABASE MANAGEMENT

 SYSTEM

Fill in the blanks

1)    A database is an organized collection of data. You can visualize it as a container of information.

2)    Database programs such as Microsoft Access, OpenOffice.org Base, and MySQL Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.

3)    A DBMS (database management system) is a software package with computer programs that controls the creation, maintenance, and use of a database.

4)    Flat File means  Data is stored in a single table. Usually suitable for less amount of data.

5)    Relational means Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data.

6)    A database is an organized collection of data.

7)     A _Microsoft Access, / OpenOffice.org Base,/ MySQL _is a software package that can be used for creating and managing databases.

8)     A _Microsoft Access / OpenOffice.org Base is a database management system that is based on the relational model.

9)    Three popular DBMS software are Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite.

10)  A Primary Key (PK) is a unique value that identifies a row in a table.

11)  Composite Key is a combination of _one or more columns.

12) A foreign key is a column or a set of columns in one table that references the primary key columns in another table.

13) The database management systems contain multiple files that are to be stored in many different locations in a system or even across multiple systems. Because of this, there were sometimes multiple copies of the same file which lead to data redundancy.

14) Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users. So it is necessary to ensure that the data is correct and consistent in all the databases and for all the users.

15) Data Security is an important concept in a database. Only authorised users should be allowed to access the database and their identity should be authenticated using a username and password. Unauthorised users should not be allowed to access the database under any circumstances as it violates the integrity constraints.

16) Data consistency is ensured in a database because there is no data redundancy. Data Consistency means there should be multiple mismatching copies of the same data. All data appears consistently across the database and must be same for all the users viewing the database. Moreover, any changes made to the database are immediately reflected to all the users and there is no data inconsistency.

17)  

SESSION 2: CREATE AND EDIT TABLES USING WIZARD AND SQL

 COMMANDS

Fill in the blanks:

1. A table is a set of data elements that is organized using a model of vertical columns(which are identified by their name) and horizontal rows.

2. A Column or Field or Attribute is a set of data values of a particular type, one for each row of the table.

3. A Row or Record or Tuple represents a single, data item in a table.

4. Datatypes are used to identify which type of data we are going to store in the database.

5. There are Two (1Create table in Design View , 2. Use Wizard to Create Table ) ways to create a table.

6. Field properties can be set in both the _design view_ and _datasheet view_ .

 

SESSION 3: PERFORM OPERATIONS ON TABLE

Fill in the blanks:

1. The types of languages used for creating and manipulating the data in the Database are __Data Definition Language. __ & _Data Manipulation Language .

2. A _Data Definition Language (DDL)  is a standard for commands that define the different structures in a database.

3. A data manipulation language (DML)  is a language that enables users to access and manipulate data in a database.

4. A query language is a part of DML involving information retrieval only.

5.A popular data manipulation language is Structured Query Language (SQL) .

6. Entity, attribute and relationships are the basic building blocks of a database.

7. There are three specific types of relationships that can exist between a pair of tables: one-to-one, one-to-many, and many-to-many. 

 

SESSION 4: RETRIEVE DATA USING QUERY

Fill in the blanks

1. A form helps the user to systematically store information in the database.

2. A form enables users to view, enter, and change data directly in database objects such as tables.

3. SELECT statement retrieves zero or more rows from one or more database tables or database views.

4. By default, data is arranged in ascending order. order using ORDER BY clause.

5. UPDATE statement is used for modifying records in a database.

6. DELETE statement is used to remove one or more records in a Database.

 

SESSION 5: CREATE FORMS AND REPORTS USING WIZARD

Fill in the blanks:

1. To create a form you need to select FORMS_ option available under Database section.

2. A QUERY is helps to collect specific information from the pool of data in the database.

3. data dashboard is used to display the display the summary of data.

4. Graphical user interfaces (GUIs) are the interfaces with which the user interacts.

5. Data from multiple tables can be stored in database. .

 

U-2 Electronic spreadsheet Imp Fill up/ Class -10IT (402)

 

Class-10 IT(402) Book -Domestic Data Entry Operator

Unit 2:Electronic Spreadsheet (Advanced) :

Important Fill in the blanks 

SESSION 1: ANALYSE DATA USING SCENARIOS AND GOAL SEEK

1) Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet.

2) Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.

3) SUBTOTAL, totals/adds data arranged in an array—that is, a group of cells with labels for columns and/or rows.

4) Scenarios are a tool to test “what-if” questions. Each scenario is named, and can be edited and formatted separately.

5) A scenario is essentially a saved set of cell values for your calculations. You can easily switch between these sets using the Navigator or a drop-down list which can be shown beside the changing cells.

6) Goal Seek option under Tools menu, you can discover what values will produce the result that you want

7) Solver option under Tools menu amounts to a more elaborate form of Goal Seek.

SESSION 2: LINK DATA AND SPREADSHEETS

1)  At the bottom of each worksheet window is a small tab that indicates the name of the worksheets in the workbook.

2)   A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.

3) There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. 

4) Spreadsheet software allows the user to share the workbook and place it in the Network location where several users can access.

5) Hyperlinks can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to web sites.

SESSION 3: SHARE AND REVIEW A SPREADSHEET

1) Spreadsheet software allows the user to share the workbook and place it in the network location where several users can access it simultaneously.

2) The Comment column by default contains an explanation of the change that was made.

3) Sometimes, multiple reviewers return edited versions of a worksheet at the same time. In this case, it may be quicker to review all of these changes at once, rather than one review at a time. For this purpose, Calc provides the feature of merging worksheets.

4)  Spreadsheet software can find the changes by Comparing Sheets.

5)  Excel comments are used to add a note or explain a formula in a cell. Excel provides users with the flexibility of editing, deleting, and showing or hiding comments on an Excel worksheet. Users can also resize and move the Excel comment box.

6) Choose Edit > Changes > Comments. The automatically-added comment provided by Calc appears in the title bar of this dialog and cannot be edited. Type your own comment and click OK.

7) Spreadsheet software allows the user to share the workbook and place it in the shared location where several users can access.

SESSION 4: CREATE AND USE MACROS IN SPREADSHEET

1) Macros are useful to repeat a task the same way over and over again.

2) A macro is a saved sequence of commands or keystrokes that are stored for later use.

3) Macros are useful to repeat a task the same way over and over again.

4) we record a Macro by steps  using tools - - > macros - - >  Record Macro

U-1 Digital Documentation Practical / Class 10th IT(402)

 Class -10th 

IT (402)

UNIT 1:  DIGITAL DOCUMENTATION (ADVANCED)

Practical Marks : 5

Download Libre Office:

1) Create and Apply Styles in the document :

• List style categories. Select the style from the Styles and Formatting window. 
• Use Fill Format to apply a style to many different areas quickly. 
• Create and update a new style from a selection. 
• Load a style from a template or another document. 
• Create a new style using drag-and drop. 

2)  Insert and use images in document :

• Insert an image to document from various sources. 
• Modify, resize, crop and delete an image. 
• Create drawing objects 
• Set or change the properties of a drawing object 
• Resize and group drawing objects 
• Position the image in the text 

3)  Create and use template:

• Create a template. 
• Use predefined templates. 
• Set up a custom default template. 
• Update a document. 
• Change to a different template. 
• Use the Template. 
• Update the document and save the changes.

4)  Create and customize table of contents  :

• Create a table of contents. 
• Define a hierarchy of headings. 
• Customize a table of contents. 
• Apply character styles.
• Maintain a table of contents. 

5)  Create and Apply Styles in the document :

• Demonstrate to print the label using mail merge, do the following to achieve 
• Create a main document, 
• Create the data source,
• Enter data in the fields, 
• Merge the data source with main document, 
• Edit individual document, 
• Print the letter and address label 

Class-10 IT(402) /Book -Domestic Data Entry Operator /Unit-1 Digital Documentation Fill-up

 

Class-10 IT(402) Book -Domestic Data Entry Operator

Unit-1 Digital Documentation( Advanced) using Libre office Writer

Important Fill in the blanks 

Chapter-1 Introduction to Styles

1) A style is A style is a collection of all formatting information, which you want to save and then apply on the document.

2) Styles are logical attributes.

3) Style help improve consistency in a document.

4) Writer provides six Style categories  : page style, paragraph style, Character style, Frame Style , List Style ,  and Table Style.

5) Page style include page size, margins, headers , footnote, borders and backgrounds. 

6) Paragraph Style  control all aspects of a paragraph's appearance. It include tab stop, text alignment, line spacing and borders.

7)  Shortcut command to style and formatting in Libre office is F11.

8) Character styles affect selected text within a paragraph, such as   changing the text colour, text size, highlighting text and emphasising it

9) Frame styles allows to format a frame by specifying its size, position, border and how the text is placed around the picture.

10) Numbering styles apply similar alignment, numbering or bullet characters, and fonts to numbered or bulleted lists.

11)  List styles include  lists by putting numbering or bullets of a different kind or specify numeric format.

12)  Table styles allows to format a table by adding borders, using different text or border colour(s), aligning text inside the table, having different patterns or text colour.

13) Fill format method is useful when a same style is to be applied at many places scattered in the document. Fill Format can be used to style scattered – pages, frames, tables, lists, paragraphs or characters.

14) Predefined Heading style(s) act as bookmarks in a document. These bookmarks allow faster browsing in a document.

15) These Style(s) and formatting tools can be accessed from Menu bar, Drop Down List and Side bar.

16) Writer allows creating custom style and saving them for future use.

17) New styles can be created using Selection method or Drag and Drop method. Drag and Drop method cannot be used to create a Page style.

18) Styles menu (from sidebar) in Writer provide options to work on all six type of styles.

19) A  Style is a collection of different formats.

20) Styles are especially handy in Libre Office_.

21) Proper use of styles improves consistency in a document.

22)  The first five buttons at the top of the Styles window select the category of styles.

23)Using predefined Heading styles to creates Bookmark in the document.

24) On opening a new file  default  Style is used for formatting the document.

25) In page layout documents, you can arrange  object like text boxes and graphics.

26)  Character styles are often integrated in  paragraph Style.

27) Fill Format  allows to apply style at different places in the document.

28)  Predefined Style  cannot be updated by Drag and Drop method.

 

*************************************************************

Chapter-2 Working with Images

1) Images can be added to a document in several ways: by inserting an image file, directly from a graphics program or a scanner, or from the Open Office Gallery

2) Invert graphic filter Inverts the color values of a color image or the brightness values of a grayscale image.

3) Smooth  graphic filter  Softens the contrast of an image.

4) Sharpen graphic filter increases the contrast of an image.

5) Remove noise graphic filter removes single pixels from an image.

6) Solarization graphic filter mimics the effects of too much light in a picture. A further dialog box opens to adjust the parameters.

7) Aging graphic filter simulates the effects of time on a picture. Can be applied several times. A further dialog box opens to adjust the aging level.

8) Posterize graphic filter makes a picture appear like a painting by reducing the number of colors used.

 

9) Pop Art graphic filter  modifies the picture dramatically.

10) Charcoal graphic filter displays the image as a charcoal sketch.

11) In Relief  graphic filter a  dialog box is displayed to adjust the light source that will create the shadow and, hence, the relief effect.

12) Mosaic graphic filter joins groups of pixels into a single area of one color.

13) Transparency modify the percentage value in the Transparency box on the Picture toolbar to make the image more transparent.

14) Arrangement refers to the placement of a graphic on an imaginary vertical axis. 

15) Arrangement controls how graphics are stacked upon each other or relative to the text.

16)  Alignment refers to the vertical or horizontal placement of a graphic in relation to the chosen anchor point.

17) Anchoring refers to the reference point for the graphics. This point could be the page, or frame where the object is, a paragraph, or even a character. An image always has an anchor point.

18) Text wrapping refers to the relation of graphics to the surrounding text, which may wrap around the graphic on one or both sides, be overprinted behind or in front of the graphic, or treat the graphic as a separate paragraph or character.

19) You can change color images to grayscale by selecting the image and then selecting Grayscale from the Graphics mode list.

20) When Keep image size is selected, cropping produces enlargement (for positive cropping values), shrinking (for negative cropping values), or distortion of the image so that the image size remains constant.

Chapter 3: Advance Features of Writer

1) A template is a model that you use to create other documents.

2) Format and settings regarding indexes, tables, bibliographies, table of contents

Templates can also contain predefined text, saving you from having to type it every time you create a new document

Session 4: Create and customize table of contents

1) The Table of Contents feature allows creating automated page wise headings navigation in digital documents.

2) By default, there is 3 in MS Word, 10 in OO Writer level of headings available for a table of contents.

 

 

3)  It is advisable to create a Table of Contents at Begining of the digital document.

 

 

4. Heading are part of Paragraph  styles.

 

 

5. The main heading is also known as Top-level   heading.

 

 

6. To open insert index/table dialog box click on Insert  ￫ Indexes and Tables￫  Indexes and Tables   in OO writer. To open Table of contents drop down click on  References ￫ Table contents  option in MS Word.  

 

 

7. The preview of the table of content is available at Left in OO writer, Top in Table of contents dorp down in MS Word in the Table of the contents dialog box.

 

 

8. The Protect against manual changes option locks your table of contents for modification in OO Writer.

 

9. For   option allows you to select on which the Table of contents is created.

 

 

10. The  outline  option displays the headings in the hierarchy level in the Table of contents.

 

Session 5: Implement Mail Merge

1) A mail merge can also be a quick way to take a list of people’s mailing addresses and generate labels or envelopes with the address for a different person on each label or envelope

2) The mail merge wizard is available under  tool  menu.

3)  You cannot modify your document contents once the mail merge wizard has been started. False

4). You can use letter  or E-mail type of document in mail merge.

5) . Which button is used to create a new address list in the mail merge wizard in the step insert address block?

    

a) Create Data Source        

b) Select address List        

c) More                       

d) None of these

6) . Which of the following button is used to delete unwanted fields from the address list?

    

a) New            

b) Delete     

c) Customize & then Delete             

d) find

7)  The Save as Individual documents  option is used to create individual merged document .

8)  The From _____ to _________option allows to select range to merge documents.  

8. The mail merge wizard has total  8  number os steps to complete the process.

9. Which of the following is the last step of the mail merge wizard?

    

a) Select the document                                 

b) Edit the document

    c) Personalize document                           

d) Save, Print or send

10. The _______________ step of mail merge wizard allows to modify in the document.

    

a) Select a document type        

b) Create Salutation            

c) Adjust layout               

d) Edit Document

Revision L-8 / Class 5th Computer

  

Class : 5^th

Subject : Computer

Revision  

 (Topic L-8 Internet  )

A) Fill in the blanks                                                                              ( 1  X 4 = 4)

1)   ___________and ________can be attached with e-mail message.

2)   ___________ is the feature of Internet through which purchasing can be done online.

3)   ____________are different types of pictures which represents special moods such as sadness, happiness, angry, etc.

4)   Online Textual Conversation is known as ____________.

 

B) Write T for “True” and F for “False” :-                                   (2X1=2)

1)   Ms-Word is a web bowser                                                    

2)   Most banks now provide their services online, which is fast and secure.  

 

C) Answer the following                                                                    (2X2=4)

1)   What is the difference between Web Site and Web page?

 

2)   What are the Benefits of Internet ?

Solved Revision L-8 Internet / Class 5th computer

 

Class : 5^th

Subject : Computer

Revision Answer

 (Topic L-8 Internet  )

A) Fill in the blanks                                                                              ( 1  X 4 = 4)

1)   Audio and video can be attached with e-mail message.

2)   E-Shopping is the feature of Internet through which purchasing can be done online.

3)   Emoticons are different types of pictures which represents special moods such as sadness, happiness, angry, etc.

4)   Online Textual Conversation is known as chatting.

 

B) Write T for “True” and F for “False” :-                                   (2X1=2)

1)   Ms-Word is a web bowser                                                   FALSE

2)   Most banks now provide their services online, which is fast and secure. TRUE

 

C) Answer the following                                                                    (2X2=4)

1)   What is the difference between Web Site and Web page?

Ans: Web Site : It is the collection of related web pages.

For example : www,sbmpv.org is a name of website which shapes  the future of our nation.

Web Page : It is an individual page of a website. For Example the web page displayed below is an individual page of any website.

 

2)   What are the Benefits of Internet ?

Ans: 1) Internet is the best source to get information on various topics to improve knowledge.

2) Now we can easily connect to the whole world within a few seconds.

3) Using internet, we can show our talents and skill to the whole world.

4) Most banks now provide their services online, which is fast and secure.