This is a simple tool to get an overview on subtopics in a literature survey for a thesis, paper or any other academic work. It is created in Microsoft Excel 365 and should work properly in the offline application.
Please use and change this tool however you like and however it serves you. (MIT License).
- Type in your reference in APA or any other style your like.
- Type in year of publication (color changes depending on age).
- Set if core paper.
- Set category (dropdown).
- Define if subtopic is addressed in reference.
- Place for small explanation of subtopic.
- Define subtopics in gray cells here.
- Sheet of the literature review.
- Sheet for statistics (automatically created). Need to be sorted manually.
- Sheet for settings:
- Colored age categories can be set.
- Reference categories can be defined. (up to 10 categories for the dropdown menu)
- Selection options for subtopic for each reference can be defined. (up to 5 selection options for the dropdown menu)
The idea of this literature review tool is based on an idea of Prof. Dr. Annie Wu.