Journal articles: 'MS Excel'

1

El-Gebeily, M., and B. Yushau. "Numerical Methods with MS Excel." Mathematics Enthusiast 4, no. 1 (February 1, 2007): 84–92. http://dx.doi.org/10.54870/1551-3440.1061.

Full text

APA, Harvard, Vancouver, ISO, and other styles

2

Shoji, Tetsuya. "Calculation of Variogram by MS-Excel." Geoinformatics 11, no. 2 (2000): 126–27. http://dx.doi.org/10.6010/geoinformatics1990.11.2_126.

Full text

APA, Harvard, Vancouver, ISO, and other styles

3

Mihaylov, Deyan. "Cryptography and Cryptanalysis in MS EXCEL." Mathematics and Informatics LXV, no. 1 (February 28, 2022): 53–71. http://dx.doi.org/10.53656/math2022-1-4-kri.

Full text

Abstract:

This paper provides implementations of three well-known ciphers – Caesar Cipher, Vigenere Cipher and Hill Cipher in Microsoft Excel. It is shown how the ciphers can be broken by using Brute-force Attack, Frequency Analysis Attack and Known-plaintext Attack. For the purpose of the cryptanalysis the relative occurrence frequencies of the letters and the index of coincidence (κ ) in Bulgarian language are determined. The classical Frequency Analysis Attack is modified using the cross-correlation between frequencies of letters in the natural language and the cipher text. Modular matrix operations in MS Excel are shown.

APA, Harvard, Vancouver, ISO, and other styles

4

Радзіховська, Л., and Л. Гусак. "Застосування табличного процесора MS EXEL при викладанні системного аналізу." COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION, no. 40 (September 23, 2020): 84–89. http://dx.doi.org/10.36910/6775-2524-0560-2020-40-13.

Full text

Abstract:

Стаття присвячена застосуванню сучасних інформаційних технологій під час викладання дисципліни «Системний аналіз». Розкриті зміст та важливість дисципліни для розв’язання задач аналізу, проектування та управління в усіх системах. Розглянуті методологічні підходи щодо викладання дисципліни із використанням табличного процесора MS Exel. Обґрунтовано, що впровадження цієї програми дає змогу зосередити увагу на конкретних проблемах, які є основними в даній дисципліні без відволікання на аналітичні та довготривалі обчислення. Запропоновані способи організації обчислень засобами MS Excel під час вивчення окремих тем системного аналізу. Проведено аналіз наукової літератури щодо застосування табличного процесора MS EXCEL при побудові та дослідженні математичних моделей економічних процесів. Доведено доцільність використання обчислювального середовища Microsoft Excel для розв’язування задач з системного аналізу.

APA, Harvard, Vancouver, ISO, and other styles

5

Martiningsih, Raden Roro. "EFEKTIVITAS PEMANFAATAN MS EXCEL DALAM PEMBELAJARAN MATEMATIKA DI SMP MUHAMMADIYAH 1 SURABAYA." Jurnal Kwangsan 3, no. 2 (December 16, 2015): 107. http://dx.doi.org/10.31800/jtp.kw.v3n2.p107--120.

Full text

Abstract:

Build innovative learning can be done by utilizing MS Excel application on statistical material in class VII SMP aim of this study was to determine the effectiveness of the use of MS Excel in mathematics at SMP Muhammadiyah 1 Surabaya. This study uses an experimental study comparing the mathematics achievement of students of class VII SMP Muhammadiyah 1 Surabaya utilizing Ms Excel and who do not use Ms Excel. The treatments provided are the use of MS Excel on statistical learning. The results showed an average difference in learning achievement statistics that utilize MS Excel in learning is 7.94, while a group of students who do not utilize is 5.89. Results of t-test showed significant value of 0.007, with a significance level of 0.05, which means no statistical difference in learning achievement of students between the harness and utilize MS Excel. It can be concluded that learning with MS Excel on a statistical significant effect. AbstrakMembangun pembelajaran inovatif bisa dilakukan dengan cara memanfaatkan aplikasi Ms Excel pada materi statistik di kelas VII SMP Tujuan penelitian ini adalah mengetahui efektifitas pemanfaatan Ms Excel dalam pembelajaran matematika di SMP Muhammadiyah 1 Surabaya. Penelitian ini menggunakan penelitian ekperimen yang membandingkan prestasi belajar matematika peserta didik kelas VII SMP Muhammadiyah 1 Surabaya yang memanfaatkan Ms Excel dan yang tidak memanfaatkan Ms Excel. Perlakuan yang diberikan adalah pemanfaatan Ms Excel pada pembelajaran statistik. Hasil penelitian ini menunjukkan rata-rata perbedaan prestasi belajar statistik yang memanfaatkan Ms Excel dalam pembelajaran adalah 7,94 sedangkan kelompok siswa yang tidak memanfaatkan adalah 5,89. Hasil uji t menunjukkan nilai signifikasi 0,007, dengan level signifikansi 0,05 yang artinya ada perbedaan prestasi belajar statistik siswa antara yang memanfaatkan dan tidak memanfaatkan Ms Excel. Sehingga dapat disimpulkan bahwa pembelajaran dengan Ms Excel pada statistik memberikan pengaruh secara signifikan.

APA, Harvard, Vancouver, ISO, and other styles

6

Martiningsih, Raden Roro. "EFEKTIVITAS PEMANFAATAN MS EXCEL DALAM PEMBELAJARAN MATEMATIKA DI SMP MUHAMMADIYAH 1 SURABAYA." Jurnal Kwangsan 3, no. 2 (December 16, 2015): 107. http://dx.doi.org/10.31800/jtpk.v3n2.p107--120.

Full text

Abstract:

