Teaching Reform and Practice of Functional Experiment Based on the Cultivation of Excellent Medical Talents

In order to cultivate excellent clinical medical talents with a solid foundation, strong literacy, refined skills, excellent communication abilities, innovative thinking, and a strong focus on practicality, functional experiments have undergone a series of reforms in areas such as constructing new curriculum systems, improving teaching content, updating teaching equipment, introducing new teaching models, and enhancing teaching evaluation systems.

Analysis of The Impact of Excellent Event Management on the Safety of Patients and Clinical Caregivers

Objective: To investigate the impact of excellent event management in improving patient safety and nursing staff care satisfaction. Methods: The study was analyzed by retrospective comparison, and routine management from January 2022 to December 2022 was set as the control group, and excellent event management from January 2023 to January 2024 was set as the study group. The differences in nursing outcomes between both groups were compared. Results: The rate of adverse events in the study group (0.61%) was lower than that in the control group (0.96%), and the rate of excellent events in the study group (2.57%) was higher than that in the control group (0.97%) (P < 0.05). Meanwhile, the satisfaction level of nursing safety in the study group reached 98.81%, which was much higher than in the control group (92.21%) (P < 0.05). Conclusion: Nursing excellent event management had a positive impact on improving patient care safety satisfaction, reducing the rate of adverse events, and increasing the rate of reporting excellent events.

基于Excel测试模板的变频器自动测试程序设计

变频器作为微波信号发射端和接收端的重要器件,对收发系统性能具有较大影响,因此,需对相关参数进行测试。本文针对其种类、测试参数和测试仪器设备多,以及测试人员要求高、人工测试效率低,开发设计变频器自动测试程序,并基于Excel测试模板,实现定制化测试。

Excel支持的匀变速运动位移公式的探究教学

匀变速直线运动的位移公式是教学中的难点。在分析人教版新教材编写设计和高一学生学情后,提出以Excel软件作为技术支持的科学探究教学改进方案。通过v-t图像围成的面积和真实位移的数据对比,得到匀变速直线运动v-t图像围成的面积表示位移的结论。

应用型本科高校“Excel人力资源管理工具应用”课程建设研究

数据分析技术在人力资源管理行业中的应用越来越广泛,但目前人力资源管理专业学生的数据分析能力相对薄弱。通过对应用型本科高校“Excel人力资源管理工具应用”课程建设进行研究,找出原有课程教学中存在的主要问题,对课程内容进行重构和设计,注重Excel工具应用的教授及数据分析素养的提升,培养高素质的应用型人力资源数据分析人才。

VBA结合Excel在施工进度横道图制图软件开发中的应用研究

施工进度计划是建设项目施工组织设计中的重要内容,横道图是水利水电项目设计阶段施工总进度计划的主要表示方法。本文依托Microsoft Office Excel内嵌的VBA语言简单、方便、高效的特点和优势,探索研发了一款符合水利水电行业设计习惯的施工进度横道图制图软件,可以减少人力投入,提高设计效率,满足行业设计需求。软件具有自动进行工程量汇总、强度累计、制作强度曲线图、绘制施工总进度横道图并标注线条强度、分期分幅出图、进度线条批量平移(含部分项目跨停工时段平移)等功能,在诸多水利水电项目设计中得到良好应用。

Excel软件在医学统计学课程中的教学应用探讨

在医学数据统计处理中,常用的统计软件包括SAS、SPSS和R。此外,掌握Excel软件中的统计功能对于提高数据处理能力也是一个极佳的选择。文章以《卫生统计学》教材为例,展示了数据处理的过程,并探讨了计量资料的均数、标准差、配对设计资料的t检验、两个独立样本的t检验以及单因素方差分析在统计分析中的应用方法。Excel软件可以作为医学统计学课程的辅助教学软件。

Python实现Excel文档转换到Word文档的自动化方法

