Evaluating Nurse Data Navigation Training Program: A Quality Improvement Project

Nursing ability to navigate data by sourcing, visualizing, and managing data provides for skill and insights development. Effectiveness of clinical, operational and strategic decision making is underpinned by sound understanding of the data. The object of this quality improvement project is to design, deliver and evaluate a nursing specific training program using spreadsheet software Excel to improve nurse competence and confidence in data navigation.

Qualitative Development of Students’ Digital Skills by Integrating a Spreadsheet Software in First Year Introduction to Engineering and Seminar Course

The Introduction to Engineering (ITE) and Industrial Seminar and Profession (ISP) courses conducted at School of Chemical and Energy Engineering, Universiti Teknologi Malaysia, are integrated courses which implement the Cooperative Problem-based Learning (CPBL) methods in the same semester. Based on this integrated courses, the main aim of this paper is to investigate the qualitative impact of spreadsheet hands-on seminar on the first year students' digital skill. At the beginning of the semester, students are given sustainability-based project to work on, which requires them to collect and to report the data in a series of presentations and written reports. In order to present those data, they need to use analysis tools such as a spreadsheet software. The students are introduced with some in-depth applications of the Microsoft Excel software through the seminar sessions in the ISP course. With the knowledge that the students gain, they are expected to implement it in the CPBL project. A qualitative approach has been adopted to implement the study. Student’s reflections were used as the data source to identify common attributes that they have managed to gain from seminar sessions. This study has found that all students had primarily learned about digital skills. They perceived hand-on activity during the seminar as a good platform to acquire knowledge on basic calculation and developed learning skill on Excel. Moreover, students recognized the skills they are learning will be useful in other courses and future careers.

Human–Machine Collaboration for Democratizing Data Science

Everybody wants to analyse their data, but only few posses the data science expertise to do this. Motivated by this observation, we introduce a novel framework and system VisualSynth for human-machine collaboration in data science. Its aim is to democratize data science by allowing users to interact with standard spreadsheet software in order to perform and automate various data analysis tasks ranging from data wrangling, data selection, clustering, constraint learning, predictive modeling and auto-completion. VisualSynth relies on the user providing colored sketches, i.e., coloring parts of the spreadsheet, to partially specify data science tasks, which are then determined and executed using artificial intelligence techniques.

FAST CAT

Descriptive and empirical sciences, such as History, are the sciences that collect, observe and describe phenomena to explain them and draw interpretative conclusions about influences, driving forces and impacts under given circumstances. Spreadsheet software and relational database management systems are still the dominant tools for quantitative analysis and overall data management in these these sciences, allowing researchers to directly analyse the gathered data and perform scholarly interpretation. However, this current practice has a set of limitations, including the high dependency of the collected data on the initial research hypothesis, usually useless for other research, the lack of representation of the details from which the registered relations are inferred, and the difficulty to revisit the original data sources for verification, corrections or improvements. To cope with these problems, in this article we present FAST CAT, a collaborative system for assistive data entry and curation in Digital Humanities and similar forms of empirical research. We describe the related challenges, the overall methodology we follow for supporting semantic interoperability, and discuss the use of FAST CAT in the context of a European (ERC) project of Maritime History, called SeaLiT , which examines economic, social and demographic impacts of the introduction of steamboats in the Mediterranean area between the 1850s and the 1920s.

Optimizing Orthopaedics and Rehabilitation Medicine Course Grading System by Spreadsheet Software

Background: Complex processes in grading system occasionally delay time-to-report and affect the accuracy of the report in Orthopaedics and Rehabilitation Medicine Course. Objective: To assess the effectiveness of spreadsheet software in the grading processes of the Orthopaedics and Rehabilitation Medicine Course. Methods: A cross-sectional study was conducted at Department of Orthopaedics, Faculty of Medicine Ramathibodi Hospital, Mahidol University. Exam scores of the 5th year medical students between 2014 and 2018 were collected. This study included complete summative data and excluded any data from repeated examinations. The effectiveness of grading system using spreadsheet software was evaluated the primary outcome as time-to-report (days) and accuracy of grade reports. Results: There were 893 students from 5 academic years, median duration of grade reports was 2.5 days (range, 0 - 30). Grade reports were 100% accurate. The analysis showed the longest duration of time-to-report was in 2014 with median 10.5 days (range, 0 - 30), and the shortest duration was in 2018 with median 0 day (range, 0 - 4). During 5 consecutive years, the spreadsheet software can reduce time-to-report significantly (P = .01). Conclusions: Spreadsheet software is an effective method to reduce time-to-report and reporting errors in grading system.