Build innovative learning can be done by utilizing MS Excel application on statistical material in class VII SMP aim of this study was to determine the effectiveness of the use of MS Excel in mathematics at SMP Muhammadiyah 1 Surabaya. This study uses an experimental study comparing the mathematics achievement of students of class VII SMP Muhammadiyah 1 Surabaya utilizing Ms Excel and who do not use Ms Excel. The treatments provided are the use of MS Excel on statistical learning. The results showed an average difference in learning achievement statistics that utilize MS Excel in learning is 7.94, while a group of students who do not utilize is 5.89. Results of t-test showed significant value of 0.007, with a significance level of 0.05, which means no statistical difference in learning achievement of students between the harness and utilize MS Excel. It can be concluded that learning with MS Excel on a statistical significant effect. AbstrakMembangun pembelajaran inovatif bisa dilakukan dengan cara memanfaatkan aplikasi Ms Excel pada materi statistik di kelas VII SMP Tujuan penelitian ini adalah mengetahui efektifitas pemanfaatan Ms Excel dalam pembelajaran matematika di SMP Muhammadiyah 1 Surabaya. Penelitian ini menggunakan penelitian ekperimen yang membandingkan prestasi belajar matematika peserta didik kelas VII SMP Muhammadiyah 1 Surabaya yang memanfaatkan Ms Excel dan yang tidak memanfaatkan Ms Excel. Perlakuan yang diberikan adalah pemanfaatan Ms Excel pada pembelajaran statistik. Hasil penelitian ini menunjukkan rata-rata perbedaan prestasi belajar statistik yang memanfaatkan Ms Excel dalam pembelajaran adalah 7,94 sedangkan kelompok siswa yang tidak memanfaatkan adalah 5,89. Hasil uji t menunjukkan nilai signifikasi 0,007, dengan level signifikansi 0,05 yang artinya ada perbedaan prestasi belajar statistik siswa antara yang memanfaatkan dan tidak memanfaatkan Ms Excel. Sehingga dapat disimpulkan bahwa pembelajaran dengan Ms Excel pada statistik memberikan pengaruh secara signifikan.

APA, Harvard, Vancouver, ISO, and other styles

7

Martiningsih, Raden Roro. "EFEKTIVITAS PEMANFAATAN MS EXCEL DALAM PEMBELAJARAN MATEMATIKA DI SMP MUHAMMADIYAH 1 SURABAYA." Jurnal Kwangsan 3, no. 2 (December 16, 2015): 107. http://dx.doi.org/10.31800/jkwangsan-jtp.v3n2.p107--120.

Full text

Abstract:

Build innovative learning can be done by utilizing MS Excel application on statistical material in class VII SMP aim of this study was to determine the e ectiveness of the use of MS Excel in mathematics at SMP Muhammadiyah 1 Surabaya. This study uses an experimental study comparing the mathematics achievement of students of class VII SMP Muhammadiyah 1 Surabaya utilizing Ms Excel and who do not use Ms Excel. The treatments provided are the use of MS Excel on statistical learning. The results showed an average di erence in learning achievement statistics that utilize MS Excel in learning is 7.94, while a group of students who do not utilize is 5.89. Results of t-test showed signi cant value of 0.007, with a signi cance level of 0.05, which means no statistical di erence in learning achievement of stu- dents between the harness and utilize MS Excel. It can be concluded that learning with MS Excel on a statistical signi cant effect. AbstrakMembangun pembelajaran inovatif bisa dilakukan dengan cara memanfaatkan aplikasi Ms Excel pada materi statistik di kelas VII SMP Tujuan penelitian ini adalah mengetahui efekti tas pe- manfaatan Ms Excel dalam pembelajaran matematika di SMP Muhammadiyah 1 Surabaya. Penelitian ini menggunakan pene- litian ekperimen yang membandingkan prestasi belajar matema- tika peserta didik kelas VII SMP Muhammadiyah 1 Surabaya yang memanfaatkan Ms Excel dan yang tidak memanfaatkan Ms Excel. Perlakuan yang diberikan adalah pemanfaatan Ms Excel pada pembelajaran statistik. Hasil penelitian ini menunjukkan rata-rata perbedaan prestasi belajar statistik yang memanfaat- kan Ms Excel dalam pembelajaran adalah 7,94 sedangkan kel- ompok siswa yang tidak memanfaatkan adalah 5,89. Hasil uji t menunjukkan nilai signi kasi 0,007, dengan level signi kansi 0,05 yang artinya ada perbedaan prestasi belajar statistik siswa antara yang memanfaatkan dan tidak memanfaatkan Ms Excel. Sehingga dapat disimpulkan bahwa pembelajaran dengan Ms Excel pada statistik memberikan pengaruh secara signi kan.

APA, Harvard, Vancouver, ISO, and other styles

8

Martiningsih, Raden Roro. "EFEKTIVITAS PEMANFAATAN MS EXCEL DALAM PEMBELAJARAN MATEMATIKA DI SMP MUHAMMADIYAH 1 SURABAYA." Jurnal Kwangsan 3, no. 2 (December 16, 2015): 107. http://dx.doi.org/10.31800/jurnalkwangsan.v3i2.28.

Full text

Abstract:

Build innovative learning can be done by utilizing MS Excel application on statistical material in class VII SMP aim of this study was to determine the e ectiveness of the use of MS Excel in mathematics at SMP Muhammadiyah 1 Surabaya. This study uses an experimental study comparing the mathematics achievement of students of class VII SMP Muhammadiyah 1 Surabaya utilizing Ms Excel and who do not use Ms Excel. The treatments provided are the use of MS Excel on statistical learning. The results showed an average di erence in learning achievement statistics that utilize MS Excel in learning is 7.94, while a group of students who do not utilize is 5.89. Results of t-test showed signi cant value of 0.007, with a signi cance level of 0.05, which means no statistical di erence in learning achievement of stu- dents between the harness and utilize MS Excel. It can be concluded that learning with MS Excel on a statistical signi cant effect. AbstrakMembangun pembelajaran inovatif bisa dilakukan dengan cara memanfaatkan aplikasi Ms Excel pada materi statistik di kelas VII SMP Tujuan penelitian ini adalah mengetahui efekti tas pe- manfaatan Ms Excel dalam pembelajaran matematika di SMP Muhammadiyah 1 Surabaya. Penelitian ini menggunakan pene- litian ekperimen yang membandingkan prestasi belajar matema- tika peserta didik kelas VII SMP Muhammadiyah 1 Surabaya yang memanfaatkan Ms Excel dan yang tidak memanfaatkan Ms Excel. Perlakuan yang diberikan adalah pemanfaatan Ms Excel pada pembelajaran statistik. Hasil penelitian ini menunjukkan rata-rata perbedaan prestasi belajar statistik yang memanfaat- kan Ms Excel dalam pembelajaran adalah 7,94 sedangkan kel- ompok siswa yang tidak memanfaatkan adalah 5,89. Hasil uji t menunjukkan nilai signi kasi 0,007, dengan level signi kansi 0,05 yang artinya ada perbedaan prestasi belajar statistik siswa antara yang memanfaatkan dan tidak memanfaatkan Ms Excel. Sehingga dapat disimpulkan bahwa pembelajaran dengan Ms Excel pada statistik memberikan pengaruh secara signi kan.

APA, Harvard, Vancouver, ISO, and other styles

9

Kim, Youngheub. "Application of MS Excel in Teaching Statics." Transactions of the KSME C: Industrial Technology and Innovation 2, no. 1 (March 1, 2014): 21–28. http://dx.doi.org/10.3795/ksme-c.2014.2.1.021.

Full text

APA, Harvard, Vancouver, ISO, and other styles

10

Steur, P. P. M., L. Lipinski, H. Manuszkiewicz, and A. Szmyrka-Grzebyk. "Data-acquisition programming under MS-Excel®." Measurement Science and Technology 11, no. 2 (January 19, 2000): N28—N30. http://dx.doi.org/10.1088/0957-0233/11/2/404.

Full text

APA, Harvard, Vancouver, ISO, and other styles

11

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

12

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

13

Upendra, Siddamsetty, Siddamsetty Mahendra, and Poli Sivasankar Rao. "Two-way ANOVA Calculations Using MS-Excel." Research Journal of Science and Technology 9, no. 4 (2017): 532. http://dx.doi.org/10.5958/2349-2988.2017.00091.2.

Full text

APA, Harvard, Vancouver, ISO, and other styles

14

Holiachuk N. and Talakh Т. "ЕКОНОМІЧНА АНАЛІТИКА З ВИКОРИСТАННЯМФУНКЦІЙ ПРОГНОЗУВАННЯ MS EXCEL." Economic forum 1, no. 4 (November 24, 2021): 129–38. http://dx.doi.org/10.36910/6775-2308-8559-2021-4-18.

Full text

Abstract:

Показники рентабельності – це відносні показники, які застосовують для порівняння підприємств різних галузей, форм власності, розмірів, обсягів реалізації продукції та ін. Розрахунок показників рентабельності, оцінка ефективності господарювання за допомого них та розрахунок їх прогнозних величин з використанням MS Excel є важливим елементом оцінки фінансової діяльності кожного підприємства. В даний час використовуються різні підходи, методики розрахунку фінансових результатів діяльності підприємства, в тому числі з використанням функцій і можливостей MS Excel, а отже, змінюється характеристика даних показників, їх інтерпретація, умови розрахунків тощо. Використання таблиць Excel дає можливість не тільки розрахувати показники рентабельності підприємства, визначити тренд та побудувати графіки, які демонструють динаміку показників, а й розрахувати прогнозні показники рентабельності, що дасть можливість покращити менеджмент підприємства та спрямувати перспективи його розвитку. В статті дана характеристика наукових підходів до економічної сутності поняття «рентабельність» та системи показників, що характеризують рентабельність підприємства. З’ясовано, що всі вчені економісти одностайні у твердженні, що рентабельність – це показник ефективності фінансово-господарської діяльності підприємства і відображає відношення результату господарювання до його витрат. Проте немає єдиної думки про систему показників рентабельності. В статті виділено систему показників, за якою характеризується ефективність лісових господарств Волинської області. Проведено аналіз показників рентабельності за 9 років господарської діяльності п’яти лісових господарств. З’ясовано тренд підприємств і визначено, що розвиток підприємств відбувається за синусоїдою. Це дало можливість розрахувати та запропонувати до практичного застосування прогноз цих показників за допомогою використання функцій прогнозування TREND, FORECAST, GROWTH, LINEST. Обґрунтовано, що функції TREND, FORECAST, GROWTH, LINEST та Аркуш прогнозу дозволяють зробити «швидкий» прогноз зміни показників на будь-який період.

APA, Harvard, Vancouver, ISO, and other styles

15

Hrehova, Stella. "Introduction to MS Excel advanced techniques via e-learning." New Trends and Issues Proceedings on Humanities and Social Sciences 4, no. 1 (August 26, 2017): 255–60. http://dx.doi.org/10.18844/prosoc.v4i1.2263.

Full text

APA, Harvard, Vancouver, ISO, and other styles

16

Tsogoeva, Aida, Alan Tsogoev, and Madina Datieva. "METHODOLOGY OF SOLVING OPTIMIZATION PROBLEMS WITH MS EXCEL SOFTWARE." Proceedings of Irkutsk State Technical University 21, no. 12 (December 2017): 114–22. http://dx.doi.org/10.21285/1814-3520-2017-12-114-122.

Full text

APA, Harvard, Vancouver, ISO, and other styles

17

