it takes 12 seconds to produce each dessert. Try this … A To draw a line graph showing the connection between the number of desserts and the time taken to make them 1 First find a formula that relates the time to the number of desserts. It is important to be consistent with the units used for time. Note that 12 seconds = minutes The total production time is 15 minutes plus 0.2 minutes for each dessert. Think about n For desserts the total time is given by . Can you explain this formula? 2 Use the formula to set up a spreadsheet table. n T Put headings (for number of desserts) and (for time in minutes) at the top of columns A and B. n, To use 0 as the first value of enter 0 in cell A2. Write a spreadsheet version of the formula in cell B2 to calculate the time. n. Write a spreadsheet formula in cell A3 to calculate the next value of A B C A B C n T n T 1 1 2 0 15 2 0 =15+0.2*A2 3 50 3 =A2+50 n 3 Use ‘fill down’ to complete the table as far as = 1000. The first few rows are shown below. A B C A B C n T n T 1 1 2 0 0 2 0 =15+0.2*A2 3 50 25 3 =A2+50 =15+0.2*A3 4 100 35 4 =A2+50 =15+0.2*A4 5 150 45 5 =A2+50 =15+0.2*A5 6 200 55 6 =A2+50 =15+0.2*A6 7 … ….. 7 …. …..
it takes 12 seconds to produce each dessert. Try this … A To draw a line graph showing the connection between the number of desserts and the time taken to make them 1 First find a formula that relates the time to the number of desserts. It is important to be consistent with the units used for time. Note that 12 seconds = minutes The total production time is 15 minutes plus 0.2 minutes for each dessert. Think about For n desserts the total time is given by . Can you explain this formula? 2 Use the formula to set up a spreadsheet table. Put headings n (for number of desserts) and T (for time in minutes) at the top of columns A and B. To use 0 as the first value of n, enter 0 in cell A2. Write a spreadsheet version of the formula in cell B2 to calculate the time. Write a spreadsheet formula in cell A3 to calculate the next value of n. A B C A B C 1 n T 1 n T 2 0 15 2 0 =15+0.2*A2 3 50 3 =A2+50 3 Use ‘fill down’ to complete the table as far as n = 1000. The first few rows are shown below. A B C A B C 1 n T 1 n T 2 0 0 2 0 =15+0.2*A2 3 50 25 3 =A2+50 =15+0.2*A3 4 100 35 4 =A2+50 =15+0.2*A4 5 150 45 5 =A2+50 =15+0.2*A5 6 200 55 6 =A2+50 =15+0.2*A6 7 … ….. 7 …. …..
FSMA%20Hire%20a%20coach%20student_09_04_15.docx