Main Tags

Categories

This Week's/Trending Posts

Hand-Picked/Curated Posts

Most Popular/Fun & Sports

Hand-Picked/Weekly News

The Most/Recent Articles

VEPPUR

SKILL INDIA HTML INTRODUCTION PART -1

 


HTML



HTML Introduction

HTML is the standard markup language for creating Web pages.

What is HTML?

  • HTML stands for Hyper Text Markup Language
  • HTML is the standard markup language for creating Web pages
  • HTML describes the structure of a Web page
  • HTML consists of a series of elements
  • HTML elements tell the browser how to display the content
  • HTML elements label pieces of content such as "this is a heading", "this is a paragraph", "this is a link", etc.




SKILL INDIA - EUUCATION AND AWARNES ( YOU TUBE CHANNEL ) TO FOLLOW AND SUBSCRIVE FOR LATES UPDATE

A Simple HTML Document

Example

<!DOCTYPE html>
<html>
<head>
<title>Page Title</title>
</head>
<body>

<h1>My First Heading</h1>
<p>My first paragraph.</p>

</body>
</html>

Example Explained

  • The <!DOCTYPE html> declaration defines that this document is an HTML5 document
  • The <html> element is the root element of an HTML page
  • The <head> element contains meta information about the HTML page
  • The <title> element specifies a title for the HTML page (which is shown in the browser's title bar or in the page's tab)
  • The <body> element defines the document's body, and is a container for all the visible contents, such as headings, paragraphs, images, hyperlinks, tables, lists, etc.
  • The <h1> element defines a large heading
  • The <p> element defines a paragraph

What is an HTML Element?

An HTML element is defined by a start tag, some content, and an end tag:

<tagname> Content goes here... </tagname>

The HTML element is everything from the start tag to the end tag:

<h1>My First Heading</h1>
<p>My first paragraph.</p>
Start tagElement contentEnd tag
<h1>My First Heading</h1>
<p>My first paragraph.</p>
<br>nonenone

Note: Some HTML elements have no content (like the <br> element). These elements are called empty elements. Empty elements do not have an end tag!

Web Browsers

The purpose of a web browser (Chrome, Edge, Firefox, Safari) is to read HTML documents and display them correctly.

A browser does not display the HTML tags, but uses them to determine how to display the document:

View in Browser

HTML Page Structure

Below is a visualization of an HTML page structure:

<html>
<head>
<title>Page title</title>
</head>
<body>
<h1>This is a heading</h1>
<p>This is a paragraph.</p>
<p>This is another paragraph.</p>
</body>
</html>

Note: The content inside the <body> section will be displayed in a browser. The content inside the <title> element will be shown in the browser's title bar or in the page's tab.

HTML History

Since the early days of the World Wide Web, there have been many versions of HTML:

YearVersion
1989Tim Berners-Lee invented www
1991Tim Berners-Lee invented HTML
1993Dave Raggett drafted HTML+
1995HTML Working Group defined HTML 2.0
1997W3C Recommendation: HTML 3.2
1999W3C Recommendation: HTML 4.01
2000W3C Recommendation: XHTML 1.0
2008WHATWG HTML5 First Public Draft
2012WHATWG HTML5 Living Standard
2014W3C Recommendation: HTML5
2016W3C Candidate Recommendation: HTML 5.1
2017W3C Recommendation: HTML5.1 2nd Edition
2017W3C Recommendation: HTML5.2

SKILL INDIA COMPUTER EDUCATON - ALL VIDEO PLAYLIST


SKILL INDIA - SAMLL STUDENTS BEAUTIFUL PAINTBRUSH DRAWING


SKILL INDIA ALL POWERPOINT VIDEOS PLAYLIST




Read More

Excel Basic Formula & Syntax

 


EXCEL BASIC FORMULA & SYNTAX WITH EXAMPLE




You got the result C2(281), right? Way to go!

Note: You can make formulas with all four arithmetic operations, such as addition (+), subtraction (-), multiplication (*) and division (/).

Here are some examples:

  • =2+4 gives you 6
  • =4-2 gives you 2
  • =2*4 gives you 8
  • =2/4 gives you 0.5

In the next chapter you will learn about Ranges and how data can be moved in the Sheet.

Test Yourself With Exercises

