Differences

This shows you the differences between two versions of the page.

--- emis_user_manual [2023/11/10 19:52] – [Power Query] ghachey
+++ emis_user_manual [2024/08/16 14:09] (current) – [Rollover Workbook] ghachey
@@ Line 270: / Line 270: @@
   * Total Expenditure: $400,000
   * Current Expenditure: $0
+==== Dashboard Analysis ====
+Under ''Budget -> Dashboard'' a number of built-in budget analysis components are included. They are discussed briefly in following sub-sections.
+=== GNI (aka. GNP) and Government Spending ===
+This will provide some high level budget expenditure including the
+  * GNI (aka. GNP)
+  * Total education expenditure (Ed Expenditure)
+  * Total government expenditure (Govt Expenditure)
+  * Public Expenditure on Education as % of Total Government Expenditure (Ed/Govt %)
+  * Public Expenditure on Education as % of GNI (Ed/GNI %)
+{{ :user-manual:budget-dashboard-1.png?nolink |}}
+=== Spending By Sector (table format) ===
+This one breaks down the total expenditure (Actual vs Budgeted) by education sectors (which translates to education levels).
+{{ :user-manual:budget-dashboard-2.png?nolink |}}
+=== Spending By Sector (chart format) ===
+This chart also breaks down the total expenditure (Actual vs Budgeted) by education sectors (which translates to education levels).
+{{ :user-manual:budget-dashboard-3.png?nolink |}}
+However, with this chart you can interactively change the content to display other figures such as the per-pupil education expenditure as shown below.
+{{ :user-manual:budget-dashboard-4.png?nolink |}}
+{{ :user-manual:budget-dashboard-5.png?nolink |}}
+=== Spending By District ===
+Finally, the education expenditure can be display by districts. District could be will be a localized terms such as State, Province, Atolls, etc.
+{{ :user-manual:budget-dashboard-6.png?nolink |}}
 ===== Exams =====
@@ Line 777: / Line 819: @@
 ==== School Accreditation Dashboard ====
-This is where you can get some live data analytics just like every other module in the EMIS. You access just like other dashboard, Click on ''School Accreditation -> Dashboard''
+This is where you can get some live data analytics just like every other module in the EMIS. You access just like other dashboard, Click on ''School Accreditation -> Dashboard''.
+<note important>In order for the dashboard to contain data from the most recently approved and uploaded cloudfiles, the EMIS warehouse has to be regenerated.</note>
 {{ :user-manual:school-accreditation-dashboard-1.png |}}
@@ Line 1180: / Line 1224: @@
 ===== Data Operations =====
+==== Annual Census Data Transfer ====
+The Pacific EMIS supports a number of ways to transfer data from schools to a centralized database. They have varying degrees of maturity and complexity of user adoption. They are summarized in the below table.
+^ Method      ^ Description       ^ Maturity          ^ User Adoption Complexity ^
+| PDF Survey    | A comprehensive survey of data with the majority of it in aggregate format containing enough for the main key performance indicators     | Very mature       | Easy       |
+| Excel Workbook    | A comprehensive survey of data with support for individual rosters and richer data containing enough for the main key performance indicators and more. Built on widely used spreadsheet (Excel)     | Very mature       | Moderate       |
+| Student Information System (SIS)    | The highest form of data management within the schools then pushed to the centralized system. An online web-based student information system meant for daily use by schools.     | On-going development       | Difficult       |
 ==== Upload PDF Survey ====
@@ Line 1195: / Line 1250: @@
 {{ :user-manual:pdf-survey-upload.png?nolink |}}
-==== Upload Workbook Census ====
+==== Upload Excel Workbook ====
 <note important>This documentation below is strictly how to load a Annual School Census Workbook into the EMIS. Information on how to use the workbook itself is documented in [[annual_school_census_workbook_user_manual|Annual School Census Workbook User Manual]]</note>
@@ Line 1237: / Line 1292: @@
 ==== Rollover Workbook ====
