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

[Sajitha Bashir]

Hello Archana, Guru

Please find attached excel file with the review of articles assigned to me
(Includign original OXfam study I did as example).  Please note that I
could not access the EPW article which requires a subscription.

Also two articles assigned to me were themselves review articles. I have
summarized them in the Word document.  The oen from EU is fairly good. The
Observer Research Foundation article is of poor quality and I do not
recommend using it, for the reasons indicated

Sajitha

On Tue, Aug 10, 2021 at 2:52 PM Archana Mehendale <
mehendalearchana at gmail.com> wrote:

> 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
>>>
>> --
> 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/20210812/5b98cabe/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SB Education  Emergency Short Research Compendium V1.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 26628 bytes
Desc: not available
URL: <http://educationemergency.net/pipermail/research_educationemergency.net/attachments/20210812/5b98cabe/attachment-0001.xlsx>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Summary of two research articles.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 19467 bytes
Desc: not available
URL: <http://educationemergency.net/pipermail/research_educationemergency.net/attachments/20210812/5b98cabe/attachment-0001.docx>