# Quick Start for Non-Technical Users

**For:** Piyush Sahib, Government Highschool
**Date:** 2026-05-08
**Goal:** Use the UDISE+ automation tool easily

---

## Step 1: One-Time Setup (Done by Tech Person)

Have your IT person or tech-savvy colleague run these commands **once**:

```bash
# Navigate to your data folder
cd ~/UDISE_Data

# Activate the virtual environment
source venv/bin/activate

# Install all required packages
pip install selenium pandas openpyxl webdriver-manager
```

ℹ️ **What this does:** Downloads Python libraries needed for automation.

---

## Step 2: Running the Tool (You Do This Every Month)

### Option A: Using Terminal (Recommended)

1. Open **Terminal** (Ctrl+Alt+T)
2. Type this command:
   ```bash
   cd ~/UDISE_Data && source venv/bin/activate && python3 udise_student_manager.py
   ```
3. Press **Enter**

**What you'll see:**
```
============================================================
UDISE+ STUDENT DATA MANAGER
============================================================

1. लॉगिन करने के लिए credentials दर्ज करें:
Username [24110206411]:  ← type your username here
Password:  ← type password (won't show on screen)
School Code [24110206411]:  ← press Enter (already filled)

2. ब्राउज़र शुरू हो रहा है...
🔧 Setting up Chrome driver...
✓ Chrome driver ready
🔐 Logging in as...
✓ Successfully logged in!
📊 Navigating to student data...
✓ Found student section
⬇️  Downloading student data...
✓ Download initiated
📁 Creating master Excel file...
✓ Master Excel created: /home/piyush/UDISE_Data/UDISE_Student_Master.xlsx

============================================================
✓ PROCESS COMPLETE!
============================================================
```

