Assignment due by end of class at 10:30 or I fail
BCTA 406 Assignment – Tribunal Attendance BISM 101, Royce Calverley 2022, Assessment 1 Part 1 Instructions BISM 101 RNA – Assessment 2: Excel (25%) • Each student will complete Part 1. • Each student will submit one excel file that contains Part 1 • The file must be saved with the following naming convention: “Studentname.BISM.Assessment2Part1.xlsx“ This is a timed assignment and must be submitted by email to the instructor at: Royce.Calverley@humber.ca Any assignments that are not submitted by the end of class will not be accepted. Please note: • The work must be your own, do not copy from any online sources or other students ** STUDENTS MUST COMPLETE THE ASSESSMENT IN ORDER TO PASS THE COURSE. Part 1: Create a conflict check system using Microsoft Excel. Marked out of 20. 1. Use the client list below. 2. Create 2 sheets in your book. On the second sheet enter the information from the client list into the following categories if possible (First Name, Last Name, Phone Number, Applicant/Respondent, and the Name of the Court or Tribunal). Use headers, and sort the list by Applicant/Respondent first and then by Last name. 3. Make the list look attractive using boarders and colours. Remove the gridlines. And freeze the headers at the top of the page. 4. On sheet 1 create a form where the user can type in the name and/or phone number of a potential client. Have a visual response that says either Safe or Unsafe. Safe if there is no conflict and unsafe if there is a conflict. 5. Make the entry form on sheet 1 look attractive and user friendly. Including short instructions on how to use the conflict check system you have designed. 6. Rename the sheets as “Check Form” and “Client List”. Client List: mailto:Royce.Calverley@humber.ca BISM 101, Royce Calverley 2022, Assessment 1 Part 1 Instructions 1. Johan Smith came into the office on Monday and wanted to hire us to sue his tenant at Landlord and Tenant. His phone number is 416-607-8383. After a short consultation he did not hire us. 2. Tim Essen was a client for several years. We represented him on several small claims matters where his employees were suing him regarding alleged unsafe work conditions. His phone number is 474-555-6487. 3. Sofia Keironopoplis hired us to sue her neighbour for failing to maintain a backyard pool leading to damage to her yard in the amount of $5000. 4. Tina Chen is a 23-year-old woman who’s son was told that they did not qualify for special education at his elementary. We represented Ms. Chen at the Ontario Special Education Tribunal. Her phone number is 647-888-5423. 5. Jim McDowell is a contractor who did a renovation. The owners of the property were not happy with the work and sued him at the Small Claims Court. We represented Mr. McDowell. His phone number is 647-555-6271. 6. Mrs. Martine came in for a consultation after she was turned down for social benefits after being laid off due to covid. Her phone number is 555-648-8855. 7. Aafreen Ali was a client for two years. We represented her in a criminal matter where she was charged with shop lifting. Her phone number is 674-555-2541. 8. Jeong Kim owns a small grocery store. He had an issue with one of his employees stealing from him. His phone number is 665-552-8887. He decided not to proceed with the claim after an initial consultation. 9. Fred Simpson’s phone number is 225-554-8872. He is a licensed paralegal who keep up his accounting files as required by the LSO. We represented him at the Law Society Tribunal. 10. Julia Singer was fired from her job after she complained to management that she was being harassed. She hired us to represent her at the Employment Standards Board. Her phone number is 416-845-1252. Marking Rubric: Marks: 1-3 4 5 Client List There are 2 or more errors in the information. There are one or two small errors in the information. All the information as been correctly entered into the client list. Formulas and calculations are correct There are significant issues with the formulas There are some small issues with the formulas. | All of the formulas are correct and meet the requirements of the assessment. Design and appearance. The student has not taken advantage of the opportunity to improve the design or appearance. The conflict cheque system does not take advantage of the options in excel. The conflict cheque system is attractive and easy to use. Formatting Requirements. 2 or more formatting requirements have not been met. One formatting requirements have not been met. All of the formatting requirements have been met. BISM 101, Royce Calverley 2022, Assessment 1 Part 1 Instructions BCTA 406 Assignment – Tribunal Attendance BISM 101, Royce Calverley 2022, Assessment 1 Part 2 Instructions BISM 101 RNA – Assessment 2: Excel (25%) • Each student will complete Part 2. • Each student will submit one excel file that contains Part 2. • The file must be saved with the following naming convention: “Studentname.BISM.Assessment2Part2.xlsx “ This is a timed assignment and must be submitted by email to the instructor at: Royce.Calverley@humber.ca Any assignments that are not submitted by the end of class will not be accepted. Please note: • The work must be your own, do not copy from any online sources or other students ** STUDENTS MUST COMPLETE THE ASSESSMENT IN ORDER TO PASS THE COURSE. Part 2: Draft an Invoice for Julian Singer. Marked out of 20. 1. Using the information provided in the scenario below create an invoice billing Julian for services rendered. 2. Julian’s address is 2344 Yonge Street, North York, Unit 1103. 3. The invoice should include a detailed breakdown of the work done, including total owed both with and without tax (at the Ontario rate). 4. The invoice must be automated so when you enter the hours it automatically calculates the totals using the information provided below and is easy to use by anyone even if they did not create the invoice. (Use the L and P method shown in class and adapted for this scenario). 5. The invoice should be well designed, attractive, and include a picture. 6. The invoice must include the name and address of your law firm. 7. Rename the sheet as “Invoice” Scenario: We represented Julian for 5 months culminating with a successful hearing at the Employment Standards Board. The case was handled by a senior lawyer who spent 4 hours on the case. She asked a paralegal to do the research and it took the paralegal 2.5 hours. In addition, she asked a law clerk to fill out the court forms for one hour. The firm hourly rates are $350 for lawyer time, $150 for paralegal time, and $75 for law clerk time. mailto:Royce.Calverley@humber.ca BISM 101, Royce Calverley 2022, Assessment 1 Part 2 Instructions Marking Rubric: Marks: 1-3 4 5 Invoice formulas and automation. Invoice is not correctly automated. Invoice contains one or more automation mistakes. Invoice is logically automated. Scenario Information. Significant necessary information is missing. Some necessary information is missing. All of the necessary information from the scenario has been included. Appearance Invoice is difficult to understand or not attractive. Invoice did not take advantage of options provided by excel. Invoice is attractive and easy to understand. Formatting Requirements Two or more formatting requirements have not been met. One formatting requirement has not been met. All of the formatting requirements have been met. *Additional marks may be removed for failure to complete the assignment or follow the assignment instructions.