# Create

## Spreadsheet content

![Spreadsheet basic tab](/files/iCUjT6F3Mad1snYDein0)

On the Basic tab, you are able to set:

1. **Title**\
   Make sure the title is **self-descriptive**, which clears the purpose of the spreadsheet and what is expected of students.<br>
2. **Instructions** \
   Add general instructions that students might need to do with the spreadsheet. Also, it might be important for the students to know how the result is being calculated and how you will mark the score.&#x20;

In the spreadsheet you can insert values or formulae to calculate or demonstrate a particular calculation.&#x20;

Alternatively, you can set the spreadsheet so students have to use it to resolve a problem or calculation using their own formulas (see the **two modes** below).

## Advanced settings

![Spreadsheet advanced settings tab](/files/VF7ZArrJ9sAgWrHYiYIt)

### **Spreadsheet modes**

The two modes that you can use the spreadsheet depend on the learning objective that you are pursuing.&#x20;

#### **Play only**

If what you require is for your students to play with a set of formulae to attained a results but don't need them to create their own formula, then you can use this mode.

{% hint style="info" %}
**Play only example**\
\
Say what you want to do is for students to calculate the interest rate that they will have to pay on a loan. Then you can set up the spreadsheet so the student only need to pluck their numbers (ie: interest rate, loan amount, period, etc) and the formulate that ***you set up*** will give them the result.&#x20;
{% endhint %}

#### Learners allowed to submit individual spreadsheets

Alternatively, if what you want the students to do is to use the spreadsheet to create their own calculations and formulae and submit these for evaluation then, you want the Learners allowed to submit individual spreadsheets mode enabled instead.&#x20;

Students, individually, will be able to create their own calculations and formulae and save these for your review.

If you want to mark the students' spreadsheet, make sure you set the `Enable spreadsheet marking` check box.

### Learning outcomes

![Spreadsheet learning outcomes](/files/qC1AoyanrkhhM9LETcOn)

{% hint style="success" %}
**Mapping learning outcomes to activities is very useful for curriculum mapping.**
{% endhint %}

As with all activities in LAMS, you can map your learning outcomes to this activity. If you want to add a learning outcome, just search for the particular outcome or type a new one it will be added to your list of learning outcomes for the future.

You can search Learning Outcomes by code or name.

### Reflection and End of Activity <a href="#reflection-and-end-of-activity" id="reflection-and-end-of-activity"></a>

As in all LAMS activities, you are able to get your students to reflect on the activity as soon as they finish. This is an important part of learning and research shows that it is when we reflect upon what we just learn that long lasting learning forms. Adding instructions for students to reflect on the activity.

![Spreadsheet end of activity](/files/uWk9pO2mzYLHkV5ijO0J)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.lamsfoundation.org/lams/tools/spreadsheet/create.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
