University of Southern Queensland- CIS5100

Description

Marks out of

Wtg(%)

Due date

ASSIGNMENT 2

100.00

35.00

5^th June 2019

IMPORTANT INFORMATION

· This assignment must be all your own work. It is acceptable to discuss course content with others to improve your understanding and clarify requirements, but solutions to assignment questions must be done on your own.

· You must not copyfrom anyone, including tutors and fellow students, nor allow others to copy your work.

· All Assignments will be checked using collusion monitoring tools to ensure that each assignment is the original work of the submitting student. Assignments that do not adhere to this requirement will be deemed as being the result of collusion or plagiarism. This may lead to severe academic penalties as outlined in USQ Policy Library: Academic Integrity Policy and Procedure. It is your own responsibility to ensure the integrity of your work. Refer to the USQ Policy Library for more details:

• Academic Integrity Policy
• Academic Integrity Procedure

· This assignment is quite complex, and exposes you to many different components in Microsoft Access (any version from Access 2007 to current), some or all of which might be very unfamiliar to you. The assignment description provides some explanation of how to use these components, but you are also expected to use available resources such as Online Help, the Beskeen et al text, the Practical Skillssections at the end of each Module in the Study Materials, the SAM onlinetutorial activities, the course discussion forums, appendices and practical related videos, as well as exploring and experimenting on your own.

· It is important to make sure you have backups of all assignmentsyou create. This is especially true if you store documents on a flash (thumb) drive. Flash drives can become corrupted or lost very easily. There are many options available (Dropbox, or Google Drive) and USQ students already have access to Google Drive via uConnect - UDrive. Another good idea is to Email your assignmentfile to yourself every-time you finish working on it, that way you have multiple copies of your progress in case you need to revert to a previous stage or are looking for a piece of information you have mistakenly deleted. Please note that lost or corrupted assignment files is not grounds for an extension.

· USQ’s Assessment – Assignment (Late Submission) and Compassionate and Compelling Circumstances procedures relate to Extensions and Late Assignments. They can be found under the following links:

• Assessment – Assignment (Late Submission) Procedure
• Assessment of Compassionate and Compelling Circumstances Procedures

· An Assignment submitted after the due date without an approved extension of time will be penalised. The penalty for late submission is a reduction by five percent (5%) of the maximum markapplicable for the assignment, for each University Business Day or part Business Day that the assignment is late. An assignment submitted more than ten (10) University Business Days after the due datewill have a mark of zerorecorded for that Assignment.

· References are required and theHarvard AGPSstandard of referencing must be used, including in-text referencing. Ensure that your reportand presentationare fully referenced, including any references to the textbook. Your essayshould include a List of Referencesusing theHarvard AGPS standards. A useful link on referencing is from USQ’s Library site:<http://www.usq.edu.au/library/referencing>

· Any direct and paraphrased quotes mustbe referenced using Harvard AGPS style and listed in the List of References.

Do not repeat verbatim large portions of information from other sources such as the text or video – you must put the ideas/information in your own words. Only use small direct quotes where possible.

• Students are encouraged to work in teamsto complete the assignment as teamwork is an important skill required by industry. You may choose to work alone.

• If you opt to work as a team:

• The same marks will be awarded to both students.
• No team can exceed more than two students.
• It is up to you to find a team-mate and this can usually be achieved through a request on the Study Desk.
• Only one team membershould submit the assignment.
• You must provide the student names and student numbers of both team memberson the title pageof the report.

• All students MUSTemail the Course Teamby the 23^rdMarch 2019the following information using the link provided in the Assignment 2 Area within the Assessment Tab. You will NOTbe able to submit your Assignment until you have notified the Course Team; Assignments will be treated as lateuntil notification is made.

• Please use the following email templateand ensure you cc the emailalso to your teammate:

Subject: CIS5100 S1 2019 Assignment 2

Dear Course Team,

[I / we] have been working [individually / in a team] on CIS5100 Assignment 2 and [I / we] will be submitting the Assignment [by myself / as a team of two students]:

1. [Enter Student Full Name] [Enter Student ID] [Enter Campus] [Email Address]
2. [Enter Student Full Name] [Enter Student ID] [Enter Campus] [Email Address]

ASSIGNMENT 2 REQUIREMENTS

Applicable course objective:

· critically analyse business requirements from an information systems perspective

· critique information systems concepts to identify and resolve problems within a business context

· identify the appropriate information systems to develop practical solutions within a business context

· communicate information systems concepts to both technical and non-technical audiences within a business context.

Applicable graduate qualities and skills gained from this assessment instrument:

· Problem Solving (Skill U2)

· Written & Oral Communication (Skill U4)

• ,
  Rainbow Gardens, FloriFlorarieMunta Rainbow Gardens bucuresti Romania.

Dr Rikki Wagnerwas extremely impressed with our computing firm’s – Mendelssohn Technologies– development of the Queen of Sheba Wedding Emporium’ Database Management System (DBMS) utilising Microsoft Access and Decision Support System (DSS) utilising Microsoft Excel (Assignment 1).

