Lecture notes for the Introduction to problem solving with applications by James Tam Return to the course web page

Marking of Assignment 1

Functional requirements
 

Feature of Excel to be included (many these should be included in the Spreadsheet data worksheet)

 

Max max

   

Mark received
 

Average percentage for each course component

              

5

    
 

Average for the term percentage and average letter grade

 

2

    
 

Minimum percentage for each course component

 

5

    
 

Maximum percentage for each course component

 

5

    
 

Minimum term percentage

 

1

    
 

Maximum term percentage

 

1

    

 

Maps the percentages to letter grades for each student

 

8

    
 

Count for the number of students who received the various letter grades

 

12

    

 

Graph showing the occurrences of letter grades received

 

6

    

 

Shows the average percentage for each faculty with a pivot table

 

6

    

 

Contact information

 

4

    

 

Display result of alternate grade cutoffs

 

8

 

 
  TOTAL FUNCTIONAL MARKS   63    

 

Worksheets
 

 

 

Max max

   

Mark received
 

Introduction

              

5

    

 

Model

 

4

 

 

 

Data dictionary

 

4

 

 

 

Dashboard

 

7

 

 

 

TOTAL

 

20

 

 

 

Layout and representation
         

 

   4 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

 

 

  

 

 

 

 

  

 

 

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 seperated)

 

Whitespace and separation

 

 

  

 

 

 

 

 

 

 

1 mark: yes

 

0 marks: no

 

Consistent alignment

 

 

 

 

 

 

 

 

 

 

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

 

0 marks:
No alignment or center alignment used

 

Alignment (appropriate)

 

 

 

 

 

 

 

 

 

 

4 marks:

 

0 marks:

 

Are data and calculations explicit

 

 

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

 

OVERALL RAW SCORE (MAX 80)

 

LETTER GRADE:

 

A 96 - 100   C 61 - 68
A- 91 - 95   C- 51 - 60
B+ 86 - 90   D+ 41 - 50
B 81 - 85   D 31 - 40
B- 76 - 80   F 0 - 30
C+ 69 - 75