Building Databases and the Cocitation Counts Generation System Using Microsoft Excel Program in Visual Basics

2010 ◽  
pp. 137-142
Author(s):  
Sean Eom
Keyword(s):  
Retrieval System ◽  
Generation System ◽  
Microsoft Excel ◽  
Spreadsheet Program ◽  
Citation Database ◽  
Research Journal ◽  
Alternative Approach ◽  
Master's Thesis ◽  
Author Citations

This chapter shows another alternative approach of building citation database and retrieval system using the spreadsheet program, Microsoft Excel. McIntyre built a custom database based on the Clothing and Textile Research Journal (CTRJ), covering from 1990 to 2006 as part of his master’s thesis. The database includes all the author citations, citations sorted by article, and the top cited author’s cocitation frequencies.

A Master Class in Dimensional Analysis: the Universal Gas Constant

2018 ◽  
Author(s):  
john andraos
Keyword(s):  
Physical Chemistry ◽  
High School ◽  
General Chemistry ◽  
Dimensional Analysis ◽  
Undergraduate Students ◽  
Microsoft Excel ◽  
Energy Unit ◽  
Spreadsheet Program ◽  
Volume Unit

We present a spreadsheet-assisted exercise using Microsoft Excel software for the<br>determination of the universal gas constant, R, in 35,712 different units. This large<br>number of units arises from a simple enumeration of possible pressure-volume unit<br>combinations and energy unit combinations covering SI (metric), Imperial (British), and<br>American units. In turn, various units for force and area used for defining pressure, and<br>various units for force and distance used for defining energy are explored. This<br>presentation serves as an excellent exercise for high school and undergraduate students to<br>master the skill of dimensional analysis, unit conversions, and basic combinatorics in<br>general chemistry and physical chemistry courses. Instructors can also use the described<br>exercise of constructing conversion matrices to train students in how to efficiently use the<br>Microsoft Excel spreadsheet program.

Cardiac Catheter Laboratory Based Computer Generated Bivalirudin/Glycoprotein IIb/IIIa Flow Sheet

2005 ◽  
Vol 40 (10) ◽  
pp. 882-889 ◽  
Author(s):  
Michael Zolnierz
Keyword(s):  
Creatinine Clearance ◽  
Flow Sheet ◽  
Percutaneous Coronary Interventions ◽  
Microsoft Excel ◽  
Spreadsheet Program ◽  
Cardiac Catheter ◽  
Pharmacy Department ◽  
Percutaneous Coronary ◽  
Specific Medication ◽  
Catheter Laboratory

Bivalirudin and glycoprotein IIb/IIIa antagonists are commonly used during percutaneous coronary interventions (PCI). The Pharmacy Department of Charlton Memorial Hospital implemented a dosing flow sheet that is operated by the Cardiac Catheter Lab nursing staff. The computer-oriented program utilizes the Microsoft Excel spreadsheet program. The computer spreadsheet calculates an estimated creatinine clearance (CrCl) rate and inserts proper renal adjusted dosages of both bivalirudin and glycoprotein IIb/IIIa antagonists into a printed flow sheet. The computer program is encoded to follow specific medication regimens for patients whether or not they are on dialysis. Institutions can develop medication dosing flow-sheet forms utilizing the spreadsheet concept.

scholarly journals PELATIHAN SPREADSHEET UNTUK MEDIA PEMBELAJARAN KREATIF DAN SOLUTIF BAGI SISWA SMA/MA DI KECAMATAN NARMADA

2019 ◽  
Vol 2 (2) ◽  
pp. 28
Author(s):  
Johri Sabaryati ◽  
M. Isnaini ◽  
Ni Wayan Sri Darmayanti ◽  
Linda Sekar Utami
Keyword(s):  
Microsoft Excel ◽  
Spreadsheet Program

Keterbatasan sarana dan prasarana laboratorium menjadi faktor penghambat untuk melakukan praktikum fisika. Padahal praktikum dapat membantu siswa dalam memahami konsep fisika. Sehingga untuk mengatasi kesulitan dalam mempelajari konsep fisika adalah dengan menggunakan media bantu pengajaran. Salah satunya menggunakan spreadsheet, program spreadsheet yang familiar untuk pengolahan data yaitu Microsoft excel karena menyajikan fasilitas secara sederhana, mudah dan tidak memerlukan instalasi secara khusus. Sehingga siswa dengan mudah dapat menggunakan fasilitas tersebut untuk memvisualkan berbagai model matematika. Tujuan dari pelatihan ini adalah (1) memberikan pelatihan aplikasi spreadsheet sebagi media pembelajaran kreatif dan solutif untuk lebih memahami konsep fisika karena terbatasan alat peraga, (2) meningkatkan kemampuan siswa dalam mengikuti perkembangan software simulasi yang ada saat ini. Pelaksanaan pelatihan secara teknis berjalan cukup lancar tanpa ada hambatan yang cukup berarti. Namun ada beberapa permasalahan yang timbul yakni masih ada peserta yang masih kurang mampu dalam menjalankan program spreadsheet. Sebagian peserta mengalami kesulitan dalam code penjalanan program selain ada beberapa tombol yang tidak mereka temukan dilayar MS.Excel.

