基于VBA的Excel与SQL Server数据通信的应用

针对现代高校教务管理上网无纸化工作的要求,介绍了用Excel VBA编程技术,在Excel中访问服务器端SQL Server数据库中数据的方法,并设计实现一个基于通用的高校远程事务管理系统实例,解决了高校教务管理环节中存在的难题.该系统实现成本低、通用性强、操作简单.     

浅谈Excel函数在高校教务管理中的应用

在学校教务处学生成绩、教材征订、教学手册等整理统计工作中，时常会用到电子表格Excel。根据多年的教务管理经验，本文给出了Excel在高校教务管理中常用的几个应用技巧。     

EXCEL VBA在高校教务管理中的应用

高等院校管理工作的核心是教务管理。教务工作能否准确、快速地完成直接影响着学校的教育教学质量,关系着整个学校培养人才目标的实现。由于拥有强大的函数系统,Excel软件在教务工作中得到了广泛的应用,极大提高了教务工作效率。但对于纷繁复杂的教务工作,Excel函数并不能提供完善的解决方案。针对该问题,本文提出了针对教务员的利用Visual Basic for Application(VBA)实现复杂Excel表格统计运算的方法,方便广大教务员进一步提高工作效率。     

EXCEL VBA在高校教务管理中的应用

高等院校管理工作的核心是教务管理。教务工作能否准确、快速地完成直接影响着学校的教育教学质量,关系着整个学校培养人才目标的实现。由于拥有强大的函数系统,Excel软件在教务工作中得到了广泛的应用,极大提高了教务工作效率。但对于纷繁复杂的教务工作,Excel函数并不能提供完善的解决方案。针对该问题,本文提出了针对教务员的利用Visual Basic for Ap-plication（VBA）实现复杂Excel表格统计运算的方法,方便广大教务员进一步提高工作效率。     

基于VBA的试卷分析系统研究

针对目前高校试卷分析系统使用不便,可操作性差,文中提出在Excel中嵌入使用VBA编程的方法,配合高校教务管理系统,实现在Excel中自动进行试卷分析。结果表明,该系统能够对较通用的Excel格式成绩文件自动地进行综合分析,直观、形象地输出分析结果;通用性好,可操作性强。     

基于Excel和Access的学生成绩单设计与实现

针对高校教务管理工作运用Excel对成绩数据进行统计、整理,保证成绩的及时性、准确性和完整性。然后,利用Access较强的数据库管理功能和不用编程的优势,对成绩进行管理和输出。主要功能包含成绩查询,成绩单的设计、打印输出,具有易实现,易上手的特点。实现快速、准确、高效的成绩管理,并能依托成绩系统开展相关工作,方便师生,促进教学教务管理。     

自动化网上登分的实现

为了提高高校教务部门普遍采用的网上登分的工作效率,本文通过分析研究在Windows操作系统中,外部程序操纵IE浏览器、访问Excel的方法,提出了把Excel中数据按关键字对应,自动导入特定登分网页的程序实现方法,实现了网上登分的自动化、智能化。     

高校教务管理系统数据仓库的设计与实现

高校教务管理信息化以来,各高校相继建立了基于联机事务处理的教务管理系统,如何在现有的教务管理系统基础上建立起教务管理数据仓库,充分挖掘有价值的信息成为学者们研究的重点,文章从数据仓库体系结构、模型设计、主题划分、数据加载和联机分析实现的角度对高校教务管理数据仓库的设计与实现进行了探讨,旨在探索高校教务数据仓库的方法与途径。     

毕业生成绩单生成软件的开发与应用

教务管理系统是高校必不可少的教学管理软件,随着需求的提升教务管理系统也在不断地升级改造;因新旧系统数据库的兼容性问题而存在的安全隐患,过渡期间一些高校同时有两套教务管理系统在运行,两个系统中的成绩如何生成一张完整的毕业生成绩单就成了问题。利用VBA编程手段把从新旧系统中导出的Excel成绩表自动生成每个学生按学期分布的毕业生成绩单,大大减轻了教务人员的工作负担。文中介绍了有关方法和技术,以对遇到相同或相近问题的读者有所启示。     

基于构件的软件复用在高校教务管理系统中的实现

高校教务管理系统是在校园网络环境下实现的对学分制教务进行计算机管理的集成系统。在高校信息化程度飞速发展的时代,有必要开发一个功能较为全面的高校教务管理系统。该文在阐述了基于构件的软件复用技术,利用软构件技术设计开发了一套高效的教务管理系统,最终实现了高校教务管理的科学化、规范化和信息化。     

Only connect: teaching, technology and telesis

Abstract This paper describes an approach to the design of interactive multimedia materials being developed in a European Community project. The developmental process is seen as a dialogue between technologists and teachers. This dialogue is often problematic because of the differences in training, experience and culture between them. Conditions needed for fruitful dialogue are described and the generic model for learning design used in the project is explained.     

European Community policy and the market

