What is the purpose of using the Split Column option in Power Query Editor?

To split a text column based on a specific delimiter

To filter data based on a specific criteria

Which option within the Split Column menu should be chosen to remove extra spaces from a text column?

Each occurrence of the delimiter

Only the first occurrence of the delimiter

How can you combine multiple split text columns into a single column after removing extra spaces?

By using the Text.Combine function in M query

By adding a new custom column with a formula

By using conditional formatting

What type of error will occur if you provide individual columns instead of a list to the Text.Combine function?

It will not recognize the Text.Combine function

It will concatenate the columns without removing spaces

What alternative method, besides using the Text.Combine function, can be used to remove extra spaces from a text column?

Merging the column with another column

What is the benefit of the technique demonstrated in the video compared to using other methods like AM Query?

It is a simpler and more user-friendly approach

It is the only method that can remove extra spaces

It provides more control over the formatting of the text

It is more efficient for large datasets

In the context of the video, what is the purpose of adding a custom column after splitting the text column?

To combine the split text columns into a single column after removing extra spaces

To calculate a new value based on the existing data

To filter out unwanted characters

To add a unique identifier to each row

What does the Text.Combine function do in Power Query Editor?

It combines multiple text values into a single text string

It splits a text column based on a delimiter

It removes extra spaces from a text column

It converts a text value to a different data type

How can you identify if there are extra spaces present in a text column within Power BI?

By looking for visual cues in the data table

By checking the data type of the column

By using a filter to identify rows with multiple spaces

By using a custom formula to analyze the number of spaces between words

Remove space from a text column in Power Query Power BI

Land preparation •Carrots can be planted in beds. •The beds should be prepared before planting. (a)digging: this is done using a hoe or a spade so as to loosen the soil. •During digging , remove roots and stems of weeds. (b) manuring: add 2kg of well rotten manure per square metre. •Work the manure deeply into the soil so that the roots of the carrots do not come into directly contact with manure. •Improperly incorporated manure causes development of carrots that have side roots. •this condition is called forking. Planting •Carrots are planted in beds where they will mature. •Water the bed a day before planting. •Mark the rows 30cm apart. •Carrots seeds are very small, therefore due to their size sow the seeds thinly along the rows. •Rub the seeds between your fingers as you sow. •Cover the seeds with fine sand. •The bed can be covered with grass so that the soil remain moist. •Water the bed soon after sowing using a watering can fitted with a fine rose. Caring for carrots (a) Thinning: is when you remove some of the baby plants in a row to free up space for the rest so that they can grow to full size. • Thinning in carrots is usually done two weeks after germination. • Thin out to leave a spacing of 4 -6 cm from each plant. (b) Watering: If carrots are not watered enough they will not grow fast. • Therefore carrots need a steady supply of water to keep the soil moist during the growing period. (c) Weeding: weeds are removed by hand, especially those in the rows. (d) Top dressing: carrots are usually not top dressed. •Fertilizer can only be applied after one has noticed leaves turning yellow. (e) Pest and disease control: aphids and nematodes attack carrots. •Dimethoate is used to control aphids. Harvesting carrots •Carrots are harvested 2 to 3 months after planting. •Bigger ones are harvested first inorder to leave more room for the young seedlings to develop. •Water the bed first the lift the carrots by hand. •A garden fork can also be used to loosen the soil, then pull up by hand. •The carrots can then be tied into bunches of 5 – 7 carrots

