ार्गदर्शिकासरल इयत्ता 1 ली च्या विद्यार्थ्यांची माहिती भरण्यासाठी office setup व सूचना
This excel file can be opened in 'MicrosoftOffice (Excel)' version 2003,2007,2010 or 2013setup for
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 allowsall macros to run
.Setup for 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 OKSetup for 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 OKAfter 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 excelfile.***** 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,StreamDivision No.DivisionMediumNot
Applicable1AMarathiEnter 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: 1Student's First Name: AdityaStudent's Middle Name: PravinStudent's
Last Name: Patil
Date of Birth: 11-08-2009
Gender: Male
Mother's First Name: SimaMother's
Middle Name: PravinMother's
Last Name: Patil
UDISE Number: 27251111199
Meduim: MarathiSemi English:
NoDate of Admission: 16-06-2016
Standard of Admission: Senior KG (1 Year Before 1st Std)
Admission Type: Regular
UID Number: 123456789012
This excel file can be opened in 'MicrosoftOffice (Excel)' version 2003,2007,2010 or 2013setup for
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 allowsall macros to run
.Setup for 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 OKSetup for 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 OKAfter 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 excelfile.***** 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,StreamDivision No.DivisionMediumNot
Applicable1AMarathiEnter 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: 1Student's First Name: AdityaStudent's Middle Name: PravinStudent's
Last Name: Patil
Date of Birth: 11-08-2009
Gender: Male
Mother's First Name: SimaMother's
Middle Name: PravinMother's
Last Name: Patil
UDISE Number: 27251111199
Meduim: MarathiSemi English:
NoDate of Admission: 16-06-2016
Standard of Admission: Senior KG (1 Year Before 1st Std)
Admission Type: Regular
UID Number: 123456789012
No comments:
Post a Comment