Topic outline

Collapse all Expand all
• Select topic General

  General
  • Select activity Announcements

    

    Forum

    Announcements Forum
• Select topic Test related to basic Computer Science and Statistics - Admission to the Academic Year 2023-2024

  Test related to basic Computer Science and Statistics - Admission to the Academic Year 2023-2024

  
  TEST SYLLABUS
  

  Computer Science:

  1. Propositional logic
  2. Conditions
  3. Loops
  4. Variables
  5. Arrays, lists, dictionaries (hash)
  6. Functions
  7. Tables of relational databases
  8. Select From Where (1 table)
  9. Internal Join
  10. External Join.

  
  Statistics:
  

  1. Measures of central tendency
  2. Measures of dispersion
  3. Contingency tables
  4. Linear correlation
  5. Random variables
  6. Probability function, density function and cumulative distribution function
  7. Expectation
  8. Gaussian distribution
  9. Stochastic independence
  10. Probability of independent events
  11. Law of large numbers
  12. Central limit theorem
  13. Conditional distribution and conditional expectation
  14. Linear regression.

  
  TEST TEXTBOOKS
  
  

  1. Database System Concepts. Avi Silberschatz, Henry F. Korth, S. Sudarshan
  2. Introduction to the Theory of Statistics. Alexander M. Mood, Franklin A. Graybill, Duane C. Boes. McGraw-Hill
  3. Introductory statistics, Ross S.M., ELSEVIER ACADEMIC PRESS, 4^th ed., 2017, ISBN: 978-0-12-804317-2,0128043172
  4. Think Python 2nd Edition by Allen B. Downey.

  
  
  TEST EXAMPLES
  
  

  Q: What is the result of the following query?
       SELECT name, surname
       FROM students
       WHERE mean > 25

  A1: All names and surnames of the students with a mean greater than 25.
  A2: All names and surnames of the students with a mean greater than or equal to 25.
  A3: All data of the students with a mean greater than 25.
  A4: All data of the students with a mean greater than or equal to 25.
  A5: All names and surnames, without duplicates, of the students with a mean greater than 25.
  A6: All names and surnames, without duplicates, of the students with a mean greater than or equal to 25.

  
  Q: You have to compare the dispersion of the two variables X and Y in a population. Which of the following measures can be reasonably compared?
  

  A1: Second moments of X and Y, with X and Y having different means.
  A2: Variances of X and Y, regardless of their means.
  A3: Mean squared errors of X and Y about zero, if their means are not zero.
  A4: Coefficients of variation of X and Y, when at least one of the two variables has the mean equal to zero.
  A5: Mean and median of X with mean and median of Y.