Introduction to Computers

 

Module 1

• Introduction

• What is a computer

• History of computers

• Features of Computer Systems

• Basic application of computer

• IT Gadgets and Their Applications

• Components of computer systems

• a) Hardware

• central processing unit

• Keyboard, Mouse and VDU

• Other input devices

• Other output devices

• Computer memory and storage devices

• b) Software

• Application Software

• System Software

• Utility Software

• Open Source and Proprietary Software

• Multimedia & Entertainment

Introduction to GUI Based Operating Systems

 

Module 2

• introduction

• Operating System

• Basics of popular operating systems [Linux, Windows]

• Operating system for mobiles and tablets

• User interface for desktops and laptops

• Taskbar

• sign

• Start Menu

• Run an application

• Operating System Simple Settings

• Change system date and time

• Change display properties

• To add or remove Windows components

• Change mouse properties

• Add and remove printers

• File and Directory Management

• Types of files

• Types of extensions

Elements of Word Processing

 

Module 3

• introduction

• Word Processing Basics

• Opening a word processing package

• Menu Bar

• Using help

• Using icons at the bottom of the menu bar

• Create a new document

• Open and close documents

• Opening the document

• Save and Save

• Page Setup

• Print Preview

• Printing of documents

• Save the document as a PDF file

• Text creation and manipulation

• Document Creation

• Edit text

• Text Selection

• Cut, copy and paste

• Font and size selection

• Alignment of text

• Undo and rework

• Format text

• Article Indenting

• Bullets and numbering

• Changing cases

• Headers and footers

• Table manipulation

• diagram table

• Changing the width and height of the cell

• Alignment of text in the cell

• Delete/insert rows and columns

• Border and Shading

• Shortcut Keys

spreadsheet

 

Module 4

• introduction

• Elements of electronic spread sheet

• Opening a spreadsheet

• Cell Address

• Enter data

• Page Setup

• Printing of spread sheet

• Save workbooks

• Manipulation of cells and sheets

• Enter text, numbers, and dates

• Create text, numbers, and date series

• Edit worksheet data

• Insert and delete rows, columns

• Changing cell height and width

• Sorting and Filtering

• Formulas, Tasks and Charts

• Using formulas for numbers (addition, subtraction, multiplication and division)

• AutoSum

• Tasks (Sum, Count, Max, MIN, Average)

• Charts (bar, pie, line)

Create small presentations

 

Module 5

• introduction

• Basics

• Using PowerPoint

• Open a PowerPoint presentation

• Save presentation

• Creation of presentation

• Create a presentation using a template

• Create a blank presentation

• Enter and edit text

• Insert and delete slides in a presentation

• Preparation of slides

• Insert a Word table or Excel worksheet

• Add clip art pictures

• Insert another object

• Resize and scale an object

• Providing aesthetics

• Enhance text presentation

• Working with color and line style

• Add movies and sound

• Adding headers and footers

• Presentation of slides

• View presentation

• Choose set up for presentation

• Print slides and handouts

• Slideshow

• Running slideshows

• Transition and slide time

• Automating slideshows

Computer Communication and the Internet

 

Module 6

• introduction

• Basics of Computer Networks

• Local Area Network

• Wide Area Network

• Network Topology

• Internet

• Internet and the concept of WWW

• Basics of Internet Architecture

• Services on the Internet

• World Wide Web and Websites

• Communication over the Internet

• Internet Services

• Preparing computers for Internet access

• ISPs and examples [broadband/broadband] Dialup/ WiFi]

• Internet Access Technology

• Web Browsing Software

• Popular Web Browsing Software (IE/IE) Mozilla Firefox Chrome/ Opera etc.)

• Configure a Web browser

• search engine

• Popular Search Engines/ Search for content

• Accessing a web browser

• Using favorite folders

• Download web page

E-mail Social Networking and E-Governance

 

Module 7

• Structure of e-mail

• Using e-mail

• Opening an email account

• Mailbox: Inbox and Outbox

• Create and send a new e-mail

• Reply to an e-mail message

• Forward e-mail messages

• Search email

• Attach files with email

• Email Signature

• Social Networking and E-Commerce

• Facebook, Twitter, LinkedIn, Instagram

• Instant messaging (WhatsApp, Facebook, Messenger, Telegram)

• Introduction to Blog

• Basics of E-Commerce

• Nitikets

• Overview of e-Governance Services like Railway Reservation, Passport, e-Hospital [ORS]

• Accessing e-Governance Services on Mobile Usage

• “Umang App”

• Digital Locker

Digital Financial Tools and Applications

 

Module 8

• Digital Financial Tools

• Understanding OTP [One Time Password] and QR [Quick Response] Code

• UPI [Unified Payment Interface]

• AEPS [Aadhaar Enabled Payment System]

• USSD [Unstructured Supplementary Service Data]

• Card [Credit/Credit] Debit]

• eWallet

• POS [Point of Sale]

• Internet Banking

• National Electronic Funds Transfer (NEFT)

• Real Time Gross Settlement (RTGS)

• Immediate Payment Service (IMPS)

• Online Bill Payment

Overview of future skills and cybersecurity

 

Module 9

• Introduction to

• Internet of Things [IoT]

• Big Data Analytics

• Cloud Computing

• Virtual Reality

• artificial intelligence

• Social & Mobile

• Blockchain Technology

• 3D Printing/ Additive Manufacturing

• Robotics Process Automation

• cyber security

• Need for cyber security

• Secure the PC

• Secure a smart phone

Libra sortcut keys

libra Question/Answer

 

Introduction [Module 1]

 

1. What is Computer

A computer is an electronic device that manipulates information, or data. It has the ability to store, retrieve and process data. You may already know that you can use the computer to write documents, send emails, play games, and browse the web. You can also use it to edit or create spreadsheets, presentations, and even videos.

2. History of computers

Before computers were developed, people used sticks, stones and bones as counting tools. As technology advanced and the human mind improved over time, more computing devices were developed such as Abacus, Napier Bones, etc. These tools were used as computers to perform mathematical calculations, but not too complex.

Some of the popular computing devices are described below, which evolve from the oldest to the latest or most advanced technology:

abacus

About 4000 years ago, the Chinese invented Abacus, and it is believed to be the first computer. The history of computers begins with the birth of Abacus.

Structure: Abacus is basically a wooden rack consisting of metal rods on which a layer of pearls is mounted.

Work of Abacus: In Abacus, beads were moved by the Abacus operator according to certain rules for performing arithmetic calculations. In some countries such as China, Russia, and Japan, Abacus is still used by their people.

Napier’s Bones

Napier’s Bones was a manually operated calculation tool and as the name indicates, it was invented by John Napier. In this device, they used 9 different ivory strips (bones) marked with numbers to multiply and divide for calculations. It was also the first machine to use a decimal point system for calculations.

Pascaline

It is also called arithmetic machine or addition machine. Blaise Pascal, a French mathematician-philosopher, invented it between 1642 and 1644. It was the first mechanical and automatic calculator. It is invented by Pascal to help his father, who is a tax accountant in his work or calculations. It can add and subtract in quick time. It was originally a wooden box with a series of gears and wheels. This is done by rotating the wheel such that when a wheel is rotated in a circle, it rotates the neighbor wheel and a series of windows are given on top of the wheels to read the yoga.

Stepped reckoner or leibniz wheel

Gottfried Wilhelm Leibniz, a German mathematician-philosopher, developed this device in 1673 by improving Pascal’s invention to develop this machine. It was originally a digital mechanical calculator, and was called a step reconnaissance because it was made of flute drums instead of gear (used in previous models of Pascaline).

differential engine

Charles Babbage, also known as the “father of the modern computer”, designed the differential engine in the early 1820s. The differential engine was a mechanical computer capable of performing simple calculations. It works with the help of steam because it was a steam-driven calculation machine, and it was designed to solve tables of numbers such as logarithmic tables.

 

Analytical Engine

Again in 1830 Charles Babbage developed another calculation machine that was the analytical engine. The analytical engine was a mechanical computer that used punch cards as input. It was able to perform or solve any mathematical problem and store information in the form of permanent memory (storage).

Tabulation Machine

An American statistician Herman Hollerith invented this machine in the year 1890. The tabuling machine was a mechanical tabulator based on punch cards. It was able to tabulate data and record or sort data or information. This machine was used by the US Census in the year 1890. Hollerith’s tabuling machine company was started by Hollerith and this company later became International Business Machine (IBM) in the year 1924.

differential analyst

Differential Analyzer was the first electronic computer introduced in the United States in the year 1930. It was originally an analog device invented by Onenover Bush. This machine has vacuum tubes to switch electrical signals to perform calculations. It was able to perform 25 calculations in just a few minutes.

Mark I

In the year 1937, major changes began in the history of computers when Howard Aiken planned to develop a machine that could perform large numbers of large calculations or calculations. In 1944, the Mark I computer was created as a partnership between IBM and Harvard. It was also the first programmable digital computer to mark a new era in the computer world.

Generations of computers

First generation computers

In the period 1940-1956, it was referred to as the period of the first generation of computers. These machines are slow, spacious and expensive. In this generation of computers, vacuum tubes were used as the basic components of the CPU and memory. In addition, they mainly relied on batch operating systems and punch cards. Magnetic tape and paper tape were used as output and input devices. For example ENIAC, UNIVAC-1, EDVAC, etc.

Second Generation Computers

Over a period of the year, 1957-1963 was referred to as the period of the second generation of computers. It was transistor computer time. In the second generation of computers, transistors (which were cheap in cost) are used. Transistors are also compact and consume less power. Transistor computers are faster than first generation computers. For primary memory, magnetic core was used, and secondary memory for storage purposes for magnetic disks and tapes. In second generation computers, COBOL and FORTRAN are used as assembly languages and programming languages, and batch processing and multiprogramming operating systems were used in these computers.

For example IBM 1620, IBM 7094, CDC 1604, CDC 3600, etc.

Third Generation Computers

In the third generation of computers, integrated circuits (ICs) were used instead of transistors (in the second generation). A single IC consists of multiple transistors that increase the power of the computer and also reduce the cost. Third generation computers are more reliable, efficient and smaller in size. It used remote processing, time-sharing, and multiprogramming as the operating system. FORTRON-II to IV, COBOL, and PASCAL ARE HIGH-LEVEL PROGRAMMING LANGUAGES that were used.

For example IBM-360 series, Honeywell-6000 series, IBM-370/168, etc.

Fourth Generation Computers

The period 1971-1980 was mainly the time of fourth generation computers. VLSI (Very Large Scale Integrated) circuit was used in this. VLSI is a chip that contains millions of transistors and other circuit elements and because of these chips, computers of this generation are more compact, powerful, faster and affordable (less in cost). Real-time, time-sharing and distributed operating systems are used by these computers. C and C++ are used as programming languages in this generation of computers. For example Star 1000, PDP 11, CRY-1, CRY-X-MP, etc.

Fifth Generation Computers

Since 1980 – to this day these computers have been used. ULSI (Ultra Large Scale Integration) technology is used in fifth generation computers instead of VLSI technology of fourth generation computers. Processor chips are used in these computers with ten million electronic components. Parallel processing hardware and AI (Artificial Intelligence) software are also used in fifth generation computers. Programming languages such as C, C++, Java, .NET, etc. is used. for example desktop, laptop, notebook,

Ultrabook, etc.

3. Features of Computer Systems

• Speed – Computers are faster than humans.

• Accuracy – Computers are always accurate.

• Versatility – Computers create different types of jobs.

• Storage capacity – Storage space is limited only by the amount of storage you purchase.

• Hard work – Computers don’t get tired.

• Reliability – Computers are highly reliable machines and have a long failure-free life.

• Automation – Repeat a process automatically.

movement

Computers are capable of processing data at high speeds in seconds that take humans hours to complete.

• Today’s powerful computers process millions of instructions per second.

• The speed of a computer is measured in terms of microseconds, nanoseconds, and even picoseconds.

veridicality

Computers are very accurate. If the error occurs, it is only because of humans. The degree of accuracy of a computer depends on its hardware and software design.

versatility

A computer is a versatile tool. Computers are not only handling complex arithmetic, but can also do many types of work.

• Computers can be programmed to perform any task that can be organized as a series of logical steps.

• For example, computers and computing devices are used in every possible scenario such as

  • Railway or airline reservations

  • banking

  • Publishing exam results

  • Ecommerce

  • search

  • Get information

  • Hotel

  • Hospitals

  • Office Administration

  • Launch of satellites

  • Monitoring of patients

  • Analysis of large amounts of data

  • And so on.

storage capacity

A computer’s storage can store millions of documents or images, audio or video or any other type of data.

• • Such data can be retrieved as needed.

  • Computers have primary memory and secondary memory.

  • The user of the computer can temporarily store and remember the same information in primary memory

  • Users can also use secondary storage devices (hard disks, SSDs, compact disks, external hard drives, tapes) to permanently store large amounts of data.

labour

The computer is not like a human being.

• • Humans get tired at some point in their working hours and may lose their focus.

Computers can work continuously without getting tired or bored and produce error-free results.

• • If we want to execute 10 million instructions, computers will perform the last one with the same speed and accuracy as the first one.

reliability

A computer is a relatively highly reliable machine.

The computer has a long failure-free life.

• • The maintenance of the computer is relatively easy.

  • If a part of the computer fails, it will be replaced or repaired at minimal cost.

automation

• • With automation, you can produce a million products after providing the right input.

  • Example: robotic computer, factory powered by computer powered cars.

  • Once you provide a line of tasks to the computer, it can continue to move until it completes all the tasks.

  • Humans need to instruct computers to perform tasks. Using these instructions, the processing of the task can be controlled without human contact.

  • In recent years, computer software applications are trained to find problems automatically using a concept called machine learning.

4. Computer Application

         Basic application of computer

Computer Application

Basic applications of computers- Nowadays computers have been employed in almost all aspects of professional and personal life. Some of the areas where computers are being used are as follows:

1. Education computers- have proved to be excellent teachers. Educational institutions are using computers in many ways such as tele-education, virtual classrooms, online classes, etc.

2. Science and engineering- scientists have been its users for a long time. A new adventure among scientists is the idea of a collaborative, an internet-based collaborative laboratory, in which researchers from around the world can easily work together even at distances.

3. Industry computers- are used here to control the continuous operation of manufacturing systems and machinery. Parameters such as temperature, pressure, volume are monitored and controlled by computers. Robotics, developed with the help of computers, plays a very important role here.

4. Entertainment Our entertainment- and enjoyment time has also been influenced by computerization.

5. Administration-Various departments of the administration government use computers for their planning, (Morgencontrol and law enforcement activities).

6. Health computers- play a very important role in this field. Activities like scanning, X-ray, tele-medicine, patient monitoring, patient records, diagnosis, etc. are done with the help of computers.

7. Multimedia – This is the field related to the computer controlled integration of text, graphics, images, animation, audio and any other media where each type of information can be digitally represented, stored, transmitted and processed.

8. Bank Computers- Used in Banks/ Banks Can be used to keep records of customer accounts.

9. Military personnel – they also use computers for their important tasks such as determining the weather, calculating the trajectory of missiles, etc.

