{"id":107,"date":"2024-01-18T18:22:03","date_gmt":"2024-01-18T23:22:03","guid":{"rendered":"https:\/\/sites.temple.edu\/souravdas\/?page_id=107"},"modified":"2024-02-16T13:57:37","modified_gmt":"2024-02-16T18:57:37","slug":"cis-2109","status":"publish","type":"page","link":"https:\/\/sites.temple.edu\/souravdas\/","title":{"rendered":"CIS 2109 Lab (Spring 2024)"},"content":{"rendered":"\n<p><strong>All the necessary updates and hints for each lab will be posted on this page.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background:linear-gradient(309deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%)\">INFORMATION<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Attendance is mandatory.<\/li>\n\n\n\n<li>There are two submissions for each lab. One <span style=\"text-decoration: underline\">lab progress report<\/span> and one <span style=\"text-decoration: underline\">lab report.<\/span><\/li>\n\n\n\n<li>The lab progress report is due at the end of each lab at <span style=\"text-decoration: underline\">5 p.m. on Fridays<\/span>. You have to submit a document or screenshot that demonstrates you have made progress on the assigned task for the day.<\/li>\n\n\n\n<li>The grade for the progress report is either 0 or 100. There are <span style=\"text-decoration: underline\">no partial grades<\/span>.<\/li>\n\n\n\n<li>No submissions for lab reports are to be accepted without the submission of a progress report. Yes, there <span style=\"text-decoration: underline\">are partial grades<\/span> for the final submissions.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background:linear-gradient(309deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%)\">GRADE WEIGHTS<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Midterm 1: 15%<\/li>\n\n\n\n<li>Midterm 2: 15%<\/li>\n\n\n\n<li>Final: 20%<\/li>\n\n\n\n<li>Labs: 20%<\/li>\n\n\n\n<li>Homework: 10%<\/li>\n\n\n\n<li>Group Project: 20%<\/li>\n\n\n\n<li>Discussion Boards and Extra Credits: 2%<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background:linear-gradient(309deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%)\">LINKS<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Student List: <a href=\"https:\/\/forms.gle\/BQBbXyvVVVZGitxU6\">https:\/\/forms.gle\/BQBbXyvVVVZGitxU6<\/a>  <\/li>\n\n\n\n<li>Editor\/Tutorial: <a href=\"https:\/\/www.w3schools.com\/sql\/\">https:\/\/www.w3schools.com\/sql\/<\/a><\/li>\n\n\n\n<li>Oracle Cloud Link : <a href=\"https:\/\/www.oracle.com\/cloud\/sign-in.html?intcmp=OcomFreeTier\">https:\/\/www.oracle.com\/cloud\/sign-in.html?intcmp=OcomFreeTier<\/a><\/li>\n<\/ol>\n\n\n\n<p class=\"has-vivid-red-color has-text-color has-link-color wp-elements-a349ff26557a23da413623f340f767f8\"><strong>Make sure to create your own user profile; do not use ADMIN.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background:linear-gradient(168deg,rgb(255,206,236) 26%,rgb(152,150,240) 100%)\">LAB 4 <\/h2>\n\n\n\n<p class=\"has-white-background-color has-text-color has-background has-link-color has-large-font-size wp-elements-b78ce61f434f3b9fc92483fcd4dfbe97\" style=\"color:#0174b7\"><strong><span style=\"text-decoration: underline\">You must complete at least \u00bd\u00a0of the lab during the lab session &#8211; 7 questions.\u00a0<\/span><\/strong><\/p>\n\n\n\n<p><em>When you are asked to commit\/rollback &#8211; remember that DML statements need a commit and can be rolled back (i.e. insert, update and delete). DDL statements (create, alter, drop, truncate) do not require a commit as a commit is executed automatically before and after the DDL statement.<\/em><\/p>\n\n\n\n<p class=\"has-vivid-red-color has-text-color has-link-color has-large-font-size wp-elements-8aa7bef7791834224ea466b3b1f46f0b\"><strong><a href=\"https:\/\/sites.temple.edu\/souravdas\/2024\/02\/16\/lab-4-few-hints\/\" data-type=\"post\" data-id=\"232\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline\">Click for hints<\/span><\/a><\/strong><\/p>\n\n\n\n<p class=\"has-regular-font-size\"><span style=\"text-decoration: underline\"><strong>URL<\/strong><\/span>: <a href=\"https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375560?module_item_id=6174554\">https:\/\/<\/a><a href=\"https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375560?module_item_id=6174554\" target=\"_blank\" rel=\"noreferrer noopener\">templeu.instructure.com\/courses\/137381\/assignments\/2375560?module_item_id=6174554<\/a><\/p>\n\n\n\n<p><br><span style=\"text-decoration: underline\"><strong>Due<\/strong><\/span>: Feb 16 at 5pm (progress), Feb 23 at 3pm (final lab report)<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background:linear-gradient(168deg,rgb(255,206,236) 26%,rgb(152,150,240) 100%)\">LAB 3 <\/h2>\n\n\n\n<p class=\"has-vivid-red-color has-text-color has-link-color has-large-font-size wp-elements-1590f11b5489a4ea152be71af2d709fd\"><strong><a href=\"https:\/\/sites.temple.edu\/souravdas\/2024\/02\/02\/lab-3-few-hints\/\" data-type=\"post\" data-id=\"210\">Click for hints<\/a><\/strong><\/p>\n\n\n\n<p class=\"has-regular-font-size\"><span style=\"text-decoration: underline\"><strong>URL<\/strong><\/span>: <a href=\"https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375556?module_item_id=6174545\">https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375556?module_item_id=6174545<\/a> <\/p>\n\n\n\n<p><br><span style=\"text-decoration: underline\"><strong>Due<\/strong><\/span>: Feb 2 at 5pm (progress), Feb 9 at 3pm (final lab report)<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background:linear-gradient(168deg,rgb(255,206,236) 26%,rgb(152,150,240) 100%)\">LAB 2 <\/h2>\n\n\n\n<p class=\"has-vivid-red-color has-text-color has-link-color has-large-font-size wp-elements-54c08c44d6567dd2150f9af44be20fe4\"><strong><a href=\"https:\/\/sites.temple.edu\/souravdas\/2024\/01\/25\/lab-2-few-hints\/\" data-type=\"link\" data-id=\"https:\/\/sites.temple.edu\/souravdas\/2024\/01\/25\/lab-2-few-hints\/\">Click for hints<\/a><\/strong><\/p>\n\n\n\n<p class=\"has-regular-font-size\"><span style=\"text-decoration: underline\"><strong>URL<\/strong><\/span>: <a href=\"https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375554?module_item_id=6174537\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375554?module_item_id=6174537<\/a><\/p>\n\n\n\n<p><br><span style=\"text-decoration: underline\"><strong>Due<\/strong><\/span>: Jan 26 at 5pm (progress), Feb 2 at 3pm (final lab report)<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-background\" style=\"background:linear-gradient(168deg,rgb(255,206,236) 26%,rgb(152,150,240) 100%)\">LAB 1<\/h2>\n\n\n\n<p class=\"has-regular-font-size\">Before starting out, fill out the student list <em><a href=\"https:\/\/forms.gle\/BQBbXyvVVVZGitxU6\" data-type=\"link\" data-id=\"https:\/\/forms.gle\/BQBbXyvVVVZGitxU6\">form<\/a><\/em> and this <a href=\"https:\/\/sites.temple.edu\/souravdas\/files\/2024\/01\/CRA-Survey-Flyer_2023.pdf\" data-type=\"link\" data-id=\"https:\/\/sites.temple.edu\/souravdas\/files\/2024\/01\/CRA-Survey-Flyer_2023.pdf\"><em>survey<\/em><\/a>.<\/p>\n\n\n\n<p>Lab 1 is only about setting up the Oracle cloud account. So just follow the document.<br><br><span style=\"text-decoration: underline\"><strong>URL<\/strong><\/span>: <a href=\"https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375552?module_item_id=6174529\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/templeu.instructure.com\/courses\/137381\/assignments\/2375552?module_item_id=6174529<\/a><\/p>\n\n\n\n<p><br><span style=\"text-decoration: underline\"><strong>Due<\/strong><\/span>: Jan 19 at 5pm (progress), Jan 26 at 3pm (final lab report)<\/p>\n\n\n\n<p class=\"has-vivid-red-color has-text-color has-link-color wp-elements-c9365267f914bd71ea50e5e539e3962b\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>All the necessary updates and hints for each lab will be posted on this page. INFORMATION GRADE WEIGHTS LINKS Make sure to create your own&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/sites.temple.edu\/souravdas\/\">Continue reading<span class=\"screen-reader-text\">CIS 2109 Lab (Spring 2024)<\/span><\/a><\/div>\n","protected":false},"author":35813,"featured_media":0,"parent":0,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"class_list":["post-107","page","type-page","status-publish","hentry","entry"],"acf":[],"_links":{"self":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/pages\/107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/users\/35813"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/comments?post=107"}],"version-history":[{"count":51,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/pages\/107\/revisions"}],"predecessor-version":[{"id":244,"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/pages\/107\/revisions\/244"}],"wp:attachment":[{"href":"https:\/\/sites.temple.edu\/souravdas\/wp-json\/wp\/v2\/media?parent=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}