Re: SC Agency Accountability Reports - More (potentially resolvable) Issues

1 view
Skip to first unread message

Owen Ambur

unread,
Nov 28, 2022, 11:18:15 PM11/28/22
to gayaudeshani, aboutthe...@googlegroups.com
Gaya, I suppose it will take human intervention to properly name the goals and objectives but one potential method would be to select the first noun following the first verb in the goal/objective statement.  See, for example, those in this file:  https://stratml.us/carmel/iso/SCDOA2017wStyle.xml

If you can do that, it would make my job easier.  In any event, the sooner you can provide the first drafts, the sooner I can start the editing process and see how long it takes to: a) include the names of the agencies as well as the mission and vision statements, and b) edit the goal and objective names.

Of course, I'm also looking forward to seeing the partner and budget data included from the spreadsheets, but it might be best to check first to see if those other steps can be completed in a reasonable amount of time and without undue effort for a few of the files before we take on even more complexity.

I haven't don't an exact count but about a hundred files are listed at https://www.scstatehouse.gov/reports/aar2018/aar2018.php  However, they don't all have to be done at once.  Some of them are more important than others, e.g., those listed at https://stratml.us/drybridge/index.htm#SouthCarolina  

What I am most anxious to see is how the performance indicators shape up since they are the most cumbersome to capture manually.



On Monday, November 28, 2022 at 12:16:13 AM EST, gayaudeshani <gayaud...@gmail.com> wrote:


Identifying the noun is not an easy task, I can identify it as the word which comes after an article or starting with a capital letter. If you want me to automate it, we need to specify the method that works.

On Fri, Nov 18, 2022 at 8:57 PM Owen Ambur <owen....@verizon.net> wrote:
Gaya, if the number of exceptions is small (e.g., just the three you've noted), perhaps we should either: 

a) exclude them for now and decide what to do about them later, or 
b) capture any data from them that may fit the pattern and decide whether to manually capture the rest, using my XForm for StratML Part 2.

See my other responses to your questions below in [brackets].



On Friday, November 18, 2022 at 07:59:17 AM EST, gayaudeshani <gayaud...@gmail.com> wrote:


Inside the sample 1 folder there are some Excel files, where the sheet format is different.
 i.e normally 4th sheet contains Strategic Plan FY2022 Results, but in N200, P340, P300 it's not the 4th sheet, I believe we need to follow an unique format for this.

And some excel files contain 3.1. as the SequenceIndicator  and I remove the last '.' from those values.

On Fri, Nov 18, 2022 at 10:35 AM gayaudeshani <gayaud...@gmail.com> wrote:
I have hardcoded the organization mission, vision and values (this will automatically append to each output xml file), is that correct?

[If you mean that you have included those elements so that the output is valid XML and can be opened in my XForm for StratML Part 2, yes, that's what needs to be done.  Assuming that those elements are blank, I wil plan to manually populate them using the information contained in the PDFs of the agencies' reports... unless we can come up with a better way of doing so.]

Gaya, the name of each goal and objective is the subject (noun) to which it primarily refers.  
Since some contain more than one noun, judgment is often required to determine which one is primary, and in the case of objectives, which noun is best to use is influenced by the name of the goal under which is nested (to help users determine which ones may be of greatest interest to them before clicking a link to view them).
Also, when more than one objective under a goal references the same primary subject, it is necessary to append an adjective from the statement to the name of its subject, to distinquish them from each other.

I couldn't understand the above, please explain with samples, let's say the goal description is, 'Enhance the safety of the public, SCDPS officers, and other law enforcement officers' and the objective description is 'Protect the public through enforcement and education' , in this case, what should be the corresponding names?

