The Sistec is the Brazilian system for diploma registration and validation on technical and superior courses. The sistec package provides tools for Brazilian institutions to update the student’s registration and make data analysis about their situation, retention and drop out.
You can install the sistec package from CRAN as follows:
install.packages("sistec")
To upgrade to the latest version of sistec, run the following command and restart your R session:
install.packages("devtools")
devtools::install_github("r-ifpe/sistec")
Load the package.
library(sistec)
You can download the Sistec’s student registration using your proper account on Sistec. The package provides support if your data comes from setec or web. Be sure that your data has these variables:
On setec: “Nome Aluno”, “Numero Cpf”, “Co Ciclo Matricula”, “Situacao Matricula”, “No Curso”, “Dt Data Inicio” and “Unidade Ensino”.
On web: “NO_ALUNO”, “NU_CPF”, “CO_CICLO_MATRICULA”, “NO_STATUS_MATRICULA”, “NO_CICLO_MATRICULA”, “DT_DATA_INICIO” and “CO_UNIDADE_ENSINO”.
Tip: To take every student for your institution/campus using web, search by student name and use " ".
To download the student’s data, go to your proper account on Qacademico and follow:
Be sure that your data has the variables: “Matricula”, “Nome”, “Situacao Matricula”, “Curso”, “Cpf”, “Instituicao”, “Per. Letivo Inicial” and “Cota”.
Sigaa datasets can be partial or complete. These two formats can perform the comparison, but the partial doesn’t have information about “Campus” and “Cota”.
To download the partial Sigaa’s data, go to your proper account on Sigaa and follow:
For the complete dataset, you have to download directly from the Sigaa database. Be sure that your data has the variables: “Matricula”, “Nome”, “Situacao Matricula”, “Curso”, “Cpf”, “Instituicao”, “ano_ingresso”, “semestre_ingresso” and “Cota”.
To download Conecta datasets from the database follow these steps:
If your institute is not fully integrated with the package, you can
transform your academic database into a generic layout and use
read_rfept()
normally.
To transform your database in a generic rfept layout, follow these requirements:
Load the sistec package and pass the folder path to read_sistec()
and
read_rfept()
functions. (NOTE: These datasets were generated
randomly and do not represent the reality, it is just for example
purpose).
sistec <- read_sistec(system.file("extdata/examples/sistec", package = "sistec"))
qacademico <- read_rfept(system.file("extdata/examples/qacademico", package = "sistec"))
Compare the student’s situation using compare_sistec()
comparison <- compare_sistec(sistec, qacademico)
You can save the comparison in .xlsx format using write_output()
write_output(output_path = "your_folder",
output_folder_name = "the_name_you_want",
comparison = comparison)
ARIA is the web interface created in this package to ease your work. You
can use all those functions just clicking in a few buttons. The ARIA is
available on version
desktop,
online or run aria()
in your R session.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.