<div dir="ltr">Dear All, <div>Here is the excel sheet with five sheets. </div><div>I am fine now. </div><div>Thanks for adding Neha. She will join us in the next meeting. </div><div>Thanks Guru for offering support - will come back if we need any. </div><div>Jyotsna </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Aug 12, 2021 at 10:39 PM Guru <<a href="mailto:Guru@itforchange.net">Guru@itforchange.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
Dear Jyotsna<br>
<br>
Take care and get well soon.<br>
<br>
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<br>
We can also support, as required on the webinars.<br>
<br>
regards,<br>
Guru<br>
<div>
<div><br>
</div>
</div>
<div>On 12/08/21 5:58 pm, Jyotsna Jha wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">Dear All,
<div>Sorry, I have not been able to complete the task. Will
definitely share the latest by Monday. </div>
<div>Also, I will not be able to join today - I am not well.
Next week, Neha, my colleague, will also join. Copying her.</div>
<div>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. </div>
<div>Sorry once again for both not being able to join and also
being late in doing the job. </div>
<div>Jyotsna <br>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Aug 12, 2021 at 4:00
PM Guru <<a href="mailto:Guru@itforchange.net" target="_blank">Guru@itforchange.net</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div> Thanks <br>
<br>
The two files and the one shared by Archana yesterday are
in the 'Compendium' folder inside the 'Research' folder
in <b><a href="https://tinyurl.com/eeindia21" target="_blank">https://tinyurl.com/eeindia21</a></b>
<div> <br>
<div>regards<br>
Guru<br>
<br>
</div>
</div>
<div>On 12/08/21 9:54 am, Sajitha Bashir wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hello Archana, Guru
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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</div>
<div><br>
</div>
<div>Sajitha</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Aug 10, 2021
at 2:52 PM Archana Mehendale <<a href="mailto:mehendalearchana@gmail.com" target="_blank">mehendalearchana@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Hi Guru,
<div>Here is the spreadsheet containing extracts
of articles/reports I reviewed.</div>
<div>Regards,</div>
<div>Archana</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Aug 10,
2021 at 7:51 AM Archana Mehendale <<a href="mailto:mehendalearchana@gmail.com" target="_blank">mehendalearchana@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Thanks, Sajitha.
<div>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.</div>
<div>Regards,</div>
<div>Archana</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Aug
10, 2021 at 7:23 AM Sajitha Bashir <<a href="mailto:sajitha.bashir@gmail.com" target="_blank">sajitha.bashir@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Thanks, Guru.
<div>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)</div>
<div><br>
</div>
<div>Sajitha<br>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Fri,
Aug 6, 2021 at 1:03 AM Guru <<a href="mailto:Guru@itforchange.net" target="_blank">Guru@itforchange.net</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div> Dear all<br>
<br>
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.<br>
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<br>
<br>
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
:-)<br>
Let me know if you have any
doubts/need clarifications<br>
<br>
regards,<br>
Guru<br>
<div><br>
<br>
-------- Forwarded Message --------
<table cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<th valign="BASELINE" nowrap align="RIGHT">Subject: </th>
<td>Ed. Emergency [Research] -
Excel file with categories
and example</td>
</tr>
<tr>
<th valign="BASELINE" nowrap align="RIGHT">Date: </th>
<td>Sun, 1 Aug 2021 23:36:42
-0400</td>
</tr>
<tr>
<th valign="BASELINE" nowrap align="RIGHT">From: </th>
<td>Sajitha Bashir <a href="mailto:sajitha.bashir@gmail.com" target="_blank"><sajitha.bashir@gmail.com></a></td>
</tr>
<tr>
<th valign="BASELINE" nowrap align="RIGHT">To: </th>
<td>Archana Mehendale <a href="mailto:arch_mehendale@yahoo.com" target="_blank"><arch_mehendale@yahoo.com></a>,
Rishikesh <a href="mailto:rishikesh@apu.edu.in" target="_blank"><rishikesh@apu.edu.in></a>,
Jyotsna Jha <a href="mailto:jyotsna@cbps.in" target="_blank"><jyotsna@cbps.in></a></td>
</tr>
<tr>
<th valign="BASELINE" nowrap align="RIGHT">CC: </th>
<td>Guru <a href="mailto:guru@itforchange.net" target="_blank"><guru@itforchange.net></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<div dir="ltr">Hi Archana and
colleagues
<div><br>
</div>
<div>Here is the revised Excel
file with one example, using the
Oxfam study. </div>
<div>Explanatory notes: </div>
<div>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. </div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>In Col I, I have put the main
findings which relate to the
Category / issue in Col G. </div>
<div><br>
</div>
<div>If this is a good working
model, we can start with this. </div>
<div><br>
</div>
<div>A few other questions:</div>
<div><br>
</div>
<div><b>Archana</b> - 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.<br>
</div>
<div><br>
</div>
<div><b>Guru</b> - 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)</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</div>
-- <br>
Research mailing list<br>
<a href="mailto:Research@educationemergency.net" target="_blank">Research@educationemergency.net</a><br>
<a href="http://educationemergency.net/mailman/listinfo/research_educationemergency.net" rel="noreferrer" target="_blank">http://educationemergency.net/mailman/listinfo/research_educationemergency.net</a><br>
</blockquote>
</div>
-- <br>
Research mailing list<br>
<a href="mailto:Research@educationemergency.net" target="_blank">Research@educationemergency.net</a><br>
<a href="http://educationemergency.net/mailman/listinfo/research_educationemergency.net" rel="noreferrer" target="_blank">http://educationemergency.net/mailman/listinfo/research_educationemergency.net</a><br>
</blockquote>
</div>
</blockquote>
</div>
-- <br>
Research mailing list<br>
<a href="mailto:Research@educationemergency.net" target="_blank">Research@educationemergency.net</a><br>
<a href="http://educationemergency.net/mailman/listinfo/research_educationemergency.net" rel="noreferrer" target="_blank">http://educationemergency.net/mailman/listinfo/research_educationemergency.net</a><br>
</blockquote>
</div>
<br>
<fieldset></fieldset>
</blockquote>
<br>
</div>
-- <br>
Research mailing list<br>
<a href="mailto:Research@educationemergency.net" target="_blank">Research@educationemergency.net</a><br>
<a href="http://educationemergency.net/mailman/listinfo/research_educationemergency.net" rel="noreferrer" target="_blank">http://educationemergency.net/mailman/listinfo/research_educationemergency.net</a><br>
</blockquote>
</div>
</div>
</blockquote>
<br>
</div>
-- <br>
Research mailing list<br>
<a href="mailto:Research@educationemergency.net" target="_blank">Research@educationemergency.net</a><br>
<a href="http://educationemergency.net/mailman/listinfo/research_educationemergency.net" rel="noreferrer" target="_blank">http://educationemergency.net/mailman/listinfo/research_educationemergency.net</a><br>
</blockquote></div>