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

Mon Aug 16 15:03:02 IST 2021

Dear All,
Here is the excel sheet with five sheets.
I am fine now.
Thanks for adding Neha. She will join us in the next meeting.
Thanks Guru for offering support - will come back if we need any.
Jyotsna

On Thu, Aug 12, 2021 at 10:39 PM Guru <Guru at itforchange.net> wrote:

> Dear Jyotsna
>
> Take care and get well soon.
>
> Good to hear about the second survey and the dissemination plans. We can
> take help of coalition members to reach it across in multiple languages
> (key messages) to different constituencies/geographies
> We can also support, as required on the webinars.
>
> regards,
> Guru
>
> On 12/08/21 5:58 pm, Jyotsna Jha wrote:
>
> 
> Dear All,
> Sorry, I have not been able to complete the task. Will definitely share
> the latest by Monday.
> Also, I will not be able to join today - I am not well. Next week, Neha,
> my colleague, will also join. Copying her.
> Meanwhile, we are completing our analysis of the second round of survey in
> Bihar. Soon, we will be writing at least two media pieces - one in English
> and one in Hindi. We also propose to do a series of five webinars in
> September focusing on the impact of COVID-19. One will be on education.
> Will keep you posted.
> Sorry once again for both not being able to join and also being late in
> doing the job.
> Jyotsna
>
>
> On Thu, Aug 12, 2021 at 4:00 PM Guru <Guru at itforchange.net> wrote:
>
>> Thanks
>>
>> The two files and the one shared by Archana yesterday are in the
>> 'Compendium' folder inside the 'Research' folder  in  *https://tinyurl.com/eeindia21
>> <https://tinyurl.com/eeindia21>*
>>
>> regards
>> Guru
>>
>> On 12/08/21 9:54 am, Sajitha Bashir wrote:
>>
>> 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
>>>
>>
>>
>> --
>> 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/20210816/96c5ec4e/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Education Emergency_Study review_Jyotsna Jha.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 161195 bytes
Desc: not available
URL: <http://educationemergency.net/pipermail/research_educationemergency.net/attachments/20210816/96c5ec4e/attachment-0001.xlsx>