A Master Class in Dimensional Analysis: the Universal Gas Constant

Author(s):  
john andraos

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.

2018 ◽  
Author(s):  
john andraos

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.


2014 ◽  
Vol 15 (3) ◽  
pp. 297-310 ◽  
Author(s):  
Vered Dangur ◽  
Shirly Avargil ◽  
Uri Peskin ◽  
Yehudit Judy Dori

Most undergraduate chemistry courses and a few high school honors courses, which focus on physical chemistry and quantum mechanics, are highly mathematically-oriented. At the Technion, Israel Institute of Technology, we developed a new module for high school students, titledChemistry – From “the Hole” to “the Whole”: From the Nanoscale to Microelectronics. The module is based on a qualitative approach to teaching quantum chemistry, emphasizing interdisciplinary real-life applications and integration of visualization. While aimed at honors high school chemistry students, the module was also partially implemented and assessed in an undergraduate chemistry course. The research objective was to investigate the effect of the module on the visual and textual understanding of quantum mechanical concepts among 122 honors and 65 volunteer undergraduate chemistry students. The research tools included students' pre- and post-questionnaires. High school honors and undergraduate students, who were exposed to the module, significantly improved their textual and visual understanding of quantum mechanical concepts and their ability to move across illustrations and explanations. Honors and undergraduate students minimized the gap that had existed between them in terms of integrating micro and quantum levels into their post-questionnaire answers. Our findings augment the current set of the four chemistry understanding levels – macro, micro, symbol and process – by adding the quantum mechanical level as a fifth level of chemistry understanding. The study contributes to teaching physical chemistry by providing a tool for learning, assessment, and research of chemistry understandingviaboth visual and textual modes.


A Biology and Chemistry Primer for Undergraduate Students (ABACUS-1) is a project that has so far developed a General Chemistry Primer which introduces basic chemistry concepts and integrated relevant practical experiments to allow a refresher for Undergraduate students and enhance better performance in science related courses regardless of pre-university subjects studied. Data on applicants’ education background, enrolment and performance was obtained from the Uganda Christian University Faculty of Science and Technology and Admissions Office. Chemistry experts developed ten chapters of the Primer that was made available to students as a reference text. Feedback was obtained in a structured Knowledge, Attitude and Practice survey. Continuous performance tracking was done on tests and exams of students with whom the Primer was piloted. Data was analysed using SPSS and Microsoft Excel 2010. In the 2013/14 Bachelor of Environmental Science (BES) cohort, 3 out of 15 students had sat for Advanced Level Chemistry, 53 % of the students in this program scored below 70% in General Chemistry course unit and all scored above 65% in Environmental Chemistry I before piloting the Primer. After piloting the Primer, 80% of the students in BES program that did not sit for Advanced Level Chemistry scored above 65% in Environmental Chemistry II. In the 2013/14 Bachelor of Science in Civil and Environmental Engineering (BSCEE) cohort, 26 out of 74 students had sat for Advanced Level Chemistry, 81% of these scored above 71% in Environmental Chemistry I and 4 students who scored below 65% did not sit for Advanced Level Chemistry. After piloting the Primer, 74 % of the students in the BSCEE program who did not sit for Advanced Level Chemistry scored above 65%. The Primer could have increased the confidence of the students who did not sit for Advanced Level Chemistry thus boosting students’ education and training.


2018 ◽  
Vol 1 (1) ◽  
Author(s):  
Laura Pavelka ◽  
Avik Ghoshdastidar ◽  
Mitchell J. Huot ◽  
Ian S. Butler

AbstractThe post-secondary education system in the Province de Québec is quite different from that in the rest of Canada and in many other countries throughout the world. The introduction of a 2-year Collèges d’enseignement général et professionnel (CEGEP) program in 1967 has led to a reduction in the number of years that Quebec students have to spend in both high school and at university. The CEGEP program combines the last year of high school with the first year of a traditional 4-year university program meaning that students living in Quebec must do a 3-year undergraduate degree at the universities, while all other students must do a 4-year degree. Moreover, since almost 50 % of 27 000 undergraduate students at McGill come from other parts of Canada and internationally, this has led to enrolments of about 1000 students in the basic science courses. We present here an overview of how the introductory General Chemistry courses at McGill University are currently being handled so that the students have a meaningful first-year experience.


1997 ◽  
Vol 90 (7) ◽  
pp. 572-579
Author(s):  
Edwin McClintock ◽  
Zhonghong Jiang

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.