Spreadsheet program for calculating secondary electron trajectories in electrostatic fields

1991 ◽  
Vol 49 ◽  
pp. 534-535
Author(s):  
Grady F. Bradley ◽  
David C. Joy
Keyword(s):  
Secondary Electron ◽  
Low Voltage ◽  
Microsoft Excel ◽  
Secondary Electrons ◽  
Spreadsheet Program ◽  
Electron Trajectories ◽  
Electrostatic Fields ◽  
Effective Use ◽  
Primary Electrons ◽  
Voltage Scanning

With the increasing importance of Low Voltage Scanning Electron Microscopy, the problem of describing the influence exerted by Secondary electron detectors on the path of primary electrons as well as its effects on the trajectories followed by secondary electrons become increasingly important. In situations where uncoated, insulating specimens are studied in an SEM, the additional problem of sample charging also has to be considered. Characterizing these interactions can be very difficult by conventional programming methods. The large number of points and the interdependence of the potentials at all of the points make the “bookkeeping” very difficult to manage. Spreadsheet programs with macroinstruction languages, however, can make these calculations much easier to perform. Not only can spreadsheets be used to calculate the potential field within a microscope column, macro programming can be used to calculate trajectories throughout that field. For the computations described in this paper, Microsoft Excel for the Macintosh was the spreadsheet chosen because of its effective use of the graphics capabilities of the Macintosh.

scholarly journals Understanding Reversible Molecular Binding

2017 ◽  
Vol 79 (9) ◽  
pp. 746-752 ◽  
Author(s):  
George P. Smith
Keyword(s):  
Cell Surface Receptor ◽  
Laboratory Model ◽  
Microsoft Excel ◽  
Spreadsheet Program ◽  
Reversible Binding ◽  
Biology Students ◽  
Molecular Binding ◽  
Natural Ligand ◽  
Surface Receptor ◽  
A Cell

Reversible binding between biomolecules—for example, between a cell-surface receptor such as the insulin receptor and its corresponding natural ligand such as insulin—is central to innumerable physiological transactions. Binding of the dye HABA to egg-white avidin is a simple, reliable, and colorful laboratory model for introducing beginning biology students to the principles underlying reversible binding. They can probe the reaction quantitatively with a spectrophotometer, and model it mathematically using only high-school algebra and a spreadsheet program such as Microsoft Excel.

An Exact and Simple Approach to log-log Plots for Defect and Ionic Equilibria

1997 ◽  
Vol 52 (8-9) ◽  
pp. 629-636
Author(s):  
Giorgio Spinolo ◽  
Umberto Anselmi-Tamburini ◽  
Paolo Ghigna
Keyword(s):  
Traditional Approach ◽  
Functional Dependence ◽  
Total Concentration ◽  
Free Ligand ◽  
Spreadsheet Program ◽  
Thermodynamic Variable ◽  
Defect Equilibria ◽  
Simple Oxide ◽  
Ionic Equilibria ◽  
Alternative Approach

Abstract An alternative approach to log-log plots for defect equilibria in the solid state and ionic equilibria in solution is presented. The method is based on the strictly monotone character of the functional dependence of an externally controlled thermodynamic variable (e.g. the oxygen partial pressure P(O2) for the defect equilibria in a simple oxide, or a total concentration for the ionic equilibria in solution) on a chemically relevant compositional variable (such as the electron concentration n for defect equilibria, or [H3O+] or a free ligand concentration for solution equilibria). This functional dependency can be safely inverted. The concentration of all species and the externally controlled thermodynamic variable can be calculated as a function of the chemically relevant compositional variable. The appropriate plots are then obtained using naively a spreadsheet program. This method gives exact results in many more cases than the traditional approach.

Spread Sheet Model of Continuous Casting

1996 ◽  
Vol 118 (1) ◽  
pp. 37-44 ◽  
Author(s):  
B. G. Thomas ◽  
B. Ho
Keyword(s):  
Continuous Casting ◽  
Programming Languages ◽  
Casting Process ◽  
Transfer Model ◽  
Continuous Casting Mold ◽  
Microsoft Excel ◽  
Spreadsheet Program ◽  
Model Predictions ◽  
Engineering Models ◽  
Spread Sheet

