[Research] Spreadsheet for compiling research studies

[Archana Mehendale]

Hi Sajitha,

The spreadsheet you've shared looks good to start with and I am okay with
either working offline or on Google Sheet.

Regarding the ORF study, I agree, let us first look at actual studies and
look at the literature reviews separately, if required.

@ all - Instead of replying to Sajitha's email, I have copied it below and
am sending this to the group id which Guru has created. But Guru, I am not
sure if this works like Google-groups where messages are distributed to all
members, including the sender.

Thank you,
Archana

----
  Hi Archana and colleagues

Here is the revised Excel file with one example, using the Oxfam study.
Explanatory notes:
I  put 13 categories , Col G (there is a drop down menu, which is linked to
the second work sheet).  I think this carries the major issues we would
want to cover,but we can add a few more if we wish (I don't think we
shoudl exceed 15).  If the study did not cover that issue, I left ithe cell
blank.

In Col H, I tried to identify sub-categories  for some of the main
categories (also with a drop down menu   but I am not yet sure that they
are exhaustive/ meaningful. We will have to see after we categorize a few
studies. For this example, I have used the sub-cateogry to identify the
MAIN thing that the report talks about.

In Col I, I have put the main findings which relate to the Category / issue
in Col G.

If this is a good working model, we can start with this.

A few other questions:

*Archana* -  I tried to use the Observer Research Foundation article you
had "alllotted" to me, but as it is itself a review of several articles, it
would not be appropriate to put its "findings" in this format.  So, I
suggest we use this excel file for unique studies, not reviews of studies
For the review articles, it is probably best to prepare a one page summary
. Is that okay?  (Also, I did not find the ORF review very illuminating,
and it often used newspaper articles to reference studies, which was
disconcerting, to say the least. Ours should be sharper and have a
clear narrative).  I will go through the ones you have suggested.

*Guru* - please advise what is the best way for us to enter the studies. If
we do it directly on a Googlesheet, there will be a problem of
re-organizing the studies in some sequence.  If we each work on our
separate files to summarize the studies allocated by Archana, can someone
put them together in an order (eg chronological or type of study)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://educationemergency.net/pipermail/research_educationemergency.net/attachments/20210802/d2768485/attachment.html>