Relevant bibliographies by topics / Excel VBA / Journal articles
To see the other types of publications on this topic, follow the link: Excel VBA.

Journal articles on the topic 'Excel VBA'

Author: Grafiati
Published: 4 June 2021
Last updated: 13 June 2025

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Consult the top 50 journal articles for your research on the topic 'Excel VBA.'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.

1

BABA, Alexandru. "Sending data from excel to autocad." University of Pitesti. Scientific Bulletin - Automotive Series 30, no. 1 (2020): 1–6. http://dx.doi.org/10.26825/bup.ar.2020.003.

Full text
Abstract:
The interaction between Excel and AutoCad using VBA is useful for all engineers who use AutoCad, so in this article I want to show that using VBA in Excel candraw objects in AutoCad. Therefore, by programming in VBA from Excel, you can launch AutoCAD and with the help of a spreadsheet application we transmit the data in AutoCAD to draw objects
APA, Harvard, Vancouver, ISO, and other styles
2

Du, Rui Qing, Jing Qin Mu, Xiao Hui Li, and Xue Long Zhang. "Design and Implementation of Excel VBA-Based Combination Charts in Analyzing Mineral Resources Data." Applied Mechanics and Materials 687-691 (November 2014): 1518–21. http://dx.doi.org/10.4028/www.scientific.net/amm.687-691.1518.

Full text
Abstract:
In Mineral resource economics, a large amount of data stored in Excel files usually need to be shown in various charts for analyzing. Excel VBA provides a fast and easy way to create charts. This paper illustrates how to create batched combination charts of several mineral resources and their annual increments based on Excel VBA. Every step of creating process is illustrated in details and the Excel VBA codes are analyzed carefully. And the resulting combination charts are displayed to emphasize the different chart types and to prove the effectiveness of Excel VBA.
APA, Harvard, Vancouver, ISO, and other styles
3

Fabulya, Zoltán. "Hőkezelési folyamatok összehangolása Excel VBA szolgáltatásokkal." Jelenkori Társadalmi és Gazdasági Folyamatok 12, no. 4 (2017): 19–25. http://dx.doi.org/10.14232/jtgf.2017.4.19-25.

Full text
Abstract:
Konzervek hőkezelési folyamatainak összehangolása során az egyes folyamatok kezdési időpontjának késleltetésével elkerülhetjük a gőz-, és a vízfelhasználási csúcsokat. Az Excel Visual Basic for Application szolgáltatása megfelelő keretet biztosít arra, hogy felhasználóbarát kezelőfelületet alakítsunk ki, mellyel akár egy egyedi felhasználói program megjelenését és kezelésének kényelmét biztosíthatjuk. így az informatikában járatlanok is könnyen használható, programként működő alkalmazással dolgozhatnak. Parancsgombokra klikkelve hangolhatjuk össze a párhuzamosan zajló folyamatokat, miközben diagramokon követhetjük a gőz-, és vízfelhasználás alakulását.
APA, Harvard, Vancouver, ISO, and other styles
4

Hampel, György. "Páros t-próba programozható kialakítása Excel VBA környezetben." Jelenkori Társadalmi és Gazdasági Folyamatok 14, no. 1 (2019): 53–59. http://dx.doi.org/10.14232/jtgf.2019.1.53-59.

Full text
Abstract:
Az Excel táblázatkezelő programmal olyan számolótáblákat tudunk kialakítani, melyeket többször is használhatunk. Egy-egy adat megváltozásakor automatikusan újraszámítódik a teljes tábla. Az adatok megváltoztatását programozott módon is elvégezhetjük a Visual Basic for Application (VBA) szolgáltatás segítségével. Összetett számítások esetén célszerű arra törekedni, hogy a kialakított számolótábla egyszerűen tegye lehetővé a paraméterek értékétől függő eredmények képzését.Jelen publikáció a páros t-próba automatizált végrehajtása kialakításának egy lehetséges módját tárgyalja. Statisztikai programok nem teszik lehetővé a programozással automatizált kiértékeléseket, ezért az Excel VBA alkalmazása jelentősen felgyorsítja az ismételten elvégzendő számítások előkészítését és végrehajtását. A cikkben bemutatom egy könnyen és kényelmesen használható kezelőfelület elkészítését, valamint a hozzá tartozó VBA programokat.
APA, Harvard, Vancouver, ISO, and other styles
5

Shoji, Tetsuya. "Calculation of Variograms by MS-Excel/VBA." GEOINFORMATICS 13, no. 1 (2002): 9–21. http://dx.doi.org/10.6010/geoinformatics.13.9.

Full text
APA, Harvard, Vancouver, ISO, and other styles
6

SHIMURA, Toshiaki, and Moeru KOJIMA. "Point Count Application by MS-Excel VBA." Geoinformatics 26, no. 1 (2015): 15–20. http://dx.doi.org/10.6010/geoinformatics.26.1_15.

Full text
APA, Harvard, Vancouver, ISO, and other styles
7

Sorg, Mascha. "Excel im Finanzwesen und Makroprogrammierung mit VBA." Controlling & Management 50, no. 3 (2006): 136–37. http://dx.doi.org/10.1365/s12176-006-0525-z.

Full text
APA, Harvard, Vancouver, ISO, and other styles
8

Ruqoyyah, Siti, Sukma Murni, and Tommy Tanu Wijaya. "The Effect of VBA for Microsoft Excel as Teaching Material to Improve Prospective Elementary School Teachers' Mathematical Conceptual Understanding." Mimbar Sekolah Dasar 7, no. 2 (2020): 251–68. http://dx.doi.org/10.17509/mimbar-sd.v7i2.26494.

