Please enable JavaScript.
Coggle requires JavaScript to display documents.
class ipeka puri Informatics ellenore : - Coggle Diagram
class ipeka puri Informatics ellenore :
Computer network
Benefits
Sharing data and information
Sharing hardware
Faster communication
Time and cost efficiency
Network type based on range
Local Area Network (small scale)
Metropolitan Area Network (City scale)
Wide Area Network (Inter country)
Personal Area Network (around 10m)
Campus Area Network (uni scale)
Storage Area Network (high-speed data storage)
Components
Hardware = Cables, switches, routers, modems
Software = Network protocol, operating system
User = A person who acessed the network
Network type
Cable = WIred connection (Lan, Backbone, RJ45, Switch)
Wireless = Wireless connection (WIFI, Bluetooth, satellite, cellphone, IR)
Internet
Understanding
The world's largest computer network, connecting millions of devices
Benefit
Source of information and knowledge
Coommunivcation media
Entertainment
Support online learning
Internet services
Web = Site page based information
Email = Electronic mail
Cloud storage = online storage
Social media = interaction between user
Impact
Positive
Quick information
Broad horizon
Make work easier
negative
spread hoax
Gadget addiction
data misuse
Computer system
Understanding
A computer system is an electronic device that can be programmed to receive data (input), process it, and present the results (output) to users for meaningful work. This system consists of three main components that cannot be separated.
Computer system pilar
Hardware
Input devices = Keyboard, mouse,scanner, microphone
Processing device = Processor
Ourput device = Monitor, Printer, Speaker, Projector
Software
system =
Windows
macOS
Linux / Android
Application
Microsoft Word (Typing)
Google Chrome (Browsing)
Photoshop (Photo Editing)
Brainware
Programmer
Analisis data
graphic designer
Daily user
Administrator
computational thinking
a problem-solving approach that involves breaking down complex problems into smaller, more manageable parts (decomposition), identifying patterns, and creating a step-by-step solution (algorithm) :
pattern recognition
Identifying similarities and trends within the smaller problems
abstraction
Focusing on the important details and ignoring irrelevant information to find a general solution.
decomposition
Breaking a large, complex problem down into smaller, more manageable sub-problems.
algorithm
Creating a set of step-by-step instructions to solve the problem.
where do we use it?
Data analysis
daily use
Software dev
ICT
Gsheet function
count = count numeric cells
avg = mean value
counta = count non empty cells
sum = add number
Max = largest value
min = minimum value
product = multiplication
round = rounfing the number
abs = absolute value
if = conditional output
averageif = Calculates the average of values that meet one condition.
averageifs = Calculates the average of values that meet multiple conditions.
countblank = count empty cells
countif = Counts cells that meet one condition.
countifs = Counts cells that meet multiple conditions.
ifs = Runs multiple IF conditions without nesting.
or = Returns TRUE if at least one condition is true.
and = Returns TRUE if all conditions are true.
xor = Returns TRUE only if the number of TRUE conditions is odd.
median = Returns the middle number when sorted.
sumif = Adds numbers that meet one condition.
sumifs = Adds numbers that meet multiple conditions.
vlookups = Searches vertically in the first column and returns a value from a selected column.
hlookups = Searches horizontally in the first row and returns a value from a selected row