Tuesday, May 31, 2016

Making Class Data and Scatter Plots



Today the students will be creating a Class Data Sheet and using their Data to create Scatter Plots of their lemonade Sales.

They will be making the following Scatter Plots

Temperature - Profit

Temperature - Cups Sold

Lemons Used - Cups Sold

Sugar Used - Cups sold

Sugar Used - Profit

Lemons Used - Profit


First they need to input their 45 days into the following Active Document.

LEMONADE CLASS DATA EXCEL

How to make Scatter Plots


Wednesday, May 25, 2016

Time to start the Business Plans of the Final Project

Today the students will have time to complete their 45 Days.  If they are finished they will begin working on their Business Plans.  A link to the starter document is below.  Students will need to save an editable version in their L Drives.  They will then begin completing the Business Plan Components.

Business Plan Starter Document


RADIO AD TEMPLATE CLICK HERE


HOW TO DESIGN A LOGO IN PHOTOSHOP


Monday, May 16, 2016

Finishing All Missing Work and Final Project Begins

Today the students will have the opportunity to get all their missing work caught up.

Once they have completed all missing projects they may begin working on their Final Projects!





The Lemonade Stand


You are being asked to create a successful company selling lemonade.  
Over the next few weeks you will be completing the following tasks.

  1. Creating a Company Name and Logo ……………………….… 5 Points


  1. Doing Market Research to discover perfect recipe ………….…...  5 Points


  1. Creating a Business Plan in Word……………..t ………………… 5 Points


  1. Creating a Sales Chart for 6 Weeks of Sales in Excel…... ……...  5 Points


  1. Scatter Plot in Excel for 6 weeks of sales …………...…………... 5 Points


  1. Creating an Advertising Campaign for your Product …………… 5 Points


  1. 3D Model of Lemonade Stand in Sketchup………………. …… 5 Points


  1. 5 minute Business Plan Presentation to Class in Powerpoint..... 5 Points


  1. Professionalism …………………………………………………... 10 Points


______________________________________________________________

Total Points Possible …………………………………………………    … 50 Points


THE LEMONADE STAND MARKET RESEARCH LINK

FULL LEMONADE STAND MARKET RESEARCH TEMPLATE

Wednesday, May 11, 2016

Codecademy and HTML Programming


We will be using Codecademy to learn our html coding.

Students must register for an account first before proceeding.

CLICK HERE TO GO TO COURSE

After being directed to the website you must click on Sign Up.

Use your OFFICE 365 EMAIL accounts

Copy and paste Each Chapters code into a word document after you have completed the chapter.  

Send me the completed Word Document with all of the Code when you are done with the entire set!

It should look like the example below.

Codecademy

Chapter 1 Code

<!DOCTYPE html>
<awesome>Feel free to change this text.</awesome>

Chapter 2 Code..
   

Monday, May 9, 2016

Finishing Powerpoint, Moving into the World of Business

Today the students will be starting the end of their Powerpoint modules.  They will be completing their Final Project.

Final Project Document Click Here

Book Stack Picture Click Here

POWERPOINT Starter Click Here (MAKE SURE TO SAVE IT AS YOUR OWN PROJECT BEFORE EDITING)

Instructions for the project are below.



PowerPoint 2013 Advanced Project


In this assignment, you will use PowerPoint 2013 to modify an existing PowerPoint presentation about your Computer Applications Class.
Complete the steps below in order, one at a time. Please make only the changes listed in the instructions. When you're done, save the file and submit your PowerPoint to the Blackboard Project link.
Instructions
1.    Download and save the presentation: 
PowerPoint 2013 Advanced Project Start.pptx
Note: if you see a yellow bar at the top of your document titled "Protected View," be sure to click the "Enable Editing" button, so you can complete the assignment.
2.    Save your blank document to your Unit_11, PowerPoint Folder, with the file name:
PowerPoint_Advanced_Project_YourLastName
(The computer will add .pptx for you to complete your save correctly)
  1. On slide 1, in the lower text box, type in your first and last name, your school name (ex. Sacajawea Middle School) and today’s date below the name (give month, day and year).
    • HINT: When you are finished the words your name, school name and date should be replaced with the information you were asked to type.
  2. On slide 2, select the picture and then apply the Reflected Bevel, Black picture style from the Picture Styles group on the Format tab.
    • HINT: Hover the mouse over the picture styles to see the style name.
  3. Select the Book_Stack.png then copy and paste it to your computer desktop.
  4. On slide 4, click the insert picture command in the placeholder on the left.  Choose the Book_Stack.png, located on your computer desktop.
  5. Once the Book Stack image is placed into your Powerpoint presentation, delete it from your computer desktop.
  6. On slide 4, click the Table command in the placeholder on the right. Insert a table with 2 columns and 6 rows.
  7. Type the following text into the table, with Periods in the left column and times in the right column:
