Database Creation Through If, Vlookup, Sum and Sumif Functions of Microsoft Excel

Using databases is a fundamental matter for every business and non-business related activities. Their creation is more important than their usage, because creating a software through which we could track stock status in a enterprise’s warehouse is a huge burden for a newly founded enterprise. Microsoft Excel, a part of Microsoft Office packet, is a suitable program as it contains the needed tools and fuctions to create a database. We are going to practically show you how to create a database using Excel functions such as if, sum, sumif and vlookup and also using other tools such as condictional formatting and freeze panes. First of, you create a table with the warehouse articles; then you create an invoice for sale articles, and lastly the made sales will substract the article in the warehouse. The result of this worksheet gives us a practical software which calculates what the warehouse has left after the sales. This is important because a beginner enterpreneur doesn’t have to pay lots of money to create a database, but this worksheet will help them create one without being an expert in Microsoft Excel. In conclusion, we can say it is very important to be innovative in the activities we conduct, because the enterprenur spirit will not let their work be affected by someone else, including a software of advanced technology. Key words: Software, Microsoft Excel, Database, Warehouse Etc

Optic Fibers as a Broadcasting Media

Fast brodcasting of an information is always a challange from our daily activities. Through fast broadcasting of the information always created pre-eminence in military activities, business, researching, etc. From ancient times we know that information was orally and hand in hand broadcasted which in most of the times casused in loss of information and due to this also in loss of activities which are mentioned above. Due to information technology notably computer networks and internet overtime information started broadcasting faster. Information started broadcasting through copper wires and through wireless. Big applications started to develop with the increased use of Internet, high quality broadcasting (HD), video on demand broadcasting (VoD), triple pay broadcasting (three services on a medium), etc., then these two mediums couldn’t complete all these requests. Therfore after these problems, optic fiber began to be used as a broadcasting medium which eleminated all the defects of other mediums. Importance of this paper work is telling developing stages of optic fiber, it’s characteristics and it’s losses. Then it is shown that which devises enforce the signal of fibers and in the end all three mediums that we mentioned are compared on the basis of attributes. Findings form the paper will only enforce that knowledge we had before about optic fiber, the best broadcasting medium. Key words: Broadcast, Medium, Information, Optic Fiber, etc

Optic Fibers as a Broadcasting Media

Fast brodcasting of an information is always a challange from our daily activities. Through fast broadcasting of the information always created pre-eminence in military activities, business, researching, etc. From ancient times we know that information was orally and hand in hand broadcasted which in most of the times casused in loss of information and due to this also in loss of activities which are mentioned above. Due to information technology notably computer networks and internet overtime information started broadcasting faster. Information started broadcasting through copper wires and through wireless. Big applications started to develop with the increased use of Internet, high quality broadcasting (HD), video on demand broadcasting (VoD), triple pay broadcasting (three services on a medium), etc., then these two mediums couldn’t complete all these requests. Therfore after these problems, optic fiber began to be used as a broadcasting medium which eleminated all the defects of other mediums. Importance of this paper work is telling developing stages of optic fiber, it’s characteristics and it’s losses. Then it is shown that which devises enforce the signal of fibers and in the end all three mediums that we mentioned are compared on the basis of attributes. Findings form the paper will only enforce that knowledge we had before about optic fiber, the best broadcasting medium. Key words: Broadcast, Medium, Information, Optic Fiber, etc

E-commerce: Buying and Selling through Internet in Kosovo

Before internet was invented, there were invented numerous networks that helped American businesses in multiple savings. First of, they didn’t spend money on buying printers or scanners for the computers they possessed, meaning that the money spent before on buying hundreds of them, now was saved and used to buy a few of printers and scanners. How was this done? This worked by binding the entire computers of a floor to a single network. Second, the factor mostly taken into account is the energy saving and various abuses. Imagine the enormous amount of electricity that hundreds of printers and scanners would spend  and how much energy tens of them would spend, moreover  just think about how much these devices would be used in offices, where nobody is looking, for personal interests.American business, as the most creative one and the strongest was bothered by only one thing . This was the misuse of secret corporation information. These abuses occurred when the data had to be printed and transferred to corporate subsidiaries around the world. During the transfer the data could also be lost or damaged (intentionally or unintentionally) and then the corporation would suffer losses (the data were transferred via floppy discs, or they were printed in hard copies). The solution for these problems came from the US military that had invented the internet earlier and after having consumed it for its own needs, decided to put it up for American businesses.The internet has developed its own services such as : www, ftp, e-mail, and buying and selling though internet (e-commerce). Nowadays, information exchanges with corporate branches are not made roughly, but electronically in real time. Additionally, this made it possible for a new category of web designers to be created and they created a powerful web-site through which some businesses created virtual shops and they started earning more money than they used to, in their physical stores.This American development started penetrating in other countries as well. In Kosovo and Albania the situation has not changed in terms of doing business through internet. An important reason might be that Kosovo is not admitted to third party service for payments paypal.com, as well as in the world’s largest virtual store Amazon.Inc. But the first steps have already been taken