10. Business- Using a wide range of business software a company’s marketing division can produce sales forecasts and formulate new strategies.

11. Commerce- This is the activity of buying and selling goods and services on a particular large scale.

12. Publishing Computer – has made the publishing process an easy one. Without a computer, the various parts of the publication—text, images, and graphics—must be created individually, then cut and pasted to create a page layout.

Components of computer systems

5. a) Hardware

Hardware, abbreviated as HW, refers to all physical components of a computer system, including the equipment associated with it. You cannot create a computer or use software without using hardware. The screen on which you are reading this information is also a hardware.

central processing unit

A central processing unit is also called a processor, central processor or microprocessor. It fulfills all the important functions of the computer. It receives instructions from both hardware and active software and produces outputs accordingly. It stores all important programs such as operating systems and application software. CPU also helps input and output devices to communicate with each other. Due to these characteristics of the CPU, it is often referred to as the brain of a computer.

The CPU is installed or inserted into the CPU socket located on the motherboard. In addition, it provides a heat sink to absorb and destroy heat to keep the CPU cool and work smoothly.

 

Generally, a CPU has three components:

• ALU (Arithmetic Logic Unit)

• control unit

• Memory or storage unit

Keyboard, Mouse and VDU

A keyboard is one of the primary input devices that allows users to input text into a computer or any other electronic machinery. It is a peripheral device that is the most basic way for the user to communicate with the computer. It consists of several buttons, which create numbers, symbols, and letters, and creates special keys such as Windows and Alt keys, including performing other tasks. The design of the keyboard comes from the typewriter keyboard, and the numbers and letters on the keyboard are arranged in that way, which helps to type quickly.

The above keyboard design is called QWERTY design because the upper-left corner of the keyboard consists of its first six letters. Although the keyboard design is derived from typewrite, nowadays, it has many other keys as well as alt/ip keyboard. Options, controls, and Windows keys are also included, which can be used as shortcuts to perform special operations in conjunction with other keys. For example, if you press Control + S while you work on a document, it will save the document you are working on. In addition, most keyboards have function keys (F1 to F12 or F16) at the top of the keyboard and the arrow keys are arranged in the negative side used to perform many tasks.

Types of Keyboard

Most computer users use a standard keyboard, which connects to the computer. Although there are many types of computer keyboards, such as the following are:

1. Flexible Keyboard: This is a kind of keyboard made of soft silicone with highly portable. It is water and dust resistant and does not require frequent cleaning. It functions similarly to a standard keyboard and the connection connects to the computer via a serial port. These types of keyboards can also be more durable in some ways than traditional keyboards.

The flexible keyboard is made of soft silicone which protects it from many different substances. For example, if you use a keyboard near a liquid space, silicone skin provides excellent protection against spills. In addition, it does not sound when used; That is why it is also called silent keyboard. These keyboards are useful for travel time as they can be rolled into a bag and made flexible in outdoor conditions.

2. Wireless keyboard: It is a computer keyboard that is connected to a computer, laptop or tablet without any cable. Users can move the wireless keyboard around without placing it on the desk as it offers users portability and flexibility. It is designed by stainless steel material which extends its life for a long time. It can set up very easily by plugging the USB receiver into the computer. It uses light waves to transmit signals to other infrared-enabled devices because it is based on infrared technology. Some wireless keyboards use radio frequency technology, which communicates through signals with a range from 27 MHz to 2.4 GHz.

3. Mechanical keyboard: It is made with high quality which is commonly used in both home and office. It is designed for long life with high durability and responsiveness. It provides crisp click sound, moderate resistance, and better response to gaming performance and final typing. It offers better features such as framing, switches, type print methods, functionality, PCB board, key construction, lighting, or more than traditional rubber dome keyboards.

4. Virtual Keyboard: This is a software-based keyboard that enables users to type without the need for physical keys. It is an alternative to a physical keyboard or digital representation of a QWERTY keyboard. This type of keyboard usually consists of several pages of characters, including numbers, letters, punctuation marks, and symbols. Some virtual keyboards also include options to insert emojis, stickers, or animateds, depending on the device’s operating system. Devices with virtual keyboards are tablets, smartphones and other portable devices, as these devices do not require the constant use of physical keyboards.

Examples of virtual keyboards

5. Gaming Keyboard: A keyboard that contains some specific keys used for gamers is known as a gaming keyboard. W, S, D, A, and arrow keys are widely used for games on standard QWERTY keyboards. Gaming keyboards (mostly mechanical keyboards), the key replaces unnecessary depression that provides fast action for the game.

Mainly used on US keyboards today. Sol, Christopher Sholes and Carlos Gleeden created a type-writer whose picture is shown below:

 

rat

The mouse is a small, movable device that lets you control a series of things on a computer.  Most types of icons have two buttons, and some will have a wheel in the middle of the buttons. Most types of mouse connect to a computer by cable, and use the power of a computer to work.

V.D.U.

The monitor, commonly called the Visual Display Unit (VDU), is the main output device of a computer. It creates images from small points, called pixels that are arranged in rectangular form. The sharpness of the image depends on the number of pixels. Two types of viewing screens are used for the monitor.

Other input devices

An input device is a term for a physical piece of hardware that connects to a primary device such as a computer to provide user input. Input devices are generally a class of peripheral devices that connect to the primary device. Top examples include: keyboard.

    List of input devices

• keyboard

• rat

• scanner

• Light pen

• Barcode Reader

• microphone

• Touchscreen

• joystick

• webcam

Other output devices

Output devices are used to convert computer-produced output into a human-readable form. The output device takes information from the computer and presents it on projection, display or paper.

Examples of computer output devices

• A monitor is an output device that displays the output as images on a digital screen. …

• Printer is another peripheral device used as an output device. …

• …

• Computer speaker. …

• …

• GPS (Global Positioning System) …

• Sound card. …

•  

 

6. Computer memory and storage devices

Computer Storage Device Definition: A hardware device that can be used to store digital data and applications that can be in the form of images, video, audio, etc. is called a storage device. It is a major component of a computer and the hard drive is one of its examples.

7. b) Software

Software is a set of instructions, data or programs that are used to operate a computer and perform specific tasks. This is in contrast to hardware, which describes the physical aspects of a computer. Software is a general term used to refer to applications, scripts, and programs running on a device.

1. Application Software

What is Application Software?

The term “application software” refers to software that performs specific tasks for the user. When a user directly interacts with a piece of software, it is called application software. The sole purpose of application software is to assist the user in performing specified tasks. Popular web browsers like Microsoft Word and Excel, as well as Firefox and Google Chrome, are examples of application software. It also includes a range of mobile apps, including apps like WhatsApp for communication and games like Candy Crush Saga. There are also app versions of popular services, such as weather or transportation information, as well as apps that allow users to connect with businesses. Global Positioning System (GPS), graphics, multimedia, presentation software, desktop publishing software, and so on are examples of such software.

2. System Software

System software is a type of computer program designed to run a computer’s hardware and application programs. If we think of computer systems as a layered model, then system software is the interface between hardware and user applications. The operating system is the most well-known example of system software.

8. Utility Software

Utility software includes all systems and programs on a computer system that maintain its functionality. A computer’s utility software includes components that help the operating system optimize, maintain, organize, and manage how it functions in all situations.

9. Open Source and Proprietary Software

One way to classify software is through ownership and licensing. There are two types of proprietary and licensing software:

• Open Source Software

• Proprietary Software

While both types of software are usually widely available, they differ significantly in what they can and cannot be done.

Open source software can be free of copyright and is usually available to anyone. The proprietary software is copyrighted and only available under license.

10. Multimedia and Entertainment

Multimedia is often used in the entertainment industry which is mainly used  in making movies, short films, 2D animations, 3D animations and VFX. Multimedia games are the talk of the town these days that can be accessed online with a good internet connection.

Introduction to GUI Based Opterating Systems [Module 2]

Operating System

An operating system (OS) is a program that, after initially loaded into a computer by a boot program, manages all other application programs in the computer. Application programs use the operating system by requesting services through a defined application program interface (API).

Basics of popular operating systems [Linux, Windows]

 

An operating system is the most important software that runs on a computer. It manages the computer’s memory and processes as well as all its software and hardware. It allows you to communicate with the computer without knowing how to speak the computer’s language.  Without an operating system, a computer is useless.

Linux

Linux (pronounced LINN-ux)  is a family of open-source operating systems, meaning they can be modified and distributed by anyone around the world. This is  different from proprietary software like Windows  , which can only be modified by the company that owns it. The advantages of Linux are that it’s free, and there are many different distributions—or versions—you can choose from.

Microsoft Windows

Microsoft created the Windows operating system in the mid-1980s. There have been many different versions of Windows, but the most recent are Windows 10 (released in 2015), Windows 8 (2012), Windows 7 (2009), and Windows Vista (2007). Windows  comes pre-loaded on most new PCs  , which  helps make it the most popular operating system in the  world  .

User interface for desktops and laptops

A GUI (Graphical User Interface) is a system of interactive visual components for a computer. A GUI displays objects that convey information, and represent actions that the user can take. Objects change color, size, or visibility when the user interacts with them.

Computers, like desktops and  laptops, usually use graphical user interfaces. Some software however use different interfaces, such as command prompts using a text-based interface. Handheld devices also commonly use graphical user interfaces.

Taskbar

Taskbar is a user interface component in the Microsoft operating system that allows quick access to open applications, files, and system settings. It’s usually located at the bottom of the screen and provides quick access to important features like the Start menu, system tray, and task manager. To start applications, switch between open applications and access system settings, and users can use the taskbar. Additionally, the taskbar can be changed to fit the user’s needs and preferences. For example, the size and placement of icons can be changed, and new icons can be added for commonly used programs.

sign

 

 Icons are small graphics that are used to symbolize common functions, files, devices, and directories ·              Content symbol variables  are icon fonts, a new font format.

    Start Menu

 

The Microsoft Windows Start menu is the primary location in Windows for locating your installed programs and finding any files or folders. By default, the Start menu can be accessed by clicking in the lower-left corner of the Windows screen. The picture shows an example of the Windows 7 Start menu.

Run an application

1) To execute a program. The phrases “run the program” and “launch the program” are synonyms. (2) A single program or set of programs earmarked for execution. (3) In Windows, a command in the Start menu that lets you run programs directly.

 

Operating System Simple Settings

Step 1 − Go to “Control Panel” from the Start menu.

Step 2 − Select “Hardware and Sound” and select “Device and Printer” from the options listed.

Step 3 − Click “Mouse” under Devices and Printers, and change any of the following properties and change the “Apply” change.

 

Change system date and time

 

To set your time and time zone in Windows 10 , start the date and time > time and language > > settings.

Change display properties

Most advanced display settings from previous versions of Windows are now available on the Display Settings page.

•  Select Start  > System  display > settings > Settings.

• If you want to resize your text and apps, choose an option from the drop-down menu under Scale and Layout. To change your screen resolution, use the drop-down menu under Display Resolution. NOTE: You should use the recommended solution. If you change the resolution, the content may appear blurry or pixelated.

• To adjust your color calibration, search for “Calibrate display color” in the Settings search box and follow the instructions.

• If you don’t see the setting you’re looking for, try searching for it in the Search box on the taskbar.

To add or remove Windows components

In this, go to Programs > Programs and Features and click or tap the “Turn Windows Features on or off” option on the left. The Windows Features window opens, displaying a list of features that you can add or remove according to your preferences.

  Change mouse properties

 

Change mouse settings

1. Open the mouse properties by clicking the Start button. , and then click Control Panel. …

2. Click the Buttons tab, and then do any of the following: To swap the functions of the right and left mouse buttons, under Button Configuration, select the Switch Primary and Secondary Button check boxes. …

3. Click OK.

Add and remove printers

Adding printer: Windows

If your printer doesn’t connect via USB, and you don’t have setup instructions or drivers, follow these steps.

1. Turn off the PC and connect the printer. Power on both PCs and printers.

2. In Windows 7, click Start, Devices, and Printers. In Vista, click Start, Control Panel, Hardware and Sound, Printers.

3. Click Add Printer .

4. If the printer is physically connected to the PC, click Add Local Printer. If the printer is connected wirelessly or over the network, go to step 5.

4a. Select Use an existing port, and then select your printer port from the drop-down list  . Click Next.

4b. Select your printer manufacturer and model from the two lists. If your model is not listed and your system is connected to the Internet, click the Windows Update button  . If you have a driver on the disc or CD, or if you downloaded a file,  click Drive Have…   To point Windows to the driver you want to use. Click Next.

Assign a custom name to your printer, if you want an easy way to identify it.  Click  Next.

4d. When prompted, select the sharing option. If you are unsure what to do,  select Do not share this printer. Click Next.

4e. Click Print Test Page to confirm the successful installation  .   Click Finish.

5. If your printer is connected wirelessly or over a network, click Add Network, Wireless, or Bluetooth Printer.

 Select the printer you want to install from the list. Click Next.

5b. When prompted,  click Install Driver. Click Next.

5c. Click Print Test Page to confirm a successful installation  .   Click Finish.

Printer addition: OS X

If OS X does not automatically recognize your printer, and you do not have setup instructions or drivers, follow these steps.

1. Open System Preferences, and then open Print and Fax.

2. Click + (plus icon) at the bottom of the Printer pane to add a printer.

3. Click the Default button . OS X will display a list of all available printers, both wired and wireless.

4. Select the printer you want to install. Click Add.

Printer removal: Windows

1. In Windows 7, click Start, Devices and Printers. In Vista, click Start, Control Panel, Hardware and Sound, Printers.

2. Right-click the printer you want to remove. In Windows 7, click Remove Device. In Vista, click Delete.

Printer removal: OS X

1. Open System Preferences, and then open Print and Fax.

2. Select the printer you want to remove from the Printer pane, and then click – (minus icon).

3. Confirm that you want to remove the printer by clicking Delete Printer.

File and Directory Management

The root directory is created when we start formatting the disk and  putting files on  it. In it, we can create new directories called “sub-directories”. root.

file of steel

The file is nothing but a collection of information. The information can be of numbers, characters, graphs, images, etc. Each file should be stored under a unique name for its future reference. Each file must be saved with extensions. Some extensions and their details are given below −

representation

The file should be represented in the address bar with the file path, file name, and extension.

For example: C:\Windows\system32\Hello.htmlin which the C:\Windows\system32 path →   Hello → file name   .html → expansion.

Directory Management

Directory is a location/directory. Field/ The location where a set of files will be stored. It is a folder that contains details about files, file size, and the time when they are created and last modified. The different types of directories are discussed below −

Root Directory

The root directory is created when we start formatting the disk and putting files on it. In it, we can create new directories called “sub-directories”. The root directory is the highest level directory and is viewed when booting the system.

deputy director

The subdirectory is a directory inside the root directory, in turn, it can have another subdirectory.

Types of files

 

6 Different Types of Files and How to Use Them

• . JPEG.

• .PNG.

• .GIF.

• .PDF.

• . SVG.

• .MP4.

 

Types of extensions

Common Windows File Extensions

File Extensions	File Type
DIF	Data Interchange Format
DOC or .DOCX	Microsoft Word for Windows/Word97
EPS	Encapsulated PostScript
..EXE	PC Applications