Full text
Abstract:
This research is motivated by the low ability to understand mathematical concepts possessed by prospective elementary school teacher students. This study aims to see the achievement and improvement of students' mathematical understanding abilities that use Microsoft Excel-based VBA teaching materials with those using conventional learning. This study uses a quasi-experimental method with a non-equivalent pre-test and post-test control group design. This study's population were all second-semester elementary school teacher candidates in one private university in West Java, Indonesia. The sample in this study was 70 prospective 2nd-grade elementary school teacher candidates. The instrument used in this study was a test of understanding mathematical concepts. The results showed: 1) learning using VBA Microsoft Excel as a teaching material was able to improve students' ability to understand mathematical concepts; 2) learning using Microsoft Excel VBA as teaching material is better than conventional learning; and 3) students can be enthusiastic, active and motivated in learning mathematics with VBA Microsoft Excel.
APA, Harvard, Vancouver, ISO, and other styles
9

Zhao, Ming Bo. "Influence Line Analysis of the Plane Trusses Based on EXCEL." Applied Mechanics and Materials 166-169 (May 2012): 927–30. http://dx.doi.org/10.4028/www.scientific.net/amm.166-169.927.

Full text
Abstract:
The purpose of this paper is to investigate the application of Excel software in the constructing and plotting of influence lines in plane trusses. Obtaining the influence coefficient of the plane trusses with Excel, the influence lines in the plane trusses were constructed and plotted via VBA Functions in Excel. The research outcome of this paper is expected to be helpful to engineering practice, teaching and research work. Key words: EXCEL；plane trusses；influence line；VBA
APA, Harvard, Vancouver, ISO, and other styles
10

Hampel, György. "Egymintás t-próba programozható kialakítása Excel VBA környezetben." Jelenkori Társadalmi és Gazdasági Folyamatok 13, no. 3-4 (2018): 169–75. http://dx.doi.org/10.14232/jtgf.2018.3-4.169-175.

Full text
Abstract:
Az Excel számolótáblák egyszerűen használható lehetőséget biztosítanak számítások elvégzésére, s mindezt úgy, hogy adatváltozás esetén automatikus újraszámítás történik. Ezt kihasználva elegendő csak egyszer kialakítani a számolótáblát, melyet így újból felhasználhatunk más bemenő adatok esetén. A Visual Basic for Application (VBA) szolgáltatással minimális programozói ismeret birtokában a bemenő adatok cseréjét programozottan is elvégezhetjük. Egymintás t-próba többszöri végrehajtását automatizálni tudjuk. Statisztikai számításokat biztosító programok használata során az újabb kiértékeléseket csak manuálisan tudjuk kezdeményezni. Nagy előnyt biztosít számunkra az Excel VBA ismétlődő kiértékelések során. Bemutatásra kerül a számítások automatizált elvégzéséhez szükséges felhasználóbarát kezelőfelület kialakítása ez Excel táblázatkezelő program segítségével.
APA, Harvard, Vancouver, ISO, and other styles
11

Nurmaenah, Neng Cucu, Selvi Agini, Yulianda Putri, and Siti Chotimah. "Analisis Minat Belajar Siswa Pada Materi KPK Dan FPB Menggunakan Pendekatan Saintifik Berbantuan Aplikasi Visual Basic Excel (VBE)." Journal on Education 2, no. 4 (2020): 275–82. http://dx.doi.org/10.31004/joe.v2i4.320.

Full text
Abstract:
This study aims to analyze the learning interests of Class IV Elementary students in learning mathematics on the KPK and FPB material assisted by the VBA Excel application by using 20 indicators of learning interest. The research method for analysis uses descriptive qualitative method, with the instrument used in the form of giving questionnaires containing positive and negative statements to analyze students' interest in learning mathematics. The sample subject in the study was grade IV Cibungur State Primary School located in West Bandung with the number of students 29 people. The results obtained from research that students' interest in learning mathematics learning aided by VBA Excel in the KPK and FPB material is good. Keywords: Analysis of interest in learning, VBA Excel
APA, Harvard, Vancouver, ISO, and other styles
12

Romlah, Siti, Nurlela Nugraha, and Wahyu Setiawan. "Analisis Motivasi Belajar Siswa SD Albarokah 448 Bandung dengan Menggunakan Media ICT Berbasis For VBA Excel Pada Materi Garis Bilangan." Jurnal Cendekia : Jurnal Pendidikan Matematika 3, no. 1 (2019): 220–26. http://dx.doi.org/10.31004/cendekia.v3i1.98.

