Course web page: Introduction to problem solving with applications James Tam Return to the course web page

Marking of Assignment 1

Functional requirements
 

Feature of Excel to be included: obviously values should be computed by Excel and not determined externally and manually entered. However the formula should be well designed so that changes to the spreadsheet will have a minimal effect e.g., the impact of changing cutoffs should be minimized

 

Max max

  

Mark received
           
 

Computes average percentage for each course component (1 mark for each)

              

5

    
 

Computes average for the term percentage and determines the average letter grade (1 mark for each)

 

2

    
 

Computes minimum percentage for each course component (1 mark for each)

 

5

    
 

Computes maximum percentage for each course component (1 mark for each)

 

5

    
 

Computes minimum term percentage

 

1

    
 

Computes maximum term percentage

 

1

    

 

Automatically maps the percentages to letter grades for each student (1 mark for each letter grade correctly mapped)

 

12

    
 

Automatically counts the number of students who received each of the letter grades (1 mark for counting each grade)

 

12

    

 

Graph the occurrences of letter grades received (half mark for each grade correctly represented)

 

6

    

 

Shows the average percentage for each faculty with a pivot table

 

12

    

 

Display result of alternate grade cutoffs (1 mark for each letter grade correctly mapped)

 

12

 

 
  Penalty: contact information not included in spreadsheet (4 marks for each)   -8    
           
  TOTAL FUNCTIONAL MARKS   73    

 

Layout and representation
         

 

   6 marks:
Appropriate type and amount of variation used		   0 marks:
Far too many fonts and/or effects distract from the data, or no variation was used.

 

Fonts and font effects (number, effects)

                6 __________________________________ 0

 

 

 

 

  

 

 

2 marks:
Appropriate amount (different sections are distinct while data within a section is visually grouped

 

 0 marks:
Too much whitespace (wasted areas), too little whitespace (groups aren't separated)

 

Whitespace and separation

              2 __________________________________ 0

 

 

 

 

 

 

 

1 mark: yes

 

0 marks: no

 

Consistent alignment

             1 ________________0.5 ________________ 0

 

 

 

 

 

 

 

4 marks:
Left and right alignment is used to group and structure the sheet

 

0 marks:
No alignment or center alignment used

 

Alignment (appropriate)

             4 __________________________________ 0

 

 

 

 

 

 

 

10 marks (always)

 

0 marks (never)

 

Are data and calculations explicit

           10 __________________________________ 0
         
    4 marks:   0 marks:
  Graph (appropriate type used, is information clearly represented)              4 __________________________________ 0
         
  TOTAL MARKS 27    

 

OVERALL RAW SCORE (MAX 100)

 

GRADE POINT:

Mapping of raw score to grade point for Assignment 1

Raw score 90 - 100 88 - 89 86 - 87 85 84 83 81 - 82 80
Grade point 4.0 3.9 3.8 3.7 3.6 3.5 3.4 3.3

 

Raw score 78 - 79 76 - 77 75 73 - 74 71 - 72 70 69 68
Grade point 3.2 3.1 3.0 2.9 2.8 2.7 2.6 2.5

 

Raw score 67 65 - 66 63 - 64 61 - 62 60 58 - 59 56 - 57 55
Grade point 2.4 2.3 2.2 2.1 2.0 1.9 1.8 1.7

 

Raw score 54 53 52 50 - 51 48 - 49 46 - 47 40 - 45 < 40
Grade point 1.6 1.5 1.4 1.3 1.2 1.1 1.0 0