To the Lakota, and other indigenous people on North America's Great Plains, the bison was an essential part of their culture ( expressed in the quote on the previous page). The bison provided meat for nutrition, a hide for clothing and shelter, bones for tools, and fat for soap. The bison was also central to their religious beliefs. So, when European settlers hunted the bison nearly to extinction, Lakota culture suffered. Culture is central to a society and the identity of its people, as well as its continued existence. Therefore, geographers study culture as a way to understand similarities and differences among societies across the world, and in some cases, to help preserve these societies. Analyzing Culture All of a group's learned behaviors, actions, beliefs, and objects are a part of culture. It is a visible force seen in a group's actions, possessions, and influence on the landscape. For example, in a large city you can see people working in offices, factories, and stores, and living in high-rise apartments or suburban homes. You might observe them attending movies, concerts, or sporting events. Culture is also an invisible force guiding people through shared belief systems, customs, and traditions. Culture is learned, in that it develops through experiences, and not merely transmitted through genetics. For example, many people in the United States have developed a strong sense of competitiveness in school and business, and believe that hard work is a key to success. These types of elements, visible and invisible, are cultural traits. A series of interrelated traits make up a cultural complex, such as the process of steps and acceptable behaviors related to greeting a person in different cultures. A single cultural artifact, such as an automobile, may represent many different values, beliefs, behaviors and traditions and be representative of a cultural complex. Since culture is learned there are many ways that one generation passes its culture to the next. Children and adults learn traits three ways: • imitation, as when learning a language by repeating sounds or behaviors from a person or television • informal instruction, as when a parent reminds a child to say "please" • formal instruction, as when students learn history in school 132 HUMAN GEOGRAPHY: AP" EDITION CULTURAL COMPLEX OF THE AUTOMOBILE The automobile provides much more than just transportation, as it reflects many values that are central to American culture. Origins of Culture The area in which a unique culture or a specific trait develops is a culture hearth. Classical Greece was a culture hearth for democracy more than 2,000 years ago. New York City was a culture hearth for rap music in the 1970s. Geographers study how cultures develop in hearths and diffuse-or spread-to other places. Geographers also study taboos, behaviors heavily discouraged by a culture. For example, many cultures have taboos against eating certain foods, such as pork or insects. What is considered taboo changes over time. In the United States, marriages between Protestants and Catholics were once taboo, but they are not widely opposed now. Traditional, Folk, and Indigenous Cultures With the beginning of the Industrial Revolution in the late 18th century, modern transportation and communication connected people as never before and led to extensive cultural mixing, especially as cities have grown. The world prior to this time was very different; however, remnants of the past are still evident in our modern cultures. Traditional, folk, and indigenous cultures share some important characteristics and are often grouped together, but they do have some subtle differences. Traditional Culture Recently, the meanings of traditional, folk, and indigenous culture have begun to merge, causing geographers to debate when each should be used. Increasingly, the term traditional culture is used to encompass all three cultural designations. All three types share the function of passing down long-held beliefs, values, and practices and are generally resistant to rapid changes in their culture. Folk Culture The beliefs and practices of small, homogenous groups of people, often living in rural areas that are relatively isolated and slow to change, are known as folk cultures. Like all cultures, they demonstrate the diverse ways that people have adapted to a physical environment. For example, people around the world learned to make shelters out of available resources, whether 3.1: INTRODUCTION TO CULTURE 133 it was snow or mud bricks or wood. However, people used similar resources such as wood differently. In Scandinavia, people used trees to build cabins. In the American Midwest, people processed trees into boards, built a frame, and attached the boards to it. Many traits of folk culture continue today. Corn was first grown in Mexico around 10,000 years ago, and it is still grown there today. While many elements of folk culture exist side by side with modern culture, there are people whose societies have changed little, if at all, from long ago. These people practice traditional cultures, those which have not been affected by modern technology or influences. They often live in remote regions, such as some small tribes in the Amazon rainforest, and have scant knowledge of the outside world. As the lines continue blurring between cultural designations, the Amish of Pennsylvania are often referenced as both folk and traditional culture. Indigenous Culture When members of an ethnic group reside in their ancestral lands, and typically possess unique cultural traits, such as speaking their own exclusive language, they are considered an indigenous culture. Some indigenous peoples have been displaced from their native lands, but still practice their indigenous culture. Native Americans in the United States, such as the Navajo, have kept indigenous cultural practices. First Nations of Canada, such as the Inuit, have also retained their indigenous culture. Globalization and Popular Culture As a result of the Industrial Revolution, improvements in transportation and communication have shortened the time required for movement, trade, or other forms of interaction between two places. This development, known as space-time compression (see Topics 1.4 and 3.6), has accelerated culture change around the world. In 1817, a freight shipment from Cincinnati needed 52 days to reach New York City. By 1850, because of canals and railroads, it took half that long. And by 1852, it took only 7 days. Today, an airplane flight takes only a few hours, and digital information takes seconds or less. Similar change has occurred on the global scale. People travel freely across the world in a matter of hours, and communication has advanced to a point where people share information instantaneously across the globe. The increased global interaction has had a profound impact on cultures, from spreading English across the world to instant sharing of news, events and music. Globalization specifically refers to the increased integration of the world economy since the 1970s. The process of intensified interaction among peoples, governments, and companies of different countries around the globe has had profound impacts on culture. The culture of the United States is intertwined with globalization. Through the influence of its corporations, Hollywood movies, and government, the United States exerts widespread influence in other countries. But other countries also shape American culture. For example, in 2019, the National Basketball Association included players from 38 countries or territories. When cultural traits- such as clothing, music, movies, and types of 134 HUMAN GEOGRAPHY: AP. EDITION businesses-spread quickly over a large area and are adopted by various groups, they become part of popular culture. Elements of popular culture often begin in urban areas and diffuse quickly through globalization processes such as the media and Internet. These elements can quickly be adopted worldwide, making them part of global culture. People around the world follow European soccer, Indian Bollywood movies, and Japanese animation known as anime. With people in many nations wearing similar clothes, listening to similar music, and eating similar food, popular cultural traits often promote uniformity in beliefs, values, and the cultural landscape across many places The cultural landscape, also known as the built environment (see Topic 3.2), is the modification of the environment by a group and is a visible reflection of that group's cultural beliefs and values. Traditional Culture to Popular Culture Popular culture emphasizes trying what is new rather than preserving what is traditional. Many people, especially older generations or those who follow a folk culture, openly resist the adoption of popular cultural traits. They do this by preserving traditional languages, religions, values, and foods. While older generations often resist the adoption of popular culture, they seldom are successful in keeping their traditional cultures from changing, especially among the young people of their society. One clash between popular and traditional culture is occurring in Brazil. As the population expands to the interior of the rain forest, many indigenous cultures, like the Yanamamo tribe, have more contact with outside groups. Remaining isolated by the forest is becoming increasingly difficult as many young people from the indigenous cultures become exposed to popular culture and begin to integrate into the larger Brazilian society. As the young people leave their communities, they are more likely to accept popular culture at the expense of their indigenous cultural heritage, which threatens the very existence of their folk culture. Traditional culture typically exhibits horizontal diversity, meaning each traditional culture has its own customs and language that makes it distinct from other culture groups. Yet, people people within each group are usually homogeneous, or very similar to each other. By contrast, popular culture typically exhibits vertical diversity, meaning that modern urban societies are usually heterogeneous, or exhibiting differences, within the society and usually contain numerous multiethnic neighborhoods. However, on a global scale popular cultures are relatively similar with the same type of malls, shops, fast food, and clothing. Urban global culture centers are not identical, yet, global cities often do not have as much horizontal diversity across space as folk cultures. 3.1: INTRODUCTION TO CULTURE 135 COMPARING TRADITIONAL AND POPULAR CULTURE Trait Traditional Culture Popular or Global Culture Society • Rural and isolated location • Urban and connected location • Homogeneous and • Diverse and multiethnic indigenous population population • Most people speak an • Many people speak a global indigenous or ethnic local language such as English or language Arabic • Horizontal diversity • Vertical diversity Social • Emphasis on community and • Emphasis on individualism and Structure conformity making choices • Families live close to each • Dispersed families other • Weakly defined gender roles • Well-defined gender roles Diffusion • Relatively slow and limited • Relatively rapid and extensive • Primarily through relocation • Often hierarchical • Oral traditions and stories • Social media and mass media Buildings and • Materials produced locally, • Materials produced in distant Housing such as stone or grass factories, such as steel or glass • Built by community or owner • Built by a business • Similar style for community • Variety of architectural styles • Different between cultures • Similar between cities • Traditional architecture • Postmodern / contemporary architecture Food • Locally produced • Often imported • Choices limited by tradition • Wide range of choice • Prepared by the family or • Purchased in restaurants community Spatial Focus • Local and regional • National and global Artifacts, Mentifacts, and Sociofacts Whether a cultural attribute is considered traditional, folk, indigenous, or popular in nature, it is valuable to differentiate between elements of culture that can be seen and those that can not. There are artifacts that comprise the material culture, which consists of tangible things, or those that can be experienced by the senses. Art, clothing, food, music, sports, and housing types are all tangible elements of culture. Another element of the study of artifacts is understanding the techniques to use or build a specific artifact. Artifacts can be unique to a particular culture, or can be shared. For example, people of all cultures need to communicate through language, yet there are many groups that possess languages unique to their culture. The ability to read, write and understand the English language is an artifact of importance for much of popular global culture. 136 HUMAN GEOGRAPHY: AP" EDITION Mentifacts comprise a group's nonmaterial culture and consist ofintangible concepts, or those not having a physical presence. Beliefs, values, practices, and aesthetics (pleasing in appearance) determine what a cultural group views as acceptable and desirable. Mentifacts can also be unique or shared. People of many cultures possess an belief in one or many deities, and often the deities are unique to that culture. The belief in a god is a mentifact-the religious building or symbols are artifacts. Cultural groups also possess sociofacts, which are the ways people organize their society and relate to one another. Taken altogether, people tend to see the whole of their culture as greater than the sum of its individual parts. Sociofacts are embodied through families, governments, sports teams, religious organizations, education systems, and other social constructs. As with artifacts and mentifacts, sociofacts may also be unique or similar to other societies. Families are the foundations of most societies, yet what constitutes the structure of a family may vary widely between cultural groups. For example, Western cultures tend to view the nuclear family, consisting of the parents and their children as the basic family unit. By contrast, in many Western African cultures the norm is the extended family, consisting of several generations and other family members such as cousins living under one roof.