Excel Exercise:

Complete the Excel formula:

1+1

Start the Exercise


Read More
EXCEL ADV TIPS AND TRICKS

EXCEL ADVANCE AI TECHNOLOGY9

 


EXCEL IN ADVANCE TECHNOLOGY


ADVANCE EXCEL USING AI TECHNOLOGY



EXCEL SHORT VIDEO
SUM IF AND AVERAGE FUNCTION

https://youtube.com/shorts/lR6RB9dSudk?si=-DuKdbLc8VOpr7K-/0258



FOR MORE TIPS AND TRICKS 

JOIN OUR SKILL INIDIA VEPPUR WHATTSUP CHANNEL

AND FOLLOW OUR YOU TUBE CHANNEL





1

Read More
SKILL INDIA EXCEL TUTORIAL

Introduction to Microsoft Excel

 



MS excel


Introduction to Microsoft Excel

👶 For KG Students – Very Simple Explanation

https://upload.wikimedia.org/wikipedia/commons/thumb/e/e3/Microsoft_Office_Excel_%282019%E2%80%932025%29.svg/960px-Microsoft_Office_Excel_%282019%E2%80%932025%29.svg.png

https://wallstreetmojocms.recurpro.in/uploads/Gridlines_In_Excel_1_9adb572047.png

https://byu-pathway.brightspotcdn.com/ca/8e/dbec9d0d407e83cdd17c0e2b90bb/m01-07-fig07.png

4

🌟 What is Microsoft Excel?

Microsoft Excel is a smart notebook inside the computer 💻

It helps us:

  • ✏️ Write names

  • 🔢 Write numbers

  • ➕ Do addition

  • ➖ Do subtraction

  • 📊 Make charts

  • 📋 Make tables

Excel is like a magic maths book.

📖 Example 1 – Adding Numbers

Teacher asks:

10 + 20 = ?

In Excel we type:

=10+20

Excel shows:

30 ✅

Wow! Excel is very smart!

📖 Example 2 – Student Marks

Let us write:


Name

Marks

Ravi

50

Meena

80

Excel can tell:

Who got highest marks?
Who passed?
Total marks?

Very easy!

🧱 What Do We See in Excel?

Excel has:

  • 📦 Small boxes → Called Cells

  • ↔️ Letters on top → Called Columns (A, B, C…)

  • ↕️ Numbers on side → Called Rows (1, 2, 3…)

Example:

A1 means:
Column A + Row 1





Getting Started with Microsoft Excel (Beginner Level)

https://bettersolutions.com/excel/ribbon/file-backstage-startscreen-hometab.png

https://bettersolutions.com/excel/workbooks/workbooks-new.png

https://cdn.ablebits.com/_img-blog/ribbon/excel-ribbon.png

4

📘 1. What is Microsoft Excel?

Microsoft Excel is a spreadsheet software.

It is used to:

  • Store data

  • Do calculations

  • Create tables

  • Make charts

  • Manage accounts

👉 Excel is mostly used in schools, offices, shops, banks, and companies.

📘 2. How to Open Excel

🖥️ On Windows:

  1. Click Start

  2. Type Excel

  3. Click Microsoft Excel

OR

  1. Double click Excel icon on Desktop

📘 3. Creating a New Workbook

When Excel opens:

  1. Click Blank Workbook

  2. A new spreadsheet will open

📌 Workbook = Full Excel file
📌 Worksheet = Single page inside workbook

📘 4. Understanding the Excel Screen

Excel has different parts:

🔹 Ribbon

Top menu bar (Home, Insert, Page Layout)

🔹 Columns

Vertical lines (A, B, C, D…)

🔹 Rows

Horizontal lines (1, 2, 3…)

🔹 Cell

Small box where row & column meet

Example:

Cell A1 = Column A + Row 1

📘 5. Entering Data

Example 1: Typing Text

Click on A1
Type: Ravi
Press Enter

Example 2: Typing Number

Click on A2
Type: 100
Press Enter

📘 6. Basic Formula (Addition)

Click on A3
Type:

=10+20

Press Enter

Answer: 30

📘 7. Using Cell Reference Formula

If:

A1 = 10
A2 = 20

In A3 type:

=A1+A2

Press Enter

Answer: 30

