UrbanTution
UrbanTution
Overview
Course Description
Informatics Practices is a course to get acquainted with computer terminologies and operation handling. The aim of the subject is to make a student: Understand the application development process. Gain programming skills in front-end application development. Gain skills in Database Creation and querying using ANSI SQL.
What you'll learn
Basic computational thinking.
Learn how to reason with variables
Learn state transitions and conditionals and iteration.
Notion of data types
Notion of higher order data structures such as lists and dictionaries.
Concepts of data handling: creating managing
and working with Data Frames using Python Pandas.
Structure of simple SQL queries.
Cyber safety.
Requirements
A Computer
Willing to learn about Informatics Practices
Course Content
- Basic computer organisation: describe a computer system and mobile system, CPU, memory,hard disk, I/O, battery, power, transition from a calculator to a computer
- Familiarization with the basics of Python programming: a simple ?hello world" program, process of writing a program, running it, and print statements; simple data-types: integer, float, string
- Introduce the notion of a variable, and methods to manipulate it (concept of L-value and Rvalue even if not taught explicitly)
- Knowledge of data types and operators: accepting input from the console, assignment statement, expressions, operators and their precedence.
- Conditional statements: if, if-else, if-elif-else; simple programs: e.g.: absolute value, sort 3 numbers, divisibility.
- Notion of iterative computation and control flow: for, while, flowcharts, decision trees and pseudo code; write a lot of programs: interest calculation, EMI, tax calculation (examples from GST), standard deviation, correlation
- Lists and dictionary: finding the maximum, minimum, mean; linear search on a list of numbers, and counting the frequency of elements in a list using a dictionary.
- Text handling: compare, concat, and substring operations.
- Introduction to Python modules: creating and importing.
- Introduction to data structures in Pandas: Series, and Data Frame
- Operations on a Series: head, tail, vector operations
- Data Frame operations: create, display, iteration, select column, add column, delete column
- Binary operations in a Data Frame: add, sub, mul, div, radd, rsub
- Matching and broadcasting operations
- Missing data and filling values.
- Comparisons, Boolean reductions, comparing Series, and combining Data Frames.
- Cyber safety: safely browsing the web, identity protection, confidentiality, social networks, cyber trolls and bullying
- Appropriate usage of social networks: spread of rumours, and common social networking sites (Twitter, LinkedIn, and Facebook) and specific usage rules.
- Safely accessing web sites: adware, malware, viruses, Trojans
- Safely communicating data: secure connections, eavesdropping, and phishing and identity verification.
UrbanTution