ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY PROGRAM OUTCOMES (POs) A B.Tech – graduate should possess the following:

1. Engineering knowledge: Apply the knowledge of mathematics, science, engineering fundamentals, and an engineering specialization to the solution of complex engineering problems.

2. Problem analysis: Identify, formulate, review research literature, and analyze complex engineering problems reaching substantiated conclusions using first principles of mathematics, natural sciences, and engineering sciences.

3. Design/development of solutions: Design solutions for complex engineering problems and design system components or processes that meet the specified needs with appropriate consideration for the public health and safety, and the cultural, societal, and environmental considerations.

4. Conduct investigations of complex problems: Use research -based knowledge and research methods including design of experiments, analysis and interpretation of data, and synthesis of the information to provide valid conclusions.

5. Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern engineering and IT tools including prediction and modeling to complex engineering activities with an understanding of the limitations.

6. The engineer and society: Apply reasoning informed by the contextual knowledge to assess societal, health, safety, legal and cultural issues and the consequent responsibilities relevant to the professional engineering practice.

7. Environment and sustainability: Understand the impact of the professional engineering solutions in societal and environmental contexts, and demonstrate the knowledge of, and need for sustainable development.

8. Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of the engineering practice.

9. Individual and team work: Function effectively as an individual, and as a member or leader in diverse teams, and in multidisciplinary setti ngs.

10. Communication : Communicate effectively on complex engineering activities with the engineering community and with society at large, such as, being able to comprehend and write effective reports and design documentation, make effective presentations, and give and receive clear instructions.

11. Project management and finance: Demonstrate knowledge and understanding of the engineering and management principles and apply these to one’s own work, as a member and leader in a team, to manage projects and in multidisciplinary environments.

12. Life -long learning: Recognize the need for, and have the preparation and ability to engage in independent and life -long learning in the broadest context of technological change.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY PREFACE The purpose of any Workshop is Learning -by-Doing and the objective of IT Workshop is to impart knowledge about the computer hardware, computer maintenance and a suite of

productivity tools which will help the students during their four year course of study. The workshop facilitates the students with basic applied knowledge of computers through well -defined h ands -on exercises.

The various concepts covered in the workshop include training on PC Hardware, Internet usage and Productivity tools of MS -Office suite like Word, Excel, PowerPoint and Google forms . PC Hardware introduces the students to the working of a personal computer and its basic peripherals, the process of assembling and dis -assembling a personal computer, installation of system software like MS Windows; In addition tips and tricks of

hardware and software troubleshooting process would be covered. Internet & World Wide Web module teaches the different ways of using the internet, efficient usage of web browsers, email, newsgroups etc. Also, awareness of cyber hygiene, i.e., protecting the personal computer from the onslaught of viruses, s pyware and other cyber attacks would be covered.

The modules dealing with MS -Office Suite will equip the students with all the skills required to prepare professional word documents for technical writing; to perform computations and data analy sis using excel spreadsheets; and to design visually appealing PowerPoint presentations. The Module of Google forms will supplement their knowledge of Creating forms surveys and quizzes as well as collaborate edit and share the forms with

other people. The workshop also aims at cultivating the technical skills along with the right attitude in the students, through one -to-one interaction and proper teamwork.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY I Year B.TECH - II SEM L/T/P/C -/-/2/1

(R22A0083) ENGINEERING AND COMPUTING HARWARE WORKSHOP It is consisting of 2 parts: Part I: Comput ing Hardware Workshop Part II: Engineering Workshop COURSE OBJECTIVES:

 Understand the internal structure of computer system and learn to diagnose minor problems with the computer functioning.

 Know the proper usage and threats of the World Wide Web & Study in detail about the various features of Ms -Word, Excel, PowerPoint and Google Forms  To obtain the knowledge about Electrical wiring and S oldering – Desoldering procedures.

 To provide hands on experience in usage of different engineering materials, tools equipments and processes which are common in the engineering field.

 To develop professional attitude, team work, precision and safety pract ices at work place.

Part I: COMPUTING HARDWARE WORKSHOP Task - 1: PC HARDWARE Identification of the peripherals of a computer, components in a CPU and its functions.

Block diagram of the CPU along with the configuration of each peripheral. Functions of Motherboard. Assembling and Disassembling of PC. Installation of OS. Basic Linux commands.

Task - 2: TROUBLESHOOTING Hardware Troubleshooting: Students are to be given a PC which does not boot due to proper assembly or defective peripherals and the students should be taught to identify and correct the problem.

Software Troubleshooting: Students have to be given a malfunctioning CPU due to system software problems. They should identify the problem and fix it to get the computer back to working condition.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY Task 3: INTERNET Web Browsers, Access of websites, Surfing the Web, Search Engines, Customization of web browsers, proxy settings, bookmarks, search toolbars, pop -up blockers. Antivirus

downloads, Protection from various threats.

MS OFFICE Task 4: MICROSO FT WORD Overview of MS word features. Usage of Hyperlink, Symbols, Spell Check, Track Changes.

Table of Content, Newspaper columns, Images from files and clipart, Drawing toolbar and Word Art, Formatting Images, Textboxes, Paragraphs and Mail Merge in word . Using Word to create Project Certificate, Project Abstract, News Letter, Resume.

Task 5: MICROSOFT EXCEL Overview of Excel Features Excel formulae & Functions, conditional formatting, Charts, Hyper linking, Renaming and Inserting worksheets, Data Analysi s functions.

