[Research] Fwd: Ed. Emergency - Excel file with categories and example

[Archana Mehendale]

Hi Guru,
Here is the spreadsheet containing extracts of articles/reports I reviewed.
Regards,
Archana

On Tue, Aug 10, 2021 at 7:51 AM Archana Mehendale <
mehendalearchana at gmail.com> wrote:

> Thanks, Sajitha.
> FYI - I am substituting one of the articles that I was reviewing by
> Cappelle et al which is behind the IJED paywall with the UNICEF report on
> which the article is based. I am updating the same on the Education
> Emergency > Research & Articles sheet also.
> Regards,
> Archana
>
>
> On Tue, Aug 10, 2021 at 7:23 AM Sajitha Bashir <sajitha.bashir at gmail.com>
> wrote:
>
>> Thanks, Guru.
>> Just clarifying to others that you would like us to work on our own excel
>> files, and use one sheet for each study (ie don't put them under each other)
>>
>> Sajitha
>>
>>
>>
>> On Fri, Aug 6, 2021 at 1:03 AM Guru <Guru at itforchange.net> wrote:
>>
>>> Dear all
>>>
>>> I think it is better for each of us to enter  individually in the
>>> attached workbook and then mail filled one to me and we will process it.
>>> This is because Sajitha has already configured the 'list of values' in
>>> this  and that will help in the input in a standard way and save input
>>> time. See her mail below with detailed information
>>>
>>> You can refer Oxfam sheet which Sajitha has filled as a reference and
>>> fill one study per sheet in same manner. I have copied the Oxfam sheet
>>> (minus data) to create 10 more blank sheets eagerly waiting for your input
>>> :-)
>>> Let  me know if you have any doubts/need clarifications
>>>
>>> regards,
>>> Guru
>>>
>>>
>>> -------- Forwarded Message --------
>>> Subject: Ed. Emergency [Research] - Excel file with categories and
>>> example
>>> Date: Sun, 1 Aug 2021 23:36:42 -0400
>>> From: Sajitha Bashir <sajitha.bashir at gmail.com>
>>> <sajitha.bashir at gmail.com>
>>> To: Archana Mehendale <arch_mehendale at yahoo.com>
>>> <arch_mehendale at yahoo.com>, Rishikesh <rishikesh at apu.edu.in>
>>> <rishikesh at apu.edu.in>, Jyotsna Jha <jyotsna at cbps.in> <jyotsna at cbps.in>
>>> CC: Guru <guru at itforchange.net> <guru at itforchange.net>
>>>
>>> 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)
>>>
>>>
>>>
>>> --
>>> Research mailing list
>>> Research at educationemergency.net
>>>
>>> http://educationemergency.net/mailman/listinfo/research_educationemergency.net
>>>
>> --
>> Research mailing list
>> Research at educationemergency.net
>>
>> http://educationemergency.net/mailman/listinfo/research_educationemergency.net
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://educationemergency.net/pipermail/research_educationemergency.net/attachments/20210810/8d3a02f6/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Education  Emergency Short Research Compendium_Archana_10Aug21.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 37909 bytes
Desc: not available
URL: <http://educationemergency.net/pipermail/research_educationemergency.net/attachments/20210810/8d3a02f6/attachment-0001.xlsx>