CAF 2020 eTool by Salvatore Spampinato

CAF 2020 - eTool

Warning : the Caf etool is based upon a Microsoft SQL database, so it is mandatory to download and install first a Microsoft application called SQLLocalDb.msi . To do so, please, follow the Startup instructions, that you’ll find in the last pages of the present Tutorial.

The Caf etool is continously updated so be sure to have the last version, referring to https://www.caf-network.eu/Digital_Tools

CAF 2020 - eTool

WHY THIS ETOOL The main goal of an etool is to facilitate the management of one or more processes; it doesn’t intervene directly in the management, but only acts as a support. In the case of Caf 2020, we are dealing with a model that, however simple, actually implies a considerable commitment on the part of a small or large organisation, a commitment shared between several assessors. Below it is a list of features relating to this etool.

3) it implements the synchronization of data produced remotely by the assessors. The product of the assessors needs to be integrated, synchronization mechanisms are therefore necessary. The etool offers two tools that allow it to be implemented, allowing each individual assessor to produce a single compressed file, to be transmitted in the most appropriate ways, to a figure with administrator functions.

4) it produces automatic data summaries. 1) it allows different assessors to operate on the data for Considering the mass of data with which we are dealing with, which they are responsible, which can subsequently be init is imperative to have summaries available that allow us to tegrated, for the purpose of producing final summary do- have a picture as complete as possible of the situation, in orcuments. der to make the right choices. The etool allows to create, in a simple and fast way, many The model considers twenty-eight sub-criteria articulated in summaries of the data, in the form of documents with heteroexamples (around ten for each sub-criterion). Of each example geneous content, or in the form of numerical tables or graphs. different aspects must be considered, differentiated between These documents can be further processed and finally printed "enablers" and "results", consisting of both textual content and /or saved in the most appropriate supports. and numerical values. All this having in mind that among the various entities there are logical connections to be taken into 5) it compares the values between different numerical taaccount. bles and assign the most appropriate score. It is therefore a framework that, however complex, must be The attribution of the final scores comes from the consensus designed precisely, on a support that is reliable and easy to meeting. manage by users. The etool has a single environment in which to recall for each single dimension of analysis (plan-do-check-act / trend2) it provides an engine for automatic data management. targets-comparisons-coverage) and for each sub criterion, the The etool adopts the Microsoft SQL relational database. tables of all the data entered by all the assessors, supported by their statistical and graphical data. CAF 2020 - eTool

CAF 2020 - eTool

It is also possible, at the same time, to recall the situation concerning the evidences, the strengths, weaknesses, ideas for improvement, of each subcriterion, so as to have all the elements possible to attribute the final scores. 6) it facilitates the reading of numerical data. Numerical data is indispensable as they represent the measurements of the parameters that describe an organisation. The etool produces, in addition to the numerical tables, also their graphic representation through histograms, aerograms, radar diagrams, which facilitate the understanding of the results. 7) the pyramidal structure of data Data passes through different elaborations, which follow the logical path adopted in practice. The user is thus guided in their insertion and takes advantage of all the facilities offered by the automation. For the Enablers this is applied in the path that from the relative raw data leads to a first synthesis and therefore to the extrapolation of the strengths, weaknesses, areas for improvement, ideas for improvement and the final (automatic) document of the Self Assessment Report. For the prioritization phase, this is applied in the path that leads from the ideas for improvement to their collation by themes, to the first formulation of the improvement actions, to their subdivision into key improvement actions and quick wins. They in turn will form the basis for the subsequent and final phase of prioritization.

8) it considers the international nature of the Caf model. Caf is an international model, born in Europe but also adopted outside of it. The Caf 2020 is available in 19 languages. The development environment with which the etool was created allows the complete localization in the various languages, both of the examples and of the user interface, in order to make the model completely usable, without linguistic obstacles and this may constitute an additional factor of its diffusion. At now it is fully localised in English and Italian and partially localised in 17 languages.

CAF 2020 - eTool

CAF 2020 - eTool RETURN LINKS TO:

< MAIN FORM

PRIORITISATION FORM

ETOOL RELATIONS

ELABORATION PATH OF KEY IMPROVEMENT ACTIONS

INDEX

1 2 3 4 5 6 7 8 9

YOUTUBE VIDEOS Enablers Results Self Assessment Report Enablers/Results score Ideas collation Key actions Consensus Eipa prioritisation Synchronisation (2:39)

(8:12)

(3:27)

(5:32)

(6:42)

(1:54)

(2:42)

(4:35)

(2:49)

Caf Clipboard

(3:27)

It is recommended to follow the numerical order to visualize the videos . * The videos were made some time ago, so the images slightly differ from the current interface, but the underlying concepts are basically the same. CAF 2020 - eTool

CAF 2020 - eTool

CONVENTIONS Numeric values are initialized to 0 (zero).  Text values are initialized to "--" (double dash, without quotes).  The following conventions have been adopted in the management of the indicators: - for sub-criteria 6.1 - 7.1 - 8.1 the values are initialized to the string "RESULT" (without quotes); - for sub-criteria 6.2 - 7.2 - 8.2 - 9.1 - 9.2 the values are initialized to the string “INDICATOR" (without quotes); 

If you change a text value initialized to "--" with a different one and then want to delete it, do not insert blank spaces but reinsert the string "--". In the management of indicators, when you insert a new string value, thus changing the default ones, and subsequently you want to delete it, reinsert the initialization ones "RESULT" or "INDICATOR" (without quotes). When you change any value, you are actually changing a database field. The above conventions actually behave like filters, instructing the software to take into account (or not) a certain value. This avoids processing unnecessary database fields.

CAF 2020 - eTool

PART 1 - THE SELF ASSESSMENT PHASE

PART 3 – INSTALLATION INSTRUCTIONS °INSTALLATION INSTRUCTIONS

°WHY THIS ETOOL °MAINFORM °CAF ADJUSTMENT °ENABLERS MANAGEMENT °ANNUALITIES INSERTION °INDICATORS MANAGEMENT °RESULTS MANAGEMENT °CHRONOLOGY °SYNTHESIS MANAGEMENT °STRENGHTS-WEAKNESSES-IDEAS FOR IMPROV. °ENABLERS SCORE INPUT °RESULTS SCORE INPUT °CONSENSUS MEETING MANAGEMENT °CHARTS MANAGEMENT °INTERACTIVE CHARTS °CONTRIBUTIONS MERGING °SELF ASSESSMENT REPORT °BACKUP

PART 4 – APPENDICES APPENDIX A °THE SYNCHRONIZATION PROCEDURE APPENDIX B °A CAF-etool PROJECT APPENDIX C °WORKFLOW UTILITIES

PART 2 - THE PRIORITISATION PHASE °COPY GRIDS °IDEAS COLLATION °ACTIONS FORMULATION °QUICK WINS/KEY IMPROVEMENT ACTIONS °PRIORITISATION EIPA approach °PRIORITISATION AUSTRIAN approach °PRIORITISATION FINNISH approach °PRIORITISATION ITALIAN approach °PRIORITISATION PORTUGUESE approach °PRIORITISATION SLOVAK approach

°CAF JOURNEY °CAF CLIPBOARD °BENCHLEARNING °BALANCED SCORE CARD °PCM °ETOOL RELATIONS °ELABORATION PATH KEY IMPROV. ACTIONS .. °CRITICAL SUCCESS FACTORS °ANNOTATIONS °DICTATION HIERARCHICAL GRAPH TOOL: INPUTGLEE CONCLUSIONS HOW TO OPERATE

CAF 2020 - eTool

CAF ADJUSTMENT

< < INDEX

“The core of CAF2020 is a questionnaire with 200 examples of self-assessment of public organisations.” (https://www.eipa.eu/portfolio/european-caf-resource-centre/) The word “examples” tell us theyr true nature: they represent only suggestions. An interesting pubblication “Implementing CAF in public administration: Best practices in Europe ‐ obstacles and challenges” by Melpomeni A. Vakalopoulou, George D Tsiotras, Katerina Gotzamani is downloadable at https://www.researchgate.net/ publication/263491110_Implementing_CAF_in_public_administration_Best_practices_in_Europe_-_obstacles_and_challenges/ link/56fa59ed08ae81582bf4c49a/download Within it several ideas are underlined about the Caf adjustment: “… modifying CAF and adjusting it into the uniqueness of every organization can be obtained only through careful study and analysis of its implementation.” “… organizations not only implemented CAF, but they tried to differentiate and adjust it to their individual structure and status.” “The study of this case proves the need for CAF adjustments to the specialised conditions of every organization. Also, the example of the Finnish Public Management Department shows that CAF is a tool that can evolve and adjust itself to the new challenges and special features of every public administration. “ In the recent “Transforming Public Administration with Caf” by Thomas Prorok, Philp Parzer, they claim at page 36: “With the adjustment of the CAF questionnaire the examples of CAF can be concretised and customised to the specific culture and ‘language’ of the organisation” This eTool takes care of this important aspect of the Caf model and allows to personalize the examples and also to add others, in order to fulfill the above ideas. Look next pages for the Enablers’ and Results’ examples adjustment .

CAF 2020 - eTool

To select an assessor, click an option button.

INDEX

The colors of the buttons follow a logic subdivision. ——————————————————————————-———TEXTUAL DATA MANAGEMENT The first row of buttons calls the forms for (from left to right): -Insert raw data for Enablers -Insert raw data for Results -To do a synthesis for every sub criterion, based upon the previous raw data -To establish, referring to the previous synthesis, the WEAKNESSES, STRENGHTS, AREAS FOR IMPROVEMENT, IDEAS FOR IMPROVEMENT for every sub criterion. I have called the inherent button REGISTER. ——————————————————————————-———NUMERICAL DATA MANAGEMENT The second row deals with commands to manage the SCORES, the CONSENSUS meeting and the score representation through charts . ——————————————————————————-———The third row deals with UTILITY operations such as (from left to right): -Export all the data of every assessor (from assessor 1 to assessor 10) to synchronize (this is done by the Administrator) all the contributions (scores, weaknesses, areas for improvement, ideas for improvement) -To do a backup or to restore the archives and to subdivide the work among the assessors of the raw data inserted with the ENABLERS and RESULTS commands -To do the synchronization of all the contributions (scores, weaknesses, areas for improvement, ideas for improvement) . -To print the SELF ASSESSMENT REPORT inside the inner word processor in a structured manner that, of course, can be further on elaborated, inside or outside it. ——————————————————————————-———-The fourth row shows the credits, call the form for the PRIORITISATION phase, call the form to manage the steps of the Caf journey and exit from the application. ——————————————————–——— Call the Caf clipboard - Call the tutorial

CAF 2020 - eTool

CAF 2020 - eTool ENABLERS MANAGEMENT

< < INDEX For every sub criterion (1.1 in the picture) and for every example (n.1 in the picture) there are four textual boxes to fill.

The command opens a new form for the synthesis management. The Font command allows you to establish the Font type and size of the textual boxes The image shows the filled textual boxes (in blue) and the empty ones (in gray) inherent the examples. CAF 2020 - eTool

CAF 2020 - eTool

Adjustment of the Caf questionnaire: customize the examples. The examples can be customised , tailoring them to own organisation. It is up to the Admin to take this into account for the synchronization (see the part about synchronization in this tutorial). Click the checkbox and change the text, then uncheck it. Once checked you can also restore the original content, clicking the Restore button. Clicking an option-button you can enlarge the adjacent textbox. To shrink it again you have to click the upper option-button.

CAF 2020 - eTool

Adjustment of the Caf questionnaire: add new examples. To add a new example click the green button “+”, a new yellow textbox is shown, write the text and then click the INSERT NEW EXAMPLE button. To delete a new example (it’s not possible to delete the original ones) select the same with the navigation bar and then click the red button “-” . Adding new examples makes the Caf etool more flexible but more attention is required in the synchronization phase. The insertion of new examples should be done by the administrator, before the first evaluation phase. He/she will hand over the modified database to the assessors, on which they can work.

CAF 2020 - eTool

< INDEX

YEARS

If, for example, you select 2018 (in the list) as the first year, you have the situation in the picture. That is three years for which you can insert data in the Results forms. Then click Exit. This operation is done only once,

Before you insert any data in the Results forms it needs to select the years with the command

at the beginning of the work. This is a fontpicker, to choose the font family and the size of the font to use in the forms.

CAF 2020 - eTool

CAF 2020 - eTool INDICATORS MANAGEMENT

To insert data for the Results, it first needs to have a series of measurable parameters, the performance and perception indicators , relative to the organisation. The Caf model gives not binding indications about them, so the organisation is free to find and structure such parameters for its needs. Next phase is to insert them in the Caf etool database, which has room for up to 15 indicators for every example . Once inserted, they can only be affined during time, so it is recommended a deep study about their composition and structuring. The Admin inserts the indicators in his/her database so they have to be synchronized with the S.A.G. components. The Backup form presents, for this purpose, two commands named BKP-IND and RST-IND, respectively for the backup and the restore of only data inherent the indicators. With the command BKP-IND it is created the backup in any chosen folder inside the system and also the relative compressed file, that can be easily transmitted to S.A.G. components. They, after its decompression in their own system, will launch the restoring operation. The below picture shows the work scheme. The operation can be repeated when it needs.

CAF 2020 - eTool

CAF 2020 - eTool INDICATORS MANAGEMENT

< < INDEX 1) select an example with the Examples list (the first is visible in the picture) , they are shown FIFTEEN indicators (this is a fixed number). 2) update an indicator : click on it and change the text. This slider allows to enlarge/ shrink the height of the textboxes.