Dr Wagnerrealises that the business has a lot to learn and that the business will need to invest considerable money to bring the business into the modern online business world, from their current single computer mail order set-up. Dr Wagnerhas contracted our firm to advise the business on how they can grow their mail order business into a cutting-edge online presence. The business has asked us to develop a report to provide them with information about the following topics that they see as key to their business growth:

1. What type of hardware and software, including networking infrastructure and/or a combination of cloud services, should the business acquire and/or procure to expand their capabilities to meet their new e-business initiative?

(Use Baltzan Chapter 5 - Technical Fundamentals to assist you in answering this topic)

1. What would be the benefits to the business of using business intelligence?

(Use Baltzan et al Chapter 8 Section 2 – Business Intelligence)

1. What would be the benefits to the business of implementing a customer relationship management system?

(Use Baltzan et al Chapter 10 Section 1 –Enterprise Information Systems: CRM to assist you in answering this topic)

1. What issues should the business be aware of when embarking on a social media presence?

(Use Baltzan et al Chapter 11 Section 2 – Social Media to assist you in answering this topic)

• You are expected to have access to the Baltzan et al 3rd Edition textbook as your starting point to answering all the above questions – use of Google search in place of the textbook may result in lower or failing marks.

Mrs Georgie Handel, your manager, has set up the following tasks for you to complete this project:

• Task 1: Personal Research Journal
• Task 2: Case Study Report
• Task 3: PowerPoint Presentation to Client

Refer to the marking criteria for details of mark allocations.

• All Tasks in this project must be developed with professionalism and user-friendliness in mind.

Time on Activity

27 Sept 2017

Investigation into the Information Technology Strategies should the Business consider to obtain / retain competitive advantage in their marketspace.

John Smith

• Baltzan et al 2013, Business Driven Information Systems, McGraw-Hill.
• Canon, M 2016, The Importance of IT Strategic Planning and How to Approach It, viewed 27th Sept 2017, <http://documentmedia.com/article-2401-The-Importance-of-IT-Strategic-Planning-and-How-to-Approach-It.html>.

4 hours

29 Sept 2017

How the business should be considering using Social Media as an avenue for communicating with their customers and promoting their brand.

John Smith / Fred Nerks

• Baltzan et al 2013, Business Driven Information Systems, McGraw-Hill.
• Entrepreneur 2011, 10 Laws of Social Media Marketing, viewed 29th Sept 2017, <https://www.entrepreneur.com/slideshow/299334>.

3 hours

Submit this journal as an appendix to Task 2 (after the List of References and include in the Table of Contents).

Your report should include a professional title page, computer generated Table of Contents (including List of Tables and List of Figures) and Appendices.

Note: Make sure to state the names of all students involved in the report on the title page.

Your report should include a letter of transmittal, executive summary, and introduction to the report.

What type of hardware and software, including networking infrastructure and/or a combination of cloud services, should the business acquire and/or procure to expand their capabilities to meet their new e-business initiative?

• Develop a computer hardware proposal(including printer(s)) to allow the business to provide up to ten (10) staffwith computer access, including current Australian prices for the equipment. If you decide on a cloud-based infrastructure solution, develop the proposal to enable cloud services for infrastructure for server and data storage requirements, e.g. Amazon EC2 or Microsoft Azure. Justify why your proposal is necessary for the business.

• Develop a computer software proposal, including both system and application software, to support the proposed computer hardware proposal, including Australian prices for the software. If you decide on a cloud-based software solution, develop the proposal to enable cloud services for software for e-commerce solutions, e.g. Microsoft Dynamics e-commerce or BigCommerce. Justify why your proposal is necessary for the business.
• Include a diagramof the proposed hardware, software and network infrastructure; or the proposed cloud solution architecture; to help Dr Wagner visualise what you are recommending.

(Use Baltzan Chapter 5 - Technical Fundamentals to assist you in answering this topic)

What would be the benefits to the business of using business intelligence?

• How could the business use business intelligence? Outline for Dr Rikki Wagnerhow business intelligence can assist the business decision making.

• How could the business use data mining to gain competitive advantage? What type of data mining would best suit the current business's analysis needs? Why?
• What type of business intelligence tools would best suit the business's current needs? Why?

(Use Baltzan et al Chapter 8 Section 2 – Business Intelligence)

What would be the benefits to Dr Rikki Wagnerof implementing a customer relationship management system?

• How could the business support its customer facing day-to-day operations through the use of an operational customer relationship management system for marketing?  Justify your answer.

• How could the business support its customer facing day-to-day operations through the use of an operational customer relationship management system for sales? Justify your answer.
• How could the business support its customer facing day-to-day operations through the use of an operational customer relationship management system for customer service? Justify your answer.
• In what different ways could Dr Rikki Wagneruse metrics from the business’s customer relationship management systems to track and monitor performance for sales, service and marketing. Justify your answer. 

