Download your own copy of MS Office 2013 at HOME!!!

Google Classroom Link to Period 1 Class Code of6ewi
Google Classroom Link to Period 2 Class Code 8k6tvk
Google Classroom Link to Period 4 Class Code wzrjy3
Google Classroom Link to Period 7 Class Code pabclc
Google Classroom Link to Period 8 Class Code p2q0oly
Link to Google Drive

Please use the writing supports in the Google Classroom as necessary. Check them out!

Wednesday May 31st at 3pm - All Late work is DUE!! You MUST send me an email telling me what you finished or I will not know to grade it!!! Missing work includes (but is not limited to):

  • Fast Forward 10 Years (presentation slides or PowerPoint)
  • Job Application (link)
  • Resume (templates from Career Resources on the left)
  • Grades signature form (parent/guardian signature)
  • Anything else marked MISSING in Infinite Campus (Student/Parent Portal)

May 25/26, 2017

Standard

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use technology to increase the effectiveness of communications.

Objectives

Students will be able to analyze data and create information demonstrating their learning of MS Word, Excel, and PowerPoint and formulas by researching, creating, and presenting information about the value of a college education using the Internet, MS Excel, MS Word, MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
Success Indicators
  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • use the Internet for research and documenting where you obtained the information.
    • answer the following questions:
      • what is the financial and social value of education?
      • where can I obtain a college degree?
      • what will it costs
    • present your findings to the class

Do Now - Always be prepared to discuss!!

No Do Now

Agenda

Today you will be presenting your final presentations. Please DO NOT login!

May 10 - 19, 2017

Final Project Work

Standard

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use technology to increase the effectiveness of communications.

Objectives

Students will be able to analyze data and create information demonstrating their learning of MS Word, Excel, and PowerPoint and formulas by researching, creating, and presenting information about the value of a college education using the Internet, MS Excel, MS Word, MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
Success Indicators
  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • use the Internet for research and documenting where you obtained the information.
    • answer the following questions:
      • what is the financial and social value of education?
      • where can I obtain a college degree?
      • what will it costs
    • present your findings to the class

Do Now - Always be prepared to discuss!!

No Do Now

Agenda

Mock Interviews/Thank you notes if you haven't done them already
Final project work (Final Project description)
Ask for help!
Timeline:
  • Spreadsheet due on May 12
  • Essay due May 17/18
  • Presentations due May 19

May 8/9, 2017 - Mock Interviews: TODAY!!! PROFESSIONAL DRESS

Standard

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use technology to increase the effectiveness of communications.

Objectives

Students will be able to analyze data and create information demonstrating their learning of MS Word, Excel, and PowerPoint and formulas by researching, creating, and presenting information about the value of a college education using the Internet, MS Excel, MS Word, MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
Success Indicators
  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • **You will be able to:
    • use the Internet for research and documenting where you obtained the information.
    • answer the following questions:
      • what is the financial and social value of education?
      • where can I obtain a college degree?
      • what will it costs
    • present your findings to the class

Do Now - Always be prepared to discuss!!

No Do Now

Agenda

Print resumes if you haven't already
Last minute prep for interviews
Interviews
Fill out self-assessment
Final project work (Final Project description)

May 5, 2017 - Mock Interviews: PERIOD 1 & 7 May 8th, PERIOD 4 & 8 May 9th, PROFESSIONAL DRESS

Standard

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use technology to increase the effectiveness of communications.

Objectives

Students will be able to analyze data and create information demonstrating their learning of MS Word, Excel, and PowerPoint and formulas by researching, creating, and presenting information about the value of a college education using the Internet, MS Excel, MS Word, MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
Success Indicators
  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • use the Internet for research and documenting where you obtained the information.
    • answer the following questions:
      • what is the financial and social value of education?
      • where can I obtain a college degree?
      • what will it costs
    • present your findings to the class

Do Now - Always be prepared to discuss!!

Read the following under the Interview Prep above:
  • Mock Interview Rubric
  • Mock Interview Questions (make sure you can answer all of them!)
  • Questions to Ask Interviewers (make sure you have two that you can ask)

Agenda

Print resumes if you haven't already
Final project work (Final Project description)

May 3/4, 2017 - Mock Interviews: PERIOD 1 & 7 May 8th, PERIOD 4 & 8 May 9th, PROFESSIONAL DRESS

Standard

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use technology to increase the effectiveness of communications.

Objectives

Students will be able to analyze data and create information demonstrating their learning of MS Word, Excel, and PowerPoint and formulas by researching, creating, and presenting information about the value of a college education using the Internet, MS Excel, MS Word, MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
Success Indicators
  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • use the Internet for research and documenting where you obtained the information.
    • answer the following questions:
      • what is the financial and social value of education?
      • where can I obtain a college degree?
      • what will it costs
    • present your findings to the class

