Introduction
Through the studies of the LEAD 256 course, the indulgence of many informatic topics such as programming, statistics, machine learning, and web development have brought forth many new entrances into the field of technology unto the eyes of the researcher. This paper will discuss some of those findings and discuss a current and potentially future applications of the applied learning topics. The project accompanying this paper was developed to better understand deeper developmental ideas and ethics to create an application based on the new knowledge that is accessible to everyone.
Project Goals
- Delve deeper into the, specifically, Python language and get a better overall understanding of the language
- Get a basic understanding of Hyper-Text Markup Language (HTML) for easy web development purposes
- Master Microsoft Excel to make the application of statistical analysis easier and more efficient
- Accomplish the previous goals before the end of the semester and apply them into the development of this project
- Achieve a more logical mindset through the development of the project and the knowledge gained through partaking in this course
Video of the Project
“Show Data” will pop-out another window that shows the current dataset in the workbook you’re working with. This is done by obtaining the workbook file’s path, diving into the workbook using the Pandas Python library and getting a n-dimensional dictionary that holds the column headings and data within.
“Create Data” will pop-out another window that will request the number of headings the user needs (or the number of columns the dataset requires) and the number of data items, rows, the dataset requires. Then, the application directs you to, essentially, a spreadsheet style data-entry form that will be directly imported into your workbook once completed and the “Submit” button is clicked.
“Insert Data” will first ask the user which row they wish to begin inserting data at within the dataset and how many data items, rows, the user wishes to insert. From here, you will be directed to another spreadsheet style data-entry form with the headings listed out and the number of rows you requested ready to be filled out.
“Delete Data” will pop-out the same window as the “Insert Data” button, except this time there is no spreadsheet data-entry form. Once the row in which you wish to begin data deletion and the number of rows you wish to delete has been entered, the application will automatically delete and adjust your dataset within the workbook.
“Macros” creates a menu for multiple actions. From here, you can turn your data into a table inside the Excel workbook by clicking “Create Table”, or you can manually sort your data in ascending order or descending order by clicking the respective buttons. The “Exit” button just leaves the macro menu.
“Change File” opens up the starting window which the user either typed, browsed for, or created their workbook file. This will effectively change the workbook you are working with and, if accidentally clicked, the user can just select the same workbook to continue working with the same data.
"Exit" will exit the application.
Machine Learning
Machine learning is the act of creating a computer simulate model off of a dataset that can either predict treands in the dataset for future data interpretation or recommendation or enabling very complex algorithms to be processed and executed efficiently. The research conducted into this topic can solely be acredited to the Cognitive Class vis IBM. Through this research, multiple implementations of machine learning were discovered. Whether that be classification, recommender systems, regressions, whether linear or otherwise, the list goes on and on. Machine learning is part of the next steps into the future of technology. The reason this project decided not to implement machine learning is due to the fact that obtaining the data and training a model to accomplish some task within data analysis would require much more research than conducted and would prove quite difficult to demonstrate and create.
Web Development
Web development is an ever-growing and changing field of software development. HTML was the basis of this research. This was found out to be one of only three programming languages that are used to create the internet and the things conducted on it. HTML is specifically used to create the objects, data, text, and images used. CSS is used to stylize the web page. Finally, JavaScript is used to create interactivity within the page.
This project is considered to be a project of which sparks completeness and fulfills a sense of purpose. While the project may also be considered redundant when it could easily be conduct within Excel itself, the process and development of the project was fun and very informative. If this course were to be taken again, the topics chosen for research would be more specialized and coherent as to make sure that an applied project would incorporate every aspect of the research conducted.
The future from this class could not look better. I am pursuing my bachelor’s in computer science and engineering which will solidify my passion with programming and working with computers. This project alone verifies that passion. I look forward to working on my next big project!
Certificates
Credits:
Created with images by dTosh - "Python coding language sign. Device, programming, developing concept. Abstract, digital, wireframe, low poly mesh, Raster blue neon 3d illustration. Triangle, line, dot, star" • howtogoto - "Excel Spreadsheet stats graph analytics data. Accountant hands point financial Document Trading Information with excel file. Finance statistic report analyze business graph, chart, database, report" • maciek905 - "Source PC website developer. Real software development code. JavaScript code in text editor. Computer interface. Abstract technology background. Java Software engineer concept." • Elnur - "Machine learning and cognitive computing - 3d rendering" • Tim - "HTML & CSS tags" • kontrymphoto - "HTML, CSS and media query code" • Scanrail - "Programming source code abstract background" • xresch - "tech circle technology"