Toymurudov, Sh, L. Lugaev, and A. Hayrullaev. "Solving systems of linear equations using ms excel spreadsheet." Актуальные направления научных исследований XXI века: теория и практика 2, no. 4 (October 9, 2014): 151–55. http://dx.doi.org/10.12737/4726.

Full text

APA, Harvard, Vancouver, ISO, and other styles

18

Nugroho, Didit Budi, Bambang Susanto, and Mince M. M. Rosely. "Penggunaan MS Excel untuk Estimasi Model GARCH(1,1)." Jurnal Matematika Integratif 14, no. 2 (January 11, 2019): 71. http://dx.doi.org/10.24198/jmi.v14.n2.17680.71-82.

Full text

Abstract:

Permasalahan umum yang sering dijumpai dalam banyak studi keuangan yaitu volatilitas tak konstan untuk \emph{return} aset. Suatu pendekatan untuk memodelkan runtun waktu keuangan dengan heteroskedastisitas pada \emph{return} aset yaitu model GARCH. Studi ini bertujuan untuk menunjukkan bagaimana MS Excel dapat digunakan untuk mengestimasi model GARCH(1,1). MS Excel menawarkan suatu kemudahan penghitungan dan mungkin merupakan piranti yang paling banyak digunakan untuk menganalisis data keuangan. Untuk tujuan penyelidikan, studi ini mengadopsi data simulasi dan data riil kurs beli USD terhadap IDR periode 2010--2017. Parameter-parameter dalam model GARCH(1,1) diestimasi menggunakan metode likelihood maksimum dengan bantuan Solver yang tersedia di MS Excel. Hasil empiris pada data simulasi menunjukkan bahwa MS Excel menyediakan keakuratan yang baik untuk menaksir model GARCH(1,1). Aplikasi untuk data riil menghasilkan nilai-nilai optimal untuk model GARCH(1,1) yang serupa dengan yang dihasilkan oleh metode-metode MCMC menggunakan alat bantu Matlab.

APA, Harvard, Vancouver, ISO, and other styles

19

Nugroho, Didit Budi, Bambang Susanto, and Mince M. M. Rosely. "Penggunaan MS Excel untuk Estimasi Model GARCH(1,1)." Jurnal Matematika Integratif 14, no. 2 (January 11, 2019): 71. http://dx.doi.org/10.24198/jmi.v14i2.17680.

Full text

Abstract:

Permasalahan umum yang sering dijumpai dalam banyak studi keuangan yaitu volatilitas tak konstan untuk \emph{return} aset. Suatu pendekatan untuk memodelkan runtun waktu keuangan dengan heteroskedastisitas pada \emph{return} aset yaitu model GARCH. Studi ini bertujuan untuk menunjukkan bagaimana MS Excel dapat digunakan untuk mengestimasi model GARCH(1,1). MS Excel menawarkan suatu kemudahan penghitungan dan mungkin merupakan piranti yang paling banyak digunakan untuk menganalisis data keuangan. Untuk tujuan penyelidikan, studi ini mengadopsi data simulasi dan data riil kurs beli USD terhadap IDR periode 2010--2017. Parameter-parameter dalam model GARCH(1,1) diestimasi menggunakan metode likelihood maksimum dengan bantuan Solver yang tersedia di MS Excel. Hasil empiris pada data simulasi menunjukkan bahwa MS Excel menyediakan keakuratan yang baik untuk menaksir model GARCH(1,1). Aplikasi untuk data riil menghasilkan nilai-nilai optimal untuk model GARCH(1,1) yang serupa dengan yang dihasilkan oleh metode-metode MCMC menggunakan alat bantu Matlab.

APA, Harvard, Vancouver, ISO, and other styles

20

Gubina, S. "THE SOLUTION OF OPTIMIZATION PROBLEMS BY MEANS OF MATHCAD AND MS EXCEL." Актуальные направления научных исследований XXI века: теория и практика 2, no. 5 (November 11, 2014): 268–70. http://dx.doi.org/10.12737/6402.

Full text

APA, Harvard, Vancouver, ISO, and other styles

21

Ovsiienko, Yuliia I. "НАВЧАННЯ СТУДЕНТІВ-АГРАРІЇВ МАТЕМАТИЧНОЇ СТАТИСТИКИ ЗАСОБАМИ MS EXCEL." Information Technologies and Learning Tools 42, no. 4 (September 18, 2014): 94–108. http://dx.doi.org/10.33407/itlt.v42i4.1106.

Full text

Abstract:

У статті розкрито методику навчання студентів-аграріїв оцінки параметрів статистичного розподілу генеральної сукупності; проведення кореляційно-регресійного аналізу статистичних даних з агробіології у середовищі редактора електронних таблиць MS Excel. Запропонований алгоритм має не тільки загальний характер, а й кожен його етап проілюстровано на прикладі розв’язування задачі. Матеріал статті може бути використаний на практиці для опрацювання студентами експериментальних даних, одержаних дослідним шляхом; під час виконання завдань курсових і дипломних робіт бакалаврів або магістрів; у процесі розробки викладачами власного лабораторного практикуму для різних спеціальностей і напрямів підготовки.

APA, Harvard, Vancouver, ISO, and other styles

22

Peluso, Fabio, José González Castelain, Eduardo Usunoff, and Lorena Rodríguez. "Estimación probabilística del riesgo sanitario con MS Excel:." Cuadernos del CURIHAM 13 (December 21, 2007): 53–62. http://dx.doi.org/10.35305/curiham.v13i0.82.

Full text

Abstract:

El objetivo de este trabajo es presentar, a través de un ejemplo, cómo pueden utilizarse las potencialidades de MS Excel para realizar análisis de riesgo sanitario probabilístico. Se aplica a un caso de ingesta accidentalsubcrónica o crónica de agua, debida al uso recreativo de aguas naturales, utilizando al nitrato como sustancia peligrosa para la salud. El trabajo ofrece funciones complejas anidadas, desarrolladas en ese software de planilla de cálculo, con las cuales aplicar Monte Carlo para obtener las distribuciones de frecuencias, tanto de los parámetros definitorios de la exposición como las del riesgo. Los resultados indican que esas funciones complejas son un buen sustituto a operaciones efectuadas con software comercial desarrollado explícitamente para evaluaciones de riesgo. Sin resignar precisión de cálculo, se compensa la falta de opciones de menús específicas o las capacidades gráficas y analíticas ceñidas a esta temática, con la ubicuidad de Excel y su costo menor. Esto lo convierte en una opción factible para encarar estudios de riesgo sanitarios probabilísticos por parte de los responsables de la gestión de los recursos hídricos en los municipios, los que generalmente presentan recursos limitados que hacen improbable la compra de software de alto costo.

APA, Harvard, Vancouver, ISO, and other styles

23

Азиева, Л. Д. "ПРИМЕНЕНИЕ МАКРОСОВ MS EXCEL ДЛЯ РЕШЕНИЯ ПРИКЛАДНЫХ ЗАДАЧ." II Всероссийской научно-практической конференции «Digital Era», no. 2 (March 25, 2022): 28–39. http://dx.doi.org/10.36684/59-2022-2-28-39.

Full text

Abstract:

Средства разработки Microsoft Visual Basic предоставляют ряд входных данных через пользовательский интерфейс и редактор программ. Всегда есть какие-то задания для пользователей, которые используют функции в электронных таблицах. Для пользователей в программе Excel предлагается возможность создания удобных функций – макросов-программ, написанных на специальном языке Visual Basic. Visual Basic – очень полезный инструмент для разработки программ для операционных систем Microsoft Windows. В статье рассмотрены примеры разработки программ на языке Visual Basic для решения сопутствующих задач.

APA, Harvard, Vancouver, ISO, and other styles

24

Surkova, Lyudmila, and Denis Davydov. "INTERFACE INTERACTION OF THE BIM SOFTWARE WITH MS OFFICE." Construction and Architecture 9, no. 4 (December 18, 2021): 66–70. http://dx.doi.org/10.29039/2308-0191-2021-9-4-66-70.

Full text

Abstract:

The paper examines the necessity and possibility of interface interaction of the information modeling program Revit Autodesk with the common office program MS Excel. Such interaction makes it easier to prepare project documentation in accordance with the requirements of Russian standards, GOST. An analysis of the capabilities of the built-in Revit tools for creating specifications and their design according to GOST requirements showed an insufficient level of automation of these processes. Ready-made foreign and Russian solutions in the field of Revit plugins that implement interaction with Excel have a number of disadvantages. The purpose of this article is to demonstrate the capabilities of the application programming interface (API) for creating applications using the example of a developed software solution for automating the unloading of information from a BIM model into an Excel electronic document, in order to bring data presentation standards in line with GOST requirements. The application is developed using a tool environment: the C# programming language, the MS Visual Studio development environment, the WPF user interface creation tool, the Revit-side application programming interface .Net API, an interface for interacting with Excel ClosedXML files. As a result, the interface of the developed plugin is presented. The program allows you to export documents-statements and specifications - to Excel, designed according to the requirements of GOST. The user-friendly tab-based user interface, the compliance of the program design with the Revit system and the implemented functionality give the program advantages over its analogues. The application is available for free download to any Revit user, which is of practical importance.

APA, Harvard, Vancouver, ISO, and other styles

25

Sari, Rafika, Aida Fitriyani, and Rosiana Disiati Prabandari. "Optimalisasi Penggunaan MS. Word dan MS. Excel Pada Siswa SMP PGRI Astra Insani Bekasi." Jurnal Pengabdian kepada Masyarakat UBJ 3, no. 2 (June 30, 2020): 95–104. http://dx.doi.org/10.31599/jabdimas.v3i2.184.

Full text

Abstract:

The utility of information technology in this case Computers in the world of education are very important. The use of information technology, in this case, is to utilize the use of word and data processing software applications that are easy and powerful while still making it easier for students and teachers to do material editing. As one of the schools that is concerned in creating a systematic, interesting and friendly learning process, SMP PGRI Astra Insani Bekasi, has a computer practice room that is used to deliver learning material every day. Microsoft Office Word and Excel can be maximized by using the facilities in it. The optimization program for the two Microsoft Office applications aims to explore and explore more about the features that exist in the two Microsoft Office applications, which students may not have been familiar with before. By utilizing and maximizing features on find text, replace text, autocorrect, create and edit tables, introduce MS features. Excel and activate the menus that are in it, so that it helps the teacher's role in maximizing student knowledge of the lessons delivered. Keywords: computer training, MS. Word, MS. Excel, junior school student Abstrak Peran teknologi informasi dalam hal ini komputer di dunia pendidikan sangatlah penting. Penggunaan teknologi informasi dalam kasus ini adalah dengan memanfaatkan penggunaan software aplikasi pengolah kata dan data yang mudah dan powerfull dengan tetap mempermudah siswa dan guru untuk melakukan editing materi. Sebagai salah satu sekolah yang konsen dalam menciptakan proses pembelajaran yang sistematis, menarik, dan penuh keramahan, SMP PGRI Astra Insani Bekasi, telah memiliki ruang praktek komputer yang digunakan untuk menyampaikan materi pelajaran setiap harinya. Microsoft Office Word dan Excel dapat dimaksimalkan penggunaanya dengan memanfaatkan fasilitas-fasilitas di dalamnya. Program pelatihan pengoptimalan dua aplikasi Microsoft Office ini bertujuan untuk menggali dan mengeksplorasi lebih jauh mengenai fitur-fitur yang ada pada dua aplikasi Microsoft Office tersebut, yang mungkin sebelumnya siswa-siswi belum mengenal fitur-fitur tersebut. Dengan memanfaatkan dan memaksimalkan fitur pada find text, replace text, auto correct, membuat dan menyunting tabel, pengenalan fitur-fitur pada MS. Excel serta mengaktikan menu-menu yang ada didalamnya, sehingga turut membantu peran guru dalam memaksimalkan pengetahuan siswa terhadap pelajaran yang disampaikan. Kata kunci: pelatihan komputer, MS. Word, MS. Excel, siswa SMP

