Building Custom Spreadsheet Functions with Python: End-User Software Engineering Approach

End-user computing empowers non-developers to manage data and applications, enhancing collaboration and efficiency. Spreadsheets, a prime example of end-user programming environments widely used in business for data analysis. However, Excel functionalities have limits compared to dedicated programming languages. This paper addresses this gap by proposing a prototype for integrating Python’s capabilities into Excel through on-premises desktop to build custom spreadsheet functions with Python. This approach overcomes potential latency issues associated with cloud-based solutions. This prototype utilizes Excel-DNA and IronPython. Excel-DNA allows creating custom Python functions that seamlessly integrate with Excel’s calculation engine. IronPython enables the execution of these Python (CSFs) directly within Excel. C# and VSTO add-ins form the core components, facilitating communication between Python and Excel. This approach empowers users with a potentially open-ended set of Python (CSFs) for tasks like mathematical calculations, statistical analysis, and even predictive modeling, all within the familiar Excel interface. This prototype demonstrates smooth integration, allowing users to call Python (CSFs) just like standard Excel functions. This research contributes to enhancing spreadsheet capabilities for end-user programmers by leveraging Python’s power within Excel. Future research could explore expanding data analysis capabilities by expanding the (CSFs) functions for complex calculations, statistical analysis, data manipulation, and even external library integration. The possibility of integrating machine learning models through the (CSFs) functions within the familiar Excel environment.

Construction and Reflection of Software Engineering Major Based on Accreditation Board for Engineering and Technology (ABET) Certification

With the rapid development of information technology,the demand for talents in the field of software engineering is growing.In order to cultivate high-quality software engineering talents who meet the market demand,universities have continuously carried out the construction of software engineering majors.Accreditation Board for Engineering and Technology(ABET)certification,as an internationally recognized higher education quality assurance system,provides important reference and guidance for the construction of software engineering majors.Guided by student learning outcomes and core competencies,combined with the characteristics of software engineering talent cultivation,the innovation of talent cultivation mode takes industry-education integration and school-enterprise cooperation as the main development paths and explores comprehensive reform of the major in terms of professional positioning and goals,curriculum system,teaching conditions,and teachers.This comprehensive reform model has effectively promoted the development of major construction and improved the quality of talent cultivation.

Research on the Cultivation of Innovative Talents in Software Engineering Based on the OBE Concept

Under the background of New Engineering,focusing on talent cultivation,this article explores the teaching reform and innovation of software engineering majors.Starting from the goal of cultivating software engineering talents in the context of New Engineering,the concept of outcome-based education is introduced to study and explore the construction of innovative talent training models for software engineering majors in universities.Through recent years’application practice,initial results have been achieved,which can provide feasible methods and ideas for the cultivation of innovative talents in other majors.

Construction and Innovation of Comprehensive Evaluation Means of PBL+OBE-based Software Engineering Practical Courses

Software engineering is an engineering discipline that guides software developers to carry out software development,software maintenance,and software management.The traditional evaluation methods of software engineering courses do not highlight the training goal of outcomebased education(OBE).This paper systematically studies the evaluation methods for practical courses in software engineering from three aspects:course evaluation guidelines,course evaluation methods and course evaluation effects;establishes a comprehensive,scientific,and objective system of course evaluation;effectively measures students’learning effect;promotes teachers to continuously improve the teaching process;and thus improves the teaching quality of software engineering courses.Besides the general approach,this paper also takes software project construction practice as an example to demonstrate the effect of the proposed approach.

Research and Design of Consistent Project Cases for the Software Engineering Course Group

In order to enhance the abilities of practical innovation and solving complex engineering problems of students in the engineering context,we design a course cluster teaching model based on a unified enterprise-level project case.The program divides the knowledge points required by the project into the corresponding courses,and divides their realization into the practical teaching cases,so as to realize the design of teaching practice cases embodied in the unified project framework.This model allows students to practice projects based on the unified project background while learning knowledge from different courses.It not only allows students to learn abstract,fragmented,and difficult-to-understand knowledge systems thoroughly,but also integrates the knowledge into the practice of the enterprise-level project development,helping students experience the value of knowledge in complex engineering projects and thus improving their ability to solve complex engineering problems while learning theoretical knowledge.

Teaching Reform and Practice of Software Engineering Graduate Students by Implanting Scientific Research Literacy into Classroom Teaching Content

How to cultivate and improve graduate students’innovation and practical abilities in software engineering through the curriculum and teaching mode reform is an important issue.In this paper,a research literacy-driven teaching mode is proposed.It assists in the reform of the curriculum system.Then,a curriculum system construction framework is proposed,which involves the integration of research literacy into classroom teaching content.It assists in the cultivation of research abilities of graduate students in software engineering.The effectiveness of the curriculum reform is demonstrated through questionnaire surveys and research outcomes of the project team.The results show that the methods explored in this paper can serve as valuable references for future course design and teaching practice in computer-related courses for graduates.

How to Effectively Apply ChatGPT in Software Engineering Education?——A Perspective from Undergraduate Students

