Excel应用于方差分析的实训教学探究

针对国内应用型本科湖南文理学院院校概率统计课程的实训教学越来越多地注重Excel作为初学者操作平台的现状,就非平衡数据和嵌套结构的数据在Excel中实现方差分析的过程进行探究。突出以组内矫正数为主线整理数据后简化平方和分解公式的理念,使得Excel中进行方差分析时,数据整理流程完全格式化,平方和的分解步骤更为简洁,自由度分解、F检验等步骤不再繁琐,为非统计专业本科阶段借助Excel电子表格率先实现概率统计课程实训教学的宽口径模式提供借鉴。     

Associations of fish with various types of littoral habitats in reservoirs

Fish associations with different types of littoral habitats were studied in four canyon‐shaped reservoirs in the Czech Republic in years 2010 and 2011 by gillnets. Two to three habitats per reservoir–beaches (former meadows), stump fields (former forest) and rubble slopes–were defined and sampled along the longitudinal axis of reservoirs. Effects of reservoir, habitat and locality (position along longitudinal axis) on fish biomass, abundance and species structure were tested for juvenile and adult fish separately. Hierarchical analysis of variance revealed that habitats differed significantly in fish biomass and abundance. Redundancy analysis showed that analysed environmental variables had significant influence on fish community structure. Most variability in community structure was explained by reservoir and then by combination of habitat and slope steepness. Locality position had the smallest influence on community structure. For both adult and juvenile fish total abundance and biomass, the most inhabited habitat was beaches; rubble slopes were the least inhabited. Habitat associations differed among species. Among adults, bream Abramis brama, white bream Blicca bjoerkna and roach Rutilus rutilus were associated with beaches and stump fields, whereas perch Perca fluviatilis, ruffe Gymnocephalus cernuus, asp Aspius aspius and pike Esox lucius were associated with rubble slopes. Bream, white bream, bleak Alburnus alburnus, roach, ruffe and pikeperch Sander lucioperca were associated with beaches among juveniles, whereas the only juvenile associated with rubble slopes was perch. We showed that most common species are associated with distinct habitats and also that utilisation of various littoral habitats differs in general.     

Effects of Rice Variety and Growth Location in Cambodia on Grain Composition and Starch Structure简

The effects of variety and growth location on grain composition and starch structures were investigated using three rice (Oryza sativa L.) cultivars (Phka Romduol, Sen Pidao and IR66) with different amylose contents. All the three cultivars were planted in three different agro-climatic zones (Phnom Penh, Coastal and Plateau) of Cambodia. The protein content of polished grains increased when rice was planted at a location with higher average temperature, but their lipid content decreased. The amylose content and degree of branching were not greatly affected by the minor temperature differences among the growing locations. Starch fine structures characterized by the chain-length distribution were significantly different among the cultivars, but not significantly among different locations. The results suggested that protein and lipid biosyntheses were more sensitive to the environmental temperature than that of starch in rice grains.     

C语言在线评价与测试系统的开发与探讨

随着网络教育的发展,接受网络教育和考试认证的人越来越多,在线考试正在得以迅速发展.本文简要介绍在线系统工作原理和系统配置.     

木棉雄蕊特征与其繁殖策略的关系分析

采用野外观察和实验室检测方法,对云南省个旧市冷墩村的木棉花部结构、雄蕊特征、花粉活性进行研究。结果表明,自然种群中花部形态特征具有一定变异性,3层雄蕊变异系数大小关系显著。在湿度为60%、温度为35℃时花粉活性最强。研究发现,木棉雄蕊长短变化可能有利于不同传粉生物传粉效率提高和增强适应性;木棉高层雄蕊花药个体大、花粉数量多、活性高,适应干热河谷传粉繁殖条件;温度较低时,底层花药花粉活力相对较高,可为逆境环境下木棉高层花药受损后提供后备花粉源。文章就木棉花部形态与繁殖关系、木棉形态及花粉活力对繁殖的影响进行讨论。     

Soil physical changes and maize growth in a structurally fragile tropical soil due to mulching and duration between irrigation intervals

