PSEB Notes

This PSEB 7th Class Computer Notes Chapter 4 Microsoft Word Part-II will help you in revision during exams.

PSEB 7th Class Computer Notes Chapter 4 Microsoft Word Part-II

Introduction:
Sometimes we need to create, design and manage effective documentation. To do this, we need to know how to format a document. Formatting means changing the general arrangement and appearance of the text in a document.

There are three types of text formatting available in MS-Word:

1. Character Formatting
2. Paragraph Formatting
3. Page.

In addition, we need to know how to highlight our document so that readers can easily read all the important parts of the document. MS Word gives us the ability to present our documents in a very efficient way. In this lesson, we will learn about formatting text, inserting pictures, inserting charts, creating objects, word art, clip art and more.

Text Selection
Before applying any type of formatting to text in MS Word or any word processing software we have to select the text so that we can apply the formatting on that selected text. We can select text using the mouse button or the keyboard keys.

How to Choose Text in MS Word?
Place the cursor in front of the text and then left click on the mouse button, hold it and drag it over the text and then release it. The text will be selected.

• Double click on the word to select the same word.
• To select the entire paragraph, click within the paragraph three times.
• To select the complete document, in the Home tab from the editing group, click Select command and then click the Select All button.
  Or
  Press Ctrl + A from the keyboard.
• Press Shift + Arrow keys from the keyboard; Hold down the Shift key and press the arrow button, Word will select the text in the direction of the arrow button. There are three arrow keys in numeric keypad, so you can select text in three different directions.

Home Tab:
The Home tab is the default tab in Microsoft Word. It consists of five groups of related commands; Clipboard, fonts, paragraphs, styles and editing. It helps you change the document settings like font size, adding bullets, adjusting style and many more common features. This helps you to return to the home section v of the document.

Clipboard Group
The Clipboard group is the first group to the left side of the Home Tab. This group contains four commands such as cut, copy, paste, format printer. It is often used in conjunction with the editing group, to the right of that tab.
In this topic, today we will learn how to cut copy and paste a word or paragraph.

Copy Paste Options
When we need to retype a word or paragraph in a document, we use the Copy option. Using the Copy option, we save our time and effort. Using the Copy option, you can copy text from one place to another. MS Word offers a variety of ways to copy and paste text.

Some popular methods are given below:
Method 1.

• First select the text you want to copy.
• Click the Home tab and click the Copy command.
• Place the cursor where you want to paste the text.
• Click on the Paste command in the Home tab as shown in the picture above.

Method 2.

• First select the text you want to copy.
• Hover the cursor over the selected text and right click on the mouse. ignore AH
• A menu will appear; Select the “Copy” option from this.
• Now, move the cursor to the desired position and right click on the mouse.
• A menu will appear; Select the “paste” option from this.

Method 3.

• First select the text you want to copy.
• Now press the Ctrl + C button.
• Now, move the cursor to the desired position and press the Ctrl + V button.

Cut Paste Option
Cut Paste Option means to move the selected text from one place to another. In Microsoft Word, you can cut text from a document and paste that text into ‘another document or anywhere in the same document. After cutting the text, it is stored in the clipboard.

Method 1.

• First select the text you want to cut.
• Click the Home tab and then click the Cut command.
• Place the cursor where you want to paste the text.
• Click on the Paste command in the Home tab as shown in the picture above.

Method 2.

• First select the text you want to cut.
• Now click the right button of the mouse on selected text.
• A menu will appear; select the “Cut” option from this menu.
• Now, move the cursor to the desired position and right click on the mouse.
• A menu will appear; select the “Paste” option.

Method 3.

• First select the text you want to copy.
• Now press the Ctrl + X button.
• Now, move the cursor to the desired position and press the Ctrl + V button.

Format Painter
With the help of Format Painter we can copy the format already applied to the text in our document very easily and without wasting time. Below are the steps for copying text formatting:

Method 1.

• First select the text whose formatting you want to copy.
• Click the Home tab and click the Format Painter command.
• The pointer changes to a paintbrush icon.
• Use the brush and drag it over the text where you want to apply the formatting.
• To cancel formatting, press the Esc key or click on the Format Painter command.

Method 2.

• First select the text whose formatting you want to copy.
• Now press the Ctrl + Shift + C button.
• Click on the text where you want to apply the copied formatting.
• Now press the Ctrl + Shift + V button.

Font Group
Text typed with the help of a typewriter is very simple and black in color, in this text we can neither change the color of the letters nor change its style but MS Word has given us a facility with which we can present our text in a very attractive way, we can change the color, style, size etc. of our text. The Fonts group of the Home tab gives us a number of character formatting commands such as font style, font size, font color, bold, italic, underline.

Pressing Ctrl + Shift + F keys will open the Font dialog box on the screen as shown in the picture below:

Font Face
Font face is used to change the appearance of the text. Steps to change the font face of the text are as follow:

• Select the text whose font you want to change.
• Select the appropriate font from the Font dialog box as shown in the picture above.
  Or
• Select the font from the Font drop-down menu in the Font group on the Home tab. Here I have selected the Times New Roman option.

Font Size
To change the size of the text, font side option is used. Steps to change the font size are as follow:

• Select the text whose size you want to change,
• Select the appropriate size from the Font dialog box as shown in the picture above.
  Or
• Select the size option from the Font drop-down menu in the Font group on the Home tab. Here I have selected the size 12.

Grow Font and Shrink Font
As shown in the picture below, large size A is called Grow Font and small size A is called Shrink Font. With the help of Grow Font we can increase the size of selected text by one size and with the help of Shrink Font we can reduce the size of selected text by one size.

• Select the text whose size you want to increase.
• Click on Grow Font.
  Or
  Press Ctrl +> Shortcut button on the keyboard:
• Select the text whose size you want to decrease.
• Click on the Shrink font.
  Or
  Press Ctrl + < Shortcut button on the keyboard.

Font Style
Word processor software uses three basic font styles for text, these are as follows:

• Bold: If you want to thicken the text in your document, the Bold (B) option will be used. To do this, first select the text and then press the B button from the Font group. Or press the Ctrl + B Shortcut button on the keyboard.
• Italic: If you want to italicize the text in your document, the Italic (I) option will be used. To do this, first select the text and then click the I button from the Font group. Or press the Ctrl + I Shortcut button on the keyboard.
• Underline: If you want to underline the text in your document, the underline (U) option will be used. To do this, first select the text and then click the U button from the Font group. Or press the Ctrl + U Shortcut button on the keyboard.

Font Color:
If you want to change the color of a word or paragraph in your document, you must select a font color for this purpose. Here are the steps to change the color of the text.

• Select the text you want to change color.
• Select the appropriate color from the Font dialog box as shown in the picture above.
  Or
• Select the text you want to change the color.
• Click on the Font Color option from the Font group as shown in the picture below. Now a pull down menu will open.
• Choose your favorite color from this menu. Now your text will change to that color.

Text Highlight Color:
Just as we can highlight a word or a sentence in our written document with the help of a pen, we can highlight our text with any color in MS Word.

• Select the text you want to highlight.
• Click on the Text Highlight
  
  option from the Fonts group. Now a pull down menu will open.
• Now choose your favorite color from this menu. Your text will be highlighted in that color.

Clear Formatting:

This option works to remove the formatting applied to the text
document. For this, select the text whose formatting you want to delete, and then click Clear Formatting from the Home tab.

Change Text Case:
(а) Sentence case: It capitalizes the first letter of each sentence.
(b) Lowercase: It changes the text from uppercase to lowercase.
(c) Uppercase-: It capitalizes all the all letters of your text.
(d) Capitalize Each Word: It capitalizes the first letter of each word.
(e) Toggle Case: It allows you to Shift between two case views, e.g. to Shift between Capitalize Each Word and cAPITALIZE eACH wORD.

You can easily change the text case in your document by follow these steps:

• Select the text you want to change.
• Click on the change case option from the Fonts group. Now a pull down menu will open.
• Select the desired case. Your text will be change in that case.

Paragraph Group
The paragraph group provides options related to the setting of the paragraph. Such as alignment, bullet, numbering, line and paragraph spacing etc.

Click on the Show / Hide button to show paragraph symbols and other hidden formatting symbols. Or press the (Ctrl + *) button from the keyboard.

Alignment
You can change the text alignment in your document to make it more presentable and readable.
There are four types of alignments available in the paragraph group which is as follows:

• Align Text Left (Ctrl + L): Aligns the selected text with the left margin.
• Align Text Right (Ctrl + R): Aligns the selected text with the right margin.
• Center (Ctrl + E): This aligns the selected text to the center within the margin.
• Justify (Ctrl + J): Aligns text to both left and right margins, adding extra space between words as necessary.

Here are the steps to change the alignment:

• Select the text.
• Click the appropriate alignment button from the Paragraph group of the Home tab.

Bullets and Numbers
Bullets or numbers are used to create a list in a document or to convert typed text into a list. Here are the steps to add bullets and numbers to a list:

• Place the cursor where you want to insert the bullet/number.
• If you want to insert a bullet, click on the Bullet option in the paragraph group and if you want to insert a number, click on the Number button.
• If you want more bullets/numbers style options, click on the arrow to the right of the bullet/number command. This will open the drop down menu.
• Now select any bullet/number style that you want to add from this list.

Paragraph Indenting:
Indenting a paragraph allows you to set text within a paragraph at different margins. There are several options for indenting:

• First Line: This option controls the left limit for the first line of the paragraph.
• Hanging: Controls the left boundary of each line in a paragraph except the first line.
• Left: Controls the left border for each line in a paragraph.
• Right: Controls the right limit for each line in a paragraph.

To indent paragraphs, you can follow the steps below :

• Place the cursor where you want to increase or decrease the indent.
• Click on the indent
  
  buttons to control the indent
• Repeatedly click the indent button to increase or decrease the size of the indent.

Line Spacing Adjustment
Line spacing represents the vertical distance between lines within a paragraph and determines the position of each line corresponding to the line above it. By default the line spacing is 1.15. You can increase or decrease the spacing between lines from the Paragraph dialog box. The line spacing drop-down menu includes two options, Add Space Before Paragraph and Add Space After Paragraph, this option adds a line of space above paragraph and below paragraph. Adding space will be removed by clicking this option again.

You can change the space between lines and paragraphs by following the steps below:

• Select the paragraph you want to change.
• On the Home tab, click the Paragraph dialog box launcher.
• Click the Indents and Spacing tab from the paragraph dialog box.
• In the Spacing section, adjust the space according to your needs.

Click on the line spacing button in the paragraph group as

and click on the required option from the drop down menu.
Or
To add single line space press (Ctrl +1), to add double line space press (Ctrl + 2) and to add 1.5 line space press (Ctrl + 5).

Borders and Shading
You can add borders and shading to paragraphs and full pages.
1. Shading: This option is used to color the background of the paragraph or selected text.

2. Border: This option is used to customize the border of the selected cell or text.

