Information system
Required – Spreadsheet

General
1. Create a single spreadsheet file and title it myname – tool1 (example: Mosher – Tool 1)
2. Generate the worksheets (tabs) as described below
3. Some check figures are provided in the attachments to assist in getting the calculations correct

Grade Calculation Worksheet
1. Title worksheet (tab): “Grade Calculation”
2. Create and enter the information supplied in Attachment 1 – List of Students and Grades
3. Utilize the frame found in Attachment 2 –Grade Calculation Frame
4. Calculate the missing data with the following rules:
a. Decision Tools column
i. Total = sum of individual grades (use SUM function)
b. Mid Term column
i. Adjusted = Actual + Adjustment (use absolute reference)
ii. Determine the letter grade using the LOOKUP function into the Grade Table worksheet
c. Final Exam column
i. % = Actual ÷ Possible (use absolute reference and format as %)
ii. Adjusted = ((Actual + Adjustment) ÷ Possible) * 100
iii. Determine the letter grade using the LOOKUP function into the Grade Table worksheet
d. Final Grade column
i. Total = Decision Tool Total + (Mid Term Adjusted * .35) + (Final Exam Adjusted * .35) [FYI… grades are 30% tools, 35% MT and 35% Final]
ii. Determine the letter grade using the LOOKUP function into the Grade Table worksheet
e. Average row
i. Determine the Average for each column using the AVERAGE function
f. Max row
i. Determine the largest amount for each column using the MAX function
g. Min row
i. Determine the smallest amount for each column using the MIN function
h. Adjustment
i. Adjustment amount (provided – no additional input required) to be used as instructed above
i. Possible
i. Possible score (provided – no additional input required) for each assignment to be used as instructed above
j. Count
i. Number of numeric items listed within each column. Use the COUNT function

Grade Table worksheet
1. Title worksheet: Grade Table
2. Recreate the following grade matrix (used for the LOOKUP function):

From To Grade
0 59 F
60 62 D-
63 66 D
67 69 D+
70 72 C-
73 76 C
77 79 C+
80 82 B-
83 86 B
87 89 B+
90 92 A-
93 100 A

Grade Distribution worksheet
1. Title worksheet: Distribution
2. Use the frame as shown in Attachment 3 – Grade Distribution Frame
3. Use the COUNTIF function as per the following
= COUNTIF(graderange,currentgrade)

Where:
• graderange is the range of values from the Grade Calculation worksheet
• currentgrade is the grade category you are totaling

4. Hint: For the Grades row, count the Total column from the Final Grades area within the Grade Calculation worksheet

Mid Term Chart worksheet
1. Title worksheet: MT Chart
2. Create a bar chart in a separate worksheet
3. Use values (single series) from the MT Adj row from the Distribution worksheet
4. Provide an appropriate title on top of the chart
5. X axis labels: Grades A – F
6. Y axis labels: Number 0 – ?? (let program establish default)

Grade Chart worksheet
1. Title worksheet: Grade Chart
2. Create a line chart
3. Use values from the Final Adj row and the Grade row (2 series) from the Distribution worksheet
4. Provide an appropriate title on top of the chart
5. X axis labels: Grades A – F
6. Y axis labels: Number 0 – ?? (let program establish default)
7. Include legend at the bottom of the chart

In this individual assignment you will investigate process re-design and develop implementation guidelines for an industrial internet-of-things (IoT) application of your choice. You could find this application by looking at websites such as www.informationweek.com and www.rfidjournal.com. In writing your report you may not have sufficient information on technologies and processes and it is fine to make some assumptions, as long as these are clearly stated and justified.

Your report should include the sections as follows:

1. Literature review, in which you introduce the topic chosen by citing appropriate academic and practitioner sources. (20 marks)
2. Business processes before implementation, in which you describe the processes where the chosen technologies will be applied. You should use business process diagrams, including decision flow-charts, to describe the processes. (20 marks)
3. Technology description, in which you identify where and how the technologies will be used. You should use a diagram to explain how the technologies work.
(20 marks)
4. Business processes after implementation, in which you describe how processes should change after implementing the application. You should update the diagrams you introduced in section 2. (10 marks)
5. Benefits and costs, in which you make a short business case for the implementation of the application in organisations. (20 marks)
6. Implementation guidelines, in which you may take into account technical and organisational limitations for example by mapping the possible interactions among technologies and people. (10 marks)

Where diagrams are used these should normally be included in the main body of your work. If they are located in the appendix they will not have a role in the assessment – examiners are under no obligation to read appendices.
Overall word limit: 3,000 words maximum.

SUBMISSION INSTRUCTIONS
Your completed assignment must be uploaded to DUO
no later than 12:00 midday on25 April 2016.

A penalty will be applied for work uploaded after 12:00 midday as detailed in the Programme Handbook. You must leave sufficient time to fully complete the upload process before the deadline and check that you have received a receipt.
An IDENTICAL paper copy should be placed in the post box outside the Undergraduate Office in the Business School no later than 15:00 (3 pm).Work will not be marked unless this identical paper copy is received.
Assignments should be typed, using 1.5 spacing and an easy-to-read 12-point font. You should use double-sided printing, and ensure that assignments are securely bound.Written assignments and dissertations/business projects must not exceed the word count indicated in the module handbook/assessment brief.
The word count should:
? Include all the text, including title, preface, introduction, in-text citations, quotations, footnotes and any other items not specifically excluded below.
? Exclude diagrams, tables (including tables/lists of contents and figures), equations, executive summary/abstract, acknowledgements, declaration, bibliography/list of references and appendices. However, it is not appropriate to use diagrams or tables merely as a way of circumventing the word limit. If a student uses a table or figure as a means of presenting his/her own words, then this is included in the word count.
Examiners will stop reading once the word limit has been reached, and work beyond this point will not be assessed. Checks of word counts will be carried out on submitted work, including any assignments or dissertations/business projects that appear to be clearly over-length. Checks may take place manually and/or with the aid of the word count provided via an electronic submission. Where a student has intentionally misrepresented their word count, the School may treat this as an offence under Section IV of the General Regulations of the University. Extreme cases may be viewed as dishonest practice under Section IV, 5 (a) (x) of the General Regulations.
Very occasionally it may be appropriate to present, in an appendix, material which does not properly belong in the main body of the assessment but which some students wish to provide for the sake of completeness. Any appendices will not have a role in the assessment – examiners are under no obligation to read appendices and they do not form part of the word count. Material that students wish to be assessed should always be included in the main body of the text.
Guidance on referencing can be found in the programme handbook and on DUO.

MARKING GUIDELINES
Performance in the summative assessment for this module is judged against the following criteria:
• Relevance to question(s)
• Organisation, structure and presentation
• Depth of understanding
• Analysis and discussion
• Use of sources and referencing
• Overall conclusions