# Spreadsheet

## ![](/files/mEsFyJVL53YLKtsISiU2) Intro

The **Spreadsheet activity** is a tool that allows students to use spreadsheets to create, collect, analyse and storage data in tabular form. 

Cells within the spreadsheet can be used for performing basic arithmetic and mathematical functions, or financial accountancy and statistical operations. 

In LAMS, the **spreadsheet tool can be use in two modes**:

1. Students can use the spreadsheet to collect and **create their own analysis and models** -which then as teacher you give students marks.<br>
2. A **read-only mode** where students can pluck numbers and see the result based on a pre-configure model.&#x20;

### Why do I want to use Image Gallery?

1. Collect data and perform mathematical analysis.<br>
2. Automate data processing and analysis by performing mathematical, financial or statistical calculations by using functions. <br>
3. Expose students to complex data models that they can create or you as teacher can supply for them to use.&#x20;

{% hint style="success" %}
**Educational Insight**

With Spreadsheets helps students to ***collect and perform data analysis in an structured manner***.&#x20;
{% endhint %}

### What can I use Spreadsheets for?

Spreadsheet is a great tool to structure, organise and analyse data.

Whether you are using Image Gallery for a photography class or for teaching medical diagnostics, it is an helpful tool for students to use, learn and share digital imagery.&#x20;

### How does it work? <a href="#how-does-it-work" id="how-does-it-work"></a>

As a teacher you can use Spreadsheet to let students work out their own data collection and create their own functions to analyse the data.&#x20;

Alternatively, you can give the students an analytical model where students can just add their data and see the results based on the calculations in the model.

Students can use the spreadsheet to add their own functions to analyse the data.&#x20;


---

# 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.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.