{"id":4927,"date":"2023-07-06T07:55:20","date_gmt":"2023-07-06T07:55:20","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/"},"modified":"2023-07-06T07:55:20","modified_gmt":"2023-07-06T07:55:20","slug":"google-sheet-menghitung-ipk","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/","title":{"rendered":"Cara menghitung ipk di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menghitung IPK Anda di Google Spreadsheet berdasarkan nilai yang Anda terima di berbagai mata kuliah dan berapa banyak kredit yang bernilai untuk setiap mata kuliah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda ingin menghitung IPK Anda berdasarkan informasi berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38461 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gpa1.png\" alt=\"\" width=\"510\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fungsi <strong>SWITCH<\/strong> dan <strong>SUMPRODUK<\/strong> di Google Spreadsheet dan contoh langkah demi langkah berikut menunjukkan cara melakukannya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai Anda<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai yang Anda terima serta jumlah SKS yang bernilai untuk setiap mata kuliah:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38461 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gpa1.png\" alt=\"\" width=\"510\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Hitung poin yang diterima untuk setiap kelas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu menetapkan jumlah poin yang diterima untuk setiap kelas berdasarkan nilai huruf dengan menggunakan logika berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">SEBUAH = 4 poin<\/span><\/li>\n<li> <span style=\"color: #000000;\">B = 3 poin<\/span><\/li>\n<li> <span style=\"color: #000000;\">C = 2 poin<\/span><\/li>\n<li> <span style=\"color: #000000;\">D = 1 poin<\/span><\/li>\n<li> <span style=\"color: #000000;\">F = 0 poin<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>D2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SWITCH<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">B2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">A<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">4<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">B<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">3<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">C<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">D<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">1<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">F<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">0<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat mengklik dan menyeret rumus ini ke setiap sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38462 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gpa2.png\" alt=\"\" width=\"565\" height=\"346\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Hitung IPK<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Terakhir, kita bisa mengetikkan rumus berikut di sel <strong>B7<\/strong> untuk menghitung IPK keseluruhan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUMPRODUCT<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">D2:D5<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span dir=\"auto\" style=\"color: #800080;\">C2:C5<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">\/<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">SUM<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #800080;\">C2:C5<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38463 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gpa3.png\" alt=\"\" width=\"485\" height=\"389\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Rata-rata keseluruhan untuk siswa tertentu ternyata adalah <strong>3,25<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam contoh khusus ini, kami menghitung IPK berdasarkan empat kelas berbeda, namun rumus yang sama ini dapat digunakan pada sejumlah kelas mana pun yang ingin Anda gunakan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-konstanta\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara mengalikan kolom dengan konstanta<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-kalikan-kolom-dengan-persentase\/\" target=\"_blank\" rel=\"noopener\">Google Sheets: cara mengalikan kolom dengan persentase<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-memberi-peringkat-pada-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara mengurutkan item di beberapa kolom<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menghitung IPK Anda di Google Spreadsheet berdasarkan nilai yang Anda terima di berbagai mata kuliah dan berapa banyak kredit yang bernilai untuk setiap mata kuliah. Misalnya, Anda ingin menghitung IPK Anda berdasarkan informasi berikut: Untungnya, hal ini mudah dilakukan menggunakan fungsi SWITCH dan SUMPRODUK di Google Spreadsheet dan contoh langkah demi [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Menghitung IPK di Google Sheets (dengan Contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung IPK di Google Sheets, beserta contoh lengkapnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghitung IPK di Google Sheets (dengan Contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung IPK di Google Sheets, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T07:55:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gpa1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/\",\"name\":\"Cara Menghitung IPK di Google Sheets (dengan Contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T07:55:20+00:00\",\"dateModified\":\"2023-07-06T07:55:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung IPK di Google Sheets, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung ipk di google sheets (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menghitung IPK di Google Sheets (dengan Contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung IPK di Google Sheets, beserta contoh lengkapnya.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghitung IPK di Google Sheets (dengan Contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung IPK di Google Sheets, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/","og_site_name":"Statorials","article_published_time":"2023-07-06T07:55:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/gpa1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/","url":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/","name":"Cara Menghitung IPK di Google Sheets (dengan Contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T07:55:20+00:00","dateModified":"2023-07-06T07:55:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung IPK di Google Sheets, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menghitung-ipk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung ipk di google sheets (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4927"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4927"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4927\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}