Period 1
      9:15 - 10:10
Period 2
    10:15 – 11:05
Period 3
    11:10 – 12:00
Period 4
     12:30 – 1:20
Period 5
      1:25 – 2:15
Period 6
      2:20 – 3:15
  1. Select the top row of the table and then insert a row above it.
  2. Select both cells in the row you just inserted and then use the Merge Cells command on the Table Tools Layout tab. When you're done, the top row should contain only one cell.
    • HINT: Be sure to select both cells in the row before using the Merge Cells command.
  3. In the cell you just merged, type "My Schedule".
  4. Center align ALL the text in the table.
  5. Select the table and apply the Dark Style 1 - Accent 1 table style from the Table Styles group on the Table Tools Design tab. Do not leave the table in the default table style.
  6. On slide 5, click below the words “One of my strengths:” and type in one of your strengths in your Math class.  Do the same for “One of my struggles:”
  7. On slide 5, click the Chart command in the placeholder on the right.
  8. Select the Pie category and then select the 3D Pie chart. (It should not be the default pie chart.)
  9. spreadsheet will appear in a new window. Next, type the following cell content in the specified cells of the spreadsheet:
    • A2: Tests
    • A3: Quizzes
    • A4: Homework
    • A5: Classwork
    • B1: Grading Categories
    • B2: 60%
    • B3: 30%
    • B4: 5%
    • B5: 5%
    • HINT: If you're not sure how to enter information into a spreadsheet, review the Cell Basics Excel 2013 tutorial.
  10. Click the X in the top-right corner of the spreadsheet to close the spreadsheet window. Select the chart. Next, use the Quick Layout command on the Chart Tools Design tab to apply Layout 6.
    • HINT: Hover the mouse over the layouts to see the layout name.
  11. On slide 6, click below the words “One of my strengths:” and type in one of your strengths in your Science class.  Do the same for “One of my struggles:”

  12. On slide 6, click the Online Pictures command and type in “science test tubes” in the search box.  Choose the image that looks exactly like this:

  1. On slide 7, click below the words “One of my strengths:” and type in one of your strengths in your Computer Applications class.  Do the same for “One of my struggles:”
  2. On slide 7, click the SmartArt command in the placeholder.
  3. Select the List category and then select the Vertical Box List SmartArt graphic.
    • HINT: Hover the mouse over the SmartArt graphics to see the SmartArt name. You may have to scroll down to find the correct layout.
  4. Locate the Text pane on the left side of the SmartArt graphic (this is a small box that has an arrow pointing left). If it isn't visible, click the small arrow on the left of the SmartArt graphic to open it. Once you have located the the text pane, delete all of the placeholder text.
    • HINT: Once you've deleted the text, there should only be one large SmartArt shape.
  5. Open the document titled “Advanced Project Slide 7 Text”.
  6. Select all the text on the page that appears and then copy it to your clipboard.
    • HINT: Once you've selected the text, you can press Ctrl+C on your keyboard to copy it. Alternatively, you can select the text, right-click the mouse, and then select Copy.
  7. Select the SmartArt Text pane and then paste the text from your clipboard. When you're done, the SmartArt should have separate shapes.
    • HINT: You can use the Paste command on the Home tab or press Ctrl+V on your keyboard.
  8. Close the Text pane. Next, select the shape that begins with "Employability Skills" and then use the commands in the Create Graphic group on the SmartArt Tools Design tab to move the shape down.
    • HINT: Be sure to select the entire shape (not individual text boxes within the shape) by clicking the edge of the shape.
    • HINT: When you're done, the "Employability Skills" shape should appear below the "keyboarding Skill Development" shape.
  9. Select the entire SmartArt graphic and then change the colors to Colorful Range - Accent Colors 4 to 5.
    • HINT: Hover the mouse over the colors to see the color name.
    • HINT: When you're done, the SmartArt will be in yellow, green and blue title boxes. All other information will be in white text boxes with colored borders.
  10. Select the Review tab and then use the Spelling command to correct any of your own spelling errors, along with the following errors:
    • "strenght" should be changed to "strength"
    • "Sience" should be changed to "Science"
    • "Curricullum" should be changed to "Curriculum"
  11. Ignore the spelling suggestions for specific names.  These include words like:
    • Names of schools
    • Names of people
  12. Select Slide 8, which is titled “Questions?”   Select the word “Goals” directly below the first picture of books and insert a hyperlink that links to slide 3 of your presentation.
  13. On the same slide select each of the other pictures of books above each title and create the following hyperlinks for each page:
Schedule
Slide 4
Period 1
Slide 5
Period 2
Slide 6
Period 3
Slide 7

  1. Test your hyperlinks to be sure that you are taken to the correct slides in your PowerPoint Presentation, from your final slide.
  2. Double check all your instructions to see that you have completed all steps.
  3. Save your presentation again, then close PowerPoint. 
  4. Once closed, submit your completed presentation to the PowerPoint Intermediate Project Assignment link in Blackboard for assessment by your teacher.






Wednesday, May 4, 2016

Finishing the Power Point Intermediate Modules



Module 7- Modifying Themes

Click Here for Walk Through and Assignment





Module 8 - Inserting Videos

Click Here for Walk Through and Assignment






Module 9 - Inserting Audio

Click Here for Walk Through and Assignment






FINAL PROJECT INTERMEDIATE POWERPOINT


Click Here for the Downloaded Presentation -  MUST CLICK SAVE AS and GIVE NEW NAME

Instructions are Below


PowerPoint 2013 Intermediate Project
In this assignment, you will use PowerPoint 2013 to modify an existing PowerPoint presentation about Spokane Public Schools STEM Camps.
Complete the steps below in order, one at a time. Please make only the changes listed in the instructions. When you're done, save the file and submit your PowerPoint to the Blackboard Project link.

Instructions
1.    Download and save the presentation: 
PowerPoint 2013 Intermediate Project Start.pptx
Note: if you see a yellow bar at the top of your document titled "Protected View," be sure to click the "Enable Editing" button, so you can complete the assignment.
2.    Save your blank document to your Unit_10, PowerPoint Folder, with the file name:
PowerPoint_Intermediate_Project_YourLastName
(The computer will add .pptx for you to complete your save correctly)
3.    Select the Design tab. Next, click the drop-down arrow in the Variants group and change the Theme Colors to Violet II.
Change the Theme Fonts to Arial Black - Arial.
    • HINT: You will need to scroll down to see the Arial Black – Arial Theme Fonts set.
  1. On slide 1, select the words "2014 Summer STEM Camps." Click the Format tab, and then apply the Word Art style Fill – Lavender, Background 2, Inner Shadow.
    • HINT: Hover the mouse over the Word Art styles to see the style name.
  2. Select the words "JOIN IN THE FUN FOR MIDDLE SCHOOL STUDENTS!". Next, click the Animations tab, and then apply a Spin animation from the Emphasis group.
    • HINT: You will need to click the More drop-down arrow in the Animations group to find this animation.
6.    On slide 2, select all the text on the right and apply bullets to the 4 items.  Next, select the bulleted items and change the bullets to Star bullets.
    • HINT: When you're done, all the bulleted items should use the Star Bullet shape.
