ConverTier2

Conversion of Tiered Assessment Responses to Polytomous Scores

R-CMD-check R License

Overview

ConverTier2 converts binary responses from tiered assessment instruments into polytomous item scores using user-defined scoring rules. It supports scoring-rule parsing, data validation, tiered response conversion, Excel processing, and a bilingual Indonesian-English Shiny application.

Features

Installation

install.packages("ConverTier2")
library(ConverTier2)

To launch the Shiny application, install its suggested interface dependencies if they are not already available:

install.packages(c("DT", "openxlsx", "shinyjs", "shinythemes"))
ConverTier2::launch_app()

Shiny application

The application provides a language selector for Bahasa Indonesia and English. The product name ConverTier2 remains unchanged. Users can select 2, 3, or 4 tiers, edit scoring rules, download an Excel template or example dataset, upload their own Excel file, validate and convert responses, preview scores, and download the results.

The blank template contains 10 items. All tier counts use the same column-naming convention: Tier1_Item1, Tier2_Item1, Tier1_Item2, Tier2_Item2, and so on. For three- or four-tier instruments, additional tier columns are included for each item. Columns are ordered item-by-item, with all tiers for an item grouped together. Enter only 0 or 1 in response cells; do not change column names or order. The template and example workbook include an instruction sheet in the language selected in the Shiny application.

Create a template or example dataset in R

# Empty template: 10 items, 2 tiers
empty_template <- create_template_data()

# Empty template: 10 items, 3 tiers
three_tier_template <- create_template_data(n_items = 10, n_tier = 3)

# Example data: 10 respondents, 10 items, 2 tiers
example_data <- create_example_data()

create_template_data() returns an empty data frame with the required column names. create_example_data() returns reproducible binary response data that can be used to test the conversion workflow.

Usage

1. Define scoring rules

rules <- parse_rules("
11 = 4
10 = 3
01 = 2
00 = 1
")

2. Prepare data

data <- data.frame(
  Tier1_Item1 = c(1, 1, 0),
  Tier2_Item1 = c(1, 0, 0),
  Tier1_Item2 = c(0, 1, 1),
  Tier2_Item2 = c(1, 0, 1)
)

3. Validate and convert

validate_data(data, n_tier = 2)
scores <- convert_tier(data, rules, n_tier = 2)

4. Process an Excel file

scores <- convert_file(
  input = "data/input.xlsx",
  output = "data/scored_output.xlsx",
  rules = rules,
  n_tier = 2
)

Main functions

Function Purpose
parse_rules() Parses text-based scoring rules into a named numeric vector.
validate_data() Validates binary tiered assessment data.
convert_tier() Converts tiered binary responses into item scores.
convert_file() Reads, validates, converts, and optionally exports Excel data.
create_template_data() Creates an empty template data frame with item-tier columns.
create_example_data() Creates reproducible binary example data.
launch_app() Launches the bilingual Shiny application.

Authors

License

MIT License. See LICENSE for details.