The default text “RESULT” (for 6.1-7.1-8.1) or “INDICATOR” (for 6.2-7.2-8.2-9.1-9.2) have to be changed for the new indicators. If the text is not changed they are not considered, that is, it is a kind of filter. Once you have edited the indicators that you want, you can click on the EXIT button. Regarding the perception results (6.1 - 7.1 - 8.1), what you insert in the concerning fields are the same elements that you consider in the questionnaires, surveys, focus groups, appraisals, interviews, consultation with staff representatives, user panels, reports, public press meetings, NGOs, CSOs and/or others instruments that the organisation usually adopts. CAF 2020 - eTool

CAF 2020 - eTool

< < INDEX

RESULTS MANAGEMENT

1) 2)

A useful chart shows the numerical values in a more readable way. The reference years are established only once, within the previous form YEARS, at the beginning of the work. You can also manage the indicators directly inside theyr textbox’s description. The management table of the previous page, will be accordingly updated, in a two-way mode. CAF 2020 - eTool

Select an example from the list Select an indicator (previously established) with the navigation bar (they are available up to fifteen indicators for every example - the established indicators are indicated in green color) Fill the two textual boxes and insert the values (inherent the selected indicator) for three years.

CAF 2020 - eTool RESULTS MANAGEMENT

PANELS 1) selection of the example

2) indicators navigation

3) insertion of values, perception results/ indicators results and summary 4) values chart

The previous image is re-proposed for clarity, given the importance of the topic. Although it seems complex, it actually reflects the ordinary indicators management procedure. CAF 2020 - eTool

CAF 2020 - eTool

Adjustment of the Caf questionnaire: customize the examples. The examples can be customised , tailoring them to own organisation. It is up to the Admin to take this into account for the synchronization (see the part about synchronization in this tutorial). Click the Edit example button, two textboxes are shown. The upper one presents the selected example that you can change, the lower one contains the original example , that you can restore with a copy/ paste operation. Click again the Edit example button and the two textboxes are hidden.

CAF 2020 - eTool

Adjustment of the Caf questionnaire: add new examples. To add a new example click the green button “+”, a new yellow textbox is shown, write the text and the click the INSERT NEW EXAMPLE button. To delete a new example (it’s not possible to delete the original ones) select the same from the list and then click the red button “-” . Adding new examples makes the Caf etool more flexible but more attention is required in the synchronization phase. The insertion of new examples should be done by the administrator, before the first evaluation phase. He/she will hand over the modified database to the assessors, on which they can work. No check is made on the insertion of duplicates.

CAF 2020 - eTool

< < INDEX

RESULTS’ CHRONOLOGY

A chart is invaluable to show the changing over time of the considered parameter. They are all test values, of course. You can print all the tables in the inner wordprocessor. CAF 2020 - eTool

CRONOLOGY OF THE RESULTS When you complete a three-years period in a RESULTS table, with the SHIFT command you can perform a shifting of data to eliminate the first year and to insert a new one. This way, however, valuable information would be lost. It has been introduced the possibility of inserting such a year into a specific table which will then reflect the CRONOLOGY of the results (for that indicator). In the left picture there is the table of examples in subcriterion 6.1. The ID_REL column represents the code in the example. Let's consider the first example, with code ID_REL = 1. Clicking on that first line they will be shown, in the second table, all the INDICATORS related to this sub-criterion (in a fixed number of fifteen). By clicking on each orange button of them , the third table shows the chronology for such a parameter and the concerned chart.

CAF 2020 - eTool SYNTHESIS MANAGEMENT

< < INDEX

For every sub criterion, in the left side are called the list of examples and the data inserted with the previous forms. This is a reader, that allows to clearly look the data and with searching text features. In this Edit environment they can be inserted others external objects (pictures, tables, charts, and so on) and to do copy/paste from left to right. For ENABLERS they are shown the EVIDENCES,for the RESULTS it is shown the SUMMARY. CAF 2020 - eTool

CAF 2020 - eTool STRENGHTS- WEAKNESSES,-AREAS FOR IMPROVEMENT- IDEAS FOR IMPROVEMENT MANAGEMENT

These are toggle buttons, when one of them is active, the others are not, so you have to deactivate it to click another.

READ ONLY

< < < INDEX For every subcriterion it is called (in the right side) the document created with the previous form, that is, the situation for the selected one . It is a read-only document and referring to its content they can be filled the four textual fields concerning STRENGHTS, WEAKNESSES, AREAS FOR IMPROVEMENT, IDEAS FOR IMPROVEMENT , selected with the homonymous buttons. It is also shown the score, previously inserted with the

PRIORITISATION PHASE The command IDEAS COLLATION opens the inherent form - look at --> >

To facilitate the future subdivision in QUICK WINS and ACTIONS, it is recommended, for every proposed action, to insert on the left also the number of the sub criterion to which it belongs. The following is an example: 1.1 – action 1 - Lorem ipsum dolor sit amet, ... 1.1 – action 2 - Lorem ipsum dolor sit amet, ... 1.1 – action 3 - Lorem ipsum dolor sit amet, .... CAF 2020 - eTool

inherent forms. This command print the stenghts, weaknesses, areas and ideas for improvement, in the inner wordprocessor, where they can be further elaborated.

CAF 2020 - eTool ENABLERS' SCORE ASSIGNMENT

< < INDEX The form for the score assignment for Enablers. The labels are colored based on their value according to the upper range scale. This command switch from the remarks scoring and the list of examples. You can insert the REMARKS to scoring for every subcriterion. All the remarks can be printed in the inner wordprocessor. This command shows/ hides the labels of the examples, so you can do copy/paste inside the textboxes.

CAF 2020 - eTool

< INDEX With the MAP command it is drawn the complete map, which concerns all the Enablers sub-criteria and their examples subdivided for score range . These are the labels shown with the command, that you insert inside the inherent textboxes (look the previous page). With the COPY_GRIDS form it is possible to collect also this type of data for every assessor. The scores instead, are inserted with the SYNCHRONIZATION command.

These are toggle buttons, when one of them is active, the others are not, so you have to deactivate it to click another.

CAF 2020 - eTool

< INDEX The VALUES command shows the map of all the values of all the sub-criteria, concerning one assessor (the one selected with the START form). The conditional formatting allows, by means of the colors, to see the complete situation.

CAF 2020 - eTool

< INDEX The EVIDENCES command shows the same ( previously established inside the

ENABLERS

forms) for the selected subcriterion, so to easily identify the right range score

CAF 2020 - eTool

< INDEX

The upper buttons show another values map, concerning the score inserted by all the assessors. The goal is, of course, to have ever the complete situation clearly shown. The red number on the left shows the clicked button and the concerning criterion.

CAF 2020 - eTool

< INDEX Clicking upon a subcriterion button and clicking upon this button, they are shown/ hidden the Weaknesses, Strengths, Ideas for improvement, Areas for improvement for the same subcriterion, so to have all the elements to assign the score. The Results’ score assignment has the same feature, not shown for shortness.

CAF 2020 - eTool

INSERT THE VALUES IN EXCEL

1. click the PRINT command 2. SELECT the content (click inside the text and press Ctrl + A) 3. COPY the content in the clipboard (Ctrl + C) open EXCEL, click a cell and paste (Ctrl + V) The same for the RESULTS and the CONSENSUS values. CAF 2020 - eTool

< INDEX

CAF 2020 - eTool

ASSIGN SCORE LOOKING AT THE SYNTHESIS

You can call the Synthesis and simultaneously work with both, so to assign the right score and to position the sub-criteria’s number inside the small textboxes.

CAF 2020 - eTool

CAF 2020 - eTool RESULTS' SCORE ASSIGNMENT