4. **Browser window opens and logs in automatically** — you'll see it happening
5. **Wait until it finishes** (don't close browser until you see "PROCESS COMPLETE")
6. Close the browser window when done

---

### Option B: Desktop Shortcut (Easiest)

Create a desktop shortcut (ask IT to help):

1. Right-click on Desktop → **Create Launcher**
2. Name: `UDISE Downloader`
3. Command:
   ```bash
   gnome-terminal -- bash -c 'cd ~/UDISE_Data && source venv/bin/activate && python3 udise_student_manager.py; exec bash'
   ```
4. Icon: Choose any (maybe Chrome icon)
5. Click **OK**

**To use:** Double-click the `UDISE Downloader` icon on your desktop.

---

## Step 3: Process the Data

After download completes, run the cleaner:

```bash
cd ~/UDISE_Data
source venv/bin/activate
python3 udise_data_processor.py
```

You'll see:
```
============================================================
UDISE+ DATA PROCESSOR
============================================================
📂 Loading: /home/piyush/UDISE_Data/student_data_table_1_20260508.xlsx
✓ Loaded 542 records
🧹 Cleaning data...
✓ Cleaned. 542 records remaining

STUDENT DATA SUMMARY
============================================================
Total Students: 542
Male: 298
Female: 244
Class Distribution:
  1: 45
  2: 48
  3: 52
  ...
============================================================
✓ No major issues found!

💾 Saving to: /home/piyush/UDISE_Data/Student_Data_Cleaned_20260508_hhmmss.xlsx
✓ Excel file saved successfully
```

---

## Step 4: Open Your Excel File

The main file is:
```
/home/piyush/UDISE_Data/UDISE_Student_Master.xlsx
```

**To open:**

**Method 1:** Using Terminal
```bash
libreoffice --calc ~/UDISE_Data/UDISE_Student_Master.xlsx
```

**Method 2:** File Manager (easier)
1. Open **Files** (file manager)
2. Go to **Home** → **UDISE_Data** folder
3. Double-click `UDISE_Student_Master.xlsx`
4. It opens in **LibreOffice Calc** (or Excel if you have it)

---

## Step 5: What You'll See in Excel

The file has **4 sheets** (tabs at bottom):

### Tab 1: `Basic_Info`
All student personal details:
- Admission No
- Name
- Father's Name
- Mother's Name
- Date of Birth
- Gender
- Caste
- Mobile Number
- Address

### Tab 2: `Academic`
Class and school info:
- Class (कक्षा)
- Section (सेक्शन)
- Roll Number
- Medium (Hindi/English/Gujarati)
- Year

### Tab 3: `Attendance`
Monthly attendance:
- Month
- Working Days
- Days Present
- Days Absent
- Attendance %

### Tab 4: `Fees`
Fee payment status:
- Fee Type
- Amount
- Paid
- Due
- Last Payment Date

---

## Common Tasks in Excel (ਉਪਯೋਗੀ ਕਾਰਜ਼)

### 1. Add a New Student

1. Go to **Basic_Info** sheet
2. Scroll to **last row** (after all data)
3. Type in new student details:
   ```
   Admission_No: 2024055 (new number)
   Name: Aman Singh
   Father_Name: Rajesh Singh
   ...
   ```
4. Go to **Academic** sheet → add same Admission_No with class info
5. **Save** (Ctrl+S or File → Save)

### 2. Update a Student's Class

1. Open **Academic** sheet
2. Find student by Admission_No (Ctrl+F)
3. Change **Class** column to new class (e.g., from 9 to 10)
4. Update **Section** if needed
5. **Save**

### 3. Mark Fee as Paid

1. Open **Fees** sheet
2. Find student row
3. In **Paid** column, type amount paid (same as Amount)
4. **Due** will become 0 automatically (if formula exists) or type 0
5. **Save**

### 4. Fix a Phone Number

1. Open **Basic_Info** sheet
2. Find student row
3. Click phone number cell
4. Edit — make sure it's exactly 10 digits, no spaces
5. **Save**

### 5. Backup Your Master File (IMPORTANT!)

Every month after editing, make a backup:

```bash
# Terminal command
cp ~/UDISE_Data/UDISE_Student_Master.xlsx ~/UDISE_Data/Backup_$(date +%Y%m%d).xlsx
```

This creates: `Backup_20260508.xlsx` (today's date)

**Easy way:** Just copy-paste the file in File Manager:
1. Right-click `UDISE_Student_Master.xlsx`
2. **Copy**
3. Paste in same folder → rename to `Backup_20260508.xlsx`

---

## Step 6: Monthly Routine

**At start of every month:**

1. **Download fresh data from UDISE+** (Step 2 above)
2. **Process it** (Step 3 above)
3. **Compare with your master file**:
   - Are there new admissions? → Add them
   - Are there class promotions? → Update class column
   - Any corrections? → Fix in master file
4. **Backup old master file** (Step 5, #4 above)
5. **Save updated master file**

---

## Step 7: If Something Goes Wrong

### Problem: "Password incorrect"
**Fix:** Check caps lock. UDISE+ password is case-sensitive. Try logging manually to portal first.

### Problem: "Chrome driver not found"
**Fix:** Ask IT to run:
```bash
pip uninstall webdriver-manager -y && pip install webdriver-manager
```

### Problem: Browser opens but stays on same page
**Fix:** UDISE+ portal might have changed. Take screenshot and contact developer (Hermes Agent).

### Problem: Data file not created
**Fix:** Check if portal shows "No data available" — maybe school code wrong or login didn't succeed.

---

## Need Help?

**For script issues:** Check logs:
```bash
cat ~/UDISE_Data/cron.log  # if using scheduler
```

**For Excel issues:** 
- Select cell → press F2 to edit
- Undo mistake: Ctrl+Z
- Save often: Ctrl+S

**Contact:** Share error message + screenshot with your tech support person.

---

## Quick Command Cheatsheet

| काम | Command / Action |
|-----|------------------|
| Tool चलाएँ | `cd ~/UDISE_Data && source venv/bin/activate && python3 udise_student_manager.py` |
| Data process करें | `python3 udise_data_processor.py` |
| Excel खोलें | `libreoffice --calc UDISE_Student_Master.xlsx` |
| Backup बनाएँ | File copy करें → Backup_TodayDate.xlsx |
| Screen lock | Ctrl+Alt+L |

---

**That's it!** After a couple of runs you'll be comfortable. Start with test run first (just download, don't edit anything). Then next month try editing 1-2 records.

You can do this! 🙏

**Need a desktop shortcut or simpler way?** Ask to create a one-click launcher.