Microsoft® Excel® 2013: Comprehensive, 1st Edition Steven M. Freund | Mali Jones | Joy L. Starks solutions manual and test bank

Microsoft® Excel® 2013: Comprehensive, 1st Edition  Steven M. Freund | Mali Jones | Joy L. Starks  solutions manual and test bank

Consider This: Your Turn 8-3

Comparing Budget Data

Sample Grading Rubric

Part 1:

Consider This: Plan Ahead Guidelines	Grading Notes	Suggested Percent	Score
1. Gather income and expenses information for group members, consolidate into single worksheet.	Check for accuracy of consolidated figures	30
2. Calculate summary measures	Check for accuracy of summary measures Summary measures should be across group members, by month	40
3. Create series of line charts	Line charts should be summary measures over 6 month time period	20
Add trendlines to charts	Check for correct setup of trendlines	10

Part 2: Critical Thinking Decisions

This assignment requires students to identify the criteria they used for adding trendlines.

· Students should identify charts that have trending data, if any.

Consider This: Your Turn 4-2

Determining the Break-Even Point

Sample Grading Rubric

Part 1:

Consider This: Plan Ahead Guidelines	Grading Notes	Suggested Percent	Score
1. Create a data table.	Create structure of table using appropriate cell labels. Students should use borders, color, font formatting, etc., to produce a visually appealing table	40
2. Populate data table	Correct population of fields to generate accurate one-way table results	40
3 .Protect worksheet	Check that only cells with data can be selected	20

Part 2: Critical Thinking Decisions

This assignment requires students to evaluate between two different options for a two-way table.

· Students should evaluate the number of possibilities for each two-way table, and report the one with the largest number of break-even points.