Do Now

End-of-Year Goal Setting link - Please click on the link and answer the questions in the form. Thank you!

Agenda

Introduce final project (Final Project description)
Print resumes
Last minute prep for interviews
Final project work

May 1/2, 2017 - Mock Interviews: PERIOD 1 & 7 May 8th, PERIOD 4 & 8 May 9th, PROFESSIONAL DRESS

Standards

ESSK.09.03 Demonstrate skills related to seeking and applying for employment to find and obtain a desired job
Communicate information and ideas effectively to multiple audiences using a variety of media and formats.

Objectives

  • Students will be able to explore and describe the ways an individual can prepare for a job interview by completing a packet of information using:
    • Internet
    • Class information
    • Computer

Success Indicators

  • Packet completed

Do Now - Always be prepared to discuss!!

Answer in the Google classroom: Describe a time when you were impressed with someone you just met. What caused you to be impressed?

Agenda

Do Now Activity
Activity explanation: Packet on interview preparation
Work on packet

April 28, 2017 Period 7 and 8

Standard

Students will learn essential skills employers want.

Objectives

  • Students will be able to explore how to hunt for a job and analyze the tools needed for the job search by determining choices they can make to create a positive personal brand and following their JA individual, JA materials, directions and peer assistance.
  • Students will be able to solve work-base problems by using critical thinking skills using coaching from their JA individual, JA materials, directions and peer assistance.

Success Indicators

  • Projects completed

Do Now - Always be prepared to discuss!!

None today

Agenda

Finish past due work:
  • Fast Forward 10 Years PowerPoint
  • Resume
  • Job Application
  • Interview Tips presentation
If all those are done, take a 3 MINUTE typing test and then typing lessons.

Homework

None

April 28, 2017 Career Success: Junior Achievement Session 7 Periods 1, 2, 4

Standard

Students will learn essential skills employers want.

Objectives

  • Students will be able to explore how to hunt for a job and analyze the tools needed for the job search by determining choices they can make to create a positive personal brand and following their JA individual, JA materials, directions and peer assistance.
  • Students will be able to solve work-base problems by using critical thinking skills using coaching from their JA individual, JA materials, directions and peer assistance.

Success Indicators

  • Listened to JA coach
  • Completed all JA projects

Do Now - Always be prepared to discuss!!

None today

Agenda

Introduce JA coach
Session 1 - Career Success

Homework

None
April 26/27, 2017 - Mock Interviews PERIOD 1 & 7 May 8, PERIOD 4 & 8 May 9th, PROFESSIONAL DRESS

Standards

ESSK.09.03 Demonstrate skills related to seeking and applying for employment to find and obtain a desired job
Communicate information and ideas effectively to multiple audiences using a variety of media and formats.

Objectives

  • Students will be able to independently and collaboratively explore, understand and create a presentation that can be used to explain how to prepare for a job interview. The presentation will be well organized and contains no grammatical errors using:
    • Job Interview Strategies article
    • Class discussion
    • Computer

Success Indicators

  • PowerPoint created that explains how to prepare for a job interview.

Do Now - Always be prepared to discuss!!

Answer in the Google classroom: What does it mean to make a first impression. Write at LEAST 3 SENTENCES using proper grammar

Agenda

Do Now Activity
Activity explanation: Your school counseling department has asked you to prepare a presentation that can be used to explain how to prepare for a job interview. You will
read the article Job Interview Strategies for Teens: Part I — Interview Preparation and Google search other sources on how to prepare for a job interview. You will prepare a PowerPoint slide presentation including what you consider to be the most important tips. Upload your presentation to the assignment in Google Classroom.

April 24/25, 2017 - Mock Interviews PERIOD 1 & 7 May 8, PERIOD 4 & 8 May 9th, PROFESSIONAL DRESS

Standards

ESSK.09.03 Demonstrate skills related to seeking and applying for employment to find and obtain a desired job
Communicate information and ideas effectively to multiple audiences using a variety of media and formats.

Objectives

  • Students will be able to independently and collaboratively explore, understand and create a presentation that can be used to explain how to prepare for a job interview. The presentation will be well organized and contains no grammatical errors using:
    • Job Interview Strategies article
    • Class discussion
    • Computer

Success Indicators

  • PowerPoint created that explains how to prepare for a job interview.

Do Now - Always be prepared to discuss!!

No Do Now - Immediately finish your resume and job application and upload to the Google classroom. It is LATE!!!

Agenda

