Buku Pengantar Teknologi Informasi Kelas 8 SMP

Materi Pengantar Teknologi Informasi

Kata Sambutan............................................................................ iii
Kata Pengantar............................................................................ i v
Daftar Isi........................................................................................... v

Bab 1
Mengenal Aplikasi Pengolah Kata ........................................ 1
A. Aplikasi Pengolah Kata ......................................................... 3
1. Pengertian Aplikasi Pengolah Kata ......................... 3
2. Jenis-Jenis Aplikasi Pengolah Kata .......................... 3
B. Microsoft Office Word 2007 .................................................. 8
1. Menjalankan Microsoft Office Word 2007 ............... 8
2. Menutup Microsoft Office Word 2007 ...................... 9
3. Lingkungan Kerja Microsoft Office Word 2007 .......................................... 9
4. Fasilitas Microsoft Office Word 2007 ...................... 12

Bab 2
Mengena l Microsoft Office Wor d 2007 ............................. 19
A. Menu dan Ikon ...................................................................... 21
1. Office Button .................................................................. 21
2. Ribbon ............................................................................. 22
3. Quick Access Toolbar .................................................. 31
4. Pop Up Menu ................................................................. 32
B. Word Options ......................................................................... 33
1. Kategori Popular ......................................................... 33
2. Kategori Display .......................................................... 34
3. Kategori Proofing ......................................................... 35
4. Kategori Save ................................................................ 36
5. Kategori Advanced ...................................................... 36
6. Kategori Customize ..................................................... 37
7. Kategori Add-Ins ......................................................... 37
8. Kategori Trust Center ................................................. 38
9. Kategori Resources ...................................................... 38

Bab 3
Menggunakan Microsoft Office Wor d 2007 ................... 43
A. Operasi Dasar ........................................................................45
1. Membuat Dokumen Baru ........................................ 45
2. Mengetikkan dan Mengatur Naskah .................... 46
3. Menyisipkan dan Mengatur Objek ........................ 57
4. Menyimpan Dokumen .............................................. 62
5. Membuka Dokumen .................................................. 63
6. Mencetak Dokumen ................................................... 64
B. Membuat Dokumen ............................................................ 66
1. Membuat Surat ............................................................ 66
2. Membuat Banner ........................................................ 71
3. Membuat Daftar Isi .................................................... 72
Latihan Semester I....................................................................... 83

Bab 4
Mengenal Aplikas i Pengolah Angka ................................. 87
A. Aplikasi Pengolah Angka ................................................... 89
1. Pengertian Aplikasi Pengolah Angka ................... 89
2. Jenis-Jenis Aplikasi Pengolah Angka .................... 90
B. Microsoft Office Excel 2007 ................................................ 94
1. Menjalankan Microsoft Office Excel 2007 ............ 94
2. Menutup Microsoft Office Excel 2007 .................... 95
3. Lingkungan KerjaMicrosoft Office Excel 2007 ....................................... 95
4. Fasilitas Microsoft Office Excel 2007 ...................... 98

Bab 5
Mengena l Microsoft Office Excel 2007 ............................. 105
A. Menu dan Ikon .................................................................... 107
1. Office Button ................................................................ 107
2. Ribbon ........................................................................... 108
3. Quick Access Toolbar ................................................ 116
4. Pop Up Menu ............................................................... 117
B. Fungsi..................................................................................... 118
1. Fungsi IF ....................................................................... 118
2. Fungsi AND dan OR ................................................. 119
3. Fungsi NOT ................................................................. 119
4. Fungsi NOW dan TODAY ....................................... 120
5. Fungsi SUM, SUMIF dan SUMIFS ........................ 120
6. Fungsi AVERAGE, AVERAGEIF, dan AVERAGEIFS ........................................................................... 121
7. Fungsi MIN dan MAX .............................................. 122
8. Fungsi ROUND, ROUNDUP, ROUNDDOWN,dan MROUND ............................................................ 122
9. Fungsi COUNT, COUNTA, COUNTBLANK,dan COUNTIF ............................................................. 123
10. Fungsi LEFT, MID, dan RIGHT ............................. 124
11. Fungsi LEN .................................................................. 125
C. Excel Options ........................................................................126
1. Kategori Popular ....................................................... 126
2. Kategori Formulas..................................................... 127
3. Kategori Proofing ....................................................... 127
4. Kategori Save .............................................................. 128
5. Kategori Advanced .................................................... 129
6. Kategori Customize ................................................... 129
7. Kategori Add-Ins ........................................................ 130
8. Kategori Trust Center ............................................... 130
9. Kategori Resources .................................................... 130

Bab 6
Menggunakan Microsoft Office Exce l 2007 ................. 135
A. Operasi Dasar ...................................................................... 137
1. Membuat Dokumen Baru ...................................... 137
2. Penanganan Sel dan Data ...................................... 138
3. Menyimpan Dokumen ............................................ 151
4. Membuka Dokumen ................................................ 152
5. Mencetak Dokumen ................................................. 153
B. Membuat Dokumen .......................................................... 155
1. Mengolah Data Kelulusan ...................................... 155
2. Mengolah Data Kepegawaian ............................... 160
Latihan Semester II .................................................................... 169

Daftar Pustaka .......................................................................... 173
Indeks ......................................................................................... 174
Glosarium .................................................................................... 177
Jawaban Soal-Soal Pilihan .................................................. 179
Lampiran ..................................................................................... 180