इ. १ ली माहिती भरणे

इ. १ ली माहिती भरीत असतांना खालील प्रमाणे Excel Setting करणे.

You have downloaded excel sheet for student data entry of

School Code : your udise

School Name : XYZ

Standard  : 1st Standard

Number of Divisions : 2

This excel file can be opened in 'Microsoft Office (Excel)' version 2003,2007,2010 or 2013

After opening excel sheet in Microsoft Office 2003, following steps are follow

1) Navigate to 'Tools' tab > 'Macro' > 'Security'.

2) Click on 'Security' option. A Security window will open.

   It will show you all the security levels that you can select for your macros.

3) Select 'Low' Option - This setting allows all macros to run.

After opening excel sheet in Microsoft Office 2007

1) With an excel file opened click on the 'Office' button.

2) Click on 'Excel Options' (present at the bottom).

3) Select the 'Trust Center' > 'Trust Center Settings'.

4) Click on the 'Macro Settings'. Choose the security level for running macros.

5) Enable all macros (not recommended, potentially dangerous code can run)

OR

1) When you open an excel file in security warning pop-up for enable macro, click > Option

2) Select Enable Content and press OK

After opening excel sheet in Microsoft Office 2010 and 2013

1) Open a Microsoft Excel file, and navigate to 'File' > 'Options' > 'Trust Center'.

   Click 'Trust Center Settings'

2) Select the 'Macro Settings' option.

3) Choose the security setting that you want to be applicable on macro execution.

4) Enable all macros (not recommended, potentially dangerous code can run)

OR

1) When you opening an excel file their is one security warning pop-up for enabable macro,

   click > Enable Content

2) Then select Eanble Content and press OK

After opening the excel file you will get 'Visual Form' for student data entry.

Form will have button as 'Insert','Update' and 'Delete'

***** INSERT *****

1) Click on insert button to add students in the list.

2) To fill all rhe fields properly and click on SAVE, a record will be save in excel

   file.

***** UPDATE *****

1) Click on update button to update the information for students already inserted.

2) Select General Register Number and click on 'Get Data' button.

3) Edit the information / fields as required.

***** DELETE *****

1) Click on delete button to delete students record.

2) Select General Register Number and click on 'Get Data' button.

3) Students information entered will be displayed on the form.

4) Click on 'Delete' to delete record in excel file.

Select division number as,

Stream      Division No.      Division    Medium

Not Applicable          1           A           Marathi

Not Applicable          2           B           Marathi

Enter data for all students in the standard and then only upload the excel sheet.

***** DO NOT *****

1) Use any other excel sheet for data entry.

2) Use the sheet for another standard or another school.

3) Enter any invalid or garbage data.

4) Rename the file name.

Example:

General Register No.: 12344567

Stream: Not Applicable

Academic Year: 2016-2017

Standard: 1st Standard

Division: 1

Student's First Name: Aditya

Student's Middle Name: Pravin

Student's Last Name: Patil

Date of Birth: 11-08-2009

Gender: Male

Mother's First Name: Sima

Mother's Middle Name: Pravin

Mother's Last Name: Patil

UDISE Number: 27251111199

Meduim: Marathi

Semi English: No

Date of Admission: 16-06-2016

Standard of Admission: Senior KG (1 Year Before 1st Std)

Admission Type: Regular

UID Number: 123456789012