https://applieddigitalskills.withgoogle.com/c/middle-and-high-school/en/wage-a-sea-battle-with-google-sheets/wage-a-sea-battle-with-google-sheets/introduction-to-wage-a-sea-battle-with-google-sheets.html#
9/21/21
Objective(s):
Spreadsheet:
Mini Genius Hour Next!
9/20/21
Objective(s):
Spreadsheet:
Next - Quiz
9/17/21
Objective(s):
Spreadsheet:
9/16/21
Objective(s):
Using data to answer questions:
Grade is based on difficulty, presentation, and accuracy. (20 pts)
9/15/21
Objective(s):
First!
Using data to answer questions:
Grade is based on difficulty, presentation, and accuracy. (20 pts)
How many does 8 billion look like
9/14/21 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop. I picked questions to answer using a spreadsheet
Bell Work:
Today!
Next: Using data to answer questions:
Grade is based on difficulty, presentation, and accuracy. (20 pts)
9/13/21 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Jump on Classroom
Today!
9/10/21 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Grab a whiteboard, marker, rag - order of operation
Today!
9/9/21 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open classroom
Today!
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open classroom
Today!
DAY 9 - 9/7/21 Objective(s) - I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Today!
DAY 9 - 9/7/21 Objective(s) - I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Today!
DAY 8 - 9/2/21 Objective(s) - I can use use relevant tools in G Suite. I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success Criteria - I recreated the Google document
Bell Work: Open the project from yesterday. I created a spreadsheet using formulas to find answers to questions.
G-Suite:
DAY 7 - 9/1/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have complete my presentation.
Bell Work: Open the project from yesterday.
DAY 6 - 8/31/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open the project from yesterday.
G Suit Topics - Group Tasks:
Live presentations
DAY 5 - 8/30/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open the project from yesterday.
G Suit Topics - Group Tasks:
DAY 4 - 8/26/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open the project from yesterday.
G Suit Topics - Group Tasks:
DAY 3 - 8/25/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: How do you learn best? How would you teach a concept from computer software?
G Suit Topics - Group Tasks:
Day 2 - 8/24/21
Objective: I can start building positive relationships with fellow students.
Welcome Back!
Introductions and Team Building!
Day 1 - 8/23/21
Objective: I can start building positive relationships with fellow students.
Welcome Back!
Introductions and Team Building!
Homework
10/29-30 Objective(s) - I can use google docs to create an organized document with advanced features.
Success criteria: I replicated the PDF posted on classroom.
Bell Work: Open Drive!
Previous Assignments:
Next:
10/27/20 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open Drive!
G Suit Topics - Group Tasks:
Next
Home Work: Continue Genius Hour
10/26/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have demonstrated new skills in G Suite.
Last Week:
G Suit Topics - Group Tasks:
Home Work: Continue Genius Hour
10/26/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Spreadsheets:
G Suit Topics - Group Tasks:
Home Work: How's your Genius Hour going?
10/23/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Spreadsheets:
G Suit Topics - Group Tasks:
Home Work: How's your Genius Hour going?
10/22/20 - Objective(s) - I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success criteria: I created a spreadsheet using formulas to find answers to questions.
Bell Work: Open google docs on desktops!
Spreadsheets:
10/21/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open your presentation
G Suit Topics - Group Tasks:
10/20/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: How do you learn best? How would you teach a concept from computer software?
G Suit Topics - Group Tasks:
Or Applied Digital Skills
2019!
10/28/19
Objective(s):
Bell Work: Open your spreadsheet from yesterday
New - Grades updated! Please check them!
Spreadsheet:
10/28/19
Objective(s):
Bell Work: Open your spreadsheet from yesterday
New - Grades updated! Please check them!
Spreadsheet:
10/25/19
Objective(s):
Bell Work: Open your spreadsheet from yesterday
Reteach:
Spreadsheet:
Objective(s):
Bell Work: Open your spreadsheet from yesterday
Today - Today finish up spreadsheet, create presentation, & practice
Friday - Deliver presentation
Spreadsheet:
10/23/19
Objective(s):
Bell Work: Open Illuminate!
1. Midterm - Wednesday (digital citizenship, spreadsheets, 1 or 2 google drive questions)
2. Please turn in:
3. Using data to answer questions:
10/22/19 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop. I picked questions
Bell Work: Get here!
Finish from yesterday Bill's Bikes?
Grade is based on difficulty, presentation, and accuracy. (20 pts)
Midterm - Wednesday (digital citizenship, spreadsheets, 1 or 2 google drive questions)
10/21/19 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop.
Bell Work: Grab a whiteboard with a partner
Last Week
Midterm - Wednesday (digital citizenship, spreadsheets, 1 or 2 google drive questions)
10/18/19 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop.
Bell Work: Get to my website!
Today!
10/17/19 - Objective(s) - I can use a table to do various calculations.
Success criteria: I will setup a table to calculate nutrition information.
Bell Work: Kahoot!
Today!
10/15/19 - Objective(s) - I can use a table to do various calculations.
Success criteria: I will setup a table to calculate nutrition information.
Bell Work: Open Fast Food Assignment
Today!
10/14/19 - Objective(s) - I can use a table to do various calculations.
Success criteria: I will setup a table to calculate nutrition information.
Bell Work: Open assignment from Friday
Today!
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open assignment from yesterday
Today!
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Today!
Tomorrow
Spreadsheets:
10/9/19 - Objective(s) - I can use google docs to change custom styles, drawings, links, and formatting.
I can use a table to do various calculations.
Success criteria: I can use google docs to recreate a document using styles, drawings, links, and formatting. I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Challenge Spreadsheets:
PWSTC Video!
10/8/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: Open your presentation
Reminder
G Suit Topics Challenge
PWSTC Video!
10/7/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: Open your presentation
Reminder
G Suit Topics
10/4/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: Open your presentation
G Suit Topics
Presentation Norms
Bell Work: Check PowerSchool
Test results
G Suit
Topics
Group Tasks
10/1/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: How do you learn best? How would you teach a concept from computer software?
G Suit
Topics
Group Tasks
Or Applied Digital Skills
2018
10/16/18 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Rehearse for the first 6 mins!
5th hour
Today
Grade is based on difficulty, presentation, and accuracy. (20 pts)
10/15/18 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Make sure you turn in your Bill's Bikes on classroom
From Friday:
Tuesday - Deliver presentation
Spreadsheet:
10/12/18 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Make sure you turn in your Bill's Bikes on classroom
From Thursday:
Grade is based on difficulty, presentation, and accuracy. (20 pts)
Today - question approval & create spreadsheet
Monday - create presentation & practice
Tuesday - Deliver presentation
10/11/18 - Objective(s) - I can choose the correct formula in a spreadsheet
Bell Work: Grab a whiteboard with a partner
From Tuesday:
Done?
Bell Work: Record the objective and homework for the day in google calendar
Bell Work: Kahoot!
Last week:
10/5/18 - Objective(s) - I can create a presentation that explains a current event.
Bell Work: Record the objective and homework for the day in google calendar
Today
Homework: FINISH fast food spreadsheet assignment!
10/4/18 - Objective(s) - I can create a spreadsheet that answers questions.
Bell Work: Record the objective and homework for the day in google calendar
Spreadsheets: Done?
Tomorrow
10/3/18 - Objective(s) - I can create a spreadsheet that answers questions.
Bell Work: Record the objective and homework for the day in google calendar
Digital Citizenship
10/2/18 - Objective(s) - I can create a spreadsheet that answers a question.
Bell Work:
Digital Citizenship
10/1/18 - Objective(s) - I can create a spreadsheet that answers a question.
Bell Work:
Digital Citizenship
9/11/18 Objective: Review G-Suit (Google Applications)
Bell work: Take this survey about the event planning project.
1st - Finish Google activity (10 mins)
2nd -Research project "Technology's Role in Current Events" (10 mins)
Next - Digital citizenship
9/10/18 Objective: Review G-Suit (Google Applications)
Bell work: Go to g.co/applieddigitalskills
1st - Get in groups of three
2nd - Finish Google activity
3rd - Begin research project "Technology's Role in Current Events"
9/4-7/18 Objective: Review G-Suit (Google Applications)
Bell work: Get to my website!
Day 5-8 - Continue event planning Google activity
8/30/18 Objective: Review G-Suit (Google Applications)
Bell work: Log on to desktops and get to my website.
(add "@pwschools.org" if you could not login yesterday.)
Day 4
From Yesterday
10/9/17 - Objective(s) - I can use use all the tools of G Suit
Bell Work: Open Drive
G Suit
Begin Hardware Unit
10/6/17 - Objective(s) - I can use use all the tools of G Suit
Bell Work: Open Drive
docs.google.com/document/d/1_jSbXN_SgVduTgxe-pPFEZU0AF2RjmHQojqzk9Qmq0g/edit?usp=sharing
G Suit
Begin Hardware Unit
10/5/17 - Objective(s) - I can use use all the tools of G Suit
Bell Work: Open Drive
G Suit
10/2/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Practice for the first 4 mins.
Grade is based on difficulty, presentation, and accuracy. (20 pts) Today - Deliver presentations
Next...Google Docs/Calendar...
9/30/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Practice for the first 4 mins.
Grade is based on difficulty, presentation, and accuracy. (20 pts) Today - Deliver presentations
9/29/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Practice for the first 4 mins.
Grade is based on difficulty, presentation, and accuracy. (20 pts) Today - Deliver presentations
9/28/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes and any other missing assignments
Using data to answer questions:
Tomorrow - Deliver presentation
9/27/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes and any other missing assingment
Using data to answer questions:
Today - question approval & create spreadsheet
Tomorrow - create presentation & practice
Friday - Deliver presentation
9/26/17 - Objective(s) - I can choose the correct formula in a spreadsheet. I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes
Finish Bill's Bikes (15 mins)
Partner Presentation
Using data to answer questions- You will create a spreadsheet that answers 1 central question, with 2+ follow up questions. You will need to present your findings after completing the spreadsheet. (20 pts)
9/25/17 - Objective(s) - I can choose the correct formula in a spreadsheet. I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes
Finish Bill's Bikes
Partner Presentation
Using data to answer questions- You will create a spreadsheet that answers 1 central question, with 2+ follow up questions. You will need to present your findings after completing the spreadsheet. (20 pts)
9/22/17 - Objective(s) - I can choose the correct formula in a spreadsheet
Bell Work: Kahoot!
Spreadsheets:
9/21/17 - Objective(s) - I can choose the correct formula in a spreadsheet
Bell Work: Open both greenbacks and fast food
Spreadsheets:
Done?
9/20/17 - Objective(s) - I can create an "IF" statements in Google Sheets.
Bell Work: Open fast food assignment
Test - 6th grade results
New Phishing Email - want to see?
Spreadsheets:
9/19/17 - Objective(s) - I can create a spreadsheet that answers a question.
Bell Work:
Digital Citizenship
9/21/21
Objective(s):
- I can use the correct functions to find values to story problems.
- Present a spreadsheet that answers 3 original questions.
- I did my best on the quiz today
Spreadsheet:
- Finish Presentations
Mini Genius Hour Next!
9/20/21
Objective(s):
- I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
- Present a spreadsheet that answers 3 original questions.
Spreadsheet:
- Present your findings today.
Next - Quiz
- Conditional formatting
- Functions such as: max, min, sum, average
- Order of operation
- How to read the table
9/17/21
Objective(s):
- I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
- Create a spreadsheet that answers 3 original questions.
Spreadsheet:
- Finish up spreadsheet and presentation
- Presentation volunteers
- Finish over the weekend to present on Monday
9/16/21
Objective(s):
- I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
- Create a spreadsheet that answers 3 original questions.
Using data to answer questions:
- You will create a spreadsheet that answers 1 central question
- Then answer 2+ follow up questions that is related. I encourage you to do something that measures something different (distance, area, time, calories, money)
- You will need to present your findings after completing the spreadsheet
Grade is based on difficulty, presentation, and accuracy. (20 pts)
9/15/21
Objective(s):
- I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
- Create a spreadsheet that answers 3 original questions.
First!
- Turn in Bill's Bikes
Using data to answer questions:
- You will create a spreadsheet that answers 1 central question
- Then answer 2+ follow up questions
- You will need to present your findings after completing the spreadsheet
- Part?
Grade is based on difficulty, presentation, and accuracy. (20 pts)
How many does 8 billion look like
9/14/21 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop. I picked questions to answer using a spreadsheet
Bell Work:
Today!
- Finish Bill's Bikes
- Help others across the finish line!
or - Self Test (3 pts E.C.)
- Help others across the finish line!
Next: Using data to answer questions:
- You will create a spreadsheet that answers 1 central question
- Then answer 2+ follow up questions
- You will need to present your findings after completing the spreadsheet
Grade is based on difficulty, presentation, and accuracy. (20 pts)
- Example Spreadsheet & Presentation
- Pick an idea!
9/13/21 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Jump on Classroom
Today!
- Kahoot!
- Begin Bill's Bikes
9/10/21 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Grab a whiteboard, marker, rag - order of operation
Today!
- Turn in Fast Food & Calories
- Complete practice quiz worksheet
- yourself
- partner
- group
9/9/21 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open classroom
Today!
- Continue Fast Food & Calories - Starter Spreadsheet
- Stuck? use video help
- Optional Self Test - (Create in excel for 3 EXTRA CREDIT pts)
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open classroom
Today!
- Begin Fast Food & Calories - Starter Spreadsheet
- Optional Self Test - (Create in excel for 3 EXTRA CREDIT pts)
DAY 9 - 9/7/21 Objective(s) - I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Today!
- Finish the document challenge
- Begin Greenbacks Assignment
DAY 9 - 9/7/21 Objective(s) - I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Today!
- Finish the document challenge
- Begin Greenbacks Assignment
DAY 8 - 9/2/21 Objective(s) - I can use use relevant tools in G Suite. I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success Criteria - I recreated the Google document
Bell Work: Open the project from yesterday. I created a spreadsheet using formulas to find answers to questions.
G-Suite:
- View Google Drawings
- Complete the Recreate Challenge
- Spreadsheet Basics
- Create 2 sets of intersecting data points
- Answer one or more questions
- Partners?
- Begin Greenbacks Assignment
DAY 7 - 9/1/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have complete my presentation.
Bell Work: Open the project from yesterday.
DAY 6 - 8/31/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open the project from yesterday.
G Suit Topics - Group Tasks:
Live presentations
- Please be genuine with your questions
- Please follow ALL instructions from classmates
- Two grades - one for your presentation (5 pts) and one for classroom participation (5 pts)
DAY 5 - 8/30/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open the project from yesterday.
G Suit Topics - Group Tasks:
- Finish your presentation (20 mins)
- If you have a file for the class to use please upload Here
- 1 Person in the group turn in on Classroom
- Why learn G suite (Google Drive and Apps)
- Please be genuine with your questions/ struggles
- Please follow ALL instructions from classmates
- Two grades - one for your presentation (5 pts) and one for classroom participation (5 pts)
DAY 4 - 8/26/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open the project from yesterday.
G Suit Topics - Group Tasks:
- Finish your presentation
- Screenshots, pictures, and bullet points
- Demonstration features
- Create an activity for students to work with the features - Example - Example 2
- Move Files Here
- Make a Folder for your group
- Move all the files (Presentation/Activity/Examples)
DAY 3 - 8/25/21 Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: How do you learn best? How would you teach a concept from computer software?
G Suit Topics - Group Tasks:
- Watch video OR google your topic
- Make a list of everything that will be covered!
- Divide the workload evenly
- Create a presentation
- Screenshots, pictures, and bullet points
- Demonstration features
- Create an activity for students to work with the features - Example - Example 2
- Move Files Here
- Make a Folder for your group
- Move all the files (Presentation/Activity/Examples)
Day 2 - 8/24/21
Objective: I can start building positive relationships with fellow students.
Welcome Back!
Introductions and Team Building!
- 2 Truths and one lie - then ask me a question
- Little more about me
- Teacher and Student Expectation
- Add Classroom
- 1st - lusz5uw
- 3rd - ztepxl3
- 5th - pu2i7qg
- Read the Syllabus
- Weebly is for me - classroom is for you
- You will need earbuds next week!
Day 1 - 8/23/21
Objective: I can start building positive relationships with fellow students.
Welcome Back!
Introductions and Team Building!
- Competitive Sorting
- Seating Chart
- Getting to know each other
- Little more about me
- Teacher and Student Expectation
- Add Classroom
- 1st - lusz5uw
- 3rd - ztepxl3
- 5th - pu2i7qg
- Read the Syllabus
- Weebly is for me - classroom is for you
Homework
- You will need earbuds next week!
10/29-30 Objective(s) - I can use google docs to create an organized document with advanced features.
Success criteria: I replicated the PDF posted on classroom.
Bell Work: Open Drive!
Previous Assignments:
- Greenbacks Spreadsheet (Due Thursday)
- Google Drawing (Due Thursday)
- Challenge Document (Due Friday)
Next:
10/27/20 - Objective(s) - I can use a table to do various calculations.
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open Drive!
G Suit Topics - Group Tasks:
- Finish Presentations
- Group 9 (me) - Create drawing on Classroom
- Complete the "Challenge" on Classroom
- Finish Greenbacks assignment
Next
- How to set up a table
- Begin Fast Food & Calories
Home Work: Continue Genius Hour
10/26/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have demonstrated new skills in G Suite.
Last Week:
- Finish the spreadsheet greenbacks
- Grades updated!
G Suit Topics - Group Tasks:
Home Work: Continue Genius Hour
10/26/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Spreadsheets:
- How did the Greenbacks Assignment go? How about the Challenge?
G Suit Topics - Group Tasks:
Home Work: How's your Genius Hour going?
10/23/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Spreadsheets:
- How did the Greenbacks Assignment go? How about the Challenge?
G Suit Topics - Group Tasks:
Home Work: How's your Genius Hour going?
10/22/20 - Objective(s) - I can use a spreadsheet to do various calculations and present it in a visually attractive way.
Success criteria: I created a spreadsheet using formulas to find answers to questions.
Bell Work: Open google docs on desktops!
Spreadsheets:
- Begin Greenbacks Assignment
10/21/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: Open your presentation
G Suit Topics - Group Tasks:
- Watch video OR google your topic
- Make a list of everything that will be covered!
- Divide the workload evenly
- Create a presentation
- Move Files Here
- Make a Folder for your group
- Move all the files (Presentation/Activity/Examples)
10/20/20 - Objective(s) - I can use use all the tools in G Suite.
Success Criteria - I have worked within a group to create a presentation for my assigned topic
Bell Work: How do you learn best? How would you teach a concept from computer software?
G Suit Topics - Group Tasks:
- Watch video OR google your topic
- Make a list of everything that will be covered!
- Divide the workload evenly
- Create a presentation
- Screenshots, pictures, and bullet points
- Demonstration features
- Create an activity for students to work with the features
Or Applied Digital Skills
2019!
10/28/19
Objective(s):
- Present data in a spreadsheets
- I can deliver my presentation in a clear and effective way.
Bell Work: Open your spreadsheet from yesterday
New - Grades updated! Please check them!
Spreadsheet:
- Turn your slides and spreadsheet into classroom
- Volunteers first!
- What does your progress look like?
- Take pictures and video (you will want them for your presentation)
10/28/19
Objective(s):
- Present data in a spreadsheets
- I can deliver my presentation in a clear and effective way.
Bell Work: Open your spreadsheet from yesterday
New - Grades updated! Please check them!
Spreadsheet:
- Turn your slides and spreadsheet into classroom
- Volunteers first!
- What does your progress look like?
- Take pictures and video (you will want them for your presentation)
10/25/19
Objective(s):
- Find gaps in learning
- Present data in a spreadsheets
- I can identify my performance on the last test and clarify what misconceptions I had.
- I can deliver my presentation in a clear and effective way.
Bell Work: Open your spreadsheet from yesterday
Reteach:
- Grab a whiteboard
- Write down why each answer is correct or incorrect.
- Share out
Spreadsheet:
- Turn your slides and spreadsheet into classroom
- Volunteers first!
Objective(s):
- I can follow directions on setting up an appropriate spreadsheet.
- I can use the correct functions to find values to story problems.
- Create a spreadsheet that answers 3 original questions.
- Create a presentation that illustrate your results.
Bell Work: Open your spreadsheet from yesterday
Today - Today finish up spreadsheet, create presentation, & practice
Friday - Deliver presentation
Spreadsheet:
- Remember 1 central question, then 2 follow up questions
- You will need to present your findings after completing the spreadsheet
- Presentation should include screenshots of your data.
- Use descriptive labels
- Include images
10/23/19
Objective(s):
- I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
- Create a spreadsheet that answers 3 original questions.
Bell Work: Open Illuminate!
1. Midterm - Wednesday (digital citizenship, spreadsheets, 1 or 2 google drive questions)
2. Please turn in:
3. Using data to answer questions:
- Grade is based on difficulty, presentation, and accuracy. (20 pts)
- Example Spreadsheet & Presentation
- Work on it in class today and then create a presentation to present your results!
10/22/19 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop. I picked questions
Bell Work: Get here!
Finish from yesterday Bill's Bikes?
- Need Help? - Example Starter Spreadsheet
- Self Test (3 pts E.C.)
- You will create a spreadsheet that answers 1 central question
- Then answer 2+ follow up questions
- You will need to present your findings after completing the spreadsheet
Grade is based on difficulty, presentation, and accuracy. (20 pts)
- Example Spreadsheet & Presentation
- Pick an idea!
Midterm - Wednesday (digital citizenship, spreadsheets, 1 or 2 google drive questions)
10/21/19 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop.
Bell Work: Grab a whiteboard with a partner
Last Week
- Turned in Fast Food & Calories on classroom (a few turned in Self Test - (3 E.C. pts))
- Stuck? use video help
- Began Bill's Bikes
- Continue/Finish Bill's Bikes
- Need Help? - Example Starter Spreadsheet
- No talking for the first 20 mins.
- Begin Self Test (3 pts E.C.)
Midterm - Wednesday (digital citizenship, spreadsheets, 1 or 2 google drive questions)
10/18/19 - Objective(s) - I can follow directions on setting up an appropriate spreadsheet. I can use the correct functions to find values to story problems.
Success criteria: I will setup a spreadsheet to calculate the profitability of a bike shop.
Bell Work: Get to my website!
Today!
- Wrap up practice quiz worksheet
- yourself
- partner
- group
- Turn in Fast Food & Calories on classroom
- Stuck? use video help
- Show me Self Test - (3 E.C. pts)
- Begin Bill's Bikes
10/17/19 - Objective(s) - I can use a table to do various calculations.
Success criteria: I will setup a table to calculate nutrition information.
Bell Work: Kahoot!
Today!
- Turn in Fast Food & Calories on classroom
- Upload to google drive if you created it in excel
- Did the video help?
- Show me Self Test - (3 E.C. pts)
- Complete practice quiz worksheet
- yourself
- partner
- group
- Begin Bill's Bikes
10/15/19 - Objective(s) - I can use a table to do various calculations.
Success criteria: I will setup a table to calculate nutrition information.
Bell Work: Open Fast Food Assignment
Today!
- Finish Fast Food & Calories
- Optional Self Test - (Create in excel for 3 EXTRA CREDIT pts)
10/14/19 - Objective(s) - I can use a table to do various calculations.
Success criteria: I will setup a table to calculate nutrition information.
Bell Work: Open assignment from Friday
Today!
- Show me Greenbacks Assignment
- Save for now (I'll check it Today)
- Finish Fast Food & Calories
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open assignment from yesterday
Today!
- Finish Greenbacks Assignment
- Save for now (I'll check it Monday)
- Begin Fast Food & Calories
- Optional Self Test - (Create in excel for 3 EXTRA CREDIT pts)
Success criteria: I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Today!
- Finish Recreate this! challenge
- Begin Greenbacks Assignment
Tomorrow
Spreadsheets:
- Finish Greenbacks Assignment
- Begin Fast Food & Calories
10/9/19 - Objective(s) - I can use google docs to change custom styles, drawings, links, and formatting.
I can use a table to do various calculations.
Success criteria: I can use google docs to recreate a document using styles, drawings, links, and formatting. I can use formulas to find answers to questions using a spreadsheet.
Bell Work: Open google docs on desktops!
Challenge Spreadsheets:
- Begin Greenbacks Assignment
Tutorial and Answers!
PWSTC Video!
10/8/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: Open your presentation
Reminder
- Why learn G suite (Google Drive and Apps)
- Please be genuine with your questions/ struggles
- Please follow ALL instructions from classmates
- Two grades - one for your presentation (10 pts) and one for classroom participation (10 pts)
G Suit Topics Challenge
- Make a diagram in slides, publish as a website, then...
- Recreate this!
- Spreadsheets!
PWSTC Video!
10/7/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: Open your presentation
Reminder
- Why learn G suite (Google Drive and Apps)
- Please be genuine with your questions/ struggles
- Please follow ALL instructions from classmates
- Two grades - one for your presentation (10 pts) and one for classroom participation (10 pts)
G Suit Topics
10/4/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: Open your presentation
G Suit Topics
Presentation Norms
- Golden Rule
- Please follow ALL instructions from classmates
Bell Work: Check PowerSchool
Test results
G Suit
Topics
Group Tasks
- Watch video OR google your topic
- Make a list of everything that will be covered!
- Divide the workload evenly
- Create a presentation
- Screenshots, pictures, and bullet points
- Demonstration features
- Create an activity for students to work with the features
- Move Files Here
10/1/19 - Objective(s) - I can use use all the tools in G Suite
Bell Work: How do you learn best? How would you teach a concept from computer software?
G Suit
Topics
Group Tasks
- Watch video OR google your topic
- Make a list of everything that will be covered!
- Divide the workload evenly
- Create a presentation
- Screenshots, pictures, and bullet points
- Demonstration features
- Create an activity for students to work with the features
Or Applied Digital Skills
2018
10/16/18 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Rehearse for the first 6 mins!
5th hour
Today
- Turn in presentation AND spreadsheet in classroom
- Deliver presentation!
Grade is based on difficulty, presentation, and accuracy. (20 pts)
- Example Spreadsheet & Presentation
- Pick an idea!
10/15/18 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Make sure you turn in your Bill's Bikes on classroom
From Friday:
- Email me with missing assignments!
Tuesday - Deliver presentation
Spreadsheet:
- Remember 1 central question, then 2 follow up questions
- You will need to present your findings after completing the spreadsheet
- Presentation should include screenshots of your data.
- Use descriptive labels
- Include images
- Example Spreadsheet & Presentation
- Pick an idea!
10/12/18 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Make sure you turn in your Bill's Bikes on classroom
From Thursday:
- Email me with missing assignments!
- You will create a spreadsheet that answers 1 central question
- Then answer 2+ follow up questions
- You will need to present your findings after completing the spreadsheet
Grade is based on difficulty, presentation, and accuracy. (20 pts)
- Example Spreadsheet & Presentation
- Pick an idea!
Today - question approval & create spreadsheet
Monday - create presentation & practice
Tuesday - Deliver presentation
10/11/18 - Objective(s) - I can choose the correct formula in a spreadsheet
Bell Work: Grab a whiteboard with a partner
From Tuesday:
- Still need to see a few Fast Food & Calories
- Still no talking
- Music is allowed today
- Finish Bill's Bikes
- Need Help?
- Talk to me
Done?
- Begin Self Test (2 pts E.C.)
- Done - 3d Sculpting - Easy Modeling
Bell Work: Record the objective and homework for the day in google calendar
Bell Work: Kahoot!
Last week:
- Show me Fast Food & Calories & Greenbacks Assignment
- Grades updated (please check powerschool and email me with questions)
- Spreadsheet practice quiz worksheet
- Begin Bill's Bikes
- Need Help?
10/5/18 - Objective(s) - I can create a presentation that explains a current event.
Bell Work: Record the objective and homework for the day in google calendar
Today
- Work on your current event issue - create presentation
- This is the last time working in class on it.
- Review your project as a team and pick the slides, pages, or topics you will talk about.
- Please label each slide with who was in charge of it.
- Please use relevant images that clearly help us understand the subject.
- Please practice giving the presentation if you finish.
Homework: FINISH fast food spreadsheet assignment!
10/4/18 - Objective(s) - I can create a spreadsheet that answers questions.
Bell Work: Record the objective and homework for the day in google calendar
Spreadsheets: Done?
- Show me Greenbacks Assignment
- Show me Fast Food & Calories
- Begin Self Test (2 pts E.C.)
- Done - 3d Sculpting - Easy Modeling
Tomorrow
- Feel proud that you are teaching your peers something new and important.
- Work on your current event issue - create presentation or google sites
- This is the last time working in class on it.
- Review your project as a team and pick the slides, pages, or topics you will talk about.
- Please label each slide with who was in charge of it.
- We will practice the presentation next week.
10/3/18 - Objective(s) - I can create a spreadsheet that answers questions.
Bell Work: Record the objective and homework for the day in google calendar
Digital Citizenship
- Test review
- 2nd hour - "Humans need not apply"
- Show me Greenbacks Assignment
- Show me Fast Food & Calories
- Begin Self Test (2 pts E.C.)
- Work on your current event issue - create presentation on Friday
- Done - 3d Sculpting - Easy Modeling
10/2/18 - Objective(s) - I can create a spreadsheet that answers a question.
Bell Work:
Digital Citizenship
- Test review
- Finish Greenbacks Assignment
Tutorial and Answers! - Begin Fast Food & Calories
10/1/18 - Objective(s) - I can create a spreadsheet that answers a question.
Bell Work:
Digital Citizenship
- Come at lunch to make up test.
- Review low questions tomorrow?
- Begin Greenbacks Assignment
Tutorial and Answers! - 10/9/17 - Objective(s) - I can use use all the tools of G Suit
Bell Work: Open Drive
G Suit - Finish presentations
- Topics
- Fast Food & Calories
9/11/18 Objective: Review G-Suit (Google Applications)
Bell work: Take this survey about the event planning project.
1st - Finish Google activity (10 mins)
- Submit three assignments to google classroom (due tonight)
2nd -Research project "Technology's Role in Current Events" (10 mins)
- Pick a topic
- Fill this out as a group
- Results - docs.google.com/document/d/1XuGd2M1OJTdWH0af-mjzSPxMj-JsYX3e6iIr0nP0j_0/edit#
Next - Digital citizenship
9/10/18 Objective: Review G-Suit (Google Applications)
Bell work: Go to g.co/applieddigitalskills
1st - Get in groups of three
2nd - Finish Google activity
- Submit three assignments to google classroom
- Everyone in your group needs to finish the event planning project (help each other!)
3rd - Begin research project "Technology's Role in Current Events"
9/4-7/18 Objective: Review G-Suit (Google Applications)
Bell work: Get to my website!
Day 5-8 - Continue event planning Google activity
- Continue Project
- By Friday get through activity 5 and get a start on activity 6.
- We will finish activity 6 and 7 on Monday
8/30/18 Objective: Review G-Suit (Google Applications)
Bell work: Log on to desktops and get to my website.
(add "@pwschools.org" if you could not login yesterday.)
Day 4
From Yesterday
- Finish a Little more about me
- Did everyone take the Pre-Test?
- Classroom
- 2nd - irajtei
- 5th - cm4z4t
- 6th - 9bn3keg
- Go to g.co/applieddigitalskills
- Click "Sign In," and sign in with your Google account
- Select "I am a student"
- Enter class code:
- 2nd Hour bb07-q4r0
- 5th v0zb-qgy3
- 6th bl8b-p4r0
- Click into the first lessons of the class on your dashboard
- Put on headphones and watch the first video
- Partner is your shoulder buddy, default group of 4
10/9/17 - Objective(s) - I can use use all the tools of G Suit
Bell Work: Open Drive
G Suit
- Finish presentations
- Topics
Begin Hardware Unit
10/6/17 - Objective(s) - I can use use all the tools of G Suit
Bell Work: Open Drive
docs.google.com/document/d/1_jSbXN_SgVduTgxe-pPFEZU0AF2RjmHQojqzk9Qmq0g/edit?usp=sharing
G Suit
- Present Today
- Topics
Begin Hardware Unit
10/5/17 - Objective(s) - I can use use all the tools of G Suit
Bell Work: Open Drive
G Suit
- Get in 7 groups
- Topics
- Present Friday
10/2/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Practice for the first 4 mins.
Grade is based on difficulty, presentation, and accuracy. (20 pts) Today - Deliver presentations
Next...Google Docs/Calendar...
9/30/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Practice for the first 4 mins.
Grade is based on difficulty, presentation, and accuracy. (20 pts) Today - Deliver presentations
9/29/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Practice for the first 4 mins.
Grade is based on difficulty, presentation, and accuracy. (20 pts) Today - Deliver presentations
9/28/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes and any other missing assignments
Using data to answer questions:
- Presentation should include screenshots of your data.
- Use descriptive labels
- Include images
- Example Spreadsheet & Presentation
- Pick an idea!
Tomorrow - Deliver presentation
9/27/17 - Objective(s) - I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes and any other missing assingment
Using data to answer questions:
- You will create a spreadsheet that answers 1 central question, with 2+ follow up questions. You will need to present your findings after completing the spreadsheet.
- Example Spreadsheet & Presentation
- Pick an idea!
Today - question approval & create spreadsheet
Tomorrow - create presentation & practice
Friday - Deliver presentation
9/26/17 - Objective(s) - I can choose the correct formula in a spreadsheet. I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes
Finish Bill's Bikes (15 mins)
- Please don't cheat!
- $25,136
- Done - think of ideas for your partner presentation and see if data is available
Partner Presentation
Using data to answer questions- You will create a spreadsheet that answers 1 central question, with 2+ follow up questions. You will need to present your findings after completing the spreadsheet. (20 pts)
- Example Spreadsheet
- Example presentation
- Write your ideas here!
- Commit to one main questions
- Collect data
- Calculate data
- Ask another question
- Repeat 2+
9/25/17 - Objective(s) - I can choose the correct formula in a spreadsheet. I can use spreadsheets to answer questions.
Bell Work: Open Bill's Bikes
Finish Bill's Bikes
- 6th hour changes
- Need Help?
- Done - think of ideas for your partner presentation and see if data is available
Partner Presentation
Using data to answer questions- You will create a spreadsheet that answers 1 central question, with 2+ follow up questions. You will need to present your findings after completing the spreadsheet. (20 pts)
- Example Spreadsheet
- Example presentation
- Write your ideas here!
- Last year's Ideas list
- Commit to one main questions
- Collect data
- Calculate data
- Ask another question
- Repeat 2+
9/22/17 - Objective(s) - I can choose the correct formula in a spreadsheet
Bell Work: Kahoot!
Spreadsheets:
- Begin Bill's Bikes
- Need Help?
9/21/17 - Objective(s) - I can choose the correct formula in a spreadsheet
Bell Work: Open both greenbacks and fast food
Spreadsheets:
- Show me Greenbacks Assignment & Fast Food
- If you are done stand up please!
- Finish with helper (15 mins)
- New Partner Assignment - Furniture Store -Print Off
Done?
- Help Somebody
- Self Test (2 pts E.C.)
- Easy Modeling
9/20/17 - Objective(s) - I can create an "IF" statements in Google Sheets.
Bell Work: Open fast food assignment
Test - 6th grade results
New Phishing Email - want to see?
Spreadsheets:
- Show me Greenbacks Assignment
- Show me Fast Food & Calories
- Begin Self Test (2 pts E.C.)
- Done - 3d Sculpting - Easy Modeling
9/19/17 - Objective(s) - I can create a spreadsheet that answers a question.
Bell Work:
Digital Citizenship
- Complete test?
- Cell referencing
- Finish Greenbacks Assignment
Tutorial and Answers! - Complete Fast Food & Calories