Creating a Scheduler (Features : - Gridlines, Format Cells, Summation, auto fill, Formatting) Calculating GPA (Features : - Cell Referencing, Formulae and functions in excel Task 6: MICROSOFT POWER POINT Overview of PowerPoint features, Insertio n of images, slide transition, Custom animation, Hyperlinks.

Task 7: GOOGLE FORMS Google forms introduction, opening Google forms, editing forms, add questions, copy duplicate questions, delete questions, required questions, more button, form color and themes, preview form, advance form settings, send form, view responses, close form PART II: ENGINEERING WORKSHOP

A. List of Experiments:

1. Residential house wiring using switches, fuse, indicator, lamp and energy meter.

2. Fluorescent lamp wiring 3. Stair case wiring 4. Soldering and Desoldering practice – components, devices and circuits using general Purpose PCB.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY B. TRADES FOR EXERCISES:

At least two exercises from each trade:

1. Carpentry:

To prepare T -Lap Joint, Dovetail Joint.

To prepare Mortise & Tenon Joint.

2. Fitting:

To prepare V -Fit, Dovetail Fit & Semi -circular fit.

3. Tin-Smithy:

To make Square Tin, Rectangular Tra y & Conical Funnel.

Trades to demonstrate:

1. Plumbing 2. Foundry 3. Welding 4. Black smithy 5. Metal cutting (Water Plasma)

TEXT BOOKS – IT WORKSHOP 1. Introduction to Information Technology, ITL Education Solutions limited, Pearson Education 2. Excel Functions and Formulae, Bernd held, Theodor Richardson, Third Edition TEXT BOOKS – ENGINEERING WORKSHOP

1. Workshop Manual, P. Kannaiah and K. L. Narayana, 3rd Edition, Scitech,2015 2. Printed Circuit Boards - Design, Fabrication, Assembly and Testing, R. S. Khandpur, Tata M cGraw -Hill Education, 2005.

COURSE OUTCOMES:

 Ability to identify, assemble and troubleshoot the major components of a computer and perform the installation of Operating System.

 Capacity to make effective usage of the internet for academics and develop professional documents, spreadsheets and presentations.

 Students will be able to understand the domestic, illumination, stair -case wiring procedures and soldering de soldering practice  The student will have hands -on experience on manufacturing of compone nts using different trades of engineering processes  The student will be able to perform in a team, adhering to industrial safety practices

and follow professional working standards.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY INDEX Task No. Topic Page No.

1 PC HARDWARE 1 2 TROUBLESHOOTING 23 3 INTERNET 27 4 MICROSOFT WORD 37 5 MICROSOFT EXCEL 57

6 MICROSOFT POWER POINT 99 7 GOOGLE FORMS 111 ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 1 | P a g e TASK 1

PC HARDWARE Identify the peripherals of a computer, components in a CPU and its functions.

A peripheral device is an internal or external device that connects directly to a computer but does not contribute to the computer's primary function, such as computing. It helps end users access and uses the functionalities of a computer.

Types of Peripheral Devices There are many different peripheral devices, but they fall into three general categories:

1. Input devices, s uch as a mouse and a keyboard 2. Output devices, such as a monitor and a printer Storage devices, such as a hard drive or flash drive 3. The central processing unit (CPU) of a computer is a piece of hardware that carries out the instructions of a computer program. It performs the basic arithmetical, logical, and

input/output operations of a computer system. The CPU is like the brains of the computer - every instruction, no matter how simple, has to go through the CPU.

A typical CPU has a num ber of components. The first is the arithmetic logic unit (ALU), which performs simple arithmetic and logical operations. Second is the control unit (CU), which manages the various components of the computer. It reads and interprets instructions from memor y and transforms them into a series of signals to activate other parts of the computer. The control unit calls upon the arithmetic logic unit to perform the necessary

calculations. Third is the cache, which serves as high -speed memory where instructions ca n be copied to and retrieved.

A computer can process data, pictures, sound and graphics. They can solve highly complicated problems quickly and accurately.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 2 | P a g e Input Devices The device which are connected to computer and they are used to send the data to th e computer internally, are known as the input devices. Following are some important input

devices .

Mouse: Mouse is the one of the most common device that one would find in a desktop. It is normally plugged with the USB connection. It would be connected t hrough the PS/2 port which is located on the back of the computer. In older system, one might find the serial port which was used to move the move around. The old mouse contained ball inside of it which helped it move. But nor the trend has changed the mou se that one uses contains some LED

light. They are called the laser mouse. The LED light now emits out of the mouse sensing that where the mouse is being moved. The installation of mouse is easy, one can just plug the mouse and the drivers would be searche d by windows itself. The mouse can be configured from the control panel where the speed of it can be improved.

Keyboard: it is the famous device that is being used today and it is connected through a USB connection at the back of the computer. Old keyboar ds used to have the Mini DIN PS/2 connection with them; one would have to go through the manufacturer's website to know that what are the drivers for the keyboard and then can get them installed when he connects the keyboard with the computer.

Touch screen: Touch screen is becoming common as well. They are normally used on the mobile phones and other smart devices. Also, the tablets also contain this feature. Now it is even common to find a computer's large screen which works with the touch screen sys tem.

It makes it very easy to type and navigate and one can bring the keyboard on the screen and type it there as well hence one doesn't have to install the keyboard. The configurations and the installation of the touch screen are also done in a display wh en it is bought.

Scanner: At a time, the fax machines were widely used by the people and till now, they use it. But now the tables have turned and people tend to use the scanners. The scanners have the ability to turn the paper's image into a digital one hence sending the data from one place to another while keeping the same paper with us is now an easy task and the data can be sent more easily through the internet. The scanners are now used a lot and one can

simply scan a paper and save it in any format h e wants to.

Barcode reader: If one goes to some super market or the retail environment, one would see the barcode. It's a machine that is used to read the code which is printed at the back of the products. The connection of the bar code is normally made through the USB connection.

Some old versions of the bar codes also use the PS.2 connections to get connected to the computer. The barcodes use the laser technology to read the barcode. The light comes and goes when the code is exposed to the barcode reader. This eye can directly dama ge one's eye as well so one has to be careful while using this machine. The barcode contains a specific driver when it is connected, the driver is detected by the windows and hence it can

work properly.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 3 | P a g e KVM: If one is working in an environment where there is a single display but there are many different computers connected to it, the one is using the KVM. KVM means the keyboard, video and the mouse. Here if one wants to move to another device, he just has to push a

single button to get to other device. Thi s set can be centralized and the KVM can be used to switch between all the computing devices .

Microphone: the putting of voice in our computer is very common. It is done by the chat or it is even done for the voice reorganization software's which are avail able in the market.

Microphones on not only at the headset, but they can be found separately and are there in the laptops as well. They also have the specific drivers and the configuration can be made through the control panel.

Biometric devices: these dev ices are used as the security tools. They are mostly used on some portable devices which tend to go away from one. If one tries to use the laptop, he might find there is a finger print reader there and hence it is protected since only the administrator who has set it up can log in to the computer .

Game pads: Game pad is the wonderful thing for the gamers. It allows the gamers to have some control over the gaming experience.

Joysticks: it is the gaming input which is widely used. It is a stick which has many buttons on it.

Digitizer: the digitalizing pad has some specialized pins that allow the user to draw on it very carefully and accurately. They are for those who have got some artistic abilities and they are installed with the driver.

Touch Screen Biometric Device KVM ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 4 | P a g e Multimedia devices Digital cameras: the digital cameras are the standalone cameras which are used by the

individuals. These days almost everyone has got a digital camera and they are even embedded into the mobile pho ne where they can be used to take picture. The digital cameras when connected to the PC for transfer of pictures require the driver to get installed and that driver comes with the accessories .

Microphone: if one wants to do some conferences or the voice chat, he would be meeting the microphone. They are available as the separated ones as well which can be easily used.

They are normally connected through some USB connection and there is the digital connecto r which is associated with it to provide the high quality.

Webcam: Having a video is now a great need of the everyday life. Now it is very common to find some built in cameras into the displays which are being used these days. Specially, they are so commo n in the laptop and if they are not present, it is pretty common to get it connected and it is done pretty cheap amount. One can also enjoy the live video if it is plugged through the 802.11 wireless connections which go into the USB connection in the

comp uter.

Camcorder: Most of the video conference has to be recoded and hence one needs the camcorders. They are normally done for some live videos. Normally those people, who upload videos on the video sharing websites like YouTube etc., use this tool to rec ord the videos and then can upload them on the PC, were after editing, they can upload it on the website. They are not only into the digital cameras but they can be found easily on every

laptop and almost every mobile phone so one can record anything anyti me without any hustle. The video is stored in the flash memory. There is mostly having the large storage capacities in the digital cameras so that the videos can be recorded no matter how big they are. For transferring the videos off the camera, one would need a Fire wire , it is a kind of direct HDMI connection and it can be used to display the video immediately on some

display.

MIDI enabled devices: MIDI stands for the Musical Instrument Digital Interface. It is actually a device which is musical one and can digitalize all of the information and can transfer it to the computer in some really standard way. Many of the application which contains these capabilities of the music use this midi as the standard format so that the information can be getting in and out of the computer. It is common to get these devices plugged into the

computers with the help of some Ethernet cables and even the USB cables. While on the different side there in instrument is coated, the large din connections are used to get connected between the commuter and the device.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 5 | P a g e Webcam Camcorder MIDI enabled device Microphone Digital Cameras Output Devices:

Output devices are those devices which do not send the data into the computer, in fact through these devices, the computer communicates with the user. Some of these output devices are as follows; Printers: if one has the data in the computer, it is obvious that he has to take it out of the computer. There are several ways for it and one of them is the painters. These printers are

available not only in the office environment and in some retail environment, bu t at the homes as well. One might need the printer to take out the prints of the important information he finds on the internet or the assignment which he creates. At office, many important documents are sent and received in the digitalized format and they have to be converted to the hard copy so they can be read easily. At the shops, one might find the

painters which are used for printing out the receipts which are handed over to the customers. Hence printers are used in every aspect of the busy life. Prin ters have various types and the laser printers are the most famous type since they print really good. For printers there is much software and one must install the appropriate drivers to get them work. The configuration of the printer can be done manually o nce it is connected to the

computer.

Speakers: many of the features which are used by us are mainly related to the audio.

Doesn't matter whether one listens to the podcasts or plays music, He would need the audio to be heard. Even while watching the movie or some educational video, hearing the voice is really important part and for that purpose, one needs the speakers. The laptop contains the right left speakers which are located at these both sides. There is also a subwoofer which can be used for th e mixing of the voice. Also, one can have some

advanced computer speaker which can be plugged into the computer externally for the sake of better quality of the sound. The laptops have various options which are provided to user so that he can hear the soun d with different options.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 6 | P a g e Display devices: one of the most integral parts of the PC is the display devices which are used. The human beings need to see that what's going on the operating system and to get in touch with the interface, they must have some d isplay device which can show them the

appropriate amount of data. Normally the display devices are pretty thin and one has many options for the display devices and they vary in prices range as well. These device can be both non touchable and the Touch Scre en. These display devices are not just connected to the computers; instead they are connected to the mobile phones as well. Also the Tablets contain some display devices as well. These displays show us what is exactly going on there

and how we can control the computer The Mother Board The important constituent components of an ATX Motherboard are given below:

There are primarily two types of motherboards, AT motherboard, and ATX motherboard.

The AT and ATX motherboards differ in the form factor. Full AT is 12" wide x 13.8" deep, and Baby AT is 8.57" wide x 13.04" deep. Full -ATX is 12" wide x 9.6" deep and Mini -ATX is 11.2" wide x 8.2" deep. Other major differences include power supply connector, and keyboard connector. AT has 5 -pin large keyboard conn ector, whereas ATX has 6 -pin mini connector.

Similarly, AT has single row two connectors +/ -5V, and +/ -12V, whereas ATX motherboard has double row single connector providing +/ -5V, +/ -12z, and +3.3V.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 7 | P a g e USB (Universal serial bus): USB is the General -purpose connection for PC. You can find USB versions of many different devices, such as mice, keyboards, scanners, cameras, and even printers. a USB connector's distinctive rectangular shape makes it easily recognizable.

USB has a number of feature s that makes it particularly popular on PCs. First, USB devices are hot swappable. You can insert or remove them without restarting your system.

Parallel port: Most printers use a special connector called a parallel port. Parallel port carries data on more than one wire, as opposed to the serial port, which uses only one wire.

Parallel ports use a 25 -pin female DB connector. Parallel ports are directly supported by the motherboard through a direct connection or through a dangle.

CPU Chip: The central processing unit, also called the microprocessor performs all the calculations that take place inside a pc. CPUs come in Variety of shapes and sizes. Modern CPUs generate a lot of heat and thus require a cooling fan or heat sink. The cooling device (such as a cooling fan) is removable, although some CPU manufactures sell the CPU with a fan permanently attached

RAM slots: Random -Access Memory (RAM) stores programs and data currently being used by the CPU. RAM is measured in units called bytes. RAM ha s been packaged in many different ways. The most current package is called a 168 -pin DIMM (Dual Inline Memory module).

Floppy controller: The floppy drive connects to the computer via a 34 -pin ribbon cable, which in turn connects to the motherboard. A flo ppy controller is one that is used to control the floppy drive.

IDE controller : Industry standards define two common types of hard drives: EIDE and SCSI.

Majority of the PCs use EIDE drives. SCSI drives show up in high end PCs such as network servers or graphical Workstations. The EIDE drive connects to the hard drive via a 2 -inch -wide, 40 -pin ribbon cable, which in turn connects to the motherboard. IDE controller is responsible for controlling the hard drive.

PCI slot: Intel introduced the Peripheral co mponent interconnect bus protocol. The PCI bus is used to connect I/O devices (such as NIC or RAID controllers) to the main logic of the computer. PCI bus has replaced the ISA bus.

ISA slot (Industry Standard Architecture): It is the standard architecture of the Expansion bus. Motherboard may contain some slots to connect ISA compatible cards.

CMOS Battery: To provide CMOS with the power when the computer is turned off all other boards comes with a battery. These batteries mount on the motherboard in one of three ways: the obsolete external battery, the most common onboard battery, and built -in battery.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 8 | P a g e AGP slot : If you have a modern motherboard, you will almost certainly notice a single connector that looks like a PCI slot, but is slightly shorter and usually brown. You also probably have a video card inserted into this slot. This is an Accelerated Graphics Port (AGP)

slot.

CPU Slot: To install the CPU, just slide it straight down into t he slot. Special notches in the slot make it impossible to install them incorrectly. So remember if it does not go easily, it is probably not correct. Be sure to plug in the CPU fan's power .

Power supply plug in: The Power supply, as its name implies, pro vides the necessary electrical power to make the pc operate. The power supply takes standard 110 -V AC power and converts into +/ -12- Volt, +/ -5-Volt, and 3.3 -Volt DC power.

CPU (Processor ): The central processing unit (CPU, occasionally central processor unit) is the hardware within a computer system which carries out the instructions of a computer program by performing the basic arithmetical, logical, and input/output operations of the system.

SMPS (Switched mode Power Supply): A switched -mode power supply (switching -mode power supply, SMPS, or switcher) is an electronic power supply that incorporates a switching regulator to convert electrical power efficiently.

Cabinet : A computer cabinet is an enclosure with fitted, fixed or removable side panels and doors. The cabinet contains a computer rack for mounting computers or other electronic equipment.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 9 | P a g e CPU heat Sink and fan: A computer fan is any fan inside, or attached to, a computer case used for active cooling, and may refer to fans that draw cool er air into the case from the outside, expel warm air from inside, or move air across a heat sink to cool a particular

component.

RAM (Random Access Memory): RAM (random access memory) is the place in a computer where the operating system, application programs, and data in current use are kept so that they can be quickly reached by the computer's processor. RAM is much faster to read from and write to than the other kinds of storage in a computer, the hard disk, floppy disk, and CD-ROM. However, the data in RAM stays there only as long as your computer is running.

When you turn the computer off, RAM loses its data. When you turn your computer on again, your operating system and other files are once again loaded into RAM, usually from your hard disk.

HDD (Hard Disk Drive ): The hard disk is housed inside the hard drive, which reads and writes data to the disk. The hard drive also transmits data back and forth between the CPU and the disk.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 10 | P a g e SATA: The term SATA generally refers to the types of cables and connections. Serial ATA replaces Parallel ATA as the IDE standard of choice for connecting storage devices inside of computer.SATA storage devices can transmit data to and from the rest of the computer

much, much faster than an othe rwise similar PATA device.

CD-ROM Drive: Short for Compact Disc -Read Only Memory , a CD-ROM (shown right) is an optical disc which contains audio or software data whose memory is read only. A CD-ROM Drive or optical drive is the device used to read them. CD -ROM drives have speeds ranging from 1x all the way up to 72X, meaning it reads the CD roughly 72 times faster than the 1x version.

CD Writer: A CD writer is a piece of computer equipment that you use for copying data from computer onto a CD.

Different Screws Used : Screws are the hardware used to secure parts of a PC to the case.

Although there are numerous manufacturers of computer cases, they have generally used three thread sizes.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 11 | P a g e AGP (Accelerated Graphics Port) Card: Stands for "Accelerat ed Graphics Port." AGP is a type of expansion slot designed specifically for graphics cards LAN (Local Area Network) Card: A network interface card (NIC) is a computer circuit board

or card that is installed in a computer so that it can be connected t o a network. Personal computers and workstations on a local area network (LAN) typically contain a network interface card specifically designed for the LAN.

Exercise:

1. Draw the block diagram of the CPU along with the configuration of each peripheral .

2. Write software and hardware requirements of a PC ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 12 | P a g e Assembling and D e-Assembling of PC Preparations

Computer motherboards and expansion cards contain very delicate integrated circuit(IC) chips. To protect them against damage from static electricity, you should follow some precautions whenever you work on your computer.

1. Unplug your computer when working on the inside.

2. Use a grounded wrist strap before handling computer components. If you do not have one, t ouch both of your hands to a safely grounded object or to a metal object, such as the power supply case.

3. Hold components by the edges and try to not touch the IC chips, leads or connectors, or other components .

4. Place components on a grounded anti -static pad or on the bag that came with the components whenever the components are separated from the system.

5. Ensure that the ATX power supply is switched off before you plug in or remove the ATX power cod.

Assembling a Computer After buying all the computer components they must be put together. This process is called assembling. It usually takes about fifteen minutes (installing not included). Although easy, it must be done carefully so as to avoid unnecessary damage to the syste m.

Materials Required Make sure that you have all the below materials before starting.

All the necessary components  Processors  Motherboard  Hard disk  RAM

 Cabinet  Floppy Drive  CD Drive  Cards  Display Card (Not needed if On -board display is available on Moth erboard)

 Sound Card (Not needed if On -board sound is available on Motherboard)  Modem  Other Cards (If Any  Monitors  Keyboard

 Mouse  Speaker  UPS ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 13 | P a g e

Other Components (If Any) 1. Also keep the cables that came with the components close by 2. Head Screwdriver (also known as Star Screwdriver) 3. Flat head Screwdriver 4. Forceps (for pulling out jumpers and screws)

5. Magnetized Screwdriver 6. Multi meter (Testing) Computer Assembling Steps 1. Open the case 2. Connect the power supply

3. Attach components to the motherboard 4. Fix the motherboard 5. Install internal drives 6. Install drives in external slots 7. Install adapter cards

8. Connect all internal cables 9. Re-attach the side panels 10. Connect external cables to the computer 11. Boot the computer for the first time Computer Disa ssembly steps

1. Power off the system 2. Unplug power cables 3. Disconnect external cables from the computer 4. Detach the side panels /open the case 5. Disconnect all internal cables

6. Remove adapter cards 7. Remove drives from external slots 8. Uninstall internal drives 9. Unfix the motherboard 10. Detach the components from the motherboard

11. the power supply Exercise:

1. Write necessary components specifications in detail.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 14 | P a g e Basic Linux Commands Study of general purpose utilities commands .

1. Cal Command – To display a calendar.

# cal 2. script Command – make typescript of terminal session # script 3. echo Command - display a line of text.

#echo 4. printf Command - format and print data # printf 5. bc command – # bc

6. Who command # who 7. Whoami command #whoam i 8. tty command –

# tty 9. uname command – #uname 10. clear command – # clear

11. ls command – # ls  -l: list the file in long format  -t: list in order of last modification time.

 -a: list all entries, including hidden file.

 -d: list the directory file instead of contents.

 -u: list in order of last access file.

 -I: prints the inode number of file.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 15 | P a g e Study of file system navigation commands, text processing tools, communication commands 1. cat Command –

# cat > - -----Write file text --------- ------------------------------ - Ctrl+z 2. file Command – # file 3. wc Command –

# wc -l : prints number of lines along with file name.

-w: prints number of words along with file name.

-c : prints number of characters along with file name.

4. cp Command – # cp 5. rm Command – # rm 6. mv Command –

# mv 7. more Command – # more 8. head Command – # head

9. Tail Command – # tail 10. gzip Command – # gzip 11. gunzip Command –

# gunzip ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 16 | P a g e Study of VI editor VI editor is the default file editor in most of the Linux machines. It is having great capabilities

to edit a file within few key strokes. Lets start with some general information and then move on to some good things what vi editor can do for you while edi ting a file.

1. Vi stands for visual.

2. Vi have its variants like vim which stands for Vi IMproved, VimX11for gui and winvi for MS windows.

3. Vi is the most popular editor and next most popular editor is gedit. 4.Some other editors which will do the work of editing files are neno, pico, gedit, emacs, vim, joe, nedit, ed etc.

In vi editors there are three basic modes 1. Command mode 2. Input mode 3. Ex mode or last line mode In VI we used following commands

i – Insert text to left of curser.

I – insert text at beginning of line.

a – append text to right of curser.

A – append text at the end of line.

o – opens line below.

O – opens line above.

R – replace text from curser to right.

s – replace text right character under curser with any number of characters.

S – replace entire line.

:x/:w – it is used to save and quit the editor.

:q – used to aborting editor.

:w – save file and remains in editing mode.

Navigation Commands h - To move one character left .

j -To move one line down.

k -To move one line up.

l - To move one character right.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 17 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 18 | P a g e

Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 19 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 20 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 21 | P a g e Record Notes

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 22 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 23 | P a g e

TASK 2 Troubleshooting Hardware Troubleshooting 1. If you hit the power button & nothing happened.

Check all power connections.

Check for power on mother board.

2. If the system turns on but does not beep or begin to boot up.

Remove all components except motherboard/ CPU check by giving power to them Computer error beeps codes:

 No beep: short, no power, bad CPU/ MD, loose peripherals.

 One beep: everything is normal & computer posted tax.

 Two beeps: post / CMOS error.

 One long been one short beep: Motherboard problem.

 One long beep two short beep: video problem.

 One long beep three short beeps: video problem.

 Three long beeps: keyboard error.

 Repeated long beep: memory error.

 Continuous high - low beeps: CPU overheating Software Troubleshooting:

Error messages encountered during boot before Windows loads ensure that your computer BIOS settings are correctly configured to the hardware that is installed in your computer The next time you have a software problem, try these troubleshooting tips in the order they're listed below.

Carefully document the steps you take. That way, if a tech support call becomes necessary, at least you'll have a good idea of what isn't causing the problem.

 Free up RAM by closing other open programs.

 Restart the software.

 Shut down and restart your computer.

 Use the Internet to find help.

 Search for answers  Check the vendor's website  Check other websites ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 24 | P a g e

 Undo any recent hardware or software changes.

 Uninstall the software, and then reinstall it.

 Look for software patches.

 Scan for viruses and malware.

 Check for a firewall conflict.

 Boot up in Safe Mode.

 Defragment your hard drive.

Exercise:

1. Write in detail about hardware and software trouble shooting steps ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 25 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 26 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 27 | P a g e TASK 3

INTERNET Procedure:

Web browser provides the means to the searching and also helps to download the web content. Web browsers support most of the famous Internet Protocols like HTTP, FTP.

Common file formats a browser accepts are HTML Well known browsers natively support a variety of other formats in addition to HTML such as JPEG, PNG, and GIF image formats Different web browsers available in the market are:

Google Chrome Internet Explorer Netscape Mozilla Opera

Lynx Safari Bookmark: Each web browser is built -in with the support of Internet Bookmarks which serve as a named anchor – primarily to URLs. The primary purpose of this book mark is to easily catalog and access web pages that the web browser user has visited or plans to visit,

without having to navigate the web to get there.

Pop-up Blockers:

Pop-ups are a form of online adve rtising on the WWW intended to attract the attention of the users. These pop ups are hosted on the web sites which are frequently visited by the netizens. These pop ups are activated when these web sites open a new web browser window and there by displayin g the advertisements A plug -in is a software component program that interacts with a main application to provide a better integration of the media.

The basic difference between application programs and plug -ins is that multimedia files are launched in a se parate window where as in plug -ins multimedia play in the browser window.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 28 | P a g e Few famous Plug -INS are:

 Apple Quick Time  Macromedia flask  Microsoft Media Player  Adobe Shockwave  Sun Micro systems Java Applet

LAN Proxy Settings:

 Select tools menu in Internet Explorer  Select Internet Options  Select Connections You end up in two options 1. Dial -up and virtual network settings

2. LAN setting The selection at this step is dependent on the kind of connection you are trying to configure.

They are:

Dial-up modem connection LAN connection DSL or Cable modem B. How to access the websites, email and Search Engines, various threats on the internet and would be asked to configure their computer to be safe on

the internet, Antivirus Downloads to avoid viruses and/or worms.

A search engine can be defined as a web site with tools which help you to find information on the internet.

Limitations:

They filter results according to the information that a particular user has given them, which rarely provides an accurate reflection of a user’s real interests.

Although it is less of a problem than it used to be, search engine rankings have always been manip ulated by keyword –stuffing: the inclusion of unnaturally large numbers of search terms into web pages.

 Rankings are almost certainly affected in some way by the search engine companies’ commercial interests: their dependence on paid advertising, and their promotion of their own products.

 You can select the search terms  You can use the same search terms with multiple search engines  You can change search terms as much as you wish  You will normally receive numerous links  Its fast

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 29 | P a g e Cons: There are so many different search engines it may be difficult to choose  You will normally receive too many links often making it difficult to identify the most relevant sites.

 The vast majority of links may be only marginally relevant or altogether irrelevant  Alta Vi sta  Ask Jeeves  Google

 Lycos Etc.

Meta Search Engines:

Meta search engines or “met crawlers” don’t crawl the web themselves. Instead they search the resources of multiple search engines by sending a search to several search engines at once aggregating the result.

Pros:

You only need to use one search tool which is time - efficient You only need to learn how to use one search engine reducing learning curve You benefit from the difference among several search tools at once Cons:

Meta search services may not be able to leverage each individual search engines full range of query tools resulting in less refined searches You cannot personally select the search engines queried by Meta search services.

Viruses and/or worms Antivirus: Antivirus software is a program that either comes installed on your computer or that you Purchase or install yourself. It protects your computer against most viruses, worms, Trojan horses and other unwanted invaders that can make your computer s ick.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 30 | P a g e Firewall:

A firewall is a special software or hardware designed to protect a private computer network from unauthorized access. A firewall is a set of related programs located at a network gateway server which protects the resources of the private n etwork from users from other networks.

Installing Symantec antivirus for Windows:

 Insert Symantec antivirus CD into your CD drive  Double click on the Symantec -setup.exe  The installer will open  Click next to proceed License agreement will open .Click I accept the terms of the license agreement and then

click next.

Follow the instruction on the screen to complete the installation. Get Computer Updates:

 Click start> settings>control panel  Click Automatic Updates icon to open Automatic Updates dialog box  Check the box Keep my computer up to date  Choose a setting Click OK Block Pop ups:

 In the IE open tools>pop -up blocker  Click on Turn on Pop - up blocker Windows Firewall:

 Go to Start>control panel>Network and Internet Connections>windows firewall  In the gener al tab check the On(recommended) box  If you don’t want any exceptions check on Don’t allow exceptions box A test which simulates all of the above tasks would be crafted and given to the students.

 Identify and explain the components required to establish a network  Establish internet connection and create a new email id , send mail and attachment file to other mail account  Define search engine. List the various search engines. Navigate through any of the search engine like Google and explore its features.

 Download a file from the internet. Write the various steps involved in downloading  What is Antivirus software? List a few popular anti -virus kits available.

 Explain the functionality of the firewall quoting a few examples.

Exercise:

1. Students customize their web browsers with the LAN proxy settings, book marks, search toolbars and pop up blockers ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 31 | P a g e Record Notes

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 32 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 33 | P a g e

Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 34 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 35 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 36 | P a g e Record Notes

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 37 | P a g e TASK 4 Word Orientation: an overview of Microsoft (MS) office 2007/ 10 Importance of MS office 2007/10, overview of toolbars, saving files, Using Help and

resources, rulers, format painter.

INTRODUCTION TO MS -OFFICE Microsoft office is a set of inter related desk top applications ,servers and services, collectively refers to as an office suit for the micro soft windows and MAC OSX operating systems .

MS WORD:

Microsoft Word is a word processing software package. We can use it to type letters, reports, and other documents. In Word 2007, how a window displays depends on the size of your window, the size of your monitor and the resolution to which your monitor is set.

Resolution determines how much information your computer monitor can display.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 38 | P a g e STARTING MS WORD :- Two ways of starting MS WORD: - Double click on Microsoft word icon on the desk top. Click on start ->programs ->ms office -

>ms word.

The Microsoft Office Button In the upper -left corner of the Word 2007 window is the Microsoft Office button. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks.

The Quick Access Toolbar The Quick Access toolbar provides you with access to commands you frequently use. By default Save, Undo, and Redo appear on the Quick Access toolbar. You can use Save your file, Undo to rollback an action you have taken, and Redo to reapply an action you have rolled back.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 39 | P a g e The Ribbon We use the Ribbon to issue commands. The Ribbon is located near the top of the screen, below the Quick Access toolbar. At the top of the Ribbon are several tabs; clicking a tab

displays several related command groups. Within each group are related command buttons.

You click buttons to issue commands or to access menus and dialog boxes The Ruler We can use the ruler to change the format of your document quickly The Text Area You type your document in the text area. The blinking vertical line in the upper -left corner

of the text is the cursor.

The Status Bar The Status bar appears at the very bottom of your w indow and provides such information as the current page and the number of words in your document.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 40 | P a g e A. By Using Word create project certificate. Features to be covered: -Formatting Fonts in word, Drop Cap in word, Applying Text effects, Using Character S pacing, Borders and Colors, Inserting Header and Footer, Using

Date and Time option in Word.

The graphical user interface (GUI) provides ways to apply the various font formatting options (or character formatting options) to your text. In Word 2010 and Word 2007, many of these options are displayed directly in the Font group on the Home tab of the Ribbon and on the contextual toolbar that appears when you right -click within text. Additional options are available in the Font dialog box, which you can open by clicking the Font dialog box

launcher ( ) in the lower right -hand corner of the Font group on the Home tab. In Word 2003, many of these options are displayed directly on the Formatting toolbar, and additional options are available in the Font dialog box, which you can open by right -clicking and then clicking Font ( A) on the context -sensitive menu that opens or by clicking Font on the Format menu. The Font dialog box has two tabs.

Font Character Spacing The font formatting options that you can configure on the Font tab in the Font dialog box influence the appearance of the individual characters in your text ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 41 | P a g e

A drop cap is a specially formatted letter that appears at the beginning of a paragraph.

Word 2007 offers two styles of drop caps. The first, and more common, begins the paragraph with a large letter that spills down into the text. Thus, the drop cap displaces the first few lines of the paragraph. The second style places the large first letter in the margin adjacent to the paragraph.

Add an effect to text Select the text that you want to add an effect to. On the Home tab, in the Font group, click Text Effect.

Click the effect that you want.

For more choices, point to Outline, Shadow, Reflection, or Glow, and then click the effect that you want to add.

Remove an effect from text Select the text that you want to remove an effect from. On the Home tab, in the Font group, click Clear Formatting.

If you want to add a graphic or text at the top or the bottom of your document, you need to add a header or footer. You can quickly add a header or footer from the galle ries or you can add a custom header or footer. You can use these same steps to add a header or footer without page numbers Add a header or footer from the gallery On the Insert tab, in the Header & Footer group, click Header or Footer.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 42 | P a g e Click the header o r footer that you want to add to your document. To return to the body of your document, click Close Header and Footer on the Design tab (under Header & Footer Tools).

Click where you want to insert the date or time .

On the Insert tab, in the Text group, click Quick Parts.

Click Field.

In the Categories box, click Date and Time.

In the Field names box, click Create Date, Print Date, or Save Date.

In the Date formats box, click the date and time format that you want — for example, 2/12/2018 9:45 PM or 12 February 2018 Creating project abstract Features to be covered: -Formatting Styles, Inserting table, Bullets and Numbering, Changing Text Direction, Cell alignment, Footnote, Hyperlink, Symbols, Spell Check, Track Changes.

To create a document ap plying the above mentioned techniques.

Table : A table consists of rows and columns.

Cell Alignment: Aligns contents written in a table in the top left corner or top right corner or in the center etc.

Foot Not e: Foot notes are used to specify comments or provide references for text in a document.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 43 | P a g e Hyperlink: It is a colored and underlined text or a graphic that you click to go to a file, a location in a file, an HTML page on the World Wide Web, or an HTML page in an intranet.

Symbols: You may not be able to enter certain symbols into your word document, as there is a limitation on the keys on the key board. Creating new symbols especially when working with mathematical terms becomes very difficult.

Spell check: It automatically checks for spelling and gramma tical errors.

Bullets and Numbering: In Microsoft word we can easily create bulleted or numbered list of items.

Formatting Styles:

Changing Text direction: You can change the text orientation in drawing objects, such as text boxes, shapes , and callouts, or in table cells so that the text is displayed vertically or horizontally.

Track changes: Track changes are an excellent feature of Microsoft word as it enables a user or reviewer to keep track of the changes that have taken a period. Changes like insertion , deletion or formatting changes can be kept track of.

Table:

1. Click where you want to create a table.

2. On the Table menu, point to Insert, and then click Table.

3. Under Table size, select the number of columns and rows.

4. Under AutoFit behaviour , choose options to adjust table size.

5. To use a built -in table format, click AutoFormat.

Select the options you want Cell Alignment:

1. Click the cell that contains text you want to align.

2. On the Tables and Borders toolbar, select the option for the horizontal and vertical alignment .you want for example, Align Bottom Center or Align Top Right.

Foot Note:

1. In print layout view, click where you want to insert the note reference mark.

2. On the Insert menu, point to Reference, and then click Footnote.

3. Click Footnotes or Endnotes.

4. By default, Word places footnotes at the end of each page and endnotes at the end of the document. You can change the placement of footnotes and endnotes by making a selection in the Footnotes or Endnotes box.

5. In the Number format box, click the format yo u want 6. Click Insert. Word inserts the note number and places the insertion point next to the note number.

7. Type the note text.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 44 | P a g e 8. Scroll to your place in the document and continue typing.

9. As you insert additional footnotes or endnotes in the document, Word automatically applies the correct number format.

Hyper link:

Create a hyperlink to a file on your computer 1. Select the text or picture that you want to display as a hyperlink.

2. On the Insert tab, click Hyperlink .

3. Under Link to , do one of the follow ing:

To link to an existing file, click Existing File or Web Page under Link to , and then find the file in The Look in list or the Current Folder list.

To create a new, blank file and link to it, click Create New Document under Link to , type a name for the new file, and either use the location shown under Full path or browse to a different save location by clicking Change . You can also choose whether to Edit the new document later or open and Edit the new document now.

Create a hyperlink to a location in the current document 1. Select the text or picture that you want to display as a hyperlink.

2. On the Insert tab, click Hyperlink You can also right -click the text or picture and click Hyperlink on the shortcut menu.

3. Under Link to , click Place in This Document ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 45 | P a g e Create hyperlink to a location on the web 1. Select the text or picture that you want to display as a hyperlink.

2. On the Insert tab, click Hyperlink .

3. You can also right -click the text or picture and click Hyperlink on th e shortcut menu.

4. In the Insert Hyperlink box, type or paste your link in the Address box.

Symbol:

1. Click where you want to insert the symbol.

2. On the Insert menu, click Symbol, and then click the Symbols tab.

3. In the Font box, click the font that you want.

4. Double -click the symbol that you want to insert.

5. Click Close Spell check:

1. On the Standard toolbar, click Spelling and Grammar.

2. When Word finds a possible spelling or grammatical problem, make your changes in the Spelling and Grammar dialog box.

Bullets and Numbering:

1. Type 1.to start a numbered list or * (asterisk) to start a bulleted list, and then press SPACEBAR or 2. TAB.

3. Type any text you want.

4. Press ENTER to add the next list item (Word automatically inserts the next number or bullet).

5. To finish the lis t, press ENTER twice, or press BACKSPACE to delete the last bullet or number in the list Formatting Styles:

1. Select the words, paragraph, list, or table you want to change. If the Styles and formatting task pane is not open, click Styles and Formatting on the Formatting Toolbar.

2. Click the style you want in the Styles and Formatting task pane. If the style you want is not listed, click All Styles in the Show box Track Changes:

1. Open the document you want to revise.

2. On the Tools menu, click Track Changes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 46 | P a g e Changing Text direction:

1. Click the drawing object or table cell that contains the text you want to change.

2. On the Format menu, click Text Direction.

3. Click the orientation you want Description about MS -word:

To create news Letter Microsoft Word is a popula r and commonly used word processing program. It is one of the most popular word processing programs, if not the most popular.

Microsoft Word is often used in businesses, schools and universities.

Procedure:

Microsoft Word is a popular and commonly used wo rd processing program. It is one of the most popular word processing programs, if not the most popular. Microsoft Word is often used in businesses, schools and universities.

Table of contents:

Table of contents displays a list of headings in a created doc ument. It basically provides an outline of the entire document created format.

Newspaper columns:

One can create a newspaper columns document by specifying the number of new letter -style column required and then adjust their width, and add vertical lines between columns.

Images from files and clipart:

Inserting a picture (graphic) from a file and cl ipart may be required for a document.

This picture could be a scanned photograph or any other digitally produced one. These pictures can be modified, resized, cropped and enhanced.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 47 | P a g e Drawing toolbar and Word Art:

One can create his/her own drawings in Micr osoft word Provides a full fledged drawing tool bar. Word Art in Microsoft word enables you to create special and decorative text.

Formatting Images, Textboxes and Paragraphs:

Formatting an image includes selecting appropriate color, size, layout and cropping.

Generally the text in a document follows a standard orientation (line after line). A text box provides a different orientation to the text with in a document. It can arrange the text in anywhere and can be resized and moreover moved to any sectio n of the document or even outside.

When you are formatting a paragraph, you do not need to highlight the entire paragraph.

Placing the cursor anywhere in the paragraph enables you to format it. After you set a paragraph format, subsequent paragraphs will have the same format unless you change the format.

Procedure:

Table of contents:

1. Click where you want to insert the table of contents.

2. On the Insert menu, point to Reference, and click Index and Tables.

3. Click the Table of Contents tab.

4. To use one of the available designs, click a design in the Formats box.

5. Select any other table of contents options you want.

Newspaper columns:

1. Select the entire or part of document to be converted into a newsletter -style 2. Click on format menu, select columns 3. Any desired number of columns are presets -one or two or three or left or right b \can be selected.

4. Width and spacing can be fixed and equal columns width can be checked for uniformity 5. If newspaper columns are to be separated by a line, then check line between 6. Under app ly to will be whole document if entire document is selected else we have to select a Selected text.

7. Click ok ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 48 | P a g e Inserting images from files and clip art:

1. Click where you want to insert the picture.

2. On the Insert menu, point to Picture, and then click From F ile.

3. Locate the picture you want to insert 4. Double -click the picture you want to insert.

Clip Art:

1. On the Insert menu, point to Picture, and then click Clip Art.

2. In the Clip Art task pane, in the Search for box, type a word or phrase that describes the clip you want or type in all or some of the file name of the clip.

3. To narrow your search, do one or both of the following To limit search results to a specific collection of clips, in the Search in box, click the arrow and select the collections you want to search. To limit search results to a specific type of media file, in the Results should be box, click the arrow and select the check box next to the types of clips you want to find.

4. Click Go.

5. If you don't know the exact file name, you can substitute wil dcard characters for one or more real characters. Use the asterisk (*) as a substitute for zero or more characters in a file name. Use the question mark (?) as a substitute for a single character in a file name.

6. In the Results box, click the clip to insert it.

Drawing Toolbar and Word Art:

1. Click in your document where you want to create the drawing.

2. On the Insert menu, point to Picture, and then click New Drawing.

3. A drawing canvas is inserted into your document.

4. Use the Drawing toolbar to add any shapes or pictures that you want.

Word Art:

1. On the Drawing toolbar, click Insert WordArt 2. Click the WordArt effect you want, and then click OK.

3. In the Edit WordArt Text dialog box, type the text you want.

4. Do any of the following:

5. To change the font type, in the Font list, select a font.

6. To change the font size, in the Size list, select a size.

7. To make text bold, click the bold button.

8. To make text italic, click the Italic button.

9. Formatting of the images can be achieved by selecting the image and double click on the picture, format picture dialog box appears.

The same can be achieved by selecting the tools menu > customize>tool bars tab>picture and click close.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 49 | P a g e Basic formatting features of an image Resize a drawing 1. Select the drawing canvas

2. On the Drawing Canvas toolbar, do one of the following:

3. To make the drawing canvas boundary larger without changing the size of the objects on the Canvas , click Expand.

4. To make the drawing canvas boundary fit tightly around the drawing objects or pictures, Click Fit.

5. To scale the drawing and make the objects and canvas proportionately smaller or larger, Click Scale Drawing, and then drag the edges of the canvas.

Resize a picture or shape 1. Position the mouse pointer over one of the sizing handles 2. Drag the sizing handle until the object is the shape and size you want.

3. To increase or decrease the size in one or more directions, drag the mouse away from or toward the center , while doing one of the following:

4. To keep the center of an object in the same place, hold down CTRL while dragging the mouse.

5. To maintain the object's proportions, drag one of the corner sizing handles.

6. To maintain the proportions while keeping the center in the same place, hold down CTRL while dragging one of the corner sizing handles .

Crop a picture:

1. Select the picture you want to crop.

2. On the Picture toolbar, click Crop.

3. Position the cropping tool over a cropping handle and then do one of the following:

4. To crop one side, drag the center handle on that side inward.

5. To crop equally on two sides at once, hold down CTRL as you drag the center handle on either side inward.

6. To crop equally on all four sides at once, hold down CTRL as you drag a corner handle inward.

7. On the Picture toolbar, click Crop to turn off the Crop command ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 50 | P a g e Text Box:

1. On the Drawing t oolbar, click Text Box.

2. Click or drag in your document where you want to insert the text box 3. You can use the options on the Drawing toolbar to enh ance a text box — for example 4. To change the fill color — just as you can with any other drawing object Paragraphs:

Change line spacing  Select the text you want to change.

 On the Formatting toolbar, point to Line Spacing, and then do one of the following:

 To apply a new setting, click the arrow, and then select the number that you want.

 To apply the most recently used setting, click the button.

 To set more precise measurements, click the arrow, click more , and then select the options you want under Line Spacing .

Change spacing before or after paragraphs 1. Select the paragraphs in which you want to change sp acing.

2. On the Format menu, click Paragraph, and then click the Indents and Spacing tab.

3. Under Spacing, enter the spacing you want in the before or after box.

Change paragraph direction 1. Place the insertion point in the paragraph that you want to change, or select several paragraphs.

2. Do one of the following:

To have text begin from the left, click Left -to-Right on the Formatting toolbar.

To have text begin from the right, click Right -to-Left on the Formatting toolbar.

1. When you change the paragraph direction, Microsoft Word leaves justified and centered text as it is. In the case of left -aligned or right -aligned text, Word flips the alignment to its opposite. For example, if you have a left -to-right paragraph that is right aligned, such as the date at the top of a letter, clicking Right -to-Left results in a right -to-left paragraph that is left aligned

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 51 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 52 | P a g e

Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 53 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 54 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 55 | P a g e Record Notes

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 56 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 57 | P a g e

TASK 5 Excel Orientation: the importance of MS office 2007/10 tool Excel as a Spreadsheet tool, Accessing, overview of toolbars, saving excel files, Using help and resources.

Introduction to MS -Excel Excel is a computerized spreadsheet, which is an important business tool that he lps you report and analyze information. Excel stores spreadsheets in documents called workbooks.

Each workbook is made up of individual worksheets, or sheets. Because all sorts of calculations can be made in the Excel spreadsheet, it is much more flexible than a paper spreadsheet. The Excel window has some basic components, such as an Active cell, Column headings, a Formula bar, a Name box, the mouse pointer, Row headings, Sheet tabs, a Task Pane, Tab scrolling buttons and Toolbars.

Sample Worksheet ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 58 | P a g e Excel worksheet and workbooks When you set up calculations in a worksheet, if an entry is changed in a cell, the

spreadsheet will automatically update any calculated values that were based on that entry.

When you open Excel, by default it will open a blan k workbook with three blank worksheets.

When you save a workbook, you have a Save As option that can save the spreadsheet to earlier versions of Excel or to Quattro Pro, Lotus 123 formats, dBase formats, and even to a comma or tab delimited text file.

Identify Excel components To navigate within a workbook, you use the arrow keys, Page Up, Page Down, or the Ctrl key In combination with the arrow keys to make larger movements. The most direct means of Navigation is with your mouse.

Scroll bars are provided and work as they do in all Windows applications. To move to other Worksheets, you can:

A. Click their tab with the mouse B. Use the Ctrl key with the Page Up and Page Down keys to move sequentially up or down Through the worksheets.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 59 | P a g e If you are familiar with Microsoft Access, you will find the tab scrolling buttons for Moving between worksheets to be similar to record browsing on an Access form or Datasheet . Developing a Worksheet

 Determine the worksheet’s purpose. Enter the data and formulas .

 Test the worksheet and make any necessary edits / corrections  Document the worksheet and improve appearance.

 Save and print the complete worksheet.

Entering data into a worksheet To enter data, first make the cell in which you want to enter the data active by clicking it.

Enter the data (text, formulas, dates, etc.) into the active cell.

Use the Alt + Enter key combination to enter text on multiple lines within the same cell. Use TAB Key, arrow keys, or ENTER key to navigate among the cells.

Entering Formulas A formula is a mathematical expression that calculates a value. In Excel, formulas always Begin with an equal sign (=).

A formula can consist of one or more arithmetic operators.

The order of precedence is a set of predefined rules that Excel foll ows to calculate a formula.

Resize worksheet rows and columns There are a number of methods for altering row height and column width using the mouse or menus:

Click the dividing line on the column or row, and drag the dividing line to change the width of the column or Height of the row Double -click the border of a column heading, and the column will increase in width to match the length of the longest entry in the column Widths are expressed either in terms of the number of characters or the number of scre en pixels.

Identify cell ranges  A group of worksheet cells is known as a cell range, or range.

 Working with ranges in a worksheet makes working with the data easier.

 Ranges can be adjacent or nonadjacent.

 An adjacent range is a single, rectangular block of cell ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 60 | P a g e  Select an adjacent range by clicking on a cell and dragging to an opposite corner of a  rectangle of cells

 A nonadjacent range is comprised of two or more adjacent ranges that are not contiguous to each other  To select a nonadjacent range, begi n by selecting an adjacent range, then press and hold down the Ctrl key as you select other adjacent ranges Select and move worksheet cells

To select a large area of cells, select the first cell in the range, press and hold the Shift key, and then click t he last cell in the range.

Once you have selected a range of cells, you may move the cells within the worksheet by clicking and dragging the selection from its current location to its new one.

By pressing and holding the Ctrl key as you drag, Excel will le ave the original selection in its place and paste a copy of the selection in the new location. To move between workbooks, use the Alt key while dragging the selection.

Insert worksheet rows and columns You can insert one or many additional rows or columns within a worksheet with just a few steps using the mouse or menu options. You can insert individual cells within a row or column and then choose how to displace the existing cells. You can click the Ins ert menu and then select row or column, or right click on a row or column heading or a selection of

cells and then choose Insert from the shortcut menu. Delete worksheet rows and columns To delete and clear cells, rows, or columns, you can use the Edit menu, or right click on a heading or a selection of cells and choose Delete from the shortcut menu. Clearing, as opposed to deleting, does not alter the structure of the worksheet or shift unclear data cells. What can be confusing about this process is tha t you can use the Delete key to clear

cells, but it does not remove them from the worksheet as you might expect.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 61 | P a g e Use undo and redo features Editing is an intrinsic task in any document, and especially useful are the Undo and Redo actions. The Undo featur e allows you to sequentially back up to a certain action, such as a

delete , a move, an entry, etc. Allows you to reverse those actions. Redo allows you to reapply actions one step at a time that you have previously undone.

Print as workbook To print a worksheet, you can use: A menu The Print button on the standard toolbar The Ctrl -P keystroke to initiate a printout of the worksheet a) Calculating GPA - Features to be covered: - Cell Referencing, Formulae in excel –

average, std. deviation, Charts, Rena ming and Inserting worksheets, Hyper linking, Count function, LOOKUP/VLOOKUP, Sorting, Conditional formatting .

Procedure:

1. On the chart menu click chart type 2. Text direction.

3. Click the arrow down next to the text direction button. For right to left click ri ght to left. For left to right reading order, click left to right.

4. For reading order that is consistent with the language of the first entered character, click context. For reading order that is inconsistent with the language of the first entered character , click control.

5. In the tools menu click options and then click chart tab.

6. To show all worksheet data in the chart even if some rows and columns are hidden, clear the plot visible cells by check box.

7. To prevent hidden rows and columns from displaying in the chart, select the plot cells only check box Hyper Linking:

1. Create a worksheet: On the file menu, click new, and then click blank workbook task pane.

2. Insert a worksheet: C lick worksheet on the insert menu. Right click on sheet tab and then click inser t double click the template for the type of sheet you want.

3. Hyperlink: Using hyperlink we can insert one more sheet in the present sheet 4. Count function: Create a blank worksheet press control +c. In the worksheet select cell A and press control +c. On the tools menu point to formula auditing and then click formula auditing menu.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 62 | P a g e Worksheet:

1. In the file menu go to menu then a new worksheet is created.

2. To add a single worksheet, click worksheet on the Insert menu. To add multiple 3. worksheets hold down shift and then click the number of worksheet tasks to add in an open Workbook Sort:

1. Click a cell in the list you want to sort.

2. On the Data menu click sort.

3. Under first key sort click the custom sort order you want and then click ok.

4. Click any other sorting option you want.

Formulae in Excel:

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 63 | P a g e Charts:

1. Get your data into Excel. First, you need to input your data into Excel.

2. Choose a type of chart/graph to create. ...

3. Switch axes, if necessary. ...

4. Adjust your labels and legends, if desired. ...

5. Change the Y axis measurement options, if desired. ...

6. Reorder data, if desired.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 64 | P a g e FORMULAS IN EXCEL CALCULATE PRODUCTION PER HOUR Data for some employees is recorded in a worksheet. They work a varied number of hours

Each day to produce clocks. By calculating the number of pieces each employee produces per hour, it can be determined who is the most productive employee.

To see who the most productive employee is :

1. In a worksheet, enter your own data or the data shown in Figure 1 –1.

2. Select cells D2:D7.

3. Enter the following formula: =C2/(B2*24) .

4. Press to fill the selected cell range with the current entry.

5. From the toolbar select Home and go to Number .

6. Click the dropdown arrow and select Format Cells .

7. Select the Number tab and then select Number from the Category list.

8. Set Decimal places to 2.

9. Click OK.

FIGURE 1 –1 Beckham is the most productive. He produces an average of nearly 22 clocks per hour.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 65 | P a g e CALCULATE THE AGE OF A PERSON IN DAYS A worksheet lists the names of friends in column A and their birth dates in column B. To calculate the number of days each person has been alive, enter the current date in cell B1

and perform the following steps:

To calculate the age of a person in days:

1. In a worksheet, enter your own data or the data shown in Figure 1 –2.

2. Select cells C5:C9.

3. Enter the following formula: =$B$1 -B5.

4. Press .

5. From the toolbar select Home and go to Number .

6. Click the dropdown arrow and select Format Cells .

7. Select the Number tab and then select General from the Category list.

8. Click OK.

FIGURE 1 –2 NOTE The formula must have an absolute reference to cell B1, which is available by going to the formula bar, highlighting the cell reference, and pressing F4 until the appropriate reference appears ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 66 | P a g e CALCULATE A PRICE REDUCTION All prices in a price list have to be reduced by a certain percentage. The amount of the price reduction is 15%; this is entered in cell C1.

To reduce all prices by a certain percentage:

1. In a worksheet, enter your own data or the data shown in Figure 1 –3.

2. Select cell C1 and type −15% .

3. Select cells C4:C8.

4. Enter the following formula: =B4+(B4*$C$1) .

5. Press FIGURE 1 –3 NOTE Please note that the formula must have an absolute reference to cell C1. Also, columns B and C are formatted with the Currency style, which is available by clicking on the $ button in the Home ribbon toolbar.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 67 | P a g e CONVERT CURRENCY In a worksheet, currency has to be converted from dollars (column B) to Euros (column C) .

The rate of exchange from dollars to Euros is placed in cell C1; here we use 0.747.

To convert currency:

1. In a worksheet, enter your own data or the data shown in Figure 1 –4.

2. Select cells C4:C8.

3. Enter the following formula: =B4*$C$1 .

4. Press .

5. Press to show the dialog Format Cells 6. Select the Number tab and then select Currency from the Category list.

7. Choose the required € Euro format.

8. Click OK.

NOTE To convert Euros back to dollars, use the following formula: =C4/$C$1.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 68 | P a g e CONVERT FROM HOURS TO MINUTES As a task, time in a timesheet has to be converted from hours to minutes.

To convert time to minutes:

1. In a worksheet, enter your own data or the data shown in Figure 1 –5.

2. Select cells B4:B8.

3. Enter the following formula: =A4*24*60 .

4. Press .

5. Format cells B4:B8 as general by pressing and then selecting the Number tab and then General from the Category list.

6. Click OK.

NOTE To convert a minutes format to an hours -and-minutes format, use the formula =B4/24/6 0.

Remember to format the cells with a time format, as shown in cell C4 in Figure 1 –5.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 69 | P a g e LOGICAL FUNCTIONS USE THE AND FUNCTION TO COMPARE TWO COLUMNS Two columns in a worksheet have to be evaluated. If the value in column A is greater than

20 and the value in column B is greater than 25, both values are valid.

To compare two columns:

1. In cells A2:A10, enter values from 1 to 100.

2. In cells B2:B10, enter values from 1 to 100.

3. Select cells C2:C10 and type the following formula:

4. =AND ( A2>20,B2>25) .

5. Press .

NOTE If both criteria are valid, Excel shows the value as TRUE; otherwise, it is FALSE.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 70 | P a g e USE THE AND FUNCTION TO SHOW SALES FOR A SPECIFIC PERIOD OF TIME This example checks all rows for a specific time period using the AND function. The function returns TRUE if all the arguments are TRUE and FALSE if one or more arguments are FALSE.

NOTE Up to 30 conditions can be used in one formula.

To show sales in a period of time:

1. Select cell B1 and enter the start date.

2. Select cell B2 and enter the end date.

3. The range A5:A16 contains dates ranging from 09/11/04 to 09/22/04.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 71 | P a g e USE THE OR FUNCTION TO CHECK CELLS FOR TEXT A worksheet contains several words in column A. Each row has to be checked for the words “new” or “actual” in column A. The OR function is used for this task. The function returns

TRUE if either argument is true and FALSE if both arguments are not true.

NOTE Up to 30 conditions can be used in one formula.

To use the OR function to check for two or more criteria:

1. Enter in range A2:A10 words like “new," “actual," and “old." 2. Select cells B2:B10 and type the following formula:

3. =OR(A2="New",A2="actual") .

4. Press ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 72 | P a g e USE THE OR FUNCTION TO CHECK CELLS FOR NUMBERS A worksheet contains several values in column A. Each row has to be evaluated based on

certain the specific value in column A. The OR function is used for this task. The function returns TRUE if any argument is TRUE and FALSE if all arguments are FALSE.

NOTE Up to 3 0 conditions can be used in one formula.

To check for two or more criteria:

1. Enter in range A2:A12 values from –43 to 100.

2. Select cells B2:B12 and type the following formula:

=OR ( A2=1 , A2>=99 , A2<0).

3. Press ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 73 | P a g e USE THE XOR FUNCTION TO CHECK FOR MUTUALLY EXCLUSIVE CONDITIONS

A worksheet contains several values in column A and another set of values in column B. The columns must contain in the same row one number above 900 but not both. The XOR function is used for this task. The function return s TRUE if only one argument is TRUE, FALSE if both arguments are TRUE and FALSE if all arguments are FALSE.

To check for the specified criteria:

1. Enter in range A2:A12 values from 0 to 1,000.

2. Enter in range B2:B12 values from 0 to 1,000.

3. Select cells C2:C1 2 and type the following formula:

=XOR ( A2>=900,B2>=900) .

4. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 74 | P a g e USE THE IF FUNCTION TO COMPARE COLUMNS AND RETURN A SPECIFIC RESULT As shown in earlier examples, Excel returns the value TRUE or FALSE when using the OR and

AND functions. The IF function can also be used to conduct conditional tests on values and formulas.

This example compares two columns and shows the result in column C.

To return specific text after comparing values:

1. Enter in range A2:A12 values from 0 to 1,000.

2. Enter i n range B2:B12 values from 0 to 1,000.

3. Select cells C2:C12 and type the following formula:

4. =IF (A2>=B2,"Column A is greater or equal”, “Column B is greater") .

5. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 75 | P a g e USE THE IF FUNCTION TO CHECK FOR LARGER, EQUIVALENT, OR SMALLER VALUES In the previous example, two different messages were used as the result for comparing

Values . To check for three conditions in column A and present the result as “Column A is Larger ,” “equal,” or “Column A is smaller,” perform the following steps.

To compare columns and show the result:

1. Copy the previous example.

2. Select cells C2:C12 and type the following formula:

3. =IF (A2>B2,"Column A is larger”, IF ( A2=B2,"Equal", “Column A is smaller")) .

4. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 76 | P a g e TEXT FUNCTIONS THE LEFT AND RIGHT FUNCTIONS TO SEPARATE A TEXT STRING OF NUMBERS

A worksheet contains a list of 10 -digit numbers that have to be separated into two parts:

a three -digit part and a seven -digit part. Use the LEFT and RIGHT functions to do this. The LEFT function returns the first character or characters in a text string, based on the number of characters specified. The RIGHT function returns the last character or characters in a text string based on the number of characters specified.

To separate a text string o f numbers:

1. In a worksheet, enter a series of 10 -character numbers in cells A2:A10. The numbers can also contain letters.

2. Select cells B2:B10 and type the following formula:

3. =LEFT ( A2, 3).

4. Press .

5. Select cells C2:C10 and type the following formula:

6. =RIGHT ( A2, 7).

7. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 77 | P a g e USE THE LEFT FUNCTION TO CONVERT INVALID NUMBERS TO VALID NUMBERS In this example, invalid numbers have to be converted to valid numbers. The invalid

numbers contain a minus sign at the right end of the text. Excel cannot interpret this, so the minus sign in the text needs to be moved to the left of the numbers. First, c heck the length of each number with the LEN function. This function returns the number of characters in a text string. Then use the LEFT function to move the minus sign. LEN ( text) text: The text whose length you want to be determined. A space is considere d a character.