Elements of Word Processing

 

Module 3

Word Processing Basics

 

Editing in word processing may include the following tasks:

• Adding text (words, phrases, paragraphs, etc.)

• Delete a portion of text.

• Copying text.

• Moving text.

• Paste text.

• Grammar and spelling checks.

• Text formatting.

Opening a word processing package

Word processing packages are mostly used in offices on microcomputers. To open a new document, click on the “Start” button and go to “All Programs” and click on “Microsoft Word”.

Menu Bar

The menu bar is part of a browser or application window, usually on the top left, with drop-down menus that allow the user to interact with content or applications in a variety of ways.

 

Using help

 

You can also access Help from the File menu. In any Office application, click File and in the upper right corner, click the Familiar ? button. Or use the F1 function key at any time to open the Help Viewer window for the Office application you are working on.

 

Create a new document

 

Create a document

1. Open Word. Or, if Word is already open, select New > file.

2. In the Search online template box, enter a search term, such as letters, resumes, or invoices. Or, select a category such as business, personal or education under the search box.

3. Click the template to view the preview. …

4. Select Create.

 

Open and close documents

Word automatically starts with a blank page. To open a new file, click “New”. To close the document, click “X” in the upper right corner of the window.

Opening the document

 

Open an OpenDocument text file in Word Click the File tab.

1. Click Open.

2. To view files that are saved only in OpenDocument format, in the Type file list, click OpenDocument Text.

3. Click the file that you want to open, and then click Open. Tip: To open the file, you can also double-click it after you find it.

 

Save and Save

The difference between save and save is that Save allows you to update an already saved file with new content, whereas Save Us allows you to save a new file or existing file to a new location with the same or different name .

 

Page Setup

Page Setup has user-defined parameters that help determine how the printed page appears. Those parameters can include everything from size, margin, page orientation,  and quality of print.

 

 Print Preview

Click Print > File. To preview your file, click Print Preview. To return to your file and make changes before you print it, click the File tab again. To print your file and check or change the properties of your printer,  Click Print.

 

Printing of documents

Click Print > File. To preview your file, click Print Preview. To return to your file and make changes before you print it, click the File tab again. To print your file and check or change the properties of your printer,  Click Print.

Save the document as a PDF file

In the File name box, enter a name for the file, if you have not already. In the Save as type list, select PDF (*.pdf). If you want the file to open in the selected format after you save, automatically select the view file after you save the check box.

Text creation and manipulation

Text manipulation usually refers to the ability to change typed words, sentences, and paragraphs. Manipulation can include changing characters (letters and symbols), adding line breaks, changing the direction of the text and the case of characters (capital letters or small letters).

Document Creation

Document creation (also known as document automation, document creation, document assembly, or document preparation) software allows you to convert text-based documents (typically, word-processing files) and PDF forms into powerful productivity tools called templates.

Word is already open, select new > blank document > the file. Create a document by using a template. Open Word. Or, if Word is already open, select New > file. Double-click the template to open it.

Edit text

The ability to change text by adding, deleting, and rearranging letters, words, sentences, and paragraphs. The main operation in text editing word processors is performed by users, who usually also handle graphics and other multimedia files. View text editors and word processing.

Text Selection

Select text

Selecting text is a very common and frequently used operation. It is used many times and in many ways. For example, if you need to delete text (specific or complete paragraph) you need to select it first. Similarly, in many operations the selection of text is the first basic operation or minimum requirement. So, in this article, we will look at how to select text in different ways:

• Single-word: Quickly double-click that word with the mouse to select a word in MS-Word.

• Line of text: To select a line of text, place your cursor at the beginning of the line and then press “Shift + Down Arrow”.

Paragraph: To select the entire paragraph, place your cursor at the beginning of the paragraph and then press “Ctrl + Shift + Down arrow”.

 

 

Cut, copy and paste

 

1. Cut- Select cut. Or press Ctrl + X.

2. Lei- Select Paste. Note: Paste only uses your most recently copied or cut items.

3. Copy- Select Copy or press Ctrl + C.

 

Font and size selection

Change the size of the selected text

Select the text or cells that you want to change. To select all the text in a Word document, press Ctrl + A. On the Home tab, click Font Size in the Font size box.

 

• Alignment of text

Text alignment is a paragraph formatting attribute that determines the presence of text throughout the paragraph. For example, in a paragraph that is left-aligned (the most common alignment), the text is aligned with the left margin. In a paragraph that is appropriate, the text is aligned with both margins. Align the text left.

 

• Undo and reverse

To undo an action, press Ctrl + Z. To perform a undone action again, press Ctrl + Y.

 To redo something you’ve undo, press Ctrl+Y or F4. (If F4 doesn’t work, you may need to press the F-lock key or the FN key, then F4). If ..

 To reverse your last undo, press CTRL+Y. You can reverse more than one action that has been undone. You can  use the reado command  only after the   undo  command. Select All

To reverse your last undue, press CTRL+Y

Command Shortcut Key: Process

Undo CTRL+Z- To reverse your last action, press

Ctrl +V Paste- Place the cursor anywhere

Reado is the opposite of undo: it recreates the action you’ve undoed. For example, if you decide you do this, eventually, want to delete the item you have.

 

Format text

 

Add and format text

1. Select the text that you want to format. To select a word, double-click it. To select a line of text, click to the left of it.

2. Select an option to change the font, font size, font color, or make the text bold, italic, or underline.

 

Article Indenting

First-line demand by default

1. Place the cursor anywhere in the paragraph.

2. On the Home tab, right-click General Style, and select Modify.

3. Select the format, and then select paragraph.

4. On the Indents and Spacing tab, under Indentation, select the first row.

5. Select OK.

6. Select OK again.

Bullets and numbering

In bulleted lists, each paragraph begins with a bullet character. In numbered lists, each paragraph begins with an expression that includes a number or letter and a separator such as a period or parent. The numbers in the numbered list are automatically updated when you add or remove paragraphs to the list.

 

Changing cases

 To use keyboard shortcuts to change between capitalizing the lowercase, uppercase, and each word, select the text and press SHIFT+F3 as long as you want.

These dialog boxes have options:

• A matter of punishment. This option capitalizes on the first letter of each sentence in the selection.

• This option makes all selected text lowercase.

• This option capitalizes on each letter in the selection.

• Title case. …

• Toggle case.

 

Headers and footers

A header is a text that is placed at the top of a page, while a footer is placed at the bottom or foot of the page. Generally these fields are used to insert document information, such as document name, chapter title, page number, creation date, and so on.

 

Table manipulation

Manipulation of the table includes dragging a table, changing the width and height of the cell, alignment of text in the cell, deletion/deletion of rows and columns. Insertion, and borders and shading included.

The manipulation operation involves selecting, inserting, deleting, and updating data in the SQL database. Select – We can select one or more data from the table.

 

 

diagram table

• Select the Table Insert > diagram table >.

• Draw a rectangle to create the boundaries of the table. Then draw lines for columns and rows inside the rectangle.

 

Changing the width and height of the cell

Set a row to a specific height

1. Select the row or rows that you want to change.

2. On the Home tab, in the Cells group, click Format.

3. Under Cell Size, click Row Height.

4. In the Row height box, type the value that you want, and then click OK.

 

 

 

Alignment of text in the cell

Select the cells that contain the text that you want to align. To align text horizontally, select Align text left, center, or text right. When you have a long line of text, part of the text may not be visible. To fix it without changing column width, click Wrap Text.

If you want to re-align text in a cell to enhance the visual presentation of your data, here’s how you can do it:

1. Select the cells that contain the text that you want to align.

2. Choose one of the following alignment options on the Home tab:

3. To align text vertically, select Top Alignment , Middle Alignment , or Bottom Align .

4. To align text horizontally, select Align text left , center , or text right .

5. When you have a long line of text, part of the text may not be visible. To fix it without changing column width, click Wrap Text.

6. To center text in several columns or rows, click Merge and Center.

 Delete/insert row and column

1. Select the cells, rows, or columns that you want to delete.

2. Right-click, and then select the appropriate deletion option, for example, Delete and Shift Cells, Delete and Move Cells to the Left, Delete Rows, or Delete Columns.

 

Border and Shading

Boundaries are rules that you can add to any or all of the four sides of a paragraph. Shading is the color or artistic design that you use as the background for a paragraph. Borders and shading are formatting tools to enhance text, paragraphs, table cells, or frames.

Short cut keys :

