Day 53 to 54 Sheets Store Project

Sheets Store Project

Day 53 to 54: Spreadsheets Day 5

• Spreadsheets Unit Review
• Turn work in using the Assignment Submission Form 
• DUE 4/6/20: Spreadsheet Unit Review 

Day 51 to 52: Spreadsheets Day 4

• Make a copy of Lesson 3.6 Template
• Complete Spreadsheets Lesson 3.6
• if necessary, view the 3.6 Step-by-step Instructions
• Make a copy of Lesson 3.7 Template
• Complete Spreadsheets Lesson 3.7
• if necessary, view the 3.7 Step-by-step Instructions
• Turn work in using the Assignment Submission Form
  • DO NOT SHARE IT WITH ME
    • DUE TODAY: 3.5-3.7
• Watch the Day 5 eLearning Video 
• Wash your hands before and after each lesson.

Day 49 to 50: Spreadsheets Day 3

• Watch these videos and take notes as you watch.
  • Creating Charts
• Review this Graphing Presentation
• Make a copy of Lesson 3.4 Template
• Complete Spreadsheets Lesson 3.4
• View the 3.4 Step-by-step instructions if needed
• Make a copy of Lesson 3.5 Template
• Complete Spreadsheets Lesson 3.5
• View 3.5 Step-by-step instructions if needed
• Turn work in using the Assignment Submission Form
  • DO NOT SHARE IT WITH ME
    • DUE TODAY: 3.1-3.4
• Watch the Day 4 eLearning Video

Day 47: Spreadsheet Formatting

Column Headings - Bold and Underline
Title - Bold, Larger, Merged and Centered
Totals - single line above, double line below

Consider black fill and white text for headings and titles

Day 47 to 48: Spreadsheets Day 2

• Watch these videos and take notes as you watch.
  • Simple Formulas
  • Complex Formulas
  • Using Functions
• Make a copy of 3.2 Template
• Complete Spreadsheet Lesson 3.2
• View 3.2 Step-by-step instructions if needed
• Make a copy of 3.3 Template
• Complete Spreadsheets Lesson 3.3
• View 3.3 Step-by-step instructions if needed
• Turn work in using the Assignment Submission Form
  • DO NOT SHARE IT WITH ME
• Watch the Day 3 E-Learning Video

Day 45: Intro to Spreadsheets

• Spreadsheets are used to track and analyze data
• Made up of Rows and Columns
• Intersection of rows and columns is a cell
• Each cell has a unique cell address
• 4-line title
• Who 
• What
• When
• By:
• Use formulas and functions to do calculations
• formulas with relative references can be copied
• copy and paste
• auto-fill handle

Day 45 to 46: Intro to Spreadsheets

• Watch these videos and take notes as you watch.
• Getting Started with Google Sheets 
• Modifying Cells
• Formatting Cells
• Complete Spreadsheets Lesson 3.1
• Turn work in using the Assignment Submission Form
• DO NOT SHARE IT WITH ME

Day 44: Intro to Extended E-Learning

Please go through this presentation that you should have received from your Period 2 teacher.

 

Please email me with any questions or concerns.

Day 45 to 48 - Continue Showcase Website

Typing Club

• Complete daily practice in Typing Club using proper technique (remember to focus on how you type, not how well). Work on one lesson for 5 to 10 minutes repeatedly, each day

Weebly

• Showcase Website / Digital Portfolio
• What is the Purpose of a Showcase Website?
• To enhance your digital footprint and build your Personal Brand, a showcase website can be used as a one-stop shop for your positive Digital Footprint. Whether you are writing a college entrance essay, writing a resume or interviewing for a job, you MUST make yourself stand out from everyone else.
• This project is going to help you do that in the form of a Showcase Website.  A Showcase Website allows you to showcase your experiences, achievements, abilities, passions, and future plans in a creative online platform.  You will be creating and publishing your first Showcase Website.
• What is a Showcase Website? Read to find out more... 
• Explanation of a Showcase Website (Digital Portfolio) 
• Creative Educator (Digital Portfolios)
• What does a Showcase Website look like? 
• For Digital Literacy students, a Showcase Website is a good way to start a positive digital footprint and get your high school career off to a great start! Below is a link to a sample website you can use as an example. Your website should include many of the aspects you see here: 
• Cora Baker
• How do I create a Showcase Website? 
• Go to Weebly (or another web authoring tool) and create an account. Use your professional gmail address and password so it is easy to remember. Select a free URL that includes your brand name 
• A consistent, professional brand name across platforms helps you stay memorable: 
• CoraBak2.weebly.com 
• CoraBak2@gmail.com 
• Twitter.com/CoraBak2 
• Add pages for Home, About, Contact, Portfolio 
• Add content to the Home page 
• Make your name stand out 
• Add a button to link to your About page 
• Include your personal statement
• Consider creating a welcome video for this page 
• Create an About page with your professional picture, activities, and honors 
• School, Extracurricular Activities, Volunteering, Honors & Awards 
• Skills & Languages 
• What programs and/or applications would you say you are proficient at? 
• What computer skills do you have to offer at this point in your career? 
• Soft skills developed 
• Include information on soft skills you developed thus far such as communication, time management, collaboration, etc. 
•  Check out a list of soft skills HERE. 
• Add pictures that relate to the different activities 
• Consider adding an About Me Video
• Create a Contact page with links to Gmail, Twitter, YouTube, Blogger, (and LinkedIn if you are at least 16 yrs old) 
• Use images as links to your professional social media accounts 
• Create a Portfolio page with links to examples of your work 
• Performance videos 
• plays, sports, concerts, speeches, service projects, etc... 
• Evidence of your writing 
• School projects of which you are proud 
Set Up Instructions
Layout Guidelines