To cut off the last character and display a negative value:

1. In a worksheet, enter a series of numbers in cells A2:A10 that have a minus sign at the end.

2. Select cells B2:B10 and type the following formula:

3. = -LEFT ( A2, LEN (A2) -1).

4. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 78 | P a g e USE THE LOWER FUNCTION TO CONVERT TEXT FROM UPPERCASE TO LOWERCASE To convert all letters to lowercase in a text string, use the LOWER function. This function

Has the following syntax:

LOWER ( text) text: Text to be converted to all lowercase letters. The text can be either a reference or a text string.

To convert a text string to lowercase:

1. In cells A2:A8, type any text in uppercase letters.

2. Select cells B2:B8 and type the following formula:

3. =LOWER ( A2).

4. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 79 | P a g e USE THE UPPER FUNCTION TO CONVERT TEXT FROM LOWERCASE TO UPPERCASE The UPPER function is used to convert a text string to all uppercase letters. This function has the

following syntax:

UPPER ( text) Text : Text to be converted to all uppercase letters. The text can be either a reference or a text string.

To convert a text string to uppercase:

1. In cells A2:A8, type any text in lowercase letters.

2. Select cells B2:B8 and type the following formula:

=UPPER ( A2).

3. Press ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 80 | P a g e USE THE MID FUNCTION TO SEPARATE LAST NAME FROM FIRST NAME