MS Word Shortcut Keys List
Shortcuts	Uses of Shortcut keys
Ctrl+A	Select All
Ctrl + ⓑ	Bold
Ctrl + C	Copy text
Ctrl+I	Italicize highlighted selection
Ctrl + F	Find
Ctrl + H	Find and replace
Ctrl + J	Justify paragraph alignment
Ctrl + X	Cut selected text
Ctrl + N	Open a new/blank document
Ctrl + O	Open
Ctrl + P	Open the print window
Ctrl + K	Insert link
Ctrl + U	Underline highlighted selection
Ctrl + V	Paste
Ctrl + G	Find and replace options
Ctrl+Shift+=	Set chosen text as superscript.
Ctrl+=	Set chosen text as a subscript.
Ctrl + L	Align selected text or line to the left
Ctrl + Q	Align selected paragraph to the left
Ctrl + E	Align selected text or line to the center
Ctrl + R	Align selected text or line to the right
Ctrl + M	Indent the paragraph
Ctrl + T	Hanging indent
Ctrl + D	Font options
Ctrl + Shift + F	Change the font
Ctrl + Shift + >	Increase selected font +1
Ctrl + ]	Increase selected font +1
Ctrl + [	Decrease selected font -1
Ctrl + Shift + *	View or hide non printing characters
Ctrl + (Left arrow)	Move one word to the left
Ctrl + (Right arrow)	Move one word to the right
Ctrl + (Up arrow)	Move to the beginning of the line or paragraph
Ctrl + (Down arrow)	Move to the end of the paragraph
Ctrl + Del	Delete the word to the right of the cursor
Ctrl + Backspace	Delete the word to the left of the cursor
Ctrl + End	Move the cursor to the end of the document
Ctrl + Home	Move the cursor to the beginning of the document
Ctrl + Space	Reset highlighted text to the default font
Ctrl + 1	Single-space lines
Ctrl + 2	Double-space lines
Ctrl + 5	1.5-line spacing
Ctrl + Alt + 1	Change text to heading 1
Ctrl + Alt + 2	Change text to heading 2
Ctrl + Alt + 3	Change text to heading 3
Shift + F3	Change case of selected text
Shift + Insert	Paste
F4	Repeat the last action performed (Word 2000+)
F7	Spell check selected text and/or document
Shift + F7	Activate the thesaurus
F12	Save as
Ctrl + S	Save
Shift + F12	Save
Alt + Shift + D	Insert the current date
Alt + Shift + T	Insert the current time
Ctrl + W	Close document

spreadsheet

 

Module 4

 

Elements of electronic spread sheet

• Open an existing worksheet. …

• Rename the worksheet. …

• Organization of the worksheet. …

• Cell address. …

• Menu bar. …

• The mathematical formula appears in the formula bar when the cell that includes the formula in the worksheet is selected. …

• Save workbooks.

 

Opening a spreadsheet

 

Click File, and then click New. If you want to start with the equivalent of a blank grid, click the blank workbook. If you want a head-start on a particular type of workbook, choose one of the templates available on the Office.com.

 

 

 

Cell Address

A reference is the address of a cell. It identifies a cell or category of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.

Enter data

Data entry is the process of transcribed information into an electronic medium such as a computer or other electronic device. This can be done either manually or automatically using a machine or a computer.

When you want to manually enter data into Excel, you have several options. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data you enter can be the number, text, date, or time. You can format the data in different ways.

Page Setup

Page Setup has user-defined parameters that help determine how the printed page appears. Those parameters can include everything from size, margin, page orientation,  and quality of print.

Printing of spread sheet

To print the entire worksheet, select the print > print > file. Make sure that the entire workbook is selected. If you have Excel Desktop Application, you can set more print options. Select Open in Excel and select multiple print areas on the worksheet.

Save workbooks

• Click file > Save As.

• Under Save As, select the location where you want to save your workbook. …

• Click Browse to find the location you want in your Documents folder. …

• In the File name box, enter a name for a new workbook. …

• To save your workbook in a different file format (such as…

• Click Save.

 

Manipulation of cells and sheets

The manipulation of cells is entering and modifying the contents of cells. Enter text, number, and date.

Observing, examining, and/or observing cellular responses. Or a collection of means for accurate control of the static or dynamic state of individual biological cells for the purpose of changing or changing.

Enter text, numbers, and dates

 

Enter text or number in the cell

1. On the worksheet, click Cell.

2. Type the numbers or text that you want to enter, and then press ENTER or TAB. To enter data on a new row within a cell, enter a line break by pressing ALT+ENTER .

  Below are the steps to do this:

1. Select the cells that contain the number that you want to convert to date.

2. Click on the ‘Home’ tab.

3. In the Numbers group, click the Number Formatting drop-down.

4. In the drop-down, select the ‘Long date’ or short date’ option (based on what format you want to keep these numbers in)

 

Create text, numbers, and date series

Create a text series

1. Select the cell that contains the start text.

2. Then drag the Fill handle (+) to the cell where you want to fill out the text.

Edit worksheet data

You edit a worksheet to change the way the worksheet looks or behaves. For example, you might want to change the layout of the worksheet data, or add calculations, percentages, or totals.

 

Insert and delete rows, columns

Insert or delete columns

1. Select any cell within the column, then go to the Home >  > insert the sheet column  or delete the sheet column.

2. Alternatively, right-click the top of the column, and then select Insert or Delete.

Insert or delete a row

1. Select any cell within the row, then go to the home > > insert sheet rows or delete sheet rows.

2. Alternatively, right-click the row number, and then select Insert or Delete.

Changing cell height and width

 

1. Select the column or column that you want to change.

2. On the Home tab, in the Cells group, click Format.

3. Under Cell size, click column width.

4. In the Column width box, type the value that you want.

5. Click OK.

Resize rows

1. Select a row or range of rows.

2. On the Home tab,  select Format >  row width (or row height).

3. Type the width of the row and select OK.

Resize columns

1. Select a column or range of columns.

2. On the Home tab,  select Format >  column width (or  column height).

3. Type the width of the column and select OK.

Sorting and Filtering

You sort data to quickly organize your data and find the data you want. You filter the data for one or more columns of data to display only the rows that you specify and hide the rows that you do not want to display.

Select the cell in the column that you want to sort. Select sort and filter and how you want to order it: sort A into Z, sort Z into A, or custom sort . For custom sort: Sort, sort, and select order sort criteria. To set additional filters, select Add Level and choose your sort criteria.

Formulas, Tasks and Charts

Formula is an expression that calculates the value of a cell. The functions are predefined formulas and are already available in Excel.

For example, =A2 +A2+A3+A4 is a formula that adds values from cells A2 to A4. Function is a predefined formula that is already available in Excel. Functions perform specific calculations in a particular order based on specified values, called arguments or parameters.

Using formulas for numbers (addition, subtraction, multiplication and division)

Formulas for addition, subtraction, multiplication and division in Excel

organising	mathematical operator	example
amount	+	= 10 + 5
deduction	–	= 15-10
multiplication	x	= 5 * 3
division	÷	= 15/5

 

 

AutoSum

 

AutoSum is a Microsoft Excel and other spreadsheet program function that ties together a series of cells and displays the total in the cell.

Tasks (Sum, Count, Max, MIN, Average)

 

The average function calculates the average, or arithmetic mean, of its arguments. The Max function finds the maximum value.

The MIN function finds the minimum value.

The sum function calculates the sum of its arguments.

Sum – The sum of all numbers in rows that match this criterion.

Average – the average of all numbers in rows that match this criterion.

Max – the highest number in all rows that match this criterion.

Min – The lowest number among all rows that match this criterion.

Charts (bar, pie, line)

A bar graph shows comparisons between categories. A pie chart is used to represent and compare parts of the whole.

The bar graph showing data in intervals is called a histogram.

A line graph is used to display data that changes continuously over a period of time.

EXCEL SHORT CUT KEYS

• CTRL+N = CREATE A NEW WORKBOOK

• CTRL+O = OPEN AN EXISTING WORKBOOK

• CTRL+S = SAVE A WORKBOOK

• CTRL+W = CLOSE A WORKBOOK

• CTRL+A = SELECT ALL CONTENTS OF THE WORKSHEET

• CTRL+B = BOLD HIGHLIGHTED SELECTION

• CTRL+I = ITALIC HIGHLIGHTED SELECTION

• CTRL+K = INSERT LINK

• CTRL+U = UNDRELINE HIGHLIGHTED SELECTION

• CTRL+F4 = CLOSE EXCEL

• CTRL+Z = UNDO LAST ACTION

• CTRL+Y = REDO AN ACTION

• CTRL+F2 = SWITCH TO PRINT PREVIEW

• CTRL+ F1 = SHOW OR HIDE THE RIBBON

• CTRL+ F9 = MINIMIZE THE WORKBOOK WINDOW

• CTRL+SHIFT+U =EXPAND OR COLLAPSE THE FORMULA BAR

• CTRL+F = SEARCH IN A SPREADSHEET, OR USE FIND AND REPLACE

• CTRL+TAB = SWITCH BETWEEN OPEN WORKBOOKS

• CTRL+1 = CHANGE THE FORMAT OF SELECTED CELLS

• CTRL+5 = STRIKETHROUGH HIGHLIGHTES SELECTION

• CTRL+P = BRING UP THE PRINT DIALOG BOX TO BEGIN PRINTING

• CTRL+SHIFT+; = ENTER THE CURRENT TIME

• CTRL+; = ENTER THE CURRENT DATE

• F11 = CREATE A CHART FROM SELECTED DATA (ON A SEPARATE SHEET)

• F12 = OPEN THE SAVE AS DIALOG BOX

• F1 = OPEN THE HELP PANE

• F5 = GO TO A SPECIFIC CELL. FOR EXAMPLE, C6

• F7 = CHECK SPELLING

• F9 = CALCULATE ALL WORKSHEETS IN ALL OPEN WORKBOOKS

• ALT+F1 = CREATE AN EMBEDDED BAR CHART BASED ON SELECT DATA (SAME SHEET)

• ALT+Q = GO TO THE “TELL ME WHAT YOU W

• ALT OR F10 = TURN KEY TIPS ON OR OFF

• ALT+F = OPEN THE FILE TAB MENU

• ALT+H = GO TO THE HOME TAB

• ALT+N = OPEN THE INSERT TAB

 ALT+P                         = GO TO THE PAGE LAYOUT TAB

• ALT+M =  GO TO THE FORMULAS TAB

• ALT+A = GO TO THE DATA TAB

• ALT+R = GO TO THE REVIEW TAB

• ALT+W = GO TO THE VIEW TAB

• ALT+X = GO TO THE ADD-INS TAB

• ALT+Y = GO TO THE HELP TAB

• ALT+SHIFT+F1 = INSERT NEW WORKSHEET

• ALT+F8 = CREATE, RUN, EDIT, OR DELETE A MACRO

• ALT+F11 = OPEN THE MICROSOFT VISUAL BASIC FOR APPLICATIONS EDITOR

• F4 = REPEAT THE LAST COMMAND OR ACTION. FOR EXAMPLE, IF THE LAST THING YOU TYPED IN A CELL IS “HELLO,” OR IF YOU CHANGE THE FONT COLOR, CLICKING ANOTHER CELL AND PRESSING F4 REPEATS THAT ACTION IN THE NEW CELL.

• SHIFT+F3 = INSERT A FUNCTION SHIFT+F9 : CALCULATE ACTIVE WORKSHEETS

• SHIFT+F11 = INSERT A NEW WORKSHEET

Create small presentations

 

Module 5

Basics

What are the basics of PowerPoint?

It is a presentation-based program that uses graphics, videos, etc. to make the presentation more interactive and interesting. The file extension for the saved PowerPoint presentation is “.ppt”. A PowerPoint presentation with slides and other features is also known as PPT.

 

Using PowerPoint

Create a presentation

1. Open PowerPoint.

2. In the left pane, select New.

3. Select an option: To create a presentation from scratch, select a blank presentation. To use the finished design, select one of the templates. To see tips for using PowerPoint, select Take Tour, and then select Create.

Open a PowerPoint presentation

How to open a presentation in PowerPoint

1. Click the File tab.

2. Click Open. Press Ctrl + O…

3. Select the location where the file is saved. Displays a list of presentations you’ve recently opened. …

4. Locate and double-click the file you want to open.

Save presentation

Click File >, select or browse to the folder, type a name for your presentation in the File name box, and click Save. Hit Ctrl +S often.

 

Creation of presentation

Create a presentation in PowerPoint

1. To create a presentation from scratch, select a blank presentation.

2. To use the finished design, select one of the templates.

3. To see tips for using PowerPoint, select Take Tour, and then select Create,

Create a presentation using a template

1. In PowerPoint, click File, and then click New.

2. Under Available templates and themes, do one of the following: To reuse a template that you recently used, click Recent Templates. …

3. When you find the template that you want, click it to view the details, and then click Create.

 

Create a blank presentation

 

 Create a presentation. Open PowerPoint.  In the left pane, select New. Select an option: To create a presentation  from scratch  ,  select a blank presentation.

 

Enter and edit text

 Select text and  select Cut from edit menu  ; 2, click from the I-Beam pointer where you want to move the text  and  select Paste from the Edit menu.

 Insert and delete slides in a presentation

 You can delete one or more slides at once: Single Slide – Right-click and select Delete Slide. Hold down multiple slides – Ctrl and select the slides you want, then right-click and select Delete Slide.

Preparation of slides

1. Collect a thin piece of your sample and place it on a clean, dry slide. …

2. Place a drop of water on your sample. …

3. Place the coverslip at a 45-degree angle, with one edge touching the water and let go. …

4. Your slide is ready to view.

 

Insert a Word table or Excel worksheet

Link or embed an Excel worksheet in Word

1. > inserting text > the object.

2. Go to Create > Browse from File, and locate the file that you want to insert into the Word document.

3. Choose one of the following: To add the file as a linked object, select the link to the file, and then select OK.

Add clip art pictures

Insert clip art into Word, PowerPoint, or Excel

1. Select Insert picture > > stock images. The tabs at the top show you the types of pictures you can choose from: …

2. Select the tab, then browse the images by scrolling, or enter a word in the search box to filter out the set of images.

3. Select an image or images, then choose Insert.

 

Insert another object

Click in the slide where you want to place the object. On the Insert tab, in the Text group, click Objects. Click Create from File.

 

Resize and scale an object

Hold down CTRL+SHIFT. Move the mouse pointer to one of the handles and then click and drag the mouse. Release the mouse before releasing CTRL+SHIFT.

 

Providing aesthetics

Enhancing the text can be done by changing the font style, font color, font size, and using the font case options.

 

Enhance text presentation

Make sure everything can be seen and read from the back of the room. Pictures: Remember that pictures and graphs can be attractive compared to tablets. Choose pictures that will engage the audience rather than distract them. Flexibility: Create pauses in your presentation to allow questions.

• Go big or go home. …

• Make your headlines bold. …

• Let your text breathe. …

• Don’t get all fancy with your fonts. …

• Choose a contrasting font color. …

• Don’t use the same old boring bullet point. …

• Be consistent.

 

Working with color and line style

Work  with lines in the  project  · Right-click the line you want to change and click Properties. · Under Line,  select a color from the color list and  a line thickness  .

 

Add movies and sound

In General view, select the slide to which you want to add the video. On the Insert tab, click Video, then click The Movie from File. In the Choose Movie dialog box, select the file that you want to insert. If you want to embed the video on the slide, just click Insert.

 

Adding headers and footers

Add a standard or customized header or footer

1. Go > insert headers or footers.

2. Choose from a list of standard headers or footers, go to the list of header or footer options, and select the header or footer that you want. …

3. When you’re done, select Close header and footer or press Esc.

 

Presentation of slides

In the Home tab, in the Slides section, select New Slide.

Select an option:

1. To create a presentation from scratch, select a blank presentation.

2. To use the finished design, select one of the templates.

3. To see tips for using PowerPoint, select Take Tour, and then select Create,

View presentation

At the bottom of the slide window. Use slideshow view to get your presentation to your audience. Slideshow view occupies the full computer screen, just like your presentation looks on a large screen when your audience sees it.

Choose set up for presentation

Here are the points needed to create a successful presentation:

• Clearly define your objectives before giving a presentation.

• Learning and mastering your subject.

• Building plans and thinking about storytelling.

• Prepare and practice your oral presentation.

• Be natural during the presentation.

 

Print slides and handouts

Print your PowerPoint slides, handouts, or notes

• Select the print > file.

• For the printer, select the printer you want to print.

• For settings, select the options you want: …

• For copies, choose how many copies you want to print.

• Select Print.

 

Slideshow

A slideshow is the presentation of a series of still images (slides) on a projection screen or electronic display device, usually in a predetermined sequence. Changes can occur automatically and at regular intervals or they can be controlled manually by the presenter or viewer.

The best way to quickly create a slideshow is to use Google Photos on your Android phone. Google Photos essentially creates a video of pictures that you can use as a slideshow. Start by opening the Google Photos app and selecting the pictures you want to create a slideshow with.

Running slideshows

Open the presentation you  want to run as a slideshow.    On the Slide Show tab, click Run from Start. Select the slide you want to start the slide show from. On the Slide Show tab, click Run.

 

Transition and slide time

Determine the speed of transition

Select the slide that contains the transition you want to change. On the Transition tab, in the Time group, in the Duration box, type the number of seconds you want to run. If you want all transition effects in the slideshow to use the same speed, click Apply to All.

When you rehearse, use the slide timing feature to record the time you need to present each slide, and then use the recorded time to automatically forward the slides when you give your presentation to your actual audience. The slide timing feature is ideal for creating a self-running presentation.

Slide transition is the visual effect that occurs when you move from one slide to another during the presentation. You can control the speed, add sound, and customize the look of the transition effects.

PowerPoint Shortcut keys

• Ctrl+Tab: Switch between different open presentations

• Ctrl+N: Create a new presentation

• Ctrl+O: Open an existing presentation

• Ctrl+Q: Save and close a presentation

• Ctrl+S: Save a presentation

• Ctrl+Y: Repeat last action

• Ctrl+W: Close a presentation

• Ctrl+Z: Undo an action

• Ctrl+F: Search in a presentation or use Find and Replace

• Ctrl+F1: Show or hide the ribbon

• Ctrl+F2: Print Preview View

• Alt+F2: Open the Save As dialog box

• Alt+F: Open the File tab menu

• Alt+A: Go to the Animations tab

• Alt+G: Open the Design tab

• Alt+H: Go to the Home tab

• Alt+K: Go to the Transitions tab

• Alt+N: Open the Insert tab

• Alt+Q: Go to the “Tell me what you want to do” box

• Alt+R: Go to the Review tab

• Alt+S: Go to the Slide Show tab

• Alt+W: Go to View tab

• Alt+X: Go to the Add-ins tab

• Alt+Y: Go to the Help tab

 

Selection and navigation shortcuts

• Ctrl+A:            Select all text in a textbox, all slides in a presentation or all objects on a slide

• Tab: Select and/or switch to the next object on a slide

• Shift+Tab: Select or move to the previous object on a slide

• Home: Go to the first slide, or from within a text box, go to the beginning of the line

• End: Go to the last slide, or from within a text box, go to the end of the line

• Page Down: Go to the next slide

• Page Up: Go the previous slide

• Ctrl+Down Arrow: Move a slide down in the presentation (click on a slide thumbnail first)

• Ctrl+Up Arrow: Move a slide up in the presentation

• Ctrl+Shift+Up Arrow: Move a slide to the beginning of the presentation (click on a slide thumbnail first)

• Ctrl+Shift+Down Arrow: Move a slide to the end of the presentation

 

 

Computer Communication and the Internet

 

Module 6

 

 

Basics of Computer Networks

Local Area Network

LAN stands for Local Area Network. A network is a group of two or more connected computers, and a LAN is a network contained within a small geographical area, usually within a single building. Home WiFi networks and small business networks are common examples of LANs.

A local area network (LAN) consists of a series of computers that are connected together to form a network in a confined space. The computer in a LAN is equipped with TCP/IP. IP connects to each other via Ethernet or Wi-Fi. A LAN is generally exclusive to an organization, such as a school, office, association, or church.

 

Wide Area Network

A wide-area network (WAN) is the technology that connects your offices, data centers, cloud applications, and cloud storage together. It is called a wide area network because it extends beyond a single building or large complex to include a specific geographical area, or even multiple locations spread across the world.

 

 

 

Network Topology

A network topology is the arrangement with which computer systems or network devices are connected to each other. Topology can define both the physical and logical aspect of the network. Both logical and physical topology can be similar or different in the same network.

point-to-point

Point-to-point networks consist of exactly two hosts such as a computer, switch or router, back to back connected servers using a piece of cable. Often, the receiving end of one host is associated with sending the end of another and vice versa.

If the hosts are logically point-by-point connected, there may be several intermediate devices. But the final hosts are unaware of the underlying network and look at each other as if they are directly connected.

Bus Topology

In the case of bus topology, all devices share a single communication line or cable. Simply topology can have problems when sending multiple host data at the same time. Therefore, simply topology is either csma/csma. THE CD uses technology or simply recognizes a host as the master to solve the issue. It is one of the simplest forms of networking where the failure of one device does not affect other devices. But the failure of the shared communication line can cause all other devices to stop working.

Both ends of the shared channel have line Terminator. The data is sent in only one direction and as soon as it reaches the extreme end, terminator removes the data from the line.

Star Topology

All hosts in star topology are connected to a central device, known as a hub device, that uses a point-to-point connection. That is, a point-to-point connection exists between the host and the hub. The hub device can be any of the following:

• Layer-1 devices such as hubs or repeaters

• Layer-2 devices such as switches or bridges

• Layer-3 devices such as routers or gateways

As in bus topology, the hub acts as a single point of failure. If the hub fails, the connectivity of all hosts to all other hosts fails. Every communication between hosts takes place only through the hub. The star topology is not expensive because in order to connect another host, only one cable is needed and the configuration is simple.

Ring Topology

In ring topology, each host machine connects to precisely two other machines, forming a circular network structure. When a host tries to send or send a message to a host that is not adjacent to it, the data travels through all intermediate hosts. To connect another host to the existing structure, the administrator may only need one more additional cable.

Failure of any host results in the failure of the entire ring. Thus, every connection in the ring has a point of failure. There are methods that employ another backup ring.

Mesh Topology

In this type of topology, one host is attached to one or several hosts. This topology has hosts in a point-to-point connection with every other host or may even have hosts that are in a point-to-point connection for only a few hosts.

Hosts in mesh topology also serve as relays to other hosts that do not have direct point-to-point links. Mesh technology comes in two types:

• Full Mesh: All hosts have a point-to-point connection to every other host in the network. Thus an N(n-1)/2 connection is required for each new host. It provides the most reliable network structure among all network topology.

• Partially trap: Not all hosts have a point-by-point connection to every other host. Hosts connect to each other in somewhat arbitrary way. This topology exists where we need to provide reliability to certain hosts.

 

Tree Topology

Also known as hierarchical topology, it is the most common form of network topology currently in use. This topology mimics as extended star topology and simply inherits the properties of topology.

This topology is designed to change the network to multiple levels/levels of the network. Divides into layers. Mainly in LAN, a network is divided into three types of network devices. The lowest access-layer is where computers are attached. The middle layer is known as the distribution layer, which acts as an intermediary between the upper layer and the lower layer. The highest layer is known as the core layer, and it is the central point of the network, i.e. the root of the tree from which all nodes become forks.

There is a point-to-point relationship between all neighboring hosts. Just like topology, if the root goes down, the entire network suffers, although this is not a point of failure. Each connection serves as a point of failure, the failure of which divides the network into unattainable segments.

Daisy Chen

This topology combines all hosts in a linear fashion. Similar to ring topology, all hosts are connected to only two hosts, except the last hosts. This means, if the final hosts in the Daisy series are connected it represents the ring topology.

Each link in the Daisy chain topology represents a single point of failure. Each link failure divides the network into two segments. Each intermediate host works as a relay for its immediate hosts.

Hybrid Topology

A network structure that has more than one topology in its design is called a hybrid topology. The merits and demerits of all topology involving hybrid topology are inherited.

The above figure represents an arbitrarily hybrid topology. Combination topology can include features of star, ring, bus, and daisy-chain topology. Most WAN are connected via dual-ring topology and the networks connected to them are mostly star topology networks. The Internet is the best example of the largest hybrid topology

Internet

The Internet is a technology of connecting multiple computers together through a network. There are different types of networks that combine to form the Internet. Different types of small networks include local area networks (LANs), personal area networks (PAN), metropolitan area networks (MAN), campus area networks (CAN), etc.

 

Internet and the concept of WWW

In simple terms, WWW is just a common point of connectivity for information sharing that is facilitated by a global network of computers. On the other hand, there is a connection between the Internet, computers and countless other devices that make up a vast network of systems.

 

 

Basics of Internet Architecture

Internet architecture is a meta-network, which refers to a congregation of thousands of different networks interacting with a common protocol. In simple terms, it is referred to as an internetwork that is connected using a protocol. The protocol used is TCP/IP. IP.

The Internet architecture relies on a wide array of additional protocols to function. IP, TCP, and UDP are key components in data transmission, but, to be effective and productive, other protocols must help.

 

Services on the Internet

The Internet is a collection of interconnected computers, which share data and services. A service is a program running on a computer that allows you to perform a useful activity such as: browsing the World Wide Web (WWW) and receiving emails.  Downloading videos and music files.

Internet Services

• communication services. There are various communication services available that exchange information with individuals or groups. …

• Information Retrieval Services. …

• Web Services. …

• World Wide Web (WWW) …

• Video conferencing.

 

 

World Wide Web and Websites

The World Wide Web – also known as web, WWW or W3 – refers to all public websites or pages that users can access on their local computers and other devices via the Internet. These pages and documents are interconnected through hyperlinks on which users click for information.

 

Communication over the Internet

Internet communication refers to the sharing of information, data, ideas, or words over the  Internet. The Internet includes networks connected around the world that are equipped with standardized Internet Protocol suites (TCP/IP). Transmit data through packet switching using (IP).

Types of Internet Communication

• Instant messaging.

• Internet Telephony and VoIP.

•  
•  

• Video conferencing.

• SMS and wireless communication.

 

Internet Services

Internet Services means the use of online information, communications and other services we provide and access to information and services provided by third parties.

 

It supports human communication through social media, electronic mail (e-mail), “chat rooms,” newsgroups, and audio and video transmission and allows people to work collaboratively in many different locations. It supports access to digital information by many applications, including the World Wide Web.

 

Preparing computers for Internet access

1. Connect your modem. Before you power up your modem, you’ll want to connect it to your computer and your phone jack or cable outlet. …

2. Connect your router to the Internet (optional)…

3. Test your internet connection. …

4. Set up your modem and network. …

5. Connect to a wireless network.

 

ISPs and examples [broadband/broadband] Dialup/ WiFi]

Verizon, Spectrum and AT&T are some examples of ISPs. Earlier ISPs used direct subscriber line (DSL) and cable ISP options to connect the general public to the Internet, especially those who lived in urban areas.

An Internet Service Provider (ISP) is a company that provides access to the Internet. ISPs can provide this access through multiple means including dial-up, DSL, cable, wireless and fiber optic connections. A variety of companies operate as ISPs, including cable providers, mobile carriers, and telephone companies.

Internet Access Technology

Currently, broadband technologies such as cable internet and ADSL are the most widely used methods for internet access. The speed, cost, reliability and availability of Internet access depend on the region, internet service provider and type of connection.

In this section, we discuss four major Internet access technologies (DSL, cable modem, fixed wireless, and mobile wireless) and also some future technologies that may be common.

Web Browsing Software

Web Browser Definition: A software application used to access information on the World Wide Web is called a web browser. When a user requests some information, the web browser fetches data from a web server and then displays the webpage on the user’s screen.

Configure a Web browser

Step 1 – Open Google Chrome through the icon in the task bar or “Start menu”. It is present at the top right corner of the window and go to the “Settings” option from the menu displayed. Step 3 − From the window opened, change people’s settings, appearance, search engines, default browser, startup, and advanced tabs.

Change your search settings

• On your Android phone or tablet, go to google.com.

• At the top left, tap menu. Settings.

• Choose your search settings.

• Below, click Save.

 

search engine

What is the definition of search engine?

A search engine is a software program that helps people find the information they are looking for online using keywords or phrases. Search engines are able to quickly return results—even with millions of websites—by constantly scanning the internet and indexing every page they find.

 

A search engine is a web-based tool that enables users to locate information on the World Wide Web. Popular examples of search engines  are Google, Yahoo!, and MSN Search.

Popular Search Engines/ Search for content                       

Top 10 Most Popular Search Engines in the World

•  

• Microsoft Bing.

•  
•  
•  
•  

• com.

•  

 

 

Accessing a web browser

Web access means that websites, tools, and technologies are designed and developed so that people with disabilities can use them. More specifically, people can: experience, understand, navigate, and interact with the web. Contribute to the web.

To get started,  open the web browser of your choice by clicking on your application icon – a browser window will open automatically. Alternatively, you can right-click on the icon and select Open from the drop-down menu. Of course, you’re probably using a browser right now as you read this article.

 

Using favorite folders

The Favorites section of Outlook at the top of the navigation panel contains shortcuts to folders such as your Inbox, Sent Items, and Search Folders. You can add, remove, and organize folders in this section to access your mail folders more easily.

Right-click the folder that you want to add or remove, and then click Show in Favorites or Remove from Favorites.

 

Download web page

To read the saved page, open the file on your computer. It will open in your default browser, like Chrome or Safari.

You must be online to save a page.

1. On your computer, open Chrome.

2. Go to the page you want to save.

3. At the top right, click More Tools. Save the page as this.

4. Choose where you want to save the page.

5. Click Save.

E-mail Social Networking and E-Governance

 

 Module 7

 

Structure of e-mail

 

Subject line: Short sentence that summarizes the reason you wrote the email. Greeting: This is where you greet your recipient. Be formal and concise.

 

Body: The main paragraph of your email that communicates the main message.

 

Using e-mail

E-mail means electronic mail or electronic mailer. The most commonly used feature of a network in the field of communication is e-mail. It is the transmission of messages from one computer to another. Communication can be between two to several users.

Typically, an email header contains the following information:

• This message provides a summary of the topic and is displayed in a separate line above the body of the message. For example, a subject line might say “company mission statement” or “employee stock purchase plan.”

• Sender (from). This field is the sender’s email address. If it is associated with the email address, a display name may also be shown instead. Most email clients fill this field automatically.

• Date and time(s) received . This field shows the local time and date when the message was created. This is a mandatory header field that is automatically filled in by most email clients.

• If a user  clicks on the Reply button  , this field automatically populates the message with the sender’s email address, which now becomes the “recipient”.

• Recipient (two). This field shows the first and last name of the e-mail recipient, as configured by the sender.

• Recipient email address. This is the recipient’s email address or where the message was sent.

• Carbon Copy (CC). field includes the email addresses of people who need to receive the email but are not expected to reply. When a person presses Reply All, all CC addresses receive feedback.

• Blind Carbon Copy (BCC). If a sender doesn’t want their recipient to know who received the email, they can use the BCC field to enter those addresses. Addresses in the BCC list do not respond when a reply presses All.

• Attachment. This field contains any files attached to the message.

mischievou

This is the content of the email. It can contain anything the user wants to send, including text, video, or file attachments. Depending on the email client used, the email body is replaced by plain text or. While plain text messages may not have special formatting or multimedia elements, HTML email enables special formatting and inclusion of multimedia options within the body of the message. The body of the message may also include signatures or automatically generated text that the sender’s email system inserts.

Opening an email account

How do I open email or Gmail?

Open your email

1. Visit any Web browser-mail.google.com.

2. Most Google Pages—in the top right, click App Launcher. And select Gmail.

3. Android Devices- Install and open Android apps.

4. Apple iOS Devices- Install and open the iOS app.

Step 1: Choose a Google Account Type

1. Go to the Google Account Sign In page.

2. Click Create Account.

3. Enter your name.

4. In the “User name” field, enter a user name.

5. Enter and confirm your password. Tip: When you enter your password on mobile, the first letter is not sensitive.

6. Click Next. …

7. Click Next.

Mailbox: Inbox and Outbox

Inbox. The inbox is where you will view and manage the emails you receive. Emails are listed with the sender’s name, message subject, and date of receipt.

Inbox – Inbox is an area where you can see all received mail.

Outbox – Outbox is an area where outgoing messages or messages that are in the process of being sent or that fail to send are stored.

Sent Mail – Sent mail is an area for viewing all sent or successfully delivered mail.

Create and send a new e-mail

1. Select New Email > Home.

2. Add recipients, topics, and messages to the body of the e-mail.

3. Select Send.

Reply to an e-mail message

1. Select an email to respond.

2. Select the answer.

3. Type your message.

4. Select Send.

NOTE: No received attachments are automatically added to the answer.

Forward to share emails with others

1. Select an email to forward.

2. Select To proceed.

3. Add who you want to forward.

4. Add a note to the email body if you wish.

5. Select Send.

 

Search email

• On your computer, go to Gmail.

• In the search box at the top, enter what you want to search for.

• Press Enter. A list of emails will appear.

• To further refine the search, use the search filter chips at the bottom of the search box or the search operators in the search box.

Attach files with email

Forward an email as an attachment

1. On your computer, go to Gmail.

2. Select the email you want.

3. Click More. Proceed as attachment.

4. In the “To” field, add recipients. You can also add recipients to the “Cc” and “Bcc” fields.

5. Add a topic.

6. Write your message.

7. At the bottom, click Send.

Email Signature

 

Create an email signature

1. Choose a new email.

2. Select signature > signature.

3. Select New, type a name for the signature, and select OK.

4. Under Edit Signatures, type your signature and format it to your liking.

5. Select OK and close the email.

6. Select a new email to see the signature you’ve created.

 

Social Networking and E-Commerce

The role of social media in ecommerce is to build brand awareness, advertise for target user segments, sell products, improve and expand customer support, and engage in conversation and community building .

Social commerce is the process of selling your products using your social media profile . You can use platforms like Instagram, Facebook, Pinterest, and TikTok to do this—each of them offers a unique set of features to put their products in front of potential customers during their social media scrolls.

Facebook, Twitter, LinkedIn, Instagram

• Log in to LinkedIn and click on your “Profile” page. …

• Click “Add a Twitter account”, and a pop-up window from Twitter will open.

• Close the window, and your Twitter account is now a clickable link to your LinkedIn profile page, allowing anyone who sees your page to click and view your Tweets.

 

Instant messaging (WhatsApp, Facebook, Messenger, Telegram)

Some examples of POPULAR IM services today  include Signal, Telegram, WhatsApp Messenger, WeChat, QQ Messenger, Viber, Line, and Snapchat. The popularity of some apps varies greatly between different countries.

Introduction to Blog

This introduction serves as a thesis of content — what will be covered, in what order, and what viewers can expect to take. Some visitors read the material from start to finish. Laying out your thesis helps people quickly find the information they need.

Basics of E-Commerce

E-commerce (electronic commerce) is the purchase and sale of goods and services, or electronic networks, primarily the communication of money or data over the Internet. These business transactions occur as either business-to-business (B2B), business-to-consumer (B2C), consumer-to-consumer or consumer-to-business.

There are three main types of e-commerce: business-to-business (websites like Shopify), business-to-consumer (websites like Amazon), and consumer-to-consumer (websites like eBay).

Nitikets

Neticet is a built-in word from the words net and manners. Thus Nelliket describes the rules of conduct for respectful and proper communication on the Internet. Neticet is often referred to as a courtesy for the Internet. These are not legally binding rules, but recommended rules of etiquette.

 

Overview of e-governance services like railway reservation,

Electronic governance or e-governance can be defined as the use of information and communication technology (ICT) by the government to provide and facilitate the integration of government services, exchange of information, communication transactions and various standalone systems and services.

The system includes all the steps, including electronic diversion of internal correspondence, creation of files, movement of correspondence and files, digital signature certificate (DSC), electronic signature of noting and drafts using ECISION and finally, record of records.

Accessing e-Governance Services on Mobile Usage

E-governance applications allow citizens, trades and government entities to access government information available round the clock including every second and make the delivery of government services more effective and accessible in various government domains.

Umang App”

UMANG provides a single platform for all Indian citizens to access pan-India e-Gov services from the Centre to local government bodies.

An initiative by The National e-Governance Division (NEGD) of the Ministry of Electronics and Information Technology (MeitY). Umang strives to become a one stop gateway for all government schemes and services through various channels like mobile application (iOS, Android), chatbots, voice  bots and websites.

Digital Locker

Targeted at the idea of paperless governance, DigiLocker  is a platform for issuing and verifying documents and certificates in a digital manner, thus eliminating the use of physical documents.

DigiLocker is an Indian digitization online service provided by the Ministry of Electronics and Information Technology (MeitY), Government of India under its Digital India initiative.

How safe is digital locker?

Since DigiLocker is a government-based initiative, it has stringent safety protocols. To protect the user’s data, it uses 256 bit SSL encryption. The process of signing up takes place through an OTP sent to the registered mobile number of the user.

Digital Financial Tools and Applications

 

Module 8

 

Digital Financial Tools

Digital Financial Services (DFS)  covers a wide range of access and distributed financial services through digital channels including payments, credit, savings, remittances and insurance.

What are the types of digital finance?

• online banking, online payment and transfer services.

• Peer-to-peer lending.

• personalized investment advice and services.

Understanding OTP [One Time Password] and QR [Quick Response] Code

 

TOTPs are obtained in the form of QR codes or from a secret seed password given on user registration in PlainText. TOTPs (and their seeds) are deployed either on hardware security tokens or as soft tokens, meaning mobile device apps that display numbers.

UPI [Unified Payment Interface]

 

Unified Payments Interface (UPI) is a payment system that allows users to link more than one bank account in a smartphone app and transfer funds without providing IFSC code or account number. It is a real-time payment system where funds are deposited instantly on a real-time basis.

 

 

AEPS [Aadhaar Enabled Payment System]

AEPS is a bank-led model that allows online interoperable financial transactions over POS (Point of Sale/Micro ATM) through business correspondent (BC)/bank mitra of any bank using Aadhaar authentication. How to get it: Provide KYC (Know Your Customer) information to open a new account.

Card [Credit/Credit] Debit]