-<note important>Currently there is no link in the menu to access the rollover workbook feature. It canonly be accessed through the browser by entering the URL by hand. So when logged in visit the link [[https://youremis.domain.name/#!/censusworkbook/create|https://youremis.domain.name/#!/censusworkbook/create]]</note>
+=== Initialize the new survey year ===
-<note important>Currently a new survey year needs to be produced manually before doing the rollover. This can be done by executing the stored procedure
+A new survey year needs to be produced manually before doing the rollover. There is no menu items at the moment but you can easily access the page directly from the browser as shown below and saving the new survey year. Usually it pre-populates the new census year data automatically.
-<code sql>
-exec pSurveyWriteX.CreateSurveyYear 2023, '2022-12-31','2022-11-30',6, 'your-user@email.com'
+{{ :user-manual:emis-user-guide-census-init-1.png?nolink |}}
-</code>
-</note>
+After the new census year has been initialized you can do the rollover page as shown below.
+{{ :user-manual:emis-user-guide-census-rollover-1.png?nolink |}}
 The workbook census rollover can work for all schools at the national level, at the district (e.g state, province, etc.) level or individual schools. It is the recommended way to get started on a new school year data as it contains cleaned up data and reduces chances of introducing duplicates or other messy data.
@@ Line 1254: / Line 1311: @@
   * Final verification that all the teacher/students for each schools are all as expected
   * Final verification of School and WASH data
-{{ :user-manual:workbook-rollover.png?nolink |}}
 ==== Upload Exams ====
@@ Line 1420: / Line 1475: @@
 Further notes on the Flexible Excel/Word Reports type of reporting. We have a combination of tools (e.g. [[data_publishers_toolkit|Data Publishing Toolkit]], [[multi-part_word_documents|Multi-part Word Document]]) and practices for publishing data into Excel tables and pivot tables. This forms the basis for the construction of documents such as Annual Statistics Digest, etc. These connection are direct connections to SQL Server using Excel’s OLEDB capacity. It is possible to establish SQL connections across the WAN, but this entails some careful security setup to allows users through a firewall to reach the SQL Server. In particular, a "read only" user. In order to support users who do not have access to SQL (i.e. either across their LAN, or across the WAN) to access data in Excel we are building support for new options. This would allow more options for remote hosting, and also for a broader set of users to have access to Excel.
-The three available planned options are available in various levels of maturity
+The three planned options are available in various levels of maturity and the table below shows the comparative strength and weaknesses of the 3 approaches:
 ^ Mode 	^ Connection 	^ Refreshable? 	^ Flexibility 	^ Distribution ^ Maturity ^
@@ Line 1441: / Line 1496: @@
 Power query extends Excel’s ability to access data from relational sources with the ability to extract, transform and load data from a wide variety of sources including http rest end points.
 ‌
-=== Dynamic Workbooks ===
+==== Dynamic Workbooks ====
 Currently this design is prototyped:
@@ Line 1467: / Line 1522: @@
 </code>‌
+====== Public Data Dissemination ======
+Aside from data about individuals, just about all other data benefits from being public for a number of reasons:
+  * **Transparency and Accountability**: Open data fosters transparency, holding organizations and governments accountable.
+  * **Innovation and Collaboration**: Public data fuels innovation, enabling collaboration among researchers, entrepreneurs, and developers.
+  * **Informed Decision-Making**: Accessible data empowers individuals and organizations for better decision-making.
+  * **Citizen Engagement**: Open data encourages citizen participation and engagement in public affairs.
+  * **Economic Growth**: Data availability stimulates economic growth, fostering entrepreneurship and creating jobs.
+  * **Research Advancement**: Open data accelerates research and scientific discoveries across various fields.
+  * **Public Services Improvement**: Governments utilize open data to enhance public services and address societal challenges.
+  * **Cross-Sector Collaboration**: Open data facilitates collaboration between sectors to address complex issues.
+  * **Community Empowerment**: Open data enables communities to address local challenges and actively participate in development.
+  * **Accountable Governance**: Open data supports accountable governance, allowing citizens to monitor government activities and foster trust.
+The Pacific EMIS supports a number of ways to disseminate data in a timely manner that KEMIS does not yet fully adopt. They are summarized in the table below:
+^ Method ^ Description ^ Time to Access ^ Access Difficulty ^
+| Publications | Often the most official and slowly curated sources of data. | Longest time. Requires more efforts in collecting, validating, preparing and publishing and can come sometime years after. | Easy. Typically through downloadable PDF documents. |
+| Mobile App | Download all data and view analysis on your phone. | Fast. New data immediately available. | Easy. Download the Pacific Open Education Data app on your Android or iPhone |
+| Public Login | The web application supports a public login to view all dashboards and download excel data exports. | Fast. New data immediately available. | Easy. Login the country EMIS public profile from login page. |
+| REST API | Access the raw data through special web requests in formats such as JSON and XML. | Fast. New data immediately available. | Difficult. Typically used by developers or researching with programming skills |
+A word of caution. The pacific island countries faces unique challenges making it hard to continuously improve the quality of data. Accessing the data any of the fast methods has the caveat that it has had less time for scrutiny and possible remediation. So it should always be used with care and we always appreciate any apparent issue brought to our attention so we can work to fix them.
+Each of these methods will have a sub-sections here with additional documentation.
 ===== References =====