Applications of Spreadsheets in Education : The Amazing Power of a Simple Tool

This e-book is devoted to the use of spreadsheets in the service of education in a broad spectrum of disciplines: science, mathematics, engineering, business, and general education. The effort is aimed at collecting the works of prominent researchers and educators that make use of spreadsheets as a means to communicate concepts with high educational value. The e-book brings some of the most recent applications of spreadsheets in education and research to the fore. To offer the reader a broad overview of the diversity of applications, carefully chosen articles from engineering (power systems and control), mathematics (calculus, differential equations, and probability), science (physics and chemistry), and education are provided. Some of these applications make use of Visual Basic for Applications (VBA), a versatile computer language that further expands the functionality of spreadsheets. The material included in this e-book should inspire readers to devise their own applications and enhance their teaching and/or learning experience.

Creating flexible mappings between building information models and cost information

During the early design stages of construction projects, accurate and timely cost feedback is critical to design decision making. This is particularly challenging for cost estimators, as they must quickly and accurately estimate the cost of the building when the design is still incomplete and evolving. State-of-the-art software tools typically use a rule-based approach to generate detailed quantities from the design details present in a building model and relate them to the cost items in a cost estimating database. In this paper, we propose a generic approach for creating and maintaining a cost estimate using flexible mappings between a building model and a cost estimate. The approach uses queries on the building design that are used to populate views, and each view is then associated with one or more cost items. The benefit of this approach is that the flexibility of modern query languages allows the estimator to encode a broad variety of relationships between the design and estimate. It also avoids the use of a common standard to which both designers and estimators must conform, allowing the estimator added flexibility and functionality to their work.

Plasma nanoscience : from nano-solids in plasmas to nano-plasmas in solids

The unique plasma-specific features and physical phenomena in the organization of nanoscale soild-state systems in a broad range of elemental composition, structure, and dimensionality are critically reviewed. These effects lead to the possibility to localize and control energy and matter at nanoscales and to produce self-organized nano-solids with highly unusual and superior properties. A unifying conceptual framework based on the control of production, transport, and self-organization of precursor species is introduced and a variety of plasma-specific non-equilibrium and kinetics-driven phenomena across the many temporal and spatial scales is explained. When the plasma is localized to micrometer and nanometer dimensions, new emergent phenomena arise. The examples range from semiconducting quantum dots and nanowires, chirality control of single-walled carbon nanotubes, ultra-fine manipulation of graphenes, nano-diamond, and organic matter to nano-plasma effects and nano-plasmas of different states of matter. © 2013 Taylor and Francis Group, LLC.

Kinetics of low-pressure, low-temperature graphene growth : toward single-layer, single-crystalline structure

Graphene grown on metal catalysts with low carbon solubility is a highly competitive alternative to exfoliated and other forms of graphene, yet a single-layer, single-crystal structure remains a challenge because of the large number of randomly oriented nuclei that form grain boundaries when stitched together. A kinetic model of graphene nucleation and growth is developed to elucidate the effective controls of the graphene island density and surface coverage from the onset of nucleation to the full monolayer formation in low-pressure, low-temperature CVD. The model unprecedentedly involves the complete cycle of the elementary gas-phase and surface processes and shows a precise quantitative agreement with the recent low-energy electron diffraction measurements and also explains numerous parameter trends from a host of experimental reports. These agreements are demonstrated for a broad pressure range as well as different combinations of precursor gases and supporting catalysts. The critical role of hydrogen in controlling the graphene nucleation and monolayer formation is revealed and quantified. The model is generic and can be extended to even broader ranges of catalysts and precursor gases/pressures to enable the as yet elusive effective control of the crystalline structure and number of layers of graphene using the minimum amounts of matter and energy.

A vibrational spectroscopic study of the silicate mineral pectolite – NaCa2Si3O8(OH)

The mineral pectolite NaCa2Si3O8(OH) is a crystalline sodium calcium silicate which has the potential to be used in plaster boards and in other industrial applications. Raman bands at 974 and 1026 cm−1 are assigned to the SiO stretching vibrations of linked units of Si3O8 units. Raman bands at 974 and 998 cm−1 serve to identify Si3O8 units. The broad Raman band at around 936 cm−1 is attributed to hydroxyl deformation modes. Intense Raman band at 653 cm−1 is assigned to OSiO bending vibration. Intense Raman bands in the 2700–3000 cm−1 spectral range are assigned to OH stretching vibrations of the OH units in pectolite. Infrared spectra are in harmony with the Raman spectra. Raman spectroscopy with complimentary infrared spectroscopy enables the characterisation of the silicate mineral pectolite.

The molecular structure of the phosphate mineral kidwellite NaFe93+(PO4)6(OH)11⋅3H2O – a vibrational spectroscopic study