What’s the difference?

When you use a debit card, funds for your purchase amount are taken from your checking account almost immediately.

When you use a credit card, the amount will be charged on your line of credit, which means you’ll pay the bill at a later date, which also gives you more time to pay.

What are the three types of credit cards?

Fortunately, most cards  can be classified into three major categories based on the features they offer:

1. Rewards credit cards,

2. Low Interest and Balance Transfer Card

3. Credit-building cards.

Four Common Forms of Credit

• Revolving loans. This form of credit allows you to borrow money up to a certain amount. …

• Charge card. This form of credit is often considered similar to a rotating credit card. …

• Installment Credit. …

• Non-installment or service loan

eWallet

E-wallet means electronic wallet. It is a type of electronic card that is used for transactions made online through a computer or smartphone.

 

Internet Banking

Internet banking, also known as online banking, e-banking or virtual banking, is an electronic payment system that enables customers of a bank or other financial institution to conduct a series of financial transactions through the financial institution’s website.

 

What are the benefits of net banking?

• Net banking is available 24/7.

• This allows for easy fund transfer.

• It provides convenience for carrying out banking transactions.

• Customers can easily track their transaction history with just a few clicks.

• Net banking is secure and requires a password for access.

What are the types of Internet Banking?

The major types of e-banking are online internet banking, mobile banking, automated teller machines (ATMs), and debit and credit cards.