📘 8. Saving the File

  1. Click File

  2. Click Save As

  3. Choose Location

  4. Type File Name: MyExcelFile

  5. Click Save

📘 9. Simple Practice Exercise

Create this table:

Name

Marks

Ravi

80

Meena

90

Now:

  1. Add total using formula

  2. Save the file

📘 10. Beginner Tips

✔ Always start formula with "="
✔ Save your file regularly
✔ Use simple formulas first
✔ Practice daily


bout Spreadsheet – For Beginners

https://softwareg.com.au/cdn/shop/articles/Gridlines-in-Excel.png?v=1707895938

https://support.microsoft.com/images/en-us/0cf61bba-56d2-4b1e-9a49-e69553797326

4

📘 What is a Spreadsheet?

A Spreadsheet is a table made of:

  • Rows ➡️ (1, 2, 3…)

  • Columns ⬇️ (A, B, C…)

  • Cells ⬜ (Small boxes)

It is used to:

  • Store information

  • Do calculations

  • Organize data

  • Create reports

👉 Microsoft Excel is a spreadsheet program.

🧱 Main Parts of a Spreadsheet

1️⃣ Rows

  • Horizontal lines

  • Numbered as 1, 2, 3, 4…

2️⃣ Columns

  • Vertical lines

  • Named as A, B, C, D…

3️⃣ Cell

  • Where row and column meet

  • Example: A1, B2, C5

📌 A1 means Column A + Row 1

📊 Example of a Spreadsheet

Name

Tamil

English

Maths

Ravi

80

75

90

Meena

85

88

92

In this spreadsheet:

  • Each box is a Cell

  • We can calculate total marks

  • We can find highest mark

🟢 Why Do We Use Spreadsheet?

We use spreadsheets in:

🏫 School – Marksheet
🏢 Office – Salary sheet
🛒 Shop – Bill making
🏦 Bank – Account management

🧮 What Can a Spreadsheet Do?

✔ Add numbers
✔ Subtract
✔ Multiply
✔ Divide
✔ Find average
✔ Count data
✔ Create charts

Example:

If A1 = 10
If A2 = 20

In A3 type:

= A1 + A2

Answer: 30

🎯 Beginner Practice

Open Excel and create this:

  1. In A1 type Name

  2. In B1 type Marks

  3. Enter 3 student names

  4. Add marks

  5. Use formula to find total

📌 Important Points

  • Spreadsheet is made of rows and columns

  • Cell is the basic unit

  • Always start formula with "="

  • Excel is the most popular spreadsheet software



About Ribbon in Microsoft Excel

👩‍🏫 Beginner Friendly Teaching Guide

https://cdn.ablebits.com/_img-blog/ribbon/excel-ribbon.png

https://wallstreetmojocms.recurpro.in/uploads/Excel_2016_Ribbons_Tabs_and_Quick_Access_Toolbar_a2f61461ed.jpg

https://cameron.econ.ucdavis.edu/excel/msribbon.gif

4

📘 What is Ribbon?

The Ribbon is the top menu area in Microsoft Excel.

It contains:

  • Buttons

  • Tools

  • Commands

👉 We use the Ribbon to do all work in Excel.

Think like this:

🧰 Ribbon = Toolbox of Excel

📍 Where is Ribbon Located?

The Ribbon is at the top of the Excel window, below the Title Bar.

It has many tabs.

🟢 Main Tabs in Ribbon (Beginner Level)

1️⃣ File Tab

Used to:

  • Save

  • Open

  • Print

  • Close file

2️⃣ Home Tab (Most Important)

Used to:

  • Bold text

  • Change font size

  • Change color

  • Align text

  • Add borders

  • Copy & Paste

👉 Beginners mostly use Home tab.

3️⃣ Insert Tab

Used to:

  • Insert charts

  • Insert tables

  • Insert pictures

  • Insert shapes

4️⃣ Page Layout Tab

Used to:

  • Change page size

  • Set margins

  • Print settings

5️⃣ Formulas Tab

Used to:

  • Insert functions

  • Use SUM

  • Use AVERAGE

  • Use IF

  • Use financial formulas

6️⃣ Data Tab

Used to:

  • Sort data

  • Filter data

  • Remove duplicates




Read More
Subscribe to: Posts ( Atom )