If you want to apply a border/shading to a paragraph or an entire page, first select the paragraph or page, then click the Borders or Settings button. For more border/shading options, click the small arrow next to it.

Style Group
You can create professional and presentable documents in MS Word by applying different styles. Changing the style of text can make your document look amazing as well as prepare your document for a table of contents page. You have several choices to choose from.

To use Quick Styles:

• Select the text you want to format.
• Click the Styles group next to the Home tab dialog box.
• Click the style you want to apply.

To see all options, click the dialog box launcher in the lower right corner of the Styles section.

Editing Group
The edit group actually appears at the far right of the Home tab. There are three options in this group which are as follows:

• Find (Ctrl + F): If you want to find a particular word or phrase in a document or an entire page, you can use the “Find” option.
• Replace (Ctrl + H): You can use this option if you want to delete any word and insert new word in that position.
• Select: This option is used to select a document .There are three different options for selection, which are as ahead:
  (а) Select All (Ctrl + A): This option allows us to select the entire document.
  (b) Select Object: This option allows you to select one or more objects, (c) Select Text with Similar Formatting: This option allows us to select words with similar formatting.
• GoTo (Ctrl + G): With the help of this command, we can easily reach a specific place in the document. Such as pages, sections, bookmarks, footnotes, end notes, etc.

Finding Words:
If you want to search for a word in a document follow these steps :

• Click the Find option from the Editing group on the Home tab.
• Type the words in the Find What box as shown below and click on the Find Next option.

Replacing Words:
To replace a word or more in a document follow these steps:
Click the Replace button from the Editing group on home Tab. The Find and Replace dialog box will display.

• Type the word you want to change in the Find What box as shown.
• In the Replace With box, type the word with which you want to replace the old word.
• Click on the Find Next option.
  You can use the Ctrl + F keys to find words and the Ctrl + H shortcut keys to replace words.

Insert Tab
This tab contains all the commands for inserting items into your documents like Pages, Tables, Links, Header and Footer, Text, Symbols are all insert tab options.

Pages
There are 3 options in the page group as shown in the picture below:

1. Cover Page: This button can be used to insert a pre-formatted cover page for a document. The information displayed on the page is filled in after the page is created.

Steps to add a Cover Page :
(a) From the Insert Tab, in the Pages group, click the Cover Page button.
(b) Select the cover page of your choice.
(c) Add in important information by editing the text that displays on the cover page.

2. Blank Page: This option is used to insert a new blank page into a document at the cursor position. If you want to add a new page anywhere in your document, click on the Blank Page option in the Page group from the Insert tab.

3. Page Break: This option is used to delete a page at the current cursor position and start a new page. In simple words we can say that it divides the page into two parts. For Page Break, click on the Page Break option from the Page group or use the Ctrl + return keys.

Tables Group
This button is used to insert a table into the document. With this option, you can create a table or row or column in the document. Or you can set the rows and columns of the table as your wish. In MS Word you can easily convert text to table.

Here are the steps to insert a table:

• Place the cursor where you want to place the table.
• Click the Table button from the tables group in the Insert tab. A dropdown table grid will open.
• Click and drag over the small boxes to determine the number of columns and rows for your table.

According to Insert Table dropdown menu we have three more options to insert a table into the document.

• Insert Table: You can click the Insert Table menu item to type in the number of columns and rows.
• Draw Table: Click the Draw Table button to use a pencil tool to draw cells of a table.
• Quick Table: By clicking on the Quick Tables option, we get a list of different table designs. You can choose any design of your choice for the table.

Illustrations Group
This group allows us to add photos, clip art, shapes, smart art, etc. in our document.
1. Pictures: This option is used to insert photos into your document. Here are the steps to insert pictures into the document:
(a) Place the cursor where you want to insert the image.
(b) In the Insert tab, click on the Picture option from the Illustrations tab.
(c) The Insert Picture dialog box will open.
(d) From this dialog box, click the image you want to insert.
(e) Click on the Insert button.

2. Shapes: This button is used to insert the shapes such as circles, squares, arrows and triangles into a document, When the button is clicked. Here are the steps to insert the shape:
(а) In the Insert tab, click on the Shapes option from the Illustrations tab.
(b) A gallery of different shapes will appear.
(c) Click the desired shape and then drag the shape into the document.

If you want to write something in the drawn shape, here are the steps:
(a) Right click on the drawn shape.
(b) Click Add Text from the pop-up menu.

You are now able to type the text in your Shape.

3. Smart Art: Smart Art graphics are visual representations of information. The Smart Art option is used to present information in the form of an image easily and quickly. This option offers many different layouts to effectively communicate your message or ideas. The steps to add smart art graphics are given below:
(а) On the Insert tab, in the Illustration group, click Smart Art.
(b) In the Choose a Smart Art Graphic dialog box, choose the layout you want to insert.
(c) Click the Ok button to insert your Smart Art graphic.

1. Click the Text Pane from the Create Graphic group in the Design Tab.

2. Type your text in the Type your text here box.

In the Smart Art Graphic, click the [Text] box and then type your text. For best results, use this option after you have added all the boxes.

Charts
Use this feature to insert a bar, area or line chart in a document. Steps to insert the chart are as follow:

• From the Insert tab, in the illustrations group, select Chart button.
• From the pull down menu, select the chart design you would like to use and then click Ok.

Clip Art
Clip art refers to a graphic or a picture that you can insert in your document. It comes in different formats and styles. It is used to enhance the appearance of a document. The steps to insert a clip art are given below:

• Place the cursor where you want to insert the clip art.
• From the Insert tab in Illustrations group click the Clip Art button.
• A task pane appears on the right side of document.
• Enter the keyword in ‘Search for’ field and select the suitable option in ‘Search in’ and ‘Results should be’ fields.
• Click Go, clip art menu will appear.
• Select the desired clip art.

Header & Footer
Header and Footer are parts of a document that contain specific information such as page number and total number of pages, title of the document, company logo, any photo, etc. A header appears at the top of each page and footer appears at the bottom of each page.

To insert the header and footer in your document steps are as follows:
1. From the Insert tab, click the Header / Footer option from the Header & Footer group.

2.Now a drop down menu of pre-design heading styles will open, from this menu you can choose any style as per your need.

3. Similarly clicking on the Footer option will open the already created Footers design and you can choose any design as per your need.

4. Now click on Edit Header or Edit Footer from the Header or Footer drop down menu.

5. Now you can edit the header/footer of your document.

6. Click the Close Header and Footer button to exit edit mode.

Insert Date and Time in Header/Footer
To insert the date or time in the header or footer, follow the instructions below:

• From the Insert tab, click the Date & Time option in the Text group.
• A Date & Time dialog box will open.
• Select the date format from the‘Available Format’list.
• Choose your desired language.
• Click the Update Automatically check box.
• Click the OK button at the bottom of the dialog box.

Removing Headers and Footers
The steps for removing headers and footers are as follows:

• From the Insert tab, click the Header/Footer command from the Header & Footer group.
• Now the drop down menu will open, from this menu you can click on Remove Header/Remove Footer option.

Page Number
MS Word automatically places a page number on top of each page and place it in the title, footer or sidebar. We can use the “Format page number” option to assign different numbers to these pages with the help of MS Word. Page number drop-down commands include: top of page, bottom of page, page margin, current position, format page number and delete page number.

1. Top of Page: If you want to put a number at the top of your page, click on the Page Number option from the Header & Footer group of the Insert tab and click on the Top of Page option from the drop-down list.

2. Bottom of Page: If you want to enter the number at the bottom of your page, click on the Page Number option from the Header & Footer group of the Insert tab and click on the Bottom of Page option from the drop¬down list.

3. Current Position: If you want to enter the page number on the position of your cursor, click on the Page Number option from the Header & Footer group of the Insert tab and click on the Current Position option from the drop-down list.
4. Remove Page Number: If you want to delete the previously entered page number, click on the Page Number option from the Header & Footer group of the Insert tab and click on the Remove Page Number option from the drop-down list.

Text Group:
The following options are available in the text group:

• Text: Text boxes are used to highlight text in a document.
• Quick Parts: Click this button to insert pre-formatted text, auto-text, document properties and fields into a document. Several different types of Quick Parts are available. It is also possible to create customized Quick Parts to use later in documents.
• Word Art: To insert decorative text into a document, click this button.
• Drop Caps: Drop Caps wrere used to create a capital character at the beginning of a paragraph. When this button is clicked, three options for drop caps will be displayed.

Hover the mouse over one edge of the text box. Mouse pointer will turn into a cross with arrows.

Click, hold and drag the text box to the desired location.

Resize Text Boxes

• Click on the text box you want to resize.
• Click, hold and drag the two-sided arrow-shaped handle on the corners or sides of the text box until it is the desired size.

Word Art
Word Art is designed to allow you make your text more attractive; you can format your text to make it look like a picture or 3D art and enhance its appearance in different ways. The steps to insert Word Art are given below:

• Select the text you want to change.
• Then click on the Insert tab.
• Click on the WordArt drop-down arrow in the Text group.

• A drop-down menu of WordArt style will appear. Click the style you want to use.
• Word will automatically create a text box for the text.
• Now click Ok button, the text will appear in the selected style.

Add Drop Cap Text

• Select a paragraph from your document.
• From the Insert Tab, in the Text group, click Drop Cap.
• Select the Drop Cap option of your choice from the menu.

Symbols Group.
Two buttons allow you to add special typing to your document. These buttons are Equation and symbols.

1. Equation: This button is used to insert a mathematical equation into a document. The equation tools ribbon will appear when the button is clicked. This ribbon is used to create the equation. A list of common equations is also available.
You can add it to your document by clicking on the equation you need from the Built-In Equation list as shown in the picture below:
Or
Click “Insert New Equation.” You will see a new “Equation Tools” Ribbon tab, giving you the option to create your own equation from scratch.

2. Symbols: The Symbols tool allows you to type characters that are not often found on the keyboard. This button is used for inclusion in copyright or trademark documents.

Click on the button to see some recently used symbols:

• Place your cursor where you want to add the symbol.
• From the Insert Tab, in the Symbols Group, click Symbol button.
• Select the symbol of your choice from the available options.
• If you don’t find the symbol at first, click the More Symbols option and select from the choices made available.

Note:

• Formatting means changing the general arrangement and appearance of the text in a document.
• There are three types of text formatting available in MS-Word:
  1. Character Formatting
  2. Paragraph Formatting
  3. Page.
