Day 22: Finish Projects and Final Exam

Final Exam:

Continue Integrated Google Apps Project:

Spreadsheet Project Instructions

Create a store and sell four products
- Calculate the following amounts using formulas and functions where apprpriate

• Quantity Sold
• Selling Price per Unit
• Gross Sales Revenue
• Cost per Unit
• Cost of Sales
• Unit Profit
• Gross Profit
• Totals for Quantity Sold, Gross Sales, Cost of Sales, and Gross Profit

- Add pie charts for anything with a total (to show percentages of the total)
- Add column charts for an unit information (to compare amounts to each other)

---

Google Docs Flyer Project Instructions
Create a flyer to announce an event at your store
- try inserting a drawing with WordArt to make it more interesting (not required)
- Make sure you follow basic design principles
- Consider the following questions (you do not have to address each o:

• Who 
• What 
• When
• Where
• Why 
• How

Link to Example Flyer for Restaurant

---

Google Presentation Project Instructions

Create an animated presentation about your store

- Add a title slide with a creative and descriptive title, as well as your name, teacher name, class name, and date

- Add three more content slides

- Add a slide transition

• select a slide in left panel
• choose Transition on tool bar
• apply medium fade to all slides

- Add content to three content slides. Each slide should have:

• title that describes the category of product
• bulleted list of three products in that category (each item needs to be in its own text box)
• image of each product that enters at the same time as its related text
  - select item and have it fade in "on click"
  - select corresponding image and have it fade in "with previous"
  - select next item and have it fade in "on click"
  - select next image and have it fade in "with previous"
  - select previous image and have it fade out "with previous"

Link to Example Presentation for Restaurant

Continue Career Research Project:

Continue with PSA Project:

• Sign up for a PowToon account
• create a 1-minute  PSA that relates to Digital Citizenship.  .
• Powtoon Tutorial
• PSA Project Instructions, Requirements and Checklist
• PSA Storyboard Checklist

Continue with EverFi:

• go to everfi.com/login
• click Continue
• if necessary, complete the previous days’ activities before continuing
• put on your headphones, turn down the volume, and click the next rectangle
• click the next balloon
• after video, take out a notebook to jot down some notes,
• continue through the simulation, taking notes along the way

Computer Science and Coding

• Go to this website to continue where you left off.

Update Weebly Website:

• sign in at weebly.com

Day 21 Integrated Project and Unit 4 Test

Integrated Google Apps Project:

Spreadsheet Project Instructions

Create a store and sell four products
- Calculate the following amounts using formulas and functions where apprpriate

• Quantity Sold
• Selling Price per Unit
• Gross Sales Revenue
• Cost per Unit
• Cost of Sales
• Unit Profit
• Gross Profit
• Totals for Quantity Sold, Gross Sales, Cost of Sales, and Gross Profit

- Add pie charts for anything with a total (to show percentages of the total)
- Add column charts for an unit information (to compare amounts to each other)

---

Google Docs Flyer Project Instructions
Create a flyer to announce an event at your store
- try inserting a drawing with WordArt to make it more interesting (not required)
- Make sure you follow basic design principles
- Consider the following questions (you do not have to address each o:

• Who 
• What 
• When
• Where
• Why 
• How

Link to Example Flyer for Restaurant

---

Google Presentation Project Instructions

Create an animated presentation about your store

- Add a title slide with a creative and descriptive title, as well as your name, teacher name, class name, and date

- Add three more content slides

- Add a slide transition

• select a slide in left panel
• choose Transition on tool bar
• apply medium fade to all slides

- Add content to three content slides. Each slide should have:

• title that describes the category of product
• bulleted list of three products in that category (each item needs to be in its own text box)
• image of each product that enters at the same time as its related text
  - select item and have it fade in "on click"
  - select corresponding image and have it fade in "with previous"
  - select next item and have it fade in "on click"
  - select next image and have it fade in "with previous"
  - select previous image and have it fade out "with previous"

Link to Example Presentation for Restaurant

Continue Career Research Project:

Continue with PSA Project:

• Sign up for a PowToon account
• create a 1-minute  PSA that relates to Digital Citizenship.  .
• Powtoon Tutorial
• PSA Project Instructions, Requirements and Checklist
• PSA Storyboard Checklist

Continue with EverFi:

• go to everfi.com/login
• click Continue
• if necessary, complete the previous days’ activities before continuing
• put on your headphones, turn down the volume, and click the next rectangle
• click the next balloon
• after video, take out a notebook to jot down some notes,
• continue through the simulation, taking notes along the way

Computer Science and Coding

• Go to this website to continue where you left off.

Update Weebly Website:

• sign in at weebly.com

Day 20 Integrated Google Apps Project

Integrated Google Apps Project:

Spreadsheet Project Instructions

Create a store and sell four products
- Calculate the following amounts using formulas and functions where apprpriate

• Quantity Sold
• Selling Price per Unit
• Gross Sales Revenue
• Cost per Unit
• Cost of Sales
• Unit Profit
• Gross Profit
• Totals for Quantity Sold, Gross Sales, Cost of Sales, and Gross Profit

- Add pie charts for anything with a total (to show percentages of the total)
- Add column charts for an unit information (to compare amounts to each other)

---

Google Docs Flyer Project Instructions
Create a flyer to announce an event at your store
- try inserting a drawing with WordArt to make it more interesting (not required)
- Make sure you follow basic design principles
- Consider the following questions (you do not have to address each o:

• Who 
• What 
• When
• Where
• Why 
• How

Link to Example Flyer for Restaurant

---

Google Presentation Project Instructions

Create an animated presentation about your store

- Add a title slide with a creative and descriptive title, as well as your name, teacher name, class name, and date

- Add three more content slides

- Add a slide transition

• select a slide in left panel
• choose Transition on tool bar
• apply medium fade to all slides

- Add content to three content slides. Each slide should have:

• title that describes the category of product
• bulleted list of three products in that category (each item needs to be in its own text box)
• image of each product that enters at the same time as its related text
  - select item and have it fade in "on click"
  - select corresponding image and have it fade in "with previous"
  - select next item and have it fade in "on click"
  - select next image and have it fade in "with previous"
  - select previous image and have it fade out "with previous"

Link to Example Presentation for Restaurant

Continue Career Research Project:

Continue with PSA Project:

• Sign up for a PowToon account
• create a 1-minute  PSA that relates to Digital Citizenship.  .
• Powtoon Tutorial
• PSA Project Instructions, Requirements and Checklist
• PSA Storyboard Checklist

Continue with EverFi:

• go to everfi.com/login
• click Continue
• if necessary, complete the previous days’ activities before continuing
• put on your headphones, turn down the volume, and click the next rectangle
• click the next balloon
• after video, take out a notebook to jot down some notes,
• continue through the simulation, taking notes along the way

Computer Science and Coding

• Go to this website to continue where you left off.

Update Weebly Website:

• sign in at weebly.com

Day 19 Google vs. Office & Presentation Basics

Google vs. Office Tasks:

1. Determine which tech tool should be used based on the given scenarios.
2. How do we decide which tool to use, Google Drive or Microsoft Office?  Is one better than  the other?  Read the articles below with the purpose of determining what features each has to offer and why they are important.  While you read, make a list of the pros and cons  for both.
    
1. Google Drive vs. Microsoft Office
2. Review: Google Drive vs. Apple iWork vs. Office
3. Intent Social: Google Drive vs. Microsoft Office
4. Microsoft Word vs. Google Docs: Do You Really Need MS Office Anymore?
3. Think-Pair-Share: Considering the pros and cons of both Google Docs and Microsoft Word.  Come up with at least 2 examples/scenarios of when you would use one application over the other.  Discuss your examples with a partner and be prepared to share with the class.

Presentation Basics Tasks:

1. Watch YouTube Clip: PowerPoint Intro (3:17)
2. Watch YouTube Clip: Creating PowerPoint Presentations (2:07)
3. Create a PowerPoint presentation about yourself.  Click here for instructions.
4. Complete the Presentation Tool Chart 

Integrated Google Apps Project

Spreadsheet Project Instructions
Create a store and sell four products
- Calculate the following amounts using formulas and functions where apprpriate

• Quantity Sold
• Selling Price per Unit
• Gross Sales Revenue
• Cost per Unit
• Cost of Sales
• Unit Profit
• Gross Profit
• Totals for Quantity Sold, Gross Sales, Cost of Sales, and Gross Profit

- Add pie charts for anything with a total (to show percentages of the total)
- Add column charts for an unit information (to compare amounts to each other)

---

Google Docs Flyer Project Instructions
Create a flyer to announce an event at your store
- try inserting a drawing with WordArt to make it more interesting (not required)
- Make sure you follow basic design principles
- Consider the following questions (you do not have to address each o:

• Who 
• What 
• When
• Where
• Why 
• How

Link to Example Flyer for Restaurant

---

Google Presentation Project Instructions

Create an animated presentation about your store

- Add a title slide with a creative and descriptive title, as well as your name, teacher name, class name, and date

- Add three more content slides

- Add a slide transition

• select a slide in left panel
• choose Transition on tool bar
• apply medium fade to all slides

- Add content to three content slides. Each slide should have:

• title that describes the category of product
• bulleted list of three products in that category (each item needs to be in its own text box)
• image of each product that enters at the same time as its related text
  - select item and have it fade in "on click"
  - select corresponding image and have it fade in "with previous"
  - select next item and have it fade in "on click"
  - select next image and have it fade in "with previous"
  - select previous image and have it fade out "with previous"

Link to Example Presentation for Restaurant

Continue Career Research Project:

Continue with PSA Project:

• Sign up for a PowToon account
• create a 1-minute  PSA that relates to Digital Citizenship.  .
• Powtoon Tutorial
• PSA Project Instructions, Requirements and Checklist
• PSA Storyboard Checklist

Continue with EverFi:

• go to everfi.com/login
• click Continue
• if necessary, complete the previous days’ activities before continuing
• put on your headphones, turn down the volume, and click the next rectangle
• click the next balloon
• after video, take out a notebook to jot down some notes,
• continue through the simulation, taking notes along the way

Computer Science and Coding

• Go to this website to continue where you left off.

Update Weebly Website:

• sign in at weebly.com

Day 18 Career Research Project and Unit 3 Test

Unit 3 Test


Career Research Project:

Instructions:

Launch Google Chrome
–Go to www.bls.gov/k12/students.htm
–click Career Exploration
–pick “in-demand” area

• Managing Money
• Computers

–pick career to research

Launch Google Presentation
–use career as title, name in subtitle
–create 5 more slides

• Contents
• Description (What They Do)
• Preparation (How to Become One)
• Pay
• Job Outlook

–add content to slides–repeat above steps for career of your choice

Continue with PSA Project:

• Sign up for a PowToon account
• create a 1-minute  PSA that relates to Digital Citizenship.  .
• Powtoon Tutorial
• PSA Project Instructions, Requirements and Checklist
• PSA Storyboard Checklist

Continue with EverFi:

• go to everfi.com/login
• click Continue
• if necessary, complete the previous days’ activities before continuing
• put on your headphones, turn down the volume, and click the next rectangle
• click the next balloon
• after video, take out a notebook to jot down some notes,
• continue through the simulation, taking notes along the way

Computer Science and Coding

• Go to this website to continue where you left off.

Update Weebly Website:

• sign in at weebly.com

Day 17 Career Preparation

Tasks:
Get to Know Yourself
Complete the surveys below and create a Blogger post that reflects on your results.
Personal Interest Survey
Skills Assessment 
Personality Test      
 -  Careers by Personality Type

Tasks:

1. What the Video - Choosing College Wisely (12:44)
2. Complete the College Research and Comparison Spreadsheet 

Tasks:

1. Begin Your Naviance Resume 
2. Review the Personal Business Letters Presentation 
3. Write a Personal Business Letter (Cover Letter or College Letter of Interest) 

Resources:
Letter Notes 
YouTube Clip: Formatting a Personal Business Letter in Google Docs  
Article: How Should A Cover Letter Look? 
Article: What Should Be Included in a College Letter of Interest? 

Elevator Pitch Assignment

Continue with PSA Project:

• Sign up for a PowToon account
• create a 1-minute  PSA that relates to Digital Citizenship.  .
• Powtoon Tutorial
• PSA Project Instructions, Requirements and Checklist
• PSA Storyboard Checklist

Continue with EverFi:

• go to everfi.com/login
• click Continue
• if necessary, complete the previous days’ activities before continuing
• put on your headphones, turn down the volume, and click the next rectangle
• click the next balloon
• after video, take out a notebook to jot down some notes,
• continue through the simulation, taking notes along the way

Computer Science and Coding

• Go to this website to continue where you left off.

Update Weebly Website:

• sign in at weebly.com