• Landscape management A landscape is the evident factor of a land, its landforms, and the combined features of natural or artificial elements. Landscape management includes maintenance and integration of physical elements, water bodies, land cover, indigenous vegetation, human elements, such as structures and buildings, and climatic conditions. • Soil Preparation In the list of farming practices, soil preparation is placed second because of its importance for seed germination. Before a crop is grown, the soil is leveled and plowed a bit deeply to prepare it for the sowing of seed. After plowing, the soil loosens and develops proper aeration in the soil. • Sowing Seed selection from good quality varieties is the principal step of sowing. After preparing the soil, seeds are spread over the field, called sowing. Manual and mechanical (seeders) methods of sowing can be used. Some plants, such as rice, are first grown as seedlings in a small space and later transplanted to fields. • Manuring Plants need nutrients for their growth and fruit/seed production. Therefore, nutrients must be consumed at even intervals. Fertilization is the stage at which nutrients are introduced into the lands. These nutrients can be natural manure or artificial fertilizers. Decomposed products and waste of plants and animals are used as manure because of their nutrient richness. • Irrigation Irrigation means supplying water to plants. Water sources can be dams, ponds, wells, canals, etc. Excessive irrigation can damage crops and lead to waterlogging. The irrigation interval and frequency must be monitored, as they vary with the crop. • Weeding Unwanted plants grown alongside field crops are known as weeds. These plants are removed with the help of weed killers (weedicides), manually plucking with hands. Several weeds can be removed with better soil preparation techniques. • Integrated Pest Management • IPM – Integrated Pest Management, is a successful and ecologically sensitive technique to manage pests using combined sustainable practices. IPM is a series of methods including pest assessment, decision, and control techniques • Integrating Crops and Livestock Integrating crops and livestock increases the diversity and environmental sustainability of both sectors. In the meantime, it will offer opportunities to increase overall agricultural production and profitability. • Storage/Selling In the end steps of agricultural practices, the resulting grains are stored in warehouses for later use and selling purposes. Therefore, better plant protection methods must be used to protect grains from rodents and insect pests. The stores should be cleaned, dried, well-fumigated, etc., before storing grains. • Harvesting Among steps of farming practices, harvesting needs significant care otherwise it will result in yield reduction. When the crop reaches maturity, the cutting starts, and the produce will be stored in a dry place. This process is known as harvesting. After harvesting, manual or mechanical thrashing is done to separate grains from the plants.

