Theoretical Analysis and Practical Reflection on the Role Conflict of Double-Qualified Teachers in University-Affiliated Hospitals

Taking role conflict as the starting point,this article examines and reflects on the development of clinical teachers.In the process of the occurrence,development,and resolution of role conflicts among clinical teachers,there are many hidden issues related to the development of clinical teachers.The development of clinical teacher teaching and role conflict management contain similar educational philosophies and practical issues.This study draws on classic theories and research achievements in the development of university teachers and conducts theoretical analysis and practical reflection on the development of clinical teachers in medical colleges from the perspective of role conflict in social psychology.Policy recommendations are proposed,including strengthening the construction of teaching systems at the hospital organizational environment level,enhancing the role identity and teacher beliefs of clinical teachers,promoting their teaching development and academic learning,and ensuring their normal teaching investment;promoting leadership support at the level of interpersonal interaction and leveraging the role of colleague support in alleviating role conflicts;enhancing individual teacher beliefs,teacher role learning,and role skills.

基于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并实现排版的任务。

Research misconduct in hospitals is spreading:A bibliometric analysis of retracted papers from Chinese university-affiliated hospitals

Purpose: The number of retracted papers from Chinese university-affiliated hospitals is increasing, which has raised much concern. The aim of this study is to analyze the retracted papers from university-affiliated hospitals in China’s mainland from 2000 to 2021. Design/methodology/approach: Data for 1,031 retracted papers were identified from the Web of Science Core collection database. The information of the hospitals involved was obtained from their official websites. We analyzed the chronological changes, journal distribution, discipline distribution and retraction reasons for the retracted papers. The grade and geographic locations of the hospitals involved were explored as well.Findings: We found a rapid increase in the number of retracted papers, while the retraction time interval is decreasing. The main reasons for retraction are plagiarism/self-plagiarism(n=255), invalid data/images/conclusions(n=212), fake peer review(n=175) and honesty error(n=163). The disciplines are mainly distributed in oncology(n=320), pharmacology & pharmacy(n=198) and research & experimental medicine(n=166). About 43.8% of the retracted papers were from hospitals affiliated with prestigious universities. Research limitations: This study fails to differentiate between retractions due to honest error and retractions due to research misconduct. We believe that there is a fundamental difference between honest error retractions and misconduct retractions. Another limitation is that authors of the retracted papers have not been analyzed in this study.Practical implications: This study provides a reference for addressing research misconduct in Chinese university-affiliated hospitals. It is our recommendation that universities and hospitals should educate all their staff about the basic norms of research integrity, punish authors of scientific misconduct retracted papers, and reform the unreasonable evaluation system.Originality/value: Based on the analysis of retracted papers, this study further analyzes the characteristics of institutions of retracted papers, which may deepen the research on retracted papers and provide a new perspective to understand the retraction phenomenon.

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颜色值中,从而能在实际应用场景中明确敏感文档传播链条,对文档泄露源头进行追踪溯源,定位泄密责任人,以减少信息泄露事件的发生。经实验对比发现,所提水印算法不可感知性好,对增加、删除、重新键入、格式刷、复制粘贴和另存为等多种常见文档操作和攻击具有很强的鲁棒性,同时支持多层水印嵌入。与其他基于文档格式的水印算法相比,所提算法具有更好的水印不可见性、更强的鲁棒性和更宽广的应用范围。

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.

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.

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

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

高变异药物等效性评估方法在Excel中的实现

目的:使用Excel建立一种简易高效的高变异药物生物等效性评估方法。方法:利用Excel内置的统计分析函数,对数据进行单因素方差分析、90%置信区间、单侧95%置信区间上限等统计学检验。结果:基于Excel进行高变异药物的生物等效性检验,其得出的结果个体内变异系数、90%置信区间和单侧95%置信区间上限与Phoenix WinNonlin结果一致。结论:高变异药物等效性评估方法在Excel中可以实现,且整个数据处理过程高效快捷、结果可靠,是处理高变异药物生物等效性试验数据的一种理想方法。

基于Excel的电子天平校准研究与应用

随着电子天平新版检定规程的发布实施,很多电子天平将以校准证书的形式出现。本文通过Excel中函数和VBA的功能,通过按照JJF 1847—2020《电子天平校准规范》附录A中的电子天平测量结果的不确定度评定公式进行计算,采用混合编程解决了电子天平校准的原始记录和证书生成问题。

Research on Coupling Chinese Excellent Traditional Culture and Ideological and Political Course to Educate People

As a great country with a long civilization of more than 5,000 years,China has developed both inheritance and innovation during its long history.In the changing times,the Chinese nation,with its indestructible stance,has continuously condensed its fine traditional culture and formed the spirit of our nation through the wash of time.The article discusses the importance of combining the excellent Chinese traditional culture with ideological and political course,the dilemmas faced and the countermeasures to cope with them,in order to promote the inheritance and development of China’s excellent traditional culture and make suggestions for students to better learn and carry forward the excellent traditional culture.

基于Excel VBA的入侵告警数据处理方法与实现

在对周界入侵告警系统指标评判需求和告警记录特点进行深入分析的基础上,利用Excel VBA设计并实现了告警记录聚类、入侵事件关联、干扰事件关联等功能。通过对已知信息数据的综合分析处理,成功实现了对周界入侵告警系统漏报率、误报率、响应时间、定位精度等指标参数的快速计算。研究结果表明,基于Excel VBA的数据处理方法能够准确且迅速地完成告警记录信息的分析处理,满足周界入侵系统指标评判的需求,极大地提升了工作效率。

Excel开发工具在调查问卷中的应用研究

采用Excel办公软件及其内置的开发工具,实践得出一种调查问卷设计及答案自动汇总的方法,在不宜使用网络问卷工具的情况下,该方法可作为替代解决方案。

基于Office Open XML的Excel操作题自动阅卷系统的实现

Excel操作题自动阅卷系统的设计往往采用RTF、VBA方式,但效果并不理想,针对这种情况提出了一种基于Office Open XML格式和Python语言,使用开源库Openpyxl、Element Tree及自编类解析Excel文件的操作题自动阅卷评分系统的方法,总结了Office Open XML格式的Spread sheet ML标记语言的常用标记及作用,其次设计了自动阅卷流程,细化为格式解析、格式保存和格式对比量化评分三个阶段,并将格式解析分解为Openpyx l解析、Element Tree解析两个步骤,解决了解析中容错的自定义问题。经过测试,使用该方法能可靠地实现Excel 2010版本操作题的自动阅卷。

基于Excel VBA的微信公众号图片爬取技术研究

微信已成国民级应用,而微信公众号更是为数众多。作为Microsoft Office办公软件核心应用程序之一的Excel,由于与VBA天然无缝对接,在特定场景下具有很好的应用能力。本研究设计一个基于Excel VBA的微信公众号图片爬取框架,主要使用技术为VBscript的RegExp对象(正则表达式)和XMLHTTP对象等。研究认为Excel VBA爬取微信公众号图片胜在即开、即用、快捷、方便、高效、稳定。