Full text
Abstract:
The purpose of this study was to describe the learning motivation of Albarokah 448 Elementary School students using ICT based media for excel VBA on the number line material. The research method used is descriptive qualitative method. The research subjects were conducted on 35 students of Albarokah Elementary School 448 Bandung class VI. The instruments provided were questionnaires on the student learning motivation scale consisting of 20 statements and 4 answer choices, namely 1. Strongly Agree (SS), 2. Agree (S), 3. Disagree (TS), 4. Very Disagree (STS. The learning motivation questionnaire related to ICT-based VBA excel media consists of 4 indicators.The results of the study show that the learning motivation of students at Albarokah Elementary School 448 Bandung using ICT-based media for VBA excel on the number line material as a whole is very good and there are 3 indicators that enter the criteria are very good, for indicators of confidence in using mathematics (very good), flexible indicators in doing mathematical work (very good), voluntary indicators leaving other obligations or tasks, (very good). in working on mathematics (good), and can be seen the average overall percentage of all students included in the very criteria well.
 Keywords: Mathematics Learning Motivation, ICT based on Excel VBA, Outline.
 Abstrak
 Tujuan penelitian ini adalah untuk mendeskripsikan motivasi belajar siswa SD Albarokah 448 Bandun dengan menggunakan media ICT berbasis for VBA excel pada materi garis bilangan. Metode penelitian yang digunakan adalah metode kualitatif deskriptif. Subjek penelitian yang dilakukan yaitu pada 35 siswa SD Albarokah 448 Bandung kelas VI. Instrumen yang diberikan berupa angket skala motivasi belajar siswa yang terdiri dari 20 pernyataan dan 4 pilihan jawaban yaitu 1.Sangat Setuju(SS), 2.Setuju(S), 3.Tidak Setuju (TS), 4.Sangat Tidak Setuju(STS. Angket motivasi belajar yang berhubungan dengan media ICT berbasis VBA excel terdiri dari 4 indikator. Hasil penelitian menunjukan bahwa motivasi belajar siswa SD Albarokah 448 Bandung dengan menggunakan media ICT berbasis for VBA excel pada materi garis bilangan secara keseluruhan tergolong sangat baik dan terdapat 3 indikator yang masuk kriteria baik sekali yaitu untuk indikator Percaya diri dalam menggunakan matematika(sanga baik), indikator Flekibel dalam melakukan kerja matematika (sangat baik); indikator Kerelaan meninggalkan kewajiban atau tugas lain,(sangat baik ). Terdapat 1 indikator yang masuk kriteria baik yaitu indikator Ketekunan dalam mengerjakan matematika(baik). Dan dapat dilihat rata-rata persentase keseluruhan semua siswa termasuk kedalam kriteria sangat baik.
APA, Harvard, Vancouver, ISO, and other styles
13

Yanase, Keiji. "An introduction to FE analysis with Excel-VBA." Computer Applications in Engineering Education 25, no. 2 (2017): 311–19. http://dx.doi.org/10.1002/cae.21799.

Full text
APA, Harvard, Vancouver, ISO, and other styles
14

Joyce, Toby, Edward J. Lisay, and Robert L. Nickerson. "An excel VBA application of Hoadley's QMP algorithm." Bell Labs Technical Journal 8, no. 1 (2003): 233–37. http://dx.doi.org/10.1002/bltj.10056.

Full text
APA, Harvard, Vancouver, ISO, and other styles
15

Hampel, György. "Excel VBA alkalmazása egy biometriai esettanulmány példáján bemutatva." Jelenkori Társadalmi és Gazdasági Folyamatok 12, no. 4 (2017): 35–40. http://dx.doi.org/10.14232/jtgf.2017.4.35-40.

Full text
Abstract:
Az Excel táblázatkezelő program olyan szolgáltatásait alkalmazhatjuk hatékonyan, melyekkel nagymennyiségű adat egy-egy részével ismétlődően kell végrehajtani statisztikai kiértékeléseket. Szerepük alapján külön munkalapon kerültek elhelyezésre a kiértékelendő adatok, a statisztikai számítási eljárások és az eredményeket összesítő táblázatok. A munkalapok közötti adatmozgást az éppen szükséges adatok kiválasztásával Visual Basic for Application program látja el. Egy termény két termesztési módjának összehasonlítására mért 44 kémiai összetevő mennyiségének kiértékelése során csaknem félezerszer végrehajtott statisztikai számítás eredményét kapjuk meg összesítve, táblázatba rendezett formában az elkészített VBA programmal.
APA, Harvard, Vancouver, ISO, and other styles
16

Fabulya, Zoltán. "Excel VBA függvények kialakítása háromdimenziós vektorok matematikai alkalmazására." Jelenkori Társadalmi és Gazdasági Folyamatok 14, no. 1 (2019): 29–34. http://dx.doi.org/10.14232/jtgf.2019.1.29-34.

Full text
Abstract:
A háromdimenziós vektorokkal végzett műveletek számítógépes támogatottsága nem megfelelő. A sokak által használt Excel táblázatkezelő program sem rendelkezik testreszabott szolgáltatásokkal a vektorműveletekhez. Ezt a hiányosságot az Excel Visual Basic for Applications nyújtotta lehetőségekkel megszüntethetjük. Kialakíthatunk felhasználói függvényeket, melyekkel kiszámíthatjuk a vektorok matematikai alkalmazási területéhez kapcsolódó eredményeket:
 
 Vektor nagysága, abszolút értéke
 Két vektor által bezárt szög, illetve a szög koszinusza
 Két vektor skaláris szorzata
 Két vektor vektoriális szorzata
 Három vektor vegyes szorzata
 
 Az így elkészített függvények a megszokott módon elérhetők lesznek a táblázatkezelő programban, így biztosítva a háromdimenziós vektorok témakörébe tartozó matematikai számítások egyszerű elvégzését.
APA, Harvard, Vancouver, ISO, and other styles
17

Bernard, Martin, Chandra Novtiar, and Euis Eti Rohaeti. "Penerapan Permainan Operasi Bilangan Bulat Menggunakan VBA pada Guru Kecamatan Pangalengan." ETHOS (Jurnal Penelitian dan Pengabdian) 8, no. 1 (2020): 5071. http://dx.doi.org/10.29313/ethos.v8i1.5071.

Full text
Abstract:
Abstract. This research is a descriptive qualitative that aims to find the practicalities of media and workshops on making integer game media using Visual Basic Application (VBA) for Microsoft Excel and Microsoft PowerPoint. Observation of the 3 participants showed that the use of Microsoft Excel and PowerPoint before the workshop which did not lead to the creation of game media for learning. After the workshop on making learning media for integer operations, 73.63% of teachers or prospective teachers stated the practicality of the media and was feasible to use compared to before which only 15.78% of teachers used Microsoft Excel and PowerPoint for administrative purposes only. The workshop that was held was also stated to be practically implemented in various levels of schools with a practical rating of 77.89% which was a practical criterion compared than before. Keywords. Media, VBA, Excel, Powerpoint, ICT Abstrak. Penelitian pada Pengabdian pada Masyarakat ini bersifat deskriptif kualitatif yang bertujuan untuk mengetahui kepraktisan media dan workshop pembuatan media permainan bilangan bulat dengan menggunakan Visual Basic Application (VBA) for Microsoft Excel dan Microsoft Powerpoint. Observasi terhadap 3 orang peserta memperlihatkan penggunaan Microsoft Excel dan Powerpoint sebelum workshop yang tidak mengarah pada pembuatan media permainan unruk pembelajaran. Setelah workshop pembuatan media pembelajaran operasi bilangan bulat , 73,63% guru atau calon guru menyatakan kepraktisan media dan layak digunakan dibandingkan sebelumnya yang hanya 15,78% guru memanfaatkan Microsoft Excel dan Powerpoint pada keperluan administrasi saja. Workshop yang dilaksanakan juga dinyatakan praktis diimplementasikan di sekolah dengan berbagai jenjang dengan penilaian kepraktisan sebesar 77,89% yang merupakan kriteria praktis dibandingkan dengan sebelumnya. Kata Kunci. Media, VBA, Excel, Powerpoint, TIK
APA, Harvard, Vancouver, ISO, and other styles
18

Shirokova, Olga Aleksandrovna. "Practice of Visual Solution of Boundary Value Problems by Running VBA in Microsoft Excel." Russian Digital Libraries Journal 24, no. 3 (2021): 548–62. http://dx.doi.org/10.26907/1562-5419-2021-24-3-548-562.

Full text
Abstract:
The article discusses the construction of a visual solution of boundary value problems for a linear differential equation of the second order by the tridiagonal sweep method in VBA in Excel. Creating macros in VBA allows you to visualize solutions to such boundary value problems.
APA, Harvard, Vancouver, ISO, and other styles
19

Shanmugam, Ramalingam. "Essentials of Excel, Excel VBA, SAS, and Minitab for statistical and financial analysis." Journal of Statistical Computation and Simulation 90, no. 1 (2019): 179–80. http://dx.doi.org/10.1080/00949655.2019.1628890.

Full text
APA, Harvard, Vancouver, ISO, and other styles
20

Bernard, Martin, and Eka Senjayawati. "Developing the Students’ Ability in Understanding Mathematics and Self-confidence with VBA for Excel." JRAMathEdu (Journal of Research and Advances in Mathematics Education) 1, no. 1 (2019): 45–56. http://dx.doi.org/10.23917/jramathedu.v1i1.6349.

Full text
Abstract:
Visual Basic Application for Excel is a simple program language and has the power to process data quickly. The utilization of math functions in Microsoft Excel can help work on Excel display more interactive so that teachers can create props inside Excel. The advantages of Microsoft Excel than other mathematical software are the many math functions and images available in the form of shapes or pictures. The availability of VBA, math and image functions in Microsoft Excel help teachers to design the creation of media related to mathematics learning, especially to develop the ability of junior high school students who have difficulty to connect mathematics lessons with basic mathematics knowledge requirements. By using VBA for Excel, the ability of junior high school students to improve in the usual way significantly with a t-test with 0.006 <0.05. Furthermore, there is an association between the students’ self-confidence and their mathematical comprehension skills with a contingency coefficient of 0.525 including a moderate association.
APA, Harvard, Vancouver, ISO, and other styles
21

Bernard, Martin, and Eka Senjayawati. "Developing the Students’ Ability in Understanding Mathematics and Self-confidence with VBA for Excel." JRAMathEdu (Journal of Research and Advances in Mathematics Education) 4, no. 1 (2019): 45–56. http://dx.doi.org/10.23917/jramathedu.v4i1.6349.

Full text
Abstract:
Visual Basic Application for Excel is a simple program language and has the power to process data quickly. The utilization of math functions in Microsoft Excel can help work on Excel display more interactive so that teachers can create props inside Excel. The advantages of Microsoft Excel than other mathematical software are the many math functions and images available in the form of shapes or pictures. The availability of VBA, math and image functions in Microsoft Excel help teachers to design the creation of media related to mathematics learning, especially to develop the ability of junior high school students who have difficulty to connect mathematics lessons with basic mathematics knowledge requirements. By using VBA for Excel, the ability of junior high school students to improve in the usual way significantly with a t-test with 0.006 0.05. Furthermore, there is an association between the students’ self-confidence and their mathematical comprehension skills with a contingency coefficient of 0.525 including a moderate association.
APA, Harvard, Vancouver, ISO, and other styles
22

Matsuyama, Hidekazu, and Teruya Yamada. "Development of Hokkaido Agricultural Statistic Database with "Excel VBA"." Agricultural Information Research 7, no. 2 (1998): 81–95. http://dx.doi.org/10.3173/air.7.81.

Full text
APA, Harvard, Vancouver, ISO, and other styles
23

Tsai, Weiyu, and Don G. Wardell. "An Interactive Excel VBA Example for Teaching Statistics Concepts." INFORMS Transactions on Education 7, no. 1 (2006): 125–35. http://dx.doi.org/10.1287/ited.7.1.125.

Full text
APA, Harvard, Vancouver, ISO, and other styles
24

LeBlanc, Larry J., and Michael R. Galbreth. "Implementing Large-Scale Optimization Models in Excel Using VBA." Interfaces 37, no. 4 (2007): 370–82. http://dx.doi.org/10.1287/inte.1060.0256.

Full text
APA, Harvard, Vancouver, ISO, and other styles
25

Sanggala, Ekra. "Penyelesaian CVRP dengan Menggunakan Savings Algorithm & VBA Excel." Jurnal Media Teknik dan Sistem Industri 4, no. 1 (2020): 39. http://dx.doi.org/10.35194/jmtsi.v4i1.850.

Full text
Abstract:
Capacitated Vehicle Routing Problem (CVRP) merupakan sebuah masalah logistik yang banyak diteliti oleh para ilmuwan. Salah satu algoritma yang populer untuk menyelesaikannya adalah Algoritma Savings. Jika perhitungan Algoritma Savings dilakukan secara manual tentu akan banyak menghabiskan waktu, oleh karena itu diperlukan sebuah aplikasi untuk membantu menyelesaikan perhitungannya. Visual Basic Application for Excel (VBA Excel) dapat digunakan untuk membuat aplikasi ini. Aplikasi yang dihasilkannya ini dapat menyelesaikan perhitungan Algoritma Savings, walaupun sampai saat ini hanya cocok untuk keperluan latihan dan sebagai media pembelajaran, aplikasi ini masih bisa dikembangkan lagi.
APA, Harvard, Vancouver, ISO, and other styles
26

Chin, Jerry, and Mary Chin. "AN EXCEL VBA APPROACH TO THE TRUTH FUNCTIONAL FORM." California Business Review 2, no. 3 (2014): 7–12. http://dx.doi.org/10.18374/cbr-2-3.1.

Full text
APA, Harvard, Vancouver, ISO, and other styles
27

Racicot, François-Éric, and Raymond Théoret. "OPTION PRICING MODELS & VOLATILITY USING EXCEL®-VBA." Journal of Derivatives & Hedge Funds 13, no. 2 (2007): 181–83. http://dx.doi.org/10.1057/palgrave.jdhf.1850068.

Full text
APA, Harvard, Vancouver, ISO, and other styles
28

Craney, Trevor A., and Nathan White. "Distribution Selection with No Data Using VBA and Excel." Quality Engineering 16, no. 4 (2004): 643–56. http://dx.doi.org/10.1081/qen-120038025.

Full text
APA, Harvard, Vancouver, ISO, and other styles
29

Zhou, Jibin, and Xianhua Li. "GeoPlot: An Excel VBA program for geochemical data plotting." Computers & Geosciences 32, no. 4 (2006): 554–60. http://dx.doi.org/10.1016/j.cageo.2005.07.005.

Full text
APA, Harvard, Vancouver, ISO, and other styles
30

Rahayu, Galih Dani Septiyan, and Hana Sakura Putu Arga. "Influence of VBA-based Monopoly Game in Microsoft Excel as Teaching Material on Primary School Students’ Cross-Cultural Competence in Social Studies Learning." Mimbar Sekolah Dasar 6, no. 2 (2019): 147. http://dx.doi.org/10.17509/mimbar-sd.v6i2.16935.

Full text
Abstract:
The background of this research is based on diversity of Indonesia in terms of social, cultural, religious, language and ethnic groups. The specific problem in this research lies on the diversity of students in one public elementary school in Cimahi City, situated in the area of the Indonesian Army. Therefore, this research seeks to investigate the difference in improvement of students’ cross cultural skills between learning using VBA (Visual Basic of Application)-based Monopoly game teaching materials in Microsoft Excel and conventional learning. This research aims at improving students’ cross cultural skills, and observing the differences or disconnection of the improvement of students’ cultural skills between learning using VBA-based teaching materials and conventional learning. This research employed a quasi-experimental method with a non-randomized pretest-posttest control group design. A quantitative observation instrument in the form of a checklist was used as the research instrument. The results revealed that both learning using a teaching material of VBA-based Monopoly in Microsoft Excel and conventional learning were able to improve the students’ cross cultural skills. However, based on the result of N-Gain test, learning using teaching material of VBA-based Monopoly game in Microsoft Excel was better than conventional learning.
APA, Harvard, Vancouver, ISO, and other styles
31

Amalya, Ewis, M. Rahmad M. Rahmad, and Syahril Syahril. "PERANCANGAN VISUALISASI GELOMBANG BERBASIS VBA DENGAN MICROSOFT EXCEL SEBAGAI MEDIA PEMBELAJARAN FISIKA SISWA SMA." Jurnal Geliga Sains: Jurnal Pendidikan Fisika 5, no. 2 (2018): 95. http://dx.doi.org/10.31258/jgs.5.2.95-103.

Full text
Abstract:
Penelitian ini bertujuan untuk merancang media pembelajaran visualisasi gelombang berbasis VBA padamicrosoft excel sebagai media pembelajaran fisika yang valid bagi siswa SMA kelas XI. Penelitian inimenggunakan metode Research and Development dengan tipe ADDIE. Tahap dari perancangan mediapembelajaran visulisasi gelombang ini meliputi Analisis, Desain, Pengembangan, Implementasi, danEvaluasi. Namun, pada penelitian ini peneliti hanya melakukan hingga tahap pengembangan, kemudiandilakukan validasi media menggunakan instrumen penilaian. Instrumen yang digunakan adalah lembarpenilaian validasi media pembelajaran visualisasi gelombang berbasis VBA pada Microsoft Excel. Penilaiandilakukan pada 3 aspek yaitu aspek perancangan, aspek isi pembelajaran, dan aspek pedagogik yang dinilaioleh validator. Validator terdiri dari tim pakar dan pengguna. Pakar yaitu validator yang merupakan dosenPendidikan Fisika Universitas Riau, sedangkan pengguna yaitu validator dari guru SMA yang berada diPekanbaru. Skor validasi yang didapat untuk aspek perancangan dari pakar dan pengguna 3.62. Skorvalidasi pada aspek isi pembelajaran dari pakar dan pengguna 3.60, dan skor validasi yang didapat padaaspek pedagogik dari pakar dan pengguna adalah 3.73. Hasil analisis skor validasi media pembelajaranvisualisasi gelombang berbasis VBA pada microsoft excel berada pada kategori ST (sangat tinggi) untuksemua aspek yang dinilai. Dengan demikian media ini dapat dikatakan valid dan layak digunakan sebagaimedia pembelajaran fisika yang valid pada materi gelombang untuk siswa SMA kelas XI.
APA, Harvard, Vancouver, ISO, and other styles
32

Eissa, Abdalla. "Developing Excel-VBA Spreadsheet for Truss Element Analysis and Design." FES Journal of Engineering Sciences 9, no. 1 (2021): 86–90. http://dx.doi.org/10.52981/fjes.v9i1.663.

Full text
Abstract:
In this paper EXCEL Visual Basic application spreadsheet has used in analyzing and designing truss elements. EXCEL spreadsheet was developed to draw and analyzes different type of truss elements for tension and compression forces. The truss members were tested under dead, imposed, and wind load. Members capacity was provided according to BS 5950. Different type of joints connection was designed and recommended for support and internal joints.
APA, Harvard, Vancouver, ISO, and other styles
33

Dong, Guo Liang, Shu Quan Xu, and Fu Jia Liu. "Implementation of Chart Automatically Drawing in Excel Based on VBA." Applied Mechanics and Materials 427-429 (September 2013): 2576–79. http://dx.doi.org/10.4028/www.scientific.net/amm.427-429.2576.

Full text
Abstract:
Drawing charts are odd work by adding a data source manually and setting other parameters such as border, legend etc in Excel. The key technologies and implementation methods of chart-automatic-drawing are described using embedded VBA Programming codes.
APA, Harvard, Vancouver, ISO, and other styles
34

Wang, De Ling, and Jiang Hai Shen. "Application of Excel VBA in Score Analysis for Specialty Accreditation." Applied Mechanics and Materials 536-537 (April 2014): 574–77. http://dx.doi.org/10.4028/www.scientific.net/amm.536-537.574.

Full text
Abstract:
In the standard target system of specialty accreditation, assessed results of teaching process are required to reflect students level of mastering related knowledge. Examination score is the most direct and important reflection. In this paper, VBA programming was applied to generate score sheet of main curriculums in recent years which is required in self-assessment report for specialty accreditation. Firstly, original data were obtained from information management system of teaching affairs. They are teaching task files and class score sheet, which are all Excel files. Secondly, original data were handled by VBA according to requirement. Compulsory courses for civil engineering class and scores for first exams were selected. Thirdly, average scores and first passing rates were calculated. At last, a summary score sheet was produced which is helpful to analyze students learning effect and to find out reasons. Therefore, the efficiency of analyzing teaching results for specialty accreditation is greatly improved.
APA, Harvard, Vancouver, ISO, and other styles
35

Zhang, Zhiyong. "Construction of the Multimedia Teaching Platform of Cost Accounting Course Based on EXCEL VBA Program." International Journal of Emerging Technologies in Learning (iJET) 13, no. 05 (2018): 177. http://dx.doi.org/10.3991/ijet.v13i05.8436.

Full text
Abstract:
there exit some problems in domestic multimedia teaching of “Cost Accounting” course such as the difficulties of achieving teaching objectives and teaching effect, slow control loading, data missing in excel saving page, and data leakage risk, etc. Thus this paper has constructed a multi-media teaching platform for “Cost Accounting” course based on Excel VBA technology. Firstly, the paper has elaborated the theoretical foundation of constructing “Cost Accounting” course multimedia teaching platform. Then the paper has elaborated the methods and procedures of constructing “Cost Accounting” course multimedia teaching platform based on Excel VBA, and displayed the construction results. In addition, the paper has innovatively applied the technology of webpage remote processing classroom Excel. In the end, the paper has applied and verified the teaching effect of the platform in practical teaching. The result shows that the multi-media teaching platform constructed in this paper has greatly improved the teaching effect of“Cost Accounting” course.
APA, Harvard, Vancouver, ISO, and other styles
36

O. Abisoye, Blessing, and Opeyemi A. Abisoye. "Simulation of Electric Power Plant Performance Using Excel® -VBA." International Journal of Information Engineering and Electronic Business 10, no. 3 (2018): 8–14. http://dx.doi.org/10.5815/ijieeb.2018.03.02.

Full text
APA, Harvard, Vancouver, ISO, and other styles
37

SHOJI, Tetsuya. "Drawing of Several Kinds of Histograms by MS-Excel/VBA." GEOINFORMATICS 17, no. 3 (2006): 185–89. http://dx.doi.org/10.6010/geoinformatics.17.185.

Full text
APA, Harvard, Vancouver, ISO, and other styles
38

Amalfitano, Domenico, Vincenzo De Simone, Anna Rita Fasolino, and Porfirio Tramontana. "EXACT: A tool for comprehending VBA-based Excel spreadsheet applications." Journal of Software: Evolution and Process 28, no. 6 (2016): 483–505. http://dx.doi.org/10.1002/smr.1787.

Full text
APA, Harvard, Vancouver, ISO, and other styles
39

SATHO, Takahisa, and Hirofumi EGUCHI. "A31 Control System Design Tool by means of Excel VBA." Proceedings of the Symposium on the Motion and Vibration Control 2009.11 (2009): 393–98. http://dx.doi.org/10.1299/jsmemovic.2009.11.393.

Full text
APA, Harvard, Vancouver, ISO, and other styles
40

TATENO, Masayoshi, Takashi SAIKA, Kiyoshi KATO, and Akisato MIZUNO. "Estimation of Excel VBA as Programming Language for an Education." Journal of JSEE 47, no. 4 (1999): 2–7. http://dx.doi.org/10.4307/jsee.47.4_2.

Full text
APA, Harvard, Vancouver, ISO, and other styles
41

Azwir, Hery Hamdi, and M. Yafi Maulidin. "IMPLEMENTING AN AUTOMATED SYSTEM TO SIMPLIFY THE DATA MANAGEMENT PROCESS AT PARTS STORAGE AREA OF PT. Z." J@ti Undip : Jurnal Teknik Industri 12, no. 2 (2017): 85. http://dx.doi.org/10.14710/jati.12.2.85-94.

Full text
Abstract:
This research concerns about the design and implementation of a new information system which will simplify the processes of the current system and its impact on the warehouse staffs. In order to automate the processes, a programmed information system is designed using Microsoft excel VBA, a basic programming function inside Microsoft excel. First, the current system is analyzed. Next, the user requirements and proposed system requirements are analyzed to make the system design. Then, the program is developed and tested by using VBA (Visual Basic for Applications). Then, the new system is implemented and the implementation results are analyzed. The results found that the new system successfully fulfilled the objectives of this research and the user requirements, although there are still some improvements which need to be done. During two months’ period of implementation, there are some problems encountered which required the programmer to improve the system. Like every system, there are some advantages and disadvantages found in this new system.AbstrakPenelitian ini fokus kepada desain dan implementasi sistem informasi baru yang akan mengotomatisasi proses dari sistem saat ini dan dampaknya terhadap staf gudang. Dalam rangka untuk mengotomatisasi proses, sistem informasi yang terprogram dirancang menggunakan Microsoft excel VBA,sebuah fungsi dasar pemrograman dalam Microsoft excel. Pertama, sistem yang sekarang dianalisis. Selanjutnya, kebutuhan pengguna dan kebutuhan sistem yang diusulkan dianalisis untuk membuat desain sistem. Kemudian, program ini dikembangkan dan diuji dengan menggunakan VBA (Visual Basic for Applications). Kemudian, sistem baru diimplementasikan dan hasil dari implementasi dianalisis. Hasil penelitian menemukan bahwa sistem baru berhasil memenuhi tujuan penelitian ini dan kebutuhan pengguna, meskipun masih ada beberapa perbaikan yang perlu dilakukan. Selama periode dua bulan implementasi, ada beberapa masalah yang dihadapi yang membutuhkan programmer untuk mengembangkan sistemnya. Seperti setiap sistem, ada beberapa kelebihan dan kekurangan yang ditemukan dalam sistem baru ini.
APA, Harvard, Vancouver, ISO, and other styles
42

Romanchenko, Tatyana Nikolaevna. "Creating an electronic textbook in EXCEL using the VBA programming language." Программные системы и вычислительные методы, no. 1 (January 2020): 18–30. http://dx.doi.org/10.7256/2454-0714.2020.1.32244.

Full text
Abstract:
The author gives the presentation of the content and structural components of an electronic textbook using Excel and the programming language Visual Basic for Applications using an example of a textbook fragment. The methods of presenting theoretical material, modeling with a visual demonstration, automatic verification of the results of assignments, automatic visual display of the results of mastering the topic using the built-in Excel functions are described in detail. The codes of programs for automatic presentation of individual tasks, automatic data modeling based on built-in Excel functions and building a scatter chart with smooth curves are given. The research methodology is based on testing the capabilities of MS Excel and the built-in programming language Visual Basic for Applications to solve the tasks. In contrast to the tools available today for creating electronic educational resources, such a textbook is easily modifiable, allows you to change the scripts of the educational process, in addition to test tasks, present students with sets of individual tasks, and adapt tasks to the level of students. In addition, it is an effective didactic tool for simultaneously mastering the Excel spreadsheet processor and discipline that requires modeling or performing complex calculations and routine operations.
APA, Harvard, Vancouver, ISO, and other styles
43

Ma, Lijun, and Guowen Che. "Excel VBA programming with Excel to compute the load tranceverse distribution coefficient of G-M method." Journal of Physics: Conference Series 1941, no. 1 (2021): 012026. http://dx.doi.org/10.1088/1742-6596/1941/1/012026.

Full text
APA, Harvard, Vancouver, ISO, and other styles
44

Nurhayati, Nurhayati. "PENGGUNAAN MEDIA ANIMASI BERBASIS VISUAL BASIC (VBA) SPREADSHEET EXCEL UNTUK MENINGKATKAN PENGUASAAN KONSEP MAHASISWA PADA MATERI POTENSIAL OSILATOR HARMONIK SEDERHANA." Jurnal Edukasi Matematika dan Sains 3, no. 1 (2015): 54. http://dx.doi.org/10.25273/jems.v3i1.246.

Full text
Abstract:
<p>Penelitian ini bertujuan untuk menerapkan media berbasis <em>visual basic</em> (<em>VBA</em>) <em>spreadsheet excel</em> dalam membelajarkan materi potensial osilator harmonik dan menganalisis pengaruh penggunaan media tersebut terhadap penguasaan konsep dan mahasiswa fisika. Selain itu penelitian ini dilakukan untuk mendapatkan gambaran tentang tanggapan mahasiswa terhadap implementasi media berbasis <em>visual basic</em> (<em>VBA</em>) <em>spreadsheet excel</em> pada materi potensial osilator harmonik.Metode yang digunakan adalah metode kuasi eksperimen dengan rancangan<em>Nonrandomized Groups Posttest-Only</em>. Uji hipotesis menggunakan uji <em>U Mann Whitney</em> yang terdapat pada program SPSS.Berdasarkan hasil analisis data dapat disimpulkan bahwa: (1) penguasaan konsep potensial osilator harmonik sederhana bagi mahasiswa yang memperoleh pembelajaran menggunakan media berbasis <em>visual basic spreadsheet excel</em> lebih tinggi secara signifikan dibandingkan mahasiswa yang memperoleh pembelajaran tanpa menggunakan media berbasis <em>visual basic spreadsheet excel</em> dan (2) pembelajaran dengan menggunakan media berbasis <em>visual basic spreadsheet excel</em> dapat menumbuhkan motivasi belajar mahasiswa pada materi potensial osilator harmonik sederhana.</p>
APA, Harvard, Vancouver, ISO, and other styles
45

Jang, Seung Ju, and Dae-Hyun Ryu. "Design of Efficient Data Search Function using the Excel VBA DAO." Journal of the Korea Institute of Information and Communication Engineering 18, no. 1 (2014): 217–22. http://dx.doi.org/10.6109/jkiice.2014.18.1.217.

Full text
APA, Harvard, Vancouver, ISO, and other styles
46

Park, Cheolyong, and Hyun Seok Choi. "An educational tool for binary logistic regression model using Excel VBA." Journal of the Korean Data and Information Science Society 25, no. 2 (2014): 403–10. http://dx.doi.org/10.7465/jkdi.2014.25.2.403.

Full text
APA, Harvard, Vancouver, ISO, and other styles
47

Stolf, Rubismar, Jorge Hiroshi Murakami, Caetano Brugnaro, Luiz Gabriel Silva, Luiz Carlos Ferreira da Silva, and Luiz Antonio Correia Margarido. "Penetrômetro de impacto stolf - programa computacional de dados em EXCEL-VBA." Revista Brasileira de Ciência do Solo 38, no. 3 (2014): 774–82. http://dx.doi.org/10.1590/s0100-06832014000300009.

Full text
Abstract:
Há dois principais tipos de penetrômetro, o estático e o dinâmico. No primeiro, uma haste com uma ponta cônica é introduzida contínua e lentamente (quase estático), registrando-se concomitantemente a força de reação que é igual à resistência do solo. No segundo, utiliza-se a mesma haste. Contudo, esta é introduzida por meio da promoção de uma massa de impacto em queda livre. Dessa forma, a teoria pode ser tratada pela dinâmica newtoniana para obtenção da resistência. O objetivo do programa é proporcionar uma ferramenta rápida, facilitadora da computação de dados de resistência do solo, para esse último penetrômetro, resultando tabelas e gráficos já no formato científico. Desenvolvido em linguagem de programação Visual Basic Aplication (VBA), escolheu-se o aplicativo Excel como interface com o usuário pela sua popularidade. É constituído por quatro planilhas, duasauxiliares, sendo duas delas essenciais, Plan1 e 2: Plan1 - dados de entrada (número de impactos e profundidade). Concomitante à digitação, a tabela de resistência é confeccionada com o respectivo gráfico, podendo tabelar 40 perfis. Plan2 - cumpre função especial de equalizar, ou seja, padronizar a profundidade em camadas constantes, permitindo unificar todos os perfis em uma única tabela. Para tal, escolhe-se uma espessura de camada (exemplo: 5 cm); em seguida, o programa coleta os dados de resistência (MPa) da Plan1 e interpola os valores para a profundidade de 5 em 5 cm. Após realizar esse procedimento para todas as tabelas da Plan1, o programa gera, na Plan2, uma única tabela com todos os perfis, a média geral e os respectivos gráficos. É possível selecionar os perfis; por exemplo, apenas os medidos na linha ou entrelinha de plantio e eliminar perfis a critério do usuário. Como objetivo complementar, descreve-se a evolução do projeto "Penetrômetro de impacto", iniciado em 1982, cuja técnica passou a ser adotada no meio científico, após a publicação da teoria nesta revista em 1991. Apresenta-se também levantamento no meio científico nos últimos três anos (2010-2012), propiciando uma visão das principais aplicações na atualidade.
APA, Harvard, Vancouver, ISO, and other styles
48

SHOJI, Tetsuya. "Display of Powder X-ray Diffraction Patterns by MS-Excel/VBA." GEOINFORMATICS 15, no. 4 (2004): 185–92. http://dx.doi.org/10.6010/geoinformatics.15.185.

Full text
APA, Harvard, Vancouver, ISO, and other styles
49

Taresawa, Yumiko. "Writing a program of social psychological experiment by using Excel VBA." Proceedings of the Annual Convention of the Japanese Psychological Association 79 (September 22, 2015): 1PM—001–1PM—001. http://dx.doi.org/10.4992/pacjpa.79.0_1pm-001.

Full text
APA, Harvard, Vancouver, ISO, and other styles
50

Liang, Hui, and Hua Li. "Research of Excel VBA Teaching Based on Computational Thinking Ability Training." Applied Mechanics and Materials 373-375 (August 2013): 2200–2204. http://dx.doi.org/10.4028/www.scientific.net/amm.373-375.2200.

Full text
Abstract:
Recently, higher education has seen an increasing emphasis on the prominent role of computational thinking in computer fundamental education. Computational thinking is taken for the fundamental skills for everyone, not just computer scientist, to learn and use. How to develop students capacity for computational thinking during the teaching process is one of the basic goals of computer fundamental education. Using Excel VBA course teaching as example, in this paper, we discuss how to understand the essence of computational thinking and how cultivate the computational thinking ability of students.
APA, Harvard, Vancouver, ISO, and other styles
We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!

To the bibliography