Rubic_Print_FormatCourse_CodeClass_CodeAssignment_TitleTotal

Rubic_Print_Format

Course Code	Class Code	Assignment Title	Total Points
EDU-330	EDU-330-O500	Content Analysis for Cultural Competency	70.0
Criteria	Percentage	No Submission (0.00%)	Insufficient (65.00%)	Approaching (75.00%)	Acceptable (85.00%)	Target (100.00%)	Comments	Points Earned
Content	100.0%
Matrix: Text Analysis	15.0%	Not addressed.	Conducts the text analysis by poorly applying the article’s nine guidelines to identify bias in the selected material.	Conducts the text analysis by briefly applying the article’s nine guidelines to identify bias in the selected material.	Conducts the text analysis by properly applying the article’s nine guidelines to identify bias in the selected material.	Conducts the text analysis by professionally applying the article’s nine guidelines to identify bias in the selected material.
Matrix: Assessing Surface and Deep Culture	15.0%	Not addressed.	Ineffectively assesses the degree to which surface culture and deep culture are addressed and the cultural values that are presented in the text.	Partially assesses the degree to which surface culture and deep culture are addressed and the cultural values that are presented in the text.	Effectively assesses the degree to which surface culture and deep culture are addressed and the cultural values that are presented in the text.	Innovatively assesses the degree to which surface culture and deep culture are addressed and the cultural values that are presented in the text.
Matrix: Evaluating the Text for Bias	15.0%	Not addressed.	Inappropriately explains how each guideline was applied to evaluate the text for bias in order to create more relevant learning experiences for all students.	Broadly explains how each guideline was applied to evaluate the text for bias in order to create more relevant learning experiences for all students.	Appropriately explains how each guideline was applied to evaluate the text for bias in order to create more relevant learning experiences for all students.	Insightfully explains how each guideline was applied to evaluate the text for bias in order to create more relevant learning experiences for all students.
Cultural Competence Continuum	10.0%	Not addressed.	Unclearly describes where the text falls on the cultural competence continuum and why.	Somewhat describes where the text falls on the cultural competence continuum and why.	Clearly describes where the text falls on the cultural competence continuum and why.	Thoroughly describes where the text falls on the cultural competence continuum and why.
Personal Bias and Resources	10.0%	Not addressed.	Illogically reflects on personal bias and includes resources that insufficiently deepen cultural understanding.	Ambiguously reflects on personal bias and includes resources that generally deepen cultural understanding.	Appropriately reflects on personal bias and includes suitable resources to deepen cultural understanding.	Insightfully reflects on personal bias and includes purposeful resources to deepen cultural understanding.
Action Steps	15.0%	Not addressed.	Incomprehensibly or inappropriately identifies the action steps for competently and respectfully addressing student performance issues that may appear to be affected by the individual and cultural differences.	Sufficiently identifies the action steps for competently and respectfully addressing student performance issues that may appear to be affected by the individual and cultural differences.	Reasonably and completely identifies the action steps for competently and respectfully addressing student performance issues that may appear to be affected by the individual and cultural differences.	Expertly identifies the action steps for competently and respectfully addressing student performance issues that may appear to be affected by the individual and cultural differences.
Organization	10.0%	Not addressed.	An attempt is made to organize the content, but the sequence is indiscernible. The ideas presented are compartmentalized; may not relate to each other.	The content may not be adequately organized even though it provides the audience with a sense of the main idea.	The content is logically organized. The ideas presented relate to each other. The content provides the audience with a clear sense of the main idea.	The content is well organized and logical. There is a sequential progression of ideas related to each other. The content is presented as a cohesive unit. Provides the audience with a clear sense of the main idea.
Mechanics of Writing (includes spelling, punctuation, grammar, language use)	5.0%	Not addressed.	Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction are used.	Submission includes mechanical errors, but they do not hinder comprehension. Effective sentence structures are used, as well as some practice and content-related language.	Submission is largely free of mechanical errors, although a few are present. A variety of effective sentence structures and figures of speech are used, as well as appropriate practice and content-related language.	Submission is virtually free of mechanical errors. Word choice reflects well-developed use of practice and content-related language. Sentence structures are varied and engaging.
Documentation of Sources (citations, footnotes, references, bibliography, etc., as appropriate to assignment and style)	5.0%	Not addressed.	Documentation of sources is inconsistent or incorrect, as appropriate to assignment and style, with numerous formatting errors.	Sources are documented, as appropriate to assignment and style, although several minor formatting errors are present.	Sources are documented, as appropriate to assignment and style, and format is mostly correct.	Sources are completely and correctly documented, as appropriate to assignment and style, and format is free of error.
Total Weightage	100%

Grader - Instructions Excel 2019 Project

Exp19_Excel_Ch03_ML1_Airports

Project Description:

As an analyst for the airline industry, you track the number of passengers at the top six major U.S. airports: Atlanta (ATL), Chicago (ORD), Los Angeles (LAX), Dallas/Fort Worth (DFW), Denver (DEN), and New York (JFK). You researched passenger data and created a worksheet that lists the number of total yearly passengers at the top six airports. To prepare for an upcoming meeting, you will create a clustered column chart to compare the number of passengers at each airport. Then, you will create a line chart that compares trends over time. Next, you will create a bar chart to compare the passenger count for the latest year of data available and then emphasize the airport with the largest number of passenger traffic. Finally, you want to insert sparklines to visually represent trends in passengers at each airport over the 10-year period.

Steps to Perform:

Step	Instructions	Points Possible
1	Start Excel. Download and open the file named Exp19_Excel_Ch03_ML1_Airports.xlsx. Grader has automatically added your last name to the beginning of the filename.	0
2	You want to create a clustered column chart to depict the passenger counts at the six airports over several years. Use Quick Analysis to create a clustered column chart for the range A4:L10. Cut the chart and paste it in cell A15.	7
3	You want to customize the column chart with a chart title, display the years as a data series, enlarge the chart to be easier to read, and apply a chart style. •Type Passengers by Top U.S. Airports as the chart title. •Swap the data on the category axis and in the legend. •Set a 3.5" height and 11.4" width. •Apply the Style 7 chart style.	10
4	The value axis takes up a lot of space for the numbers. You will adjust the value axis to simplify it. •Change the display units to Millions for the value axis. •Edit the axis title to display Millions of Passengers.	4
5	You want to focus on the 2016 data series by adding data labels. Display data labels above the columns for the 2016 data series only.	3
6	Applying a fill color to the chart area will make the chart visually appealing. Apply the Light Gradient – Accent 2 preset gradient fill to the chart area.	2
7	A best practice is to add Alt Text to a chart for accessibility compliance. Add Alt Text: The chart displays the number of passengers in millions for the top six airports from 2006 to 2016. (including the period).	5
8	When you change the workbook theme, Excel applies that theme to the chart styles. Change the workbook theme to Slice.	3
9	You want to create a bar chart to display passenger counts for only one year. Create a recommended clustered bar chart for the range A5:A10 and L5:L10 and move the chart to a chart sheet named Bar Chart.	5
10	You want to customize the bar chart. •Change the chart color to Colorful Palette 3. •Enter Passengers at Top 6 U.S. Airports in 2016 as the chart title. •Apply the Style 5 chart style. •Add Alt Text: The bar chart shows passengers at Top 6 U.S. Airports in 2016. Atlanta had the most passengers. (including the period).	8
11	Modifying the axes will improve readability of the bar chart. •Change the font size to 10 for the category axis and value axis. •Change the value axis Maximum Bound to 1.1E8.	5
12	You will format a data point so that it stands out and then add gridlines to enhance readability in the bar chart. •Format the Atlanta data point with Dark Blue, Text 2 fill color. •Add Primary Minor Vertical gridlines.	4
13	A line chart effectively shows trends over time for the passenger counts at the different airports. Create a line chart using the range A4:L10 in the Passenger worksheet and move the chart to a chart sheet named Line Chart. Add a chart title Passengers at U.S. Airports 2006-2016 and bold the title.	8
14	You want to customize the line chart. •Set the Minimum Bound at 4.0E7 for the value axis. The Maximum Bound should change to 1.1E8 automatically. •Set the Vertical (Value) Axis Display units to Millions. Delete the Vertical (Value) Axis Display Units Label from the upper-left corner of the chart. Add a value axis title In Millions. •Change the font size to 10 for the value axis and category axis. •Move the legend to the top. •Filter the chart by deselecting the odd-numbered years. •Add Alt Text: The line chart displays trends for top six U.S. airports from 2006 to 2016 at two-year intervals. (including the period).	10
15	Sparklines provide a simple visualization to represent data in a worksheet. Display the Passenger worksheet and insert Line sparklines in the range M5:M10 to illustrate the data in the range B5:L10.	5
16	You want to customize the sparklines to point out high and low points. •Show the high and low points in each sparkline. •Apply Black, Text 1 color to the high point marker in each sparkline	5
17	On the Questions worksheet, type the answer to the first question in cell A2. Enter only the airport code. Answer the other questions by typing in the answers in cells A3, A4, A5, and A6.	5
18	Group the Bar Chart and Line Chart sheets and insert a footer with Exploring Series on the left side, the sheet name code in the center, and the file name code on the right on all worksheets. Group the Passenger and Questions sheets and insert a footer with the same data. Change to Normal view.	5
19	Set page formats for the Passenger worksheet. Select Legal paper size, select Landscape orientation, set 0.3" left and right margins, and scale to fit 1 page.	6
20	Save and close Exp19_Excel_Ch03_ML1_Airports.xlsx. Exit Excel. Submit the file as directed.	0

Total Points

100

Created On: 03/10/2020 1 Exp19_Excel_Ch03_ML1 - Airports 1.2

blog2