Chapter

Use of E - applications:
Learning objectives:

 To know:-

 To understand Google and its applications.

 To understand Spread sheet, presentation, Maps and other such features.
 Understanding & Using Google Calendar.
 Using YouTube, Channel Creation, Adding description, Downloading & uploading
content.
 Use of online food apps for ordering food and supplies online

Session: Google and its applications:

Google Search (also known simply as Google), is a search engine provided by Google. Handling
more than 3.5 billion searches per day, it has a 92% share of the global search engine market. It
is also the most-visited website in the world.

The order of search results returned by Google is based, in part, on a priority rank system called
"PageRank". Google Search also provides many different options for customized searches, using
symbols to include, exclude, specify or require certain search behavior, and offers specialized
interactive experiences, such as flight status and package tracking, weather forecasts, currency,
unit, and time conversions, word definitions, and more.
The main purpose of Google Search is to search for text in publicly accessible documents offered
by web servers, as opposed to other data, such as images or data contained in databases. In June
2011, Google introduced "Google Voice Search" to search for spoken, rather than typed, words.

Below are few of the most commonly used features of Google in an office:

Google offers few apps in its web browser for its patrons. Below mentioned are few of the most
commonly used apps to run an efficient office/ work place:

Google Drive:

Google allows all users’ access to Google Drive. Google Drive is cloud-based storage which
allows users to save files online and access the same from the device of their choosing including
smartphones, tablets, PCs, iPhones and iPads.
The company offers all users 15 GB of free storage on Google Drive. Google recently changed
its free storage policy earlier this year. What this means is that any new photos and videos you
back up will count toward the free 15GB of storage that comes with every Google account.

How to save files on Google Drive on Android:

1. Tap on the Google Drive icon to open the app on your device.
2. Login to your Google Account if you haven’t done the same already.
3. Click on the + button located on the bottom left corner of your screen.
4. Click on the upload button from the menu.
5. Select the files you want to upload.
6. You can access the files from the device of your choosing after the files are uploaded.

How to save files on Google Drive from your PC:

1. Visit drive.google.com.
2. Log in to your Google account if you haven’t done the same already.
3. Click on the +New icon located on the top left corner of the screen
4. Click on the upload button
5. Select the files that you wish to upload from your PC
6. You can access the files from the device of your choice after the file is uploaded.
Google Spread Sheets:

What is Google Sheets?

Google Sheets is a web-based application that enables users to create, update and modify
spreadsheets and share the data online in real time.

Google's product offers typical spreadsheet features, such as the ability to add, delete and sort
rows and columns. But unlike other spreadsheet programs, Google Sheets also enables multiple
geographically dispersed users to collaborate on a spreadsheet at the same time and chat through
a built-in instant messaging program. Users can upload spreadsheets directly from their
computers or mobile devices. The application saves every change automatically, and users can
see other users' changes as they are being made.

Google Sheets is included as part of the Google Docs Editors suite of free web applications. This
suite also includes Google Docs, Google Slides, Google Drawings, Google Forms, Google Sites
and Google Keep.

What is Google Sheets used for?

Google Sheets is typically used for spreadsheet collaboration across different geographic
locations. Multiple users can modify a Google Sheets document in real time, with changes
tracked for each individual user.
The Google Sheets online spreadsheet application enables users to create, edit and format
spreadsheets online to organize and analyze information. Google Sheets is often compared to
Microsoft Excel, as both applications are used for similar purposes. Google Sheets is essentially
Google's cloud-based version of Microsoft Excel's basic features.

How do you use Google Sheets?

Users can create and edit spreadsheets via the Google Sheets online web application, as well as
through mobile devices running on iOS or Android. To use Google Sheets, a valid email address
is required. Google Sheets enables users to do the following:

 Edit and format spreadsheets: Spreadsheet items can be added, edited, formatted and
applied to formulas and functions through Google Sheets.
 Analyze: Google Sheets can visualize spreadsheet data in charts, graphs and tables.
 Share: Users can share Google Sheets documents and folders with others for real-time
collaboration.
 Print and download: Users can open and import Google Sheets files into other document
