You will develop an Excel spreadsheet with 3-year trend data on a variety of key performance indicators and budget items showing the financial status of the institution selected for the Case Study Institution Profile earlier in the course

Criteria

Levels of Achievement

Content 70%

Advanced

Proficient

Developing

Not Present

Spreadsheet – Analysis (2/3 of Content)

55 to 59 points

Spreadsheet displays all required key performance indicators with 3 years of trend data.

51 to 54 points

Spreadsheet displays most of the required key performance indicators and may or may not include 5 years of trend data.

1 to 50 points

Spreadsheet displays a minimum of the required key performance indicators with fewer than 5 years of trend data.

0 points

Not present

Spreadsheet – Content (1/3 of Content)

27 to 29 points

Spreadsheet column titles, rows, values, and percentages are complete with 0–1 missing pieces of information/errors.

25 to 26 points

Spreadsheet column titles, rows, values, and percentages have 2–4 missing pieces of information/errors.

1 to 24 points

Spreadsheet column titles, rows, values, and percentages have 5 or more missing pieces of information/errors.

0 points

Not present

Structure 30%

Advanced

Proficient

Developing

Not Present

Spreadsheet – Grammar and Spelling, APA Formatting

35 to 37 points

Spelling and grammar are correct. Sentences are complete, clear, and concise. Where applicable, references are cited in current APA format.

32 to 34 points

Spelling and grammar has some errors. Sentences are presented well. Where applicable, references are cited with some current APA formatting.

1 to 31 points

Spelling and grammar errors distract. Sentences are incomplete or unclear. Where applicable, references are minimally or not cited in current APA format.

0 points

Not present