< < INDEX The form for the score assignment for Results. The labels are colored based on their value according to the upper range scale. The MAP command shows the map of all the values, as that of Enablers score (not shown for shortness). The upper buttons show the values inserted by all the assessors score (not shown for shortness). This command switch from the remarks scoring and the list of examples. You can insert the REMARKS to scoring for every subcriterion. All the remarks can be printed in the inner wordprocessor.

CAF 2020 - eTool

CAF 2020 - eTool CONSENSUS MANAGEMENT

< < INDEX For every analysis dimension (PLAN/DO/CHECK/ ACT/TREND/TARGETS/ COMPARISON/ COVERAGE) it is shown the chart with the score assigned by every assessor . The consensus score is assigned from the lists and its value is automatically placed in one of the two tables, relating to the chosen option.

These simple statistics help the attribution of the consensus score. The data distribution is also shown in a box plot chart. Data refers to test values. If you hover the cursor upon the boxplot chart, you can see its values (min, max, Q1 < first quartile >, Q3 < third quartile >, MEAN(continue line), MEDIAN(dashed line)). All the statistics can be also printed with the command in the inner wordprocessor, where they can be further elaborated. The chart for the new score can be created with the buttons like this. CAF 2020 - eTool

CAF 2020 - eTool

< INDEX It is implemented a conditional formatting that colors the cells based on Subcriterion 4.1

their values.

Subcriterion 4.2

Subcriterion 4.3

Subcriterion 4.4

Subcriterion 4.5

Subcriterion 4.6

Clicking the buttons at the top it is shown the complete table of the numeric values of the relative chosen criterion. To read this table: - e.g. caf 4 1 is the criterion 4 and the assessor 1 , caf 4 3 is the criterion 4 and the assessor 3 and so on - every row represents a phase e.g. the row with ID =5 is the PLAN phase, the row with ID =6 is the DO phase, ID =7 is the CHECK phase, ID =8 is the ACT phase for sub criterion 4.2, and so on (the yellow row is the PLAN/TREND phase). Clicking again on a button the table is hidden and it is possible to click the others buttons. For Results the sequence is TREND – TARGET – COMPARISON – COVERAGE CAF 2020 - eTool

CAF 2020 - eTool

< INDEX

With the REGISTER command it is possible to show/hide (for the chosen sub criterion) the weaknesses, strengths, areas for improvement, ideas for improvement established in the Register form.

CAF 2020 - eTool

CAF 2020 - eTool CHARTS MANAGEMENT

< < INDEX All the numeric values are represented by several kind of charts that can be also printed (Bars-PieRadar– Stacked bars). With the HTML command it is created an html file, that can be published in a website. Look at “Interactive charts” further on. With the EXPORT command all the charts are exported in the folder you choice. The visualized chart can be copied in the clipboard (COPY command) or saved (SAVE command) in your system.

You can insert all the exported images in a PowerPoint presentation with a few steps. 1. Launch PowerPoint , but do not open the presentation in which you want to add the images. 2. Click "Insert" at the top of the window. 3. Click "Photo Album" at the top to start a new photo album. 4. Click "File/Disk" and use the file browser to select all the images you want to insert as slides. You can hold "Ctrl" while clicking to select multiple images or press "Ctrl-A" to select all of them. 5. Click "Insert" and then "Create" to create a new photo album in a second PowerPoint window. CAF 2020 - eTool

CAF 2020 - eTool BAR CHART

RADAR –subcriteria

PIE CHART

RADAR criteria

CAF 2020 - eTool

< INDEX

CAF 2020 - eTool PERCENTAGE BARS

GAUGE CHARTS

CAF 2020 - eTool

INTERACTIVE BAR CHARTS

< INDEX

The command HTML in the CHARTS’ form creates an HTML file that, if is open with a browser, shows all the produced charts in an interactive manner, that is, hovering the cursor on its elements it is shown the numeric value (they are Google charts). It is very useful because it can be also published in our own website, to show to the world our Caf situation. The picture is a partial one, all the charts for all the sub-criteria are shown in the same window. There is also a global stacked bars’ chart (see next page)

CAF 2020 - eTool

CAF 2020 - eTool INTERACTIVE STACKED BAR CHART

< INDEX YOU CAN VISUALIZE THESE CHARTS AT

https://sites.google.com/ view/caf-etool-2020-chartsdemo/home

“Gauge” charts.

CAF 2020 - eTool

< INDEX Clicking a button it is shown a bar chart of the numeric values, for Enablers and Results, so to do a visual comparison of them. In the picture they have been clicked the 3.1 and 7.1 buttons.

It is possible to investigate the relations among the enablers and the results looking the sub-criteria’s score (previously established with the inherent forms) with suitable tables and charts, choosing the values source from Consensus meeting or current Assessor . When the score is (automatically) inserted, the labels are coloured accordingly to the upper-left range score, so to show a map. The numbers refer to test values, hence they are not coherent . CAF 2020 - eTool

CAF 2020 - eTool MERGING OF CONTRIBUTIONS

Every assessor Exports his/ her own data with this command from the main form and transmits it to the Admin.

< INDEX

The Admin will put all the contributions received by the Assessors in a folder as preferred. Then he/she launches the command “MERGE” to integrate it in his/her own database. Data are added (in numeric order of assessor) in their own fields of the database, so there will be a certain redundancy. The Assessor ‘s number is added after the contribution to which it belongs. The Admin will remove this redundancy , making a further rationalization of data. The software shows the existing assessments in the folder (from assessor 1 to assessor 5 in the example) with concerning numbers in green color.

CAF 2020 - eTool

CAF 2020 - eTool PRINT SELF ASSESSMENT REPORT SELF ASSESSMENT REPORT

< < INDEX

With this command the Self Assessment Report is automatically created inside an Edit environment, where it can be further on elaborated and then printed. The content is automatically created taking it from the database and from the rtf files created in the Synthesis form, so, every elaboration that you do inside it, is not automatically saved when you exit from this form. You can save it with the save command in the ribbon, or you can do copy/paste in another word processor.

CAF 2020 - eTool

< 1) select the reader option 2) click the command 3) select the scrolling mode it is shown the new bar so it is possible to insert several types of annotations. This S.A.R. is not the final version, but only the base on which to work, so the annotations are useful. With this command (a toggle button) it is shown/hidden the list of (textual) annotations.

CAF 2020 - eTool

CAF 2020 - eTool BACKUP MANAGEMENT

When you create a Backup in the folder you < INDEX prefer, it is created a new folder named "XML", a compressed one named "XML_CAF.zip" and a .bak file that is the backup of the inner SQL database. When you Restore your work, you have to search and select the folder containing the XML folder. If you have a folder synchronized with a cloud service like Dropbox or Google Drive, you can select it with the “Cloud” button and the .Zip chronology will be automatically inserted also in such cloud services.

T:\mydir

The backup and restore of data are very important functions in every software and the right backup policy is a basic rule. As a further security initiative, during the exit phase, it is maked an automatic backup inside an hidden folder, that can be restored in the case of difficulties. It is recommended to ever make also an external backup. During the same phase it is also created a compressed backup file, named with its timestamp. In this way you’ll have the chronology (that you can call with this command) of all the backup files, that you can accordingly manage (copy, delete, rename, move). This command exports the chronology. CAF 2020 - eTool

These command have been introduced to facilitate the initial indicators management in that they allow the backup and restore of data inherent the same ( look also at the indicators management form).

CAF 2020 - eTool

READ YOUR DATABASE WITH EXCEL Your BACKUP is positioned in a folder called “XML”, inside which there are many .xml files. The .xml format is a universal one, so it can be read with many tools including Microsoft Excel. Go to Open and choose a file in your XML folder, choose XML Table from the options that appear and click OK in the next message that follows. It is shown a table with the values (textual and numerical). This is an example (a small part)

So you can easily read your database and manage a copy of it for your purposes. The following is a chart done with Excel with the previous values

You can also read a .xml file with:  a browser  a text editor  an XML viewer/editor but it’ll be shown in .xml format and not a table one as with Excel.

CAF 2020 - eTool

CAF 2020 - eTool COPY GRIDS

DISTRIBUTION OF WORK

< INDEX

With “MERGE” command it is possible to integrate some type of data, like strengths, weaknesses, areas for improvement, ideas for improvement and scores (for enablers and results), but for the raw data inserted with the first two forms (ENABLERS and RESULTS) this is not possible or rather, it doesn’t make sense. With this functionality it is possible to leverage the subdivision of the work among the assessors and then to integrate it. In the left there are listed all 28 sub-criteria with aside a choosing list with a range 1-10. These numbers are the order number of each assessor. In the picture the assessor n. 2 compiles the form concerning sub-criteria 1.1-1.2-1.3 -7.1-7.2 and assessor n. 1 compiles the forms 3.1-3.2-3.3-5.1-5.2-5.3 and so on. The subdivision of the work among the assessors is a strength of Caf model and this etool takes care of this aspect .

Click on and a form appears, where the Admin has to search the folder where he/she has previously put the (decompressed) folders exported by the Assessors. The etool takes the assessors’ data and copy the concerned fields content in the analogous fields of the Admin’s database (overwriting them - there will be shown a warning message). Please look at section SYNCHRONISATION further on. CAF 2020 - eTool

CAF 2020 - eTool

INDEX

PART 2 PRIORITISATION PHASE -

CAF 2020 - eTool

< < < INDEX

   

QUICK WINS management BENCHLEARNING management BALANCED SCORECARD management PROJECT CYCLE MANAGEMENT

The EIPA button and the buttons with flags refer to the localised approaches (EIPA - Italian— Portuguese—Finnish—Austrian—Slovak) to the prioritisation phase, as those presented in the “CAF Improvement identification, prioritisation and implementation . A study of inspiring practices installed in 20 Public Sector organisations throughout Europe and the methodologies for prioritisation. “ by Patrick Staes, Nick Thijs, Dorina Claessens in 2016.

> CAF 2020 - eTool

CAF 2020 - eTool

IDEAS COLLATION / ACTIONS FORMULATION

CAF 2020 - eTool

CAF 2020 - eTool IDEAS COLLATION FOR THEME

< < < INDEX

Clicking the upper buttons they are shown the IDEAS FOR IMPROVEMENT for every subcriterion. Clicking these buttons it is possible to collate the ideas under common themes (up to twenty). The command FORMULATE ACTIONS shows the inherent form. You can PRINT the ideas for each theme. CAF 2020 - eTool

CAF 2020 - eTool

< < < INDEX

Clicking the THEMES button it is shown/hidden the list of common themes to manage the same.

CAF 2020 - eTool

The four buttons allow to format the text inside the new textbox. This is useful because in this way you can organize the text before to move it inside the THEMES textbox. Text is moved without formatting.

