Technology Tips: Two Useful Functions for Excel Grade Books

2006 ◽  
Vol 99 (8) ◽  
pp. 566-569
Keyword(s):  
Community College ◽  
Programming Language ◽  
Visual Basic ◽  
Daily Basis ◽  
Microsoft Excel ◽  
The Third ◽  
Administrative Tasks ◽  
Quiz Scores

Do you often think there must be a more effective way to accomplish some of the administrative tasks you complete on a daily basis, such as dropping the two lowest quiz scores in your grade book, making a calendar of assignments, or creating a grading rubric for a project? This month's “Technology Tips” provides you with some useful shortcuts. Glen Lobo, from Sinclair Community College, Dayton, Ohio, shares two Microsoft Excel macros from his personal grade book. The first two tips show how to record and edit a macro in Excel, while the third tip illustrates how to create a macro using Visual Basic programming language. This month's “Surfing Note” lists useful online administrative resources that can be used in your classroom.—Eds.

scholarly journals Software Design using Visual Basic for Application and Microsoft Excel Programming for Students

2020 ◽  
Vol 1 (2) ◽  
pp. 86-97
Author(s):  
Fadillah Ramadhan ◽  
Hendang Setyo Rukmi ◽  
Arif Imran ◽  
Cahyadi Nugraha ◽  
Risdan Ferdiansyah
Keyword(s):  
Programming Languages ◽  
Programming Language ◽  
Software Design ◽  
Rapid Development ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Post Test ◽  
Design Software ◽  
Learning Programming ◽  
Visual Basic For Application

The rapid development of information technology has made people to have the ability to design software with a programming language. There are quite some engineers who have not mastered programming languages. It happens becausesome people think that developing software with a certain programming language is very difficult. The language is difficult to understand, the accuracy must be precise, and the user is not familiar with the platform. Difficulty in learning programming languages is a problem that is often encountered by university students, vocational students, or employees. This article describes an easy programming language training activity for beginners, namelyVisual Basic for Applications (VBA)-Ms. Excel training.The advantage of this programming language iseasy to operate because manystudentsor employees are very familiar with Ms. Excel so that the adaptation process will be easy. The results of the post-test training that was attended bystudents showed a significant increase in the ability to design programming languages.

APLIKASI AKUNTANSI PENATAUSAHAAN KEUANGAN DESA MENGGUNAKAN FRAMEWORK CODEIGNITER

2018 ◽  
Vol 4 (1) ◽  
Author(s):  
Yati Nurhayati
Keyword(s):  
Programming Language ◽  
Human Error ◽  
Financial Data ◽  
Microsoft Excel ◽  
Financial Administration ◽  
The Village

AbstrakDesa sebagai salah satu bagian dari pemerintahan yang memiliki anggaran besar melalui APBDes untuk peningkatan infrastruktur desa dan kesejahteraan masyarakatnya. Maka desa wajib melakukan pengelolaan keuangan dan pencatatan keuangan (penatausahaan) secara akurat dan detail. Salah satu desa yang memiliki APBDes besar adalah Desa Ciputat. Dalam penatausahaan atau pencatatan keuangan masih dilakukan secara semi manual (Microsoft excel) sehingga banyak kelemahan yaitu besarnya kemungkinan human error dan ketidak seimbangan (balance) keuangan dikarenakan banyaknya format yang harus dibuat dalam beberapa lembar kerja. Sehingga dibutuhkan sebuah aplikasi yang dapat mengelola data keuangan secara cepat dan akurat. Aplikasi ini dirancang menggunakan UML, sedangkan system dikembangkan menggunakan metode RAD. Hasil perancangan diterapkan ke dalam Bahasa pemrograman PHP dan MySQL menggunakan framework CodeIgniter. Hasil akhir dari penelitian ini adalah sebuah aplikasi akuntansi penatausahaan (pencatatan) keuangan di desa dan menghasilkan laporan dalam bentuk Buku Kas Umum dan Buku Pembantu Kegiatan.�Kata Kunci�Desa, Keuangan, Penatausahaan, RAD, PHP, MySQL,CodeIgniter, Akuntansi., Buku Kas Umum, Buku Pembantu Kegiatan�AbstractVillage as a part of government has big estimation through APBDesa for increasing villages infrastructure and prosperity for the citizens. Therefore, the village should do managing financial and registration financial (administration) accurately and detail. One of villages that has a big APBDesa is Ciputat Village. In administration or registration financia, it still conductes semi-manual (Microsoft excel) so there are many weakness such as big posibility of human error and un-balance of financial caused many kind of format that should be produced in several sheets. So, it needs an application that can manage financial data accurately and fast. This application is designed by using UML, while the system is developed by using RAD methodology. And results are implemented into PHP Programming Language and MySQL by using framework CodeIgniter. Last Results of this research is an accounting application of Financial Administration (registration) in village and produce report in General Ledger form and subsidiary ledger form.Keywords� Village, Financial, Administration, RAD, PHP, MySQL, CodeIgniter, Accounting., General Ledger, Subsidiary Ledger

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

