Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Exsel Dafa

    Uploaded by

    JASMIATI RAFIAN JS 1
    The document contains 3 tables and 2 sections of text. The first table shows the weighting of tasks, exams, and projects in a class. The second table provides sample student data including IDs, names, and scores on two tasks. The third table calculates total scores and assigns letter grades for 10 students. The first text section explains traffic light logic functions. The second section shows sample traffic light conditions and the corresponding light that would be illuminated.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Exsel Dafa

    Uploaded by

    JASMIATI RAFIAN JS 1
    29 views2 pages
    The document contains 3 tables and 2 sections of text. The first table shows the weighting of tasks, exams, and projects in a class. The second table provides sample student data including IDs, names, and scores on two tasks. The third table calculates total scores and assigns letter grades for 10 students. The first text section explains traffic light logic functions. The second section shows sample traffic light conditions and the corresponding light that would be illuminated.

    Original Description:

    UTS EXCEL

    Original Title

    EXSEL DAFA

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains 3 tables and 2 sections of text. The first table shows the weighting of tasks, exams, and projects in a class. The second table provides sample student data including IDs, names, and scores on two tasks. The third table calculates total scores and assigns letter grades for 10 students. The first text section explains traffic light logic functions. The second section shows sample traffic light conditions and the corresponding light that would be illuminated.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    29 views2 pages

    Exsel Dafa

    Uploaded by

    JASMIATI RAFIAN JS 1
    The document contains 3 tables and 2 sections of text. The first table shows the weighting of tasks, exams, and projects in a class. The second table provides sample student data including IDs, names, and scores on two tasks. The third table calculates total scores and assigns letter grades for 10 students. The first text section explains traffic light logic functions. The second section shows sample traffic light conditions and the corresponding light that would be illuminated.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    Nama : Muhammad Daffa Katianda_221011400435

    Tabel Persen Tabel Keterangan


    TASK BOBOT Nilai ABC CDE
    T1 4% Ket Lulus Belum lulus
    T2 5%
    T3 6%
    UTS 20%
    UAS 30% Tugas
    NO Nama
    T1 T2
    Tabel Nilai 1 ANDI 76 50
    Nilai Score 2 JONI 83 34
    A 100 3 SANTI 67 72
    B 85 4 LALA 56 66
    C 75 5 WAWAN 87 65
    D 65 6 IWAN 54 76
    E 55 7 LANI 83 83
    8 MALA 77 77
    9 SONLY 75 75
    10 JAKA 81 81

    FUNGSI LOGIKA
    DENGAN KONDISI 2 DENGAN KONDISI 3
    LAMPU KONDISI LAMPU KONDISI
    MERAH BERHENTI MERAH BERHENTI
    MERAH BERHENTI KUNING HATI-HATI
    HIJAU JALAN HIJAU JALAN
    MERAH BERHENTI MERAH BERHENTI
    MERAH BERHENTI KUNING HATI-HATI
    HIJAU JALAN HIJAU JALAN
    HIJAU JALAN HIJAU JALAN
    KUNING HATI-HATI
    MERAH BERHENTI
    HIJAU JALAN
    KUNING HATI-HATI
    MERAH BERHENTI
    Tugas TOTAL NILAI
    UTS UAS PROJEK KET
    T3 100% ABCD
    87 50 83 50 66 #N/A
    76 34 77 34 56.33333 #N/A
    50 72 75 72 68 #N/A
    34 66 81 66 61.5 #N/A
    72 65 80 65 72.33333 #N/A
    66 76 66 76 69 #N/A
    65 81 43 81 72.66667 #N/A
    76 80 76 80 77.66667 #N/A
    81 66 81 66 74 #N/A
    80 43 80 43 68 #N/A

    You might also like