Oracle Application Express 20.1 Version Released

Oracle continues to support the ongoing improvement of Application Express (aka APEX). This application building tool is a low-code environment that makes building database-driven applications easier than writing all of the HTML and SQL code from scratch. Also, because it is embedded within the Oracle database, there is no need for add-on reporting tools. This low-code development tool saves hundreds of hours in development time and is very versatile.

For example, NC DPI uses APEX for the development of its EDDIE system.
(See http://apps.schools.nc.gov/ords/f?p=125:1)

This new version includes an enhanced search feature for its reports, responsive report widths in its interactive reports, and an expanded library of graphing and charting types.
To see more about its features go to this URL.  
https://apex.oracle.com/en/platform/features/whats-new/

Data Smart LLC uses APEX to build custom student reporting systems for school districts. Other applications created include a student performance recording for direct daily measurement (DDM), a team meeting recording system, and a curriculum development tool. Within the “family’ of applications, all data can be combined and accessed for reporting and analysis.

Do You Provide Files to Vendors?

If the school district does, then you will want to learn about ETL

What is ETL?

ETL stands for Extract, Transform and Load. It is the data process in which data is exported to an ETL program, changed in some way, and then pushed to a new location, such as a local or remote database table.

The process can be accomplished by a series of scripts that require expertise to write, attention to see if they are executing correctly. In my work at Data Smart LLC, I no longer write scripts to transform data for uploading to our Oracle database. Instead, I use an ETL program that automates the process.

While I have used a few ETL programs, however, I found an ETL program that I really like and recommend. The program is EasyMorph  https://easymorph.com/   You really need to check out their website and watch the video demonstration. Now here is the great news about this program.  There is a free version so you can get the feel of the program and I use it for most of my ETL work. The professional version is about $750 per year. 

Here is a typical process that I create (in about 30 minutes):

On a pre-defined schedule that I set up in the program, the process is run.

  1. Set up a scheduled export from a source like Power School so the file is saved on your computer.
  2. EasyMorph will Import the file(s) from my desktop or a database source. (EXTRACT)
  3. Then the program will change the column headings, data type if I need number instead of text, remove unwanted characters such as “N/A”, and change the file from a .txt or tab-delimited to a .csv separated file type and save it. (TRANSFORM) This transforming process is accomplished by selecting pre-programmed actions which are arranged in a timeline sequence.
  4. The program then moves on to the process step of uploading the data file to the destination. (LOAD) The destination can be back to your desktop for attaching to an email, a local database or a remote hosted database table.
  • The real power comes from the ability to execute SQL queries on the data table BEFORE uploading the data. So if you are replacing data daily to a remote server, you can either on the front end merge your previous data file and select only new data, or run a TRUNCATE statement to remove all data and start fresh or run an UPDATE statement to add data if the data is changed.
  1. Lastly, I get an email from the program telling me that the process ran and a log of errors if there were any errors.

This is by far the best solution to getting your data from point A to point B in a format that meets the vendor’s specifications. No this is what I call be data smart.

Dr. Lew Johnson
Oracle APEX Developer
Data Smart LLC

Considering a Data System?

Recently, I was asked what is the most cost-efficient way to provide multi-year data storage and be able to access it for creating reports. Four questions come to mind which need to be answered before providing a database recommendation.

Questions:

1: Will the data need to be accessed by users in various sites across the district, rather than one person at a central site?

2: How many users do you anticipate connecting to or viewing the data?

3: Do you want a unified system which would be a database AND a way to report the data? Or do you want separate database storage and a separate reporting tool?

4: what is your budget?

Answers:

Option 1 – Single user, no budget then MS ACCESS will do the job.

Option 2 – Multiple users, low budget: then a self-hosted database such as MS SQL, MySQL, or Oracle XE Express. There are free tools which can be used “read-only” to query the data and make basic reports

Option 3 – Multiple users, low budget (Less than $10,000 and no per-user fee), cloud-hosted and a query/reporting tool. My choice would be a host Oracle database with Application Express for query and reporting. Unlimited users can be added AT NO ADDITIONAL COST. Users can have various roles and permissions to view and manipulate data.

Option 4 – Multiple users, high budget (over $30,000 and per-user fees), cloud-hosted and a separate reporting tool, which has the per-user fee, I would recommend a hosted database and an add-on reporting tool. For example, a hosted database may cost $1,500 per year and then a user fee might be $10-$20 per user PER MONTH. So for 250 viewers (teachers) the cost at $10/month would be over $30,000 per year.

I recommend option 3, which is what Data Smart LLC provides to school districts. Data Smart LLC does all of the database management, data uploads, report tweaking, and analysis reports as part of its single fee.

Announcing APEX 19.1

Significant Software and Database Upgrade

Data Smart LLC has upgraded all of its client’s data systems to APEX 19.1.
The new system will use the Oracle database 18c xe.  

This is a giant step forward in the ability to customize pages within the data systems and also produce a much wider variety of charts.  You can learn more about APEX 19.1 at:

https://blogs.oracle.com/apex/announcing-oracle-apex-191

 

 

Building a Data Culture in Schools: Data Access is a Critical Component

Building a Data Culture in Schools: Data Access is a Critical Component

There have been hundreds of articles, blog postings and presentations on using data in schools. The information presented focuses on topics such as the inquiry cycle using data, data teams,  and leadership and teacher skills for understanding data. A critical aspect of this data use process is getting the data needed to make informed decisions. Issues surrounding data availability include
1 Access in a secure user-friendly format,
2. timeliness of receiving the data, such as growth data being available which is completed months after         testing is scored and the school year has started in the fall, and
3. access to interpretation protocols.

The first critical issue is having data in a user-friendly format. Many schools provide the printouts from the scoring software with the student scores. This report requires the teacher to look up previous scores and make a comparison to determine if a student did better than the previous year. After all of the testing is completed in the district, the testing office can build spreadsheets of student scores and provide this information to the administrator. However, to be useful, the data needs to be matched to each student’s previous scores to put some sort of context to the information.

Data systems range in size and price to full data warehouse systems. These systems cost over $100,000 and require someone to manage and maintain the system. Another option is a data system for collecting and reporting the data. These systems can be secured at a cost of about $3 to 8 dollar range per ADM. However, these data systems may not be custom created and may not offer the data analysis support a school district may need.

If you would like assistance in selecting or building your own data system, contact Data Smart LLC.
www.Data-smart.net