Research on Mechanical Product Development Based on CAD Software

2014 ◽  
Vol 484-485 ◽  
pp. 933-937
Author(s):  
Fu Na Li ◽  
Lin Wei Yang ◽  
Ying Zeng
Keyword(s):  
Programming Language ◽  
Interface Design ◽  
Development Process ◽  
Visual Basic ◽  
Common Language ◽  
Test Results ◽  
Technology Application ◽  
Development System ◽  
Design And Implementation ◽  
Software Interface

This paper introduces analysis the development process of CAD technology, application of the AutoCAD software in engineering field and teaching as well as the significance of the development of two times the. This paper analyzes in detail the development of common language, and the use of Visual BASIC development and application of software based on AutoCAD. The author elaborates the software interface design and method calls AutoCAD in VB. Finally, the design and implementation of a programming language re-development system based on AutoCAD is concerned. The test results show that the developed AutoCAD two development system has good practical value.

Design of a Total Revenue Forecasting Tool to Estimate the Economic Output of Hardwood Logs

2020 ◽  
Vol 70 (4) ◽  
pp. 439-447
Author(s):  
Juan J. González ◽  
Henry Quesada ◽  
Sailesh Adhikari ◽  
Brian Bond ◽  
Shawn Grushecky
Keyword(s):  
Probability Distributions ◽  
Visual Basic ◽  
Total Revenue ◽  
Total Income ◽  
Microsoft Excel ◽  
Economic Output ◽  
Revenue Forecasting ◽  
Simple Tool ◽  
Hardwood Lumber ◽  
Volume Output

Abstract This article introduces a total revenue forecasting tool designed for calculating the economic output of visually graded hardwood lumber. The tool integrates Monte Carlo simulation from previous studies' data, providing a pseudoestimation of total board-feet based on log grades. The lumber output from different log groups is modeled using probability distributions for each lumber grade. The estimated volume output is multiplied by the respective price for each grade, leading to an expected amount of economic output for given log-grades. The tool was implemented using Microsoft Excel 2016 and Visual Basic. This work provides hardwood lumber producers with a valuable and simple tool to determine different scenarios of total income from each log, as established by the user with a statistical perspective. This total revenue forecasting tool provides the industry with a way to reduce waste and estimate their potential revenue by maximizing the interaction between the log yield's variables and providing the economic output of log, leading to an improvement of the economy of the hardwood market.

P28 Reducing medication errors – a tripartite approach. small steps – better outcomes

2018 ◽  
Vol 103 (2) ◽  
pp. e1.33-e1
Author(s):  
Patel Bhavee ◽  
Isaac Rachel ◽  
Vallabhaneni Pramodh
Keyword(s):  
Medication Errors ◽  
Improve Patient Safety ◽  
Medication Administration ◽  
Daily Basis ◽  
Junior Doctors ◽  
Health Board ◽  
Final Report ◽  
List Type ◽  
Microsoft Excel ◽  
Audit Form