通过研究开发了一种基于Python语言,实现Excel数据自动转换成Word文档并实现排版功能的方法,为科研工作者、数据分析师或报告撰写人员提供一个方便快捷的工具,帮助他们更高效地完成Excel数据转换成Word并实现排版的任务。

Evolutionary Decision-Making and Planning for Autonomous Driving Based on Safe and Rational Exploration and Exploitation

Decision-making and motion planning are extremely important in autonomous driving to ensure safe driving in a real-world environment.This study proposes an online evolutionary decision-making and motion planning framework for autonomous driving based on a hybrid data-and model-driven method.First,a data-driven decision-making module based on deep reinforcement learning(DRL)is developed to pursue a rational driving performance as much as possible.Then,model predictive control(MPC)is employed to execute both longitudinal and lateral motion planning tasks.Multiple constraints are defined according to the vehicle’s physical limit to meet the driving task requirements.Finally,two principles of safety and rationality for the self-evolution of autonomous driving are proposed.A motion envelope is established and embedded into a rational exploration and exploitation scheme,which filters out unreasonable experiences by masking unsafe actions so as to collect high-quality training data for the DRL agent.Experiments with a high-fidelity vehicle model and MATLAB/Simulink co-simulation environment are conducted,and the results show that the proposed online-evolution framework is able to generate safer,more rational,and more efficient driving action in a real-world environment.

List of winners of excellent papers of Baosteel Technical Research in 2023

According to the three-tiered review opinions of the editorial office of Baosteel Technical Research and the expert review opinions,the following papers were selected as the excellent papers of Baosteel Technical Research in2023.

面向流动追踪的多层鲁棒Excel文档水印

Excel文档被广泛应用于金融财务、科学研究、数据分析、统计报告等领域,在教育培训、在线办公等诸多场景中扮演着重要角色,却也潜藏着违规使用、侵权行为和信息泄露等安全隐患。为保护Excel文档内容的安全,迫切需要研究更安全可靠的文档保护技术。文中基于Excel文档格式,提出了一种面向流动追踪的多层鲁棒Excel文档水印算法,该算法通过将多层水印信息嵌入Excel文档的单元格样式和边框的RGB颜色值中,从而能在实际应用场景中明确敏感文档传播链条,对文档泄露源头进行追踪溯源,定位泄密责任人,以减少信息泄露事件的发生。经实验对比发现,所提水印算法不可感知性好,对增加、删除、重新键入、格式刷、复制粘贴和另存为等多种常见文档操作和攻击具有很强的鲁棒性,同时支持多层水印嵌入。与其他基于文档格式的水印算法相比,所提算法具有更好的水印不可见性、更强的鲁棒性和更宽广的应用范围。

Optimal search path planning of UUV in battlefeld ambush scene

Aiming at the practical application of Unmanned Underwater Vehicle(UUV)in underwater combat,this paper proposes a battlefield ambush scene with UUV considering ocean current.Firstly,by establishing these mathematical models of ocean current environment,target movement,and sonar detection,the probability calculation methods of single UUV searching target and multiple UUV cooperatively searching target are given respectively.Then,based on the Hybrid Quantum-behaved Particle Swarm Optimization(HQPSO)algorithm,the path with the highest target search probability is found.Finally,through simulation calculations,the influence of different UUV parameters and target parameters on the target search probability is analyzed,and the minimum number of UUVs that need to be deployed to complete the ambush task is demonstrated,and the optimal search path scheme is obtained.The method proposed in this paper provides a theoretical basis for the practical application of UUV in the future combat.

Influence of a diet meal plan on pepsinogen I and II,gastrin-17,and nutritional status in gastric ulcer patients

