[Research] Fwd: Ed. Emergency - Excel file with categories and example
Guru
Guru at ITforChange.net
Mon Aug 16 23:39:54 IST 2021
Thanks Jyotsna
Marzia and I will discuss tomorrow how we can 'consolidate' /
'present' this
Rishi
Eagerly waiting for your review
thanks
Guru
On 16/08/21 3:03 pm, Jyotsna Jha wrote:
> 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
> <mailto: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
>> <mailto: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
>>> <mailto: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
>>> <mailto: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
>>> <mailto: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
>>> <mailto: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>
>>> <mailto:sajitha.bashir at gmail.com>
>>> To: Archana Mehendale
>>> <arch_mehendale at yahoo.com>
>>> <mailto:arch_mehendale at yahoo.com>, Rishikesh
>>> <rishikesh at apu.edu.in>
>>> <mailto:rishikesh at apu.edu.in>, Jyotsna Jha
>>> <jyotsna at cbps.in> <mailto:jyotsna at cbps.in>
>>> CC: Guru <guru at itforchange.net>
>>> <mailto: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
>>> <mailto:Research at educationemergency.net>
>>> http://educationemergency.net/mailman/listinfo/research_educationemergency.net
>>> <http://educationemergency.net/mailman/listinfo/research_educationemergency.net>
>>>
>>> --
>>> Research mailing list
>>> Research at educationemergency.net
>>> <mailto:Research at educationemergency.net>
>>> http://educationemergency.net/mailman/listinfo/research_educationemergency.net
>>> <http://educationemergency.net/mailman/listinfo/research_educationemergency.net>
>>>
>>> --
>>> Research mailing list
>>> Research at educationemergency.net
>>> <mailto:Research at educationemergency.net>
>>> http://educationemergency.net/mailman/listinfo/research_educationemergency.net
>>> <http://educationemergency.net/mailman/listinfo/research_educationemergency.net>
>>>
>>>
>>
>> --
>> Research mailing list
>> Research at educationemergency.net
>> <mailto:Research at educationemergency.net>
>> http://educationemergency.net/mailman/listinfo/research_educationemergency.net
>> <http://educationemergency.net/mailman/listinfo/research_educationemergency.net>
>>
>
> --
> Research mailing list
> Research at educationemergency.net
> <mailto:Research at educationemergency.net>
> http://educationemergency.net/mailman/listinfo/research_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/441196e5/attachment-0001.html>
More information about the Research
mailing list