1 / 41

Executive Summary

Data Collection System for Basic Statistics of Local Level Development Social Statistics Division Central Statistical Organization Ministry of Statistics and Program Implementation. Executive Summary.

zandra
Download Presentation

Executive Summary

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Collection System forBasic Statistics of Local Level DevelopmentSocial Statistics DivisionCentral Statistical OrganizationMinistry of Statistics and Program Implementation

  2. Page 2 Executive Summary BSLLD is an application created to automate the collection of Data from Villages of India and to get proper and better statistics of Villages. The Basic Statistics for Local Level Development (BSLLD) in India is comprehensive local development to the BSLLD beneficiaries. All the data about the development and its status; in a Village, is to be filled in by a Recording Officer assigned by Block officer of a particular Block under a Panchayat. The main components of the BSLLD are: • Descriptive Identification of Village • Particulars of Data Recording Officer • Village Schedule-A Forms • Village Schedule-B Forms • Reports

  3. Application Components • Login Page / Home Page: • Login page is the entry point of application to take user to home page. • Village Identification: • Identification of Village describes that which Village comes under which Panchayat and Block of which State. • Recording officer: • This provides information about a Recording Officer for a particular Village for a Year & Month. • Schedule-A Forms: • Filling all the relevant data of Village for Schedule-A Forms and then submitting the full data. • Schedule-B Forms: • Filling all the related data of a Village for Schedule-B which has dependency on Schedule-A forms. • Reports: • This is provided to generate report for all forms depending upon the data present for that form. Page 3

  4. In-class Activity • Installation of the Application • Application Navigation • Understanding Menu • Master Data Set • Create Master List of: • Tehsil • Block / Mandal • Panchayat • Village • Schedule Analysis • One set of Data Entry for Schedule A and Schedule B • Report Generation • Migration and Split Database Training Page 4

  5. Basic Statistics for Local Level Development Installation Windows XP or Above Installation of Microsoft Access 2003 or Above Registry Change Mscondes.dll Installation Distribution of BSLLD Code

  6. Login Page Page 6

  7. Login Credentials of BSLLD Software Login : bslld Password : bslld123!

  8. Home Page Page 8

  9. Identification Page 9

  10. Mapping Study • Discussion About the Village Mapping Data Set in the State • State • District • Tehsil or Talukas • Block or Mandals • Panchyat • Villages

  11. Data Recording Page 11

  12. Validations and Constraints in the Software Basic Statistics for Local Level Development Page 12

  13. Block – 2 Schedule -A • Item Code can accept only values “1” or “2”. • No special characters Allowed. • When only single value entered in the Source code it will display a message to select value from list. Page 13

  14. Block – 3 Schedule -A • Values for 3.1, 3.2, and 3.3 should not exceed 9. • Item Code can accept only values “1” or “2” for “3.4” and “3.5”. • Values of 3.7(a), 3.7(b), and 3.7(c) should not exceed 100%. • When only single value entered in the Source code it will display a message to select value from list. Page 14

  15. Block – 4 Schedule -A • Values for distance should be two digit and if found single digit should be converted into two digit by adding “0” before digit. • Distance should be in whole numbers. • If distance is greater than 100 then it should be converted to “99” and saved. • For 4.6 to 4.10 if distance code is “00” then enter the no. of Schools else not allow to enter. • When only single value entered in the Source code it will display a message to select value from list. Page 15

  16. Block – 5 Schedule -A • Values of 5.1 & 5.2 should be greater values in 5.3, 5.4 and 5.5 else data will not be saved. • Values of 5.3 should be greater than the values in 5.4 and 5.5. • When only single value entered in the Source code it will display a message to select value from list. Page 16

  17. Block – 6 Schedule -A • The combined values of 6.3 to 6.7 should be less than 10% of the values in 5.1 and 5.2 else data must be rechecked. • When only single value entered in the Source code it will display a message to select value from list. Page 17

  18. Block – 7 Schedule -A • All values entered in the text boxes should not exceed more than 9 and should be rechecked and if even then values are greater than 9 should be converted to 9 and saved and appropriate remarks should be added in respect of that in remarks column. • When only single value entered in the Source code it will display a message to select value from list. Page 18

  19. Block – 8 Schedule -A • When only single value entered in the Source code it will display a message to select value from list. Page 19

  20. Block – 9 Schedule -A • Values entered should be whole no. and if decimal no. entered then the digits after decimal should be strike off and entered as whole no. • When only single value entered in the Source code it will display a message to select value from list. Page 20

  21. Block – 10 Schedule -A • Values entered should be whole no. and if values in 10.1 to 10.9 exceed 1000, should be rechecked. • If values for 10.10 to 10.12 cross 9999 then should be rechecked. Page 21

  22. Block – 11 Schedule -A • If values entered crosses 9 then should be rechecked and submitted as 9 with necessary remarks. • When only single value entered in the Source code it will display a message to select value from list. Page 22

  23. Block – 12 Schedule -A • Values entered should be whole no. and should always be less than or equal to values in 5.1 and 5.2 for male and female separately. • When only single value entered in the Source code it will display a message to select value from list. Page 23

  24. Block – 22 Schedule -B Page 24

  25. Block – 22 Schedule -B • If Block 5 is not fill, below message will be shown. Refer Figure 26. • If the total of Female, Item 22.3 to 22.7 is cross 1% of the total of Female of 5.1, the figure should be verified, and below message will be shown. Refer Figure 27. • If the total of Male, Item 22.3 to 22.7 is cross 1% of the total of Male of 5.2, the figure should be verified, and below message will be shown. Page 25

  26. Block – 23 Schedule -B Page 26

  27. Block – 23 Schedule -B • If Block 5 is not fill, below message will be shown. • If the total of Male, Item 23.1 to 23.6 is cross 10% of the total of Male of 5.2, the figure should be verified, and below message will be shown. • If the total of Female, Item 23.1 to 23.6 is cross 10% of the total of Female of 5.1, the figure should be verified, and below message will be shown. • If the total of Male, Item 23.7 to 23.11 is cross 50% of the total of Male of 5.2 in the age group of 60 years, and below message will be shown. Page 27

  28. Block – 24 Schedule -B • This Block is totally dependent upon the data filled up in Block 5 • Total Will be calculated automatically • This Block cannot be filled in if Block 5 is not filled Page 28

  29. Block – 25 Schedule -B • If the total of Female, Item 25.1 to 25.6 is cross 10% of the total of Female of 5.1, the figure should be verified, and below message will be shown. • If the total of Male, Item 25.1 to 25.6 is cross 10% of the total of Male of 5.2, the figure should be verified, and below message will be shown. Page 29

  30. Block – 26 Schedule -B Page 30

  31. Reports Generation This section is been created to generate the report for the data entered for the Village of particular Year and Month. This section provides a Report format to the data entered so that one can easily clarify the data and in represent able format and one can easily take print out of that. This Section contains twenty buttons for displaying reports. As for every Block there is a different button to display different Form if we click Form 2 button then it will display Report for that particular Form. • Here are the images of different reports: • Schedule A(Reports) • Schedule B(Reports) • Schedule A(Query) • Schedule B(Query) • Aggregation A • Aggregation B Page 31

  32. Basic Stastatics for Local Level Development Merging Two or More Databases using BSLLD Merging Tool Page 32

  33. Basic Stastatics for Local Level Development Central Database This Central Database has to be sent to the MOSPI Database- A Database- B Page 33

  34. Migration Page 34

  35. Split Database Installation over LAN In MS-Access 2003 Page 35

  36. Page 36

  37. Split Database Installation over LAN In MS-Access 2007 Page 37

  38. Queries ??

  39. Thank You Madhav Mishra Software Consultant BSLLD Project Infogain India Pvt Ltd Ph: +91-9891225425 +91-120-2581811 +91-120-2445144 Etx-4673 Email : madhavmishra@infogain.com

  40. Ajaz Ahmed Ansari Software Consultant BSLLD Project Infogain India Pvt Ltd Ph: +91-9990296887 +91-120-2581811 +91-120-2445144 Etx-4673 Email : ajazahmed.ansari@infogain.com

More Related