Do Now Activity
Activity explanation: Your school counseling department has asked you to prepare a presentation that can be used to explain how to prepare for a job interview. You will
read the article Job Interview Strategies for Teens: Part I — Interview Preparation and Google search other sources on how to prepare for a job interview. You will prepare a PowerPoint slide presentation including what you consider to be the most important tips. Upload your presentation to the assignment in Google Classroom.

April 21, 2017 - PERIOD 2 Mock Interviews April 25th, PROFESSIONAL DRESS

30 Minute Classes!

Standards

ESSK.09.03 Demonstrate skills related to seeking and applying for employment to find and obtain a desired job
  • ESSK.09.03.b Prepare a résumé.
  • ESSK.09.03.d Complete an employment application.
Communicate information and ideas effectively to multiple audiences using a variety of media and formats.

Objectives

  • Students will be able to independently create a job specific resume and employment application that includes prior work experience, volunteer work...etc. which is well organized and contains no grammatical errors using:
    • College in Colorado
    • Resume templates/examples
    • Computer

Success Indicators

  • Completed resume uploaded to the Google Classroom and saved to print.
  • Completed cover letter uploaded to the Google Classroom and saved to print.

Do Now - Always be prepared to discuss!!

No do now today!

Agenda

Do Now Activity
Finish Resume
Finish job application
  • If you finish early, go back to College in Colorado and work on a cover letter and upload to the Google classroom in this assignment.
PERIOD 2 ONLY - INTERVIEW PREPARATION
  • You will be graded on your interview skills by the volunteers interviewing you. They will fill out this mock interview rubric it is worth 25 points. Read over the expectations and devise a strategy to achieve the maximum points in each category. Following your interview you will complete a self-evaluation of your interview using this same form (this is 5 points of the total grade.)
    1. Prepare for Mock Interviews by finalizing and printing 3 copies of your resume and cover letter.
    2. Review the mock interview rubricto determine what you need to do during the interview.
    3. Use this list of Mock Interview Questions to help prepare for the interviews.
    4. Use this Interview Checklist to prepare for the interview.
    5. Interview Tips
    6. Questions to Ask Interviewers
    7. The job you will be interviewing for is with one of these three Job Ads . Spend some time researching this company to learn about what they do, their mission, values and the kind of jobs that are available.

April 19/20, 2017 - Period 2 Mock Interviews April 25th, PROFESSIONAL DRESS

Standards

ESSK.09.03 Demonstrate skills related to seeking and applying for employment to find and obtain a desired job
  • ESSK.09.03.b Prepare a résumé.
  • ESSK.09.03.d Complete an employment application.

Objectives

  • Students will be able to independently create a job specific resume and employment application that includes prior work experience, volunteer work...etc. which is well organized and contains no grammatical errors using:
    • College in Colorado
    • Resume templates/examples
    • Computer

Success Indicators

  • Completed resume uploaded to the Google Classroom and saved to print.
  • Completed job application uploaded to the Google Classroom and saved to print.

Do Now - Always be prepared to discuss!!

What three qualities do you think employers value the most in an employee? Explain your answer in the Google classroom.

Agenda

  • Do Now
  • Finish resumes (Periods 1 and 7 need to fix their job objectives!)
    • The job you will be interviewing for is with one of these three Job Ads .
      1. Spend some time researching this company to learn about what they do, their mission, values and the kind of jobs that are available.
      2. Pick the job you want to interview for and make an appropriate job objective for that specific job in your resume.
  • Read A Job-Seeker’s Guide to Successfully Completing Job Applications (link).
    • Using what you learned about job applications, you will complete the FBLA Job Application liked in Google Classroom.
    • This is for a fictional Management Trainee job at a fictional company, Merit Corporation.
    • When you are done, upload your completed job application to the Google Classroom assignment.
    • If you finish early, go back to College in Colorado and work on a cover letter and upload to the Google classroom in this assignment.
PERIOD 2 ONLY - INTERVIEW PREPARATION
  • You will be graded on your interview skills by the volunteers interviewing you. They will fill out this mock interview rubric it is worth 25 points. Read over the expectations and devise a strategy to achieve the maximum points in each category. Following your interview you will complete a self-evaluation of your interview using this same form (this is 5 points of the total grade.)
    1. Prepare for Mock Interviews by finalizing and printing 3 copies of your resume and cover letter.
    2. Review the mock interview rubricto determine what you need to do during the interview.
    3. Use this list of Mock Interview Questions to help prepare for the interviews.
    4. Use this Interview Checklist to prepare for the interview.
    5. Interview Tips
    6. Questions to Ask Interviewers
    7. The job you will be interviewing for is with one of these three Job Ads . Spend some time researching this company to learn about what they do, their mission, values and the kind of jobs that are available.