Ect weather data. Trackingthe The forecasters have a lot of help! Meteorologists, or scientists who study weather, collect data from all over the world. They use automated systems at sea, on land, in the air, and in space to help track the weather. At sea, weather buoys collect data on coastal weather conditions. These data help keep people in coastal cities safe. On land, weather-monitoring stations track weather conditions in remote locations. They can send advance notice about incoming weather. Scientists also use Doppler radar towers to observe how storm clouds are moving. Weather balloons and weather satellites collect data from high above Earth’s surface. Weather satellites can track the weather over very large areas. They also help relay data from land-based tools to meteorologists around the world. Scientists launch weather balloons that carry tools, called radiosondes, into the atmosphere. A typical radiosonde measures air temperature, air pressure, and humidity. Weather satellites orbit Earth. They collect weather data, such as cloud cover, and track storms, such as hurricanes. These satellites use radio signals to transmit data back to Earth. Packets of air move across Earth’s surface. An air mass is a large body of air with the same temperature and humidity throughout. An air mass reflects the conditions of the place where it forms. Air masses that form over land are dry. Air masses that form over water are moist. Cold air masses form near the poles, and warm air masses form near the tropics. As air masses move across an area, they can collide. The boundary between two air masses is called a front. Weather changes take place at fronts. For example, as a warm front passes over an area, warm air replaces cooler air and the temperature rises. The movement of air masses and fronts explains why you might be chilly one day and warm the next. At a front, stormy conditions are common. Air masses may form over land or water. The masses that form over land near the poles will be cold and dry. The masses that form over water near the poles will be cold and moist. Which types of air masses will form near the tropics? A cold front forms where a cold air mass bumps into a warmer air mass. The denser cold air pushes the warm air up. Water vapor in the air cools, and large clouds form. Thunderstorms and heavy rain often take place. Cooler temperatures follow a cold front. A warm front forms where a warm air mass moves over a cold air mass. A warm front forms a wider area of clouds and rain than a cold front. Steady rain or snow may fall. Warmer temperatures follow a warm front.

