Section outline

  • 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, 4th 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.