April 17/18, 2017 - Period 2 Mock Interviews April 25th, PROFESSIONAL Dress

Standards

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
ESSK.09.03 Demonstrate skills related to seeking and applying for employment to find and obtain a desired job
  • ESSK.09.03.b Prepare a résumé.

Objectives

  • In groups, students will be able to critique and modify PowerPoint slides using directions on the handout and oral and written directions, and discussions with peers.
  • Students will be able to independently create a job specific resume that includes prior work experience, volunteer work...etc. which is well organized and contains no grammatical errors using:
    • College in Colorado
    • Resume templates/examples
    • Computer

Success Indicators

  • Completed resume uploaded to the Google Classroom and saved to print.

Do Now - Always be prepared to discuss!!

Each of you will have a PowerPoint critique handout that you will be filling out. You will be working in teams and looking at PowerPoint slides. Your team will have to decide what you would modify on each slide and how you would fix it. Come up with as many modifications as you can in the time allotted for each slide. The Do Now is to discuss with your team how best to go about critiquing each slide. You can use the Word Wall to help you remember areas to critique. Link to Presentations Word Wall

Agenda

Do Now
Team Slide discussions
Introduction to resumes
  1. The job you will be interviewing for is with one of these three Job Ads .
    1. Spend some time researching this company to learn about what they do, their mission, values and the kind of jobs that are available.
    2. Pick the job you want to interview for and make an appropriate job objective for that specific job in your resume.
  2. Examples
Click on the Career Resources link in the upper left green box to get started on your resume.

April 14, 2017 Career Success: Junior Achievement Session 5

Standard

Students will learn essential skills employers want.

Objectives

  • Students will be able to create their own work environment priorities by following their JA individual, JA materials, directions and peer assistance.

Success Indicators

  • Listened to JA coach
  • Completed all JA projects

Do Now - Always be prepared to discuss!!

None today

Agenda

Session 5 - Know Your Work Priorities

Homework

None

April 13, 2017

Standards

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
    • Use a variety of computer software demonstrating a mastery of beginning workplace skills.
Demonstrate skills related to seeking and applying for employment to find and obtain a desired job.

Objectives

  • Students will be able to share and defend their opinion about whether PowerPoint helps people communicate more effectively using the language from class (presentation, slide, background, multimedia, movement, contrast, etc.) associated with using PowerPoint using MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
  • Students will be able to create PowerPoint presentations and apply PowerPoint skills and techniques learned in class using MS PowerPoint, oral and written directions, and peer assistance.

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create multimedia presentations with information, pictures, backgrounds, and animation.
    • Follow directions on the handouts to create presentations.
    • Understand how you can use PowerPoint and how it is used in the business world.

Do Now - Always be prepared to discuss!!

Think-Pair-Share - In the THINK section of the T-P-S sheet answer the following: Do you agree with the statement PowerPoint helps people communicate more effectively. Answer why or why not. Write at least 3 full sentences using proper grammar. Use words from our word wall in your sentences.
Link to Presentations Word Wall

Agenda

Do Now Activity
Review
Project 9 - Present It!
  • Continue working on the presentation then have a peer check what you have done. Once you are finished please upload to the classroom.
Last 10 minutes of class: Have one of your peers look at your presentation for spelling, grammar, and the requirements before you turn it into the classroom.

April 12, 2017 - Blue Day 30 minutes

Standards

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
    • Use a variety of computer software demonstrating a mastery of beginning workplace skills.
Demonstrate skills related to seeking and applying for employment to find and obtain a desired job.

Objectives

  • Students will be able to critique their peers in-progress presentation using directions on the Presentation Round Robin sheet and MS PowerPoint, oral and written directions, and teacher-made examples.
  • Students will be able to create PowerPoint presentations and apply PowerPoint skills and techniques learned in class using MS PowerPoint, oral and written directions, and peer assistance.

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create multimedia presentations with information, pictures, backgrounds, and animation.
    • Follow directions on the handouts to create presentations.
    • Understand how you can use PowerPoint and how it is used in the business world.

Do Now - Always be prepared to discuss!!

Open your presentation #9.
Write your name on the Presentation Round Robin sheet and follow those directions. Move seats to your left. Be prepared to share your information.

Agenda

Do Now
Project 9 - Present It!
  • Continue working on the presentation then have a peer check what you have done. Once you are finished please upload to the classroom.
Implement the suggestions from your peers.

April 10, 2017

Standards

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
    • Use a variety of computer software demonstrating a mastery of beginning workplace skills.
Demonstrate skills related to seeking and applying for employment to find and obtain a desired job.