• The Home tab is the default tab in Microsoft Word which consists of five groups of related commands; Clipboard, fonts, paragraphs, styles and editing.
• The Fonts group of the Home tab gives us a number of character formatting commands such as font style, font size, font color, bold, italic, underline.
• With the help of Format Painter we can copy the format already applied to the text in our document.
• We can also reverse the work done during editing using undo command. If we have made a mistake while editing the text in the document, we can correct it by clicking on the Undo command from the “Quick access” toolbar and this will undo the last change we made to the document,
• With the help of Grow font we can increase the size of selected text by one size.
• With the help of Shrink font we can reduce the size of selected text by one size.
• Word processor software uses three basic font styles for text, these are Bold, Italic and Underline.
• Clear Formatting option is used to remove the formatting applied to the text document.
• There are four types of text alignments available in the paragraph group, which are Align Text Left, Align Text Right, Center and Justify.
• Bullets or numbers are used to create a list in a document or to convert typed text into a list.
• To find a particular word or phrase in a document the “Find” option is used.
• If you want to delete any word and insert new word in that position, use Replace option.
• “Select Text with similar Formatting” option allows us to select words with similar formatting.
• Insert tab contains all the commands for inserting items into your documents like Pages, Tables, Links, Header and Footer, Text, Symbols etc.
• With the help of “Draw Table” button, we use a pencil tool to draw cells of a table.
• Page Break option is used to delete a page at the current cursor position and start a new page.
• Clip art refers to a graphic or a picture that you can insert in your document.
• Header arid Footer are parts of a document that contain specific information such as page number and total number of pages, title of the document, company logo, any photo, etc.
• A header appears at the top of each page, and footer appears at the bottom of each page.
• Text boxes are used to highlight text in a document.

This PSEB 9th Class Agriculture Notes Chapter 11 Important Current Issues in Agriculture will help you in revision during exams.

PSEB 9th Class Agriculture Notes Chapter 11 Important Current Issues in Agriculture

→ Man has been practicing farming since time immemorial.

→ By using specialized genetic engineering technologies crops can be genetically modified by the transfer of genes of other plants or organisms into the crop.

→ Such improved crops are known as G.M. or transgenic crops.

→ Bt is an abbreviation for the soil bacterium Bacillus thuriengiensis.

→ A crystalline protein is produced in Bt cotton which is highly toxic for bollworms; insects pests of cotton.

→ Initially Bollguard-I hybrid had only one Bt gene and later on, Bollguard-II had two Bt genes.

→ The yield of Bt cotton is five quintal lint per acre.

→ After the introduction of Bt cotton use of insecticides has reduced a lot.

→ GM crops of Brinjal, soybean, maize, rice, etc. have been developed.

→ Some organisations, social activities consider GM crops have an adverse effect on the environment, human health, biodiversity of plants, and species of cultivated plants.

→ The government of India enacted ‘protection of plant varieties and the Farmers’ Rights Act (PPV & FR act) in 2001.

→ This act provided protection for general crops for six years and the protection period can be extended for 15 years.

→ Trees and vines were protected for 9 years and the period can be extended for 18 years.

→ One can get information about registration from the site www.plantauthority.gov.in.

→ Developed countries are using the new concept of precision farming, for this, they are using sensors, G.P.S., etc.

→ In developed countries nitrogen sensor is used to find out the requirement of nitrogen in different sections of a field.

→ We can save water by using a laser land leveler and Tensiometer.

→ In some of the developed countries, G.P.S. is used to accurately measure the fields.

→ According to reports, due to global warming earth has warmed by 0.5°C over the past 100 years.

→ Green House Gases are Carbon dioxide, nitrogen oxide, chlorofluorocarbon (CFC), methane, etc.

This PSEB 9th Class Computer Notes Chapter 4 Introduction to DBMS will help you in revision during exams.

PSEB 9th Class Computer Notes Chapter 4 Introduction to DBMS

First research for DBMS use was held in 1960 which was in the form of small software A U.S. based company N.A. A. (North America Aviation) was created it with the Name of GUAM (Generalize Update Access Method). GUAM was based on small components, different components build it together so it was called a hierarchical structure at that time.

History of DBMS:

From 1960 to 1970 on the basis hierarchical structure several researches was done and in 1967 Conference on Data System Languages (CODASYL) created Task force with the collaboration of the U.S. government and the big business personalities which was called Database Task Force Group(DBTG).

IN 1971 Network Database was developed and later ones from time to time inventions come into existence after the DBMS innovation was done and now we are easily using DBMS in our todays life.

Terminology used in Databases

In databases many technical terms are used. Some of the important terms are as follows :

1. Attribute: In a database management system, an attribute refers to a database component, such a table. It also may refer to a database field.
2. Record: A record is a group of fields within a table that reference one particular object. A record is also known as a tuple.
3. File: Files in computers fields are very similar in features to that of paper documents used in library and office files.
4. There are many kind of files such as text files, data files, directory files, binary and graphic files, and these different types of files store different types of information.

Data and Information

Data are small raw materials such as character, numbers, pictures etc. After processing on these raw materials we get meaningful information.

Database

Database is a proper arrangement of information. There is no use of unarranged information. Database is a collection of a large amount of data. Dictionary is the best example of data in which all words are arranged in an alphabetical sequence which makes it easier for any word to search.

Computer database is collection of well-arranged records that is stored in the computer. User can obtain the required information from the database. The decision can be taken on the basis of this information. Software called database management system is used to prepare database.

Necessary instructions for designing a good database.

1. The data must be accurate ,well arranged and complete so it could be easily fetch when required by someone.
2. While creating database system we have to keep in mind that whether database application is going to use on any website or any other local area network or on both the result must be able to get very fast and accurate.
3. The database design should be correct.
4. Database should be design while thinking about the future problem.

Uses of Database System Application:

1. In banking sector to look after of the account of the customer.
2. For airline reservation and making schedule of the information.
3. In universities to fetch information of the students and about the courses.
4. To create the monthly statement of an organization.
5. For telecommunication
6. In finance to store the information of sales and purchase.
7. In sales to store the information of customers purchased products.
8. In Manufacturing management to store the information of warehouses.
9. In human resource to store the employee’s salary bills, payrolls, taxes etc.

File Processing System:

In old approach, before to computer, all information’s were stored on papers. But initial days, these records were stored in the form of files. That’s why this system is Called FILE PROCCESING SYSTEM. This is the way we stored data or record in files is similar to papers, in the form of flat files to be simpler, in notepad.

All files were grouped according to their categories; files uses only related information’s and each file is named properly.

Drawbacks of file processing system

1. Data Mapping and Access: Although all the related information’s are grouped and stored in different files, there is no mapping between any two files.
2. Data Redundancy: There were no methods to validate the insertion of duplicate data in file system. Any user can enter any data.
3. Data Dependence: In the files, data are stored in specific format, say tab, comma or semicolon. If the format of any of the file is changed, then the program for processing this file needs to be changed.
4. Data inconsistency: This has occurred here, because there is no proper listing of files which has same copies of data.
5. Security: Each file on computer can be password protected. This is very difficult in the file system.
6. Integrity: If There is no direct checking facility in the file system. Hence these kinds of integrity checks are not easy in file system.
7. Concurrent Access: Accessing the same data from the same file is called concurrent access. In the file processing system, concurrent access leads to incorrect data.

DBMS:

The full name of DBMS is data management system. A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers a systematic way to create, retrieve, update and manage data. The DBMS essentially serves as an interface between the database and end users or application programs ensuring that data is consistently organized and remains easily accessible.

Advantages of DBMS:

1. When the same data is duplicated and changes are made at one site, which is not propagated to the other site.
2. Redundancy is controlled in DBMS.
3. Data is shared by multiple applications or by multiple users in DBMS.
4. In DBMS there is Restricting unauthorized access to the database.
5. DBMS Providing Backup and Recovery.
6. DBMS Solves Enterprise Requirement than Individual Requirement.
7. DBMS systems provide mechanisms to provide concurrent access of data to multiple users.
8. In DBMS ,Data Model can be developed.
9. DBMS is a central system.

Disadvantages of DBMS:

1. You must have to get training to use the database.
2. However, the DBMS is written to be more general, to cater for many applications rather than just one. The effect is that some applications may not run as fast as they used to.
3. Higher impact of a failure so there is every possibility of damaging the data.
4. An extra hardware is needed.
5. Conversion, cost is very high of the DBMS, its not easy to move it here and there.
6. The complexity and breadth of functionality makes the DBMS an extremely large piece of software, occupying many megabytes of disk space.
7. The cost of DBMS varies significantly, depending on the environment and functionality provided. There is also the recurrent annual maintenance cost.

DBA:

DBA stands for database administrator. DBA should be a person or bunch of persons. Database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system.

Different types of DBA’s according to their responsibilities are as follows:

1. Administrative DBA
2. Development DBA
3. Architect DBA
4. Data Warehouse DBA

Main Responsibilities of DBA are the following:

1. DBA has to take care of the Database design and implementation.
2. DBA will Implement and maintain database security.
3. DBA is responsible for the Database and application tuning and performance monitoring too.
4. DBA is responsible to Setup and maintain documentation and standards.
5. DBA will look upon the plan growth and changes.
6. DBA have to establish and maintain sound backup and recovery policies and procedures.
7. DBA decides about which kind of hardware will be in use.
8. DBA have right to change data according to the needs of user.
9. DBA fix data validation for the users.

Redundancy:

A very large amount of duplicate data stores frequently in database in duplicate form again and again . This is called data redundancy.
Types of Entities:
In DBMS types of Entities are as follows:

1. Weak entity: Weak entity is that type of Entity that cannot be identified separately by its attribute. Thus, We can say that this Entity is not caused primary key.
2. Strong entity: The entity in which Primary key is used that entity is called strong entity by this data comes distinctiveness.

Entity-Relationship Diagram:

Entity-Relationship Diagram is a way which will help us to we identifying with attributes of an entity we can show it logically. There are several ways to ‘make ER Diagram Two them are as follows of which are used mostly.
1. Dr. Peter Chen
2. James Martin and Clive Finekelstein

Keys in DBMS:

Keys are very important part of database management system.

1. Super Key: Super key is defined as a set of attributes within a table that uniquely identifies each record within a table. Super Key is a superset of Candidate key.
2. Candidate Key: Candidate keys are defined as the set of fields from which primary key can be selected.
3. Primary Key: Primary key is a candidate key that is most appropriate to become main key of the table. It is a key that uniquely identify each record in a table.
4. Composite Key: Composite Key is the key which consists of two or more attributes that uniquely identify an entity occurrence is called Composite key.
5. Foreign key: Foreign key is the key in rational database that provide link between two tables because it references the primary key of the another table and it established a link between them.

Normalization:

Normalization is a scientific way in which difficult table is make quite simple in terms of understandable by user. To reduce Redundancy from tables and to reduce database Inconsistency or to remove and to make database strong.

1. There should be an identifier in each table.
2. In each table single type of entity should be stored Null.
3. Value should store at minimum.
4. Same Values that should take place use less frequently in database.

Normalization Concept: To implement Normalization concept various normal forms are used. Commonly used Normal forms are written as follows:

1. First Normal Form (INF)
2. Second Normal Form (2NF)
3. Third Normal Form (3NF)
4. Fourth Normal Form (4NF)
5. Boyce Coded Normal Form

