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

[Archana Mehendale]

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/13545f0a/attachment-0001.html>