APA, Harvard, Vancouver, ISO, and other styles

26

Lukáč, Stanislav, and Radovan Engel. "Technology Tips: Using MS Excel to Simulate Coin Tossing." Mathematics Teacher 101, no. 8 (April 2008): 614–16. http://dx.doi.org/10.5951/mt.101.8.0614.

Full text

Abstract:

Understanding the basic principles of the theory of probability can be challenging for students. Gelman and Nolan (2002) emphasize the importance of illustrating basic principles of the theory of probability through unusual stories and problems. Tossing coins and throwing dice are sure ways to provoke student interest and create teaching moments. In addition, the use of technology in association with the simulation of random events and data analysis can also increase student interest. An important advantage of modern technology is that a large number of random experiments can be accomplished during a short time, creating the possibility of using advanced numeric and graphic tools for processing the acquired results.

APA, Harvard, Vancouver, ISO, and other styles

27

Horda, Iryna M., and Leonid O. Flehantov. "КОМП’ЮТЕРНЕ МОДЕЛЮВАННЯ ПРОЦЕСУ МЕХАНІЧНОГО РУХУ ТІЛА ЗАСОБАМИ MS EXCEL." Information Technologies and Learning Tools 47, no. 3 (June 6, 2015): 99. http://dx.doi.org/10.33407/itlt.v47i3.1245.

Full text

Abstract:

The mathematical model of body motion is analyzed, thrown at the angle to the horizon in a gravitational field and its computer realization with the help of MS Excel means. The recommended technique allows during laboratory work analyze mechanical body motion, carry out calculable experiments, changing the outgoing model parameters such as initial posture, location purposes, geometric dimensions of ball and basket, initial velocity and angle, and also acceleration of gravity; explore the mechanical motion in hypothetical conditions that are difficult to implement in practice. Using this technique promotes logical thinking development of students, motivation to learn the subject, interest, better learning of basic theoretical positions, skills forming of research activity.

APA, Harvard, Vancouver, ISO, and other styles

28

Дейнека, Виктор Иванович, Александр Владимирович Туртыгин, Ван Ань Нгуен, Елена Юрьевна Олейниц, and Людмила Александровна Дейнека. "Использование MS Excel для обработки неразделенных пиков на хроматограммах." Сорбционные и хроматографические процессы 20, no. 2 (May 12, 2020): 249–56. http://dx.doi.org/10.17308/sorpchrom.2020.20/2779.

Full text

Abstract:

В работе на примере триацилглицеринов льняного масла и антоцианов плодов винограда сортаМолдова предложен способ компьютерного моделирования не полностью разделенных пиков с использованием программы MS Excel. Благодаря предложенному способу для неразделенных пиков возможен расчет таких параметров как число теоретических тарелок, разрешение пиков, количественное определение не полностью разделяющихся веществ. Полученные результаты сопоставляются с результатами, получаемыми стандартными для программного обеспечения хроматографов способами. Показано, что при существенном различии «полуширин» неразделенных пиков корректное соотношение между их содержанием может быть рассчитано только после их разделения гауссовыми функциями. Установлено, что дополнительное уширение возможно в том случае, если пик объединяет два изомера (например, изомеров положения триацилглицеринов) с небольшим различием удерживания между ними. Эмпирически установлено, что небольшое отклонение хроматографических пиков исследованных объектов от Гауссового распределения может быть компенсировано добавлением небольшого пика с большим временем удерживания, параметры которого могут быть подобраны при компьютерном моделировании пика в программе MS Excel.

APA, Harvard, Vancouver, ISO, and other styles

29

Yang, Bin, Xingming Sun, Lingyun Xiang, Zhiqiang Ruan, and Ruizhen Wu. "Steganography in Ms Excel Document using Text-rotation Technique." Information Technology Journal 10, no. 4 (March 15, 2011): 889–93. http://dx.doi.org/10.3923/itj.2011.889.893.

Full text

APA, Harvard, Vancouver, ISO, and other styles

30

Vertat, Petr, and Jan Drahokoupil. "FITEXC – DIFFRACTION PROFILE FITTING PROGRAM RUN IN MS EXCEL." Acta Polytechnica CTU Proceedings 17 (June 26, 2018): 20. http://dx.doi.org/10.14311/app.2018.17.0020.

Full text

Abstract:

We present our custom made diffraction fitting program FitExc for the basic treatment of the 1D diffraction profiles, in particular, the Intensity(2θ) of X-ray, synchrotron or neutron diffraction measurements. In the current state, the program allows for simultaneous fitting of up to three profiles in one data set and is intended to be used mainly for precise lattice parameters determination or fitting of overlapped peaks. The entire program is built in the common MS Excel environment, it does not require any installation and is free to use.

APA, Harvard, Vancouver, ISO, and other styles

31

Raabe, Oliver. "Schnittgrößenermittlung bei Sandwichbauteilen mit Hilfe von MS-EXCEL®." Stahlbau 73, no. 1 (January 2004): 59–60. http://dx.doi.org/10.1002/stab.200490033.

Full text

APA, Harvard, Vancouver, ISO, and other styles

32

Shoji, Tetsuya. "Drawing of Wulff net and Stereographic Projection by MS-Excel." Geoinformatics 11, no. 2 (2000): 128–29. http://dx.doi.org/10.6010/geoinformatics1990.11.2_128.

Full text

APA, Harvard, Vancouver, ISO, and other styles