(Use Baltzan et al Chapter 10 Section 1 –Enterprise Information Systems: CRM to assist you in answering this topic)

What issues should the business be aware of when embarking on a social media presence?

• Outline to Dr Rikki Wagnerwhy the business should also be considering using Social Media as an avenue for communicating with their customers and promoting their brand. 

• Review and critique, including providing screen captures, the social media presences of three (3) other businesses that sell similar products to Dr Rikki Wagner’s. 
• How should the business manage their social media presence? Develop a draft Social Media Policy for the business that they can implement if they were to embark on a social media strategy.

(Use Baltzan et al Chapter 11 Section 2 – Social Media to assist you in answering this topic)

Your report should include separate conclusions and recommendations sections.

• Conclusions provide a summary of your key findings from the body of the report.
• Recommendations provide a summary of the recommendations to the business based on the research conducted in the report.

References are required and the Harvard AGPSstandard of referencing must be used. This standard is detailed on USQ Library Site <http://www.usq.edu.au/library/referencing>.

Ensure that your reports are fully referenced, including any reference to the text book. Your report should include in-text referencesand a List of References.

Do not repeat verbatim large slabs of information from other sources such as the text – you must put the ideas/information in your own words.

You must use at least ten (10) academically sound sources other than the textbookin completing this report.

• You are expected to have access to the Baltzan et al 3rd Edition textbook as your starting point to answering all the above questions – use of Google search in place of the textbook may result in lower or failing marks.
• Note:the word count does not include letter of transmittal, executive summary, references or appendices. 

Mrs Georgie Handel has asked you to provide a professionally developed business presentation to the client, Dr Wagner, outlining the project scope, key findings and key recommendations from the Case Study Report. Create a Microsoft PowerPoint Presentation (using PowerPoint 2007 to current) and name it [1^ststudent lastname] / [initial] _ [student number] _ & _ [2^ndstudent lastname] / [initial] _ [course code] _ assign2.pptx(eg.genrichr_0050051005_cis1000_assign2.pptx).

Make sure that your professional developed business presentation is prepared so that it conforms to the course StudyDesk presentation resources. These resources include, but are not limited to the Practical Appendixes found on the Study Schedule and Module Materials and various videos.

The professional business presentations set of slides should be structured as follows:

• Title – outlining the full Business Name, Project Description, Student Name and Student ID.
• List of Topics  
• Presentation Content – the following are the topics the presentation must answer: 
  • Outline the Scope of the Report
  • List and discuss the Key Findings from the Report
  • List and discuss the Recommendations from the Report

• Each slidemust include detailed speaker notes provided in the notes section of the slide – the detailed speaker notes must provide a full answer to each of the following questions and it should be written so that another person could present this presentation on your behalf to the client. You must include in text referencing in the note section for any direct and paraphrased quotes.
• DO NOT PROVIDE THIS AS AN AUDIO RECORDING
• Summary of Presentation
• Bibliography 

• Note: It is expected that you will use the Baltzan et al and Beskeen et al textbooks to answer the topics Mrs Georgie Handel has given you for the presentation, as well as reputable online sources of information. You need to include a brief Bibliography formatted using the Harvard AGPS style on a separate page (see the following USQ website for referencing help:http://www.usq.edu.au/library/referencing/harvard-agps-referencing-guide. 

Attach the Microsoft Word files(using any version from Word 2007 to current) and Microsoft PowerPoint files(using any version from PowerPoint 2007 to current) using the naming convention below, to your online assignment submission in the Assignment 2 area on the CIS5100 StudyDesk before midnightAustralian Eastern Standard Time (AEST) on the day the assignment is due.

1. [1^ststudent lastname] / [initial] _ [student number] _ & _ [2^ndstudent lastname] / [initial] _ [student number] _ [course code] _ assign2.docx
   (eg.GenrichR_0050051005_&_ShresthaA_0050051555_cis5100_assign2.docx).
2. [1^ststudent lastname] / [initial] _ [student number] _ & _ [2^ndstudent lastname] / [initial] _ [course code] _ assign2.pptx
   (eg. GenrichR_0050051005_&_ShresthaA_0050051555_cis5100_ assign2.pptx). 
   • Note: Simply changing the file extension to .docx on a Word 2003 file will not result in a suitable submission. If the assignment files cannot be opened by the marker, it may be treated as late until a suitable replacement is received.

Upon completion of the submission process, check your uConnectemail account for an automatically generated confirmation email (if you do not have an email account, print out the Submission Complete screen before exiting the Submission System). You mustcheck that the file name and file size are listed correctly - if there is a problem with either, please email the course leader immediately.

If you have difficulties submitting through the StudyDesk Assignments submission tool, please review the Student Instructionsdocument listed also on the CIS5100 StudyDesk. As a last resort only, email the course leader for instructions on an alternative course of action.