Lesson Plan-2014

(1)

INDUSTRIAL TRAINING INSTITUTE LESSON PLAN

Name : Unit/Block No.: Week No.: 1 Lesson no. : 1

Trade : COPA Date: Time :

Title: History of Computers & Generation Of Computer Objectives:

 Blasé Pascal and his Mechanical calculator  Charles Babb age: differential engine  First Generation

 Second Generation  Third Generation  Four Generation

Aids: Chalk, Duster, Black Board, Pointer. Preparation:

Review: Abacas seems to with the earliest calculation machine, which was developed by Chinese 3000 years ago. Until 1950 the major contribution were from the university and research institution. Almost all the letter development due to the computer manufacturing.

Introduction: The first mechanical calculation machine was made in 1642 by the great French matumatwan and philosopher Blasé Pascal.

From the early 1950's computer started appearing in quick succession, each claiming an

improvement over the other. They represented improvement in speed memory (storage) systems input and output devices and programming technique They also showed a cont. Reduction in physical size and cost.

Motivation:

 Think how ancestors are used to calculate and manipulate numbers.  The very basic need of coming revolution in the rapid developing world.  The basic fundamental qualification for each and every field.

Presentation:

Topics Information Points Spot Hints

Pascal's Mechanical calculator

Pascal machine could perform additions. It was later improved upper by leaning, a German mathematical and whose machine could perform multiplication and division as well.

Charles Babbage, an English mathematical developed mechanical calculating devices called difference engine for automatic compo ration of mathematical tables around 1830. Babbage was also involved in the design of another calculating machine which could perform many general function in an automatically after much afford, he corralled a machine called analytical engine. This machine had a memory device and arithmetical device, a punch card input system and an extended memory store. Thus Babbage analytical engine had many of the same fundamental jealous as the modern computers.

Look back on history, we had less of any counting devices known to us today except we see graphite slates having abacus ring balls pierced in steel rods as if it is some playing object for babies but can’t signify the importance of its.

(2)

Computer developed after ENIAC have been classified into the following for generation First Generation –1946 to 1955

Second Generation ---1956 to 1965 Third Generation - 1966 to 1975 Four Generation - 1976 to present

First Generation The 1st_{Generation computer those that in vacuum} tubes are used. Magnetic tap drive and magnetic core memory were developed during this period.

From 1946 each decade has contributed one generation of computer. Second

Generation

The 2nd_{generation computers were market by the} use of the Solid State device called the transistor in the place of vacuum tube. All in more reliable than earlier counter parts.

Third Generation Along with the third generation computers never and faster equipments where introduce for handling storage and input output continued efforts towards miniaturization led to the development of the large scale in integration (LSI) technology.

Forth Generation The latest child of the computer family that uses LSI chips has been named the 4th_Generation computers, which marks increased user computers integration and speed.

Fifth Generation Japan and many other country are working on systems What are know as export system which will considerably improve the main machine instruction.

Question:

 List the special features of Babbage Analytical engine.  How do you they compare with the modern computers?  Classify the generation of computers.

What is the main difference between different generation computers?

Summary: Babbage in conceded one of the great performs in the trade of compaction for this foresight to design the analytical engine.

The developments of the computers are closely associated with the development in mechanical technology, particularly the semi conductor technology.

Application: Now days there are the most widely used machine, education, Business, Communication, Personal, and Fun.

Such system would integrate the advantage in the both hard were and soft were technology and would facility computer added problems slowing with the help of organized information many specialize area.

Reference: Early one chemical compute.  IBM PC CLONES – B Gonvindarajalu.

 INTRODUCTION TO MICROPROCESSORS – R. Gaonkar. Next Lesson: Function of Computer.

(3)

Title: Function Of Computer. ( Input, Output, ALU, Control Unit, Memory) & Application of Computer Objectives:  Introduction  Development  Components  Application  E-governance Application

 Commercial application use like railway reservation, telephone billing etc. Aids: Chalk, Duster, Black Board, Pointer.

Preparation:

The applications of components are so wide that they will be playing vary important rots and future life of man to relieve him from many physical and mental ban dens.

The complain does everything as per the instructions given by the programmer in his program. It cannot think of its own like human being.

Introduction:

The first mechanical calculation machine was made in 1642 by the great French matumatwan and philosopher Blasé Pascal pres.

Motivation:

Before use of computer all work was done by paper and it was very lengthy process to do and after use of computer in various application paper is work is reduced and work is become very fast. Presentation:

Input unit memory unit ALU Control unit Output unit

BLOCK DIAGRAM OF COMPUTER

Input unit: The purpose of the input unit is to accept the input data which is required to store the problems Memory unit: the memory unit retains the slips for solution and initial input –data, the intermediate and final results.

Arithmetic unit: the arithmetic unit per forms all mathematical

computation apon receiving instruction from control unit.

Control unit: This unit performs the most vital function in the computer. It actual all this unit and controls the data flow between them to solve the problem.

Output units: The output unit accepts the final result and translates them from machine code to the readable from.

ALU

CU

I/P _O/P

(4)

Computer Application in railway reservation Electricity

Phone Billing

Computer- controlled seat reservation bring benefit to customers. This is achieved by using computer networks. Electricity billing by maintaining the list of all the user name, connection number, number of units and the amount to be paid.

Computerized telephone exchanges handle an ever-increasing volume of calls. They can be linked up to other networks/exchanges for wider, prompt use.

It saves your valuable time.

You can even get the status update.

The information is available at anywhere and anytime

provided you have access to internet.

Question: Study the function of each unit of computer. Explain Various application of computer.

How to use of computer in E governance? Summary:

The complain does everything as per the instructions given by the programmer in his programmer. It cannot think of its own like human being.

Application:

All large business are complain for calculating pay rules billing and processing inventories Reference:

(5)

Title: Introduction to various processor & computer Languages Objectives:

 Micro Computer  Mini Computer  Mainframe Computer  Super Computer Aids: Chalk duster Preparation:

Computers are above available in different size and with different Capabilities. Review:

Broadly they may be categorized as microcomputer, mini computer, main frames and super computer Introduction:

The selection of a particular system primarily depends on volume of data to be handle and the speed of the processor.

Presentation:

Micro computer A Microcomputer is the smallest general purpose processing system Functionally it is similar to any

other large system.

Microcomputers are self contains units and easily designed for use by for a one person at a time.

Since Microcomputer can be liked to large computers they form a very important segment of the integrated information system. Mini computers A Mini computer a medium size

computer they are more costly and power full than a microcomputer. An important diffraction between a Micro and Mini computer is that a Mini computer is usually design to serve multiple users simultaneously.