What are the 3 advantages of banking?

Benefits of Bank Account

• Bank accounts provide convenience. For example, if you have a checking account, you can easily pay by cheque or through online bill payment. …

• Bank accounts are secure. Your money will be protected from theft and fire. …

• It’s an easy way to save money. …

• Bank accounts are cheap.

What is the risk of internet banking?

Due to the open nature of the internet, all web-based services like YAB’s online banking will naturally be available on your user ID/ID card. Usernames, passwords, viruses are subject to risks such as attacks, hacking, unauthorized access and online theft of fraudulent transactions.

National Electronic Funds Transfer (NEFT)

NEFT is a centralised nationwide payment system owned and controlled by the Reserve Bank of India (RBI). It easily transfers money between banks across India. A bank branch should be NEFT enabled to allow the customer to transfer funds to another party.

Who can do NEFT transactions?

Any individual, firm or company can carry out NEFT transactions. For transactions, it is mandatory that the account holder’s bank account be NEFT-enabled.

Real Time Gross Settlement (RTGS)

Gross settlement means that transactions are handled and dealt with individually, so many transactions are not grouped or grouped together. This is the basis of the real-time gross settlement system. The RTGS system is generally used for large-value interbank fund transfers operated and organized by the country’s central bank.

Immediate Payment Service (IMPS)

Instant Payment Service (IMPS) is an instant payment inter-bank electronic fund transfer system in India . IMPS provides an inter-bank electronic fund transfer service through mobile phones. This service is available 24×7 throughout the year including bank holidays.

What are the features and benefits of IMPS?

• 1) Immediate fund transfer. Staying true to your name, IMPS allows you to transfer money in an instant. …

• 2) 24×7 availability. …

• 3) Instant notifications. …

• 4) Versatility of the mode. …

• 5) Safe and secure. …

• 6) Minimum information is required. …

• 7) Multiple applications. …

• 8) Cost efficient.

IMPS (Immediate Payment Service)
Rs 2 lakh, instantly. Therefore, you can think of IMPS as a fund transfer mode that has the best features of both RTGS and NEFT. You can transfer as little amount as you want at any time, with quick results. Although IMPS services are mostly used online, some banks offer SMS services.

Online Bill Payment

You can pay your electricity bill online on Paytm using debit card, credit card, Paytm wallet and UPI (UPI is only available on Paytm app). You can use the method.

Overview of future skills and cybersecurity

 

Module 9

Internet of Things [ I OT ]

The Internet of Things (IoT) describes networks of physical objects—”things”—that are embedded with sensors, software, and other technologies for the purpose of connecting and exchanging data with other devices and systems on the Internet.

What are the 4 types of IoT?

• Internet of Things Introduction.

• Mobile/Cellular IoT connectivity.

• Wi-Fi IoT connectivity.

• Bootstrap IoT connectivity to OEM.

• IoT connectivity management.

• Cases use IoT.

Features of Internet of Things (IoT)

• In the case of IoT, the most important feature that can be considered is connectivity. …

• …

• Active engagements. …

• …

• Dynamic nature. …

• …

• …

•  

Big Data Analytics

Big data analytics is the process of collecting, examining, and analyzing large amounts of data to discover market trends, insights, and patterns that can help companies make better business decisions.

Cloud Computing

Simply put, cloud computing is the delivery of computing services – including servers, storage, databases, networking, software, analytics, and intelligence – over the Internet (the “cloud”) to offer rapid innovation, flexible resources, and economies of scale.

 

There are four main types of cloud computing:

 

Private clouds, public clouds, hybrid clouds and multicloud.

                                                                                                                           

Virtual Reality

Virtual reality (VR) is a computer-generated environment with scenes and objects that appear to be real, making the user feel like they are immersed in their surroundings. This environment is perceived through a device known as a virtual reality headset or helmet.

 

Artificial intelligence

What is Artificial Intelligence (AI)? Artificial intelligence  is the simulation of human intelligence processes by machines, especially computer systems. Typical applications of AI include specialist systems, natural language processing, speech recognition, and machine vision.

4 Main Types of Artificial Intelligence

• Reactive machines. Reactive machines are AI systems that have no memory and are task specific, meaning that an input always provides the same output. …

• Limited memory. The next type of AI in its development is limited memory. …

• Theory of mind. …

• self-awareness.

What are the 3 main components of AI?

To understand some deep concepts like data mining, natural language processing, and driving software, you need to know three basic AI concepts: machine learning, deep learning, and neural networks.

Social & Mobile

A term to refer to social networking applications, media, or platforms such as Facebook, Foursquare, Instagram, Pinterest, Twitter, etc., which are often distributed through mobile devices such as smartphones, tablets, or laptop computers.

 

 

 

7 Different Types of Social Media

• Traditional social networking sites. Most of us are familiar with social networking sites like Facebook, Twitter, LinkedIn and TikTok. …

• Social review sites. …

• Image and video sharing sites. …

• Video hosting sites. …

• Community Blog. …

• Discussion sites. …

• Sharing economy networks.

Blockchain Technology

The buying and selling of Bitcoin is recorded and transmitted in a network of powerful computers, known as nodes. This network of thousands of nodes around the world competes to confirm transactions using computer algorithms. This is known as Bitcoin mining.

3D Printing/ Additive Manufacturing

3D printing or additive manufacturing enables you to produce geometrically complex objects, shapes and textures.

Robotics Process Automation

The term robotic process automation (RPA) brings the image of physical robots that perform labor-intensive activities, such as cleaning the house, lifting heavy objects, doing every job as a human worker.

What can robotic process automation do?

Think of RPA bots as a digital workforce that can interact with any system or application. For example, bots are able to copy-paste web data, scrape, perform calculations, open and transfer files, parse emails, log into programs, connect to APIs, and extract unstructured data.

cyber security

Cyber security is the protection of internet-connected systems such as hardware, software, and data from cyber threats. The practice is used by individuals and enterprises to protect against unauthorized access to data centers and other computerized systems.

Cybersecurity can be classified into five different types:

• Security of critical infrastructure.

• Application security.

• Network security.

• Cloud security.

• Internet of Things (IoT) security.

 

 

 

 

Why do we need cybersecurity?

Cyber security is important because it helps protect organizations and individuals from cyber attacks. Cybersecurity can help prevent data breaches, identity theft, and other types of cybercrime. Organizations should take strong cyber security measures to protect their data and customers.

Need for cyber security

Cyber security is important as it protects all categories of data from theft and damage. This includes sensitive data, personally identifiable information (PII), protected health information (PHI), personal information, intellectual property, data, and government and industry information systems.

 

What is cybersecurity and what is its need?

Cyber security is the protection of internet-connected systems such as hardware, software, and data from cyber threats. The practice is used by individuals and enterprises to protect against unauthorized access to data centers and other computerized systems.

 

What are the benefits of cybersecurity for businesses?

• Protects sensitive personal information. …

• Protect personal and business data. …

• Improves productivity. …

• Provides a business continuity plan. …

• Improving the overall security of an organization. …

• Let’s take a look at the effects of cybersecurity:

Secure the PC

What does it mean to secure a computer?

Computer security is the security that is installed for computer systems and protects important information from unauthorized access, theft or misuse. There are various practices in place that are widely in use, mainly to protect computer systems and networks and prevent potential malicious activities.

 

Keep your computer safe at home

1. Use the firewall. …

2. Keep all software up to date. …

3. Use antivirus software and keep it running. …

4. Make sure your passwords are well chosen and secure. …

5. Do not open suspicious attachments or click unusual links in messages. …

6. Browse the web securely. …

7. Stay away from pirated content.

 

Secure a smart phone

6 Trivia Tips to Keep Your Smartphone Safe

1. Avoid giving personal information. …

2. Use a PIN, password, or pattern to lock your phone. …

3. Download apps only from trusted stores. …

4. Back up your data. …

5. Keep your operating system and apps updated. …

6. Log out of the sites after making the payment.

 

LIBRA OFFICE SORT CUT KEYS

LIBRA OFFICE WRITE FONT SIZE                                            12

LIBRA OFFICE PRINT PREVIEW                                               CTRL+SHIFT+O

WHICH SHORT KEY NEW STYLE                                             SHIFT+11

NEW DOCUMENT                                                                          CTRL+SHIFT+N

DOUBLE UNDER LINE                                                                 CTRL+D

AUTOMATIC SPELLING CHECK IN LIBRA                             SHIFT+F7

SHORT CUT KEY OF HEADING 3                                              CTRL+3

SHORTCUT KEY INSERTING TABLE LIBRA OFFICE          CTRL+F12

OPEN REMOTE IN LIBRA OFFICE                                            FILE

MENU USED FOR WATER MARK                                              INSERT

 SHORTKEY SAVE IN LIBRA OFFICE CALC                          CTRL+SHIFT+S

EXIT OF SHORT KEY LIBRA OFFICE                                       CTRL+Q

HOW MANY MENU ARE LIBRA OFFICE IMPRESS               10

 

 

 

 

 

 

LIBRA OFFICE QUESTIONS /ANSWER FOR CCC EXAM

 

LibreOffice (writer) CCC Questions

 

Q1. In LibreOffice Writer, mail merge option is in which menu?

(A) Insert

(B) Format

(C) Tools

(D) Form

Ans: C

 

Q2. What is the shortcut key of manage template key in LibreOffice Writer?

(A) Ctrl + T

(B) Ctrl + shift + N

(C) Shift + N

(D) None of above

Ans: B

 

Q3.Find the Minimum zoom percentage in LibreOffice Writer?

(A) 20

(B) 10

(C) 15

(D) 5

Ans: A

 

Q4.What is the maximum font size in LibreOffice writer?

(A) 72

(B) 96

(C) 11

(D) 48

Ans: B

 

Q5.What is the shortcut key of superscript in LibreOffice Writer?

(A) Ctrl + shift + P

(B) Ctrl +shift + B

(C) Ctrl +Shift + S

(D) None of Above

Ans: A

 

Q6. What is the shortcut key of increasing font size in LibreOffice?

(A) Ctrl + ]

(B) Ctrl + }

