Poland Liceum ogólnokształcące, klasa II Computer science

1. Programming and solving problems with computers

Programming · Graphics and documents · Spreadsheets and databases · Presentations, web pages, information search

• Programming Basics: Sequence, Selection, Loops and Functions – A program is a set of exact instructions a computer follows. Every program is built from three structures: sequence (steps in order), selection (if/else choices) and iteration (loops). Variables store values. Functions group code into reusable, named blocks, which makes programs modular and easier to test, debug and maintain.
• Graphic Design – Graphic design is planning pictures, words and shapes so that a message is clear, useful and attractive. Designers use elements (line, shape, colour, type, image, space) and principles (alignment and grid, hierarchy, contrast, proximity, repetition, balance and white space). They follow a process: brief, research, ideas, sketches, digital drafts, feedback and final artwork. Graphic design is used in posters, logos, book covers, packaging, signs, websites and apps.
• Database Concepts: DBMS, Relations and Keys – Keeping data in separate files causes duplication, inconsistency and poor security. A database stores related data in one organised place, and a DBMS (like MySQL) is the software that manages it. In the relational model, data is kept in tables (relations) made of columns (attributes) and rows (tuples); a domain is the set of allowed values of a column. A candidate key uniquely identifies each row; one is chosen as the primary key and the others are alternate keys.
• Web Development: How HTML, CSS and JavaScript Build a Web Page – A web page is a set of text files. The browser (client) asks a server for them using a URL and HTTP. HTML gives the page its structure: headings, paragraphs, links, images, lists, tables and forms. CSS gives style: colours, fonts, spacing and layout. JavaScript gives behaviour: it reacts to clicks and changes the page. Responsive design makes one page fit both phones and computers. Good pages are also accessible, fast and safe.