Objectives

  • Students will be able to share and defend their opinion about whether PowerPoint helps people communicate more effectively using the language from class (presentation, slide, background, multimedia, movement, contrast, etc.) associated with using PowerPoint using MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
  • Students will be able to create PowerPoint presentations and apply PowerPoint skills and techniques learned in class using MS PowerPoint, oral and written directions, and peer assistance.

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create multimedia presentations with information, pictures, backgrounds, and animation.
    • Follow directions on the handouts to create presentations.
    • Understand how you can use PowerPoint and how it is used in the business world.

Do Now - Always be prepared to discuss!!

Think-Pair-Share - In the THINK section of the T-P-S sheet answer the following: Do you agree with the statement PowerPoint helps people communicate more effectively. Answer with why or why not. Write at least 3 full sentences using proper grammar. Pair with another person and listen to the things they put down and share what you put down. Write your partner's answer in the PAIR section. In the SHARE section, write down what you and your partner will share with the class.

Agenda

Do Now
Think-Pair-Share
Project 9 - Present It!
  • Continue working on the presentation then have a peer check what you have done. Once you are finished please upload to the classroom.
Have one of your peers look at your presentation for spelling, grammar, and the requirements before you turn it into the classroom.

April 6/7, 2017

Standards

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
    • Use a variety of computer software demonstrating a mastery of beginning workplace skills.
Demonstrate skills related to seeking and applying for employment to find and obtain a desired job.

Objectives

  • Students will be able to explain what PowerPoint is and when and how it should be used using the language from class (presentation, slide, background, multimedia, movement, contrast, etc.) associated with using PowerPoint using MS PowerPoint, oral and written directions, teacher-made examples, and peer assistance.
  • Students will be able to create PowerPoint presentations and apply PowerPoint skills and techniques learned in class using MS PowerPoint, oral and written directions, and peer assistance.

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create multimedia presentations with information, pictures, backgrounds, and animation.
    • Follow directions on the handouts to create presentations.
    • Understand how you can use PowerPoint and how it is used in the business world.

Do Now - Always be prepared to discuss!!

Login to www.quia.com/web and take the Excel Post Assessment.

Agenda

Do Now
Discussion - What does the word multimedia mean to you?
Teacher introduction and presentation on PowerPoint
Teacher models Project #9 Present It!
Students work on Project #9
  • Read and follow the directions for Project #9. The illustrations show suggested content for the seven (7) slides in the presentation. The content appearing in slides is described in detail in the instructions. You should also add additional text, word art, graphics (pictures), and background that will improve the appearance of the slides.
  • Remember that effective presentations have brief, general bullet points in the slide and more detailed explanations in the notes.
  • You should also go to O-Net Online to get additional details about your career and the education required. This information should be added to slides 3 and 4 or you may insert an additional slide. These elements should be present to receive an 'A' on the project.

April 4/5, 2017 Merge

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to explain what merging cells means and create a spreadsheet where they demonstrate how to merge cells using the stem "The definition of merging cells is __."
    • Article
    • Oral and written directions
    • Peer assistance
    • Class Discussion

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create a multi-column/row spreadsheet, formatting it and entering formulas into it.
    • Follow directions on the handout to create a spreadsheet and manipulate data within it.
    • Continue to understand some of the uses for spreadsheets in both a home and business setting.
    • Continue using more advanced formatting for a more organized spreadsheet.

Do Now - Always be prepared to discuss!!

Go to www.dictionary.com and look up the definition for the word 'merge'. Copy and paste the definition into a new Google doc. Then, think about things that can be merged and write down at least three (3) examples. Upload the Google doc to the classroom Do Now assignment.
Agenda
Do Now
Agenda:
  1. Merging cells is an important tools that make spreadsheet organization more effective and professional. Please read this article for your Do Now: Merge and unmerge cells
  2. Assignment Activity #17: Read and follow the directions to complete Activity #17 on page 35 of the Excel It! book. Download (click on) this start file to begin **Excel it Activity 17** Carefully read and follow the directions in the Excel It! book.
    • Before turning in the assignment, have a person sitting next to you review your work.This assignment is due at the end of the period.
    • Reminder: You can create formulas using cell references by clicking in the cell where you want the result to be displayed, start your formula with an equal sign =, click on the cell you want to reference in your formula, enter the math operator (+, -, *, /)and enter a number or click on another cell to reference in your formula.
  3. If you finish before the end of the period you can work on any missing assignments that you may have or typing lessons.

March 24, 2017

PERIOD 2 ONLY - Click on this link Google Form and answer the questions in the form. Click on submit and then do the second part of the Do Now below.

Standard

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use technology to increase the effectiveness of communications.