In a worksheet, names are listed in column A, and the last name has to be copied to column B. As in the previous example, the space between the first and last names has to be determined with the SEARCH function. This function returns the position of the de sired character inside a text string starting from start_num . The MID function then returns a specific number of characters starting from a desired position inside a text string.

MID ( text, start_num, num_chars) text: Text string containing the desired characters.

start_num: Position of the first character to extract from the text.

num_chars: Number of characters to be extracted.

To separate the last name from the first name:

1. In a worksheet, enter a series of full names in cells A2:A10.

2. Select cells B2 :B11 and type the following formula:

=MID ( A2, SEARCH ( “ “,A2)+1,100) .

3. Press ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 81 | P a g e USE THE SEARCH FUNCTION TO SEPARATE FIRST NAME FROM LAST NAME

This task demonstrates how to separate first and last names. In a worksheet, full names are listed in column A. We want to copy the first name to column B. The SEARCH function can be used to determine the space between the parts of the text string. This function returns the position of the searched character inside a text string:

SEARCH( find text , within text, start_num) find_text: The text or character for which you are searching. Wildcard characters, question marks (?), and asterisks (*) can be used in find_text. A question mark matches any single character, and an asterisk matches any sequence of chara cters. To find a question mark or asterisk, type a tilde (~) before the character

