Excel Days

Excel Days

Complete the following exercises using Excel.

Submit the 3 assignments to the Portal

1. Excel Practice - directions and example to follow

1. column of 100 1's
2. column of counting from 1-100
3. column of counting by 2's to 100
4. column of counting by 5's to 100
5. column of counting by 10's to 100
6. Heading - Excel Practice (merged and centered)
1. Bold, larger than cell text, colored font and colored fill
7. Date in one column
8. Convert one full column of numbers to currency formatting
9. Use the function button to sum all the rows
1. include a title on the column of the sums
10. At the bottom of each column compute using functions
1. sum
2. average
3. max

2. M&M's

3. Grades

Snip of Demonstration of Excel Practice in class 

Example of how to Share your Excel Assignments

DIRECTIONS

1. There is a packet of a few assignments.

2. When you are done, share the Excel file using the snipping tool.

3. Be sure to save your Excel file in your network drive as you may be asked to upload it to the Portal.

USE THE SNIPPING TOOL TO CAPTURE YOUR WORKSHEET

Create a Custom Map

Create a Custom Map

My Maps Tutorial

Requirements:

1. Create a custom map using "My Maps" using Google Maps.
2. Name your map and give a description of what it includes
3. Identify a minimum of 7 locations for your map.
1. Each locations needs a custom icon
2. A description for each spot is needed
3. Include 2 videos of an informational nature
4. For all others an image is needed.
5. Use the draw tool to identify the walking/driving/cycling route you recommend.
6. Save the map
7. Share the map on your blog

Have fun

Tuesday F Block Information

Tuesday F Block Information

1. If you haven't played a bunch of games and then written your Reflective Blog Post based on the prompts I put in the Post for Monday then............. DO That!

THEN

2. Begin your PowerPoint Stop Motion Animation

Directions:
1. Choose an idea and a mini story or comic type animation. It will be very short in length but many slides.
2. Begin making Slide #1.

• before getting too far! Remove the backgrounds from any image you use with a background

3. Copy slide #1, then add what else you want to add.
4. Move your "things/moving parts" just a tiny bit on your screen
5. Copy slide #2, then add what else you want. Only if you need to add items.
6. Repeat Step #4
7. Copy slide again.
8. Keep repeating this process.

Other Info:
Minimum of 35-50 slides
Two (2) day project
Set timing to .01 for each slide.
Remove the mark on advance with "mouse click"
Test the slide show to see how the items are moving along.
Submit to your blog as a Windows Media Video then upload the video to your blog.

Have fun!

Monday Options - A Block

Monday Options - A Block

1. Continue perfecting your game
2. Play other people's games in the class
3. Go to Thimble (A Webmaker site)
4. Begin making a Stop Motion Animation using PowerPoint

BLOG POST AFTER PLAYING AT LEAST 10 GAMES!
1. Write about what game you think should win an AWARD:

• Most Fun
• Most Difficult
• Most Creative

2. Choose one game to write about and describe the following:

• What was done differently than what you did in your own game
• What might you incorporate into your game that you saw
• Describe another way the game could have been programmed using the same theme (for example)
• a maze without a timer or score could use both as ways to make it more difficult or the opposite, if no timer used only hurdles or road blocks or sending you back to the beginning with a penalty)

Answer Garden

Try this Out!

Make an App

AppInventor - Try it Out

Choose One of these to make an App with.

Game Project Check-in

Creative Commons Music

**Warning ......   This could be a time distraction!

Check out this Link for Free music and sound!

When done!

OPTIONS:

1. Use this link to get to Code Studio.
You will use Unit 3, Animations and Games to try more tools as you learn about Game design.
Code Studio Link

2. Pencil Code
Link to Pencilcode

3. Alice
I will need to download it onto your computer.

Remember to sign in or create an account!

Final Creative Game

Final Project Directions and Grading

Showcasing the AP CS Principles Final App Project

App Video Playlist

Rock Paper Scissors

Rock Paper Scissors Example Project - Do not Remix

You can begin, as you know you will need at least 3 Sprites and a backdrop for this game.

Debug-its Round 3

Debug 3.1
Debug 3.2
Debug 3.3
Debug 3.4
Debug 3.5

Grades Grades Grades

Grades Challenge

Fix these Dice!

Dice Challenge

Revised List of Unit 4 Projects

Revised List of Unit 4 - Scratch Projects

Project #11 - Baseball Homerun

Project #11 -  Baseball Homerun

Remix this Baseball starter Project

Do one of the following:

1. The cat (or some other living creature) hits a homerun and runs all the bases.

• Use a costume change
• Be sure to change the direction of the cat as it rounds 1st base to go to 2nd.
• Use Wait time to make give it time to say something about the fabulous progress around the field.

 2. The cat hits a single

• Cat says something about the hit
• Cat will move around the bases either by:
• stealing a base at a time
• moving ahead because another player got a hit.
• Use comment or speech bubbles about the success of moving from one base at a time.

Post your link to your blog when done.

Project #10 - Age Program Using Conditionals

Age Program Using Conditionals

Next Up!

NEXT UP!

Debug-its! Round 2
Here is the link to the set of 5.
No need to make separate entries on your blog.
In the Notes area is where you tell what you did to fix the problem.
These are the links that will bring you right to the Scratch Team Debug-it Challenges.

Good luck

Debugit 2.1
Debugit 2.2
Debugit 2.3
Debugit 2.4
Debugit 2.5

F BLOCK ANNOUNCEMENT

F BLOCK ANNOUNCEMENT

Please go to this link and do the following:

1. Follow it!

2. Be thinking about a project you have that you might like to add to the Studio or a friend's project that you like a lot.

Here is the F Block Exemplar Projects

A BLOCK ANNOUNCEMENT

A BLOCK ANNOUNCEMENT

A BLOCK STUDIO

Nutrition Game

Nutrition Game

Be Creative~ Have Fun

• Have 10 foods minimum (5 healthy, 5 unhealthy)
• Have a point system (+ for healthy, - for unhealthy)
• Decide what is a winning score
• Make an announcement somehow of winning the game
• Each Sprite needs to say something when clicked

EXTRA CREDIT:

Have your sprite foods disappear when clicked

and/or

Add another level

and/or

Use Sprite foods from another source than the Scratch library (draw your own, use images as food)

Always remember to include instructions

Create a scene or setting for the food

Post to your Blog as a link

Cat & Mouse Timer Remix

Cat & Mouse Timer Remix

See the directions on the Project page.
This is for beginning directions to learn how to add useful features to games.

Fish Chomp Starter

Moving 3 Ways Example

Moving 3 Ways Example

Click this to see inside this Project.
When you look at the code you will see each Sprite has a different way to move!

Scratch Name Needed

Fill this out Immediately....... Thank you!

Alphabet Learning Game

Alphabet Learning Game

Use any ten letters of the alphabet to create a learning game for those just beginning.
Each letter needs to be able to function in 2 different ways using these two evemts:

1. Keyboard
2. Mouse

Using the event make the letter have a Costume change

Use sound if you want
For example:
1. The letter "H"....... when I touch the "h" on the keyboard something will happen.

• The H will turn into a house,
• The "H will speak and say something like, "H is for happy!"

2. When I click on the "H" in the game with my mouse, the "H" will change costume into a hairy hound.

Each letter needs to change costume and to be able to be touched by the keyboard and touched by the mouse. These are two separate events.

Name Project

Name Project

Create a New Project and Name it "Name Project"

1. A separate Sprite for every letter of your first name
2. Use an Event block to start your program or, "When the Green Flag" is clicked.
3. All the letters need to have a unique behavior
4. Choose a background.
5. Include instructions on the project page.
6. Embed your project with the html code to your blog.
7. Share the link as a hyperlink to your blog.
this can all be in the same blog post

Extra Credit: Have your name reinitialize itself when the green flag is clicked

Remember to test your code during your programming.

Debug-its 1.1-1.5

Scratch DeBugits #1 (1.1-1.5)

25 Point Project
Debut-its Link
Use this link to find the first section of Debug-its.
There are 5 you need to complete for this assignment (5 points each).

DIRECTIONS:

1. Remix the project after you open it.
2. Read the directions on the project page to determine what the problem is.
3. For each of the problems for each of the 5 challenges, change the code to fix the problem.
4. On the project page describe what you did to fix the problem.

4. Share on your blog two ways:

Embed your code and share the link.

SCRATCH DAY 1

SCRATCH DAY 1

10 Point Project

1. Make an account on Scratch.mit.edu

2. Username: first initial, last name

3. Create a new project

1. Add a new sprite in addition to the cat
2. Add a background
3. Add an action for each sprite to do (different for each sprite)

4. Share your project to the blog by enbedding.

5. Remember to test it

6. On your project page label your project and give directions.

Final Webpage Post

TWO STEPS FOR SHARING:

1. PORTAL
Please upload your .txt file of your html and css code to the E-Locker in the Portal. You will use the folder called "Final Webpage".
Please "RUN" your code and see what it looks like on a full screen.

2. BLOG POST

• Share the link from Code Studio's Web lab
• Use the hyperlink option

Tuesday, 4/10 class will take part in a Gallery walk of each others' webpages.
A brief checklist will be used as you circulate the room and see everyone's work over the past month.

Great job everyone. I can't wait to see the finished products.

FINAL WEBPAGE POST

FINAL WEBPAGE POST

In addition to Checkpoint #1 make sure to add the following:
1. Ordered list or Unordered list
2. Video (optional)

• 3. Animation (for example, scrolling text)
• Other animated affect of your choice

3. Centered images

4. Borders around something 

• page
• section of text or image

5. Image that when clicked goes to a webpage

Web Page Checkpoint #1

Web Page Checkpoint #1

After today..... 4/5 you should have saved (somewhere I can view) the following:

1. Title
2. Four images
3. Two working links
4. P's .... paragraph tags with info
5. 1 iFrame (box)
6. 2 other heading styles
7. background color
8. Colored text
9. Text formating using some combination of any of the following (at least 3):
1. bold
2. italics
3. underline
4. text alignment (center or right)

Other even more interesting items will be needed for your final version of your webpage.

For example......... scrolling text, animation, video, page borders and more.

Web Lab Documentation

Use this site as a Reference for HTML & CSS

Unit 2 Directions

Unit 2 - Stage 4 Directions

Unit 2 - Stage 5 Directions

Unit 2 - Stage 6 Directions

Unit 2 - Stage 7 Directions

Unit 2 - Stage 8 Directions

For Fun and a Peek at What's Coming

Play Lab

Hobby & Recipe Assignment

Hobby & Recipe Assignment

When you are done with this part of Code Lab (Stage 4) please take a Snippet of each page including both the code and the non-code side of the screen. Make one post to your blog with both the Hobby and Recipe assignment included in the post.

Thanks, I look forward to seeing what recipes you chose and how you applied the new codes you've learned.

F Block: 3/20

A Block: 3/21

Sophomores: Don't worry about class (of course), when you return you will have the time you need.

HTML LESSONS

HTML LESSONS

Complete the 5 Exercises on the W3 Schools tutorial.

Stage 3

STAGE 3

Lesson 3 Link

Follow the directions on the Code Studio website.

Directions and Handout if you don't have a packet for Lesson 3

STAGE 2

Let's look at these two documents together and begin to add to our 

"WEB DEVELOPMENT PRACTICES" packet page 1, "QUALITY WEBSITE FEATURES LIST".

10 Principles of Effective Web Design

10 Rules of Web Design

Add these rules and principles to the page in the packet that asks for features of quality websites.

Explore the following 4 websites and answer the following questions in your blog.

1. What new features do you notice that could be added to the Quality Website features.
2. What common elements do you notice across all the websites?
For example, does every webpage have a title?


Personal Website #1
Personal Website #2
Personal Website #3
Personal Website #4


We will share the features noticed in these personal websites, especially, and any new observations. Add any newly found features to your list in web-development-practices packet on page one.

Stage 1 - Unit 2 Rating Websites

Stage 1 - Unit 2

Rating Websites

Websites:
Website #1
Website #2
Website #3
Website #4
Website #5

Unit 2 Code Studio - Web Development

Unit 2 Code Studio

Assignment:
1. Get a packet and put your name on it.
2. Use the link above to begin Unit 2
3. Complete the 1st Activity - Rating Websites

• Complete thoroughly
• Work with a partner or alone
• No Threesomes!

Scavenger Hunt

RULES

1.  Make a doc
2. Include search item
3. Include a snip of each item
4. Post/share to your blog

Example Doc of Scavenger Hunt Activity

Blog Address

Link to access Blog Address Form
Thank you.

Blog Setup

Required:

Add the following Gadgets:

• Blog list - Label this "Blog List"
• List - Label this "Frequently used Websites" or something like that
• Image - your own choice
• Your own choice
• Your own choice
• Statistics

After initial setup:

1. Add these websites you may use often: include

1. http://www.w3schools.com/
2. https://code.org/student

2. Add to your Blog List, 5 student blogs and the Class Blog.

• http://classconnectionsrmhs.blogspot.com/
• be sure to test each link 

3. Code Studio

Use the link below to access our class in Code Studio.

A Block - Link to Code Studio 
F Block - Link to Code Studio