formats, including Microsoft Excel, Word, PowerPoint, Adobe PDF and PNG (Portable
Network Graphics).
Google Sheets features

Google Sheets includes the following core features:

 Spreadsheet editing and formatting: This includes operations and functions for data entry;
data summary; text translation; data import; data validation; data protection; cleaning to
return text with unprintable characters removed and trimming to remove spaces that may
be leading, trailing or repeated in text; filtering data by conditions such as date,
alphabetical or numerical order; custom conditions and heat maps, which use colors to
represent the density of data points in the table; and basic and advanced formulas.
 Data visualization: Users can generate spreadsheet data for graphs, charts and other types
of diagrams and embed them in websites.
 Machine learning-based features: The Explore feature uses machine learning to build
charts, create pivot tables and answer questions about the data. It can auto-update based
on selected data.
 Offline editing: Even when not connected to the internet, Sheets can edit offline, and
changes will update once an internet connection is restored.
 Compatibility: Sheets documents are compatible with a variety of formats, including
Excel (XLS), Apache Open Office, PDF, Text, HTML and comma-separated values
(CSV).
 Google product integration: Google Sheets can be integrated with other Google services,
such as Drawing, Finance, Form and Translate. It is also compatible with Microsoft files
and shares many of the same keyboard shortcuts.
 Collaboration feature: Emails can be sent when other collaborators make comments or
changes to the shared spreadsheet, and users can view the version history.
 Security: Users can manage permissions for editing, downloading, copying or printing for
specific collaborators through individual-, group- or domain-level access.

Google Docs

Google Docs is a free Web-based application which a user can use to create documents and
spreadsheets. If you are a Google docs user you can import, create, edit and update documents
and spreadsheets in various fonts and file formats, combining text with formulas, lists, tables and
images. You can use Google Docs on your computer as well as Android and iPhone & iPad.
How to use Google Docs: Computer

Google Docs is an online word processor that lets you create and format documents and work
with other people. Here is a step by step guide which you can follow to use Google Docs.

Step 1: Create a document

To create a new document you need to follow the below-given steps:

Step 1: First open the Docs home screen at docs.google.com on your computer.

Step 2: After that in the top left, under Start a new document, click New.

Apart from the above steps, you can also create new documents from the URL
docs.google.com/create. After creating a document you can edit and format it.

Step 2: Edit and format

Here are the steps you can follow to edit a document:

Step 1: On your computer, open a document in Google Docs.

Step 2: After opening a document select a word, double-click it or use your cursor to select the
text you want to change.

Step 3: Start editing.

Step 4: You can even undo or redo an action, click Undo or Redo at the top of the page.
Note: If you are using a touch screen device to edit a document, like a Pixel Book, double-tap the
document to start typing. You can add numerous things and edit text, paragraphs, spacing, and
more in a document, like.

Step 3: Share & work with others

You can share files and folders with people and choose whether they can view, edit, or comment
on them.

Google Maps:

Google Maps is one of the most widely used services nowadays. It is an incredibly versatile tool
which is quick and easy to handle. Starting from measuring the distance between any two
locations to providing directions to the drivers, bikers, walkers, and users of public transportation
it helps users in a variety of ways.

Google Maps have made out life much easy and now it’s difficult to imagine a life without it. Do
you know how to use it? Here is a step-by-step instruction on how to use Google Maps.
Before you start using Google Maps, you need to do the following:

Turn on GPS

Let Google Maps access your current location and audio speakers

Here's a guide to get you started using Google Maps

Step 1: At first you need to open the Google Maps app.

Step 2: Search for a place or tap it on the map.

Step 3: In the bottom right, tap directions. (You can even add the destinations)

Step 4: To add destination you have to go to the top right and tap more and then add a stop.

Step 5: Choose one of the following:

 Driving
 Transit
 Walking
 Ride Services
 Cycling

Step 6: If other routes are available, they will be shown in gray on the map. To follow an
alternate route, tap the gray line.
Step 7: To start navigation, tap Start.

Step 8: To stop or cancel navigation, go to the bottom left and tap Close

You can even access the hear voice directions. So that when you navigate to a place, you can
hear voice directions.

How to change the volume?

While using Google maps you can change the volume level. Here are the steps you need to
follow:

Step 1: Open the 'Google Maps' app.

Step 2: Tap 'Menu' and then 'Settings'.

Step 3: Tap on 'Navigation settings' and then 'Voice level'.

Step 4: Choose 'Louder, Normal, or Softer'.

Understanding & Using Google Calendar:

Getting started with Google Calendar:

Google Calendar is a powerful, free service you can use to organize your schedule and
coordinate events with others. It has many useful features, including the ability to share calendars
with others and easily switch what is currently being displayed. You can access your calendar
from any computer or mobile device as long as you are signed in to your Google account.

How to get to Google Calendar:

You'll need to be signed in to your Google account to access Google Calendar. If you don't
already have one, you can read more about creating a Google account here.
You can get to Google Calendar by visiting calendar.google.com. If you're already on another
Google page, click the menu button at the top-right, then click the Calendar icon.
There's also a Google Calendar app available for most mobile devices. The Google Calendar app
is installed by default on most Android devices, and you can download it from the Play Store.
There's also an iOS version in the App Store.

Navigating Google Calendar:

Google Calendar offers a lot of viewing flexibility. The button at the top-right will change the
scope of the current view, showing a single day or week, an entire month, and other view modes.
At the top-left of the window, the arrow buttons will change the view to different dates in the
past or future. You can also click the mini calendar to the left of the main calendar to view a
specific date. The Today button will return the calendar view to the current day.
Events:

Each item on the calendar is an event. To create an event, click a blank space on the calendar. A
small box will appear for you to enter basic information on the event. Click the Save button to
finish, or click the More Options button to enter more details. The only information you need to
enter is the title of the event and the time, but more information can be useful for anyone looking
at the event.

In the event form, you can add notifications to remind you of the event before it starts. These
reminders can be notifications in your browser, or they can be automated emails. This can help
you stay on schedule or give you time to plan travel.
You can modify existing events or view their details by clicking the event on the calendar.

Creating new calendars:

You can create separate calendars to help you organize events or share with specific people.
Click the plus sign next to other calendars, then click Create new calendar. This will open a form
that's similar to the form for creating new events, with its own permission and sharing settings.
After creating a new calendar, new events can be assigned to it, and old events can be moved to
it.
Sharing and customizing calendars:

One of the most powerful features of Google Calendar is the ability to customize and share them.
Move your mouse over a calendar name on the left, then click the three dots icon beside it to
open a menu for this calendar. You can change the color of events in this calendar in your view,
or you can hide it from the current view.
You can share the entire calendar with others by clicking Settings and sharing. This will give
you options similar to invitations for events, but it affects the entire calendar you are sharing.
Shared calendars can be useful for coordinating many related events with a group of people.

Using YouTube, Channel Creation, Adding description, Downloading &

uploading content:
What is YouTube?

YouTube is a free video sharing website that makes it easy to watch online videos. You can even
create and upload your own videos to share with others. Originally created in 2005, YouTube is
now one of the most popular sites on the Web, with visitors watching around 6 billion hours of
video every month.

If you've ever watched a video online, there's a good chance it was a YouTube video. For
example, almost all of the video tutorials on our website are actually YouTube videos!

What to use YouTube?

One reason YouTube is so popular is the sheer number of videos you can find. On average, 100
hours of video are uploaded to YouTube every minute, so there's always something new to
watch! And you'll find all kinds of videos on YouTube—adorable cats, quirky cooking demos,
funny science lessons, quick fashion tips, and a whole lot more.

Check out a few of the YouTube videos below. They should give you a good idea of the wide
range of content available on YouTube.
Signing in to YouTube:

While it's not necessarily required, we do recommend signing in to YouTube. Signing in allows
you to like and comment on the videos you find, share videos more easily, and even upload and
edit your own videos.

You'll need a Google account to sign in to YouTube. If you don't have a Google account, just
follow these instructions from our Google Account tutorial to learn how to create one.

Navigating YouTube:

Once you have a Google account, you're ready to sign in and start watching videos. Simply go to
www.youtube.com, click Sign In in the upper-right corner, and enter your Google account
information.