Mini computer are the popular data processing system.

Main Frame

computer Computer with large storagecapacity and very high speed of processing (compared to Micro and Mini computer) are known as mainframe computer. They support a large number of terminals for used by a variety of users simultaneously. They are above used as the central hose –Computer in distributed data processing system.

(6)

Super Computer These have extremely large storage capacity and counting speed, which are at least 10 times faster than others computers. While the speed of traditional computers in measured in terms of millions of instruction per second (MIPS), A super Computer is rated in terms of Million of operation per second (MOPS): An operation is made of up numerous instruction.

Typically the super computer is used for large scale numerical problems in scientific and engineering discipline

Program:- Sequence of instruction to perform any task is called program.

The language , which can understand by computer is known as programming language.

There are 3 types of programming language.

(1) Machine language (2) Assembly language (3) Higher level language

Machine language :- Computer works on binary pulses. Hence, it can be understood only in pulses. Program written in binary code is called machine language.

Assembly language:- Instructions written in machine language is not easy to remember. We can easily remember the symbols instead of numbers or code. Assembly language uses mnemonics ( symbols) to represent any instruction.

Assembly or symbolic language requires ‘Translator’ , which translate assembly language program into machine language.

Machine & Assembly language, both are machine oriented language. Program development in this language is very tedious.

(7)

Higher Level

Language:-Higher level languages uses simple English words, in which command in particular format are used to perform some instruction or work.

This language is user oriented. As writing program in machine language being tedious, it puts off write in English like words which is easy & convenient, consuming less time with minimum error.

Then this English type command is converted into machine language by particular program. For each High level Language that may be a Compiler or Interpreter.

Question: Classify the Computer according to the their speed and storage capacity (1) What do you mean by ‘Machine language’?

(2) Why H.L.L. is required? (3) Function of Translator.

(4) Difference between Compiler and Interpreter.

Summary: Computers are classified according to their technology and extreme use of its purpose. Application: Application of each computer varies from business to business and it s potential capacity of processing. Application in the electronic, petroleum engineering Weather for casting structural analysis chemistry, medicine and physics.

(8)

Topic / Aim : Input / Output device & their Features

Objective : (1) Online input device, Keyboard , Mouse, Scanner , light Pen Etc (2) VDU ,LCD ,various types of printer

Aids : Marker, White Board ,Duster ,Computer ,Projector Preparation :

* Review : Various Application Of Computer & Various Function Of Computer

* Introduction : various input & Output devices are used to give data to system & to get information from system.

Motivation : Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / Input device

Keyboard devices Mouse

Scanner Monitor

Cathode ray tube LCD

Printer

Input devices are used to enter data from outside world into primary storage.

Allow data entry into a computer system by pressing a set of keys

Used to rapidly point to and select a graphic icon or menu item from multiple options displayed on GUI of a screen.

Input device that translates paper document into electronic format for storage in a computer. Monitor are most popular o/p devices used for producing soft-copy o/p.

The cathode ray tube (CRT) is a vacuum tube containing an electron gun (a source of electrons) and a fluorescent screen.

LCD was introduced in the 1970s and is now applied to display terminals also.

Printers are used to produce paper (commonly known as hardcopy) output. Based on

the technology used.

101 keys QWERTY key board is most popular. Most popular point and draw device.

Stored image can be manipulated with image processing s/w

Display o/p on a television like screen.

Its advantages like low energy consumption, smaller and lighter.

they can be classified as Impact or Non-impact printers.

(9)

Impact printers

Non-impact printers

they use typewriting printing mechanism wherein a hammer strikes paper through a ribbon in order to produce output.

printers do not touch the paper while printing. They use chemical, heat or electrical signals to etch the symbols on paper. Inkjet, Deskjet, Laser, Thermal

printers fall under this category of printers.

Dot-matrix and Character printers fall under this category.

Inkjet, Deskjet, Laser, Thermal printers fall under this category of printers.

APPLICATION :

SUMMARY : Input devices are the devices through which we can give instruction to system. output device gives the output of our given instructions . ASSIGNMENT/ :

QUESTION

(1) What is the full form of VDU,LCD? (2) What is Soft Copy & Hard Copy? (3) Explain it’s feature

REFERENCE : Computer Operator & Programming Assistant – NIMI NEXT LESSON : BIOS Settings & Various Type of Memories

(10)

Topic / Aim : BIOS Settings & Various Type of Memories

Objective : (1) types of memory device , primary memory device: ram, rom

Secondary memory device: Floppy Disk ,Hard Disk, Cd/ Dvd, Flash Memory ,Blue Ray Disk

Aids : Marker, White Board ,Duster ,Computer, Projector Preparation :

* Review : Types of Memory and It’s Example

* Introduction : various types of storage devices are used to store data temporary or permanent.. Motivation :

Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / Types of memory

device

Primary storage devices

ROM (Read only memory )

Secondary storage

- Primary storage - Secondarty storage RAM (Random Access Memory)

Primary storage of a computer is often referred as RAM because of its random access capabilities.

RAM chips are volatile memory. Data is burnt by manufacturer

User can load and store “read-only” programs and data in it.

User can erase information stored in it and chips can be reprogrammed to store new.

It has unlimited capacity.

Speed is far slower than primary storage.

Used to store large volumes of data on permanent basis.

Every computer has a temporary storage built into computer hardware. This temporary storage is known as main memory.==

Also known as auxiliary memory.

Example : magnetic tape , CDROM , floppy disk , hard disk.

APPLICATION :

SUMMARY : Input devices are the devices through which we can give instruction to system. output device gives the output of our given instructions . ASSIGNMENT/ :

QUESTION

(1) Describe Types of Memory and it’s Function (2) What is key to Enter in BIOS setting

(3) What is use of BIOS Setting.

REFERENCE : Computer Operator & Programming Assistant – NIMI NEXT LESSON : Basic Hardware & Software Issues & Software Installation

(11)

Name : Unit/Block No.: Week No.: 3 Lesson no. :6

Topic / Aim : Basic Hardware & Software Issues & Software Installation

Objective : What is hardware and software, Types of Software and It’s Installation Aids : Marker, White Board ,Duster ,Computer ,Projector

Preparation :

* Review : Types of Input / Output device & their Features * Introduction : various Hardware & Software It’s Example Motivation :

Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / Hardware &

Software Issues

Installation any Software

1)Continue Restart Computer 2)Do not Display Monitor

3)Do not Work Keyboard and Mouse 4)Boot Disk Failure

5)Do not out Volume In Speaker 6) Net Work Problem

7)Do not Start Internet.

8)Problem To take Printout thought Printer 9) To come Bip Bip volume in CPU 10) Become to hide file & Folder 11)Cd and Dvd do not open and Write 12)Speed low computer’s

Installation of Basic software 1)Minimum System Requirement 2) Software Setup File or It’S cd Driver 3)User Manual

First Start Computer and Check It’s Problem

1)What is Problem to Restart Computer?

2)What is Problem to do not Display Monitor? 3)Describe problem do mot Work keyboard and Mouse

1) Explain Step to install Microsoft Office

APPLICATION : SUMMARY : ASSIGNMENT/ : QUESTION

(1) What is Required to Install any Software (2) Describe Hardware and Software Issue

REFERENCE : Computer Operator & Programming Assistant – NIMI NEXT LESSON : DOS Internal Commands

(12)

Topic / Aim : Internal Command of DOS Objective : (1) Operating System

(2) CUI & GUI Aids : Chalk, Duster, Pointer. Preparation : Booting Process Review :

Intoduction : DOS is a One Type of CUI Operating System Motivation : Command.com file is the set of Internal command Presentation :

Topics Information Points Tell Spot hints /

Question (Ask) DOS Internal

Command _ Date_Time  CLS  Ver  Vol  DIR  Copy Con  Type  Copy  Ren  Del  MD,CD,RD  Prompt  Edit  Exit

--> What is the full form of DOS?

----> Detail discussion of all the internal commands Of DOS

APPLICATION : Run all the internal commands.

SUMMARY : Use Internal Command any time when your system is on. ASSIGNMENT/ :

QUESTION

(1) What is CUI System?

(2) Difference Between Type & Edit (3) Explain DOS Prompt

(4) Difference between Del & RD REFERENCE :

(13)

Topic / Aim : External Command of DOS Objective : (1) Disk Operating System

(2) Internal Command of DOS Aids : Chalk, Duster, Pointer.

Preparation : Run Dos . Check Dos prompt Review :

Introduction : Motivation : Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / DOS External

Command _ Label_Find  Sort  Tree  More  Attrib  Format  CHKDSK  Disk copy  Scan disk  Del tree

--> What is the use of external commands of DOS?

----> Detail discussion of all the External commands Of DOS

APPLICATION : Run all the External commands.

SUMMARY : External commands are use to format hard disk, Install new programs. Manage all files .

ASSIGNMENT/ : QUESTION

(1) What is Use of sort command? (2) Difference Between Tree & Del tree? (3) Explain Format Command

(4) How can you change the attrib of file? REFERENCE :

(14)

INDUSTRIAL TRAINING INSTITUTE

LESSON PLAN

Topic / Aim Introduction to open source and linux operating system. Objective

Aids Marker pen , duster , pointer. Preparation

Review

Introduction Linux is Unix base operating system. It is invented by Linus Trovalds . There is no any owner of Linux OS. Any one can download it without any hidden cost or freely. Today, Linux is mostly used operating system in personal computer. It is very useful for small business and also the installation is absolutely free.

Motivation To create Socially Responsible and free open source software like GIMP. Presentation

Topics Information Points Tell _{Questions (Ask)}Spot hints / Invention Of Linux

:

Open Source :

What Is Linux :

Where Is Linux :

 Linux is invented by Linus Trovalds , student of the Helsinki University in the year of

1991. Linus likes to play with computer and software so that he gives the name LINUX to the newly invented Operating System.

 The main advantage of linux is , it is open source operating system means Any one can download it easily without any cost. Also the source code for this OS is easily available. So we can also modify it as per our views and ideas. Installation and utilization of the linux is also free. So that Linux called Open Source Operating system.

 Linux is Operating System which is also known as GNU / LINUX. Linux is co-operative development model so that any one can use it.  It is also known as Free Open Source Software (FOSS).

The main advantages of linux is Speed , Security And its Stability. There is no any Issues like Virus , Spyware and Worm.

 Linux is open OS so that the software is developed by the co-ordination of many Companies.

 In starting phase it is used as a Server operating system but now its use as a desktop operating system.

Who is the Inventor of Linux Operation System ?

Why Linux is called Open Source ?

What is the Full Form of FOSS ?

Can virus affected to our pc if we installed Linux ?

(15)

Advantage Of Linux :

 It is also used in Symbian Operating System Phone as well as in PDAS.

 There is no any owner of Linux Os . So any one can debug it without License Permission.  The main advantage is , its Free and most of the softwares comes with General Public License.

Multiple User can use it at a time. Speed will be same no matter how many users use it.  Its run on PC , MAC OS , Mainframe Computer , Super Computer and in Cell Phone.  We also run it on Separate Hardware.

What are the advantages Of Linux Operating System?

APPLICATION To Develops the open source software like open office which is mostly work as a Microsoft Office provided by Microsoft Corporation.

To create Virus Free and Spyware free Application.

SUMMARY Today all the software are very costly in market. Linux is only single platform on which we can create , modify and debug the free application or software. It will be very useful in Government Sectors Because now a days government has to pay big amount of money to private sector or company for their license version software.

ASSIGNMENT/

QUESTION 1.Explain History Of Linux.2.What Do you mean by Linux ? And where it is used ? 3.Explain the advantages of Linux Operating System. REFERENCE Internet

(16)

INDUSTRIAL TRAINING INSTITUTE

LESSON PLAN

Topic / Aim LINUX Commands.

Objective To aware with the basic Linux Commands. Aids Marker pen , duster , pointer.

Preparation Review

Introduction We can perform the different operations like change date , display message , copy files , remove folders , create folders etc..Using the Linux Commands. It is also used to perform system task like to change password for particular login user. In short Linux command is very useful when we have to perform different task in a system mainly in Character User Interface (CUI).

Motivation To work in Character User Interface and Open Source Software. Presentation

Topics Information Points Tell _{Questions (Ask)}Spot hints / Date Command :

Echo Command :

Who Command :

Ls command :

 It is use to display as well as change the system date and time.

 Different parameters like D,x,X,Y,y,b,B,m, W etc..are use to set date and time in a particular format like mm/dd/yy and etc.

 Syntax : date [option] [+format]

 This command is use to display message on screen. We can also display echo in a color. Different escape sequence code is used to display foreground color as well as back ground color.

 Syntax : echo [option] [String]

 It is use to display list of currently login users as well as additional information of particular user like login time and terminal number etc..

 Syntax : who [option]

 This command is use to display list of files as well as directories.

 Different options like -a,-A,-R,-x,-d,-l are used to display files and directory in particular format.

 Syntax : ls [option] File / Directory.

E.g. date ‘+DATE: %m/ %d/%y/%n’

It display the o/p like DATE : 10/28/14

E.g. echo HELLO_COPA

E.g. $who

E.g. ls –A

To display file list with all hidden files.

(17)

(18)

Cp command : Rm command : Mv command : Cd Command : Mkdir Command : Rmdir Command : Chmod Command : Sort Command : Grep Command : Passwd command :

 This command is used to copy one or more files to another location.

 We can also copy archive file as well as take back up using the sub option –a,-b.

 Syntax : cp source file destination file.  This command is use to delete file. It deletes the file with message or without message with sub option –f and –i.

 Syntax : rm [option] [file]

 This command is use to rename file and moves the file from one directory to another.  Syntax : Mv Old_Filename New_Filename  This command is use to change current directory.

 Syntax : cd directory_name

 This command is use to make new directory in to current directory. The new directory must not be in the same directory.

 Syntax : mkdir directory_name  This command is use to delete empty directory.

 Syntax : rmdir Directory_name

 This command is use to change file’s access permission. Different code for read,write and execute is used.

 Syntax : chmod code filename

 This command is use to arrange lines in text file.

 Syntax : sort [option] filename

This command is use to search particular word in a file as well as display that word on a screen.

 Syntax : grep [option] string file_name  This command is use to change password for the currently logged in user.

 Syntax : passwd [option]

E.g. $ p1.doc e:\p2.doc

E.g. $ rm test.txt It removes test.txt file.

E.g. mv mycopa.txt c.txt

E.g. cd d:

E.g. mkdir iti_babra

E.g. rmdir iti_babra

E.g. chmod 644 test.txt

E.g.$ sort iti_babra_adm

E.g. $ grep ‘copa’ itibbr.txt

(19)

APPLICATION Mostly used in different Linux based OS like ubuntu, fedora etc…

SUMMARY It Becomes very easy to work in a Character User Interface using all these linux command. It is possible to perform different task related to the operating system using Linux command.

ASSIGNMENT/ QUESTION

1. Explain Date and Ls command with all its option. 2. Explain mkdir and rmdir command with example. 3. Explain cp,rm,mv and cd command with example. REFERENCE Internet

(20)

Name : Unit/Block No.: Week No.: 6 Lesson

no. :

11

Trade : COPA Date: Time : 9Hour

Topic / Aim : Introduction of word & file menu Objective : (1) Installation of MS-Office

(2) Application of MS word

(3) Various option of MS word(File Menu) Aids : Chalk, Duster, Pointer.

Preparation :

* Review : Window * Intoduction :

Motivation : How to creat Atrective Document Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / Introduction of MS

Office MS Office automation software is useful to _{make various document, spread sheet and} presentation It contain 3 part.

A. MS-Word B. MS-Excel C. MS-Power Point  Use of MS-word to make various type

of Document.

 MS-Excel is useful for making of different type of spread sheet.  Power Point is for presentation

Thus by use of Ms-Office one can do any type Of computer work. It is more advantages then Dos base software like Lotus & Word star.

Installation of MS-Office  Insert CD of MS-Office in the CD drive of computer system.

 From run option of start menu run setup.exe  Give required

option during setup.  After completion of MS – Office installation ,restart computer system. Run MS-Office now. Study of various

menu. From start menu, program load MS-Word by_{double clicking on MS-Word. After Loading} window of Word.

One Menu bar you will see following option. File,Edit,View,Insert,Format,Tool,Table,Windo w,Help.

File Menu. _{In file menu following item see.}

New, open, close, save, save as, web page, version, page preview, page setup, print preview, send to, property

Detail discussion of all option of file menu.

(21)

APPLICATION : Word is useful to make various types of document. SUMMARY : MS-Office(Office Automation Software)

ASSIGNMENT/ :

QUESTION (1) What is the full form of MS in MS-Word?(2) What if the difference between save and save as? (3) What is the use of print preview?

(4) Explain page setup?

REFERENCE : MS-Word is use to create application, letters and other attractive documents. NEXT LESSON : Edit , View and Insert Menu of MS-Word.

(22)

Name : Unit/Block No.: Week No.: 7 Lesson

no. :

12

Trade : COPA Date: Time : 9

Hours Topic / Aim : Introduction of Edit , View and Insert menu of MS-Word.

Objective : (1) Edit Menu of MS-Word. (2) View Menu of MS-Word. (3) Insert Menu of MS-Word. Aids : Chalk, Duster, Pointer. Preparation :

* Review : MS Office * Intoduction :

Motivation : Using Edit, View and Insert menu of Word ,user can edit the document. Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / Edit Menu In edit menu following options are available.

Undo , Repeat, Cut, Copy, Paste, Paste Special, paste as hyperlink, clear, select all, find,

Replace, Go to, Link, Object

Detail Discussion of all above option of edit Menu

View menu. In view menu following options are available. Normal, Web layout, Print layout, Out line, Tool bar, Ruler, Document map, header & footer, Footnote, Comment, Full screen, Zoom

Detail Discussion of all above option of View Menu

Insert menu. In Insert menu following Options are available. Break, Page Number, date & Time, auto text, Field, Symbol, Comment, Footnote, Caption, Cross reference, index & Tab, picture, Book mark, file, object.

Detail Discussion of all above option of Insert Menu.

APPLICATION : Edit , View and Insert menu is useful for editing word document. SUMMARY : View for Different view of document, Insert and Edit menu for editing

document ASSIGNMENT/ :

QUESTION

(1) Work all short cut key of option of edit, view and insert menu? (2) What is the use of Header & Footer?

(3) difference between paste and paste special? (4) How to add new page in document?

REFERENCE :

(23)

Topic / Aim : Format,Tools & Table Menu Objective : (1) Format menu

(2) Tools menu (3) Table menu Aids : Chalk, Duster, Pointer. Preparation :

* Review :

* Intoduction : Microsoft word

Motivation : Window & dos base program like typing tutor ,Ms-Office etc. Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / Format menu --> Font: This will change the font attributes of

either the currently selected text

-->Paragraph: select the text you wish to change and then use this command to make the

alterations, such as alignment, indentation, and spacing.

-->Bullets and Numbering: This is a handy command, it creates indented lists with various formats.

-->Borders and Shading: This command allows you to create borders and shading on elements within your Microsoft Word document.

-->Columns: The Columns command will split the current document into the number of columns you specify.

-->Drop Cap:This tool allows you to either add a drop cap character to your document or change an existing letter (at the start of a sentence) to a drop cap.

-->Text Direction: This allows you to change the text direction of a text object, for example a text box.

-->Change Case: The Change case tool allows you to alter the case of existing text.

-->Background: This changes the background color of your Microsoft Word document. It also allows you to add watermarks and use different gradient effects.

-->Styles and Formatting: This will open the Styles and Formatting toolbar, allowing you create headings, lists and more.

--> What is the use of font command?

--> What is the use of borders and shading? --> What is the use of change case?

(24)

Tools Menu _{-->Spelling and Grammar: This command will} check the spelling and grammar of the current Microsoft Word document.

-->Language: The language tool has various options, including setting the language of the document, translating text, open the thesaurus and manage hyphenation.

-->Word Count: This will open the Word Count dialogue box, enabling you to count the amount of words in the whole document, or the

currently selected text.

-->Protect Document: This command allows you to control the protection of the document, including tracked changes, comments and forms.

-->Letters and Mailing: Gives you access to various features, including the Mail Merge Wizard, the Letter Wizard, the Envelopes and Labels tool, and the Mail Merge Toolbar. -->Macro: This opens the Macro Dialogue box, allowing you to manage subsequent and existing macros. We will be covering Microsoft Word macros in a future tutorial.

-->Templates and Add-Ins: Opens the Templates and Add-Ins Dialogue box, allowing you to add, remove or update styles and template.

-->AutoCorrect Options: Opens the AutoCorrect dialogue box, enabling you to manage

capitalization, and also the replace text as you type settings.

-->Options: This opens the main options dialogue box in Microsoft Word. It allows you to change many aspects of the current document and Microsoft Word environment.

--> What is the use of spelling and grammer? --> Explain mail merge.  explain macro.

(25)

Table menu _{-->Draw Table: This command opens the Tables} and Borders dialogue box with the draw table tool active.

-->Insert: Allows you to insert a whole table or just columns, rows and cells into the current document.

-->Delete: Delete complete tables, columns, rows and selected cells.

-->Select: This command allows you to select the current table, column, row or cell.

-->Merge Cells: This tool will merge the currently selected cells into one.

-->Split Cells: This will split the selected cell/s into your chosen amount of columns and rows, it will also offer (if more than one cell selected) to merge the selected cells before the split. -->Table AutoFormat: This command will open the Microsoft Word Table AutoFormat dialogue box, where you can choose from a number of different table templates, including preset fonts and cell background colours (colors).

-->Convert: This command will convert existing text into a table format. The text will have to have a common separator to indicate the different columns, it will also needs new

paragraphs where you would like each row. -->Sort: This opens the Sort Table dialogue box. You can choose which column you would like to sort and by what order.

--> What is the use of merge cells?

--> What is the use of split cells?

--> What is the use of sort?

APPLICATION :

SUMMARY : Thus, format,tools and table menu is very useful for making document attractive.

ASSIGNMENT/ :

QUESTION (1) Explain mostly used commands of format menu in word.(2) Explain mostly used commands of tools menu in word. (3) Explain mostly used commands of table menu in word. REFERENCE :

(26)

Topic / Aim : Introduction of EXCEL & File menu Objective : (1) Introduction to EXCEL

(2) File menu Aids : Chalk, Duster, Pointer. Preparation :

* Review : * Intoduction :

Topics Information Points Tell _{Question (Ask)}Spot hints / Introduction to excel Microsoft excel is a spreadsheet software and a

software of micrsoft office suite. It is used to sotore numeric data very easily. You can also add formula and function to analyze the data. You can also add graphics like charts to manipulate the data very easily. Excel files called workbook. Each workbook has three worksheets. Worksheets are the are where you can enter data in tabular format. Each worksheet have 255 columns ane 65536 rows. Excel files are saved using .xls extension. Microsoft excel is used for creating marksheets,payroll of employees,production reports for companies. You can start excel by start->all programs->Microsoft office-> Microsoft excel. You can also open excel by typing “excel” in run menu. Excel screens have different areas like

titlebar,menubar,standard toolbar,formatting toolbar,formulabar,worksheet etc.

--> What is the use of Microsoft excel?

--> Explain different ways to start excel

(27)

File menu -->New... Opens a new Excel Workbook. -->Open... Opens many types of Excel documents, even text files.

-->Close: Closes the current Workbook. -->Save As... Saves your Workbook under a different name or different format.

-->Page Setup Controls how your page prints out.

-->Print Area: Is how you specify the part of your worksheet that you wish to print. -->Print Preview Shows you what your document looks like before you waste paper printing out something that doesn't look the way you want it to.

-->Print... Prints the selected area, current Worksheet all Worksheets in your Workbook. Properties Allows you to look up or add detailed information about your document. Below this is a list of the files opened recently by Excel.

--> Exit Closes Excel and all open Workbooks.

--> What is the use of new,open,save command ? --> Explain page

setup,print preview,print area.

APPLICATION :

SUMMARY : Thus, Microsoft excel is very useful software for calculations on data. ASSIGNMENT/ :

QUESTION

(1) Write short note on Microsoft excel

(2) Explain mostly used commands of file menu. REFERENCE :

(28)

Name : Unit/Block No.: Week No.: 10 Lesson no. : 15

Topic / Aim : Edit, View & Insert Menu Objective : (1) Edit menu

(2) View menu (3) Insert menu Aids : Chalk, Duster, Pointer. Preparation :

* Review : * Intoduction :

Topics Information Points Tell _{Question (Ask)}Spot hints / Edit menu --> Undo :Takes back the last thing you did. You

may click it or type Ctrl+Z repeatedly to turn back time to before you make a mistake. --> Repeat or Redo: Repeats the last action reverses an undo.

-->Cut: The selected cell(s) will disappear after you paste them. Selected text disappears and is stored temporarily in the Clipboard.

--> Copy: The contents of selected cell(s) will be copied to a new location when you paste them. Selected text is copied into the Clipboard. --> Paste :Previously cut or copied cells are pasted into the newly selected location. Cut or copied text, images, etc. are copied from the Clipboard into the newly selected location. --> Fill: Lets you fill selected cells with the contents of the first cell in the range (in white). --> Clear: Removes formatting (e.g. bold), contents, or all of the above. Note that the little "Del": key clears contents but not formats or comments.

--> Delete Sheet: Permanently removes the current sheet from existence.

--> Move or Copy Sheet.: Lets you move or copy the current Worksheet within the current Workbook or to a new Workbook.

--> Find.:Locates a given text string within your selection.

--> Replace: Locates and replaces a given text string in your selection with another specified string (or with nothing at all).

--> Go To.:Takes you to a cell specified by column and row, or specified by name.

--> What is the use of cut,copy and paste command?

--> What is the use of move or copy sheet command?

--> What is the use of find,replace and goto?

(29)

View menu _{--> Normal View :displays all cells, printing or} not.

--> Page Break Preview :Displays only the cells that will be printed. You may set page breaks in this views (displayed as blue lines) by dragging them.

--> Toolbars: Lets you select which toolbars are visible across the top of your Excel window (i.e. the rows of buttons).

--> Formula Bar: Sets whether or not you wish to display the Formula Bar, which displays the formula (if any) or unformatted contents of the currently selected cell.

--> Status Bar :Sets whether or not you wish to display the Status Bar, shown across the bottom of the Excel window.

--> Header and Footer: Allows you to edit the Header, which appears across the top of each printed page, and/or the Footer, which appears across the bottom.

--> Full Screen :Maximizes the viewable area of your worksheet by filling up the entire screen and hiding everything except the menu bar. --> Zoom:Allows you to zoom in and out of your document (i.e. to magnify or shrink the worksheet display - does not affect printed format).

--> What is use of page break preview?

--> Explain header and footer.

Insert menu --> Cells: Inserts new cells into your worksheet, prompting you to ask how you would like to move the surrounding cells out of the way. --> Rows : Inserts a new row above the selected cell(s).

-->Columns: Inserts a new column to the left of the selected cell(s).

--> Worksheet: Inserts a new Worksheet, with its tab to the left of that of the selected Worksheet. --> Chart... Launches the Chart Wizard to help you insert a chart based on given data within your Worksheet.

--> Page Break: Inserts a page break above the selected cell(s).

--> What is use of chart? --> What is use of pagebreak?

--> What is the use of function?

(30)

--> Function: Launches the Function Wizard to insert a function based on given given data within your Worksheet. Picture: Inserts a Clip Art, an image file, WordArt or acquires a new file from a scanner.

--> Object: Inserts an object such as a Windows Media Player video or other OLE (Object Linking and Embedding) compatible file. --> Hyperlink : Inserts a link to a specified website or file location. If you click on the link, you will be brought to that location.

APPLICATION : SUMMARY : ASSIGNMENT/ : QUESTION

(1) Explain mostly used commands of edit menu in excel. (2) Explain mostly used commands of view menu in excel. (3) Explain mostly used commands of insert menu in excel. REFERENCE :

(31)

Name : J.G.Chaudahri Unit/Block No.: Week No.: 11 Lesson no. : 16

Topic / Aim Format , Tool And Data menu of EXCEL

Objective 1. To represent a data in a proper format to understand it easily. 2. To create error free and grammatically perfect worksheet.

3. Present data in proper sequence so that anyone can understand it easily. Aids Marker Pen , Duster And Pointer

Preparation Review

Introduction In a computer , when you work with arithmetic or numerical data it is very necessary that it looks like anybody can understand it easily and must be in proper sequence and format. It is also necessary that the data will be error free and provides user friendly environment.

Motivation Create database program like Result sheet and Accounting Database. Presentation

Topics Information Points Tell _{Question (Ask)}Spot hints /

FORMAT MENU :

TOOLS MENU :

 CELLS :- Using this option you can set the particular category for each and every cell like currency, number, date, time, percentage etc. It is also possible to set alignment like left, center, right, top, bottom. It provides the facility to set font, font style, size, border, effects and shading color for the cell.

Row And Column:- This option is use to set height and width of the cell should be adjustable as per data.You can also hide Row and Column. Sheet :- Using this option, User can gives the name to sheet as per its requirement and also set background picture for the sheet and tab color. User can hide the sheet using this option. Auto Format:- It is a collection of different inbuilt formats for sheet with designs and different colors.

 Conditional Formatting :- User can provides different formatting to the cell as per different condition.

 Spelling (F7):- Excel checks the spelling in entire active worksheet. If there is a mistake, it suggest the correct spelling.

Research:- You can quickly reference information online and easily insert definition , stoke quotes etc.

Is it possible to set date format for particular cell or column ? How ?

How can you set row height or column width ? Is it possible to set back ground image to sheet ? How?

How can you set Auto format of sheet in excel? E.g. : In Mark sheet if student result is fail then cell’s background color should be red otherwise it’s display with green

background color etc.. Which is the short cut key to check spelling ?

(32)

DATA MENU :

Protection:- User can protects it’s data in sheet using this option. Password require to un-Protect the sheet.

Auto correct :- It’s automatically corrects the spellings or word if we specify it in auto correct option.

Macro:- If you perform a task repeatedly in excel , you can automate the task with a macro. It is a series of command and functions that are stored in Microsoft Visual Basic modules and can be run when ever you need to perform the task.

 Sort :- Use to sort data according to specific sort order like ascending or descending.

If data in one column will be same then it will checks the 2nd_{and 3}rd_{column which} we specify in sort option of data menu.

 Filter :- We can filter data as per our

requirement. Sheet contains different cell values in different rows but if we want to see particular cells which contains same value or value to above or below to specific criteria , then it should be done only with filter option.

Validation :- We can specify the particular rules for particular cell using this option.

Text to Column :- User can converts the text data into column automatically using this option

How we can protect our sheet?

E.g. Spelling ‘The’ is type Like “ Teh” then it will automatically converted in to “ The“ if we already added that spelling into this option.

E.g. If you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps.

How can you arrange data in particular order ?

E.g. In result sheet we have to see only those rows which contains “Science” as a stream then it should be possible with filter option.

E.g. In mark sheet , percen-tage must be between 1 to 100 so if any one can enter Above or below value , it display error like “The value you entered is not valid. APPLICATION To create mark sheet etc.

SUMMARY It is very easy to arrange , format and represent data and save our time and energy.

1. Explain Conditional Formatting in EXCEL. 2. Explain sort and Filter facility and it’s advantage. 3. Explain macro facility.

REFERENCE Internet.

(33)

Topic / Aim Introduction to power point & File , Edit , View menu.

Objective 1. A universally designed presentation enhances student learning by presenting information in a variety of formats , text , images , and multimedia.

2. To create useful and proper presentation so that any persons can understand it easily.

Review

Introduction Power point is the presentation graphics program that helps you create lasting visual impact either in person or online. With enhanced multimedia support , save your presentation to storage device for distribution and play streaming audio and video within a slide show.

Motivation To create presentation like Business strategy , science and technology etc… Presentation

Topics Information Points To Tell Spot Hint / Questions_(Ask) Introduction To

Power point :

FILE MENU :

 Power point is a very powerful software using which we can create suitable

presentation , slides on particular topics. It becomes very easy to present data on a computer using the power point software.

 New :- Using this option we can create a blank presentation or choose inbuilt design templates.

 Open :- To open presentations which are stored on storage media.

 Close :- To close the currently open presentation file.

 Save :- It is use to store or save presentation on storage media in a computer.

 Save as :- It is use to create another copy of saved presentation with different name and location.

 Page Setup :- It is use to set slide size like A4 , banner , letter etc… as well as height & width of slide.

We also set the orientation of slide , notes , handouts & outline using this option.

 Print Preview :- It displays the slides same as print in hard copy.

What Is Power Point ?

What is the shortcut key of New , Open ,and Save option ?

Which Option is use to set Orientation of Slide ?

(34)

EDIT MENU :

VIEW MENU :

 Print :- It is use to take print out of our slides. We can also print selected slides as well as specifies the number of copies into this.  Exit :- Use to exit from power point software.

 Undo (ctrl+z) :- It removes the effect or process of last task.

 Repeat (ctrl+y):- It cancels the effect of undo.

 Cut(ctlr+x) :- It is use to move data from one slide to another.

 Copy(ctrl+c) :- It is use to copy data from one slide to another.

 Paste(ctrl+v) :- Use to paste cut or copied data to the destination.

 Office Clipboard :- It saves the copy of copied or cut data in it.

 Clear :- Use to delete particular object/ content as well as slide.

 Select All :- Use to select all the content or data in a slide.

 Duplicate :- To create the slide same as selected slide.

 Find :- We can search particular word in our presentation using this option. We can also search with perfect match like capital word or small.

 Replace :- We can put another word at the place of the word written in “ Find what” box.  Normal :- It is the main editing view. User can normally works with normal view.

 Slide Sorter :- It is an exclusive view of our slide in thumbnail from , helpful for rearranging the order of our slides.

 Slide Show :- Slide show view takes up the full computer screen , like an actual slide show presentation. In this full screen view you see your presentation the way your audience will.  Task Pane :- When this option is ticked , It will display the task pane to the right side of the slide.

 Toolbar :- Use to enable different toolbar like picture , drawing , standard , formatting etc… on the screen.

 Ruler :- Use to display vertical as well as horizontal ruler on the screen.

 Header and Footer :- Using this option , we can add date & time as well as slide number and footer text which display bottom side of the slide.

 Zoom :- We enlarge our slide using this option. It supports minimum 33% and maximum 400% zoom.

Which shortcut key is use to print slide data ?

What is the shortcut key of undo or repeat ?

What is the shortcut key of cut , copy & paste ?

What is the shortcut key of clear & select all ?

What is the shortcut key of Find and replace ?

How many types of view available in power point ?

How can you add different toolbar in power point ?

How can you add slide number in power point ?

(35)

APPLICATION To represent any data on computer Easily & Attractively.

SUMMARY When You are making your presentation , create the content of your presentation first and then get creative with colors and animation. ASSIGNMENT/

QUESTION

1. What is Power Point ? Explain the file menu.

2. Explain the edit menu with all sub menus in power point.

3. How many types of views are available in power point ? Explain each with details.

REFERENCE Internet.

(36)

Topic / Aim Insert and slide show menu.

Objective 1. To create presentation using multimedia tools like sound , pictures , objects etc... 2. To add animation effects and timings of slides in presentation.

Review

Introduction It is very necessary that our presentation has sound effects , animations , pictures and effects. Sometimes our presentation becomes boring so that Insert menu and slide show menu both provides the facilities to add above mention all facilities and effects. They makes our presentation attractive and Interesting.

Motivation To create presentations like Business strategy , science & Technology etc….. Presentation

Topics Information Points Tell _{Questions (Ask)}Spot hints / INSERT MENU :

SLIDE SHOW MENU :

 New Slide(ctrl+m) :- It is use to insert new blank slide into current presentation.

 Duplicate Slide :- It is use to insert another slide same as selected slide into presentation.  Slide Number :- Use to insert slide number in all slides of presentation.

 Date & Time :- To insert date and time into current slide.

 Picture :- It is use to insert graphics like clip art , auto shapes , word art and organization chart. We can also insert picture from scanner and camera.

 Diagram :- It is also possible to add different diagram in our presentation. We can add

different diagrams like chart , cycle diagram , radial diagram , pyramid diagram , target diagram into our presentation.

 Textbox :- Use to insert textbox in slide which is use to write text.

Movies and Sound :- We can add movie clip with sound using this option, Its also provides the facility to record the sound.

 Table :- We insert table with specific rows and columns into our slide using this option.  Object :- It is also possible to add object of other applications like Excel , Word , Adobe Reader and Word pad etc… using this option.  View Show :- We represent our presentation in full screen view using this option. The short cut key for this option is F5.

What is the shortcut key for new slide ?

How can you add slide number , date & time into presentation ?

How can you add auto shapes in power point ? What is the need of organization chart ?

Which Option is use to insert video clip into presentation ?

Is it possible to add word document in our

presentation ? How ? What is the short cut key of slide show ?

(37)

 Set up Show :- We sets how many slides have to display and also sets slide show resolution using this option.

 Action Buttons :- We add different buttons icons like next , previous , home etc.. using this option.

After adding buttons specify hyperlink for that button. So when we click on that button during slide show , we moves on slide which set into hyperlink.

 Animation Schemes :- It contains different animation schemes like fade in , faded zoom , flash bulb and much more for the contents in our slide.

 Custom Animation :- It’s use to apply custom animation effects to our content in slide. If we select this option , animation effect will apply by software on our content automatically.  Slide Transition :- It is use to give

animation effect to our slide not to content. We also set sound & speed for our slide transition.  Hide Slide :- If we hide any slide then it should not be display during slide show.

What is the use of Action Buttons ?

How we can apply animation to our content ?

What is the main difference between animation scheme and slide transition ? How we can apply animation to our slide ?

APPLICATION To represent any data on computer Easily & attractively.

SUMMARY Add only necessary sounds and animation in presentation. If we added more sounds , colors & Animation into slide then people more attracts towards them not towards your data and so that it should be possible that you will be fail in your aim.

1.Explain Picture & Diagram option with all option. 2.Explain Animation schemes and Slide transition option. 3.What is diagram chart ? Explain with figure and example. REFERENCE Internet

(38)

Topic / Aim : Concepts of Data, Information , Database, DBMS and RDBMS

Objective : (1) Terminology of Data, Information ,Database , DBMS and RDBMS (2) Explanation of DBMS