Relationships:

Relationship allow relational database to split and store data in different tables.

Types of relationship are as under

1. One-to-One: One to one is implemented using single table by establishing relationship between same type of column in table.
2. One-to-many: One to many is implemented while using two tables with primary and foreign key relationship.
3. Many-to-Many: Many to Many implemented using a junction table. The keys from both the tables from composite primary key of the junction table.

What is Oracle.

Oracle is world’s larges4 software company, it was founded in 1977 with the name of Relational Software Corporation, and This Company developed first Relational Database Management Software (RDBMS) Oracle in the world.

SQL:

Structure query language is a high level language which is used to store, control and amend the database.

SQL Advantages:

1. SQL is not only a high level language even we have to use it for maintain the data, update data and controlling the data.
2. SQL provides the facility to a user to do work simultaneously in different databases
3. Program build in SQL is portable means it is very easy to a user to move it anywhere
4. SQL is an easy and simple language to learn and it use to make tough programs.

DB2:

DB2 is a database product which was design by IBM. It is a relational database management System. DB2 is developed to store, to find to look and to get accurate data from database.

Data Models:

Data model is a way to give us information about the structure of database.

1. Object Oriented logically model: It is used to describe data line by line. It is of five type:

1. Binary model
2. Functional Model
3. Entity relationship model
4. Object oriented model
5. Symantic data model

2. Record Base Logical Model: It is also used to describe data line by line but a format is used in it permanently. It is of three types:

1. Network model
2. Relational Model
3. Heirachical Model
   

3. Physical Data Model: It has been used to describe data at lowest level of the database. Some parts of it are as follows:

1. Entity: Tells about different kind of entities of the database.
2. Attributes: It tells about the entity of users Name, Address etc.
3. Entity set: It is the mixture of entity and attributes. Different kind of entity and attributes are store here.
4. Relationship: It describes about the relationship of the entity which we are using.
5. Relationship set: Many kind of relationships are used in database but when same kind of relationship bring together at a place it is called relationship set.

This PSEB 9th Class Computer Notes Chapter 3 Networking will help you in revision during exams.

PSEB 9th Class Computer Notes Chapter 3 Networking

In networking the computers are connected to each other to share data with each other.

Networking:

A network is the group of two or more computers that are linked in order to share resources exchange files, or allow communications.
The computers on a network may be linked through cables, telephone lines, radio waves, satellites, or infrared light beams.

Need for Networking:

The ability to exchange data and communicate efficiently is the main purpose of networking computers. Some of common factors for Networking are:

Networks are used to:
1. Facilitate communication via chat email, video conferencing, instant messaging, etc.
2. Enable multiple users to share a single hardware device.

3. Enable file sharing across the network.
4. Allow for the sharing of software or operating programs.
5. Make information easier to access.
6. Allow Multi users to work together from different locations.
7. Allow Multi users to access the Internet simultaneously
8. Store data centrally for ease of access and back-up.

Advantages and Disadvantages of Computer Network:

Advantages of Network:

1. Sharing files, data and information: We can share data program and different resources with it. It is only possible because all the files are stored on server
2. Sharing Hardware and software: We can share hardware and software within network easily.
3. Communication Media: Network provides a very fast communication media
4. Data Integrity: File integrity remains continuous due to network. It saves much time. Network helps in fast saving and sharing of files.
5. Cost-effective: We can share costly input and output devices like printer with network . It reduces the cost of system.
6. Reliability: Network ensures use of many resource to us e.g. when hardware fails, information can be recovered from other computer with the help of network.
7. Flexibility: It provides more flexibility because in it there is a possibility of connecting devices of different businessmen.
8. Backup: We can take backup over network.
9. Security: Network provides security to us.
10. Speed: Sharing and transferring files within networks is very rapid as compared to mannual transfer.

Disadvantages of Network:

1. Management: Management of whole network is tough.
2. Network Failure: All the central facilities may fail due to network failure.
3. Expensive to Build: Building a network is a serious business in many occasions, especially for
4. Security: Danger of security is always present on network. Data can be misused on network.
5. Large scale organizations: Cables and other hardware are very pricey to buy and replace.

Parts of Computer Network:

The purpose of a network is to join computers together. The computers will also need to include software that enables them to connect to the network.

There are two types of computers which are used for networking:
1. Client or Node: Client/Node is the normal computer system which is connected to network for sharing of resources.
2. Server: It is a powerful computer. It helps in sharing of resources or information. It controls all other nodes.
3. NIC: A network interface card (NIC) is a computer circuit board or card that is installed in a computer so that it can be connected to a network.

It should be fitted in each client and server computer. Every client linked to network interface card has its own specific number is called node address.
There are two types of network cards: wired and wireless!
4. HUB/Switch: A networking hub/Switch is a device that allows you to connect multiple computers to a single network device.

5. Router: A router is hardware device designed to receive, analyze and forward incoming data within a network or to another network.

Networks Topologies:

The term Topology refers to the way in which the various nodes or computers of a network are linked together. It describes the actual layout of the computer network hardware.

It may be depicted physically or logically. Physical topology is the placement of the various components of a network, including device location and cable installation, while logical topology illustrates how data flows within a network.

The following factors are considered while selecting a topology:

1. Cost
2. Reliability
3. Scalability
4. Bandwidth capacity
5. Ease of installation
6. Ease of troubleshooting
7. Delay from one node to another.

Topologies:

While making a selection of a particular topology we consider the relative status of different devices that are to be linked.

The nodes in a network can have following two relationships:
1. Peer to Peer: In this relationship, all the devices in the network have equal status in sharing the link.
2. Client-Server (Primary-Secondary): In this, one device controls the traffic and all other devices transmit through primary device.

Types of Network Topologies:

1. Bus Topology: Bus Topology is the simplest of network topologies. In this type of topology, all the nodes (computers as well as servers) are connected to the single cable (called bus), by the help of T- connectors. This central cable is the backbone of the network and is known as Bus (thus the name). A signal from the source is broadcasted and it travels to all workstations connected to bus cable.

Advantages of Bus Topology:

1. Any new computer can be attached easily.
2. It is a cheaper topology.
3. If one computer fails, others are not affected.

4. Cable required is least compared to other network topology.
5. Used in small networks.
6. It is easy to understand & connect

Disadvantages of Bus Topology:

1. More wire is needed to connect more nodes,
2. If the main central line fails the entire network collapses.
3. The efficiency of network is reduced with the increase in number of computers.
4. Cable has limited length.
5. It is slower than the ring topology. .
6. Terminators are required at both ends of the backbone cable
7. Difficult to identify the problem if the entire network shuts down

2. Ring Topology:

In it all the computers are logically linked in the form of a ring. In it each node is connected to two other nodes. Rings can be unidirectional, with all traffic travelling either clockwise or anticlockwise around the ring.
There are two kinds of ring topologies :

1. Single Ring
2. Dual Ring

Advantages of Ring Topology:

1. Very orderly network where every device has access to the token and the opportunity to transmit
2. Performs better than a bus topology under heavy network load
3. Does not require a central node to manage the connectivity between the computers
4. It is easier to locate the problems with device and cable i.e. fault isolation is simplified. If one device does not receive a signal within a specified time, it can issue an alarm.

Disadvantages of Ring Topology:

1. Failure of one computer can affect the total network
2. Difficult to troubleshoot
3. Adding or removing Computers disrupts the network
4. A ring network requires more cable than a bus network.

3. Star Topology:

In this type of topology all the computers are connected to a hub, a router or a switch. This hub/switch is the central node and all others nodes are connected to the central node. The computers present in star topology cannot have a direct relation with each other.

Advantages of Star Topology:

1. It is easily to prepare and connect.
2. It is easier to find faults in network.
3. More nodes can be connected in it. With it propagation delay does not increase.
4. Easy to setup and modify.
5. Easy to troubleshoot.
6. Failure of one computer does not effect the other.

Disadvantages of Star Topology:

1. Performance and as well number of nodes which can be added in such topology is depended on capacity of central device.
2. Cost of installation is high
3. Failure of hub results in failure of complete network.

4. Mesh Topology:

1. In mesh topology, each node is connected to every other node in the network.
2. A mesh topology can be a full mesh topology or a partially connected mesh topology.
3. In a full mesh topology, every computer in the network has a connection to each of the other computers in that network.

4. In a partially connected mesh topology, at least two of the computers in the network have connections to multiple other computers in that network.

Advantages of Mesh Topology:

1. In the event that one of those nodes fails, network traffic can be directed to any of the other nodes.
2. Even if one of the components fails there is always an alternative present. So data transfer doesn’t get affected.
3. Data can be transmitted from different devices simultaneously. This topology can withstand high traffic.
4. Expansion and modification in topology can be done without disrupting other nodes.

Disadvantages of Mesh Topology:

1. Installation and configuration is difficult.
2. Cabling cost is more.

5. Tree Topology:

A tree network is a combination of two or more star networks connected together which involve a variety of single nodes connected to a central node.

Advantages of Tree Topology:

1. It is an extension of Star and bus Topologies, tree topology is the best alternative.
2. Expansion of Network is possible and easy.
3. The whole network can be easily managed and maintained.

4. Error detection and correction is easy.
5. If one segment is damaged, other segments are not effected.

Disadvantages of Tree Topology:

1. Tree topology, relies heavily on the main bus cable.
2. Scalability of the network depends on the type of cable used.
3. As more and more nodes and segments are added, the maintenance becomes difficult.
4. It has higher cabling cost in setting up a tree structure.

6. Hybrid Topology:

A hybrid topology is a type of network topology that uses two or more other network topologies, including bus topology, mesh topology, ring topology, star topology, and tree topology. It is two different types of topologies which is a mixture of two or more topologies.

Advantages of Hybrid Topology:

1. Reliable as Error detecting and troubleshooting is easy.

2. Effective.
3. Scalable as size can be increased easily.

Disadvantages of Hybrid Topology:

1. Complex in design.
2. Costly.

Data Communication:

Data communication is exchange of data between two or more computers with the help of communication medium. The device that transmits the data is known as sender and the device that receives the transmitted data is known as receiver.
Data communication must fulfil/obey following three conditions:
1. Delivery: Network should deliver the data at proper place.

2. Accuracy: Data communication should be free from fault.
3. Time limit: Data should reach destination without any delay.

Components of Data Communication

1. Sender: Sender prepares information (data) and sends it.
2. Medium: It carriers the information from sender to receiver.
3. Receivers: Receiver receives the information.
4. Protocol: There are rules under which data transmission takes place between sender and receiver.

Methods of data transmission:

Three methods of data transmission are given below:
1. Simplex: In it communication is one direction. The message source works as the transmitter. It sends the message over the data channel to the receiver. The receiver is the destination of the message.

2. Half duplex: In it information can flow in both directions but not at the same time. In other words if information is sent by one system then second can only receive it or vice versa

3. Full duplex: In it information can move in both directions at same time. It provides fast communication.

