11 Weeks โข Comprehensive Coverage โข Full Mark Preparation
Foundation concepts and computer components
A diverse set of technological tools and resources used to communicate, and to create, process, store, and manage information.
When you order from Trendyol or Amazon:
The "brain" of the computer that executes instructions
Components:
RAM: Random Access Memory (volatile, fast)
ROM: Read-Only Memory (permanent)
Cache: Ultra-fast temporary storage
HDD: Hard Disk Drive (mechanical)
SSD: Solid State Drive (faster, no moving parts)
Cloud: Remote storage via internet
Main circuit board connecting all components
| Input Devices | Output Devices |
|---|---|
| Keyboard, Mouse, Scanner, Microphone, Camera, Touch Screen | Monitor, Printer, Speaker, Projector, Headphones |
| Generation | Period | Technology | Examples |
|---|---|---|---|
| 1st | 1940s-1950s | Vacuum tubes | ENIAC, UNIVAC |
| 2nd | 1950s-1960s | Transistors | IBM 1401 |
| 3rd | 1960s-1970s | Integrated Circuits | IBM 360 |
| 4th | 1970s-1990s | Microprocessors | Personal Computers |
| 5th | 1990s-Present | AI, Cloud, Mobile | Smartphones, IoT, Supercomputers |
Understanding software types and OS fundamentals
Without software, hardware is useless!
Controls and manages computer hardware
Examples:
Performs specific tasks for users
Examples:
Improve performance and security
Examples:
Manages hardware, files, memory, and user interface
| Type | Examples | Use Case |
|---|---|---|
| Desktop OS | Windows, macOS, Linux | Personal computers |
| Mobile OS | Android, iOS | Smartphones, tablets |
| Server OS | Windows Server, Linux | Web servers, databases |
| Embedded OS | ATM systems, Car computers | Specialized devices |
E-learning platforms, OBS portal, online courses
E-Nabฤฑz system, medical records, telemedicine
Online banking, mobile payments, ATMs
E-commerce, Trendyol, Amazon
E-Devlet, digital services, online taxes
Streaming, gaming, social media
System design and networking fundamentals
Determines system performance and organization
| Type | Coverage | Example |
|---|---|---|
| PAN (Personal Area Network) | Few meters | Bluetooth, USB |
| HAN (Home Area Network) | Single home | Home Wi-Fi, IoT devices |
| LAN (Local Area Network) | Building/Campus | Office network, school network |
| MAN (Metropolitan Area Network) | City-wide | City network connecting multiple LANs |
| WAN (Wide Area Network) | Large geographic area | Internet |
All devices connected to a single cable
โ
Simple, low cost
โ Single point of failure
Devices connected in a circular chain
โ
Equal access
โ Break affects all
All devices connect to central hub
โ
Easy to manage
โ Hub failure affects all
Multiple interconnections
โ
High reliability
โ Expensive
| Layer | Function | Protocols/Examples |
|---|---|---|
| Application Layer | Communication between applications | HTTP, SMTP, FTP, DNS |
| Transport Layer | Reliable data transfer | TCP (reliable), UDP (faster) |
| Internet Layer | IP addressing and routing | IP Protocol |
| Network Access Layer | Physical network interface | Ethernet, Wi-Fi |
Block unauthorized access
Protect data in transit
Detect and remove malware
Secure remote connections
Organizing, storing, and managing digital files
A named collection of related information stored on secondary storage
| DO โ | DON'T โ |
|---|---|
| Use descriptive names | Use vague names |
| Include dates (YYYY-MM-DD) | Use spaces |
| Use underscores or hyphens | Make names too long |
| Be consistent | Use special characters (< > : " | ? *) |
ICT_Lecture4_2024-03-15.pdfnew doc (1).docx
| Service | Free Storage | Benefits |
|---|---|---|
| Google Drive | 15 GB | Google integration, collaboration |
| OneDrive | 5 GB | Microsoft Office integration |
| Dropbox | 2 GB | Easy sync, file versioning |
AI, Cloud Computing, IoT, Cybersecurity, and more
Learns from labeled data
Example: Email spam detection
Discovers hidden patterns
Example: Customer segmentation
Replaces local hardware with virtual services
| Service | Description | Examples |
|---|---|---|
| IaaS (Infrastructure as a Service) |
Virtual servers and infrastructure | AWS, Azure, Google Cloud |
| PaaS (Platform as a Service) |
App development tools and platforms | Heroku, Google App Engine |
| SaaS (Software as a Service) |
Online applications | Google Workspace, Office 365 |
Collect and exchange data to improve efficiency
Smart thermostats, lights, security cameras
Fitness trackers, smartwatches
Manufacturing monitoring, predictive maintenance
Soil moisture sensors, weather monitoring
Fake emails to steal information
Viruses, trojans, ransomware
Encrypts data, demands payment
Unauthorized data exposure
Document creation and professional formatting
Part of Microsoft 365, used in offices, universities, and public institutions
| Era | Technology |
|---|---|
| 1950s-60s | Electric typewriters (limited editing) |
| 1970s | Early computer word processors (WordStar, WordPerfect) |
| 1983 | Microsoft Word - GUI, menus, rich formatting |
| 2000s-Now | Cloud integration, AI-assisted editing, collaboration |
Font, paragraph, styles, clipboard
Tables, pictures, shapes, headers/footers
Margins, orientation, columns, breaks
Table of contents, citations, footnotes
Styles (Heading 1/2): Create document structure + automatic table of contents
Ensures consistency and professional appearance
Spreadsheets, formulas, and data visualization
Vital for data entry/management, analysis/reporting, and decision support in ICT
Changes when copied
Stays fixed when copied
Partially fixed
Examples: =A1+B1, =A1*B1, =A1-B1
Excel recalculates automatically when values change
| Function | Purpose | Example |
|---|---|---|
=SUM(A2:A10) |
Adds a range of numbers | Total sales |
=AVERAGE(B2:B10) |
Finds the mean | Average grade |
=MIN(C2:C10) |
Smallest value | Minimum price |
=MAX(C2:C10) |
Largest value | Maximum score |
=ROUND(D2,2) |
Rounds to decimal places | 4.5678 โ 4.57 |
=COUNTIF(B2:B8,">=50") counts cells โฅ 50Excel Tables: Structured data with automatic filtering and formulas
Compare values across categories
Show trends over time
Show proportions/percentages
Show relationships between variables
Visual snapshot that updates with the pivot table
Useful for e-Devlet usage statistics by service
Data management and structured query language
Stored electronically in a computer system
Used to create, read, update, and delete data
| Category | Purpose | Commands |
|---|---|---|
| DDL (Data Definition) | Define database structure | CREATE, DROP, ALTER, TRUNCATE |
| DML (Data Manipulation) | Manipulate data | INSERT, UPDATE, DELETE |
| DQL (Data Query) | Query data | SELECT |
| DCL (Data Control) | Control access | GRANT, REVOKE |
| TCL (Transaction Control) | Manage transactions | COMMIT, ROLLBACK, SAVEPOINT |
| Function | Purpose | Example |
|---|---|---|
| COUNT() | Count rows | SELECT COUNT(*) FROM Employees; |
| SUM() | Sum values | SELECT SUM(Salary) FROM Employees; |
| AVG() | Average value | SELECT AVG(Salary) FROM Employees; |
| MAX() | Maximum value | SELECT MAX(Salary) FROM Employees; |
| MIN() | Minimum value | SELECT MIN(Salary) FROM Employees; |
Flexible schema and horizontal scalability
MongoDB, CouchDB
Store JSON-like documents
Redis, DynamoDB
Simple key-value pairs
Cassandra, HBase
Wide-column stores
Neo4j, ArangoDB
Network relationships
| Use SQL When... | Use NoSQL When... |
|---|---|
| Structured data | Unstructured/semi-structured data |
| Strong consistency needed | High scalability needed |
| Complex queries and joins | Simple queries |
| Transactional systems | High-speed read/write |
Historical data storage and OLAP queries
Understanding large-scale data processing
Raw facts and figures
Unprocessed, no context
Example: 35, 25, 40
Processed data with meaning
Context and interpretation
Example: Average age is 33.3 years
Massive amounts of data (petabytes)
High-speed data generation and processing
Different data types and sources
Data quality and accuracy
Extracting meaningful insights
Process large volumes at scheduled times
Example: Daily sales reports
Process data as it arrives
Example: Stock trading, fraud detection
Continuous data flow processing
Example: IoT sensor data, social media feeds
Turning data into actionable insights
Focus: Past and current business performance
| Business Intelligence | Analytics |
|---|---|
| What happened? (Descriptive) | Why did it happen? (Diagnostic) |
| Historical data analysis | Predictive and prescriptive |
| Reporting and dashboards | Advanced statistical analysis |
| Business users | Data scientists |
Historical data storage and supports OLAP queries
Popular business analytics tool
Visual analytics platform
Self-service BI
Accessible and familiar
Enterprise BI suite
Helps monitor performance quickly and make data-driven decisions
What happened?
Reports, dashboards
Why did it happen?
Drill-down analysis
What will happen?
Machine learning models
What should we do?
Recommendations, optimization
Managing ICT projects and software development
Project Management: Balancing scope, time, cost, and quality
Web apps, mobile apps, enterprise software
Network design, installation, upgrades
ERP, CRM, database systems
Security audits, penetration testing
Each phase completed before the next begins
Focus on customer collaboration and flexibility
Work delivered in small pieces called iterations or sprints (typically 1-4 weeks)
Defines features and priorities
Manages product backlog
Facilitates process
Removes obstacles
Builds the product
Self-organizing
| Aspect | Waterfall | Agile |
|---|---|---|
| Approach | Sequential, linear | Iterative, incremental |
| Requirements | Fixed at start | Can change |
| Customer Involvement | Beginning and end | Continuous |
| Testing | After implementation | Throughout development |
| Delivery | End of project | Frequent releases |
| Documentation | Extensive | Minimal, sufficient |
| Best For | Stable requirements, regulated | Changing requirements, innovation |
Eliminate the risk
Reduce likelihood or impact
Shift risk to third party
Acknowledge and monitor
Visual timeline showing tasks, dependencies, milestones
Visual workflow management (To Do, In Progress, Done)
Track remaining work in sprint
Document risks, probability, impact, responses
โ ICT definition and components
โ Hardware: CPU, memory, storage
โ Computer generations
โ Software types
โ Operating systems
โ ICT applications
โ Computer architecture
โ Network types and topologies
โ TCP/IP protocols
โ Network security
โ File management
โ Organization strategies
โ Backup and recovery
โ Cloud storage
โ AI and Machine Learning
โ Cloud Computing (IaaS, PaaS, SaaS)
โ IoT applications
โ Cybersecurity threats
โ Microsoft Word interface
โ Document formatting
โ Styles and templates
โ Professional communication
โ Excel interface and functions
โ Formulas (SUM, AVERAGE, IF)
โ Charts and visualization
โ Pivot tables
โ Database fundamentals
โ Relational model
โ SQL queries (SELECT, INSERT, UPDATE)
โ NoSQL databases
โ Data vs Information
โ Big Data (5 V's)
โ Hadoop and MapReduce
โ Data processing types
โ Business Intelligence
โ BI architecture and tools
โ Dashboards and KPIs
โ Analytics types
โ Project management basics
โ Waterfall methodology
โ Agile and Scrum
โ Risk management
You now have a comprehensive understanding of all 11 weeks of ICT material.
Review regularly, practice with examples, and you'll ace your exams!
Good luck! ๐ช