BACKGROUND Gastric ulcers(GUs)have a high risk of clinical morbidity and recurrence,and further exploration is needed for the prevention,diagnosis,and treatment of the disease.AIM To investigated the effects of a diet plan on pepsinogen(PG)I,PG II,gastrin-17(G-17)levels and nutritional status in patients with GUs.METHODS A total of 100 patients with GUs treated between May 2022 and May 2023 were enrolled,with 47 patients in the control group receiving routine nursing and 53 patients in the experimental group receiving dietary nursing intervention based on a diet plan.The study compared the two groups in terms of nursing efficacy,adverse events(vomiting,acid reflux,and celialgia),time to symptom improvement(burning sensation,acid reflux,and celialgia),gastric function(PG I,PG II,and G-17 levels),and nutritional status[prealbumin(PA)and albumin(ALB)levels].RESULTS The experimental group showed a markedly higher total effective rate of nursing,a significantly lower incidence of adverse events,and a shorter time to symptom improvement than the control group.Additionally,the experimental group’s post-intervention PG I,PG II,and G-17 levels were significantly lower than preintervention or control group levels,whereas PA and ALB levels were significantly higher.CONCLUSION The diet plan significantly reduced PG I,PG II,and G-17 levels in patients with GUs and significantly improved their nutritional status.

Integration of Excellent Chinese Traditional Culture into the Training and Education of Acupuncture and Massage Professionals

By reflecting on the current situation of the integration of excellent Chinese traditional culture into the training of acupuncture and massage professionals,this paper aims to carry out the research on the integration of excellent Chinese traditional culture into the training and education of acupuncture and massage.The specific implementation path includes early investigation and analysis,establishment of research objectives,formulation of teaching strategies,means and methods,empirical research on the process of teaching practice,teaching measurement and evaluation,and so on.Finally,it summarizes the connotation of the integration of excellent Chinese traditional culture into the training of acupuncture and massage professionals,in order to provide new ideas and methods for the integration of excellent Chinese traditional culture into the training and education of acupuncture and massage professionals.

基于EXCEL的供应链物流选址决策分析

随着企业经营规模的扩大,如何通过降低成本提升企业价值,已成为企业竞争力提升的关键。在物流行业中,基于供应链的物流选址问题是影响企业物流成本的重要因素。如何科学地做好供应链物流选址决策,将直接影响企业的经济效益。本文以石油公司为研究对象,结合线性规划的相关理论,构建基于供应链的物流选址决策模型,运用EXCEL工具,进行选址决策分析,以实现企业资源的优化配置,从而降低企业运营成本。

Efficient Route Planning for Real-Time Demand-Responsive Transit

Demand Responsive Transit (DRT) responds to the dynamic users’ requests without any fixed routes and timetablesand determines the stop and the start according to the demands. This study explores the optimization of dynamicvehicle scheduling and real-time route planning in urban public transportation systems, with a focus on busservices. It addresses the limitations of current shared mobility routing algorithms, which are primarily designedfor simpler, single origin/destination scenarios, and do not meet the complex demands of bus transit systems. Theresearch introduces an route planning algorithm designed to dynamically accommodate passenger travel needsand enable real-time route modifications. Unlike traditional methods, this algorithm leverages a queue-based,multi-objective heuristic A∗ approach, offering a solution to the inflexibility and limited coverage of suburbanbus routes. Also, this study conducts a comparative analysis of the proposed algorithm with solutions based onGenetic Algorithm (GA) and Ant Colony Optimization Algorithm (ACO), focusing on calculation time, routelength, passenger waiting time, boarding time, and detour rate. The findings demonstrate that the proposedalgorithmsignificantly enhances route planning speed, achieving an 80–100-fold increase in efficiency over existingmodels, thereby supporting the real-time demands of Demand-Responsive Transportation (DRT) systems. Thestudy concludes that this algorithm not only optimizes route planning in bus transit but also presents a scalablesolution for improving urban mobility.

Enable Excel-Based Basic Cybersecurity Features for End Users by Using Python-Excel Integration