THINGS YOU SHOULD KNOW BY NOW

• Six Ps of Success
• Touch Typing Technique
• Trouble Shooting Your Chromebook
• Online Organization
• Organizing Your Drive
• Sharing Files in Google Apps
• Setting Up Your Calendar
• Professional Email Format
• Basic Computer Parts
• Design Principles
• How to Deliver a Presentation
• Digital Citizenship

Comprehension Checks:

• (Please note these are only practice. Also, it may count your answer wrong if you don't spell it the same way I do.... don't worry, the point is just so YOU can check your comprehension of the material.)
• Success Skills
• Touch Typing
• File Management
• Computer Components
• E-mail
• Design Principles
• Delivering a Presentation
• Copyrights and Plagiarism
• Online Safety

THINGS THAT SHOULD BE DONE ALREADY:

• PencilCode House Assignment
• Save your file
• click Share
• Copy the "See it Here Code" URL
• turn in to the Assignment Submission Form
• Turn in Worksheets using the Assignment Submission Form:
• student biography
• Success Skills
• Drive
• Online Organization
• Sharing Files
• Calendar Worksheet
• Gmail worksheet
• Delivering a Presentation Worksheet
• Copyrights Worksheet
• Digital Citizenship Review Worksheet
• Gmail Assignment
• Follow these email tips to compose a properly formatted, professional e-mail to your teacher that explains how being organized can help you in the workplace.
• as an alternative, you can watch Use What You've Got.... or lose it! and tell your teacher about the video in the body of your email.
• Presentation Assignments
• Person Place or Thing Assignment
• example of person slides and place slides
• Personal Brand Presentation.
• CyberBullying
• Watch the the videos:
• "Stacey's Story -- When Rumors Escalate"
• Is Ricardo a Cyberbully?
• Use information from the videos above and the Stop Bullying website to complete and submit the Cyberbullying Notes

ON-GOING ASSIGNMENTS:

• Online Organization
• organize your Drive using folders and naming conventions
• Google Calendar
• update your calendar with important events
• Gmail
• use labels to achieve zero-inbox
• Watch this video and create a signature line for your gmail account.
• Personal Brand Presentation
• Finish and submit your Personal Brand Presentation.
• start simple and build from there
• you can always go back and make it "better"
• follow the design principles
• eye-pleasing contrasting colors
• 5x5
• simple fonts (30 pt for body, 36 pt for titles)
• font pairs that work together (avoid cursive fonts)
• use text emphasis
• example
• Build Your Brand
• add your professional photo to all of your online accounts
• As time allows, make a copy of this helpful document and start preparing for your future by:
• Creating your Resume
• Learning who you are: 
• Skills
• Interests
• Values (online assessment)
• Goals
• Personality
• Knowing what you do: 
• Special Classes
• Sports, Clubs, Other School Activities
• Work Experience
• Honors, Awards, Leadership
• Preparing a general Cover Letter
• Creating a list of your Network of Contacts:
• What kind of people do you have your network?
• The goal is establish quality relationships with others in your industry that you can potentially leverage, and create visibility for yourself.
• EverFi Ignition
• continue where you left off at Everfi.com
• PencilCode.net 
• Continue in the PencilCode guide 
• Work on completing each of the assignments beginning on page 9 of the guide
• move through the guide at your own pace, as time allows
• Showcase Website / Digital Portfolio
• set up showcase website in Weebly
• Log into your Weebly account 
• Add pages for Home, About, Contact, Portfolio 
• Add content to the Home page 
• Make your name stand out 
• Add a button to link to your About page 
• Include your personal statement
• Consider creating a welcome video for this page 
• Create an About page with your 
• professional picture
• activities
• honors
• School
• Extracurricular Activities 
• Volunteering 
• Skills & Languages 
• What programs and/or applications would you say you are proficient at? 
• What computer skills do you have to offer at this point in your career? 
• Soft skills developed 
• Include information on soft skills you developed thus far such as communication, time management, collaboration, etc. 
•  Check out a list of soft skills HERE. 
• Add pictures that relate to the different activities 
• Consider adding an About Me Video
• Create a Contact page with links to Gmail, Twitter, YouTube, Blogger, and LinkedIn
• Use images as links to your professional social media accounts 
• Create a Portfolio page with links to examples of your work 
• Performance videos 
• plays, sports, concerts, speeches, service projects, etc... 
• Evidence of your writing 
• School projects of which you are proud 
• Optional Twitter Activities
• Go to Twitter
• Add an appropriate profile picture
• Add a short bio about yourself. Include items such as:
• Interests
• Extracurriculars/Sports
• Goals
• Begin developing a professional learning network (PLN). Do so by following people and organizations that relate to school, examples include:
• Teachers
• Classmates
• Leyden Affiliated
• @MrHaworth212
• @WestLeydenFBLA
• @TBonuma
• @JasonMMarkey
• Social Media Campaign (Optional)
• Review this document for completeness of your profile.

