Category: Geography

Step 1 Download the file for your city (This would be the city you chose a neighborhood on earlier in the semester)
you will be working on the sandiego excel sheet that i have uploaded
San DiegoDownload San Diego (you can find it in the files update)
You will only accomplish one task…
Find which host has the MOST Air BnB Properties and graph the 5 highest
In the example we used data I made up for an example – here I will be using real data from the website ‘Inside Air BnB’ which collects data from Air BnB to show how they contribute to issues of affordable housing.
You should follow along as we go, but just in case you get lost or mess up I have completed the example for you. It always helps as you can chart your progress and use the formulas here as a template for YOUR CITY.
It’s up to you how you want to tackle this – I’m the worst so I usually try to skip ahead – lift the heaviest weight – take the greatest challenge – and then fail and try the tutorial.
I am integrating concepts from the game design theory of metroidvania… Look it up if you are interested. 
Here is my completed Excel Worksheet for Portland Download Here is my completed Excel Worksheet for Portland. (example chart in files)
Step 1 Poke around…
EACH ROW is a different Air BnB property. There are a lot of properties! probably more than 4,000.
There are 8 data columns – there are only 1 of them you will need to consider for now (3 if you are doing the ‘A’ assignment). I needed to create Latitude and Longitude so I could make the files for next week (for mapping)
HOST ID – Uniquely identifies each host. This is helpful because…
HOST NAME – Only identifies the name of the host (it is possible there are different host_id and host_names because hosts can have the same name)
NEIGHBORHOOD – What neighborhood is the property located in? Sometimes these will be names – other times numbers. If they are numbers they simply represent zipcodes.
ROOM_TYPE – Air BnB has three categories – Entire Home, Private Room, or Shared Apartment are the options.
PRICE – The price in dollars of an Air BnB per night
Reviews – The number of reviews the property had 
Step 2 Set up the spreadsheet
Click ‘A’ in the top row to highlight the whole host_id column
Copy it and click on J (the whole column) and paste
The final copy and paste will be a column which you will populate. 
In K1 write ‘count’
In K2 enter ‘1’ 
highlight K2 and click on the green square in the bottom right hand portion of the box
DRAG IT DOWN ALL THE WAY TO THE LAST CELL (sorry this is going to take a while!)
For me it was ‘4603’ 
Once you have 1’s all the way down to the last row of Air BnB Properties. 
Step 3: Create and populate a new sheet.
Name it ‘host id’
Copy and Paste columns J and K (Host ID and the count column you created) into the host id sheet  (columns A and B)’ 
Step 4: SUMIF
In C1 of the host id sheet type ‘SUMIF’
This is a new formula! SUMIF will help us calculate which hosts have the most reviews
Copy this formula into C2 of the host id sheet
SUMIF($A$2:$A$4603, A2, $B$2:$B$4603)
I KNOW THERE IS no =(equals) sign. The reason for this is because you will have to change some values based on the spreadsheet of the city you have.
First change the 4603 (look it appears twice in the SUMIF formula above) and change it to the the number of the last row you have data entry (in my case it’s the 4603th row – there are 4603 properties in Portland – there will a similar number in the thousands for your city)
You can scroll to the bottom of the document to find this number.
After you paste into the cell put an equals sign at the begging
Once you have changed 4603 to the number unique to your spreadsheet… 
PUT IN THE EQUAL SIGN AT THE BEGINNING OF THE EQUATION. It won’t work otherwise
Then… drag it down (the method we used for count above) – highlighting C2 and dragging it all the way down to that last row you just input into the formula. 
IF YOU ARE GETTING LOST DON’T FORGET TO PRESS UNDO 
PLEASE REFER TO MY SHEET IN PORTLAND TO SEE HOW ALL OF THIS WORKS (LINK ABOVE)
It looks something like this… 
What does this tell us. It counts the number of times each host id (that unique identifier for each host) appears in a row
From this information we will find out who had the the most properties.
Step 5: Copying for Sorting and Analysis
Copy the whole row A into Column E 
Copy the whole row C —- THEN right click on F to highlight the whole column — right click — go to paste special — values (Remember this from last lab?)
Now we can sort to find the five highest Host Id’s 
Left click on F and drag over to E so both columns are highlighted 
SORT AND FILTER FROM LARGEST TO SMALLEST! (Z through A)
If a screen pops up just press ok… 
Step 6: Get Rid of the Duplicates
Great! The problem is we have SO many duplicates – let’s get rid of them 
Highlight E AND F and find ‘Data’ in the top ribbon
From here find ‘remove duplicates’ – that little Neapolitan ice cream looking thing with the red x next to text to columns 
Again – if this isn’t popping up full screen Excel or look up the tool on Google.
Just press ok when the menu comes up
Great we got rid of all the duplicate values
If those exponents look weird simply expand the E column by hovering over the border and dragging it a little larger
Step 7 Analysis
The next step is to simply look up these numbers in the original spreadsheet
Go back to Sheet 1
Press Command (or Control) F and simply type in 5615582 (this is the host id with the most properties) and press enter (make sure nothing is highlighted in the sheet or it will only search what is highlighted
Press enter several times in the entry in the host_id column doesn’t come up 
Look at that! It’s called RoomPicks! 
Let’s enter that on the ‘host_id’ spread sheet into G2
Rinse and Repeat and it will look something like this
Step 8 Preparing for a Chart
Finally – copy the first five entries for the names you just recorded (G1-G6)  Into I2 – make sure you type  ‘host’ into I1
and F1-F6 (the sum of properties for each  of the top five hosts) into J2 – put the ‘number of properties into J1
If you’ve made it this far you are in good shape! 
Next highlight J2 and scroll over to include J2 – J6 and I2 – I6 DO NOT INCLUDE THE NAMES AT TOP
Once you have highlighted this table sort in reverse order z – a (see the values above)
We do this so our chart will look nice
Step 9: Make a Chart
Simply highlight the entire table with the title like below and then click on ‘insert’ on the top ribbon and find the vertical bar chart
2d column will do 
It will look something like this
Just Change the title and you are good to go
Step 10 – YOU DON’T HAVE TO HAND IN ANYTHING YOU JUST DID – after all I gave you answers above, which you should totally use to make the same chart for your city!
AshevilleDownload Asheville
AustinDownload Austin
BostonDownload Boston
ChicagoDownload Chicago
NashvilleDownload Nashville
San DiegoDownload San Diego
Using SUMIF in the method described above:
Find the the total number of properties for each Host ID
The names of the hosts with the 5 most properties
Create a graph that features the names of these top five hosts and how many properties they own (should go from left to right on the graph from lowest to highest – like shown in my graph for Portland)

This worksheet activity provides an opportunity for you to engage deeply with a specific geographic region by analyzing the fundamental themes of geography that characterize that region.
To complete this assignment, review the Worksheet Template Guidelines and Rubric Word Document and complete the following steps:
Use the Themes of Geography resource and the required resources in this module to specifically discuss the criteria used to identify the realms (or regions) and subregions.
Download the Worksheet Template Guidelines and Rubric document and select a region from the list below to address the questions related to geographic themes in the worksheet.
China’s coastal core
China’s interior
China’s western periphery
Mongolia
The Korean Peninsula
Japan
Taiwan
Mainland Southeast Asia
Insular Southeast Asia
Once you have completed the worksheet, upload and submit your saved worksheet file to the learning environment to finish this assignment.
Link to Themes of geogrpahy      https://snhu-media.snhu.edu/files/course_repository/undergraduate/geo/geo200/geo200_storyline/story_html5.html  

I have already completed some of the work in the PowerPoint linked below, you are free to edit what I already have down as you want.
I have included an example of a completed report that got a good score, it is not the same format but should demonstrate the type of information needed.
There needs to be specific slides for each of the four spheres (atmosphere, biosphere, atmosphere, geosphere)

listen to this podcast

Рельєф материків і рельєф океанів суттєво відрізняються. Материки мають різноманітний рельєф, включаючи гори, долини, рівнини та плато. На материках можуть бути великі гірські ланцюги, такі як Гімалаї, Анди або Альпи. Океани, натомість, мають переважно рівний морський дно, яке може мати деякі виступи, ями і хвилеподібні структури, такі як хребти або рівнини, але загалом вони менш різноманітні в порівнянні з материками.

Requirements for your 8-10 slide presentation:
A cover slide where you name the national park, include the state where it is located and provide a photograph depicting a feature of the park.
Example: Lassen National Park, California.  I would also include an image of the bubbling mudpots.
A slide to address the geographic theme of location. Identify the absolute and relative locations of the park; provide at least one supporting map.
Example: Acadia National Park is located in the Northeast U.S., along the Atlantic Coast on the Gulf of Maine; it is directly east of Augusta, Maine’s capital city.  The absolute location is 44N, 68W.  I would also include a map of the park.
A slide to address what United States region(s) the national park is a part of. This includes geographic regions such as the Southwest, Pacific Northwest, etc., but can also include climatic region and/or biome(s).  Include at least one supporting visual such as a map of U.S. regions, a climograph, biome photograph, etc.
Example: Olympic National Park is located in the Pacific Northwest. The climate is largely Marine West Coast (cfb) but parts of the region are Mediterranean (csb).  I would continue with more details on the climate types and regions and provide a photograph of the temperate rainforest biome.
At least one slide to share research and discuss specific physical characteristics of the park in detail. What are the features?  How did they form?  What is their significance to the region?  Include at least one supporting photograph addressing the questions above.
Example: Carlsbad Caverns National Park is known for its caves, formed from the erosion of limestone over four million years ago.  As part of this slide I would also cover how the caves formed, as well as the decoration stage when stalagmites and stalactites grew.  To address significance, I would elaborate on the history of the Capitan Reef and include a photograph of a well decorated cave in the park.  
At least one slide that explains how geographic processes are represented in the national park.
Example: Bryce Canyon National Park is known for its beautiful hoodoos, which are unique rock structures that formed through a 3 step process that includes sedimentary rock formation, uplift and erosion. I would continue to elaborate on what hoodoos are, how they were formed and what processes are occurring today.
A slide should evaluate examples of human-environment interaction that take place or have taken place in the park. This could include anything from the construction of dams to fishing to rock climbing or hiking.
Example: A portion of Virgin Islands National Park is underwater.  One unique example of human-environment interaction is snorkeling, in fact, the park even has an underwater snorkeling trail in Trunk Bay!  Popular activities at the park include snorkeling and hiking the numerous trails on the island of St. John.  Elaborating on these examples would be an appropriate addition to this slide.
A concluding slide that explains why you chose the national park and if this a park you would want to visit, why/not?
Example: I chose to complete my project on The Grand Canyon National Park because I would like to visit the park in the future and it is within driving distance of Moreno Valley.  I would like to visit the Grand Canyon because I have always had an interest in native cultures and the history of Native Americans in the region and how they lived off of the land interests me.  I would prefer to visit in the spring when the snow has melted but it isn’t as hot and dry as the summers in the park.
A bibliography slide that cites all sources used, in MLA or APA format.
Examples of MLA and APA citations can be found at Purdue’s OWLLinks to an external site.

okay please when you are doing the citations please indicate the cities and make sure you and me can have access to them because every time i order i have a issue to open the links that were provided to me so please make sure the cites are accurate and accessible for me to access it once i click on the citation ALSO PLEASE INDICATE THE ONE YOU ARE CHOOSING TO DO SO I CAN MAKE SURE TO PROVIDE YOU LESSONS AND CONTENTS THE PROF PROVIDED ME SO OUT OF THE FIVE PLEASE INDICATE WHICH NUMBER YOU ARE DING AND I CAN SHARE THELESSONS AND SOME LINKS THE PROF GAVE ME PLEASE THANK YOU AND ONCE YOU ARE DONE DOING THIS ASSIGNMENT I AND DO IT WELL FOR MY NEXT ASSIGNMENT THE 2 ASSIGNMENT I WILL MAKE SURE YOU DO ASSIGNMENT 2 SINCE YOU WOULD KNOW HOW TO DO IT BECAUSE U ALREADY WILL BE DOING ASSIGNMENT 1 THNK YOU GOOD LUCK PLEASE IT IT WELL NO PLAGIRISM TO BE USED AND USE YOUR OWN WORDS PLEASE ALSO CHECK FOR PLAGIRISM PLEASE NO PLAGIRISM

I need one page for each section. Each section should be one page, double-spaced, in 12-point font. Required Text: Rubenstein, James M. The Cultural Landscape: An Introduction to Human Geography, 12Th ed
Please don’t use AI to write the papers. 🙂 And please give me an AI report.
this is supposed to be written from my perspective. like a discussion post would be written

Please fill in answers using complete sentences. All the information
should be attached. Please let me know if you have any questions.

1. In your own words, summarize the article for someone who has not read it. Your summary should be four to five sentences in length. 
2 .In four to five sentences, evaluate the article using the CRAAP test (see more information at the bottom of the page). 
3. Select “golden lines” from the article. Golden lines are one to three sentences that are powerful quotes from the reading. These lines are especially insightful or thought-provokig.  
a)Select one to three sentences from the reading that you think make good “golden lines”. 
b)Copy and paste golden lines. Include the document page number. 
c)In two to three sentences, explain why you think this particular quote is especially insightful or thought-provoking. 
4.What questions do you have about the information presented in the article? In one to two sentences, be sure to explain why you are asking the question. 
CRAAP TEST 
Is it current? 
Was it written recently enough to be accurate? 
Is it relevant? 
Does the information relate to your topic or answer your question? 
Who is the intended audience? 
Is it authoritative? 
Who wrote, published, or publicized it? 
What makes the author an expert? 
Are they backed by an institution (such as a university or institute)? If not, are they a primary source? 
Is it accurate? 
Is there supporting evidence? 
Has the information been reviewed by experts or fact-checkers? 
Are there spelling or other errors? 
What’s the purpose? 
Why was this information created? Is it to promote something? Sell ads? Drive votes? 
Is the purpose clear? 
What biases can you find? What are others saying about the author or source? 
What is your purpose and bias?