within_text: The text within which you want to search for find_text.

start_num: The start position for the search function within the text; if there is no start_num defined i nside the function, Excel sets it to 1.

To separate the first and last names:

1. In a worksheet, enter a series of full names in cells A2:A10.

2. Select cells B2:B11 and type the following formula:

3. =LEFT ( A2, SEARCH ( “ “,A2) -1).

4. Press ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 82 | P a g e BASIC STASTICAL FUNCTIONS USE THE MAX FUNCTION TO DETERMINE THE LARGEST

VALUE IN A RANGE This example finds the largest value in the range A3:D11 by using the MAX function. The function’s return value is the largest value in a set.

MAX ( number1, number2,) number1, number2, from 1 to 30 numbers for which you want to find the largest value. It is possible to use a cell reference; however, the cells must contain numbers or values that can be converted to numbers.

To determine the largest value:

1. In cells A3:D11 type any values.

2. In cell B1 type the formula = MAX ( A3:D11).

3. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 83 | P a g e USE THE MIN FUNCTION TO FIND THE EMPLOYEE WITH THE LOWEST SALES In a company, employee sales are monitored. Columns B to E contain the sales for the first

four months of the year. To determine which employee has the lowest monthly sales, use the MIN function. The function’s return value is the smallest value in a set.

MIN( number1, number2, ...) number1, number2, ...: From 1 to 30 numbers for which you want to find the smallest value.

