Page 7 - KM Informatika-BS-KLS-VIII_Neat
P. 7
3. Konàgurasi Jaringan Komputer .....................................................98
4. Routing pada Jaringan Komputer ............................................... 100
B. Komunikasi Data pada Ponsel ...........................................................................................101
C. Terhubung ke Internet dengan Aman ..............................................................................104
1. Web Phishing ................................................................................... 105
2. Setting Keamanan pada Browser ............................................... 106
Bab 6 Analisis Data ....................................................................................................................... 113
A. Pencarian Data.......................................................................................................................118
1. Pencarian Data dengan Fungsi Lookup .................................... 119
2. Pencarian Data dengan Fungsi Reference ........................................... 123
B. Visualisasi Data ....................................................................................................................130
C. Peringkasan Data .................................................................................................................. 141
1. SUMIFS dan COUNTIFS ............................................................. 141
2. Pivot Table Satu Dimensi .............................................................. 149
3. Pivot Table Dua Dimensi ............................................................... 153
D. Pengelolaan Data ................................................................................................................. 157
E. Studi Kasus ............................................................................................................................162
1. Tantangan - Pencarian Data ......................................................... 164
2. Tantangan- Peringkasan dan Visualisasi Data .......................... 165
3. Tantangan - Pengelolaan Data ..................................................... 166
Bab 7 Algoritma Pemrograman ..................................................................................................169
A. Eksplorasi Lanjutan Scratch................................................................................................171
1. Kode Control, Input, dan Variable .............................................. 171
2. Kode Custom Block ........................................................................ 176
B. Pengantar Blockly Games dan Eksplorasi Puzzle Maze .............................................180
C. Eksplorasi Blockly Games Music ......................................................................................193
D. Eksplorasi Sprites dengan Blockly ..................................................................................200
E. Pengenalan Pemrograman Prosedural ..........................................................................209
1. Variabel ............................................................................................. 217
2. Percabangan ..................................................................................... 220
3. Pengulangan ..................................................................................... 221
F. Modul Tambahan - Bermain dengan Robot Ozobot .....................................................233
Bab 8 Dampak Sosial Informatika ............................................................................................243
A. Media Sosial ...........................................................................................................................245
1. Klasiàkasi Media Sosial ................................................................. 245
2. Dampak Media Sosial .................................................................... 247
vii
