BSBITU402A Develop & use complex spreadsheets Assessment 2 Assignment 2 There are two parts to this assignment, Part A and Part B. Part A is compulsory. You must complete all tasks with Part A to be considered competent in this unit. If you wish to continue and be considered for a COMPETENT CREDIT or COMPETENT DISTINCTION you must complete Part B. Portfolio Task Compulsory Weighting Minimum Marks Required to achieve Competency 8 marks 26 marks 16 marks Part A, Task 1 Part A, Task 2 Part A, Task 3 Part B, Task 1 Part B, Task 2 TOTAL Yes Yes Yes No No 10 marks 30 marks 20 marks 35 marks 5 marks 100 marks 50 marks 2 LA014027, Assessment 2 – BSBITU402A – Develop and use complex spreadsheets ©New South Wales, Department of Education and Training 2011 Version 1, March 2011 Part A: What you have to do You are required to submit a portfolio of 3 tasks that demonstrates your ability to produce a variety of complex spreadsheets.
Find the cost if Pomper Demolition Service removes 95% of the debris by evaluating the expression for x = 95. Submission Requirements: Answer all the questions included in the lab. You can submit your answers in a Microsoft Word document, or write your answers on paper and then scan and
By how many did she fall short? She fell 4 short. 23 * 5 = 115 115 - 111= 4 [pic] 6. Evaluate: (-34 - -25) ÷ 3 (-34 - -25) ÷ 3 -9 ÷ 3 -3 [pic] 7. Use sets to solve the problem: Results of a survey of fifty students indicate that 30 like red jellybeans, 29 like green jellybeans, and 17 like both red and green jelly beans.
SM*(S12-4202-04) Turn over. 4202 0 4 0 0 01 2 QUESTION 1 Answer questions on one text. (a) The History Boys Answer part (i) and either part (ii) or part (iii). You are advised to spend about 20 minutes on part (i), and about 40 minutes on part (ii) or part (iii). (i) Read the extract on the opposite page.
Y-cable 125 _____________ 22175 Vat 13% extra Practice Test Two Candidate Name _________________ INTERNATIONAL ENGLISH LANGUAGE TESTING SYSTEM LISTENING SECTION TIME: 30 MINUTES INSTRUCTIONS: You must not open the booklet until you are instructed to do so. Write your name and registration number at the top of the page. You should attempt all questions. All recordings will be played only once. Write all your answers on the test paper itself.
Then use the information in your document answers to help you write the essay. You will be graded as follows: Document/scaffolding questions 10 points Use of all documents 10 points Introduction 5 points Conclusion 5 points Essay (content & question addressed) 20 points DIRECTIONS: Using the information contained in the documents and your knowledge of social studies, answer the questions that follow each document. Your answers will help you write your essay (see TASK on front cover). 1. What was the purpose of the notice from the Imperial German Embassy?
One point will be deducted for each occurrence of poor grammar and misspelled words. Step 1 – Create the data. 1. Create a new Access table by “Importing” the work sheet “Raw Data” from the Excel Workbook, CGS1060 Final Project Data.xlsx, into Access. ( Note: you should have 97 records including column headings) 2.
Puritanism Group Projects Directions: You and your group (no more than 3 in a group) will prepare one of the following assignments and present it to the class. 1. Vocabulary – Choose 15 words from The Scarlet Letter that you think would be unfamiliar to most juniors. Make a vocabulary lesson comprised of three parts – a matching (definitions – the dictionary definition in your own words), a fill in the blank where the sentences are taken from The Scarlet Letter and a fill in the blank where the sentences deal with a modern subject. Then, create a vocabulary test – you may use whatever format you deem most effective.
Date: 11/02/2013 Descriptive Statistics Excel Worksheet Directions: Answer all problems and submit to instructor at the end of module 1 Q1 b Q2 d Q3 e Q4 b S2 = [∑X2-(∑X)2]/N 5. For the following sample of scores: 2, 6, 1, 4, 2, 2, 4, 3, 2 Mean 2.88889 Mean = Mean = 2.9 26 9 Find the mean, variance and standard deviation variance 2.36111 Variance = x 2 6 1 4 2 2 4 3 2 26 2-2.9 = -0.9 6-2.9 = 3.1 1-2.9 = -1.9 4-2.9 = 1.1 2-2.9 = -0.9 2-2.9 = -0.9 4-2.9 = 1.1 3-2.9 = 0.1 2-2.9 = -0.9 2.9 18.89 9-1 .= 2.361 0.81 9.61 3.61 1.21 0.81 0.81 1.21 0.01 0.81 18.89 standard deviation 1.53659 Square root of variance 2.361 .= 1.536 6. A sample of size 7 (n = 7) has a mean of M = 9. One of the sample scores is changed from x = 19 to x = 5. What is the value for the new sample New Sample Mean = 7 Explanation of work: When the data value is 19:mean = sum of values / # of value 9 = sum/7 sum = 7 x 9 = 63 When that data value is 5 the sum is 63-14 = 49 New mean = 49/7 = 7 7.
The mean cycle time was 10 minutes and standard deviation 2.5 minutes. What is the coefficient of variation? A None of these answers B 40% C 25% D 12.5% 5. An Individual control chart has been established with control limits of 3.245 and 3.257 with central line at 3.251. An engineer collects the following sample and plots points on the control chart: 3.255, 3,252, 3.254, 3.252, 3.253, 3.252, 3.253 A.