90.2K

Verified Solution

Link Copied!

1. Consider the following gradebook.
   1. Excel
      1. grades are computed the same way as our class
   2. English
      1. have homework and quizzes worth 40% each, with the final worth 20 %
      2. Lowest quiz grade is dropped if there are zero absences
   3. Social Studies
      1. Homework, Exams, and Final are worth 1/3 each
      2. Each absence is 2 points off the final average, each late point off the final average

2. All students must have a letter grade for each course
   1. Letter grades should be computed using the same scale as these below.
   2. A Excellent 90 -100
   3. B Very Good 80 - 89
   4. C Average 70 - 79
   5. D Passing 60 - 69
   6. F Failure Below 60

3. All grade columns should be conditionally formatted so all grades below passing, or 60, or equal to F, have red lettering and shading.
4. All averages should have 2 decimal places.
5. Test values must be restricted to between 0-100
6. Note that social studies and English is 3 credits, Excel is 4 credits.
7. Produce graphs that show the following:
   1. Test grade trends for all students by class
   2. Homework grade trends for all students by class
   3. Test grade trends by program per subject
   4. Test grade trends by program for all subjects
   5. The number and % for each program
8. You must produce counts of passing and failing students and program for each course.
9. Make transcript template similar to what is illustrated below

GPA = (quality points * # of credits for math course + quality points * # of credits for Social Studies + quality points * # of credits for English course)/Total number of credits for all courses

1. Quality points
   1. A =4
   2. B =3
   3. C = 2
   4. D =1
   5. F = 0
   6. No credits are earned if the student gets an F

10. Name each worksheet the last name of each student
11. Complete a transcript for each student using the template just created.

12. You will be graded on the following:
    1. Do the worksheets meet the specs
    2. Graphics and professional formatting transcripts
    3. For printing and viewing online, should be professional, meaning not splitting graphs and not losing context if tables split onto multiple pages
    4. Appropriate use of absolute and relative addressing
    5. Appropriate reuse of values where possible
    6. The only cells that should be unlocked are the grade cells. (protect each protected sheet with the password password). Everything else should be locked.
    7. Appropriate charts used.
    8. The project must contain at least one of the following:
       1. If statements
       2. Vlookups
       3. Pivot tables
       4. Line, bar, spark lines, pie chart
    9. Submit the workbook in Blackboard by the due date
    10. 25% off for each day late

The picture below doesn't have to be clear. The homework said: Make a transcript similar to the image. So It's just the structure that needs to be similar

Transcript ${schoolLogo Hard DiskFileId} East River School 1 School Way Drive Address: Student: Stewart Dent Gender: Male Birth Date: 01/01/1995 COPA 4.0 Total Crest Hous: 44 East River School 9th Grade 2010/2011 GPA 3.8 Course Grade Credits 3 als 4 English Math Science Total Credits for 9th Grade 10 Grading Seale 50-90= 90-100= above 100 = 4 below 66-F 70-80 = 60-70 =D Transcript ${schoolLogo Hard DiskFileId} East River School 1 School Way Drive Address: Student: Stewart Dent Gender: Male Birth Date: 01/01/1995 COPA 4.0 Total Crest Hous: 44 East River School 9th Grade 2010/2011 GPA 3.8 Course Grade Credits 3 als 4 English Math Science Total Credits for 9th Grade 10 Grading Seale 50-90= 90-100= above 100 = 4 below 66-F 70-80 = 60-70 =D

Answer & Explanation Solved by verified expert

See Answer