Financial Statement Analysis Project: Assessment Goal: Scenario: Steps to Completion: Perform:
Prepare:
Deliverables: submit in appropriate LEO assignment folder
|
|
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.
Excel
Exceeds Performance Expectations
13.5 points
Meets Performance Expectations
12 points
Does Not Meet Performance Expectations
0 points
Correct format
The formatting of the cells, graphs, tables, overall report, statement, etc. are easy to read and understand. Cells requiring labeling are properly labeled. Number of sheets is in alignment with assessment instructions. The work has a professional appearance.
The formatting of the cells, graphs, tables, overall report, statement, etc. are mostly easy to read and understand. Some cells requiring labeling are properly labeled. Number of sheets is less than or greater than the requirements of the assessment. The work has a somewhat professional appearance.
The formatting of the cells, graphs, tables, overall report, statement, etc. are not easy to read and understand. Some cells requiring labeling are properly labeled. Number of sheets is excessively more or less than the requirements of the assessment. The work appeared unprofessional. Or did not submit.
/ 13.5
Accuracy of numbers
All numbers on the are accurate. Currency figures have currency symbols in the correct cells only. The number of decimal places is appropriate given the numbers.
Most of the numbers on the work are accurate. Currency figures have currency symbols in the correct cells and some incorrect cells. The number of decimal places may be appropriate given the numbers.
Most of the numbers on the work are inaccurate. Currency figures have currency symbols in almost all cells. The number of decimal places may be appropriate given the numbers. Or did not submit.
/ 13.5
Accuracy of formulas
Chooses the correct formula and uses formulas to compute values on the worksheet(s). All formulas are correct. The use of advanced Excel functions is confirmed by the formulas. Formulas are used across multiple sheets when appropriate.
Mostly chooses the correct formula and uses formulas to compute values on the worksheet(s). Some of the formulas are correct. The use of advanced Excel functions cannot be confirmed by the formulas. Formulas are used across multiple sheets when appropriate.
Mostly chooses the correct formula and uses formulas to compute some values on the worksheet(s). Some of the formulas are correct. The use of advanced Excel functions cannot be confirmed by the formulas. Formulas are not used across multiple sheets when appropriate. Or did not submit.
/ 13.5
Tables, graphs, Smart-art, etc.
Tables, graphs, and smart-art are used to graphically represent cell data. Formatting of tables, graphs, and smart-art appears professional and contributes to creating a deep understanding of the quantitative data.
Tables, graphs, and smart-art are used to graphically represent cell data. Selection and formatting of tables, graphs, and smart-art appears somewhat professional and somewhat contributes to understanding the quantitative data.
Tables, graphs, and smart-art are used, but not to a great extent. Selection and formatting of tables, graphs, and smart-art appears unprofessional and does not contribute to understanding the quantitative data. Or did not submit.
/ 13.5
This table lists criteria and criteria group name in the first column. The first row lists level names and includes scores if the rubric uses a numeric scoring method.
Presentation
Exceeds Performance Expectations
6.75 points