CAF 2020 - eTool

To facilitate the < INDEX procedure, with the MIRROR command the ideas for improvement are duplicated. Clicking the S/H(show/ hide) command a new textbox is shown signaled with a red label on the left. Clicking the upper buttons the ideas for improvement are shown in this new textbox. To collate an idea: 1) click an upper button (a subcriterion) 2) click a Theme (1 up to 20) 3) select an idea from the left textbox 4) press the F5 functional button of the keyboard and it will be MOVED in the right theme space 5) in this way you can operate with the remaining data and at the end of the work all the content of the textboxes will be empty, meaning this that all the ideas have been collated.

CAF 2020 - eTool

< < < INDEX

ACTIONS FORMULATION

TO THE QUICK WINS FORM

In the left they are automatically loaded the AREAS FOR IMPROVEMENT (from the REGISTER form) and the ORGANISATION’s STRATEGIC OBJECTIVES(previously elaborated in the CRITICAL SUCCESS FACTORS form, that you can call with this command). Clicking an upper button they are shown the IDEAS previously collated for theme and the theme’s description . Based on these data, they can be formulated the IMPROVEMENT ACTIONS (on the right) that will be automatically available in the QUICK WINS management form. CAF 2020 - eTool

CAF 2020 - eTool

QUICK WINS / KEY IMPROVEMENT ACTIONS

CAF 2020 - eTool

CAF 2020 - eTool QUICK WINS / KEY IMPROVEMENT ACTIONS MANAGEMENT KEY IMPROVEMENT ACTIONS

FROM THE ACTIONS FORMULATION FORM

TO THE PRIORITISATION FORM

<< < < < INDEX In this textbox you’ll have the action list automatically taken from the ACTIONS FORMULATION form. The first operation to do is to copy this list in the middle textbox, with this command. You do this operation only once, but in the case of a mistake or a new self assessment phase you can repeat this operation. You can print the three contents inside the inner word processor.

Now you can cut and paste , from the middle textbox to the left textbox the actions that are considered QUICK WINS. At the end you’ll have all the QUICK WINS in the left textbox and all the KEY IMPROVEMENT ACTIONS in the middle text box. The list of these actions will be automatically available in the following PRIORITISATION (for EIPA , Finnish, Portuguese, Italian, Austrian, Slovak approach) form. As a further facilitation, when you select some text in the middle textbox, press the F5 functional button of the keyboard and the text will be moved in the left textbox and is appended at the end of the existing text. If you do a mistake you can leverage the UNDO/REDO (Ctrl + Z / Ctrl + Y) features of the two textboxes: click inside the textbox in which you want UNDO or REDO and press (Ctrl + Z / Ctrl + Y) how many times you want, there are not limits. CAF 2020 - eTool

CAF 2020 - eTool

<< << INDEX

PRIORITISATION - EIPA’s approach

CAF 2020 - eTool

CAF 2020 - eTool ACTIONS LIST CONSTRUCTION

<< < < << INDEX The PRIORITISATION command shows the homonymous form. The ACTION SHEET

FROM THE QUICK WINS FORM

command shows the homonymous form, that implements the “Scheme B” of the Caf brochure.

These KEY IMPROVEMENT ACTIONS are automatically inserted from the QUICK WINS elaboration previously done, but until now it is only pure text. You can now construct the KEY IMPROVEMENT ACTIONS LIST in the right., that is an indexed one as you can see from the first column ID.

CAF 2020 - eTool

< < < << INDEX

ACTION SHEET

The actions can be completed with the information as those considered in the “Scheme B” of the Caf brochure. A synthesis can be printed inside the inner word processor, for further elaborations. You can also have a GANTT chart with the time data, but only for the first 25 actions. See to the next page. The ACTION SHEET is available also for Austrian, EIPA, Finnish, Italian , Portuguese and Slovak prioritisation phase.

CAF 2020 - eTool

CAF 2020 - eTool INITIATIVES GANTT CHART

<< << INDEX The initiatives are shown here by clicking on the left buttons.

CAF 2020 - eTool

CAF 2020 - eTool PRIORITISATION - EIPA APPROACH

<< << INDEX

The KEY IMPROVEMENT ACTIONS LIST, previously established, is shown in the right table. CAF 2020 - eTool

CAF 2020 - eTool

<< << INDEX

COMPLETE MODE

This is the EIPA approach to the prioritisation phase (COMPLETE MODE), as that presented in the “CAF Improvement identification, prioritisation and implementation . A study of inspiring practices installed in 20 Public Sector organisations throughout Europe and the methodologies for prioritisation. “ by Patrick Staes, Nick Thijs, Dorina Claessens in 2016. It is possible to manage up to 50 default actions. For every proposed action they can be chosen the subcriterion to which it belongs, the SW value (articulated in IMCC, IMST, IMIR, IMSR) , the EIM value (articulated in LD, RN, SR), the PIM value and the chosen action. In this area it is shown a summary of all the data inserted. Clicking upon the small green labels they are shown the definitions of every voice. The etool makes available the Caf score.

CAF 2020 - eTool

<< << INDEX

CONCENTRATED MODE

This is the EIPA approach to the prioritisation phase (CONCENTRATED MODE) . It is very simplified compared with the complete mode. The values for the strategic weight SW and the ease of implementation EIM are in the range 1-10. Several tables are accordingly presented in the edit environment of the etool and created with the PRINT commands. They can be saved or exported in other professional word processor for further elaborations. The following are some screenshots of these tables.

CAF 2020 - eTool

<< << INDEX STRATEGIC WEIGHT OUTPUT

EASE OF IMPLEMENTATION OUTPUT

Created in the complete mode

CAF 2020 - eTool

CAF 2020 - eTool GLOBAL OUTPUT

Created in the complete mode (with test values). CAF 2020 - eTool

<< << INDEX

CAF 2020 - eTool CONCENTRATED MODE OUTPUT

Created in the concentrated mode. CAF 2020 - eTool

<< << INDEX

CAF 2020 - eTool

<< << INDEX

PRIORITISATION - AUSTRIAN approach

CAF 2020 - eTool

CAF 2020 - eTool ACTIONS LIST CONSTRUCTION

<< << INDEX The PRIORITISATION command shows the homonymous form.

FROM THE QUICK WINS FORM

The ACTION SHEET command shows the homonymous form, that implements the “Scheme B” of the Caf brochure.

These KEY IMPROVEMENT ACTIONS are automatically inserted from the QUICK WINS elaboration previously done. You can now construct the KEY IMPROVEMENT ACTIONS LIST in the right.

CAF 2020 - eTool

<< << INDEX

PRIORITISATION

Insert the Priority value in the INPUT column ( 0 up 8) , it will be inserted also in the PRIORITY column and its background colored accordingly the lateral scale. Once the work is complete click

the

SCORE

header and the table is ordered in ascendant or descendent order. Look at the next picture.

CAF 2020 - eTool

<< << INDEX EXPORT THE TABLE 1-Select a row clicking in the left. 2-Click in the upper left corner to select the whole datagrid. 3-Press Ctrl + C and it is copied in the clipboard. 4-Open your word processor and paste ( Ctrl + V ) the content. Select the table and set the borders as visible and do all the elaborations that you want. The PRIORITISATION is very fast, because the most of the work has been previously done in the QUICK WINS form. Here is done only a sieving operation.

CAF 2020 - eTool

<< << INDEX

PRIORITISATION - FINNISH approach

CAF 2020 - eTool

CAF 2020 - eTool PRIORITISATION—FINNISH APPROACH

The ACTION SHEET command allows to manage the same as explained before.

CAF 2020 - eTool

<< << INDEX On the right there is the action list. It is shown the new action list . In the middle there is a grid with nine categories to which belong the actions. To categorize an action: 1) Select an action with the navigation buttons 2)Click in one of the nine buttons in the low/left side (the categories). It is updated the grid and incremented (or decremented) the number of actions inside a category. 3). To know the actions in a category, click upon the relative black circular button and they will be shown in this list

CAF 2020 - eTool

<< << INDEX

FROM THE QUICK WINS FORM

The ACTION LIST command shows/hides the actions list from the QUICK WINS form (the KEY IMPROVEMENT ACTIONS ), so you can fill the KEY IMPROVEMENT ACTIONS LIST.

CAF 2020 - eTool

<< << INDEX The actions’ number and the categories to which they belong, are also shown inside a MAP, shown/hidden with this command. When you hover over a yellow label (an action) it is shown the tooltip of its category and the description of the action inside a pink textbox that appears (in the picture it is visible the tooltip for the category “POTENTIAL” and the description of the action n.2). The pink textbox disappears when you leave the label. The actions are positioned in numeric order inside a category. You can also assign the “UNCLASSIFIED” category to an action with the “0” button.

CAF 2020 - eTool

<< << INDEX The action list is also printed (with the PRINT command) inside an edit environment, where it can be further on elaborated.

CAF 2020 - eTool

<< << INDEX

PRIORITISATION - ITALIAN approach

CAF 2020 - eTool

CAF 2020 - eTool WEAKNESSES MANAGEMENT

<< << INDEX

For every subcriterion, called with the above buttons, they are shown the weaknesses previously elaborated. It is possible to classify them in three types as RECURRENT, STRATEGIC and OPERATIONAL . The buttons with the P (paste) letter, are useful to paste the content of the clipboard (which content is here displayed) together with the number of the subcriterion to which it belongs. As usual, it is possible to have automatically, a synthesis inside the Edit environment, that can be also enlarged with the button E/S (enlarge/shrink). CAF 2020 - eTool

CAF 2020 - eTool

<< << INDEX

ANALYSIS’ FLOW

Lorem ipsum dolor sit amet, consectetur adipisci elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur.

1 - We copy in the clipboard one weakness (Ctrl+C). Say that it is a recurrent weakness,we visualize the content of the clipboard with the P (paste) button.

3 Once we ha completed the work we can get the synthesis with the PRINT command, inside the Edit environment. The list of the classified weaknesses is shown.

Lorem ipsum dolor sit amet, consectetur adipisci elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua.

2 - As it is a recurrent weakness, we 1.1 Lorem ipsum dolor sit amet, consectetur adipisci elit, sed eiusmod tempor incidunt ut labore et dolore magna aliqua.

paste it in the inherent textbox with the P (paste) button. The content of the clipboard will be added, together with the number of the subcriterion to which it belongs (1.1 in the example)

CAF 2020 - eTool

CAF 2020 - eTool INITIATIVES MANAGEMENT

<< << INDEX Print a synthesis of all the initiatives inserted inside the edit environment. Print the Action list as established in the QUICK WINS management form. Show/Hide the Strengths. Show/Hide the Action sheet.