33

Tanavalee, Chotetawan, Panya Luksanapruksa, and Weerasak Singhatanadgige. "Limitations of Using Microsoft Excel Version 2016 (MS Excel 2016) for Statistical Analysis for Medical Research." Clinical Spine Surgery 29, no. 5 (June 2016): 203–4. http://dx.doi.org/10.1097/bsd.0000000000000382.

Full text

APA, Harvard, Vancouver, ISO, and other styles

34

Sekhar, V., K. Umakrishna, V. Srinivasa Rao, and Ch Satyavani. "Completely Randomised Design (CRD) Analysis – by Manual and MS-Excel." International Journal of Current Microbiology and Applied Sciences 8, no. 03 (March 10, 2019): 954–59. http://dx.doi.org/10.20546/ijcmas.2019.803.114.

Full text

APA, Harvard, Vancouver, ISO, and other styles

35

Chen, Li Jun, Xue Wei Bai, and Xing Gang Wang. "Dynamic Simulation of Four-Bar Mechanism Based on MS Excel." Applied Mechanics and Materials 635-637 (September 2014): 1561–64. http://dx.doi.org/10.4028/www.scientific.net/amm.635-637.1561.

Full text

Abstract:

In this paper, Four-bar mechanism is included to analyze the typical motion characteristic of mechanic design. A model is developed using MS Excel, and three dynamic visualized algorithms are employed with simple and convenient function modules within the software. Emphasis is placed on the establishment of model and the comparison between different approaches to simulate.

APA, Harvard, Vancouver, ISO, and other styles

36

Berardi, L., D. Laucelli, L. Ridolfi, and O. Giustolisi. "WQNetXL: A MS-excel Water Quality System Tool for WDNs." Procedia Engineering 89 (2014): 262–72. http://dx.doi.org/10.1016/j.proeng.2014.11.186.

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

Kelesoglu, Omer, and Mehmet Ulker. "Multi-objective fuzzy optimization of space trusses by Ms-Excel." Advances in Engineering Software 36, no. 8 (August 2005): 549–53. http://dx.doi.org/10.1016/j.advengsoft.2005.02.001.

Full text

APA, Harvard, Vancouver, ISO, and other styles

39

Ismail, Siti Zubaidah, and Abdulsalam Khaled Abdullah Al-Hadi. "Developing Palm Oil Inventory Control System Using Ms Excel Macro." Journal of Modern Manufacturing Systems and Technology 5, no. 1 (March 19, 2021): 51–55. http://dx.doi.org/10.15282/jmmst.v5i1.6102.

Full text

Abstract:

The palm oil sector is just one of the popular sectors in Malaysia that offer one of the highest exports to Malaysia's economy. This study handles the research study of inventory control for Malaysian palm oil plantation. The existing inventory control cannot be running smoothly when the inventory are managed in different user interface systems which is by utilizing manual inventory control like Microsoft Excel and handwriting documents. Data collection was gathered with the targeted respondents, they are core members of the management team who have a great experience as well as understanding of their inventory system. In order to make PSS inventory control much easier as well as organized, an inventory application system is developed utilizing MS Excel Macro. The outcomes of this research study are a computerized supply control system that beneficial, crucial, and also much better substitute for a hand-operated administration system and quick handling.

APA, Harvard, Vancouver, ISO, and other styles

40

Grachev, V. V. "USING MATHCAD AND MS EXCEL TO SOLVE AN INDIVIDUAL TYPE OF CHEMISTRY PROBLEMS." Informatics in school, no. 10 (December 23, 2019): 51–54. http://dx.doi.org/10.32517/2221-1993-2019-18-10-51-54.

Full text

Abstract:

The article discusses the possibility of using software products the computer mathematics system Mathcad and the spreadsheet processor MS Excel in chemistry — to solve the problem of selecting coefficients in the equations of redox reactions after its mathematical formulation. The example of solving a specific problem by means of Mathcad and MS Excel is analyzed in detail.

APA, Harvard, Vancouver, ISO, and other styles

41

Bin, Jung-In, and Byung-Hun Lee. "Modelling of effluent and GHGs for wastewater treatment plants using by MS Excel simulator(PKES)." Journal of the Korean Society of Water and Wastewater 28, no. 6 (December 30, 2014): 735–45. http://dx.doi.org/10.11001/jksww.2014.28.6.735.

Full text

APA, Harvard, Vancouver, ISO, and other styles

42

BORŽÍKOVÁ, Jana. "SOME RESULTS AND CONCLUSIONS OF THE RESEARCH OF TEACHING APPLIED MATHEMATICS EFFICIENCY BY MS EXCEL." Journal of Technology and Information 1, no. 3 (December 1, 2009): 70–75. http://dx.doi.org/10.5507/jtie.2009.057.

Full text

APA, Harvard, Vancouver, ISO, and other styles

43

Lee, Yoonmi, Hyunji Chung, and Sangjin Lee. "A Study on Edit Order of Text Cells on the MS Excel Files." Journal of the Korea Institute of Information Security and Cryptology 24, no. 2 (April 30, 2014): 319–25. http://dx.doi.org/10.13089/jkiisc.2014.24.2.319.

Full text

APA, Harvard, Vancouver, ISO, and other styles

44

Antipina, Nataliya M., Vladimir N. Zakharov, Yury M. Protasov, and Vladimir M. Yurov. "NON-PARAMETRIC CRITERION OF DIFFERENCE FOR TWO RELATED SAMPLES IN TABLE EDITOR MS EXCEL." Bulletin of the Moscow State Regional University (Economics), no. 2 (2021): 47–55. http://dx.doi.org/10.18384/2310-6646-2021-2-47-55.

Full text

APA, Harvard, Vancouver, ISO, and other styles

45

