Assessment Task Instructions.

Added on - Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 4 of 11 pages
Assessment Task Instructionsand Feedback Form(non-graded)Task No.3Task TitleAssessment Item 3Due Date30/11/2018Unit / Module detailsQualification/CourseCodeICT60515TitleAdvanced Diploma of Computer Systems TechnologyUnit/ModuleCodeICTWEB501TitleBuild a Dynamic WebsiteAssessment detailsAssessorAssessor’s nameVikram BehalAssessor’s phone03 9254 6130Assessor’s emailvbehal@kangan.edu.auElements / LearningoutcomesElement 1, 2, 3,4RTO Identifier 3077 | CRICOS provider number 01218GVersion 1.0Last saved 21/11/2018Page1of11
Assessment Task Instructionsand Feedback Form(non-graded)Task overview(see below for specificinstructions and criteria)Students are required to accomplish their task professionally and in allocated time. This projectrequires students to work individual, however they can discuss contents of website with their team. Itis their responsibility to inform teacher if they need any extra time to accomplish this task.Task 1.Students are required to create SQL File/script to do following:a.Create one database called booksb.Create user 'user3'@'localhost' password 'Password01' and GRANT him permissions likeSELECT, INSERT, UPDATE and DELETE.c.CREATE TABLE Book as per Task Instructions and Student Work (page 7)d.CREATE TABLE Author as per Task Instructions and Student Work (page 7)e.CREATE TABLE Customers as per Task Instructions and Student Work (page 7)f.CREATE TABLE Order as per Task Instructions and Student Work (page 7)g.ALTER TABLE Order as per Task Instructions and Student Work (page 7)h.ALTER TABLE Book ADD FOREIGN KEY Author_id and link it with Authorid of Author(Books database) as under:i.(Authorid) REFERENCES Author(Author_id);f. Inset at least four records in both tablesg. Import script in your WAMP make sure you logged in as root in WAMP.h. Upload SQL file/script with this fileTask 2.Students are required to create web site for Small Engineering Bookshop. Bookshop is dealingwith new and old engineering related books. Website for small Engineering Bookshop mustcontains following, however first page must have three sections. Students are required to usebooks database provided by teacher:a.Top section must DisplayName of Business, Address of Business Phone number and Fax number.b.Left hand section must contain links to different web sites and/or links to business. Somesample links are as under:i.Homeii.Book Listiii.Author Listiv.Customer Listv.Form to insert customer details into table customersvi.Useful links to other websitesKangan InstituteGoogle AustraliaWorksafe Victoriavii.Contact usTask 3.Students are required to use database books. When student will click on Book List. They mustget three options as under and they must display records as per options. Students must displaycontent of Task 2 in a table format.a.Display 1stfive records from table boo.b.Display seven records from table book starting from 3rdrecord.c.Display 1stfive records from table book and display only id, ISBN, Title and description.Task 4.Students are required to use database books. When student will click on Author List, It mutdisplay all authorsTask 5.Students are required to create one web page with simple form to insert data into tablecustomer of database books. Form must have two buttons Clear and submit. When student willpress clear button form must clear all fields and when student will enter submit button, data mustbe inserted into table “Customer” of database books.Task 6.Students are required to create one web page with simple form to insert data into tableOrder of database books. Form must have two buttons Clear and submit. When student will pressclear button form must clear all fields and when student will enter submit button, data must beinserted into table “Order” of database books.Task 7.Students are required to create user documentation for above website (for all above tasks).Please note Add screenprint at the end of this document.RTO Identifier 3077 | CRICOS provider number 01218GVersion 1.0Last saved 21/11/2018Page2of11
Assessment Task Instructionsand Feedback Form(non-graded)AssessmentconditionsThis information is to be handed to each student to outline the assessment requirements.This is open book assessment.Students are required to submit this assessment item as a report.This Assessment Item requires students to work individually and address all requirements/complete all tasks as per Assessment instructions and criteria.Students are required to accomplish their task professionally and in timeStudents must submit this Assessment item at MyLearningThis assessment item is assignmentStudent can complete this assessment in their own time. This assessment item is due in week8; however student can negotiate time with teacher under special circumstancesRead the Plagiarism policy and procedure carefully to understand the consequences that youcould face if your work is plagiarized.You plagiarize if you present other writers' words or ideas as your own.You must use citations to document all ideas and significant information that are not yourown.Submit this document by the due date (penalties applies)Insert your name and student id in the footer.Use Font: Arial Font Size: 10 Heading: Bold Arial Heading Size: 12 Sub Heading: Bold ArialSub Heading Size:Marking Criteria for this assessment Item is as underResourcesResources are available through MyLearningHow to submitComplete Assessment items as per assessment Item description and upload assessment item atMyLearningAll items submitted must be clearly marked with the following details:Your full nameYour student numberYour class groupThe dateThis cover sheet must accompany all items submitted.RTO Identifier 3077 | CRICOS provider number 01218GVersion 1.0Last saved 21/11/2018Page3of11
Assessment Task Instructionsand Feedback Form(non-graded)Assessment instructions and criteriaWith competency based assessmentallassessment requirements for each assessment task must be assessed as satisfactory(S)for a competent(CA)result to be recorded. If an assessment result for any task is assessed as not satisfactory(NS)aresubmission will be required for the outstanding(NS)assessment task.Rows can be deleted by left clicking to the left of the row and clickBackspaceRows can be added by left clicking to the left of the row and clickCTRL+Cand thenCTRL+VInstruction/TaskCriteria that you will be assessed onSNSTask 1. Students are required to create SQLFile/script to do following:a.Create one database calledbooksb.Create user 'user3'@'localhost'password 'Password01' andGRANT him permissions likeSELECT, INSERT, UPDATE andDELETE.c.CREATE TABLE Book as per TaskInstructions and Student Work(page 7)d.CREATE TABLE Author as perTask Instructions and StudentWork (page 7)e.CREATE TABLE Customers as perTask Instructions and StudentWork (page 7)f.CREATE TABLE Order as per TaskInstructions and Student Work(page 7)g.ALTER TABLE Order as per TaskInstructions and Student Work(page 7)h.ALTER TABLE Author ADDFOREIGN KEY Author_id and linkit with Authorid of Book (Booksdatabase) as under:(Author_id) REFERENCESBook(Authorid);f. Inset at least four records in bothtablesg. Import script in your WAMPmake sure you logged in as root inWAMP.h. Upload SQL file/script with thisfileStudents createed SQL File/script to do following:a.Create one database called booksb.Create user 'user3'@'localhost' password'Password01' and GRANT him permissions like SELECT,INSERT, UPDATE and DELETE.c.CREATE TABLE Book as per Task Instructions andStudent Work (page 7)d.CREATE TABLE Author as per Task Instructions andStudent Work (page 7)e.CREATE TABLE Customers as per Task Instructions andStudent Work (page 7)f.CREATE TABLE Order as per Task Instructions andStudent Work (page 7)g.ALTER TABLE Order as per Task Instructions andStudent Work (page 7)h.ALTER TABLE Author ADD FOREIGN KEY Author_id andlink it with Authorid of Book (Books database) asunder:(Author_id) REFERENCES Book(Authorid);f. Inset at least four records in both tablesg. Import script in your WAMP make sure you logged inas root in WAMP.h. Upload SQL file/script with this fileRTO Identifier 3077 | CRICOS provider number 01218GVersion 1.0Last saved 21/11/2018Page4of11
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access