Scribd Logo
Upload

Welcome to Scribd!

  • 40 views

    APCO-IASC 1P01 - Winter 2019

    Uploaded by

    Kashém
    The document contains information about a loan including monthly repayments over different periods at varying interest rates. Tables show the monthly payment, total amount paid back, and cost of the loan in interest over 5, 10, 15, 20, and 25 years. It also includes class statistics for a course, listing student names and grades for assignments, tests, and the final exam. The average grade for the class was a C, with most students earning grades of A or C.

    Copyright:

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

    APCO-IASC 1P01 - Winter 2019

    Uploaded by

    Kashém
    40 views8 pages
    The document contains information about a loan including monthly repayments over different periods at varying interest rates. Tables show the monthly payment, total amount paid back, and cost of the loan in interest over 5, 10, 15, 20, and 25 years. It also includes class statistics for a course, listing student names and grades for assignments, tests, and the final exam. The average grade for the class was a C, with most students earning grades of A or C.

    Original Title

    APCO-IASC 1P01_Winter 2019.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains information about a loan including monthly repayments over different periods at varying interest rates. Tables show the monthly payment, total amount paid back, and cost of the loan in interest over 5, 10, 15, 20, and 25 years. It also includes class statistics for a course, listing student names and grades for assignments, tests, and the final exam. The average grade for the class was a C, with most students earning grades of A or C.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    40 views8 pages

    APCO-IASC 1P01 - Winter 2019

    Uploaded by

    Kashém
    The document contains information about a loan including monthly repayments over different periods at varying interest rates. Tables show the monthly payment, total amount paid back, and cost of the loan in interest over 5, 10, 15, 20, and 25 years. It also includes class statistics for a course, listing student names and grades for assignments, tests, and the final exam. The average grade for the class was a C, with most students earning grades of A or C.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 8

    Running Head: APCO/IASC 1P01 – WINTER 2019

    APCO/IASC 1P01 – Winter 2019

    Name.

    Institution.

    Date.
    2
    APCO/IASC 1P01 – WINTER 2019

    Loan Function.

    The table below shows the monthly repayments of the loan.

    Loan Amount $ 350,000

    Monthly Payment For Loan

    Loan Period (Years)


    5 10 15 20 25
    2.50% ($6,211.58) ($3,299.45) ($2,333.76) ($1,854.66) ($1,570.16)
    3.00% ($6,289.04) ($3,379.63) ($2,417.04) ($1,941.09) ($1,659.74)
    3.50% ($6,367.11) ($3,461.01) ($2,502.09) ($2,029.86) ($1,752.18)
    4.00% ($6,445.78) ($3,543.58) ($2,588.91) ($2,120.93) ($1,847.43)
    4.50% ($6,525.06) ($3,627.34) ($2,677.48) ($2,214.27) ($1,945.41)
    5.00% ($6,604.93) ($3,712.29) ($2,767.78) ($2,309.85) ($2,046.07)

    The table below shows amounts to be paid back at different rates.

    Total Amount Paid Back

    Loan Period (Years)


    5 10 15 20 25
    $372,694.5
    2.50% 9 $395,933.59 $420,077.20 $445,118.43 $471,047.57
    $377,342.5
    3.00% 0 $405,555.13 $435,066.43 $465,861.98 $497,921.88
    $382,026.6
    3.50% 4 $415,320.64 $450,376.00 $487,166.16 $525,654.75
    $386,746.9
    4.00% 6 $425,229.58 $466,003.39 $509,023.48 $554,228.68
    $391,503.4
    4.50% 0 $435,281.32 $481,945.77 $531,425.48 $583,624.10
    $396,295.9
    5.00% 1 $445,475.16 $498,199.98 $554,362.82 $613,819.54
    3
    APCO/IASC 1P01 – WINTER 2019

    The table below shows different annual interest accumulated after 5 years.

    Cost of Loan (Amount of Interest)

    Loan Period (Years)


    5 10 15 20 25
    2.50% ($22,694.59) ($45,933.59) ($70,077.20) ($95,118.43) ($121,047.57)
    3.00% ($27,342.50) ($55,555.13) ($85,066.43) ($115,861.98) ($147,921.88)
    ($100,376.00
    3.50% ($32,026.64) ($65,320.64) ) ($137,166.16) ($175,654.75)
    ($116,003.39
    4.00% ($36,746.96) ($75,229.58) ) ($159,023.48) ($204,228.68)
    ($131,945.77
    4.50% ($41,503.40) ($85,281.32) ) ($181,425.48) ($233,624.10)
    ($148,199.98
    5.00% ($46,295.91) ($95,475.16) ) ($204,362.82) ($263,819.54)

    Class Statistics.

    Stud Last First Raw


    Num Name Name Major Lab 1 Lab 2 Lab 3 Test 1 Test 2 Exam Final Final Grade
    630034 Concurrent
    1 ostream oren ed. 7 9 8 56 37 69 66.57 67 C
    631939
    4 driggs donovan history 10 10 8 45 50 67 59.29 60 C
    632889
    4 dunkley drew math 8 10 7 66 57 92 82.29 83 A
    635565
    2 jardin jasper history 10 7 10 67 46 88 80.14 81 A
    639708
    8 maquire mose math 6 6 8 69 62 93 86.71 87 A
    640049
    2 juares julius history 10 9 9 45 46 65 58.14 59 C
    642071
    6 moy michelle math 8 6 8 62 62 66 79.71 80 A
    4
    APCO/IASC 1P01 – WINTER 2019

    646048 Concurrent
    1 seward stanton ed. 8 7 7 68 36 86 78.29 79 A
    647704
    4 calandra charlie english 7 9 8 55 41 80 66.71 67 C
    648537
    2 marble mitchell english 6 10 9 51 62 87 68.71 69 B
    650306
    8 toby trinidad history 7 10 7 59 40 80 70.43 71 B
    666766 Concurrent
    2 toliver travis ed. 8 10 6 30 41 49 41.71 42 F
    667869
    5 nettles noah english 3 9 6 62 51 73 76.57 77 B
    670216
    5 moy malcom math 7 6 2 23 62 33 40.71 41 F
    672030 mohmma
    7 marchal d history 4 7 10 51 46 80 64.14 65 C
    672895
    7 gast gregg math 10 9 6 55 64 64 73.29 74 B
    674980
    9 junkins jerrold math 4 3 6 43 65 44 61.57 62 C
    676515 gammel
    9 s granvill english 9 10 9 50 62 67 67.71 68 C
    677078
    1 deluane darin english 10 9 10 39 64 52 57.29 58 D
    677492 Concurrent
    4 varnes virgil ed. 10 7 8 45 41 65 56.71 57 D

    The marking scheme generated

    APXO 1P01 Marking Scheme St Num Stud Num


    6300341 oren ostream Lab 1-7 Lab 2-9 Lab 3-8
      Base Weight 6319394 donovan driggs Lab 1-10 Lab 2-10 Lab 3-8
    Lab 1 10 9 6328894 drew dunkley Lab 1-8 Lab 2-10 Lab 3-7
    Lab 2 10 9 6355652 jasper jardin Lab 1-10 Lab 2-7 Lab 3-10
    Lab 3 10 9 6397088 mose maquire Lab 1-6 Lab 2-6 Lab 3-8
    Test 1 70 20 6400492 julius juares Lab 1-10 Lab 2-9 Lab 3-9
    Test 2 65 20 6420716 michelle moy Lab 1-8 Lab 2-6 Lab 3-8
    Exam 100 33 6460481 stanton seward Lab 1-8 Lab 2-7 Lab 3-7
    Total 100 6477044 charlie calandra Lab 1-7 Lab 2-9 Lab 3-8
    6485372 mitchell marble Lab 1-6 Lab 2-10 Lab 3-9
    6503068 trinidad toby Lab 1-7 Lab 2-10 Lab 3-7
    6667662 travis toliver Lab 1-8 Lab 2-10 Lab 3-6
    5
    APCO/IASC 1P01 – WINTER 2019

    6678695 noah nettles Lab 1-3 Lab 2-9 Lab 3-6


    6702165 malcom moy Lab 1-7 Lab 2-6 Lab 3-2
    mohmmad marchal Lab 1-4 Lab 2-7 Lab 3-
    6720307 10
    6728957 gregg gast Lab 1-10 Lab 2-9 Lab 3-6
    6749809 jerrold junkins Lab 1-4 Lab 2-3 Lab 3-6
    6765159 granvill gammels Lab 1-9 Lab 2-10 Lab 3-9
    6770781 darin deluane Lab 1-10 Lab 2-9 Lab 3-10
    6774924 virgil varnes Lab 1-10 Lab 2-7 Lab 3-8

    The class statistics showed that the average mean grade attained by the students was a C, with a

    mean mark of 67%. The two marks A and C recorded the highest number of grades as shown in

    the table below.


    Grade No.
    Class Stat A 5
    Min 41 B 4
    Max 87 C 5
    Median 68   D 2
    Average 67 C F 2
    18

    Charts to display class statistics

    The breakdown major chart generated was as shown in the table below.

    Major A B C D F
    Concurrent ed. 1 0 1 1 1
    6
    APCO/IASC 1P01 – WINTER 2019

    English 0 2 2 1 0
    History 1 1 3 0 0
    Math 2 1 3 0 1
    Total All
    Majors 4 4 9 2 2

    From the table above it is evident that grade C was attained by a high number of students from

    the totals of all majors. A graph was drawn to represent the breakdown major chart representing

    grades attained by various subjects. A pie chart representing percentage of attainment of grades

    was also established.

    Major Chart
    F

    0 1 2 3 4 5 6 7 8 9 10

    Concurrent ed. English History


    Math Total All Majors
    7
    APCO/IASC 1P01 – WINTER 2019

    Grades

    A
    11% B
    28% C
    11% D
    F

    28% 22%
    8
    APCO/IASC 1P01 – WINTER 2019

    References

    Akbar, A., & Putra, Z. P. (2017). Excel Functions and Formulas Pocketbook.

    Bartholomew, P. (2017). A Structured Approach to the development of Solutions in Excel. arXiv

    preprint arXiv:1704.01142.

    Emil, C. (2018). What-If Analysis Tools in Excel. Ovidius University Annals, Economic

    Sciences Series, 18(2), 240-245.

    You might also like