Spreadsheet programs, such as Microsoft Excel, Informix WINGZ, and Lotus 123, provide a framework for very fast and easy development of simple engineering models. The present paper describes a model of the continuous casting process that has been developed using a spreadsheet program, Microsoft Excel, running on a Macintosh II personal computer. The model consists of two-dimensional (2-D) steady-state finite-difference heat conduction calculations within a continuous casting mold coupled to a one-dimensional (1-D) transient solidification heat transfer model of the solidifying shell. The model structure and equations are described and the model predictions are compared with previous solutions. Practical examples using the model are discussed and sample results are provided. Spreadsheet programs running on personal computers are capable of relatively complex calculations that would require extensive effort using conventional programming languages.

scholarly journals The Peer Reviews and the Programming Course

10.28945/2859 ◽  
2005 ◽  
Author(s):  
Grandon Gill
Keyword(s):  
Peer Review ◽  
Computer Programming ◽  
Course Design ◽  
Teaching Skill ◽  
Traditional Lecture ◽  
Peer Reviews ◽  
Research Journal ◽  
Alternative Approach ◽  
Approach To Teaching ◽  
Initial Results

What would happen if a typical computer programming course were submitted for peer review by a research journal? Using a format inspired by typical peer reviews, issues relating to rigor, relevance and course design are raised. In these fictional reviews, weaknesses of the traditional “lecture and test” approach to teaching are identified in all three areas and it is argued that such weaknesses may be inherent to that design—particularly in teaching skill based courses. An alternative approach, whose inspiration is the techniques employed in U.S. submarine qualification, is the proposed and some initial results of teaching such a course are presented.

scholarly journals Teaching the Principles of Landscape Bidding with an Electronic Spreadsheet

HortScience ◽  
1990 ◽  
Vol 25 (10) ◽  
pp. 1299-1301
Author(s):  
David J. Beattie ◽  
Lawrence C. Ragan
Keyword(s):  
Indirect Costs ◽  
Thinking Skills ◽  
Labor Costs ◽  
Microsoft Excel ◽  
Spreadsheet Program ◽  
Higher Order Thinking Skills ◽  
Apple Macintosh Computer ◽  
Cost Of Materials ◽  
Electronic Spreadsheet ◽  
The Relationship

An interactive spreadsheet program was developed to demonstrate how a landscape bid is estimated. Information from a profit and loss statement, entered periodically, is retained for succeeding bids. Machine and labor costs are determined separately. For an individual bid, inputs include cost of materials, overhead, labor and machine times, contingency, and profit. Labor costs are automatically modified to reflect crew efficiency, and materials costs reflect storage, freight, and other charges. Overhead is based on the relationship between annual direct and indirect costs. The calculations section displays intermediate steps of the final bid estimate. Summaries from calculations include a final bid estimate. A printing option allows the user to selectively print any of the sections, a customer's copy, or the entire bid. The program uses an Apple Macintosh computer, was written for Microsoft Excel software, and uses macro programs. Its concept can be adapted to any electronic spreadsheet and can be protected to allow entry of only certain input data. The program can be used for small landscape businesses, classroom instruction, and/or extension instruction in which higher-order thinking skills are emphasized.

Technology Tips: Spreadsheets: Powerful Tools for Probability Simulations

1997 ◽  
Vol 90 (7) ◽  
pp. 572-579
Author(s):  
Edwin McClintock ◽  
Zhonghong Jiang
Keyword(s):  
High School ◽  
High School Students ◽  
Complex Problem ◽  
School Students ◽  
Microsoft Excel ◽  
Spreadsheet Program ◽  
Evaluation Standards ◽  
Problem Situations ◽  
Formal Concepts ◽  
Preservice Mathematics Teachers

The Curriculum and Evaluation Standards for School Mathematics (NCTM 1989) recommends that high school students extend their K-8 experiences with simulations and experimental probability to continue to improve their intuition and build more formal concepts of theoretical probability based on these experiences. In keeping with this idea, we use spreadsheets frequently in studying and investigating probabilistic situations with both high school students and preservice mathematics teachers. Our approach includes simulations but goes beyond the simulation process as a way of learning important concepts and principles of probability. We have found that spreadsheets are a very powerful tool for simulating probabilistic situations, not only for simple problems, such as simulating coin Ripping and die tossing, but also for rather complex problem situations. In this article, we illustrate the use of spreadsheets as a simulation tool for solving a collection of probability problems. The spreadsheet program we use is Microsoft Excel (1995), but other spreadsheet programs, such as Quattro Pro (Borland 1994), can be used with the same degree of effectiveness.

Sign in / Sign up

Export Citation Format

Share Document