The mineral kidwellite, a hydrated hydroxy phosphate of ferric iron and sodium of approximate formula NaFe93+(PO4)6(OH)11⋅3H2O, has been studied using a combination of electron microscopy with EDX and vibrational spectroscopic techniques. Raman spectroscopy identifies an intense band at 978 cm−1 and 1014 cm−1. These bands are attributed to the PO43− ν1 symmetric stretching mode. The ν3 antisymmetric stretching modes are observed by a large number of Raman bands. The series of Raman bands at 1034, 1050, 1063, 1082, 1129, 1144 and 1188 cm−1 are attributed to the ν3 antisymmetric stretching bands of the PO43− and HOPO32− units. The observation of these multiple Raman bands in the symmetric and antisymmetric stretching region gives credence to the concept that both phosphate and hydrogen phosphate units exist in the structure of kidwellite. The series of Raman bands at 557, 570, 588, 602, 631, 644 and 653 cm−1are assigned to the PO43− ν2 bending modes. The series of Raman bands at 405, 444, 453, 467, 490 and 500 cm−1 are attributed to the PO43− and HOPO32− ν4 bending modes. The spectrum is quite broad but Raman bands may be resolved at 3122, 3231, 3356, 3466 and 3580 cm−1. These bands are assigned to water stretching vibrational modes. The number and position of these bands suggests that water is in different molecular environments with differing hydrogen bond distances. Infrared bands at 3511 and 3359 cm−1 are ascribed to the OH stretching vibration of the OH units. Very broad bands at 3022 and 3299 cm−1 are attributed to the OH stretching vibrations of water. Vibrational spectroscopy offers insights into the molecular structure of the phosphate mineral kidwellite.

Room-temperature photoluminescence from nitrogenated carbon nanotips grown by plasma-enhanced hot filament chemical vapor deposition

Nitrogenated carbon nanotips with a low atomic concentration of nitrogen have been synthesized by using a custom-designed plasma-enhanced hot-filament plasma chemical vapor deposition system. The properties (including morphology, structure, composition, photoluminescence, etc.) of the synthesized nitrogenated carbon nanotips are investigated using advanced characterization tools. The room-temperature photoluminescence measurements show that the nitrogenated carbon nanotips can generate two distinct broad emissions located at ∼405 and ∼507 nm, respectively. Through the detailed analysis, it is shown that these two emission bands are attributed to the transition between the lone pair valence and bands, which are related to the sp3 and sp2 C-N bonds, respectively. These results are highly relevant to advanced applications of nitrogenated carbon nanotips in light emitting optoelectronic devices.

Minimizing the Gibbs–Thomson effect in the low-temperature plasma synthesis of thin Si nanowires

An advanced combination of numerical models, including plasma sheath, ion- and radical-induced species creation and plasma heating effects on the surface and within a Au catalyst nanoparticle, is used to describe the catalyzed growth of Si nanowires in the sheath of a low-temperature and low-pressure plasma. These models have been used to explain the higher nanowire growth rates, low-energy barriers, much thinner Si nanowire nucleation and the less effective Gibbs–Thomson effect in reactive plasma processes, compared with those of neutral gas thermal processes. The effects of variation in the plasma sheath parameters and substrate potential on Si nanowire nucleation and growth have also been investigated. It is shown that increasing the plasma-related effects leads to decreases in the nucleation energy barrier and the critical nanoparticle radius, with the Gibbs–Thomson effect diminished, even at low temperatures. The results obtained are consistent with available experimental results and open a path toward the energy- and matter-efficient nucleation and growth of a broad range of one-dimensional quantum structures.

Controlled electronic transport in single-walled carbon nanotube networks : selecting electron hopping and chemical doping mechanisms

The electronic transport in both intrinsic and acid-treated single-walled carbon nanotube networks containing more than 90% semiconducting nanotubes is investigated using temperature-dependent resistance measurements. The semiconducting behavior observed in the intrinsic network is attributed to the three-dimensional electron hopping mechanism. In contrast, the chemical doping mechanism in the acid-treated network is found to be responsible for the revealed metal-like linear resistivity dependence in a broad temperature range. This effective method to control the electrical conductivity of single-walled carbon nanotube networks is promising for future nanoscale electronics, thermometry, and bolometry. © 2010 American Institute of Physics.

Plasma-assisted self-sharpening of platelet-structured single-crystalline carbon nanocones

A mechanism and model for the vertical growth of platelet-structured vertically aligned single-crystalline carbon nanostructures by the formation of graphene layers on a flat top surface are proposed and verified experimentally. It is demonstrated that plasma-related effects lead to self-sharpening of tapered nanocones to form needlelike nanostructures, in a good agreement with the predicted dependence of the radius of a nanocone's flat top on the incoming ion flux and surface temperature. The growth mechanism is relevant to a broad class of nanostructures including nanotips, nanoneedles, and nanowires and can be used to improve the predictability of nanofabrication processes. © 2007 American Institute of Physics.