Spreadsheet: 736977d1623998382-solved-find-most-recent-valid-cell-and-return-its-value-example2
Sheet: Grade 5

Date | Unit No. | No. Lessons | Unit Title | Section | Pages | Notes |  |  |  |  |  |  |  | Month | Date | Unit No. | Unit Title | No. Lessons
2021-04-22 00:00:00 |  |  | Hello, friends. | Starting Out | 3, 10-11 |  |  |  |  |  |  |  |  | April | 22 | Unit 1 | Hello, friends. | 0.125
2021-04-23 00:00:00 |  |  | Hello, friends. | Starting Out | 3, 11-12 |  |  |  |  |  |  |  |  | April | 23 | Unit 1 | Hello, friends. | 0.25
2021-04-29 00:00:00 |  |  |  |  |  | No school |  |  |  |  |  |  |  | April | 29
2021-04-30 00:00:00 |  |  | Hello, friends. | Starting Out | 10-11 |  |  |  |  |  |  |  |  | April | 30 | Unit 1 | Hello, friends. | 0.375
2021-05-06 00:00:00 |  |  | Hello, friends. | Starting Out | 10-11, 87 |  |  |  |  |  |  |  |  | May | 6 | Unit 1 | Hello, friends. | 0.5
2021-05-07 00:00:00 |  |  | Hello, friends. | Starting Out | 10-12, 87 |  |  |  |  |  |  |  |  | May | 7 | Unit 1 | Hello, friends. | 0.625
2021-05-13 00:00:00 |  |  | Hello, friends. | Your Turn | 12, 87 |  |  |  |  |  |  |  |  | May | 13 | Unit 1 | Hello, friends. | 0.75
2021-05-14 00:00:00 |  |  | Hello, friends. | Your Turn | 13 |  |  |  |  |  |  |  |  | May | 14 | Unit 1 | Hello, friends. | 0.875
2021-05-20 00:00:00 |  |  | Hello, friends. | Enjoy Communication! | 14 |  |  |  |  |  |  |  |  | May | 20 | Unit 1 | Hello, friends.
2021-05-21 00:00:00 |  |  | Hello, friends. | Enjoy Communication! | 14-15 |  |  |  |  |  |  |  |  | May | 21 | Unit 1 | Hello, friends.
2021-05-27 00:00:00 |  |  | Hello, friends. | Over the Horizon | 15, 34, 16-17 |  |  |  |  |  |  |  |  | May | 27 | Unit 1 | Hello, friends.
2021-05-28 00:00:00 |  |  | Hello, friends. | Over the Horizon | 16-17 |  |  |  |  | Grade 5 |  |  |  | May | 28 | Unit 1 | Hello, friends.
2021-06-03 00:00:00 |  |  | When is your birthday? | Starting Out | 14-15 | Flashcard game, SO videos |  | April |  | Intro/Alphabet/S&L/Starting Out | 3 | - -  -- --  -- --  22-23  -- 30 |  | June | 3
2021-06-04 00:00:00 |  |  | When is your birthday? | Starting Out | 14-15 | Birthday Bingo! |  | May | Unit 1 | Hello, friends. | 8 | 6-7  13-14  20-21  27-28 |  | June | 4
2021-06-10 00:00:00 |  |  | When is your birthday? | Starting Out | 15-16, 88 | LW&T, LL1, S&L lowercase |  | June | Unit 2 | When is your birthday? | 8 | 3-4  10-11  17-18  24-25 |  | June | 10
2021-06-11 00:00:00 |  |  | When is your birthday? | Your Turn | 16 | Let's Try 2 & 3 |  | July | Unit 3 | What do you want to study? | 6 | 1-2   8-9   15-16  -- --  -- -- |  | June | 11
2021-06-17 00:00:00 |  |  | When is your birthday? | Your Turn | 14-17, 88 | Unit vocab review; S&L lowercase; writing names and sentences |  | August |  | Check Your Steps 1 |  | - -  -- --  -- --  -- -- |  | June | 17
2021-06-18 00:00:00 |  |  | When is your birthday? | Your Turn | 17, 88 | Let's Listen 2, Let's Try 3 & 4 |  | September | Unit 4 | He can bake bread well. | 8 | 2-3   9-10  16-17  -- 24  30 |  | June | 18
2021-06-24 00:00:00 |  |  | When is your birthday? | Enjoy Communication! | 17-18 | Dates of holidays; sing happy birthday; make a birthday card |  | October | Unit 5 | Where is the post office? | 9 | 1   7-8   14-15  21-22  28-29 |  | June | 24
2021-06-25 00:00:00 |  |  | When is your birthday? | Enjoy Communication! | 18-19 | What do you want for Christmas? Sing happy birthday; exchange birthday cards |  | November | Unit 6 | What would you like? | 8 | 4-5  11-12  18-19  25-26 |  | June | 25
2021-07-01 00:00:00 |  |  | When is your birthday? | Over the Horizon | 20-21 | Holidays around the world; difference between [NAME] and English; Video |  | December |  | Check Your Steps 2 | 6 | 2-3   9-10  16-17  -- --  -- -- |  | July | 1
2021-07-02 00:00:00 |  |  | What do you want to study? | Starting Out |  |  |  | Jan-Feb | Unit 7 | Welcome to Japan. | 6 | - -  13-14  20-21  27-28 |  | July | 2
2021-07-08 00:00:00 |  |  | What do you want to study? | Starting Out |  |  |  | Feb-Mar | Unit 8 | Who is your hero? | 7 | 3-4  10 --  17-18  24-25 |  | July | 8
2021-07-09 00:00:00 |  |  | What do you want to study? | Starting Out |  |  |  | March |  | Check Your Steps 3 | 5 | 3 -  10-11  17-18  -- --  -- -- |  | July | 9
2021-07-15 00:00:00 |  |  | What do you want to study? | Your Turn |  |  |  |  |  |  |  |  |  | July | 15
2021-07-16 00:00:00 |  |  | What do you want to study? | Your Turn |  |  |  |  |  |  |  |  |  | July | 16
2021-09-02 00:00:00 |  |  | What do you want to study? | Your Turn |  |  |  |  |  |  |  |  |  | September | 2
2021-09-03 00:00:00 |  |  | What do you want to study? | Enjoy Communication! |  |  |  |  |  |  |  |  |  | September | 3
2021-09-09 00:00:00 |  |  | What do you want to study? | Enjoy Communication! |  |  |  |  |  |  |  |  |  | September | 9
2021-09-10 00:00:00 |  |  | What do you want to study? | Over the Horizon |  |  |  |  |  |  |  |  |  | September | 10
2021-09-16 00:00:00 |  |  | Check Your Steps 1 |  |  |  |  |  |  |  |  |  |  | September | 16
2021-09-17 00:00:00 |  |  | He can bake bread well. | Starting Out |  |  |  |  |  |  |  |  |  | September | 17
2021-09-23 00:00:00 |  |  |  |  |  | No school |  |  |  |  |  |  |  | September | 23
2021-09-24 00:00:00 |  |  | He can bake bread well. | Starting Out |  |  |  |  |  |  |  |  |  | September | 24
2021-09-30 00:00:00 |  |  | He can bake bread well. | Your Turn |  |  |  |  |  |  |  |  |  | September | 30
2021-10-01 00:00:00 |  |  | He can bake bread well. | Your Turn |  |  |  |  |  |  |  |  |  | October | 1
2021-10-07 00:00:00 |  |  | He can bake bread well. | Enjoy Communication! |  |  |  |  |  |  |  |  |  | October | 7
2021-10-08 00:00:00 |  |  | He can bake bread well. | Enjoy Communication! |  |  |  |  |  |  |  |  |  | October | 8
2021-10-14 00:00:00 |  |  | He can bake bread well. | Over the Horizon |  |  |  |  |  |  |  |  |  | October | 14
2021-10-15 00:00:00 |  |  | He can bake bread well. | Over the Horizon |  |  |  |  |  |  |  |  |  | October | 15
2021-10-21 00:00:00 |  |  | Where is the post office? | Starting Out |  |  |  |  |  |  |  |  |  | October | 21
2021-10-22 00:00:00 |  |  | Where is the post office? | Starting Out |  |  |  |  |  |  |  |  |  | October | 22
2021-10-28 00:00:00 |  |  | Where is the post office? | Your Turn |  |  |  |  |  |  |  |  |  | October | 28
2021-10-29 00:00:00 |  |  |  |  |  | No lesson (meeting) |  |  |  |  |  |  |  | October | 29
2021-11-04 00:00:00 |  |  | Where is the post office? | Your Turn |  |  |  |  |  |  |  |  |  | November | 4
2021-11-05 00:00:00 |  |  | Where is the post office? | Enjoy Communication! |  |  |  |  |  |  |  |  |  | November | 5
2021-11-11 00:00:00 |  |  | Where is the post office? | Enjoy Communication! |  |  |  |  |  |  |  |  |  | November | 11
2021-11-12 00:00:00 |  |  | Where is the post office? | Over the Horizon |  |  |  |  |  |  |  |  |  | November | 12
2021-11-18 00:00:00 |  |  | Where is the post office? | Over the Horizon |  |  |  |  |  |  |  |  |  | November | 18
2021-11-19 00:00:00 |  |  | What would you like? | Starting Out |  |  |  |  |  |  |  |  |  | November | 19
2021-11-25 00:00:00 |  |  | What would you like? | Starting Out |  |  |  |  |  |  |  |  |  | November | 25
2021-11-26 00:00:00 |  |  | What would you like? | Your Turn |  |  |  |  |  |  |  |  |  | November | 26
2021-12-02 00:00:00 |  |  | What would you like? | Your Turn |  |  |  |  |  |  |  |  |  | December | 2
2021-12-03 00:00:00 |  |  | What would you like? | Enjoy Communication! |  |  |  |  |  |  |  |  |  | December | 3
2021-12-09 00:00:00 |  |  | What would you like? | Enjoy Communication! |  |  |  |  |  |  |  |  |  | December | 9
2021-12-10 00:00:00 |  |  | What would you like? | Over the Horizon |  |  |  |  |  |  |  |  |  | December | 10
2021-12-16 00:00:00 |  |  | What would you like? | Over the Horizon |  |  |  |  |  |  |  |  |  | December | 16
2021-12-17 00:00:00 |  |  | Check Your Steps 2 |  |  |  |  |  |  |  |  |  |  | December | 17
2022-01-13 00:00:00 |  |  | Welcome to Japan. | Starting Out |  |  |  |  |  |  |  |  |  | January | 3
2022-01-14 00:00:00 |  |  | Welcome to Japan. | Starting Out |  |  |  |  |  |  |  |  |  | January | 4
2022-01-20 00:00:00 |  |  | Welcome to Japan. | Your Turn |  |  |  |  |  |  |  |  |  | January | 10
2022-01-21 00:00:00 |  |  | Welcome to Japan. | Your Turn |  |  |  |  |  |  |  |  |  | January | 11
2022-01-27 00:00:00 |  |  | Welcome to Japan. | Enjoy Communication! |  |  |  |  |  |  |  |  |  | February | 17
2022-01-28 00:00:00 |  |  | Welcome to Japan. | Enjoy Communication! |  |  |  |  |  |  |  |  |  | February | 18
2022-02-03 00:00:00 |  |  | Welcome to Japan. | Over the Horizon |  |  |  |  |  |  |  |  |  | February | 24
2022-02-04 00:00:00 |  |  | Welcome to Japan. | Over the Horizon |  |  |  |  |  |  |  |  |  | February | 25
2022-02-10 00:00:00 |  |  | Who is your hero? | Starting Out |  |  |  |  |  |  |  |  |  | March | 3
2022-02-11 00:00:00 |  |  |  |  |  | No school |  |  |  |  |  |  |  | March | 4
2022-02-17 00:00:00 |  |  | Who is your hero? | Starting Out |  |  |  |  |  |  |  |  |  | March | 10
2022-02-18 00:00:00 |  |  | Who is your hero? | Your Turn |  |  |  |  |  |  |  |  |  | March | 11
2022-02-24 00:00:00 |  |  | Who is your hero? | Your Turn |  |  |  |  |  |  |  |  |  | March | 17
2022-02-25 00:00:00 |  |  | Who is your hero? | Enjoy Communication! |  |  |  |  |  |  |  |  |  | March | 18
2022-03-03 00:00:00 |  |  | Who is your hero? | Enjoy Communication!
2022-03-04 00:00:00 |  |  |  |  |  | No school
2022-03-10 00:00:00 |  |  | Who is your hero? | Over the Horizon
2022-03-11 00:00:00 |  |  | Who is your hero? | Over the Horizon
2022-03-17 00:00:00 |  |  | Check Your Steps 3
2022-03-18 00:00:00 |  |  | Check Your Steps 3