AimPaediatric medication errors have everyday potential to cause unintended harm.1 Our aim was to reduce paediatric medication errors on a busy general paediatric medical ward.MethodA prospective audit was undertaken, using an audit form, looking at the number and severity of medication errors from May 2016 to July 2016. The severity of the errors was graded as per the EQUIP study.2 The results were analysed using Microsoft Excel.Action – A study afternoon was arranged in August 2016 to highlight the common themes behind the medication errors followed by a multidisciplinary brainstorming exercise to gather suggestions on reducing medication errors.An education package was introduced:Medical – all trainees were asked to complete a mandatory online module designed by the Royal College of Paediatrics and Child Health, which provides an overview of need for safe prescription practice in children and common themes leading to errors. Further teaching was provided in departmental teaching meetings and the lead paediatric pharmacist undertook targeted teaching.Nursing – an in house competency package was developed based around the principles of the ‘5 rights’ of medication administration, the Health Board controlled drug policy and the All Wales Policy for Medicines Administration, Recording, Review, Storage and Disposal. All staff were encouraged to complete this package. Through one on one sessions with the practice development nurse, staff were coached to follow the five Rs of Right Drug, Right Dose, Right Time, Right Route, and Right Patient.Pharmacy – Lead pharmacist introduced an education tool as advocated by Meds IQ called Druggle3 in the department, where at the end of the safety huddle the pharmacist discusses medication interventions on a daily basis that may have happened on the ward. Through this tool formative education was provided to junior doctors and nurses.Re–audit – After six months of intensive education, a prospective re–audit was undertaken between December 2016 and February 2017 using an audit form. The results were analysed using Microsoft Excel.ResultsThe results showed that 88.6% (141/159) of children admitted had medication errors. 61.2% (87/141) of errors were minor, 34.7% (49/141) significant, 2.8% (4/141) serious and 1.3% (1/141) potentially lethal.The results of the re-audit showed that 12.1% (57/470) of children had medication errors. 77.2% (44/57) of errors were minor and 22.8% (13/57) significant. There were no serious or potentially lethal errors reported.This showed an overall reduction of 76.5% medication errors in the children admitted following the introduction of the education package.ConclusionThe education package through the tripartite approach has achieved a substantial change in the overall rate of prescription errors. We believe medication errors are a significant but preventable cause of harm to children and young people. To ensure this change of practice is sustained we aim to continue the emphasis of education and change management to improve patient safety.ReferencesCass H. Reducing paediatric medication error through quality improvement networks; where evidence meets pragmatism. Arch Dis Child2016;101:414–416.EQUIP final report. http://www.gmc-uk.org/FINAL_Report_prevalence_and_causes_of_prescribing_errors.pdf_28935150.pdf [Accessed: 01/08/16].DRUG-gle (Druggle). http://www.medsiq.org/tool/drug-gle-druggle [Accessed: 01/08/2016].

scholarly journals OPTIMALISASI JUMLAH KENDARAAN DAN RUTE DISTRIBUSI LOGISTIK PEMILIHAN DI KABUPATEN KEDIRI PADA MASA PANDEMI

2021 ◽  
Vol 3 (1) ◽  
pp. 1-25
Author(s):  
Eka Wisnu Wardhana ◽  
Oki Anita Candra Dewi
Keyword(s):  
Vehicle Routing ◽  
Vehicle Routing Problem ◽  
Nearest Neighbor ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Google Maps ◽  
Routing Problem ◽  
Visual Basic Application