As a highly advanced conversational AI chatbot trained on extensive datasets,ChatGPT has garnered significant attention across various domains,including academia,industry,and education.In the field of education,existing studies primarily focus on 2 areas:Assessing the potential utility of ChatGPT in education by examining its capabilities and limitations;exploring the educational scenarios that could benefit from the integration of ChatGPT.In contrast to these studies,we conduct a user survey targeting undergraduate students specializing in Software Engineering,aiming to gain insights into their perceptions,challenges,and expectations regarding the utilization of ChatGPT.Based on the results of the survey,we provide valuable guidance on the effective incorporation of ChatGPT in the realm of software engineering education.

Meta-SEE:Intelligent and Interactive Learning Framework for Software Engineering Education Based on Metaverse and Metacognition

With the rapid evolution of technology and the increasing complexity of software systems,there is a growing demand for effective educational approaches that empower learners to acquire and apply software engineering skills in practical contexts.This paper presents an intelligent and interactive learning(Meta-SEE)framework for software engineering education that combines the immersive capabilities of the metaverse with the cognitive processes of metacognition,to create an interactive and engaging learning environment.In the Meta-SEE framework,learners are immersed in a virtual world where they can collaboratively engage with concepts and practices of software engineering.Through the integration of metacognitive strategies,learners are empowered to monitor,regulate,and adapt their learning processes.By incorporating metacognition within the metaverse,learners gain a deeper understanding of their own thinking processes and become self-directed learners.In addition,MetaSEE has the potential to revolutionize software engineering education by offering a dynamic,immersive,and personalized learning experience.It allows learners to engage in realistic software development scenarios,explore complex systems,and collaborate with peers and instructors in virtual spaces.

Teaching Reform Based on the Competency Model for Software Engineering-related Courses

This paper explores the reform and practice of software engineering-related courses based on the competency model of the Computing Curricula,and proposes some measures of teaching reform and talent cultivation in software engineering.The teaching reform emphasizes student-centered education,and focuses on the cultivation and enhancement of students’knowledge,skills,and dispositions.Based on the three elements of the competency model,specific measures of teaching reform are proposed for some professional courses in software engineering,to strengthen course relevance,improve knowledge systems,reform practical modes with a focus on skill development,and cultivate good dispositions through student-centered education.The teaching reform’s attempts and practice are conducted in some courses such as Advanced Web Technologies,Software Engineering,and Intelligent Terminal Systems and Application Development.Through the analysis and comparison of the implementation effects,significant improvements are observed in teaching effectiveness,students’mastery of knowledge and skills are noticeably improved,and the expected goals of the teaching reform are achieved.

Research and Practice on the Multi-dimensional Course Goal Achievement Evaluation of Software Engineering

According to the standards of engineering education accreditation,the achievement paths and evaluation criteria of course goals are presented,aimed at the objectives of software engineering courses and the characteristics of hybrid teaching in Kunming University of Science and Technology.Then a multi-dimensional evaluation system for course goal achievement of software engineering is proposed.The practice’s results show that the multi-dimensional course goal achievement evaluation is helpful to the continuous improvement of course teaching,which can effectively support the evaluation of graduation outcomes.

A New Model of Software Engineering Education and Exploration of Professional Curriculum Teaching

This paper focuses on the problems,opportunities,and challenges faced by software engineering education in the new era.We have studied the core ideas of the new model and reform,the specific measures implemented,and the challenges and solutions faced.The new model and reform must focus on cultivating practical abilities,introducing interdisciplinary knowledge,and strengthening innovation awareness and entrepreneurial spirit.The process of reform and innovation is carried out from the aspects of teaching methods,teaching means,and course performance evaluation in the teaching practice of software engineering courses.We adopt a method of“question guiding,simple and easy to understand,flexible and diverse,and emphasizing practical results”,optimizing the curriculum design,providing diverse learning opportunities,and establishing a platform for the industry-university-research cooperation.Our teaching philosophy is to adhere to the viewpoint of innovative teaching ideas,optimizing teaching methods and teaching means,and comprehensively improving the teaching quality and level of software engineering education.

Static Analysis Techniques for Fixing Software Defects in MPI-Based Parallel Programs

The Message Passing Interface (MPI) is a widely accepted standard for parallel computing on distributed memorysystems.However, MPI implementations can contain defects that impact the reliability and performance of parallelapplications. Detecting and correcting these defects is crucial, yet there is a lack of published models specificallydesigned for correctingMPI defects. To address this, we propose a model for detecting and correcting MPI defects(DC_MPI), which aims to detect and correct defects in various types of MPI communication, including blockingpoint-to-point (BPTP), nonblocking point-to-point (NBPTP), and collective communication (CC). The defectsaddressed by the DC_MPI model include illegal MPI calls, deadlocks (DL), race conditions (RC), and messagemismatches (MM). To assess the effectiveness of the DC_MPI model, we performed experiments on a datasetconsisting of 40 MPI codes. The results indicate that the model achieved a detection rate of 37 out of 40 codes,resulting in an overall detection accuracy of 92.5%. Additionally, the execution duration of the DC_MPI modelranged from 0.81 to 1.36 s. These findings show that the DC_MPI model is useful in detecting and correctingdefects in MPI implementations, thereby enhancing the reliability and performance of parallel applications. TheDC_MPImodel fills an important research gap and provides a valuable tool for improving the quality ofMPI-basedparallel computing systems.