Communication Channel:

Communicating data from one location to another requires some form of pathway or medium. These pathways, called communication channels, use two types of media: cable (twisted-pair wire, cable, and fiber-optic cable) and broadcast (microwave, satellite, radio, and infrared).

Types of Networks:

Network may be small or large based on it size, complexity and Distribution area. On the basis of its area of distribution, network is divided into three parts :

1. PAN(Personal Area Network)
2. LAN (Local Area Network)
3. MAN (Metropolitan Area Network)
4. WAN (Wide Area network)

1. Personal Area Network: A personal area network, or PAN, is a computer network organized around an individual person. This could be inside a small office or residence. Personal area networks can be constructed with cables or be wireless. It refers to the interconnection of information technology devices or gadgets (include laptop computers, PDAs, cellphones, printers) within the environment of an individual user (typically within 10 meters).

2. Local Area Network (LAN): A LAN is a network that is used for communicating among computer devices, usually within an office building or home. LAN’s enable the sharing of resources. Such as files or hardware devices that may be needed by multiple users. It Is limited in size, typically spanning a few hundred meters, and no more than a mile.

It Requires little wiring, typically a single cable connecting to each device. It has lower cost compared to MAN’s or WAN’s. LAN’s can be either wired or wireless. Twisted pair, coax or fiber optic cable can be used in wired LAN’s. It is suitable to bus, ring or star topology. In it generally coaxial Cable, twisted pair and optical fiber etc. transmission media is used.

3. Metropolitan Area Network (MAN): It is distributed to a city or large area. In it many LANs are connected. A MAN is optimized for a larger geographical area than a LAN, ranging from several blocks of buildings to entire cities. .A MAN might be owned and operated by a single organization, but it usually will be used by many individuals and organization. A MAN often acts as a high speed network to allow sharing of regional resources, A MAN typically covers an area of between 5 and 50 km diameter.

4. Wide Area Network (WAN): WAN covers a large geographic area such as country, continent or even whole of the world. WAN can contain multiple smaller networks, such as LANs or MANs. In this network telephone lines, satellite, microwave etc. media are used. These transmission media are linked with Router.

This PSEB 9th Class Computer Notes Chapter 7 E-Governance will help you in revision during exams.

PSEB 9th Class Computer Notes Chapter 7 E-Governance

“Governance” means The process of decision-making and the process by which decisions are implemented. Various factors are involved in governance. Government is one of the actors in governance. Other actors involved in governance vary depending on the level of government.

It’s not about making ‘correct’ decisions, but about the best possible process for making and implementing those decisions.

Main Characteristics of Good Governance:

1. Good governance is answerable to the community,
2. Good governance is transparent.
3. Good governance follows the rule of law.
4. Good governance is responsive.
5. Good governance is effective and efficient in implementing decisions and follows processes.
6. Good governance is participatory.

History and development of E-governance:

In India E-Governance originated during the seventies. The ICT was used to manage data related to elections, census, tax administration etc. After that, with the efforts of the National Informatics Center (NIC) all the district headquarters were connected during the eighties. From the early nineties, e-governance has used IT for wider sectoral applications with emphasis on reaching out to rural areas.

Earlier, a talk between a citizen and the Government takes place in a government office. But with the advancement of Information and Communication technologies, work culture of government offices has enhanced. Information and Communication Technologies has made it possible to locate service centers near to clients.

Such centers may consist of an unattended kiosk in the government agency, a service kiosk located close to the client outside the government agency, or the use of a personal computer at home or office.

In all the cases public traditionally look for information and services addressing his/her needs. In both cases quality and efficiency are of great importance. Therefore, the establishment of e-Govemance requires a good knowledge of the needs that exist in the society and that can be offered using ICT.

Due to widespread demand of E-govemance and exponentially increasing size of data, new technologies Hke Open source solutions and cloud computing need to be used in working of government. Today, electricity, water, phone and all kinds of bills can be paid over the internet. All these work is what government and citizens are using and doing. All ‘this dependents on internet and when citizens depends on government internet services all that come is E-Govemance.

E-governance:

Online working of a government or providing its services online to its citizens at their door step is known as E-Govemance. In other words, E-Govemance means online availability of government services.

E-Govemance has made the working of government more efficient andmore transparent to its citizens. Success or failure of any government depends on three things:

1. The way the government works.
2. Transparency in its working and information.
3. Communication to its citizen.

In E-Govemance, government use of internet technology to communicate and provide information to common peoples and businessman.

There are four pillars of E-Governance:

1. Connectivity: Connectivity is required to connect the people to the services of the government.
2. Knowledge: The knowledge here is referred to as IT knowledge.
3. Data Content: To share information over the internet, government possesses its database which should have the data content related to government services.
4. Capital: Capital is referred to money used by government to provide their services.

Objectives of E-Governance:

The two main objectives of e-governance are:
1. To satisfactorily fulfil the public’s needs and expectations by simplifying their interaction with various online services.
2. To facilitate a speedy, transparent, accountable, efficient and effective process for performing government administration activities.

E-Governance models:

These four models of e-governance are as:

1. Government to citizens (G2C)
2. Government to government (G2G)
3. Government to employees (G2E)
4. Government to businessman (G2B)

1. Government to citizens (G2C):

This model of e-govemance refers to the government services which are shared by citizens. In this model, citizens visit to the links of services that they want to use. This model strengthens the bond between government and its citizen. Type of services which are provided by this model includes:-

1. Payment of online bills such as electricity, water, telephone bills etc.
2. Online registration of applications.
3. Copies of land-record.
4. Online filling of complaints.
5. Availability” of any kind of online information.

2. Government to government (G2G):

This model refers to the services which are shared between the governments. These types of services or information are as:

1. Sharing of information between police department of various state.
2. Government document exchange which includes preparation, approval, distribution, and storage of ail governmental documents, is also done through e- governance.
3. Most of the finance and budget works are also done through e-governance.

3. Government to businessmen (G2B):

It is used by businessmen to communicate to the government. Type of services which are provided by this model includes:-

1. Collection of taxes.
2. Rejection and approval of patent is done by this model.
3. Payment of all kind of bills and penalty.
4. Sharing of all kind of information, rules and data.
5. Complaints or any kind of dissatisfaction can be shown by this.

4. Government to employees (G2E):

This model increases the transparency between government and its employee. Information that can be shared by this model:

1. All kind of data submission (attendance record, employee record etc.) from various government offices is done by this model.
2. Employee can file all kinds of complaints and dissatisfaction by this model.
3. All kind of rule- regulation and information for employees can be shared by this.
4. Employees can check their payment and working record.
5. Employees can register all kind of working forms online.

Areas of E-governance:

Today area of e-governance is very wide. E-Governance is implemented by government in almost every field.

I. E-Governance in urban areas:

1. Transportation

Services provided by e-governance in this area are:

1. Issue of learner licensees, Issue of driving licenses, Renewal of driving licenses etc.
2. To provide transport-related facilities online.
3. For online bookings, cancellation of seats, for enquiry about departure of buses, availability of seats and buses etc.
4. Issuance of Time Table of buses.
5. Provision of booking facility for Interstate transport.
6. Transportation Improvement Program.
7. Regional Transportation Plans.
8. Congestion Management Process.
9. Transportation Demand Management.

Various projects such as

• IRCTC (Indian Railway Catering and tourism Cooperation ltd.) Offers online rail ticket booking, and checking of ticket reservation status.
• HRTC (Himachal Road Transport Corporation project) is for online bookings, cancellation of seats, for enquiry about departure of buses, availability of seats and buses etc.

2. Online payment of bills and taxes

Services provided by e-govemance in this area are :

1. Online Transactions such as payment of license fees, university fees, etc.
2. Payment of Bill such as online payment of electricity and water bills,utility bills, to avail of trade licenses and transact on government matters at these facilities. ‘
3. Payment of taxes such as online payment of motor vehicle taxes, revenue taxes,
4. Payment of house EMIs.

Various Projects such as

• SAMP ARK by Chandigarh government.
• E-Suvidha by the government of Uttar Pradesh.
• E-SEVA (Electronic seva) by Andhra Pradesh.
• E-Mitra by the Government of Rajasthan

3. Information and public relation key services:

With these kinds of projects people can get any kind of information with just a single click are as under :
1. Information about vacancies, tenders and market rates etc.
2. Village e-mail etc.

Various projects such as
1. LokMitra by the government of Himachal Pradesh.

4. Municipal services

Services provided are as:

1. House Tax Assessment, Billing and Collection.
2. Maintaining records of Land & property. Certificates like Land sale Permission, Legal heir certificate.
3. Issue of Passport Verification Certificate.
4. Issue of Death and BirthCertificates.
5. Registration & Attorneys of properties such as computerization of the Document registration work at Sub Registrar Office.
6. Provide services such as issuance of certificates, issuance of orders in respect of Social Security Schemes such as old age pension, widow pension, freedom fighter pension etc.
7. Review and approval authority for site plans

Various projects such as

• SDO Suite by Assam government.
• Rural Digital Services.

5. Roads and traffic management

Services provided by this type of e-governance is :

1. Network of Roads & Bridges.
2. Road construction and their maintenance.
3. Traffic Management.

Safety, Accident and pollution control.arious projects such as
1. RSPCB (Rajasthan State Pollution Control Board) by Govt, of Rajasthan.

II. Areas of e-governance in rural areas

In rural areas e-govemance has its very powerful impact.
1. Agriculture:
Following are the projects used in Agriculture.
1. AGMARKNET: It is a project approved by Department of Marketing & Inspection (DMI), Ministry of Agriculture, and the Government of India.
2. SEEDNET: It is a SEED informatics network under ministry of Agriculture, Government of India.

2. Local information:

For local information such as personal information, prices of seeds, fertilizers, loan rates etc.
Various projects such as
1. E-Aadhar
2. E-JanSampark

3. Disaster management:

To deal with these disasters, much state government has started e-governance service for this.
Project in this area are:
1. Chetana by the state of Bihar is a Disaster management system which has been started to deal with natural disasters such as flood and earthquake.

4. Land record management:

By facilitating e-governance service in this area, millions of land records can be maintain in a very short time span.
Projects in this area are :

1. Land Records Management System State Government of Punjab.
2. Devbhoomi State Government of Uttarakhand.
3. Bhu-Lekh UP State Government of Uttar Pradesh.
4. E-Dhara State Government of Gujarat.

5. Panchayat:

Services provided by e-governance in this area are:

1. Issue of Birth/Death certificate.
2. Application for inclusion of name in Voter list.
3. Conducting various welfare schemes for the poor and needy sections of the society.
4. Preparing district wise planning, implementing those plan, and review for success.
5. To provide wage employment to the needy from amongst the poorest section of the rural society.
6. Rural water supply and sanitation.

Various projects:

1. E-GramViswa Gram Project by Gujarat.

III. E-governance in Health

Service provided by these projects are as:

1. Availability of medicines.
2. Special health camps.
3. Facilities at Anganwadi centers.

Various projects are:

• Hospital OPD Appointment:
• Online Vaccination Appointment for International Traveler:

IV. E-governance in Education

Providing basic education (elementary, primary, and secondary) to children.

1. Providing computer education to children.
2. Results for 10th& 12th classes.
3. Information on eligibility for “Distribution of books” scheme.

Various projects are:
Online Scholarship Management System such as Ashirwad portal by Punjab Government.

This PSEB 9th Class Computer Notes Chapter 6 Internet Applications will help you in revision during exams.

PSEB 9th Class Computer Notes Chapter 6 Internet Applications

Internet allows us to use many services like Internet Banking, Online Shopping, Online Ticket Booking, Online Bill Payment, emaihetc.

Internet provides concept of electronic commerce that allows the business deals to be conducted on electronic systems

Email:

Email, short for “electronic mail,” It is one of the most widely used features of the Internet, along with the web. It allows us to send and receive messages to and from anyone with an email address, anywhere in the world.

Gmail:

‘Google Mail’ or ‘Gmail’ is a free email service provided by Google. You can send and receive emails, block spam, create an address book, and perform other basic email tasks.

Creating new account:

In this, we’ll study about how to get started with email by creating an account in Gmail.
Follow these step-by-step instructions to create a Gmail account
1. Open up our internet browser.
2. Type address. WWW.gmail.com

3. Create Google Account
The ‘choose our username’ is the unique email address that we wish to use, which will be placed before ‘@gmail.com’.
1. Type password
2. Then fill your birth date (Month, Day, Year)

3. Fill your Gender (Male/Female)
4. Mobile phone number and any other e-mail address(if exist)
Once we have completed this page fully, clicking Next Step will take us to the next Page.
Click “Continue to Gmail” to go to our inbox and get started.

Captcha Code:

A CAPTCHA is a type of test used in computing to determine whether or not the user is human.

A CAPTCHA is a program that protects websites by generating and grading tests that humans can pass but current computer programs cannot.

How to send and receive E-mail?

To send an email, click “Compose Mail” located above the folder list. An entry form appears in the Gmail interface.

The recipients: In the “To:” box, type the address of the person we want to write to.
To view the “Cc:” tab click “Add Cc”. Cc means “carbon copy”, type here the addresses of people who are not the main recipients of the message, but we still want to send a copy to.

To view the “Bcc:” tab click “Add Bcc”. Bcc stands for “Blind carbon copy “, type here the addresses of people we want to send a copy of the mail to, without the other recipients knowing.

The subject

In “Subject:”, enter the subject of the email.
When we finish typing our mail, click the “Send” button to send it immediately or on the “Save” button to save as draft.

Attach file(s)with email message:

In the new message window, click the paperclip icon to add an attachment. Find and click on the folder or files we wish to attach, then click “Open” and we should see the attachment added to our message.

Google Apps:

Google Apps is a suite of Web-based applications from Google that includes e-mail, calendar, word processing, spreadsheet and presentations.

1. Google Calendar

Google Calendar is a time-management web application and mobile app created by Google. Google Calendar allows multiple calendars to be created and shown in the same view. Each can be shared, either read-only or with full edit control, and either with specified people or with everyone.

2. Google Maps

Google Maps is a desktop web mapping service developed by Google. It offers satellite imagery, street maps, 360° panoramic views of streets (Street View), real-‘time traffic conditions (Google Traffic), and route planning for traveling by foot, car, bicycle (in beta), or public transportation.

3. Translate

Google Translate is a free multilingual statistical machine translation provided by Google to translate text, speech, images, or real-time video from one language into another.

4. Google +

Google+ (Google Plus) is Google’s attempt at social networking. The Google+ service that delivers functionality and many features similar to those of Facebook.

5. Google Docs

Google Docs is an online word processor that lets you create and format text documents and collaborate with other people in real-time.

6. Google Sheets

Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and simultaneously work with other people.

7. Google Slides

Google Slides is an online presentations app that allows you to show off your work in a visual way.

8. Play Store

Google Play is Google’s online store for purchasing and downloading apps, music, books, movies and similar content for use on Android-powered smartphones, tablets, Google TV and similar devices.

Google Drive

Google Drive is a service offered by Google that allows us to store and share files online.

Benefits of Google Drive:

1. Google Drive lets us send large files directly from our Gmail account.
2. Google Drive allows us to access our files remotely.
3. Google Drive has its own mobile application which gives us access to our files on our iPhone or smartphone.
4. Google Drive allows us to find content easily with a keyword search.
5. Google Drive is equipped with an OCR (optical character recognition) function, which allows us to search for words or expressions in scanned documents.
6. Google Drive allows users to open various types of files.
7. All the facilities described above are free.

How to share file(s)?

1. Open Drive, or a file or folder we want to share.
2. Open the sharing box:

• While we have a file open: Click Share in the top-right comer.
• While we have a folder open: Click the share icon in the top-right.
• From our file list in Drive: Select the name of a file or folder and click the share icon at the top.

3. Under “People” in the sharing box, type the email addresses of the people or Google Groups we want to share with.

4. Choose the type of access we want to give -these users by clicking the dropdown arrow to the right of the text box:

• Can edit: Users can edit the file or folder and share it with others.
• Can comment: Users can view and add comments to the file, but can’t edit it.
• Can view: Users can see the file or folder but can’t edit or comment on it

5. Click Done. The users will receive an email letting them know we’ve shared the file or folder with them.
6. If we want to share multiple files at once, add the files to a folder in Drive and then share the entire folder with the people we want to see the files.

How to download software?

The same basic steps apply to most downloads:

1. Click the link.
2. Choose open or save.
3. Confirm the download.
4. rim or open the download.

Internet in Media

TV, radio and the Internet used to be completely separate things, but that’s no longer true with today’s technology. We can now watch TV shows on our computer, connect to the Internet on many.

1. On Line Newspaper:
Online newspaper is the online version of a newspaper, either as a stand-alone publication or as the online version of a printed periodical.

2. Online TV channels, Radio, Live programs(Streaming Media)
Online radio is the distribution of audio broadcasts over the Internet. There are thousands of Internet radio stations that can be streamed to a software media player in a computer, mobile device, stand-alone Internet radio, media hub or media server.

What is Cloud?

The term ‘Cloud’ refers to a Network or Internet. In other words, we can say that Cloud is something, which is present at remote location.
Applications such as e-mail, web conferencing, customer relationship management (CRM) execute on cloud.
Cloud networking refers to manipulating, configuring, and accessing the hardware and software resources remotely. It offers online data storage, infrastructure, and application.

Cloud Printing:

Cloud Printing enable users to print documents and other materials on any device associated with the cloud (network). Users create content with any softwarefool they want and transfer the file to a cloud printing service provider via whatever device they choose, which then routes the file to a cloud-attached printer at a location selected by the user.

Internet Security:

The Internet is indeed private and secure, but there are a number of serious security risks.

1. Virus/Anti-virus:
A computer virus is a computer program that replicates itself into other computer programs and can cause damage to a computer’s software, hardware or data.

2. Spyware:
Spyware is a program installed on our computer that sends information about us and how we use our computer to a third party, typically without we being aware this is happening. Spyware often enters our system when we install some type of free software from an untrusted source.

3. Trojan:
A Trojan horse, often shortened to Trojan, is a type of malware designed to provide unauthorized, remote access to a user’s computer. Trojan horses do not have the ability to replicate themselves like viruses; however, they can lead to viruses being installed on a machine since they allow the computer to be controlled by the Trojan creator.

4. Phishing Scams:
Phishing is an e-mail fraud method in which the wrongdoer sends out legitimate-‘looking email in an attempt to gather personal and financial information from recipients.

5. Digital Signature:
Digital Signature is a digital code which is attached to an electronically transmitted document to verify its contents and the sender’s identity.

This PSEB 9th Class Computer Notes Chapter 2 MS Excel Part-II will help you in revision during exams.

PSEB 9th Class Computer Notes Chapter 2 MS Excel Part-II

A chart is a tool that is used to communicate data graphically. A chart can allow knowing the meaning behind data.

Charts:

Excel has various types of charts, so we can choose one that most effectively represents our data.

Types of Chart:

1. Pie Chart
2. Column Chart
3. Line Chart
4. Bar Chart
5. Area Chart
6. Scatter Chart.

Create a Chart

To create a line chart, the steps are as follows:
1. Type the data in our excel worksheet.

2. Select the range.

3. On the Insert tab, in the Charts group, choose Line, and select Line with Markers.

Change a chart type

We can easily change a chart type at any time. Following are the steps to change a chart type:
1. Select the chart.

2. On the Insert tab, in the Charts group, choose Column, and select Clustered Column.

Switch Row/Column

1. Select the chart. Chart Tools contextual tab is activated.

2. On the Design tab, click Switch Row/ Column.

Add chart Title

1. Select the chart.
2. On the Layout tab, click Chart Title, Above Chart.

3. We will see a caption (Chart Title) above our chart. Enter our desired title.

Elements of a Chart

1. Chart area: A chart area contains everything inside the chart window, including all parts of the chart.
2. Data marker: A data marker is a symbol on the chart that represents a single value in the worksheet. A data marker can be a bar in a bar chart, a pie in a pie chart, or a line on a line chart.
3. Data series: It is a group of related values such as all the values in a single row in the chart.
4. Axis: It is a line that is used as a major reference for plotting data in a chart.
5. Tick mark: It is a small line intersecting an axis. A tick mark indicates a category, scale, or chart data series.
6. Plot area: It is the area where our data is plotted and it includes the axes and all markers that represent data points.
7. Gridlines: These are the optional lines extending from the tick marks across the plot area.
8. Chart text: It is a label8- or title that we add to our chart. Attached text is a title or label that is linked to an axis such as the Chart Title.
9. Legend: It is a key that identifies patterns, colors, or symbols associated with the markers of a chart data series. The legend shows the data series name corresponding to each data marker

Equations and Symbols

How to insert equations, symbols and special characters in excel:

Excel makes it easy to enter symbols, such as foreign currency marks, as well as special characters, like trademark and copyright symbols, into cells. These symbols are available in the Symbol dialog box.

1. Click the Insert tab and then click the Symbol button in the Symbols group. The Symbol dialog box appears.

2. Select the desired symbol on the Symbols tab; or click the Special Characters tab and select the desired character.
3. Click Insert to insert the symbol or character.
4. Click close when we’re done adding symbols and special characters. The inserted symbols or characters appear in the worksheet.
5. Press Enter to complete the cell entry.

Pivot Table:

Insert Pivot Table

The data in a worksheet can be easily managed by using PivotTables. We can summarize the data. Pivot Table allows us to manipulate it in various ways. PivotTables are very helpful tool when we have to deal with large and complex spreadsheets.

A PivotTable is very helpful in doing these calculations. We can do calculations and summarize the data in a way that’s not only easy to read but also easy to manipulate.