7.    On slide 3, select the bulleted items and change the bullets to Star bullets.
  1. On slide 4, use the Tab key to indent all of the bulleted items.
  2. Select the bulleted items you just indented and then change the bullet style for all items to use the Star bullets.
  3. On slide 5, select the picture. (This image shows video camera with a long lens). Next, use the Rotate command on the Format tab to Flip Horizontal.
    • HINT: When you're done, the video camera will be pointed toward the right side of the screen.
  4. With the picture still selected, click the Crop command and then choose Crop to Shape to crop the image to the Snip Diagonal Corner Rectangle shape.
    • HINT: Hover the mouse over the shapes to see the shape name.
    • HINT: When you're done, the bottom-right and top-left corners of the picture will be removed.
  5. On slide 6, select the cone image in the center of the 3 shapes.
  6. Use the Color command on the Format tab to recolor to Purple, Accent color 2 Dark When you're done, the cone should be purple.
  7. Select all three shapes on the slide at the same time. Then, use the Align command on the Format tab to Align Center.
    • HINT: To select more than one object at the same time, press and hold the Shift key on your keyboard and then click each object. You can also click and drag your mouse to form a selection box around the objects.
    • HINT: When you're done, the top edge of each picture will be lined up with the other pictures. Be sure to use the Align command on the Format tab, not the Text Alignment commands on the Home tab.
  8. With the pictures still selected, use the Align command on the Format tab to Distribute Vertically. When you're done, the middle shape will be exactly between the other shapes above and below.
  9. Group the pictures.
  10. Select the grouped pictures. (You should only have to click once to select all three.) Use the Align command on the Format tab to Align Middle.
    • HINT: When you're done, all three shapes will be moved down slightly to the middle of the slide.
  11. On slide 7, use the Shapes command on the Insert tab and select the Folded Cornerhttp://assets.gcflearnfree.org/topics/Keys/folded_corner_shape.png. Next, click, hold, and drag your mouse to draw the shape onto the slide, directly over the black text, so that all the text is covered.
    • HINT: Hover the mouse over the shapes to see the shape name. The Folded Corner is in the Basic Shapes group, next to the Smiley Face. If you do this correctly, all black text will be covered by a plum colored, folded corner shape.
  12. Select the shape, then click the Send Backward command on the Format tab and select Send to Back.
  13. Move the shape so that the text in the textbox is centered.  This text begins with the words "To register online...".
  14. Resize the shape so that all the text fits within the shape.
    • HINT: When you're done, all of the text should appear on top of the shape. It should look like a handwritten note.
  15. Select the shape and then apply the following Shape Style from the Format tab: Subtle Effect - Plum, Accent 1.
    • HINT: Hover the mouse over the Shape styles to see the style name.
  16. Save your presentation again, then close PowerPoint. 
  17. Once closed, submit your presentation to the PowerPoint Intermediate Project Assignment link in Blackboard for assessment by your teacher.





Tuesday, May 3, 2016

Powerpoint Intermediate Continued....

Students who have not finished the ADVANCED MODULE of typing.com will continue to type for 10 minutes at the beginning of class.

Students will then begin to work on their next set of modules.

WHEN COMPLETE EMAIL OR SHARE ALL WORK TO

MICHAELR@SPS81.ORG OR STEVENC@SPOKANESCHOOLS.ORG

Module 4 - Word Art

Click Here for the Walk Through and Assignment





Module 5 - Arranging Objects

Click Here for the Walk Through and Assignment








Module 6 - Animating Text Objects

Click Here for Walk Through and Assignment




 BONUS PROJECT WORTH 10 EXTRA CREDIT POINTS!!!!


Make a 10 Slide Animation using the tutorial below!



Monday, May 2, 2016

Power Point Intermediate Modules Begin!


Today the students will begin their day with their normal tasks.

10 minutes of typing

Typing.com

Then they will start to work on their powerpoint Intermediate Modules

SHARE ON ONE DRIVE OR EMAIL PROJECTS TO

michaelr@sps81.org or stevenc@spokaneschools.org

Module 1 - Formatting Pictures

Click Here for Walk Through and Assignment






Module 2 - Lists

Click Here for Walk Through and Assignment





Module 3 - Indents and Line Spacing

Click Here for Assignment and Walk Through