{"id":5927,"date":"2023-05-10T14:42:28","date_gmt":"2023-05-10T05:42:28","guid":{"rendered":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/?p=5927"},"modified":"2024-08-22T13:47:58","modified_gmt":"2024-08-22T04:47:58","slug":"moodle4_how-to-use-database","status":"publish","type":"post","link":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/2023\/05\/10\/moodle4_how-to-use-database\/","title":{"rendered":"How to use Database"},"content":{"rendered":"<p>In the &#8220;Database&#8221; activity, you can accumulate information with your students according to the theme you have set. In order to create a database, a template for the database will be created by the instructor, and the students will enter their information according to the template.<\/p>\n<p>1. Select &#8220;Database&#8221; from &#8220;Add an activity or resource&#8221;.<br \/>\n<a href=\"https:\/\/wnpspt.waseda.jp\/teacher\/wsdmoodle\/wp-content\/uploads\/sites\/12\/2022\/12\/0903_01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6637 size-full\" src=\"https:\/\/wnpspt.waseda.jp\/teacher\/wsdmoodle\/wp-content\/uploads\/sites\/12\/2022\/12\/0903_01.png\" alt=\"\" width=\"748\" height=\"302\" \/><\/a><\/p>\n<p>2. Name the database (theme).<br \/>\nAfter naming the database, click &#8220;Save and Display.<br \/>\nIf you want to set the input period for the database, go to &#8220;Use&#8221; and set the &#8220;Start date and time&#8221;, &#8220;End date and time&#8221;, &#8220;Start viewing date and time&#8221;, and &#8220;End viewing date and time&#8221;.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4648\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2461.png\" alt=\"\" width=\"1297\" height=\"697\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2461.png 1297w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2461-300x161.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2461-1024x550.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2461-768x413.png 768w\" sizes=\"auto, (max-width: 1297px) 100vw, 1297px\" \/><\/p>\n<p>3.Define the fields.<br \/>\nSet the fields that will be the items in the database. In the example below, we will set up fields to allow students to enter the following information about the World Heritage Site: (1) Name, (2) Classification, (3) Year of registration, (4) Image, and (5) Remarks.<\/p>\n<p>(1) Name<br \/>\nSelect &#8220;Text input&#8221; from the &#8220;Create a field&#8221; pull-down menu.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6153\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_13.png\" alt=\"\" width=\"1086\" height=\"823\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_13.png 1086w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_13-300x227.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_13-1024x776.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_13-768x582.png 768w\" sizes=\"auto, (max-width: 1086px) 100vw, 1086px\" \/><\/p>\n<p>Enter the &#8220;Field Name&#8221; on the next screen. Check the &#8220;Required field&#8221; checkbox if you want to make it a required field.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6155\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_14-1.png\" alt=\"\" width=\"1273\" height=\"684\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_14-1.png 1273w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_14-1-300x161.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_14-1-1024x550.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_14-1-768x413.png 768w\" sizes=\"auto, (max-width: 1273px) 100vw, 1273px\" \/><\/p>\n<p>(2) Classification<br \/>\nSelect &#8220;Menu&#8221; from the pull-down menu under &#8220;Create a field&#8221; and enter the field name and options on the next screen.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6156\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_15.png\" alt=\"\" width=\"1269\" height=\"683\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_15.png 1269w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_15-300x161.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_15-1024x551.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_15-768x413.png 768w\" sizes=\"auto, (max-width: 1269px) 100vw, 1269px\" \/><\/p>\n<p>(3) Registration year<br \/>\nSelect &#8220;Numeric&#8221; from the pull-down menu of &#8220;Create a field&#8221; and enter the field name on the next screen.<br \/>\n(4) Image<br \/>\nSelect &#8220;Image&#8221; from the pull-down menu of &#8220;Create a field&#8221;, and enter the field name on the next screen.<br \/>\n5) Remarks<br \/>\nSelect &#8220;Text Area&#8221; from the pull-down menu of &#8220;Create a field&#8221; and enter the field name on the next screen. (You will be able to enter more characters compared to the text input in \u2460.<\/p>\n<p>This completes the configuration.<br \/>\nWhen the setting is complete, the field will look like the following screen.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6158\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_16.png\" alt=\"\" width=\"1120\" height=\"686\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_16.png 1120w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_16-300x184.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_16-1024x627.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_16-768x470.png 768w\" sizes=\"auto, (max-width: 1120px) 100vw, 1120px\" \/><\/p>\n<p>4. Confirm the entry screen of the student.<br \/>\nClick on the &#8220;Add Entry&#8221; tab to confirm the student entry screen. If there is no problem with the information, instruct the student to enter the data from the &#8220;Add entry&#8221; screen.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6159\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_08.png\" alt=\"\" width=\"1106\" height=\"1150\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_08.png 1106w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_08-289x300.png 289w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_08-985x1024.png 985w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_08-768x799.png 768w\" sizes=\"auto, (max-width: 1106px) 100vw, 1106px\" \/><\/p>\n<p>If you want to modify the entry screen, please refer to &#8220;5.<\/p>\n<p>5. Setting up the template<br \/>\nClick on the &#8220;Template&#8221; tab to display the &#8220;Template for Individual Display&#8221;. The settings of this template will be reflected in the &#8220;4. Adding entries&#8221; screen, so modify them as necessary.<br \/>\nBy default, the last line of the template contains &#8220;##edit## ##delete##&#8230;&#8221;, but if you do not want to allow this operation, delete the entire line because it will allow students to edit or delete all the entries in the database. If you do not want to allow this operation, delete the entire line. Also, click on &#8220;Template for list view&#8221; and delete the entire line there as well.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6160\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_09.png\" alt=\"\" width=\"1112\" height=\"741\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_09.png 1112w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_09-300x200.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_09-1024x682.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_09-768x512.png 768w\" sizes=\"auto, (max-width: 1112px) 100vw, 1112px\" \/><\/p>\n<p>6. Check the database that the student has entered.<br \/>\nAfter entering the information in the database, both faculty members and students will be able to view the information from the tabs &#8220;List view (all items displayed)&#8221; or &#8220;Individual view (each item displayed one by one)&#8221;.<br \/>\n(Example: List view)<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4655\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2468-300x248.png\" alt=\"\" width=\"300\" height=\"248\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2468-300x248.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2468-768x636.png 768w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u2468.png 849w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>When checking, you can also use the &#8220;Search&#8221; function to display only the relevant data from the &#8220;Field Information&#8221;.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6161\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_10.png\" alt=\"\" width=\"1093\" height=\"559\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_10.png 1093w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_10-300x153.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_10-1024x524.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/08\/0903_10-768x393.png 768w\" sizes=\"auto, (max-width: 1093px) 100vw, 1093px\" \/><\/p>\n<p>7. Export the database.<br \/>\nSelect the field you want to export, and click &#8220;Export Entry&#8221; to download the database as a CSV file. You can download the database as a CSV file, image and file.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6269\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/02\/09-03_\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9.png\" alt=\"\" width=\"811\" height=\"599\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/02\/09-03_\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9.png 811w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/02\/09-03_\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9-300x222.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2023\/02\/09-03_\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9-768x567.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4657\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246a-300x115.png\" alt=\"\" width=\"300\" height=\"115\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246a-300x115.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246a-768x295.png 768w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246a.png 773w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>(Reference) Differences in functions between faculty members and students<br \/>\nCreate template\/field New registration to DB Update DB Delete DB<br \/>\nTeacher \u25cb \u25cb \u25cb \u25cb \u25cb \u25cb<\/p>\n<p>1 &#8220;2. Name the database (theme). In the setting screen of &#8220;2. Adding a database name (theme)&#8221;, if &#8220;Approval required&#8221; in &#8220;Entry&#8221; is set to &#8220;Yes&#8221;, the approval of the teacher in charge is required to add the database (default setting is &#8220;No&#8221;).<br \/>\nTo disable updating and deleting of the DB, it is necessary to delete the corresponding tab from &#8220;5.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4658\" src=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246b-300x126.png\" alt=\"\" width=\"300\" height=\"126\" srcset=\"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246b-300x126.png 300w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246b-1024x430.png 1024w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246b-768x323.png 768w, https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-content\/uploads\/sites\/4\/2021\/09\/\u246b.png 1300w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<!-- Anyway Feedback Container \/\/-->\n<div class=\"afb_container\" id=\"afb-container-post-5927\"><div style=\"margin:0 auto;background-color:linen;width:80%;padding:20px;border:1px solid #ccc;border-radius: 10px;\">\r\n<center>\r\n<span class=\"message\"><B>Did it help you?<\/B><\/span>\r\n<br><br><a class=\"good\" href=\"#afb-post-5927\"><i class=\"fa fa-thumbs-o-up\" aria-hidden=\"true\"><\/i>Good<\/a>\u3000\u3000<a class=\"bad\" href=\"#afb-post-5927\"><i class=\"fa fa-thumbs-o-down\" aria-hidden=\"true\"><\/i>No good<\/a>\r\n<br><br><span class=\"status\">0 out of 0 people said that this help was helpful.<\/span>\r\n<\/center>\r\n<\/div><input type=\"hidden\" name=\"post_type\" value=\"post\" \/>\n<input type=\"hidden\" name=\"object_id\" value=\"5927\" \/>\n<\/div>\n<!-- \/\/Anyway Feedback Container -->","protected":false},"excerpt":{"rendered":"<p>In the &#8220;Database&#8221; activity, you can accumulate information with your students according to the the [&hellip;]<\/p>\n","protected":false},"author":50,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"no","footnotes":""},"categories":[44],"tags":[],"class_list":["post-5927","post","type-post","status-publish","format-standard","hentry","category-moodle-useful-features"],"modified_by":"ochiai","_links":{"self":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts\/5927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/comments?post=5927"}],"version-history":[{"count":7,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts\/5927\/revisions"}],"predecessor-version":[{"id":6271,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/posts\/5927\/revisions\/6271"}],"wp:attachment":[{"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/media?parent=5927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/categories?post=5927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wnpspt.waseda.jp\/teacher_en\/wsdmoodle\/wp-json\/wp\/v2\/tags?post=5927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}