Transcript Lab Notes

COMP101 –
Exploring Multimedia and Internet Computing
LA2 (Tue 14:00 – 16:50)
TA: Jackie Lo
Lecture Review
 Operating System (OS)




Working platform between user and computer
Control the computer to act as user’s will
E.g. Windows 3.1/9X/ME/XP, UNIX, etc.
Like, working staffs of McDonald’s kitchen
Computer
McDonald’s kitchen
Hardware components Cooking utensils
Users
Customers
Lecture Review
Features
Accepts
commands
Makes
components
act
Schedules
activities for
best
performance
OS
Input Drivers
McDonald’s staff
Receptions
Device Drivers Chefs
Scheduler
Managers
Lecture Review
 File Management
 Structure
 Backup
 Format and Defragment
 Command Line Interface (CLI) vs
Graphical User Interface (GUI)
 Multi-tasking
 Questions?
Lecture Review
 Local Area Network (LAN)
 Connect computers in short distance
 E.g. a flat, a lab, a building
 Wide Area Network (WAN)
 Connect computers is longer distance
 For a LAN connected to WAN
 Router / gateway serve as postman to
collect outgoing and distribute incoming
message to each computer in LAN.
Lecture Review
 Internet protocol (IP)
 Standard format stating computer
address
 4-byte long
 E.g. 143.89.13.21
 All computers in WAN on the network
has a unique IP address
 Messages send to router
 router will change the address on the
message according its routing table and
distribute
Lecture Review
 Transmission control protocol (TCP)
 Standard language between computer
and computer
 A message divided into IP packets (like
words)
 Ensure no misunderstanding
 Check for packet lost
 Request for lost packet
 Remove duplicated packet
Lecture
 Domain name system (DNS)
 Translate IP address to human
understandable address
 E.g. 143.89.13.21 = “ust.hk”
 Firewall
 software filter to prevent harmful
messages from reaching a LAN
Lab Notes
 Spreadsheet
 sheet of paper with rows and columns
 application software like a physical
spreadsheet to help dealing with data
 CSV Files (Comma Separated Value)
 text file which contain rows of values
 Each values in a row is separated by “,”
 Cell
 A unit in a spreadsheet
Lab 2
 Follow the steps in lab 2
 Notes for using excel functions
 Remember to add =, if u type in the formula