Event studies with daily stock returns in Stata: Which command to use?

In this article, I provide an overview of existing community-contributed commands for executing event studies. I assess which command could have been used to conduct event studies that have appeared in the past 10 years in 3 leading accounting, finance, and management journals. The older command eventstudy provides a comfortable graphical user interface and good functionality for event studies that do not require hypotheses testing. The command estudy, described in Pacicco, Vena, and Venegoni (2018, Stata Journal 18: 461–476; 2021, Stata Journal 21: 141–151), provides a set of commonly applied test statistics and useful exporting routines to spreadsheet software and LATEX for event studies with a limited number of events. The most complete command in terms of available test statistics and benchmark models as well as its ability to handle events with insufficient data, thin trading, and large samples is eventstudy2.

Three Dimensional Analysis and Comparison of Human Anterior Teeth and Experimentally Created Bitemark Depressions

A system was proposed to scan dental models to record three-dimensional features seen in the anterior teeth to create a database of dental profiles. Dental casts were randomly selected to create indentations in cowhide leather. Reid Bite Reader was used to measure the bite forces generated by Reynolds Controlled Bite Force Generator to make the teeth impressions. Using the Immersion MicroScribe® 3D, information from the 53 bitemark depressions and 62 sets of dental casts were transferred to an Excel Spreadsheet. Software was developed to perform the 3D comparison using metric and pattern analysis. Statistic analysis showed 100% success when comparing both arches together of the dental casts with the bitemarks or other dental casts.

Fiji plugins for qualitative image annotations: routine analysis and application to image classification

Quantitative measurements and qualitative description of scientific images are both important to describe the complexity of digital image data. While various software solutions for quantitative measurements in images exist, there is a lack of simple tools for the qualitative description of images in common user-oriented image analysis software. To address this issue, we developed a set of Fiji plugins that facilitate the systematic manual annotation of images or image-regions. From a list of user-defined keywords, these plugins generate an easy-to-use graphical interface with buttons or checkboxes for the assignment of single or multiple pre-defined categories to full images or individual regions of interest. In addition to qualitative annotations, any quantitative measurement from the standard Fiji options can also be automatically reported. Besides the interactive user interface, keyboard shortcuts are available to speed-up the annotation process for larger datasets. The annotations are reported in a Fiji result table that can be exported as a pre-formatted csv file, for further analysis with common spreadsheet software or custom automated pipelines. To illustrate possible use case of the annotations, and facilitate the analysis of the generated annotations, we provide examples of such pipelines, including data-visualization solutions in Fiji and KNIME, as well as a complete workflow for training and application of a deep learning model for image classification in KNIME. Ultimately, the plugins enable standardized routine sample evaluation, classification, or ground-truth category annotation of any digital image data compatible with Fiji.

Implementation of Sistem Administrasi Keuangan Sekolah for Junior High Schools, Senior High Schools and Vocational Schools in Bogor PESAT Schools (Si-AKSES)

In educational institutions, one of the resources that need to be managed properly is school financial resources. However, there are still many schools that have not managed their financial resources optimally, one of which is in the student financial administration process which is still done manually, namely by recording with books or recording with spreadsheet software. This has the risk of data being damaged, data lost, difficult to evaluate and monitoring, and less effective in student financial administration services. The same is the case with PESAT Bogor school, where schools still use spreadsheet software in financial administration. So in this study, the implementation of an integrated financial administration system at SMP, SMA, and SMK PESAT is integrated (Si-AKSES) in order to create optimal school governance, especially in the financial administration process. The software development uses the waterfall method which is implemented with the MySQL database, the PHP programming language and the CodeIgniter framework. With the existence of Si-AKSES, it can facilitate PESAT schools in providing services to students who want to make school financial payments, recording student transactions from the start of entry to graduation, controlling student arrears, reporting processes, and so that school finances are more controllable and transparent.