It is possible to use a cell reference; however, the cells must contain numbers or values that can be converted to numbers.

To determine the lowest monthly sales:

1. In a worksheet, copy the range A1:E10 shown in Figure 2. Select cells B12:E1 2 and type the following formula:

3. =MIN(B2:B10 ).

4. Press ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 84 | P a g e USE THE AVERAGE FUNCTION TO CALCULATE THE AVERAGE OUTPUT

In this example, the output of three production lines has been recorded for several days.

Now the average of the three highest outputs of each line has to be calculated. For this task, Excel provides the AVERAGE function, which returns the average, or arithmetic mean, of the arguments.

AVERAGE( number1, number2 , ...) number1, number2, ...: From 1 to 30 numeric arguments for whic h you want to determine the average. It is also possible to use a cell reference, as shown in this example.

To calculate the average of the three highest capacities of each production line:

1. In cells B2:D10, type the output of each production line.

2. Select cells B13:D13 and type the following formula:

3. =AVERAGE ( LARGE(B2:B10,1),LARGE(B2:B10,2), LARGE(B2:B10,3)).

4. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 85 | P a g e MATHEMATICAL FUNCTIONS USE THE SUM FUNCTION TO SUM A RANGE In this example, all values of a range in a worksheet have to be added, with the sum

appearing in cell A11. To do this, use the SUM function, which returns the sum of all numbers in a range of cells.

SUM ( number1, number2 ,) number1, number2, …: From 1 to 30 arguments to be summed. Cell references are also valid.

To sum a range:

1. In cells A2:A10, enter any values from 1 to 100. Figure shows that we used dollar Amounts .

2. In cell A11, type the following formula:

=SUM ( A1:A10).

3. Press NOTE : To perform this task a little faster, just select cell A11 and click on the Σ icon (AutoSum) in the Editing bar under the Home tab. Then press to display the result of the calculation ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 86 | P a g e USE THE SUMIF FUNCTION TO DETERMINE SALES OF A TEAM In this example, all the sales of different teams have to be summed. You can use the SUMIF function to add all cells in a range, specified by a given criterion.

SUMIF( range, criteria, sum_range ) range: A range of cells to be evaluated.

criteria: The criteria that specifies which cells to add. This can be a number, expression, or text.

sum range : The actual cells to be summed.

To sum specified data:

1. In cells A2:A10, enter a team number from 1 to 3.

2. List all team members in cells B2:B10.

3. In cells C2:C10, enter the daily sales of each employee.

4. List the numbers 1, 2, 3 for each team in cells E2:E4.

5. Select cells F2:F4 and type the following formula:

6. =SUMIF($A$2:$A$10,E2,$C$2:$C$10).

7. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 87 | P a g e USE THE SUMPRODUCT FUNCTION TO CALCULATE THE VALUE OF THE INV ENTORY In this example, the costs of all products in a warehouse have to be summed to obtain the

value of the entire inventory. To do this, use the SUMPRODUCT function. This function multiplies corresponding components in the given arrays and returns the sum of those products.

SUMPRODUCT ( array1, array2, array3, …) array1, array2, array3, …: From 2 to 30 arrays whose components are to be multiplied and then added.

To calculate the in ventory value:

1. Enter the data shown in columns A and B in Figure 6 –8. The quantity of each product is listed along with the cost of each unit.

2. Select cell B12 and type the following formula:

3. =SUMPRODUCT(B2:B10,A2:A10).

4. Check the result by selecting cells D2:D10 and typing the following formula:

5. =A2*B2.

6. Press .

7. Sum this range in cell D12.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 88 | P a g e LOOKUP FUNCTIONS USE THE VLOOKUP FUNCTION TO LOOK UP AND EXTRACT DATA FROM A DATABASE

Typing a valid product number in cell B1 fills cells B2 to B4 with the corresponding data from the list. To do this, use the VLOOKUP function, which searches for a value in the lefthand column of a table and returns a value in the same row from a column specified in the table.

VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) lookup_value: The value to be found in the left -hand column of the array.

table_array: The table in which data is looked up.

col_index_num: The column number in table_array from which the matching value must be returned. 1 retu rns the value in the first column in table_array, 2 returns the value in the second column in table_array, and so on.

range_lookup: A logical value that indicates whether VLOOKUP is to find an exact match or an approximate match. If TRUE or omitted, an app roximate match is returned.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 89 | P a g e To look up and extract data from a list:

1. In cell B2, type the following formula:

=VLOOKUP ( $B$1,$A$7:$D$16,2,FALSE).

2. In cell B3, type the following formula:

=VLOOKUP ( $B$1,$A$7:$D$16,3,FALSE).

3. In cell B4, type the following formula:

=VLOOKUP($B$1,$A$7:$D$16,4,FALSE).

4. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 90 | P a g e USE THE HLOOKUP FUNCTION TO DETERMINE SALES AND COSTS FOR A TEAM The costs and sales for a team have to be looked up in a table. Each team is listed by column

with its costs and sales. To get the desired information, use the HLOOKUP function, which searches for a value in the top row of a table or an array of values and then returns a value in the same column from a row that is specified in the table or array.

HLOOKUP(lookup_value, table_array, row_index_num, range_lookup) lookup_value: The value to be found in the top row of the table.

table_array: A table in which data is looked up.

row_index_num: The row number in table_array from which the matching value wil l be returned.

range_lookup: A logical value that indicates whether HLOOKUP is to find an exact match or an approximate match.

To determine sales and costs for a team:

1. In a worksheet, copy the information in cells A1:E3, as shown in Figure 9 –7.

2. In cell A7, enter a valid team name.

3. In cell B7, type the following formula:

=HLOOKUP($A$7,$B$1:$E$3,2,FALSE).

4. Press .

5. Select cell C7 and type the following formula:

=HLOOKUP($A$7,$B$1:$E$3,3,FALSE).

6. Press .

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 91 | P a g e CONDITIONAL FORMATING USE THE WEEKDAY FUN CTION TO DETERMINE WEEKENDS AND SHADE THEM

With the help of the WEEKDAY function, we can find out the day of the week for a particular date. This function returns the days as an integer ranging from 1 (Sunday) to 7 (Saturday) by default. You can also use this function in conditional formatting. In this example, some dates are listed in column A and the weekends are then marked as shown.

To detect and shade weekends:

1. Copy cells A1 and B1 into a new worksheet, as shown in Figure 10 –1.

2. Enter =TODAY() in cell A2 and =A2+1 in cell A3. For the remaining cells A4:A12, enter =Ax+1, where x is the previous cell number.