(C) Ctrl+[

(D) Both A and B

Ans: D

 

Q7. What is the shortcut key for Autotext used in LibreOffice Writer?

(A) Ctrl + F3

(B) Ctrl + F2

(C) Ctrl+F4

(D) None of the above

Ans: B

 

Q8. What is the shortcut key for save as in LibreOffice Writer?

(A) Ctrl + Shift + S

(B) Ctrl + S

(C) F12

(D) None of the above

Ans: A

 

Q9. What is the shortcut key for Auto spell check used in LibreOffice Writer?

(A) Shift + F7

(B) Ctrl + F7

(C) F7

(D) Ctrl + Shift +F7

Ans: A

Q10. What is the shortcut key for heading 3 in LibreOffice Writer?

(A) Ctrl + 1

(B) Ctrl + 2

(C) Ctrl+ Shift + 3

(D) Ctrl + 3

Ans: D

Q11. In LibreOffice Writer, find the location of footnote?

(A) Bottom of the page

(B) Top of the page

(C) Bottom of the document

(D) Top of the document

Ans: A

 

Q12. By default Line spacing in LibreOffice Writer is?

(A) 1

(B) 1.5

(C) 2

(D) 2.5

Ans: A

 

Q13. What is the shortcut key for double underlying in LibreOffice Writer?

(A) Ctrl + Shift + D

(B) Ctrl + D

(C) Ctrl+U

(D) Ctrl + Shift + U

Ans: B

 

Q14. What is the shortcut key for inserting a table in LibreOffice Writer?

(A) Ctrl + F12

(B) Ctrl + F2

(C) Ctrl+F1

(D) None of the above

Ans: A

 

Q15. What is the shortcut key for page break in LibreOffice Writer?

(A) Ctrl + Enter

(B) Ctrl + Shift + Enter

(C) Sift + Enter

(D) Enter

Ans: A

 

Q16. What is the default file extension in LibreOffice Writer?

(A) .odt

(B) .ods

(C) .odp

(D) .docx

Ans: A

 

Q17. In which menu the commands like bold, italic, underline are found in the LibreOffice Writer?

(A) Style

(B) Format

(C) Insert

(D) View

Ans: B

 

Q18. In LibreOffice, the shortcut key of going at the last of the left of the cell is

(A) Alt + Tab

(B) Tab

(C) Alt

(D) Shift + Tab

Ans: D

 

Q19. In LibreOffice Writer, scroll bar option is in which menu?

(A) File

(B) Insert

(C) Tools

(D) View

Ans: D

 

Q20. Thesaurus option is in which menu of LibreOffice?

(A) Format

(B) Tools

(C) View

(D) None of the above

Ans: B

 

Q21. Which shortcut key is used for full screen in LibreOffice?

(A) Ctrl + Shift + J

(B) Ctrl + Shift +K

(C) Shift +J

(D) None of the above

Ans: A

 

Q22. Which shortcut key is used in LibreOffice to hide or unhide the ruler?

(A) Ctrl + Shift + R

(B) Ctrl + Shift + P

(C) Ctrl+ Shift + B

(D) None of the above

Ans: A

 

Q23. What is the shortcut key for clear format in LibreOffice Writer?

(A) Ctrl + C

(B) Ctrl + M

(C) Ctrl+ Shift+ M

(D) None of the above

Ans: B

 

Q24. What is the shortcut key to close the current window in LibreOffice Writer?

(A) Ctrl + Q

(B) Ctrl + W

(C) Ctrl+T

(D) None of the above

Ans: B

 

Q25. Ruler option is found in which menu?

(A) Home

(B) Insert

(C) View

(D) Tools

Ans: C

Q26. What is the default location of save in LibreOffice Writer?

(A) Desktop

(B) Documents

(C) Downloads

(D) All of above

Ans: B

 

Q27. What is the shortcut key for heading 2 in LibreOffice Writer?

(A) Ctrl + 1

(B) Ctrl + 2

(C) Ctrl+3

(D) None of the above

Ans: B

Q28. What is the margin in LibreOffice Writer document?

(A) .5

(B) 1.5

(C) 0

(D) 1

Ans: D

 

Q29. What is the word processing in LibreOffice?

(A) Draw

(B) Impress

(C) Calc

(D) Writer

Ans: D

 

Q30. What is the file extension for template in LibreOffice Writer?

(A) .odp

(B) .odt

(C) .ott

(D) .doc

Ans: C

 

Q31. Which of the following is not shown in status bar of LibreOffice Writer?

(A) Total Characters

(B) Current page number

(C) Total numbers of words

(D) Computer’s name

Ans: D

 

Q32. Which of the following keyboard shortcut is used to exit writer?

(A) Ctrl + F4

(B) Ctrl + F2

(C) Ctrl+F1

(D) Alt + F4

Ans: D

 

Q33. How do you paste special in LibreOffice ?

(A) Ctrl + Shift + V@

(B) Ctrl + V

(C) Ctrl + Shift + P

(D) Ctrl + P

Ans: A

 

Q34. What is the shortcut key to create a new document in LibreOffice Writer?

(A) Ctrl + N

(B) Ctrl + Shift+ N

(C) Shft + N

(D) None of the above

Ans: A

Q35. LibreOffice Writer के किस menu में mail merge या लेटर विजार्ड पाया जाता है?

1. a) फॉरमैट

2. b) फाइल

3. c) टूल्स

4. d) इंसर्ट

Ans : c)

 

Q36. LibreOffice Writer में default font size कितना होता है?

1. a) 10

2. b) 12

3. c) 15

4. d) 6

Ans : b)

Q37. Libreoffice Writer में new style के लिए किस shortcut key का प्रयोग करते हैं?

1. a) Shift + F12

2. b) Ctrl + F11

3. c) Ctrl + Shift + F11

4. d) Shift + F11

Ans : d)

 

Q38. Libreoffice Writer में redu करने की shortcut key है?

1. a) Ctrl + Z

2. b) Ctrl + Y

3. c) Ctrl + R

4. d) Ctrl + Shift + R

Ans : b)

Q39. LibreOffice Writer में Manage template की shortcut key क्या होती है?

1. a) Ctrl + T

2. b) Ctrl + shift + N

3. c) Shift + N

4. d) None

Ans : b)

Q40. LibreOffice writer में बुलेट लिस्ट जोड़ने के लिए किस कुंजी का प्रयोग करते हैं?

1. a) Shift + F12

2. b) F12

3. c) Ctrl + F12

4. d) None

Ans : a)

 

Q41. Super script and sub script दोनों सामान करैक्टर की तुलना में बड़े दिखाई देते हैं?

1. a) True

2. b) False

Ans : b)

 

Q42. LibreOffice writer में status bar को हटाया जा सकता है?

1. a) True

2. b) False

Ans : a)

 

Q43. LibreOffice writer एक ओपन सोर्स system software है?

1. a) True

2. b) False

Ans : b)

 

Q44. LibreOffice Writer और एमएस ऑफिस दोनों में Ctrl + F का समान कार्य होता है?

1. a) True

2. b) False

Ans : a)

 

Q45. LibreOffice Writer में सामान्यता लैंडस्केप होता है?

1. a) True

2. b) False

Ans : b)

 

Q46. LibreOffice writer document को हम doc, docx, xml जैसे files में save नहीं कर सकते क्योंकि यह ओपन सोर्स होता है?

1. a) True

2. b) False

Ans : b)

LibreOffice (calc) CCC Questions:

 

Q47. In LibreOffice Calc, the shortcut key of going at the last of left of the cell is?

(A) Alt + Tab

(B) Tab

(C) Alt

(D) Shift + Tab

Ans: D

Q48. What is the last column in LibreOffice Calc?

(A) AMJ

(B) XFD

(C) AMG

(D) EMJ

Ans: A

 

Q49. What is the combination of row and column in LibreOffice Calc?

(A) Cell

(B) Table

(C) Position

(D) Data

Ans: A

 

Q50. In LibreOffice Calc, Which symbol appears when a formula error occurs?

(A) $

(B) *

(C) \

(D) #

Ans: D

 

Q51. What will be the result of =product (7,-2)?

(A) 14

(B) -14

(C) 5

(D) None of the above

Ans: B

 

Q52. In LibreOffice Calc, cos,sin, fact,exp are category of?

(A) Data

(B) Math/Tring

(C) Mathematical

(D) String

Ans: C

 

Q53. What is the shortcut key of print preview in LibreOffice Calc?

(A) Ctrl + Shift + P

(B) Ctrl + Shift + O

(C) Ctrl + P

(D) None of the above

Ans: B

 

Q54. What is the shortcut key of inserting function in LibreOffice Calc?

(A) Ctrl + F2

(B) Ctrl + F4

(C) Ctrl + F3

(D) None of the above

Ans: A

 

Q55. What is the default file extension in LibreOffice Calc?

(A) .odt

(B) .ods

(C) .odp

(D) .xlsx

Ans: B

 

Q56. What is the shortcut key of edit mode of a cell in LibreOffice Calc?

(A) F2

(B) Ctrl + Shift + M

(C) Ctrl + M

(D) F3

Ans: A

 

Q57. What is the shortcut key of inserting time in LibreOffice Calc?

(A) Ctrl + ;

(B) Ctrl + Shift + ;

(C) Ctrl + T

(D) None of the above

Ans: B

 

Q58. What is the shortcut key of formatting of the cell in LibreOffice Calc?

(A) Ctrl + 1

(B) Ctrl + F2

(C) Ctrl + 2

(D) Ctrl + M

Ans: A

 

Q59. In which menu, merge cells command is found?

(A) Format

(B) Style

(C) Sheet

(D) Edit

Ans: A

Q60. What is the shortcut key of deleting of the cell in LibreOffice Calc?

(A) Ctrl + +

(B) Ctrl + –

(C) Ctrl + D

(D) Delete

Ans: B

 

Q61. In LibreOffice Calc, if the value is larger than the cell space, what result comes?

(A) ###

(B) Cell enlarges and result comes correctly

(C) ####

(D)NAME

Ans: A

 

Q62. What is maximum zoom in LibreOffice Calc?

(A) 300%

(B) 200%

(C) 400%

(D) 500%

Ans: C

 

Q63. What is the minimum zoom in LibreOffice Calc?

(A) 10

(B) 15

(C) 8

(D) 20

Ans: D

 

Q64. How many total columns are there in LibreOffice Calc?

(A) 1024

(B) 1048576

(C) 16384

(D) None of Above

Ans: A

 

Q65. How many total rows are there in LibreOffice Calc?

(A) 1024

(B) 1048576

(C) 16384

(D) None of Above

Ans: B

 

Q66. How many maximum characters in one cell in LibreOffice Calc?

(A) 32767

(B) 1048576

(C) 16384

(D) 1024

Ans: A

 

Q67. What is the shortcut key to reach of last cell of a spreadsheet in LibreOffice Calc?

(A) Ctrl + Home

(B) Ctrl + End

(C) Ctrl + Shift + Home

(D) None of above

Ans: B

Q68. What is the shortcut key for adding cell in LibreOffice Calc?

(A) Ctrl + +

(B) Ctrl + –

(C) Ctrl + D

(D) Delete

Ans: A

 

Q69. How many total charts in LibreOffice Calc?

(A) 8

(B) 5

(C) 10

(D) None of Above

Ans: C

 

Q70. What is the value of =round (175,-2)?

(A) 100

(B) 173

(C) 200

(D) None of Above

Ans: C

Q71. What is the value of =round (1175,-2)?

(A) 1100

(B) 1173

(C) 1200

(D) None of Above

Ans: C

 

Q72. which shortcut key is used for current date?

(A) Ctrl +:

(B) Ctrl + ;

(C) Ctrl + shift :

(D) None of above

Ans: B

 

Q73. What is the mail merge option in LibreOffice Calc?

(A) To mail a created file to someone

(B) Used for mailing many people

(C) Used to merge two mails together

(D) None of Above

Ans: B

 

Q74. What is the shortcut key to reach first column in LibreOffice Calc?

(A) Home

(B) Ctrl + Home

(C) Alt + Home

(D) None of above

Ans: B

 

Q75. What is the shortcut command to open a new file in LibreOffice Calc?

(A) Ctrl + N

(B) Ctrl + M

(C) Ctrl + Shift + N

(D) None of Above

Ans: A

 

Q76. What is the shortcut key to increase the cell width in LibreOffice Calc?

(A) Alt + Left Arrow

(B) Alt + Right Arrow

(C) Ctrl + Right Arrow

(D) None of Above

Ans: B

Q77. LibreOffice Calc में function insert करने की shortcut key है?

1. a) Shift + F3

2. b) Ctrl + F2

3. c) Ctrl + F3

4. d) Alt + F3

Ans : b)

 

Q78. LibreOffice Calc में print preview की shortcut key क्या है?

1. a) Ctrl + Shift + P

2. b) Ctrl + Shift + O

3. c) Ctrl + P

4. d) None

Ans : b)

Q79. LibreOffice Calc में टाइम इंसर्ट करने के लिए किस shortcut key का प्रयोग करते हैं?

1. a) Ctrl + ;

2. b) Ctrl + Shift + ;

3. c) Ctrl + T

4. d) None

Ans : b)

 

Q80. LibreOffice Calc में Cell फॉर्मेटिंग के लिए किस shortcut key का प्रयोग करते हैं?

1. a) Ctrl + 1

2. b) Ctrl + F2

3. c) Ctrl + 2

4. d) Ctrl + M

Ans : a)

Q81. पूरे रो को सेलेक्ट करने के लिए किस shortcut key का प्रयोग करते हैं?

1. a) Ctrl + Space

2. b) Shift + Space

3. c) Ctrl + Shift + Page down

4. d) None

Ans : b)

 

Q82. LibreOffice Calc फाइल by default किस नाम से से save होता है?

1. a) Untitled1

2. b) Calc1

3. c) Spreadsheet1

4. d) None

Ans : a)

 

Q83. LibreOffice में comment के लिए किस key का प्रयोग करते हैं?

1. a) Ctrl + Shift + C

2. b) Ctrl + C

3. c) Ctrl + Shift + T

4. d) Ctrl + Alt + C

Ans : d)

 

Q84. LibreOffice Calc में किसी नंबर को करेंसी फॉर्मेट में बदलने के लिए किस कुंजी का प्रयोग करते हैं?

1. a) Ctrl + Shift + 1

2. b) Ctrl + Shift + 5

3. c) Ctrl + Shift + 4

4. d) Ctrl + Shift + 3

Ans : c)

 

Q85. LibreOffice Calc में डायरेक्ट फॉर्मेट क्लियर करने की शॉर्टकट की है?

1. a) Ctrl + v

2. b) Ctrl + M

3. c) Ctrl + Shift + F

4. d) Ctrl + 1

Ans : b)

 

Q86. Name box कहां होता है?

1. a) मेनू बार के नीचे बाए तरफ

2. b) मेनू बार के ऊपर बाएं तरफ

3. c) स्टेटस बार पर

4. d) मेनू बार के नीचे दाएं तरफ

Ans : a)

 

Q87. अगली सीट में जाने के लिए किस key का प्रयोग करते हैं?

1. a) Tab

2. b) Ctrl + Tab

3. c) Ctrl + Shift + Tab

4. d) Shift + Tab

Ans : b)

 

Q88. LibreOffice Calc में किसी value को हाईलाइट करने के लिए किस shortcut key का प्रयोग करते हैं?

1. a) Ctrl + F6

2. b) Ctrl

3. c) Ctrl + F8

4. d) Ctrl + F1

Ans : c)

 

Q89. LibreOffice Calc में किसी cell का address कहां दिखाई देता है?

1. a) Formula Bar

2. b) Address Book

3. c) Name box

4. d) None

Ans : c)

 

Q90. Calc में लास्ट cell का address क्या होता है?

1. a) $D$10

2. b) AMJ1048575

3. c) XFD1048576

4. d) $AMD$1048576

Ans : b)

Q91. LibreOffice Calc में Monday से लेकर Sunday तक लिखने के लिए क्या करते हैं?

1. a) Monday लिखकर राइट डाउन corner पकड़कर नीचे की तरफ खींचते हैं

2. b) Monday लिखकर enter press करते हैं

3. c) =week() function का use करते हैं

4. d) उपरोक्त सभी

Ans : a)

Q92. Libreoffice Calc सेल के लेफ्ट जाने के लिए कौन सी key का use करते हैं?

1. a) Alt +Tab

2. b) Tab

3. c) Alt

4. d) Shift + Tab

Ans : d)

 

Q93. सभी वर्कशीट के formula को क्या कहते हैं?

1. a) Manipulate Values

2. b) Manipulate Labels

3. c) Return of formula Result

4. d) Use The Additional Operator

Ans : c)

Q94. LibreOffice Calc में =10*20/4*8 का क्या मान आएगा?

1. a) 400

2. b) 6.25

3. c) 7

4. d) 500

Ans : a)

 

Q95. LibreOffice Calc में नंबर लेफ्ट एलाइनमेंट और अल्फाबेट राइट अलाइनमेंट होता है?

1. a) True

2. b) False

Ans : b)

Q96. LibreOffice Calc by default एक ऑटो कैलकुलेटर feature उपलब्ध कराता जो कि एक चयनित सीमा परिसर में मानो को प्रदर्शित करता है?