Artikel ini membahas tentang permasalahan distribusi logistik pemilihan kepala daerah (Pemilihan) yang berkaitan dengan penentuan jumlah kendaraan yang tepat dan pemilihan rute terdekat dengan mempertimbangkan jarak yang dapat dilalui oleh kendaraan roda 4 atau lebih. Penentuan jumlah kendaraan dan rute yang tepat ini sangat penting bagi Komisi Pemilihan Umum (KPU) karena aspek logistik dan distribusi sangat berpengaruh dalam memastikan suara masyarakat tersampaikan dengan baik. Selain itu aspek ini memiliki keterkaitan satu dengan lainnya baik bersifat strategis maupun teknis. Selama pandemi, distribusi logistik Pemilihan tidak hanya berkaitan dengan kebutuhan alat pemungutan suara namun juga alat pelindung diri (APD) selama pelaksanaan pemungutan. Oleh karena itu kegiatan logistik menjadi lebih banyak dengan tetap mempertimbangkan protokol kesehatan sehingga diperlukan sebuah aplikasi yang dapat menentukan jumlah kendaraan dan rute yang tepat sebagai dasar untuk mempercepat pengambilan keputusan. Penelitian ini fokus pada penentuan jumlah kendaraan dan rute distribusi logistik yang optimal pada Pemilihan tahun 2020 di masa pandemic COVID-19 di KPU Kabupaten Kediri menggunakan pendekatan vehicle routing problem dengan memperhatikan jarak dari google maps serta menggunakan algoritma nearest neighbor dalam menentukan jarak terdekat antar titik. Aplikasi yang dikembangkan adalah penentuan rute menggunakan Visual Basic Application (VBA) pada Microsoft Excel. Penelitian ini menghasilkan jumlah kendaraan sebanyak 12 kendaraan untuk pengiriman logistik Pemilihan maupun APD dengan batas maksimal total perjalanan setiap truk sepanjang 100 km. Selain itu terdapat 6 kecamatan yang dikunjungi dua kali karena total kebutuhan melebihi kapasitas kendaraan.

scholarly journals Constructing Student’s Mathematical Understanding Skills and Self Confidence: Math Game with Visual Basic Application for Microsoft Excel in Learning Phytagoras at Junior High School

2018 ◽  
Vol 7 (3.2) ◽  
pp. 732 ◽  
Author(s):  
Martin Bernard ◽  
Eva Dwi Minarti ◽  
Masta Hutajulu
Keyword(s):  
High School ◽  
High School Students ◽  
Junior High School ◽  
Junior High ◽  
Visual Basic ◽  
Process Data ◽  
School Students ◽  
Microsoft Excel ◽  
Mathematical Concepts ◽  
Visual Basic Application

Learning media in Mathematics by using Microsoft Excel software that assisted Visual Basic application is a tool that can be applied for a more interactive visualization so that students better understand about mathematical concepts. Microsoft Excel is a software that serves to process data in the form of numbers that are always associated with mathematical commands. In addition, the functions of commands in Microsoft Excel can be applied in various fields such as Statistics, Economics and Finance, Mathematical Logic, and Engineering. If using mathematical concepts with data processing. But it is not just a number, it can also be used to process objects on shapes or drawings on images. This, of course, requires a function other than the mathematical functions of Visual Basic Applications, which can make math tools more interesting. The advantages of Microsoft Excel with Visual Basic for Application (VBA) are (1) the images are more interactive with different sizes and can make more; (2) more economical; (3)saving time; (4)the software is easy to find, and (5)improving students 'understanding of mathematical concepts and foster students' sense of trust, especially in junior high school students.  

Using Spreadsheet Modules to Augment the Design of Adhesive Lap Joints

2007 ◽  
Author(s):  
Terry E. Shoup ◽  
Michael Drew
Keyword(s):  
Numerical Algorithms ◽  
Visual Basic ◽  
Lap Joints ◽  
Adhesive Joints ◽  
Geometric Configuration ◽  
Lap Joint ◽  
Microsoft Excel ◽  
Traditional Design ◽  
Adhesive Type ◽  
Selection Of

This paper presents two easy-to-use spreadsheet modules in Microsoft Excel to assist with the design of adhesive joints. The modules make use of embedded Visual Basic numerical algorithms to give assistance with the selection of both the adhesive type and the geometric configuration of an adhesive lap joint. These modules facilitate the quick implementation of designs that are more accurate than was previously possible by traditional design methods. The method will be particularly helpful to students and inexperienced designers who first encounter the need to design adhesive joints. The paper also includes an example application to illustrate the use of the modules.

Sign in / Sign up

Export Citation Format

Share Document