It is possible to manage up to 25 initiatives . Choosing an option they can be filled the four textual data and to insert the values of the impact column (1/3/5) and the feasibility column (1/3/5). The value of the priority’s field is automatically calculated. It can be edited a synthesis, inside the Edit environment. CAF 2020 - eTool

CAF 2020 - eTool

<< << INDEX

The Initiatives’ management form also present a complete “Action-sheet” as the one considered in the Caf model (the Scheme B). The previous picture show the form as it normally appears and this shows it when the remaining fields to consider are called.

CAF 2020 - eTool

CAF 2020 - eTool INITIATIVES GANTT CHART

This is a (very simple) GANTT which refers to the INITIATIVES managed with the previous form. The initiatives are shown here by clicking on the left buttons. This is the date of the current day, useful to see the situation. The number of initiatives is 25.

CAF 2020 - eTool

<< << INDEX

CAF 2020 - eTool PRIORITISATION—ITALIAN APPROACH

<< << INDEX With this form it is possible to do a prioritization of the initiatives, based upon the priority value.

CAF 2020 - eTool

CAF 2020 - eTool CRITICAL SUCCESS FACTORS MANAGEMENT

<< << INDEX It is possible to insert up to 25 CFS. For every subcriterion, relating to the list of CFS you can insert the value of the importance ( 1/2/3 ). It is then calculated the total and the normalized total. The command Importance Value Chart shows a new form with the next chart . The command for the Critical Success Factors analysis.

The command for a global view of CSF.

CAF 2020 - eTool

<< << INDEX

This is the global view of CSF. The labels’ color, based upon their numeric value, show a map CAF 2020 - eTool

CAF 2020 - eTool

IMPORTANCE/VALUE CHART

CAF 2020 - eTool

<< << INDEX

CAF 2020 - eTool

<< << INDEX

With the commands it is shown/hide the list of priorities

CAF 2020 - eTool

<< << INDEX

PRIORITISATION - PORTUGUESE approach

CAF 2020 - eTool

<< << INDEX

IMPROVEMENT SUGGESTIONS MANAGEMENT

FROM THE QUICK WINS FORM

The aggregation of the list of improvement suggestions can be done from the Action List : taken from the QUICK WINS. Clicking upon an option they can be chosen the Self assessment team’s suggestions and the stakeholders’ suggestion (source satisfaction surveys). These suggestions are the actions chosen, that will be managed with the following PRIORITISATION form. CAF 2020 - eTool

CAF 2020 - eTool

<< << INDEX SCORING

Clicking an option (that is an action) they can be inserted the impact, capacity, clients, choosing the values with the comboboxes (1 / 3 / 5) and the ranking. The scoring is automatically calculated. The improvement action is filled with copy/paste from the list of improvement suggestions managed with the previous form (see the next picture on the right). For every action must be filled the justifications for the scoring. The UPDATE command is to do manually the updating of the database, usually done when the exit button is clicked. It is useful whether it takes much time to manage all the actions.The ACTION SHEET command allows to manage the same as explained before.

CAF 2020 - eTool

<< << INDEX

COPY/PASTE TO IMPROVEMENT ACTION FIELD

READ ONLY

With the PRINT command all the actions are listed with the table of values and the justifications to the scoring, inside an edit environment, for further elaborations that can be also saved. With the ACTIONS LIST command it is printed the list of actions as established in the aggregation form, so it is possible to copy and paste in the IMPROVEMENT ACTION field.

CAF 2020 - eTool

CAF 2020 - eTool PLANNING MANAGEMENT

< << INDEX The PLANNIG phase is managed with this form. The ACTION LIST previously established is available and shown/hidden with the homonymous command.

CAF 2020 - eTool

< << INDEX It is created with the PRINT command

CAF 2020 - eTool

< << INDEX

PRIORITISATION - SLOVAK approach

CAF 2020 - eTool

CAF 2020 - eTool ACTIONS LIST CONSTRUCTION

< << INDEX The PRIORITISATION command shows the homonymous form.

FROM THE QUICK WINS FORM

The ACTION SHEET command shows the homonymous form, that implements the “Scheme B” of the Caf brochure.

These KEY IMPROVEMENT ACTIONS are automatically inserted from the QUICK WINS elaboration previously done. You can now construct the KEY IMPROVEMENT ACTIONS LIST in the right. You have to insert in an action field the number of the subcriterion to which it belongs in the form x.x (for example 4.3).

CAF 2020 - eTool

< << INDEX SCORING—PRINCIPLE OF EXCELLENCE

For every subcriterion you can insert the score inherent the eight principles of excellence. This score give us the Index depending on 8 principles of excellence (IPoE). The Caf score give us the Index depending on the CAF evaluation criteria (ICC).

CAF 2020 - eTool

< << INDEX You can select the whole table clicking on upper left corner of the grid, copy in the clipboard (Ctrl + C) and paste (Ctrl + V) in your word processor, so you can further elaborate and print it. You can sort the Ip column clicking on its title “Ip”.

This form automatically shows the action list and the final priority index, according to the formula Ip = 0,6*ICC + 0,4*IPoE CAF 2020 - eTool

CAF 2020 - eTool

INDEX

UTILITIES

CAF 2020 - eTool

CAF 2020 - eTool BENCHLEARNING MANAGEMENT

< << INDEX

This form

allows to

manage the bench learning process. It is composed of five phases.

CAF 2020 - eTool

< << INDEX

BENCHLEARNING MANAGEMENT

It is possible to print a synthesis than can be also edited in its own environment and then saved.

CAF 2020 - eTool

CAF 2020 - eTool CRITICAL SUCCESS FACTORS MANAGEMENT

<< < < << INDEX

The Critical Success Factors can be analyzed through a path that deals with the Vision and the Mission of the organisation, the inherent strategic Objectives, the operational Objectives and their enabling conditions. To open the C.S.F. form, click in the homonym button in the FORMULATE ACTIONS FORM CAF 2020 - eTool

CAF 2020 - eTool BALANCED SCORE CARD MANAGEMENT

<< < << INDEX

The Critical Success Factors can be further on declined in Key Performance Indicators to which assign a Target and an Actual Value. Their difference give useful indications. With the PRINT command the table is printed in the edit environment. The DIFFERENCE column has a conditional formatting that colours the cells in orange when it is negative.

CAF 2020 - eTool

CAF 2020 - eTool PROJECT CYCLE MANAGEMENT

< << INDEX

This is a simple PCM. In this grid it can be added/edited a project. In this grid they can be added/edited all the activities provided for the project and in this grid they can be added/edited all the budget voices provided for every project. It is also available (for every project) the GANTT for the provided activities .It is possible to look at all the tables with the GRID command. The PLAN can be printed inside an edit environment in which it can be further edited. The following picture shows a little part of it. CAF 2020 - eTool

CAF 2020 - eTool PROJECT CYCLE MANAGEMENT

< << INDEX

To insert the content, click a circular button and insert it in the textbox that appears. It is also shown a description of what it has to be inserted. The goal of this PCM is only to have a fast way to draft one or more (simplified) projects , without any velleity to replace a professional one.

CAF 2020 - eTool

The project can be printed inside an edit environment.

CAF 2020 - eTool

< << INDEX

CAF 2020 - eTool

< << INDEX

This is the overall view of projects, activities and budget, recallable with the previous GRID command. CAF 2020 - eTool

CAF 2020 - eTool

< << INDEX THE CAF JOURNEY MANAGEMENT

This form manages the “Caf journey”. The 10 buttons act as switches that turn on/off the steps. They can be inserted (N buttons) notes for every step. The U (undo) buttons turn off the switches (from higher order back to lower one). The PRINT command insert the overall synthesis in this textbox , that can be saved (SAVE button) in a text file. These buttons show the description of every step as the Caf brochure. CAF 2020 - eTool

CAF 2020 - eTool

INPUTGLEE

< < INDEX

With this utility that I have named INPUTGLEE, that you can call with this command, you can create hierarchical graphs leveraging a powerful Microsoft library called MSAGL . These graphs can be useful to organize the Caf users’ activity.

There are many visual tools that allow you to build hierarchical charts. There is no doubt that the desired result is achieved but at the cost of considerable effort and with the serious limitation of the time available, which is usually not much. It is more rational to leave these tasks to the machine, which can perform all the necessary optimizations, while leaving the last word to the human operator. This is what INPUTGLEE does; GLEE (Graph Layout Execution Engine) was the old name of MSAGL (Microsoft Automatic Graph Layout) a Microsoft library. The purpose of the software is to facilitate the input of nodes and their links. It is obvious that these relationships must be known in advance and the simplest way to start the job is to draw them out with pen and paper, but regardless of their positioning in the graph, which instead will be created by the underlying algorithm. The more is the number of nodes, the more you'll appreciate the help of the MSAGL library. CAF 2020 - eTool

CAF 2020 - eTool

The use of the images have some limitations: Don’t insert too many images, otherwise the map becomes somewhat confusing; Choose small images, with dimensions of an icon (48 x 48 – 128 x 128 – max 256 x 256); Apart from that, the library is highly optimized and allows you to create excellent graphics. Tip – when you drag a node with more edges, these seem to collapse into one. To avoid this, press the shift keyboard key while dragging it. Furthermore, the nodes position is updated. CAF 2020 - eTool

CAF 2020 - eTool

E-TOOL RELATIONS

CHARTS

ENABLERS SCORE CONSENSUS

RESULTS SCORE

CHARTS

> >

SELF

> INDICATORS

> RESULTS

CHRONOLOGY

REPORT

> SYNYHESIS

ASSESSMENT

> ENABLERS

INDEX

WEAKNESSES

STRENGTHS

AREAS FOR IMPROVE-

IDEAS FOR IMPROVEMENT

> COLLATE IDEAS

IMPROVEMENT ACTIONS

> CRITICAL SUCCESS FACTORS

KEY IMPROVEMENT ACTIONS LIST

FORMULATE

ACTION SHEET

ORGANISATION’s STRATEGIC

> BALANCED SCORE CARD CAF 2020 - eTool

QUICK WINS

> PRIORITISATION

CAF 2020 - eTool

THE ELABORATION PATH OF THE KEY IMPROVEMENT ACTIONS

INDEX

> AREAS FOR IMPROVEMENT

> IDEAS FOR IMPROVEMENT

> IDEAS FOR IMPROVEMENT COLLATION UNDER COMON THEMES

> QUICK WINS

ACTIONS FORMULATION

ACTIONS SUBDIVISION

> KEY IMPROVEMENT ACTIONS

> ORGANISATION’s STRATEGIC OBJECTIVES

