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.

The effect of microscopic texture on the direct plasma surface passivation of Si solar cells

Textured silicon surfaces are widely used in manufacturing of solar cells due to increasing the light absorption probability and also the antireflection properties. However, these Si surfaces have a high density of surface defects that need to be passivated. In this study, the effect of the microscopic surface texture on the plasma surface passivation of solar cells is investigated. The movement of 105 H+ ions in the texture-modified plasma sheath is studied by Monte Carlo numerical simulation. The hydrogen ions are driven by the combined electric field of the plasma sheath and the textured surface. The ion dynamics is simulated, and the relative ion distribution over the textured substrate is presented. This distribution can be used to interpret the quality of the Si dangling bonds saturation and consequently, the direct plasma surface passivation.

Highly efficient silicon nanoarray solar cells by a single-step plasma-based process

Highly efficient solar cells (conversion efficiency 11.9%, fill factor 70%) based on the vertically aligned single-crystalline nanostructures are fabricated without any pre-fabricated p-n junctions in a very simple, single-step process of Si nanoarray formation by etching p-type Si(100) wafers in low-temperature environment-friendly plasmas of argon and hydrogen mixtures.

Structural, optical and electrical properties of Al-doped ZnO transparent conducting oxide for solar cell applications

Al-doped zinc oxide (AZO) thin films are deposited onto glass substrates using radio-frequency reactive magnetron sputtering and the improvements in their physical properties by post-synthesis thermal treatment are reported. X-ray diffraction spectra show that the structure of films can be controlled by adjusting the annealing temperatures, with the best crystallinity obtained at 400°C under a nitrogen atmosphere. These films exhibit improved quality and better optical transmittance as indicated by the UV-Vis spectra. Furthermore, the sheet resistivity is found to decrease from 1.87 × 10-3 to 5.63 × 10-4Ω⋅cm and the carrier mobility increases from 6.47 to 13.43 cm2 ⋅ V-1 ⋅ s-1 at the optimal annealing temperature. Our results demonstrate a simple yet effective way in controlling the structural, optical and electrical properties of AZO thin films, which is important for solar cell applications.