ITIS 1P98 Assignment2
Assignment 2
INSTRUCTIONS
You must complete this assignment in a group of three of four students from the same lecture section. Any deviation from this group requirement will be penalized 20% unless you have prior approval from the instructor.
Create a new Word document. On the title page of the Word document file, put the names and student numbers of all of your team members.
Open a new Excel Workbook and create a Worksheet for each of questions 1-5. The teaching assistant/marker should be able to easily find the answers for each question on its Worksheet. Provide a summary of your answers to all of these questions in the Word document. Question 6 should be answered in your Word document only. For question 7, create a new database in MS Access and summarize your answers in the Word document.
Select one member of your team to submit the following files into Sakai (Assignment 1):
1. Submit the MSWord file with all of the answers to the questions in sentence format.
2. Submit the Excel file that shows your calculations.
3. Submit the Access file with your database for question 7
All submissions must be received before 11:00 pm on Tuesday December 3, 2013. You are responsible for ensuring that the files you submit can be opened and that they contain the correct information.
Linear and Integer Programming
Question 1
Jared is a business student at Brick University. He has just finished a course in Information Technology which had a midterm exam, a final exam, assignments and class participation. He earned 82% on the midterm exam, 79% on the final exam, 94% on the assignments and 100% on participation. The instructor is letting the student choose their own weighting scheme for the final course mark, with the following restrictions:
Participation can be no more than 10% of the total course mark.
The weighting for the final exam must be at least 1.5 times the weighting for the midterm exam.
The total of the midterm and final exams must count for more
INSTRUCTIONS
You must complete this assignment in a group of three of four students from the same lecture section. Any deviation from this group requirement will be penalized 20% unless you have prior approval from the instructor.
Create a new Word document. On the title page of the Word document file, put the names and student numbers of all of your team members.
Open a new Excel Workbook and create a Worksheet for each of questions 1-5. The teaching assistant/marker should be able to easily find the answers for each question on its Worksheet. Provide a summary of your answers to all of these questions in the Word document. Question 6 should be answered in your Word document only. For question 7, create a new database in MS Access and summarize your answers in the Word document.
Select one member of your team to submit the following files into Sakai (Assignment 1):
1. Submit the MSWord file with all of the answers to the questions in sentence format.
2. Submit the Excel file that shows your calculations.
3. Submit the Access file with your database for question 7
All submissions must be received before 11:00 pm on Tuesday December 3, 2013. You are responsible for ensuring that the files you submit can be opened and that they contain the correct information.
Linear and Integer Programming
Question 1
Jared is a business student at Brick University. He has just finished a course in Information Technology which had a midterm exam, a final exam, assignments and class participation. He earned 82% on the midterm exam, 79% on the final exam, 94% on the assignments and 100% on participation. The instructor is letting the student choose their own weighting scheme for the final course mark, with the following restrictions:
Participation can be no more than 10% of the total course mark.
The weighting for the final exam must be at least 1.5 times the weighting for the midterm exam.
The total of the midterm and final exams must count for more