COMPUTER COURSE FEE DETAILS

cybotech computers

SHORT CUTS

More than 100 Keyboard Shortcuts must read
SHARE IT........

Keyboard Shorcuts (Microsoft Windows)
1. CTRL+C (Copy)
2. CTRL+X (Cut)
3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9. F2 key (Rename the selected item)
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the selected item)
18. ALT+F4 (Close the active item, or quit the active program)
19. ALT+ENTER (Display the properties of the selected object)
20. ALT+SPACEBAR (Open the shortcut menu for the active window)
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneou sly)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop)
25. F4 key (Display the Address bar list in My Computer or Windows Explorer)
26. SHIFT+F10 (Display the shortcut menu for the selected item)
27. ALT+SPACEBAR (Display the System menu for the active window)
28. CTRL+ESC (Display the Start menu)
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
30. F10 key (Activate the menu bar in the active program)
31. RIGHT ARROW (Open the next menu to the right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left, or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing)

Dialog Box - Keyboard Shortcuts
1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the options)
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
6. ENTER (Perform the command for the active option or button)
7. SPACEBAR (Select or clear the check box if the active option is a check box)
8. Arrow keys (Select a button if the active option is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft Natural Keyboard Shortcuts
1. Windows Logo (Display or hide the Start menu)
2. Windows Logo+BREAK (Display the System Properties dialog box)
3. Windows Logo+D (Display the desktop)
4. Windows Logo+M (Minimize all of the windows)
5. Windows Logo+SHIFT+M (Restorethe minimized windows)
6. Windows Logo+E (Open My Computer)
7. Windows Logo+F (Search for a file or a folder)
8. CTRL+Windows Logo+F (Search for computers)
9. Windows Logo+F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo+R (Open the Run dialog box)
12. Windows Logo+U (Open Utility Manager)
13. Accessibility Keyboard Shortcuts
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off)
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off)
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
19. Windows Logo +U (Open Utility Manager)
20. Windows Explorer Keyboard Shortcuts
21. END (Display the bottom of the active window)
22. HOME (Display the top of the active window)
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder)

MMC COnsole Windows Shortcut keys

1. SHIFT+F10 (Display the Action shortcut menu for the selected item)
2. F1 key (Open the Help topic, if any, for the selected item)
3. F5 key (Update the content of all console windows)
4. CTRL+F10 (Maximize the active console window)
5. CTRL+F5 (Restore the active console window)
6. ALT+ENTER (Display the Properties dialog box, if any, for theselected item)
7. F2 key (Rename the selected item)
8. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote Desktop Connection Navigation
1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from left to right)
3. ALT+PAGE DOWN (Switch between programs from right to left)
4. ALT+INSERT (Cycle through the programs in most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.)

Microsoft Internet Explorer Keyboard Shortcuts
1. CTRL+B (Open the Organize Favorites dialog box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser with the same Web address)
8. CTRL+O (Open the Open dialog box,the same as CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web )

SHARE IT WITH YOUR FRIENDS

abacus

vacation computer courses

 

 

COMPUTER BASE

DIGITAL SUMMER CAMP

PUBLISHED BY

 RESEARCH TEAM

 SDCT, THIRUVANANTHAPURAM

COMPUTER

Computer is an electronic device that can perform a variety of operations in accordance with a set of instructions called program.

Features of computer

1.      Speed

2.      Storage capacity

3.      Accuracy

4.      Reliability

5.      Versatility

Parts of a Computer

            Basically a computer has three parts, they are:

1.      Input Unit

2.      CPU (Central Processing Unit)

3.      Output Unit

Block diagram of a Digital Computer

Input Unit

            It is the unit meant to receive the data and instruction contain in program. In other words it is the unit through which the programmer communicates with the computer.

Eg: Keyboard, Mouse, Scanner, MICR, OCR, etc…

CPU (Central Processing Unit

            It is the   brain of the computer that actually under stand and executes all the instructions. The CPU comprises three distinct parts, namely Memory Unit, ALU (Arithmetic & Logic Unit and Control Unit.

ALU (Arithmetic & Logic Unit)

This is the place where actual execution of the instruction takes place during the data processing. The ALU is capable of performing the basic arithmetic operations such as addition, subtraction, multiplication, division and some of the logical operations.

Memory Unit

            Memory Unit is the section where all data, program and results are stored. The memory of the computer is classified into Primary Memory and Secondary Memory.

Primary Memory

            It is also called computers main memory. All data information which are to be processed by the computer, are kept ready in this memory. The results obtained after processing in the arithmetic and logic unit are also stored in main memory.

                        Commonly used primary storage devices are:

1.      RAM –Random Access Memory

2.      ROM – Read Only Memory

Secondary Memory

            The programs and data which require any further use are stored in a Secondary Memory. Recording, erasing and rerecording for a number of times are possible in an auxiliary storage.

            Commonly used Secondary Storage devices are:

1.      Floppy Disk

2.      Hard Disk

3.      Magnetic Disk

4.      CD ROM

Output Unit

           It is the unit meant to display the result of computation from the memory. Some of the Out put devices produce only a temporary copy of a result (like the monitor), while some others produce a permanent copy (like the printer)

                         

MICROSOFT WORD

                        Microsoft Word is a word processing package. This refers to create documents, store and manipulate them for editing or formatting

Elements of MS Word

Title bar- Display the ms-word title with file name.

Menu bar- Display the menus and pull down menus of word.

Standard tool bar- A bar with buttons that performs some of the most common task in word such as new, open save, print….etc

Formatting tool bar- A bar with buttons and options used to apply commonly used to format such as bold italic, font, size, etc

Work area – Typing areas of Ms Word.

Status bar- The bar at the bottom of word window that display information about the current status document

Menus of word

            File, Edit, View, Insert, Format, Table, Windows, Help

File menu commands

New – Create a blank document.

Open – opens an Existing document.

Close – Close the active document.

Save – Saves the active document.

Saves – Saves the active document with different names.

Page setup- Change margin and size.

Print preview – Show a document look when you print it.

Print – Controls how document is printed.

Edit Menu Commands

   

Undo – Reverses one or more changes made in a document.

Redo – Repeat the action cancelled with the undo operation.

Cut – Removes a selected text from the document and place it in the clipboard.

Copy – Copies a selected text to the clipboard.

Paste – Insert a copy of clipboard contents at the selected place.

Clear – Deletes a selected text.

Select All – Selecting the document of entire document.

Find (ctrl+f) - Searches for specified text from document

Replace (ctrl+f)-Searching a particular text and replacing it with another word.

Go to (ctrl+f) - Finding a page, lines, Book mark etc

View Menu Commands

Normal- Displays document in a simple view

Outline - Displays the heading levels with paragraph levels.

Page layout View – A WYSWYG (What you see is what you get) view that allows us to see what the page will look when printed.

Full Screen- Hides all screen elements and display the contents of documents in full screen.

Tool Bar – Displays or hides the entire tool bars in word.

Ruler- Displays or hides the vertical and horizontal ruler lines

Header and Footer- Adds special text or graphics words repeats top of every page (header) and bottom of every page (footer).

Zoom-

Insert Menu Commands

Break- Insert a page break, column break, and sections break at the insertion point.

Page Number- Inserts page numbers with in a document.

Step:

    

1.      Insert –Page Number

2.      Select the  location and Position

3.      Click ok button

Date and Time- Insert the date and time in the different format.

Symbol- Insert special character to the document.

Foot Note- Inserts a footnote or endnote for a selected text.

     Foot note- Foot notes are placed at the end of the page

     End note- End notes are placed at the end of the document

Picture- Inserts a graphic or picture created in another application.

Object- Inserts a drawing object from another application.

Hyperlink- To link a word or picture with a file.

 Step

1.      Select the text or picture to hyper link.

2.      Insert – hyper link.

3.      Click Browse for file button.

4.      Select the file we want to link and ok.

Format Menu Commands

Font – font tab

1.      Font – Use to select a font name.

2.      Font style – Select a style.

3.      Size – Selecting a size

4.      Under line – Select the type of under line.

5.      Color – select the color of selected text.

6.      Effect – Select a combination of effect.

Paragraph – Controls the appearance of paragraph by indentation and text below.

            Indents – left and right boundary of selected text.

Types of indents

1.      Left indent

2.      Right indent

3.      first line indent

4.      hanging indent

Alignment

1.      Left alignment

                Aligns the text at the left indent.

2.      Right alignment

                   Align selected text at the right indent.

3.      Centered alignment

                     Centers selected text between the left and right indents.

4.      Justified alignment

                   Expands spaces in to lines to align text evently between the left and right indent

Boarders and Shading

           Add boarders and shading to selected paragraphs, table, cell and frames.

Columns

         Change the number of columns in a selected document.

Change case

          Change the selected characters to upper case, lower case, etc.

1.      Sentence case – Capitalizes the first letter of first word in a sentence.

2.      Upper case – Changes to the selected text to upper case.

3.      Lower case – Changes to the selected to lower case.

4.      Toggle case – Changes uppercase letters to lower case and lower case letter to uppercase.

5.      Title case - Capitalize the first letter of each word in the selections.

Bullets and Numbering

Formats bullets and styles with in a list.

 Back ground

                  This option is used to change the background color.

Style

           This command is used to create modify or apply a style for a selected text.

Tools Menu Commands

Spelling- Checks the spelling in the active document

Options- 

1. Change – Select word form suggestions list and replaces it in the position of original word.
2. Ignore -   Does not correct the spelling of the current  word.

Grammar

     Checks the documents for possible grammar and style errors and displays suggestions for correcting them.

Auto correct

    Customizes the settings used to correct text automatically as you type.

Protect Document

     Allow temporary protection for a document.

Macro

    A Macro is a series of keystrokes and mouse links that can be called with the simple click of the mouse.

Table Menu

Insert table: Insert a table with number of rows and columns with a specified column width.

Delete cells: Delete the selected cells in a table

Split cells: Split a cell horizontally in to multiple cells

Merge cells: Combine the contents of adjacent cell into a single cell.

Select table: Select the entire table. Short cut Alt+5

Sort: Arranges the information of selected rows alphabetically, numerically or by data

Split table: Divides a table into two parts and inserts a paragraph mark above the splited row

New window of Microsoft Word 2007

MICROSOFT EXCEL

It is a standard Spread Sheet Software package developed by Microsoft Corporation, USA. It is used extensively in preparing budgetary reports, Profit and Loss accounts etc. 

Work Book   

            A blank document in MS Excel Window is called an Excel Workbook. A work book is a large are consisting of 65,536 rows and 256 columns. The intersection of each row and column is called a cell.

Formula Bar

            The formula bar is located just below the formatting toolbar. It shows the address of the active cell, name of the place, where the cell pointer is located and the contents of the active cell.

Copying and moving worksheets

     One or more selected worksheets can be copied within and between workbooks.

Inserting an Deleting worksheets

     Work book can be expanded or contracted by inserting or deleting work sheets.

*Choose Insert – Work sheet from the menu bar to insert a new worksheet or right                               click on one of the selected sheet tabs and select insert from the shortcut menu.

*Choose Edit- Delete sheet from the menu bar or right click on the sheet and choose the delete from the shortcut menu.

Columns width and Rows Height

              If the data which is entered into the cell is bigger than the width of the column, It is partially visible. The column width can be adjusted by the following steps.

              *Select the column

               *The column option is selected from the format menu.

                *Click on the width …. option. A dialog is displayed.

                *type the required of the column in the text box column width.

         Similarly the rows height can also be adjusted by selecting the rows….option from the Format menu.

Auto Format

The predesigned formats allow you to apply a standard format to all or part of a worksheet.

*Select the portion of the worksheet you want to auto format.

*Choose format –Auto format from the menu bar to open the Auto format dialog box.

 * Choose any format which you want

* Click the options buttons to show format to apply and deselect any option which you do not want to show click OK.

Conditional Formatting

Using Conditional formatting formats can be applied to selected cells based on the condition.

Formula

            In a spreadsheet one of the powerful feature is of formulas. Formulas can be used to perform calculations involving addition, substration, division and multiplication. In excel formulas begins with an equal sign.

Functions

            Functions are built in special programs which accept data, known as arguments, and return a value after performing calculations on the data. The different types of functions are statistical function, mathematical function, text functions etc.

New window of Microsoft Excel 2007

MICROSOFT POWER POINT

                        Power point is used to create Professional quality presentations. It allows as creating the presentations with text pictures, sound and animations.

Power point views

1. Slide view
2. Outline View
3. Slide sorter view

Slide Transition

            Transition control the way in which, each slide will appear as its opens on the slide show screen.

To open Slide Transition dialog box Choose Slide show à Slide Transition.

Animation

            We can change the order in which objects enter the slide and the manner in which each object on the slide.

            To changes the settings for an object.

                        Choose Slide Show à Custom Animation

                        In custom animation we can set

                                    - The timing

                                    - Control when sounds and text items are introduced.

                                    - Determine how we want charts animated

- Set play settings to control when and if an object is animated on   the slide.

Running a Slide Show

                        To run a slide show

                                    Click Slide Showà View Show

New window of Microsoft Powerpoint  2007

                                   

INTERNET

                        Internet is a world wide network of computers. It consists of millions of computers connected to each other and capable of exchanging data and information by using communication links such as telephone lines fiber optics satellite and other Medias.

WWW – World Wide Web

                        World Wide Web is the collection of all types of information stored in millions of computers connected to the internet.

E-Mail

            Electronic mail or E-mail is a simple tool for sending and receiving brief text messages between individuals or among larger audiences.

GIMP

GIMPis an acronym for GNU Image Manipulation Program. It is a freely distributed program for such tasks as photo retouching, image composition and image authoring.

Starting GIMP

                        Start à Programs à GIMP

                                    Now we get a small window, containing many tool and options on screen.

            To create a new file,

                                    Click new from the file menu, we get a dialog box, give the width, height and resolution of the file and then click ok.

Tools in GIMP

Rectangular selection tool

            Elliptical selection tool

            Hand- drawn selection tool

            Bezier curves selection tool

            Image shapes selection tool

            Selection Tool

            Pick color tool

            Zoom in and out tool

            Distance and Angular measurement tool

            Move Layer and selection tool

            Cut & Resize tool

            Rotation tool

            Shearing tool

            Change the mode of vision tool

To turn the layer tool

Text tool

Fill with color or pattern

            Fill with color gradient

            Pencil tool

            Brush tool

            Eraser tool

            Spray colors

            Pen tool

            Pattern tool

             

Change background color

            Click Black rectangle on the tool box

            We will get a dialog box , Select the required color

OUT PUT DEVICES

CLASSIFICATION OF COMPUTERS ACCORDING TO SIZE