> KEY IMPROVEMENT ACTIONS LIST CONSTRUCTION

> ACTIONS SHEET

CAF 2020 - eTool

> PRIORITISATION

CAF 2020 - eTool

RAW DATA

SYNTHESIS



 WEAKNESSES



 STRENGTHS



 AREAS



FOR IMPROVEMENT  IDEAS FOR IMPROVEMENT

SCORE

S.A.R.

CONSENSUS

IDEAS COLLATION FOR THEME ACTIONS FORMULATION

KEY IMPROVEMENT ACTIONS

FLOW DIRECTION

PRIORITISATION C.S.F.

ASSOCIATION COMMANDS / OPERATIONS

CAF 2020 - eTool

QUICK WINS

CAF 2020 - eTool THE CAF CLIPBOARD

INDEX

This clipboard represents a dedicated space for every subcriterion, easily recallable when it needs, with the small button near the EXIT button of every form,

Click on the microphone icon, click inside and dictate the text. CAF 2020 - eTool

to insert all the notes that come in mind during the work . Clicking on a subcriterion button, the pen picture appears to signal that it is possible to insert the text (if you begin to type it vanishes). With the Print command you can print a synthesis of all the notes inside the edit environment. You can use Microsoft Cortana (for English (Australia, Canada, India, United Kingdom), French (France), German (Germany), Italian (Italy), Portuguese (Brazil) , Spanish (Mexico, Spain) and simplified Chinese languages. Press the shortcut (Windows + H) on your keyboard and this box appears on your screen

CAF 2020 - eTool

With the SKETCH command you can draw coloured sketches, that are automatically saved and reloaded in new sessions. You can:  save the sketch in your system  open an existing sketch (that replaces all)  import an image as a background upon which to draw your sketches  save all as a jpeg image A stylus is more suitable than mouse, because it can leverage the features of the underneath graphic control…. and it can certainly give better results!

CAF 2020 - eTool

< INDEX

It is useful to take fast annotations of the ideas that come in mind, through POST-IT labels. It is possible to do such a thing inside the etool, clicking the small green button present in all the forms. You can insert text or sketches, inside boxes , that can also be moved and resized. The upper annotations command shows/hides the list of the textual notes. To insert a note select an icon and the command bar is enabled. CAF 2020 - eTool

CAF 2020 - eTool

INDEX

PART 3—INSTALLATION INSTRUCTIONS

CAF 2020 - eTool

INSTALLATION INSTRUCTIONS There is not an installation phase, you have to download the package of your interest, decompress it ( a .zip file) in your system and then launch the “WpfCAF.exe” file that you find in the folder that is created. Prerequisites: -Windows 10 O.S. ; -It is mandatory to download and install a Microsoft application called SQLLocalDB.msi that is essential to manage the inner SQL database . Please look at the “ Startup instructions” that you find at the end of the present tutorial.

CAF 2020 - eTool

INDEX

CAF 2020 - eTool

INDEX

APPENDIX A - SYNCHRONIZATION

CAF 2020 - eTool

NOTES ABOUT THE SYNCHRONIZATION One thing to bear in mind is the kind of work that is being adopted. In general it can be of two types: • standalone type, in which both the assessors that the Admin operate on the same machine; • operational autonomy, hence on different machines. The latter is the one that will probably be adopted in most cases, above all for flexibility reasons . Assuming to have chosen this, there are some concepts that need to be clarified, in order to operate in the more correct and effective way. The working cycle of the SAG is carried out in two stages. In the first, which could be defined as "private", each assessor works in a private sphere, anywhere he wants to do it and with any machine (assuming the Microsoft Windows Operating System). The second, instead, of "collegial” type, is managed by the Admin, which is actually a fictitious figure, which may coincide with an assessor, but also with the same SAG. It is extremely important to clearly define the ways in which all the individual contributions (from the assessors), merge into one (the admin). (SEE ALSO NOTES AT THE END) The Caf etool provides two current instruments for this process: a) The first is of explicit type and is the MERGE phase b) The second is the mask COPY GRIDS called up from the main screen.

INDEX It is implemented through the following steps: a) EXPORT -database and RTF FILES The single assessor EXPORTS his/her own database (with the homonymous command of the main form) also in XML(*) format, to which will be added a prefix, depending on the order number ( "A_" for the assessor # 1, "B_" for the assessor # 2, etc. until "L_" for the assessor # 10). Obviously the purpose is to clearly identify they. The evidences' management makes use, both of data belonging to the internal database, both also of external data sources to it. These can be of various kinds (text, images, tables, statistical graphs, and so on), and the assessors should be in a position of being able to enter the same. As these are external elements to the database, they must remain external, but it has to be possible a form of synchronization, which, by force of circumstances may not coincide with those mentioned previously (in fact limited only to the database). This synchronization makes use of ".rtf" format files, produced by the contents of the RichTextBox of the mask ENABLERS AND RESULTS MANAGEMENT. This in practice constitutes a simple text editor, with basic formatting options but with the possibility to insert graphics, images, tables, and so on. RTF files are exported together with the database, but a suffix (coinciding with the database prefix) is added.(*) XML stands for eXtensible Markup Language and is a universal format, adopted for the exchange of data through all the platforms. It is highly optimized and allows very fast operations.

-MERGE phase CAF 2020 - eTool

CAF 2020 - eTool

Strategic planning of tasks It is very important an advance planning of tasks in order for an equitable distribution of the same among all the assessors. In this way, each assessor will produce a number of ".rtf" files

INDEX base with those of the assessors. During this operation, the synchronization of the RTF files is also performed. (See end notes). The .rtf files produced by different assessors, but dealing with

to be transferred, as a result of the synchronization, in the the same sub-criterion, are subjected to a MERGE operation in Admin system. However, there is the possibility (by several as- that it is produced one .rtf file with the contents of these files, sessors) of producing .rtf files about the same sub-criterion. appending the content in the order of the numbering of the (See d) synchronization)

assessors . The Admin will eliminate redundant data and will

give it a final shape. b) TRANSMISSION Each assessor transmits his/her own database (in XML for> mat) and the .rtf files to the Admin. It is an operation which, obviously, can be done in various ways and is released by the B - COPY GRIDS Caf etool. The Caf etool creates at this purpose a single compressed file, which can be transmitted in a more smooth way. Please refer to the section of the Tutorial. c) AGGREGATION After receiving the database and all the .rtf files, the Admin must simply inserts they (aggregating they), in any of his/her system folder. If you adopt a shared folder on an Internet hosting service files, this operation is automatic. d) MERGE phase It is done with the homonymous command the MAIN form) and synchronizes the Admin

( in dataCAF 2020 - eTool

CAF 2020 - eTool

INDEX

THE SYNCHRONIZATION CYCLE The Caf etool has been designed upon the idea that the Self Assessment Group is an unitary entity, though formed by the union of distinct sub-entities (the assessors). With the synchronization mechanism, the sub-entities, though operating autonomously, share the same data. The following is the circular schema of the process. CAF ADJUSTMENT The

Caf

adjustment,

previously

shown, makes the synchronization procedure indispensable, as it is (obviously) necessary to operate on the same examples. The Admin after the Caf adjustment (with the S.A.G. collaboration), exports its own database and the Assessors synchronize it with theyr own.

CAF 2020 - eTool

Limiting ourselves to a single table (there is one for INDEX sub-criterion), the following occurs: - There are 11 columns, 10 for the assessors and one for the

SYNCHRONIZATION MECHANISM

Its necessity is connected to the operating modes, that are: 1. Standalone mode: the machine on which you work is unique and in turn the assessors access it by acting on both Admin the "private" fields (the scores), than on "public" (all others). 2. Operational autonomy: each assessor works on a different system (the Admin system can also be used by an assessor). The first mode, clearly, does not need any synchronization. The second one, instead, imposes its use. The reasons, as obvious, require further clarifications. A database is composed of tables, not considering for simplicity also other necessary entities. Each table consists of fields (intersection between a row and a column), in which they fit the specific information. The CAF model provides that each assessor contributes to the definition of the contents; these contributions will be further on developed and defined by the figure called Admin. On the other hand, each assessor also inserts data that must necessarily be differentiated from those of the others (the scores). Finally, looking to the nature of the data, we see that in part they must be unique within the database. To take account of this variety of content formation, the appropriate technical choices have been done to differentiate, then, the same synchronization. Schematically, the synchronization is performed as follows: 1) SCORES CAF 2020 - eTool

CAF 2020 - eTool

INDEX 2) public data, which are formed by the contributions of each assessor (evidences, strengths, weaknesses, .....) The situation is the following

The content of the FIELD (e.g. the first line of the column 9), in the Admin’s database, is constituted by the content of such fields in the database of each assessor, placed accordingly to the order number of the same one. This will introduce ( of course) a certain redundancy to the content, that the Admin must remove. CAF 2020 - eTool

CAF 2020 - eTool

INDEX 3) public data, but that must be UNIQUE inside the Admin database. These are made up of all the TABLES that are formed by filling the masks "Aggregation and analysis of Enablers evidences" and "Aggregation and analysis of Results evidences." This uniqueness feature requires to Admin figure, an advance planning of the assessors' tasks, so that each assessor fills a number of tables that WILL REPLACE THE SAME TABLE IN THE ADMIN’s DATABASE. This will be done using the COPY GRIDS > command of the main screen. The picture shows a possible example. For simplicity, avoiding crossings, they are replaced only two tables for single assessor .

CAF 2020 - eTool

INDEX 4) Rich Text Files They were introduced to take into account any data from EXTERNAL sources to the database and that cannot be inserted in this, given their qualitative and quantitative nature, not known first. They are considered within the data type of point 2), which we refer for their

S.A.G operates in a centric manner. All the (autonomously done) contributions flow to the admin, that aggregates and synchronizes them. At the end the admin transmits his/her own database and the assessors restore it in their own system. CAF 2020 - eTool

CAF 2020 - eTool

BACKUP

ASSESSORS

DATA EXPORT

ADMIN —————————————  DATA INTEGRATION  DATA SYNCHRONISATION

BACKUP

DATA RESTORE

REDUNDANCY Redundancy is of fundamental importance in the event of (accidental or malicious) loss of data. The etool has different degrees of redundancy: 1) AUTOMATIC BACKUP at the end of each work session an automatic backup is made in a specific folder, thus having a history of the same; 2) MANUAL BACKUP with manual backup the data is saved in the folder you choose. Operations 1) and 2) are related to a single assessor, so the redundancy grows linearly with their number. RESTORE The Restore function allows you to always have updated data. CAF 2020 - eTool

CAF 2020 - eTool

