IT Workshop Lab Record
IT Workshop Lab Record
(AUTONOMOUS)
Certificate
in………………………………laboratory by Mr/Ms……………………………………………..
EXCEL
Excel Orientation: The mentor needs to tell the
importance of MS office or equivalent (FOSS)tool
14 Excel as a Spreadsheet tool, give the details of the four
tasks and features that would be covered in each. Using
Excel :Accessing, overview of toolbars, saving excel 24/11/2023
files, Using helpand resources.
Task 1: Creating a Scheduler - Features to be covered:
Gridlines,Format Cells, Summation, auto fill,
Formatting Text.
Task 2: Calculating GPA -. Features to be covered:-
Cell Referencing, Formulae in excel –
15
average,standard deviation,Charts,Renaming and 01/12/2023
inserting worksheets,hyperlinking,count function. and Inserting worksheets, Hyper linking,
LOOKUP/VLOOKUP
16 Task 3: Split cells, freeze panes, group and outline,
08/12/2023
Sorting, Boolean and logical operators, Conditional
Formatting
POWER POINT
Task 1: Students will be working on basic power point
utilities and tools which help them create basic power 15/12/2023
point presentations. PPT Orientation, Slide Layouts,
17
Inserting Text, Word Art, Formatting Text,Bullets and
Numbering, Auto Shapes, Lines and Arrows in
PowerPoint.
Task 2: Interactive presentations - Hyperlinks,
22/12/2023
18 Inserting –Images, Clip Art, Audio, Video,
Objects,Tables and Charts.
Task 3: Master Layouts (slide, template, and notes),
19 Types of views (basic, presentation, slide slotter,notes
etc.), and Inserting – Background, textures, Design 22/12/2023
Templates, Hidden slides.
AI TOOLS – ChatGPT
Task 1: Prompt Engineering: Experiment with
different types of prompts to see how the model
responds.
20 Try asking questions, starting conversations, or even
29/12/2023
providing incomplete sentences to see how the model
completes them.
• Ex: Prompt: "You are a knowledgeable AI. Please
answer the following question: What is the capital of
France?"
The word computer derived from a Latin word “compute”, which means “calculate”.
Definition:-
A Computer is an electronic device that takes data and instructions as an input from the user,
processes data , and provides useful information known as output.
Expansion:-
C – Commonly
O – Operated
M – Machine
P – Particularly
U – Used for
T – Technical
E – Education
R – Research
Components of a computer:-
A computer system has mainly two components, namely Hardware and Software.
Hardware:-
Hardware refers to the physical units of the computer which includes all electronic and
electric components and devices, which can be seen by us and touchable components.
Software:-
Input, process information, output, storage are the various functions of computer.
2. Usb
3. Parallel port
4. Cpu chip
5. Ram slots
6. Floppy controller
7. Ide controller
8. Pci slot
9. Isa slot
1. Mouse &keyboard:
Keyboard Connectors are two types basically. All PCs have a Key board port
connected directly to the motherboard. The AT-style keyboard connector is quickly
disappearing, being replaced by the smaller mini DIN PS/2-style keyboard connector.
Mouse:-
Mouse is an electro-mechanical, hand-held device.
It is used as a pointer.
USB is the General-purpose connection for PC. You can find USB versions of many
different devices, such as mice, keyboards, scanners, cameras, and even printers. a USB
connector's distinctive rectangular shape makes it easily recognizable. USB has a number of
features that makes it particularly popular on PCs. First, USB devices are hot swappable. You
can insert or remove them without restarting your system.
3. Parallel port:
Most printers use a special connector called a parallel port. Parallel port carry data
on more than one wire, as opposed to the serial port, which uses only one wire. Parallel ports
use a 25-pin female DB connector. Parallel ports are directly supported by the motherboard
through a direct connection or through dangle.
4. CPU Chip:
The central processing unit, also called the microprocessor performs all the
calculations that take place inside a pc. CPUs come in Variety of shapes and sizes.Modern
CPUs generate a lot of heat and thus require a cooling fan or heat sink. The cooling device
(such as a cooling fan) is removable, although some CPU manufactures sell the CPU with a
fan permanently attached.
5. RAM slots:
Random-Access Memory (RAM) stores programs and data currently being used by
the CPU. RAM is measured in units called bytes. RAM has been packaged in many different
ways. The most current package is called a 168-pin DIMM (Dual Inline Memory module).
6. Floppy controller:
The floppy drive connects to the computer via a 34-pin ribbon cable, which in turn
connects to the motherboard. A floppy controller is one that is used to control the floppy
drive.
7. IDE controller:
Industry standards define two common types of hard drives: EIDE and SCSI.
Majority of the workstations. The EIDE drive connects to the hard drive via a 2-inch-wide,
40-pin ribbon cable, which in turn connects to the motherboard. IDE controller is
responsiblefor controlling the hard drive.
8. PCI slot:
Intel introduced the Peripheral component interconnect bus protocol. The PCI bus
is used to connect I/O devices (such as NIC or RAID controllers) to the main logic of the
computer. PCI bus has replaced the ISAbus.
To provide CMOS with the power when the computer is turned off all
motherboards comes with a battery. These batteries mount on the motherboard in one of three
ways: the obsolete external battery, the most common onboard battery, and built-in battery.
If you have a modern motherboard, you will almost certainly notice a single
connector that looks like a PCI slot, but is slightly shorter and usually brown. You also
probably have a video card inserted into this slot.This is an Advanced Graphics Port (AGP)
slot
To install the CPU, just slide it straight down into the slot. Special notches in the
slot make it impossible to install them incorrectly. So remember if it does not go easily, it is
probably not correct. Be sure to plug in the CPU fan's power.
The Power supply, as its name implies, provides the necessary electrical power to
make the pc operate. the power supply takes standard 110-V AC power and converts into +/-
12- Volt, +/-5-Volt, and 3.3-Volt DC power.
Computer Peripherals
Cabinet / Case:
S.M.P.S
A switched-mode power
supply (switching-mode power supply,
switch-mode power supply, switched power
supply, SMPS, or switcher) is an electronic
power supply that incorporates a switching
regulator to convert electrical power
efficiently.
Computer – Motherboard
Central Processing
Unit (CPU)A central processingunit
(CPU), also called a centralprocessor,
main processor or just processor, is
the electronic circuitry that
executes instructions comprising
a computer program. The CPU performsbasic
arithmetic, logic, controlling,
and input/output (I/O) operations
specified by the instructions in the
program.
Types of Central processing Unit / Types of Processors
5. Octa Core CPU 8 Intel released their first Intel Core i7- 3.50 GHz and
Octa-core processor in 5960X
20 MB of Cache.
the Year 2014.
CPU fan
• ROM holds all control programs and instructions which are needed for operating of
your computer system and its hardware components such as keyboard, mouse,
printer, and more.
• ROM contains BIOS (Basic Input/output System), and it is also known as “Boot
Loader”. When, you to get start up your PC then boot loader program is loaded into
RAM, and it controls all activates of your Computer system.
A VGA Card
A VGA Card – also known as
a video/display card or graphics adapter –
is utilised in order to process and generate an
output image feed to a computer monitor or
display. .... Much like a motherboard or
micro-computer, a video card is a printed
circuit board that comes equipped with its
own processing unit and memory
Sound Card
A sound card (also known as an audio card)
is an internal expansion card thatprovides
input and output of audio signals to and
from a computer under control of computer
programs. The term sound card is also
applied to external audio interfaces used for
professional audio applications.
Hard Disk
Hard disk, also called hard disk drive or hard drive, magnetic storage medium for
a computer. ............................. A computer's hard drive is a device consisting of several
hard disks, read/write heads, a drive motor to spin the disks, and a small amount of
circuitry, all sealed in a metal case to protect the disks from dust.
Task 2: Every student should disassemble and assemble the PC back to working condition. Lab instructors
should verify the work and follow it up with a Viva. Also, students need to go through the video which shows the
process of assembling a PC. A video would be given as part of the course content.
1. Check how to open the cabinet and determine where to fix the components.
2. Determine if the case has the appropriate risers installed.
1. Line up the patch on the motherboard ( ps/l, USB, etc ) with the appropriate
holes in theblock panel I/O shield of the case.
2. Check the points where you and to install
3. Install them and make the mother board sit on them and fix screws if required.
1. ACR slot.
2. PCI Slot.
3. AGP Slot.
4. ATX Connectors.
5. CPU Fan.
6. Chipset North Bridge.
7. CPU socket.
8. Floppy.
9. System memory.
10. Chipset south bridge.
11. Panel connector.
12. Power supply.
13. IDE connectors.
ATX Connectors:
1. PS, Mouse.
2. Key board.
3. USB.
4. Parallel ( Prints )
5. Serial COM1.
6. Serial COM 2.
7. Joystick.
8. Sound.
Fitting the processor:
2. Notice that there is a pin missing at one corner, determine the direction to fit in the processor.
3. You should not force the CPU. When inserting it. All pins should slide smoothly into the socket.
5. Install the heat sink over it (Different type for each processor). Heat sink / CPU fan.
Fitting the RAM:
2. RS, RE, RS or RESET: Connect the two pin Reset cable here.
3. PWR, PW, PWSW, PS or power SW: Power switch, the pc’s on (switch, the plug is two pin ).
4. PWLED, PWRLED or Power LED: The light emitting diode on the front panel of
the caseilluminates when the computer is switched on. It’s a 2-pin cable.
5. HD, HDD, and LED: These two pins connect to the cable for the hard disk activity LED.
Final Check:-
1. Mother board jumper configurations are the settings for the processor operator.
2. Drive jumper settings, master/ slave correct?
3. Are the processor, RAM modules and plug in cards finally seated in there sockets?
4. Did you plug all the cables in? Do they all fit really?
5. Have you frightened all the screws in plug- in cards or fitted the clips?
6. Are the drive secure?
7. Have u connected the power cables to all driver?
Powering up for the first time:
1. Ensure that no wires are touching the CPU heat sink fan.
2. Plug your monitor, mouse and keyboard.
3. Plug in power card and switch the power supply.
4. If everything is connected as it should be
• All system, fans should start spinning.
• U should hear a single beep and after about 5-10 sec.
• Amber light on monitor should go green.
• You will see computer start to boot with a memory check.
• Now check front LED’S to see if u plugged them in correctly.
• Check all other buttons.
• Power afford change any wrong settings.
WEEK-2
Task 3: Every student should individually install MS windows on the personal computer. Lab instructor should
verify the installation and follow it up with a Viva.
Section:1
1.Download the appropriate installation media from Microsoft:
• Download Windows 10
• Download Windows 8.1 Disc Image (ISO File)
• Download Windows 7 Disc Images (ISO Files)
2.Follow the steps to download the Windows version you want. Some versions may require you to provide
your Windows product key to verify your eligibility to download disc images.
3.Save the Media Creation Tool to your computer. Launch the file and click Accept when prompted toagree to
the software license terms when the download is finished.
4.Select Create installation media (USB flash drive, DVD, or ISO file) for another PC and clickthe Next
button.
5.Select Create installation media (USB flash drive, DVD, or ISO file) for another PC and clickthe Next
button.
6.Follow any on-screen instructions to set your preferred language, Windows edition, and System
Architecture. If unsure, check the Use the recommended options for this PC option and proceed.
7.Choose the USB flash drive and select your USB from the list. The Windows installation files will start to
download to your USB drive.
8.Flash drive: Select your flash drive from the list, click Next,and wait for the installation files to install.When
the process is complete, click Finish.
9.Connect your Windows 10 installation media. If you created a flash drive, connect it to the PC on whichyou
want to install Windows 10. If you made a DVD, insert it into the drive now.
10.Boot the PC into the BIOS. If your PC is not already set up to boot from your flash or optical drive,
rebooting from your installation media won't work
11.Wait for your computer to restart. Once your computer finishes restarting, you'll see a window here with
your geographical data. You're now ready to begin setting up your Windows 10 installation.
Section:2
3. Enter the product key to activate Windows and press “Next”, or press
“Skip” to enter a valid product key later.
4. Check the box next to “I accept the license terms” and select “Next”.
7.Select the “Load driver” option to load the appropriate driver for the storagedevice.
8.Make sure to load the appropriate storage device driver onto a CD, DVD, or USB flash
drive before completing the next step. The storage device drivers canbe found on the Lenovo
Support website here.
- For storages devices attached to the Intel storage controller, load the Intel Rapid Storage
Technology enterprise (RSTe) driver.
o Select “Browse”, and browse to the CD, DVD, or USB flash drive to where the
storage device driver is located and select “OK”.
- For storages devices attached to the Broadcom controller, load the Broadcom storage driver.
o Select “Browse”, browse to the CD, DVD, or USB flash drive to wherethe
storage device driver is located and select “OK”.
9.Select the driver to install.
10.Select the drive to install Windows and select “Next” at the bottom.
11.Installing Windows screen.
12.After the installation completes, the system will automatically reboot. If no product key
was entered above, then it’ll prompt to enter a product key again.
Either enter the product key here and select “Next” or select “Do
this later” at the bottom left.
13.Select “Use Express Settings” at the bottom right to use the default settings or select
“Customize settings” at the bottom left. For instructional purposes, “UseExpress settings”
was selected.
14.Create an account by typing a “User name”. Optionally, type a password to make itsecure.
15.Windows 10 desktop screen.
Task 4: Every student should install Linux on the computer. This computer should have windows installed. The
system should be configured as dual boot (VMWare) with both Windows and Linux. Lab instructors should verify
the installation and follow it up with a Viva.
1. Open a browser and open the VirtualBox downloads page and click the Windows hosts link. The latest
VirtualBox version as of this writing is 6.1.36. Save the installer somewhere you can quickly locate it, like
your Downloads folder.
2. Locate the VirtualBox installer file using your File Explorer. Double-click the file to launch the
VirtualBox Setup wizard.
Launch setup to install VirtualBox on Windows
3. Click Next on the first screen. This action tells the Wizard that you want to install VirtualBox.
Welcome message
5. On the next screen, you’ll see a list of the shortcuts and file associations the installation will create.
Check or uncheck the items you wish to include or exclude and click Next. This example leaves all options
checked.
Custom setup options
7. Finally, you’ll see a screen asking you to confirm the installation. Click Install to install VirtualBox on
Windows 10.
8. The installation process takes several minutes, depending on your system speed. Click Finish to close
the Wizard after the installation and start using VirtualBox.
After you install VirtualBox on Windows 10, your can create your first virtual machine.
Windows 11 had compatibility issues with VirtualBox, such as VMs cannot start, crashing, and having
corrupted displays. But Microsoft confirmed that such issues no longer exist in VirtualBox 6.1.28 and later
versions, so you can also apply all the steps below on Windows 11.
1. First, click the New button in the top-right corner of the VirtualBox window. This action
brings up the Create Virtual Machine wizard. This Wizard lets
Introduction
Linux is an industry-standard operating system, and Ubuntu is a popular distribution of Linux. In
order to run Ubuntu as the guest operating system in a virtual machine on your host machine (such
as your Windows or Mac laptop), you can first install VirtualBox and then install Ubuntu within
VirtualBox. Then whenever you start VirtualBox, you can select Ubuntu (or any other guest
operating system that you’ve installed) to run in the virtual machine managed by VirtualBox.
The virtual machine will boot off the installation disk and start the installation process
(Figure 9). Because the installation process downloads files from the Internet, you will need
a good connection.
Choose your language and click Install
Ubuntu to start the installation process.
At various times, you will be asked to
make a choice. Except otherwise
directed, you should accept the default
choices.
Task 5: Every student should install BOSS on the computer. The system should be configured as dual boot (VMWare)
with both Windows and BOSS. Lab instructors should verify the installation and follow it up with a Viva
OVERVIEW
• BOSS Operating System is an Indian OS based on GNU/Linux developed by C-DAC (Centre for
Development of Advanced Computing), Chennai.
• It is developed to provide the benefit of using Free/Open source software all over India.
• The Indian government has been using the BOSS operating system for official use and to control different
cyber vulnerabilities in Indian cyberspace.
• BOSS Operating System, also known as Bharat Operating System Solution, is a GNU/Linux distribution
that is derived from Debian Linux.
• This distribution was developed in India by the Centre for Development of Advanced Computing (C-
DAC), Chennai, in the year 20062006 for the enhancement of Free/Open source software used throughout
the entire nation.
• The National Resource Centre for Free and Open Source Software (NRCFOSS) is the key provider of BOSS
GNU/Linux OS.
• It has an upgraded desktop environment that supports local Indian languages.
Versions of BOSS
Till now, 9 major versions of BOSS OS have been released, which are as follows :
• 1.0 (Tarag) released in January 2006
• 2.0 (Anant) released in September 2007
• 3.0 (Tejas) released in September 2008
• 4.0 (Savir) released in April 2011
• 5.0 (Anokha) released in September 2013
• 6.0 (Anoop) released in August 2015
• 7.0 (Drishti) released in August 2018
• 8.0 (Unnati) released in July 2019
• 9.0 (Urja) released in February 2021
BOSS INSTALLATION ON VIRTUAL BOX
13.Whenever your
Click Start it shows
the pop-up
➢ Select the
Start-up Disk
14.Now Select “Install
BOSS-Graphical” or
“Install BOSS-Text
Mode
19.Click on
“Continue” to proceed
towards Manual
Network
configuration.
20.Set user name
21.Set up the
Password
22.By selecting
automatic partitioning,
you will not have to use
partitioning tools to
assign mount points,
create partitions or
allocate space for your
installation.
23.Continue
Partition disk
➢ Select
Continue
24.Select “Yes”
And Press Continue
25.It will ask the
confirmation before
writing the changes
to disk. Click “Yes”
and then click
“Continue”.
26.Finishing the Installation
27.Its Shows the Requesting
System Rebooting
You can connect a LAN cable to your computer to use the internet. In most cases you will not need to manually
configure the IP address, but if you have already connected the Ethernet cable and still aren’t getting the internet you
should follow the steps below.
Please note:
• this feature may not be supported in all models, and its function and procedure may differ depending on the
model.
• you will need an IP address to connect to a wired LAN, if this is not automatically assigned you can look it
up in Network and Internet settings.
Please note: check the location of the port, since it may vary between laptop and desktop models, then connect the
cable.
Desktop
Connect a LAN cable to the port at the back of the desktop computer.
Laptop
If there is no LAN port on the side of the laptop computer, use a LAN adapter to connect.
2.Click the Start button on the taskbar and then click Settings.
3. Click Network and Internet.
Please note: the name of the network device may vary depending on the model.
7. Select Internet Protocol Version 4 (TCP/IPv4), then click Properties
Please note:
• the name of the network component may vary depending on the Windows operating system.
• to add network items such as client, service, and protocol, click install at the bottom of the network list.
Please note:
• if your IP is not automatically assigned you can look it up in Network and Internet settings.
• to enter a fixed IP address, click Use the following IP address and then enter the address.
Accessing Web Sites
Each website has a unique address, called a URL (short for Uniform Resource Locator). It's like a street
address that tells your browser where to go on the Internet. When you type a URL into the browser's address
bar and press Enter on your keyboard, the browser will load the page associated with that URL.
In the example below, we've typed www.bbc.com/travel into the address bar.
Understanding URLs
Every time you click a link on a website or type a web address into your browser, it’s a URL. URL stands for
Uniform Resource Locator. Think of it like a street address, with each portion of the URL as different parts of
the address, and each giving you different information. Let’s examine each component of a URL and what we
can learn from it.
Scheme
Every URL begins with the scheme. This tells your browser what type of address it is so the browser connects
to it correctly. There are many types of schemes, but for typical web browsing you will mostly
see http and https. Your browser usually won’t show the scheme in the address bar, and usually you don’t need
to type the scheme when typing a web address; instead, you can just begin with the domain name. The scheme
is still always part of the URL; it just isn’t being displayed.
Domain name
The domain name is the most prominent part of a web address. Typically, different pages on the same site will
continue to use the same domain name. For example, all pages on this site share the
GCFLearnFree.org domain name.
Each segment of the domain name separated by a period is called a domain. The domain on the right is called
a top-level domain, with the domain to the left of it called the second-level domain, then third-level domain,
and so on.
You can often learn something about the site from the domains. One of the domains usually identifies the
organization, while the top-level domain may give you more general information on what kind of site it is. For
example, in the domain name nc.gov, the .gov domain means it is a government website in the United States,
the nc domain identifies it as the website of North Carolina.
In most URLs, the www domain can be omitted. Google.com and www.google.com lead to the same page.
However, other subdomains cannot be omitted. For example, all pages under news.google.com require
the news sub domain in the URL.
File path
The file path—often just called the path—tells your browser to load a specific page. If you don’t specify
a path and only enter a domain name, your browser is still loading a specific page; it’s just loading a default
page, which usually will help you navigate to other pages.
URLs that end with the domain name without a file path usually will load a homepage or an index page that's
designed to help you navigate to specific pages on the site. Often, if you can’t remember the file path for a
specific page, you can go to the homepage and search for it.
Parameters
Some URLs include a string of characters after the path—beginning with a question mark—called
the parameter string. You have probably noticed this part of a URL appear in your address bar after performing
a search on Google or YouTube. The parameter string can be clear or confusing to a human user, but it is critical
information for the server.
Anchor
Also appearing after the path, the anchor tells your browser to scroll to or load a specific part of the page.
Usually the anchor begins with a hashtag and is used to direct your browser to a specific part of a very long
page, much like a bookmark. Different anchors don’t load different pages; they simply tell the browser to
display different parts of the page.
A whole URL
When combined, these elements make up a URL, although not all URLs will have all five parts.
Using what we learned in this tutorial, we can tell from the domain name of this URL that it’s on Wikipedia,
from the parameters that the page is probably about burritos, and from the anchor that we’ll be looking at the
section on burritos for breakfast.
Keep in mind that these are the most common components of a URL. There are many other parts, but these are
the five you will see most often and that can usually give you the most information.
Accessing Email’s
Electronic mail, commonly shortened to “email,” is a communication method that uses electronic devices to
deliver messages across computer networks. "Email" refers to both the delivery system and individual messages
that are sent and received.
• Use a web browser to navigate to your email provider and log into your email account.
• Some email clients, like Outlook, let you download apps that you can use on your computer or
mobile. These apps give you access to your email account.
Go to your email service provider. Open a new tab in your favourite web browser and go to the address of your
email service provider. Email accounts accessed online are called “webmails.” This is the most commonly used
kind of email because it’s free and anyone can use it.
• Popular email service providers include Google (Gmail), Yahoo (Yahoo Mail), AOL (AIM), and
Microsoft (Outlook).
• To find out the web address of your webmail, you may ask people you know who use the same
email service, contact the customer service department of the email provider you’re using, or just
search for it.
Type in your username and password. Once you’ve opened the web address of your email provider, you
should be able to see a login page. Enter your email account’s credentials (username and password) in the text
fields provided.
• If you forgot your password, you can click the "Forgot Password?" link. If you remember your
password, you can change it to something else within your email dashboard.
Click the “Log In” or “Sign In” button to continue. You should now be able to access your email inbox.
• Once you've accessed your email, there are numerous things you can do! For one, you
can delete all the emails from one sender.
Task 2: Web Browsers, Surfing the Web: Students customize their web browsers with the LAN proxy settings,
bookmarks, search toolbars and pop-up blockers. Also, plug-ins like Macromedia Flash and JRE for applets
should be configured.
For many years, especially in the early 2000s, there was one browser that almost everyone used:
Microsoft's Internet Explorer. If you used the Internet at that time, you probably clicked an icon like this to
access the Web:
In the past, Internet Explorer was pre-installed on any PC you buy. Starting in the mid-2000s, other software
companies introduced new browsers, including Mozilla Firefox and Google Chrome. At the time, these
browsers allowed for more experimental features. Because of this, web developers began creating websites with
browsers like Chrome and Firefox in mind, which meant they didn't always work as well in Internet Explorer. If
you have a PC with Windows 10, you'll have Microsoft Edge as your web browser instead. Watch this video to
learn more about browsing in Edge.
It's always a good idea to keep at least two web browsers on your computer or mobile device. This way, if a
website isn't working correctly you can try opening the page in a different web browser. More often than not,
this trick can solve a lot of problems you might encounter online.
Each website has a unique address, called a URL (short for Uniform Resource Locator). It's like a street
address that tells your browser where to go on the Internet. When you type a URL into the browser's address
bar and press Enter on your keyboard, the browser will load the page associated with that URL.
In the example below, we've typed www.bbc.com/travel into the address bar.
Links
Whenever you see a word or phrase on a website that's blue or underlined in blue, it's probably a hyperlink,
or link for short. You might already know how links work, even if you've never thought about them much
before. For example, try clicking the link below.
Links are used to navigate the Web. When you click a link, it will usually take you to a different webpage.
You may also notice that your cursor changes into a hand icon whenever you hover over a link.
If you see this icon, it means you've found a link. You'll find other types of links this way too. For example,
many websites actually use images as links, so you can just click the image to navigate to another page.
Navigation buttons
The Back and Forward buttons allow you to move through websites you've recently viewed. You can also
click and hold either button to see your recent history.
The Refresh button will reload the current page. If a website stops working, try using the Refresh button.
Tabbed browsing
Many browsers allow you to open links in a new tab. You can open as many links as you want, and they'll stay
in the same browser window instead of cluttering your screen with multiple windows.
To open a link in a new tab, right-click the link and select Open link in new tab (the exact wording may vary
from browser to browser).
To close a tab, click the X.
To create a new blank tab, click the button to the right of any open tabs.
If you find a website you want to view later, it can be hard to memorize the exact web address. Bookmarks,
also known as favorites, are a great way to save and organize specific websites so you can revisit them again
and again. Simply locate and select the Star icon to bookmark the current website.
Your browser will also keep a history of every site you visit. This is another good way to find a site you visited
previously. To view your history, open your browser settings—usually by clicking the icon in the upper-right
corner—and select History.
Downloading files
Links don't always go to another website. In some cases, they point to a file that can be downloaded, or saved, to
your computer.
If you click a link to a file, it may download automatically, but sometimes it just opens within your
browser instead of downloading. To prevent it from opening in the browser, you can right-click the link and
select Save link as (different browsers may use slightly different wording, like Save target as).
Saving images
Sometimes you may want to save an image from a website to your computer. To do this, right-click the image
and select Save image as (or Save picture as).
Pop-Up Blockers
A pop-up is a small window that appears while browsing a website. Marketers mainly use pop-ups for advertising
and generating leads. A pop-up blocker is any program that prohibits a pop-up at some point in time.
Block notifications
If you still get communications from a site after disabling pop-ups, you may be subscribed to notifications. To
turn off notifications for a site:
Plug-ins
Plug-ins are small applications that allow you to view certain types of content within your web browser. For
example, Adobe Flash, Macromedia Flash and Microsoft Silverlight are sometimes used to play videos,
while Adobe Reader is used to view PDF files. Macromedia Flash is a program that creates interactive, and
animated media such as motion graphics, videos, presentations, and websites.
To enable the Java Runtime Environment (JRE) through your Web browser to follow given steps for Internet
Explorer.
4. Now, In the pop-up, scroll down and search for ‘Scripting of Java applet’ and make sure it is
enabled and click OK.
If you don't have the correct plug-in for a website, your browser will usually provide a link to download it.
There may also be times when you need to update your plug-ins.
Downloading and uploading
Downloading
Usually, when you download a file you will start the download by clicking a link to that file. Many of our
tutorials contain links to files, like this:
If you click the link, your browser should prompt you to select one of two methods for downloading the file.
• Open with will download the file and load it immediately in the specified program.
• Save File will download it and save it to your hard drive.
Either way, once you click OK, the download begins. Your browser will indicate the progress and time
remaining on the download.
Once the download is complete, either the file will be saved to your computer or it will open in the program you
selected. If you have trouble finding the file after you’ve downloaded it, check out our Finding Your
Downloads lesson.
Some browsers don’t always start this download process when you click the link to a file. In these cases, you
can right-click the link, then click Save Link As, then select a location to download the file.
Uploading
If a site allows uploads, it will have an upload utility to help perform the file transfer. Each site handles this
process differently, but we’ll give some common examples. Usually, the site will have help pages to walk you
through the upload process.
Many sites have an upload button that opens a dialog box. For example, Facebook has a camera icon that
begins the upload process.
A dialog box will appear, prompting you to select a file. Browse to the location where your file is stored, select
it, then click the Open button. Afterward, a progress bar tracking the upload process will appear on the page.
Some sites support a drag-and-drop interface. For example, when logged in to Dropbox you can drag the files
from a folder on your computer and drop them into the browser window.
WEEK-5
Task 3: Search Engines & Netiquette: Students should know what search engines are and how to use the search
engines. A few topics would be given to the students for which they need to search on Google. This should be
demonstrated to the instructors by the student.
After you run a search, you'll see a list of relevant websites that match your search terms. These are commonly
known as search results. If you see a site that looks interesting, you can click a link to open it. If the site doesn't
have what you need, you can simply return to the results page to look for more options.
Most browsers also allow you to perform a web search directly from your address bar, although some have a
separate search bar next to the address bar. Simply type your search terms and press Enter to run the search.
Search suggestions
If you don't find what you're looking for on the first try, don't worry! Search engines are good at finding things
online, but they're not perfect. You'll often need to try different search terms to find what you're looking for.
If you're having trouble thinking of new search terms, you can use search suggestions instead. These will
usually appear as you're typing, and they're a great way to find new keywords you might not have tried
otherwise. To use a search suggestion, you can click it with your mouse, or select it with the arrow keys on your
keyboard.
Refining your search
If you're still having trouble finding exactly what you need, you can use some special characters to help refine
your search. For example, if you want to exclude a word from a search, you can type a hyphen (-) at the
beginning of a word. So if you wanted to find cookie recipes that don't include chocolate, you could search
for recipes cookies -chocolate.
You can also search for exact words or phrases to narrow down your results even more. All you need to do is
place quotation marks (" ") around the desired search terms. For example, if you search for recipes "sugar
cookies", your search results will only include recipes for sugar cookies, instead of any cookies that happen to
use sugar as an ingredient.
These techniques may come in handy in certain cases, but you probably won't need to use them with most
searches. Search engines can usually figure out what you're looking for without these extra characters. We
recommend trying a few different search suggestions before using this method.
Content-specific searches
There may be times when you're looking for something more specific, like a news article, picture, or video.
Most search engines have links at the top of the page that allow you to perform these unique searches.
In the example below, we've used the same search terms to look for images instead of websites. If you see an
image you like, you can click to visit the website it originally came from.
You can use the extra search tools to narrow down your results even more. These tools will change based on the
type of content you're looking for, but in this example we can filter our images by size, color, image type, and
more. So if you wanted to find cookies with pink frosting, you could search for images that are mostly pink.
Advertisements
One final thing to note: Most search engines include advertisements with search results. For example, you can
see advertisements at the top of the search results below.
These ads are based on your search terms, and they often look similar to other search results. While they may be
useful in some cases, it's usually more helpful to focus on the actual search results.
Task 4: Cyber Hygiene: Students would be exposed to the various threats on the internet and would be asked to
configure their computer to be safe on the internet. They need to customize their browsers to block pop ups, block
active x downloads to avoid viruses and/or worms.
1. Computer Viruses
Computer viruses are the most common among internet security threats out there. Viruses enter your computers
by attaching to a host file or a system. Once they enter your computer, they can create damage instantly or
remain dormant.
The goal of viruses is to infect your other computers and networked systems. One of the basic steps to protecting
your computers from viruses is by setting up a firewall. This firewall works by blocking external access to your
network systems. A firewall is not 100% foolproof. But it will at least deter or slow down cyber attackers.
2. Malware
Another common security threat to your computer systems is malware or ransomware. Malware attacks your
files and will only stop until you pay the cybercriminal a hefty ransom. Studies reveal that malware affects 32%
of all the computers in the world. The attack starts by infecting your database systems. From there, it will encrypt
your data then pose a threat to delete all your files.
One of the first signs of a malware attack is the slowing down of your system. If you notice your computers
slowing down for no apparent reason, shut it down first. Disconnect them from the internet then reboot your
system. Thereafter, you can install a security product to scan your system for malware. Furthermore, install
reputable antivirus software along with your firewall.
3. Phishing
The main targets of a phishing attack include your usernames, passwords, and credit card information. They steal
valuable data by pretending to be banks and financial institutions, and they can also impersonate reputable
websites and even some of your personal contacts.
They use emails or instant messages that look legitimate at first glance. Their messages come with URLs that
prompt you to input your personal information. In turn, they’ll steal your credentials and use them to access your
accounts. To keep away from phishing attacks, be mindful of the emails and messages you receive. If you don’t
know the sender, think twice before opening the message. Also, check the content of your emails before opening
any links. If you see a lot of misspelled words, then a phishing attack is possible.
Additionally, invest in a total security program that offers protection against phishing attacks.
4. Botnets
Of all the different forms of internet security threats, this is one of the most dangerous. A botnet is similar to
malware. However, it involves a network of computers that hackers compromised.
In turn, hackers use it to control the infected computers within the network. What makes it even more dangerous
is that hackers can control the network remotely.
Since the end goal of botnets is to force you to pay a ransom, installing a dependable security program is
paramount. And if you discover one of your computers carries a botnet, you must remove the software and run
an antivirus scan thereafter.
6. Trojan Horse
A Trojan Horse is a program that looks legitimate and harmless. But in reality, it is a vector that carries many
harmful viruses. Once it gains network access, it can steal sensitive company data.
The most common method for Trojan Horse attacks is through email. The email usually comes with a link or
attachment containing the viruses. Once you open the attachment, it automatically downloads malware to your
computer. Apart from installing cybersecurity software, you should update your software regularly. This also
includes your security patches.
8. Rootkit
Similar to botnets, a rootkit allows hackers to access your system remotely. They do this by placing a collection
of tools on your network. Some of the common forms of rootkit attacks include the stealing of passwords and
disabling antiviruses, among others.
Rootkits enter your network if your system security is vulnerable. Thus, the solution is to keep your patches up-
to-date.
Pop-Up Blockers
A pop-up is a small window that appears while browsing a website. Marketers mainly use pop-ups for advertising
and generating leads. A pop-up blocker is any program that prohibits a pop-up at some point in time.
Block or allow pop-ups in Chrome
By default, Google Chrome blocks pop-ups from automatically showing up on your screen. When a pop-up is
blocked, the address bar will be marked Pop-up blocked . You can also decide to allow pop-ups.
• For websites that need ActiveX to work. ActiveX is still used on some sites, like banking sites. You
will need to turn on ActiveX if you want to use any of these websites.
• to use software from before. Some older games and apps that help you get things done may need
ActiveX. You will need to turn on ActiveX if you want to use any of these programs.
• To use certain Chrome features. Some parts of Chrome, like the PDF viewer, need ActiveX to work.
You will need to turn on ActiveX if you want to use these features.
WEEK-6
LaTeX
LaTeX is a high-quality typesetting system; it includes features designed for the production of technical and
scientific documentation. LaTeX is the de facto standard for the communication and publication of scientific
documents. LaTeX is available as free software.
An introduction to LaTeX
LaTeX, which is pronounced «Lah-tech» or «Lay-tech» (to rhyme with «blech» or «Bertolt Brecht»), is a
document preparation system for high-quality typesetting. It is most often used for medium-to-large technical
or scientific documents but it can be used for almost any form of publishing.
LaTeX is not a word processor! Instead, LaTeX encourages authors not to worry too much about the
appearance of their documents but to concentrate on getting the right content. For example, consider this
document:
Hello world!
To produce this in most typesetting or word-processing systems, the author would have to decide what layout to
use, so would select (say) 18pt Times Roman for the title, 12pt Times Italic for the name, and so on. This has
two results: authors wasting their time with designs; and a lot of badly designed documents!
LaTeX is based on the idea that it is better to leave document design to document designers, and to let authors
get on with writing documents. So, in LaTeX you would input this document as:
\documentclass{article}
\title{Cartesian closed categories and the price of eggs}
\author{Jane Doe}
\date{September 1994}
\begin{document}
\maketitle
Hello world!
\end{document}
Task 2: Using La TeX and Word to create a project certificate. Features to be covered:- Formatting Fonts
in word, Drop Cap in word, Applying Text effects, Using Character Spacing, Borders and Colors,
Inserting Header and Footer, Using Date and Time option in both LaTeX and Word.
Header and Footer:
1. To create a header, enter text or graphics in the header area
or click button on the header and footer toolbar.
2. To create footer, click switch between header and footer.
3. Then click exit.
Date and Time:
Insert a date field that automatically updates so that the current date isdisplayed when you
open or print the file.
Insert a time field that automatically updates so that the current timeis
displayed when you open or print the file.
Border:
• On the format menu, click borders and shadings.
• To specify that the border appears on a particular side of a page, suchas onlyat
the top, click custom under setting.
• To specify a particular page or section for the borders to appear,click
theoption you want to apply.
• To specify the exact position of the border on the page. Finally, click OK.
Color:
• Select the text you want to make a different color.
• To apply the color most recently applied to text, click font color.
• To apply different colors, click the arrow on the right of the font colorbutton,
select the color you want and then click the button.
PROCEDURE:
First click start button on the status bar. Then select program and again select
Microsoft word. On the menu bar click the file option. Then again click new. Then
enter the text not less than 100 words. A header appears at the top and the footer
appears at the bottom of each page. On the view menu, click header and footer
option. From dialogue box, make the required changes and then click OK. On the
format menu, click borders and shading s make required changes and the click OK.
Select the text you want and make the different color. Click on right of the font
color button, and then select the color you want and then click on the button.
WEEK-8
Task 3: Creating project abstract Features to be covered: -Formatting Styles, inserting table, Bullets and
Numbering, Changing Text Direction, Cell alignment, Footnote, Hyperlink, Symbols, Spell Check, Track
Changes.
AIM:
To create a document applying the above-mentioned techniques.
Software Requirement:MS-WORD
Hardware Requirement: Personal computer
THEORY:
Table:
A table consists of rows and columns.
Cell Alignment:
Aligns contents written in a table in the top left corner or top rightcorner or in
the center etc...
Foot Note:
Foot notes are used to comment on, or provide references for text in adocument.
Hyperlink:
It is a colored and underlined text or a graphic that you click to go to a file, a location in a file,
an HTML page on the World Wide Web, or an HTML page in an intranet.
Symbols:
You may not be able to enter certain symbols into your word document, as there is a
limitation on the keys on the keyboard. Creating these new symbols especially when working with
mathematical terms becomes very difficult. For example we can insert symbols such as≡,≈, ,..
Spell check:
It automatically checks for spelling and grammatical errors
Track changes:
A track change is an excellent feature of Microsoft word as it enables a user or
reviewer to keep track of the changes that have taken a period. Changes like insertion, deletion or
formatting changes can be kept track of.
Procedure:
Changing Text direction:
1. Click the drawing object or table cell that contains the text you want tochange.
2. On the Format menu, click Text Direction.
3. Click the orientation you want.
Table:
Cell Alignment:
Foot Note:
1. In print layout view, click where you want to insert the note referencemark.
2. On the Insert menu, point to Reference, and then click Footnote.
3. Click Footnotes or Endnotes.
By default, Word places footnotes at the end of each page and endnotes at the end of
the document. You can change the placement of footnotes and endnotes by making a
selection in the Footnotes or Endnotes box.
Hyper link:
Select the text or picture you want to display as the hyperlink, and then clickInsert Hyperlink
on the Standard toolbar
3. In the Name of new document box, type the name of the new file.
4. Under When to edit, click either Edit the new document later or Editthe new
document now
An e-mail address:
1. Select the text or picture you want to display as the hyperlink, and thenclick Insert
Hyperlink on the Standard toolbar
2. Under Link to, click E-mail Address.
3. Either type the e-mail address you want in the E-mail address box, or selectan e-mail
address in the recently used e-mail addresses box.
4. In the Subject box, type the subject of the e-mail messageA
specific location in another document
1. Type 1. to start a numbered list or * (asterisk) to start a bulleted list, andthen press
SPACEBAR or TAB.
2. Type any text you want.
3. Press ENTER to add the next list item.
Word automatically inserts the next number or bullet.
4. To finish the list, press ENTER twice, or press BACKSPACE to delete thelast bullet
or number in the list
Formatting Styles:
1. Select the words, paragraph, list, or table you want to change.
2. If the Styles and Formatting task pane is not open, click Styles and
Formatting on the Formatting toolbar
3. Click the style you want in the Styles and Formatting task pane. Ifthe
style you want is not listed, click All Styles in the Show box
Track Changes:
THEORY:
Table of contents:
Table of contents displays a list of headings in a created document. It
basically provides an outline of the entire document created
Newspaper columns:
One can create a newspaper columns document by specifying the number of
new letter-style column required and then adjust their width , and add vertical lines between
columns.
Newspaper columns:
6. Under apply to will be whole document if entire document is selected else wehave to
select a selected text.
7. Click ok
5. If you don't know the exact file name, you can substitute wildcard characters for
one or more real characters. Use the asterisk (*) as a substitute for zero or more
characters in a file name. Use the question mark (?) as a substitute for a single
character in a file name.
3. Use the Drawing toolbar to add any shapes or pictures that youwant
WORD ART:
1. On the Drawing toolbar, click Insert WordArt .
2.Click the WordArt effect you want, and then click OK.
3. In the Edit WordArt Text dialog box, type the text you want.4.Do any
of the following:
To change the font type, in the Font list, select a font.To change
the font size, in the Size list, select a size.To make text bold,
click the Bold button.
To make text italic, click the Italic button.
Formatting Images:
2. The same can be achieved by selecting the tools menu > customize>toolbars
tab>picture and click close.
Resize a drawing
o To scale the drawing and make the objects and canvas proportionately smaller or
larger, click Scale Drawing, and then drag the edges of the canvas.
Text Box:
1. On the Drawing toolbar, click Text Box .
2. Click or drag in your document where you want to insert the text box
3. You can use the options on the Drawing toolbar to enhance a text box—for
example, to change the fill color— just as you can with any other drawing object
1. On the Formatting toolbar, point to Line Spacing, and then do one ofthe
following:
o To apply a new setting, click the arrow, and then select the number thatyou
want.
oTo apply the most recently used setting, click the button.
o To set more precise measurements, click the arrow, click More,and
then select the options you want under Line Spacing.
1. Place the insertion point in the paragraph that you want to change, or selectseveral
paragraphs.
2. Do one of the following:
o To have text begin from the left, click Left-to-Right on the Formattingtoolbar.
o To have text begin from the right, click Right-to-Left on the Formattingtoolbar.
When you change the paragraph direction, Microsoft Word leaves justified and centered text
as it is. In the case of left-aligned or right -aligned text, Word flips the alignment to its
opposite. For example, if you have a left-to-right paragraph that is right aligned, such as the
date at the top of a letter, clicking Right-to-Left results in a right-to-left paragraph that is left
aligned.
Forms:
Using Microsoft word one can create an organized and structured document with a provision
to enter the required information into it. A document of such nature is called a form.
Mail Merge
Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more
using information stored in a list, database, or spreadsheet. When performing a Mail Merge, you will need
a Word document (you can start with an existing one or create a new one) and a recipient list, which is
typically an Excel workbook.
The Mail Merge pane will appear and guide you through the six main steps to complete a merge. The
following example demonstrates how to create a form letter and merge the letter with a recipient list.
Step 1:
• From the Mail Merge task pane on the right side of the Word window, choose the type of
document you want to create. In our example, we'll select Letters. Then click Next: Starting
document to move to Step 2.
Step 2:
• Select Use the current document, then click Next: Select recipients to move to Step 3.
Step 3:
Now you'll need an address list so Word can automatically place each address into the document. The list can be in
an existing file, such as an Excel workbook, or you can type a new address list from within the Mail Merge
Wizard.
1. Select Use an existing list, then click Browse to select the file.
3. If the address list is in an Excel workbook, select the worksheet that contains the list, then
click OK.
4. In the Mail Merge Recipients dialog box, you can check or uncheck each box to control
which recipients are included in the merge. By default, all recipients should be selected.
When you're done, click OK.
5. Click Next: Write your letter to move to Step 4.
If you don't have an existing address list, you can click the Type a new list button and click Create, then type
your address list manually.
Step 4:
Now you're ready to write your letter. When it's printed, each copy of the letter will basically be the same; only
the recipient data (such as the name and address) will be different. You'll need to add placeholders for the
recipient data so Mail Merge knows exactly where to add the data.
To insert recipient data:
1. Place the insertion point in the document where you want the information to appear.
2. Choose one of the placeholder options. In our example, we'll select Address block.
3. Depending on your selection, a dialog box may appear with various customization options.
Select the desired options, then click OK.
4. A placeholder will appear in your document (for example, «AddressBlock»).
5. Add any other placeholders you want. In our example, we'll add a Greeting line placeholder
just above the body of the letter.
6. When you're done, click Next: Preview your letters to move to Step 5.
For some letters, you'll only need to add an Address block and Greeting line. But you can also add more
placeholders (such as recipients' names or addresses) in the body of the letter to personalize it even further.
Step 5:
1. Preview the letters to make sure the information from the recipient list appears correctly in
the letter. You can use the left and right scroll arrows to view each version of the document.
2. If everything looks correct, click Next: Complete the merge to move to Step 6.
Step 6:
1. Click Print to print the letters.
2. A dialog box will appear. Decide if you want to print All of the letters, the current document
(record), or only a select group, then click OK. In our example, we'll print all of the letters.
3. The Print dialog box will appear. Adjust the print settings if needed, then click OK. The
letters will be printed.
Challenge!
1. Open our practice document and practice recipient list.
2. Use the Mail Merge Wizard to merge the letter with the recipient list.
3. Insert an address block at the top of the document. Choose the second format: Joshua
Randall Jr.
4. Above the body of the letter, insert a Greeting Line. Format the greeting line so it says Mr.
Randall,
5. Check your letters to make sure they are formatted correctly. Your third letter should look
something like this:
EXCEL
Excel Orientation: The mentor needs to tell the importance of MS office or equivalent (FOSS) tool Excel as a
Spreadsheet tool, give the details of the four tasks and features that would be covered in each. Using Excel –
Accessing, overview of toolbars, saving excel files, Using help and resources.
Introduction to MS-Excel
Excel is a computerized spreadsheet, which is an important business tool that helps you report
and analyze information. Excel stores spreadsheets in documents called workbooks. Each workbook
is made up of individual worksheets, or sheets. Because all sorts of calculations can be made in the
Excel spreadsheet, it is much more flexible than a paper spreadsheet. The Excel window has some
basic components, such as an Active cell, Column headings, a Formula bar, a Name box, the mouse
pointer, Row headings, Sheet tabs, a Task Pane, Tab scrolling buttons and Toolbars.
Sample Worksheet
Excel worksheet and workbooks
When you set up calculations in a worksheet, if an entry is changed in a cell, the spreadsheet
will automatically update any calculated values that were based on that entry. When you open Excel,
by default it will open a blank workbook with three blank worksheets. When you save a workbook,
you have a Save As option that can save the spreadsheet to earlier versions of Excel or to Quattro
Pro, Lotus 123 formats, dBase formats, and even to a comma or tab delimited text file.
Identify Excel components
To navigate within a workbook, you use the arrow keys, Page Up, Page Down, or the Ctrl Key
in combination with the arrow keys to make larger movements. The most direct means of Navigation
is with your mouse.
Scroll bars are provided and work as they do in all Windows applications. To move to other Worksheets,
you can:
A. Click their tab with the mouse
B. Use the Ctrl key with the Page Up and Page Down keys to move sequentially up or down
Through the worksheets.
If you are familiar with Microsoft Access, you will find the tab scrolling buttons for Moving
between worksheets to be similar to record browsing on an Access form or Datasheet.
Developing a Worksheet
➢ Determine the worksheet’s purpose. Enter the data and formulas.
➢ Test the worksheet and make any necessary edits / corrections
➢ Document the worksheet and improve appearance.
➢ Save and print the complete worksheet.
Entering data into a worksheet
To enter data, first make the cell in which you want to enter the data active by clicking it.
Enter the data (text, formulas, dates, etc.) into the active cell.
Use the Alt + Enter key combination to enter text on multiple lines within the same cell. Use
TAB Key, arrow keys, or ENTER key to navigate among the cells.
Entering Formulas
A formula is a mathematical expression that calculates a value. In Excel, formulas always
Begin with an equal sign (=).
A formula can consist of one or more arithmetic operators.
The order of precedence is a set of predefined rules that Excel follows to calculate a formula.
Resize worksheet rows and columns
There are a number of methods for altering row height and column width using the mouse or
menus:
Click the dividing line on the column or row, and drag the dividing line to change the width of
the column or Height of the row Double-click the border of a column heading, and the column will
increase in width to match the length of the longest entry in the column Widths are expressed either
in terms of the number of characters or the number of screen pixels. Identify cell ranges
➢ A group of worksheet cells is known as a cell range, or range.
➢ Working with ranges in a worksheet makes working with the data easier.
➢ Ranges can be adjacent or nonadjacent.
➢ An adjacent range is a single, rectangular block of cell
➢ Select an adjacent range by clicking on a cell and dragging to an opposite corner of a
➢ rectangle of cells
➢ A nonadjacent range is comprised of two or more adjacent ranges that are not
contiguous to each other
➢ To select a nonadjacent range, begin by selecting an adjacent range, then press and hold
down the Ctrl key as you select other adjacent ranges
To delete and clear cells, rows, or columns, you can use the Edit menu, or right click on a
heading or a selection of cells and choose Delete from the shortcut menu. Clearing, as opposed to
deleting, does not alter the structure of the worksheet or shift unclear data cells. What can be
confusing about this process is that you can use the Delete key to clear cells, but it does not remove
them from the worksheet as you might expect.
Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for
Microsoft Windows. It features calculation, graphing tools, pivot tables, and a macro programming language called
Visual Basic for Applications.
Grid lines
1. Click the worksheet.
2. On the file menu, click page Layout and the go to sheet options.
3. Click gridlines.
Format Cell
1. Change the font and font size.
2. Change the text color.
3. Make selected text or numbers bold, italic or underlined.
4. Create a new style.
Auto fit
1. Combine cells horizontally or vertically to make one large cell.
2. Add borders to cells.
3. Shade cells with colors.
4. Change the column width and row height
5. Change the font, font size or colors of text.
6. Align text vertically at the top, center and bottom of cell.
Task 2: Calculating GPA -. Features to be covered:- Cell Referencing, Formulae in excel – average, std. deviation,
Charts, Renaming and Inserting worksheets, Hyper linking, Count function.
Procedure
1. On the chart menu click chart type
2. Text direction.
3. Click the arrow down next to the text direction button. For right to left click right to left.
For left to right reading order, click left to right.
4. For reading order that is consistent with the language of the first entered character, click
context. For reading order that is inconsistent with the language of the first entered
character, click control.
5. In the tools menu click options and then click chart tab.
6. To show all worksheet data in the chart even if some rows and columns are hidden, clear the
plot visible cells by check box.
7. To prevent hidden rows and columns from displaying in the chart, select the plot cells
only check box
Hyper Linking
1. Create a worksheet: On the file menu, click new, and then click blank workbook task pane.
2. Insert a worksheet: C lick worksheet on the insert menu. Right click on sheet tab and then
click insert double click the template for the type of sheet you want.
3. Hyperlink: Using hyperlink we can insert one more sheet in the present sheet
4. Count function: Create a blank worksheet press control +c. In the worksheet select cell A
and press control +c. On the tools menu point to formula auditing and then click formula
auditing menu.
Worksheet
1. In the file menu go to menu then a new worksheet is created.
2. To add a single worksheet, click worksheet on the Insert menu. To add multiple
3. worksheets hold down shift and then click the number of worksheet tasks to add in an open
Workbook
Sort
1. Click a cell in the list you want to sort.
2. On the Data menu click sort.
3. Under first key sort click the custom sort order you want and then click ok.
4. Click any other sorting option you want.
Formulae in Excel
Charts
1. Get your data into Excel. First, you need to input your data into Excel.
2. Choose a type of chart/graph to create. ...
3. Switch axes, if necessary. ...
4. Adjust your labels and legends, if desired. ...
5. Change the Y axis measurement options, if desired. ...
6. Reorder data, if desired.
FORMULAS IN EXCEL
Data for some employees is recorded in a worksheet. They work a varied number of hours Each
day to produce clocks. By calculating the number of pieces each employee produces per hour, it
can be determined who is the most productive employee.
1. In a worksheet, enter your own data or the data shown in Figure 1–1.
2. Select cells D2:D7.
3. Enter the following formula: =C2/(B2*24).
4. Press <Ctrl+Enter>to fill the selected cell range with the current entry.
5. From the toolbar select Home and go to Number.
6. Click the dropdown arrow and select Format Cells.
7. Select the Number tab and then select Number from the Category list.
8. Set Decimal places to 2.
9. Click OK.
Count Function
Some of the content in this topic may not be applicable to some languages.
1. To count words in selected text only, select the text you want.
If you don’t select any text, Microsoft Word counts the words in the whole document.
LOOKUP/VLOOKUP
Task 3: Split cells, freeze panes, group and outline, Sorting, Boolean and logical operators, Conditional
formatting
This document explains the functions of VLOOKUP and HLOOKUP and how to use them
in a spreadsheet. It can be used in all versions of Microsoft Excel.
VLOOKUP and HLOOKUP are functions in Excel that allow you to search atable of data
and based on what the user has supplied and give appropriate information from that table.
If you have a table of Student ID numbers, Student Names and Grades, you can set up
Excel so that if a Student ID number is supplied by the user, it will look through the table
and output the student's name and grade.
A B C
VLOOKUP
HLOOKUP is the exact same function, but looks up data that hasbeen
formatted by rows instead of column.
The table _array is the area of cells in which the table is located. This includes not only
the column being searched on, but the data columns for which you are going to get the
values that you need. Back to the example, the table_array would not only include the
Student ID number column, but the columns for the Student Names and Grades as well.
The col _index _num is the column of data that contains the answer that you want. If your
table is set up as: column 1 - Student ID Number, column 2 - Student Names, column 3 -
Grades and you inputted a Student ID Number and you want to retrieve the grade that was
received for that person, the col _index
_num would be 3. 3 is the column number of the data column for the ANSWER that you are
trying to look up.
2. Under the Function Category, choose either All or Lookup & Reference.
4. The Function Wizard for VLOOKUP will then display. The 4 values talked
about above (lookup _value, table _array, col _index _num, range_lookup) are
required by the function. Each line for each value
required. If you put the cursor into the first line for lookup _value, down
below it explains what the lookup _value is for your reference. Similar
information is displayed when the cursor is in any of the other fields.
5. Enter in the lookup _value either by typing in the number for the cell, or,by
selecting the cell on the worksheet.
6. Enter in the table _array by typing in the numbers for the cells, or,by
selecting the group of cells on the worksheet.
7. Enter in the number for column which contains the data that you wish toobtain in
the col _index _num area.
Enter into the range _lookup field the value TRUE if the function should acceptthe closest
value to your lookup _value without going over or FALSE if an exact match is required.
8. Hit OK when ready.
WEEK-12
POWER POINT
Task 1: Students will be working on basic power point utilities and tools which help them create basic power
point presentations. PPT Orientation, Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and
Numbering, Auto Shapes, Lines and Arrows in PowerPoint.
• On the Home tab, click the bottom half of New Slide, and pick a slide layout.
, but you can change the slide orientation to portrait (vertical) layout
• In the Slide Size dialog box, select Portrait, then select OK.
• In the next dialog box, you can select Maximize to take full advantage of the space available, or you can select
Ensure Fit to make sure that your content fits on the vertical page.
Inserting text
desired text.
3.Ensure that your cursor is located inside the text placeholder and begin typing your text.
Insert WordArt
WordArt is a quick way to make text stand out with special effects. You begin by picking a WordArt style from
the WordArt gallery on the Insert tab, and then customize the text as you wish.
1.Click Insert > WordArt, and pick the WordArt style you want.
In the WordArt gallery, the letter A represents the different designs that are applied to all text you type.
Note: The WordArt icon is located in the Text group, and it may appear different depending on the program
you're using and the size of your screen. Look for one of these icons:
• The placeholder text "Your text here" appears, with the text highlighted.
You can use bulleted or numbered lists to help organize your text or show a sequential process in your
PowerPoint presentation.
• On the left side of the PowerPoint window, click a slide thumbnail that you want to add bulleted or numbered
text to.
• On the slide, select the lines of text in a text placeholder or table that you want to add bullets or numbering to.
• On the Home tab, in the Paragraph group, click Bullets or Numbering .
Add shapes
1. On the Insert tab, select Shapes, and then select a shape from the menu that appears.
2. In the slide area, click and drag to draw the shape.
3. Select the Format or Shape Format tab on the ribbon. Open the Shape Styles gallery to quickly add a
color and style (including shading) to the selected shape.
Change a connector
1. Select a connector.
2. Select the Format Shape option from the right mouse Action menu. Alternatively, on the Home tab, in
the Shape Styles group, select Line, and then select Line Options.
3. In the Format Shape pane, under Line, make sure Solid line is selected, and then select the type, size, or
cap type.
WEEK-13
Task 2: Interactive presentations - Hyperlinks, Inserting –Images, Clip Art, Audio, Video, Objects, Tables and
Charts.
Add a Hyperlinks to a slide
The fastest way to create a basic web hyperlink on a PowerPoint slide is to press Enter after you type the
address of an existing webpage.
Link to a website
1. Select the text, shape, or picture that you want to use as a hyperlink.
2. Select Insert > Hyperlink.
3. Select Existing File or Web Page, and add the:
o Text to display: Type the text that you want to appear as hyperlink.
o ScreenTip: Type the text that you want to appear when the user hovers over the hyperlink
(optional).
o Current Folder, Browsed Pages, or Recent Files: Select where you want to link to.
o Address: If you haven't already selected a location above, insert the URL for the web site you
want to link to.
If you link to a file on your computer, and move your PowerPoint presentation to another
computer, you'll also need to move any linked files.
o 4. Select OK.
1. Select the text, shape, or picture that you want to use as a hyperlink.
2. Select Insert > Hyperlink and select an option:
o Place in This Document: Link to a specific slide in your presentation.
o Create New Document: Link from your presentation to another presentation.
o E-mail Address: Link a displayed email address to open up a user's email program.
3. Fill in the Text to display, ScreenTip, and where you want to link to.
4. Select OK.
Add pictures
• To insert a picture that is saved on your local drive or an internal server, choose This Device, browse for
the picture, and then choose Insert.
• (For Microsoft 365 subscribers) To insert a picture from our library, choose Stock Images, browse for a
picture, select it and choose Insert.
• To insert a picture from the web, choose Online Pictures, and use the search box to find a picture.
Choose a picture, and then click Insert.
Clipart
Clip Art is a collection of media files (images, videos, audio, and animation files) that Microsoft includes with
the PowerPoint application.
In Office 2013 and Office 2016, there's no longer a clip art library, but Office still helps you insert clip art.
STEP 1:
Select Insert > Online Pictures
STEP 2:
Type a word or phrase to describe what you're looking for, then press Enter.
STEP 3:
Filter the results by Type for Clipart.
STEP 4:
Select a picture.
STEP 5:
Select Insert.
That's it!
Record audio
Note: Your device must have a microphone enabled in order to record audio.
If you’re using more than one audio file per slide, we recommend putting the audio icon in the same spot on
a slide to find it easily.
7. Select Play.
Change playback options
Select the audio icon and then select the Playback tab. Then select which options you'd like to use:
• To trim the audio, select Trim and then use the red and green sliders to trim the audio file accordingly.
• To fade in or fade out audio, change the number in the Fade Duration boxes.
• To adjust volume, select Volume and select the setting you prefer.
• To choose how the audio file starts, select the dropdown arrow next to Start, then select an option:
o In Click Sequence: Plays the audio file automatically with a click.
o Automatically: Plays automatically once you advance to the slide that the audio file is on.
o When Clicked On: Plays audio only when the icon is clicked on.
• To choose how the audio plays in your presentation, select an option:
o Play Across Slides: Plays one audio file across all slides.
o Loop until Stopped: Plays an audio file on loop until it’s stopped manually by clicking the
Play/Pause button.
• To have the audio play continuously across all slides in the background, select Play in Background.
Delete audio
To delete an audio clip, select the audio icon on the slide and press Delete.
1. In Normal view, click the slide that you want the video to be in.
2. On the Insert tab, click the arrow under Video, and then click Video on My PC.
3. In the Insert Video box, click the video that you want, and then click Insert.
To help prevent broken links, we recommend copying the video into the same folder as your presentation, and
then linking to it there.
1. In Normal view, click the slide where you want the link to the video to be in.
2. On the Insert tab, click the arrow under Video, and then click Video on my PC.
3. In the Insert Video box, click the file that you want to link to, click the down arrow next to the Insert
button, and then click Link to File.
Find out where a linked video is stored
If there's already a video on a slide and you want to know where it's stored, go to File > Info. Under Optimize
Media Compatibility, there will be information about all media files in the presentation—whether they are
linked or embedded in the file. If there are any linked videos, PowerPoint gives you a View Links hyperlink.
Click it to open a dialog box that shows the storage location of any linked files.
YouTube video
If you want to insert a video on YouTube, switch to Insert or link to a video on YouTube.
Preview a video
When a video is selected on a slide, a toolbar appears below the video that has a play/pause button, a progress bar,
incremental forward/backward buttons, a timer, and a volume control. Click the Play button at the left of that
toolbar to preview the video.
By default, in Slide Show, the video plays as part of the click sequence. That means that when you click
anywhere on the slide to advance to the next step (or when you press the Spacebar, Right arrow key, or other key
that advances to the next step) the video plays. This Start option is called In Click Sequence.
But if you prefer, you can make the video start automatically as soon as it appears onscreen, or make it play
when it is clicked:
Automatically (If there are animation steps before it, the animation steps will play first and then the
video starts playing automatically. If there are no other animation steps before the video
on the slide, the video begins playing immediately.)
When Clicked
The video starts only when it has been clicked.
On
Objects
There are two ways to insert content objects into a PowerPoint presentation:
• Linked objects A linked object is updated if its source file is changed. For example, a linked chart
built from data in Microsoft Excel is changed if the source Excel data changes. The source file must be
available on your computer or network to maintain the link between the inserted object and the source
data. Inserting a linked object is recommended if the source data set is large or complex.
• Embedded objects The source data is embedded in the presentation. You can view the embedded
object on another computer, because the source data is part of the presentation file. Embedded objects
typically require more disk space than linked objects.
• In the File box, type the name of the file, or click Browse to select from a list.
• To display the content in your presentation, clear the Display as icon check box.
• To display an icon that is clicked to view the object, select the Display as icon check box.
To change the default icon image or label, click Change Icon, and then click the icon that you want from
the Icon list. If you want, you can type a label in the Caption box.
• If the object does not already exist, click Create new. In the Object type box, click the type of object that
you want to create.
• If the object already exists, click Create from file. In the File box, type the name of the file, or click
Browse to select from a list. Clear the Link check box.
• To display the content in your presentation, clear the Display as icon check box.
• To display an icon that is clicked to view the object, select the Display as icon check box.
To change the default icon image or label, click Change Icon, and then click the icon that you want from
the Icon list. If you want, you can type a label in the Caption box.
• Use the mouse to select the number of rows and columns that you want.
• Select Insert Table, and then enter a number in the Number of columns and Number of rows lists.
• To add text to the table cells, click a cell, and then enter your text. After you enter your text, click outside the
table.
Tips:
• To quickly insert a new row at the end of a table, click inside the last cell of the last row, and then press
TAB.
• To add rows or columns, right-click a cell, click Insert on the mini toolbar, and choose where you’d like
to insert the row or column.
• To delete rows or columns, right-click a cell, click Delete on the mini toolbar, and choose what you'd like
to delete.
Charts
• Click the chart type and then double-click the chart you want.
Tip: For help deciding which chart is best for your data, see Available chart types.
• In the worksheet that appears, replace the placeholder data with your own information.
• When you insert a chart, small buttons appear next to its upper-right corner. Use the Chart Elements
button to show, hide, or format things like axis titles or data labels. Or use the Chart Styles button to
quickly change the color or style of the chart.
Tip: The Chart Filters button is a more advanced option that shows or hides data in your chart.
Task 3: Master Layouts (slide, template, and notes), Types of views (basic,
presentation, slide slotter, notes etc.), and Inserting – Background, textures,
Design Templates, Hidden slides.
Slide master
When you want all your slides to contain the same fonts and images (such as logos), you can make those changes
in one place—the Slide Master, and they'll be applied to all your slides. To open Slide Master view, on
the View tab, select Slide Master:
The master slide is the top slide in the thumbnail pane on the left side of the window. The related layout masters
appear just below the slide master (as in this picture from PowerPoint for macOS):
1 Slide master
2 Layout masters
When you edit the slide master, all slides that are based on that master will contain those changes. However, the
majority of changes that you make will most likely be to the layout masters related to the master.
Slide Layouts
You change and manage slide layouts in Slide Master view. Every theme has a several slide layouts. You choose
the layouts that best match your slide content; some are better for text and some are better for graphics.
In Normal view, you’ll apply the layouts to your slides (shown below).
Templates
1. Open a blank presentation: File > New > Blank Presentation
2. On the Design tab, select Slide Size > Custom Slide Size and choose the page orientation and dimensions you
want.
3. On the View tab, in the Master Views group, choose Slide Master.
The slide master is the largest slide image at the top of the slide thumbnail list, to the left of your slides.
Associated slide layouts are positioned beneath the slide master.
4. To make changes to the slide master or slide layouts, on the Slide Master tab, do any of the following:
▪ To add a colorful theme with special fonts and effects, click Themes, and choose a theme from the gallery.
Use the scrollbar on the right to see more themes.
▪ To change the background, click Background Styles, and choose a background.
▪ To add a placeholder (to hold text, a picture, chart, video, sound, and other objects), in the thumbnail pane,
select the slide layout that you want to hold the placeholder, and do the following:
▪ Click Insert Placeholder, and select the type of placeholder you want to add.
▪ On the slide master or slide layout, click and drag to draw the placeholder size.
Tip: To resize a placeholder, drag the corner of one of its borders.
▪ To move a placeholder around on a slide master or slide layout, select the edge and then drag it into a new
position.
▪ To remove an unwanted placeholder in a slide master or slide layout, select it in the slide thumbnail pane, and
then select the border of the placeholder on the slide and press Delete.
▪ To set the page orientation for all of the slides in your presentation, click Slide Size > Custom Slide Size.
Under Orientation, choose Portrait or Landscape.
Slides are best when you don’t cram in too much information. You can put helpful facts and notes in the speaker
notes, and refer to them as you present.
1. To open the notes pane, at the bottom of the window, click Notes .
2. Click inside the Notes pane below the slide, and begin typing your notes.
Types of views
Normal view
You can get to Normal view from the task bar at the bottom of the slide window, or from the View tab on the
ribbon.
Normal view is the editing mode where you’ll work most frequently to create your slides. Below, Normal view
displays slide thumbnails on the left, a large window showing the current slide, and a section below the current slide
where you can type your speaker notes for that slide.
You can get to Slide Sorter view from the task bar at the bottom of the slide window, or from
the View tab on the ribbon.
Slide Sorter view (below) displays all the slides in your presentation in horizontally sequenced, thumbnails. Slide
show view is helpful if you need to reorganize your slides—you can just click and drag your slides to a new location,
or add sections to organize your slides into meaningful groups.
Notes Page view
You can show or hide your speakers notes with the Notes button at the bottom of the slide window, or you
can get to Notes Page view from the View tab on the ribbon.
The Notes pane is located beneath the slide window. You can print your notes or include the notes in a presentation
that you send to the audience, or just use them as cues for yourself while you're presenting.
1. Right-click the margin of the slide and then select Format Background.
2. In the Format Background pane, choose Picture or texture fill.
3. Under Insert picture from, choose where to get the picture from:
Option Use it to
File Insert a picture from your computer or network
drive
Clipboard Insert a copied picture
4. To adjust the picture's relative lightness, slide the Transparency bar to the right.
5. To apply the background picture to all slides in your presentation, choose Apply to All. Otherwise, simply close
the Format Background pane.
Textures
1. On the Format tab, in the Shape Styles group, click the arrow next to Shape Fill.
2. Do one of the following:
▪ To add or change a fill color, click the color you want.
▪ To choose no color, click No Fill.
▪ To use a color that isn't one of the theme colors, click More Fill Colors, and then either click the color that
you want on the Standard tab, or mix your own color on the Custom tab. Custom colors and colors on
the Standard tab do not update if you later change the document theme.
▪ To adjust the transparency of the shape, click More Fill Colors. At the bottom of the Colors dialog box, move
the Transparency slider, or enter a number in the box next to the slider. You can vary the percentage of
transparency from 0% (fully opaque, the default setting) to 100% (fully transparent).
▪ To add or change a fill picture, click Picture, locate the folder that contains the picture that you want to use,
click the picture file, and then click Insert.
▪ To add or change a fill gradient, point to Gradient, and then click the gradient variation that you want. To
customize the gradient, click More Gradients, and then choose the options that you want.
▪ To add or change a fill texture, point to Texture, and then click the texture that you want. To customize the
texture, click More Textures, and then choose the options that you want.
Design Templates
Design templates contain color schemes, slide and title masters with custom formatting, and styled fonts designed
for a particular "look." When you apply a design template to your presentation, the slide master and color scheme of
the new template replace the slide master and color scheme of the original presentation. After you apply a design
template, each slide you add, regardless of the AutoLayout has the same custom look.
1. Open a presentation you wish to use a basic design template or create a presentation for this purpose.
2. Click on File in the ribbon, click on Save As and choose where to save it.
3. In the Save As dialog box, under File name, type in a name for your template.
4. Click Design Template from the Save as type: dropdown menu (bottom of screen).
5. Click the Save button.
Hidden Slides
If there is a slide that should be included in the presentation file, but you don't want it to appear in the slide show,
you can hide the slide.
Hide a slide
1. In the left navigation pane, select the thumbnail image of the slide you want to hide.
2. Right-click the slide, then select Hide Slide. The slide now shows a slash through the slide number to indicate
that it's hidden:
Unhide a slide
1. In the left navigation pane, select the hidden slide you want to unhide.
2. Right-click the slide, then select Unhide Slide.
3. Show a hidden slide during a presentation
If you're in Slide Show view and you decide that you want to show a hidden slide, you can do so:
The screen switches to a thumbnail list of all the slides in the presentation.
The selected slide is shown full-screen and the slide show resumes.
If you are using presenter view, your audience won't see the steps you take to select the slide. They will simply
see the slide you select in step 2.
• To start the presentation at the first slide, in the Start Slide Show group, click From Beginning.
• If you’re not at the first slide and want to start from where you are, click From Current Slide.
To get out of Slide Show view at any time, on the keyboard, press Esc.
WEEK-14
ChatGPT refers to a type of language model developed by OpenAI, specifically based on the GPT
(Generative Pre-trained Transformer) architecture. The "GPT" in ChatGPT stands for "Generative Pre-trained
Transformer," highlighting its key features.
"Generative" implies that the model can generate coherent and contextually relevant text based on the input it
receives. "Pre-trained" indicates that the model is initially trained on a large corpus of diverse text data before
being fine-tuned or adapted for specific tasks. "Transformer" refers to the underlying neural network
architecture, which uses self-attention mechanisms to process input data in parallel, making it highly effective
for handling sequential data like language.
ChatGPT is designed to understand and generate human-like text, making it suitable for various
natural language processing (NLP) tasks, including but not limited to chatbots, conversational agents, and
text-based applications. It can understand context, generate responses, and provide valuable information based
on its training data.
The features of ChatGPT, or any model based on the GPT architecture, include: 1.Generative Text:
ChatGPT is capable of generating human-like text responses given a prompt or input. It can be used
for a variety of natural language generation tasks.
2. Pre-trained: Before fine-tuning for specific tasks, ChatGPT is pre-trained on a large and diverse
dataset to learn the nuances of language and context.
3. Context Understanding: The model has the ability to understand context over a certain window of
text, allowing it to generate coherent and contextually relevant responses.
4. Large-scale Training Data: ChatGPT is trained on a vast amount of text data, which helps it capture a
broad range of topics, styles, and linguistic patterns.
5. Transfer Learning: Because it's pre-trained, ChatGPT can be fine-tuned for specific tasks with smaller,
task-specific datasets. This allows the model to adapt to particular use cases. 6.Flexibility: ChatGPT is
versatile and can be applied to various natural language processing tasks, including chatbots, question
answering, summarization, and more.
7. Parameter Size: The number of parameters in the model contributes to its capacity to learn and
generalize. Larger models, like GPT-3, have billions of parameters, enabling them to capture complex
patterns in data.
8. Attention Mechanism: The Transformer architecture, which ChatGPT is based on, utilizes attention
mechanisms to give different weights to different parts of the input sequence, allowing the model to focus
on relevant information.
9. Multi-Head Attention: ChatGPT employs multi-head attention, allowing it to attend to different
positions in the input sequence independently, capturing different aspects of thecontext.
10. Fine-Tuning: While pre-trained, ChatGPT can be fine-tuned on specific datasets for better performance
on particular tasks or domains.
It's important to note that these features are general characteristics of models based on the GPT architecture,
and specific implementations or versions may have additional capabilities or improvements.
Task 1: Prompt Engineering: Experiment with different types of prompts to see how the model responds. Try asking
questions, starting conversations, or even providing incomplete sentences to see how the model completes them.
Ex: Prompt: "You are a knowledgeable AI. Please answer the following question: What is the capital of France?"
1. Informational Prompt:
Prompt: "Provide a brief explanation of how photosynthesis works."
Expected Response: A detailed and informative explanation of the process of photosynthesis.
2. Creative Prompt:
Prompt: "Imagine a world where humans can communicate with animals. Describe a day in thelife of someone
with this extraordinary ability."
Expected Response: A creative and imaginative narrative about a person's experiences in aworld where
interspecies communication is possible.
3. Conversational Prompt:
Prompt: "What are your thoughts on the impact of artificial intelligence on society?" Expected Response:
An opinion or discussion on the societal implications of artificialintelligence, reflecting the model's
"perspective."
4. Problem-Solving Prompt:
Prompt: "You are a virtual assistant. Help the user troubleshoot a common computer problem,like a slow
performance issue."
Expected Response: Step-by-step guidance on diagnosing and addressing a computer's slowperformance.
5. Personal Reflection Prompt:
Prompt: "Share a personal experience or story that has left a lasting impact on you." Expected Response: A
reflective and personal account of a significant event or experience.
6.Humorous Prompt:
Prompt: "Tell me a joke that involves both technology and animals."
Expected Response: A light-hearted and humorous joke combining elements of technology andanimals.
7. Comparison Prompt:
Prompt: "Compare and contrast the advantages and disadvantages of traditional educationversus online
learning."
Expected Response: An analysis highlighting the pros and cons of both traditional and onlinelearning methods.
8. Prediction Prompt:
Prompt: "What do you think will be the most significant technological advancement in the nextdecade?"
Expected Response: A speculative response predicting a major technological breakthrough inthe coming years.
QUESTION:
• Ex: Prompt: "You are a knowledgeable AI. Please answer the following question: What is
thecapital of France?"
Answer: The capital of France is Paris.
WEEK-15
Task 2: Creative Writing: Use the model as a writing assistant. Provide the beginning of a story or a description of a
scene, and let the model generate the rest of the content. This can be a fun way to brainstorm creative ideas
Ex: Prompt: "In a world where gravity suddenly stopped working, people started floating upwards. Write a story about
how society adapted to this new reality."
Creative writing is a form of expression that goes beyond the mere conveyance of information or facts.
It is the art of crafting original and imaginative content, often in the formof stories, poems, or essays, to
evoke emotions, engage the reader's imagination, and convey ideas in a unique and artistic manner. Creative
writing allows writers to explore and experiment with language, style, and structure to create a literary work
that is not only informative but also aesthetically pleasing.
ANSWER:
In an instant, the laws of nature betrayed the unsuspecting inhabitants of Earth. Gravity, the invisible force
that had grounded humanity for eons, abruptly ceased its hold. Panic spread likewildfire as people, cars, and
even trees lifted off the ground, ascending into the sky.
In a stroke of genius, engineers and scientists developed specialized suits with built-in thrusters, allowing
individuals to control their movements. These suits became a symbol of adaptation and survival. Schools
shifted their focus to zero-gravity physics, teaching childrenhow to manoeuvre gracefully through the air.
Cities transformed into intricate networks of floating structures, connected by transparent walkways and
airborne transportation. Parks became suspended gardens, and offices convertedinto levitating workspaces.
Everyday activities required a new set of skills, from cooking in mid-air kitchens to playing sports with a
newfound sense of freedom.
As society adapted to its weightless existence, a sense of unity emerged. Collaborative effortsbecame the norm
as people discovered the importance of working together to navigate this uncharted territory. Community
events took on a surreal charm, with floating festivals and airborne celebrations lighting up the night sky.
At first, the fear of drifting into space lingered in the collective consciousness. However, engineers soon
developed safety measures, creating invisible barriers that surrounded habitablezones. These protective fields
prevented accidental journeys into the cosmic unknown and allowed society to flourish within its floating
confines.
In this extraordinary world, where the ground was no longer an anchor, humanity found resilience, innovation,
and a shared purpose. As the sun set on a horizon that was now a canvasof suspended dreams, the floating
society embraced the limitless possibilities of their weightless existence, forever bound by the indomitable
spirit of adaptation.
Task 3: Language Translation: Experiment with translation tasks by providing a sentence in one language
and asking the model to translate it into another language. Compare the output to see how accurate and
fluent the translations are.
Ex: Prompt: "Translate the following English sentence to French: 'Hello, how are you doing today?'"
Language translation refers to the process of converting written or spoken text from one language into another
while preserving the meaning and intent of the original content. This task is commonly performed by
individuals known as translators or by automated systems, such as machine translation tools.
There are two primary types of language translation:
1. Human Translation:
Professional Translators: Skilled individuals who translate text manually, taking into accountthe cultural
nuances, idioms, and context of the source and target languages.
Interpreters: Individuals who specialize in translating spoken language in real-time, facilitatingcommunication
between people who speak different languages.
2. Machine Translation (MT):
Automated Systems: Computer-based systems or software that use algorithms and linguisticrules to
translate text from one language to another.
Neural Machine Translation (NMT): A type of machine translation that uses artificial neuralnetworks to
improve translation quality by considering the context and meaning of entire sentences.
Language translation is crucial for breaking down language barriers in various domains, including
international business, diplomacy, literature, academic research, and everyday communication. It plays a
vital role in fostering global understanding, enabling people from different linguistic backgrounds to access
information and communicate effectively. Advancesin machine translation technologies have led to
significant improvements in translation speed and accuracy, although human translators often remain
essential for handling complex or context-sensitive content.
QUESTION:
• Ex:Prompt: "Translate the following English sentence to French: 'Hello, how are you
doingtoday?'"
The English sentence "Hello, how are you doing today?" can be translated to French as:
ANSWER:
"Bonjour, comment ça va aujourd'hui ?"