scholarly journals Creating an electronic textbook in EXCEL using the VBA programming language

2020 ◽  
pp. 18-30
Author(s):  
Tatyana Nikolaevna Romanchenko
Keyword(s):  
Programming Language ◽  
Visual Display ◽  
Visual Basic ◽  
Educational Process ◽  
Structural Components ◽  
Automatic Data ◽  
Smooth Curves ◽  
Electronic Textbook ◽  
Visual Basic For Applications ◽  
Visual Demonstration

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.

scholarly journals The role of a multimedia textbook in the priority national project “education”

2021 ◽  
Vol 94 ◽  
pp. 02010
Author(s):  
Elena Vasilenko ◽  
Pavel Vasilenko
Keyword(s):  
Visual Display ◽  
Educational Process ◽  
Electronic Publication ◽  
Electronic Textbooks ◽  
National Project ◽  
Modern Education ◽  
Electronic Textbook ◽  
Opportunities For Learning ◽  
Text Illustrations

In the article, the authors consider the role of a multimedia textbook in modern education. The priority national project "Education" is being implemented in Russia - the creation and implementation of modern electronic textbooks is one of the priority concepts in this project. Electronic publications enhance interactive features such as modeling, surveys, discussions, and additional multimedia materials. Advantages of electronic textbooks: mobility, large capacity of information; the ability to constantly update content, without purchasing a new textbook and financial expenses; level of visibility: you can only put text, illustrations, diagrams and graphs in a printed publication, but you can also put animation in an electronic publication, which is convenient for visual display of academic subjects. The electronic textbook provides more opportunities for learning within the existing programs, as well as for the development and optimization of the educational process.

scholarly journals Rancang Bangun Sistem Informasi Inventory Berbasis Client Server pada PT Arpan Bali Utama di Denpasar

2020 ◽  
Vol 10 (3) ◽  
pp. 94-102
Author(s):  
Ayu Dwi Setiawati ◽  
◽  
I Made Dwi Jendra Sulastra ◽  
Keyword(s):  
Information System ◽  
Programming Language ◽  
Input Data ◽  
Visual Basic ◽  
Data Input ◽  
Client Server ◽  
Microsoft Access ◽  
Visual Basic For Applications ◽  
Data Search ◽  
Industrial Company

PT Arpan Bali Utama as an industrial company must always be responsive to the company's needs, because the company's production supplies the existing inventory. In this study, the design of an inventory information system for stock opname and warehouse card activities at PT Arpan Bali Utama. The design of this inventory information system is intended to solve problems related to the management of stock opname data and warehouse cards, both in data input and in computerization of stock opname reports and warehouse cards. This system was developed using the Visual Basic for Applications (VBA) programming language and a database developed using the Microsoft Access 2016 application. The results obtained from this study are an inventory information system designed to assist accounting and warehouse departments in carrying out stock opname activities. data input, data search, and production of stock opname reports and warehouse cards. In addition, this system can also help the accounting department through warehouse cards to see the movements of goods in the warehouse.

The Use of Information and Communication Technologies in the Educational Process: Achievements, Problems, Prospects

2018 ◽  
Vol 79 (9) ◽  
pp. 3-6
Author(s):  
I. V. Merzlikina
Keyword(s):  
Information And Communication Technologies ◽  
Communication Technologies ◽  
Educational Process ◽  
Electronic Textbook ◽  
Information And Communication

The article deals with the problems of informatization of education, proposes ways to solve these problems, clarifies the functions of electronic textbook and electronic applications to the textbook.

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.

scholarly journals Optimization of material delivery time analysis by using Visual Basic for applications in Excel

2021 ◽  
Vol 2 (2) ◽  
pp. 89
Author(s):  
Muhammad Ali Khan ◽  
Muhammad Ahmed Kalwar ◽  
Abdul Karim Chaudhry
Keyword(s):  
Small And Medium Enterprises ◽  
Visual Basic ◽  
Delivery Time ◽  
Time Analysis ◽  
Monthly Basis ◽  
Visual Basic For Applications ◽  
Manual Tasks ◽  
Medium Enterprises ◽  
Automated Methods ◽  
Planning Production

<p>In small and medium enterprises, huge numbers of reports are prepared regarding the procurement, planning, production etc on daily, weekly, monthly, quarterly and yearly basis. If the interval between preparation of same report is longer then there is the greater probability that employee can forget the procedure of preparing the report; thus it is beneficial to automate these types of reports especially when there is no cost required for automation. In the same way, material delivery analysis is a kind of report which is prepared on monthly basis and as per the employees` feedback they usually forget some of the steps of report formation; therefore, there was the chance of mistake at the end of employee. Therefore, this report was automated for to minimize the chance of error and report preparation time. All the manual tasks were enlisted and were programmed for automation by the help of VBA macros. For the execution of macros, userform was designed in visual basic editor (in MS excel) consisted on four command buttons and macros were called on command buttons` click. On pressing ‘ctrl + q’ userform used to appear on the screen. Furthermore, the comparison of old and automated methods was conducted to reflect the best suitable method. The report used to take 1.55 minutes to be made manually. Comparison of time of both methods of report formation indicated that suggested method took 70.86% less time as compared to the old method of preparing material delivery time analysis report.</p>

scholarly journals DEVELOPMENT AND TESTING OF ALGORITHM FOR CALCULATION OF OPERATING PARAMETERS OF TRAWLING SYSTEMS

2019 ◽  
Vol 198 ◽  
pp. 221-229 ◽  
Author(s):  
E. A. Zakharov ◽  
O. N. Kruchinin ◽  
D. L. Shabelsky
Keyword(s):  
Experimental Data ◽  
Visual Basic ◽  
Educational Process ◽  
Resistance Force ◽  
Operating Parameters ◽  
Calculation Algorithm ◽  
Model Application ◽  
Bottom Trawling ◽  
Good Convergence ◽  
Expansion Force

Numerical model of trawling system is developed on the base of equilibrium principle, using F.I. Baranov’s scheme of its power and geometric parameters interdependence. The model application to bottom trawling takes into account the effect of bottom grounds on the resistance force and expansion force of the trawling system. Algorithm is proposed for calculation of operating parameters of bottom and midwater trawls, with an operation to minimize the error of iteration. The model and the calculation algorithm were tested in MS Office Excel environment, using Visual Basic programming, and showed good convergence of the calculated and experimental data that indicates reliability of the model. This algorithm and the program for calculation of operating parameters could be used for trawl designing, in accounting surveys to determine the trawl opening, and in educational process for training the industrial fishery scholars.

Sign in / Sign up

Export Citation Format

Share Document