How to create a PivotTable:

1. Select the table or cells – including column headers – containing the data we want to use.
2. From the Insert tab, click the PivotTable command.

3. The Create PivotTable dialog box will appear. Click OK.

Add fields to the Pivot Table:

1. Before using Pivot Table, first of all we’ll need to decide which fields to add to the PivotTable. Each field is a column header from the source data.
2. In the Field List, place a check mark next to each field we want to add.

3. The selected fields will be added to one of the four areas below the Field List.

4. The PivotTable now shows the change.

Data Tools:

Data Tools are simply tools which make it easy to manipulate data. Some of them are used to save our time by extracting or joining data and others perform complex calculations on data.

Convert Text to Columns:

Steps are as follows:
1. Type the data in our worksheet as:

2. Select the range with full names.

3. On the Data tab, click Text to Columns.

4. Choose Delimited and click Next.

5. Clear all the check boxes under Delimiters except for the Comma and Space check box.

6. Click Finish.

Data Validation:

Data validation is a powerful feature that is used to set up certain rules to dictate what can be entered into a cell.

How to Create Data Validation Rule:

To create a data validation rule, the steps are as follows:
1. Type the data in our excel worksheet.
2. Select cell D2.
3. On the Data tab, click Data Validation.

1. In the Allow list, click Whole number.

2. In the Data list, click between.
3. Enter the Minimum and Maximum values.
Input Message: Input messages appear when the user selects the cell and tell the user what to enter.

On the Input Message tabas below do the following:
1. Check ‘Show input message when cell is selected’.

2. Enter a title.
3. Enter an input message.

Error Alert:

If users ignore the input message and enter a number that is not valid, we can show them an error alert.
On the Error Alert tab do the following:
1. Check ‘Show error alert after invalid data is entered1.
2. Enter a title.
3. Enter an error message.

4. Click OK.

Data Validation Result:

To check our Data Validation result follows the steps as below:
1. Select cell C2.

2. Try to enter a number higher than 10.

What-If Analysis:

What-If Analysis in Excel allows us to try out different values (scenarios) for formulas. In MS Excel a scenario is a set of values that saves and can substitute automatically on our worksheet.

1. On the Data tab, click What-If Analysis and select Scenario Manager from the list.

2. The Scenario Manager Dialog box appears.

3. Type a name, select cell and click on OK.

4. Enter the corresponding value and click on OK again.

5. Next, add 4 other scenarios.

Scenario Summary:

After creating your required Scenarios, to easily compare the results of these scenarios following are the steps below:
1. Click the Summary button in the Scenario Manager.

2. Next, select cell for the result cell and click on OK.

Goal Seek?

The goal seek function is a part of what-if analysis tool set. It allows a user to use the desired result of a formula to find the possible input value necessary to achieve that result.

3. Type a name, select cell and click on OK.

4. Enter the corresponding value and click on OK again.

5. Next, add 4 other scenarios.

Scenario Summary: After creating your required Scenarios, to easily compare the results of these scenarios following are the steps below:
1. Click the Summary button in the Scenario Manager.

2. Next, select cell for the result cell and click on OK.

Goal Seek?
The goal seek function is a part of what-if analysis tool set. It allows a user to use the desired result of a formula to find the possible input value necessary to achieve that result.

Protection:

In simple words Protection means to keep our stuff safe from misuse from an authorised person. In Excel we can protect our workbook/worksheet.

Protect Worksheet

Steps to Protect Worksheet:
1. Right click a worksheet tab

2. Click Protect Sheet.

Protect Workbook

A workbook can be protected easily as we have protected a worksheet. A workbook can be protected such as:
Structure: If we protect the workbook structure, users cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore.
Windows: If we protect the workbook windows, we cannot move, change the size and close windows anymore.

1. Open a workbook.
2. On the Review tab, click Protect Workbook.

3. Check Windows enter a password and click OK.

4. Re-enter the password and click on OK.

View Tab

Split

In Excel we can split the worksheet window into separate panes and scroll the worksheet in each pane so that we can easily compare data from two separate worksheet locations. We can make the panes in a workbook window disappear by double-clicking anywhere on the split bar that divides the window.
1. Click the split box above the vertical scroll bar.
2. Notice the two vertical scroll bars.
3. To remove the split, double click the horizontal split bar that divides the panes (or drag it up).

Freeze

Freeze option is very useful in some cases when we have a long table and want to see all. We need to scroll it while looking all the data. We will see that the table headings are also scrolled during scrolling, so it becomes difficult to understand the meaning of data without having its heading name hidden.

Freeze Top Row: To freeze the top row, execute the following steps.
1. On view tab, click Freeze Panes and then Freeze

2. Scroll down to the rest of the worksheet.

How to Unfreeze Panes of your worksheet

To unlock all rows and columns, execute the following steps.
1. On the View tab, click Freeze Panes, Unfreeze Panes.

How to Freeze Panes of a Worksheet

To freeze panes, execute the following steps.
1. Select row.
2. On the View tab, click Freeze Panes, Freeze Panes.

3. Scroll down to the rest of the worksheet.

Hide/Unhide Columns, Rows and Sheets:

Hiding Rows:

In desired spreadsheet select the rows (for multiple selection hold Ctrl key and keep selecting) we want to hide and navigate to Home tab.
From Cells group, click Format button. Now from Hide & Unhide options, click Hide Rows.
Upon click it will automatically hide the selected rows.

Hiding Columns:

For hiding the columns in specific sheet, following are the steps:
1. Select the columns we want to handle.
2. Now click on Format button in Cells group. Now Click on Hide & Unhide options then click Hide Columns.

How to Hide Worksheets

Following are the steps to do so:
1. Select the sheet which we want to hide.
2. Now Click Hide Sheet from Hide & Unhide options from Cell group in Home Tab.
3. Click on Hinde Sheet Option from Hide and Unhide.

Macro:

A macro is a series of commands that is grouped together so that we can run whenever we need to perform the specific task. We can use macros in Excel to save time by automating tasks that we perform frequently.

The easiest method for creating many macros is to use macro recorder. When we record a macro Excel stores the information about each step you take as you perform a series of commands. We then run the macro to repeat or playback the set of commands.

The macro recorder records every action we complete. So before we start the process of recording it is very important to plan macro- that what steps we need to record. To display the Developer tab, follow these steps:
1. Click the File tab and then click Options. The Excel Options dialog box
appears.
2. Click Customize Ribbon in the left pane, and then select the Developer check box under Main Tabs on the right side of the dialog box.

3. Click OK. The Developer tab appears in the Ribbon.

How to Record a macro:

Follow these steps to record a macro:
1. Choose Record Macro in the Code group of the Developer tab. The Record Macro dialog box appears.
2. Type a name for the macro in the Macro Name text box.

3. Assign a Shortcut Key.
4. From the Store Macro In drop-down list, select where we want to store the macro:

• This Workbook: Save the macro in the current workbook file.
• New Workbook: Create macros that we can run in any new workbooks created during the current Excel session.
• Personal Macro Workbook: Choose this-option if you want the macro to be available whenever we use Excel, regardless of which worksheet we’re using.
• Type a description of the macro in the Description text box.
• Click OK. The Record Macro option on the Developer tab changes to Stop Recording.
• Perform the actions you want to record.
• Choose Stop recording in the Code group of the Developer tab.
• The macro recorder stops recording keystrokes and the macro is complete.

This PSEB 9th Class Computer Notes Chapter 5 Introduction to MS-Access will help you in revision during exams.

PSEB 9th Class Computer Notes Chapter 5 Introduction to MS-Access

Data has become an important part of human life. It has increased the need of data management. This need has given birth to various software. MS Access is one of the most common software in this category.

MS-Access:

Access is a Relational Database Management System (RDBMS). It is used for database creation and management. MS-Access Allow user to perform basic tasks such as opening and closing database, Creating tables, Forms, queries and Reports. If we want to understand Access, Firstly we must have to understand databases.

It is part of the MS Office software suite. It is used in millions of corporate firms across the globe and in homes also.

MS Access is used to store and retrieve large amounts of data. It can be used for something simple such as keeping a record of your books collection or for something larger such as invoicing/ stock management.

Relational Database:

Relational database was proposed by Edgar Codd around 1969. It has since become the dominant database model for commercial applications.

A relational database organizes data in tables. A table is made up of rows and columns. A row is also called a record. A column is also called a field.

MS-ACCESS is a relational database management system. Relational databases allow you to organize your data into tables; each table focuses on a specific topic; the various tables can then be linked to each other for inquiry and reporting purposes.

Guidelines to design a Database:

1. Identify all the fields needed by you to produce the required information
2. Organize each piece of data into its smallest useful part to make the design perfect.
3. Make group related fields into tables
4. Determine each table’s primary key which will uniquely identified.
5. You will have to Include a common field in related tables.

Some Technical Words of Access:

Access arranges and divided database as under:

1. Database file: The database file is the main file of database which consists the whole data of the document.
2. Table: A table is the basic element of a Database and contains the data entered by users. Each row (or record) contains information about a particular item.
3. The record is made up of several fields; each field contains one piece of information relating to the item.
4. Fields: A field is an individual set of data items that are of the same type.
5. Data Types: Databases consist of tables, tables consist of fields and fields are of a certain data type.

Components of MS Access:

1. Table: Tables are the data storage facilities in MS Acfcess. Each table contains rows called records and columns called fields. A record is a collection of facts about a particular person or an organization. Each record in a table should be unique.
2. Queries: A query that copies or changes data. Queries include append, delete, make-table, and update queries. A query that asks a question about the data stored in your tables and returns a result set in the form of a datasheet, without changing the data.
3. Forms: Forms provides us friendly environment to view the data in which it shows a single record at a time.
4. Reports: Reports provide a means of organizing and summarizing data. A report can be a simple list, a student’s report or a school report.
5. Macros: Macro is an automatic action that should be performed to an object of the data. It allow users to their work automatically.
6. Modules: A module is collection of procedure statement and declaration which are stores as unit. Module are verv similar to macros.
7. Database objects: Databases in Access 2010 are composed of four objects: tables, queries, forms, and reports.

Data Types:

In access many types of data types can be used the data type is decided before creating a table. We know there are different data types of table. Some of the important data types of access are given below:

Data types	Size/Format	Storage Capacity	Functions
Text	Up to 255 characters	Text – including numeric text (eg phone numbers)	Text consists of digits/ numbers, letters or their combination. It can have maximum of 255 letters.
Number	Long Integer Integer Single and double bytes	Whole numbers	Numbers been used only from the prescribed size which we will declare in document.
Data types	General	Both date & time	It is used for date and time. The data can vary from 100 to 9999. it is 8 byte long
Yes/no	Yes/No True/False On/Off	N.A	For data with only 2 possible values. It is used for logical values.
Currency	Currency Scientific, percentage	Up to 15 figures	It can also be use in mathematics or scientific functions.
Auto Number	N.A	Automatic counter- incremented by 1 for each record	It is used in all numeric programs it automatically give increment to a number.
Memo	Up to 65535 characters	Longer pieces of text	Memo is used in where we have to enter a longer text
OLE Object video	N.A	For pictures, sound, videos, word/excel, documents or any other docs.	It is been used to insert picture, sound, videos, word/excel, documents
Hyperlink	N.A	N.A	It is used For links to the WWW or e-mail
Calculated	N.A	N.A	This data type allow you to create a field that is based on a calculation of other fields in the same table

