Lesson 5, Topic 3
In Progress

# Third Section

Lesson Progress
0% Complete

## // Excel Excersice

• Excel sheet: Area percent column (B)
• The second column which is related to the number of International students, what to do:
• Go to the US news website and copy the number of international students for each school to the right cell in your sheet ( as shown in the video).

The column in red is a calculated value, don’t worry about it now. It will be used in the final calculation, so don’t attempt to change it; otherwise, it will affect the final result.

## // Excel Excersice

• Excel sheet: Area precent ( column D):
• Here you will follow the last slide: for each school you will look at its location on google and Identify:
• 1. which country it is in
• 2. which state the school is located in ( if it is in the US).
• 3. is the school in a big city, small city or its own isolated campus.
• After knowing the above information follow the table shown to you and enter the number based on it.

## 3) Hobbies, interests and recreational:

• Once you find the location, start looking for:

## // Excel Excersice

• Excel sheet: Hobbies, interests and recreational (column E):

Steps:

• 1. on the nots we provide you: recording the locations, centers and clubs you found in that location (city).
• 2. visit the website for these locations and look at their activity and what they offer and see if it really fits you
• 3. In the excel sheet column E you will find the hobbies, interests and recreational category where you need to enter a value from (0 to 100). 0 being not satisfying and 100 is extremely satisfying.

## // Excel Excersice

• Excel sheet: Overall ranking ; Column (F,GH,I) (in green)

Steps:

• Here you will only look at the overall ranking for each school and type it down in the right column.
• Anything more than a 100 you would have to put a 0.

## // Excel Excersice

• Excel sheet:

Steps:

• follow the exact format. We will be using US news ranking.
• Log on to their website and select the school that is in your list and look at these four topics and type the ranking to the excel sheet under the column name ( K,M,O and Q).

## // Excel Excersice

• Excel sheet: Research Output

Steps:

• For this we will be using the Times Higher Education(THE) ranking:
• I. log to the THE website select the school you in your list.
• II. scroll down to the statistics, as seen in the figure here.
• III. click on research and copy that number to the excel sheet (column  U).

## // Excel Excersice

• Excel sheet: Engineering ranking
• Just like what we saw in the major section. Go to the US news ranking and look at the Engineering top schools ( as explained in the video lecture).
• Copy the ranking to the excel sheet in column X.

## // Discord Excersice

• Discord server: Go to discord and discuss your minor with your group!

## // Excel Excersice

• Excel sheet: Engineering ranking
• Just like before go to the US ranking website and enter the specific field you are interested in as a minor or second major and type the ranking you get in the excel sheet.