Abstract This paper starts with some reflections on the policy considerations and priorities which are shaping European Commission (EC) research programmes. Then it attempts to position the current projects which seek to capitalise on information and communications technologies for learning in relation to these priorities and the apparent realities of the marketplace. It concludes that while there are grounds to be optimistic about the contribution EC programmes can make to the efficiency and standard of education and training, they are still too technology driven.     

一种自适应子融合集成多分类器方法

融合集成方法已经广泛应用在模式识别领域,然而一些基分类器实时性能稳定性较差,导致多分类器融合性能差,针对上述问题本文提出了一种新的基于多分类器的子融合集成分类器系统。该方法考虑在度量层融合层次之上通过对各类基多分类器进行动态选择,票数最多的类别作为融合系统中对特征向量识别的类别,构成一种新的自适应子融合集成分类器方法。实验表明,该方法比传统的分类器以及分类融合方法识别准确率明显更高,具有更好的鲁棒性。     

Avoiding semantic and temporal gaps in developing software intensive systems

Development of software intensive systems (systems) in practice involves a series of self-contained phases for the lifecycle of a system. Semantic and temporal gaps, which occur among phases and among developer disciplines within and across phases, hinder the ongoing development of a system because of the interdependencies among phases and among disciplines. Such gaps are magnified among systems that are developed at different times by different development teams, which may limit reuse of artifacts of systems development and interoperability among the systems. This article discusses such gaps and a systems development process for avoiding them.     

Designing economic np control charts: A programmed simulation approach

This paper presents control charts models and the necessary simulation software for the location of economic values of the control parameters. The simulation program is written in FORTRAN, requires only 10K of main storage, and can run on most mini and micro computers. Two models are presented - one describes the process when it is operating at full capacity and the other when the process is operating under capacity. The models allow the product quality to deteriorate to a further level before an existing out-of-control state is detected, and they can also be used in situations where no prior knowledge exists of the out-of-control causes and the resulting proportion defectives.     

The development of robot art

Going through a few examples of robot artists who are recognized worldwide, we try to analyze the deepest meaning of what is called “robot art” and the related art field definition. We also try to highlight its well-marked borders, such as kinetic sculptures, kinetic art, cyber art, and cyberpunk. A brief excursion into the importance of the context, the message, and its semiotics is also provided, case by case, together with a few hints on the history of this discipline in the light of an artistic perspective. Therefore, the aim of this article is to try to summarize the main characteristics that might classify robot art as a unique and innovative discipline, and to track down some of the principles by which a robotic artifact can or cannot be considered an art piece in terms of social, cultural, and strictly artistic interest. This work was presented in part at the 13th International Symposium on Artificial Life and Robotics, Oita, Japan, January 31–February 2, 2008     

Explanation and prediction: an architecture for default and abductive reasoning

Although there are many arguments that logic is an appropriate tool for artificial intelligence, there has been a perceived problem with the monotonicity of classical logic. This paper elaborates on the idea that reasoning should be viewed as theory formation where logic tells us the consequences of our assumptions. The two activities of predicting what is expected to be true and explaining observations are considered in a simple theory formation framework. Properties of each activity are discussed, along with a number of proposals as to what should be predicted or accepted as reasonable explanations. An architecture is proposed to combine explanation and prediction into one coherent framework. Algorithms used to implement the system as well as examples from a running implementation are given.     

Three Process Perspectives: Organizations, Teams, and People

This paper provides the author's personal views and perspectives on software process improvement. Starting with his first work on technology assessment in IBM over 20 years ago, Watts Humphrey describes the process improvement work he has been directly involved in. This includes the development of the early process assessment methods, the original design of the CMM, and the introduction of the Personal Software Process (PSP)^SM and Team Software Process (TSP){^SM}. In addition to describing the original motivation for this work, the author also reviews many of the problems he and his associates encountered and why they solved them the way they did. He also comments on the outstanding issues and likely directions for future work. Finally, this work has built on the experiences and contributions of many people. Mr. Humphrey only describes work that he was personally involved in and he names many of the key contributors. However, so many people have been involved in this work that a full list of the important participants would be impractical.     

基于复小波噪声方差显著修正的SAR图像去噪

提出了一种基于复小波域统计建模与噪声方差估计显著性修正相结合的合成孔径雷达(Synthetic Aperture Radar,SAR)图像斑点噪声滤波方法。该方法首先通过对数变换将乘性噪声模型转化为加性噪声模型,然后对变换后的图像进行双树复小波变换(Dualtree Complex Wavelet Transform,DCWT),并对复数小波系数的统计分布进行建模。在此先验分布的基础上,通过运用贝叶斯估计方法从含噪系数中恢复原始系数,达到滤除噪声的目的。实验结果表明该方法在去除噪声的同时保留了图像的细节信息,取得了很好的降噪效果。     

How do children do mathematics with LOGO?

Abstract  This paper considers some results of a study designed to investigate the kinds of mathematical activity undertaken by children (aged between 8 and 11) as they learned to program in LOGO. A model of learning modes is proposed, which attempts to describe the ways in which children used and acquired understanding of the programming/mathematical concepts involved. The remainder of the paper is concerned with discussing the validity and limitations of the model, and its implications for further research and curriculum development.