Task 3- Student Information Unpacking (Topics: Nested collections, flow-control, multi-file, strings) Requires: utilities.py-> variables students and studentsInfo Task 3 is to print out a list of students and their information. This information is stored in two variables (a list and a dictionary of lists). The data is organized as shown in the diagram below. Specifically, the variable students is a list 47 strings of student names; the variable studentsInfo is a dictionary where the keys indicate information about the students. Each key is associated with a list of integers that indexes into the students list variable. The keys in the dictionary indicate the following information: 'Year 1' to 'Year 4' is what year a student is studying. For example, 'Sasha' is a 'Year 2' student (see below). Keys 'CS','DM','BZ','SE' indicate the students' program of study (e.g., 'CS' is comp sci, 'DM' is digital media, 'BZ' is business, and 'SE' is software engineering). For example, 'Solar' is a 'CS' student. Keys 'On Campus' and 'Off Campus' indicate the students' living arrangements. For example, 'Mahmoud' lives 'On Campus'. index 1 3 4 5 45 46 students - ['Juhong', 'Sasha', 'solar', 'Ali', 'Amy', 'Gopi', -, 'Mahmoud', 'Rutha'] studentsInfo - { "Year 1': [42, 24, 12, 37, 35, 23, 32, 5, 34, 19], "Year 2': [1, 28, 36, 46, 30, 15, 6, 33, 13, 7, 18, 44], "Year 3': [26, 11, 21, 3, 2, 14, 31, 27], *Year 4': [25, 4, 20, е, 16, 17, 40, 39, 29, 22, 41, 9, 8, 10, 38, 43, 45], "CS': [24, 1, 3, 12, 2, зе, 23, 34, з, 45, 6, 22, 39, 11, 14, 28, 15, 26, 21, 7], "DM': [44, 18, 16, 40, 29, 13, 46], "BZ': [10, 5, 9, 31, 41, 20, 8, 25, 17, 42, 35, 43, 38, e], "SE': [4, 19, 27, 32, 36, 37], "On Campus': [24, 13, 6, 3, 22, 4, 23, 12, 15, m, 33, 40, 43, 35, 8, 45], 'Off Campus': [30, 1, 37, 36, 41, 16, 9, 25, 29, 17, e, 18, 31, 44, 5, 32, 2, 20, 28] Task 3 should behave as follows: 1) Use the two variables above to print out each student's information sorted by the student's name (see below). 2) Format the output for each student as follows: Vladen (Year 3) Program: CS Housing: On Campus

An index may speed up queries, but it's usually a terrible idea to create an index for every property or combination of properties that might be used as search keys. I'd want to know more about this.

how to write "List the job titles that end with the letter "t” in MySQL

Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a formula using the INDEX Use the Lookup table (range A2:E23) as the array. For the row_num argument, use the MATCH Use the Project ID (cell H2) as the lookup_value for the MATCH function. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.

Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.

For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.

Article Link:  https://www.mdpi.com/2304-6740/11/2/65Write a summary about the article - Summarize the main idea/point(s) - Please include excerpts from the article to emphasize a point, but it must be cited as an in-text citation. E.g. "Quote." (Author's lat name page) For example, (John 6)

A wavy line will appear at the cursor's current position in the code editor.

2-List the course number and description of courses where in students have received grades for every one of the possible grade types offered in the course. Order by course number.4- List course number and description all of the Java courses and the total number of enrollments for each course. Arrange by course number. Show zero for courses with no students enrolled.5-List student ID and Name of all of the students in area code 617 along with the number of enrollments each has. If the students has not enrolled in any courses, display the word “none” in the enrollments column.Alphabetize the list on last name and first name.

Test Methods for Software Where do you draw the line while doing domain testing? Please provide a succinct summary of each.