Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    BTM MiniCase Excel

    Uploaded by

    Laurent Klein
    This document contains a BTM mini case study with the following information: 1) A table listing 13 students with their assignments, midterm, and final exam scores. 2) Computation of each student's weighted total average. 3) Statistical distribution of student grades showing the mean grade is 70.52692307692. 4) Breakdown of letter grades based on weighted course average ranges. The highest average was 86.75 and the lowest was 54.65.

    Copyright:

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

    BTM MiniCase Excel

    Uploaded by

    Laurent Klein
    12 views8 pages
    This document contains a BTM mini case study with the following information: 1) A table listing 13 students with their assignments, midterm, and final exam scores. 2) Computation of each student's weighted total average. 3) Statistical distribution of student grades showing the mean grade is 70.52692307692. 4) Breakdown of letter grades based on weighted course average ranges. The highest average was 86.75 and the lowest was 54.65.

    Original Description:

    BTM MiniCase Excel

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a BTM mini case study with the following information: 1) A table listing 13 students with their assignments, midterm, and final exam scores. 2) Computation of each student's weighted total average. 3) Statistical distribution of student grades showing the mean grade is 70.52692307692. 4) Breakdown of letter grades based on weighted course average ranges. The highest average was 86.75 and the lowest was 54.65.

    Copyright:

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

    BTM MiniCase Excel

    Uploaded by

    Laurent Klein
    This document contains a BTM mini case study with the following information: 1) A table listing 13 students with their assignments, midterm, and final exam scores. 2) Computation of each student's weighted total average. 3) Statistical distribution of student grades showing the mean grade is 70.52692307692. 4) Breakdown of letter grades based on weighted course average ranges. The highest average was 86.75 and the lowest was 54.65.

    Copyright:

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

    BTM Mini Case

    1) Students Names Organized in Alphabetical Order (Last names, A-Z)

    First Name Last Name Student # Assignments (%) Mid-Term (%)


    Avesta Atif 6789012 78 74
    Alex Carter 4567890 87 55
    Robert Dessousa 3456789 55 78
    Carmela Giampaolo 3345678 61 55
    Brendan Gringas 7898123 88 61
    Stacey Imbert 5698901 73 78
    Ching Jung 1234567 50 76
    Joseph Lopes 1244568 63 65
    Ali Morad 5677234 64 50
    Andrea Rivas 9212345 60 88
    Narayna Talla 8901234 78 85
    Daniel Tran 2223456 50 65
    Han Yu 2451237 87 56

    2) Computation of Weighted Total Average for each Student

    Weight 20% 35%


    First Name Last Name Student # Assignments (%) Mid-Term (%)
    Avesta Atif 6789012 78 74
    Alex Carter 4567890 87 55
    Robert Dessousa 3456789 55 78
    Carmela Giampaolo 3345678 61 55
    Brendan Gringas 7898123 88 61
    Stacey Imbert 5698901 73 78
    Ching Jung 1234567 50 76
    Joseph Lopes 1244568 63 65
    Ali Morad 5677234 64 50
    Andrea Rivas 9212345 60 88
    Narayna Talla 8901234 78 85
    Daniel Tran 2223456 50 65
    Han Yu 2451237 87 56
    3) Computation of the Grade of each Student

    Final Exam (%)


    76 First Name Last Name
    40 Narayna Talla
    62 Andrea Rivas
    60 Avesta Atif
    80 Brendan Gringas
    61 Ching Jung
    84 Han Yu
    72 Daniel Tran
    74 Stacey Imbert
    88 Joseph Lopes
    92 Robert Dessousa
    84 Ali Morad
    78 Carmela Giampaolo
    Alex Carter

    4) Statistical Distribution for Student Grades

    45%
    Final Exam (%) Weighted Course Average First Name
    76 75.7 Narayna
    40 54.65 Andrea
    62 66.2 Avesta
    60 58.45 Brendan
    80 74.95 Ching
    61 69.35 Han
    84 74.4 Daniel
    72 67.75 Robert
    74 63.6 Stacey
    88 82.4 Joseph
    92 86.75 Ali
    84 70.55 Alex
    78 72.1 Carmela
    f the Grade of each Student

    Weight 20% 35% 45%


    Student # Assignments (%) Mid-Term (%) Final Exam (%)
    8901234 78 85 92
    9212345 60 88 88
    6789012 78 74 76
    7898123 88 61 80
    1234567 50 76 84
    2451237 87 56 78
    2223456 50 65 84
    5698901 73 78 61
    1244568 63 65 72
    3456789 55 78 62
    5677234 64 50 74
    3345678 61 55 60
    4567890 87 55 40
    Average/assessment 68 68.1538461538462 73.15384615385

    Statistical Distribution for Student Grades

    Last Name Weighted Course Average Normal Distribuiton Mean


    Talla 86.75 0.00841924057437764 70.52692307692
    Rivas 82.4 0.0183428123550683
    Atif 75.7 0.037974925573197
    Gringas 74.95 0.0397568746100578
    Jung 74.4 0.0409296753405963
    Yu 72.1 0.0443302019990669
    Tran 70.55 0.0450345346424673
    Dessousa 69.35 0.0446389816097517
    Imbert 67.75 0.042875483567509
    Lopes 66.2 0.0399705702703804
    Morad 63.6 0.0331722034798252
    Carter 58.45 0.0177810133786374
    Giampaolo 54.65 0.00903690912099426
    Weighted Course Average Course Grade
    86.75 A
    82.4 A- Grade Total
    75.7 B F 0 - 59
    74.95 B C 60 - 69
    74.4 B B- 70 - 72
    72.1 B B 73 - 76
    70.55 B- B+ 77 - 79
    69.35 C A- 80 - 84
    67.75 C A 85 - 94
    66.2 C A+ 95 - 100
    63.6 C
    58.45 F
    54.65 F

    Standard Deviation
    8.85855554874807

    Statistical Distribution f
    0.05

    0.045

    0.04

    0.035

    0.03
    ormal Distribution

    0.025

    0.02
    0.04

    0.035

    0.03

    Normal Distribution
    0.025

    0.02

    0.015

    0.01

    0.005

    0
    50 55 60 65

    Weighted Cou
    Number of Students per Grade
    5

    # of Students
    2
    4
    4
    1
    4
    0
    1 3
    Number of Students

    1
    0

    0
    0 - 59 60 - 69 70 - 72 73 - 76 77 - 79 80
    F C B- B B+

    Class Grade

    atistical Distribution for Student Grades


    65 70 75 80 85 90

    Weighted Course Averages


    ts per Grade

    77 - 79 80 - 84 85 - 94 95 - 100
    B+ A- A A+

    rade

    You might also like