DOM Notes.pdf

MODULE FUNDAMENTAL Name input devices of Computers. → Mouse Computer keyboard Scanner Microphone CPU Touchpad Graphic tablet, Barcode reader etc. Name the laptops which are a...

MODULE FUNDAMENTAL Name input devices of Computers. → Mouse Computer keyboard Scanner Microphone CPU Touchpad Graphic tablet, Barcode reader etc. Name the laptops which are available in the market. → Dell, Lenovo, HP, Apple, Acer, Asus Toshiba Samsung, Infinix Name output devices of computer. → Printer Monitor Loudspeaker Projector, Sound Card Computer speakers Desktop computers Headphone. RAM-Random Access memory When you switch on the computer what you see? → OS window Name some software which is used by you → Microsoft word, PowerPoint, Microsoft excel, Microsoft Access What is the full form of CPU? → Central processing unit. Write some names with information of Computer Hardware parts. → Computer hardware includes the physical tangible parts or components of computer such as the cabinet, central processing unit (CPU) monitor, keyboard, computer data storage, graphics card, sound card, speaker’s motherboard Uses of computer in daily life → Home, Education Medical field, Marketing, Military, weather forecasting, Robotics; Retail & Trade, Science & security surveillance Difference between Hardware Software → Hardware: the physical x visible components of a computer system are called hard ware. Hardware is any part of the computer that we can see & touch. Eg: Monitor, mouse, CPU, Speaker, headphones keyboard etc. → Software A set of computer instruction procedures s programs that make the computer hardware functional represents the program which performs different tasks on a computer system. Eg:-Windows, word, Excel, Access, PowerPoint, Chrome etc. When you switch on the computer what is displayed on the desktop → Windows OS 1 Created By: Rahul Ravankar  WORD PAD Uses of line spacing & Paragraph line spacing.  Line spacing – Change the spacing between lines of text. Add or remove the space after paragraph.  Paragraph spacing – Determines the amount of vertical space between lines of text in a paragraph. Paragraph includes:  Indentation → Left, Right & First Line. Steps to cut any shapes from paint move to WordPad.  Click on select Rectangular selection→ Select the shape→ Click on cut option→ Open WordPad→ select paste option. In word pad clipboard displays → cut, copy paste. Use of folder in the computer →to store all the files separately Text effect meaning → Apply a visual effect to the selected text, such as a shades, glow or reflection Steps to change the icon of the folder → Select folder Right click on folder > Properties >Customize change icon >Select icon- Apply >ok. Steps to replace the word in WordPad →Select the paragraph → Click on Replace (Editing) →Type the word which you want to replace under Find What →Type the word which you want to change the word from previous word under Replace with →Click on Replace All → Ok. 1 Created By: Rahul Ravankar  Ms-word What is mail, Merge? → Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document. Short Cut keys in MS word i. Paste : Ctrl + V ii. Bold : Ctrl + B iii. Cut: : Ctrl + X iv. Italic : Ctrl + I v. Select All : Ctrl + A vi. Copy : Ctrl + C vii. Print : Ctrl + P viii. Save : Ctrl + S Home-Clipboard contain tools Cut:- Cut the selection input it on the clipboard Copy: - Copy the Selections putting on the clipboard Format painter: Copy formatting from one applies it to another. Place Paste:- Paste the selected text or image Home Font contain toolbars Bold: - Make the selection Bold Italic Italicize The selected text Underline:- Underline the selected text Strikethrough:-Draw a line through middle of the selected text Subscript :- creates small letters below the text. Font colour-Change the text coder Increase the font size - A crow font (AAAA Decrease the font -size - Shrink font (Anna) 1 Created By: Rahul Ravankar Home paragraph tool bar contain Align to left: Text is aligned to the left Align to the centre Text is aligned in the centre Align to me right: Text is aligned to the right Justify: - Text is aligned from left side equally margins adding extra space between words Border: gives border to pages, paragraph text Bullets: gives bullets using different styles & symbols. Decrease indents Decreases indent level of the Paragraph. Increase indents Increases indent level of the paragraph. Shading: Colour the background behind the selected text paragraph. Home toolbar contains → Clipboard, font, Paragraph, Styles & editing. Home editing toolbar contains →Find: It finds the given word from the document Replace:- Replaces The selected word from the document Insert-Pages tools contain. Cover page → Insert a fully formatted cover page Blank page Insert new blank page at the cursor Position Page break Start the next page at the current position. Based Insert table Design tools contain Table style options, Table styles, Draw borders. 2 Created By: Rahul Ravankar Watermark: Insert text/image behind the page Insert table layout contain tools. → Table, Rous columns, Merge, Cell size, Alignment Data Insert tool contains → Pages, Tables, Illustrations, links, Header footer & Text, Symbol. Insert Illustrations too contain →Picture, Clip Art, Shapes, Smart Art, Chart, Screeshot. Insert Text tool contains →Textbox, Quick Parts, Word Art, Drop Cap, Signature Line, Date & Time, Object. Page layout tools contains →Themes, Page setup, Page background, paragraph. Page layout themes tools contain. →Themes - Changes overall design of the entire dae inclucting color, fonts's effects Colour Change colour of the current Themes. In Page layout Page setup tools contain →Margins Gives margin sizes for the entire document Orientation Switch pages between Portraits & Landscape. Size: - Choose paper size for the current page. Columns Split text into two or more columns Breaks Add page, selection or column break to the document in the Line Numbers Add line number along margin In Page layout Page background tools contain →Watermark Insert text behind the content of the page Page color Gives color for the background of the page borders Applies border around the page Insert Table layout Rous column tool contain →Delete rows, columns, cells on the entire table, 3 Created By: Rahul Ravankar In table layout Merge tool contains. → Merge cells Merge the selected cells to one cell. Split cell-Split the selected cells to multiple new cells. Split table split table into two tables. Uses of Mail Merge → Create a form letter which you intend to print or email multiple times, sending each copy to a different recipient. Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spread sheet, or database, is associated with the document Shortcut formula Ctrl+A Select all contents of the page Ctrl+B Bold highlighted selection Ctrl+C-Copy Selected text Ctrl+x - Cut selected text Ctrl + N - Open new/blank document Ctrl+P - Open the print window Ctrl+ I- Italicism highlighted selection. Ctrl+U - underline highlighted selection Ctrl + Y-Redo the last action performed Ctrl + 2-Undo last action Ctrl + J-Justify paragraph alignment Ctrl+ W-Close document Ctrl+S- Save 4 Created By: Rahul Ravankar Steps by step to replace word "Goa" with "India" →Select replace Find what "Goa" Replace with "India Replace All Uses of MS word in daily life →Creating text documents, Editing formatting the documents, Graphical documents, comprising images MS Word enables users to do write-ups, create documents, resumes, contracts, etc.  Used for Business  Used in Education  Used in Home based  To create resumes notes & assignments. Change Case contain → Sentence case, lowercase, Uppercase, Capitalize each word, and toggle case. 5 Created By: Rahul Ravankar  MS Excel Home-Alignment contains tools. Wrap text – Makes all content visible within a call by displaying it on multiple lines Merge & Centre: - Joins the selected cello into the larger cell & centres the contents in the new cell Orientation – Rotate text to a diagonal angle on Vertical Orientation. Decrease indent: - Decrease the margin between the border & the text in the cell. Increase indent: - Increase the margin between the border & the text in the cell.  Align text to left  Align text in centre  Align text in right  Justify  Top Align  Middle Align  Bottom Align Home-Number tool contains Currency: The Currency data type is for inputting currency values with a specific currency symbol. (%) percentage- Display value of the cell as percentage Comma- Increase decimal - 1001 1001.00 Decrease decimal - 1001.00 1001 Different types of charts →Column, line, Pie, Bar, Area, XY Scatter, Stock, surface, Doughnut, Bubble, Radar Insert-Text tool contains  Text box-  Header & footer  Word Art  Signature line  Object 1 Created By: Rahul Ravankar Uses of Excel cin Daily life  Quick Calculation  Expense Management  Data visualization  Performance reporting  Attendances tracing  Sales Inventory Trackers  Data Filtering... Function IF Checks whether a condition is met, & returns one value if true, & another value is false. Eg:- If (logical test, value- if true, value if fake) Count if -> Courts the number of cells within a range that meet the given condition. Eg:- =countif(D5:D11,”