Remolding Software Engineering Course Based on Engineering Education Concepts

The core of the engineering education concepts is student-centered teaching,result-oriented teaching,and continuous improvement.It is necessary to carry out course remolding of software engineering course guided by engineering education concepts.This paper first analyzes the pain points of teaching the course of software engineering,and then introduces how to remold the course based on engineering education concepts,including reformulating the teaching objectives,teaching modes,and assessment methods.Through teaching practice,we find that the improved course has achieved a better teaching result,which reflects the advantages of the engineering education concepts.

Software Engineering Technology for the 21^(st) Century

In this paper we will discuss the software engineering technology for the 21 st century. First we review development over the last half century, overview application requirement and environment, accept a challenge. Then we outline following software engineering techniques: 1) Process;2) Analysis;3) Design;4) UML;5) Component;6) Java +XML;7) Integrated;8) Quality(ISO9000&CMM).

Construction and Practices of the Course of Software Process&Tools Oriented Certified in Engineering Education

In recent years,it is the general trend to adopt the standards of international engineering education certification to construct curriculum.“Software Process and Tools”is one of the core courses of Harbin Institute of Technology’s software engineering undergraduate training program.Focusing on the construction work and practical exploration of the course in the process of reforming the software engineering professional curriculum system,and how to achieve the standards of engineering education certification,This paper makes a review and summary.This paper focuses on the status and the role of the course in the whole curriculum system,as well as project-driven teaching content design and practical teaching methods.And summarizes the experience and results of 3 rounds of teaching practice.

Human Factors Analysis in Software Engineering

The general human factors analysis analyzes human functions, effects and influence in a system. But in a narrow sense, it analyzes human influence upon the reliability of a system, it includes traditional human reliability analysis, human error analysis, man-machine interface analysis, human character analysis, and others. A software development project in software engineering is successful or not to be completely determined by human factors. In this paper, we discuss the human factors intensions, declare the importance of human factors analysis for software engineering by listed some instances. At last, we probe preliminarily into the mentality that a practitioner in software engineering should possess. Key words human factors analysis - software engineering - software reliability CLC number TP 311.5 Foundation item: Supported by the National Natural Science Foundation of China (60173013)Biography: Xu Ren-zuo (1946-), male, Professor, research direction: software engineering, software reliability engineering, software safety and software testing.

Development and Experience of“Software Project Practice”Course for the Master of Software Engineering

Practice is an important phase in the teaching of software engineering.How to improve students' practical ability is a common problem for many software colleges.The course of Software Project Practice is proposed to enhance students' practical skills.In this course,the students participate in the whole process of software development practice and take the exercise of entrepreneurial project development in their learning stage.

Research and Exploration on the Construction of Double Qualified Teachers in Software Engineering

In order to solve the problem of insufficient integration of school-enterprise supervisors in the current school-enterprise cooperation model,this article introduces the ideas and results of the construction of a team with double-qualified instructors majored in software engineering.Specifically,the integration of production and education are carried out in three stages,i.e.,enterprise cooperation courses,enterprise internship,and graduation design(internship),by taking the software engineering major of the School of Information and Software Engineering of the University of Electronic Science and Technology of China as a case study.

The Exploration of Talent Cultivation in Software Engineering“ Internet Plus Finance”

With the rapid development of the Internet finance industry,society has put forward urgent needs for“Internet Plus finance”composite talents,and also put forward challenges to talent cultivation in colleges and universities.To cultivate the talents in the“Internet Plus finance”,the School of Information and Software Engineering of the University of Electronic Science and Technology of China(hereinafter“the School”)begins the 10 major measures,such as the construction of training programs,the construction of the curriculum system,the construction of the faculty team,and the construction of the practice base.Meanwhile,the School works together with banks,which have cooperated for a long time,to establish the talent cultivation system in the direction of“Internet Plus finance”in the software engineering major,solving the problem of interdisciplinary talent training in the field of software engineering and finance.

A Way to Build Software Culture: Distributed Object-Oriented Software Engineering over Internet

This paper focuses on Distributed Object Oriented Software Engineering over Internet, which is a way to build software culture. We believe that our work will contribute to better understanding of how to meet the needs of the big potential software market and to promote the software industry in developing country. The United States and Western Europe have well established software industry and related civilization. Software science, technology, and engineering are needed in China; however, maybe what is needed, first of all, is software civilization, including software ideas, customs, skills, arts, etc. We will draw a framework for the software culture as following: Software is the most important commodity in this age; Brilliance of hardware component era has become past fact; A software component era is ahead; Traditional linear process model is obsolete; Modern software engineering has a new face, object evolution model; Distributed object oriented software engineering over Internet is an approach to software component era; and Complete software civilization will be formed all over the world in next century.