Romania Clasa a XI-a ICT (natural sciences)

Chapters: 3

1. Modern user skills

Data and processing

Data Types, Operators and Errors in Python – Every value in Python has a data type: numbers (int, float, complex), bool (True/False), None, sequences (str, list, tuple) and mapping (dict). Mutable types (list, dict) can be changed in place; immutable types (int, float, bool, str, tuple) cannot. Operators are arithmetic (+ − * / // % **), relational (< > <= >= == !=), logical (and, or, not), assignment (= += −= …), identity (is, is not) and membership (in, not in). Precedence decides the order of evaluation, with ** highest and or lowest. Type conversion can be implicit (automatic, int → float) or explicit (int(), float(), str()). input() reads text as a string; print() shows output with sep and end. Errors are syntax errors (grammar), runtime errors or exceptions (crash while running) and logical errors (wrong answer).

Analysing a task · Word processor and spreadsheet

Spreadsheets in Accounting: Formulas, BRS, Schedules, Ratios and Charts – A spreadsheet is a grid of rows and columns where each cell can hold a number, a word or a formula. When one number changes, every formula that uses it updates by itself. Accountants use spreadsheets for bank reconciliation, depreciation and loan schedules, payroll, ratio analysis and charts.

Team project

Coming soon