21st+Century+Computer+Applications+Semester+1+2013-2014

21st Century Computer and Multimedia Applications focuses on developing the essential skills for using office suite programs which includes Word, Power Point, Excel, and Publisher. Microsoft Office and Google Docs will be used throughout the course.

Block 3A and 4A - E201 Email/Google Drive Account: darryl.mendonez@sbschools.org Student Email Site Google Drive Quarter 1 Presentation Slides Quarter 2 Presentation Slides 2nd Semester can be found here.


 * Daily Activities: **

//Daily Activities for Semester 2 can be found here.//
 * =__Quarter 1__= ||  ||   ||
 * ===Date=== || ===Classwork=== || ** Home **** wo **** rk ** ||
 * 9-5-14 || * Do Now: Assign seats
 * Finish Info & Interests
 * Explore class wiki and School Email
 * Go over Syllabus and Course Expectations
 * Explore Insight and Google Drive
 * Create classroom folder
 * Ice Breaker – 20 Questions Character Game
 * Closure: What are some new things you learned today about Google Drive?

*Reminder: Pre Assessment will be given next class ||  ||
 * 9-9-14 ||  ||   ||
 * 9-11-14 || * Create School Email
 * Explore Google Drive
 * Ice Breaker - 20 Questions Character Game || Log into your school email from home and your Google Drive ||
 * 9-15-14 || * Create Shared Folder
 * Save vs. Save as ||  ||
 * 9-17-14 || * Headers & Footers
 * Shortcut Keys || Memorize Shortcut Keys from Activity 3 ||
 * 9-19-14 || More Shortcut Keys Practice || Study for Shortcut Keys Quiz on Tuesday ||
 * 9-23-14 || * Shortcut Key Quiz
 * Discover Format Page Orientation
 * Discover Center Align Text on a Page
 * Activity: Party Invitation ||  ||
 * 9-25-14 || * Do Now: Create Mr. Mendonez's Wedding Invitation
 * Discover Setting Default Font and Font Size
 * Discover Single Spacing
 * Discover Common Formatting Features
 * Activity: Texting Phrases
 * Closure: What are some new formatting features I learned today? ||  ||
 * 9-30-13 || * Do Now: Make a Flyer for the the next South Brunswick Vikings football game against the Edison Eagles which is on October 4th at 7:00 pm at home. The purpose of the flyer is to try to get as many students to attend the game as possible. Be sure to include all the information. Try to use as many of the formatting features we have learned in class as you can.
 * Review New Formatting Features
 * Finish Activity 5 - Texting Phrases
 * Acitivity 5 - Fairy Tale
 * Discover Symbols and Special Characters
 * Activity: PTO Letter
 * Closure: What are some symbols you learned how to type today? What steps do you have to do to type them? ||  ||
 * 10-2-13 || * Do Now: Finish Activity 5 - Fairy Tale
 * Discover Symbols and Special Characters
 * Activity: PTO Letter
 * Closure: What are some symbols you learned how to type today? What steps do you have to do to type them? ||  ||
 * 10-4-13 || * Do Now: Finish PTO Letter
 * Review How to type Symbols and Special Characters
 * Closure: What are the steps to Find and Replace Text in a word document? ||  ||
 * 10-8-13 || * Do Now: Finish PTO Letter
 * Discover Find and Replace Text in a Document
 * Activity: Glee
 * Discover Spelling and Grammar Check
 * Discover Using the Thesaurus
 * Activity: America's Got Talent
 * Activity: Typing Test
 * Set Typing Test to English, 3 Minutes, and Aesop's Fable
 * Try the Typing Test 6 times and record each attempt on a Google Document in your shared folder. Title the document Typing Test Log.
 * Record the Typing Speed, Errors, and Adjusted Speed.
 * Closure: What are the steps to use the thesaurus? ||  ||
 * 10-10-13 || * Do Now: Finish Typing Test Activity
 * Set Typing Test to English, 3 Minutes, and Aesop's Fable
 * Try the Typing Test 6 times and record each attempt on a Google Document in your shared folder. Title the document Typing Test Log.
 * Record the Typing Speed, Errors, and Adjusted Speed.
 * Practice Proofreading
 * Discover Auto-Numbering
 * Activity: Homonyms
 * Discover Tabs
 * Discover Show/Hide Formatting Marks
 * Discover Setting Page Margins
 * Activity: Movie Ratings
 * Closure: How do you use auto-numbering? Is there more than one way to set up auto-numbering? ||  ||
 * 10-14-13 || *
 * Career Planning Presentation Slides
 * Do Now: Imagine you are getting ready for your first job interview. How can you prepare yourself so that you make the best impression?
 * Introduction to Interviewing
 * MTV HIRED Video
 * As you watch take notes. Separate your sheet into a DO column and a DON’T column. In the DO column write down the positive things that the job candidates did. In the DON’T column write down the negative things that the job candidates did.
 * Be prepared to discuss your notes with the class.
 * Closure: Visit the website for each company shown on MTV HIRED. Are there currently any job openings? Would you like to work there? Why/Why not? || Speak to a few adults (or older siblings) about their experiences with jobs & interviews. How do they prepare? What type of things were they asked? Have they ever had to interview others for a position at their company? What type of questions did they ask? How did they evaluate the candidates?