This etool is based on a relational database realized with Microsoft SQL. It is light in terms of resources and can be saved as a unique file, so to be easily exchanged among the S.A.G. . The etool uses the database through the effective (although quite old) ADO.net tecnology; tables are stored in the RAM, hence elaborated and then saved back into the database in a very fast and transparent manner for the users. This software does a massive use of XML format (a universal one) for storing and exchange data. The database has almost 130 tables, most of which are in hyerarchical relations, so to represent the underneath logic model. The following picture shows an example of hyerarchical relation.

CAF 2020 - eTool

SYNCHRONISATION—OVERALL DIAGRAM WEAKNESSES—STRENGTHS—AREAS FOR IMPROVEMENT— IDEAS FOR IMPROVEMENT— SCORES ASSESSORS EXPORT DATA

MERGE

ADMIN’s database

COPY GRIDS

ASSESSORS EXPORT DATA

ENABLERS / RESULTS (RAW DATA) CAF 2020 - eTool

S Y N C H R O N I S A T I O N

CAF 2020 - eTool

INDEX

APPENDIX B : “CAF 2020 eTool localization project”

CAF 2020 - eTool

INDEX

The modern Programming Environments (like Microsoft Visual Studio 2019) provide very efficient instruments to accomplish the localization in any language. In the case of Caf 2020 e-Tool what it needs is the existing localized Caf model and only the translation of a single column of a single table (of three columns). It has about four hundreds rows but a lot of it must be filled with phrases or words taken from the Caf model. The following is a small part of the localization table for Russian language (for Caf 2013) (made by Mr. Dmitry Maslov, national Caf correspondent for Russia). Once the table is complete, it has to be inserted in a special section of the software and the interface for that language is ready. This is a work of a few hours. The second phase of the localization is to insert, in several tables of the database, all the “examples” of the already localized version of the Caf model. Once all these translations are complete, the full localization will also be complete.

CAF 2020 - eTool

DICTATION

INDEX

The new technology (Microsoft Cortana) is now available for desktop applications like the eTool. It works with Windows 10 and for English (Australia, Canada, India, United Kingdom), French (France), German (Germany), Italian (Italy), Portuguese (Brazil) , Spanish (Mexico, Spain) and simplified Chinese languages. For the others languages you have to use Microsoft Speech Recognition technology. Press the shortcut (Windows + H) on your keyboard and this box appears on your screen

Click on the microphone icon and then click in a textbox inside the Caf etool, or inside the Caf clipboard or the edit environment, dictate the text with a microphone and it will be transcribed. It's a great convenience and facilitation. I’m sure that in the future this will be extended to all the languages, but if you want leverage this feature also with the others languages, there are other ways like the followings, though they have not the same flexibility. Google docs It is an excellent solution. If you open the eTool and at the same time you open a document in Google docs, it is possible to dictate inside it and with a copy/paste you can transfer the content in the eTool textboxes. You can also use your Android Smartphone to dictate in the same document opened both in it that in your personal computer. At https://support.google.com/docs/answer/4492226?hl=it#zippy=%2Clanguages-that-work-with-voice-typing you'll find the "tutorial" for dictations in Google Docs. Google dictation is available for almost every language, so it doesn't suffer the Microsoft Cortana's limitations. Microsoft “Dictation” It is a stand-alone application that you can get from Microsoft Store. Go to https://www.microsoft.com/en-us/p/ dictation/9p4lw96t0bcd?activetab=pivot:overviewtab and choice your language. It is available only with Windows 10

CAF 2020 - eTool

INDEX

APPENDIX C - WORKFLOW

CAF 2020 - eTool

ENABLERS

5-Repeat the procedure for all the indicators belonging to the example

1-Select an example with the navigation bar 2-Compile the textual boxes 3-Exit

INDEX

B-Exit RESULTS’ CHRONOLOGY

————————————————————————— RESULTS This form is very articulated and before to begin, it needs to work with others forms: the YEARS and the INDICATORS’ MANAGEMENT ones · YEARS 1-Select the edit option 2-Select the first year with the list box 3-Exit · INDICATORS’ MANAGEMENT 1-Select an example from the list 2-Change the default content (RESULT or INDICATOR) with the one that you establish (there are up to fifteen indicators for every example). 3-Exit RESULTS A-Select an example from the list 1-Select an indicator from the navigation bar 2-Fill the Perception or Indicator results box 3-Insert measurement, target and comparison for the year considered 4-Fill the summary box

This is a read-only form. There are three master-details tables. 1-Click on a row in the first list (the examples) – it is shown the inherent details table (the indicators) 2-Click on a row of indicators – it is shown the inherent details table with the values (measurement, target and comparison ) for the three years considered and also a chart. ————————————————————————— SYNTHESIS 1-Select a subcriterion They are shown the example list and the DATA inserted with the previous forms (ENABLERS and RESULTS) in two read-only boxes 2-Insert, in the edit environment and for every subcriterion, a synthesis. You can do copy paste from left to right and insert also new external data (tables, pictures, charts and so on) 3-Exit

CAF 2020 - eTool

INDEX

CONSENSUS MEETING

1-Select

1-Select a subcriterion (small buttons) 2-Select an analysis dimension (PLAN-DO-CHECK-ACTTREND-TARGET-COMPARISON-COVERAGE) The chart with the score given by all the assessors is created and some simple statistics are shown at the bottom of the form. Furthermore, you can set the percentile for the boxplot chart. The chart and these statistics will help the choice of the score to assign collegially. 3-Select the score from the lists under the range scale. It will be located inside one of the two tables depending on whether we consider an Enabler o a Result.

a subcriterion (in the right side is shown the synthesis previously inserted - it’s read-only) 2-Fill the four textual boxes (you can do copy paste from right to left) 3-Collate the ideas for improvement under common themes 4-Formulate the improvement actions 5-Exit ————————————————————————— ENABLERS AND RESULTS’ SCORE 1-Select a subcriterion (small buttons) Select a score range and select the score from the lists for the four analysis dimension (PLAN-DOCHECK-ACT) 2-Select a criterion (large buttons) to see the score assigned by all the assessors. 3-Click the VALUES command to show the map of all the score value for all the sub-criteria 4-Click the MAP to show the map of the examples involved in every range score 5-Click the PRINT command to have the VALUES (voice c) in a textual box, from which you can copy the content.

4-Repeat the procedure until to fill the two tables. 5-With the PRINT command you can write the two tables in a textbox, so you can copy the content for your needs. 6-The REGISTER command call the homonymous form that will help you to select the score. 7-The criterion buttons allow to show, for every criterion, all the numeric values.

—————————————————————————

CAF 2020 - eTool

CHARTS

—————————————————————————

1– Select an option 2-Select a subcriterion to look the inherent bar chart 3-Click the STACKED BARS or RADAR commands to look the same

RESTORE

4– Click the CAF RELATIONS command to look the same

1-Select the RESTORE command 2-Select the BACKUP directory 3-Wait for the restore procedure 4-When it is complete the application will be closed

—————————————————————————

CONTRIBUTION MERGING

COPY GRIDS There are 28 lists, each of one contains the numbers from 1 to 10 (the assessors number) 1-Click a list (a subcriterion) and select the assessor number that will deal with that subcriterion 2-Repeat the action for each list 3-Launch the command COPY GRIDS 4-Exit

1-The Admin puts the contributions received by the assessors in a directory. 2-He/she select this directory and launches the command MERGE to integrates all the contributions in the database

SELF ASSESSMENT REPORT Click the SELF ASSESSMENT REPORT command to create it in the edit environment. ————————————————————————— BACKUP 1-Select the BACKUP command 2-Select a directory to save the files 3-Exit CAF 2020 - eTool

CAF 2020 - eTool

PRIORITISATION

PORTUGUESE APPROACH

————————————————————————— QUICK WINS – ACTION LIST There are three vertical textual boxes: in the right you’ll have the ACTION LIST automatically taken from the S.A.R. 1-Launch the COPY ACTION LIST S.A.R. command and they will be copied in the middle textbox 2-Cut and paste from the middle textbox to the left one the actions that you consider QUICK WINS. 3-Exit ————————————————————————— EIPAS’s APPROACH 1-Select the prioritisation mode (complete or concentrated) 2-Select a subcriterion from the list 3-COMPLETE MODE Insert IMCC – IMST – IMIR - IMSR - LD – RN – SR – PIM 4-CONCENTRATED MODE Insert SW - EIM – PIM 5-Insert the possible chosen action 6-Print the values tables 7-Exit

INDEX

There are three vertical textual boxes: in the right you’ll have the ACTION LIST taken from the S.A.R. or from QUICK WINS, accordingly with the chose option. 1-Select a TOPIC with the inherent option 2-Copy/paste from the right textbox to the left one (the assessment team’s improvement suggestion) 3-Fill the middle textbox (the stakeholders suggestions) 4-Launch the SCORING or PLANNING command 5-Exit · PORTUGUESE APPROACH – SCORING 1-Choise an option (an action) 2-Insert the impact, capacity, clients values with the lists 3-Fill the justifications for impact, scoring, clients 4-Exit · PORTUGUESE APPROACH - PLANNING For each action, called with the navigation buttons fill the

CAF 2020 - eTool

form.

CAF 2020 - eTool

FINNISH APPROACH Click ACTION LIST command and it will be shown the same taken from QUICK WINS form. 1-Insert the new actions (up to 25) to consider in the grid on the right side. 2– Navigate the actions and assign a category to each one, clicking on the buttons in the low-left side (there are 9 category to Select from) 3-With the MAP command, a categorization map of the actions is shown (or hidden). 4-The action list is printed (with the PRINT command) inside an edit environment, where it can be further on elaborated. ————————————————————————— AUSTRIAN APPROACH On the left there are the actions taken from the QUICK WINS. 1-Based on its content you can fill the new actions list 2-Click the PRIORITISATION command to show the relative form 3-Insert the prioritisation values in the INPUT field 4-Click in the PRIORITY header to order in ascending or descending mode 5-Select the whole table clicking on the upper left corner and copy (Ctrl + C) in the clipboard to export it.

SLOVAK APPROACH

INDEX

On the left there are the actions taken from the QUICK WINS. 1-Based on its content you can fill the new actions list 2-Click the PRIORITISATION command to show the relative form 3-Click the SCORE PoE command to open the inherent form a.Select a subcriterion in the upper side b.Assign a score for the eight principles of excellence with the lists c.Exit from the SCORE PoE form 4-the prioritisation form will be updated 5-they are shown : a-the CAF score b-the PoE score c-the ICC index d-the IpoE index e-the total priority index according to the formula Ip = 0,6*ICC + 0,4*IpoE 6-Click in the Ip header to order in ascending or descending mode 7-Select the whole table clicking on the upper left corner and copy (Ctrl + C) in the clipboard to export it.

