Online Survey | Built with Qualtrics Experience Management™

Dear Applicant

Please answer the questions asked in this form. Your answers to questions in this form to help us and you to determine if you’re prepared to succeed in the program. Prerequisites for the program include a programming course, a statistics course, and a database course. If you’ve successfully completed an appropriate course, please tell me which course to look for on your transcript? If you haven’t taken an appropriate course, please briefly describe your experience in that area.

Note: You can email answers to programming challenge question, Database/SQL and statistics question in separate documents if needed. Email id to send the documents is kumars@uwgb.edu

Sampath Kumar

Academic Director- MS-DS program

Please enter your Full Name (First, Last)

Prerequisites for the MS DS program include a programming course, a statistics course, and a database course. If you’ve successfully completed an appropriate course, please tell me which course to look for on your transcript? If you haven’t taken an appropriate course, please briefly describe your experience in that area.

(Write the name of the course and university in the appropriate text box)

Programming course

Statistics course

Database course

If you haven’t taken an appropriate course, please briefly describe your experience in that area.

Please indicate your comfort level on the scale of 0-3 (0 – Not familiar at all; 1 – Little knowledge; 2 – Fair Understanding; 3 – Expert) for the following subjects / topics / questions.

For statistics level courses your knowledge in following topics are:

Please indicate your comfort level on the scale of 0-3 (0 – Not familiar at all; 1 – Little knowledge; 2 – Fair Understanding; 3 – Expert) for the following subjects / topics / questions.

For statistics level courses your knowledge in following topics are:
	Not Familiar at all	Little knowledge	Fair understanding	Expert
Descriptive statistics: Mean, median, Mode, Standard deviation, variance	Not Familiar at all	Little knowledge	Fair understanding	Expert
Probability, rules, concepts	Not Familiar at all	Little knowledge	Fair understanding	Expert
Permutations and combinations	Not Familiar at all	Little knowledge	Fair understanding	Expert
Scatter plot; Histogram; Correlation Analysis	Not Familiar at all	Little knowledge	Fair understanding	Expert
Data types	Not Familiar at all	Little knowledge	Fair understanding	Expert
Probability distributions	Not Familiar at all	Little knowledge	Fair understanding	Expert
Simple Regression	Not Familiar at all	Little knowledge	Fair understanding	Expert
Hypothesis testing	Not Familiar at all	Little knowledge	Fair understanding	Expert
Confidence Interval/ Margin of error	Not Familiar at all	Little knowledge	Fair understanding	Expert

Please indicate your comfort level on the scale of 0-3 (0 – Not familiar at all; 1 – Little knowledge; 2 – Fair Understanding; 3 – Expert) for the following subjects / topics / questions.

For programming level courses your knowledge in following topics are:

Please indicate your comfort level on the scale of 0-3 (0 – Not familiar at all; 1 – Little knowledge; 2 – Fair Understanding; 3 – Expert) for the following subjects / topics / questions.

For programming level courses your knowledge in following topics are:
	Not Familiar at all	Little knowledge	Fair understanding	Expert
Repetition: Loops / While / For	Not Familiar at all	Little knowledge	Fair understanding	Expert
Selection Statements: If, case, switch	Not Familiar at all	Little knowledge	Fair understanding	Expert
Function/Method: Return types/values; Arguments list; Parameters	Not Familiar at all	Little knowledge	Fair understanding	Expert
Arrays/Lists	Not Familiar at all	Little knowledge	Fair understanding	Expert
Objects/OOP: What is it?	Not Familiar at all	Little knowledge	Fair understanding	Expert
Simple Data Structures: Queue, Stack; Hash Table	Not Familiar at all	Little knowledge	Fair understanding	Expert

Database / SQL

https://www.khanacademy.org/computing/computer-programming/sql
Introduction to SQL: Querying and managing data/ Khan academy

Please indicate your comfort level on the scale of 0-3 (0 – Not familiar at all; 1 – Little knowledge; 2 – Fair Understanding; 3 – Expert) for the following subjects / topics / questions.

For Database/ SQL level courses your knowledge in following topics are:

Database / SQL

https://www.khanacademy.org/computing/computer-programming/sql
Introduction to SQL: Querying and managing data/ Khan academy

Please indicate your comfort level on the scale of 0-3 (0 – Not familiar at all; 1 – Little knowledge; 2 – Fair Understanding; 3 – Expert) for the following subjects / topics / questions.

For Database/ SQL level courses your knowledge in following topics are:
	Not Familiar at all	Little knowledge	Fair understanding	Expert
SQL Basics: basics of creating tables and selecting data in various different ways.	Not Familiar at all	Little knowledge	Fair understanding	Expert
SQL Queries: AND/OR, IN, LIKE, HAVING	Not Familiar at all	Little knowledge	Fair understanding	Expert
Joins: inner joins, outer joins, and self joins	Not Familiar at all	Little knowledge	Fair understanding	Expert
Modifying databases with SQL: UPDATE, DELETE, ALTER, and DROP.	Not Familiar at all	Little knowledge	Fair understanding	Expert

Programming Challenge Question:

Write a program that reads in 2 numbers, call them n and m. Compute the nth Fibonicci number and the mth Fibonacci number and then find the greatest common factor of those two numbers. For example, if I typed in 11 and 16, the answer would be 5. The 11th Fibonacci number is 55 and the 16th one is 610. The greatest common factor is 5. You should ensure the user types in a positive number and ask again if the user doesn't.

Please provide solution as well!

(Note: Do not use built in functions or libraries such as those available in R or Python)

(If needed you can email me the answer to this question and next two questions in a separate document instead of typing it here)

Statistics Challenge question

You are examining if people like Coke or Pepsi equally. The p-value came out to be .03. Interpret this number (and explain as clearly as you could without using the statistical jargon). Will your interpretation be any different if the p-value had been .06 instead of .03? Please explain. What are all the null and alternative hypotheses in this case?

Please provide the solution as well

Database Challenge Question:

Let's say you have a customer table and an orders table where a customer can have many orders. Could you write a SQL query to return the top five customer names based on the dollar amount ordered? You can assume the tables have reasonable columns like customerFirstName, customerID, orderCost, etc.

Thank you for taking the survey and your interest in our MS- DS program