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

[Guru]

thanks Archana

On 11/08/21 12:21 am, Archana Mehendale 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>
>
>

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