Science.gov

Sample records for spreadsheet auditing software

  1. Classroom Applications of Electronic Spreadsheet Computer Software.

    ERIC Educational Resources Information Center

    Tolbert, Patricia H.; Tolbert, Charles M., II

    1983-01-01

    Details classroom use of SuperCalc, a software accounting package developed originally for small businesses, as a computerized gradebook. A procedure which uses data from the computer gradebook to produce weekly printed reports for parents is also described. (MBR)

  2. Software Quality Assurance Audits Guidebooks

    NASA Technical Reports Server (NTRS)

    1990-01-01

    The growth in cost and importance of software to NASA has caused NASA to address the improvement of software development across the agency. One of the products of this program is a series of guidebooks that define a NASA concept of the assurance processes that are used in software development. The Software Assurance Guidebook, NASA-GB-A201, issued in September, 1989, provides an overall picture of the NASA concepts and practices in software assurance. Second level guidebooks focus on specific activities that fall within the software assurance discipline, and provide more detailed information for the manager and/or practitioner. This is the second level Software Quality Assurance Audits Guidebook that describes software quality assurance audits in a way that is compatible with practices at NASA Centers.

  3. Microcomputers: Spreadsheet Software. Evaluation Guides Series. Guide Number 9.

    ERIC Educational Resources Information Center

    Gray, Peter J.

    In this brief guide, the use of microcomputer spreadsheet programs is discussed. Key characteristics are described, with examples of what these programs can do: calculations, recalculation, table lookup, data storage, logical decisions, and simple graphics. Advanced spreadsheet features are noted--consolidation, sort, and execute. Finally,…

  4. When Spreadsheets Become Software - Quality Control Challenges and Approaches - 13360

    SciTech Connect

    Fountain, Stefanie A.; Chen, Emmie G.; Beech, John F.; Wyatt, Elizabeth E.; Quinn, Tanya B.; Seifert, Robert W.

    2013-07-01

    As part of a preliminary waste acceptance criteria (PWAC) development, several commercial models were employed, including the Hydrologic Evaluation of Landfill Performance model (HELP) [1], the Disposal Unit Source Term - Multiple Species model (DUSTMS) [2], and the Analytical Transient One, Two, and Three-Dimensional model (AT123D) [3]. The results of these models were post-processed in MS Excel spreadsheets to convert the model results to alternate units, compare the groundwater concentrations to the groundwater concentration thresholds, and then to adjust the waste contaminant masses (based on average concentration over the waste volume) as needed in an attempt to achieve groundwater concentrations at the limiting point of assessment that would meet the compliance concentrations while maximizing the potential use of the landfill (i.e., maximizing the volume of projected waste being generated that could be placed in the landfill). During the course of the PWAC calculation development, one of the Microsoft (MS) Excel spreadsheets used to post-process the results of the commercial model packages grew to include more than 575,000 formulas across 18 worksheets. This spreadsheet was used to assess six base scenarios as well as nine uncertainty/sensitivity scenarios. The complexity of the spreadsheet resulted in the need for a rigorous quality control (QC) procedure to verify data entry and confirm the accuracy of formulas. (authors)

  5. Software validation applied to spreadsheets used in laboratories working under ISO/IEC 17025

    NASA Astrophysics Data System (ADS)

    Banegas, J. M.; Orué, M. W.

    2016-07-01

    Several documents deal with software validation. Nevertheless, more are too complex to be applied to validate spreadsheets - surely the most used software in laboratories working under ISO/IEC 17025. The method proposed in this work is intended to be directly applied to validate spreadsheets. It includes a systematic way to document requirements, operational aspects regarding to validation, and a simple method to keep records of validation results and modifications history. This method is actually being used in an accredited calibration laboratory, showing to be practical and efficient.

  6. Animations in spreadsheets

    NASA Astrophysics Data System (ADS)

    Aubrecht, Gordon J.; Bolland, T. Kenneth; Ziegler, Michael G.

    1999-12-01

    Recently, Ole Haglund mentioned in this journal that it was possible to incorporate animations into spreadsheets. We would like to describe what might be an easier way to incorporate animations into spreadsheets using Excel™ software.

  7. Software For Computer-Security Audits

    NASA Technical Reports Server (NTRS)

    Arndt, Kate; Lonsford, Emily

    1994-01-01

    Information relevant to potential breaches of security gathered efficiently. Automated Auditing Tools for VAX/VMS program includes following automated software tools performing noted tasks: Privileged ID Identification, program identifies users and their privileges to circumvent existing computer security measures; Critical File Protection, critical files not properly protected identified; Inactive ID Identification, identifications of users no longer in use found; Password Lifetime Review, maximum lifetimes of passwords of all identifications determined; and Password Length Review, minimum allowed length of passwords of all identifications determined. Written in DEC VAX DCL language.

  8. The Benefit of Introducing Audit Software into Curricula for Computer Auditing Students: A Student Perspective from the University of Pretoria

    ERIC Educational Resources Information Center

    Coetzee, G. P.; du Bruyn, R.

    2003-01-01

    The use of computers in the learning process is a well-researched area. The introduction of computers and related audit software in the auditing field has had a major influence on the auditing process. Very little research has been done on the inclusion of computer audit software in the auditing syllabus. Even less research has been done on the…

  9. Software Assists in Extensive Environmental Auditing

    NASA Technical Reports Server (NTRS)

    Callac, Christopher; Matherne, Charlie

    2002-01-01

    The Base Enivronmental Management System (BEMS) is a Web-based application program for managing and tracking audits by the Environmental Office of Stennis Space Center in conformity with standard 14001 of the International Organization for Standardization (ISO 14001). (This standard specifies requirements for an environmental-management system.) BEMS saves time by partly automating what were previously manual processes for creating audit checklists; recording and tracking audit results; issuing, tracking, and implementing corrective-action requests (CARs); tracking continuous improvements (CIs); and tracking audit results and statistics. BEMS consists on an administration module and an auditor module. As its name suggests, the administration module is used to administer the audit. It helps administrators to edit the list of audit questions; edit the list of audit locations; assign manditory questions to locations; track, approve, and edit CARs; and edit completed audits. The auditor module is used by auditors to perform audits and record audit results: It helps the auditors to create audit checklists, complete audits, view completed audits, create CARs, record and acknowledge CIs, and generate reports from audit results.

  10. Software Assists in Extensive Environmental Auditing

    NASA Technical Reports Server (NTRS)

    Callac, Christopher; Matherne, Charlie; Selinsky, T.

    2002-01-01

    The Base Environmental Management System (BEMS) is a Web-based application program for managing and tracking audits by the Environmental Office of Stennis Space Center in conformity with standard 14001 of the International Organization for Standardization (ISO 14001). (This standard specifies requirements for an environmental-management system.) BEMS saves time by partly automating what were previously manual processes for creating audit checklists; recording and tracking audit results; issuing, tracking, and implementing corrective-action requests (CARs); tracking continuous improvements (CIs); and tracking audit results and statistics. BEMS consists of an administration module and an auditor module. As its name suggests, the administration module is used to administer the audit. It helps administrators to edit the list of audit questions; edit the list of audit locations; assign mandatory questions to locations; track, approve, and edit CARs; and edit completed audits. The auditor module is used by auditors to perform audits and record audit results: it helps the auditors to create audit checklists, complete audits, view completed audits, create CARs, record and acknowledge CIs, and generate reports from audit results.

  11. Software Assists in Extensive Environmental Auditing

    NASA Technical Reports Server (NTRS)

    Callac, Christopher; Matherne, Charlie

    2003-01-01

    The Base Environmental Management System (BEMS) is a Web-based application program for managing and tracking audits by the Environmental Office of Stennis Space Center in conformity with standard 14001 of the International Organization for Standardization (ISO 14001). (This standard specifies requirements for an environmental-management system.) BEMS saves time by partly automating what were previously manual processes for creating audit checklists; recording and tracking audit results; issuing, tracking, and implementing corrective-action requests (CARs); tracking continuous improvements (CIs); and tracking audit results and statistics. BEMS consists of an administration module and an auditor module. As its name suggests, the administration module is used to administer the audit. It helps administrators to edit the list of audit questions; edit the list of audit locations; assign mandatory questions to locations; track, approve, and edit CARs; and edit completed audits. The auditor module is used by auditors to perform audits and record audit results: it helps the auditors to create audit checklists, complete audits, view completed audits, create CARs, record and acknowledge CIs, and generate reports from audit results.

  12. Use of a desktop scanner and spreadsheet software for mapping arterial disease.

    PubMed

    Cremers, Stephanie G; Weinberg, Peter D

    2005-01-01

    Mapping the surface area and distribution of atherosclerosis has so far required photographic, video, or photomicrographic imaging of the inner surface of the arterial wall, as well as laborious manual or sophisticated image processing methods of quantification. We investigated whether comparable results could be obtained by using a conventional flatbed scanner and readily available spreadsheet software. Lipid-rich lesions near 21 aortic branches from cholesterol-fed rabbits were mapped using a scanner-based technique and an established photomicrographic technique. When the tissue was counterstained and held on the scanner by a transparent weight to obtain adequate contrast and prevent detection of adventitial staining, the areas of lipid deposition detected by the two methods correlated highly (R2 = 0.99). Discrepancies arose mainly at the edges of lesions, probably because of alignment errors and better flattening of the tissue on the scanner; when these were accounted for, discrepancies occurred in < 1% of the total area examined. The new method produces results comparable with previous procedures, but is much more rapid and requires only office equipment and software. PMID:15934503

  13. Decision Analysis Using Spreadsheets.

    ERIC Educational Resources Information Center

    Sounderpandian, Jayavel

    1989-01-01

    Discussion of decision analysis and its importance in a business curriculum focuses on the use of spreadsheets instead of commercial software packages for computer assisted instruction. A hypothetical example is given of a company drilling for oil, and suggestions are provided for classroom exercises using spreadsheets. (seven references) (LRW)

  14. The Effect of Software Features on Software Adoption and Training in the Audit Profession

    ERIC Educational Resources Information Center

    Kim, Hyo-Jeong

    2012-01-01

    Although software has been studied with technology adoption and training research, the study of specific software features for professional groups has been limited. To address this gap, I researched the impact of software features of varying complexity on internal audit (IA) professionals. Two studies along with the development of training…

  15. Electronic Spreadsheet Packages for Microcomputers.

    ERIC Educational Resources Information Center

    Gibson, Larry M.

    1984-01-01

    Describes capabilities and advantages of spreadsheet software, including its ability to perform "what-if" analysis quickly and easily. Also noted are additional advantages; applications, including use in the library environment; history and development; new-generation spreadsheets; and enhanced packaging in the near future. A spreadsheet software…

  16. A simple method to estimate the optimum iodine concentration of contrast material through microcatheters: hydrodynamic calculation with spreadsheet software

    NASA Astrophysics Data System (ADS)

    Yamauchi, Teiyu; Furui, Shigeru; Suzuki, Shigeru; Mimura, Kohshiro; Hayashi, Toshihiko; Yamada, Takeshi; Futami, Choichiro; Tsukiyama, Yumiko; Harada, Motoko

    2008-03-01

    It is important to increase the iodine delivery rate (I), that is the iodine concentration of the contrast material (C) × the flow rate of the contrast material (Q), through microcatheters to obtain arteriograms of the highest contrast. It is known that C is an important factor that influences I. The purpose of this study is to establish a method of hydrodynamic calculation of the optimum iodine concentration (i.e., the iodine concentration at which I becomes maximum) of the contrast material and its flow rate through commercially available microcatheters. Iopamidol, ioversol and iohexol of ten iodine concentrations were used. Iodine delivery rates (I meas) of each contrast material through ten microcatheters were measured. The calculated iodine delivery rate (I cal) and calculated optimum iodine concentration (calculated C opt) were obtained with spreadsheet software. The agreement between I cal and I meas was studied by correlation and logarithmic Bland-Altman analyses. The value of the calculated C opt was within the optimum range of iodine concentrations (i.e. the range of iodine concentrations at which I meas becomes 90% or more of the maximum) in all cases. A good correlation between I cal and I meas (I cal = 1.08 I meas, r = 0.99) was observed. Logarithmic Bland-Altman analysis showed that the 95% confidence interval of I cal/I meas was between 0.82 and 1.29. In conclusion, hydrodynamic calculation with spreadsheet software is an accurate, generally applicable and cost-saving method to estimate the value of the optimum iodine concentration and its flow rate through microcatheters.

  17. Development and demonstration of an enhanced spreadsheet-based well log analysis software. Final report, May 1998

    SciTech Connect

    Watney, W.L.; Doveton, J.H.; Guy, W.J.

    1998-10-01

    The Advanced Class Work Program is a field-based research and demonstration program for demonstration of advanced or improved technologies identified in the Department of Energy`s Class Field Demonstration Projects. The objective of the Advanced Class Work program is to conduct field demonstrations of technologies for which a small, incremental amount of work will produce or improve a transferable, useful technology for oil recovery. The goal of the program is to enhance the products of near-term Class projects and maximize the applicability and effectiveness of project results. PfEFFER (Petrofacies Evaluation of Formations For Engineering Reservoirs) is a well log analysis computer package. The software was tested and successfully applied in Schaben Field, a DOE Class 2 Field Demonstration Project to assist in improving reservoir characterization and assessing reservoir performance. PfEFFER v.1 was released in January, 1996 as a commercial spreadsheet-based well-log analysis program developed and distributed through the Kansas Geological Survey. The objectives of this project were: Task 1 -- Enhance the PfEFFER software package; Task 2 -- Develop major new modules to significantly augment PfEFFER capabilities; Task 3 -- Conduct field demonstration of software application using the necessary reservoir data acquired from oil operators and construct a database; and Task 4 -- Perform technology transfer activities that include workshops, reports, presentations, or other methods to communicate results to interested parties.

  18. EISA 432 Energy Audits Best Practices: Software Tools

    SciTech Connect

    Maryl Fisher

    2014-11-01

    Five whole building analysis software tools that can aid an energy manager with fulfilling energy audit and commissioning/retro-commissioning requirements were selected for review in this best practices study. A description of each software tool is provided as well as a discussion of the user interface and level of expertise required for each tool, a review of how to use the tool for analyzing energy conservation opportunities, the format and content of reports generated by the tool, and a discussion on the applicability of the tool for commissioning.

  19. 78 FR 47804 - Verification, Validation, Reviews, and Audits for Digital Computer Software Used in Safety...

    Federal Register 2010, 2011, 2012, 2013, 2014

    2013-08-06

    ... identification as Draft Regulatory Guide, DG-1267 on August 22, 2012 (77 FR 50723) for a 60-day public comment... COMMISSION Verification, Validation, Reviews, and Audits for Digital Computer Software Used in Safety Systems...), revision 2 of RG 1.168, ``Verification, Validation, Reviews, and Audits for Digital Computer Software...

  20. Computer Software.

    ERIC Educational Resources Information Center

    Kay, Alan

    1984-01-01

    Discusses the nature and development of computer software. Programing, programing languages, types of software (including dynamic spreadsheets), and software of the future are among the topics considered. (JN)

  1. Hot oiling spreadsheet

    SciTech Connect

    Mansure, A.J.

    1996-09-01

    One of the most common oil-field treatments is hot oiling to remove paraffin from wells. Even though the practice is common, the thermal effectiveness of the process is not commonly understood. In order for producers to easily understand the thermodynamics of hot oiling, a simple tool is needed for estimating downhole temperatures. Such a tool has been developed that was distributed as a compiled, public-domain-software spreadsheet. That spreadsheet has evolved into an interactive from on the World Wide Web and has been adapted into a Windows{trademark} program by Petrolite, St. Louis MO. The development of such a tools was facilitated by expressing downhole temperatures in terms of analytic formulas. Considerable algebraic work is required to develop such formulas. Also, the data describing hot oiling is customarily a mixture of practical units that must be converted to a consistent set of units. To facilitate the algebraic manipulations and to assure unit conversions are correct, during development parallel calculations were made using the spreadsheet and a symbolic mathematics program. Derivation of the formulas considered falling film flow in the annulus and started from the transient differential equations so that the effects of the heat capacity of the tubing and casing could be included. While this approach to developing a software product does not have the power and sophistication of a finite element or difference code, it produces a user friendly product that implements the equations solved with a minimum potential for bugs. This allows emphasis in development of the product to be placed on the physics.

  2. 77 FR 50723 - Verification, Validation, Reviews, and Audits for Digital Computer Software Used in Safety...

    Federal Register 2010, 2011, 2012, 2013, 2014

    2012-08-22

    ...The U.S. Nuclear Regulatory Commission (NRC or the Commission) is issuing for public comment draft regulatory guide (DG), DG-1267, ``Verification, Validation, Reviews, and Audits for Digital Computer Software used in Safety Systems of Nuclear Power Plants.'' The DG-1210 is proposed Revision 2 of Regulatory Guide (RG) 1.168, dated February 2004. This revision endorses, with clarifications and......

  3. Petrogenetic Modeling with a Spreadsheet Program.

    ERIC Educational Resources Information Center

    Holm, Paul Eric

    1988-01-01

    Describes how interactive programs for scientific modeling may be created by using spreadsheet software such as LOTUS 1-2-3. Lists the advantages of using this method. Discusses fractional distillation, batch partial melting, and combination models as examples. (CW)

  4. Spreadsheet-like image analysis

    NASA Astrophysics Data System (ADS)

    Wilson, Paul

    1992-08-01

    This report describes the design of a new software system being built by the Army to support and augment automated nondestructive inspection (NDI) on-line equipment implemented by the Army for detection of defective manufactured items. The new system recalls and post-processes (off-line) the NDI data sets archived by the on-line equipment for the purpose of verifying the correctness of the inspection analysis paradigms, of developing better analysis paradigms and to gather statistics on the defects of the items inspected. The design of the system is similar to that of a spreadsheet, i.e., an array of cells which may be programmed to contain functions with arguments being data from other cells and whose resultant is the output of that cell's function. Unlike a spreadsheet, the arguments and the resultants of a cell may be a matrix such as a two-dimensional matrix of picture elements (pixels). Functions include matrix mathematics, neural networks and image processing as well as those ordinarily found in spreadsheets. The system employs all of the common environmental supports of the Macintosh computer, which is the hardware platform. The system allows the resultant of a cell to be displayed in any of multiple formats such as a matrix of numbers, text, an image, or a chart. Each cell is a window onto the resultant. Like a spreadsheet if the input value of any cell is changed its effect is cascaded into the resultants of all cells whose functions use that value directly or indirectly. The system encourages the user to play what-of games, as ordinary spreadsheets do.

  5. Spreadsheets and Bulgarian Goats

    ERIC Educational Resources Information Center

    Sugden, Steve

    2012-01-01

    We consider a problem appearing in an Australian Mathematics Challenge in 2003. This article considers whether a spreadsheet might be used to model this problem, thus allowing students to explore its structure within the spreadsheet environment. It then goes on to reflect on some general principles of problem decomposition when the final goal is a…

  6. CLAB Transuranic Waste Spreadsheets

    SciTech Connect

    Leyba, J.D.

    2000-08-11

    The Building 772-F Far-Field Transuranic (TRU) Waste Counting System is used to measure the radionuclide content of waste packages produced at the Central Laboratory Facilities (CLAB). Data from the instrument are entered into one of two Excel spreadsheets. The waste stream associated with the waste package determines which spreadsheet is actually used. The spreadsheets calculate the necessary information required for completion of the Transuranic Waste Characterization Form (OSR 29-90) and the Radioactive Solid Waste Burial Ground Record (OSR 7-375 or OSR 7-375A). In addition, the spreadsheets calculate the associated Low Level Waste (LLW) stream information that potentially could be useful if the waste container is ever downgraded from TRU to LLW. The spreadsheets also have the capability to sum activities from source material added to a waste container after assay. A validation data set for each spreadsheet along with the appropriate results are also presented in this report for spreadsheet verification prior to each use.

  7. How to Create Automatically Graded Spreadsheets for Statistics Courses

    ERIC Educational Resources Information Center

    LoSchiavo, Frank M.

    2016-01-01

    Instructors often use spreadsheet software (e.g., Microsoft Excel) in their statistics courses so that students can gain experience conducting computerized analyses. Unfortunately, students tend to make several predictable errors when programming spreadsheets. Without immediate feedback, programming errors are likely to go undetected, and as a…

  8. Spreadsheets in Science Teaching.

    ERIC Educational Resources Information Center

    Elliot, Chris

    1988-01-01

    Described is the use of a spreadsheet to model dynamic phenomena using numerical iterative methods. Uses the discharge of a capacitor, simple and damped harmonic motion, and the flow of heat along a bar as examples. (Author/CW)

  9. Teaching Statistics by Spreadsheet: A Developmental Approach.

    ERIC Educational Resources Information Center

    Ostrowski, John W.

    1988-01-01

    Presents a framework for using spreadsheet software (Lotus 1 2 3) on a microcomputer to develop statistical procedure templates for teaching statistical concepts. Provides an overview of traditional computer-based statistical applications, an outline for teaching-oriented statistical applications with illustrations, and suggestions for integrating…

  10. Construction of spline functions in spreadsheets to smooth experimental data

    Technology Transfer Automated Retrieval System (TEKTRAN)

    A previous manuscript detailed how spreadsheet software can be programmed to smooth experimental data via cubic splines. This addendum corrects a few errors in the previous manuscript and provides additional necessary programming steps. ...

  11. Office Computer Software: A Comprehensive Review of Software Programs.

    ERIC Educational Resources Information Center

    Secretary, 1992

    1992-01-01

    Describes types of software including system software, application software, spreadsheets, accounting software, graphics packages, desktop publishing software, database, desktop and personal information management software, project and records management software, groupware, and shareware. (JOW)

  12. [Use of spreadsheets as decision support systems in health care].

    PubMed

    Sabanović, Z; Masic, I

    1995-01-01

    During the last decade the spreadsheets take very important place in many different kind of theoretical and practical applications. In recent years the PC-Windows Operating System allowed us to use and develop many sorts of specialised software packages, as well as expert packages, applicable in medicine. The relationship or communication between man and computer has been improved using new hardware configuration based on fast and intelligent processors, software modification and audio-visual technology. The facts mentioned above have instantly produced circumstances for more powerful spreadsheet software. According to powerful spreadsheet features we can utilise calculation and maximise HIGM requirement for our software configuration. The investigation within large area of Tuzla-Podrinje Kanton shows us that small number of people are using spreadsheet in medical application. Very small percentage of people have limited number of applications on calculation like, subtraction, addition, multiplication, division and percentage. They have often used spreadsheet as an integral part of the following software packages, EXCEL ver. 5.0 and very little Lotus 1-2-3 because Lotus is in these days behind. The aim of this paper is to highlight application of the spreadsheet USING EXCEL software package. Apart from simple calculation and graphic presentation in "DSS-Decision making support system" can be used for model simulation, generator configuration, management monitoring, support and decision making in health care. PMID:9324558

  13. Fibonacci Numbers and the Spreadsheet.

    ERIC Educational Resources Information Center

    Verderber, Nadine L.

    1991-01-01

    Described is a classroom activity incorporating a computer spreadsheet to study number patterns generated by the Fibonacci sequence. Included are examples and suggestions for the use of the spreadsheet in other recursive relationships. (JJK)

  14. LADTAPXL Aqueous Dose Spreadsheet

    Energy Science and Technology Software Center (ESTSC)

    1999-08-10

    LADTAPXL is an EXCEL spreadsheet model of the NRC computer code LADTAP. LADTAPXL calculates maximally exposed individual and population doses from chronic liquid releases. Environmental pathways include external exposure resulting from recreational activities on the Savannah River and ingestion of water, fish, and invertebrates of Savannah River origin.

  15. Relativity on a Spreadsheet.

    ERIC Educational Resources Information Center

    Carson, S. R.

    1998-01-01

    Presents a method for using spreadsheets to model special relativistic phenomena based on the connection between electric and magnetic fields in special relativity. Uses the time dilation equation to carry out transformations between reference frames that show the connection between the fields quantitatively. (DDR)

  16. Teaching Microeconomics with Microcomputer Spreadsheets.

    ERIC Educational Resources Information Center

    Smith, L. Murphy; Smith, L. C., Jr.

    1988-01-01

    Demonstrates how spreadsheets can be used in teaching basic microeconomic concepts. Presents use of spreadsheet models in studying revenue function, production function, cost information, and profit maximization theory. Discusses application in several simulated situations. Outlines step by step method for creating a spreadsheet graph. (KO)

  17. Hot Oiling Spreadsheet

    Energy Science and Technology Software Center (ESTSC)

    1993-10-22

    One of the most common oil-field treatments is hot oiling to remove paraffin from wells. Even though the practice is common, the thermal effectiveness of the process is not commonly understood. In order for producers to easily understand the thermodynamics of hot oiling, a simple tool is needed for estimating downhole temperatures. Such a tool has been developed that can be distributed as a compiled spreadsheet.

  18. Spreadsheet analysis of gamma spectra for nuclear material measurements

    SciTech Connect

    Mosby, W.R.; Pace, D.M.

    1990-01-01

    A widely available commercial spreadsheet package for personal computers is used to calculate gamma spectra peak areas using both region of interest and peak fitting methods. The gamma peak areas obtained are used for uranium enrichment assays and for isotopic analyses of mixtures of transuranics. The use of spreadsheet software with an internal processing language allows automation of routine analysis procedures increasing ease of use and reducing processing errors while providing great flexibility in addressing unusual measurement problems. 4 refs., 9 figs.

  19. Enhanced CLAB transuranic waste spreadsheet

    SciTech Connect

    Leyba, J.D.

    2000-08-11

    The Building 772-F Far-Field Transuranic (TRU) Waste Counting System is used to measure the radionuclide content of waste packages produced at the Central Laboratory Facilities (CLAB). Data from the instrument are entered into an Excel spreadsheet. The spreadsheet calculates the necessary information required for completion of the Transuranic Waste Characterization Form (OSR 29-90) including the weight percent of the various waste components. In addition, the spreadsheet calculates the associated Low Level Waste (LLW) stream information that potentially could be useful if the waste container is ever downgraded from TRU to LLW. The spreadsheet also has the capability to sum activities from source material added to a waste container after assay. A validation data set for the spreadsheet along with the appropriate results are also presented in this report for spreadsheet verification prior to each use.

  20. Value of Information spreadsheet

    SciTech Connect

    Trainor-Guitton, Whitney

    2014-05-12

    This spreadsheet represents the information posteriors derived from synthetic data of magnetotellurics (MT). These were used to calculate value of information of MT for geothermal exploration. Information posteriors describe how well MT was able to locate the "throat" of clay caps, which are indicative of hidden geothermal resources. This data is full explained in the peer-reviewed publication: Trainor-Guitton, W., Hoversten, G. M., Ramirez, A., Roberts, J., Júlíusson, E., Key, K., Mellors, R. (Sept-Oct. 2014) The value of spatial information for determining well placement: a geothermal example, Geophysics.

  1. Dose Calculation Spreadsheet

    Energy Science and Technology Software Center (ESTSC)

    1997-06-10

    VENTSAR XL is an EXCEL Spreadsheet that can be used to calculate downwind doses as a result of a hypothetical atmospheric release. Both building effects and plume rise may be considered. VENTSAR XL will run using any version of Microsoft EXCEL version 4.0 or later. Macros (the programming language of EXCEL) was used to automate the calculations. The user enters a minimal amount of input and the code calculates the resulting concentrations and doses atmore » various downwind distances as specified by the user.« less

  2. Teaching Science and Mathematics Subjects Using the Excel Spreadsheet Package

    ERIC Educational Resources Information Center

    Ibrahim, Dogan

    2009-01-01

    The teaching of scientific subjects usually require laboratories where students can put the theory they have learned into practice. Traditionally, electronic programmable calculators, dedicated software, or expensive software simulation packages, such as MATLAB have been used to simulate scientific experiments. Recently, spreadsheet programs have…

  3. SNAP: Spreadsheet Nebular Analysis Package

    NASA Astrophysics Data System (ADS)

    Komljenovic, M.; Krawchuk, C.; McCall, M.; Kingsburgh, R.; Richer, Michael; Stevenson, C.

    1996-12-01

    A flexible and extensible software package for two dimensional nebular analyses has been implemented using Visual Basic within Microsoft Excel (version 5). From a calibrated list of fluxes and errors for each spectral row (or object), the program first identifies the lines by their source ions by referring to wavelengths generated from atomic data. The atomic data used in all the calculations is easily updated or augmented by the user. Colour excesses can be computed from a reddening law and ratio of total to selective extinction of a user's choice. For each spectral row, line fluxes can be corrected for stellar absorption and reddening and reported in a format suitable for publication. Temperatures, densities, emission coefficients, and ionic abundances are computed using an adaptation of the FIVEL five-level atom routine. The user has complete control over which spectral lines are used in an analysis -- there are no pre-ordained methods. Abundance analyses can be performed using physical conditions either measured or specified for each spectrum. Since the software is embedded in Microsoft Excel, graphical representations of the data are easily created, and extended analyses using the full functionality of the spreadsheet are easily implemented.

  4. Cruising the Climate with Spreadsheets

    ERIC Educational Resources Information Center

    Krall, Rebecca McNall

    2010-01-01

    Electronic spreadsheets and online weather databases are excellent tools for making real-world comparisons of local, national, and global climate trends. The activities described in this article incorporate these tools to help familiarize students with electronic spreadsheets and how to use authentic data sets available from the internet to answer…

  5. Using Spreadsheets to Assess Learning

    ERIC Educational Resources Information Center

    Wagner, Judson E.

    2007-01-01

    Spreadsheets can be a powerful tool when it comes to teaching physics. From data analysis and graphing to animated simulations, Excel[R] is a very versatile program for the educator and learner alike. This paper describes and supports another use for Excel through Reflective Formative Assessment Spreadsheets (RFAS). To illustrate the use of RFAS,…

  6. Spreadsheets for Analyzing and Optimizing Space Missions

    NASA Technical Reports Server (NTRS)

    Some, Raphael R.; Agrawal, Anil K.; Czikmantory, Akos J.; Weisbin, Charles R.; Hua, Hook; Neff, Jon M.; Cowdin, Mark A.; Lewis, Brian S.; Iroz, Juana; Ross, Rick

    2009-01-01

    XCALIBR (XML Capability Analysis LIBRary) is a set of Extensible Markup Language (XML) database and spreadsheet- based analysis software tools designed to assist in technology-return-on-investment analysis and optimization of technology portfolios pertaining to outer-space missions. XCALIBR is also being examined for use in planning, tracking, and documentation of projects. An XCALIBR database contains information on mission requirements and technological capabilities, which are related by use of an XML taxonomy. XCALIBR incorporates a standardized interface for exporting data and analysis templates to an Excel spreadsheet. Unique features of XCALIBR include the following: It is inherently hierarchical by virtue of its XML basis. The XML taxonomy codifies a comprehensive data structure and data dictionary that includes performance metrics for spacecraft, sensors, and spacecraft systems other than sensors. The taxonomy contains >700 nodes representing all levels, from system through subsystem to individual parts. All entries are searchable and machine readable. There is an intuitive Web-based user interface. The software automatically matches technologies to mission requirements. The software automatically generates, and makes the required entries in, an Excel return-on-investment analysis software tool. The results of an analysis are presented in both tabular and graphical displays.

  7. Use of Wingz spreadsheet as an interface to total-system performance assessment

    SciTech Connect

    Chambers, W.F.; Treadway, A.H.

    1992-01-01

    A commercial spreadsheet has been used as an interface to a set of simple models to simulate possible nominal flow and failure scenarios at the potential high-level nuclear waste repository at Yucca Mountain, Nevada. Individual models coded in FORTRAN are linked to the spreadsheet. Complementary cumulative probability distribution functions resulting from the models are plotted through scripts associated with the spreadsheet. All codes are maintained under a source code control system for quality assurance. The spreadsheet and the simple models can be run on workstations, PCs, and Macintoshes. The software system is designed so that the FORTRAN codes can be run on several machines if a network environment is available.

  8. Turning Spreadsheets into Graphs: An Information Technology Lesson in Whole Brain Thinking

    ERIC Educational Resources Information Center

    Patterson, Thomas F.; Leonard, Jonathan G.

    2005-01-01

    We have concluded that teaching undergraduate students to use spreadsheet software to analyze, interpret, and communicate spreadsheet data through a graph is an information technology exercise in whole brain thinking. In investigating why our students have difficulty constructing proper graphs, we have discovered that graphing requires two…

  9. Learning Chemical Kinetics with Spreadsheets.

    ERIC Educational Resources Information Center

    Blickensderfer, Roger

    1990-01-01

    Presented are several simple kinetic systems together with the spreadsheets used to solve them. A set of exercises in chemical kinetics appropriate for an introductory course in physical chemistry is given. Error propagation calculations with experimental data are illustrated. (CW)

  10. Introducing Artificial Neural Networks through a Spreadsheet Model

    ERIC Educational Resources Information Center

    Rienzo, Thomas F.; Athappilly, Kuriakose K.

    2012-01-01

    Business students taking data mining classes are often introduced to artificial neural networks (ANN) through point and click navigation exercises in application software. Even if correct outcomes are obtained, students frequently do not obtain a thorough understanding of ANN processes. This spreadsheet model was created to illuminate the roles of…

  11. Spreadsheets for Thermodynamics Instruction: Another Point of View.

    ERIC Educational Resources Information Center

    Sandler, Stanley I.

    1997-01-01

    Responds to the suggestion that computational tools be used in undergraduate thermodynamics courses. Argues that instead of using spreadsheets or specially prepared programs, students can quickly develop their own worksheets and solve problems using an equation-solving software program such as MATHCAD. Emphasis is on understanding the fundamentals…

  12. Numerical Stimulation of Multicomponent Chromatography Using Spreadsheets.

    ERIC Educational Resources Information Center

    Frey, Douglas D.

    1990-01-01

    Illustrated is the use of spreadsheet programs for implementing finite difference numerical simulations of chromatography as an instructional tool in a separations course. Discussed are differential equations, discretization and integration, spreadsheet development, computer requirements, and typical simulation results. (CW)

  13. Interactive Spreadsheets in JCE Webware

    ERIC Educational Resources Information Center

    Coleman, William F.; Fedosky, Edward W.

    2005-01-01

    A description of the Microsoft Excel spreadsheet simulation, Anharmonicity.xls that can be used to smoothly and continuously switch a plotted function and its quadratic approximation is presented. It can be used in a classroom demonstration or incorporated into a student-centered computer-laboratory exercise to examine the qualitative behavior of…

  14. The Devil and Daniel's Spreadsheet

    ERIC Educational Resources Information Center

    Burke, Maurice J.

    2012-01-01

    "When making mathematical models, technology is valuable for varying assumptions, exploring consequences, and comparing predictions with data," notes the Common Core State Standards Initiative (2010, p. 72). This exploration of the recursive process in the Devil and Daniel Webster problem reveals that the symbolic spreadsheet fits this bill.…

  15. Spreadsheets in Advanced Physical Chemistry.

    ERIC Educational Resources Information Center

    Kari, Roy

    1990-01-01

    Described are several spreadsheet templates which use the functions of iteration and logical look-up which allow students to calculate and graph quantum mechanical functions and to simulate rotational and vibrational energy level and spectra. The templates are listed in the appendix. (KR)

  16. Budgeting Basics: Profit Planning with Spreadsheets.

    ERIC Educational Resources Information Center

    Hollister, Joan; Schultz, Sally M.

    1996-01-01

    Budgeting is a valuable planning tool, facilitated by basic spreadsheets. Three basic steps in creating a budget--listing fixed and variable costs, computing a break-even point, and evaluating modifications--are explained. Models illustrate the basics of moving around the spreadsheet and entering formulas. Popular spreadsheet programs and price…

  17. Visual Spreadsheets in VisIt

    SciTech Connect

    Whitlock, B; Childs, H

    2007-02-05

    The VACET team would like to add visual spreadsheeting capability to the visualization tool VisIt, to make it be a viable tool for current users of AMRVis and ChomboVis. This document describes AMRVis and ChomboVis approaches to visual spreadsheets and describes a proposed visual spreadsheet mechanism for VisIt.

  18. A spreadsheet algorithm for stagewise solvent extraction

    SciTech Connect

    Leonard, R.A.; Regalbuto, M.C.

    1993-01-01

    Part of the novelty is the way in which the problem is organized in the spreadsheet. In addition, to facilitate spreadsheet setup, a new calculational procedure has been developed. The resulting Spreadsheet Algorithm for Stagewise Solvent Extraction (SASSE) can be used with either IBM or Macintosh personal computers as a simple yet powerful tool for analyzing solvent extraction flowsheets.

  19. Software Bridge

    NASA Technical Reports Server (NTRS)

    1995-01-01

    I-Bridge is a commercial version of software developed by I-Kinetics under a NASA Small Business Innovation Research (SBIR) contract. The software allows users of Windows applications to gain quick, easy access to databases, programs and files on UNIX services. Information goes directly onto spreadsheets and other applications; users need not manually locate, transfer and convert data.

  20. Microcomputer spreadsheets for radioactive waste management and shielding analysis

    SciTech Connect

    Negin, C.A.; Worku, G.; Urland, C.S.; Deltete, C.P.

    1986-09-01

    The report describes several desktop computer applications for use in radioactive waste management and radiation engineering analyses. TMI-2 engineers identified eight calculational tasks that could be facilitated by use of microcomputer spreadsheet software. For each case, appropriate calculations and frequently used data on isotopes and materials were built into the six spreadsheet templates for calculating and thirty-one data sets. The spreadsheets are distributed on diskette to avoid the need for re-input by the user. The applications include: (1) calculation of radioactive decay for a specific time interval for often found radionuclides and their daughter radioisotopes; (2) determination of the disposability of a waste container by calculating the 10CFR61 sum-of-the-fractions concentrations; (3) estimation of the cost of a waste disposal campaign; (4) projection of the rate of hydrogen gas generation in waste liners; (5) calculation of the dose rate from a point source; and (6) inferring the radioisotopic contents of a waste container from the external radiation, and vice versa. This set of microcomputer spreadsheet applications was selected for inclusion as part of EPRI's task of transferring technology developed at TMI-2 to the industry. Waste management is a concern to all plant operators. Microcomputers are used for a variety of evaluation and recordkeeping tasks. Increasing their usefulness to engineers by tools such as these spreadsheets serves to relieve analysts of calculational tasks. As the report provides background and development histories, and the spreadsheets are presented on diskette, the product can be used as a training tool as well.

  1. Spreadsheet log analysis in subsurface geology

    USGS Publications Warehouse

    Doveton, J.H.

    2000-01-01

    Most of the direct knowledge of the geology of the subsurface is gained from the examination of core and drill-cuttings recovered from boreholes drilled by the petroleum and water industries. Wireline logs run in these same boreholes generally have been restricted to tasks of lithostratigraphic correlation and thee location of hydrocarbon pay zones. However, the range of petrophysical measurements has expanded markedly in recent years, so that log traces now can be transformed to estimates of rock composition. Increasingly, logs are available in a digital format that can be read easily by a desktop computer and processed by simple spreadsheet software methods. Taken together, these developments offer accessible tools for new insights into subsurface geology that complement the traditional, but limited, sources of core and cutting observations.

  2. Teaching Computational Physics Using Spreadsheets

    NASA Astrophysics Data System (ADS)

    Lee, Jaebong; Shin, K.; Lee, S.

    2006-12-01

    In recent year, many research groups have been developing spreadsheet program for physics teaching. For example it used to solve Laplace equation1, to visualize potential surface2, and to animate physical contents3. Because Microsoft Excel program is easy to learn, it can apply to many physics problem. And Microsoft® Excel has a Visual Basics for Applications (VBA). ExcelVBA is user-friendly programming tool. Using Excel-VBA and operation with cells, we develop kinds of program about simple harmonic motion, pendulum, satellite orbit, diffraction and so on. We also taught undergraduate students how to program about physics contents using Excel-VBA. We will discuss its’ effect and student’s response. 1. T.T. Crow,”Solution to Laplace’s equation using spreadsheets on personal computer”, Am. J. Phy. 55, 817-823(Sept. 1987) 2. R. J. Beichner, “Visualizing potential surfaces with a spreadsheets”, Phys. Teach. 35, 95-97(Feb. 1997) 3. O. A. Haugland,” Spreadsheet Waves”, Phys. Teach. 37, 14(Jan. 1999) *Supported by the Brain Korea 21 project in 2006

  3. Spreadsheets: Another Aid for the Mathematics Teacher.

    ERIC Educational Resources Information Center

    Sullivan, Peter

    1988-01-01

    Describes the use of spreadsheets. Presents four examples using a pre-designed format: repaying a loan, investigating functions, exponentials, and Fibonacci numbers. Provides three practice problems. (YP)

  4. A Spreadsheet Algorithm for Stagewise Solvent Extraction

    SciTech Connect

    Leonard, R.A.; Regalbuto, M.C.

    1993-08-01

    The material balance and equilibrium equations for solvent extraction processes have been combined with computer spreadsheets in a new way so that models for very complex multicomponent multistage operations can be setup and used easily. A part of the novelty is the way in which the problem is organized in the spreadsheet. In addition, to facilitate spreadsheet setup, a new calculational procedure has been developed. The resulting Spreadsheet Algorithm for Stagewise Solvent Extraction (SASSE) can be used with either IBM or Macintosh personal computers as a simple yet powerful tool for analyzing solvent extraction flowsheets.

  5. Space-Plane Spreadsheet Program

    NASA Technical Reports Server (NTRS)

    Mackall, Dale

    1993-01-01

    Basic Hypersonic Data and Equations (HYPERDATA) spreadsheet computer program provides data gained from three analyses of performance of space plane. Equations used to perform analyses derived from Newton's second law of physics, derivation included. First analysis is parametric study of some basic factors affecting ability of space plane to reach orbit. Second includes calculation of thickness of spherical fuel tank. Third produces ratio between volume of fuel and total mass for each of various aircraft. HYPERDATA intended for use on Macintosh(R) series computers running Microsoft Excel 3.0.

  6. Data analysis and graphing in an introductory physics laboratory: spreadsheet versus statistics suite

    NASA Astrophysics Data System (ADS)

    Peterlin, Primož

    2010-07-01

    Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared.

  7. Data Analysis and Graphing in an Introductory Physics Laboratory: Spreadsheet versus Statistics Suite

    ERIC Educational Resources Information Center

    Peterlin, Primoz

    2010-01-01

    Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

  8. Using Spreadsheets to Help Students Think Recursively

    ERIC Educational Resources Information Center

    Webber, Robert P.

    2012-01-01

    Spreadsheets lend themselves naturally to recursive computations, since a formula can be defined as a function of one of more preceding cells. A hypothesized closed form for the "n"th term of a recursive sequence can be tested easily by using a spreadsheet to compute a large number of the terms. Similarly, a conjecture about the limit of a series…

  9. Spreadsheet Modeling of Electron Distributions in Solids

    ERIC Educational Resources Information Center

    Glassy, Wingfield V.

    2006-01-01

    A series of spreadsheet modeling exercises constructed as part of a new upper-level elective course on solid state materials and surface chemistry is described. The spreadsheet exercises are developed to provide students with the opportunity to interact with the conceptual framework where the role of the density of states and the Fermi-Dirac…

  10. Teaching Raster GIS Operations with Spreadsheets.

    ERIC Educational Resources Information Center

    Raubal, Martin; Gaupmann, Bernhard; Kuhn, Werner

    1997-01-01

    Defines raster technology in its relationship to geographic information systems and notes that it is typically used with the application of remote sensing techniques and scanning devices. Discusses the role of spreadsheets in a raster model, and describes a general approach based on spreadsheets. Includes six computer-generated illustrations. (MJP)

  11. Modeling the Milky Way: Spreadsheet Science.

    ERIC Educational Resources Information Center

    Whitmer, John C.

    1990-01-01

    Described is the generation of a scale model of the solar system and the milky way galaxy using a computer spreadsheet program. A sample spreadsheet including cell formulas is provided. Suggestions for using this activity as a teaching technique are included. (CW)

  12. The Growing Problems with Spreadsheet Budgeting

    ERIC Educational Resources Information Center

    Solomon, Jeff; Johnson, Stella; Wilcox, Leon; Olson, Tom

    2010-01-01

    The ubiquitous spreadsheet in some version has been the sole and unrivaled instrument of financial management for decades. And it has served well. The spreadsheet provides the flexibility to design a unique business process. It allows users to create formulas that execute complex calculations, and it is available in the globally standardized Excel…

  13. Nonfinancial Modeling Techniques on Electronic Spreadsheets.

    ERIC Educational Resources Information Center

    Simkin, Mark G.

    1986-01-01

    Uses a prototype decision problem to demonstrate usefulness of an electronic spreadsheet in analyzing decision trees and performing other types of decision analysis. Advantages and disadvantages of implementing operations research/management science models on electronic spreadsheets are discussed and some do's and don't's are suggested. (Author)

  14. Auditing Orthopaedic Audit

    PubMed Central

    Guryel, E; Acton, K; Patel, S

    2008-01-01

    INTRODUCTION Clinical audit plays an important role in the drive to improve the quality of patient care and thus forms a cornerstone of clinical governance. Assurance that the quality of patient care has improved requires completion of the audit cycle. A considerable sum of money and time has been spent establishing audit activity in the UK. Failure to close the loop undermines the effectiveness of the audit process and wastes resources. PATIENTS AND METHODS We analysed the effectiveness of audit in trauma and orthopaedics at a local hospital by comparing audit projects completed over a 6-year period to criteria set out in the NHS National Audit and Governance report. RESULTS Of the 25 audits performed since 1999, half were presented to the relevant parties and only 20% completed the audit cycle. Only two of these were audits against national standards and 28% were not based on any standards at all. Only a third of the audits led by junior doctors resulted in implementation of their action plan compared to 75% implementation for consultant-led and 67% for nurse-led audits. CONCLUSIONS A remarkably large proportion of audits included in this analysis failed to meet accepted criteria for effective audit. Audits completed by junior doctors were found to be the least likely to complete the cycle. This may relate to the lack of continuity in modern medical training and little incentive to complete the cycle. Supervision by permanent medical staff, principally consultants, and involvement of the audit department may play the biggest role in improving implementation of change. PMID:18828963

  15. A Spreadsheet Program for Steady-State Temperature Distributions

    SciTech Connect

    Hutchens, G.J.

    2000-11-01

    A desktop program is developed in Microsoft EXCEL using Visual Basic for Applications (VBA) to solve a two-dimensional steady state heat conduction problem with a radiation boundary condition. The resulting partial differential equation and boundary conditions are solved using finite difference techniques and the results are compared with a finite element solution using the commercially available software package MSC/THERMAL. The results from the two methods are found to be within 1 percent. The VBA solution demonstrates how spreadsheet programs, like EXCEL, can be used to solve practical engineering problems with good accuracy.

  16. Spreadsheet Templates for Chemical Equilibrium Calculations.

    ERIC Educational Resources Information Center

    Joshi, Bhairav D.

    1993-01-01

    Describes two general spreadsheet templates to carry out all types of one-equation chemical equilibrium calculations encountered by students in undergraduate chemistry courses. Algorithms, templates, macros, and representative examples are presented to illustrate the approach. (PR)

  17. A Computer Simulation Using Spreadsheets for Learning Concept of Steady-State Equilibrium

    ERIC Educational Resources Information Center

    Sharda, Vandana; Sastri, O. S. K. S.; Bhardwaj, Jyoti; Jha, Arbind K.

    2016-01-01

    In this paper, we present a simple spreadsheet based simulation activity that can be performed by students at the undergraduate level. This simulation is implemented in free open source software (FOSS) LibreOffice Calc, which is available for both Windows and Linux platform. This activity aims at building the probability distribution for the…

  18. Using Spreadsheet Modeling Techniques for Capital Project Review. AIR 1985 Annual Forum Paper.

    ERIC Educational Resources Information Center

    Kaynor, Robert K.

    The value of microcomputer modeling tools and spreadsheets to help college institutional researchers analyze proposed capital projects is discussed, along with strengths and weaknesses of different software packages. Capital budgeting is the analysis that supports decisions about the allocation and commitment of funds to long-term capital…

  19. Wet Labs, Computers, and Spreadsheets.

    ERIC Educational Resources Information Center

    Durham, Bill

    1990-01-01

    Described are some commonly encountered chemistry experiments that have been modified for computerized data acquisition. Included are exercises in radioactivity, titration, calorimetry, kinetics, and electrochemistry. Software considerations and laboratory procedures are discussed. (CW)

  20. Spreadsheets in Team X: Preserving Order in an Inherently Chaotic Environment

    NASA Technical Reports Server (NTRS)

    Warfield, Keith; Hihn, Jairus

    2009-01-01

    JPL is NASA's prime center for deep space missions. In response to the need to reduce the cost and time to complete early concept studies and proposals JPL created the first concurrent engineering team in the aerospace industry: Team X. Started in 1995, Team X has carried out over 800 studies, dramatically reducing the time and cost involved, and has been the model for other concurrent engineering teams both within NASA and throughout the larger aerospace community. Since its inception, the software backbone of this highly successful design team - engaged in examining some of NASA's cutting edge concepts - has been the unassuming spreadsheet. Over the years the Team X spreadsheet-based tools have evolved from simple standalone engineering models into a networked spreadsheet intensive system with real time parameter updating. Recent new capabilities include stochastic cost estimation and a graphical drag and drop block diagram that automatically populates the related spreadsheet parameters of cost, mass and power. This paper describes how the spreadsheet functions within Team X: its history, architecture, current capabilities, enabling strengths and persistent weaknesses. In addition, the verification methods and institutional oversight that have evolved as the Team X products became increasingly critical to Laboratory success are also discussed.

  1. Renewable Energy Cost Optimization Spreadsheet

    Energy Science and Technology Software Center (ESTSC)

    2007-12-31

    The Software allow users to determine the optimum combination of renewable energy technologies to minimize life cycle cost for a facility by employing various algorithms which calculate initial and operating cost, energy delivery, and other attributes associated with each technology as a function of size.

  2. Validation and configuration management plan for the KE basins KE-PU spreadsheet code

    SciTech Connect

    Harris, R.A.

    1996-03-11

    This report provides documentation of the spreadsheet KE-PU software that is used to verify compliance with the Operational Safety Requirement and Process Standard limit on the amount of plutonium in the KE-Basin sandfilter backwash pit. Included are: A summary of the verification of the method and technique used in KE-PU that were documented elsewhere, the requirements, plans, and results of validation tests that confirm the proper functioning of the software, the procedures and approvals required to make changes to the software, and the method used to maintain configuration control over the software.

  3. Modeling Steady-State Groundwater Flow Using Microcomputer Spreadsheets.

    ERIC Educational Resources Information Center

    Ousey, John Russell, Jr.

    1986-01-01

    Describes how microcomputer spreadsheets are easily adapted for use in groundwater modeling. Presents spreadsheet set-ups and the results of five groundwater models. Suggests that this approach can provide a basis for demonstrations, laboratory exercises, and student projects. (ML)

  4. Spreadsheet Based Scaling Calculations and Membrane Performance

    SciTech Connect

    Wolfe, T D; Bourcier, W L; Speth, T F

    2000-12-28

    Many membrane element manufacturers provide a computer program to aid buyers in the use of their elements. However, to date there are few examples of fully integrated public domain software available for calculating reverse osmosis and nanofiltration system performance. The Total Flux and Scaling Program (TFSP), written for Excel 97 and above, provides designers and operators new tools to predict membrane system performance, including scaling and fouling parameters, for a wide variety of membrane system configurations and feedwaters. The TFSP development was funded under EPA contract 9C-R193-NTSX. It is freely downloadable at www.reverseosmosis.com/download/TFSP.zip. TFSP includes detailed calculations of reverse osmosis and nanofiltration system performance. Of special significance, the program provides scaling calculations for mineral species not normally addressed in commercial programs, including aluminum, iron, and phosphate species. In addition, ASTM calculations for common species such as calcium sulfate (CaSO{sub 4}{times}2H{sub 2}O), BaSO{sub 4}, SrSO{sub 4}, SiO{sub 2}, and LSI are also provided. Scaling calculations in commercial membrane design programs are normally limited to the common minerals and typically follow basic ASTM methods, which are for the most part graphical approaches adapted to curves. In TFSP, the scaling calculations for the less common minerals use subsets of the USGS PHREEQE and WATEQ4F databases and use the same general calculational approach as PHREEQE and WATEQ4F. The activities of ion complexes are calculated iteratively. Complexes that are unlikely to form in significant concentration were eliminated to simplify the calculations. The calculation provides the distribution of ions and ion complexes that is used to calculate an effective ion product ''Q.'' The effective ion product is then compared to temperature adjusted solubility products (Ksp's) of solids in order to calculate a Saturation Index (SI) for each solid of

  5. A Computer Spreadsheet for Locating Assistive Devices.

    ERIC Educational Resources Information Center

    Palmer, Catherine V.; Garstecki, Dean C.

    1988-01-01

    The article presents a directory of assistive devices for persons with hearing impairments in a grid format by distributor and type of device (alerting devices, telephone, TV/radio/stereo, personal communication, group communication, and other). The product locator is also available in spreadsheet form for either the Macintosh or IBM-PC computers.…

  6. Simulating Electrical Circuits with an Electronic Spreadsheet.

    ERIC Educational Resources Information Center

    Silva, A. Alberto

    1994-01-01

    Explains how a spreadsheet can be an effective modeling and simulation tool for studying electrical circuits. Highlights include Kirchoff's rules and matrices algebra; a pilot experiment with preservice teacher education students in a physics class; the teacher's role; student attitudes; curricular aspects; and the effectiveness of the spreadsheet…

  7. How Spreadsheets Get Us to Mars and Beyond

    NASA Technical Reports Server (NTRS)

    Hihn, Jairus; Lewicki, Scott; Wilkinson, Belinda

    2009-01-01

    Spreadsheets, spreadsheets everywhere and nary a page of documentation. JPL is NASA's prime center for deep space missions. In all of our missions, spreadsheets have played a major role in managing parts lists, managing requirements, monitoring progress, planning budgets, developing the initial concept designs, and providing the backbone of our infrastructure. In this paper we will share our lessons learned in building various spreadsheet intensive systems and applications. Based on our experience in developing and using these various systems we will propose a number of exploratory ideas as to the dimensions of spreadsheet system complexity. In addition, we will share our approaches to documentation, review, and verification of these types of systems.

  8. Forming conjectures within a spreadsheet environment

    NASA Astrophysics Data System (ADS)

    Calder, Nigel; Brown, Tony; Hanley, Una; Darby, Susan

    2006-12-01

    This paper is concerned with the use of spreadsheets within mathematical investigational tasks. Considering the learning of both children and pre-service teaching students, it examines how mathematical phenomena can be seen as a function of the pedagogical media through which they are encountered. In particular, it shows how pedagogical apparatus influence patterns of social interaction, and how this interaction shapes the mathematical ideas that are engaged with. Notions of conjecture, along with the particular faculty of the spreadsheet setting, are considered with regard to the facilitation of mathematical thinking. Employing an interpretive perspective, a key focus is on how alternative pedagogical media and associated discursive networks influence the way that students form and test informal conjectures.

  9. Simple Spreadsheet Thermal Models for Cryogenic Applications

    NASA Technical Reports Server (NTRS)

    Nash, Alfred

    1995-01-01

    Self consistent circuit analog thermal models that can be run in commercial spreadsheet programs on personal computers have been created to calculate the cooldown and steady state performance of cryogen cooled Dewars. The models include temperature dependent conduction and radiation effects. The outputs of the models provide temperature distribution and Dewar performance information. these models have been used to analyze the SIRTF Telescope Test Facility (STTF). The facility has been brought on line for its first user, the Infrared Telescope Technology Testbed (ITTT), for the Space Infrared Telescope Facility (SIRTF) at JPL. The model algorithm as well as a comparison between the models' predictions and actual performance of this facility will be presented.

  10. HSE auditing

    SciTech Connect

    Herwaarden, A.J.F. van; Sykes, R.M.

    1996-12-31

    Shell International Exploration and Production (SIEP) commenced a programme of Health Safety and Environmental (HSE) auditing in its Operating Companies (Opcos) in the late 1970s. Audits in the initial years focused on safety aspects with environmental and occupational aspects being introduced as the process matured. Part of the audit programme is performed by SIEP auditors, external to the Opcos. The level of SIEP-led audit activity increased linearly until the late 1980s, since when a level of around 40 Audits per year has been maintained in roughly as many companies. For the last 15 years each annual programme has included structured audits of all facets of EP operations. The frequency and duration of these audits have the principle objective of auditing all HSE critical processes of each Opco`s activity, within each five-year cycle. Durations vary from 8-10 days with a 4 person team to 18-20 days with a 6-8 person team. Each audit returns a satisfactory or unsatisfactory rating based on analysis of the effectiveness of the so-called eleven principles of Enhanced Safety Management (ESM) required to be applied throughout the Group. Independence is maintained by the SIEP audit leader, who carries ultimate responsibility for the content and wording of each report, where necessary backed-up by senior management in SIEP. These SIEP-led audits have been successful in the following areas: (1) Provision of early warning in areas where facilities integrity or HSE management was likely to be compromised. (2) Aiding the establishment of an internal HSE auditing process in many Opcos. (3) Training, through participation in audits, not only auditors, but also prospective line managers in the effective management of HSE. With the recent introduction of HSE Management Systems (HSE-MS) in many Opcos, auditing is now in the process of controlled evolution from ESM to HSE-MS based.

  11. Groups: knowledge spreadsheets for symbolic biocomputing.

    PubMed

    Travers, Michael; Paley, Suzanne M; Shrager, Jeff; Holland, Timothy A; Karp, Peter D

    2013-01-01

    Knowledge spreadsheets (KSs) are a visual tool for interactive data analysis and exploration. They differ from traditional spreadsheets in that rather than being oriented toward numeric data, they work with symbolic knowledge representation structures and provide operations that take into account the semantics of the application domain. 'Groups' is an implementation of KSs within the Pathway Tools system. Groups allows Pathway Tools users to define a group of objects (e.g. groups of genes or metabolites) from a Pathway/Genome Database. Groups can be transformed (e.g. by transforming a metabolite group to the group of pathways in which those metabolites are substrates); combined through set operations; analysed (e.g. through enrichment analysis); and visualized (e.g. by painting onto a metabolic map diagram). Users of the Pathway Tools-based BioCyc.org website have made extensive use of Groups, and an informal survey of Groups users suggests that Groups has achieved the goal of allowing biologists themselves to perform some data manipulations that previously would have required the assistance of a programmer. Database URL: BioCyc.org. PMID:24037025

  12. Automated Auditing Tool for Retrofit Building Projects

    Energy Science and Technology Software Center (ESTSC)

    2011-06-23

    Building energy auditors regularly use notepads, physical forms, or simple spreadsheets to inventory energy consuming devices in buildings and audit overall performance. Mobile computing devices such as smart phones or tablet computers with camera inputs may be used to automatically capture relevant information and format audit input in a way that streamlines work flows and reduces the likelihood of error. As an example. an auditor could walk through a space holding a mobile device, whichmore » automatically identifies and appliances, windows, etc. This information would automatically be added to a mobile database associated with the building for later integration with a larger building audit database. The user experience would require little or no manual input, and could integrate with tools to automate used to automate data collection for building energy modeling.« less

  13. Automated Auditing Tool for Retrofit Building Projects

    SciTech Connect

    Parker, Andrew

    2011-06-23

    Building energy auditors regularly use notepads, physical forms, or simple spreadsheets to inventory energy consuming devices in buildings and audit overall performance. Mobile computing devices such as smart phones or tablet computers with camera inputs may be used to automatically capture relevant information and format audit input in a way that streamlines work flows and reduces the likelihood of error. As an example. an auditor could walk through a space holding a mobile device, which automatically identifies and appliances, windows, etc. This information would automatically be added to a mobile database associated with the building for later integration with a larger building audit database. The user experience would require little or no manual input, and could integrate with tools to automate used to automate data collection for building energy modeling.

  14. 3-D Spreadsheet Simulation of a Modern Particle Detector

    ERIC Educational Resources Information Center

    Scott, Alan J.

    2004-01-01

    A spreadsheet simulation of a modern particle detector has been developed and can be readily used as an instructional tool in the physics classroom. The spreadsheet creates a three-dimensional model that can be rotated and helical trajectories can be highlighted. An associated student worksheet is also presented.

  15. Spreadsheet-Based Program for Simulating Atomic Emission Spectra

    ERIC Educational Resources Information Center

    Flannigan, David J.

    2014-01-01

    A simple Excel spreadsheet-based program for simulating atomic emission spectra from the properties of neutral atoms (e.g., energies and statistical weights of the electronic states, electronic partition functions, transition probabilities, etc.) is described. The contents of the spreadsheet (i.e., input parameters, formulas for calculating…

  16. Excel Spreadsheets for Algebra: Improving Mental Modeling for Problem Solving

    ERIC Educational Resources Information Center

    Engerman, Jason; Rusek, Matthew; Clariana, Roy

    2014-01-01

    This experiment investigates the effectiveness of Excel spreadsheets in a high school algebra class. Students in the experiment group convincingly outperformed the control group on a post lesson assessment. The student responses, teacher observations involving Excel spreadsheet revealed that it operated as a mindtool, which formed the users'…

  17. A Spreadsheet-Based Approach for Operations Research Teaching

    ERIC Educational Resources Information Center

    Munisamy, Susila

    2009-01-01

    This paper considers the use of spreadsheet for introducing students to a variety of quantitative models covered in an introductory Operations Research (OR) course at the University of Malaya, Malaysia. This approach allows students to develop skills in modeling as they learn to apply the various quantitative models in a spreadsheet. Indeed,…

  18. Teaching with Spreadsheets: An Example from Heat Transfer.

    ERIC Educational Resources Information Center

    Drago, Peter

    1993-01-01

    Provides an activity which measures the heat transfer through an insulated cylindrical tank, allowing the student to gain a better knowledge of both the physics involved and the working of spreadsheets. Provides both a spreadsheet solution and a maximum-minimum method of solution for the problem. (MVL)

  19. Integrating Critical Spreadsheet Competencies into the Accounting Curriculum

    ERIC Educational Resources Information Center

    Walters, L. Melissa; Pergola, Teresa M.

    2012-01-01

    The American Institute of Certified Public Accountants (AICPA) and the International Accounting Education Standards Board (IAESB) identify spreadsheet technology as a key information technology (IT) competency for accounting professionals. However requisite spreadsheet competencies are not specifically defined by the AICPA or IAESB nor are they…

  20. Using Spreadsheets to Produce Acid-Base Titration Curves.

    ERIC Educational Resources Information Center

    Cawley, Martin James; Parkinson, John

    1995-01-01

    Describes two spreadsheets for producing acid-base titration curves, one uses relatively simple cell formulae that can be written into the spreadsheet by inexperienced students and the second uses more complex formulae that are best written by the teacher. (JRH)

  1. Buyers Guide: Communications Software--Overview; Ratings Digest; Reviews; Benchmarks.

    ERIC Educational Resources Information Center

    Lockwood, Russ; And Others

    1988-01-01

    Contains articles which review communications software. Includes "Crosstalk Mark 4,""ProComm,""Freeway Advanced,""Windows InTalk,""Relay Silver," and "Smartcom III." Compares in terms of text proprietary, MCI upload, Test ASCII, Spreadsheet Proprietary, Text XMODEM, Spreadsheet XMODEM, MCI Download, Documentation, Support and Service, ease of use,…

  2. Using Spreadsheets To Model Population Growth, Competition and Predation in Nature.

    ERIC Educational Resources Information Center

    Carter, Ashley J. R.

    1999-01-01

    Describes how to place mathematical equations modeling population growth into a spreadsheet that performs calculations quickly and easily. Suggests experiments that can be performed with the spreadsheets. (WRM)

  3. Spreadsheet-Based Exercises for Introductory Laboratories

    NASA Astrophysics Data System (ADS)

    Elliott, Annie B.; Murray, Stephen D.; Ward, Richard A.

    2003-01-01

    The astronomy curriculum at Las Positas College is a familiar one to many readers - a lecture course on the solar system, another on stars and galaxies, and a separate laboratory course. The laboratory therefore has students who have never heard of some topics, and others who have just had lectures on them. Also, many topics cannot be brought into the laboratory, leading us to rely heavily upon computer-based exercises. Two of these are Kepler's laws of planetary motion and stellar structure. In developing these exercises, we have explored the use of the Microsoft® Excel spreadsheet program. Excel has the advantage of being easier to learn and implement than Java, while also being able to do sophisticated computations.1, 2 At the same time, it may be used to present material in a visually appealing manner, resembling the layout of webpages.

  4. Understanding Gauss’s law using spreadsheets

    NASA Astrophysics Data System (ADS)

    Baird, William H.

    2013-09-01

    Some of the results from the electrostatics portion of introductory physics are particularly difficult for students to understand and/or believe. For students who have yet to take vector calculus, Gauss’s law is far from obvious and may seem more difficult than Coulomb’s. When these same students are told that the minimum potential energy for charges added to a conductor is realized when all charges are on the surface, they may have a hard time believing that the energy would not be lowered if just one of those charges were moved from the surface to the interior of a conductor. Investigating these ideas using Coulomb’s law and/or the formula for the potential energy of a system of discrete charges might be tempting, but as the number of charges climbs past a few the calculations become tedious. A spreadsheet enables students to perform these for a hundred or more charges and confirm the familiar results.

  5. Laser Safety Audit and Inventory System Database

    SciTech Connect

    AUGUSTONI, ARNOLD L.

    2003-05-01

    A laser safety auditing and inventory system has been in use at Sandia National Laboratories--Albuquerque for the past five years and has recently been considered for adoption by Sandia National Laboratories--Livermore. The system utilizes the ''Microsoft Access'' database application, part of the Office 2000 software package. Audit and inventory data is available on-line for ready access by laser users. Data is updated weekly to provide users with current information relating to laser facility audits and laser inventories.

  6. A Spreadsheet for the Mixing of a Row of Jets with a Confined Crossflow

    NASA Technical Reports Server (NTRS)

    Holderman, J. D.; Smith, T. D.; Clisset, J. R.; Lear, W. E.

    2005-01-01

    An interactive computer code, written with a readily available software program, Microsoft Excel (Microsoft Corporation, Redmond, WA) is presented which displays 3 D oblique plots of a conserved scalar distribution downstream of jets mixing with a confined crossflow, for a single row, double rows, or opposed rows of jets with or without flow area convergence and/or a non-uniform crossflow scalar distribution. This project used a previously developed empirical model of jets mixing in a confined crossflow to create an Microsoft Excel spreadsheet that can output the profiles of a conserved scalar for jets injected into a confined crossflow given several input variables. The program uses multiple spreadsheets in a single Microsoft Excel notebook to carry out the modeling. The first sheet contains the main program, controls for the type of problem to be solved, and convergence criteria. The first sheet also provides for input of the specific geometry and flow conditions. The second sheet presents the results calculated with this routine to show the effects on the mixing of varying flow and geometric parameters. Comparisons are also made between results from the version of the empirical correlations implemented in the spreadsheet and the versions originally written in Applesoft BASIC (Apple Computer, Cupertino, CA) in the 1980's.

  7. A Spreadsheet for the Mixing of a Row of Jets with a Confined Crossflow. Supplement

    NASA Technical Reports Server (NTRS)

    Holderman, J. D.; Smith, T. D.; Clisset, J. R.; Lear, W. E.

    2005-01-01

    An interactive computer code, written with a readily available software program, Microsoft Excel (Microsoft Corporation, Redmond, WA) is presented which displays 3 D oblique plots of a conserved scalar distribution downstream of jets mixing with a confined crossflow, for a single row, double rows, or opposed rows of jets with or without flow area convergence and/or a non-uniform crossflow scalar distribution. This project used a previously developed empirical model of jets mixing in a confined crossflow to create an Microsoft Excel spreadsheet that can output the profiles of a conserved scalar for jets injected into a confined crossflow given several input variables. The program uses multiple spreadsheets in a single Microsoft Excel notebook to carry out the modeling. The first sheet contains the main program, controls for the type of problem to be solved, and convergence criteria. The first sheet also provides for input of the specific geometry and flow conditions. The second sheet presents the results calculated with this routine to show the effects on the mixing of varying flow and geometric parameters. Comparisons are also made between results from the version of the empirical correlations implemented in the spreadsheet and the versions originally written in Applesoft BASIC (Apple Computer, Cupertino, CA) in the 1980's.

  8. Energy Auditing.

    ERIC Educational Resources Information Center

    Association of Energy Engineers, Atlanta, GA.

    Presented is a discussion of various aspects of policy and implementation of energy auditing at various levels of government. Included are 11 chapters dealing with: (1) a national energy plan, (2) state certification for energy auditors, (3) survey instrumentation, (4) energy management economics, (5) Maine school energy auditing, (6) energy…

  9. Using the Apple Macintosh and MULTIPLAN Spreadsheet to Analyze Tests.

    ERIC Educational Resources Information Center

    Woodrow, Janice E. J.

    1986-01-01

    Describes the use of the Apple Macintosh and MULTIPLAN spreadsheet to record and analyze test data. Provides step-by-step instructions on data entry, item difficulty and discrimination calculations, test reliability, score distribution, and graphing of distributions. (JM)

  10. Do Vampires Exist? Using Spreadsheets To Investigate a Common Folktale.

    ERIC Educational Resources Information Center

    Drier, Hollylynne Stohl

    1999-01-01

    Describes the use of spreadsheets in a third grade class to teach basic mathematical concepts by investigating the existence of vampires. Incorporates addition and multiplication skills, patterning, variables, formulas, exponential growth, and proof by contradiction. (LRW)

  11. Computer Corner: Spreadsheets, Power Series, Generating Functions, and Integers.

    ERIC Educational Resources Information Center

    Snow, Donald R.

    1989-01-01

    Implements a table algorithm on a spreadsheet program and obtains functions for several number sequences such as the Fibonacci and Catalan numbers. Considers other applications of the table algorithm to integers represented in various number bases. (YP)

  12. Fitting Orbits to Jupiter's Moons with a Spreadsheet.

    ERIC Educational Resources Information Center

    Bridges, Richard

    1995-01-01

    Describes how a spreadsheet is used to fit a circular orbit model to observations of Jupiter's moons made with a small telescope. Kepler's Third Law and the inverse square law of gravity are observed. (AIM)

  13. Spreadsheet Analysis Of Queuing In A Computer Network

    NASA Technical Reports Server (NTRS)

    Galant, David C.

    1992-01-01

    Method of analyzing responses of computer network based on simple queuing-theory mathmatical models via spreadsheet program. Effects of variations in traffic, capacities of channels, and message protocols assessed.

  14. Scholastic Audits. Research Brief

    ERIC Educational Resources Information Center

    Walker, Karen

    2009-01-01

    What is a scholastic audit? The purpose of the audit is to assist individual schools and districts improve. The focus is on gathering data and preparing recommendations that can be used to guide school improvement initiatives. Scholastic audits use a multi-step approach and include: (1) Preparing for the Audit; (2) Audit process; (3) Audit report;…

  15. Safety Auditing and Assessments

    NASA Technical Reports Server (NTRS)

    Goodin, James Ronald (Ronnie)

    2005-01-01

    Safety professionals typically do not engage in audits and independent assessments with the vigor as do our quality brethren. Taking advantage of industry and government experience conducting value added Independent Assessments or Audits benefits a safety program. Most other organizations simply call this process "internal audits." Sources of audit training are presented and compared. A relation of logic between audit techniques and mishap investigation is discussed. An example of an audit process is offered. Shortcomings and pitfalls of auditing are covered.

  16. SPREADSHEET BASED SCALING CALCULATIONS AND MEMBRANE PERFORMANCE

    EPA Science Inventory

    Many membrane element manufacturers provide a computer program to aid buyers in the use of their elements. However, to date there are few examples of fully integrated public domain software available for calculating reverse osmosis and nanofiltration system performance. The Total...

  17. Systems of Linear Equations on a Spreadsheet.

    ERIC Educational Resources Information Center

    Bosch, William W.; Strickland, Jeff

    1998-01-01

    The Optimizer in Quattro Pro and the Solver in Excel software programs make solving linear and nonlinear optimization problems feasible for business mathematics students. Proposes ways in which the Optimizer or Solver can be coaxed into solving systems of linear equations. (ASK)

  18. Using the Talbot_Lau_interferometer_parameters Spreadsheet

    SciTech Connect

    Kallman, Jeffrey S.

    2015-06-04

    Talbot-Lau interferometers allow incoherent X-ray sources to be used for phase contrast imaging. A spreadsheet for exploring the parameter space of Talbot and Talbot-Lau interferometers has been assembled. This spreadsheet allows the user to examine the consequences of choosing phase grating pitch, source energy, and source location on the overall geometry of a Talbot or Talbot-Lau X-ray interferometer. For the X-ray energies required to penetrate scanned luggage the spacing between gratings is large enough that the mechanical tolerances for amplitude grating positioning are unlikely to be met.

  19. The Training Audit.

    ERIC Educational Resources Information Center

    Buckley, Roger; Caple, Jim

    1984-01-01

    This article discusses the role of the auditor and describes a seven-stage training audit model currently being employed by a multinational United Kingdom bank. Stages include familiarization, auditing the client, auditing the program, auditing the program organizer, auditing the consumer, presenting the report, and tasking action agencies. (CT)

  20. Teaching Optimal Design of Experiments Using a Spreadsheet

    ERIC Educational Resources Information Center

    Goos, Peter; Leemans, Herlinde

    2004-01-01

    In this paper, we present an interactive teaching approach to introduce the concept of optimal design of experiments to students. Our approach is based on the use of spreadsheets. One advantage of this approach is that no complex mathematical theory is needed nor that any design construction algorithm has to be discussed at the introductory stage.…

  1. A Simple Spreadsheet Strikes a Nerve among Adjuncts

    ERIC Educational Resources Information Center

    Stratford, Michael

    2012-01-01

    Energized by his fellow adjunct professors who had gathered for a national meeting last month in Washington, District of Columbia, Joshua A. Boldt flew home to Athens, Georgia, opened his laptop, and created a Google document. On his personal blog, the writing instructor implored colleagues to contribute to the publicly editable spreadsheet,…

  2. Calculating the Variables of Finance on a Spreadsheet.

    ERIC Educational Resources Information Center

    Rochowicz, John A., Jr.

    The different approaches for solving problems and learning mathematics with technology are invaluable. This paper describes how to determine the variables of the ordinary annuity equation with a spreadsheet. Examples of future value of annuity, sinking fund annuity, the number of periods necessary for periodic payments plus interest to accumulate…

  3. Negative Effects of Learning Spreadsheet Management on Learning Database Management

    ERIC Educational Resources Information Center

    Vágner, Anikó; Zsakó, László

    2015-01-01

    A lot of students learn spreadsheet management before database management. Their similarities can cause a lot of negative effects when learning database management. In this article, we consider these similarities and explain what can cause problems. First, we analyse the basic concepts such as table, database, row, cell, reference, etc. Then, we…

  4. Using Spreadsheets to Discover Meaning for Parameters in Nonlinear Models

    ERIC Educational Resources Information Center

    Green, Kris H.

    2008-01-01

    This paper explores the use of spreadsheets to develop an exploratory environment where mathematics students can develop their own understanding of the parameters of commonly encountered families of functions: linear, logarithmic, exponential and power. The key to this understanding involves opening up the definition of rate of change from the…

  5. Spreadsheets, Pedagogic Strategies and the Evolution of Meaning for Variable

    ERIC Educational Resources Information Center

    Wilson, Kirsty; Ainley, Janet; Bills, Liz

    2005-01-01

    We report on one aspect of a longitudinal study which seeks insight into the ways in which spreadsheet experience and teachers' pedagogic strategies shape pupils' construction of meaning for algebra. Using data from stimulated recall interviews we analyse the evolution of meaning for variable through the mediation of the variable cell and the…

  6. Spreadsheet application to classify radioactive material for shipment

    SciTech Connect

    Brown, A.N.

    1997-12-01

    A spreadsheet application has been developed at the Idaho National Engineering and Environmental Laboratory to aid the shipper when classifying nuclide mixtures of normal form, radioactive materials. The results generated by this spreadsheet are used to confirm the proper US Department of Transportation (DOT) classification when offering radioactive material packages for transport. The user must input to the spreadsheet the mass of the material being classified, the physical form (liquid or not), and the activity of each regulated nuclide. The spreadsheet uses these inputs to calculate two general values: (1) the specific activity of the material, and (2) a summation calculation of the nuclide content. The specific activity is used to determine if the material exceeds the DOT minimal threshold for a radioactive material (Yes or No). If the material is calculated to be radioactive, the specific activity is also used to determine if the material meets the activity requirement for one of the three Low Specific Activity designations (LSA-I, LSA-II, LSA-III, or Not LSA). Again, if the material is calculated to be radioactive, the summation calculation is then used to determine which activity category the material will meet (Limited Quantity, Type A, Type B, or Highway Route Controlled Quantity).

  7. Using a Spreadsheet Scroll Bar to Solve Equilibrium Concentrations

    ERIC Educational Resources Information Center

    Raviolo, Andres

    2012-01-01

    A simple, conceptual method is described for using the spreadsheet scroll bar to find the composition of a system at chemical equilibrium. Simulation of any kind of chemical equilibrium can be carried out using this method, and the effects of different disturbances can be predicted. This simulation, which can be used in general chemistry…

  8. A Spreadsheet Based Simulator for Experiential Learning in Production Management

    ERIC Educational Resources Information Center

    Basnet, Chuda; Scott, John L.

    2004-01-01

    This paper presents a spreadsheet based simulation game for teaching and learning production management concepts of forecasting, material requirements planning, order review and release. In this game the student plays the role of a production planner managing two products, for which customer orders are placed in variable quantities throughout the…

  9. Using Spreadsheets to Teach Aspects of Biology Involving Mathematical Models

    ERIC Educational Resources Information Center

    Carlton, Kevin; Nicholls, Mike; Ponsonby, David

    2004-01-01

    Some aspects of biology, for example the Hardy-Weinberg simulation of population genetics or modelling heat flow in lizards, have an undeniable mathematical basis. Students can find the level of mathematical skill required to deal with such concepts to be an insurmountable hurdle to understanding. If not used effectively, spreadsheet models…

  10. Using a Spreadsheet To Explore Melting, Dissolving and Phase Diagrams.

    ERIC Educational Resources Information Center

    Goodwin, Alan

    2002-01-01

    Compares phase diagrams relating to the solubilities and melting points of various substances in textbooks with those generated by a spreadsheet using data from the literature. Argues that differences between the diagrams give rise to new chemical insights. (Author/MM)

  11. A Spreadsheet-based GIS tool for planning aerial photography

    EPA Science Inventory

    The U.S.EPA's Pacific Coastal Ecology Branch has developed a tool which facilitates planning aerial photography missions. This tool is an Excel spreadsheet which accepts various input parameters such as desired photo-scale and boundary coordinates of the study area and compiles ...

  12. Automated Formative Feedback and Summative Assessment Using Individualised Spreadsheet Assignments

    ERIC Educational Resources Information Center

    Blayney, Paul; Freeman, Mark

    2004-01-01

    This paper reports on the effects of automating formative feedback at the student's discretion and automating summative assessment with individualised spreadsheet assignments. Quality learning outcomes are achieved when students adopt deep approaches to learning (Ramsden, 2003). Learning environments designed to align assessment to learning…

  13. Examining Errors in Simple Spreadsheet Modeling from Different Research Perspectives

    ERIC Educational Resources Information Center

    Kadijevich, Djordje M.

    2012-01-01

    By using a sample of 1st-year undergraduate business students, this study dealt with the development of simple (deterministic and non-optimization) spreadsheet models of income statements within an introductory course on business informatics. The study examined students' errors in doing this for business situations of their choice and found three…

  14. On the use of a standard spreadsheet to model physical systems in school teaching*

    NASA Astrophysics Data System (ADS)

    Quale, Andreas

    2012-05-01

    In the teaching of physics at upper secondary school level (K10-K12), the students are generally taught to solve problems analytically, i.e. using the dynamics describing a system (typically in the form of differential equations) to compute its evolution in time, e.g. the motion of a body along a straight line or in a plane. This reduces the scope of problems, i.e. the kind of problems that are within students' capabilities. To make the tasks mathematically solvable, one is restricted to very idealized situations; more realistic problems are too difficult (or even impossible) to handle analytically with the mathematical abilities that may be expected from students at this level. For instance, ordinary ballistic trajectories under the action of gravity, when air resistance is included, have been 'out of reach'; in school textbooks such trajectories are generally assumed to take place in a vacuum. Another example is that according to Newton's law of universal gravitation satellites will in general move around a large central body in elliptical orbits, but the students can only deal with the special case where the orbit is circular, thus precluding (for example) a verification and discussion of Kepler's laws. It is shown that standard spreadsheet software offers a tool that can handle many such realistic situations in a uniform way, and display the results both numerically and graphically on a computer screen, quite independently of whether the formal description of the physical system itself is 'mathematically tractable'. The method employed, which is readily accessible to high school students, is to perform a numerical integration of the equations of motion, exploiting the spreadsheet's capability of successive iterations. The software is used to model and study motion of bodies in external force fields; specifically, ballistic trajectories in a homogeneous gravity field with air resistance and satellite motion in a centrally symmetric gravitational field. The

  15. Determination of Needed Spreadsheet Competencies for Business Personnel in the Mid-South States.

    ERIC Educational Resources Information Center

    Rogers, Betty S.; Arn, Joseph V.

    1993-01-01

    A survey of 209 Mid-South businesses determined spreadsheet usage, what competencies are needed for entry-level and continued employment, and sources of spreadsheet training. Recommended that, because of their widespread use, spreadsheets should be taught to all business students. (Author/JOW)

  16. Cognitive Skills, Domain Knowledge, and Self-Efficacy: Effects on Spreadsheet Quality

    ERIC Educational Resources Information Center

    Adkins, Joni K.

    2011-01-01

    Numerous studies have shown that spreadsheets used in companies often have errors which may affect the quality of the decisions made with these tools. Many businesses are unaware or choose to ignore the risks associated with spreadsheet use. The intent of this study was to learn more about the characteristics of spreadsheet end user developers,…

  17. A computer simulation using spreadsheets for learning concept of steady-state equilibrium

    NASA Astrophysics Data System (ADS)

    Sharda, Vandana; Sastri, O. S. K. S.; Bhardwaj, Jyoti; Jha, Arbind K.

    2016-03-01

    In this paper, we present a simple spreadsheet based simulation activity that can be performed by students at the undergraduate level. This simulation is implemented in free open source software (FOSS) LibreOffice Calc, which is available for both Windows and Linux platform. This activity aims at building the probability distribution for the possible macro-states of a system. This has been achieved by randomly sampling the configuration space consisting of all the possible microstates and determining the corresponding macrostate for each of the samples, which is akin to Monte-Carlo simulation. This simulation could act as a very useful tool in engaging students for learning the concepts of microstates, macrostates and steady state equilibrium, once the ideas have been introduced in the classroom. Further, the effect of the number of particles on the quality of steady state equilibrium achieved demonstrates the idea of thermodynamic limit.

  18. Merging Spreadsheet and Word Processing Files Using AppleWorks V2.0 and the Apple IIGS Computer.

    ERIC Educational Resources Information Center

    Schlenker, Richard M.

    This guide was developed as a "how to" training device for merging spreadsheet and word processing files using AppleWorks version 2.0 and the Apple IIGS computer with two disk drives. Step-by-step instructions are provided for loading spreadsheet and word processor files, transferring spreadsheet files to the clipboard, merging spreadsheet and…

  19. Converting Spreadsheet Files into Data Base Files Using AppleWorks V2.0 and the Apple IIGS Computer.

    ERIC Educational Resources Information Center

    Schlenker, Richard M.

    This guide was developed as a "how to" training device for converting spreadsheet files into database files using AppleWorks version 2.0 on the Apple IIGS computer with two disk drives. Step-by-step instructions are provided for loading spreadsheet files, transferring spreadsheet files to the monitor, printing spreadsheet files, and using the data…

  20. Development and Testing of "Math Insight" Software

    ERIC Educational Resources Information Center

    Zucker, Andrew A.

    2006-01-01

    Computers running appropriate software hold great promise for teaching and learning mathematics. To this end, SRI International developed an integrated, computer-based problem solving environment called "Math Insight" that included interactive tools, such as a spreadsheet and dynamic geometric sketches, and professionally produced videos used to…

  1. LADTAP XL: An improved electronic spreadsheet version of LADTAP II

    SciTech Connect

    Hamby, D.M.

    1991-11-18

    An electronic spreadsheet has been developed to estimate the maximum individual and population dose from chronic liquid releases occurring at the Savannah River Site. Environmental pathways include external exposure, resulting from recreational activities on the Savannah River and ingestion of water, fish, and invertebrates of Savannah River origin. Quality assurance principles are applied by protecting the spreadsheet from unauthorized change and providing version number, time and date on each page of output. Improvements have been made to LADTAP II's fish and invertebrate consumption pathway model used to estimate population dose. Build-up of shoreline sediments is assumed to have occurred over the past 40 years, the approximate operating time of the Savannah River Site. Additionally, the swimming dose model has been improved by considering tritium absorption through the skin during submersion. Given a typical annual release, the skin absorption dose dominates the swimming and boating dose to both the maximum individual and population.

  2. Final Draft of RACER Audit

    SciTech Connect

    Paige, Karen Schultz; Gomez, Penelope E.

    2011-01-01

    This document describes the approach Waste and Environmental Services - Environmental Data and Analysis plans to take to resolve the issues presented in a recent audit of the WES-EDA Environmental Database relative to the RACER database. A majority of the issues discovered in the audit will be resolved in May 2011 when the WES-EDA Environmental Database, along with other LANL databases, are integrated and moved to a new vendor providing an Environmental Information Management (EIM) system that allows reporting capabilities for all users directly from the database. The EIM system will reside in a publicly accessible LANL cloud-based software system. When this transition occurs, the data quality, completeness, and access will change significantly. In the remainder of this document, this new structure will be referred to as the LANL Cloud System In general, our plan is to address the issues brought up in this audit in three ways: (1) Data quality issues such as units and detection status, which impinge upon data usability, will be resolved as soon possible so that data quality is maintained. (2) Issues requiring data cleanup, such as look up tables, legacy data, locations, codes, and significant data discrepancies, will be addressed as resources permit. (3) Issues associated with data feed problems will be eliminated by the LANL Cloud System, because there will be no data feed. As discussed in the paragraph above, in the future the data will reside in a publicly accessible system. Note that report writers may choose to convert, adapt, or simplify the information they receive officially through our data base, thereby introducing data discrepancies between the data base and the public report. It is not always possible to incorporate and/or correct these errors when they occur. Issues in the audit will be discussed in the order in which they are presented in the audit report. Clarifications will also be noted as the audit report was a draft document, at the time of this

  3. Tracer Interpretation Using Temporal Moments on a Spreadsheet

    SciTech Connect

    G. Michael Shook; J. Hope Forsmann

    2005-06-01

    This report presents a method for interpreting geothermal tracer tests. The method is based on the first temporal moment (mean residence time) of the tracer in the subsurface. The individual steps required to interpret a tracer test are reviewed and discussed. And an example tracer test directs the user through the interpretation method. An Excel spreadsheet application of the interpretation method is a companion document to this report.

  4. Mimer: an automated spreadsheet-based crystallization screening system

    PubMed Central

    Brodersen, Ditlev Egeskov; Andersen, Gregers Rom; Andersen, Christian Brix Folsted

    2013-01-01

    In this paper, a simple low-cost alternative to large commercial systems for preparing macromolecular crystallization conditions is described. Using an intuitive spreadsheet-based approach, the system allows the rapid calculation of relevant pipetting volumes given known stock-solution concentrations and incorporates the automatic design of custom crystallization screens via the incomplete-factorial and grid-screen approaches. Automated dispensing of the resulting crystallization screens is achieved using a generic and relatively inexpensive liquid handler. PMID:23832216

  5. Hassle-free audit trails: Automated audits

    SciTech Connect

    Manatt, D.R.

    1989-04-01

    The origin and history of data in databases are often as important as the data itself. A full audit trail of database operations is the best record of a database's history. INGRES provides an audit facility to format journal file entries into audit records. This facility is cumbersome and difficult to use. I describe two INGRES Report Writer reports that take all the effort out of maintaining a complete audit trail. To maintain an audit trail of changes to INGRES tables it is necessary to run AUDITDB individually on each table and store a record of the AUDITDB output. The INGRES manuals suggest how the audit records can be copied into INGRES tables for storage. Thus the maintenance of an audit trail consists of: creating tables to receive audit records, running AUDITDB, and storing the audit records into the tables. All this must be done for each table to be audited. My approach to this drudgery is to give it all to the INGRES system. Therefore, I present reports that generate command files to create the tables and run the audits. The only job left for a human is to submit the generated command files to the batch queue.

  6. Have More Fun Teaching Physics: Simulating, Stimulating Software.

    ERIC Educational Resources Information Center

    Jenkins, Doug

    1996-01-01

    High school physics offers opportunities to use problem solving and lab practices as well as cement skills in research, technical writing, and software applications. Describes and evaluates computer software enhancing the high school physics curriculum including spreadsheets for laboratory data, all-in-one simulators, projectile motion simulators,…

  7. Managers Handbook for Software Development

    NASA Technical Reports Server (NTRS)

    Agresti, W.; Mcgarry, F.; Card, D.; Page, J.; Church, V.; Werking, R.

    1984-01-01

    Methods and aids for the management of software development projects are presented. The recommendations are based on analyses and experiences with flight dynamics software development. The management aspects of organizing the project, producing a development plan, estimation costs, scheduling, staffing, preparing deliverable documents, using management tools, monitoring the project, conducting reviews, auditing, testing, and certifying are described.

  8. Computerizing Audit Studies

    PubMed Central

    Lahey, Joanna N.; Beasley, Ryan A.

    2014-01-01

    This paper briefly discusses the history, benefits, and shortcomings of traditional audit field experiments to study market discrimination. Specifically it identifies template bias and experimenter bias as major concerns in the traditional audit method, and demonstrates through an empirical example that computerization of a resume or correspondence audit can efficiently increase sample size and greatly mitigate these concerns. Finally, it presents a useful meta-tool that future researchers can use to create their own resume audits. PMID:24904189

  9. Standardized development of computer software. Part 2: Standards

    NASA Technical Reports Server (NTRS)

    Tausworthe, R. C.

    1978-01-01

    This monograph contains standards for software development and engineering. The book sets forth rules for design, specification, coding, testing, documentation, and quality assurance audits of software; it also contains detailed outlines for the documentation to be produced.

  10. Contracting for Audit Services.

    ERIC Educational Resources Information Center

    Heifetz, Harry S.

    1987-01-01

    The Single Audit Act of 1984 requires most school districts receiving over $25,000 in federal funds to undergo financial audits. This article highlights requirements for selecting certified public accountants to perform the audit and suggests factors to be considered before drafting a contract or letter of engagement. A sample letter is included.…

  11. Software quality assurance plan for GCS

    NASA Technical Reports Server (NTRS)

    Duncan, Stephen E.; Bailey, Elizabeth K.

    1990-01-01

    The software quality assurance (SQA) function for the Guidance and Control Software (GCS) project which is part of a software error studies research program is described. The SQA plan outlines all of the procedures, controls, and audits to be carried out by the SQA organization to ensure adherence to the policies, procedures, and standards for the GCS project.

  12. Manipulative and Numerical Spreadsheet Templates for the Study of Discrete Structures.

    ERIC Educational Resources Information Center

    Abramovich, Sergei

    1998-01-01

    Argues that basic components of discrete mathematics can be introduced to students through gradual elaboration of experiences with iconic spreadsheet-based simulations of concrete materials. Suggests that the study of homogeneous and heterogeneous patterns of manipulative spreadsheet templates allows for appreciation of the development of…

  13. The Iodine-Clock Reaction--A Spreadsheet Simulation To Test.

    ERIC Educational Resources Information Center

    Swain, P. A.

    1997-01-01

    Describes a spreadsheet activity for the iodine-clock reaction which follows the concentrations of all reactions and products for 200 seconds and gives the induction period. Explains that, although there are limitations to the spreadsheet, it is nevertheless illuminating. (Author/ASK)

  14. Printing AppleWorks V2.0 Spreadsheet Files Using the Apple IIGS Computer.

    ERIC Educational Resources Information Center

    Schlenker, Richard M.

    This guide was developed as a "how to" training device for printing AppleWorks version 2.0 spreadsheet files using the Apple IIGS computer with two disk drives. Step-by-step instructions are provided for loading spreadsheet files; selecting the print option; printing entire files; and for printing specific rows, columns, or blocks of the file. For…

  15. Using Spreadsheets to Make Algebra More Accessible--Part 2: Solutions to Equations

    ERIC Educational Resources Information Center

    Green, John

    2009-01-01

    This article is the second in a series of two papers which suggest some practical, spreadsheet-based ideas for helping students to make appropriate connections between particular algebraic concepts. Solving equations has traditionally been taught as a pen-and-paper process. Spreadsheets, such as that of Excel, provide a contemporary, and powerful…

  16. Solution of a Two-Dimensional Diffusion Equation Using an Advanced Spreadsheet Program.

    ERIC Educational Resources Information Center

    Kharab, Abdelwahab

    1997-01-01

    Spreadsheet programs are used increasingly by engineering students to solve problems, especially problems requiring repetitive calculations, as they provide rapid and simple numerical solutions. This article shows how advanced spreadsheet programs are used in the learning of numerical solutions of two-dimensional diffusion equation using the…

  17. Audits Made Simple

    SciTech Connect

    Belangia, David Warren

    2015-04-09

    A company just got notified there is a big external audit coming in 3 months. Getting ready for an audit can be challenging, scary, and full of surprises. This Gold Paper describes a typical audit from notification of the intent to audit through disposition of the final report including Best Practices, Opportunities for Improvement (OFI), and issues that must be fixed. Good preparation can improve the chances of success. Ensuring the auditors understand the environment and requirements is paramount to success. It helps the auditors understand that the enterprise really does think that security is important. Understanding and following a structured process ensures a smooth audit process. Ensuring follow-up on OFIs and issues in a structured fashion will also make the next audit easier. It is important to keep in mind that the auditors will use the previous report as a starting point. Now the only worry is the actual audit and subsequent report and how well the company has done.

  18. Analytical laboratory quality audits

    SciTech Connect

    Kelley, William D.

    2001-06-11

    Analytical Laboratory Quality Audits are designed to improve laboratory performance. The success of the audit, as for many activities, is based on adequate preparation, precise performance, well documented and insightful reporting, and productive follow-up. Adequate preparation starts with definition of the purpose, scope, and authority for the audit and the primary standards against which the laboratory quality program will be tested. The scope and technical processes involved lead to determining the needed audit team resources. Contact is made with the auditee and a formal audit plan is developed, approved and sent to the auditee laboratory management. Review of the auditee's quality manual, key procedures and historical information during preparation leads to better checklist development and more efficient and effective use of the limited time for data gathering during the audit itself. The audit begins with the opening meeting that sets the stage for the interactions between the audit team and the laboratory staff. Arrangements are worked out for the necessary interviews and examination of processes and records. The information developed during the audit is recorded on the checklists. Laboratory management is kept informed of issues during the audit so there are no surprises at the closing meeting. The audit report documents whether the management control systems are effective. In addition to findings of nonconformance, positive reinforcement of exemplary practices provides balance and fairness. Audit closure begins with receipt and evaluation of proposed corrective actions from the nonconformances identified in the audit report. After corrective actions are accepted, their implementation is verified. Upon closure of the corrective actions, the audit is officially closed.

  19. Collaboration Leads to State-of-the-Art Energy Auditing Tool: Project Highlights (Fact Sheet)

    SciTech Connect

    Not Available

    2013-03-01

    This fact sheet describes the tablet-based simuwatt Audit tool, which uses NREL's advanced energy modeling framework and building energy audit processes, collaboration tools, in-app media, and private company concept3D's geometric capture software combined with real-time connections to large sets of standardized data to perform building energy audits faster than traditional methods. By integrating the NREL Building Component Library, utility rates, weather information, and energy conservation measures, the tool provides investment-grade audits that cost 75% less than traditional audits and stores the data in a consistent and reusable format.

  20. 46 CFR Sec. 12 - Audit.

    Code of Federal Regulations, 2010 CFR

    2010-10-01

    ... 46 Shipping 8 2010-10-01 2010-10-01 false Audit. Sec. 12 Section 12 Shipping MARITIME... TRANSACTIONS UNDER AGENCY AGREEMENTS Reports and Audit Sec. 12 Audit. (a) The owner will audit as currently as possible subsequent to audit by the agent, all documents relating to the activities, maintenance...

  1. (abstract) Simple Spreadsheet Thermal Models for Cryogenic Applications

    NASA Technical Reports Server (NTRS)

    Nash, A. E.

    1994-01-01

    Self consistent circuit analog thermal models, that can be run in commercial spreadsheet programs on personal computers, have been created to calculate the cooldown and steady state performance of cryogen cooled Dewars. The models include temperature dependent conduction and radiation effects. The outputs of the models provide temperature distribution and Dewar performance information. These models have been used to analyze the Cryogenic Telescope Test Facility (CTTF). The facility will be on line in early 1995 for its first user, the Infrared Telescope Technology Testbed (ITTT), for the Space Infrared Telescope Facility (SIRTF) at JPL. The model algorithm as well as a comparison of the model predictions and actual performance of this facility will be presented.

  2. Experimental Design and Multiplexed Modeling Using Titrimetry and Spreadsheets

    NASA Astrophysics Data System (ADS)

    Harrington, Peter De B.; Kolbrich, Erin; Cline, Jennifer

    2002-07-01

    The topics of experimental design and modeling are important for inclusion in the undergraduate curriculum. Many general chemistry and quantitative analysis courses introduce students to spreadsheet programs, such as MS Excel. Students in the laboratory sections of these courses use titrimetry as a quantitative measurement method. Unfortunately, the only model that students may be exposed to in introductory chemistry courses is the working curve that uses the linear model. A novel experiment based on a multiplex model has been devised for titrating several vinegar samples at a time. The multiplex titration can be applied to many other routine determinations. An experimental design model is fit to titrimetric measurements using the MS Excel LINEST function to estimate concentration from each sample. This experiment provides valuable lessons in error analysis, Class A glassware tolerances, experimental simulation, statistics, modeling, and experimental design.

  3. A spreadsheet for geothermal direct use cost evaluation

    SciTech Connect

    Rafferty, K.

    1995-09-01

    In order to be seriously considered as an alternative in any project, an energy source must be easily characterized in terms of cost, both capital and unit energy cost. Historically, this has been a difficult hurdle for geothermal energy. Its costs vary with the depth and character of the resource, number of production and injection wells, and a host of other parameters. As a result, even in cases where developers are interested in using the geothermal, identifying its costs has been a cumbersome process. To address this problem, the Geo-Heat Center has developed a spreadsheet which allows potential users to quickly evaluate the capital cost and unit energy cost of accessing a geothermal resource.

  4. Auditing radiation sterilization facilities

    NASA Astrophysics Data System (ADS)

    Beck, Jeffrey A.

    The diversity of radiation sterilization systems available today places renewed emphasis on the need for thorough Quality Assurance audits of these facilities. Evaluating compliance with Good Manufacturing Practices is an obvious requirement, but an effective audit must also evaluate installation and performance qualification programs (validation_, and process control and monitoring procedures in detail. The present paper describes general standards that radiation sterilization operations should meet in each of these key areas, and provides basic guidance for conducting QA audits of these facilities.

  5. Introduction to Financial Projection Models. Business Management Instructional Software.

    ERIC Educational Resources Information Center

    Pomeroy, Robert W., III

    This guidebook and teacher's guide accompany a personal computer software program and introduce the key elements of financial projection modeling to project the financial statements of an industrial enterprise. The student will then build a model on an electronic spreadsheet. The guidebook teaches the purpose of a financial model and the steps…

  6. Birth audit

    PubMed Central

    Sachdeva, Sandeep; Nanda, Smiti; Sachdeva, Ruchi

    2013-01-01

    Objective: To describe profile of births occurring in teaching institution on selected parameters. Materials and Methods: Considering feasibility, four months were systematically chosen for two-year time frame over a decade to gather selected information of consecutive singleton intramural births from log books of labor room on structured pro-forma. Data management was done using software package and analysis carried out by computing descriptive statistics (%) and Chi-square test. Results: It was observed that there were a total of 2862 and 1527 singleton births (>28 weeks) recorded for the sampled time-frame of 2009 and 1999 respectively reflecting increased quantum of institutional deliveries over time-span. Out of 2862 births, monthly distribution was 21.8% (Jan), 20% (Apr), 37.2% (July) and 21.1% (Oct) with similar picture for 1999. The birth according to 8-hourly timeframe was computed to be 31.6% (12 am-8 am), 34.3% (8 am-4 pm) and 34.0% (4 pm to 12 am) for 2009 while it was 28.6%, 38.6% and 32.8% for 1999 (P < 0.05). Births took place through-out seven days of week; however, Sunday (12.0%) was the least popular day while Thursday (18.7%) recorded maximum proportion of births during 2009. Slightly higher proportion of pre-term births were recorded during 2009 (21.76%) in comparison to 1999 (18.53%). The caesarian section rose to 26.1% from 20.2% (P < 0.05) while M:F ratio at birth was 1.28 and 1.17 with similar proportion (92.3%; 93.0%) of newborns being discharged live during 2009 and 1999 respectively. Conclusion: It provides snapshots of birth occurring in a teaching hospital and within study constraints finding could be utilized for improving quality of care, health communication, better utilization of human resource and logistics. PMID:23633853

  7. Final Technical Report. Training in Building Audit Technologies

    SciTech Connect

    Brosemer, Kathleen

    2015-03-27

    In 2011, the Tribe proposed and was awarded the Training in Building Audit Technologies grant from the DOE in the amount of $55,748 to contract for training programs for infrared cameras, blower door technology applications and building systems. The coursework consisted of; Infrared Camera Training: Level I - Thermal Imaging for Energy Audits; Blower Door Analysis and Building-As-A-System Training, Building Performance Institute (BPI) Building Analyst; Building Envelope Training, Building Performance Institute (BPI) Envelope Professional; and Audit/JobFLEX Tablet Software. Competitive procurement of the training contractor resulted in lower costs, allowing the Tribe to request and receive DOE approval to additionally purchase energy audit equipment and contract for residential energy audits of 25 low-income Tribal Housing units. Sault Tribe personnel received field training to supplement the classroom instruction on proper use of the energy audit equipment. Field experience was provided through the second DOE energy audits grant, allowing Sault Tribe personnel to join the contractor, Building Science Academy, in conducting 25 residential energy audits of low-income Tribal Housing units.

  8. CHP Installed Capacity Optimizer Software

    Energy Science and Technology Software Center (ESTSC)

    2004-11-30

    The CHP Installed Capacity Optimizer is a Microsoft Excel spreadsheet application that determines the most economic amount of capacity of distributed generation and thermal utilization equipment (e.g., absorption chillers) to install for any user-defined set of load and cost data. Installing the optimum amount of capacity is critical to the life-cycle economic viability of a distributed generation/cooling heat and power (CHP) application. Using advanced optimization algorithms, the software accesses the loads, utility tariffs, equipment costs,more » etc., and provides to the user the most economic amount of system capacity to install.« less

  9. CHP Installed Capacity Optimizer Software

    SciTech Connect

    2004-11-30

    The CHP Installed Capacity Optimizer is a Microsoft Excel spreadsheet application that determines the most economic amount of capacity of distributed generation and thermal utilization equipment (e.g., absorption chillers) to install for any user-defined set of load and cost data. Installing the optimum amount of capacity is critical to the life-cycle economic viability of a distributed generation/cooling heat and power (CHP) application. Using advanced optimization algorithms, the software accesses the loads, utility tariffs, equipment costs, etc., and provides to the user the most economic amount of system capacity to install.

  10. The Role of Universities in Preparing Graduates to Use Software in the Financial Services Workplace

    ERIC Educational Resources Information Center

    Tickle, Leonie; Kyng, Tim; Wood, Leigh N.

    2014-01-01

    The role of universities in preparing students to use spreadsheet and other technical software in the financial services workplace has been investigated through surveys of university graduates, university academics, and employers. It is found that graduates are less skilled users of software than employers would like, due at least in part to a…

  11. Perceptions of the Software Skills of Graduates by Employers in the Financial Services Industry

    ERIC Educational Resources Information Center

    Kyng, Tim; Tickle, Leonie; Wood, Leigh N.

    2013-01-01

    Software, particularly spreadsheet software, is ubiquitous in the financial services workplace. Yet little is known about the extent to which universities should, and do, prepare graduates for this aspect of the modern workplace. We have investigated this issue through a survey of financial services employers of graduates, the results of which are…

  12. Using Spreadsheets and Internally Consistent Databases to Explore Thermodynamics

    NASA Astrophysics Data System (ADS)

    Dasgupta, S.; Chakraborty, S.

    2003-12-01

    Much common wisdom has been handed down to generations of petrology students in words - a non-exhaustive list may include (a) do not mix data from two different thermodynamic databases, (b) use of different heat capacity functions or extrapolation beyond the P-T range of fit can have disastrous results, (c) consideration of errors in thermodynamic calculations is crucial, (d) consideration of non-ideality, interaction parameters etc. are important in some cases, but not in others. Actual calculations to demonstrate these effects were either too laborious, tedious, time consuming or involved elaborate computer programming beyond the reaches of the average undergraduate. We have produced "Live" thermodynamic tables in the form of ExcelTM spreadsheets based on standard internally consistent thermodynamic databases (e.g. Berman, Holland and Powell) that allow quick, easy and most importantly, transparent manipulation of thermodynamic data to calculate mineral stabilities and to explore the role of different parameters. We have intentionally avoided the use of advanced tools such as macros, and have set up columns of data that are easy to relate to thermodynamic relationships to enhance transparency. The approach consists of the following basic steps: (i) use a simple supporting spreadsheet to enter mineral compositions (in formula units) to obtain a balanced reaction by matrix inversion. (ii) enter the stoichiometry of this reaction in a designated space and a P and T to get the delta G of the reaction (iii) vary P and or T to locate equilibrium through a change of sign of delta G. These results can be collected to explore practically any problem of chemical equilibrium and mineral stability. Some of our favorites include (a) hierarchical addition of complexity to equilibrium calculations - start with a simple end member reaction ignoring heat capacity and volume derivatives, add the effects of these, followed by addition of compositional effects in the form of ideal

  13. Improving Students' Understanding of the Importance of Economic Consequences in Standard Setting: A Computerized Spreadsheet Tool.

    ERIC Educational Resources Information Center

    Ivancevich, Daniel M.; And Others

    1996-01-01

    Points out that political and economic pressures have sometimes caused the Financial Accounting Standards Board to alter standards. Presents a spreadsheet tool that demonstrates the economic consequences of adopting accounting standards. (SK)

  14. Integrating Computer Spreadsheet Modeling into a Microeconomics Curriculum: Principles to Managerial.

    ERIC Educational Resources Information Center

    Clark, Joy L.; Hegji, Charles E.

    1997-01-01

    Notes that using spreadsheets to teach microeconomics principles enables learning by doing in the exploration of basic concepts. Introduction of increasingly complex topics leads to exploration of theory and managerial decision making. (SK)

  15. Dosimetric audit in brachytherapy

    PubMed Central

    Bradley, D A; Nisbet, A

    2014-01-01

    Dosimetric audit is required for the improvement of patient safety in radiotherapy and to aid optimization of treatment. The reassurance that treatment is being delivered in line with accepted standards, that delivered doses are as prescribed and that quality improvement is enabled is as essential for brachytherapy as it is for the more commonly audited external beam radiotherapy. Dose measurement in brachytherapy is challenging owing to steep dose gradients and small scales, especially in the context of an audit. Several different approaches have been taken for audit measurement to date: thimble and well-type ionization chambers, thermoluminescent detectors, optically stimulated luminescence detectors, radiochromic film and alanine. In this work, we review all of the dosimetric brachytherapy audits that have been conducted in recent years, look at current audits in progress and propose required directions for brachytherapy dosimetric audit in the future. The concern over accurate source strength measurement may be essentially resolved with modern equipment and calibration methods, but brachytherapy is a rapidly developing field and dosimetric audit must keep pace. PMID:24807068

  16. School Safety Audit Protocol.

    ERIC Educational Resources Information Center

    DeMary, Jo Lynne; Owens, Marsha; Ramnarain, A. K. Vijay

    The 1997 Virginia General Assembly passed legislation directing school boards to require all schools to conduct safety audits. This audit is designed to assess the safety conditions in each public school to: (1) identify and, if necessary, develop solutions for physical safety concerns, including building security issues; and (2) identify and…

  17. Auditing Schools for Safety.

    ERIC Educational Resources Information Center

    Butterfield, Eric,

    2000-01-01

    Explores the issues involved in conducting effective safety audits for educational facilities. Areas covered include auditing for site characteristics, access control, lighting, building exterior, door types and locking mechanisms, key control, alarm system controls, security monitors, and vision panels in the doors. (GR)

  18. New Richardson's extrapolation spreadsheet calculator using VBA programming for numerical differentiations

    NASA Astrophysics Data System (ADS)

    Tay, Kim Gaik; Kek, Sie Long; Abdul-Kahar, Rosmila

    2015-05-01

    In this paper, we have further improved the limitations of our previous two Richardson's extrapolation spreadsheet calculators for computing differentiations numerically. The new feature in this new Richardson's extrapolation spreadsheet calculator is fully automated up to any level based on the stopping criteria using VBA programming. The new version is more flexible because it is controlled by programming. Furthermore, it reduces computational time and CPU memory.

  19. Mass analysis for the Space Station ECLSS using the balance spreadsheet method

    NASA Technical Reports Server (NTRS)

    Chu, Wen-Ho

    1989-01-01

    The balance spreadsheet method is applied to mass analysis of the Environmental Control and Life Support System (ECLSS). The spreadsheet layout reduces the complexity of the ECLSS analysis by concisely defining the sources, sinks, and net changes in mass for each fluid. The analysis method is illustrated by using information from the latest Space Station ECLSS Architectural Control Documents and a given Space Station assembly sequence. The analysis results are plotted and discussed.

  20. A simple model of hysteresis behavior using spreadsheet analysis

    NASA Astrophysics Data System (ADS)

    Ehrmann, A.; Blachowicz, T.

    2015-01-01

    Hysteresis loops occur in many scientific and technical problems, especially as field dependent magnetization of ferromagnetic materials, but also as stress-strain-curves of materials measured by tensile tests including thermal effects, liquid-solid phase transitions, in cell biology or economics. While several mathematical models exist which aim to calculate hysteresis energies and other parameters, here we offer a simple model for a general hysteretic system, showing different hysteresis loops depending on the defined parameters. The calculation which is based on basic spreadsheet analysis plus an easy macro code can be used by students to understand how these systems work and how the parameters influence the reactions of the system on an external field. Importantly, in the step-by-step mode, each change of the system state, compared to the last step, becomes visible. The simple program can be developed further by several changes and additions, enabling the building of a tool which is capable of answering real physical questions in the broad field of magnetism as well as in other scientific areas, in which similar hysteresis loops occur.

  1. Abdominal surgery process modeling framework for simulation using spreadsheets.

    PubMed

    Boshkoska, Biljana Mileva; Damij, Talib; Jelenc, Franc; Damij, Nadja

    2015-08-01

    We provide a continuation of the existing Activity Table Modeling methodology with a modular spreadsheets simulation. The simulation model developed is comprised of 28 modeling elements for the abdominal surgery cycle process. The simulation of a two-week patient flow in an abdominal clinic with 75 beds demonstrates the applicability of the methodology. The simulation does not include macros, thus programming experience is not essential for replication or upgrading the model. Unlike the existing methods, the proposed solution employs a modular approach for modeling the activities that ensures better readability, the possibility of easily upgrading the model with other activities, and its easy extension and connectives with other similar models. We propose a first-in-first-served approach for simulation of servicing multiple patients. The uncertain time duration of the activities is modeled using the function "rand()". The patients movements from one activity to the next one is tracked with nested "if()" functions, thus allowing easy re-creation of the process without the need of complex programming. PMID:26004999

  2. Numeric calculation of celestial bodies with spreadsheet analysis

    NASA Astrophysics Data System (ADS)

    Koch, Alexander

    2016-04-01

    The motion of the planets and moons in our solar system can easily be calculated for any time by the Kepler laws of planetary motion. The Kepler laws are a special case of the gravitational law of Newton, especially if you consider more than two celestial bodies. Therefore it is more basic to calculate the motion by using the gravitational law. But the problem is, that by gravitational law it is not possible to calculate the state of motion with only one step of calculation. The motion has to be numerical calculated for many time intervalls. For this reason, spreadsheet analysis is helpful for students. Skills in programmes like Excel, Calc or Gnumeric are important in professional life and can easily be learnt by students. These programmes can help to calculate the complex motions with many intervalls. The more intervalls are used, the more exact are the calculated orbits. The sutdents will first get a quick course in Excel. After that they calculate with instructions the 2-D-coordinates of the orbits of Moon and Mars. Step by step the students are coding the formulae for calculating physical parameters like coordinates, force, acceleration and velocity. The project is limited to 4 weeks or 8 lessons. So the calcualtion will only include the calculation of one body around the central mass like Earth or Sun. The three-body problem can only be shortly discussed at the end of the project.

  3. Development of the free-space optical communications analysis software

    NASA Astrophysics Data System (ADS)

    Jeganathan, Muthu; Mecherle, G. Stephen; Lesh, James R.

    1998-05-01

    The Free-space Optical Communication Analysis Software (FOCAS) was developed at the Jet Propulsion Laboratory (JPL) to provide mission planners, systems engineers and communications engineers with an easy to use tool to analyze direct-detection optical communication links. The FOCAS program, implemented in Microsoft Excel, gives it all the power and flexibility built into the spreadsheet. An easy-to-use interface, developed using Visual Basic for Applications (VBA), to the spreadsheet allows easy input of data and parameters. A host of pre- defined components allow an analyst to configure a link without having to know the details of the components. FOCAS replaces the over-a-decade-old FORTRAN program called OPTI widely used previously at JPL. This paper describes the features and capabilities of the Excel-spreadsheet-based FOCAS program.

  4. Improving energy audit process and report outcomes through planning initiatives

    NASA Astrophysics Data System (ADS)

    Sprau Coulter, Tabitha L.

    Energy audits and energy models are an important aspect of the retrofit design process, as they provide project teams with an opportunity to evaluate a facilities current building systems' and energy performance. The information collected during an energy audit is typically used to develop an energy model and an energy audit report that are both used to assist in making decisions about the design and implementation of energy conservation measures in a facility. The current lack of energy auditing standards results in a high degree of variability in energy audit outcomes depending on the individual performing the audit. The research presented is based on the conviction that performing an energy audit and producing a value adding energy model for retrofit buildings can benefit from a revised approach. The research was divided into four phases, with the initial three phases consisting of: 1.) process mapping activity - aimed at reducing variability in the energy auditing and energy modeling process. 2.) survey analysis -- To examine the misalignment between how industry members use the top energy modeling tools compared to their intended use as defined by software representatives. 3.) sensitivity analysis -- analysis of the affect key energy modeling inputs are having on energy modeling analysis results. The initial three phases helped define the need for an improved energy audit approach that better aligns data collection with facility owners' needs and priorities. The initial three phases also assisted in the development of a multi-criteria decision support tool that incorporates a House of Quality approach to guide a pre-audit planning activity. For the fourth and final research phase explored the impacts and evaluation methods of a pre-audit planning activity using two comparative energy audits as case studies. In each case, an energy audit professionals was asked to complete an audit using their traditional methods along with an audit which involved them first

  5. Internal Auditing for School Districts.

    ERIC Educational Resources Information Center

    Cuzzetto, Charles

    This book provides guidelines for conducting internal audits of school districts. The first five chapters provide an overview of internal auditing and describe techniques that can be used to improve or implement internal audits in school districts. They offer information on the definition and benefits of internal auditing, the role of internal…

  6. Rapid Risk Evaluation (ER2) Using MS Excel Spreadsheet: a Case Study of Fredericton (new Brunswick, Canada)

    NASA Astrophysics Data System (ADS)

    McGrath, H.; Stefanakis, E.; Nastev, M.

    2016-06-01

    Conventional knowledge of the flood hazard alone (extent and frequency) is not sufficient for informed decision-making. The public safety community needs tools and guidance to adequately undertake flood hazard risk assessment in order to estimate respective damages and social and economic losses. While many complex computer models have been developed for flood risk assessment, they require highly trained personnel to prepare the necessary input (hazard, inventory of the built environment, and vulnerabilities) and analyze model outputs. As such, tools which utilize open-source software or are built within popular desktop software programs are appealing alternatives. The recently developed Rapid Risk Evaluation (ER2) application runs scenario based loss assessment analyses in a Microsoft Excel spreadsheet. User input is limited to a handful of intuitive drop-down menus utilized to describe the building type, age, occupancy and the expected water level. In anticipation of local depth damage curves and other needed vulnerability parameters, those from the U.S. FEMA's Hazus-Flood software have been imported and temporarily accessed in conjunction with user input to display exposure and estimated economic losses related to the structure and the content of the building. Building types and occupancies representative of those most exposed to flooding in Fredericton (New Brunswick) were introduced and test flood scenarios were run. The algorithm was successfully validated against results from the Hazus-Flood model for the same building types and flood depths.

  7. Audits of radiopharmaceutical formulations.

    PubMed

    Castronovo, F P

    1992-03-01

    A procedure for auditing radiopharmaceutical formulations is described. To meet FDA guidelines regarding the quality of radiopharmaceuticals, institutional radioactive drug research committees perform audits when such drugs are formulated away from an institutional pharmacy. All principal investigators who formulate drugs outside institutional pharmacies must pass these audits before they can obtain a radiopharmaceutical investigation permit. The audit team meets with the individual who performs the formulation at the site of drug preparation to verify that drug formulations meet identity, strength, quality, and purity standards; are uniform and reproducible; and are sterile and pyrogen free. This team must contain an expert knowledgeable in the preparation of radioactive drugs; a radiopharmacist is the most qualified person for this role. Problems that have been identified by audits include lack of sterility and apyrogenicity testing, formulations that are open to the laboratory environment, failure to use pharmaceutical-grade chemicals, inadequate quality control methods or records, inadequate training of the person preparing the drug, and improper unit dose preparation. Investigational radiopharmaceutical formulations, including nonradiolabeled drugs, must be audited before they are administered to humans. A properly trained pharmacist should be a member of the audit team. PMID:1598931

  8. NHEXAS PHASE I REGION 5 STUDY--STANDARD OPERATING PROCEDURE--FIELD USE OF THE SAMPLE COLLECTION AND CUSTODY SOFTWARE (RTI/ACS-AP-209-086)

    EPA Science Inventory

    This procedure describes field use of the sample collection and custody software developed for this pilot study. This is an easy-to-use, spreadsheet-based, two-part sample collection and custody software package. The software is for use on laptop computers and defines the kinds a...

  9. The Neighborhood Auditing Tool: A Hybrid Interface for Auditing the UMLS

    PubMed Central

    Morrey, C. Paul; Geller, James; Halper, Michael; Perl, Yehoshua

    2009-01-01

    The UMLS’s integration of more than 100 source vocabularies, not necessarily consistent with one another, causes some inconsistencies. The purpose of auditing the UMLS is to detect such inconsistencies and to suggest how to resolve them while observing the requirement of fully representing the content of each source in the UMLS. A software tool, called the Neighborhood Auditing Tool (NAT), that facilitates UMLS auditing is presented. The NAT supports “neighborhood-based” auditing, where, at any given time, an auditor concentrates on a single focus concept and one of a variety of neighborhoods of its closely related concepts. Typical diagrammatic displays of concept networks have a number of shortcomings, so the NAT utilizes a hybrid diagram/text interface that features stylized neighborhood views which retain some of the best features of both the diagrammatic layouts and text windows while avoiding the shortcomings. The NAT allows an auditor to display knowledge from both the Metathesaurus (concept) level and the Semantic Network (semantic type) level. Various additional features of the NAT that support the auditing process are described. The usefulness of the NAT is demonstrated through a group of case studies. Its impact is tested with a study involving a select group of auditors. PMID:19475725

  10. simuwatt - A Tablet Based Electronic Auditing Tool

    SciTech Connect

    Macumber, Daniel; Parker, Andrew; Lisell, Lars; Metzger, Ian; Brown, Matthew

    2014-05-08

    'simuwatt Energy Auditor' (TM) is a new tablet-based electronic auditing tool that is designed to dramatically reduce the time and cost to perform investment-grade audits and improve quality and consistency. The tool uses the U.S. Department of Energy's OpenStudio modeling platform and integrated Building Component Library to automate modeling and analysis. simuwatt's software-guided workflow helps users gather required data, and provides the data in a standard electronic format that is automatically converted to a baseline OpenStudio model for energy analysis. The baseline energy model is calibrated against actual monthly energy use to ASHRAE Standard 14 guidelines. Energy conservation measures from the Building Component Library are then evaluated using OpenStudio's parametric analysis capability. Automated reporting creates audit documents that describe recommended packages of energy conservation measures. The development of this tool was partially funded by the U.S. Department of Defense's Environmental Security Technology Certification Program. As part of this program, the tool is being tested at 13 buildings on 5 Department of Defense sites across the United States. Results of the first simuwatt audit tool demonstration are presented in this paper.

  11. Automated and Manual Rocket Crater Measurement Software

    NASA Technical Reports Server (NTRS)

    Metzger, Philip; Immer, Christopher

    2012-01-01

    An update has been performed to software designed to do very rapid automated measurements of craters created in sandy substrates by rocket exhaust on liftoff. The previous software was optimized for pristine lab geometry and lighting conditions. This software has been enhanced to include a section for manual measurements of crater parameters; namely, crater depth, crater full width at half max, and estimated crater volume. The tools provide a very rapid method to measure these manual parameters to ease the burden of analyzing large data sets. This software allows for rapid quantization of the rocket crater parameters where automated methods may not work. The progress of spreadsheet data is continuously saved so that data is never lost, and data can be copied to clipboards and pasted to other software for analysis. The volume estimation of a crater is based on the central max depth axis line, and the polygonal shape of the crater is integrated around that axis.

  12. 7 CFR 1773.8 - Audit date.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.8 Audit date. (a) The annual... change the as of audit date is obtained, in writing, from RUS. (1) A borrower may request a change in...

  13. Communication of Audit Risk to Students.

    ERIC Educational Resources Information Center

    Alderman, C. Wayne; Thompson, James H.

    1986-01-01

    This article focuses on audit risk by examining it in terms of its components: inherent risk, control risk, and detection risk. Discusses applying audit risk, a definition of audit risk, and components of audit risk. (CT)

  14. PERFORMANCE AUDIT PROCEDURES FOR OPACITY MONITORS

    EPA Science Inventory

    The manual contains monitor-specific performance audit procedures and data forms for use in conducting audits of installed opacity continuous emission monitoring systems (CEMS). General auditing procedures and acceptance limits for various audit criteria are discussed. Practical ...

  15. Auditing the auditors.

    PubMed

    Pallarito, K

    1998-09-21

    An independent auditor's opinion is supposed to be the gold standard in healthcare accounting. Such audits provide reasonable assurance that financial statements are accurate, which is particularly important in not-for-profit healthcare because most organizations don't have shareholder oversight. But the recent firing of a Big Five accounting firm by a major healthcare system in bankruptcy reorganization raises questions about the credibility of external audits. PMID:10185568

  16. Oneida Tribe Energy Audits

    SciTech Connect

    Olson, Ray; Schubert, Eugene

    2014-08-15

    Project funding energy audits of 44 Tribally owned buildings operated by the Oneida Tribe of Indians of WI. Buildings were selected for their size, age, or known energy concerns and total over 1 million square feet. Audits include feasibility studies, lists of energy improvement opportunities, and a strategic energy plan to address cost effective ways to save energy via energy efficiency upgrades over the short and long term.

  17. Energy audits at 48 hospitals

    NASA Astrophysics Data System (ADS)

    Hirst, E.

    1981-11-01

    Staff at the Oak Ridge Associated Universities (ORAU) conducted energy audits at 48 hospitals in four states (New York, Pennsylvania, Virginia, Tennessee) between 1978 and 1980. Staff at the Oak Ridge National Laboratory (ORNL) and ORAU developed and organized a computerized data base containing information from these audits. This paper describes the ORAU audit process; summarizes the data collected from these audits on hospital characteristics annual energy use, and the audit recommendations; and analyzes the audit data in terms of cost effectiveness, type of recommendations, and the relationship between potential energy saving and characteristics of the individual hospital.

  18. Manager's handbook for software development, revision 1

    NASA Technical Reports Server (NTRS)

    1990-01-01

    Methods and aids for the management of software development projects are presented. The recommendations are based on analyses and experiences of the Software Engineering Laboratory (SEL) with flight dynamics software development. The management aspects of the following subjects are described: organizing the project, producing a development plan, estimating costs, scheduling, staffing, preparing deliverable documents, using management tools, monitoring the project, conducting reviews, auditing, testing, and certifying.

  19. 7 CFR 1773.7 - Audit standards.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... 7 Agriculture 12 2010-01-01 2010-01-01 false Audit standards. 1773.7 Section 1773.7 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.7 Audit standards. (a) The audit must be performed in accordance with GAGAS and this part. The audit must be performed in...

  20. 29 CFR 96.42 - Audit standards.

    Code of Federal Regulations, 2010 CFR

    2010-07-01

    ... 29 Labor 1 2010-07-01 2010-07-01 true Audit standards. 96.42 Section 96.42 Labor Office of the Secretary of Labor AUDIT REQUIREMENTS FOR GRANTS, CONTRACTS, AND OTHER AGREEMENTS Access to Records, Audit Standards and Relation of Organization-wide Audits to Other Audit Requirements § 96.42 Audit...

  1. 7 CFR 1773.7 - Audit standards.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 7 Agriculture 12 2011-01-01 2011-01-01 false Audit standards. 1773.7 Section 1773.7 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.7 Audit standards. (a) The audit must be performed in accordance with GAGAS and this part. The audit must be performed in...

  2. 7 CFR 1773.7 - Audit standards.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 7 Agriculture 12 2014-01-01 2013-01-01 true Audit standards. 1773.7 Section 1773.7 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.7 Audit standards. (a) The audit must be performed in accordance with GAGAS and this part. The audit must be performed in...

  3. 7 CFR 1773.7 - Audit standards.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 7 Agriculture 12 2012-01-01 2012-01-01 false Audit standards. 1773.7 Section 1773.7 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.7 Audit standards. (a) The audit must be performed in accordance with GAGAS and this part. The audit must be performed in...

  4. 7 CFR 1773.7 - Audit standards.

    Code of Federal Regulations, 2013 CFR

    2013-01-01

    ... 7 Agriculture 12 2013-01-01 2013-01-01 false Audit standards. 1773.7 Section 1773.7 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.7 Audit standards. (a) The audit must be performed in accordance with GAGAS and this part. The audit must be performed in...

  5. 29 CFR 96.42 - Audit standards.

    Code of Federal Regulations, 2014 CFR

    2014-07-01

    ... 29 Labor 1 2014-07-01 2013-07-01 true Audit standards. 96.42 Section 96.42 Labor Office of the... Standards and Relation of Organization-wide Audits to Other Audit Requirements § 96.42 Audit standards. Surveys, audits, and examinations will conform to the Government auditing standards, issued by...

  6. Acid Rain Program CEM audit program

    SciTech Connect

    Nguyen, K.O.T.; Alexander, T.H.; Dupree, J.C.

    1997-12-31

    This presentation will give an overview of the Acid Rain Program CEM Audit Program: electronic and field audits. The presentation will include the reasons for audits, field audit types and levels the steps used in develop in the audit program and the audit procedures.

  7. The audit process: Part I. Pre-audit preparation.

    PubMed

    Bialachowski, Anne; Clinker, Karen; LeBlanc, Mary; McDonald, Shirley

    2010-01-01

    Infection prevention and control audits are an important element in the achievement of a health care setting's patient safety goals. The successful audit can result in enhanced partnerships between infection control professionals and other departments and services in the organization, implement change and lead to continuing improvement in outcomes for patients/residents and staff. In this first part of the audit process, the preparation leading up to the actual administration of the audit is described. PMID:20469658

  8. Data-Linking Requirements in Facilities Condition Audit RFPs.

    ERIC Educational Resources Information Center

    DeFranco, Randall W.

    2002-01-01

    Discusses why, when preparing a Request for Proposal (RFP) for Facilities Condition Audit (FCA)--including software-based delivery of findings--facilities managers should avoid complicating the bidding process with nondescript data-linking requirements. Presents ways to get an apples-to-apples comparison of bids for a proposed FCA project and…

  9. Decentralization Calls for Internal Audits.

    ERIC Educational Resources Information Center

    DiCello, Jim

    1995-01-01

    Outlines internal-auditing strategies necessitated by decentralization. Describes the following areas of concern: the student activities account, student attendance, and funding delegated to the site level. Guidelines for conducting an internal audit are also included. (LMI)

  10. How to Teach Programming Indirectly--Using Spreadsheet Application

    ERIC Educational Resources Information Center

    Tahy, Zsuzsanna Szalayné

    2016-01-01

    It is a question in many countries whether ICT and application usage should be taught. There are some problems with IT literacy: users do not understand the concepts of a software, they cannot solve problems, and moreover, using applications gives them more problems. Consequently, using ICT seems to slow work down. Experts suggest learning…

  11. CSAM Metrology Software Tool

    NASA Technical Reports Server (NTRS)

    Vu, Duc; Sandor, Michael; Agarwal, Shri

    2005-01-01

    CSAM Metrology Software Tool (CMeST) is a computer program for analysis of false-color CSAM images of plastic-encapsulated microcircuits. (CSAM signifies C-mode scanning acoustic microscopy.) The colors in the images indicate areas of delamination within the plastic packages. Heretofore, the images have been interpreted by human examiners. Hence, interpretations have not been entirely consistent and objective. CMeST processes the color information in image-data files to detect areas of delamination without incurring inconsistencies of subjective judgement. CMeST can be used to create a database of baseline images of packages acquired at given times for comparison with images of the same packages acquired at later times. Any area within an image can be selected for analysis, which can include examination of different delamination types by location. CMeST can also be used to perform statistical analyses of image data. Results of analyses are available in a spreadsheet format for further processing. The results can be exported to any data-base-processing software.

  12. Audits that Make a Difference

    SciTech Connect

    Malsbury, Judith

    1999-02-01

    This paper presents guidance on how to perform internal audits that get management's attention and result in effective corrective action. It assumes that the reader is already familiar with the basic constructs of auditing and knows how to perform them. Instead, it focuses on additional techniques that have proven to be effective in our internal auditing program. Examples using a theoretical audit of a calibration program are included.

  13. Internal Audit in Higher Education.

    ERIC Educational Resources Information Center

    Holmes, Alison, Ed.; Brown, Sally, Ed.

    This book describes a range of examples of internal audit in higher education as part of a process of the exchange of good practice. The book recognizes well-established links with audit theory from other contexts and makes use of theoretical perspectives explored in the financial sector. The chapters are: (1) "Quality Audit Issues" (Sally Brown…

  14. Developmental Audits with Challenging Youth

    ERIC Educational Resources Information Center

    Brendtro, Larry K.; du Toit, Lesley; Bath, Howard; Van Bockern, Steve

    2006-01-01

    The Developmental Audit[R] is a new strength-based assessment model for youth who are in conflict in home, school, or community. Developmental Audits involve collaboration with young persons who are seen as experts on themselves. Discussing challenging life events provides a window to the young person's private logic and goals. The audit scans…

  15. Preparing for the Annual Audit.

    ERIC Educational Resources Information Center

    Nuehring, Bert

    2002-01-01

    Proposes several key questions that school district business officials should answer to prepare for an annual financial audit involving auditor information and resource needs, district and auditor monitoring and reporting on the audit progress, and reporting the results of the audit to the board of education. (PKP)

  16. Using Appleworks V1.3 To Construct Spreadsheet Files for the Apple IIe Computer. First Edition.

    ERIC Educational Resources Information Center

    Schlenker, Richard M.; Schlenker, Deborah S.

    This guide was developed as a "how to" training device for constructing spreadsheet files using AppleWorks on the Apple IIe computer with a Duodisk or two disk drives. Step-by-step instructions are provided for program loading, selecting the spreadsheet option, setting column widths, naming columns and fields, justifying labels and values,…

  17. Developing Simple Budgets Using the AppleWorks Spreadsheet Subprogram, Apple IIe or GS Computers, and a Single Disk Drive.

    ERIC Educational Resources Information Center

    Schlenker, Richard M.

    This manual is a "how to" training device for developing spreadsheet files in the AppleWorks program using an Apple IIe or Apple IIGS Computer with a single disk drive. The manual provides step-by-step directions, and includes 36 figures depicting the computer screen at the various stages of the spreadsheet development sequence. (EW)

  18. Auditing audits: use and development of the Oxfordshire Medical Audit Advisory Group rating system.

    PubMed Central

    Lawrence, M.; Griew, K.; Derry, J.; Anderson, J.; Humphreys, J.

    1994-01-01

    OBJECTIVES--To assess the value of the Oxfordshire Medical Audit Advisory Group rating system in monitoring and stimulating audit activity, and to implement a development of the system. DESIGN--Use of the rating system for assessment of practice audits on three annual visits in Oxfordshire; development and use of an "audit grid" as a refinement of the system; questionnaire to all medical audit advisory groups in England and Wales. SETTING--All 85 general practices in Oxfordshire; all 95 medical audit advisory groups in England and Wales. MAIN OUTCOME MEASURES--Level of practices' audit activity as measured by rating scale and grid. Use of scale nationally together with perceptions of strengths and weaknesses as perceived by chairs of medical audit advisory groups. RESULTS--After one year Oxfordshire practices more than attained the target standards set in 1991, with 72% doing audit involving setting target standards or implementing change; by 1993 this had risen to 78%. Most audits were confined to chronic disease management, preventive care, and appointments. 38 of 92 medical audit advisory groups used the Oxfordshire group's rating scale. Its main weaknesses were insensitivity in assessing the quality of audits and failure to measure team involvement. CONCLUSIONS--The rating system is effective educationally in helping practices improve and summatively for providing feedback to family health service authorities. The grid showed up weakness in the breadth of audit topics studied. IMPLICATIONS AND ACTION--Oxfordshire practices achieved targets set for 1991-2 but need to broaden the scope of their audits and the topics studied. The advisory group's targets for 1994-5 are for 50% of practices to achieve an audit in each of the areas of clinical care, access, communication, and professional values and for 80% of audits to include setting targets or implementing change. PMID:8086911

  19. Walkability Audit Tool.

    PubMed

    Smith, Letha

    2015-09-01

    Walking is one of the simplest lifestyle changes workers can make to improve their health. Research shows a wealth of health benefits. Often, occupational and environmental health nurses are in charge of implementing walking programs. A tool is needed to continuously improve a company's walking program whether in the beginning stages or to an already established program. The Centers for Disease Control and Prevention (CDC) Walkability Audit Tool for a healthier worksite is an easy seven-step audit tool that occupational and environmental health nurses can easily implement. PMID:26215975

  20. National Energy Audit

    Energy Science and Technology Software Center (ESTSC)

    2001-12-30

    A user-friendly, advanced computer energy audit, the National Energy Audit (NEAT) has been developed by the Existing Buildings Research Program at Oak Ridge National Laboratory''s (ORNL''s) Building Technology Center for the U.S. Department of Energy''s (DOE''s) Weatherization Assistance and Existing Buildings Program. The computer program is designed for use by State agencies and utilities to determine the most cost-effective retrofit measures for single-family homes to increase the energy efficiency and comfort level. NEAT7.1.3 contains minormore » changes and improvements in NEAT7.1.« less

  1. A prototype Distributed Audit System

    SciTech Connect

    Banning, D.L.

    1993-08-01

    Security auditing systems are used to detect and assess unauthorized or abusive system usage. Historically, security audits were confined to a single computer system. Recent work examines ways of extending auditing to include heterogeneous groups of computers (distributed system). This paper describes the design and prototype development of a Distributed Audit System (DAS) which was developed with funding received from Lawrence Livermore Laboratory and through the Master`s thesis effort performed by the author at California State University, Long Beach. The DAS is intended to provide collection, transfer, and control of audit data on distributed, heterogeneous hosts.

  2. An Excel spreadsheet to classify chemical analyses of amphiboles following the IMA 2012 recommendations

    NASA Astrophysics Data System (ADS)

    Locock, Andrew J.

    2014-01-01

    A Microsoft Excel spreadsheet has been programmed to assist with classification of chemical analyses of orthorhombic and monoclinic amphiboles following the 2012 nomenclature recommended by the International Mineralogical Association. The spreadsheet is intended for use only with compositional data (wt% oxides and halogens, rather than atomic proportions) and provides options for the estimation of Fe3+/ΣFe and Mn3+/ΣMn ratios and OH content. Various cation normalization schemes can be automatically or manually selected. For each analysis, the output includes the group, subgroup (or B-occupancy for the oxo-amphiboles), and species name including any mandatory chemical prefixes, along with a formula based on 24 anions. The formula results can be exported in a form suitable for the AMPH2012 program. Prefixes related to space groups (proto-) and suffixes (-P21/m) are not assigned in the spreadsheet. Large data sets (up to 200 analyses at a time) can be accommodated by the spreadsheet, which is accompanied by results calculated for more than 650 amphibole analyses taken from the literature.

  3. Solving Continuous-Time Optimal-Control Problems with a Spreadsheet.

    ERIC Educational Resources Information Center

    Naevdal, Eric

    2003-01-01

    Explains how optimal control problems can be solved with a spreadsheet, such as Microsoft Excel. Suggests the method can be used by students, teachers, and researchers as a tool to find numerical solutions for optimal control problems. Provides several examples that range from simple to advanced. (JEH)

  4. VENTSAR XL - A spreadsheet for analyzing building effects and plume rise

    SciTech Connect

    Simpkins, A.A.

    1997-03-01

    VENTSAR XL is a Microsoft Excel spreadsheet that analyzes flow patterns of pollutants on or near buildings. Plume rise may be considered. This report provides a complete description and verification of all models within VENTSAR XL. User instructions also are included.

  5. The Spreadsheet in an Educational Setting. Microcomputing Working Paper Series F 84-4.

    ERIC Educational Resources Information Center

    Wozny, Lucy

    This overview of a specific spreadsheet, Microsoft's Multiplan for the Apple Macintosh microcomputer, emphasizes specific features that are important to the academic community, including the mathematical functions of algebra, trigonometry, and statistical analysis. Additional features are summarized, including data formats for both numerical and…

  6. A Simple Spreadsheet Program for the Calculation of Lattice-Site Distributions

    ERIC Educational Resources Information Center

    McCaffrey, John G.

    2009-01-01

    A simple spreadsheet program is presented that can be used by undergraduate students to calculate the lattice-site distributions in solids. A major strength of the method is the natural way in which the correct number of ions or atoms are present, or absent, at specific lattice distances. The expanding-cube method utilized is straightforward to…

  7. Numerical solutions for the one-dimensional heat-conduction equation using a spreadsheet

    NASA Astrophysics Data System (ADS)

    Gvirtzman, Zohar; Garfunkel, Zvi

    1996-12-01

    We show how to use a spreadsheet to calculate numerical solutions of the one-dimensional time-dependent heat-conduction equation. We find the spreadsheet to be a practical tool for numerical calculations, because the algorithms can be implemented simply and quickly without complicated programming, and the spreadsheet utilities can be used not only for graphics, printing, and file management, but also for advanced mathematical operations. We implement the explicit and the Crank-Nicholson forms of the finite-difference approximations and discuss the geological applications of both methods. We also show how to adjust these two algorithms to a nonhomogeneous lithosphere in which the thermal properties (thermal conductivity, density, and radioactive heat generation) change from the upper crust to the lower crust and to the mantle. The solution is presented in a way that can fit any spreadsheet (Lotus-123, Quattro-Pro, Excel). In addition, a Quattro-Pro program with macros that calculate and display the thermal evolution of the lithosphere after a thermal perturbation is enclosed in an appendix.

  8. Six Introductory Lessons for the Microcomputer Spreadsheet. Student's Workbook with Teacher's Key.

    ERIC Educational Resources Information Center

    Chenault, Shirley

    This document contains six lessons for a class on using computer spreadsheets. Each lesson contains an objective, terminology, and directions for step-by-step completion of the lesson activites. Worksheets are included for teachers to replicate and hand out or to use as overhead transparencies. The lessons cover the following concepts:…

  9. How Helpful Are Error Management and Counterfactual Thinking Instructions to Inexperienced Spreadsheet Users' Training Task Performance?

    ERIC Educational Resources Information Center

    Caputi, Peter; Chan, Amy; Jayasuriya, Rohan

    2011-01-01

    This paper examined the impact of training strategies on the types of errors that novice users make when learning a commonly used spreadsheet application. Fifty participants were assigned to a counterfactual thinking training (CFT) strategy, an error management training strategy, or a combination of both strategies, and completed an easy task…

  10. Using an Electronic Spreadsheet Simulator to Teach Neural Modeling of Visual Phenomena. Microcomputing Working Paper Series.

    ERIC Educational Resources Information Center

    Hewett, Thomas T.

    This paper describes how electronic spreadsheet simulators, originally designed to simulate and replace large paper worksheets used in accounting and financial planning, can be used to study and explore functional relationships among a number of parameters. As a way of providing a context for understanding this application of a spreadsheet…

  11. Mathematical Modeling in Science: Using Spreadsheets to Create Mathematical Models and Address Scientific Inquiry

    ERIC Educational Resources Information Center

    Horton, Robert M.; Leonard, William H.

    2005-01-01

    In science, inquiry is used as students explore important and interesting questions concerning the world around them. In mathematics, one contemporary inquiry approach is to create models that describe real phenomena. Creating mathematical models using spreadsheets can help students learn at deep levels in both science and mathematics, and give…

  12. Printing Appleworks V1.3 Spreadsheet Files Using the Apple IIe Computer. First Edition.

    ERIC Educational Resources Information Center

    Schlenker, Richard M.; Schlenker, Deborah S.

    This guide was developed as a "how to" training device for printing spreadsheet files using AppleWorks on the Apple IIe computer with a Duodisk or two disk drives. Step-by-step instructions are provided for selecting the print option; printing entire files; and for printing specific rows, columns, or blocks of the file. For each step, a diagram of…

  13. Archimedes' Law and Potential Energy: Modelling and Simulation with a Spreadsheet.

    ERIC Educational Resources Information Center

    Silva, A. Alberto

    1998-01-01

    Addresses some basic aspects of Archimedes' law. Focus is on potential energy relationships so as to elucidate some common misunderstandings and to facilitate making bridges with other physical topics. A spreadsheet model is used as a simulation tool. (Author/NB)

  14. Flipping the Classroom and Instructional Technology Integration in a College-Level Information Systems Spreadsheet Course

    ERIC Educational Resources Information Center

    Davies, Randall S.; Dean, Douglas L.; Ball, Nick

    2013-01-01

    The purpose of this research was to explore how technology can be used to teach technological skills and to determine what benefit "flipping" the classroom might have for students taking an introductory-level college course on spreadsheets in terms of student achievement and satisfaction with the class. A pretest posttest…

  15. Spreadsheets as a Transparent Resource for Learning the Mathematics of Annuities

    ERIC Educational Resources Information Center

    Pournara, Craig

    2009-01-01

    The ability of mathematics teachers to decompress mathematics and to move between representations are two key features of mathematical knowledge that is usable for teaching. This article reports on four pre-service secondary mathematics teachers learning the mathematics of annuities. In working with spreadsheets students began to make sense of…

  16. Studying Faculty Flows Using an Interactive Spreadsheet Model. AIR 1997 Annual Forum Paper.

    ERIC Educational Resources Information Center

    Kelly, Wayne

    This paper describes a spreadsheet-based faculty flow model developed and implemented at the University of Calgary (Canada) to analyze faculty retirement, turnover, and salary issues. The study examined whether, given expected faculty turnover, the current salary increment system was sustainable in a stable or declining funding environment, and…

  17. Spreadsheet Application Showing the Proper Elevation Angle, Points of Shot and Impact of a Projectile

    ERIC Educational Resources Information Center

    Benacka, Jan

    2015-01-01

    This paper provides the formula for the elevation angle at which a projectile has to be fired in a vacuum from a general position to hit a target at a given distance. A spreadsheet application that models the trajectory is presented, and the problem of finding the points of shot and impact of a projectile moving in a vacuum if three points of the…

  18. A Workshop Approach Using Spreadsheets for the Teaching of Statistics and Probability.

    ERIC Educational Resources Information Center

    Hall, A. G.

    1995-01-01

    Describes an introductory course on data, statistics, and probability given to first-year electronic engineering students at the University of Hull (United Kingdom); it is taught via workshops using spreadsheets. The four components are data and graphs, random data and statistics, probability distributions, and probability and events. (AEF)

  19. Solving a Contextual Problem with the Spreadsheet as an Environment for Algebraic Thinking Development

    ERIC Educational Resources Information Center

    Nobre, Sandra; Amado, Nelia; Carreira, Susana

    2012-01-01

    In this article we report and discuss a contextual problem solving task that was proposed to a class of 8th grade (13-14-year-old) students. These students had been developing a reasonable experience in the use of the spreadsheet to model relations within contextual problems and chose to use this tool to solve the mentioned problem, engaging in…

  20. Spreadsheet Procedure for Simulating Setpoint Tracking in SISO by Dynamic Matrix Control

    ERIC Educational Resources Information Center

    Jang, Larry K.; Lo, Roger C.

    2015-01-01

    The objective of this work is to present a spreadsheet tool that illustrates an ideal case of dynamic matrix control (DMC) calculations. The ideal case presented in this work is a hypothetical single- input-single-output DMC control system for setpoint tracking, in the absence of disturbance and mismatch between the measured and predicted process…

  1. Mediation of a Teacher's Development of Spreadsheets as an Instrument to Support Pupils' Inquiry in Mathematics

    ERIC Educational Resources Information Center

    Fuglestad, Anne Berit

    2013-01-01

    This paper presents a case of collaboration with three teachers and a didactician on task development within a developmental research project based on ideas of inquiry and learning community. The teachers' goal was to utilise a spreadsheet to orchestrate the pupils' investigations and build a library of tasks for the classroom. The focus is on one…

  2. Pre-Service Mathematics Teachers' Learning and Teaching of Activity-Based Lessons Supported with Spreadsheets

    ERIC Educational Resources Information Center

    Agyei, Douglas D.; Voogt, Joke M.

    2016-01-01

    In this study, 12 pre-service mathematics teachers worked in teams to develop their knowledge and skills in using teacher-led spreadsheet demonstrations to help students explore mathematics concepts, stimulate discussions and perform authentic tasks through activity-based lessons. Pre-service teachers' lesson plans, their instruction of the…

  3. Teachers' Emergent Goals in Spreadsheet-Based Lessons: Analyzing the Complexity of Technology Integration

    ERIC Educational Resources Information Center

    Lagrange, Jean-Baptiste; Erdogan, Emel Ozdemir

    2009-01-01

    We examine teachers' classroom activities with the spreadsheet, focusing especially on episodes marked by improvisation and uncertainty. The framework is based on Saxe's cultural approach to cognitive development. The study considers two teachers, one positively disposed towards classroom use of technology, and the other not, both of them…

  4. Using a Spreadsheet to Analyze the Thermal Performance of a Model House.

    ERIC Educational Resources Information Center

    Chamberlain, Peter; Vincent, Richard

    1989-01-01

    Described is a means of logging data from remote sensors in data files and then transferring the data to a spreadsheet for processing. The presentation of the data in tabular or graphical form is discussed. An example using temperature data from a model house is provided. (Author/CW)

  5. Numerical Modelling with Spreadsheets as a Means to Promote STEM to High School Students

    ERIC Educational Resources Information Center

    Benacka, Jan

    2016-01-01

    The article gives an account of an experiment in which sixty-eight high school students of age 16 - 19 developed spreadsheet applications that simulated fall and projectile motion in the air. The students applied the Euler method to solve the governing differential equations. The aim was to promote STEM to the students and motivate them to study…

  6. Evolving Polygons and Spreadsheets: Connecting Mathematics across Grade Levels in Teacher Education

    ERIC Educational Resources Information Center

    Abramovich, Sergei; Brouwer, Peter

    2009-01-01

    This paper was prepared in response to the Conference Board of Mathematical Sciences recommendations for the preparation of secondary teachers. It shows how using trigonometry as a conceptual tool in spreadsheet-based applications enables one to develop mathematical understanding in the context of constructing geometric representations of unit…

  7. [Nurses' practice in health audit].

    PubMed

    Pinto, Karina Araújo; de Melo, Cristina Maria Meira

    2010-09-01

    The objective of this investigation was to identify nurses' practice in heath audit. The hermeneutic-dialectic method was used for the analysis. The study was performed in three loci: the internal audit service of a hospital; the external audit service of a private health service buyer, and the state audit service of the public health system (SUS, acronym in Portuguese for Sistema Unico de Saúde-Unique Health System), in Bahia. Nine audit nurses were interviewed. In the SUS audit, the nurses report being fulfilled with their practice and with the valorization of their professional role. In the private audit--both inside and outside of health organizations--the nurses' activities are focused on meeting the interests of their contractors, and do not get much involved with the care delivered by the nursing team and with the needs of service users. PMID:20964043

  8. Designing for Audit: A Voting Machine with a Tiny TCB

    NASA Astrophysics Data System (ADS)

    Gardner, Ryan W.; Garera, Sujata; Rubin, Aviel D.

    Thoroughly auditing voting machine software has proved to be difficult, and even efforts to reduce its complexity have relied on significant amounts of external code. We design and implement a device that allows a voter to confirm and cast her vote while trusting only 1,034 lines of ARM assembly. The system, which we develop from scratch, supports visually (and hearing) impaired voters and ensures the privacy of the voter as well as the integrity of the tally under some common assumptions. We employ several techniques to increase the readability of our code and make it easier to audit.

  9. Conducting a Technology Audit

    ERIC Educational Resources Information Center

    Flaherty, William

    2011-01-01

    Technology is a critical component in the success of any high-functioning school district, thus it is important that education leaders should examine it closely. Simply put, the purpose of a technology audit is to assess the effectiveness of the technology for administrative or instructional use. Rogers Public Schools in Rogers, Arkansas, recently…

  10. Going beyond Audit

    ERIC Educational Resources Information Center

    Thomas, Mike; Liss, Anne; Milner, Alastair

    2011-01-01

    This article describes the work undertaken by a cluster of Resource Teachers: Learning and Behaviour (RTLB) to ensure that annual effectiveness reviews were more than a compliance exercise but a genuine attempt to improve their service to schools, hence the title of this article of "Going Beyond Audit". Historically, the cluster had met the…