Economy of Southeast Asia Even prior to the penetration of European interests, Southeast Asia was a critical part of the world trading system. A wide range of commodities originated in the region, but especially important were such spices as pepper, ginger, cloves, and nutmeg. The spice trade initially was developed by Indian and Arab merchants, but it also brought Europeans to the region. First the Portuguese, then the Dutch, and finally the British and French became involved in this enterprise in various countries. The penetration of European commercial interests gradually evolved into annexation of territories, as traders lobbied for an extension of control to protect and expand their activities. As a result, the Dutch moved into Indonesia, the British into Malaya, and the French into Indochina. Europe’s interest and activity in the region was further enhanced by the opening of the Suez Canal, the development of telegraphic communications, the adoption of steam shipping, and the prospects for trade with China. In the case of Malaya, the gradual diffusion of British administration provided systems of law and order and of taxation and allowed for the gradual development of infrastructure, principally reliable transport systems. This environment attracted Chinese immigrants, and the growth of the tin mining industry soon followed. Later rubber plantations were established, which brought about still further immigration. Similar developments took place in Burma (Myanmar), Vietnam, and Indonesia. In Siam (Thailand) during the second half of the 19th century, a rapid expansion of Western enterprise occurred, though not by colonization. Both British and American firms began trading in the region. The impact of the Western activity was essentially to remove trade from what had been a Chinese monopoly and to emphasize the export of a single commodity, rice. Established indigenous textile and sugar-processing industries were replaced by imports, and the economy slowly became dependent on rice exports. The Philippines gradually developed a plantation farming system under Spanish and later American influence, although rice, sugar, and tobacco continued to be produced by small-scale growers and processed by Chinese enterprises until the mid-19th century. The incorporation of Southeast Asia into the world economy had a major impact on the distribution of the region’s economic development, and it created more uneven patterns of population growth and economic activity. It also brought about a stronger sense of class distinction and resulted in a larger discrepancy between the wealthy and poor. The worldwide economic depression of the 1930s severely affected the commercialized areas most dependent on the world economy. Unemployment rose, and the period produced the seeds of political change and activism that culminated in the independence of most of the region’s countries after World War II. Since the 1950s the economic development strategies of virtually all the capitalist Southeast Asian states have emphasized urban industrialization, while agricultural development generally has been viewed as subsidiary to industrial growth. These strategies have met with mixed success. Indeed, the trading pattern of the region by and large has continued to be one of producing and exporting raw materials and importing manufactured goods. Only Singapore has reached an advanced level of industrialization, in the process becoming one of the world’s great centers of industry and commerce. There is great disparity in development rates within the region, especially between the member and nonmember countries of the Association of Southeast Asian Nations (ASEAN). Those belonging to this grouping—Brunei, Indonesia, Malaysia, the Philippines, Singapore, and Thailand—generally have experienced significant economic development since the mid-1960s; the exception has been the Philippines, the economy of which has grown at a much slower rate. Development has been extremely slow or nonexistent in the non-ASEAN countries of Cambodia, Laos, Myanmar, and Vietnam, and these are among the poorest nations in the world.

SC.8.E.5.10 (H) - Assess how technology is essential to science for such purposes as access to outer space and other remote locations, sample collection, measurement, data collection and storage, computation, and communication of information.

Related quizzes

Related quizzes