Optional LinkedIn Profile (if over 16 yrs old)

• Create a LinkedIn Account
• Complete the basic information 
• Upload a professional picture 
• Update your public profile settings to create a custom URL for your profile 
• Create a link to your LinkedIn profile from your Weebly website 
• Read the article about how to write the perfect LinkedIn summary
• Write your LinkedIn summary

Day 67 to 70: Continue Showcase Website

Typing Club

• Complete daily practice in Typing Club using proper technique (remember to focus on how you type, not how well). Work on one lesson for 5 to 10 minutes repeatedly, each day

Weebly

• Showcase Website / Digital Portfolio
• What is the Purpose of a Showcase Website?
• To enhance your digital footprint and build your Personal Brand, a showcase website can be used as a one-stop shop for your positive Digital Footprint. Whether you are writing a college entrance essay, writing a resume or interviewing for a job, you MUST make yourself stand out from everyone else.
• This project is going to help you do that in the form of a Showcase Website.  A Showcase Website allows you to showcase your experiences, achievements, abilities, passions, and future plans in a creative online platform.  You will be creating and publishing your first Showcase Website.
• What is a Showcase Website? Read to find out more... 
• Explanation of a Showcase Website (Digital Portfolio) 
• Creative Educator (Digital Portfolios)
• What does a Showcase Website look like? 
• For Digital Literacy students, a Showcase Website is a good way to start a positive digital footprint and get your high school career off to a great start! Below is a link to a sample website you can use as an example. Your website should include many of the aspects you see here: 
• Cora Baker
• How do I create a Showcase Website? 
• Go to Weebly (or another web authoring tool) and create an account. Use your professional gmail address and password so it is easy to remember. Select a free URL that includes your brand name 
• A consistent, professional brand name across platforms helps you stay memorable: 
• CoraBak2.weebly.com 
• CoraBak2@gmail.com 
• Twitter.com/CoraBak2 
• Add pages for Home, About, Contact, Portfolio 
• Add content to the Home page 
• Make your name stand out 
• Add a button to link to your About page 
• Include your personal statement
• Consider creating a welcome video for this page 
• Create an About page with your professional picture, activities, and honors 
• School, Extracurricular Activities, Volunteering, Honors & Awards 
• Skills & Languages 
• What programs and/or applications would you say you are proficient at? 
• What computer skills do you have to offer at this point in your career? 
• Soft skills developed 
• Include information on soft skills you developed thus far such as communication, time management, collaboration, etc. 
•  Check out a list of soft skills HERE. 
• Add pictures that relate to the different activities 
• Consider adding an About Me Video
• Create a Contact page with links to Gmail, Twitter, YouTube, Blogger, (and LinkedIn if you are at least 16 yrs old) 
• Use images as links to your professional social media accounts 
• Create a Portfolio page with links to examples of your work 
• Performance videos 
• plays, sports, concerts, speeches, service projects, etc... 
• Evidence of your writing 
• School projects of which you are proud 
Set Up Instructions
Layout Guidelines

THINGS YOU SHOULD KNOW BY NOW

• Six Ps of Success
• Touch Typing Technique
• Trouble Shooting Your Chromebook
• Online Organization
• Organizing Your Drive
• Sharing Files in Google Apps
• Setting Up Your Calendar
• Professional Email Format
• Basic Computer Parts
• Design Principles
• How to Deliver a Presentation
• Digital Citizenship

Comprehension Checks:

• (Please note these are only practice. Also, it may count your answer wrong if you don't spell it the same way I do.... don't worry, the point is just so YOU can check your comprehension of the material.)
• Success Skills
• Touch Typing
• File Management
• Computer Components
• E-mail
• Design Principles
• Delivering a Presentation
• Copyrights and Plagiarism
• Online Safety

THINGS THAT SHOULD BE DONE ALREADY:

• PencilCode House Assignment
• Save your file
• click Share
• Copy the "See it Here Code" URL
• turn in to the Assignment Submission Form
• Turn in Worksheets using the Assignment Submission Form:
• student biography
• Success Skills
• Drive
• Online Organization
• Sharing Files
• Calendar Worksheet
• Gmail worksheet
• Delivering a Presentation Worksheet
• Copyrights Worksheet
• Digital Citizenship Review Worksheet
• Gmail Assignment
• Follow these email tips to compose a properly formatted, professional e-mail to your teacher that explains how being organized can help you in the workplace.
• as an alternative, you can watch Use What You've Got.... or lose it! and tell your teacher about the video in the body of your email.
• Presentation Assignments
• Person Place or Thing Assignment
• example of person slides and place slides
• Personal Brand Presentation.
• CyberBullying
• Watch the the videos:
• "Stacey's Story -- When Rumors Escalate"
• Is Ricardo a Cyberbully?
• Use information from the videos above and the Stop Bullying website to complete and submit the Cyberbullying Notes

ON-GOING ASSIGNMENTS:

• Online Organization
• organize your Drive using folders and naming conventions
• Google Calendar
• update your calendar with important events
• Gmail
• use labels to achieve zero-inbox
• Watch this video and create a signature line for your gmail account.
• Personal Brand Presentation
• Finish and submit your Personal Brand Presentation.
• start simple and build from there
• you can always go back and make it "better"
• follow the design principles
• eye-pleasing contrasting colors
• 5x5
• simple fonts (30 pt for body, 36 pt for titles)
• font pairs that work together (avoid cursive fonts)
• use text emphasis
• example
• Build Your Brand
• add your professional photo to all of your online accounts
• As time allows, make a copy of this helpful document and start preparing for your future by:
• Creating your Resume
• Learning who you are: 
• Skills
• Interests
• Values (online assessment)
• Goals
• Personality
• Knowing what you do: 
• Special Classes
• Sports, Clubs, Other School Activities
• Work Experience
• Honors, Awards, Leadership
• Preparing a general Cover Letter
• Creating a list of your Network of Contacts:
• What kind of people do you have your network?
• The goal is establish quality relationships with others in your industry that you can potentially leverage, and create visibility for yourself.
• EverFi Ignition
• continue where you left off at Everfi.com
• PencilCode.net 
• Continue in the PencilCode guide 
• Work on completing each of the assignments beginning on page 9 of the guide
• move through the guide at your own pace, as time allows
• Showcase Website / Digital Portfolio
• set up showcase website in Weebly
• Log into your Weebly account 
• Add pages for Home, About, Contact, Portfolio 
• Add content to the Home page 
• Make your name stand out 
• Add a button to link to your About page 
• Include your personal statement
• Consider creating a welcome video for this page 
• Create an About page with your 
• professional picture
• activities
• honors
• School
• Extracurricular Activities 
• Volunteering 
• Skills & Languages 
• What programs and/or applications would you say you are proficient at? 
• What computer skills do you have to offer at this point in your career? 
• Soft skills developed 
• Include information on soft skills you developed thus far such as communication, time management, collaboration, etc. 
•  Check out a list of soft skills HERE. 
• Add pictures that relate to the different activities 
• Consider adding an About Me Video
• Create a Contact page with links to Gmail, Twitter, YouTube, Blogger, and LinkedIn
• Use images as links to your professional social media accounts 
• Create a Portfolio page with links to examples of your work 
• Performance videos 
• plays, sports, concerts, speeches, service projects, etc... 
• Evidence of your writing 
• School projects of which you are proud 
• Optional Twitter Activities
• Go to Twitter
• Add an appropriate profile picture
• Add a short bio about yourself. Include items such as:
• Interests
• Extracurriculars/Sports
• Goals
• Begin developing a professional learning network (PLN). Do so by following people and organizations that relate to school, examples include:
• Teachers
• Classmates
• Leyden Affiliated
• @MrHaworth212
• @WestLeydenFBLA
• @TBonuma
• @JasonMMarkey
• Social Media Campaign (Optional)
• Review this document for completeness of your profile.

Optional LinkedIn Profile (if over 16 yrs old)

• Create a LinkedIn Account
• Complete the basic information 
• Upload a professional picture 
• Update your public profile settings to create a custom URL for your profile 
• Create a link to your LinkedIn profile from your Weebly website 
• Read the article about how to write the perfect LinkedIn summary
• Write your LinkedIn summary