Skip to content

Instantly share code, notes, and snippets.

@kersulis

kersulis/make-problem-statistics.vd

Created November 6, 2019 15:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kersulis/c21935517a4c35871bebc7653bca5ee0 to your computer and use it in GitHub Desktop.
Save kersulis/c21935517a4c35871bebc7653bca5ee0 to your computer and use it in GitHub Desktop.
Download ZIP
Script for generating statistics by problem for Gradescope assignment export CSV files
Raw
make-problem-statistics.vd
sheet col row longname input keystrokes comment
open-file Quiz_1a_scores.csv o
open-file Quiz_1b_scores.csv o
open-file Quiz_2a_scores.csv o
open-file Quiz_2b_scores.csv o
open-file Quiz_3a_scores.csv o
open-file Quiz_3b_scores.csv o
open-file Quiz_4a_scores.csv o
open-file Quiz_4b_scores.csv o
open-file Quiz_5a_scores.csv o
open-file Quiz_5b_scores.csv o
open-file Quiz_6a_scores.csv o
open-file Quiz_6b_scores.csv o
open-file Quiz_7a_scores.csv o
open-file Quiz_7b_scores.csv o
Quiz_7b_scores columns-all gC
all_columns name select-col-regex (\d:) |
all_columns キQuiz_7b_scores,First Name type-float-selected g%
all_columns quit-sheet q
Quiz_7b_scores describe-all gI
describe_all column select-col-regex (\d:) |
describe_all stoggle-rows gt
describe_all delete-selected gd
describe_all sheet addcol-subst Quiz_(.+)_scores/\1 *
describe_all sheet hide-col -
describe_all sheet_re rename-col quiz ^
describe_all column addcol-subst (.+)\((.+) pts\)/\2 *
describe_all column_re rename-col pts ^
describe_all errors hide-col -
describe_all mode addcol-expr mode / pts =
describe_all キ1: Attendance check (1.0 pts) type-float-selected g%
describe_all pts type-float %
describe_all columns-sheet C
describe_all_columns キmode select-row s
describe_all_columns キmode / pts select-row s
describe_all_columns キmin select-row s
describe_all_columns キmax select-row s
describe_all_columns キmedian select-row s
describe_all_columns キmean select-row s
describe_all_columns キstdev select-row s
describe_all_columns キstdev type-float-selected g%
describe_all_columns quit-sheet q
describe_all min addcol-expr min / pts =
describe_all max addcol-expr max / pts =
describe_all median addcol-expr median / pts =
describe_all mean addcol-expr mean / pts =
describe_all stdev addcol-expr stdev / pts =
describe_all キ1: Attendance check (1.0 pts) type-string-selected g~
describe_all freeze-sheet g'
describe_all' columns-sheet C
describe_all'_columns キmode select-row s
describe_all'_columns キmin select-row s
describe_all'_columns キmax select-row s
describe_all'_columns キmedian select-row s
describe_all'_columns キmean select-row s
describe_all'_columns キstdev select-row s
describe_all'_columns delete-selected gd
describe_all'_columns quit-sheet q
describe_all' column key-col !
describe_all' quiz rename-col Quiz ^
describe_all' column rename-col Problem ^
describe_all' pts rename-col Points ^
describe_all' columns-sheet C
describe_all'_columns delete-selected gd
describe_all'_columns キdistinct select-row s
describe_all'_columns delete-selected gd
describe_all'_columns quit-sheet q
describe_all' mode / pts rename-col mode ^
describe_all' min / pts rename-col min ^
describe_all' max / pts rename-col max ^
describe_all' median / pts rename-col median ^
describe_all' mean / pts rename-col mean ^
describe_all' stdev / pts rename-col stdev ^
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment