Tutorial for SS 9-Purchase Order
You have $50 to spend
Adjust the quantities to spend as close to this amount without going over $50
You must buy at least one of each item
Can not buy parts of an item (e.g. 1.5 scissors)
You must be within ten cents of $50 (>$49.89) without going over
Finally, format the Total Unit Cost cells and the Total cell to be in currency (e.g. $1.26, NOT 1.26)

Fri-3/27

Finish any old spreadsheet assignments

Binary & ASCII Representation

Binary/ASCII Decoding Mysteries
- Solve the challenges with a partner or by yourself
- Upload as a PDF to SeeSaw

"Spring Break"

Wed-4/8

Spreadsheet Exercises Continued

Spreadsheet 10-Fill-Right-Down - Tutorial: SS-10
Spreadsheet 14 Sort Columns - Tutorial: SS-14

Take a screenshot of each and post to Seesaw

CyberSecurity

Watch the videos in Khan Academy and answer the questions (the parts circled in red) as you go--->
Screenshot the results of each quiz--a total of 4 -- (circled in red) and post to Seesaw

Fri-4/10

Spreadsheet 16 Merge Cells - Tutorial: SS-16
Spreadsheet 17 Merge Vertical Align - Tutorial: SS-17

Take a screenshot of each and post to Seesaw

Finish CyberSecurity Quizzes

Post a screenshot of the results of all 4 quizzes to Seesaw

Play the Cybersecurity Lab Game

It's actually fun!-SnapCat,

Wed-4/15

Spreadsheet 18 Cell Borders - Tutorial: SS-18
Spreadsheet 19 Cell Border Colors - Tutorial: SS-19

Take a screenshot of each and post to Seesaw

Computer Security Terms

Look at each term with the flashcards
Take the test--Matching and M/C only, all questions--until you get an A- or better
Post a full-screen screenshot of your score

Fri-4/17

Spreadsheet 20 Pie/Bar Chart - Tutorial

Create a pie chart & a bar/column chart-read the directions on Google Sheet!
Post a screenshot of each chart to Seesaw

Finish Computer Security Terms

Take the test--Matching and M/C only, all questions--until you get an A- or better
Post a full-screen screenshot of your score

KPAW 4-20-20

Wed-4/22

Loom Video Overview for 4/22 and 24

Finish old assignments from 4/8 to 4/17

All ketch'ed up? Play these games...

And watch this video:

Fri-4/24

Loom Video Overview for 4/22 and 24

Cryptocurrencies and Blockchain

Cryptocurrency Collaborative Slide Project

Read the directions on the first slide of this collaborative Google slides project

Teams and *team leaders*

*Benji*, Jonny, Pierce, Ihsan
*Aaron*, Matt P., Dylan, Oskar
Matt D., Anika K., *Bee*, Kerem
Leo, Guillermo, *Tommy*, Hossein
Kyle, *Akhil*, Jackson, Evan

* Team leaders* make a copy of slideshow and share with the rest of their team
Type your name on the slides you are going to work on-everyone needs to sign up for 6 slides
Choose 1-2 questions to answer on the second-to-last slide.
Extra Credit if a picture of your own cryptocurrency is created on last slide.
Everyone screenshots the slides that they complete and posts to Seesaw.
*Team leader* will screenshot the last two slides that are divided up by the team.

Wed-4/29

Continue Cryptocurrency Collaborative Slide Project

Fri-5/1

Spreadsheet Test - CA Census

Re-create the spreadsheet-->
Be sure to add the formulas in the empty columns
Screenshot and post to Seesaw
Loom Video Tutorials:

KPAW 5-4-20

Zoom Meeting 5/6

Go to Nearpod and type in this join code: RQTNF

wed-5/6

Loom Video Overview 5/6 & 8

Continue Spreadsheet Test - CA Census

Re-create the spreadsheet-->
Be sure to add the formulas in the empty columns
Screenshot and post to Seesaw
Loom Video Tutorials:

Fri-5/8

Loom Video Overview 5/6 & 8

Nearpod: Wi-Fi Technologies

View this interactive slideshow
Answer the embedded questions
In case you need a join code: IGRFA
No need to submit to Seesaw--Mr. Kelly can see your progress through the Nearpod app

All done? - Play Data Games!

Google Trends - Is there a correlation between 2 or more searches?
Google Feud - Like playing Family Feud

Wed-5/13 Loom Video OVerview

Create a "Clean" Bar Graph of this RAW data in Google Sheets

Add only the "Clean" data--You will need to consolidate (merge) the data in order to represent everything
Label chart with a title and value labels for each bar

Examples of "Clean" data

Fix misspellings (gumi bares vs gummy bears)
Remove non-relative data (I like Roblox!)
Translate data to actually mean something (No meat = I want only veggies)

Fri-5/15 Loom Video Overview

Finish Clean Data Bar Graph for Pizza Toppings Survey

Be sure to represent ALL the toppings and to get rid of the unnecessary data
Label chart with a title and value labels for each bar
Add a pie chart of the same data with value labels on each slice---->
Take a screenshot of "clean" data with both charts and post to Seesaw

Finished with bar graph? - Add a pie chart of this data

KPAW 5-18-20

Wed-5/20 Loom Video Overview

Ozaria - Learn Python!

Click here to join the class
If it actually requires a join code, here it is: CrashSwimShort
You will be starting and finishing Prologue: Sky Mountain (5 exercises)
No need to screenshot to Seesaw, I can check your progress online

CodeCombat's:

Fri-5/22 Loom Video Overview

Ozaria-Ch. 1 The Moon Dancers (Module 1)

This chapter is split up into 6 modules. You will be working in module 1 for now (13 exercises)
Your ultimate goal will be to finish the first 2 modules if not more...
Following along solve the practice challenges, concept challenges and the final challenge (Ninjutsu) of Module 1
No need to screenshot to Seesaw, I can check your progress online

Start of Ch. 1 The Moon Dancers - Module 1: Algorithms and Syntax

Wed-5/27 Loom Video Overview

Continue Ozaria-Ch. 1 The Moon Dancers (Module 1)

Keep working on module 1 and try to complete all 13 exercises
If you finish Ninjutsu challenge, and want to move on, keep going to module 2 (A Bug's Life)
No need to screenshot to Seesaw, I can check your progress online

End of Module 1: Ninjutsu Challenge

Fri-5/29 Loom Video Overview

Continue Ozaria-Ch. 1 The Moon Dancers (Module 2)

Go to module 2 (Debugging)
There are 10 exercises in this module
The last exercise to complete is called "Fading Shadows"
No need to screenshot to Seesaw, I can check your progress online

Ch. 1 The Moon Dancers-Module 2: Debugging

KPAW 6-1-20

Wed-6/3 Loom Video Overview

Continue Ozaria-Ch. 1 The Moon Dancers (Modules 2-3)

If you do actually finish module 2, you can start module 3 if you want (Fading Shadows is the last challenge for this module)
No need to screenshot to Seesaw, I can check your progress online

End of Module 2: Fading Shadows Challenge

Fri-6/5 Loom Video Overview

Finish any missing assignments and turn in

Finish Module 2 or 3-now due

End Distance Learning Activities.

Do not go further...

Do Not Log On

Find Your Seat

Roll

CoIn2 Overview

Lab Rules and Acceptable Use

Done? Go to the next day...

First Seesaw posts: Find a picture of each of the following people and add their name in the caption and what they invented

Tim Berners-Lee
Hakon Wium Lie & Bert Bos
Brendan Eich
Mary Kenneth Keller
James Gosling
Guido van Rossum
Donald D. Chamberlin & Raymond F. Boyce

All Done?--Blockly Games

Finish Seesaw activity?

Continue Blockly Games

Finish Pond

Silent Teacher

Tue 1/28

Finish Seesaw posts from Friday

Sign in to the CoIn2-20 Discoveries course

Use your @llesd.org acct. to sign in to Code.org
Then join the class at this link
Find Unit 4
Go to Lesson 1: Analysis of Design:

Determine Your User

Only do the first part, skip the Critiquing Design part
Work on it with a partner
Download as a PDF and post to Seesaw
Click "..." then choose "Edit People" to link your PDF with your partner(s) so they get credit too

Finished? Blockly Games

Find a partner and choose a Profile below:

Then use your profile to fill out: Reacting As Your User

Choose 1 of the user profiles to the left
Determine what product your user would prefer
Why do they like or not like something?
How would you alter a product to better suit your user?

Thu-1/30

Smart Clothing Design: User Centered Design Micro-Activity

Watch the videos to the right--->
Fill out the worksheet above while also sharing on the whiteboard the following:
- Brainstorm list of smart clothes
- Brainstorm list of people who would benefit from smart clothes
Save as a PDF and post to Seesaw

Show the teacher an A- or better for the following refresher Quizlet tests

Review your HTML knowledge
Review your CSS knowledge too!

Mon-2/3

Show the teacher an A- or better for the following refresher Quizlet tests:

Review your HTML knowledge
Review your CSS knowledge too!

Smart Clothing Design: User Centered Design Micro-Activity

Find a partner to go into business with and come up with a name
Fill out the worksheet while also sharing on the whiteboard the following:
- Brainstorm list of people who would benefit from smart clothes
- Brainstorm list of smart clothes
Save as a PDF and post to Seesaw

Name your company, design a logo and create a picture of smart clothing

Logo: Logo Maker
Clothing Design: Sketchpad
- Add labels to clothing (what their function is)

Tue-2/4

HTML/CSS Quizlets?

Name of Company, Logo and Picture of Your Smart Clothing

Logo: Logo Maker
Clothing Design: Sketchpad
- Add labels to clothing

Web Design-Smart Clothing Product

Show the teacher the following in order to start:
- A- or better on HTML/CSS Quizlets
- User Centered Design Micro-Activity (upload a pdf to Seesaw)
- Logo (upload to Seesaw)
- Clothing design with detailed labels (upload to Seesaw)
Set up an account using Glitch and follow handout
- Follow the directions on the sheet
- Minimum of 2 pages

Design Your Smart Clothing Web Site

Glitch
- Set up an acct. and share a link (via email) to other goup members so they can help with editing the site you will be making (see below)
Handout - Includes the code for the designing your 2 page site

Sample Student Sites:

Colin/Jimmy

Wed-2/5

Design Your Smart Clothing Web Site

Glitch
Handout

To add an image to your web page using Glitch:

Upload your image to "assets"
Click on the image you uploaded
Copy the URL of the image "https//cdm.glitch.com/..."

Thu-2/6

Continue Smart Clothing Website

Glitch

Add CSS/Javascript Interactivity to Your Site

20 Points for 1
10 extra credit points for more than 1

Sharing a Glitch project with a partner:

Email them the URL

Mon-2/10

Continue Smart Clothing Website

Glitch

Add CSS/Javascript Interactivity to Your Site

20 Points for 1
10 extra credit points for more than 1

Tue-2/11

Continue Smart Clothing Website

Glitch
Insert 1 or more Javascript examples into your site

Examples:

Wed-2/12

DUE!

Finish Smart Clothing Website + Js Interactivity

Copy and paste a link to your published site on Glitch to Seesaw

Examples:

Thu-2/13

Review this list of sample apps that have a mission to help others

Check out these 4 types of apps...Which type will you do?:

Copy and paste the questions to a Seesaw Note and answer them

What social issue do 2 of the apps try to address
Do a web search to see what other apps do to address a social issue? Explain 2 of them
Group options:
- Work with same group
- Work alone
- Work with another partner (no groups of 3)
What type of problem is your group interested in?
- Can be for your smart clothing OR
- Something new
Consider all of the different groups of users impacted by your chosen topic and list them
What apps already address the topic your group has chosen? If none, state that.

Mon-2/24

Continue Apps for Good research

Continue Market Research and any other questions from yesterday (italicized) on your group's Seesaw Note

Student Examples

App Idea Prototype

Use the 4 app types as guides to help you with the design of your own app
It can be for your smart clothing OR something different
Create a prototype using either paper OR Draw.io (a screen for every option) using this template
Must have at least 4 screens + an "About" screen

Tue-2/25

Continue Paper Prototype Test

Test out your "App" with your partner--pretend to "click" on each option and make sure the app takes the user to the correct paper screen
Create a cut out diagram of all your screenshots in Google slides (See below)
Does it make sense to the user? Does it take the user where they need to go?
Make changes along the way
Take a screenshot of your diagram (like below) and post to Seesaw

Wed-2/26

Finish paper/digital prototype

Sign in to the CoIn2-20 Discoveries course

Use your @llesd.org acct. to sign in to Code.org
Then join the class at this link

Digital App Design

Unit 4 Lesson 12, Puzzle 2 (U4-L12-P2): Learn how to design a screen using the various Design tools
Divide up the different screens of your app with your partner...You'll be able to link them later (Lesson 13)

Thu-2/27

Digital App Design

Unit 4 Lesson 12, Puzzle 2 (U4-L12-P2): Learn how to design a screen using the various Design tools
Divide up the different screens of your app with your partner...You'll be able to link them later (Lesson 13)

Mon-3/2

Linking Screens

U4-L13: Continue work on app by linking the different screens created by the members of your team

Test Your Digital App

Can you actually navigate to all your screens (e.g. home button)

Share Your Design for Your App

Copy and paste the link that is generated when you click on the Share button in U4-L13-P2

Tue-3/3

Finish Designing/Linking Screens for your app

Final App Presentation

Share a link to Seesaw of your finished, linked app

Finished?

Play with one of these AI Experiments:

Which ones do you like the most? - post a screenshot to Seesaw

Wed-3/4

Introduction to Machine Learning (Simple AI)

Explore these other tools...

Complete the HoC: AI for Oceans

Post a screenshot of your completion

Thu-3/5

Teachable Machine

Teach the computer to...

Mon-3/9

Unit 5: Data and Society

Introduction to Spreadsheets

Spreadsheet Terms Quizlet

Wed-3/10

Spreadsheet Exercises

Introductory Demonstration Videos

Complete the following exercises, take a screenshot and post to Seesaw:

Spreadsheet 1-Formattext
Spreadsheets 2-FormatNumbers

Binary & ASCII Representation

Binary/ASCII Decoding Mysteries
- Solve the challenges with a partner or by yourself
- Upload as a PDF to SeeSaw

Thu-3/11

Finish and post a 90% or better to Seesaw?

Spreadsheet Terms Quizlet

Guess the Formula

Try to guess the formula for each input/output

Lesson 4: Representing Images

Complete Lesson 4, Puzzles 2-6

Mon-3/16

Formulas in spreadsheets

Take a screenshot of each and post to Seesaw

Unit 5 Lesson 5: Representing Numbers

Fill out the Representing Numbers worksheet with a partner or by yourself
Download as a PDF when finished and post to Seesaw

Mon-10/21

More Formulas

Spreadsheets 6-FormulaTriangle
Spreadhseets 7-FormulaDistance
Spreadsheet 8-SumFunction

Creative Destruction

Wed-10/23

Spreadsheet 9-Purchase Order
Spreadsheet 10-Fill-Right-Down

Who is Alan Turing?

Copy/paste questions below to a Seesaw note and answer:

Who is Alan Turing?
Where is he from
When did he live?
What was his goal during WWII?
What did he create in order to succeed?
What is a Turing Machine?

Th-10/24

Spreadsheet 14 Sort Columns
Spreadsheet 16 Merge Cells
Spreadsheet 17 Merge Vertical Align

CyberSecurity

Watch the videos and answer the questions (circled in red below) as you go--->
You should complete 4 sets of 4 questions each
Screenshot the results of each quiz ( there are 4 quizzes, all circled in red below) and post to Seesaw

Time Left?

Play the Cybersecurity Lab

Fri-10/25

Spreadsheet 18 Cell Borders

Spreadsheet 19 Cell Border Colors

Computer Security Terms

Quizlet Live
Take the test--Matching and M/C only--until you get an A- or better
Show the teacher your score

If finished...

Mon-10/28

Spreadsheet 20 Pie Chart

Create a pie chart & a bar/column chart
Post a screenshot of each to Seesaw

Finish Computer Security Terms Quizlet

Show teacher an A- or better
Matching and Multiple Choice ONLY

Cryptocurrency Collaborative Slide Project

Cryptocurrency

Wed-10/30

Continue work on Cryptocurrency Collaborative Slide Project

Don't forget the last two slides!
Upload entire slideshow as a PDF to Seesaw and include the names of your group members!

Finished?

Self-Directed Coding Resources

Thu-10/31

Turn in Cryptocurrency Collaborative Slide Project

Don't forget the last two slides!
Upload entire slideshow as a PDF to Seesaw and include the names of your group members!

Problem Solving with Data

Find a NEW partner and then Make a copy of this Google doc and share with your partner
Fill out the worksheet:
- As a class, answer the first two questions: Define and Prepare
- Fill out the rest of the worksheet with your partner and be ready to prove WHY you believe the particular building should be built

Wed-11/6

Data in the Real World

With the same partner fill out the above worksheet (make a copy and then share with partner)
Watch each movie when you get to the 3rd question of each scenario
Get ready to discuss in class

Finish/turn in old assignments

Missing SS exercises
Continue Cryptocurrency Collaborative slides-PAST DUE

Done?-Learn Some Python!

CodeCombat: Build an Arcade Game
CodeCombat: Code, Play and Create
Screenshot the last level you reach just before the end of the period and post to Seesaw

Thu-11/7

Learn Some Python!

CodeCombat: Build an Arcade Game
CodeCombat: Code, Play and Create
Screenshot the last level you reach just before the end of the period and post to Seesaw

Mon-11/18

Excel Project Test - CA Census

Re-create the spreadsheet below
Be sure to add the formulas in the empty columns
Add a bar/column chart for the 2010 census data
Mr. Kelly will explain how to add a title in the header

Wed-11/20

Finish Excel Project Test

Finished? Data Fun:

Google Trends - Is there a correlation between 2 or more searches?

Higher or Lower Game -Which topic has more or less searches?

Google Feud - Like playing Family Feud

Thu-11/21

Now DUE: Excel Project Test

Puzzle 1: Create a Bar Graph of this RAW data in Google Sheets

Structuring Data - Complete Unit 5 Lesson 11 Puzzles

See direction below for all 4 puzzles:

Add only the "Clean" data--You will need to consolidate (merge) the data in order to represent everything
Label chart with a title and item labels for each bar

Puzzle 2: Copy and paste the two questions to a Seesaw Note and answer them
Puzzle 3: LOOK AT the app and spreadsheet version of the pizza (no action needed)
Puzzle 4: Clean the data and take a screenshot of the new chart of cleaned answers

FRi-11/22

Conduct a Survey

Choose a topic with at least 5 different categories with at least 4 items in each catogory:

For Example: Favorite Foods (topic)

Breakfast (category)
Brunch
Lunch
Dinner
Snack
Favorite category
Favorite overall item

Brainstorm a Topic FIRST

MindMup
Post your brainstorm to Seesaw (screenshot or pdf)

Survey Topic Ideas

Have subjects choose their favorite...

Amusement Park Rides (from various theme parks)
Soccer Players (from various teams)
Football Players (from various teams)
Countries (from various continents)
Universities (States)
Memes (on various topics or with certain objects/animals)
Video games (from various genres)
National Parks (from various states or countries)
Cars (from various manufacturers)
Articles of clothing (from various stores/brands)
Musician (from various genres or from time periods)
Electronic device (various types or manufacturers)

...Last 2 Questions: What is their favorite category & favorite overall item

Mon-12/2

Finish Brainstorm of Topic

MindMup
Post your brainstorm to Seesaw (as a PDF if possible, otherwise, a screenshot)

Create a Google Form

An example

Google Form Requirements

Number each question
Ask for Gender
Ask for Grade
Ask 5 different category questions
Last 2 need to be for favorite...
Need to include an "Other" option so they can add their own
3 Different ways to respond to your questions
- e.g. Multiple choice, short answer, dropbox, check boxes
2 or more pictures AND a theme that relate to your topic
Share, via a link, to Seesaw, your active Google Form survey
Go on Seesaw and fill out your classmates surveys!

Wed-12/4

Finish Google Form Survey - DUE NOW

Fill out everyone's survey in the class via Seesaw
Update your Google Form as necessary

Data Fun:

Google Trends - Is there a correlation between 2 or more searches?

Higher or Lower Game -Which topic has more or less searches?

Google Feud - Like playing Family Feud

Thu-12/5

If you are done with your survey...fill out any survey you have not filled out yet

And check your own data collection!

Keyboarding Activity of Choice

Finish/Update Google Form Survey

Making Decisions with Data

Fill out this worksheet (all 3 pages) while analyzing the data collected and make decisions based on what you find
OK to discuss with others, but everyone must turn in their own copy!
Download as a PDF and post to Seesaw

Fri-12/6

Finish Making Decisions with Data worksheet from (previous class)

Must turn in your OWN copy - no partners
Download as a PDF and post to Seesaw

Favorite Survey Responses

Look at the Google sheet with the responses and...
- Clean Data
- Create a chart for each question-Need to have at least one pie or
- Include the data labels, a title and color each pie/bar
- Create a spreadsheet in XL OR Google Sheets
- It should look something like what you see below