Warm-Up:
1. What is the general idea behind the AverageIfs function? Explain in your own words what it does. Objective: I can write multiple AverageIfs functions that tell me which teacher had the highest growth rate on paragraph writing last year. Assignment: Use data to decide who was the most effective teacher
0 Comments
Warm-Up:
1. Do you have your "Rate your Core Classes" Spreadsheet in the correct spot in Google Classroom? About 1/3 of you don't. Answer whether you had it there or not. 2. Take this ungraded quiz. Please work on it alone and do not share answers. Write your score on it here. Objective: I can write a short piece of code with correct syntax to calculate averages on one sheet I can arrange the data to make a meaningful chart Assignment: Calculate averages on one sheet and make a graph for favorite class data Warm-Up:
1. What's the mistake that you just keep making with spreadsheets? 2. Look at Written Instructions document to help you finish. Objective: I can write a short piece of code with correct syntax to calculate averages on one sheet I can arrange the data to make a meaningful chart Assignment: Calculate averages on one sheet and make a graph for favorite class data Warm-Up:
1. What does the Filter button look like? 2. Why did we split data onto multiple sheets before calculating averages? Objective: I can write a short piece of code with correct syntax to calculate averages on one sheet I can arrange the data to make a meaningful chart Assignment: Calculate averages on one sheet and make a graph for favorite class data Warm-Up:
1. What question(s) do you have about spreadsheets? Objective: I can write a multiple formulas to automatically calculate multiple averages. Assignment: Use a formula to get the total average score for four different classes Warm-Up:
1. How do you create a new sheet in Google Sheets? 2. What does the Auto Calculation button look like? 3. How do you average a big set of numbers in Google Sheets? 4. Go to Google Classroom and fill out the class survey 4 times (1 for each core class) Objective: I can write a multiple formulas to automatically calculate multiple averages. Assignment: Use a formula to get the total average score for three different people. Leaked footage from Area 51 this morningWarm-Up:
1. On a scale of 1-10, how much do you like math? (1 is not at all, 10 is a lot) 2. Why? 3. What does analyze mean in your own words? Objective: I can name the parts of a spreadsheet. I can write a simple formula to automatically calculate an average. Assignment: Navigate a spreadsheet and use the function button to calculate an average Has your information been hacked or stolen online? Find out here |
Heyo!Check here for updates on what you missed while you gone. Archives
May 2020
Categories |