Title Analysis and Management CMS, DBMS, and Web Server Assessment Number and Version Assessment 2: Assignment Version:1 Prescription Version NA Semester/Term & Year Term 4, 2016 Campus Auckland Date 09/08/2016 Time allowed/Due Date 15/08/2016 Learning Outcomes 3,4,5,6,7 Total Weighting 30% Learning Outcome LO # LO LO 3: Understand and apply frameworks for evaluation of alternative options in developing ICT plans. LO 4: Develop a clear understanding of the concept of strategy as it concerns the use of ICT plans. LO 5: Compare and contrast methodologies for aligning business directions with ICT strategies in preparing strategic ICT plans. LO 6: Identify steps in the process of developing ICT strategies and prepare realist ICT plans. LO 7: Identify, compare and contrast key roles for IT solutions and broad IT management roles/functions within various organizations. Tasks Details and Learning Outcomes Assessed Task Topic LO Assessed Marks Your Marks 1 ICT Strategy and planning 5,6,7 8 2 Choosing Content Management Systems (CMS) 3-6 8 3 Planning Web server 3,4,6,7 6 4 Practical (CMS and Web Server) 6,7,8 8 Total 30 Assessment Instructions: • This is an individual assignment • This assessment is based on three different tasks to be performed on different scenarios. Task 1 consists on the need and requirement analysis for a Content Management System. Task 2 consists on analyzing and planning for a Web Server. Task 3 is a practical activity that encompasses DBMS, CMS and Web server. • Perform ALL the tasks given in task 1 - task 5. • Use UML and project management tool of your choice to draw the diagrams. • You need to hand in only this document duly completed to the online system. A 10% per day penalty will incur on late submissions. • For details on plagiarism and academic misconduct, please refer to the North Tec policies and procedures available online on the website. STUDENT DECLARATION I declare that: (i) the assignment here submitted is original except for source material explicitly acknowledged; (ii) the piece of work, or a part of the piece of work has not been submitted for more than one purpose (e.g. to satisfy the requirements in two different courses) without declaration; and I also acknowledge that I am aware of North Tec policy and regulations on honesty in academic work, and of the disciplinary guidelines and procedures applicable to breaches of such policy and regulations, as contained in the North Tec website. Submitting this assignment to the online system means that I agree to the above declarations. If this assessment is submitted electronically I understand that by entering my name/student ID below, this declaration will be deemed to have the same authority as a signed statement. Student name: Student ID: Student signature: Date: Tutor/Assessor Shafiq Alam Marks: %: Grade:   Task 1 ICT Strategy and planning (8 Marks, 2 Marks each) The New Zealand Government ICT Strategy and Action Plan to 2017 was approved by Cabinet in June 2013. The Government ICT Strategy was revised in 2015 to ensure that, in a dynamic technology environment, it can achieve the government's aim of an ICT-enabled transformation of public services to New Zealanders . The summary of ICT stragegy is available on https://www.ict.govt.nz/assets/ICT-Strategy/Government-ICT-Strategy-2015-A3.pdf . Your task is: 1. Summarize this strategy and outline different features of the strategy 2. How the focus areas of the strategy will contribute to the desired outcomes 3. Analyse the opportunities outlined in the strategy and identify 2 additional opportunities 4. Relate this strategy to an ICT based small to medium size enterprise Task 2 Choosing Content Management systems (CMS) (8 Marks) Scenario 1: Marketech is a marketing firm which provide effective and innovative ways of marketing product and services to different client in the Auckland area. The company runs different electronic billboard, mobile marketing units, marketing in special events such as sports events, music concerts, and other social events. The new CEO of Marketech is keen to explore new areas of marketing including mobile marketing and web based marketing. The company has recently decided to use a web based content management system (CMS) to deal with the growing need of communication with the customer using Internet. To host and deploy their new marketing platform, being an ICT manager, your job is to address the problem of selecting an appropriate CMS for Marketech. You might use the following (but not limited to) criteria for selecting such a CMS. (License, Support, System Requirements (Operating System, Web Server, Database, Programming Language, Web Browser), Content Management, Development & Standards) Using the above performance measure, how will you address the following questions? Q1. Define at least 5 additional criteria other than the above mentioned ones that you will consider in choosing an appropriate CMS. (2 marks) Q2. Suggest two CMS along with the reason (performance criteria) that most suits the CMS and also outline their relevance and importance for Marketech. (2 marks) CMS Name Performance criteria Relevance and Importance for Marketech CMS 1 1. 2. 3. CMS 2 Q3. Suggest and alternate solution instead of using the above CMS's. Give reasons of how is the proposed alternative solution comparable with the mentioned CMS's. (2 marks) Q4. Suppose the organization was using a CMS and now want to transition to the new solution that you have suggested in Q3, what steps will be involved? How will you plan that the transition is realistic and aligned to the organizational strategies? (2 marks) Task 3 Planning Web server and databases (6 Marks) Using the case study given in task 1 and the performance measures stated above, respond to the following questions. Q1. Marketech wants to host their website on their own web server. Suppose you have been consulted for this task, what will be your performance criteria for choosing a Web Server for Marketech that suits their requirement? List at least 5 such criteria and provide a reason for each. (2 marks) Q2. Suggest one webservers along with the reason (performance criteria) that most suits the CMS along with its relevance and importance for Marketech. (2 marks) Web server Name Reason of selection Relevance and importance Web Server 1 1. 2. 3. 4. 5. Q3. Suppose they have a customer base of 4,000 customers with yearly transactions of approximately 1 million, which Database Management System (DBMS) would you suggest for Marketech? Give reasons of how is the proposed DBMS solution compatible with the mentioned CMS's. (2 marks) Task 4 Practical (CMS, Web Server, and DBMS) (8 Marks) Time to complete this task: 60 minutes Aim: The following practical activity aims to judge student capability to install, configure and test Web Server, DBMS, and CMS. You hand in: The student teacher sign-off form. Sign off form for Task 3 Note: Perform the following activities Tasks Completed/Not completed Allocated Marks Marks obtained 1. Install and configure Apache HTTP server • Install WAMP or XAMP • Check through the local host • Check through the htdocs, or www 1 2. Test Apache HTTP server with a static page and dynamic web page • Check the local host • Check the htdocs, or www • Create an html page and call it using local host • Create a Php page and call it using local host 1 3. Install and configure a CMS • Choose a CMS like WordPress, Joomla, or Drupal • Install it • Configure the admin password and database • Use the admin panel and display it using a browser 1 4. Test a CMS and install a third party template on the CMS • Select a third party template or use the template provided by the examiner • Download the template and configure it in the selected CMS • Make it default template • Display the template 1 5. Install, configure, and test MySql • Download mysql • Install mysql • Configure port, default user, and workbench o Run related services 2 6. Create a sample databased and perform basic selection and projection on a table • Create a database in MySql • Create a table • Insert values in the table • Design and run a projection query • Design and run a selection query 2 Total Marks 8 Supervisor's Signature:_____________________________   Marking Schedule S. No Comments Marks allocated Achieved 1.1 Summarize this strategy and outline different features of the strategy 2 1.2 How the focus areas will contribute to the desired outcomes 2 1.3 Analyse the opportunities outlined in the strategy and identify 2 additional opportunities 2 1.4 Relate this strategy to an ICT based small to medium size enterprise 2 1.1 List at least 5 additional criteria other than the above mentioned ones that you will consider in choosing an appropriate CMS. 2 1.2 Suggest three CMS along with the reason (performance criteria) that most suits the CMS along with its relevance and importance for Marketech 2 1.3 Suggest and alternate solution instead of using the above CMS's. Give reasons of how is the proposed alternative solution comparable with the mentioned CMS's. 2 1.4 Suggest transition steps 2 2.1 Marketech wants to host their website on their own web server. Suppose you have been consulted for this task, what will be your performance criteria for choosing a Web Server for Marketech that suits their requirement? List at least 5 such criteria and provide a reason for each 2 2.2 Suggest three webservers along with the reason (performance criteria) that most suits the CMS along with its relevance and importance for Marketech 2 2.3 Suppose they have a customer base of 4,000 customers with yearly transactions of approximately 1 million, which Database Management System (DBMS) would you suggest for Marketech? Give reasons of how is the proposed DBMS solution compatible with the mentioned CMS's. CMS's. 2 3.1 Install and configure IIS 1 3.2 Test IIS with a static page and dynamic web page 1 3.3 Install and configure Apache HTTP server 1 3.4 Test Apache HTTP server with a static page and dynamic web page 1 3.5 Install and configure a CMS 1 3.6 Test a CMS and install a third party template on the CMS 1 3.7 Install, configure, and test MySql 1 Create a sample databased and perform basic selection and projection on a table 1