Objectives

  • Students will be able to verbally explain and demonstrate their learning of Excel and formulas by completing all projects using MS Excel, oral and written directions, teacher-made examples, and peer assistance.

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create multi-column/row spreadsheets, formatting and entering formulas.
    • Follow directions on the handouts to create spreadsheets and manipulate data within them.
    • Continue to understand the uses for spreadsheets in both a home and business setting.
    • Create graphs and tables in Excel

Do Now - Always be prepared to discuss!!

10 minutes typing LESSONS

Agenda

Check Infinite Campus for MISSING Excel Assignments and complete.
Check Infinite Campus for MISSING Word Assignments and complete.
If both those are done, find a partner and play Battleship in Excel. The directions are in the Google Classroom.

March 20/21 & 22/23, 2017

Standard

Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use technology to increase the effectiveness of communications.

Objectives

  • Students will be able to verbally explain and demonstrate their learning of Excel and formulas by completing all projects using MS Excel, oral and written directions, teacher-made examples, and peer assistance.

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create multi-column/row spreadsheets, formatting and entering formulas.
    • Follow directions on the handouts to create spreadsheets and manipulate data within them.
    • Continue to understand the uses for spreadsheets in both a home and business setting.
    • Create graphs and tables in Excel

Do Now - Always be prepared to discuss!!

None today

Agenda

Check Infinite Campus for MISSING Excel Assignments and complete.
Check Infinite Campus for MISSING Word Assignments and complete.
If both those are done, find a partner and play Battleship in Excel. The directions are in the Google Classroom.

March 17, 2017 Career Success: Junior Achievement Session 4

Standard

Students will learn essential skills employers want.

Objectives

  • Students will be able to identify and demonstrate soft skills with that are in demand by employers using a mock interview following their JA individual, JA materials, directions and peer assistance.

Success Indicators

  • Listened to JA coach
  • Completed all JA projects

Do Now - Always be prepared to discuss!!

None today

Agenda

Session 4 - Get Hired - Strong Soft Skills

Homework

None

March 15/16, 2017 Six Flags Graphs/Shopping

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain the charts/tables they have created in Excel by using the stem “This chart shows___ from the Six Flags spreadsheet I created ” using the terms columns, rows, average, sum, etc.
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class Discussion

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create a multi-column/row spreadsheet, formatting it and entering formulas into it.
    • Follow directions on the handout to create a spreadsheet and manipulate data within it.
    • Continue to understand some of the uses for spreadsheets in both a home and business setting.
    • Create graphs and tables in Excel

Do Now - Always be prepared to discuss!!

Typing LESSONS for 15 minutes!

Agenda

Do Now
Teacher - demonstrate how to create graphs using the Six Flags Project
Students - finish work on Six Flags Project including graphing.
Shopping
Catch Up

March 13/14, 2017 Comic Books/Six Flags

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain to partners some of the shortcuts used in Excel by using the stem “I’m going to use _ to using the terms sum, point-and-click, drag, etc.
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class Discussion

Success Indicators

  • Touch typing skills (not looking at keyboard) improving with accuracy more important.
  • You will be able to:
    • Create a multi-column/row spreadsheet, formatting it and entering formulas into it.
    • Follow directions on the handout to create a spreadsheet and manipulate data within it.
    • Continue to understand some of the uses for spreadsheets in both a home and business setting.
    • Create graphs and tables in Excel
  • Students will understand that :
    • Spreadsheets can be used for and analyzing organizing information.

Do Now - Always be prepared to discuss!!

Write in the Google classroom three things that have you learned so far about Excel. Each person should be able to share 1 thing without saying someone else said it! So, have multiple things you have learned!

Agenda

Do Now
Teacher - demonstrate shortcuts for addition, average, sum, etc., using the checkbook register
Students - demonstrate shortcuts
Teacher - Introduce Six Flags Project
Students - work on Six Flags Project

March 10, 2017 Career Success: Junior Achievement Session 3

Standard

Students will learn essential skills employers want.

Objectives

  • Students will be able to demonstrate collaboration with team members to accomplish work-based challenges using the GPRI (goals, roles, processes, interpersonal) model to resolve work-based issues following their JA individual, JA materials, directions and peer assistance.

Success Indicators

  • Listened to JA coach
  • Completed all JA projects

Do Now - Always be prepared to discuss!!

None today

Agenda

Session 3 - Career Success

Homework

None

March 8/9, 2017 MS Excel Practice

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain to partners why math formulas, order of operations, fill, sum and sort are used in Excel by using the stem “I’m going to use to __ using the terms formula, addition, subtraction, multiplication, and division.
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class Discussion

Success Indicators

  • Understand all terms used during the review.
  • Begin research for your own project.
  • Start the project in Excel

