Fluent Essays

The intention is to practice the IT skills you have acquired so far by practicing in the given assignment. question_paper__5_.pdf Unformatted Attachment Preview HIGHER COLLEGE OF TECHNOLOGY DEPARTMENT: Information Technology Final Assignment Semester: 2 Assignment Posted Date: 19 May 2020, Tues. Time: 9:00 AM Platform (e.g. E-Learning, Microsoft Teams, etc.) Course Code Course Name Level A. Y.: 2019/2020 Submission Deadline Date: 21 May 2020, Thur. Time: 9:00 AM E-Learning Portal ITAD1100 Advanced IT Skills Diploma GENERAL COLLEGE GUIDELINES 1) 2) 3) 4) 5) 6) 7) 8) All students are given 48 hours to complete and submit their assignment from the day, date and time the assignment is uploaded. Only one assignment is given to the students within the 48-hour period given. Student should contact their respective department if more than one assignment is given within the same period (As indicated in point 7). Assignment answer scripts will be uploaded through any of the following platforms or combinations of the following: e learning, Moodle and or any course specific platform identify by the course tutor. However, students may submit their assignment through HCT emails in case if they have encountered any technical issue with the platform stated above. Student’s submissions will be checked through Turnitin software to ensure academic integrity, if applicable. According to Turnitin article on interpreting Turnitin originality report, a high percentage of plagiarism would probably be anything over 25\%. Students who fail to submit their assignment as per the deadline given; will be granted “Zero” unless otherwise justified. If students encounter any problem in submitting their course assignment, they should communicate immediately via email to their course lecturer. The student must attach proof of their inability to submit their course assignment. Students will be allowed to submit an online appeal regarding failure of assignment submission issue within three days from the date of submission deadline. The appeals will only be accepted if the student provides genuine excuse for the submission failure with attached evidence. Student may need to ask for support assistant with two related matters as following: a) Technical issues; will be tackled by the specialized technicians from Educational Technology Center (ETC). b) Course specific inquiries/support issue; students who require any clarifications on the assignments can immediately contact their respective course tutors /lecturers through emails (within the 48-hour period given). Course tutors/ lecturers should respond promptly to the student’s doubts and queries. The following are the necessary contact details for technical and department specific support: - For technical support please contact the below e mail as follow: Any Issue Related: E-mails accounts and Microsoft TEAMS Any Issue Related: E-Learning Moodle Any Other IT Troubleshooting - Office365support@hct.edu.om Support.elearning@hct.edu.om Helpdesk2@hct.edu.om For Academic related support please contact the below e mail as per the academic department identify below: Mr. Roby Surendran roby.surendran@hct.edu.om Mr. Mohammed Mushtaq md_mushtaq@hct.edu.om Mr. Jagathprasad Shreedhar jagath.sreedhar@hct.edu.om Mr. Bhaskar Ponna ponna.bhaskar@hct.edu.om Ms. Rachana Marathe rachana.marathe@hct.edu.om Ms. Jacqueline Fat Yara jacqueline.yara@hct.edu.om Page 1 of 7 Higher College of Technology Information Technology Department STUDENT DECLARATION FORM FOR ASSIGNMENT DEPARTMENT GUIDELINES: TERMS AND CONDITIONS 1. Never share or post the test questions or answer scripts for any purpose. 2. Starting from the posting of the question test papers online, the students are given exactly 48 hours to submit their answers. At the end of the 48 hours, the submission link shall be deleted or deactivated. NO EXTENSION WILL BE GIVEN. Failure to submit the answer within the 48-hour period will result to ZERO mark. 3. In case of technical problems, inform the Lecturer immediately through the HCT Email or through chat message in MS Teams, at least two (2) hours before the expiration of the 48-hour period. 4. For IT exams, there is a separate Answer Script Template where students should type their answers. For Math exams, handwritten answers are allowed. Make sure to include Student Name on each page and the question number to avoid confusion. 5. Do the proper citation in every answer taken from other sources, if applicable. 6. For handwritten answers, submit a SCANNED COPY of the answers IN SINGLE FILE. [You can use any available mobile app scanner if in case you do not have a scanner device.] 7. Send the scanned SIGNED COPY of this Declaration Form along with the answer scripts to the Lecturer. The Lecturer will NEVER mark any answer scripts without this signed Declaration Form. [If printer is not available, write this Declaration Form in A4 paper and affix the signature.] 8. Upload the ANSWER SCRIPTS ALONG WITH THE DECLARATION FORM in the appropriate platform/tool as written on the exam paper. 9. Always abide by the College Academic Integrity and Honesty Policy found at https://www.hct.edu.om/pdf/pms/academicintegrity-and-honesty-policy.pdf. 10. Abide by the guidelines mentioned above and any violation of the same will be subjected for a disciplinary action or get ZERO mark, as the case may be. STUDENT DECLARATION I, (Student’s Name)…… …………….……………………………………………… with (Student’s ID): ……………. of ……………. (Level)………………….. and who belongs to (Section)……… of the (Course Code/Course Title)………………………..…………………………………. offered by the (Department)………. department, hereby declare that my submission of Assignment is a result of my own original work except for source materials explicitly acknowledged by proper citations. I also understand that plagiarism and cheating are offenses that can lead to disciplinary action and GRADE OF ZERO, as the case may be. Signature: ………………………………………….. Date (dd-mm-yyyy): ……………………………. Page 2 of 7 Netacad [15 Marks] In your Excel Sheet Netacad, type your appropriate answer. 1. Mr. Abdul visits to the hospital for regular checkup. The data related to Mr. Abdul’s health will be called as 2. The connected electronic information network has become integral part of our lives and safeguarding them is referred as 3. In an Organization, if the Corporate data includes personal information, intellectual properties and financial data and it is called as 4. If the hackers stolen the user email address, password reminders as a security breach. Which technique should be used to safeguard users account information? 5. Data coming into a program with malicious content and it will be designed to force the program to behave in an unintended way and this happens because of 6. When a malicious application accesses memory allocated to other process and this type of vulnerability is called as 7. Google search work by ranking pages and presenting relevant results based on user’s search queries. The technique used to improve the website’s ranking is called as 8. A small organization has 50 computers in its company. Which method to be followed to keep all 50 computers safe inside the organization? Page 3 of 7 9. Mr. Rashid is downloading e-books on his computer. Without his knowledge, malicious software such as viruses, trojan horses comes and sits in his computer. Suggest how Mr. Rashid can protect his computer? 10. Mr. Salim has given the password as “ilikemyschool” for his online account and it can be easily remembered. Which category of password the above password belongs? 11. Popular online services such as Google, Facebook and Apple use a personal identification number (PIN) along with user name and password. What is this called as? 12. When a malicious party sends a fraudulent email to trick the recipient to share his password and this technique is called as 13. If an employee of an organization mishandles the confidential data, then it can be considered as 14. Mr. Said is working in an organization and he notices that someone has hacked into his computer and altered images in his social network sites. What should be the punishment for the hacker as per Royal Decree No.12/2011 cybercrime law? 15. If an employee is working in an organization and if he is passing on secret information to another rivalry organization. What should be the punishment for the hacker as per Royal Decree No.12/2011 cybercrime law? Page 4 of 7 SECTION – A [19.5 Marks] 1. In your Sheet SECTION A, you can see the data as shown below. The answers must be written in the cells with question marks (?) using functions. Instruction : From cell C5 to F13, kindly fill up any number. Sample number values are given in C4 TO F4 and E10 retain as it is. A. Using Functions, perform the following: NO CRITERIA 1 In G4:G13, Find the Total for each city by using an appropriate function. Mark 1 2 In the City size column, H4:H13, if the Total is greater than 360 display “Big”; otherwise, display “Small”. 3 1 4 5 In City Code column I4:I13, join the City Name (Column A) and Postal Code (Column B) by using an appropriate function. Find the Average of 2019 in C15 Find the Integer of the Average of 2019 in C16 6 Find the Roman equivalent of the “Integer of Average of 2019” in C17 1 7 Count the number of blanks in 2018 and display in D18 1 8 Search for the City Name Nizwa (Column A) and find out the corresponding Total 1.5 1 1 1.25 (column G) using the appropriate function. Display the result in G19 Page 5 of 7 9 Find the Sum of Total where Postal Code is 511 and display the result in G20. 1.25 10 11 Display the third lowest population in 2019 in C21 Find the most often value of the population for 2017 and display the results in E22 1.25 1 12 Find the Standard Deviation of population in 2019 and display the result in C23 1 B. Perform the following. (Functions may not be used) 13 Divide “Total” with Density given in J14 (use absolute reference) and display the results in Population Density \% for each City by J4:J13 in percentage(\%) format. 14 Type your FirstName_ID in G24. Create a link to website “https://www.google.com” 1.5 15 1.25 16 Highlight all the years from C4:F13 that are above or equal 100 with Green text and fill yellow color. Create a line spark line for each year in the locations C14:F14 17 Define a name “Population_Report” for the range F4:F13 1.25 SECTION B 1 1.25 [15.5 Marks] 1. In your sheet SECTION B - 1 you can see the data as shown below. Replace the question marks (?) in the Answer column with the appropriate function as provided in the Question column. [3.75 Marks] Page 6 of 7 2. In your sheet SECTION B - 2, you can see the data as shown below. Answer the following using the appropriate function [11.75 Marks] Instruction : From cell B3 to E8, kindly fill up any number. Sample number given in B2 to E2 No. CRITERIA Marks a. Apply Sort A1:E8 range based on Stationary (A column) in Ascending order 1. 5 b. Using AND function, check the condition (D2 is greater than 1500, E2 is less than 1.25 1000), and display the result in cell F2 b. Using OR function, check the condition (B4 is less than E4, D6 is greater than 1.25 4000), and display the result in cell F3 c Using NOT function to check the condition (E4 is less than D7) and display the 1 result in cell F4 d. Apply Freeze panes in second Row and second column e. Perform regression analysis for the given data using Sohar values as Y- Range and 1 Muscat values as X - Range. Display the normal probability plot in a new sheet.  Apply the border on Plot area with red color and width 4pt.  Add Trend line -polynomial.  Data labels = Above.  Fill the Chart Area with yellow color.  Chart title “Population Report” and underline 5.75 Note: After saving your Excel file, close it, and UPLOAD your file folder, together with the signed Student Declaration Form, in the link provided in the E-Learning portal. Only uploaded files will be marked accordingly. Page 7 of 7 ... Purchase answer to see full attachment