Types of software
System: OS (Windows, Linux). Application: word processor, spreadsheet. Utility: antivirus. Web: browser, email.
Resource 1 of 2
Lesson overview
This lesson brings together the PDF, study notes and chapter flow so you can revise Software without losing the thread.
Types of software
System: OS (Windows, Linux). Application: word processor, spreadsheet. Utility: antivirus. Web: browser, email.
Free vs proprietary software
Free/open source: accessible code. E.g.: Linux, LibreOffice. Proprietary: closed code, paid license. E.g.: Windows, MS Office.
Text formatting
Font, size, bold (Ctrl+B), italic (Ctrl+I), underline (Ctrl+U). Alignment: left, center, right, justify.
Page layout
Margins, orientation (portrait/landscape), paper size. Header and footer. Page break (Ctrl+Enter).
Tables and objects
Insert table: rows and columns. Insert image, shape, chart.
Cells and references
Cell = row-column intersection (e.g. A1, B3). Absolute reference (1): doesn't change on copy. Relative (A1): adapts.
Basic functions
=SUM(A1:A10). =AVERAGE(A1:A10). =MAX(). =MIN(). =COUNT().
Creating a chart
Select data → Insert → Chart → Choose type (bar, line, pie). Add title and legend.
Understand before memorizing
Connect each concept to a concrete use: hardware, operating system, algorithm, program, file, or network.
Algorithms
Clearly describe inputs, processing, outputs, variables, and control structures before writing code.