Do Now - Always be prepared to discuss!!

In a new Microsoft Excel Workbook, create a new spreadsheet with three columns.
  • Column A Label EXCEL Differences
  • Column B Label COMPARE
  • Column C Label WORD Differences
Fill out the table and compare and contrast MS Excel and MS Word.

Agenda

Do Now
Complete the spreadsheet you started on Monday/Tuesday and turn it in to the Google Classroom.
  • Students - will choose their own area of interest and research and create a spreadsheet that uses all these formulas (addition, subtraction, multiplication, and division). You can choose anything that includes statistics including:
    • Sports stats
    • Grades
    • Budgets
    • Inventory
    • Buying a ...... (car, computer, etc.) comparison shopping

March 6/7, 2017 MS Excel Practice - Period 2 in room 218

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain a variety of terms (formula, data, spreadsheet, cell, row, column, cell reference) associated with using Excel using a dependent clause (What is a formula? A formula is …)
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class Discussion

Success Indicators

  • Understand all terms used during the review.
  • Begin research for your own project.
  • Start the project in Excel

Do Now - Always be prepared to discuss!!

Take this Quiz on the work from Monday in this Google Form

Agenda

Do Now
Teacher - will review what we've done already in Excel.
Students - will choose their own area of interest and research and create a spreadsheet that uses all these formulas (addition, subtraction, multiplication, and division). You can choose anything that includes statistics including:
  • Sports stats
  • Grades
  • Budgets
  • Inventory
  • Buying a ...... (car, computer, etc.) comparison shopping
**If you finish with time left you can finish past-due work or typing.com lessons.

March 3, 2017 Career Success: Junior Achievement Session 2

Standard

Students will learn essential skills employers want.

Objectives

  • Students will be able to recognize and discuss common responses to conflict by applying conflict-management skills to resolve work-based issues following their JA individual, JA materials, directions and peer assistance.

Success Indicators

  • Listened to JA coach
  • Completed all JA projects

Do Now - Always be prepared to discuss!!

None today

Agenda

Session 2 - Career Success

Homework

None

March 1/2, 2017 MS Excel Practice

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain to partners why math formulas, order of operations, fill, sum and sort are used in Excel by using the stem “I’m going to use _ to using the terms formula, addition, subtraction, multiplication, and division.
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class Discussion

Success Indicators

  • Complete and upload past-due Excel spreadsheets

Do Now - Always be prepared to discuss!!

None today! Get started on past due work!
PERIOD 2 ONLY!!! Please fill out this Google form

Agenda

Today will be a catch-up day. These are all the spreadsheets that need to be completed and uploaded to the Google classroom:
  • Do Now Feb. 22nd
  • Schedule
  • Address book
  • Checkbook
  • Excel It! Activities 2, 3, and 4 - Please see February 27/28 for directions on these!

February 27/28, 2017 MS Excel Practice

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain to partners why math formulas, order of operations, fill, sum and sort are used in Excel by using the stem “I’m going to use _ to using the terms formula, addition, subtraction, multiplication, and division.
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class Discussion

Success Indicators

  • Complete and upload the two activities in Excel It!

Do Now - Always be prepared to discuss!!

Watch all of these Excel tutorials:
  1. Order of Operations
  2. Formulas in Excel
  3. Sum Function
  4. Auto Fill and Flash Fill
  5. Sort and Filter Data
  6. Sort Details