(3) Difference between Data and Information . Aids : Chalk, Duster, Pointer.

Preparation : * Review :

* Intoduction : Database management and Relational Database Management system Motivation : DBMS and RDBMS Concept in Real World

Presentation :

Question (Ask) Information  Result of Data Processing

 For Making a Decision

 Used to make process, planning and representation

--> What is Information? --> Why Information ? --> What is the use of Information?

Data  Collection of Information which should be 100% Fact.

 It is basic raw material for processing  It will simple and random.

--> what is data ? --> Why data ?

Data V/S

Information  Data From Latin Word “Datum” and _{Information From Latin Word “} Informare”

 Data is Formatted Information and Information is result of Data Processing  Data may be meaningful and

Information must be Meaningful  Data consider as system input and

Information Consider as Data Output  Data is Basic Raw materials and

Information is Product.  Data require to process for

understanding and No need to require for Information

-->Difference Between Data and Information

Database  Collection of Information with proper format

 Collection of Arranged data in format  Collection of Table

-->what is Database? --> Why Database?

(39)

DBMS  Full form of DBMS

 Maintaining Different Types of Information

 Example.Foxpro,dbase etc.  Advantages of DBMS Packages

1. Complex Relationship 2. Data redundancy

3. User Define Table Form 4. Maintain Dictionary

5. Automatic Backup And Recovery

-->what is DBMS ? --> what is Full form of DBMS ?

-->Explain Advantages of DBMS

RDBMS

 Full Form of RDBMS

 “ Edgar F. Codd” Rules of RDBMS  Concept of Row, Column, Table, Record

, Field , Attribute

 Concept and Types of Relationship

-->what is RDBMS ? --> Rules For RDBMS PACKAGES

--> what is Row and Column ?

--> What is Attribute ? -->What is Table ? --> what is Record and Field ?

-->Explain types of Relationship. APPLICATION :

SUMMARY : Concept and Terminology of Data, Information, Database and DBMS ASSIGNMENT/ :

QUESTION

(1) What is Data, Information and Database? (2) Explain DBMS with Advantages.

(3) Explain Difference Between Data and Information (4) what is RDBMS? Explain with E.F. Codd Rules.

(5) Explain Row, Column, Table, Record, Field and Attribute. REFERENCE : Microsoft Office -2003 by Bible

NEXT LESSON : Rules for designing good tables, Data Integrity Constaints and Relationships in a tables.

(40)

Topic / Aim : Rules for designing good tables, Data Integrity Constraints and Relationships in _tables. Objective : (1)Rules for Designing Table

(2) Data Integrity constraints (3)Relationship In Table. Aids : Chalk, Duster, Pointer. Preparation :

* Review :

* Intoduction : Designing Good Table With Relationship. Motivation : Data integrity in Relationship of Tables. Presentation :

Topics Information Points Tell _{Question (Ask)}Spot hints / Rules for Designing

Table  Field name Must be Between 0 to 255 _Characters.  Select proper Data type of Field.

 Set the primary key. For NO-Duplication  Set Default Value . For Blank Value  Set Validation of Field

 Set Format of Number Field  Set Yes of Field for Data Must Be

entered

Set validation text for Validation Error

--> What is Table? -->what is Row and Column?

--> What are the rules of Table Designing ?

Data Integrity

Constraints _ What is Data Integrity ?_{Primary key}  Check Constraints  Default Constraints  Foreign Key  Unique Constraints

-->what is Data Integrity? -->what is Primary key? --> what is Check Constraints ? -->What is Default Constraints ?

-->What is Foreign Key? --> What is Unique Key? Relationship In

Table _ What is Relationship ?_{Explain Types of Relation ship} 1. One – to –one

2. One – to – many 3. Many –to –many 4. Many – to – one -->what is RDBMS ? --> what is Relationship? --> Explain Types of Relationship. APPLICATION :

SUMMARY : Rules of Designing Table with Data Integrity and Relationship ASSIGNMENT/ :

QUESTION (1) Explain Rule of Designing Table .(2) Explain Data integrity .

(3) Difference Between Primary key and Foreign key (4) Explain Check, Default and Unique Constraints REFERENCE : Microsoft Access -2003 by Dummies

(41)

Topic / Aim : Creating Table Using Different Views

Objective : (1) Start The Ms-Access(awaking the Access) (2) Create Database and Store database

(3) terms of Row, Column, Table, Record and Field (4) Create Table in Design View

(5) Create Table by Using Wizard (6) Create Table By Entering Data Aids : Chalk, Duster, Pointer.

Preparation : * Review :

* Intoduction : Start The Access and Create Database And Tables Motivation : Create database and Stored Data in The Tables. Presentation :

Question (Ask) Start The Ms-Access

(awaking the Access)

 Start—Programs-Microsoft office-Access

-->How Awaking the Ms-Access ?

Create Database and

Store database  Select Blank Database of File menu Or_{Task Panel}  Store The Database with Database name

In Storage Drive

-->How to Create Database in Ms-Access ?

terms of Row, Column, Table, Record and Field

 Row means Horizontal Line  Column means Vertical Line

 Table means information that represent in Combination of Row and Column  Record means information that represent

in Horizontal line

 Field means information that represent in Vertical line -->what is Row ? -->what is Column? -->what is Table ? -->what is Record? -->what is Field? . Create Table in

Design View  Select Table Object and select Create _{Table in Design View}  Type Field name With Data type and

Description

 Set the Field Properties

 Set the Primary key For Duplication of Record

 Save the Table with Table Name

 Show the Table and Enter the Data in the table

-->Explain Create Table In Design View.

-->Explain Data types -->Explain Data type properties

(42)

Create Table by

Using Wizard  Select table Object and Create Table by _{using Wizard}  Select the table type business or

personal

 Select table and set the Fields as required

 Store the table with name and enter the data in the table

-->write steps of create table by using wizard

Create Table By

Entering Data  Select the table object and create table _{by using entering data}  You can directly entered the data in the

sheet

-->write the steps for create table by entering data

APPLICATION :

SUMMARY : Create Database and Table in Ms-Access ASSIGNMENT/ :

QUESTION (1) How to Awaking in Ms-Access?.(2) How To Create Database in Ms-Access ? (3) Explain Data types In Ms-Access. (4) Explain Types Of Create Table. (5) How to create table in Design View? (6) Explain Properties of Data Types.

(7) Write Steps for Create table by using Wizard. (8) Write steps For Create Table By Entering Data. REFERENCE : Complete Reference of Microsoft Access - 2007 NEXT LESSON : . Creating Queries & Forms