Teknologi ◽  
2020 ◽  
Vol 10 (2) ◽  
pp. 85-92
Author(s):  
Syafi’ul Hamidani ◽  
◽  
Veradilla Amalia ◽  

STMIK Bina Nusantara Jaya as one of the universities in the city of Lubuklinggau, South Sumatra, which provides scholarships for Al-Qur'an hafiz in that city to take full courses. Currently, the process of determining prospective scholarship recipients is still using a computer application, namely Microsoft Excel. With the large number of applicants who registered, the limited human resources who handled the determination of the recipients of this scholarship, and the very limited quota, it made it difficult for STMIK Bina Nusantara Jaya to determine better priorities for prospective students who received the hafiz Al-quran scholarship. For this reason, this study is intended to assist the STMIK Bina Nusantara Jaya in selecting students who receive the hafiz Al-qur'an scholarship based on 4 criteria, namely memorizing the Al-qur'an, high school academic scores, the work of parents and dependents of the parents, from these criteria. the calculation will be carried out using the Simple Multi Attribute Rating Technique (SMART) method. This method was chosen because of its simplicity of calculation and ease of finding the best alternative by assigning a weighting value from 0 to 100 in the criteria so as to simplify the calculation process to obtain the best alternative. This study resulted in recommendations for determining prospective scholarship recipients by 80%.


2021 ◽  
Vol 6 (3) ◽  
pp. 243-250
Author(s):  
Nayang Helmayunita ◽  
Ade Elsa Betavia ◽  
Dovi Septiari ◽  
Sany Dwita

Based on interviews conducted with the Head of the Vocational High School Management and Business Vocational High School Subject Teacher Conference in West Sumatra Province, it was found that teachers need to improve their competence about the use of Computer Accounting Applications. It is known that teachers still lack competence, and teachers are still unfamiliar with how to operate various menus and functions that can be used in a spreadsheet program to complete company financial reports. Based on this condition, the teaching and learning process for subjects has been done more with the lecture method and a little practice. So that this affects the competence of SMK graduates. In fact, the guidance for the world of work requires SMK graduates to operate this application program properly. The community's activity was carried out for two days on 18 and 19 September 2020 at SMKN 2 Kota Padang. The implementation is carried out in three stages, namely material presentation, integrated training, and evaluation. At the end of the activity, it was known that there was an increase in the understanding of the participants regarding the preparation of financial statements of trading companies using Microsoft Excel with a case settlement value that could be achieved was 85.71%. Furthermore, this increase in teacher competence is expected to be transferred to students and is reflected in the value of UKK and the acceptance of graduates in the world of work.


1998 ◽  
Vol 63 (7) ◽  
pp. 955-966
Author(s):  
Eva Přibylová ◽  
Miroslav Holík

Four programs for the 1H NMR line shape analysis: two commercial - Winkubo (Bruker) and DNMR5 (QCPE 165) and two written in our laboratory - Newton (in Microsoft Excel) and Simtex (in Matlab) have been tested in order to get highly accurate rate constants of the hindered rotation about a single bond. For this purpose four testing criteria were used, two of them were also developed by us. As supplementary determinations the rate constants obtained for the coalescence temperature and for the thermal racemization of chromatographically separated enantiomers were used which fitted well the temperature dependence of the rate constants determined by the line shape analysis. As a test compound adamantan-1-yl 3-bromo-2,4,6-trimethylphenyl ketone was prepared and studied. It was shown that supermodified simplex method used in our algorithm (Simtex), though time consuming, gives the most accurate values of the rate constants and consequently the calculated thermodynamic parameters Ea, ∆H≠, and ∆S≠ lay in relatively narrow confidence intervals.


2017 ◽  
Vol 10 (8) ◽  
pp. 40 ◽  
Author(s):  
Saeed Abdullah AL-Dossary

Cheating on tests is a serious problem in education. The purpose of this study was to test the efficacy of a modified form of the theory of planned behavior (TPB) to predict cheating behavior among a sample of Saudi university students. This study also sought to test the influence of cheating in high school on cheating in college within the framework of the TPB. Analyses were conducted on a sample of 322 undergraduate students using structural equation modeling. The results were consistent with the TPB model’s predictions. The TPB model explained a modest variance in cheating in college. When cheating in high school added to the model, the proportion of explained variance increased and cheating in high school was the best predictor of cheating in college. Although not hypothesized by the TPB, subjective norm had a direct effect on attitude.


Sign in / Sign up

Export Citation Format

Share Document