Notebooks for Computer Science

This page provides a guide to the Notebooks used in the coursecontains tutorials and exercises for the course on Computer Sciences of the Bsc in Engineering and Management at EDEM. The course will cover two teaching units with this online book:

• Programming Fundamentals: Learn computer programming fundamentals with Python
• Databases: Learn the basics of database systems and structured query language programming

Each teaching unit contains:

• Tutorials: Follow along tutorials for each of the classes.
• Class Exercises: Exercises to do during class to better understand the content. Class exercises must be submitted after every class.
• Exam Exercises: Extra exercises you can do prepare for the exam

Programming Fundamentals

This section contains a guide of the supporting materials for the materials used in each lecture:

• Lecture 1:

  • Tutorials:
    • Tutorial 0. Intro to Computer Programming
    • Tutorial 1. Intro to Jupyter Notebooks (Hello World)
  • Class Exercises:
    • Assignment 1: Basic programs with built-in functions

• Lecture 2: Variables and Basic Operations.

  • Tutorials:
    • Tutorial 2. Variables
  • Class Exercises:
    • Assigment 2: Variables and Basic Operations

• Lecture 3: Basic Control Structures.

  • Tutorials:
    • Tutorial 3. Basic Control Structures
  • Class Exercises:
    • Assignment 3: Basic Control Structures

• Lectures 4-5: Iterable Objects

  • Tutorials:
    • Tutorial 4. Iterable Objects I
    • Tutorial 5. Iterable Objects II
  • Exercises:
    • Assignment 4: Iterables

• Lecture 6: Functions

  • Tutorials:
    • Tutorial 6. Functions
  • Exercises:
    • Assignment 5: Functions

• Lecture 6: Object Oriented design (Not covered in class)

  • Tutorials: (Not covered in class) - Tutorial 7. Objects](https://computer-science-tutorials.readthedocs.io/en/latest/Modularization/tutorials/Objects.html)[](https://colab.research.google.com/github/ffraile/computer_science_tutorials/blob/main/source/Introduction/tutorials/Objects.ipynb)

  - Exercises: (** Not covered in class**) - Assignment 6. Objects

• Lecture 7: Array Programming

  • Tutorials:
    • Tutorial 8. Importing External Modules
    • Tutorial 9. Introduction to Numpy (Not covered in partial exam)
    • Tutorial 10. Linear Algebra with Numpy (Not covered in partial exam)
  • Exercises:
    • Assigment 7. Numpy(Not covered in partial exam)

• Lecture 8: Data Manipulation and Analysis

  • Tutorials:
    • Tutorial 11. Files(Not covered in partial exam) - Tutorial 12. Data Manipulation with Pandas (Not covered in class) - Exercises: (Not covered in class) - Assignment 8. Data manipulation (Not covered in class)

- Lecture 9: Data Manipulation and Analysis II (Not covered in class) - Tutorials: - Tutorial 13. Data Visualization with Matplotlib

• Exam Exercises:
• Exercise 1. Fibonnacci series
  • (Solved)
• Exercise 2. Quadratic Equations
  • (Solved)
• Exercise 3. Student Marks
  • (Solved)
• Exercise 4. Shopping List
  • (Solved)
• Exercise 5. Harshad Numbers
  • (Solved)
• Exercise 6. The Dice Man
  • (Solved)
• Exercise 7. Bank job
  • (Solved)
• Exercise 8. Chatbot
  • (Solved)
• Exercise 9. FinanceBot
  • (Solved)
• Exercise 10. PizzaBot
  • (Solved)
• Exercise 9. Padovan Sequence
  • (Solved)
• Exercise 10. Thue-Morse Sequence
  • (Solved)
• Exercise 10. Game Statistics
  • (Solved)

Databases

• Lecture 1: Introduction to SQL:
  • Tutorials:
    • Introduction to Databases
    • Introduction to SQL
    • Test environment
  • Exercises
    • Introduction to SQL Exercises
• Lecture 2: Join queries:
  • Tutorials:
    • Indexing and Join clauses
  • Exercises:
    • Join queries Exercises
• Lecture 3: Data types and functions:
  • Tutorials:
    • Data types and functions
  • Exercises:
    • Data types and functions Exercises
• Lecture 4: Sorting and grouping:
  • Tutorials:
    • Sorting and grouping
  • Exercises:
    • Sorting and grouping Exercises

Test databases

• Folder with the databases used in the tutorials and exercises