The YouTube homepage:

Once you've signed in, the YouTube homepage will appear, and you'll see trending and popular
videos, videos recommend for you, and more. If you see a video you want to watch, just click it
to start playing.
The Guide:

No matter where you are on YouTube, you can use the Guide on the left to quickly navigate the
site.

Simply click the menu button in the upper-left corner of any YouTube page to open the Guide at
any time.

From here, you can navigate to your playlists, channels, view history, and more.

How to Create a YouTube Channel:

Creating a well-managed YouTube channel with consistent content can help businesses grow
better, but doing it right is just as important. Here's how to do it step-by-step.
 1. Sign in to your Google account.

To watch, share, create, and comment on YouTube content, you'll need a Google account. Go to
youtube.com and click "Sign In" in the upper right-hand corner. From there, you'll be taken to a
Google sign-in page.

1. If you have a Google account, you'll be prompted to sign in.

2. If you have multiple Google accounts, be sure to select the one you want to be associated with
the YouTube channel.

3. If you do not have a Google account, click "Create Account" and follow the prompts to register
for one.

2. Create a new YouTube channel using your Google account.

Once you're set up with and signed into your Google account, it's time to create a channel. Click
your user icon in the upper right-hand corner. This represents both your Google account and you
YouTube account (as YouTube is owned by Google). You'll see a drop-down menu, where you'll
want to click "Settings."

From there, you'll be taken to your account overview. Click "Create a new channel" under "Your
channel."
The first step is to create a Brand Account. It can be whatever name you want, and doesn't have
to be the same name that you used to create your Google account -- but we do recommend that it
reflects the brand the YouTube Channel will represent.

After you enter the Brand Account name, you might be asked to verify the account via text
message or voice call. If that happens, enter the code you receive from the option you choose.

Once you've verified your Brand Account, you'll be taken to the dashboard for your channel.
Now, it's time to start customizing it.

3. Navigate to the Customize Channel page.

We'll start with the fundamental details about your channel. From your channel dashboard, click
"Customize channel."
From there, you'll be taken to the channel customization page.

You'll notice three tabs: "Layout," "Branding," and "Basic info." These three tabs will help you
optimize your channel for viewers.

4. Add Basic Info to your channel for discoverability.

Start by clicking "Basic info."

Here's where you'll enter some basic information about your channel, like the language your
videos are in, as well as a description that helps people discover your channel when they enter
search terms that describe what videos they're looking for. These keywords can include what
your channel is about, the problems it helps solve, the people and products featured, your
industry, and more.

You'll also be able to add links to sites you want to share with your viewers. These links will be
displayed over your banner image (more on this later) like so:

5. Upload branding elements to your channel.

In addition to the descriptive details that you've added, there's another element of customization
for a new YouTube channel: The visuals.
Under the "Branding" tab, you'll be able to add your:

Profile Picture

Among this channel art is your profile photo -- this is how YouTube users will identify the
creator of a video when browsing video content. You'll see this image appear beneath YouTube
videos on the play page, as shown below. YouTube recommends using a picture with dimensions
of at least 98 x 98 pixels.

Banner Image

The banner image is a large banner displayed at the top of your channel page, and it's a big
opportunity to convey your brand to your viewers. YouTube recommends using an image that's
at least 2048 x 1152 px.
Video Watermark

The video watermark is displayed at the bottom right of every video you post (see below). You'll
want to choose a logo that best represents you sized at 150 x 150 px.
Add videos and optimize them for search.

To upload your first video to YouTube, click the "Create" button in the top-right corner and
follow the prompts.

Optimizing your channel for discoverability is just the beginning. Once you start adding videos,
you'll want to optimize them for search, which in turn helps users discover your video.

But this goes beyond giving your videos accurate, clear, and concise titles -- though that is
important. Below, we describe some of the most important things to optimize on YouTube. (For
a fully comprehensive post on YouTube SEO, visit this post.)
Title:

When we search for videos, one of the first things that our eyes are drawn to is the title. That's
often what determines whether or not the viewer will click to watch your video, so the title
should not only be compelling but also clear and concise.

Description:

This should be limited to 1,000 characters -- and remember that your viewer came here to watch
a video, not to read a lot of text. Plus, YouTube only displays the first two or three lines of text,
which comes to about 100 characters, so front-load the description with the most important
information.

Tags:

Using tags doesn’t just let viewers know what your video is about -- they inform YouTube, too,
which uses tags "to understand the content and context of your video," according to Backlink.
 That way, YouTube can associate your video with similar videos, which can broaden your
content's reach. But approach with caution -- just as with your title, don't use misleading tags
because they might get you more views -- in fact, Google might penalize you for that.
Category:

Choosing a category is another way to group your video with similar content on YouTube -- but
that might not be as simple as it sounds. YouTube's Creator Academy suggests that marketers
"think about what is working well for each category" you're considering by answering questions
like:

 Who are the top creators within the category? What are they known for, and what do they do
well?

 Are there any patterns between the audiences of similar channels within a given category?

 Do the videos within a similar category have share qualities like production value, length, or
format?
 Ordering Online Food Delivery and How to Book Ola, Uber Online:

Learning Objective :- Do you need to solve a problem by building this ordering system.

How do you plan to reach more customers?

Introduction

The food industry is transforming with online food ordering apps.

The restaurant online ordering system help in notifying the right people at the right time. It is not
just about flexibility.

it’s about protecting the customer base by staying connected with them. There are some
explosive growth examples when it comes to online food ordering websites and apps.

Developing a platform for your business is important. It is more important to build it for the right
reasons.
You need to identify your objectives behind developing the restaurant online ordering system.

1. Swiggy - Swiggy attracts foodies from all across the country who want to place an
order.

2. Zomato - The best restaurants to dine in, making reservations, ordering takeout, and
discovering new foods. You may look up the menu, restaurant/dish pictures,
directions, a map view, contact, and other filters.

3. Travelkhana - If you’d like to order something delicious while you are on the
wheels, then download the TravelKhana App available on both iOS and Android.
4. Dominos - You may use its app to browse meal options such as pizza, bread &
sandwiches, desserts, and beverages.

5. Pizza Hut Delivery - Users of the app can quickly access the food menu and place
orders for their favorite dishes.

 How does online food ordering system work?

1. Your customer places a food order on your website or Facebook page.

2. The order is instantly pushed to your smartphone or tablet where you can review it
via the free order taking app we provide.

3. You decide the pickup time /delivery time and your answer is pushed right away,
which makes the entire process short and effective.

4. You start cooking and can come back to the order taking app anytime to see past or
any pending orders.
 Book Ola, Uber Cabs Online:

If your phone does not have this app, then it can be downloaded through the Play Store or
App Store for Android and IOS official website of Ola, Uber or Meru cabs.

below like Rentals / Micro / Mini / Prime / Taxi / Auto / Outstation categories .they take
to reach the pickup location. Choose one of these options. Click on 'Ride Now'

 OLA - Make sure that you have Ola app Installed in your phone as said earlier, to
follow the procedure, you should have already installed the Ola app on your
smartphone.

 Opening the Ola app without the internet connection will show up two options: try again
or book via SMS.

 After selecting the book via SMS option, it will redirect you to your default messaging
application to send an SMS to a particular number. Just send a message to that number
and wait for some time.

 Within no time, you will receive an SMS showing the details of all the cabs around you.
Select the one you need and reply it with the cab number.

 After selecting the cab you need, you will receive another SMS which contains all the
details of your cab. having said that, the driver will be given your details and location as
well.
 UBER –

Go to Playstore

• Write Uber in the search panel

• Find the Uber application
• Click on "Install" button
• Find the Uber icon in you phone
• Turn on your GPS so that it can detect your location
• Enter your pickup address if the location automatically tracked is not correct
• Enter your drop-off address.

 Uber provides different types of rides of which “Uber POOL” and “Uber
GO” are the most common ones.

 The simple rule is if you're traveling alone or with one friend, book a POOL.
In this facility, someone else will share a cab with you and the fare will be
low.
 Once you click on "Confirm Pickup" it'll start finding your ride. Wait for some
time and it'll show the name and picture of your driver along with the number of
the cab.