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℃时花粉活性最强。研究发现,木棉雄蕊长短变化可能有利于不同传粉生物传粉效率提高和增强适应性;木棉高层雄蕊花药个体大、花粉数量多、活性高,适应干热河谷传粉繁殖条件;温度较低时,底层花药花粉活力相对较高,可为逆境环境下木棉高层花药受损后提供后备花粉源。文章就木棉花部形态与繁殖关系、木棉形态及花粉活力对繁殖的影响进行讨论。     

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复合污染对植物影响和损害的研究热点,进而探明植物重金属胁迫的生理响应机制。     

皖北石灰岩山地不同植被恢复模式对植物群落物种组成及多样性的影响

通过研究皖北石灰岩山地生态系统的植被群落,分析不同植被恢复群落的组成、结构、多样性和生活型组成,进而阐明石灰岩山地生态系统植被恢复模式对群落结构特征以及植物物种多样性的影响。结果表明:研究区有54种植物,隶属26科54属。侧柏(Platycladus orientalis)+构树(Broussonetia papyrifera)人工混交林有植物种类16科26种,分别占总数的61.5%和48.1%。酸枣(Ziziphus jujuba var.spinosa)+牡荆(Vitex negundo var.cannabifolia)灌丛和荩草(Arthraxon hispidus)+牡荆草灌丛植物种类分别为32和33种,分别占调查总物种数的59.3%和61.1%。不同植被恢复群落生活型也有差异。侧柏+构树人工混交林群落高位芽植物占优势,而酸枣+牡荆灌丛和荩草+牡荆草灌丛则以地面芽植物所占比例较大。分析表明,多样性指数、均匀度指数和优势度指数均表现为侧柏+构树混交林>酸枣+牡荆灌丛>荩草+牡荆草灌丛,但物种丰富度表现为荩草+牡荆草灌丛>酸枣+牡荆灌丛>侧柏+构树混交林。Sörensen较高值出现在酸枣+牡荆灌丛与侧柏+构树混交林和荩草+牡荆草灌丛之间,侧柏+构树混交林与荩草+牡荆草灌丛Sörensen多样性值较低。研究结果表明,石灰岩山地独特的地貌特征和人工植被恢复对植物群落组成、多样性及其生活型组成产生重要影响。