🍜 English – Grade 5
Unit 1: What delicious bakso!
Tastes • Food • Greetings
Welcome! Enter your name and student number before starting the quiz.
For Teacher / Khusus Guru
Login Admin
Student Results / Hasil Siswa
📡 Multi-device sync (HP siswa → laptop guru)
Agar data dari HP siswa otomatis muncul di laptop guru, hubungkan ke Google Sheets (gratis).
Agar data dari HP siswa otomatis muncul di laptop guru, hubungkan ke Google Sheets (gratis).
Cara setup (klik untuk buka)
- Buka script.google.com → New project
- Hapus kode default, tempel kode di bawah ini, lalu Save
- Deploy → New deployment → Type: Web app
- Execute as: Me · Who has access: Anyone
- Copy URL Web App, tempel di kotak di bawah, klik Simpan
function doPost(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
if (!ss) ss = SpreadsheetApp.create("Hasil English Unit 1");
var sheet = ss.getSheets()[0];
var data = JSON.parse(e.postData.contents);
if (sheet.getLastRow() === 0) {
sheet.appendRow(["Waktu","Nama","Nomor","SkorPG","PGBenar","TFBenar","MatchBenar",
"PG1","PG2","PG3","PG4","PG5","PG6","PG7","PG8","PG9","PG10",
"PG11","PG12","PG13","PG14","PG15","PG16","PG17","PG18","PG19","PG20",
"TF1","TF2","TF3","TF4","TF5",
"Match1","Match2","Match3","Match4","Match5",
"Isian1","Isian2","Isian3","Isian4","Isian5","Isian6","Isian7","Isian8","Isian9","Isian10",
"Uraian1","Uraian2","Uraian3","Uraian4","Uraian5"]);
}
var row = [data.waktu, data.nama, data.nomor, data.skorPG, data.pgBenar, data.tfBenar, data.matchBenar];
for (var i=1;i<=20;i++) row.push((data.jawabanPG&&data.jawabanPG[i])||"");
for (var i=1;i<=5;i++) row.push((data.jawabanTF&&data.jawabanTF[i])||"");
for (var i=1;i<=5;i++) row.push((data.jawabanMatch&&data.jawabanMatch[i])||"");
for (var i=1;i<=10;i++) row.push((data.jawabanIsian&&data.jawabanIsian[i])||"");
for (var i=1;i<=5;i++) row.push((data.jawabanUraian&&data.jawabanUraian[i])||"");
sheet.appendRow(row);
return ContentService.createTextOutput(JSON.stringify({ok:true})).setMimeType(ContentService.MimeType.JSON);
}
function doGet(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var values = sheet.getDataRange().getValues();
return ContentService.createTextOutput(JSON.stringify(values)).setMimeType(ContentService.MimeType.JSON);
}
Status: belum terhubung (hanya localStorage perangkat ini)
No data yet.
Auto Score (Multiple Choice + True/False + Matching)
0