iRubric: Excel - Social Issue Analysis rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...

Excel - Social Issue Analysis

Research an important social issue. Discuss the current state of issue and include statistical data in tables and charts. Develop your own approach to solving the problem and create a spreadsheet that utilizes formulas to calculate the changes that would take place because of your plan. Show your results in tables and charts. Also show the comparison between the current data and the change to data based on your plan.

Rubric Code: FB2432

By justroz

Ready to use

Public Rubric

Subject: Computers

Type: Assessment

Grade Levels: Undergraduate

Excel
	Above Expectations 4 pts	Meets Expectations 3 pts	Needs Improvement 2 pts	Below Expectations 1 pts
Social Issue Analysis	Above Expectations Discussion shows thorough understanding of the issue and the factors that affect it.	Meets Expectations Discussion shows good understanding of the issue and the factors that affect it.	Needs Improvement Discussion shows a little understanding of the issue and the factors that affect it.	Below Expectations Discussion does not show any understanding of the topic.
Social Issue Solution	Above Expectations Proposed solution thoroughly addresses the issues pointed out in the narrative.	Meets Expectations Proposed solution moderately addresses the issues pointed out in the narrative.	Needs Improvement Proposed solution somewhat addresses the issues pointed out in the narrative.	Below Expectations Proposed solution does not addresses the issues pointed out in the narrative.
Charts/Tables	Above Expectations Charts/Tables greatly illustrate and support the statistical points brought out in the narrative.	Meets Expectations Charts/Tables moderately illustrate and support the statistical points brought out in the narrative.	Needs Improvement Charts/Tables somewhat illustrate and support the statistical points brought out in the narrative.	Below Expectations Charts/Tables do not illustrate and support the statistical points brought out in the narrative.
Formulas	Above Expectations The spreadsheet formula(s) are well-developed and will correctly determine the needed information.	Meets Expectations The spreadsheet formula(s) will correctly determine the needed information.	Needs Improvement The spreadsheet formula(s) cannot be used to correctly determine the needed information.	Below Expectations The spreadsheet has no formula(s)
Titles, Labels and Headings	Above Expectations 1. Contains a creative title that clearly relates to the data displayed.<BR> 2. Contains clearly labeled rows and columns.	Meets Expectations 1. Contains a title that somewhat relates to the data displayed.<BR> 2. Contains clearly labeled rows and columns, but the row-column organization was not completely thought out.	Needs Improvement 1. Title is present at the top of the graph.<BR> 2. Does not contain labels for some of the rows or columns, and spreadsheet shows some signs of disorganization.	Below Expectations 1. Does not contain a title.<BR> 2. Does not contain any labels for columns and rows.
Neatness and Organization	Above Expectations The spreadsheet has exceptional formatting and the information is well organized. It's easy to read.	Meets Expectations The spreadsheet has attractive formatting and is somewhat organized. Data can be read and interpreted, but with some difficulty.	Needs Improvement The spreadsheet is somewhat organized. Readability needs improvement, as there is great difficult in interpreting information.	Below Expectations The spreadsheet formatting and organization can be confusing to observer. Spreadsheet information is not readable.

Keywords:

cell, row, column, merge and center, format

Subjects:

Computers

Types:

Discuss this rubric