CAF 2020 - eTool

ITALIAN APPROACH · WEAKNESSES 1-Select a subcriterion 2-Copy in the clipboard a weakness (Ctrl + C) 3-Paste it in the inherent textbox (RECURRENT – STRATEGIC – OPERATIONAL) 4-PRINT the synthesis 5-Exit

3-Call the global view of CSF 4-Call the importance/value chart 5-Exit

· INITIATIVES 1-Select an option (an initiative) 2-Fill the four textbox 3-Assign the values for impact and feasibility 4-Fill the action sheet for each initiative 5-Print the action list and the synthesis 6-Exit · CRITICAL SUCCESS FACTORS ANALYSIS 1-Insert Vision and Mission of the organisation, the inherent strategic Objectives, the operational Objectives and their enabling conditions 2-Establish the CRITICAL SUCCESS FACTORS · CRITICAL SUCCESS FACTORS 1-Click on a subcriterion 2-For each established CSF assign the importance value (1/2/3) CAF 2020 - eTool

CAF 2020 - eTool

CONCLUSIONS

•

The aim of this work is to give to Caf users an instrument to manage the data that itself asks. It has a pyramidal structure, that is, data pass through several elaborations, each based on the previous one.

with the help of simple statistics and other data previously elaborated;



implementation, in relation to the approach adopted by each

•

It can be easily localized in any language, as shown in another appropriate project prototype.

It allows the assessors to autonomously work on their

own machine and easily share the results among the S.A.G. , through an exportation procedure , a synchronization one and the final integration of data by the Admin figure; •

It creates many summary documents that will facilitate the Caf model implementation.



The Caf e-Tool has the following features:

It can be easily adopted both for Administrations that Educational Institutions;

The prioritisation phase is also considered, with some tools

Country.

It produces several kind of charts that show the values of all the numerical data treated;

At the end of a session path it is automatically created the fi-

that help the user to easily tackle it. These tools have different

INDEX

charts and the scores’ tables can be easily filled

•

nal document of the Self Assessment Report.

The Consensus is facilitated with synthesis

The work is based on a personal motivation, which excludes any other. Salvatore

All the textual elaborations are done inside the inner ba-

sic word processor, but it is possible to transfer the content on other professional one to further on elaborate it;

CAF 2020 - eTool

STARTUP INSTRUCTIONS

Download the package of your interest extract the compressed .zip file in your system (I recommend the desktop launch (double click) the “WpfCAF.exe” file that you find at the bottom in the folder that is created. It’s recommended to create a link and put it in the Desktop (Right click —> New —> Send to Desktop) to launch this command, to avoid to accidentally delete or damage this important file.

Follow the tutorial Contacts: spampinato55@gmail.com Prerequisites: -Windows 10 O.S. ; for older O.S. versions it has to be accordingly adapted the inner SQL database; -It is mandatory to download and install a Microsoft application called SQLLocalDB.msi that is essential to manage the inner SQL database. Please look next pages to do it.

CAF 2020 - eTool

HOW TO DOWNLOAD AND INSTALL THE SQLLocalDB.msi file In your browser search the following link

https://www.microsoft.com/en-us/download/details.aspx?id=101064

Select your language and click on Download It is downloaded in your system the following SQL2019-SSEI-Expr.exe file

Double click and it is shown the following form CAF 2020 - eTool

CAF 2020 - eTool

Click the third option and it is shown (in your language –wether available) as follows Download files

Select the LocalDB option, select a path in your system and then launch the Download command

Double click to launch it and the SQL LocalDB will be installed. CAF 2020 - eTool

CAF 2020 - eTool

IMPORTANT For older pc, it is possible that the software starts (the main form is regularly shown) but when you call another form, it take several seconds to elaborate but suddenly is closed, without any messagge. This is due the hardware’s limitations that is not able to run the SQLLocalDB 2019. If this is the case, please uninstall the SQLLocalDB 2019 and install a previous version, like 2016 or 2017 (try 2017 first). The following are the direct links: 2016: https://download.microsoft.com/download/4/1/A/41AD6EDE-9794-44E3-B3D5-A1AF62CD7A6F/sql16_sp2_dlc/en-us/ SqlLocalDB.msi 2017: https://download.microsoft.com/download/E/F/2/EF23C21D-7860-4F05-88CE-39AA114B014B/SqlLocalDB.msi They are in English language but you don't have to care about that, because the language is irrelevant. ————————————————————————————————————————————————— THOSE WHO WANT TO CONTACT ME CAN SEND AN EMAIL TO spampinato55@gmail.com I WOULD BE HAPPY TO PROVIDE ALL THE ASSISTANCE POSSIBLE TO FACILITATE THE USE OF THE SOFTWARE, WHICH, ALTHOUGH IT IS NOT DIFFICULT, IS DEFINITELY VERY ARTICULATED. ALL CRITICISM AND SUGGESTIONS FOR IMPROVING THE WORK ARE WELCOME. Salvatore CAF 2020 - eTool

CAF 2020 - eTool

INDEX

CAF 2020 eTool HOW TO OPERATE

CAF 2020 - eTool

INDEX

ASSESSORS’ NUMBER ASSIGNMENT ADMIN

CAF 2020 - eTool

INDEX

INSERT RAW DATA (EVIDENCES – DATA AND INFORMATIONS OBTAINED FROM THE QUESTIONNAIRE - DATA AND INFORMATIONS OBTAINED FROM THE INTERVIEW)

A (BY EVERY ASSESSOR INSERTS RAW DATA FOR HIS/HER ESTABLISHED SUBCRITERIONS THE ADMIN), FOR ENABLERS AND/OR RESULTS

CAF 2020 - eTool

INDEX

MAKE A SUMMARY EVERY ASSESSOR MAKES A SUMMARY

RAW DATA

SUMMARY CAF 2020 - eTool

CAF 2020 - eTool

INDEX

STRENGHTS – WEAKNESSES - AREAS FOR IMPROVEMENT IDEAS FOR IMPROVEMENT BASED ON THE SUMMARY EVERY ASSESSOR ESTABLISHES THE STRENGHTS – WEAKNESSES - AREAS AND IDEAS FOR IMPROVEMENT

- STRENGHTS - WEAKNESSES - AREAS FOR IMPROVEMENT - IDEAS FOR IMPROVEMENT

SUMMARY

CAF 2020 - eTool

INDEX

SCORE ASSIGNMENT A EVERY ASSESSOR ASSIGNS A SCORE TO HIS/HER SUBCRITERIONS, FOR ENABLERS AND/OR RESULTS

CAF 2020 - eTool

INDEX

EXPORTING DATA EVERY ASSESSOR EXPORTS HIS/HER DATABASE IN A COMPRESSED FOLDER THAT TRANSMITS TO THE ADMIN

ADMIN

CAF 2020 - eTool

INDEX

DATA SYNCHRONIZATION THE ADMIN AGGREGATES THE EXPORTED DATA AND DECOMPRESS THEM IN A FOLDER, THEN HE/SHE LAUNCHES THE SYNCHRONIZATION COMMAND 1

FOLDER 1

THEY ARE SYNCHRONIZED : STRENGHTS – WEAKNESSES - AREAS AND IDEAS FOR IMPROVEMENT SCORES CAF 2020 - eTool

CAF 2020 - eTool

INDEX

RAW DATA SYNCHRONIZATION THE ADMIN LAUNCHES THE COPY GRIDS COMMAND

FOLDER 1

THEY ARE SYNCHRONIZED THE RAW DATA (ENABLERS AND RESULTS)

CAF 2020 - eTool

INDEX

ASSESSORS’ DATABASE SYNCHRONIZATION THE S.A.G. DOES THE CONSENSUS MEETING, THE ADMIN EXPORTS HIS/HER (RATIONALIZED) DATA IN A COMPRESSED FOLDER THAT TRANSMITS TO THE ASSESSORS

1 2 3 4 5 6 7

INIT

9 10

ADMIN

THEY DECOMPRESS THE FOLDER AND LAUNCH THE RESTORE COMMAND IN THEIR SYSTEM, SO THAT ALL THE DATABASES ARE SYNCHRONISED

A NEW SELF ASSESSMENT PHASE BEGINS CAF 2020 - eTool

CAF 2020 - eTool

INDEX

WEAKNESSES STRENGTHS

RAW DATA

SYNTHESIS

AREAS

FOR IMPROVEMENT IDEAS FOR IMPROVEMENT

SCORE

S.A.R.

CONSENSUS

IDEAS COLLATION FOR THEME ACTIONS FORMULATION

KEY IMPROVEMENT ACTIONS

PRIORITISATION

FLOW DIRECTION

C.S.F. ASSOCIATION COMMANDS / OPERATIONS

CAF 2020 - eTool

QUICK WINS

CAF 2020 - eTool

INDEX

IDEAS FOR IMPROVEMENT - COLLATION FOR THEME REGISTER

IDEAS FOR IMPROVEMENT

COLLATION FOR THEME

CAF 2020 - eTool

INDEX

FORMULATE IMPROVEMENT ACTIONS REGISTER

AREAS FOR IMPROVEMENT

CRITICAL SUCCESS FACTORS

IDEAS FOR IMPROVEMENT COLLATED FOR THEME

IMPROVEMENT ACTIONS - ACTION 1 - ACTION 2 - ACTION 3

.................... - ACTION n

CAF 2020 - eTool

ORGANISATION’s STRATEGIC OBJECTIVES

CAF 2020 - eTool

INDEX

IMPROVEMENT ACTIONS

- ACTION 1 - ACTION 2 - ACTION 3

IMPROVEMENT ACTIONS ARE SUBDIVIDED IN QUICK WINS AND KEY IMPROVEMENT ACTIONS

.................... - ACTION n

QUICK WINS - Q.W. 1

KEY IMPROVEMENT ACTIONS - LIST

- Q.W. 2

- KEY ACTION 1

- Q.W. 3

- KEY ACTION 2

....................

- KEY ACTION 3

- Q.W. n

.................... - KEY ACTION

CAF 2020 - eTool

INDEX KEY IMPROVEMENT ACTIONS - LIST - KEY ACTION 1 - KEY ACTION 2 - KEY ACTION 3 .................... - KEY ACTION

“CAF Improvement identification, prioritisation and implementation . A study of inspiring practices in stalled in 20 Public Sector organisations throughout Europe and the methodologies for prioritisation. “ by Patrick Staes, Nick Thijs, Dorina Claessens—2016.

PRIORITISATION APPROACHES

FROM

PRIORITISATION OF THE KEY IMPROVEMENT ACTIONS

CAF 2020 - eTool