Database creation through if, vlookup, sum and sumif functions of Microsoft Excel

Using databases is a fundamental matter for every business and non-business related activities. Their creation is more important than their usage, because creating a software through which we could track stock status in a enterprise’s warehouse is a huge burden for a newly founded enterprise. Microsoft Excel, a part of Microsoft Office packet, is a suitable program as it contains the needed tools and fuctions to create a database. We are going to practically show you how to create a database using Excel functions such as if, sum, sumif and vlookup and also using other tools such as condictional formatting and freeze panes. First of, you create a table with the warehouse articles; then you create an invoice for sale articles, and lastly the made sales will substract the article in the warehouse. The result of this worksheet gives us a practical software which calculates what the warehouse has left after the sales. This is important because a beginner enterpreneur doesn’t have to pay lots of money to create a database, but this worksheet will help them create one without being an expert in Microsoft Excel. In conclusion, we can say it is very important to be innovative in the activities we conduct, because the enterprenur spirit will not let their work be affected by someone else, including a software of advanced technology

Global financial crisis

The most recent developments in economy are a clear indicator of many changes, which are a result of this high rate pacing, which also demonstrates as such. Market economy processes occur as a result of intertwining of many potential technological and human factors, thereby creating a system of numerous diver-gences and turbulences. Economics, a social science, is characteri-sed with movements from a system to another system, and is har-monized with elements or components which have impacted the development and application of economic policies as a result. This example can be illustrated with the passing from a commanded system (centralized) to a self-governing (decentrali-zed) system, while the movement from a system to another is known as transi-tion. Such transition in its own nature bears a number of problems of almost any kind (political, economic, social, etc.), and is charac-terised with differences from a country to another.Financial crisis is a phenomenon consisting of a perception of economic policies and creation of an economic and financial stabi-lity in regional and global structures. From this, one may assume that each system has its own changes in its nature, and as a result of these changes, we have the crisis of such a system. Even in the economic field, if we look closely, we have such a problem, where development trends both in human and technological fields have created a large gap between older times and today, thereby crea-ting dynamics with a high intensity of action. If we dwell on the problem, and enter into the financial world, we can see that the so-called industrialized countries have made giant leaps in deve-lopment, while countries in transition have stalled in many fields, as a result of a high rate of corruption and unemployment in these countries, and obviously these indicators are directly connected, thereby stroking the financial system in these countries.Corruption is an element, which directly and indirectly influences the pro-cess of attracting foreign investment, and further influencing the growth of unemployment, and in turn expanding the financial crisis, where finances are already fragile.In the following sections, we will elaborate on the financial crisis in a global aspect, the impacts of this crisis in economic development, and the role of stock exchange in finance, thereby creating a multi-dimensional horizon of the problem

Online learning challenges and opportunities in Higher Education Institutions (HEIs) in developing countries

The rapid development of information technology has influenced the change of concepts of the learning environment. Today, educational institutions are increasingly focused on teaching through technology. Many universities around the world are practicing online learning thanks to the use of technology and broadband capacity that developed countries have implemented in their core and access infrastructures. Seeing the benefits of learning through technology, developing countries are also seriously considering using the benefits of technology for learning. However, there are some challenges that need to be overcome, especially in developing countries, such as poor network infrastructure, lack of ICT (Information and Communication Technology) knowledge, poor content development, and so on. This gap is seen not only between countries, but also within countries. In this paper, we will discuss the main challenges and opportunities that online learning brings in HEIs in developing countries, with emphasis in Kosovo

Online learning challenges and opportunities in Higher Education Institutions (HEIs) in developing countries

The rapid development of information technology has influenced the change of concepts of the learning environment. Today, educational institutions are increasingly focused on teaching through technology. Many universities around the world are practicing online learning thanks to the use of technology and broadband capacity that developed countries have implemented in their core and access infrastructures. Seeing the benefits of learning through technology, developing countries are also seriously considering using the benefits of technology for learning. However, there are some challenges that need to be overcome, especially in developing countries, such as poor network infrastructure, lack of ICT (Information and Communication Technology) knowledge, poor content development, and so on. This gap is seen not only between countries, but also within countries. In this paper, we will discuss the main challenges and opportunities that online learning brings in HEIs in developing countries, with emphasis in Kosovo

Development of the Creative Potential of Future Teachers Based on Smart Education

The purpose of this research is to examine the impact of smart education on the development of the creative potential of future teachers. If we consider the research as a model, we can see that it was formed using the mixed method. The study group consisted of 172 teacher candidates who are pursuing their education at various universities in Almaty, Kazakhstan. It is noted that the data collection tools used in the research included a semi-structured interview form that was developed by the researchers and supported by experts in the field. The analysis of the quantitative data from the research was conducted using a statistical programme. In addition to calculating percentages, frequencies, and means, independent variables t-tests and one-way analyses of variance were applied. For the analysis of the qualitative data from the studies, they were grouped and analysed. As a result of the research, it has been determined that teacher candidates who use smart education have high creative potential