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

Guru Guru at ITforChange.net
Thu Aug 12 15:59:21 IST 2021


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*

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>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://educationemergency.net/pipermail/research_educationemergency.net/attachments/20210812/db8b59c5/attachment.html>


More information about the Research mailing list