[From the goal description, the primary noun is "Safety".  For the objective, it is "Enforcement & Education".  I will be impressed if you can automate the process of naming the goals and objectives and, if you are able to do so, would not expect perfection.  Indeed, there may be no such thing.  In some cases, which noun to choose is a matter of judgment and may be affected by the context, e.g., the name of the goal under which each objective falls.  The intent is to facilitate queries by example as well as to enable users to readily identify goals and objective of particular interest to them in a browse listing, e.g., the tables of contents automatically generated by the stylesheet.  See, for example, the TOC at https://aboutthem.info/ATI.xml  In some cases, it may be appropriate to use a noun that does not appear in the goal/objective description itself, if there is a better term to summarize the content in the context in which appears.]

And the repeated objectives are fixed in this new version.

[Sounds good.  Will look forward to seeing how it looks in my XForm for Part 2 and in the styled output.]

On Thu, Nov 10, 2022 at 10:02 PM Owen Ambur <owen....@verizon.net> wrote:
Gaya, the name of each goal and objective is the subject (noun) to which it primarily refers.  

Since some contain more than one noun, judgment is often required to determine which one is primary, and in the case of objectives, which noun is best to use is influenced by the name of the goal under which is nested (to help users determine which ones may be of greatest interest to them before clicking a link to view them).

Also, when more than one objective under a goal references the same primary subject, it is necessary to append an adjective from the statement to the name of its subject, to distinquish them from each other.

If you can address that much logical complexity in your application, I'll be very impressed.  However, one way or another, I hope we can jointly author an article discussing not only the problems with the SC agency accountability spreadsheets but also your capabilities for dealing with them.

If you are able to deal with these issues, the next and probably easiest one to address will be to import the agency partners into the StratML output as Stakeholders whose role is Partnership at the Organization level.  Importing the budget data as Performance Indicators of the Input type may be more difficult.



On Thursday, November 10, 2022 at 11:12:32 AM EST, gayaudeshani <gayaud...@gmail.com> wrote:


while that would take a fair amount of time, it may not take an inordinate amount of time to name the goals and objectives

what do you mean by naming here? we can automate this if you explain the logic and how you do that manually?

Google was able to tell me which agency is associated with the code K050.

We can hard code the agency names and other common values in a map, so based on the code in the excel file we can automatically retrieve the corresponding values.
 
Note also that each Objective should appear only once,

I can fix this part 

On Thu, Nov 10, 2022 at 8:59 AM Owen Ambur <owen....@verizon.net> wrote:
Gaya, since the most difficult and time-cosuming part of converting the data in the South Carolina agency accountability report spreadsheets to StratML format is capturing the goals, objectives, performance indicators, it occurred to me that you apparently have already accomplished that.  (I say "apparently" because I haven't checked your output against the data in the spreadsheets.)

So the thought occurred to me to manually capture the agency names as well as their vision, mission, and value statements, using my XForm for StratML Part 2.  While it would be nice to be able to automate that process as well, it may not be overly time-consuming to perform manually, as I have demonstrated at https://stratml.us/carmel/iso/part2/SCDPS-K050.xml  (Using Notepad, I manually copied and pasted the XML that you created for the goals, objectives, and performance indicators into the <Goal> section of the XML that I created with the XForm.)

Note, however, that since the goals, objectives, and performance indicators are unnamed, the stylesheet cannot automatically render the table of contents.  So unless the primary nouns in those statements can programatically be identified, it may be necessary to manually name them as well.  Again, while that would take a fair amount of time, it may not take an inordinate amount of time to name the goals and objectives (and not worry about naming the performance indicators since they don't appear in the table of contents).

Note also that each Objective should appear only once, with all of its performance indicators nested under a single instance of it.  Previously, you dealth with the same issue with respect to the Goals.  (Just because they are repeated in each row of the spreadsheet does not mean they should be repeated in StratML format.  To the contrary, it would be better if they each only appeared once in the spreadsheets as well.)  In this particular example only four goals would need to be named and 11 objectives.  Again, while that would take some time, it may not be an inordinate amount of time and we could start with the most important agencies first, like those for which I have already peformed conversions at https://stratml.us/drybridge/index.htm#SouthCarolina

BTW, while it isn't easy to match up the code names of the spreadsheets with the agency names to which they apply, at least not in the spreadsheets themselves or in a listing on the State of South Carolina's websites, Google was able to tell me which agency is associated with the code K050.  The agency codes are also listed at the top of the PDFs at https://www.scstatehouse.gov/reports/aar2018/aar2018.php  So they could be manually captured at the same time as the agency names and vision, mission, and values statements.

Unless those parts of the process can be automated, I'm inclined to start doing that and see how long it takes.  Compared to the amount of time I've spent converting the U.S. federal agency plans, I suspect this would take far less.

What do you think?

Reply all
Reply to author
Forward
0 new messages