网络教育专科生毕业大作业

• Format errs applied to ranges (fill color, borders, number formats) are deducted for each cell in the range.
Options: Deduct Extraneous
• To count any extra formatting or cells values against the student • If student enters name, class, date information, these will marked as incorrect
– No searching for errors. – Verify/weigh errors already marked & grade charts – Skip papers with high scores?
• Controls
– Buttons – List Box – Text Box, etc.
Gathering, Grading, and Returning Assignments
4thQtrSales by t3smithjohn.xls
Attachment Executive
Nightly
– Object color – Labels (fonts/# fmt)
• Conditional formatting
• Drawing objects
– Shapes – Lines – Drop shadows
• Embedded objects
– – – – Pictures Clip Art Org charts Word Art
– Extremely Accurate (3 for 3) – Learning Curve: Easy (3 for 3)
• Extremely easy was an option
– Student Complaints
• 4 student complaints from 392 total students (1%)
MEAGER vs Instructors: PRO
• MEAGER marks in greater detail than human graders.
– Worksheet with many errors: details ignored: – alignments, column widths, row heights, missing borders, number formats, merged cells, and bold formatting
• Charts
– – – – – – – Type, Subtype Location Height/Width Source Data Source Title Legend Embedded vs. Worksheet
What does MEAGER NOT grade?
• Chart components
Unattended
(Log generated)
Evaluations
Student Survey: Grader Accuracy
Extremely inaccurate, 1
Extremely accurate, 21
Accurate, 38
98% Accurate or Extremely Accurate No one answered “Inaccurate”
• Remove objects from key that aren’t important (should not be graded) • GRADE OVERNIGHT! • AUTO EMAIL AFTER GRADING!
– It may make assumptions that aren’t explicit
40% Preferred Automated Grader Grader preferred over instructor 3:1
Instructor Survey
• Spring 2003
– MEAGER more accurate than myself (2 for 2)
• Fall 2003
– – – – Face Size Style (B/I/U) Color
What does MEAGER grade?
(continued)
• Cell
– – – – – Alignment (L/R/C) Fill Color Indent level Orientation (tilt) Number format
Student Survey: Grader Fairness
Hard/Harsh, 5, 9% Extremely fair, 10, 19%
Fair, 38, 72%
80% Fair or Extremely Fair 7 students selected “no opinion”
Student Survey: Preference
8 6 6
4
2
0 Instructor 1 Instructor 2 Instructor 3
How to use MEAGER
Selecting Files
• User must select the correct worksheet
– click on browse file button (or type filename) – navigate to file – select correct excel file
– – – – Mistyped/missing labels or numeric constants Incorrect formulas Formatting errors Charts
Workbook Grading
• Extraneous values and formats ARE NOT deducted by default • The same amount is deducted for all types of formatting errors.
苍穹龙骑 http://www.cangqionglongqi.com
MEAGER:
Microsoft Excel Automated Grader
What does MEAGER grade?
• • • • Text labels Numbers Formulas Worksheet names • Fonts
Grader Output
Marking Errors
• Errors are recorded in for error report AND • Student worksheets are marked
– Strike-through format is added to incorrect values and formulas – Comments are added to cells to describe errors
Student’s Marked Up Version
Grade Report
Errors Report
Possible Plagiarism
Total Errs (for first file)
Tips
• Test each new assignment by comparing best students to key • Key may not be correct
rem rem First batch file parameter is correct version of workbook; second parameter is path to student files rem call "C:\Program Files\Excel call "C:\Program Files\Excel call "C:\Program Files\Excel call "C:\Program Files\Excel Grader\ExcelGrader.bat" "r:\grader keys\madonna.xls" "r:\attachments\excel\madonna" Grader\ExcelGrader.bat" "r:\grader keys\razor.xls" "r:\attachments\excel\razor" Grader\ExcelGrader.bat" "r:\grader keys\awesome.xls“ "r:\attachments\excel\awesome" Grader\ExcelGrader.bat" "r:\grader keys\concrete.xls“ "r:\attachments\excel\concrete"
Plagiarism
• Helps discover possible plagiarism • Considers a pair of students at a time
INPUT #1 – Min number errors students have in common?
• More errors, more evidence of plagiarism
• MEAGER can detect errors a human grader cannot.
– Negative number formats for (positive number) – Similar fonts – Colors (grayscale printout?)
• MEAGER can reduce the time required to grade assignments.
•Errors List
•Last folder processed (no history)
Possible Plagiarism
•Last folder processed (no history)
Unattended Processing
UNATTENDED.BAT (To be edited and scheduled for daily execution by instructor)
a.) strongly prefer instructor, 2, 3% e). strongly prefer automated grader, 2, 3% d). prefer automated grader, 22, 37% b). prefer instructor, 5, 8%
c). no opinion, 29, 49%
– Total Lockups: 2 (restarting: temp DB locked) – Files Skipped: 2 (chart extraction/wrong key)
Instructors: Hours Saved Per Week (Estimated)
16 15 14
12 10 10ห้องสมุดไป่ตู้
• Next, select folder containing student workbooks
– Use browse button or type filename
Points to Deduct
• Variable grading scale • Instructor enters # of points to be deducted per error
• Currency • Percent • Accounting
• Borders
– Color – Style
• solid/broken
– Thickness
• Row Height • Column Width • Merged Ranges
What does MEAGER grade?
(continued)
INPUT #2 – What percent of a student A’s errors were also made by student B? (<100% decreases confidence of plagiarism)
Grade Report
•Kept until cleared