Yurov, Vladimir M. "A HARMONIC ANALYSIS-BASED TECHNIQUE FOR FORECASTING PERIODIC ECONOMIC PROCESSES IN MS EXCEL." Bulletin of the Moscow State Regional University (Economics), no. 3 (2018): 19–28. http://dx.doi.org/10.18384/2310-6646-2018-3-19-28.

Full text

APA, Harvard, Vancouver, ISO, and other styles

46

Samsinar, Samsinar, Titin Fatimah, Dolly Virgian Shaka Yudha Sakti, and Pipin Farida Ariyani. "Pengembangan Kapasitas Teknologi Informasi Pegawai Kanwil DJP Jakarta Selatan II Melalui Pelatihan Ms. Excel Tingkat Dasar." Jurnal Karya Abdi Masyarakat 4, no. 3 (January 1, 2021): 643–49. http://dx.doi.org/10.22437/jkam.v4i3.11589.

Full text

Abstract:

Tidak semua staf yang bekerja di bawah DJP Jakarta Selatan II memiliki tugas yang wajib bersentuhan dengan teknologi. Sehingga banyak dari staf tersebut yang membutuhkan penyegaran terhadap pengetahuan terkait teknologi, khususnya tentang MS Excel tingkat dasar. Mitra PPM sangat membutuhkan beberapa hal diantaranya membutuhkan penyegaran kembali pengetahuan tentang Microsoft Excel tingkat dasar. Pelatihan Microsoft Excel tingkat dasar menjadi solusi untuk dapat menyegarkan kembali pengetahuan para staf yang dimiliki mitra terkait Microsoft Excel tingkat dasar.

APA, Harvard, Vancouver, ISO, and other styles

47

Puspita, Desi. "Pelatihan Pembuatan Aplikasi Pengolahan Nilai Dengan MS. Excel Bagi Guru Sma Negeri 2 Pagar Alam." NGABDIMAS 2, no. 1 (June 3, 2019): 39–43. http://dx.doi.org/10.36050/ngabdimas.v2i1.225.

Full text

Abstract:

Pengolahan nilai siswa SMAN 2 Kota Pagaralam saat ini dilakukan dengan cara manual, seluruh data dihitung tiap komponen disatukan dan dijumlah menjadi satu diambil rata-rata nantinya didapatkan nilai akhir. Permasalahan ini menjadi titik kelemahan karena guru pelajaran menjadi lambat mengumpulkan nilai siswa. Sehingga pimpinan SMAN 2 Pagaralam berusaha meminimalisir dan meminta civitas (dosen) STTP untuk mengadakan pelatihan pengolahan data nilai menggunakan excel, dengan semangat berbagi ini maka melalui LPPM STTP mengadakan pengabdian pelatihan pengolahan nilai. Pelatihan dilakukan dengan metode penjelasan dan praktek langsung dengan excel, diawali dengan penyiapan data yang diolah dilanjutkan dengan penjelasan dan contoh menggunakan aplikasi dengan excel, agar pelatihan berjalan dengan baik maka dilakukan terlebih dahulu tes pendahuluan untuk mengetahui pemahaman peserta pelatihan terhadap teknik pengolahan data menggunakan excel dan hasilnya mereka rata-rata belum baik dalam pemahaman penggunaan excel hanya pernah menggunakannya saja, berikutnya setelah pelatihan dinyatakan selesai dilakukan lagi tes untuk mengetahui efektifitas pelaksanaan pelatihan dan hasilnya sesuai dengan materi yang disampaikan 100% peserta pelatihan dapat menerima materi pelatihan dan sangat memahaminya sehingga peserta mampu mengolah data nilai menggunakan excel dengan baik.

APA, Harvard, Vancouver, ISO, and other styles

48

Chowdhury, Pinaki. "Preparing Modified Bonding Representations Inventory: Challenges and Solution." Indonesian Journal Of Educational Research and Review 4, no. 3 (December 17, 2021): 441. http://dx.doi.org/10.23887/ijerr.v4i3.41639.

Full text

Abstract:

Collecting data on learners' performance in different chemistry contents and analysing them to identify their knowledge and understanding in related content areas is a major task of Chemistry Education Research. The data collection process on the learners' content knowledge and understanding of content knowledge requires a standard measuring tool. The preparation of standardized tools for measuring academic achievement requires computer software. All software used in the standardization of a tool comes at a cost and requires training for the researcher involved in handling the situation, which can impede the smooth running of a project. The same was the situation when the author was working on modifying the bonding representations inventory (BRI) for its local use in South Africa. The data analysis laboratory was situated in a different city, 500 km away from the researcher's field of work. Owing to the long distance and communication delay, the author was concerned with delays in the project. It is known that necessity, which can create an opportunity. The Microsoft Excel (MS-Excel) platform was used for standardizing the modified BRI because MS-Excel is available as a standard in MS-Office on the Windows platform. This paper presents a fact. That, a tool can be standardized by using MS-Excel without any complexity.

APA, Harvard, Vancouver, ISO, and other styles

49

Widianawati, Evina. "OPTIMALISASI PENGGUNAAN MS EXCEL TERHADAP KEPEKAAN DATA INFORMASI KESEHATAN DI POSYANDU." Jurnal Manajemen Informasi Kesehatan Indonesia 8, no. 1 (March 16, 2020): 92. http://dx.doi.org/10.33560/jmiki.v8i1.261.

Full text

APA, Harvard, Vancouver, ISO, and other styles

50

Данилов, Игорь Лолиевич, and Наталья Ивановна Егорова. "Лабораторный практикум по физике на основе моделирования в среде MS Excel." Информационное общество: образование, наука, культура и технологии будущего, no. 1 (June 19, 2017): 104–13. http://dx.doi.org/10.17586/2587-8557-2017-1-104-113.

Full text

APA, Harvard, Vancouver, ISO, and other styles

Journal articles on the topic 'MS Excel'

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