DATA SCIENCE V SEM NAAN MUDHALVAN PROJECT REFERENCE VIDEO LINK-26-27

Project Reference Video Link

https://youtu.be/J1KhQPSSh0s

https://youtu.be/3nsUWtzpDz4

https://youtu.be/zJ7xHkldHc0

https://youtu.be/NPaL96Ujy4g

https://youtu.be/VjQaecKbfUU

 

 

 

DATA MINING PROCESS

 

EXCEL-DATE - DATA VALIDATION

 Data Validation → Date in Excel is useful when you want to allow users to enter only valid dates within a specific range.

Example: Allow dates only from 1-Jan-2026 to 31-Dec-2026

Suppose you have this worksheet:

Employee	Joining Date
Rahul	15-Jan-2026
Priya	20-Mar-2026
Amit	10-Jul-2026

You want the Joining Date column to accept only dates in 2026.

Step 1 — Select the cells

Select the cells where dates will be entered, for example:

B2:B20

Step 2 — Open Data Validation

Go to:

Data → Data Validation → Data Validation

Microsoft's Excel guidance confirms that Data Validation can restrict a cell to dates and lets you choose a restriction such as "between."

Step 3 — Choose Date

In the Settings tab:

• Allow: Date
• Data: between
• Start date: 01/01/2026
• End date: 31/12/2026

The dialog should look approximately like this:

Step 4 — Add an error message

Click the Error Alert tab.

For example:

• Style: Stop
• Title: Invalid Date
• Error message: Please enter a date between 01-Jan-2026 and 31-Dec-2026.

Click OK.

Now, if someone enters:

• ✅ 15/05/2026 → accepted
• ✅ 31/12/2026 → accepted
• ❌ 15/05/2025 → rejected
• ❌ 15/01/2027 → rejected

Another useful example: Today to 7 days from today

You can make the validation dynamic.

Set:

Allow: Date
Data: between
Start date: =TODAY()
End date: =TODAY()+7

This means the cell accepts dates from today through the next 7 days. Microsoft also documents using formulas such as TODAY() in date-validation limits.

Important tip

Excel stores dates internally as sequential numbers, so a value that looks like a date should actually be recognized by Excel as a date. 

DATA MINING, DATA WAREHOUSING AND DATA VISUALIZATION -V -SEM DATA SCIENCE

 

Naan Mudhalvan - 26-27 -ODD V SEM-PROJECT-DATA SCIENCE

Step 1 – ServiceNow Administration Fundamentals (Mandatory) 

Step 2 – Welcome to ServiceNow (Zurich)

Step 3 – Welcome to ServiceNow Micro-Certification (Zurich)

Dear Faculty,

Greetings from SmartBridge!!

Please find the Faculty Orientation Session Recording link below.

🎥 Orientation Session Recording: https://youtube.com/live/wZ3Bd8LLv8U?feature=share

FACULTY ORIENTATION

If you were unable to attend the live orientation session or missed any part of the discussion, we request you to watch the recording. It provides a complete overview of the program, including:

1. Program execution flow and timelines

2. Faculty roles & responsibilities

3. SkillWallet platform orientation

4. Mandatory tasks and self-paced courses

5. Project milestones and deliverables

Kindly go through the recording at the earliest to ensure you are well prepared for the program execution.

If you have any queries, please post them in this group, and our team will be happy to assist you.

Thank you.

NETWORKS

 A network is a group of two or more connected devices, like computers or phones, that share information and tools.

How Networks Work

Connected parts: Devices link using wires, cables, or Wi-Fi.
Shared items: Users share files, printers, or internet access.
Communication: Devices "talk" to each other to send and get data.
Common Examples
Home Wi-Fi: Connects your phone, TV, and laptop together.
The Internet: A huge global network linking billions of computers

Advantages of Installing a School Network

• Shared use of data
• Shared use of resources
• Central control of programs and data
• Central storage and backup of data
• Shared pro­cess­ing power and storage capacity
• Easy man­age­ment of au­tho­riza­tions and re­spon­si­bil­i­ties

AI Dr .RGK

 1. FREE TAMIL BOOKS          2. FREE TAMIL PDF BOOKS