Science.gov

Sample records for spreadsheet auditing software

  1. 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.

  2. 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)

  3. 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)

  4. Simulation Software's Effect on College Students Spreadsheet Project Scores

    ERIC Educational Resources Information Center

    Atkinson, J. Kirk; Thrasher, Evelyn H.; Coleman, Phillip D.

    2011-01-01

    The purpose of this study is to explore the potential impact of support materials on student spreadsheet skill acquisition. Specifically, this study examines the use of an online spreadsheet simulation tool versus a printed book across two independent student groups. This study hypothesizes that the online spreadsheet simulation tool will have a…

  5. 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)

  6. [Estimation of T1 and T2 using general-purpose spreadsheet software].

    PubMed

    Kawamata, Wataru; Toyoshima, Hideto

    2009-03-20

    We performed an estimation of longitudinal (T1) and transverse relaxation (T2) time using the general-purpose spreadsheet software Microsoft Excel. The Excel tool "solver" is useful for the simultaneous estimation of both T1 and steady-state magnetization from the non-linear least square method. The estimation time is quick enough for the purpose. T1 and T2 estimated from handwritten semi-log plots were compared with the results from spreadsheet software from the viewpoint of accuracy using the phantom data. Although the data from handwritten plots include an estimation error of several percent among the subjects, the mean values are almost the same as compared with the data from spreadsheet software.

  7. 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.

  8. 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.

  9. 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.

  10. 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…

  11. 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.

  12. 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.

  13. 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.

  14. 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.

  15. 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.

  16. MINFIT: A Spreadsheet-Based Tool for Parameter Estimation in an Equilibrium Speciation Software Program.

    PubMed

    Xie, Xiongfei; Giammar, Daniel E; Wang, Zimeng

    2016-10-07

    Deterpmination of equilibrium constants describing chemical reactions in the aqueous phase and at solid-water interface relies on inverse modeling and parameter estimation. Although there are existing tools available, the steep learning curve prevents the wider community of environmental engineers and chemists to adopt those tools. Stemming from classical chemical equilibrium codes, MINEQL+ has been one of the most widely used chemical equilibrium software programs. We developed a spreadsheet-based tool, which we are calling MINFIT, that interacts with MINEQL+ to perform parameter estimations that optimize model fits to experimental data sets. MINFIT enables automatic and convenient screening of a large number of parameter sets toward the optimal solutions by calling MINEQL+ to perform iterative forward calculations following either exhaustive equidistant grid search or randomized search algorithms. The combined use of the two algorithms can securely guide the searches for the global optima. We developed interactive interfaces so that the optimization processes are transparent. Benchmark examples including both aqueous and surface complexation problems illustrate the parameter estimation and associated sensitivity analysis. MINFIT is accessible at http://minfit.strikingly.com .

  17. 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…

  18. 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…

  19. 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.

  20. Color and graphic display (CGD): programs for multiple sequence alignment analysis in spreadsheet software.

    PubMed

    Delamarche, C

    2000-07-01

    Interpretation of multiple sequence alignments is of major interest for the prediction of functional and structural domains in proteins or for the organization of related sequences in families and subfamilies. However, a necessity for the bench scientist is the use of outstanding programs in a friendly computing environment. This paper describes Color and Graphic Display (CGD), a set of modules that runs as part of the Microsoft Excel spreadsheet to color and analyze multiple sequence alignments. Discussed here are the main functions of CGD and the use of the program to highlight residues of importance in a water channel family. Although CGD was created for protein sequences, most of the modules are compatible with DNA sequences.

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

    PubMed

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

    2008-03-07

    It is important to increase the iodine delivery rate (I), that is the iodine concentration of the contrast material (C) x 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.

  2. 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.

  3. 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.

  4. Development of a Conference Planning Model Using Integrated Database, Word Processing, and Spreadsheet Software.

    ERIC Educational Resources Information Center

    Stevens, William E.

    This report presents a model for conducting a statewide conference for the approximately 900 members of the South Carolina Council of Teachers of Mathematics (SCCTM) using the AppleWorks integrated software as the basis of the implementation plan. The first and second chapters provide background information on the conference and the…

  5. Spreadsheet-Like Image Analysis

    DTIC Science & Technology

    1992-08-01

    1 " DTIC AD-A254 395 S LECTE D, ° AD-E402 350 Technical Report ARPAD-TR-92002 SPREADSHEET-LIKE IMAGE ANALYSIS Paul Willson August 1992 U.S. ARMY...August 1992 4. TITLE AND SUBTITLE 5. FUNDING NUMBERS SPREADSHEET-LIKE IMAGE ANALYSIS 6. AUTHOR(S) Paul Willson 7. PERFORMING ORGANIZATION NAME(S) AND...14. SUBJECT TERMS 15. NUMBER OF PAGES Image analysis , nondestructive inspection, spreadsheet, Macintosh software, 14 neural network, signal processing

  6. [Spreadsheets of a conventional application software for calculation of plausibility of paternity: application to parentage testing with highly polymorphic markers in deceased party].

    PubMed

    Aoki, Y; Hashiyada, M; Morioka, A; Nata, M; Sagisaka, K

    1997-06-01

    We designed a spreadsheet package for the computation of plausibility of paternity, that can cope with highly polymorphic genetic markers and cases of deceased parties. The application program is Microsoft EXCEL, which is one of the best-selling spreadsheet software running on both Microsoft Windows and Macintosh OS. Komatsu's formula for paternity testing was mainly employed in the spreadsheet package. Probability of the mother-child-alleged father combination was calculated using "IF" function to compare the members' genotypes, whereas "VLOOKUP (or HLOOKUP)" function was employed to refer to a list of genes and their frequencies. In case of a phenotype consisting of several genotypes, the list of phenotypes versus genotypes was also given, to which the function referred. To extend these spreadsheets available for the test of deceased party, additional sheets were also created to estimate frequencies of alleged father's possible genotypes. These probabilities were calculated on the basis of types of his parents and siblings, those of his wife and their biological children, and those of both. This package would be cut out to compute the probability of paternity with extremely polymorphic loci with gentle user interface. Calculation time is satisfactorily short, although it requires considerably large disk space in some extremely complicated cases. Japanese version of this package is freely available at anonymous FTP site of the Department of Forensic Medicine, Tohoku University School of Medicine.

  7. 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

    ... Institute of Electrical and Electronics Engineers (IEEE) Standard 1012- 2004, ``IEEE Standard for Software Verification and Validation'' and IEEE Standard 1028-2008, ``IEEE Standard for Software Reviews and Audits... endorse IEEE Std. 1012-2012 rather than IEEE Std. 1012-2004? IEEE Std. 1012-2012 expands the scope of...

  8. 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

    ..., the Institute of Electrical and Electronic Engineers (IEEE) Standard 1012-2004, ``IEEE Standard for Software Verification and Validation,'' and IEEE Std. 1028-2008, ``IEEE Standard for Software Reviews and Audits.'' These two IEEE standards describe methods acceptable to the NRC staff for...

  9. UK audit of single photon emission computed tomography reconstruction software using software generated phantoms.

    PubMed

    Jarritt, P H; Whalley, D R; Skrypniuk, J V; Houston, A S; Fleming, J S; Cosgriff, P S

    2002-05-01

    The purpose of this study was to undertake an audit of the quantitative characteristics of single photon emission computed tomography software using projection data from an analytically generated software phantom and a measured line source. The phantom consisted of three structures. A uniformly filled cylinder, a series of cylindrical rods of various diameters in a background activity with a rod to background ratio of 2:1 and lastly, a set of three concentric rings of activity in the ratio 1:0:1. The phantom contained no added statistical noise. No attenuation was imposed on the data. The phantom was generated analytically and projections were distributed at six different count densities. A single set of projections from a thin line source was also distributed. These data were distributed to centres throughout the UK. Centres were asked to reconstruct the data using a 'ramp only' reconstruction with no additional smoothing function applied. Data were requested for mean and standard deviation in the uniform cylinder, the maximum counts for each cylindrical rod and the mean counts in regions placed within the concentric rings. For the measured line source, centres were asked to measure the full width at half maximum and peak pixel counts for a profile through the reconstructed line. Results from 115 systems were obtained from 100 centres throughout the UK. These provided data from 12 software providers, 11 of these being commercial companies. Data were compared with the known input values and histograms of the distribution of results obtained. Significant differences in quantitative parameters were noted for the different input count densities as well as between suppliers and revisions of software from single suppliers.

  10. Methodology to Assess No Touch Audit Software Using Field Data

    SciTech Connect

    Cai, Jie; Braun, James E.; Langner, M. Rois

    2016-10-01

    The research presented in this report builds upon these previous efforts and proposes a set of tests to assess no touch audit tools using real utility bill and on-site data. The proposed assessment methodology explicitly investigates the behaviors of the monthly energy end uses with respect to outdoor temperature, i.e., the building energy signature, to help understand the Tool's disaggregation accuracy. The project team collaborated with Field Diagnosis Services, Inc. (FDSI) to identify appropriate test sites for the evaluation.

  11. 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)

  12. A microcomputer spreadsheet for aminoglycoside kinetics.

    PubMed

    Kiacz, B J

    1990-05-01

    Development of an aminoglycoside monitoring program need not entail large capital expenditures for pharmacokinetic software. Microsoft's Excel spreadsheet was used to develop a single compartment, first-order kinetics template for individualized aminoglycoside dosing. The formulas employed may be adapted to virtually any other microcomputer spreadsheet package to provide accurate professional results.

  13. Using an Electronic Spreadsheet to Cut Costs in Evaluation.

    ERIC Educational Resources Information Center

    Young, Robert; Steele, Sara

    A microcomputer spreadsheet software package can be used for a variety of tasks to manage a program or research project and to cut costs in evaluation. LOTUS 1 2 3 is a versatile, commonly available, and well-known electronic spreadsheet package. Spreadsheets were originally designed to emulate financial ledgers and balance sheets. They are useful…

  14. Spreadsheet Analysis of Harvesting Systems

    Treesearch

    R.B. Rummer; B.L. Lanford

    1987-01-01

    Harvesting systems can be modeled and analyzed on microcomputers using commercially available "spreadsheet" software. The effect of system or external variables on the production rate or system cost can be evaluated and alternative systems can be easily examined. The tedious calculations associated with such analyses are performed by the computer. For users...

  15. 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.

  16. Spreadsheets, Powerful Tools in Science Education.

    ERIC Educational Resources Information Center

    Goodfellow, T.

    1990-01-01

    Examined are applications of computer spreadsheets from simple record/observation tables to custom built analysis systems. The advantages and disadvantages depending on the use of these software packages are discussed. Several examples are used to illustrate possible applications. (CW)

  17. 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)

  18. 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)

  19. DataSpread: Unifying Databases and Spreadsheets.

    PubMed

    Bendre, Mangesh; Sun, Bofan; Zhang, Ding; Zhou, Xinyan; Chang, Kevin ChenChuan; Parameswaran, Aditya

    2015-08-01

    Spreadsheet software is often the tool of choice for ad-hoc tabular data management, processing, and visualization, especially on tiny data sets. On the other hand, relational database systems offer significant power, expressivity, and efficiency over spreadsheet software for data management, while lacking in the ease of use and ad-hoc analysis capabilities. We demonstrate DataSpread, a data exploration tool that holistically unifies databases and spreadsheets. It continues to offer a Microsoft Excel-based spreadsheet front-end, while in parallel managing all the data in a back-end database, specifically, PostgreSQL. DataSpread retains all the advantages of spreadsheets, including ease of use, ad-hoc analysis and visualization capabilities, and a schema-free nature, while also adding the advantages of traditional relational databases, such as scalability and the ability to use arbitrary SQL to import, filter, or join external or internal tables and have the results appear in the spreadsheet. DataSpread needs to reason about and reconcile differences in the notions of schema, addressing of cells and tuples, and the current "pane" (which exists in spreadsheets but not in traditional databases), and support data modifications at both the front-end and the back-end. Our demonstration will center on our first and early prototype of the DataSpread, and will give the attendees a sense for the enormous data exploration capabilities offered by unifying spreadsheets and databases.

  20. DataSpread: Unifying Databases and Spreadsheets

    PubMed Central

    Bendre, Mangesh; Sun, Bofan; Zhang, Ding; Zhou, Xinyan; Chang, Kevin ChenChuan; Parameswaran, Aditya

    2015-01-01

    Spreadsheet software is often the tool of choice for ad-hoc tabular data management, processing, and visualization, especially on tiny data sets. On the other hand, relational database systems offer significant power, expressivity, and efficiency over spreadsheet software for data management, while lacking in the ease of use and ad-hoc analysis capabilities. We demonstrate DataSpread, a data exploration tool that holistically unifies databases and spreadsheets. It continues to offer a Microsoft Excel-based spreadsheet front-end, while in parallel managing all the data in a back-end database, specifically, PostgreSQL. DataSpread retains all the advantages of spreadsheets, including ease of use, ad-hoc analysis and visualization capabilities, and a schema-free nature, while also adding the advantages of traditional relational databases, such as scalability and the ability to use arbitrary SQL to import, filter, or join external or internal tables and have the results appear in the spreadsheet. DataSpread needs to reason about and reconcile differences in the notions of schema, addressing of cells and tuples, and the current “pane” (which exists in spreadsheets but not in traditional databases), and support data modifications at both the front-end and the back-end. Our demonstration will center on our first and early prototype of the DataSpread, and will give the attendees a sense for the enormous data exploration capabilities offered by unifying spreadsheets and databases. PMID:26900487

  1. Spreadsheets and Bulgarian goats

    NASA Astrophysics Data System (ADS)

    Sugden, Steve

    2012-10-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 successful and lucid spreadsheet implementation.

  2. An audit of half-count myocardial perfusion imaging using resolution recovery software.

    PubMed

    Lawson, Richard S; White, Duncan; Nijran, Kuldip; Cade, Sarah C; Hall, David O; Kenny, Bob; Knight, Andy; Livieratos, Lefteris; Murray, Anthony; Towey, David

    2014-05-01

    The Nuclear Medicine Software Quality Group of the Institute of Physics and Engineering in Medicine has conducted a multicentre, multivendor audit to evaluate the use of resolution recovery software from several manufacturers when applied to myocardial perfusion data with half the normal counts acquired under a variety of clinical protocols in a range of departments. The objective was to determine whether centres could obtain clinical results with half-count data processed with resolution recovery software that were equivalent to those obtained using their normal protocols. Sixteen centres selected 50 routine myocardial perfusion studies each, from which the Nuclear Medicine Software Quality Group generated simulated half-count studies using Poisson resampling. These half-count studies were reconstructed using resolution recovery and the clinical reports compared with the original reports from the full-count data. A total of 769 patient studies were processed and compared. Eight centres found only a small number of clinically relevant discrepancies between the two reports, whereas eight had an unacceptably high number of discrepancies. There were no significant differences in acquisition parameters between the two groups, although centres finding a high number of discrepancies were more likely to perform both rest and stress scans on normal studies. Half of the participating centres could potentially make use of resolution recovery to reduce the administered activity for myocardial perfusion scans without changing their routine acquisition protocols. The other half could consider adjusting the reconstruction parameters used with their resolution recovery software if they wish to use reduced activity successfully.

  3. Spreadsheet modeling of thermal and lighting performance

    SciTech Connect

    Lord, D.

    1997-12-31

    A series of linked spreadsheets has been developed which allow the designer to model climate effects on and the flow of energy in buildings. Spreadsheet software is widely available, easily operated and adaptable to particular circumstances. Standard engineering formulas are used for heating, cooling and lighting calculations. The analyst can establish what-if relationships by varying assumptions and measuring their effect on the result. Both numerical and graphical output is produced.

  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. Reducing Spreadsheet Errors

    DTIC Science & Technology

    2009-09-01

    Basic for Applications ( VBA ) to improve spreadsheets. Program- ming and coding portions of a spreadsheet in VBA (especially iteration) can reduce...effort as well as errors. Users unfamiliar with VBA may begin learning by “recording macros” in Excel. Microsoft’s online tutorials...www.office.microsoft.com/en-us/excel) provide overviews of this and other VBA capabilities. 5) Thorough documentation of spreadsheet development and application is

  6. 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…

  7. 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…

  8. Methodology to Assess No Touch Audit Software Using Simulated Building Utility Data

    SciTech Connect

    Cheung, Howard; Braun, James E.; Langner, M. Rois

    2016-10-01

    This report describes a methodology developed for assessing the performance of no touch building audit tools and presents results for an available tool. Building audits are conducted in many commercial buildings to reduce building energy costs and improve building operation. Because the audits typically require significant input obtained by building engineers, they are usually only affordable for larger commercial building owners. In an effort to help small building and business owners gain the benefits of an audit at a lower cost, no touch building audit tools have been developed to remotely analyze a building's energy consumption.

  9. 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…

  10. 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…

  11. Preparation of School District Budgets with Microcomputer Electronic Spreadsheets.

    ERIC Educational Resources Information Center

    Hinitz, Herman J.

    1996-01-01

    Preparing a microcomputer electronic spreadsheet containing all relevant school district budgetary information is possible with currently available hardware and software (such as Lotus 1-2-3), despite random-access-memory limitations. Spreadsheets can provide financial summaries, inventory-control listings, scheduling alternatives,…

  12. 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.

  13. 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)

  14. 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)

  15. Spreadsheet Proof of Arguments

    DTIC Science & Technology

    2002-09-01

    This report describes the use of a spreadsheet to solve simple problems in prepositional logic. A spreadsheet can easily generate and recall truth ...tables, and with its built-in logical functions and connectives ft can calculate the truth value of logic expressions. Expressions can also be premises...and together with a conclusion constitute an argument, which can be shown valid with a truth table. This report covers the application of a

  16. Managing Cataloging Statistics with a Spreadsheet.

    ERIC Educational Resources Information Center

    Shelton, Judith M.

    1995-01-01

    Presents aspects of Pullen Library's move from manual to automated management of cataloging statistics, and offers advice to libraries in similar situations. The difficulties included staff resistance, finding the right software package, and spreadsheet training; and the advantage was that the Quattro Pro program reduces complicated spreadsheets…

  17. Managing Cataloging Statistics with a Spreadsheet.

    ERIC Educational Resources Information Center

    Shelton, Judith M.

    1995-01-01

    Presents aspects of Pullen Library's move from manual to automated management of cataloging statistics, and offers advice to libraries in similar situations. The difficulties included staff resistance, finding the right software package, and spreadsheet training; and the advantage was that the Quattro Pro program reduces complicated spreadsheets…

  18. 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)

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

    USDA-ARS?s Scientific Manuscript database

    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. ...

  20. 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)

  1. 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)

  2. Loan and Mortgage Spreadsheet.

    ERIC Educational Resources Information Center

    Burns, Edward

    Information about the effect of changes in interest rates and the length of repayment on mortgages is available through the use of this loan and mortgage spreadsheet program designed for use on Apple computers. It is especially designed to help people evaluate the relative advantages of a variable rate mortgage with a low initial rate of interest…

  3. 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)

  4. "Utstein style" spreadsheet and database programs based on Microsoft Excel and Microsoft Access software for CPR data management of in-hospital resuscitation.

    PubMed

    Adams, Bruce D; Whitlock, Warren L

    2004-04-01

    In 1997, The American Heart Association in association with representatives of the International Committee on Resuscitation (ILCOR) published recommended guidelines for reviewing, reporting and conducting in-hospital cardiopulmonary resuscitation (CPR) outcomes using the "Utstein style". Using these guidelines, we developed two Microsoft Office based database management programs that may be useful to the resuscitation community. We developed a user-friendly spreadsheet based on MS Office Excel. The user enters patient variables such as name, age, and diagnosis. Then, event resuscitation variables such as time of collapse and CPR team arrival are entered from a "code flow sheet". Finally, outcome variables such as patient condition at different time points are recorded. The program then makes automatic calculations of average response times, survival rates and other important outcome measurements. Also using the Utstein style, we developed a database program based on MS Office Access. To promote free public access to these programs, we established at a website. These programs will help hospitals track, analyze, and present their CPR outcomes data. Clinical CPR researchers might also find the programs useful because they are easily modified and have statistical functions.

  5. LICSS - a chemical spreadsheet in microsoft excel.

    PubMed

    Lawson, Kevin R; Lawson, Jonty

    2012-02-02

    Representations of chemical datasets in spreadsheet format are important for ready data assimilation and manipulation. In addition to the normal spreadsheet facilities, chemical spreadsheets need to have visualisable chemical structures and data searchable by chemical as well as textual queries. Many such chemical spreadsheet tools are available, some operating in the familiar Microsoft Excel environment. However, within this group, the performance of Excel is often compromised, particularly in terms of the number of compounds which can usefully be stored on a sheet. LICSS is a lightweight chemical spreadsheet within Microsoft Excel for Windows. LICSS stores structures solely as Smiles strings. Chemical operations are carried out by calling Java code modules which use the CDK, JChemPaint and OPSIN libraries to provide cheminformatics functionality. Compounds in sheets or charts may be visualised (individually or en masse), and sheets may be searched by substructure or similarity. All the molecular descriptors available in CDK may be calculated for compounds (in batch or on-the-fly), and various cheminformatic operations such as fingerprint calculation, Sammon mapping, clustering and R group table creation may be carried out.We detail here the features of LICSS and how they are implemented. We also explain the design criteria, particularly in terms of potential corporate use, which led to this particular implementation. LICSS is an Excel-based chemical spreadsheet with a difference:• It can usefully be used on sheets containing hundreds of thousands of compounds; it doesn't compromise the normal performance of Microsoft Excel• It is designed to be installed and run in environments in which users do not have admin privileges; installation involves merely file copying, and sharing of LICSS sheets invokes automatic installation• It is free and extensibleLICSS is open source software and we hope sufficient detail is provided here to enable developers to add their

  6. LICSS - a chemical spreadsheet in microsoft excel

    PubMed Central

    2012-01-01

    Background Representations of chemical datasets in spreadsheet format are important for ready data assimilation and manipulation. In addition to the normal spreadsheet facilities, chemical spreadsheets need to have visualisable chemical structures and data searchable by chemical as well as textual queries. Many such chemical spreadsheet tools are available, some operating in the familiar Microsoft Excel environment. However, within this group, the performance of Excel is often compromised, particularly in terms of the number of compounds which can usefully be stored on a sheet. Summary LICSS is a lightweight chemical spreadsheet within Microsoft Excel for Windows. LICSS stores structures solely as Smiles strings. Chemical operations are carried out by calling Java code modules which use the CDK, JChemPaint and OPSIN libraries to provide cheminformatics functionality. Compounds in sheets or charts may be visualised (individually or en masse), and sheets may be searched by substructure or similarity. All the molecular descriptors available in CDK may be calculated for compounds (in batch or on-the-fly), and various cheminformatic operations such as fingerprint calculation, Sammon mapping, clustering and R group table creation may be carried out. We detail here the features of LICSS and how they are implemented. We also explain the design criteria, particularly in terms of potential corporate use, which led to this particular implementation. Conclusions LICSS is an Excel-based chemical spreadsheet with a difference: • It can usefully be used on sheets containing hundreds of thousands of compounds; it doesn't compromise the normal performance of Microsoft Excel • It is designed to be installed and run in environments in which users do not have admin privileges; installation involves merely file copying, and sharing of LICSS sheets invokes automatic installation • It is free and extensible LICSS is open source software and we hope sufficient detail is provided

  7. The Effect of Spreadsheet and Dynamic Geometry Software on the Achievement and Self-Efficacy of 7th-Grade Students

    ERIC Educational Resources Information Center

    Isiksal, Mine; Askar, Petek

    2005-01-01

    Background: Since the early 1980s, there has been a growing interest in the potentiality of computers as facilitators of students' learning. The importance of using technology effectively as a learning tool has been emphasized by many researchers. However, finding good software that encourages pupils to explore and express mathematical ideas is…

  8. AUDIT OF THE AUDITS.

    PubMed

    Alam, Malik Mahmood

    2015-01-01

    Audits play an important role in improving the services to patient care. Our department was involved in carrying out Audits by the trainees on regular basis as suggested by the Royal college and each House officer or the Registrar rotating through was doing an Audit in his/her tenure. Ninteen Audits were done in 3 years in the Pediatric department. We used the criteria suggested for evaluating the quality of Audits and put into the category of full Audits, Partial Audits, Potential Audits and planning Audits. Six of our Audits were full Audits, eleven were partial Audits, two were Potential Audits and none were Planning Audits. We think that as a general trend we had similar shortcomings in quality of our Audits which need to be improved by involving seniors specially in implementing the changes suggested in the Audits otherwise it will not fulfill the Aims and objectives.

  9. 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…

  10. 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.

  11. Value of Information spreadsheet

    DOE Data Explorer

    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.

  12. Dose Calculation Spreadsheet

    SciTech Connect

    Simpkins, Ali

    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 at various downwind distances as specified by the user.

  13. Using Spreadsheets in an Introductory Physics Lab.

    ERIC Educational Resources Information Center

    Guglielmino, Rick

    1989-01-01

    Discusses how a spreadsheet might be used in an introductory physics laboratory. Describes three categories of spreadsheet uses, advantages of spreadsheet, layout, accuracy, and modifications. Gives an example of the variable mass rocket problem with typical display. (YP)

  14. Audit: Prescribing PRN medication.

    PubMed

    Adelaide, Duku; Rawther, Fathima

    2017-09-01

    PRN prescriptions enablehealthcare staff to respond quickly to the urgent clinical needs of the user without having to contact the responsible clinician (RC). One problem, established amongst most institutions by NICE regarding the use of PRN, is that most of these institutions struggle to keep an updated or full record on the PRN medications. Thus, the aim of this audit was to check the record keeping of PRN medications, of two adolescent wards in St Andrews Healthcare Hospital, against the established standards. The standards were acquired from the local trust's medicine policy and are based on good clinical practice and principles. Data were collected over a 3-month period covering all the 16 in-patients of two wards in St Andrew's Healthcare Hospital. Medical case records and drug charts were reviewed retrospectively. All PRN prescriptions were reviewed against the standards. The total percentage of compliance with the standards was analyzed using spreadsheet software. The significant results obtained were that 36% of PRN medications were not cancelled even if they had not been used for >1 month and 23% did not have clear indications of use. Majority of the other standards showed full compliance. Some PRN medications were not cancelled even if not used for >1 month, most likely because it is often uncertain when a service user may require the PRN. This could be overcome by having screening tools such as START/STOP to alert the RC after a month. Also, when filling in the PRN medication chart, clear indication for use must be an obligatory section on the system, in addition to increasing awareness among staff about this common error. Finally, regular review by the RC is required through seasonal audits, especially by medical and pharmaceutical staff, which will help monitor errors as well as increase awareness about PRN prescribing practice.

  15. 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,…

  16. Exploring Difference Equations with Spreadsheets.

    ERIC Educational Resources Information Center

    Walsh, Thomas P.

    1996-01-01

    When using spreadsheets to explore real-world problems involving periodic change, students can observe what happens at each period, generate a graph, and learn how changing the starting quantity or constants affects results. Spreadsheet lessons for high school students are presented that explore mathematical modeling, linear programming, and…

  17. 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,…

  18. 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…

  19. 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.

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

    SciTech Connect

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

    1992-11-01

    This paper discusses a commercial spreadsheet 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.

  1. 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.

  2. 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…

  3. 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…

  4. Mathematical Modeling with MyMaps and Spreadsheets

    ERIC Educational Resources Information Center

    Weber, Victoria; Fortune, Nicholas; Williams, Derek; Whitehead, Ashley

    2016-01-01

    Software programs such as Tinkerplots ® or Geometer's Sketchpad ® can help students solve problems in mathematics classes, but may not be available to them after high school. In contrast, many students who become familiar with Internet tools and programs in office packages (word processing, spreadsheets, etc.) may use them daily to enhance their…

  5. 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…

  6. Mathematical Modeling with MyMaps and Spreadsheets

    ERIC Educational Resources Information Center

    Weber, Victoria; Fortune, Nicholas; Williams, Derek; Whitehead, Ashley

    2016-01-01

    Software programs such as Tinkerplots ® or Geometer's Sketchpad ® can help students solve problems in mathematics classes, but may not be available to them after high school. In contrast, many students who become familiar with Internet tools and programs in office packages (word processing, spreadsheets, etc.) may use them daily to enhance their…

  7. Auditing orthopaedic audit.

    PubMed

    Guryel, E; Acton, K; Patel, S

    2008-11-01

    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. 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. 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. 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.

  8. The Computer Bulletin Board. Modified Gran Plots of Very Weak Acids on a Spreadsheet.

    ERIC Educational Resources Information Center

    Chau, F. T.; And Others

    1990-01-01

    Presented are two applications of computer technology to chemistry instruction: the use of a spreadsheet program to analyze acid-base titration curves and the use of database software to catalog stockroom inventories. (CW)

  9. 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.

  10. Information spreadsheet for Verify user registration

    EPA Pesticide Factsheets

    In this spreadsheet, user(s) provide their company’s manufacturer code, user contact information for Verify, and user roles. This spreadsheet is used for the Company Authorizing Official (CAO), CROMERR Signer, and Verify Submitters.

  11. 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)

  12. 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

  13. 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.

  14. Systematizing Trial and Error Using Spreadsheets.

    ERIC Educational Resources Information Center

    Sgroi, Richard J.

    1992-01-01

    Presents two spreadsheets for middle school students applying Polya's heuristic to help develop number sense, reasoning abilities, and problem-solving skills. Spreadsheet 1, "the coin problem," allows students to vary coin quantities to total $8.32. Spreadsheet 2, "ratios," develops number relationships while finding 3 3-digit…

  15. 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.

  16. 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…

  17. 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.…

  18. 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)

  19. 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)

  20. 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.…

  1. Excel spreadsheet in teaching numerical methods

    NASA Astrophysics Data System (ADS)

    Djamila, Harimi

    2017-09-01

    One of the important objectives in teaching numerical methods for undergraduates’ students is to bring into the comprehension of numerical methods algorithms. Although, manual calculation is important in understanding the procedure, it is time consuming and prone to error. This is specifically the case when considering the iteration procedure used in many numerical methods. Currently, many commercial programs are useful in teaching numerical methods such as Matlab, Maple, and Mathematica. These are usually not user-friendly by the uninitiated. Excel spreadsheet offers an initial level of programming, which it can be used either in or off campus. The students will not be distracted with writing codes. It must be emphasized that general commercial software is required to be introduced later to more elaborated questions. This article aims to report on a teaching numerical methods strategy for undergraduates engineering programs. It is directed to students, lecturers and researchers in engineering field.

  2. 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.

  3. Module Interconnection Frameworks for a Real-Time Spreadsheet

    DTIC Science & Technology

    1993-10-19

    level modular design tools for distributed systems, while also providing a simple and productive programming system for internal module design. 3.2.3...spreadsheet programming tool specifications have been worked out in great detail, and implementation was started in phase I. In the interests of readability...block transfer approach fits well with stateless programming techniques. In fact it can be an advantage in the software design because data references

  4. Using Spreadsheets to Assess Learning

    NASA Astrophysics Data System (ADS)

    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® is a very versatile program for the educator and learner alike.1-4 This paper describes and supports another use for Excel through Reflective Formative Assessment Spreadsheets (RFAS). To illustrate the use of RFAS, Fig. 1 shows a released AP Physics5 question that one student, a group of students, or the entire class may see when they access a prepared RFAS file from a shared drive. Notice that this file has been given a PowerPoint® look by removing scrollbars and gridlines and by using the Full Screen option (Fig. 1, arrow a). Students navigate from one question to the next using the tabs (Fig. 1, arrow b).

  5. 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

  6. 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…

  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. 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)

  9. 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)

  10. 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.

  11. Desiderata for a computer-assisted audit tool for clinical data source verification audits.

    PubMed

    Duda, Stephany N; Wehbe, Firas H; Gadd, Cynthia S

    2010-01-01

    Clinical data auditing often requires validating the contents of clinical research databases against source documents available in health care settings. Currently available data audit software, however, does not provide features necessary to compare the contents of such databases to source data in paper medical records. This work enumerates the primary weaknesses of using paper forms for clinical data audits and identifies the shortcomings of existing data audit software, as informed by the experiences of an audit team evaluating data quality for an international research consortium. The authors propose a set of attributes to guide the development of a computer-assisted clinical data audit tool to simplify and standardize the audit process.

  12. Beyond the Mechanics of Spreadsheets: Using Design Instruction to Address Spreadsheet Errors

    ERIC Educational Resources Information Center

    Schneider, Kent N.; Becker, Lana L.; Berg, Gary G.

    2017-01-01

    Given that the usage and complexity of spreadsheets in the accounting profession are expected to increase, it is more important than ever to ensure that accounting graduates are aware of the dangers of spreadsheet errors and are equipped with design skills to minimize those errors. Although spreadsheet mechanics are prevalent in accounting…

  13. 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.

  14. Understanding Solubility through Excel Spreadsheets

    NASA Astrophysics Data System (ADS)

    Brown, Pamela

    2001-02-01

    This article describes assignments related to the solubility of inorganic salts that can be given in an introductory general chemistry course. Le Châtelier's principle, solubility, unit conversion, and thermodynamics are tied together to calculate heats of solution by two methods: heats of formation and an application of the van't Hoff equation. These assignments address the need for math, graphing, and computer skills in the chemical technology program by developing skill in the use of Microsoft Excel to prepare spreadsheets and graphs and to perform linear and nonlinear curve-fitting. Background information on the value of understanding and predicting solubility is provided.

  15. 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.

  16. Applications Software as Cognitive Enhancers.

    ERIC Educational Resources Information Center

    Lambrecht, Judith J.

    1993-01-01

    Discusses the use of microcomputer applications software in education, reviews the literature involving studies on the development of problem-solving skills and on the instructional use of spreadsheets, and describes a project for secondary school students using spreadsheets that provides cognitive support. (Contains 35 references.) (LRW)

  17. 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)

  18. 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…

  19. 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…

  20. Spreadsheet Design: An Optimal Checklist for Accountants

    ERIC Educational Resources Information Center

    Barnes, Jeffrey N.; Tufte, David; Christensen, David

    2009-01-01

    Just as good grammar, punctuation, style, and content organization are important to well-written documents, basic fundamentals of spreadsheet design are essential to clear communication. In fact, the very principles of good writing should be integrated into spreadsheet workpaper design and organization. The unique contributions of this paper are…

  1. 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)

  2. 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…

  3. 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)

  4. 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…

  5. 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…

  6. Visual Basic programs for spreadsheet analysis.

    PubMed

    Hunt, Bruce

    2005-01-01

    A collection of Visual Basic programs, entitled Function.xls, has been written for ground water spreadsheet calculations. This collection includes programs for calculating mathematical functions and for evaluating analytical solutions in ground water hydraulics and contaminant transport. Several spreadsheet examples are given to illustrate their use.

  7. 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)

  8. Time to audit.

    PubMed

    Smyth, L G; Martin, Z; Hall, B; Collins, D; Mealy, K

    2012-09-01

    Public and political pressures are increasing on doctors and in particular surgeons to demonstrate competence assurance. While surgical audit is an integral part of surgical practice, its implementation and delivery at a national level in Ireland is poorly developed. Limits to successful audit systems relate to lack of funding and administrative support. In Wexford General Hospital, we have a comprehensive audit system which is based on the Lothian Surgical Audit system. We wished to analyse the amount of time required by the Consultant, NCHDs and clerical staff on one surgical team to run a successful audit system. Data were collected over a calendar month. This included time spent coding and typing endoscopy procedures, coding and typing operative procedures, and typing and signing discharge letters. The total amount of time spent to run the audit system for one Consultant surgeon for one calendar month was 5,168 min or 86.1 h. Greater than 50% of this time related to work performed by administrative staff. Only the intern and administrative staff spent more than 5% of their working week attending to work related to the audit. An integrated comprehensive audit system requires a very little time input by Consultant surgeons. Greater than 90% of the workload in running the audit was performed by the junior house doctors and administrative staff. The main financial implications for national audit implementation would relate to software and administrative staff recruitment. Implementation of the European Working Time Directive in Ireland may limit the time available for NCHD's to participate in clinical audit.

  9. 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.

  10. Software.

    ERIC Educational Resources Information Center

    Journal of Chemical Education, 1989

    1989-01-01

    Presented are reviews of two computer software packages for Apple II computers; "Organic Spectroscopy," and "Videodisc Display Program" for use with "The Periodic Table Videodisc." A sample spectrograph from "Organic Spectroscopy" is included. (CW)

  11. 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)

  12. Economic Comparison of Processes Using Spreadsheet Programs

    NASA Technical Reports Server (NTRS)

    Ferrall, J. F.; Pappano, A. W.; Jennings, C. N.

    1986-01-01

    Inexpensive approach aids plant-design decisions. Commercially available electronic spreadsheet programs aid economic comparison of different processes for producing particular end products. Facilitates plantdesign decisions without requiring large expenditures for powerful mainframe computers.

  13. Fitting Planetary Orbits with a Spreadsheet.

    ERIC Educational Resources Information Center

    Bridges, Richard

    1995-01-01

    Describes how to fit binocular observations of the planets to a theoretical model of circular orbits using a modern computer spreadsheet, from which fundamental data about the solar system may be deduced. (AIM)

  14. S2O - A software tool for integrating research data from general purpose statistic software into electronic data capture systems.

    PubMed

    Bruland, Philipp; Dugas, Martin

    2017-01-07

    Data capture for clinical registries or pilot studies is often performed in spreadsheet-based applications like Microsoft Excel or IBM SPSS. Usually, data is transferred into statistic software, such as SAS, R or IBM SPSS Statistics, for analyses afterwards. Spreadsheet-based solutions suffer from several drawbacks: It is generally not possible to ensure a sufficient right and role management; it is not traced who has changed data when and why. Therefore, such systems are not able to comply with regulatory requirements for electronic data capture in clinical trials. In contrast, Electronic Data Capture (EDC) software enables a reliable, secure and auditable collection of data. In this regard, most EDC vendors support the CDISC ODM standard to define, communicate and archive clinical trial meta- and patient data. Advantages of EDC systems are support for multi-user and multicenter clinical trials as well as auditable data. Migration from spreadsheet based data collection to EDC systems is labor-intensive and time-consuming at present. Hence, the objectives of this research work are to develop a mapping model and implement a converter between the IBM SPSS and CDISC ODM standard and to evaluate this approach regarding syntactic and semantic correctness. A mapping model between IBM SPSS and CDISC ODM data structures was developed. SPSS variables and patient values can be mapped and converted into ODM. Statistical and display attributes from SPSS are not corresponding to any ODM elements; study related ODM elements are not available in SPSS. The S2O converting tool was implemented as command-line-tool using the SPSS internal Java plugin. Syntactic and semantic correctness was validated with different ODM tools and reverse transformation from ODM into SPSS format. Clinical data values were also successfully transformed into the ODM structure. Transformation between the spreadsheet format IBM SPSS and the ODM standard for definition and exchange of trial data is feasible

  15. 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…

  16. 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…

  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. A National Framework for Energy Audit Ordinances

    SciTech Connect

    Taylor, Cody; Costa, Marc; Long, Nicholas; Antonoff, Jayson

    2016-08-26

    A handful of U.S. cities have begun to incorporate energy audits into their building energy performance policies. Cities are beginning to recognize an opportunity to use several information tools to bring to real estate markets both motivation to improve efficiency and actionable pointers on how to improve. Care is necessary to combine such tools as operational ratings, energy audits, asset ratings, and building retro-commissioning in an effective policy regime that maximizes market impact. In this paper, the authors focus on energy audits and consider both the needs of the policies' implementers in local governments and the emerging standards and federal tools to improve data collection and practitioner engagement. Over the past two years, we have compared several related data formats such as New York City's existing audit reporting spreadsheet, ASHRAE guidance on building energy auditing, and the DOE Building Energy Asset Score, to identify a possible set of required and optional fields for energy audit reporting programs. Doing so revealed tensions between the ease of data collection and the value of more detailed information, which had implications for the effort and qualifications needed to complete the energy audit. The resulting list of data fields is now feeding back into the regulatory process in several cities currently working on implementing or developing audit policies. Using complementary policies and standardized tools for data transmission, the next generation of policies and programs will be tailored to local building stock and can more effectively target improvement opportunities through each building's life.

  20. 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)

  1. 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)

  2. 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)

  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. Spreadsheet Applications: Prototyping an Innovative Blended Course

    ERIC Educational Resources Information Center

    Baker, J. Howard

    2004-01-01

    After teaching the advanced spreadsheet course at a major university in Louisiana as a traditional classroom course for a number of years, it was decided to create a prototype-blended course, with a considerable portion offered via distance education. This research, which uses a prototyping methodology, is exploratory in nature. Prototyping can…

  6. NEW APPROACHES: Relativity on a spreadsheet

    NASA Astrophysics Data System (ADS)

    Carson, S. R.

    1998-01-01

    A use of spreadsheets to model special relativistic phenomena is presented, based on the connection between electric and magnetic fields in special relativity, suitable for use with A-level students. The time dilation equation is used to carry out transformations between reference frames that show the connection between the fields quantitatively and allow further investigations to be carried out.

  7. 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.

  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. Chiropractic audits

    PubMed Central

    Freedman, Allan M

    2000-01-01

    This paper reviews the process which deals with audits of chiropractic billings. It includes the statutory right to review accounts, the factors which lead to a possible audit, the review process itself as well as the possible outcome of a review. Generally, the number of audits performed on professional practices is minimal in relation to the number of practitioners who submit billings for services. Audits are a matter of public necessity involving accountability to the patient and, if government billings are involved, to the public in general. It is incumbent upon the doctor to ensure that proper protocols exist within his or her office to ensure that an audit is nothing more than opening one’s office for an inspection which should satisfy all of the concerned parties as to legitimacy of the practitioner’s entitlement for reimbursement for services rendered.

  10. Desiderata for a Computer-Assisted Audit Tool for Clinical Data Source Verification Audits

    PubMed Central

    Duda, Stephany N.; Wehbe, Firas H.; Gadd, Cynthia S.

    2013-01-01

    Clinical data auditing often requires validating the contents of clinical research databases against source documents available in health care settings. Currently available data audit software, however, does not provide features necessary to compare the contents of such databases to source data in paper medical records. This work enumerates the primary weaknesses of using paper forms for clinical data audits and identifies the shortcomings of existing data audit software, as informed by the experiences of an audit team evaluating data quality for an international research consortium. The authors propose a set of attributes to guide the development of a computer-assisted clinical data audit tool to simplify and standardize the audit process. PMID:20841814

  11. GeoRePORT Input Spreadsheet

    DOE Data Explorer

    St. Onge, Melinda

    2017-04-27

    The Geothermal Resource Portfolio Optimization and Reporting Tool (GeoRePORT) was developed as a way to distill large amounts of geothermal project data into an objective, reportable data set that can be used to communicate with experts and non-experts. GeoRePORT summarizes (1) resource grade and certainty and (2) project readiness. This Excel file allows users to easily navigate through the resource grade attributes, using drop-down menus to pick grades and project readiness, and then easily print and share the summary with others. This spreadsheet is the first draft, for which we are soliciting expert feedback. The spreadsheet will be updated based on this feedback to increase usability of the tool. If you have any comments, please feel free to contact us.

  12. 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.

  13. Calculation spreadsheet for uncertainty estimation of measurement results in gamma-ray spectrometry and its validation for quality assurance purpose.

    PubMed

    Ceccatelli, Alessia; Dybdal, Ashild; Fajgelj, Ales; Pitois, Aurelien

    2017-03-03

    An Excel calculation spreadsheet has been developed to estimate the uncertainty of measurement results in γ-ray spectrometry. It considers all relevant uncertainty components and calculates the combined standard uncertainty of the measurement result. The calculation spreadsheet has been validated using two independent open access software and is available for download free of charge at: https://nucleus.iaea.org/rpst/ReferenceProducts/Analytical_Methods/index.htm. It provides a simple and easy-to-use template for estimating the uncertainty of γ-ray spectrometry measurement results and supports the radioanalytical laboratories seeking accreditation for their measurements using γ-ray spectrometry.

  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. 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,…

  16. Minority Transportation Expenditures Allocation Model (MITRAM): User documentation for the personal computer spreadsheet version

    SciTech Connect

    Vyas, A.D.; Dantini, D.J.; Marik, S.K.

    1989-02-01

    The Minority Transportation Expenditures Allocation Model (MITRAM) can project various transportation-related attributes of minority and majority populations. Individual components of the model were developed using time-series data and then validated independently using cross-sectional data. The model projects vehicle ownership, vehicle-miles of travel, workers, new car and on-road fleet fuel economy, amount and share of household income spent on gasoline, and household expenditures on public transit and taxis. These attributes are projected for whites, blacks, and both. This report describes how various components of MITRAM work and how to use MITRAM on an Apple Macintosh or an IBM PC. Two spreadsheet software packages are available: Excel for the Macintosh, and Lotus 1-2-3 for the IBM PC. The Excel version produces a set of graphs showing historical and projected values of the transportation attributes, while the LOTUS version presents only the numbers in the spreadsheets. 27 figs., 1 tab.

  17. 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.

  18. Safety Auditing and Assessments

    NASA Astrophysics Data System (ADS)

    Goodin, Ronnie

    2005-12-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.

  19. Factors Affecting the Ability to Detect Spreadsheet Errors

    ERIC Educational Resources Information Center

    Howe, Harry; Simkin, Mark G.

    2006-01-01

    The extensive computational and formatting capabilities of today's spreadsheets enable users to create sophisticated analytical models with professionally formatted outputs. But good-looking reports can mask a host of input errors, formula mistakes, and computational problems. This article examines the subject of spreadsheet error detection in…

  20. 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…

  1. 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)

  2. 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…

  3. NEW APPROACHES: Some ideas for using spreadsheets in physics

    NASA Astrophysics Data System (ADS)

    Cooke, B. A.

    1997-03-01

    Spreadsheets are frequently available on desktop computers, and because of their extensive data manipulation functions and powerful plotting facilities they are finding increasing use in physics teaching. This article is a 'toolbox' of ideas for using spreadsheets to explore random numbers, electric-potential distributions, function fitting and the frequency analysis of waveforms.

  4. A Spreadsheet Simulation for a Young's Double Slits Experiment.

    ERIC Educational Resources Information Center

    Field, Richard

    1995-01-01

    Describes a spreadsheet that can be used to show the changes in intensity of Fraunhofer diffraction patterns produced by a single and double slits arrangement. Discusses a practical demonstration of diffraction that allows data to be logged and entered into the spreadsheet. (DDR)

  5. 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'…

  6. 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,…

  7. 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…

  8. 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.

  9. 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)

  10. 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.

  11. Using Electronic Spreadsheets in Undergraduate Political Science Courses.

    ERIC Educational Resources Information Center

    Pitney, John J., Jr.

    1988-01-01

    Suggests ways undergraduate students can perform political data analyses using electronic spreadsheets. Examples include data from presidential elections, voting information, and welfare budgeting. Illustrates how data can be used as a partisan weapon and in making predictions. Emphasis is upon electronic spreadsheets rather than the more advanced…

  12. 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'…

  13. 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)

  14. 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)

  15. Stretching the Software Dollar: MS-DOS Shareware and Public Domain Software.

    ERIC Educational Resources Information Center

    Grosch, Audrey N.

    1989-01-01

    Discusses shareware and public domain software for MS-DOS systems that are available through bulletin board systems (BBS). Problems with computer viruses are discussed; shareware available for communications, database and file management, spreadsheets, word processing, and menuing software is described; and source information for software is…

  16. Validation of a general practice audit and data extraction tool.

    PubMed

    Peiris, David; Agaliotis, Maria; Patel, Bindu; Patel, Anushka

    2013-11-01

    We assessed how accurately a common general practitioner (GP) audit tool extracts data from two software systems. First, pathology test codes were audited at 33 practices covering nine companies. Second, a manual audit of chronic disease data from 200 random patient records at two practices was compared with audit tool data. Pathology review: all companies assigned correct codes for cholesterol, creatinine and glycated haemoglobin; four companies assigned incorrect codes for albuminuria tests, precluding accurate detection with the audit tool. Case record review: there was strong agreement between the manual audit and the tool for all variables except chronic kidney disease diagnoses, which was due to a tool-related programming error. The audit tool accurately detected most chronic disease data in two GP record systems. The one exception, however, highlights the importance of surveillance systems to promptly identify errors. This will maximise potential for audit tools to improve healthcare quality.

  17. 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.

  18. 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.

  19. 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.

  20. Nonlinear least-squares data fitting in Excel spreadsheets.

    PubMed

    Kemmer, Gerdi; Keller, Sandro

    2010-02-01

    We describe an intuitive and rapid procedure for analyzing experimental data by nonlinear least-squares fitting (NLSF) in the most widely used spreadsheet program. Experimental data in x/y form and data calculated from a regression equation are inputted and plotted in a Microsoft Excel worksheet, and the sum of squared residuals is computed and minimized using the Solver add-in to obtain the set of parameter values that best describes the experimental data. The confidence of best-fit values is then visualized and assessed in a generally applicable and easily comprehensible way. Every user familiar with the most basic functions of Excel will be able to implement this protocol, without previous experience in data fitting or programming and without additional costs for specialist software. The application of this tool is exemplified using the well-known Michaelis-Menten equation characterizing simple enzyme kinetics. Only slight modifications are required to adapt the protocol to virtually any other kind of dataset or regression equation. The entire protocol takes approximately 1 h.

  1. A numerical model and spreadsheet interface for pumping test analysis.

    PubMed

    Johnson, G S; Cosgrove, D M; Frederick, D B

    2001-01-01

    Curve-matching techniques have been the standard method of aquifer test analysis for several decades. A variety of techniques provide the capability of evaluating test data from confined, unconfined, leaky aquitard, and other conditions. Each technique, however, is accompanied by a set of assumptions, and evaluation of a combination of conditions can be complicated or impossible due to intractable mathematics or nonuniqueness of the solution. Numerical modeling of pumping tests provides two major advantages: (1) the user can choose which properties to calibrate and what assumptions to make; and (2) in the calibration process the user is gaining insights into the conceptual model of the flow system and uncertainties in the analysis. Routine numerical modeling of pumping tests is now practical due to computer hardware and software advances of the last decade. The RADFLOW model and spreadsheet interface presented in this paper is an easy-to-use numerical model for estimation of aquifer properties from pumping test data. Layered conceptual models and their properties are evaluated in a trial-and-error estimation procedure. The RADFLOW model can treat most combinations of confined, unconfined, leaky aquitard, partial penetration, and borehole storage conditions. RADFLOW is especially useful in stratified aquifer systems with no identifiable lateral boundaries. It has been verified to several analytical solutions and has been applied in the Snake River Plain Aquifer to develop and test conceptual models and provide estimates of aquifer properties. Because the model assumes axially symmetrical flow, it is limited to representing multiple aquifer layers that are laterally continuous.

  2. Geodynamics for Everyone: Robust Finite-Difference Heat Transfer Models using MS Excel 2007 Spreadsheets

    NASA Astrophysics Data System (ADS)

    Grose, C. J.

    2008-05-01

    Numerical geodynamics models of heat transfer are typically thought of as specialized topics of research requiring knowledge of specialized modelling software, linux platforms, and state-of-the-art finite-element codes. I have implemented analytical and numerical finite-difference techniques with Microsoft Excel 2007 spreadsheets to solve for complex solid-earth heat transfer problems for use by students, teachers, and practicing scientists without specialty in geodynamics modelling techniques and applications. While implementation of equations for use in Excel spreadsheets is occasionally cumbersome, once case boundary structure and node equations are developed, spreadsheet manipulation becomes routine. Model experimentation by modifying parameter values, geometry, and grid resolution makes Excel a useful tool whether in the classroom at the undergraduate or graduate level or for more engaging student projects. Furthermore, the ability to incorporate complex geometries and heat-transfer characteristics makes it ideal for first and occasionally higher order geodynamics simulations to better understand and constrain the results of professional field research in a setting that does not require the constraints of state-of-the-art modelling codes. The straightforward expression and manipulation of model equations in excel can also serve as a medium to better understand the confusing notations of advanced mathematical problems. To illustrate the power and robustness of computation and visualization in spreadsheet models I focus primarily on one-dimensional analytical and two-dimensional numerical solutions to two case problems: (i) the cooling of oceanic lithosphere and (ii) temperatures within subducting slabs. Excel source documents will be made available.

  3. User Interface Software Tools

    DTIC Science & Technology

    1994-08-01

    97. 19. Mark A. Flecchia and R. Daniel Bergeron. Specifying Complex Dialogs in ALGAE. Human Factors in Computing Systems, CHI+GI󈨛, Toronto, Ont...Spreadsheet Model. Tech. Rept. GIT-GVU-93-20, Georgia Tech Graphics, Visualization and Usability Center, May, 1993. 35. Daniel H.H. Ingalls. "I’he Smalltalk...Interactive Graphical Applications". Comm. ACM 36,4 (April 1993), 41-55. User Interface Software Tools -39 38. Anthony Karrer and Walt Scacchi . Requirements

  4. Spreadsheet use to calculate creatinine clearance from serum creatinine.

    PubMed

    Shrewsberry, Timothy W; Banoub, Ashraf; Fleming, Kevin; Snyder, Holly; Stehlik, James

    2007-12-01

    Spreadsheets may be created to include the Cockcroft-Gault Formula (CGF) for creatinine-based estimation of glomerular filtration rate. Creatinine clearance (CrCl) provides a more accurate method for perioperative risk assessment of renal function than serum creatinine. CrCl may be used to develop guidelines for renal protective management strategies during cardiopulmonary bypass. CGF uses serum creatinine, age, kilogram weight, sex, and "logical test" functions within the spreadsheet to calculate the CrCl. Implementation of spreadsheets has the potential for numerous other calculations and may provide an accurate and consistent method of clinical perfusion management.

  5. Using Spreadsheets in the Management, Analysis, and Reporting of Evaluation Data.

    ERIC Educational Resources Information Center

    Glowacki, Margaret L.; Rice, Richard L., Jr.

    Currently available spreadsheet programs for microcomputers provide many features that can be very useful for evaluators and researchers. Some of the basic concepts involved in spreadsheet use are introduced, and information is provided on the use of spreadsheets in maintaining and analyzing evaluation data. The spreadsheet used in the discussion…

  6. 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)

  7. 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)

  8. 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.

  9. 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)

  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. Strontium-90 Error Discovered in Subcontract Laboratory Spreadsheet

    SciTech Connect

    D. D. Brown A. S. Nagel

    1999-07-31

    West Valley Demonstration Project health physicists and environment scientists discovered a series of errors in a subcontractor's spreadsheet being used to reduce data as part of their strontium-90 analytical process.

  12. Use of Spreadsheets in Introductory Statistics and Probability.

    ERIC Educational Resources Information Center

    Mitchell, Brian S.

    1997-01-01

    Provides details of a course that introduces chemical engineering students to a variety of spreadsheet applications. The course is taken concurrently with stoichiometry and introduces statistical analysis, probability, reliability, and quality control. (DDR)

  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. 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)

  15. Using spreadsheet modelling to teach about feedback in physics

    NASA Astrophysics Data System (ADS)

    Lingard, Michael

    2003-09-01

    This article looks generally at spreadsheet modelling of feedback situations. It has several benefits as a teaching tool. Additionally, a consideration of the limitations of calculating at many discrete points can lead, at A-level, to an appreciation of the need for the calculus. Feedback situations can be used to introduce the idea of differential equations. Microsoft ExcelTM is the spreadsheet used.

  16. Financial audit

    SciTech Connect

    Not Available

    1992-01-01

    The Trans-Alaska Pipeline Liability Fund, a nonprofit corporate entity created in 1973, pays claims for damages, including cleanup costs, arising from oil discharges from vessel transporting Trans-Alaska Pipeline System oil loaded at Alaskan terminals to ports under U.S. jurisdiction. This paper presents the results of GAO's view of the independent certified public accountants' audit of the Fund's financial statements as of December 31, 1990. GAO also assesses progress toward disposing of the Fund's balances and terminating the Fund.

  17. Spreadsheet Assessment Tool v. 2.4

    SciTech Connect

    Allen, David J.; Martinez, Ruben

    2016-03-03

    The Spreadsheet Assessment Tool (SAT) is an easy to use, blast assessment tool that is intended to estimate the potential risk due to an explosive attack on a blood irradiator. The estimation of risk is based on the methodology, assumptions, and results of a detailed blast effects assessment study that is summarized in Sandia National Laboratories Technical Report SAND2015-6166. Risk as defined in the report and as used in the SAT is: "The potential risk of creating an air blast-induced vent opening at a buildings envelope surface". Vent openings can be created at a buildings envelope through the failure of an exterior building component—like a wall, window, or door—due to an explosive sabotage of an irradiator within the building. To estimate risk, the tool requires that users obtain and input information pertaining to the building's characteristics and the irradiator location. The tool also suggests several prescriptive mitigation strategies that can be considered to reduce risk. Given the variability in civilian building construction practices, the input parameters used by this tool may not apply to all buildings being assessed. The tool should not be used as a substitute for engineering judgment. The tool is intended for assessment purposes only.

  18. Aspects of audit. 4: Acceptability of audit.

    PubMed

    Shaw, C D

    1980-06-14

    Whether or not audit is accepted in Britain will be determined principally by how it is controlled, how much it costs, and how effective it is. The objectives of audit have been defined as education, planning, evaluation, research, and anticipatory diplomacy--that is, starting internal audit before external audit is imposed on the medical profession. Published reports suggest that in Britain internal audit would be more effective andless expensive than the complex professional standards review organisation devised by the Federal Government in the United States.

  19. Health and medical software related to computer user satisfaction: an interactive online expert system using diagnostic audit trails through telecommunication networks.

    PubMed

    Rushinek, A; Rushinek, S F

    1985-01-01

    The selection of a health and medical software (HMS) system is a complicated process. The overall satisfaction derived from a system depends on many variables. This study analyzes the influence of HMS predictor variables on overall satisfaction as determined by multiple regression. The null hypothesis, that multiple correlation coefficient is zero, is rejected. Th alternative hypothesis is accepted. This study confirms the theories that suggest that HMS ease of operation, independent variables, technical support troubleshooting, and reliability of computer are the major determinations of overall computer user satisfaction. The factors identified were used in the design of an HMS expert system based on artificial intelligence (ESAI).

  20. 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

  1. Software documentation for TRU certification program

    SciTech Connect

    CLINTON, R.

    1999-08-31

    The document provides validation information for software used to support TRU operational activities. Calculations were performed using a spreadsheet application. This document provides information about the usage of the software application, Microsoft{reg_sign} Excel. Microsoft{reg_sign} Excel spreadsheets were used to perform specific calculations to determine the amount of containers to visually examine and to perform analyses on container head-gas data. Contained in this document are definitions of formulas and variables with relation to the Excel codes used. Also, a demonstration is provided using predetermined values to obtain predetermined results.

  2. Comprehensive Auditing in Nuclear Medicine Through the International Atomic Energy Agency Quality Management Audits in Nuclear Medicine Program. Part 2: Analysis of Results.

    PubMed

    Dondi, Maurizio; Torres, Leonel; Marengo, Mario; Massardo, Teresa; Mishani, Eyal; Van Zyl Ellmann, Annare; Solanki, Kishor; Bischof Delaloye, Angelika; Lobato, Enrique Estrada; Miller, Rodolfo Nunez; Ordonez, Felix Barajas; Paez, Diana; Pascual, Thomas

    2017-11-01

    The International Atomic Energy Agency has developed a program, named Quality Management Audits in Nuclear Medicine (QUANUM), to help its Member States to check the status of their nuclear medicine practices and their adherence to international reference standards, covering all aspects of nuclear medicine, including quality assurance/quality control of instrumentation, radiopharmacy (further subdivided into levels 1, 2, and 3, according to complexity of work), radiation safety, clinical applications, as well as managerial aspects. The QUANUM program is based on both internal and external audits and, with specifically developed Excel spreadsheets, it helps assess the level of conformance (LoC) to those previously defined quality standards. According to their level of implementation, the level of conformance to requested standards; 0 (absent) up to 4 (full conformance). Items scored 0, 1, and 2 are considered non-conformance; items scored 3 and 4 are considered conformance. To assess results of the audit missions performed worldwide over the last 8 years, a retrospective analysis has been run on reports from a total of 42 audit missions in 39 centers, three of which had been re-audited. The analysis of all audit reports has shown an overall LoC of 73.9 ± 8.3% (mean ± standard deviation), ranging between 56.6% and 87.9%. The highest LoC has been found in the area of clinical services (83.7% for imaging and 87.9% for therapy), whereas the lowest levels have been found for Radiopharmacy Level 2 (56.6%); Computer Systems and Data Handling (66.6%); and Evaluation of the Quality Management System (67.6%). Prioritization of non-conformances produced a total of 1687 recommendations in the final audit report. Depending on the impact on safety and daily clinical activities, they were further classified as critical (requiring immediate action; n = 276; 16% of the total); major (requiring action in relatively short time, typically from 3 to 6 months; n = 604

  3. Doing Physics with Spreadsheets: Old Tricks for New Dogs

    NASA Astrophysics Data System (ADS)

    Mallinckrodt, A. John

    2006-12-01

    Despite their decidedly “last year,” low-tech status, spreadsheets remain singularly efficient and accessible tools for solving a wide variety of problems in physics, presenting examples in the classroom, and conducting preliminary or exploratory computational research projects. Moreover, newer features have enhanced these capabilities. Because of the shallow learning curve, spreadsheets should be a tool in the arsenal of all physics students and faculty. I will present a number of examples drawn from mechanics, thermodynamics, and electrostatics illustrating graphical analysis, combinatorics, animation, and solutions of ordinary and partial differential equations. I am soliciting examples from the physics teaching community for a new website devoted to the dissemination of instructional materials in spreadsheet physics.

  4. 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.

  5. Spreadsheet aided fuzzy model for prediction of chapati making quality.

    PubMed

    Gangadharappa, Gundabhakthara Hosamane; Prabhasankar, P

    2011-06-01

    A spreadsheet aided fuzzy logic model for predicting chapati making quality characteristics of Indian wheat varieties was created. Data collected from 19 randomly selected wheat varieties were used. Starch damage, Farinograph water absorption as input variables and chapati overall score as output variable were fuzzified by the use of excel spreadsheet and defuzzification was carried out using weighted average method. Fuzzy model was compared with the regression model of measured data for its error levels and ease of application. Standard error of estimate of fuzzy model was smaller (1.825) than measured (2.895) chapati quality score regression model.

  6. 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...

  7. 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)

  8. 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...

  9. Computerizing Audit Studies.

    PubMed

    Lahey, Joanna N; Beasley, Ryan A

    2009-06-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.

  10. 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

  11. 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)

  12. 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)

  13. 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,…

  14. 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,…

  15. 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.…

  16. 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…

  17. 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)

  18. 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…

  19. 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.…

  20. 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…

  1. A spreadsheet program for steady-state temperature fields

    SciTech Connect

    Hutchens, G.J.

    2000-06-01

    A spreadsheet macro program is developed in EXCEL using Visual Basic for Applications (VBA) to analyze two-dimensional heat transfer. A description of the physical system analyzed is given along with the model equations and numerical methods used. The macro program is described and results of the analysis presented.

  2. 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,…

  3. 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 ...

  4. 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…

  5. 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…

  6. 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 ...

  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. 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)

  9. Solving L-L Extraction Problems with Excel Spreadsheet

    ERIC Educational Resources Information Center

    Teppaitoon, Wittaya

    2016-01-01

    This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

  10. 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…

  11. Using Spreadsheets To Estimate the Volatility of Stock Prices.

    ERIC Educational Resources Information Center

    Riley, Kyle

    2002-01-01

    Presents a simple method for estimating the volatility of stock prices and uses a spreadsheet to apply the method to actual stock prices. This method is an application of parameter estimation and can be used in an introductory statistics course. (KHR)

  12. 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,…

  13. 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…

  14. Solving L-L Extraction Problems with Excel Spreadsheet

    ERIC Educational Resources Information Center

    Teppaitoon, Wittaya

    2016-01-01

    This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

  15. 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…

  16. 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…

  17. 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…

  18. 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…

  19. 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.

  20. 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.

  1. 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,…

  2. 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,…

  3. Software Applications To Increase Administrative and Teacher Effectiveness.

    ERIC Educational Resources Information Center

    Garland, Virginia E.

    Arguing that the most effective types of managerial computer software for teacher use are word processing, database management, and electronic spreadsheet packages, this paper uses Apple Writer, PFS File, and VisiCalc as examples of such software and suggests ways in which they can be used by classroom teachers. Applications of Apple Writer that…

  4. Automated system for scheduling pipeline time for small batch production using a symphony spreadsheet

    SciTech Connect

    Bankes, W.F.

    1986-01-01

    A scheduling pipeline program can be easily developed and customized using Symphony spreadsheet software. Monsanto Research Corporation produces small electro-mechanical component subassemblies in large lot sizes which are subdivided into transfer quantities. Since production takes place in several buildings, the transfer quantities create wait time for parts not being worked. Batch production schedules are constructed and adjusted using the pipeline program. This application uses work centers and/or balanced workstation assignments to determine schedule dates for a given transfer quantity. Production routing information is summarized for each station assignment, and these are considered as schedule points. The program incorporates many data base management, input forms, and graphic features available in Symphony.

  5. 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.

  6. 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.

  7. Software Engineering Reviews and Audits. Overview

    DTIC Science & Technology

    2011-05-19

    review was conducted and performed correctly, you have done it right.” 26 Quality Management System (QMS) Standards AS9100, SAE AS9110, and ISO 9001 ...Senior Management must have in place: allocated budget committed schedules trained personnel 12 Senior Management will always provide when they see...team inspection 25 To ensure you have a successful peer review, select trained reviewers and guidelines are understood from the start. “If the peer

  8. An Auditable Performance Based Software Acquisition Process

    DTIC Science & Technology

    2010-04-28

    All Rights Reserved SPG SSTC 2010 Inspections - Peer Reviews • Over time, each term has become ambiguous • Many times the two terms are used...interchangeably Stewart-Priven believe: • Inspections are a rigorous form of Peer Reviews • Peer Reviews are not necessarily Inspections – Peer ...Inspection tool reports for process conformance and Computerized Inspection Tools 2 Perform gap analysis and map project’s Inspection (or Peer - Review ) capabilities

  9. 46 CFR Sec. 12 - Audit.

    Code of Federal Regulations, 2011 CFR

    2011-10-01

    ... 46 Shipping 8 2011-10-01 2011-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 and...

  10. The Legal Audit: Preventing Problems.

    ERIC Educational Resources Information Center

    Perlman, Daniel H.

    1987-01-01

    Suffolk University initiated two audits that proved beneficial: a legal audit and an insurance audit. A legal audit involves having an attorney review a college's contracts, personnel handbooks, catalogs, etc., in order to anticipate and prevent problems. An insurance audit reviews an institution's risk coverage. (MLW)

  11. The Legal Audit: Preventing Problems.

    ERIC Educational Resources Information Center

    Perlman, Daniel H.

    1987-01-01

    Suffolk University initiated two audits that proved beneficial: a legal audit and an insurance audit. A legal audit involves having an attorney review a college's contracts, personnel handbooks, catalogs, etc., in order to anticipate and prevent problems. An insurance audit reviews an institution's risk coverage. (MLW)

  12. 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...

  13. 46 CFR Sec. 12 - Audit.

    Code of Federal Regulations, 2013 CFR

    2013-10-01

    ... 46 Shipping 8 2013-10-01 2013-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...

  14. 46 CFR Sec. 12 - Audit.

    Code of Federal Regulations, 2014 CFR

    2014-10-01

    ... 46 Shipping 8 2014-10-01 2014-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...

  15. 46 CFR Sec. 12 - Audit.

    Code of Federal Regulations, 2012 CFR

    2012-10-01

    ... 46 Shipping 8 2012-10-01 2012-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...

  16. 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…

  17. 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.

  18. 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.

  19. Tables: A Spreadsheet-Inspired Programming Model for Sensor Networks

    SciTech Connect

    Horey, James L; Maccabe, Arthur Barney; Nelson, Eric

    2010-01-01

    Current programming interfaces for sensor networks often target experienced developers and lack important features. Tables is a spreadsheet inspired programming environment that enables rapid development of complex applications by a wide range of users. Tables emphasizes ease-of-use by employing spreadsheet abstractions, including pivot tables and data-driven functions. Using these tools, users are able to construct applications that incorporate local and collective computation and communication. We evaluate the design and implementation of Tables on the TelosB platform, and show how Tables can be used to construct data monitoring, classification, and object tracking applications. We discuss the relative computation, memory, and network overhead imposed by the Tables environment. With this evaluation, we show that the Tables programming environment represents a feasible alternative to existing programming systems.

  20. Spreadsheet based analysis of Mössbauer spectra

    NASA Astrophysics Data System (ADS)

    Gunnlaugsson, H. P.

    2016-12-01

    Using spreadsheet programs to analyse spectral data opens up new possibilities in data analysis. The spreadsheet program contains all the functionality needed for graphical support, fitting and post processing of the results. Unconventional restrictions between fitting parameters can be set up freely, and simultaneous analysis i.e. analysis of many spectra simultaneously in terms of model parameters is straightforward. The free program package Vinda - used for analysing Mössbauer spectra - is described. The package contains support for reading data, calibration, and common functions of particular importance for Mössbauer spectroscopy ( f-factors, second order Doppler shift etc.). Methods to create spectral series and support for error analysis is included. Different types of fitting models are included, ranging from simple Lorentzian models to complex distribution models.

  1. 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.

  2. Auditing Organizational Security

    DTIC Science & Technology

    2017-01-01

    and risks, including the control of security, human factors and other activities that affect the organization’s performance , condition or safety...Managing organizational security is no different from managing any other of the command’s missions. Establish your policies, goals and risk...parameters; implement, train, measure and benchmark them. And then audit, audit, audit. Today, more than ever, Organizational Security is an essential

  3. 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.

  4. Ingres to Dbase and Financial Spreadsheet Program Packages.

    DTIC Science & Technology

    1984-02-01

    41Ihk C. ~ 14 cm 0 c 0 0 (I~o Contractor Report 223 INGRES TO DBASE AND FINANCIAL SPREADSHEET PROGRAM PACKAGES System Development Corporation J. Baird...Number N66001-83-D-0094 Controlling Office Naval Ocean Systems Center Code 912 San Diego, CA 92152 Funded by NOSC, Project Management Support System ...database files between two popular relational database management systems . Ingres (by Relational Technologies. Inc) and dBASE II (by Ashton-Tate. Inc

  5. 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

  6. 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.

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

    PubMed

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

    2013-07-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.

  8. Audit in clinical practice.

    PubMed

    Modayil, Prince Cheriyan; Panchikkeel, Ragesh Kuyyattil; Alex, Nisha

    2009-06-01

    Audit dates back to as early as 1750 BC when king Hammurabi of Babylon instigated audit for clinicians with regard to outcome. Clinical audit is a way of fi nding out whether we are doing what we should be doing. It also verifi es whether we are applying the best practice. An audit cycle involves setting-up of standards, measuring current practice, comparing results with standards (criteria), changing practice and re-auditing to make sure practice has improved A 'clinical audit' is a quality improvement process that seeks to improve patient care and clinical outcomes through a systematic review of care against explicit criteria, and the implementation of change. Changes are implemented at an individual, team or service level and a subsequent re-audit is done to confi rm improvement in health care delivery. The importance of audit in healthcare sector needs to be appreciated by the relevant authorities. The most frequently cited barrier to successful audit is the failure of organizations to provide suffi cient fund and protected time for healthcare teams.

  9. Coding for surgical audit.

    PubMed

    Pettigrew, R A; van Rij, A M

    1990-05-01

    A simple system of codes for operations, diagnoses and complications, developed specifically for computerized surgical audit, is described. This arose following a review of our established surgical audit in which problems in the retrieval of data from the database were identified. Evaluation of current methods of classification of surgical data highlighted the need for a dedicated coding system that was suitable for classifying surgical audit data, enabling rapid retrieval from large databases. After 2 years of use, the coding system has been found to fulfil the criteria of being sufficiently flexible and specific for computerized surgical audit, yet simple enough for medical staff to use.

  10. 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.

  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. 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…

  13. 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

  14. 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)

  15. 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)

  16. [Use of spreadsheet for statistical and graphical processing of records from the ambulatory blood pressure monitor Spacelabs 90207].

    PubMed

    Borges, N; Polónia, J

    1993-04-01

    The introduction of portable devices for non-invasive ambulatory blood-pressure measurement is recognized as an advance in the study of human arterial hypertension, allowing a significant improvement in the selection of hypertensive patients as well as in the analysis of the effects of antihypertensive drugs during clinical trials. The Spacelabs 90207 is a recent example of this kind of apparatus, possessing high levels of portability and being highly classified in validation studies. Nevertheless, the software of this apparatus (like other similar devices) has severe limitations in what concerns the calculation of the area under the curve of blood pressure during the time of measurement, as well as in the possibility of grouping several records in a database for easy statistic and graphic analysis of different groups of records. In order to overcome these difficulties, the authors describe the development of a group of programs, using Microsoft Excel v3.0 spreadsheets and macros, that allow a direct import of individual files from the Spacelabs software to a spreadsheet and its further processing in three phases. These three phases, which we designated by "conversion", "export to database" and "statistic and graphic analysis", will permit an easy and fast statistic and graphic analysis of selected groups of records.

  17. 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.

  18. Data acquisition and real-time control using spreadsheets: interfacing Excel with external hardware.

    PubMed

    Aliane, Nourdine

    2010-07-01

    Spreadsheets have become a popular computational tool and a powerful platform for performing engineering calculations. Moreover, spreadsheets include a macro language, which permits the inclusion of standard computer code in worksheets, and thereby enable developers to greatly extend spreadsheets' capabilities by designing specific add-ins. This paper describes how to use Excel spreadsheets in conjunction to Visual Basic for Application programming language to perform data acquisition and real-time control. Afterwards, the paper presents two Excel applications with interactive user interfaces developed for laboratory demonstrations and experiments in an introductory course in control. 2010 ISA. Published by Elsevier Ltd. All rights reserved.

  19. 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…

  20. 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…

  1. Internal audit consider the implications.

    PubMed

    Baumgartner, Grant D; Hamilton, Angela

    2004-06-01

    Internal audit can not only allay external and internal concerns about appropriateness of business operations, but also help improve efficiency and the bottom line. To get an internal audit function under way, healthcare organizations need to obtain board buy-in, form an audit committee of the board, determine resources needed, perform a risk assessment, and develop an internal audit plan.

  2. Audits of radiopharmaceutical formulations

    SciTech Connect

    Castronovo, F.P. Jr. )

    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.

  3. A random walk to stochastic diffusion through spreadsheet analysis

    NASA Astrophysics Data System (ADS)

    Brazzle, Bob

    2013-11-01

    This paper describes a random walk simulation using a number cube and a lattice of concentric rings of tiled hexagons. At the basic level, it gives beginning students a concrete connection to the concept of stochastic diffusion and related physical quantities. A simple algorithm is presented that can be used to set up spreadsheet files to calculate these simulated quantities and even to "discover" the diffusion equation. Lattices with different geometries in two and three dimensions are also presented. This type of simulation provides fertile ground for independent investigations by all levels of undergraduate students.

  4. A visual basic spreadsheet macro for recession curve analysis.

    PubMed

    Posavec, Kristijan; Bacani, Andrea; Nakić, Zoran

    2006-01-01

    A Visual Basic program for an Excel spreadsheet was written to construct a master recession curve (MRC), using the adapted matching strip method, for recession analysis of ground water level time series. The program uses five different linear/nonlinear regression models to adjust individual recession segments to their proper positions in the MRC. The program can also be used to analyze the recession segments of other time series, such as daily stream discharge or stage. Some examples of field data from Croatia are used to illustrate the usefulness of its application.

  5. 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

  6. Computers and audit

    PubMed Central

    Fitter, M.J.; Evans, A.R.; Garber, J.R.

    1985-01-01

    A computerized information system was installed in a large group practice. This paper describes how the computer system was used for the systematic auditing of clinical activities, and also demonstrates how it acted as a catalyst for the review and changes of administrative and management procedures. An analysis of the issues that arose in an audit group is used to identify how the objectives and activities of the group evolved with experience. It is demonstrated that a computer system and audit can complement and enhance each other to the benefit of clinical and managerial decision making. PMID:4078807

  7. Making the business case for telemedicine: an interactive spreadsheet.

    PubMed

    McCue, Michael J; Palsbo, Susan E

    2006-04-01

    The objective of this study was to demonstrate the business case for telemedicine in nonrural areas. We developed an interactive spreadsheet to conduct multiple financial analyses under different capital investment, revenue, and expense scenarios. We applied the spreadsheet to the specific case of poststroke rehabilitation in urban settings. The setting involved outpatient clinics associated with a freestanding rehabilitation hospital in Oklahoma. Our baseline scenario used historical financial data from face-to-face encounters as the baseline for payer and volume mix. We assumed a cost of capital of 10% to finance the project. The outcome measures were financial breakeven points and internal rate of return. A total of 340 telemedicine visits will generate a positive net cash flow each year. The project is expected to recoup the initial investment by the fourth year, produce a positive present value dollar return of more than $2,000, and earn rate of return of 20%, which exceeds the hospital's cost of capital. The business case is demonstrated for this scenario. Urban telemedicine programs can be financially self-sustaining without accounting for reductions in travel time by providers or patients. Urban telemedicine programs can be a sound business investment and not depend on grants or subsidies for start-up funding. There are several key decision points that affect breakeven points and return on investment. The best business strategy is to approach the decision as whether or not to build a new clinic.

  8. Environmental Auditing Policy Statement

    EPA Pesticide Factsheets

    EPA's policy on the use of environmental auditing by regulated entities to help achieve and maintain compliance with environmental laws and regulations, as well as to help identify and correct unregulated environmental hazards.

  9. 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.

  10. Significant event auditing.

    PubMed

    Pringle, M

    2000-12-01

    Significant event auditing has been described for 5 years and it is slowly gaining credibility as an effective method of quality assurance in British general practice. This paper describes what it is, what its background is, how it is done and whether it is effective. While it needs a positive team culture - and therefore may not suit every practice - where it is used it appears to be a useful adjunct to a clinical audit programme.

  11. 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.

  12. 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…

  13. 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…

  14. 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)

  15. Design of an Excel Spreadsheet to Estimate Rate Constants, Determine Associated Errors, and Choose Curve's Extent

    ERIC Educational Resources Information Center

    Moreira, Luis; Martins, Filomena; Elvas-Leitao, Ruben

    2006-01-01

    A new Microsoft Excel spreadsheet design that enables a prompt calculation of rate constant, k values and associated errors and also addresses less common features such as the choice of an experimental curve's extent is presented. To complete the spreadsheet design, several highlights and squared colored boxes were included to assist the user and…

  16. 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…

  17. Integrated Spreadsheets as a Paradigm of Type II Technology Applications in Mathematics Teacher Education

    ERIC Educational Resources Information Center

    Abramovich, Sergei

    2016-01-01

    The paper presents the use of spreadsheets integrated with digital tools capable of symbolic computations and graphic constructions in a master's level capstone course for secondary mathematics teachers. Such use of spreadsheets is congruent with the Type II technology applications framework aimed at the development of conceptual knowledge in the…

  18. User's guide: RPGrow$: a red pine growth and analysis spreadsheet for the Lake States.

    Treesearch

    Carol A. Hyldahl; Gerald H. Grossman

    1993-01-01

    Describes RPGrow$, a stand-level, interactive spreadsheet for projecting growth and yield and estimating financial returns of red pine plantations in the Lake States. This spreadsheet is based on published growth models for red pine. Financial analyses are based on discounted cash flow methods.

  19. 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)

  20. 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…

  1. 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…

  2. 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…

  3. Understanding Audit in Obstetrics.

    PubMed

    Eralil, Georgy Joy

    2016-10-01

    Aim of this audit is to analyse indication and proportion of babies delivered by elective caesarean section at less than 39(+0) weeks of gestation exposed to antenatal corticosteroids performed in a Premier Hospital, Hywel Dda Health University. The second aim was to learn how an audit can be done and used for improving clinical practice. Present study involved all patients who underwent elective caesarean delivery before 39 weeks completed period of gestation in August and September 2014. Data collected from medical record tracking using ICD-9 codes and analysed by clinical audit department. Patients who underwent elective caesarean section after 39 weeks completed period of gestation. The audit showed 66.6 % of patients were given antenatal corticosteroids. The observation was discussed in consultant meetings, labour forum, and was send as e-mail to every one working in Department of Obstetrics and Gynaecology. The goal was 100 %. Reaudit is to be performed in year time to know the effect of change in practice. All successful audits are structured programmes with realistic aims and objectives, leadership and attitude of senior management, nondirective, hands-on approach, support of staff, strategy groups and regular discussions, emphasis on team working and support, environment conducive to conducting audit.

  4. 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

  5. The Neighborhood Auditing Tool: a hybrid interface for auditing the UMLS.

    PubMed

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

    2009-06-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.

  6. Users guide for FRCS: fuel reduction cost simulator software.

    Treesearch

    Roger D. Fight; Bruce R. Hartsough; Peter. Noordijk

    2006-01-01

    The Fuel Reduction Cost Simulator (FRCS) spreadsheet application is public domain software used to estimate costs for fuel reduction treatments involving removal of trees of mixed sizes in the form of whole trees, logs, or chips from a forest. Equipment production rates were developed from existing studies. Equipment operating cost rates are from December 2002 prices...

  7. 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…

  8. 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)

  9. 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.

  10. 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.

  11. 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…

  12. 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.

  13. 10 CFR 603.1295 - Periodic audit.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... 10 Energy 4 2010-01-01 2010-01-01 false Periodic audit. 603.1295 Section 603.1295 Energy... Used in this Part § 603.1295 Periodic audit. An audit of a participant, performed at an agreed-upon... an audit may cover. A periodic audit of a participant differs from an award-specific audit of...

  14. 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 accordance...

  15. 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 standards...

  16. 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 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...

  17. 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...

  18. 10 CFR 603.1295 - Periodic audit.

    Code of Federal Regulations, 2013 CFR

    2013-01-01

    ... 10 Energy 4 2013-01-01 2013-01-01 false Periodic audit. 603.1295 Section 603.1295 Energy... Used in this Part § 603.1295 Periodic audit. An audit of a participant, performed at an agreed-upon... an audit may cover. A periodic audit of a participant differs from an award-specific audit of...

  19. 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…

  20. 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…

  1. 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…

  2. The Personal Computer as an Analytical Workstation: Interfacing Standard Software Products.

    ERIC Educational Resources Information Center

    Cawley, Jeffery L.

    1984-01-01

    Reviews the functions that should be included in an analytical workstation. Also discusses the common data file structures and the techniques of data interchange between software modules and presents a brief overview of commercial products and their interfacing characteristics. These software include word processors, spreadsheets, database…

  3. 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…

  4. Company's Unusual Plan to Package Commercial Software with Business Textbooks Produces a Measure of Success.

    ERIC Educational Resources Information Center

    Watkins, Beverly T.

    1992-01-01

    Course Technology Inc. has developed 10 products combining textbooks with commercial software for college accounting, business, computer science, and statistics courses. Five of the products use Lotus 1-2-3 spreadsheet software. The products have been positively received by teachers and students. (DB)

  5. Application of spreadsheets to standardize transportation radiological risk assessments

    SciTech Connect

    McClure, J.D.; Neuhauser, K.S.; Smith, J.D.

    1995-12-31

    Because of the complexity, volume of data and calculations required, one preferred analytical tool to perform transportation risk assessments is the RADTRAN computer code. RADTRAN combines user-determined material, packaging, transportation, demographic and meteorological factors, with health physics data to calculate expected radiological consequences and accident risk from transporting radioactive materials by all commercial modes including truck, rail, ship, air and barge. The computer code consists of two major modules for each transport mode: the incident-free module, in which doses from normal transport are calculated; and the accident module, in which dose consequences and probabilities are evaluated to generate risk estimates. The purpose of this presentation is to describe the development of a standardized procedure to perform transportation radiological risk assessments employing conventional spreadsheet programs to automate generation of RADTRAN input files and post-processing analysis of the resulting output.

  6. 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.

  7. 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)

  8. A Comparison of Software Schedule Estimators

    DTIC Science & Technology

    1990-09-01

    and Limitations ............................... 3 II. Literature Review ..................................... 5 Software Development Life Cycle...94 V List of ieu Figure Page 1. An Example Of System Development Reviews And Audits ...... 8 2. Life Cycle Estimate Comparison...missing a measurement that is required to run the model. 4 II. Literature Review The field of software development is of interest to a wide variety of

  9. Evaluation of medical audit.

    PubMed Central

    Robinson, M B

    1994-01-01

    OBJECTIVE--To review current knowledge of the effectiveness of medical audit programmes as a whole and of specific interventions within these programmes, as a means of changing clinical behaviour. CRITERIA FOR INCLUSION AND EXCLUSION OF PUBLISHED REPORTS--Articles listed on Medline from 1985-92 with key words "quality assurance" or "medical audit", and "evaluation" and relevant references from these articles, and from recently published reviews and reports on medical audit, were included. Excluded were simple descriptions of audit activity, replications of previous work, and publication in a language other than English. RESULTS--Evaluation of entire programmes of medical audit is unusual. Most reports concern specific interventions and focus particularly on the scientific and technical aspects of quality. These interventions may be classified by the means through which they attempt to achieve desired changes: patient characteristics; physician characteristics; administrative and organisational structures; and financial incentives. CONCLUSIONS--Knowledge about effective methods of bringing about specific changes in clinical behaviour is rudimentary. Impact is highly dependent on local factors, so generalisation of results to other settings is difficult. More qualitative research is needed to define the local factors which influence results. PMID:7964351

  10. 1984 and the Medical Audit

    PubMed Central

    Gibson, Gary

    1984-01-01

    Medical audit in its various forms pervades our practices and our medical thinking in 1984. It includes a wide range of purposes and functions, most of which need not be seen as an external “Big Brother”. Some form of audit, at least internal, is inherent in professionalism. This article reviews the concepts and principles of medical audit with special emphasis on how to stay out of trouble when faced with external audits done for monitoring purposes. PMID:20469422

  11. 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.

  12. 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"…

  13. 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)

  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. 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"…

  16. Auditing of chromatographic data.

    PubMed

    Mabie, J T

    1998-01-01

    During a data audit, it is important to ensure that there is clear documentation and an audit trail. The Quality Assurance Unit should review all areas, including the laboratory, during the conduct of the sample analyses. The analytical methodology that is developed should be documented prior to sample analyses. This is an important document for the auditor, as it is the instrumental piece used by the laboratory personnel to maintain integrity throughout the process. It is expected that this document will give insight into the sample analysis, run controls, run sequencing, instrument parameters, and acceptance criteria for the samples. The sample analysis and all supporting documentation should be audited in conjunction with this written analytical method and any supporting Standard Operating Procedures to ensure the quality and integrity of the data.

  17. 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.

  18. 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. © 2015 The Author(s).

  19. 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

  20. 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…

  1. 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…

  2. British Orthodontic Society national audit of temporary anchorage devices (TADs): report of the first thousand TADs placed.

    PubMed

    Bearn, David R; Alharbi, Fahad

    2015-09-01

    To provide data from the British Orthodontic Society (BOS) national clinical audit on temporary anchorage device (TAD) use following the recommendations of the National Institute for Health and Clinical Excellence (NIHCE) Design and setting: The Audit commenced on 1 January 2008 and is still ongoing. This article reports the data for TADs placed from 1 January 2008 to 1 November 2013. Audit data was collected from participants using a system of both on-line data entry and hard copy forms. The criteria and standards for the audit were set following the NIHCE report in conjunction with the Development and Standards Committee of the BOS. Virtually all participants used the on-line data entry available on the BOS website. The data submitted was checked and entered manually into an Excel spreadsheet, and transferred to SPSS for analysis. Written information and documented discussion of risks were provided in over 90% of TADs placed, but 17.4% were placed without a specific signed consent form. Temporary anchorage device failure rate was 24.2% overall. Among failed TADs, 93.1% were lost or removed due to excess mobility. Infection or inflammation resulting in loss or removal was reported in 6% of TADs. The only audit standard that was met was failures due to infection of inflammation. The rest of the audit standards were not met. Recommendations are made to address these issues.

  3. Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis.

    PubMed

    Neyeloff, Jeruza L; Fuchs, Sandra C; Moreira, Leila B

    2012-01-20

    Meta-analyses are necessary to synthesize data obtained from primary research, and in many situations reviews of observational studies are the only available alternative. General purpose statistical packages can meta-analyze data, but usually require external macros or coding. Commercial specialist software is available, but may be expensive and focused in a particular type of primary data. Most available softwares have limitations in dealing with descriptive data, and the graphical display of summary statistics such as incidence and prevalence is unsatisfactory. Analyses can be conducted using Microsoft Excel, but there was no previous guide available. We constructed a step-by-step guide to perform a meta-analysis in a Microsoft Excel spreadsheet, using either fixed-effect or random-effects models. We have also developed a second spreadsheet capable of producing customized forest plots. It is possible to conduct a meta-analysis using only Microsoft Excel. More important, to our knowledge this is the first description of a method for producing a statistically adequate but graphically appealing forest plot summarizing descriptive data, using widely available software.

  4. Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis

    PubMed Central

    2012-01-01

    Background Meta-analyses are necessary to synthesize data obtained from primary research, and in many situations reviews of observational studies are the only available alternative. General purpose statistical packages can meta-analyze data, but usually require external macros or coding. Commercial specialist software is available, but may be expensive and focused in a particular type of primary data. Most available softwares have limitations in dealing with descriptive data, and the graphical display of summary statistics such as incidence and prevalence is unsatisfactory. Analyses can be conducted using Microsoft Excel, but there was no previous guide available. Findings We constructed a step-by-step guide to perform a meta-analysis in a Microsoft Excel spreadsheet, using either fixed-effect or random-effects models. We have also developed a second spreadsheet capable of producing customized forest plots. Conclusions It is possible to conduct a meta-analysis using only Microsoft Excel. More important, to our knowledge this is the first description of a method for producing a statistically adequate but graphically appealing forest plot summarizing descriptive data, using widely available software. PMID:22264277

  5. [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.

  6. Passing the Audition

    ERIC Educational Resources Information Center

    Poliniak, Susan

    2012-01-01

    Auditioning is often uncomfortable but can lead to great rewards. Music educators can do much to help their students be at their best in front of a panel. In this article, four experts share their experiences as adjudicators and their advice on how best to prepare students for the process.

  7. From Auditing to Editing.

    ERIC Educational Resources Information Center

    General Accounting Office, Washington, DC.

    Clarity in communication is important for workers in the General Accounting Office since much of the auditing work must be committed to paper if Congress, government officials and employees, or the public are to benefit. As a result an extensive writing improvement program was launched and this booklet written. Part 1 covers basic communication…

  8. 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…

  9. Energy Audit . . . Here's How.

    ERIC Educational Resources Information Center

    American School and University, 1983

    1983-01-01

    After establishing building use patterns and complaints, a consulting engineer's walkthrough energy audit begins with the exterior. Then heating/cooling system efficiency is checked with a flue gases kit. Efficient use of water heaters, lighting, teacher lounges, and food preparation and eating areas saves energy. Most effective conservation…

  10. Energy Audit . . . Here's How.

    ERIC Educational Resources Information Center

    American School and University, 1983

    1983-01-01

    After establishing building use patterns and complaints, a consulting engineer's walkthrough energy audit begins with the exterior. Then heating/cooling system efficiency is checked with a flue gases kit. Efficient use of water heaters, lighting, teacher lounges, and food preparation and eating areas saves energy. Most effective conservation…

  11. 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…

  12. Passing the Audition

    ERIC Educational Resources Information Center

    Poliniak, Susan

    2012-01-01

    Auditioning is often uncomfortable but can lead to great rewards. Music educators can do much to help their students be at their best in front of a panel. In this article, four experts share their experiences as adjudicators and their advice on how best to prepare students for the process.

  13. 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

  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. 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.

  16. A spreadsheet for analyzing the in situ performance of fluorescent luminaires

    SciTech Connect

    Rubinstein, F.; Zhang, Chin

    1991-08-01

    A spreadsheet program for determining system efficacy, power input and light output of common 4 ft fluorescent lighting systems under realistic operating conditions is described. The program uses accepted IES engineering principles to precisely account for ballast factor, existing thermal conditions and maintenance practices. The spreadsheet, which includes a data base of lamp and ballast performance data, can be used to calculate the cost-effectiveness of many common lighting retrofits.

  17. Description of the Material Balance Model and Spreadsheet for Salt Dissolution

    SciTech Connect

    Wiersma, B.J.

    1994-10-12

    The model employed to estimate the amount of inhibitors necessary for bearing water and dissolution water during the salt dissolution process is described. This model was inputed on a spreadsheet which allowed many different case studies to be performed. This memo describes the assumptions and equations which are used in the model, and documents the input and output cells of the spreadsheet. Two case studies are shown as examples of how the model may be employed.

  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. 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.

  20. Open-source software for radiologists: a primer.

    PubMed

    Scarsbrook, A F

    2007-02-01

    There is a wide variety of free (open-source) software available via the Internet which may be of interest to radiologists. This article will explore the use of open-source software in radiology to help streamline academic workflow and improve general efficiency and effectiveness by highlighting a number of the most useful applications currently available. These include really simple syndication applications, e-mail management, spreadsheet, word processing, database and presentation packages, as well as image and video editing software. How to incorporate this software into radiological practice will also be discussed.

  1. 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.

  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. 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.

  4. Reviewing audit: barriers and facilitating factors for effective clinical audit

    PubMed Central

    Johnston, G; Crombie, I; Alder, E; Davies, H; Millard, A

    2000-01-01

    I K Crombie, professor and E M Alder, senior lecturer H T O Davies, reader A Millard, research fellow Objective—To review the literature on the benefits and disadvantages of clinical and medical audit, and to assess the main facilitators and barriers to conducting the audit process. Design—A comprehensive literature review was undertaken through a thorough review of Medline and CINAHL databases using the keywords of "audit", "audit of audits", and "evaluation of audits" and a handsearch of the indexes of relevant journals for key papers. Results—Findings from 93 publications were reviewed. These ranged from single case studies of individual audit projects through retrospective reviews of departmental audit programmes to studies of interface projects between primary and secondary care. The studies reviewed incorporated the experiences of a wide variety of clinicians, from medical consultants to professionals allied to medicine and from those involved in unidisciplinary and multidisciplinary ventures. Perceived benefits of audit included improved communication among colleagues and other professional groups, improved patient care, increased professional satisfaction, and better administration. Some disadvantages of audit were perceived as diminished clinical ownership, fear of litigation, hierarchical and territorial suspicions, and professional isolation. The main barriers to clinical audit can be classified under five main headings. These are lack of resources, lack of expertise or advice in project design and analysis, problems between groups and group members, lack of an overall plan for audit, and organisational impediments. Key facilitating factors to audit were also identified: they included modern medical records systems, effective training, dedicated staff, protected time, structured programmes, and a shared dialogue between purchasers and providers. Conclusions—Clinical audit can be a valuable assistance to any programme which aims to improve the

  5. 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.

  6. 7 CFR 1290.10 - Audit requirements.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 7 Agriculture 10 2011-01-01 2011-01-01 false Audit requirements. 1290.10 Section 1290.10... PROGRAM § 1290.10 Audit requirements. The State is accountable for conducting a financial audit of the... audit, a copy of the audit results. ...

  7. 23 CFR 172.7 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-04-01

    ... 23 Highways 1 2011-04-01 2011-04-01 false Audits. 172.7 Section 172.7 Highways FEDERAL HIGHWAY... SERVICE CONTRACTS § 172.7 Audits. (a) Performance of audits. When State procedures call for audits of contracts or subcontracts for engineering design services, the audit shall be performed to test compliance...

  8. 7 CFR 1773.8 - Audit date.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 7 Agriculture 12 2011-01-01 2011-01-01 false Audit date. 1773.8 Section 1773.8 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.8 Audit date. (a) The annual audit must be performed as of the end of the same calendar month each year unless prior approval to...

  9. 45 CFR 96.31 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-10-01

    ... 45 Public Welfare 1 2011-10-01 2011-10-01 false Audits. 96.31 Section 96.31 Public Welfare... Audits. (a) Basic rule. Grantees and subgrantees are responsible for obtaining audits in accordance with the Single Audit Act Amendments of 1996 (31 U.S.C. 7501-7507) and revised OMB Circular A-133, “Audits...

  10. 7 CFR 3052.230 - Audit costs.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 7 Agriculture 15 2011-01-01 2011-01-01 false Audit costs. 3052.230 Section 3052.230 Agriculture... AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 3052.230 Audit costs. (a) Allowable costs. Unless prohibited by law, the cost of audits made in accordance with the...

  11. 20 CFR 655.1312 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-04-01

    ... 20 Employees' Benefits 3 2011-04-01 2011-04-01 false Audits. 655.1312 Section 655.1312 Employees... United States (H-2A Workers) § 655.1312 Audits. (a) Discretion. The Department will conduct audits of... selected for audit will be chosen within the sole discretion of the Department. (b) Audit letter. Where an...

  12. 7 CFR 1773.3 - Annual audit.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 7 Agriculture 12 2011-01-01 2011-01-01 false Annual audit. 1773.3 Section 1773.3 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.3 Annual audit. (a) Each borrower... RUS as set forth in § 1773.4. (b) Each borrower must establish an annual as of audit date within...

  13. 32 CFR 37.1325 - Periodic audit.

    Code of Federal Regulations, 2011 CFR

    2011-07-01

    ... 32 National Defense 1 2011-07-01 2011-07-01 false Periodic audit. 37.1325 Section 37.1325 National... TECHNOLOGY INVESTMENT AGREEMENTS Definitions of Terms Used in This Part § 37.1325 Periodic audit. An audit of... awards. Appendix C to this part describes what such an audit may cover. A periodic audit of a participant...

  14. 45 CFR 158.402 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-10-01

    ... 45 Public Welfare 1 2011-10-01 2011-10-01 false Audits. 158.402 Section 158.402 Public Welfare... REVENUE: REPORTING AND REBATE REQUIREMENTS HHS Enforcement § 158.402 Audits. (a) Notice of Audit. HHS will provide 30 days advance notice of its intent to conduct an audit of an issuer. (b) Conferences. All audits...

  15. 20 CFR 655.24 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-04-01

    ... 20 Employees' Benefits 3 2011-04-01 2011-04-01 false Audits. 655.24 Section 655.24 Employees...) § 655.24 Audits. (a) Discretion. OFLC will conduct audits of H-2B temporary labor certification applications. The applications selected for audit will be chosen within the sole discretion of OFLC. (b) Audit...

  16. 16 CFR 703.7 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 16 Commercial Practices 1 2011-01-01 2011-01-01 false Audits. 703.7 Section 703.7 Commercial... Audits. (a) The Mechanism shall have an audit conducted at least annually, to determine whether the... be kept under § 703.6 of this part shall be available for audit. (b) Each audit provided for in...

  17. 11 CFR 9038.1 - Audit.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 11 Federal Elections 1 2011-01-01 2011-01-01 false Audit. 9038.1 Section 9038.1 Federal Elections... EXAMINATIONS AND AUDITS § 9038.1 Audit. (a) General. (1) The Commission will conduct an audit of the qualified... primary matching funds. The audit may be conducted at any time after the date of the candidate's...

  18. 7 CFR 3052.200 - Audit requirements.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 7 Agriculture 15 2011-01-01 2011-01-01 false Audit requirements. 3052.200 Section 3052.200..., DEPARTMENT OF AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 3052.200 Audit requirements. (a) Audit required. Non-Federal entities that expend $500,000 or more in a year in...

  19. 13 CFR 120.490 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 13 Business Credit and Assistance 1 2011-01-01 2011-01-01 false Audits. 120.490 Section 120.490... Companies (sblc) § 120.490 Audits. Every SBLC is subject to periodic audits by SBA's Office of Inspector General, Auditing Division, and the cost of such audits will be assessed against the SBLC, except for the...

  20. 7 CFR 3052.510 - Audit findings.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 7 Agriculture 15 2011-01-01 2011-01-01 false Audit findings. 3052.510 Section 3052.510 Agriculture... AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Auditors § 3052.510 Audit findings. (a) Audit findings reported. The auditor shall report the following as audit findings in a...

  1. 30 CFR 735.22 - Audit.

    Code of Federal Regulations, 2011 CFR

    2011-07-01

    ... 30 Mineral Resources 3 2011-07-01 2011-07-01 false Audit. 735.22 Section 735.22 Mineral Resources... ENFORCEMENT § 735.22 Audit. The agency shall arrange for an independent audit no less frequently than once..., Attachment P. The audits will be performed in accordance with the “Standards for Audit of Governmental...

  2. 12 CFR 704.15 - Audit requirements.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 12 Banks and Banking 6 2011-01-01 2011-01-01 false Audit requirements. 704.15 Section 704.15 Banks... UNIONS § 704.15 Audit requirements. (a) External audit. The corporate credit union supervisory committee shall cause an annual opinion audit of the financial statements to be made. The audit must be performed...

  3. 30 CFR 725.19 - Audit.

    Code of Federal Regulations, 2011 CFR

    2011-07-01

    ... 30 Mineral Resources 3 2011-07-01 2011-07-01 false Audit. 725.19 Section 725.19 Mineral Resources... REGULATIONS REIMBURSEMENTS TO STATES § 725.19 Audit. The agency shall arrange for an independent audit no less... Circular No. A-102, Attachment P. The audits will be performed in accordance with the “Standards for Audit...

  4. 30 CFR 1217.250 - Audits.

    Code of Federal Regulations, 2011 CFR

    2011-07-01

    ... 30 Mineral Resources 3 2011-07-01 2011-07-01 false Audits. 1217.250 Section 1217.250 Mineral... Revenue AUDITS AND INSPECTIONS Other Solid Minerals § 1217.250 Audits. An audit of the lessee's accounts... duplicate copies of such annual or other audits to the mining supervisor, within 30 days after the...

  5. 20 CFR 655.180 - Audit.

    Code of Federal Regulations, 2012 CFR

    2012-04-01

    ... United States (H-2A Workers) Integrity Measures § 655.180 Audit. The CO may conduct audits of... will be chosen within the sole discretion of the CO. (b) Audit letter. Where an application is selected for audit, the CO will issue an audit letter to the employer and a copy, if appropriate, to...

  6. 29 CFR 99.510 - Audit findings.

    Code of Federal Regulations, 2011 CFR

    2011-07-01

    ... 29 Labor 1 2011-07-01 2011-07-01 false Audit findings. 99.510 Section 99.510 Labor Office of the Secretary of Labor AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Auditors § 99.510 Audit findings. (a) Audit findings reported. The auditor shall report the following as audit findings in a...

  7. 11 CFR 9038.1 - Audit.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... interviews of committee personnel. Commission staff will be available to explain aspects of the audit and... 11 Federal Elections 1 2010-01-01 2010-01-01 false Audit. 9038.1 Section 9038.1 Federal Elections... EXAMINATIONS AND AUDITS § 9038.1 Audit. (a) General. (1) The Commission will conduct an audit of the qualified...

  8. 32 CFR 37.1325 - Periodic audit.

    Code of Federal Regulations, 2010 CFR

    2010-07-01

    ... 32 National Defense 1 2010-07-01 2010-07-01 false Periodic audit. 37.1325 Section 37.1325 National... TECHNOLOGY INVESTMENT AGREEMENTS Definitions of Terms Used in This Part § 37.1325 Periodic audit. An audit of... awards. Appendix C to this part describes what such an audit may cover. A periodic audit of a...

  9. 20 CFR 655.1312 - Audits.

    Code of Federal Regulations, 2010 CFR

    2010-04-01

    ... 20 Employees' Benefits 3 2010-04-01 2010-04-01 false Audits. 655.1312 Section 655.1312 Employees... United States (H-2A Workers) § 655.1312 Audits. (a) Discretion. The Department will conduct audits of... selected for audit will be chosen within the sole discretion of the Department. (b) Audit letter. Where...

  10. 13 CFR 120.490 - Audits.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... 13 Business Credit and Assistance 1 2010-01-01 2010-01-01 false Audits. 120.490 Section 120.490... Companies (sblc) § 120.490 Audits. Every SBLC is subject to periodic audits by SBA's Office of Inspector General, Auditing Division, and the cost of such audits will be assessed against the SBLC, except for...

  11. 16 CFR 703.7 - Audits.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... 16 Commercial Practices 1 2010-01-01 2010-01-01 false Audits. 703.7 Section 703.7 Commercial... Audits. (a) The Mechanism shall have an audit conducted at least annually, to determine whether the... be kept under § 703.6 of this part shall be available for audit. (b) Each audit provided for...

  12. 30 CFR 735.22 - Audit.

    Code of Federal Regulations, 2010 CFR

    2010-07-01

    ... 30 Mineral Resources 3 2010-07-01 2010-07-01 false Audit. 735.22 Section 735.22 Mineral Resources... ENFORCEMENT § 735.22 Audit. The agency shall arrange for an independent audit no less frequently than once..., Attachment P. The audits will be performed in accordance with the “Standards for Audit of...

  13. 23 CFR 172.7 - Audits.

    Code of Federal Regulations, 2010 CFR

    2010-04-01

    ... 23 Highways 1 2010-04-01 2010-04-01 false Audits. 172.7 Section 172.7 Highways FEDERAL HIGHWAY... SERVICE CONTRACTS § 172.7 Audits. (a) Performance of audits. When State procedures call for audits of contracts or subcontracts for engineering design services, the audit shall be performed to test...

  14. 38 CFR 41.200 - Audit requirements.

    Code of Federal Regulations, 2010 CFR

    2010-07-01

    ... 38 Pensions, Bonuses, and Veterans' Relief 2 2010-07-01 2010-07-01 false Audit requirements. 41...) AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 41.200 Audit requirements. (a) Audit required. Non-Federal entities that expend $500,000 or more in a year in Federal awards shall...

  15. 29 CFR 99.200 - Audit requirements.

    Code of Federal Regulations, 2010 CFR

    2010-07-01

    ... 29 Labor 1 2010-07-01 2010-07-01 true Audit requirements. 99.200 Section 99.200 Labor Office of the Secretary of Labor AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 99.200 Audit requirements. (a) Audit required. Non-Federal entities that expend $300,000 or more in a...

  16. 29 CFR 99.230 - Audit costs.

    Code of Federal Regulations, 2010 CFR

    2010-07-01

    ... 29 Labor 1 2010-07-01 2010-07-01 true Audit costs. 99.230 Section 99.230 Labor Office of the Secretary of Labor AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 99.230 Audit costs. (a) Allowable costs. Unless prohibited by law, the cost of audits made in accordance with the...

  17. 12 CFR 620.30 - Audit committees.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... 12 Banks and Banking 6 2010-01-01 2010-01-01 false Audit committees. 620.30 Section 620.30 Banks... Association Audit and Compensation Committees § 620.30 Audit committees. Each Farm Credit bank and association must establish and maintain an audit committee. An audit committee is established by adopting a written...

  18. 12 CFR 620.30 - Audit committees.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 12 Banks and Banking 7 2014-01-01 2014-01-01 false Audit committees. 620.30 Section 620.30 Banks... Association Audit and Compensation Committees § 620.30 Audit committees. Each Farm Credit bank and association must establish and maintain an audit committee. An audit committee is established by adopting a...

  19. 7 CFR 1773.8 - Audit date.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 7 Agriculture 12 2012-01-01 2012-01-01 false Audit date. 1773.8 Section 1773.8 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.8 Audit date. (a) The annual audit must be performed as of the end of the same calendar month each year unless prior approval...

  20. 12 CFR 1274.2 - Audit requirements.

    Code of Federal Regulations, 2013 CFR

    2013-01-01

    ... 12 Banks and Banking 9 2013-01-01 2013-01-01 false Audit requirements. 1274.2 Section 1274.2 Banks... § 1274.2 Audit requirements. (a) Each Bank, the OF, and the FICO shall obtain annually an independent external audit of and an audit report on its individual financial statement. (b) The OF audit...

  1. 7 CFR 1773.3 - Annual audit.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 7 Agriculture 12 2012-01-01 2012-01-01 false Annual audit. 1773.3 Section 1773.3 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.3 Annual audit. (a) Each borrower... RUS as set forth in § 1773.4. (b) Each borrower must establish an annual as of audit date...

  2. 7 CFR 3052.200 - Audit requirements.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 7 Agriculture 15 2014-01-01 2014-01-01 false Audit requirements. 3052.200 Section 3052.200..., DEPARTMENT OF AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 3052.200 Audit requirements. (a) Audit required. Non-Federal entities that expend $500,000 or more in a year...

  3. 30 CFR 735.22 - Audit.

    Code of Federal Regulations, 2013 CFR

    2013-07-01

    ... 30 Mineral Resources 3 2013-07-01 2013-07-01 false Audit. 735.22 Section 735.22 Mineral Resources... ENFORCEMENT § 735.22 Audit. The agency shall arrange for an independent audit no less frequently than once..., Attachment P. The audits will be performed in accordance with the “Standards for Audit of...

  4. 32 CFR 37.1325 - Periodic audit.

    Code of Federal Regulations, 2014 CFR

    2014-07-01

    ... 32 National Defense 1 2014-07-01 2014-07-01 false Periodic audit. 37.1325 Section 37.1325 National... TECHNOLOGY INVESTMENT AGREEMENTS Definitions of Terms Used in This Part § 37.1325 Periodic audit. An audit of... awards. Appendix C to this part describes what such an audit may cover. A periodic audit of a...

  5. 7 CFR 3052.230 - Audit costs.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 7 Agriculture 15 2014-01-01 2014-01-01 false Audit costs. 3052.230 Section 3052.230 Agriculture... AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 3052.230 Audit costs. (a) Allowable costs. Unless prohibited by law, the cost of audits made in accordance with...

  6. 12 CFR 390.285 - Audit period.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 12 Banks and Banking 5 2012-01-01 2012-01-01 false Audit period. 390.285 Section 390.285 Banks and... Associations § 390.285 Audit period. The audit period of a State savings association means the twelve month period (or other period in the case of a change in audit period) covered by the annual audit conducted...

  7. 12 CFR 620.30 - Audit committees.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 12 Banks and Banking 7 2012-01-01 2012-01-01 false Audit committees. 620.30 Section 620.30 Banks... Association Audit and Compensation Committees § 620.30 Audit committees. Each Farm Credit bank and association must establish and maintain an audit committee. An audit committee is established by adopting a...

  8. 13 CFR 120.490 - Audits.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 13 Business Credit and Assistance 1 2014-01-01 2014-01-01 false Audits. 120.490 Section 120.490... Companies (sblc) § 120.490 Audits. Every SBLC is subject to periodic audits by SBA's Office of Inspector General, Auditing Division, and the cost of such audits will be assessed against the SBLC, except for...

  9. 38 CFR 41.200 - Audit requirements.

    Code of Federal Regulations, 2012 CFR

    2012-07-01

    ... 38 Pensions, Bonuses, and Veterans' Relief 2 2012-07-01 2012-07-01 false Audit requirements. 41...) AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 41.200 Audit requirements. (a) Audit required. Non-Federal entities that expend $500,000 or more in a year in Federal awards shall...

  10. 32 CFR 37.1325 - Periodic audit.

    Code of Federal Regulations, 2012 CFR

    2012-07-01

    ... 32 National Defense 1 2012-07-01 2012-07-01 false Periodic audit. 37.1325 Section 37.1325 National... TECHNOLOGY INVESTMENT AGREEMENTS Definitions of Terms Used in This Part § 37.1325 Periodic audit. An audit of... awards. Appendix C to this part describes what such an audit may cover. A periodic audit of a...

  11. 30 CFR 735.22 - Audit.

    Code of Federal Regulations, 2012 CFR

    2012-07-01

    ... 30 Mineral Resources 3 2012-07-01 2012-07-01 false Audit. 735.22 Section 735.22 Mineral Resources... ENFORCEMENT § 735.22 Audit. The agency shall arrange for an independent audit no less frequently than once..., Attachment P. The audits will be performed in accordance with the “Standards for Audit of...

  12. 7 CFR 3052.510 - Audit findings.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 7 Agriculture 15 2014-01-01 2014-01-01 false Audit findings. 3052.510 Section 3052.510 Agriculture... AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Auditors § 3052.510 Audit findings. (a) Audit findings reported. The auditor shall report the following as audit findings in...

  13. 23 CFR 172.7 - Audits.

    Code of Federal Regulations, 2013 CFR

    2013-04-01

    ... 23 Highways 1 2013-04-01 2013-04-01 false Audits. 172.7 Section 172.7 Highways FEDERAL HIGHWAY... SERVICE CONTRACTS § 172.7 Audits. (a) Performance of audits. When State procedures call for audits of contracts or subcontracts for engineering design services, the audit shall be performed to test...

  14. 23 CFR 172.7 - Audits.

    Code of Federal Regulations, 2014 CFR

    2014-04-01

    ... 23 Highways 1 2014-04-01 2014-04-01 false Audits. 172.7 Section 172.7 Highways FEDERAL HIGHWAY... SERVICE CONTRACTS § 172.7 Audits. (a) Performance of audits. When State procedures call for audits of contracts or subcontracts for engineering design services, the audit shall be performed to test...

  15. 16 CFR 703.7 - Audits.

    Code of Federal Regulations, 2013 CFR

    2013-01-01

    ... 16 Commercial Practices 1 2013-01-01 2013-01-01 false Audits. 703.7 Section 703.7 Commercial... Audits. (a) The Mechanism shall have an audit conducted at least annually, to determine whether the... be kept under § 703.6 of this part shall be available for audit. (b) Each audit provided for...

  16. 20 CFR 655.1312 - Audits.

    Code of Federal Regulations, 2013 CFR

    2013-04-01

    ... 20 Employees' Benefits 3 2013-04-01 2013-04-01 false Audits. 655.1312 Section 655.1312 Employees... United States (H-2A Workers) § 655.1312 Audits. (a) Discretion. The Department will conduct audits of... selected for audit will be chosen within the sole discretion of the Department. (b) Audit letter. Where...

  17. 29 CFR 99.510 - Audit findings.

    Code of Federal Regulations, 2014 CFR

    2014-07-01

    ... 29 Labor 1 2014-07-01 2013-07-01 true Audit findings. 99.510 Section 99.510 Labor Office of the Secretary of Labor AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Auditors § 99.510 Audit findings. (a) Audit findings reported. The auditor shall report the following as audit findings in...

  18. 7 CFR 1773.8 - Audit date.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 7 Agriculture 12 2014-01-01 2013-01-01 true Audit date. 1773.8 Section 1773.8 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.8 Audit date. (a) The annual audit must be performed as of the end of the same calendar month each year unless prior approval...

  19. 7 CFR 1290.10 - Audit requirements.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 7 Agriculture 10 2012-01-01 2012-01-01 false Audit requirements. 1290.10 Section 1290.10... PROGRAM § 1290.10 Audit requirements. The State is accountable for conducting a financial audit of the... audit, a copy of the audit results....

  20. 29 CFR 99.230 - Audit costs.

    Code of Federal Regulations, 2014 CFR

    2014-07-01

    ... 29 Labor 1 2014-07-01 2013-07-01 true Audit costs. 99.230 Section 99.230 Labor Office of the Secretary of Labor AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 99.230 Audit costs. (a) Allowable costs. Unless prohibited by law, the cost of audits made in accordance with...

  1. 7 CFR 1773.3 - Annual audit.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 7 Agriculture 12 2014-01-01 2013-01-01 true Annual audit. 1773.3 Section 1773.3 Agriculture... (CONTINUED) POLICY ON AUDITS OF RUS BORROWERS RUS Audit Requirements § 1773.3 Annual audit. (a) Each borrower... RUS as set forth in § 1773.4. (b) Each borrower must establish an annual as of audit date...

  2. 12 CFR 1274.2 - Audit requirements.

    Code of Federal Regulations, 2011 CFR

    2011-01-01

    ... 12 Banks and Banking 7 2011-01-01 2011-01-01 false Audit requirements. 1274.2 Section 1274.2 Banks... § 1274.2 Audit requirements. (a) Each Bank, the OF, and the FICO shall obtain annually an independent external audit of and an audit report on its individual financial statement. (b) The OF audit...

  3. 20 CFR 655.1312 - Audits.

    Code of Federal Regulations, 2014 CFR

    2014-04-01

    ... 20 Employees' Benefits 3 2014-04-01 2014-04-01 false Audits. 655.1312 Section 655.1312 Employees... United States (H-2A Workers) § 655.1312 Audits. (a) Discretion. The Department will conduct audits of... selected for audit will be chosen within the sole discretion of the Department. (b) Audit letter. Where...

  4. 11 CFR 9038.1 - Audit.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 11 Federal Elections 1 2012-01-01 2012-01-01 false Audit. 9038.1 Section 9038.1 Federal Elections... EXAMINATIONS AND AUDITS § 9038.1 Audit. (a) General. (1) The Commission will conduct an audit of the qualified... primary matching funds. The audit may be conducted at any time after the date of the...

  5. 13 CFR 120.490 - Audits.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 13 Business Credit and Assistance 1 2012-01-01 2012-01-01 false Audits. 120.490 Section 120.490... Companies (sblc) § 120.490 Audits. Every SBLC is subject to periodic audits by SBA's Office of Inspector General, Auditing Division, and the cost of such audits will be assessed against the SBLC, except for...

  6. 30 CFR 735.22 - Audit.

    Code of Federal Regulations, 2014 CFR

    2014-07-01

    ... 30 Mineral Resources 3 2014-07-01 2014-07-01 false Audit. 735.22 Section 735.22 Mineral Resources... ENFORCEMENT § 735.22 Audit. The agency shall arrange for an independent audit no less frequently than once..., Attachment P. The audits will be performed in accordance with the “Standards for Audit of...

  7. 16 CFR 703.7 - Audits.

    Code of Federal Regulations, 2012 CFR

    2012-01-01

    ... 16 Commercial Practices 1 2012-01-01 2012-01-01 false Audits. 703.7 Section 703.7 Commercial... Audits. (a) The Mechanism shall have an audit conducted at least annually, to determine whether the... be kept under § 703.6 of this part shall be available for audit. (b) Each audit provided for...

  8. 29 CFR 99.200 - Audit requirements.

    Code of Federal Regulations, 2014 CFR

    2014-07-01

    ... 29 Labor 1 2014-07-01 2013-07-01 true Audit requirements. 99.200 Section 99.200 Labor Office of the Secretary of Labor AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 99.200 Audit requirements. (a) Audit required. Non-Federal entities that expend $300,000 or more in...

  9. 11 CFR 9038.1 - Audit.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 11 Federal Elections 1 2014-01-01 2014-01-01 false Audit. 9038.1 Section 9038.1 Federal Elections... EXAMINATIONS AND AUDITS § 9038.1 Audit. (a) General. (1) The Commission will conduct an audit of the qualified... primary matching funds. The audit may be conducted at any time after the date of the...

  10. 12 CFR 390.285 - Audit period.

    Code of Federal Regulations, 2013 CFR

    2013-01-01

    ... 12 Banks and Banking 5 2013-01-01 2013-01-01 false Audit period. 390.285 Section 390.285 Banks and... Associations § 390.285 Audit period. The audit period of a State savings association means the twelve month period (or other period in the case of a change in audit period) covered by the annual audit conducted...

  11. 16 CFR 703.7 - Audits.

    Code of Federal Regulations, 2014 CFR

    2014-01-01

    ... 16 Commercial Practices 1 2014-01-01 2014-01-01 false Audits. 703.7 Section 703.7 Commercial... Audits. (a) The Mechanism shall have an audit conducted at least annually, to determine whether the... be kept under § 703.6 of this part shall be available for audit. (b) Each audit provided for...

  12. 11 CFR 9038.1 - Audit.

    Code of Federal Regulations, 2013 CFR

    2013-01-01

    ... 11 Federal Elections 1 2013-01-01 2012-01-01 true Audit. 9038.1 Section 9038.1 Federal Elections... EXAMINATIONS AND AUDITS § 9038.1 Audit. (a) General. (1) The Commission will conduct an audit of the qualified... primary matching funds. The audit may be conducted at any time after the date of the...

  13. 13 CFR 120.490 - Audits.

    Code of Federal Regulations, 2013 CFR

    2013-01-01

    ... 13 Business Credit and Assistance 1 2013-01-01 2013-01-01 false Audits. 120.490 Section 120.490... Companies (sblc) § 120.490 Audits. Every SBLC is subject to periodic audits by SBA's Office of Inspector General, Auditing Division, and the cost of such audits will be assessed against the SBLC, except for...

  14. 7 CFR 3052.230 - Audit costs.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 3052.230 Audit costs. (a) Allowable costs. Unless prohibited by law, the cost of audits made in accordance with the... 7 Agriculture 15 2010-01-01 2010-01-01 false Audit costs. 3052.230 Section 3052.230 Agriculture...

  15. 7 CFR 3052.200 - Audit requirements.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ..., DEPARTMENT OF AGRICULTURE AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS Audits § 3052.200 Audit requirements. (a) Audit required. Non-Federal entities that expend $500,000 or more in a year in... 7 Agriculture 15 2010-01-01 2010-01-01 false Audit requirements. 3052.200 Section 3052.200...

  16. 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.

  17. Information systems and audit in antenatal care.

    PubMed

    Guthrie, K A; Kelly, M; Lilford, R J

    1990-03-01

    The obstetric record as initiated at the antenatal booking clinic essentially identifies the degree of risk engendered in that pregnancy so that consequent obstetric and paediatric management is tailored appropriately. Whether carried by the patient or based in the hospital with a summary carried by the patient (shared-care card), this record should be exhaustive, the emphasis being on quality, not quantity, of information recorded. To obviate human error in history-taking, patient management or record transcription, we believe on-line computerization of patient records with spin-off paperwork to be the only patient management system to fulfil the above criteria. User-friendly software can be designed with highly branching programmes which provide clinical action suggestions in high-risk cases. Various 'error traps' enhance the accuracy of information recorded. Such systems can be operated by medical and midwifery staff with minimal keyboard skills and are well accepted by patients and staff. Inexpensive and versatile microcomputer networks are excellent for such systems. The operational effects are discussed. Audit means different things to different people and one's view on the subject depends on which definition is selected. Obstetricians are quick to take credit for instituting audit in the form of local and national data collection exercises, such as statistics on perinatal mortality, birthweight, etc. While these exercises certainly constitute observational studies, they cannot be used to make conclusions about the quality of care. There is no sound inference that can be made from a review of information contained in amalgamated databases of hospital statistics. Audit, as properly defined, hinges on inference: the inference that the quality of care was or was not of a high standard. Descriptive statistics, therefore, can be used to generate hypotheses but should not be used as a form of audit, at least not in obstetrics. Auditing the quality of care involves

  18. Revalidation and electronic cataract surgery audit: a Scottish survey on current practice and opinion.

    PubMed

    Megaw, R; Rane-Malcolm, T; Brannan, S; Smith, R; Sanders, R

    2011-11-01

    To determine current knowledge and opinion on revalidation, and methods of cataract surgery audit in Scotland and to outline the current and future possibilities for electronic cataract surgery audit. In 2010 we conducted a prospective, cross-sectional, Scottish-wide survey on revalidation knowledge and opinion, and cataract audit practice among all senior NHS ophthalmologists. Results were anonymised and recorded manually for analysis. In all, 61% of the ophthalmologists surveyed took part. Only 33% felt ready to take part in revalidation, whereas 76% felt they did not have adequate information about the process. Also, 71% did not feel revalidation would improve patient care, but 85% agreed that cataract surgery audit is essential for ophthalmic practice. In addition, 91% audit their cataract outcomes; 52% do so continuously. Further, 63% audit their subspecialist surgical results. Only 25% audit their cataract surgery practice electronically, and only 12% collect clinical data using a hospital PAS system. Funding and system incompatibility were the main reasons cited for the lack of electronic audit setup. Currently, eight separate hospital IT patient administration systems are used across 14 health boards in Scotland. Revalidation is set to commence in 2012. The Royal College of Ophthalmologists will use cataract outcome audit as a tool to ensure surgical competency for the process. Retrospective manual auditing of cataract outcome is time consuming, and can be avoided with an electronic system. Scottish ophthalmologists view revalidation with scepticism and appear to have inadequate knowledge of the process. However, they strongly agree with the concept of cataract surgery audit. The existing and future electronic applications that may support surgical audit are commercial electronic records, web-based applications, centrally funded software applications, and robust NHS connections between community and hospital.

  19. Criteria for internal auditing.

    PubMed

    Holder, W W; Clay, R J

    1979-01-01

    An effective, inclusive internal auditing endeavor should help assure hospital managements that (1) an adequate system of internal control exists to assure the safeguarding of assets and the reliability of data produced by the financial information system, (2) uneconomic operating practices are detected promptly so they can be remedied, and (3) program results and effectiveness levels are of sufficiently high quality to demonstrate managerial competence.

  20. Audit Plan FY 2005

    DTIC Science & Technology

    2005-05-27

    of accountability and transactions submitted to the U . S . Treasury. Expenditure reporting performed by DFAS Indianapolis is critical to the accuracy...determine whether the retirement, health, and life insurance withholdings and employee headcount data submitted by DoD, and other Government agencies for...Withholding Data (D2004FH-0046) The overall audit objective was to determine whether the retirement, health, and life insurance withholdings and

  1. Public Perception and School District Audits.

    ERIC Educational Resources Information Center

    Burkybile, Sharon; Goodman, Jon

    1999-01-01

    School districts are subject to many audits each year. Offers a guide to school district business officials on managing their various audits effectively to maximize the benefits of each audit and minimize public-image damage and disruption. (MLF)

  2. Auditing the Records of Student-Athletes.

    ERIC Educational Resources Information Center

    Riggs, Robert O.; Hedden, Carole R.

    1985-01-01

    A 1985 survey showed that NCAA members favored mandating annual audits of athletics budgets by institutional or independent auditors. Development of Tennessee's internal audit system is described, and its internal audit procedures is outlined. (MLW)

  3. Auditing the Records of Student-Athletes.

    ERIC Educational Resources Information Center

    Riggs, Robert O.; Hedden, Carole R.

    1985-01-01

    A 1985 survey showed that NCAA members favored mandating annual audits of athletics budgets by institutional or independent auditors. Development of Tennessee's internal audit system is described, and its internal audit procedures is outlined. (MLW)

  4. 7 CFR 1291.11 - Audit requirements.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... Act applies to an eligible grantee, the State shall submit the annual audit results to AMS within 30... shall submit to AMS not later than 30 days after completion of the audit, a copy of the audit results....

  5. 7 CFR 4284.18 - Audit requirements.

    Code of Federal Regulations, 2010 CFR

    2010-01-01

    ... Grant Programs § 4284.18 Audit requirements. Grantees must comply with the audit requirements of 7 CFR part 3052. The audit requirements apply to the years in which grant funds are received and years in...

  6. The ICA Communication Audit: Process, Status, Critique

    ERIC Educational Resources Information Center

    Goldhaber, Gerald M.; Krivonos, Paul D.

    1977-01-01

    Explores the International Communication Association (ICA) Audit process including goals, products, instruments, audit logistics and timetable, feedback of results and follow-up, costs, current status and audits conducted to date. (ED.)

  7. 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.

  8. Integrating Excel Spreadsheets into the Introductory Astronomy Laboratory

    NASA Astrophysics Data System (ADS)

    Keohane, Jonathan W.; Bartlett, J. L.; Bloom, S. D.; Foy, J. P.; Thurman, H. O.

    2008-05-01

    At Hampden-Sydney College, we teach a one-semester introductory astronomy class targeting non-science majors. This course fulfills the laboratory science requirement, and as such the class is obligated to teach transferable skills such as basic numeracy, quantitative reasoning and data analysis. To this end, we explicitly teach the use of the most commonly available data analysis program, which is currently Microsoft Excel. The laboratory sciences are ideally suited to teaching these skills. During each laboratory session, students explore an astronomical phenomenon related to the lectures for that week. Randomly assigned partners use computers to analyze their data in spreadsheets and to write detailed reports structured like journal articles. We present nine Excel templates, along with the corresponding laboratory instructions, that are designed to teach general data analysis techniques using spreadsheets within the context of a traditional astronomy laboratory. These exercises begin with basic calculations and move toward more complex ones such as least squares fitting of sine functions and calculating distances from measured magnitudes and assumed luminosities.

    Laboratory Exercises with Excel Templates
    Measuring AnglesThis first lab uses the small angle formula.
    Jupiter's MoonsThe students take data with the CLEA lab of Jupiter's moons, but complete the data analysis using Excel. This includes least squares fitting of sine functions.
    Astrometry and ParallaxThe students complete the Astrometry of Asteroids CLEA lab, but perform the parallax calculations using Excel.
    The Resolution of a Telescope

  9. Inventory auditing: a manufacturing perspective.

    PubMed

    Swartley, J A; Hall, J D

    1990-08-01

    Despite the mystery that usually surrounds the annual audit program, its plan is easy to understand if you learn the basic concerns of the auditor. A five-step inventory audit plan usually consists of proving that the inventory exists, is completely represented, belongs to the firm, is properly valued, and is properly classified. To develop the inventory audit plan, an auditor must verify a firm's system of internal controls, in addition to verifying management's financial assertions by obtaining evidence about them. The time, cost, and frequency of the inventory audit with even the best plans may vary because of changing factors.

  10. Statistical auditing of toxicology reports.

    PubMed

    Deaton, R R; Obenchain, R L

    1994-06-01

    Statistical auditing is a new report review process used by the quality assurance unit at Eli Lilly and Co. Statistical auditing allows the auditor to review the process by which the report was generated, as opposed to the process by which the data was generated. We have the flexibility to use different sampling techniques and still obtain thorough coverage of the report data. By properly implementing our auditing process, we can work smarter rather than harder and continue to help our customers increase the quality of their products (reports). Statistical auditing is helping our quality assurance unit meet our customers' need, while maintaining or increasing the quality of our regulatory obligations.

  11. Use of clinical audit for revalidation: is it sufficiently accurate?

    PubMed

    Jutley, R S; McKinley, A; Hobeldin, M; Mohamed, A; Youngson, G G

    2001-09-01

    In order to provide better patient care, clinicians will be subject to revalidation and re-certification. This may be partially based on existing and ongoing data collection, yet many units fail to incorporate mechanisms that validate the data that may be used. The accuracy of audit data was evaluated in a unit that has been using commercially available audit software for over 10 years. A total of 655 consecutive surgical admissions were documented over a 6-month period and errors in data collection and entry were gathered and analyzed. An overall accuracy of 90.5% was confirmed but examination of the data found them to be open to misinterpretation. Moreover, 13% of errors were made during a single week when locum staff were involved. The study highlights the fallibility of data collection during audit, and urges caution if using such data when judging performance-related issues as part of the process of appraisal.

  12. Standard Evaluation Procedures (SEPs) and Data Entry Spreadsheet Templates (DESTs) for Endocrine Disruptor Screening Program (EDSP) Tier 1 Assays

    EPA Pesticide Factsheets

    This page provides information and access to Standard Evaluation Procedures (SEPs) and Data Entry Spreadsheet Templates (DESTs) developed by EPA's Office of Chemical Safety and Pollution Prevention (OCSPP).

  13. NEVER AUDIT ALONE--THE CASE FOR AUDIT TEAMS

    EPA Science Inventory

    On-site audits conducted by technical and quality assurance (QA) experts at the data-gathering location are the core of an effective QA program. However, inadequate resources for such audits are the bane of a QA program, and the proposed solution frequently is to send only one au...

  14. NEVER AUDIT ALONE--THE CASE FOR AUDIT TEAMS

    EPA Science Inventory

    On-site audits conducted by technical and quality assurance (QA) experts at the data-gathering location are the core of an effective QA program. However, inadequate resources for such audits are the bane of a QA program, and the proposed solution frequently is to send only one au...

  15. DCAA Audits: Widespread Problems with Audit Quality Require Significant Reform

    DTIC Science & Technology

    2009-09-01

    GAO United States Government Accountability Office Report to the Committee on Homeland Security and Governmental Affairs...U.S. Senate DCAA AUDITS Widespread Problems with Audit Quality Require Significant Reform September 2009 GAO-09-468 Report ...Documentation Page Form ApprovedOMB No. 0704-0188 Public reporting burden for the collection of information is estimated to average 1 hour per response

  16. Environmental auditing: Theory and applications

    NASA Astrophysics Data System (ADS)

    Thompson, Dixon; Wilson, Melvin J.

    1994-07-01

    The environmental audit has become a regular part of corporate environmental management in Canada and is also gaining recognition in the public sector. A 1991 survey of 75 private sector companies across Canada revealed that 76% (57/75) had established environmental auditing programs. A similar survey of 19 federal, provincial, and municipal government departments revealed that 11% (2/19) had established such programs. The information gained from environmental audits can be used to facilitate and enhance environmental management from the single facility level to the national and international levels. This paper is divided into two sections: section one examines environmental audits at the facility/company level and discusses environmental audit characteristics, trends, and driving forces not commonly found in the available literature. Important conclusions are: that wherever possible, an action plan to correct the identified problems should be an integral part of an audit, and therefore there should be a close working relationship between auditors, managers, and employees, and that the first audits will generally be more difficult, time consuming, and expensive than subsequent audits. Section two looks at environmental audits in the broader context and discusses the relationship between environmental audits and three other environmental information gathering/analysis tools: environmental impact assessments, state of the environment reports, and new systems of national accounts. The argument is made that the information collected by environmental audits and environmental impact assessments at the facility/company level can be used as the bases for regional and national state of the environment reports and new systems of national accounts.

  17. Oversight Review: Quality Control Review of Army Audit Agency’s Special Access Program Audits

    DTIC Science & Technology

    2005-08-25

    external peer review at least once every three years by reviewers independent of the audit organization being reviewed. As the organization that has audit...policy and oversight responsibilities for audits in the DoD, we conducted this external peer review of the AAA SAP audits in conjunction with the Air...Force Audit Agency (AFAA) external peer review of AAA non-SAP audits. An audit organization’s quality control policies and procedures should be

  18. Oversight Review: Quality Control Review of Air Force Audit Agency’s Special Access Program Audits

    DTIC Science & Technology

    2005-08-26

    external peer review at least once every 3 years by reviewers independent of the audit organization being reviewed. As the organization that has audit...policy and oversight responsibilities for audits in the Department of Defense, we conducted this external peer review of the AFAA SAP audits in...conjunction with the Naval Audit Service’s external peer review of AFAA non-SAP audits. An audit organization’s quality control policies and procedures

  19. A "Quick & Dirty" Strategic Audit

    ERIC Educational Resources Information Center

    Brawley, Dorothy E.

    2016-01-01

    In teaching Strategic Management, it is imperative that students first learn how to audit the firm before they begin analysis, planning and implementation. Unfortunately this is a step often overlooked. Without a complete and up to date audit, any analysis conducted would have questionable validity and reliability. This report focuses on an…

  20. Getting Ready for an Audit.

    ERIC Educational Resources Information Center

    Jacobsen, Julia

    1979-01-01

    The increasing intrusion of the federal government in institutional affairs and accountability make audits of higher education institutions inevitable. Some suggestions on how to be prepared for an audit are provided. Suggestions include familiarization with regulations, current indirect cost rate, and current rate for benefits negotiated with…

    1. Your Audit and Financial Controls.

      ERIC Educational Resources Information Center

      Hatch, Mary B.; And Others

      Audits should be performed on school accounting systems because they are required by law and they provide independent reviews of school financial procedures and suggestions for improvement. A licensed certified public accountant, public accountant, or an accountant who has met the Continuation of Education requirement should perform the audit.…

    2. The Audit Committee. Board Basics

      ERIC Educational Resources Information Center

      Ostrom, John S.

      2004-01-01

      The Effective Committees set of booklets comprises publications on the following committees: investment, buildings and grounds, academic affairs, student affairs, finance, development, trustees, audit, compensation, and executive. It is part of the AGB Board Basics Series. This report describes the primary role of an audit committee. The primary…

    3. The Audit Committee. Board Basics

      ERIC Educational Resources Information Center

      Ostrom, John S.

      2004-01-01

      The Effective Committees set of booklets comprises publications on the following committees: investment, buildings and grounds, academic affairs, student affairs, finance, development, trustees, audit, compensation, and executive. It is part of the AGB Board Basics Series. This report describes the primary role of an audit committee. The primary…

    4. Women's Campus Safety Audit Guide.

      ERIC Educational Resources Information Center

      Council of Ontario Universities, Toronto.

      This booklet is designed for those who want to make the college campus a safer environment for women. Specifically, it provides information to help make public and semi-public places safer and more comfortable for women, focusing on preventing sexual harassment and assault. The booklet introduces the safety audit and explains what the audit is…

    5. Your Audit and Financial Controls.

      ERIC Educational Resources Information Center

      Hatch, Mary B.; And Others

      Audits should be performed on school accounting systems because they are required by law and they provide independent reviews of school financial procedures and suggestions for improvement. A licensed certified public accountant, public accountant, or an accountant who has met the Continuation of Education requirement should perform the audit.…

    6. A Spreadsheet Simulation Tool for Terrestrial and Planetary Balloon Design

      NASA Technical Reports Server (NTRS)

      Raquea, Steven M.

      1999-01-01

      During the early stages of new balloon design and development, it is necessary to conduct many trade studies. These trade studies are required to determine the design space, and aid significantly in determining overall feasibility. Numerous point designs then need to be generated as details of payloads, materials, mission, and manufacturing are determined. To accomplish these numerous designs, transient models are both unnecessary and time intensive. A steady state model that uses appropriate design inputs to generate system-level descriptive parameters can be very flexible and fast. Just such a steady state model has been developed and has been used during both the MABS 2001 Mars balloon study and the Ultra Long Duration Balloon Project. Using Microsoft Excel's built-in iteration routine, a model was built. Separate sheets were used for performance, structural design, materials, and thermal analysis as well as input and output sheets. As can be seen from figure 1, the model takes basic performance requirements, weight estimates, design parameters, and environmental conditions and generates a system level balloon design. Figure 2 shows a sample output of the model. By changing the inputs and a few of the equations in the model, balloons on earth or other planets can be modeled. There are currently several variations of the model for terrestrial and Mars balloons, as well there are versions of the model that perform crude material design based on strength and weight requirements. To perform trade studies, the Visual Basic language built into Excel was used to create an automated matrix of designs. This trade study module allows a three dimensional trade surface to be generated by using a series of values for any two design variables. Once the fixed and variable inputs are defined, the model automatically steps through the input matrix and fills a spreadsheet with the resulting point designs. The proposed paper will describe the model in detail, including current

    7. A Spreadsheet Simulation Tool for Terrestrial and Planetary Balloon Design

      NASA Technical Reports Server (NTRS)

      Raquea, Steven M.

      1999-01-01

      During the early stages of new balloon design and development, it is necessary to conduct many trade studies. These trade studies are required to determine the design space, and aid significantly in determining overall feasibility. Numerous point designs then need to be generated as details of payloads, materials, mission, and manufacturing are determined. To accomplish these numerous designs, transient models are both unnecessary and time intensive. A steady state model that uses appropriate design inputs to generate system-level descriptive parameters can be very flexible and fast. Just such a steady state model has been developed and has been used during both the MABS 2001 Mars balloon study and the Ultra Long Duration Balloon Project. Using Microsoft Excel's built-in iteration routine, a model was built. Separate sheets were used for performance, structural design, materials, and thermal analysis as well as input and output sheets. As can be seen from figure 1, the model takes basic performance requirements, weight estimates, design parameters, and environmental conditions and generates a system level balloon design. Figure 2 shows a sample output of the model. By changing the inputs and a few of the equations in the model, balloons on earth or other planets can be modeled. There are currently several variations of the model for terrestrial and Mars balloons, as well there are versions of the model that perform crude material design based on strength and weight requirements. To perform trade studies, the Visual Basic language built into Excel was used to create an automated matrix of designs. This trade study module allows a three dimensional trade surface to be generated by using a series of values for any two design variables. Once the fixed and variable inputs are defined, the model automatically steps through the input matrix and fills a spreadsheet with the resulting point designs. The proposed paper will describe the model in detail, including current

    8. A collaborative computer auditing system under SOA-based conceptual model

      NASA Astrophysics Data System (ADS)

      Cong, Qiushi; Huang, Zuoming; Hu, Jibing

      2013-03-01

      Some of the current challenges of computer auditing are the obstacles to retrieving, converting and translating data from different database schema. During the last few years, there are many data exchange standards under continuous development such as Extensible Business Reporting Language (XBRL). These XML document standards can be used for data exchange among companies, financial institutions, and audit firms. However, for many companies, it is still expensive and time-consuming to translate and provide XML messages with commercial application packages, because it is complicated and laborious to search and transform data from thousands of tables in the ERP databases. How to transfer transaction documents for supporting continuous auditing or real time auditing between audit firms and their client companies is a important topic. In this paper, a collaborative computer auditing system under SOA-based conceptual model is proposed. By utilizing the widely used XML document standards and existing data transformation applications developed by different companies and software venders, we can wrap these application as commercial web services that will be easy implemented under the forthcoming application environments: service-oriented architecture (SOA). Under the SOA environments, the multiagency mechanism will help the maturity and popularity of data assurance service over the Internet. By the wrapping of data transformation components with heterogeneous databases or platforms, it will create new component markets composed by many software vendors and assurance service companies to provide data assurance services for audit firms, regulators or third parties.

    9. PAD_AUDIT -- PAD Auditing Package

      NASA Astrophysics Data System (ADS)

      Clayton, C. A.

      The PAD (Packet Assembler Disassembler) utility is the part of the VAX/VMS Coloured Book Software (CBS) which allows a user to log onto remote computers from a local VAX. Unfortunately, logging into a computer via either the Packet SwitchStream (PSS) or the International Packet SwitchStream (IPSS) costs real money. Some users either do not appreciate this or do not care and have been known to clock up rather large quarterly bills. This software package allows a system manager to determine who has used PAD to call where and (most importantly) how much it has cost. The system manager can then take appropriate action - either charging the individuals, warning them to use the facility with more care or even denying access to a greedy user to one or more sites.

    10. Multidisciplinary audit of digoxin.

      PubMed

      Keys, P W; DeSantis, D; Duffy, M G

      1978-08-01

      Use review of digoxin as part of a medical care evaluation study in a hospital is described. This drug audit within the hospital's quality assurance program used a multidisciplinary approach. The study was designed to measure the incidence of digoxin toxicity, evaluate monitoring practices for digoxin use and evaluate the adequacy of digoxin dosing patterns. Forty-eight patients were involved. Results indicated that some patients were not adequately assessed in regard to renal function and digoxin serum level. Further, there was a 17% incidence of digoxin toxicity. Studies such as this give pharmacists an opportunity to use their knowledge of proper drug use through a structured hospital program.

    11. Introducing students to clinical audit.

      PubMed

      Parkes, Jacqueline; O'Dell, Cindy

      2015-11-01

      It is more than a decade since the UK Central Council for Nursing Midwifery and Health Visiting said that engaging with clinical audit is 'the business of every registered practitioner', yet there appears to be little evidence that nursing has embraced the process. To address this issue, Northampton General Hospital and the University of Northampton implemented a pilot project in which two third-year adult nursing students worked on a 'real life' audit. Supported by the hospital's audit department, and supervised by academic tutors with the relevant experience, the students worked on a pressure-ulcer care audit for their final year dissertation. This article describes the process undertaken by the hospital audit team and the university academic team to develop the pilot project and support the students. Based on the positive evaluations, the university has extended the project to a second phase, incorporating two new partner organisations.

    12. Structural methodologies for auditing SNOMED.

      PubMed

      Wang, Yue; Halper, Michael; Min, Hua; Perl, Yehoshua; Chen, Yan; Spackman, Kent A

      2007-10-01

      SNOMED is one of the leading health care terminologies being used worldwide. As such, quality assurance is an important part of its maintenance cycle. Methodologies for auditing SNOMED based on structural aspects of its organization are presented. In particular, automated techniques for partitioning SNOMED into smaller groups of concepts based primarily on relationships patterns are defined. Two abstraction networks, the area taxonomy and p-area taxonomy, are derived from the partitions. The high-level views afforded by these abstraction networks form the basis for systematic auditing. The networks tend to highlight errors that manifest themselves as irregularities at the abstract level. They also support group-based auditing, where sets of purportedly similar concepts are focused on for review. The auditing methodologies are demonstrated on one of SNOMED's top-level hierarchies. Errors discovered during the auditing process are reported.

    13. [Development of an Excel spreadsheet for meta-analysis of indirect and mixed treatment comparisons].

      PubMed

      Tobías, Aurelio; Catalá-López, Ferrán; Roqué, Marta

      2014-01-01

      Meta-analyses in clinical research usually aimed to evaluate treatment efficacy and safety in direct comparison with a unique comparator. Indirect comparisons, using the Bucher's method, can summarize primary data when information from direct comparisons is limited or nonexistent. Mixed comparisons allow combining estimates from direct and indirect comparisons, increasing statistical power. There is a need for simple applications for meta-analysis of indirect and mixed comparisons. These can easily be conducted using a Microsoft Office Excel spreadsheet. We developed a spreadsheet for indirect and mixed effects comparisons of friendly use for clinical researchers interested in systematic reviews, but non-familiarized with the use of more advanced statistical packages. The use of the proposed Excel spreadsheet for indirect and mixed comparisons can be of great use in clinical epidemiology to extend the knowledge provided by traditional meta-analysis when evidence from direct comparisons is limited or nonexistent.

    14. MicroComputer Software for Predicting Growth of Southern Timber Stands

      Treesearch

      Robert M. Farrar

      1992-01-01

      Sixteen BASIC programs and 21 electronic spreadsheet templates for microcomputers are presented with documentation and examples of use, This software permits simulation of the growth and yield of natural stands ofeven-aged southern pines, uneven-aged loblolly-shortleaf and shortleaf pines,even-aged yellow-poplar, and of certain planted pine stands for a variety of site...

    15. Spreadsheet calculations of absorbed dose to water for photons and electrons according to established dosimetry protocols.

      PubMed

      Cederbaum, M; Kuten, A

      1999-01-01

      The calculation of absorbed dose to water according to a Code of Practice demands a strict adherence to the rules and data of the protocol. To ease the calculations and to avoid computational and methodological errors, we have developed a number of spreadsheets to perform the calculations in accordance with an established dosimetry protocol-in our case those of the International Atomic Energy Agency (IAEA) and the Institution of Physics and Engineering in Medicine and Biology (IPEMB). The spreadsheets are implemented as Microsoft Excel V5.0 worksheets. Only a limited selection of dosimetry equipment is used for calibration, which is performed according to only one of the methods allowed by the protocol. This voluntary limitation of equipment and methods is reflected in a spreadsheet that is beam-specific, compact, focused, and very practical. There are four main spreadsheets: high-energy photons (IAEA), high-energy electrons (IAEA), medium energy X rays (IPEMB), and low-energy X rays (IPEMB). The sheets allow the input of setup and measured data, but tabulated data and formulas are protected. Parameter values are copied from the protocols, and the relevant value is found by linear interpolation. Once the spreadsheets are drawn up correctly and thoroughly checked, protocol calculations are performed easily and accurately. The spreadsheets presented are tailored to suit our specific needs but can easily be modified to conform to the practices of any other institution. They are not intended as "cookbooks" but need to be filled in by a radiation physicist with the input data checked by a second professional. The same method is also used for calculating the Reference Air Kerma Rate of brachytherapy sources.

    16. Mobile Building Energy Audit and Modeling Tools: Cooperative Research and Development Final Report, CRADA Number CRD-11-00441

      SciTech Connect

      Brackney, L.

      2013-04-01

      Broadly accessible, low cost, accurate, and easy-to-use energy auditing tools remain out of reach for managers of the aging U.S. building population (over 80% of U.S. commercial buildings are more than 10 years old*). concept3D and NREL's commercial buildings group will work to translate and extend NREL's existing spreadsheet-based energy auditing tool for a browser-friendly and mobile-computing platform. NREL will also work with concept3D to further develop a prototype geometry capture and materials inference tool operable on a smart phone/pad platform. These tools will be developed to interoperate with NREL's Building Component Library and OpenStudio energy modeling platforms, and will be marketed by concept3D to commercial developers, academic institutions and governmental agencies. concept3D is NREL's lead developer and subcontractor of the Building Component Library.

    17. Can virtual streetscape audits reliably replace physical streetscape audits?

      PubMed

      Badland, Hannah M; Opit, Simon; Witten, Karen; Kearns, Robin A; Mavoa, Suzanne

      2010-12-01

      There is increasing recognition that the neighborhood-built environment influences health outcomes, such as physical activity behaviors, and technological advancements now provide opportunities to examine the neighborhood streetscape remotely. Accordingly, the aims of this methodological study are to: (1) compare the efficiencies of physically and virtually conducting a streetscape audit within the neighborhood context, and (2) assess the level of agreement between the physical (criterion) and virtual (test) audits. Built environment attributes associated with walking and cycling were audited using the New Zealand Systematic Pedestrian and Cycling Environment Scan (NZ-SPACES) in 48 street segments drawn from four neighborhoods in Auckland, New Zealand. Audits were conducted physically (on-site) and remotely (using Google Street View) in January and February 2010. Time taken to complete the audits, travel mileage, and Internet bandwidth used were also measured. It was quicker to conduct the virtual audits when compared with the physical audits (χ = 115.3 min (virtual), χ = 148.5 min (physical)). In the majority of cases, the physical and virtual audits were within the acceptable levels of agreement (ICC ≥  0.70) for the variables being assessed. The methodological implication of this study is that Google Street View is a potentially valuable data source for measuring the contextual features of neighborhood streets that likely impact on health outcomes. Overall, Google Street View provided a resource-efficient and reliable alternative to physically auditing the attributes of neighborhood streetscapes associated with walking and cycling. Supplementary data derived from other sources (e.g., Geographical Information Systems) could be used to assess the less reliable streetscape variables.

    18. 30 CFR 1208.15 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-07-01

      ... 30 Mineral Resources 3 2011-07-01 2011-07-01 false Audits. 1208.15 Section 1208.15 Mineral... Revenue SALE OF FEDERAL ROYALTY OIL General Provisions § 1208.15 Audits. Audits of the accounts and books... at such other times as may be directed by ONRR. Such audits will be for the purpose of determining...

    19. 43 CFR 3597.2 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-10-01

      ... 43 Public Lands: Interior 2 2011-10-01 2011-10-01 false Audits. 3597.2 Section 3597.2 Public Lands... Production Records § 3597.2 Audits. (a) An audit of the operator's/lessee's accounts and books may be made or... Federal Regulations. (b) An audit of the operator's/lessee's accounts and production records by the...

    20. 20 CFR 655.180 - Audit.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 20 Employees' Benefits 3 2011-04-01 2011-04-01 false Audit. 655.180 Section 655.180 Employees... United States (H-2A Workers) Integrity Measures § 655.180 Audit. The CO may conduct audits of applications for which certifications have been granted. (a) Discretion. The applications selected for audit...

    1. 20 CFR 404.1627 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 20 Employees' Benefits 2 2011-04-01 2011-04-01 false Audits. 404.1627 Section 404.1627 Employees...- ) Determinations of Disability Administrative Responsibilities and Requirements § 404.1627 Audits. (a) Audits performed by the State—(1) Generally. Audits of accounts and records pertaining to the administration of the...

    2. 24 CFR 236.901 - Audit.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 24 Housing and Urban Development 2 2011-04-01 2011-04-01 false Audit. 236.901 Section 236.901... AND INTEREST REDUCTION PAYMENT FOR RENTAL PROJECTS Audits § 236.901 Audit. Where a State or local... mortgagor of a mortgage insured or held by the Commissioner under this part, it shall conduct audits in...

    3. 11 CFR 9007.1 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-01-01

      ... 11 Federal Elections 1 2011-01-01 2011-01-01 false Audits. 9007.1 Section 9007.1 Federal Elections... AND AUDITS; REPAYMENTS § 9007.1 Audits. (a) General. (1) After each Presidential election, the Commission will conduct a thorough examination and audit of the receipts, disbursements, debts and...

    4. 7 CFR 246.20 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-01-01

      ... 7 Agriculture 4 2011-01-01 2011-01-01 false Audits. 246.20 Section 246.20 Agriculture Regulations... Monitoring and Review § 246.20 Audits. (a) Federal audit responsibilities. (1) OIG reserves the right to perform audits of State and local agencies and other organizations involved in the Program as determined...

    5. 49 CFR 663.9 - Audit limitations.

      Code of Federal Regulations, 2011 CFR

      2011-10-01

      ... 49 Transportation 7 2011-10-01 2011-10-01 false Audit limitations. 663.9 Section 663.9..., DEPARTMENT OF TRANSPORTATION PRE-AWARD AND POST-DELIVERY AUDITS OF ROLLING STOCK PURCHASES General § 663.9 Audit limitations. (a) An audit under this part is limited to verifying compliance with (1) Applicable...

    6. 24 CFR 982.159 - Audit requirements.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 24 Housing and Urban Development 4 2011-04-01 2011-04-01 false Audit requirements. 982.159 Section... Administration of Program § 982.159 Audit requirements. (a) The PHA must engage and pay an independent public accountant to conduct audits in accordance with HUD requirements. (b) The PHA is subject to the audit...

    7. 20 CFR 632.33 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 20 Employees' Benefits 3 2011-04-01 2011-04-01 false Audits. 632.33 Section 632.33 Employees... AND TRAINING PROGRAMS Administrative Standards and Procedures § 632.33 Audits. (a) General. The audit provisions of 41 CFR part 29-70 shall apply to Native American grantees. Until unified or single audit...

    8. 50 CFR 401.23 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-10-01

      ... 50 Wildlife and Fisheries 9 2011-10-01 2011-10-01 false Audits. 401.23 Section 401.23 Wildlife and... ENHANCEMENT § 401.23 Audits. The State is required to conduct an audit at least every two years in accordance with the provisions of Attachment P OMB Circular A-102. Failure to conduct audits as required may...

    9. 42 CFR 457.236 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-10-01

      ... 42 Public Health 4 2011-10-01 2011-10-01 false Audits. 457.236 Section 457.236 Public Health...-Reviews and Audits; Withholding for Failure to Comply; Deferral and Disallowance of Claims; Reduction of Federal Medical Payments § 457.236 Audits. The CHIP agency must assure appropriate audit of records on...

    10. 7 CFR 1782.10 - Audit requirements.

      Code of Federal Regulations, 2011 CFR

      2011-01-01

      ... 7 Agriculture 12 2011-01-01 2011-01-01 false Audit requirements. 1782.10 Section 1782.10... AGRICULTURE (CONTINUED) SERVICING OF WATER AND WASTE PROGRAMS § 1782.10 Audit requirements. Audits for loans... experiencing problems, the servicing official will require an audit or other documentation deemed necessary to...

    11. 7 CFR 4284.18 - Audit requirements.

      Code of Federal Regulations, 2011 CFR

      2011-01-01

      ... 7 Agriculture 15 2011-01-01 2011-01-01 false Audit requirements. 4284.18 Section 4284.18... Grant Programs § 4284.18 Audit requirements. Grantees must comply with the audit requirements of 7 CFR part 3052. The audit requirements apply to the years in which grant funds are received and years in...

    12. 50 CFR 81.15 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-10-01

      ... 50 Wildlife and Fisheries 8 2011-10-01 2011-10-01 false Audits. 81.15 Section 81.15 Wildlife and..., WILDLIFE, AND PLANTS-COOPERATION WITH THE STATES § 81.15 Audits. The State is required to conduct an audit.... Failure to conduct audits as required may result in withholding of grant payments or such other sanctions...

    13. 7 CFR 1291.11 - Audit requirements.

      Code of Federal Regulations, 2011 CFR

      2011-01-01

      ... 7 Agriculture 10 2011-01-01 2011-01-01 false Audit requirements. 1291.11 Section 1291.11... PROGRAM-FARM BILL § 1291.11 Audit requirements. Each year that a State receives a grant under the SCBGP-FB, the State is required to conduct an audit of the expenditures of SCBGP-FB funds. If the Single Audit...

    14. 20 CFR 416.2220 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 20 Employees' Benefits 2 2011-04-01 2011-04-01 false Audits. 416.2220 Section 416.2220 Employees... Payments for Vocational Rehabilitation Services Administrative Provisions § 416.2220 Audits. (a) General... in the Federal Procurement Regulations (41 CFR parts 1-20). (b) Audit basis. Auditing will be based...

    15. 20 CFR 416.1027 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 20 Employees' Benefits 2 2011-04-01 2011-04-01 false Audits. 416.1027 Section 416.1027 Employees... Determinations of Disability Administrative Responsibilities and Requirements § 416.1027 Audits. (a) Audits performed by the State—(1) Generally. Audits of account and records pertaining to the administration of the...

    16. 7 CFR 4284.657 - Audit requirements.

      Code of Federal Regulations, 2011 CFR

      2011-01-01

      ... 7 Agriculture 15 2011-01-01 2011-01-01 false Audit requirements. 4284.657 Section 4284.657 Agriculture Regulations of the Department of Agriculture (Continued) RURAL BUSINESS-COOPERATIVE SERVICE AND... Audit requirements. Grantees must provide an annual audit in accordance with 7 CFR part 3052. The audit...

    17. 42 CFR 430.33 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-10-01

      ... 42 Public Health 4 2011-10-01 2011-10-01 false Audits. 430.33 Section 430.33 Public Health CENTERS... ASSISTANCE PROGRAMS GRANTS TO STATES FOR MEDICAL ASSISTANCE PROGRAMS Grants; Reviews and Audits; Withholding... § 430.33 Audits. (a) Purpose. The Department's Office of Inspector General (OIG) periodically audits...

    18. 7 CFR 285.4 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-01-01

      ... 7 Agriculture 4 2011-01-01 2011-01-01 false Audits. 285.4 Section 285.4 Agriculture Regulations of... PUERTO RICO § 285.4 Audits. (a) The Commonwealth of Puerto Rico shall provide an audit of expenditures in... such audit shall be reported to FNS no later than 120 days from the end of each fiscal year in which...

    19. 20 CFR 404.2120 - Audits.

      Code of Federal Regulations, 2011 CFR

      2011-04-01

      ... 20 Employees' Benefits 2 2011-04-01 2011-04-01 false Audits. 404.2120 Section 404.2120 Employees...- ) Payments for Vocational Rehabilitation Services Administrative Provisions § 404.2120 Audits. (a) General... in the Federal Procurement Regulations (41 CFR parts 1-20). (b) Audit basis. Auditing will be based...

    20. 20 CFR 655.24 - Audits.

      Code of Federal Regulations, 2012 CFR

      2012-04-01

      ... OFLC. (b) Audit letter. When an application is selected for audit, the CO shall issue an audit letter... documentation must be received by the CO; and (3) Advise that failure to comply with the audit process may result in a finding by the CO to: (i) Require the employer to conduct supervised recruitment under §...