3. Select cells B2:B12 and enter the function = WEEKDAY ( A2).

4. Press .

5. Select cells A2:B12.

6. From the Home tab, go to the Styles bar and click on Conditional Formatting.

Choose New Rule.

7. In the Select a Rule Type dialog, select Use a formula to determine which cells to Format .

8. In the Edit box, type the following formula to mark Saturday:

=WEEKDAY ( $A2)=7.

9. Click Format to select the desired format ting to apply when the cell value meets the Condition .

10. Select a color from the Fill tab and click OK.

11. Click OK.

12. Repeat steps 2 through 6 and choose Manage Rule.

13. Click New Rule and insert the following formula (to mark Sunday):

=WEEKDAY ( $A2)=1.

14. Repeat step 10.

15. Click OK.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 92 | P a g e NOTE: To display the short versions of the days of the week rather than the integers returned by the function, highlight cells B2:B12, select Cells from the Format menu, and enter ddd in the Type box. Click OK

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 93 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 94 | P a g e

Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 95 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 96 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 97 | P a g e Record Notes

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 98 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 99 | P a g e

TASK 6 Basic power point utilities and tools which helpful to create basic power point presentation. Topic covered during this includes PPT Orientation, Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and Numbering, Animations, Auto Shapes, Lines and Arrows in Power point.

Introduction to MS - PowerPoint Microsoft PowerPoint is the name of a proprietary commercial software presentation program developed by Microsoft. It was developed by Microsoft and officially launched on May 22, 1990 PowerPoint is an application used for the creation of presentations. These presentations are laid out

in a "storyboard" type fashion, where individual slides are created and formatted wi th text and images. The PowerPoint allows you to choose from a wide variety of formats that include sections such as titles, lists, images, or charts. Any of these can be incorporated into your presentation.

a) Create the presentation using the following tools.

1. Formatting: Color, font type, font size, font style etc.

2. Header and Footer 3. Bullets and Numbering 4. Drawing Toolbar: Auto shapes, Textboxes, etc 5. Design Template 6. Introduction to custom animation.

Insert text:

1. Text can be added to layout.

2. Align text in the top, middle or bottom of a cell.

3. Align text on the right or left, or in the center of a cell.

4. Change cell margins.

5. Insert a tab in a table.

6. To make the symbol command available, in normal view, place the insertion point on the outbox tab or in a text place holders on the slide.

7. On the insert menu, click symbol.

8. To change fonts, click a name in the font box.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 100 | P a g e Bullets and numberings:

1. Select the lines of text that you want to add bullets or numbering to.

Click bullets or numbering.

Auto shapes:

1. Select the auto shape that has the text you want to position.

2. Double -click the selection rectangle of the auto shape or text box and then click the text box tab in the format dialog box.

3. In the text anchor point box, click the position you want the text to start in. LINES AND Animations:

1. Select the object that you want to animate.

2. On the Animations tab of the ribbon, in the Animation group, click the More button, 3. and then select the animation effect that you want.

b) Create a presentation to conduct a creativity session using the following tools.

1. Slide transition 2. Master slide view 3. Insert picture – clipart, image 4. Action button 5. Drawing tool bar – lines, arrows

6. Hyperlink 7. Custom animation 8. Hide slide 9. Wash out ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 101 | P a g e Slide transition Transitions are easy to add to your slide by using PowerPoint's Transitions Gallery.

1. Select the slide you wish to add a transition to.

2. In the Animations tab under the Transition to This Slide group choose an effect from the Transition gallery . Use the arrow to scroll through the options. PowerPoint will show you a preview of the transition when you how ever your mouse over a gallery item.

1. To set the speed of a transition, select a speed from the Transition Speed pull-down menu.

2. OPTIONAL: If you wish to add a sound effect to your transition (again, use this sparingly!) choose a preset sound from the Transition Sound pull-down menu or choose "Other Sound" to use a sound from your computer. PowerPoint also provides an option to loop your chosen sound.

3. OPTIONAL: If you want to apply your transition settings to all of your slides, click Apply To All .

4. OPTIONAL: You also have the option to customize how your slide advances. You can advance slides by clicking the mouse of the "On Mouse Cl ick" option is checked, or choose to have your slide automatically advance after a certain time. You can even have both options checked so that you can advance the slide early if you need.

Removing Transitions 1. Select the slide(s) from which you would like to remove the transition.

2. On the Animation tab in the Transitions gallery choose No Transition Master Layouts:

1. On the view menu, point to master, and then click slide master.

2. To insert a slide master, do the presentation given in slides and lastly add date and footer to the slides.

Insert Images:

1. Click where you want to insert the picture.

2. On the drawing tool bar, click insert picture.

3. Locate the folder that contains the picture that you want to insert, and then click the Picture file.

Clip Art:

1. On the insert menu, point to structure and then click clipart.

2. In the clipart task pane, in the search for box, type a word or phrase that describes the clip, you want to type in all or some of the file menus of the clip.

3. In the results box, click the clip to in sert it. Action button ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 102 | P a g e 1. On the View menu, point to Master Views , and then click Slide Master .

2. On the Home tab, in the Insert group, click Shapes , point to Action Buttons , and then click the action button that you want.

3. Drag across the location in the slide where you want the button to appear.

Tip: To change the size of the action button, drag a corner until the button is the size that you want. To keep the button width and height proportions the same, hold down SHIFT as you drag.

In the Action Set tings dialog, select how to initiate the action by doing one of the following:

Arrows:

1. In Microsoft power point, double click the chart.

2. Double click the chart item you want to change.

3. On the patterns tab, do one or both of the following.

4. To change the colors, patterns or lines, select the options you want.

To specify a fill effect, click fill effect and then select the options you want on the gradient,text patterns or picture tabs.

Hyperlink:

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 103 | P a g e 1. Select the text or object that you want to represent the hyperlink.

2. Click insert hyperlink.

3. Under link to, click place in this document.

4. Animations:

3. Select the object that you want to animate.

4. On the Animations tab of the ribbon, in the Animation group, click the More button, and the n select the animation effect that you want.

Step 1 Insert the picture by clicking the slide to which you want to add the picture, then click "Insert." Point to "Picture" and then click "From File." This opens the "Open" dialog box.

Browse to the picture you want to insert and double -click it or click "Open." Step 2 Right -click the inserted picture and click "Format Picture" from the pop -up menu. Click the "Picture" tab, then click the "Color" box arrow and select "Washout." Step 3

Right -click the picture and select "Save As Picture." Save the picture in a location that can be easily accessed.

Step 4 Delete the picture from the slide by clicking the picture and pressing the "Delete" key on the computer's keyboard.

Step 5 Click "Format," then click "Backgro und." Click "Background Fill," then click "Fill Effects." Click the "Picture" tab, then click "Select Picture." Navigate to the saved picture, click "Insert," click "OK" and then click "Apply" to insert it. The picture will appear as a washout, which looks faded in comparison to its original appearance.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 104 | P a g e Hide slide Select the correct slide. On the left side of your screen, you should see a list of all the slides in your presentation.

Click the one you wish to hide.

If you have successfully selected a slide, a box will appear around that slide.

Click Hide Slide. From the options within the Slide Show tab, find and click on the Hide Slide button. These options should be located near the top of the PowerPoint window.

If you have successfully hid a slide, there will be a slash over the number correlated with the hidden slide.

Repeat this process to hide multiple slides ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 105 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 106 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 107 | P a g e Record Notes

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 108 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 109 | P a g e

Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 110 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR

MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 111 | P a g e GOOGLE FORMS Introduction Google forms are a free Google application that allows you to quickly create and distribute a form to gather information. Form responses are saved in a Google spreadsheet in Google

drive.

Opening Google Forms Step 1. Open Google Chrome.

Step 2. Go to http://drive.google.com Step 3. Enter your full UWW email address, then click next.

Step 4. Enter your UWW password, then click Sign in .

You will now be signed into Google Drive.

Step 5. Select New > More > Google Forms from the available menu. Choose either a Blank form or From a template.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 112 | P a g e Editing Google Forms Creating a New Form from Template or by using a Blank form Step 1. The Template gallery General tab offers a number of form templates. Or, simply click on

Blank form to start from scratch.

Editing your form Step 1. Name the Form. Click the “Untitled Form” name in the top left corner of the screen, then enter the form’s name. Hit the “Enter” key to submit your changes. If using a template, click on the template title to change to a unique name of your choosing.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 113 | P a g e Step 2. Form description: Enter the description by clicking on that field. When using a template, you may find stock text in this field. Highlight and delete to replace with your description.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 114 | P a g e Edit Questions Step 1. Select “Untitled question” to enter your first question text.

Step 2. Use the dropdown to the right of the question to select the question type.

Step 3. Select each option to enter option text.

Step 4. Hit the “Enter” key to create a new option.

Note: Click the X to the right of each option to delete that option.

Note: Click the Add Other link to add an “Other” option to your list.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 115 | P a g e Add Questions Step 1. Use the question toolbar to the right to add a new question, insert a new title a nd description, inset a picture, insert a video, or add a new section.

Step 2. Follow the steps above to edit the new question.

Copy/Duplicate Question Copying a question allows you to quickly add a new question with the same format as your current question.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 116 | P a g e Delete Questions The delete button allows you to delete the selected question and options from the list.

Required Questions Select the “ Required” button to make a question required.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 117 | P a g e More Button The (More) button allows you to shuffle the order of questions and go to a new section based on a question answer.

Form Colors/Themes You can change the form color or theme by clicking the (Color Palate) button in the top right corner of the page.

Click the button to select a header image on a theme or upload your own.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 118 | P a g e Preview Form Click the “Preview” button to open a new browser tab with a final view of your form. Close out of that tab to return to the “Edit Form” view to make changes.

Advanced Form Settings Click the (Settings) button to customize your form.

General Tab: Allows you to restrict users from your form, collect email addresses of users filling out your form, limit 1 response, etc.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 119 | P a g e Presentation Tab: Allows you to display a progress bar, shuffle question order, and submit another form response. You can also modify your confirmation message once a user submits a form.

Quizzes: Allows you to set this form as a quiz, set grade options, etc.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 120 | P a g e Send Form Click the Send button to view different ways to distribute your form.

Send Via Email:

You can send your form via email to recipients or send the form email to yourself, then use Outlook to forward the form link to others.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 121 | P a g e Viewing Responses Click the Responses tab to view user responses to your form.

Summary: Shows a pie chart percentage of responses for each question.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 122 | P a g e Individual: Displays each form response individually. Click the < or > button to move between each response.

Close Form You can close the form for submission by selecting the Responses tab, then clicking the Accepting Responses toggle. You can modify the message respondants will see if they try to access your form while it is closed. Click the toggle again to reopen your fo rm.

ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 123 | P a g e Record Notes ENGINEERING AND COMPUTING HARDWARE WORKSHOP B.TECH – I YEAR MALLA REDDY COLLEGE OF ENGINEERING AND TECHNOLOGY 124 | P a g e

Record Notes