Academic year 2021 - 2022

•     Industrial Project 1 R504D69-3001 14.03.2022-30.04.2022  5 cr  (R54D21S) +-
  Learning objectives

  The student becomes familiarized with the work life while deepening their understanding of personal profession. The student becomes acquainted with a partner company or organisation. The student can set personal learning objectives and monitor own performance. The student can consider sustainable and ethical solutions in professional work.

  Contents

  - Setting personal learning objectives, following personal development
  - Norms and culture in working life
  - Applying learned skills and knowledge in practice in real projects and work
  - Ethical issues and sustainability in own profession

  ---

  Teaching methods and instruction

  Lectures, Assignments, Project based learning
  
  During the classes various examples combining theory and practice will be studied. Course includes lots of practical work in in a student team.

  Responsible person

  Aku Kesti

  Learning material and recommended literature

  Flask Web Development 2e, Miguel Grinberg (2018)
  Python For Dummies, Stef Maruch, Aahz Maruch

  Teachers

  Aku Kesti, Kenneth Karlsson

  Working life connections

  During the study unit a practical work life project will be implemented using RC cars including sensors and website developing. The work in the student teams simulate real work life situation. Student learns how to plan, agree about project tasks and contribute in a team.

  Teaching language

  Finnish

  Timing

  14.03.2022 - 30.04.2022

  Learning assignments

  The study unit is 5 credits and corresponds to approximately 130 hours work. We will split the time as follows:
  
  Lectures 40h
  Implementing the exercises (Indepent work): 40h
  Project work: 50h

  Enrollment

  01.10.2021 - 31.01.2022

  Content scheduling

  - Basics of back end and flask programming
  - Ajax / Axios
  - Jinja2 template engine
  - Databases and Flask
  - MVC Architecture
  - Authentication
  - Project work in the teams

  Location and time

  Lessons in the classrooms according to the timetable
  In addition the course includes independent and team work in the computer class rooms

  Groups

  • R54D21S

  The project work and assignments will be evaluated.
  
  Grade: Rejected - 5.

  Mode of delivery

  Contact teaching

  Degree Programmes

  Machine Learning and Data Engineering

  R&D proportion

  4 cr

  Evaluation scale

  H-5

  Credits

  • 5 cr

  Unit

  Bachelor of Engineering, Information Technology

Academic year 2022 - 2023

•     Relational Databases R504D66-3001 05.09.2022-23.10.2022  5 cr  (R54D21S) +-
  Learning objectives

  The student knows the principles of relational databases and is capable to design a relational database and apply it in practice to information management.

  Contents

  - Concept analysis
  - Relational Models
  - Basics of SQL commands (SELECT, DML, DDL)

  Assessment criteria

  Assessment criteria - grade 1

  The student knows the structure of a relational database.
  
  The student can utilize simple SQL statements in database processing.

  Assessment criteria - grade 3

  The student outlines the principles of relational databases.
  
  The student can complete a concept analysis, create a relational database model and utilize the most common SQL statements in data management.

  Assessment criteria - grade 5

  The student can perform concept analysis and create a context-based relational database model.
  
  The student can use SQL commands in a versatile manner in database processing.

  ---

  Teaching methods and instruction

  Lectures, assignments and tutorials. Inn addition code labs which are meant for tutoring the exercises.

  Responsible person

  Aku Kesti

  Learning material and recommended literature

  Materials in our learning environment, moodle. In addition you can use the literature to support your learning. For example:
  
  SQL QuickStart Guide: The Simplified Beginner's Guide to Managing
  Author: Shields, Walter
  
  The Art of SQL
  Author:Faroult, Stephane

  Teachers

  Aku Kesti

  Teaching language

  English

  Internationality

  The study unit will be taught in English and makes it possible for international students to join

  Timing

  05.09.2022 - 23.10.2022

  Learning assignments

  There will be 11 teaching sessions. Each session will take from 3 to 4 hours. In addition the student must complete the exercises on his / her own time which will take approximately 40 hours. Studying and deepening theoretical knowledge will also take about 40 hours.

  Enrollment

  14.03.2022 - 29.08.2022

  Content scheduling

  General about SQL Databases
  Tables
  Queries and Changing the data
  Filtering
  Aggregate functions
  Dataset operation
  Sorting and Grouping
  Working with multiple tables
  Database design and modeling
  Other option, NOSQL

  Location and time

  Lessons and code labs are hold in the computer class rooms at Rantavitikka campus in the autumn 2022.

  Groups

  • R54D21S

  Mode of delivery

  40% Contact teaching, 60% Distance learning

  Seats

  0 - 25

  Degree Programmes

  Machine Learning and Data Engineering

  R&D proportion

  1 cr

  Virtual proportion

  3 cr

  Evaluation scale

  H-5

  Credits

  • 5 cr

  Unit

  Bachelor of Engineering, Information Technology