新高考背景下提高信息技术中Excel题得分率的方法探究

浙江省高考改革后,选考学考分卷考试,信息技术选考中VB程序部分比例提高,大大增加了试卷的难度。但在这种情况下,大题仍保留了Excel题,相比较VB算法,这题的难度较低,较易拿满分。但从学生答题情况分析,依然有很多同学在这道题上失分,这对于想拿高分的同学来说就非常值得总结。因此,如何提高学生在Excel题上的得分率,甚至拿到满分,是一个值得探究的问题。文章从例题解析出发,以题型的解题技巧为突破,挖掘提高信息技术Excel题得分的方法。

Excel电子自动评分系统构建的研究与实现

本文主要阐述了如何利用Excel本身提供的各种功能,完成客观题答题卡的自动评分,并在安全性和答题者使用方便性方面提出自己的解决方法。

Use of Spreadsheets as an Introductory Tool for Solving Fluid-Structure Interaction Problem

A simple and intuitive manner for solving fluid-structure interaction problem has been developed using Microsoft Excel spreadsheets. By eliminating the need of previous knowledge of any programming language, the method appears as an interesting introduction to numerical solutions of partial differential equations, due to the direct and didactic way that it is developed. Proposed procedure enables the analysis of tridimensional geometries using the finite difference method and can be extended to other differential equations or boundary conditions. The author＇s objective in this paper is to develop a simple and reliable preliminary method for solving acoustic fluid-structure interaction problems with application to dam-reservoir interaction phenomena and also contribute in the educational growth for undergraduate students that are beginning research in such matter.

An Integrated Approach for Decision Support through Multi-objective Optimization with Application to an Ill-posed Design Problem

In the current scenario of global competition and short product life cycles, customer-defined satisfaction has attracted interest in artifact design. Accordingly, intelligent decision-making through multi-objective optimization has been proposed as an efficient method for human-centered manufacturing. However, previous vast researches on optimization have been mainly focused on optimization theory and optimization techniques and paid little interests on the process of problem formulation itself. In this paper, therefore, the authors present a total framework for supporting multi-objective decision making. Then, the authors try to solve the formulated multi-objective optimization problem that involves both qualitative and quantitative performance measures as a general consequence from the above procedure. Taking especially quality as a qualitative measure, the authors gave a new idea to evaluate the quality quantitatively. Additionally, to facilitate the portability of the proposed method in multidisciplinary decision-making environments, the authors implement the proposal algorithm in an Excel spreadsheet and validate the effectiveness of the approach through a case study.

Evaluation of an Examination in Biochemistry and Molecular Biology

This work was aimed at assessing one of the examinations applied to the students enrolled in courses of Biochemistry and Molecular Biology at the School of Medicine, UNAM. We analyzed a f＇mal examination in this subject. The test consisted of 80 multiple choice questions. The database was exported to Excel and then to the SPSS 16 statistical software for statistical analyses. The following techniques were used： （1） dificulty index （Pi）, （2） discrimination index （Di）, （3） discrimination coefficient （rpbis）, and （4） Cronbach＇s alpha. Those questions that complied with 3 of the 4 mentioned techniques were considered acceptable; of the 80 questions, only 25 were accepted corresponding to 31%. The topic with the largest number of accepted questions was Water and pH （75%）, and the topics without accepted questions were Bioenergetics and Hormones （0%）. It is recommended that the faculty members that elaborate multiple choice examinations must know the subject, and should have a formation in didactics and educational methodology.