> ## Documentation Index
> Fetch the complete documentation index at: https://docs.notesglider.in/llms.txt
> Use this file to discover all available pages before exploring further.

# RAW File <Newsletter>

# RAW File \<Newsletter>

<img src="https://mintcdn.com/notesglider/Oe3eYXG-Yv91qh5j/images/deprecated/MAGDB_WORKFLOW_NEWSLETTER.png?fit=max&auto=format&n=Oe3eYXG-Yv91qh5j&q=85&s=af255b2dc465f73beea00e4e0cdc14c2" alt="" width="22144" height="4192" data-path="images/deprecated/MAGDB_WORKFLOW_NEWSLETTER.png" />

*Image: Diagram Process of Newsletter*

## STEP 1: File Arrives

### DISCORD:

A notification with \<@username> will alert the designer upon file arrival in "#newsletter-daily" channel.

### GOOGLE DRIVE

1. Make a Copy of \<.pptx> file from Shared Folder into "My Drive"
2. Rename this \<.pptx> file in this format: DD-MM-YY.pptx (Ex: 01-01-24.pptx)

## STEP 2: File Conversion

### GOOGLE CODE COLABORATORY

<Card title="https://colab.research.google.com/drive/1gRdKN3KrNed5e-l6FpcKXelZgF0l5-r2?usp=sharing" href="https://colab.research.google.com/drive/1gRdKN3KrNed5e-l6FpcKXelZgF0l5-r2?usp=sharing" icon="arrow-up-right" />

Connect to the Server (Locate the Option on Top Right Corner)

<img src="https://mintcdn.com/notesglider/Oe3eYXG-Yv91qh5j/images/deprecated/Connect-Colab.png?fit=max&auto=format&n=Oe3eYXG-Yv91qh5j&q=85&s=22398bbc54ab02caba0ec96f5a15ec05" alt="" width="277" height="147" data-path="images/deprecated/Connect-Colab.png" />

*Connect with Cloud Server*

Open Table of Content (Locate on the Top Left Corner)

<img src="https://mintcdn.com/notesglider/QZrpNBlKaIJldIiz/images/deprecated/colab-index.png?fit=max&auto=format&n=QZrpNBlKaIJldIiz&q=85&s=2276090bbe2069018d7d23d0139c8150" alt="" width="358" height="121" data-path="images/deprecated/colab-index.png" />

*Open Colab Index*

Go to CREATE RAW Under PROCESS 1 : \[Newsletter-Daily] and Run It

<img src="https://mintcdn.com/notesglider/QZrpNBlKaIJldIiz/images/deprecated/colab-create-raw.png?fit=max&auto=format&n=QZrpNBlKaIJldIiz&q=85&s=e439af2a33e8d50e5604cbcdc3c1be60" alt="" width="689" height="199" data-path="images/deprecated/colab-create-raw.png" />

*Run the Cell*

Allow Access to Google Credentials and Google Drive

<img src="https://mintcdn.com/notesglider/Oe3eYXG-Yv91qh5j/images/deprecated/Access-req.png?fit=max&auto=format&n=Oe3eYXG-Yv91qh5j&q=85&s=b456fcacf16d4507a8876ddc64aa02aa" alt="" width="560" height="178" data-path="images/deprecated/Access-req.png" />

*Allow*

<img src="https://mintcdn.com/notesglider/QZrpNBlKaIJldIiz/images/deprecated/image-12.png?fit=max&auto=format&n=QZrpNBlKaIJldIiz&q=85&s=c6dc5cd45ef0da63375b0437add44d8b" alt="" width="552" height="220" data-path="images/deprecated/image-12.png" />

*Connect to Google Drive*

Enter the Exact \<.pptx> filename into the Input Field

<img src="https://mintcdn.com/notesglider/QZrpNBlKaIJldIiz/images/deprecated/image-13.png?fit=max&auto=format&n=QZrpNBlKaIJldIiz&q=85&s=6df0f78ce53e3fa6821bdf26e9751f2e" alt="" width="840" height="47" data-path="images/deprecated/image-13.png" />

*Example Image: 02-08-24.pptx*

Go to EXTRACT IMG DATA Under PROCESS 1 : \[Newsletter-Daily] and Run It

<img src="https://mintcdn.com/notesglider/QZrpNBlKaIJldIiz/images/deprecated/image-14.png?fit=max&auto=format&n=QZrpNBlKaIJldIiz&q=85&s=eddb02878021637b28e4620b9ed60ec4" alt="" width="590" height="154" data-path="images/deprecated/image-14.png" />

*Run the Cell*

Enter the Exact \<.pptx> filename into the Input Field

<img src="https://mintcdn.com/notesglider/QZrpNBlKaIJldIiz/images/deprecated/image-15.png?fit=max&auto=format&n=QZrpNBlKaIJldIiz&q=85&s=afab1d2b672e471d93f72270f6512900" alt="" width="827" height="47" data-path="images/deprecated/image-15.png" />

*Example Image: 02-08-24.pptx*

## STEP 3: File Processing

### GOOGLE DRIVE

* Select and Cut \{Ctrl+X} all 3 Items (Img Folder + Newsletter + PPTX)
* Paste into this Location: My Drive / MAGDB / Month / Daily-Newsletter

### GOOGLE DOCS

Open the Newsletter Docs file for formatting as Instructed below in video:

#### WATCH VIDEO GUIDE

<Card title="https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link" href="https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link" icon="arrow-up-right" />

