Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 25
Pertemuan 1 Informatika
Analisis Data
KELAS 8 Yang akan dipelajari BAB 1
A. Pencarian Data VLOOKUP, HLOOKUP
B. Visualisasi Data CHART
C. Peringkasan Data SUMIF DAN COUNTIFS, PIVOT
VLOOKUP ( VERTICAL LOOKUP)
BENTUK TABEL REFERENSI YANG DIGUNAKAN DIMANA HEADER
ATAU JUDUL TABEL TERLETAK DIBAGIAN ATAS DAN DATANYA TERSUSUN KEBAWAH SECARA VERTICAL. HLOOKUP ( HORIZONTAL LOOKUP)
BENTUK TABEL REFERENSI YANG DIGUNAKAN DIMANA HEADER
ATAU JUDUL TABEL TERLETAK DIBAGIAN KIRI DAN DATANYA TERSUSUN KESAMPING QUIZ Kerjakan table yang sudah disediakan dims excel VISUALISASI DATA “CHART”
Visualiasasi data adalah proses menggunakan
elemen visual seperti diagram, grafik, atau peta untuk mempresentasikan data 2500
2000
1500
1000
500
0 JANUARI FEBRUARI MARET APRIL MEI
PENGAJIAN KONSER WISATA ALAM MALL
Contoh chart: column charts ( grafik kolom )
Quiz Buatlah grafik dari data yang sudah dibuat SUMIF DAN COUNTIFS
—Someone Famous Thanks! Does anyone have any questions? addyouremail@freepik.com +91 620 421 838 yourwebsite.com
CREDITS: This presentation template was created by Slidesgo, including icons by
Flaticon, and infographics & images by Freepik
Please keep this slide for attribution
Alternative resources Here’s an assortment of alternative resources whose style fits the one of this creative template: ● Linear flat ui/ux background ● Graphic design creative process Resources Did you like the resources on this template? Get VECTORS them for free at our other amazing websites: ● Linear flat ui/ux background PHOTOS ● Graphic design creative process ● People working as a team company I ● People working as a team company II ● People working as a team company III ● People working as a team company IV Storyset Create your Story with our illustrated concepts. Choose the style you like the most, edit its colors, pick the background and layers you want to show and bring them to life with the animator panel! It will boost your presentation. Check out how it works.
Pana Amico Bro Rafiki Cuate
Use our editable graphic resources... You can easily resize these resources without losing quality. To change the color, just ungroup the resource and click on the object you want to change. Then, click on the paint bucket and select the color you want. Group the resource again when you’re done. You can also look for more infographics on Slidesgo. JANUARY FEBRUARY MARCH APRIL MAY JUNE
PHASE 1
Task 1
Task 2
PHASE 2
Task 1
Task 2
JANUARY FEBRUARY MARCH APRIL
PHASE 1
Task 1
Task 2 ...and our sets of editable icons You can resize these icons without losing quality. You can change the stroke and fill color; just select the icon and click on the paint bucket/pen. In Google Slides, you can also use Flaticon’s extension, allowing you to customize and add even more icons. Educational Icons Medical Icons Business Icons Teamwork Icons Help & Support Icons Avatar Icons
