Country: Philippines
You are in the Philippines edition. Type your country to switch.
Nigeria
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Philippines edition, with examples in pesos and from the Philippines.
Your learning profile
Writing a research note · Lesson 5 of 8
Research data management: reproducible models and an audit trail
A research conclusion is only as good as the model behind it, and spreadsheets break quietly. This lesson shows how analysts keep research reproducible: separate inputs, workings and outputs, a sources tab, an assumptions log, version control, checks that flag errors, and an audit trail that lets someone else rebuild every number.
This lesson is complete in writing. A video for it is on its way.
What you will learn
- By the end you can lay out a research model so that inputs, workings and outputs are separate and easy to check.
- You can keep a sources record and an assumptions log that let someone else rebuild every number.
- You can version a model and explain what changed between two published notes.
- You can build checks and a review step that catch common spreadsheet errors before publication.
Key terms in this lesson
- Data provenance
- Where a piece of data came from and how it has been handled since, so that its reliability can be judged.
- Assumptions log
- A record of each assumption in a model with its value, reason or source, date and author, so the model can be reviewed and updated.
- Version control
- Keeping each saved version of a file or model, with a note of what changed and why, so that any published version can be found and compared.
- Audit trail
- A record that lets someone trace a published figure back through every calculation to its source, and see when and why it changed.
- Step 1: Step 1: Why research needs data management, not started
- Step 2: Step 2: Lay the model out to be checked, not started
- Step 3: Step 3: Sources and the assumptions log, not started
- Step 4: Step 4: Versions and the audit trail, not started
- Step 5: Step 5: Checks and review, not started
About 7 min of reading
Step 1 of 5
Step 1: Why research needs data management
Opening this step…
Step 2 of 5
Step 2: Lay the model out to be checked
This step opens when you finish the one above.
Step 3 of 5
Step 3: Sources and the assumptions log
This step opens when you finish the one above.
Step 4 of 5
Step 4: Versions and the audit trail
This step opens when you finish the one above.
Step 5 of 5
Step 5: Checks and review
This step opens when you finish the one above.
Key takeaways
The key takeaways open when you finish every step.
Lesson quiz
5 questions. You need 85% to pass.
The quiz opens when you finish every step.
Read first
Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.
Popular this week: Basics: BeginnerPhilippine markets: Beginner