Study Guide

Objective

- The student is able to program with the Python programming language
- The student understands in what circumstances the this language is at its best and what the strengths and weaknesses are
- The student has capabilities to utilize the possibilities of Python in IT projects where Python is needed

Content

Python language
- Introduction to Programming
- Inputs and Outputs
- Control structures
- Functions and Modules
- Data Structures
- Object-Oriented Programming
- Exception Handling
- File Handling
- Standard Library
- Web Programming
- Interfaces
- Efficiency Issues

Prerequisites

Introduction to Computing

Assessment criteria, satisfactory (1)

The student understands the basic structures of Python programming. The student can produce simple programs independently and can solve common problems in the most simple way, like calculating an average of given numbers without using an array. The student understands how the basic control structures relate to the productivity of programming and to the resource requirements of information systems
The student understands the need for databases and their role as a part of an information system. The student is familiar with the idea and objective of conceptual modelling.

Assessment criteria, good (3)

The student knows how to apply control structures and implement simple algorithms. The student is able to apply the knowledge of productivity of programming and resource requirements of information systems.
The student is able to explain the role of a database and the database management system in layered architecture. The student is able to apply the techniques of conceptual design.

Assessment criteria, excellent (5)

The student can develop simple programs. The student knows how to apply and choose right solution patterns. The student can learn new programming techniques from written material when problems arise.

Assessment criteria, approved/failed

The student understands the basic structures of Python programming. The student can produce simple programs independently and can solve common problems in the most simple way, like calculating an average of given numbers without using an array. The student understands how the basic control structures relate to the productivity of programming and to the resource requirements of information systems
The student understands the need for databases and their role as a part of an information system. The student is familiar with the idea and objective of conceptual modelling. The student understands the concepts of table, field, primary key and foreign key as well as integrity constraint in the context of the relational model. The student is able to identify the integrity constraints of the database. The student is able to identify other data models. The student knows the basic operations of relational algebra. The student is able to write SQL queries on one table using selection criteria. The student is able to run the queries written by himself/herself on the database management system.