word, excel, powerpoint 2013

sanosh3

itc2003_project_rubricfinal.xls

Home >Computer Science homework help >word, excel, powerpoint 2013

Usage Guide

Worksheet Usage Guide

Difficulty Weight

Values between 1 and 3

1 = Routine function with few steps that is covered in the text or supplemental materia

2 = Feature that requires multiple steps, but is largely a small variation on covered material

3 = Feature that requires many steps and significant planning/critical thinking

Skill score

Enter value between 0-3

0= Not present; 1=Included;

2 = included and shows some creativity/critical thinking in the implementation

3 = significant effort beyond expectations

Categories & Features

Each category area lists features covered in assigned text or lecture material

Points per feature are determined by multiplying difficulty by skill level

The last category, Other, is available to add additional features beyond those in the text.

Additional documents beyond those required can be used for extra credit points, as determined by the instructor

TOTAL

Total points scored is the sum of all category points. Final grade will be determined by point comparison with class peers.

Comparison Worksheet

Project Feature Worksheet
	Difficulty Weight	Skill score	Points	Where is this? ( If you don't tell me I'm more likely to miss it!)
Citation Management				Specify which document, and which page/tab/slide or other specifics needed to easily locate the feature(s).
Generated Bibliography	1	0	0
Generated Table of Contents	2	0	0
In-line citations (real or fictional sources)	1	0	0
Edited citations (suppress author/year, etc.) to adapt to sentence context	2	0	0
Correct paraphrasing of real source(s)	3	0	0
Proper use of real Creative Commons material	3	0	0
			0
Word Processing: Desktop Publishing
Headers and footers with page numbers and/or date	1	0	0
Section breaks	1	0	0
Columns	1	0	0
Columns - uneven widths	2	0	0
Masthead	2	0	0
Drop Cap	1	0	0
Smart Art	2	0	0
Word Art	1	0	0
Drawing shapes -- flipped or rotated	2	0	0
Variety of layering/positioning options	3	0	0
Text box	2	0	0
Borders/shading	1	0	0
Linked object ( OLE) using other project documents	3	0	0
			0
Word Processing: Time Saving Tools
Use of a template with Building Blocks	1	0	0
Creation of a customized template (please include the dotx with submitted documents)	2	0	0
Customized theme colors and/or fonts (please include the files with submitted documents)	2	0	0
			0
Excel: Subtotals and Pivots
Grouped data	2	0	0
Subtotals by data groups	2	0	0
Pivot report	3	0	0
Pivot report with customized row/column labels	2	0	0
Pivot report with multiple pivot levels	3	0	0
Pivot report with sorted/filtered data	3	0	0
Slicer	3	0	0
Pivot chart	3	0	0
Pivot chart with customized labels, titles, etc.	2	0	0
			0
Excel: What-If Analysis
One-variable data table	3	0	0
Two-variable data table (will also get credit for one-variable table)	2	0	0
Goal Seek (provide screenshot with project documents)	2	0	0
Scenarios ( two or more scenarios)	3	0	0
Scenarios with Summary Report	3	0	0
			0
Specialized Functions
Conditional Math functions	2	0	0
Nested IF	2	0	0
Logical functions ( AND, OR, NOT)	2	0	0
Other nested functions	3	0	0
			0
Excel: Multiple Worksheets
Grouped worksheets	1	0	0
Formula with cell reference to separate worksheet	2	0	0
3D formula	3	0	0
Block of 3D formulas	2	0	0
External workbook reference	2	0	0
VLookup or HLookup	3	0	0
Defined Names for cell references	2	0	0
			0
Excel: Imports, and Templates
Data import from a text filetype (txt,csv,rtf)	1	0	0
Data import from Web Query or database	3	0	0
Data Import from XML	3	0	0
Converting Text to Columns ( provide file with unconverted column or "before" screenshot)	2	0	0
Text function(s)	1	0	0
Nested Text functions (in addition to points for text functions)	2	0	0
Protected sheet with unlocked cells for data entry	3	0	0
Creation of a customized Excel template file	2	0	0
Converting Text to Columns ( provide original unconverted file or screenshot)	2	0	0
Converting Text to Columns ( provide original unconverted file or screenshot)	2	0	0
			0
Powerpoint
Action Button(s) for slide navigation	2	0	0
Images/graphics with appropriate attribution	1	0	0
Hyperlinks to Urls and/or email addresses	1	0	0
Hyperlinks to other project files	1	0	0
Next Slide/text transition effects	1	0	0
Hyperlinks to other project files	2	0	0
Appropriate use of sound	1	0	0
Trigger(s)	1	0	0
Appropriate Multiple Animation to an object	3	0	0
Appropriate Motion Paths	2	0	0
Appropriate use of animation settings/timing	2	0	0
pdf of presentation handouts	1	0	0
			0
Macros
Macro Button that runs a macro ( Word or Excel)	4	0	0
Other
Add Criteria	0	0	0
Add Criteria	0	0	0
Add Criteria	0	0	0
		0	0
Extra Credit
TOTAL POINTS		0

&L&8COMPANY NAME -- PROJECT NAME&R&8ETL Tool Product Evaluation