# Learning how to use dataset/codes in applab

**URL:** <https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323>\
**Category:** CS Principles\
**Tags:** applab, csp, csd, data\
**Created:** [September 14, 2020, 6:00am UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323 "2020-09-14T06:00:32Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![e.fat](https://avatars.discourse-cdn.com/v4/letter/e/41988e/32.png) [@e.fat](https://forum.code.org/u/e.fat)\
**Post date:** [September 14, 2020, 6:00am UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/1 "2020-09-14T06:00:32Z")

</div>

Hi everyone,

Can someone help and point to me the correct place to look at which unit covers how to use datasets and the data codes in applab? I want my students to create an app and when the user inputs a text e.g. question might be ‘favourite dog?’ ‘Husky’. Can they see this in the dataset and possibly download it into the excel?

And if someone can also give me some examples on how to code with the dataset when user enters a text. Haven’t taught this topic and am new to it.

Any help is appreciated

---

<div class="post-metadata">

**Author:** ![gjschmidt](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.code.org/gjschmidt/32/4922_2.png) [@gjschmidt](https://forum.code.org/u/gjschmidt)\
**Post date:** [September 14, 2020, 11:00pm UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/2 "2020-09-14T23:00:56Z")

</div>

Unit 9 covers pulling data from datasets. I don’t have a lot of experience with it but they have certain sets of data available. [Here is lesson one of the unit.](https://studio.code.org/s/csp9-2020/stage/1/puzzle/1) They do a lot of pulling data from the datasets and using traversals to step through it.

---

<div class="post-metadata">

**Author:** ![e.fat](https://avatars.discourse-cdn.com/v4/letter/e/41988e/32.png) [@e.fat](https://forum.code.org/u/e.fat)\
**Post date:** [September 14, 2020, 11:28pm UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/3 "2020-09-14T23:28:49Z")

</div>

Thanks for that. I have looked through that unit and it is good. I am after a unit that introduces how to use the data codes in the code section of applab. For example I want my students to learn how to use ‘createRecord’ when a user inputs in a text and they can then see what the user has input. But I can’t seem to find a unit that has this.

---

<div class="post-metadata">

**Author:** ![hannah](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.code.org/hannah/32/4837_2.png) [@hannah](https://forum.code.org/u/hannah)\
**Post date:** [September 15, 2020, 2:58pm UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/4 "2020-09-15T14:58:39Z")

</div>

Hi @e.fat - datasets are introduced in Unit 5 in the Traversal Section (starts at Lesson 9). In Lesson 10, we have an example using the Dogs dataset that you might want to take a look at: [https://studio.code.org/s/csp5-2020/stage/10/puzzle/4](https://studio.code.org/s/csp5-2020/stage/10/puzzle/4)

In the current curriculum students interact with the datasets using the `getColumn()` command. If you’d like to dig into `createRecord()`, I suggest looking at the old Post-AP - Data Tools unit: [https://studio.code.org/s/csppostap-2019](https://studio.code.org/s/csppostap-2019). However, this unit was written prior to the datasets being added into the tool, so some adjustments may need to be made.

---

<div class="post-metadata">

**Author:** ![e.fat](https://avatars.discourse-cdn.com/v4/letter/e/41988e/32.png) [@e.fat](https://forum.code.org/u/e.fat)\
**Post date:** [September 15, 2020, 10:46pm UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/5 "2020-09-15T22:46:02Z")

</div>

Thank you for that. I think that is what I am after. Within applab and the data tab, once users input text can students download the results? Is that possible?

---

<div class="post-metadata">

**Author:** ![hannah](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.code.org/hannah/32/4837_2.png) [@hannah](https://forum.code.org/u/hannah)\
**Post date:** [September 17, 2020, 4:34pm UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/6 "2020-09-17T16:34:44Z")

</div>

@e.fat - Yes, students can download the results. If they navigate to their table in the data tab, they will find an “Export to CSV” button.

 ![Annotation 2020-09-17 123346](https://us1.discourse-cdn.com/flex016/uploads/codeorgforum/original/2X/e/e3337d95ac91d34b43c8be7fd4623c593ca946a6.png)

---

<div class="post-metadata">

**Author:** ![jbailey](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.code.org/jbailey/32/6903_2.png) [@jbailey](https://forum.code.org/u/jbailey)\
**Post date:** [February 13, 2022, 5:32pm UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/7 "2022-02-13T17:32:07Z")

</div>

I have a question about privacy and importing a new data set. If I import a CSV file of student names would that data set only be available to me in my [Code.org](http://Code.org) account or to others? Who sees it and how secure is it?

---

<div class="post-metadata">

**Author:** ![jdonwells](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.code.org/jdonwells/32/7900_2.png) [@jdonwells](https://forum.code.org/u/jdonwells)\
**Post date:** [February 14, 2022, 4:45pm UTC](https://forum.code.org/t/learning-how-to-use-dataset-codes-in-applab/33323/8 "2022-02-14T16:45:49Z")

</div>

The database is not shared when the project is re-mixed. You can not change the code in someone else’s project. So the names are protected from someone who knows nothing about programming.

However, someone who does know something can easily get that dataset.
