read_skill_assignment_xlsx {CDSS}

Read an assignment of taught and required skills for a set of learning objects from an XLSX-file.

Description

read_skill_assignment_xlsx expects an XLSX-file with two sheets assigning taught and required, respectively, skills to learning objects with two columns each. The first column contains the IDs of learning objects and the second row the IDs of single skills required or taught, respectively, by this learning object. It returns a list of two binary matrices, "taught" and "required". Each matrix has one row per learning object and one column per skill. The cells contain a "1" if the skill is taught or required, respectively, by the learning object and a "0" otherwise,

Usage

read_skill_assignment_xlsx(
  filename,
  taughtname = "Taught",
  requiredname = "Required",
  warnonly = FALSE,
  verbose = TRUE
)

Arguments

filename

Name of the XLSX-file

taughtname

Name of the sheet with required assignment (default = "Taught")

requiredname

Name of the sheet with required assignment (default = "Required")

warnonly

Are non-compliant SAs allowed? (default = FALSE)

verbose

Verbosity of compliance test (default = TRUE)

Value

List of two binary matrices, "taught" and "required".

See Also

Other functions reading skill assignments: read_skill_assignment_csv(), read_skill_assignment_ods()