---
title: "Q1 P1"
space: "Student Handbook"
url: "https://portal.cs17.org/student-handbook/assignments/q1-p1"
updated: "2026-06-04"
---

## Introduction

Welcome to your very first problem set! Follow the instructions on your computer and submit the assignment once everything is complete.

### Folder Fun

:::tip[Directory]
A folder is also called a **directory**. Plural is directories.
:::









Open up your files app and let's create some folders! In your Documents (check sidebar) folder, create a new folder named **Assignments**. Now go inside this folder and create a folder named **Q1**. Open it. Finally, create a directory (folder) here named **P1**.

Create all the following assignment files in this folder.

## LibreOffice Writer Task

Your first task here is to install the **Inter** font from Google fonts.



Done? Let's proceed.



Now, open LibreOffice Writer document and save it under the **P1** folder with the name of `rich_doc`. `Ctrl + S`  is the keyboard shortcut. Your task is to copy the following text into your newly created document (use `Ctrl + C` then `Ctrl + V` to copy and paste!):

```plaintext
# The Great Librarry of Alexandria

## A Place Full of Knowledge

More than 2,000 years ago, the ancient city of Alexandria in **Egypt** became home to one of the most famous librarries in history.

The Librarry of Alexandria was created to collect knowledge from all over the world.

Scholars travelled from distant lands carrying:
- Books
- Maps
- Scientific ideas
- Poems
- Historical records

At its peak, the librarry may have contained *hundreds of thousands* of scrolls.

> “Knowledge is the treasure of civilization.”

## Life Inside the Librarry

The librarry was **not** only a place for storing books.

It was also:
- A research center
- A meeting place for scholars
- A school for learning and discussion

People studied subjects such as:
1. Astronomy
2. Mathematics
3. Medicine
4. Philosophy


## Ancient vs Modern Learning

| Topic | Ancient Times | Modern Times |
|---|---|---|
| Books | Handwritten scrolls | Printed & digital |
| Learning Speed | Slow | Instant access |
| Storage | Physical rooms | Cloud storage |
| Communication | Messengers | Internet |

## Final Thought

Even though the original librarry no longer exists, its story reminds us that learning, preservation, and curiosity are important for every generation.
```



### Format the content

Format it according to the following rules:

- Change all the text to use Inter font and 16pt font size.
- Line starting with one `#` should be made 20pt font and centre aligned
- Line starting with one `##` should be 16pt font and kept left aligned
- Text like `*cs17*` (wrapped in single asterisk symbol) should be converted to *cs17* in italics.
- Text like `**cs17**` (wrapped in double asterisk symbol) should be converted to **cs17** in bold.
- Any line starting with `>` should be converted to blue color with a font size of 12pt.

This should be made a table with 3 columns and 4 rows:

```plaintext
| Topic | Ancient Times | Modern Times |
|---|---|---|
| Books | Handwritten scrolls | Printed & digital |
| Learning Speed | Slow | Instant access |
| Storage | Physical rooms | Cloud storage |
| Communication | Messengers | Internet |
```

*Topic, Ancient Times and Modern Times* are the columns. *Books, Handwritten Scrolls, and Printed & digital* is the first row and so on.

### Typos

The person who was typing the above document made a mistake in spelling (typo) of the word **Library**. It is spelled wrongly as "Librarry". Use the find and replace tool in LibreOffice write to fix the spelling of all the occurrences of the incorrect word. 



### Header

Download the following image (right click > save image) and insert it in the document **header**:

![](/files/telegram-cloud-photo-size-5-6073261749038681906-y.jpg)

This should repeat in every page automatically as we saw in the class.

![](/files/CleanShot 2026-05-16 at 15.44.56@2x.png)
*Hint: Header Area*

### Export to PDF

Now export this document as PDF (check notes or refer internet on how to export a PDF from LibreOffice Writer) with the same name as the writer file and store that in the **P1** folder too.



## Spreadsheet Task

CS17 students are helping organize classroom supplies for daily learning activities. Each student has requested items such as notebooks, pens, chart papers, folders, and other useful materials. In this spreadsheet task, you will create a clean order register, calculate the total cost of each request, and more.

### Data Entry

Create a new **Calc** document, save (you know the shortcut by now 😉) it under the **P1** directory created earlier, and give it a name of `library`. Enter the below data in your newly created sheet:

```plaintext
First Name,Last Name,Item Name,Category,Quantity,Price Per Item,Payment Mode
Aarav,Sharma,Notebook,Stationery,3,45,Cash
Meera,Patel,Blue Pen,Stationery,5,10,UPI
Kabir,Verma,Chart Paper,Art Supplies,4,12,Cash
Anaya,Singh,Folder,Files,2,30,UPI
Rohan,Gupta,Marker,Stationery,3,25,Cash
Sara,Khan,Glue Stick,Art Supplies,2,20,UPI
Vihaan,Mehta,Sticky Notes,Office Supplies,4,35,Cash
Arjun,Iyer,Cardboard Sheet,Art Supplies,5,15,Cash
Zoya,Malik,Stapler,Office Supplies,1,90,UPI
```

The first row in the above list are the column headers. Here is how it will look:

![](/files/CleanShot 2026-05-16 at 13.23.22@2x.png)

### Calculations

#### Total Cost

Your first task is to add a new column next to Payment Mode named **Total Cost.** Total cost is equal to the quantity multiplied by price per item. Use a simple formula for first row and then use autofill to fill it for rest of the rows.



#### Total Items

Leaving a few empty rows and then create the below two cells:

![](/files/CleanShot 2026-05-16 at 14.13.08@2x.png)
*Total Quantity should be both bold and italic*

The quantity number will be calculated using the quantity column. Use the function you think is relevant 😁



### New: Text Functions

:::tip
Many assignments will contain new **supplementary** concepts, please take the time to learn and note them down
:::











In the lectures, we learned about these functions in *formulas*:

- `SUM(E4:E10)` : Calculates and displays the sum of cells E4, E5, .. , E10
- `AVERAGE()`: Calculates average
- `MIN`, `MAX`



But these functions apply on *numbers*. But **Calc** has another category of functions which work on textual data or text. Here is an example of a text function to all capital letters (called uppercase):

```plaintext
=UPPER("john") -> "JOHN"
=UPPER(E4) -> uppercase of whatever is in cell E4
```



Notice how the raw text data is surrounded by `"` marks and **not** cell ID. Similarly there is a `LOWER` function that converts the given text to lowercase (all small letters). One useful function is `CONCAT` which is used like this:

```plaintext
=CONCAT("A", "B")
```

This formula will output `AB`. This is called **Concatenation** which means to join two texts together. Try the above functions in your spreadsheet. 

### Full Name Column

Add a new column in your sheet with the heading of **Full Name**. Use the `CONCAT` function to combine the first name and last name column to show the full name. Don't forget to use the **autofill** feature for rest of the rows!

### Screenshot

Take a screenshot of this sheet with all the columns and save it in the **P1** folder (it will be stored somewhere else by default, you will have to cut and paste the image file).

## Submission

:::note
If you have followed the instructions correctly, the assignment files will be under Documents > Q1 > P1 folder.
:::





Make sure you have saved the changes in all the files. Take the files (verify that in total there will be 4 files inside the ZIP), compress them into a `.ZIP` file and email it to [assignments@cs17.org](https://mailto:assignments@cs17.org)