( CIS5100 Assignment 1 semester 3 , 201 9 ) CIS5100 Assignment 1 Marking Scheme Student Name: Click here to enter text.Student ID: Click here to enter text. Marker Initials: Choose an item.Date...

Please do my assignment



( CIS5100 Assignment 1 semester 3 , 201 9 ) CIS5100 Assignment 1 Marking Scheme Student Name: Click here to enter text.Student ID: Click here to enter text. Marker Initials: Choose an item.Date Marked: Click here to enter a date. This document intention is to both grade and provide feedback on CIS5100 Assignment 1. You should note both the mark given for each activity and the areas that were of issue in your submission. Marking summary Part a Database Creation / 2 Database Tables – Text File Import / 2 Table Design – Setting Appropriate Data Types / 5 Table Design – Setting Appropriate Field Descriptions & Properties / 5 Table Design – Primary Keys / 2 Table Relationships / 2 Editing Customer Table Data / 2 Query Design – Query 1: Import Duty Belgium (BE) Increase / 5 Query Design – Query 2: Late Dispatched Orders Form Query / 5 Query Design – Query 3: Invoice Query with Calculated Fields / 5 Report Design – Invoice Report / 5 Part a subtotal 0 / 40 Part B Index and Documentation Worksheets / 5 Data Input Worksheet / 5 Calculations Worksheet / 5 Report Worksheet – Cell References and Range Names / 2 Report Worksheet – VLOOKUP Functions / 5 Report Worksheet – IF Functions (Cost Price AU) / 5 Report Worksheet – IF Functions (Selling Price) / 5 Report Worksheet – IF/AND Function (Discount) / 5 Report Worksheet – IF Functions (Freight Cost) / 5 Report Worksheet – Purchases, Sales and Order Discount Formulas / 3 Scenario Manager Development & Output / 5 Part B subtotal 0 / 50 Part C Analytical Essay 0 / 10 Part C subtotal 0 / 10 Final Mark 0 / 100 Note: Major Academic Misconduct will incur loss of all marks for the assignment and may lead to failure of the course. Students usually perform well in the assignment but a satisfactory performance in the exam is also required for students to pass this course. Assignment ONE part a ASSIGNMENT 1 PART a: Task 1 Demonstrate Problem Solving Skills by creating a Database and import the four (4) Text files into four (4) Tables · Database correctly created. · Four Database Tables correctly imported. Database – creation: Logical development of database as per instructions. 2 1 0 Pass: Fail: Not Submitted: Satisfactorily meets the criteria for creation of Database. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Database Creation: ______________________________________________________________________________ ______________________________________________________________________________ Database tables – text file Import: Logical development of database tables through the use of the Text file Import tool. 2 1 0 Pass: Fail: Not Submitted: Satisfactorily meets the criteria for development of Tables. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Database Tables Import from Text files: ______________________________________________________________________________ ______________________________________________________________________________ ASSIGNMENT 1 PART a:Task 2 Demonstrate Problem Solving Skills by modifying the four imported tables’ structures using the given table specifications in Microsoft Access using Table Design View. · Data fields have the appropriate data type. · Data fields have appropriate Field Description to describe the data field. · Data fields have appropriately set properties. Table Design – setting appropriate Data types: Logical development of appropriate data types for all data fields in the four database tables. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An outstanding attempt – logically developed table fields using appropriate data types. An excellent piece of work that meets all the specified criteria. More than competently meets the criteria specified with only minor mistakes or omissions. Competently meets the criteria as specified with few minor mistakes or omissions. Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Database Table Field Data Types: ______________________________________________________________________________ ______________________________________________________________________________ Table Design – setting appropriate field Descriptions & properties: Logical development of appropriate field descriptions and properties for all data fields in the four database tables. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An outstanding attempt – logically developed table fields descriptions. An excellent piece of work that meets all the specified criteria. More than competently meets the criteria specified with only minor mistakes or omissions. Competently meets the criteria as specified with few minor mistakes or omissions. Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Database Table Field Descriptions and Properties: ______________________________________________________________________________ ______________________________________________________________________________ ASSIGNMENT 1 PART a: Task 3 Table Design – Primary Keys: Logical development of database tables primary keys. 2 1 0 Pass: Fail: Not Submitted: Satisfactorily meets the criteria with minor issues. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Database Tables Primary Key(s) Development: ______________________________________________________________________________ ______________________________________________________________________________ ASSIGNMENT 1 PART a: Task 4 Table Relationships: Demonstrate Problem Solving Skills by the logical development of the relationships between the four (4) tables. 3 2 1 0 Outstanding: Pass: Fail: Not Submitted: Competently meets the criteria for development of the relationships between each table. Satisfactorily meets the criteria with minor issues. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Database Tables Relationship Development: ______________________________________________________________________________ ______________________________________________________________________________ Assignment PART A: Task 5 Edit Customers table: Demonstrate understanding of Database structure by editing the Customer Table Data details for Customer ID 112. 2 1 0 Pass: Fail: Not Submitted: Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your editing of Customer Table Data: ______________________________________________________________________________ ______________________________________________________________________________ ASSIGNMENT 1 PART a: Task 6 Demonstrate Problem Solving Skills by the creation the following THREE (3) queries using the Query Design View: · Query 1: Import Duty Belgium (BE) Increase · Query 2: Late Dispatched Orders Form Query · Query 3: Invoice Query with Calculated Fields Query Design – Query 1: Import Duty Belgium (BE) Cost Price Increase: Logical development of the Import Duty Belgium (BE) Increase. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An outstanding attempt – logically developed Query. An excellent piece of work that meets all the specified criteria. More than competently meets the criteria specified with only minor mistakes or omissions. Competently meets the criteria as specified with few minor mistakes or omissions. Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Import Duty Import Duty Belgium (BE) Increase Update Query: ______________________________________________________________________________ ______________________________________________________________________________ Query Design – QUERY 2: Late Dispatched Orders Form Query: Logical development of the Late Dispatched Orders Form Query. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An Outstanding attempt – logically developed Query. An excellent piece of work that meets all the specified criteria. More than competently meets the criteria specified with only minor mistakes or omissions. Competently meets the criteria as specified with few minor mistakes or omissions. Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Late Dispatched Orders Form Select Query: ______________________________________________________________________________ ______________________________________________________________________________ Query Design – Query 3: Invoice Query with Calculated Fields: Logical development of the Invoice Query with Calculated Fields Select Query. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An outstanding attempt – logically developed Query. An excellent piece of work that meets all the specified criteria. More than competently meets the criteria specified with only minor mistakes or omissions. Competently meets the criteria as specified with few minor mistakes or omissions. Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Invoice Query with Calculated Fields Select Query: ______________________________________________________________________________ ______________________________________________________________________________ ASSIGNMENT 1 PART a: Task 7 Report Design – Invoice Report: Demonstrate Problem Solving Skills by the logical development of the Invoice Report using Report Wizard and Design View. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An Outstanding attempt – logically developed Form with calculated field. An excellent piece of work that meets all the specified criteria. More than competently meets the criteria specified with only minor mistakes or omissions. Competently meets the criteria as specified with few minor mistakes or omissions. Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable. Issues detected about your Invoice Report: ______________________________________________________________________________ ______________________________________________________________________________ Assignment ONE part B ASSIGNMENT 1 PART B: Task 3 & 19 Develop the Index Worksheet as per Task 3 and the Documentation Worksheet, including all formulas and functions as per Task 19. Index and documentation Worksheets Demonstrate written communication skills by creating an Index and Documentation Worksheets; ensuring that they contain all the recommended data for this worksheet listed in the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An outstanding attempt – well developed containing all elements required for this worksheet. An excellent piece of work that meets all the specified criteria. More than competently meets the criteria specified with only minor mistakes or omissions. Competently meets the criteria as specified with few minor mistakes or omissions. Satisfactorily meets the criteria. Did not sufficiently meet the criteria to pass. No attempt made or diverse from what is acceptable Issues detected about your Index and Documentation Worksheet Development: ______________________________________________________________________________ ______________________________________________________________________________ ASSIGNMENT 1 PART B: Task 4, 10, 16 & 18 Develop the Data Input Worksheet as per Tasks 4, 10, 16 & 18. Data Input Worksheet Demonstrate Problem Solving Skills by developing a Data Input worksheet; ensuring that it conforms to the guidelines for this worksheet listed in the Practical Appendixes found on the Study Schedule and Module Materials – Spreadsheet design considerations. 5 4 ½ 4 3 ½ 2 ½ 1 ½ 0 Outstanding: High Distinction: Distinction: Credit: Pass: Fail: Not Submitted: An outstanding attempt – well developed containing all elements required for this worksheet. An excellent