The issues of interdisciplinary interaction of the courses "Computer Science" and "Descriptive geometry" in technical universities are considered. The features of the construction of the Computer Science course for students of construction specialties are presented and ways to expand the practical part of this course by digital methods of solving problems of descriptive geometry are discussed. In the VBA Excel programming language, the authors have developed virtual tools for obtaining intersection points of elementary geometric shapes. Based on the use of these tools, a methodology is proposed for solving some problems of descriptive geometry using information technology, but already within the framework of the Computer Science course aimed at students of construction specialties. The solution of problems of descriptive geometry in the environment of the Excel spreadsheet editor in “semi-manual” mode, without programming, followed by three-dimensional visualization in electronic drawing programs, is considered. A technology has been developed for transferring graphical information from the Excel spreadsheet editor to electronic drawing systems for visual visualization of the solution of descriptive geometry problems performed using digital modeling on an Excel sheet. The article describes a methodology for developing application software based on VBA Excel for solving problems of descriptive geometry with a minimum set of input information and a full cycle of automation of building a digital model of geometric objects. Examples of the work of applied surface intersection modeling programs in VBA Excel are given. The features of the software implementation of descriptive geometry algorithms in C++ using the OpenGL graphics library for students of IT specialties with a training focus on the development of applied software for engineer ing calculations are considered. Examples of students' term papers with programs implementing descriptive geometry methods are given.
descriptive geometry, digital modeling, computer science, tabular editor, secant plane, programming language, graphic library
1. Abutalipov R.N. Excel ot X do L [Tekst] / R.N. Abutalipov. — M.: GrossMedia, 2017. — 392 c.
2. Andreev G.N. Vychislitel'naya matematika [Tekst] / G.N. Andreev. — M.: Izd-vo MGIU, 2007. — 166 c. EDN: https://elibrary.ru/QJSLZF
3. Asharina I.V. Osnovy programmirovaniya na yazykah S i S++: Kurs lekciy dlya vysshih uchebnyh zavedeniy [Tekst] / I.V. Asharina. — M.: Goryachaya liniya — Telekom, 2018. — 208 c.
4. Baldin K.V. Informatika dlya VUZov [Tekst]: Uchebnik / K.V. Baldin, V.B. Utkin. — M.: Dashkov i K, 2016. 395 c.
5. Bol'shakov V.P. Osnovy 3D-modelirovaniya. Izuchaem rabotu v AutoCAD, KOMPAS-3D, SolidWorks, Inventor [Tekst] / V.P. Bol'shakov, A.L. Bochkov. — M.: Piter, 2016. — 304 c.
6. Boreskov A.V. Rasshireniya OpenGL (+ CD-ROM) [Tekst] / A.V. Boreskov. — M.: BHV-Peterburg, 2016. 113 c.
7. Bugrimenko G.A. Avtolisp — yazyk graficheskogo programmirovaniya v sisteme AutoCAD [Tekst] / G.A. Burgimenko — M.: Mashinostroenie, 1992. — 144 s.
8. Velihov A.S. Osnovy informatiki i komp'yuternoy tehniki: ucheb. posobie [Tekst] / A.S. Velihov. — M.: SOLON-Press, 2017. — 539 s.
9. Vyshnepol'skiy V.I. Metodicheskaya sistema provedeniya zanyatiy na kafedre «Inzhenernaya grafika» RTU MIREA [Tekst] / V.I. Vyshnepol'skiy, A.A. Boykov, K.T. Egiazaryan, N.S. Kadykova // Geometriya i grafika. — 2023. — T. 11. — № 1. — S. 23–34. — DOI:https://doi.org/10.12737/2308-4898-2023-11-1-23-24 DOI: https://doi.org/10.12737/2308-4898-2023-11-1-23-34; EDN: https://elibrary.ru/BCSTZQ
10. Gavrikov M.M. Teoreticheskie osnovy razrabotki i realizacii yazykov programmirovaniya [Tekst]: ucheb. posobie / M.M. Gavrikov, A.N. Ivanchenko, D.V. Grinchenkov. — M.: KnoRus, 2016. — 184 c. EDN: https://elibrary.ru/JMFPCI
11. Ginsburg D. OpenGL ES 3.0. Rukovodstvo razrabotchika [Tekst] / D. Ginsburg. — M.: DMK Press, 2019. — 748 c.
12. Gladkov S.A. Programmirovanie na yazyke Avtolisp v sisteme SAPR Avtokad [Tekst] / S.A. Gladkov. — M.: DIALOG-MIFI, 1991. — 96 s.
13. Golicyna O.L. Yazyki programmirovaniya [Tekst]: ucheb. posobie / O.L. Golicyna, T.L. Partyka, I.I. Popov. M.: Forum, INFRA-M, 2017. — 400 c.
14. GOST 19.701-90 (ISO 5807-85). ESPD. Shemy algoritmov, programm, dannyh, sistem. Uslovnye oboznacheniya i pravila vypolneniya. Izd. standartov, 1991. — 26 s.
15. Zaharov A.A. Soderzhanie kursa «geometricheskoe modelirovanie» dlya napravleniya podgotovki «matematika i komp'yuternye nauki» [Tekst] / A.A. Zaharov, Yu.V. Zaharova // Geometriya i grafika. — 2021. — T. 9. — № 4. S. 35–45. — DOI:https://doi.org/10.12737/2308-4898-2022-9-4-35-45 EDN: https://elibrary.ru/ZKXTJQ
16. Ignat'ev S.A. Vizualizaciya zadach nachertatel'noy geometrii posredstvom Wolfram Mathematica [Tekst] / S.A. Ignat'ev, A.I. Folomkin, E.H. Muratbakeev // Geometriya i grafika. — 2020. — T. 8. — № 4. — S. 74– DOI: https://doi.org/10.12737/2308-4898-2021-8-4-74-84; EDN: https://elibrary.ru/RNWEWF
17. — DOI:https://doi.org/10.12737/2308- 4898-2021-8-4-74-84
18. Ignat'ev S.A. Povyshenie naglyadnosti predstavleniya izuchaemyh v nachertatel'noy geometrii ob'ektov [Tekst] / S.A. Ignat'ev, E.H. Muratbakeev, M.V. Voronina // Geometriya i grafika. — 2022. — T. 10. — № 1. S. 44–53. — DOI:https://doi.org/10.12737/2308-4898-2022-10-1-44-53 EDN: https://elibrary.ru/CZOCAK
19. Ignat'ev S.A. Tehnologii dopolnennoy real'nosti v proektnoy deyatel'nosti studentov [Tekst] / S.A. Ignat'ev, Z.O. Tret'yakova, M.V. Voronina // Geometriya i grafika. — 2020. — T. 8. — № 2. — S. 51–57. — DOI:https://doi.org/10.12737/2308-4898-2020- 51-57 DOI: https://doi.org/10.12737/2308-4898-2020-51-57; EDN: https://elibrary.ru/VZDURR
20. Kimmel P. Excel 2003 i VBA. Spravochnik programmista [Tekst] / P. Kimmel. — M.: Vil'yams, 2017. 725 c.
21. Kopchenova N.V. Vychislitel'naya matematika v primerah i zadachah [Tekst]: uchebnoe posobie / N.V. Kopchenova, I.A. Maron. — SPb.: Lan', 2017. — 368 c.
22. Krylov N.N. Nachertatel'naya geometriya [Tekst] / N.N. Krylov, P.I. Lobandievskiy, S.A. Men, V.L. Nikolaev, G.S. Ikonnikova — M.: Vysshaya shkola, 1977. 231 s.
23. Krylov N.N. Nachertatel'naya geometriya [Tekst] / N.N. Krylov, G.S. Ikonnikova, V.L. Nikolaev, V.S. Vasil'ev. — M.: Vysshaya shkola, 1990. — 240 s.
24. Kuvshinov N.S. Proektirovanie v Platforme nanoCAD s modulyami «Mehanika» i «3D» [Tekst]: ucheb. posobie / N.S. Kuvshinov. — M.: DMK Press, 2023. — 384 s.
25. Kuvshinov N.S. NanoCAD Mehanika. Inzhenernaya 2D i 3D komp'yuternaya grafika [Tekst]: ucheb. posobie / N.S. Kuvshinov. — M.: DMK Press, 2020. — 528 s.
26. Kudryavcev N.G. Programmirovanie na VBA MS Excel [Tekst]: uchebnoe posobie / N.G. Kudryavcev, D.V. Kudin, M.Yu. Belikova. — Gorno-Altaysk: Izd-vo GAGU, 2015. 116 s.
27. Leparov M.N. O geometrii, esche odin raz [Tekst] / M.N. Leparov // Geometriya i grafika. — 2022. — T. 10. № 1. — S. 3–13. — DOI:https://doi.org/10.12737/2308-4898-2022-101-3-13 DOI: https://doi.org/10.12737/2308-4898-2022-10-1-3-13; EDN: https://elibrary.ru/ROPUTY
28. Macuda Koichi. WebGL. Programmirovanie trehmernoy grafiki [Tekst] / Koichi Macuda, Rodzher Li. M.: DMK Press, 2015. — 494 c.
29. Pogorelov V.I. AutoCad. Trehmernoe modelirovanie i dizayn [Tekst] / V.I. Pogorelov — SPb.: BHV, 2017. 272 c.
30. Pavlovskaya T.A. C/S++. Programmirovanie na yazyke vysokogo urovnya [Tekst] / T.A. Pavlovskaya — SPb.: Piter, 2011.
31. Sal'kov N.A. Nachertatel'naya geometriya. Osnovnoy kurs [Tekst]: ucheb. posobie / N.A. Sal'kov. — M.: INFRA-M, 2014. — 235 s. EDN: https://elibrary.ru/VEIEXJ
32. Sal'kov N.A. Nachertatel'naya geometriya — baza dlya komp'yuternoy grafiki [Tekst] / N.A. Sal'kov // Geometriya i grafika. — 2016. — T. 4. — № 2. — S. 37–47. DOI:https://doi.org/10.12737/19832 EDN: https://elibrary.ru/WJEJOL
33. Sal'kov N.A. Osnovnye prichiny plohogo usvoeniya nachertatel'noy geometrii [Tekst] / N.A. Sal'kov // Geometriya i grafika. — 2021. —T. 9. — № 2. — S. 3–11. DOI:https://doi.org/10.12737/2308-4898-2021-9-2-3-11 EDN: https://elibrary.ru/WSYIIX