Under tropical meteorological conditions, the volume of soil explored by plant roots is crucial for crop growth as it allows increased water and nutrient use efficiency. We hypothesized that, under different irrigation intervals, leguminous mulch can extend the duration between irrigation events but maintain crop performance, because decreased evaporative fluxes also reduce constraints to root exploration imposed by mechanical stress. We evaluated the combined effects of leguminous mulch and irrigation intervals on soil physical properties to determine whether the growth and productivity of maize were modified in a structurally fragile tropical soil. The experiment involved the following treatments: 4‐day irrigation intervals with soil mulched (4C) or bare (4S), 6‐day irrigation intervals with soil mulched (6C) or bare (6S), 8‐day irrigation intervals with soil mulched (8C) or bare (8S) and 10‐day irrigation intervals with soil mulched (10C) or bare (10S). Mulch decreased soil penetration resistance and increased to 4 days the favourable time for root development in drying soil. Relative to bare soil, mulch with a 6‐day irrigation interval almost doubled nitrogen uptake post‐tasselling, which decreased nitrogen remobilization and increased the crop growth rate during this stage. These conditions had a positive effect on the transpiration rate and stomatal conductance as well as on the growth and yield of maize. A 6‐day irrigation interval with mulch compared to 4 days with bare soil resulted in similar conditions for root development, but greater uptake of nitrogen (102.73–78.70 kg/ha) and better yield (6.2–5.3 t/ha), which means greater efficiency in nitrogen and water use.     

2CZD-1型段茎式甘蔗种植机设计与试验

研制了2CZD-1型段茎式甘蔗种植机,可一次性完成甘蔗种植的开沟、施肥、自动取种、自动排种、覆土和覆膜等工序,适用于宽窄行甘蔗种植。设计了机架、取送种机构、转盘施肥机构、旋耕覆土机构、覆膜机构和液压传动系统等结构,其中取送种机构采用排冗结构实现均匀排种。利用有限元分析软件ANSYS对甘蔗种植机的机架进行模态分析,并通过田间试验获得甘蔗种植机的覆土厚度合格率、种植密度、伤芽率、漏植率及总排肥量稳定性变异系数等性能参数。模拟结果表明,当激励频率为8~80 Hz时,机架容易发生共振,且最大位移可达28.12 mm。田间试验表明,该种植机的种植密度为142325芽/hm^2,覆土厚度合格率为93.6%,伤芽率为2.8%,漏植率为4.7%,种植深度合格率为89.3%,总排肥量稳定性变异系数为5.8%,工作生产率为0.32 hm2/h,符合甘蔗种植机的设计要求,能够显著提高甘蔗种植的效率。     

The Evolution Characteristics of Spatial Layout of Ancient Chinese Capitals: A Case Study of Sui,Tang and Northern Song Dynasties With Important Changes in the Historical Development of Feudal Society

Imperial city and outer city are the most important differentiation of the spatial structure of ancient Chinese capitals.The relationship between city and Guo changed from the original spatial structure mode of "respecting the west" and "sitting in the west and facing the east" to the spatial structure mode of "sitting in the north and facing the south" and the three outer cities in the east,south and west surrounding the imperial city after the Wei,Jin,Southern and Northern Dynasties,and gradually changed from the original "multi palace" system to the "single palace" system.Finally,a "heavy city" capital spatial structure with the outer city around the imperial city and the imperial city around the palace city,and the central axis of the chessboard format was formed.During the Tang and Song Dynasties,it was a period of great change in the history of feudal society in China.Through the investigation of the evolution characteristics of the spatial form of capital cities in the Tang and Song Dynasties,the track of the transformation of social ideology,political system,economic structure and many other fields in the Tang and Song Dynasties was made clear.     

重金属Cd、Pb复合污染对植物生理生化和细胞结构影响的研究进展

我国受重金属污染的土地面积广大,因采矿等造成的环境和土壤重金属污染问题日趋严重。因金属矿床形成特点及开采方式单一等原因,造成Cd、Pb居于重金属复合污染前列。通过总结单一Cd、Pb污染对植物生理生化特征的影响以及Cd、Pb复合污染对植物生理生化及细胞结构的影响等研究进展,明晰土壤重金属Cd、Pb复合污染对植物影响和损害的研究热点,进而探明植物重金属胁迫的生理响应机制。     

苹小卷叶蛾在6个苹果品种上的发育与繁殖

为探索不同品种苹果对苹小卷叶蛾生长发育和繁殖的影响,在温度(26±1)℃、相对湿度(80±5)%、光周期L∶D=16 h∶8 h的室内条件下,测定了苹小卷叶蛾在小国光、大国光、红玉、祝光、红星和金帅上的发育历期、存活率和产卵量,并组建了其各自的生命周期表。结果显示,苹小卷叶蛾在6个品种上的发育历期差异显著,全世代发育历期以小国光最短(33.95 d),以红玉最长(39.76 d);平均单雌产卵量以红玉最高(107.24粒),小国光次之(85.00粒);而存活率则无显著差异。生命表参数中净生殖率(R0)、内禀增长率(rm)和周限增长率(λ)均以小国光最高,世代平均周期(T)和种群加倍时间(Dt)以小国光最短,表明6种试验品种中小国光是苹小卷叶蛾最适宜的寄主品种。