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     

 

Static RAM and Dynamic RAM

 Your computer probably uses both static RAM (SRAM) and dynamic RAM (DRAM) at the same time, but it uses them for different reasons because of the cost difference between the two types. Once you understand how dynamic and static RAM chips work inside your computer, it's easy to see why there's a cost difference between the two and how the two types of RAM got their names.

Dynamic RAM is the most common type of memory in use today. Inside a DRAM chip, each memory cell holds one bit of information and is made up of two parts: a transistor and a capacitor. These are, of course, extremely small transistors and capacitors so that millions of them can fit on a single memory chip

The capacitor holds the bit of information — a 0 or a 1 (see How Bits and Bytes Work for information on bits). The transistor acts as a switch that lets the control circuitry on the memory chip read the capacitor or change its state.

Byte Prefixes and Binary Math

When you start talking about lots of bytes, you get into prefixes like kilo, mega and giga, as in kilobyte, megabyte and gigabyte (also shortened to K, M and G, as in Kbytes, Mbytes and Gbytes or KB, MB and GB). The following table shows the binary multipliers:

Kilo (K)

2^10 = 1,024

Mega (M)

2^20 = 1,048,576

Giga (G)

2^30 = 1,073,741,824

Tera (T)

2^40 = 1,099,511,627,776

Peta (P)

2^50 = 1,125,899,906,842,624

Exa (E)

2^60 = 1,152,921,504,606,846,976

Zetta (Z)

2^70 = 1,180,591,620,717,411,303,424

Yotta (Y)

2^80 = 1,208,925,819,614,629,174,706,176