readMerkmalXlsx: Read xlsx-Files Produced by IQB Item-DB named...

In sachseka/eatPrep: Prepare Data for IRT Analyses

Read xlsx-Files Produced by IQB Item-DB named "Merkmalsauszug"

Description

This function is primarily intended for internal use at the Institute for Educational Quality Improvement (IQB). The xlsx-files for this function are produced by the software IQB Item-DB using information stored in the IQB-Databases.

Usage

readMerkmalXlsx(filename, tolcl = FALSE, alleM = TRUE)

Arguments

filename	A character string containing path, name and extension of .xlsx produced by IQB Item-DB via 'Merkmalsauszug'.
tolcl	Logical. Indicating whether the Item-ID should be created converting numbers to lowercase letters (as required in the English project). Default is FALSE.
alleM	Logical. Indicating whether a merged data frame containing Itemmerkmale and Aufgabenmerkmale together will be created. Default is TRUE.

Details

The xlsx-file produced by 'IQB Item-DB' is expected to have the following sheets: “Itemmerkmale”, “Aufgabenmerkmale”. Order doesn't matter. readMerkmalXlsx will produce a warning if any sheets are missing or wrongly specified.

Value

A list of data frames containing Itemmerkmale, Aufgabenmerkmale and AlleMerkmale (optional).

Author(s)

Karoline Sachse

Examples

readMerkmalXlsx(system.file("extdata", "itemmerkmale.xlsx", package = "eatPrep"))

sachseka/eatPrep documentation built on June 9, 2025, 9:36 a.m.