1. a) True

2. b) False

Ans : a)

 

Q97. LibreOffice calc में पूरे Cell को एक Cell में बदल सकते हैं?

1. a) False

2. b) True

Ans : b)

 

Q98. LibreOffice Calc और Writer में है Ctrl + D का काम समान होता है?

1. a) True

2. b) False

Ans : b)

 

Q99. Round और Trunc function एक समान होते हैं?

1. a) True

2. b) False

Ans : b)

 

 

LibreOffice (Impress) CCC Questions :

 

Q100. What is the minimum zoom in LibreOffice Impress?

(A) 10

(B) 5

(C) 8

(D) 20

Ans: B

 

Q101. What is the Maximum zoom in LibreOffice Impress?

(A) 1000

(B) 2000

(C) 3000

(D) 4000

Ans: C

 

Q102. How many slide printed on an A4 paper in LibreOffice Impress?

(A) 6

(B) 9

(C) 12

(D) 15

Ans: B

 

Q103. What is the default file extension in LibreOffice Impress?

(A) .odt

(B) .ods

(C) .odp

(D) pptx

Ans: C

 

Q104. Which of the following view is not available in LibreOffice Impress?

(A) Outline

(B) Notes

(C) Slide sorter

(D) Master

Ans: D

 

Q105. Which of the following is a slide transition effect in LibreOffice Impress?

(A) Wipe all over

(B) Fine Dissolve

(C) Bit by bit

(D) None of the above

Ans: B

 

Q106. What is shortcut key to exit LibreOffice Impress?

(A) Ctrl + Q

(B) Ctrl + W

(C) Shift + C

(D) None of Above

Ans: B

 

Q107. What is shortcut key to add new slide in LibreOffice Impress?

(A) Ctrl + N

(B) Ctrl + M

(C) Shift + N

(D) Ctrl + Shift + N

Ans: B

 

Q108. What is Power point known as in LibreOffice Impress?

(A) Draw

(B) Impress

(C) Calc

(D) writer

Ans: B

 

Q109. What is shortcut key for slide show from current slide of the presentation?

(A) F5

(B) Ctrl + F5

(C) Shift + F5

(D) Alt + F5

Ans: C

 

Q110. LibreOffice Impress में कौन सा Alignment नहीं होता है?

1. a) Central Alignment

2. b) Left Alignment

3. c) Right Alignment

4. d) Justification

Ans : d)

 

Q111. LibreOffice Impress में Macros command किस menu में मिलता है?

1. a) Insert

2. b) slide

3. c) Tools

4. d) None

Ans : c)

 

Q112. LibreOffice Impress किस तरह का program है?

1. a) स्प्रेडशीट

2. b) वर्ड प्रोसेसिंग

3. c) प्रेजेंटेशन

4. d) इनमें से कोई नहीं

Ans : c)

 

Q113. LibreOffice Impress में बने Presentation का By Default क्या नाम होता है?

1. a) Shw1

2. b) Slide1

3. c) Presentation1

4. d) Untitled1

Ans : d)

 

Q114. LibreOffice Impress में कौन सी file का प्रारूप नहीं जोड़ा जाता है?

1. a) जेपीईजी (JPEG)

2. b) एच टी एम एल (HTML)

3. c) जी आई एफ (GIF)

4. d) डब्लू ए वीI (WAV)

Ans : b)

 

Q115. Libre Office presentation को किस नाम से जाना जाता है?

1. Silde Animation

2. Impress

3. Writer

4. Graphics

Ans : 2)

 

Q116. Jump to Last edited slide पर जाने की shortcut key क्या है

1. CTRL+NUMBER

2. ALT+SHIFT+F5

3. SHIFT+F5

4. None of above

Ans : 2)

 

Q117. Slide pane का option किस Menu में होता है?

1. View

2. Page Layout

3. Insert

4. Format

Ans : 1)

Q118. Slide Transition का option किस में होता है?

1. Slide

2. View

3. 1 and 2

4. Insert

Ans : 3)

 

Q119. Libreoffice draw में ruler की shortcut key क्या है?

1. Ctrl+Shift+R

2. Shift+F3

3. Ctrl+ Alt+ O

4. None Of These

Ans : 1)

Q120. लिब्रा ऑफिस Impress में कितनी मीनू होते हैं?

1. 12

2. 8

3. 10

4. 7

Ans : 3)

 

 

Q121. Impress में text box के लिए किस key का प्रयोग करते हैं?

1. F3

2. Ctrl+F2

3. IShift+F2

4. F2

Ans : 4)

 

Q122. Impress में previous slide पर जाने के लिए किस key का प्रयोग करते हैं–

1. N

2. M

3. W

4. P

Ans : 4)

 

ADG	Analog-Digital Converter.
AI	Artificial Intelligence.
ALGOL	Algorithmic Language
ALU	Arithmetic Logic Unit
ASCII	American Standard Code For Information Interchange.
ATM	Automatic Teller Machine
BASIC	Beginner’s All-Purpose Symbolic Instruction Code.
AEPS	Aadhaar Enabled Payment System
ABRS	Aadhaar Based Remittance Service
ARPANET	Advanced Research Projects Agency Network
ASP	Application Service Provider
ATM	Asynchronous Transfer Mode
BCC	Blind Carbon Copy
BCD	Binary Coded Decimal
BCR	Bar Code Reader
BIOS	Basic Input Output System
BHIM	Bharat Interface For Money
BPI	Bits Per Inch
BPS	Bits Per Second
B2C	Business to Consumer
CAD	Computer Aided Design
CARD	Computer Aided Research and Development
CC	Carbon Copy
CD-R	Compact Disk – Recordable
CD-ROM	Compact Disk – Read Only Memory
DFT	Digital Financial Tools
CGI	Common Gateway Interface
CLI	Command Line Interface
CMOS	Complementary Metal Oxide Semiconductor
COBOL	Common Business Oriented Language
CRT	Cathode Ray Tube
CPU	Central Processing Unit
CSS	Cascading Style Sheets
CU	Control Unit
DBMS	Database Management System
DMA	Direct Memory Access
DNS	Domain Name System
DOS	Disk Operating System
DPI	Dots Per Inch
DTP	Desk Top Publishing
DRAM	Dynamic Random Access Memory
DVD	Digital Video Disk
DVD-R	DVD – Recordable
DVD-RW	DVD – Rewritable
DVR	Digital Video Recorder
EBCDIC	Extended Binary Coded Decimal Interchange Code
EDP	Electronic Data Processing
EDS	Electronic Data System
EPFO	Employees Provident Fund Organization
EEPROM	Electrically Erasable Programmable Read Only Memory
EPROM	Erasable Programmable Read Only Memory
FDD	Floppy Disk Drive
FTP	File Transfer Protocol
GB	Gigabyte
GIF	Graphics Interchange Format
GIGO	Garbage in Garbage Out
GUI	Graphical User Interface
HDD	Hard Disk Drive
HTML	Hyper Text Markup Language
HTTP	Hyper Text Transfer Protocol
IDS	Intrusion Detection System
IBM	International Business Machines
IIS	Internet Information Services
IM	Instant Messaging
IMAP	Internet Message Access Protocol
IMEI	International Mobile Equipment Identity
I/O	Input / Output
IP	Internet Protocol
IPO	Input Process Output
IRC	Internet Relay Chat
IRCTC	Indian Railway Catering and Tourism Corporation
IS	Information System
IMPS	Immediate Payment service
IOT	Internet of Things
ISDN	Integrated Services Digital Network
ISO	International Organization for Standardization
ISP	Internet Service Provider
IT	Information Technology
IIoT	Industrial Internet of Things
KB	Kilobyte
Kbps	Kilobits Per Second
KHz	Kilohertz
KYC	Know your customer
LAN	Local Area Network
LCD	Liquid Crystal Display
LED	Light Emitting Diode
LPM	Lines Per Minute
LSI	Large Scale Integration
MAC	Media Access Control
MAN	Metropolitan Area Network
Mb	Megabit
MB	Megabyte
MDI	Multiple Document Interface
ME	Millennium Edition
MICR	Magnetic Ink Character Recognition
MIDI	Musical Instrument Digital Interface
MIPS	Million Instructions Per Second
MIME	Multipurpose Internet Mail Extensions
MODEM	Modulator – Demodulator
MOS	Metal Oxide Semiconductor
MS DOS	Microsoft Disk Operating System
MU	Memory Unit
MDA	Mail Delivery Agent
MTA	Mail Transfer Agent
NABARD	National Bank for Agriculture and Rural Development
NASSCOM	National Association of Software and Service Companies
NEFT	National Electronic Fund Transfer
NIC	Network Interface Card
NNTP	Network News Transfer Protocol
NUUP	National Unified USSD Platform
NPCI	National Payment Corporation Of India.
NT	New Technology
OCR	Optical Mark Reader
OSI	Open System Interconnection
ORS	Online Registration System
OTP	One Time Password
PAAS	Platform as a Service
P2P	Peer-to-Peer
PAN	Personal Area Network
PAN	Permanent Account Number
PCI	Peripheral Component Interconnect
PDA	Personal Digital Assistant
PIN	Personal Identification Number
PDF	Portable Document Format
PNG	Portable network graphics
POP	Post Office Protocol
POS	Point Of Sale
PPI	Pixels Per Inch
PPP	Point to Point Protocol
PROM	Programmable Read Only Memory
PSTN	Public Switched Telephone Network
QR Code	Quick Response Code
RAID	Redundant Array of Independent Disks
RAM	Random Access Memory
RDBMS	Relational Database Management System
RDS	Remote Desktop Services
RPA	Robotics Process Automation
RTF	Rich Text Format
ROM	Read Only Memory
RTGS	Real Time Gross Settlement
RTOS	Real Time Operating System
SAAS	Software as a Service
SATA	Serial Advance Technology Attachment
SMTP	Simple Mail Transfer Protocol
SEO	Search Engine Optimization
SET	Secure Electronic Transactions
SRAM	Static Random Access Memory
TCP	Transmission Control Protocol
UI	User Interface
UPI	Unified Payment Interface
URI	Uniform Resource Identifier
URL	Uniform Resource Locator
USB	Universal Serial Bus
USSD	Unstructured Supplementary Service Data
UTR	Unique Transaction Reference
VDU	Visual Display Unit
VLAN	Virtual Local Area Network
VM	Virtual Memory
VPA	Virtual Payment Address
W3C	World Wide Web Consortium
WAN	Wide Area Network
WAP	Wireless Application Protocol
Wi-Fi	Wireless Fidelity
WORM	Write once read many
WWAN	Wireless Wide Area Network
WWW	World Wide Web
XHTML	Extensible Hyper Text Markup Language
XML	Extensible Mark- up Language
IFSC	Indian Financial System Code

 

BANK QUESTION

 

Person needs to save money for:

1. a) Emergency

2. b) Future Needs

3. c) Large expense

4. d) All of these

 

2. ……….can be considered as a future need, which needs to save money.

3. a) Life after retirement

4. b) Buying home

5. c) Plan for marriage

6. d) Wanted to go to some other country for higher studies

 

3. Keeping cash at home is considered as unsafe because:

4. a) One cannot get any interest rate.

5. b) One cannot invest money

6. c) One is not eligible for huge initial investments

7. d) One cannot protect when it gets stolen

 

4. Which types of services delivery channels provide:

5. a) Internet

6. b) Financial

7. c) Banking

8. d) Loan

 

5. ATM is:

6. a) Automic Transaction Machine

7. b) Automatic Transit Machine

8. c) Automatic Transaction Machine

9. d) Automated Teller Machine

 

6. Bank Mitra acts as an agent of bank at those places where it is not possible to open a branch of:

7. a) Insurance

8. b) Bank

9. c) Financial Institute

10. d) ATM

 

7. ATMs enable a person to:

8. a) Deposit cash

9. b) Withdraw cash

10. c) Fund Transfer and balance enquiry

11. d) All of these

 

8. To access the internet banking customer needs:

9. a) Customer ID and Password

10. b) Customer name and password

11. c) Customer ID and Date of Birth

12. d) Customer ID and Phone Number

 

9. NEFT stands for:

10. a) National Electronic Funds Transfer

11. b) National Electric Fund Transfer

12. c) National Electronic Fond Transfer

13. d) National Electronic Fund Transmission

 

10. RTGS stands for:

11. a) Real Time Gross Settlement

12. b) Real Total Gross Settlement

13. c) Real Time Group Settlement

14. d) Real Time Gross Service

 

11. KYC stands for:

12. a) Know your customer

13. b) Knowing your customer

14. c) Know Youth Customer

15. d) Know Your Custom

16. PMJDY stands for:

17. a) Pradhan Mantri Jan-Dhan Yojana

18. b) Pradhan Mantra Jan-Dhan Yojana

19. c) Pradhan Mantri Jana-Dhan Yojana

20. d) Pradhan Mantri Jan-Dam Yojanas

 

13. QR Stands for:

14. a) Quick Response code

15. b) Quickly response code

16. c) Quick responded code

17. d) None of these

 

14. What is PMMY?

Ans. PMMY stands for Pradhan Mantri Mudra Yojana.

Shishu: Covering loans up to Rs 50,000

Kishore: Covering loans above Rs 50,000 and upto Rs 5, 00,000

Tarun: Covering loans above Rs 5, 00,000 and upto Rs 10, 00,000

 

15. What is PMSBY?

Ans: PMSBY stands for Pradhan Mantri Suraksha Bima Yojana.

Eligibility: Between 18 years and 70 years.

Policy period: One year period starting from 1st June 2015 to 31st May 2016.

Premium: Rs 12+service tax (per annum)

Risk Coverage: Total coverage under the scheme is Rs 2 lakh.

 

16. What is PMJJBY?

Ans. PMJJBY stands for Pradhan Mantri Jeevan Jyoti Bima Yojana

Eligibility: Between 18 and 50 years

Policy period: From 1 June 2015 to 31 May 2016

Premium: Rs 330+ Service tax (per annum)

Risk coverage: 2, 00,000 on death

 

17. The full form of DD is Demand Drafts.

 

18. What is IFSC?

Ans. IFSC stands for Indian Financial System Code. This is 11 digit codes with the first 4 alpha characters representing the bank and last 6 characters representing the branch. The 5th character is 0.

 

19. IMPS is immediate payment Service

 

20. Main security of internet banking is-

21. a) Password

22. b) User Name

23. c) User address

24. d) User mobile number

 

21. Which through app we can transfer the money but cannot do any payment as bill/shopping.

22. a) BHIM

23. b) Paytm

24. c) Both a & b

25. d) None

 

22. UTR means—

23. a) Unique Transaction Reference

24. b) Unique Transmission Reference

25. c) Both a & b

26. d) None

 

23. What is Aadhar seeding?

24. a) Linking of Aadhaar with Bank account

25. b) Duplicate issuance of Aadhaar

26. c) Transfer of Aadhaar

27. d) None of above

 

24. Validity period of cheque is

25. a) 4 months from date of issue

26. b) 3 months from date of issue

27. c) 1 month from date of issue

28. d) Unlimited