Type your responses in your Career Unit document that you created in class and make sure it is saved in your shared folder. ||
 * 10-17-13 || * Do Now: Open up notes from last class and discuss them and your HW questions with your neighbor.
 * MTV HIRED! Share Do’s & Don’ts
 * Introduction To Career Unit
 * Career Project: The Future: Next Exit Overview
 * Introduction to Naviance; Log into account
 * [[image:https://www.wikispaces.com/i/mime/32/application/vnd.openxmlformats-officedocument.presentationml.presentation.png width="32" height="32" caption="Your Guide To Naviance .pptx" link="file:mrmendonez/Your Guide To Naviance .pptx"]] [[file:mrmendonez/Your Guide To Naviance .pptx|Your Guide To Naviance .pptx]]
 * [|Details]
 * [[file:mrmendonez/Your Guide To Naviance .pptx|Download]]
 * 1 MB


 * Closure: What is the purpose of Naviance? How will it help you as you move through your HS career? || Make a plan as to who you will interview for Career Project ||
 * 10-21-13 || * Do Now: What are your career interests? Have they always been the same? What has influenced them?
 * Discuss Homework
 * Introduction to Naviance; Log into account
 * [[image:https://www.wikispaces.com/i/mime/32/application/vnd.openxmlformats-officedocument.presentationml.presentation.png width="32" height="32" caption="Your Guide To Naviance .pptx" link="file:mrmendonez/Your Guide To Naviance .pptx"]] [[file:mrmendonez/Your Guide To Naviance .pptx|Your Guide To Naviance .pptx]]
 * [|Details]
 * [[file:mrmendonez/Your Guide To Naviance .pptx|Download]]
 * 1 MB


 * Project Work
 * Virtual Tour of Naviance
 * Closure: What are sources you can use to research careers? || Visit either www.monster.com or careerbuilder.com. Select a job posting that interests you. What will you need to do to become qualified for the job? What is appealing about it? What career cluster is it a part of? ||
 * 10-24-13 || * Do Now: Describe the job posting you found for HW. Identify the job title, career cluster, requirements and why it interests you.
 * Discussion: Career Planning
 * || **Study for Career Planning Quiz**

Make arrangements to conduct **career project interview**. Your interviews are due on October 30th. || End of Q1 || * Do Now: Open up your presentations and start preparing to present. (Date updated due to snow day 2-5-14) || * Do Now: Continue Midterm Review (Date updated due to snow day 2-5-14) || * Do Now: Take the time to answer the Student Survey about your teacher for this class (Date updated due to snow day 2-5-14) || * Do Now: Take the time to answer the Student Survey about your teacher for this class (Date updated due to snow day 2-5-14) || * Do Now: What does it mean to be ethical? Are the rules different depending on who you are or where you are? (Date updated due to snow day 2-5-14) || * Do Now: Study for Midterm //Daily Activities for Semester 2 can be found here.//
 * 10-28-13 || * Do Now: Study for Quiz
 * **Career Planning Quiz**
 * Discuss: Think about social media & your online persona…What do you use? What guidelines do you have for using it?
 * Sign up for career choice
 * 3A Class
 * 4A Class
 * Discussion: The Selection Process
 * Social Media Can Hurt You…
 * “Nasty Interview Questions”
 * How Important Are Interview Tests?
 * 3 Things Employers Assess
 * **Project Work**: Review key dates & work independently.
 * Closure: What are some guidelines for teens when using social media? How can your usage of social media today affect your later in the college application process and in your career? || Conduct **career project interview**. Due next class. ||
 * 10-30-13 || * Do Now: Discuss the 4 steps to the job selection process with your neighbor. Which part do you think will be the most difficult?
 * Turn in Part 1 of the Career Project
 * Discussion: The Selection Process & Leaving A Job
 * Independent Project Work: Work on the Career Project. Part 2 is due next class.
 * Closure: What things might happen to someone at work that would cause them to quit? || * **Career Project** Part 2 due next class
 * **Quiz on The Selection Process and Leaving a Job next class** ||
 * 11-1-13 || * Do Now: Study for Quiz
 * **Quiz on The Selection Process and Leaving a Job**
 * Independent Project Work
 * Closure: What are the different ways to leave a job and how are they different? || **Career Project** Part 3 due next class ||
 * 11-5-13 || * Do Now: What are the four steps to The Selection Process?
 * Discuss Quiz
 * Independent Project Work
 * Closure: What are your thoughts on Naviance's Career Interest Profiler? || **Career Project** Part 4 due next class ||
 * 11-11-13 || * Do Now: Discuss with your neighbor if you think Naviance will be helpful in deciding what you want to do after high school. Why or why not? Then type your thoughts into your Career Unit Notes
 * Independent Project Work
 * Closure: What are your thoughts on Naviance's Personality Type Survey? || **Career Project due next class** ||
 * 11-13-13
 * 11-13-13
 * **Career Project Presentations** - Audience members must take notes.
 * Closure: What are some things you have learned through these presentations today? ||  ||
 * ** QUARTER 2 ** || **Quarter 2 Presentation Slides** (Updated Daily) ||  ||
 * 11-15-13 || * Do Now: Take out your notes from the previous presentations. Open a new Google Document and choose three positions you learned about from the presentations and describe at least two interesting things you learned for each. Title the Google Document 'Interesting Positions'
 * Career Planning Presentation File
 * **Career Project Presentations** - Audience members must take notes.
 * Closure: What are some things you have learned through these presentations today? ||  ||
 * 11-19-13 || * Complete the Microsoft Word Practice Activities
 * Save your files in your shared folder.
 * Activity: Typing Test
 * Set Typing Test to English, 3 Minutes, and The Wonderful Wizard of Oz
 * Try the Typing Test 6 times and record each attempt on the same Google Document we created last time we did the Typing Test. The document should be titled Typing Test Log.
 * Record your Typing Speed, Errors, and Adjusted Speed per attempt. ||  ||
 * 11-21-13 || * Do Now: Open a new Google Document in your '21st Century' folder and title it 'Excel It Notes.' Write down some reasons why someone would use Microsoft Excel to make spreadsheets.
 * Finish **Career Project Presentations**
 * Organize Word It Activity Files
 * Introduce Excel It!
 * Excel It Workbook Assignment
 * Closure: Activity 1 - Social Networking ||  ||
 * 11-25-13 || * Do Now: Finish Activity 1 - Social Networking
 * Enter data in a spreadsheet
 * Identify cell addresses by placing the cursor in a specified cell address
 * Save a spreadsheet
 * Set the print area of a spreadsheet
 * Watch: The Pursuit of Happyness
 * Go over Worksheet
 * Closure: What has Chris done to help himself financially so far? ||  ||
 * 11-27-13 || * Do Now: Discuss questions from worksheet. You do not need to log into the computers
 * Watch: The Pursuit of Happyness
 * Go over Worksheet
 * Closure: How would you feel if you found out that you have been evicted from your apartment? ||  ||
 * 12-3-13 || * Do Now: Discuss questions from worksheet. You do not need to log into the computers
 * Watch: The Pursuit of Happyness
 * Answer worksheet and reflection questions on a new Google Document
 * Closure: Discuss reflection questions with the class. ||  ||
 * 12-5-13 || * Do Now: Finish The Pursuit of Happyness Assignment
 * Answer worksheet and reflection questions on a new Google Document
 * Closing Activity: Typing Test - Space Cowboys
 * Set Typing Test to English, 3 Minutes, and Space Cowboys
 * Try the Typing Test 6 times and record each attempt on the same Google Document we created last time we did the Typing Test. The document should be titled Typing Test Log.
 * Record your Typing Speed, Errors, and Adjusted Speed per attempt. ||  ||
 * 12-9-13 || * Do Now: Review Shortcut Keys
 * Activity 2 - American Top 40 Music
 * Align cell data to left, right, and center positions
 * Discover Converting Microsoft Excel Files to Google Spreadsheets
 * Activity 3 - Text Messaging
 * Print preview to adjust setup so the spreadsheet fits on one page
 * Change font size
 * Use bold, italics, and underline text-style enhancements
 * Activity 4 - L.A. Lakers
 * Change column widths
 * Closure: What kind of jobs do you think would need their employees to know how to use Excel? ||  ||
 * 12-12-13 || * Do Now: Finish Activity 4 - L.A. Lakers
 * Discover: Format Cells to Text and Sorting Data in Ascending Order
 * Discover: Autofill feature
 * Activity 5 - Class Roster
 * Activity 6 - Automobile Research
 * Discover: Format Cells as Numbers and Increase a Cell's Decimal Places
 * Closure: Introduce Hour of Code ||  ||
 * 12-16-13 || * Do Now: Make sure you have posted your tinyurl link on the shared document for your project.
 * Explore: Code.org
 * Watch: Hour of Code, President Obama calls on every American to learn code, What Most Schools Don't Teach
 * Discover: __Learn an Hour of Code__
 * Closing Activity: Reflection - On a new Google Document write your thoughts on learning code.
 * Why do you think it is important for our future?
 * Do you think learning code is overwhelming or do you think it is something you can you feel you could learn? Why or why not?
 * Do you have interest in taking a computer science class in the future? Why or why not? ||  ||
 * 12-18-13 || * Do Now: Finish Hour of Code Reflection
 * Why do you think it is important for our future?
 * Do you think learning code is overwhelming or do you think it is something you can you feel you could learn? Why or why not?
 * Do you have interest in taking a computer science class in the future? Why or why not?
 * Paste your link into the shared spreadsheet:
 * 3A Shared Spreadsheet
 * 4A Shared Spreadsheet
 * Discuss Hour of Code
 * Meet the New Google Sheets
 * Discover: Format cells as numbers and increasing a cell's decimal places.
 * Discover: Change page orientation to landscape
 * Closing Activities:
 * Activity 7 - The Gap
 * Activity 8 - Class Roster 2 ||  ||
 * 12-20-13 || * Do Now: Finish up to Activity 8
 * Discover: Publishing Google Drawings and Documents to the Web
 * Closing Activity: Holiday Cards ||  ||
 * 1-6-14 || * Do Now: Finish up to Activity 8
 * Discover New Skills
 * Format Cells as Dates
 * Addition Formula
 * Autofill to Complete Formulas
 * Display Formulas
 * Use Average, Maximum, and Minimum Functions
 * Sort Data in Descending Order (Z-A)
 * Closure: Complete Activities 9 - 11 with Microsoft Excel ||  ||
 * 1-8-14 || * Do Now: Finish up to Activity 11
 * Project: Spreadsheet Formula Project
 * Closure: What are other ways people could use formulas in spreadsheets for? ||  ||
 * 1-10-14 || * Do Now: Log into PowerSchool and open up your Quick Lookup. Let your teacher know if you cannot log in.
 * Continue Project: Spreadsheet Formula Project
 * Closure: Once you've finished click on File, Share, and type indarryl.mendonez@sbschools.org in the Invite People field. Then click done. Only do this once you have finished. You will have more time next class if you have not yet finished. || Finish all activities up to Activity 11. Activities can be found in the Excel It! E-Book Folder ||
 * 1-14-14 || * Do Now: Read the infographic posted on Top Computer Science Degrees. Discuss with your neighbor two interesting facts you learned from it. Write down the two facts on a new Google Document and why you found each fact interesting. Share the document by sending it to darryl.mendonez@sbschools.org.
 * Watch: Phonebloks
 * Continue Project: Spreadsheet Formula Project
 * If you do not finish the project in class you must let your teacher know
 * Closure: Once you've finished click on File, Share, and type indarryl.mendonez@sbschools.org in the Invite People field. Then click done. Only do this once you have finished. ||  ||
 * 1-16-14 || * Do Now Finish Project: Spreadsheet Formula Project
 * Once you've finished click on File, Share, and type indarryl.mendonez@sbschools.org in the 'Invite People' field. Then click done. Only do this once you have finished.
 * Typing Test - Tigers in the Wild
 * Set Typing Test to English, 3 Minutes, and Tigers in the Wild
 * Try the Typing Test 6 times and record each attempt in your Typing Test Log
 * Record the Typing Speed, Errors, and Adjusted Speed
 * Discover: Multiply, Add, Subtract Formulas, Using Parenthesis in Formulas, Text Wrap within Cells
 * Closing Activities: Do the following activities in Microsoft Excel
 * Activity 12 - Teen U.S.A. Payroll Register
 * Activity 20 - Reality TV ||  ||
 * 1-21-14 || * Do Now: Finish Activities 12 and 20
 * Code.org - Log into Code.org and continue the activities from where you left off
 * Course Registration Information
 * Online Course Booklet
 * Discover: Change cell shading, insert and delete rows, insert and move columns
 * Closing Activities:
 * Activity 28 - Quarterback Statistics
 * Activity 30 - NBA Standings
 * Activity 33 - Top 10 Candy Bars || Finish Activities 12 and 20 found in the Excel It! E-Book. Due 1-22-14 by 10pm. ||
 * 1-24-14 || * Do Now: Finish Activities 28, 30, & 33
 * Code.org - Log into Code.org and continue the activities from where you left off || Finish Activities 28, 30 and 33 found in the Excel It! E-Book. Due 1-27-14 by 10pm. ||
 * 1-28-14 || * Do Now: How do pie charts, column charts, and line charts differ from each other? What are some reasons why people use each type of chart? Answer these questions in your Do Now Google Document.
 * Discover:Create a Pie Chart, Create a Column Chart, Create a Line Chart, Select Cells Using Multiple Ranges, and Use the Fill Effects Feature in a Chart
 * Activities:
 * Activity 44 - Search Engines
 * Activity 45 - iPhone Games
 * Activity 46 - Summer Olympic Games
 * Closure: Continue the Code.org activities ||  ||
 * 1-30-14 || * Do Now: Finish Activities 44, 45, & 46
 * Check PowerSchool to see if you are missing assignments
 * Midterm Review
 * The Midterm Exam will have 50 Multiple Choice questions. Make sure you know the terms or how to perform the functions from the review guide to help you prepare.
 * Closing: Any questions on the Midterm Review? || Finish Activities 44, 45 and 46 found in the Excel It! E-Book. Due 2-2-14 by 10pm. ||
 * 2-4-14
 * The Midterm Exam will have 50 Multiple Choice questions. Make sure you know the terms or how to perform the functions from the review guide to help you prepare.
 * Midterm Review Questions
 * Closing: Any questions on the Midterm Review? || **Study for Midterm** ||
 * 2-7-14
 * Block 3A**
 * Computer Apps Student Survey
 * **3A - Midterm**
 * **Closure: Form Example - Pizza Toppings** || 4A: **Study for Midterm** ||
 * 2-7-14
 * Block 4A**
 * Computer Apps Student Survey
 * 4A - Midterm Review ||  ||
 * 2-11-14
 * Block 3A**
 * Cooperative Learning: Ethics on the Job Game
 * Reflection Questions
 * Closing: Share highlights from your group discussion. ||  ||
 * 2-11-14
 * Block 4A**
 * **4A - Midterm** ||  ||

__**New Jersey Core Curriculum Content Standards**__ (covered daily) 6.3 (Social Studies; Active Citizenship in the 21st needed to be active, informed citizens who value diversity and promote cultural understanding by working collaboratively to address the challenges that are inherent in living in an interconnected world. • 8.1 (Technology, Educational Technology): All students will use digital tools to access, manage, evaluate, and synthesize information in order to solve problems individually and collaboratively and to create and communicate knowledge. • 9.1 (21st-Century Life and Careers, 21st-Century Life & Career Skills): All students will demonstrate the creative, critical thinking, collaboration, and problem-solving skills needed to function successfully as both global citizens and workers in diverse ethnic and organizational cultures. <span style="font-family: Arial,Helvetica,sans-serif;">• 9.2 (21st-Century life and Careers, Personal Financial Literacy) All students will develop skills <span style="font-family: Arial,Helvetica,sans-serif;">and strategies that promote personal and financial responsibility related to financial planning, <span style="font-family: Arial,Helvetica,sans-serif;">savings, investment, and charitable giving in the global economy. <span style="font-family: Arial,Helvetica,sans-serif;">• 9.3 (21st-Century Life and Careers, Career Awareness, Exploration & Preparation): All students <span style="font-family: Arial,Helvetica,sans-serif;">will apply knowledge about and engage in the process of career awareness, exploration, and <span style="font-family: Arial,Helvetica,sans-serif;">preparation in order to navigate the globally competitive work environment of the information <span style="font-family: Arial,Helvetica,sans-serif;">age.

<span style="font-family: Arial,Helvetica,sans-serif;">__**Formative Assessments**__ <span style="font-family: Arial,Helvetica,sans-serif;">• Do Now / Closures <span style="font-family: Arial,Helvetica,sans-serif;">• Application Exercises and Class work produced individually and in groups <span style="font-family: Arial,Helvetica,sans-serif;">• Internet Research Activities <span style="font-family: Arial,Helvetica,sans-serif;">• Observation / verbal check-for-understanding <span style="font-family: Arial,Helvetica,sans-serif;">• Presentations <span style="font-family: Arial,Helvetica,sans-serif;">• Chapter Quizzes <span style="font-family: Arial,Helvetica,sans-serif;">• Case studies <span style="font-family: Arial,Helvetica,sans-serif;">• Homework

<span style="font-family: Arial,Helvetica,sans-serif;">This class follows the South Brunswick School District Acceptable Use of Technology Agreement