Advantages of Access:

1. Convenient storage capacity: A Microsoft Access database can hold up to 2 GB of data. *
2. Easy installation and work: Access gives data managers a fully functional, relational database management system.
3. Easy to participate: Access works well with many of the developing software programs based in Windows like Microsoft SQL Server and non-Microsoft products like Oracle and Sybase.
4. Importing data: Microsoft Access allow user to import their important data.
5. Multi-user support: More About ten users in a network can use an Access application.
6. Popular Rdbms: Microsoft Access is the most popular desktop Relational database system in the world.
7. Saves your money: Microsoft Access is more economical than other larger systems; offering the same functions and usage.
8. Secure Database: MS access is secure database system information is secure which you saved on it.

Starting access:

To start access 2010 from the start menu:
Click the start button, click all programs, click Microsoft office, and then click Microsoft access 2010. The new page of the backstage view opens, displaying thumbnails of the available templates and template categories.

Another shortcut way to open access is Press windows kev with R it will open run command window on Run command type MS access is blank box.

After the open of MS access you have to click on the blank database available Under templates.

Working with Tables:

A table is a database object that vou define and use to store data update DATA. A table consists of records and fields. Every record contains data about one instance of the subject.

Creating and Modifying tables:

When you create a new table, you have complete control over the number of fields, the names of the fields, and what sort of data they can store. You can create a new table in the either datasheet view or design view.

Creating tables in datasheet view

To create a table in datasheet view:

On the create tab, in the tables group, click the table button. A new blank table opens in the object window in datasheet view.

Adding fields by entering data:

Whenever you add a new column to the datasheet, a new field is defined in the table.

1. Click in the first cell in the click to add COLUMN, ENTER the first item of data for the new record, and then press the tab or enter key to move the first cell in the column to the right.
2. Access AUTOMATICALLY ASSIGNS the value 1 to the id field.
3. WHEN THE record has been changed, but has not yet been saved.
4. Click the pencil icon in the row selector. This saves the first record with the value 1 assigned to the id field; subsequent records will be numbered sequentially.
5. Continue entering items of data in consecutive cells, and pressing the tab or enter key.
6. When you finish entering all the data for the first record, click anywhere in the row below to save the record.
7. After entering so many records as per your requirement you have to save the table

Creating Tables in design view:

In Design view, the Object window consists of two panes. The field Entry pane, located at the top of the window, is used to enter each field’s name, data type, and description. The field properties pane, located at the bottom of the window, is used to specify the field’s properties. The properties available in the Field properties pane depend on the data type assigned.

To create a table in Design view:

On the create tab, in the Table Design button. A New, blank table opens in the object window in Design view.

1. In the field name column, type a name for the first field. Field names can be up to 64 characters long. They can include any combination of letters, numbers, spaces, and brackets etc.
2. In the data type column click the down arrow and select a data type from the list).
3. In the description column, type a description for the field.
4. Repeat steps 2 through 4 to add additional fields to the table. After entering the all fields save the table.

Setting a primary key:

A primary key consists of one or more fields that uniquely identify each record in the table there are several advantages to setting a primary key.

To set a primary key follow these steps:
1. Click the row selector of the field you want to designate as the primary key.

2. In the design tab, in the tools group, click the primary key button. A key icon appears to the left of the field that you specify as the primary key.

Saving tables:

To save a table for the first time:
1. On the quick access toolbar, click the save button. The save as dialog box opens
2. In the table name box, type a name for the table.

Click the ok button. The table appears in the tables list in the navigation pane.

Closing database
To close a database:
Click the file tab, and then click close database.

Exiting access
To exit access 2010:
1. Click the file tab, and then click exit. Or, click the close button in the upper- right corner of the program window.
2. Another option is to exit Access is Press ALT+F4 key together. With this option you will exit from access in very easy way

Forms:

Forms are used for entering, modifying, and viewing records. The reason forms are used so often is that they’re an easy way to guide people into entering data correctly.

Creating forms:

It is always very convenient to work in forms. It is more comfortable easier and popular to enter data by forms that by datasheet view. Forms can be prepared by following two methods.

Create a form to display your data
1. To create a quick screen in MS Access 2010 simply go to the navigation pane and click to highlight the table you wish to base the form on.
2. Now click on the create tab.

3. In the forms section click on the button named ‘Form’.

4. MS Access creates a nice simple form. Click on any of the text boxes to position the cursor and edit the data.
At the bottom you have navigation buttons to move you from record to each record

Sorting:

1. Result could be sorted by Name or by the marks of the students who were appear in exam
2. Students could be sorted by name or by the roll no.
3. Students could be sorted by class.
You can sort both text and numbers in two ways: in ascending order and descending order. Ascending means going up, so an ascending sort will arrange numbers from smallest to largest and text from A to Z.

Descending means going down, or largest to smallest for numbers and Z to A for text. The default ID number sort that appears in your tables is an ascending sort, which is why the lowest ID numbers appear first.

Steps to sort student table are as follows:
1. Select a field in the cell you want to sort by. In student table, we will sort by student name.
2. Click the Home tab on the Ribbon, and locate the Sort & Filter group.
3. Sort the field by selecting the Ascending or Descending command.
(a) Select Ascending to sort text A to Z or to sort numbers from smallest to largest.
(b) Select Descending to sort text Z to A or to sort numbers from largest to smallest.

The table will now be sorted by the selected field.
To save the new sort, click the Save command on the Quick Access toolbar.

Data Filters:

Filters is the concept in MS-Access which allow you to view only the data you want to see. The filter then searches all of the records in the table, finds the ones that meet your search criteria, and temporarily hides the other data.

Filters are useful because they allow you to look upon on specific records without any distraction by the uninterested data. Viewing this data with a filter would be far more convenient than searching for it in a large table.

Follow these steps to apply filter:
To create a filter
1. Click the drop-down arrow next to the field you want to filter by.
(A drop-down menu with a checklist will appear. Only checked items will be included in the filtered results. Use the following options to determine which items will be included in your filter)
1. Select and deselect items one at a time by clicking their check boxes.
Here, we will deselect all of the options except for Class .
2. Click Select All to include every item in the filter. Clicking Select All a second time will deselect all items.

2. Click Blank to set the filter to find only the records with no data in the selected field.
Click OK. The filter will be applied.

Reports:

Reports allow you to print assembled data in a custom layout. You can create reports based on tables and/ or queries. There are several methods for creating a report. We will focus on the Reports wizard.

To create a report:
(i) Click on the Create tab and then select Report Wizard from the Reports group.

1. Click on the down arrow beside the Tables/Queries selection window and choose the table or query you’re basing your report on.

2. Add fields – (All the fields from your selected tables/ queries appear in the Available Fields: window.)
1. To add fields to the Selected Fields window, one-at-a-to move all available fields into the Selected Fields window at once.
2. To remove individual fields from Selected Fields, click on each field and press to remove all fields, press
3. When done, click Next.

3. When done, click Next.
(You can select a sort order for up to four fields. Click on the down arrow to select a field and then choose ascending or descending order.)

4. When done, click Next and select layout options.

5. Click Next and add title to the form.


6. Click finish to finish the repeat.

This PSEB 12th Class History Notes Chapter 4 Guru Nanak Dev Ji’s Life and His Teachings will help you in revision during exams.

PSEB 12th Class History Notes Chapter 4 Guru Nanak Dev Ji’s Life and His Teachings

Early Career of Guru Nanak Dev Ji:

• Guru Nanak Dev Ji was born on 15th April, 1469 A.D. at Rai Bhoi Ki Talwandi.
• The name of his father was Mehta Kalu Ji and the name of his mother was Tripta Ji.
• Guru Nanak Dev Ji was quite serious and thoughtful by nature since his childhood.
• Guru Sahib’s teachers were surprised to see his spiritual knowledge.
• Guru Nanak Dev Ji’s father tried to keep him busy in work through various occupations but Guru Ji showed no interest in them.
• At the age of 14 years, he was married to Sulakhni Ji, the daughter of Mool Chand, a resident of Batala.
• At the age of 20 years, he was employed at the Modikhana (foodgrain store) at the Sultanpur Lodhi.
• While at Sultanpur Lodhi, Guru Nanak attained enlightenment while bathing in the Bein rivulet.
• He was 30 years old at that time.

Udasis of Guru Nanak Dev Ji:

• After attaining enlightenment in 1499 A.D., Guru Nanak Dev Ji set out on long travels (Udasis) in India and in foreign countries.
• He spent 21 years in these travels or Udasis.
• The main objective of the Udasis of Guru Nanak Dev Ji was to remove the ignorance of the people and to give the message of the unity of Godhead and universal brotherhood of mankind.
• Guru Nanak Dev Ji started his first Udasi in 1499 A.D. with Bhai Mardana.
• Guru Nanak Dev Ji travelled Saidpur, Talumba, Kurukshetra, Panipat, Delhi, Haridwar, Gorakhmata, Banaras, Kamrup, Gaya, Jagannath Puri, Lanka and Pakpattan.
• Guru Nanak Dev Ji started his second Udasi at the end of 1513 A.D.
• In this Udasi Guru Ji travelled the Hilly states, Kailash Parbat, Ladakh, Kashmir, Hasan Abdal, and Sialkot.
• During his third Udasi, which was started at the end of 1517 A.D., Guru Nanak Dev Ji travelled to Multan, Mecca, Madina, Baghdad, Kabul, Peshawar, and Saidpur.
• Thousands of people became his followers, being greatly impressed by his personality and his teachings.

Teachings of Guru Nanak Dev Ji:

• Guru Nanak Dev Ji’s teachings were simple but impressive.
• Guru Nanak Dev Ji believed in one God only.
• According to Guru Nanak Dev Ji, God is the Greater, Sustainer and Destroyer of the world.
• He is without form and omnipotent.
• According to him, Maya is the biggest obstacle in the way of man to attaining salvation.
• Haumai (Ego) is the root cause of man’s all troubles.
• Guru Ji vehemently opposed casteism and hollow customs and traditions.
• Guru Ji raised their voice to uplift the status of women in society.
• Guru Ji emphasized the recitation of Nam.
• He regarded the Guru as the most important mean to reach God.

Immessed in Eternal Light:

• Guru Nanak Dev Ji immessed in Eternal Light on 22 September 1539 A.D.
• Before his immersion in Eternal Light, he nominated Bhai Lehna Ji as his successor.