In the digital age, the global character of the Internet has significantly improved our daily lives by providing access to large amounts of knowledge and allowing for seamless connections. However, this enormously interconnected world is not without its risks. Malicious URLs are a powerful menace, masquerading as legitimate links while holding the intent to hack computer systems or steal sensitive personal information. As the sophistication and frequency of cyberattacks increase, identifying bad URLs has emerged as a critical aspect of cybersecurity. This study presents a new approach that enables the average end-user to check URL safety using Microsoft Excel. Using the powerful VirusTotal API for URL inspections, this study creates an Excel add-in that integrates Python and Excel to deliver a seamless, user-friendly interface. Furthermore, the study improves Excel’s capabilities by allowing users to encrypt and decrypt text communications directly in the spreadsheet. Users may easily encrypt their conversations by simply typing a key and the required text into predefined cells, enhancing their personal cybersecurity with a layer of cryptographic secrecy. This strategy democratizes access to advanced cybersecurity solutions, making attentive digital integrity a feature rather than a daunting burden.

Research on the Transmission of Chinese Excellent Traditional Culture in Confucius Classroom at Sabaragamuwa University of Sri Lanka Under the Background of“the Belt and Road”Cooperation Initiative

“The Belt and Road”cooperation initiative contains Chinese excellent traditional cultural ideas,and is deeply rooted in Chinese excellent traditional culture.The proposal of“the Belt and Road”cooperation initiative is not only the strategic need to implement the“going out”of Chinese culture,but also the need to promote cultural exchanges and mutual learning among countries along“the Belt and Road”,and more importantly,the practical consideration of building a community of shared future for mankind with cultural identity.Confucius classroom,as one of the important platforms to realize the“going out”of Chinese culture,shows the“image of China”and enhances the“soft power”of Chinese culture,integrates and configures Chinese teaching and Chinese cultural resources through cooperation,and plays an important role in telling Chinese stories,spreading Chinese voice,enhancing cultural mutual trust and people-to-people contacts as well as the awareness of a community of shared future for mankind.Taking the Confucius classroom jointly built by Huanggang Normal University in China and Sabaragamuwa University in Sri Lanka as an example,this paper explores some effective transmission ways for spreading Chinese excellent traditional culture in Sri Lankan Confucius classroom under the background of“the Belt and Road”cooperation initiative,aiming to give full play to the role of Confucius classroom in cultural exchanges and enhance inter-school exchanges and cooperation between China and Sri Lanka in terms of cultural mutual trust and respect.

Motion Planning for Autonomous Driving with Real Traffic Data Validation

Accurate trajectory prediction of surrounding road users is the fundamental input for motion planning,which enables safe autonomous driving on public roads.In this paper,a safe motion planning approach is proposed based on the deep learning-based trajectory prediction method.To begin with,a trajectory prediction model is established based on the graph neural network(GNN)that is trained utilizing the INTERACTION dataset.Then,the validated trajectory prediction model is used to predict the future trajectories of surrounding road users,including pedestrians and vehicles.In addition,a GNN prediction model-enabled motion planner is developed based on the model predictive control technique.Furthermore,two driving scenarios are extracted from the INTERACTION dataset to validate and evaluate the effectiveness of the proposed motion planning approach,i.e.,merging and roundabout scenarios.The results demonstrate that the proposed method can lower the risk and improve driving safety compared with the baseline method.

Stochastic programming based coordinated expansion planning of generation,transmission,demand side resources,and energy storage considering the DC transmission system

With the increasing penetration of wind and solar energies,the accompanying uncertainty that propagates in the system places higher requirements on the expansion planning of power systems.A source-grid-load-storage coordinated expansion planning model based on stochastic programming was proposed to suppress the impact of wind and solar energy fluctuations.Multiple types of system components,including demand response service entities,converter stations,DC transmission systems,cascade hydropower stations,and other traditional components,have been extensively modeled.Moreover,energy storage systems are considered to improve the accommodation level of renewable energy and alleviate the influence of intermittence.Demand-response service entities from the load side are used to reduce and move the demand during peak load periods.The uncertainties in wind,solar energy,and loads were simulated using stochastic programming.Finally,the effectiveness of the proposed model is verified through numerical simulations.