<Warning>
  Properly Identify Headings using pptx file as reference.

  Remove Non-Heading type Content and make them as "Normal-Text" instead.

  CHECK: Dual Tables on Single Slides, Fix them.

  Remove repetitive occurrence of the word: "NEWSLIDE" using CTRL + H.
</Warning>

### MCQ Table /w AI

#### METHOD 1:

Using the URL to Google Colaboratory, In Process 1 of \[NEWSLETTER-DAILY], Go to **"GENERATE QA /W AI"** and enter the full name of Newsletter Document ex: 'NEWSLETTER-DD-MM-YY-RAW\.docx', the API will process the document and 4 responses will be presented, then Manually Read all 4 Responses one by one and choose only the best table with a good level of Questions-Answers.

<Card title="https://colab.research.google.com/drive/1S6_rGzKJbys0IzNyLCLsiEGPZaCU6k3_?authuser=3#scrollTo=oYGsgKV_uy2f" href="https://colab.research.google.com/drive/1S6_rGzKJbys0IzNyLCLsiEGPZaCU6k3_?authuser=3#scrollTo=oYGsgKV_uy2f" icon="arrow-up-right" />

<Card title="https://drive.google.com/file/d/1iuOcjKT2beOgjvf-KKSteBbj4bE7oz4g/view?usp=sharing" href="https://drive.google.com/file/d/1iuOcjKT2beOgjvf-KKSteBbj4bE7oz4g/view?usp=sharing" icon="arrow-up-right" />

#### METHOD 2:

After the Docs file is edited as instructed above, we'll save the file as Markdown (.md)

<img src="https://mintcdn.com/notesglider/Oe3eYXG-Yv91qh5j/images/deprecated/DOWNLOAD-PDF.png?fit=max&auto=format&n=Oe3eYXG-Yv91qh5j&q=85&s=5c27dc78ac49e9c8097007f5dd6c0058" alt="" width="656" height="544" data-path="images/deprecated/DOWNLOAD-PDF.png" />

*Save the File as PDF*

<Card title="https://www.perplexity.ai/search/what-to-do-read-the-attached-c-kuarMG1ORyiwoDjMuE4esQ" href="https://www.perplexity.ai/search/what-to-do-read-the-attached-c-kuarMG1ORyiwoDjMuE4esQ" icon="arrow-up-right" />

Create a new thread/conversation by clicking on the + icon then in the chat tap on the paperclip icon to attach the makrdown file to Perplexity AI and Give this Prompt to find Top 5 MCQs then Copy the Output of Generated table and paste it into Newsletter-Docs-File.

```
What to Do?

Read the attached current affairs markdown document to generate question-answers table.

Guidance:

- Background: Attached Document is a Newsletter which contains current affairs news related to latest events covering many news categories. The Newsletter is read by Students preparing for competitive examinations and this Questionnaire is a part of their preparation to assess themselves on the understanding of the newsletter read by them.
- Questionnaire-Level: The students expect the question statements to be challenging enough to test thorough reading of the newsletter. Questions should be precise but not easily answerable without careful study of the content.
- NOTE:
    1. Questions must be one single sentence only. Answers should be articulate, on point, and directly supported by information in the newsletter.
    2. Ensure questions cover different topics/sections from the newsletter for comprehensive assessment.
- STRICTLY: Avoid lengthy questions or explanatory answers. Always remember the above mentioned NOTE when framing Question-Answers from the document.

Inspirational-Question-framing-style-examples:

- Who….?
- When…?
- What…?
- Which…?
- Where….?
- According to ….., (Who/what/when/which/where)………?
- Under which (Section/Regulation/Act)…….,(Who/what/when/which/where)……?
- Which (initiative/program/policy) was launched to address...?

Output Structure:

Tabular representation with 6 rows and 2 columns:

- Header row: 'Q' in first column and 'A' in second column
- Following 5 Rows: Each row contains a Question in the first column and its corresponding Answer in the second column.
```

### NOTION

Update the **STATUS** to: "In-Progress"

Paste the Link to docs file in **INPUT-RAW-URL**

## STEP 4: File Designing

Watch this video to understand the complete design process:

<Card title="https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link" href="https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link" icon="arrow-up-right" />

### CANVA

* Open the associated Design File of Newsletter.
* Use the Newsletter Docs File to update the Design file to Latest Content.
* Insert Images into Design File using the Drive Folder containing the extracted Images.
* Insert Hyperlinks of the associated Newsletter LIVE Sessions.

#### YOUTUBE

* Open the Channel ([https://www.youtube.com/@StudyYRKapilKathpal/streams](https://www.youtube.com/@StudyYRKapilKathpal/streams)) and Find associated LIVE Stream URL.
* If URL is not found, the default link to channel must be preserved.

## STEP 5: File Cross-Checking

* Check Consistency of Newsletter Content in the final design using the Raw Newsletter Docs File in Split Screen Mode.
* Check for any possible repetition of any content or any unwanted errors.
* Open the Attached URLs of Live Stream to check their workability.
* Check the MCQs: The Qs table and Answer table should be correctly updated to today's version of the Newsletter.

SHARE > DOWNLOAD > File type: PDF Print (All Pages) > \[DOWNLOAD]

## STEP 6: Final File Upload

### GOOGLE DRIVE

Upload the file to the **"Newsletter-Daily-FINAL"** folder after Completing the checking.

Copy the Link to this uploaded final Newsletter PDF File.

### NOTION

Update the **STATUS** to: "Done"

Update the **"Pass 1"** to Checked.

Update the **Pages** of PDF:

Paste the Link to PDF file in **OUTPUT-URL**

#### WATCH VIDEO GUIDE

<Card title="https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link" href="https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link" icon="arrow-up-right" />