Agenda

  • Do Now
  • Excel It! Activity 2 Instructions
    • Research the current list of popular songs at Top 100 Songs. Use the top 10 songs and their artists names to create a spreadsheet like the one on page 4 of the Excel It! book. Follow the directions on page 3 to correctly format the spreadsheet. Upload your finished spreadsheet with your name in cell A1 and turn it in to Google Classroom.
  • Excel It! Activity 3 Instructions
    • Follow the directions on page 3. You will need to enter the data, title, and headings. Follow the directions on page 3 to correctly format the spreadsheet. Upload your finished spreadsheet with your name in cell A1 and turn it in to Google Classroom.
  • Excel It! Activity 4 Instructions
    • Follow the directions on page 7. You will need to enter the data, title, and headings. Follow the directions on page 7 to correctly format the spreadsheet. Upload your finished spreadsheet with your name in cell A1 and turn it in to Google Classroom.
  • If you finish and upload both spreadsheets to the Google classroom, you can work on missing spreadsheets (address book, checkbook. When those are done you should go to typing.com and work on your typing lessons. The last 10 minutes of class you may have typing games.

Homework

None

February 23/24, 2017 MS Excel Formulas - Bring headphones on Monday/Tuesday!

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain to partners why math formulas are used in Excel by using the stem “I’m going to use to __” using the terms formula, addition, subtraction, multiplication, and division.
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class Discussion

Success Indicators

  • Know when and why to use formulas for math function in Excel
  • Create a spreadsheet using two columns
  • Enter formulas into cells to calculate the sum of a column of numbers and average the numbers

Do Now - Always be prepared to discuss!!

Answer the Do Now questions in the Google Classroom. Please write in the PRIVATE comments not the class comments!

Agenda

Do Now
Introduction to formulas
Math review
Spreadsheet for simple formulas.

Homework

None

February 21/22, 2017 Intro to MS Excel

Standard

Communication
  • Communicate information and ideas effectively to multiple audiences using a variety of media and formats.
  • Use a variety of computer software demonstrating a mastery of beginning workplace skills.

Objectives

  • Students will be able to verbally explain basic terms used with spreadsheets and the purpose of spreadsheets using a dependent clause(They will say, “What is a column? A column is ( .....” )
    • Oral and written directions
    • Teacher-made example
    • Peer assistance
    • Class discussion

Success Indicators

  • Understand and define the terms row, column, label, constant, and formula
  • Open and save a spreadsheet

Do Now - Always be prepared to discuss!!

MS Excel pre-assessment in Quia - use this link
**http://www.quia.com/quiz/5510645.html**
If you did NOT take the POST-Assessment for MS Word because you were absent on Wednesday or Thursday, please take that, too.

Agenda

Do Now
Introduction to Excel presentation
Create two simple spreadsheets and save them.

Homework

None

February 17, 2017 Career Success: Junior Achievement Session 1

Standard

Students will learn essential skills employers want.

Objectives

  • Students will be able to solve personal and professional problems by learning how to use a problem solving technique and following their JA individual, JA materials, directions and peer assistance.
  • Students will be able to solve work-base problems by using critical thinking skills using coaching from their JA individual, JA materials, directions and peer assistance.

Success Indicators

  • Listened to JA coach
  • Completed all JA projects

Do Now - Always be prepared to discuss!!

None today

Agenda

Introduce JA coach
Session 1 - Career Success

Homework

None



Link to Quia - login = jfk(student ID #) password - 8-digit birthdate
Link to Typing.com
Link to Brain Puzzles
Link to Word Word Wall
Link to Excel Word Wall
Link to Presentations Word Wall

PERIOD 2 ONLY - INTERVIEW PREPARATION
  • You will be graded on your interview skills by the volunteers interviewing you. They will fill out this mock interview rubric it is worth 25 points. Read over the expectations and devise a strategy to achieve the maximum points in each category.
    Following your interview you will complete a self-evaluation of your interview using this same form (this is 5 points of the total grade.)
    1. Prepare for Mock Interviews by finalizing and printing 3 copies of your resume and cover letter.
    2. Review the mock interview rubricto determine what you need to do during the interview.
    3. Use this list of Mock Interview Questions to help prepare for the interviews.
    4. Use this Interview Checklist to prepare for the interview.
    5. Interview Tips
    6. Questions to Ask Interviewers
    7. The job you will be interviewing for is with one of these three Job Ads . Spend some time researching this company to learn about what they do, their mission, values and the kind of jobs that are available.



Do Now Mock Interview Followup

Do Now: Respond in your Google Docs Journal
Review the feedback from your Mock Interview and answer the following questions:
  1. What comment did you get under the “Good Job” section?
  2. Do you agree? Why or Why not?
  3. What comment did you get under the “Suggestion” section?
  4. Do you agree? Why or Why not?
  5. Identify any gaps between your self evaluation and your interviewer. What could you have done to improve your interviewers impression of you?


Grade Check:

On a piece of paper, write the following:
Name:
As of _, my grade in 's class is _. I AM MISSING THE FOLLOWING ASSIGNMENTS: . MY PLAN FOR SUCCESS IS TO:.

Student Signature: _
Parent Signature:_

This is due on and is for a grade!





Link to Word Processing Videos
Read ALL of this tutorial on Find & Replace
Link to Internet Word Wall

Excel It! Activity 10 Instructions

Use this Excel It Activity 10 Start File to begin Activity 10. You will need to enter the title, headings and the last two rows of data. Follow the directions on page 19 to correctly format the spreadsheet and enter formulas. Print your finished spreadsheet with your name in cell A1 and turn it in.

Excel It! Activity 11 Instructions

Use the finished spreadsheet from Activity 10 to begin Activity 11. Use the File>Save As command to rename your spreadsheet SAT SCORES 2. Follow the directions on page 21 to add additional formulas and sort the data. Print your finished spreadsheet with your name in cell A1 and turn it in.