1 / 63

IC3

IC3. Ms. Curtis Syllabus Classroom Expectations Textbook – Computer Literacy Basics JCPS On-line. Monday February 22, 2010. Establishing Engagement: Excel Pre-Test Fostering Connections – Identify parts of Excel 2007

carys
Télécharger la présentation

IC3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IC3 Ms. Curtis Syllabus Classroom Expectations Textbook – Computer Literacy Basics JCPS On-line

  2. MondayFebruary 22, 2010 • Establishing Engagement: • Excel Pre-Test • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – enter data, copy, clear, and delete data • Authentic Engagement: Step-by-step 17.5-17.9 • Closure: Complete the following statement on the back of your printed out assignment: The Name box shows the ________.

  3. WednesdayFebruary 24, 2010 • Establishing Engagement: • Excel Pre-Test • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Formatting columns • Authentic Engagement: Open Cruise 1 Document Step-by-step 17.5-17.9 • Closure: Assignment folder

  4. ThursdayFebruary 25, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Auto fill • Authentic Engagement: Project 17-1 & 17-2 (Module 2-page192) • Closure: Answer the following – The intersection of a single row and a single column is called a ________________.

  5. FridayFebruary 26, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – www.weather.com • Deepening Understanding: Excel 2007 – Creating a Weather Forecast Spreadsheet • Engagement: Create a worksheet in Excel with forecast for five cities -City, State – High – Low – Humidity - Precipitation • Closure – Have a good weekend

  6. March 1, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Step-by-step 18.1 -18.11 (Module 2 - page 197) • Closure: What enables you to repeat the same data in a column or row?

  7. March 2, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Step-by-step 18.1 -18.11 (Module 2 - page 197) • Closure: What enables you to repeat the same data in a column or row?

  8. MondayNovember 16, 2009 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Step-by-step 18.4 -18.8 (Module 2 - page 203) Billing Spreadsheet • Closure: When you combine several cells into a single cell you are? ___________

  9. TuesdayNovember 17, 2009 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Projects 18-1, 18-2, & 18-3 (Module 2 – page 220) Documents on JCPS Online • Closure: To sort worksheet data, you must indicate the _________ on which you want to base the sort.

  10. WednesdayMarch 3, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Projects 18-1, 18-2, & 18-3 (Module 2 – page 220) • Closure: To sort worksheet data, you must indicate the _________ on which you want to base the sort.

  11. ThursdayMarch 4, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Projects 18-1, 18-2, & 18-3 (Module 2 – page 220) Miles per Gallon & Test Score Results • Closure: Chapter 18 Formulas

  12. FridayMarch 5, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Projects 18-1, 18-2, & 18-3 (Module 2 – page 220) Building Dice • Closure: Chapter 18 Formulas

  13. ThursdayNovember 19, 2009 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identify parts of Excel 2007 • Deepening Understanding: Excel 2007 – Managing Worksheets • Authentic Engagement: Chapter 18 Study Gide (80% or better) Projects 18-1, 18-2, & 18-3 (Module 2 – page 220) Documents on JCPS Online • Closure - Functions

  14. MondayMarch 8, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections –Creating Formulas & Charting Data in Excel 2007 • Deepening Understanding: Excel 2007 – Enter formulas & use auto format • Authentic Engagement: Chapter Step-by-step19.1 – 19.7 Module 2 page 225 • Closure - Functions

  15. TuesdayMarch 9, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Creating charts • Deepening Understanding: Formatting charts • Authentic Engagement: Excel Spreadsheet –Step-by-step 19 (225) • Closure - Functions

  16. WednesdayMarch 10, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections –Creating Formulas & Charting Data in Excel 2007 • Deepening Understanding: Excel 2007 – Creating & Editing Charts • Authentic Engagement: Step-by-Step 19.8 & 19.9 (page 240) • Projects for Chapter 19 (page 246 & 247) • Closure –CASA Scrimmage - Excel

  17. ThursdayMarch 11, 2010 • Establishing Engagement: • Sign in JCPS On-line 6N56L1 • Fostering Connections –Creating Formulas & Charting Data in Excel 2007 • Deepening Understanding: Excel 2007 – Creating & Editing Charts • Authentic Engagement: Projects for Chapter 19 (page 246 & 247) • Study Guide Chapter 19 (Score 80% or better) • Closure –CASA Scrimmage - Excel

  18. FridayMarch 12, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections –Creating Formulas & Charting Data in Excel 2007 • Deepening Understanding: Excel 2007 – Using Average, Min & Max Functions • Authentic Engagement: Step-by-Step 19.1- 19.7, Projects 19.1 – 19.4 • Banquet Mileage • Sales MPG • Order Trees • News Demographics • Closure – Charting Data in Excel

  19. MondayMarch 12, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Crating a Pictogram • Deepening Understanding: Excel 2007 – Creating a chart using a pictogram • Engagement: Create a worksheet in Excel with a Pictogram & score 80% or better on Chapter 19 study guide (JCPS On-line) • Closure – CASA Scrimmage

  20. TuesdayMarch 16, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Study guide on JCPS Online • Deepening Understanding: Excel 2007 – CASA Scrimmages • Engagement: Score 80% or better on Chapter 19 study guide (JCPS On-line) • Closure – CASA Scrimmage

  21. WednesdayMarch 17 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identifying parts of a chart – X-Axis, Y-Axis, Legend, Data Labels • Deepening Understanding: Excel 2007 – Creating an absolute cell reference =(D3*$J$3) • Engagement: CASA Scrimmages – Global Warming & Fuel Usage • Closure – CASA Test

  22. ThursdayMarch 18, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identifying parts of a chart – X-Axis, Y-Axis, Legend, Data Labels • Deepening Understanding: Excel 2007 – Creating an absolute cell reference =(D3*$J$3) • Engagement: CASA Scrimmages – Cyber & Postal • Closure – CASA Test

  23. MondayMarch 22, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Column Chart, Bar chart, & Pie Chart • Deepening Understanding: Excel 2007 – Creating a chart using a Insert Tab • Engagement: Create Spreadsheets with charts from handout (9 Worksheets & Charts created in one workbook) • Closure – CASA Test

  24. TuesdayMarch 23, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Inserting Clip Art & text box in Excel • Deepening Understanding: Formatting an invoice • Engagement: Create an invoice for Classey Electronic • Closure – Review of Excel 2007

  25. WednesdayMarch 24, 2010 • Establishing Engagement: • Sign in JCPS On-line & Tool tips • Fostering Connections: Merge & Center, formatting in Excel • Deepening Understanding: Excel 2007 – • Engagement: Class Quiz Score • Closure – CASA Test

  26. ThursdayMarch 25, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections: www.whitehouse.gov • Deepening Understanding: Past US Presidents – current president, blogs weekly videos • Engagement: Presidential Cyber Interview • Closure – CASA Test

  27. FridayMarch 26, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections: Grade sheets • Deepening Understanding: Missing assignments/0’s • Engagement: • CASA Scrimmages JCPS On-line (4 Fuel, Cyber Abuse, Global, & Postal) • Roth’s Invoice • Charts (9) • Closure – CASA Test

  28. MondayMarch 29, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Identifying parts of a chart – X-Axis, Y-Axis, Legend, Data Labels • Deepening Understanding: Excel 2007 – Review for CASA Test • Engagement: CASA Test • Closure – Review of MS PowerPoint 2007

  29. TuesdayMarch 30, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – PowerPoint Presentation 2007 • Deepening Understanding: PP 2007 – Design, Page layout, Inserting word art & pictures • Engagement: Destination PowerPoint Project • Closure –MS PowerPoint 2007

  30. WednesdayMarch 31, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – PowerPoint Presentation 2007 • Deepening Understanding: PP 2007 – Design, Page layout, Inserting word art & pictures • Engagement: Destination PowerPoint Project • Closure –MS PowerPoint 2007

  31. ThursdayApril 1, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – PowerPoint Presentation 2007 • Deepening Understanding: PP 2007 – Design, Page layout, Inserting word art & pictures • Engagement: Destination PowerPoint Project • Closure –MS PowerPoint 2007

  32. FridayApril 12, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – PowerPoint Presentation 2007 • Deepening Understanding: PP 2007 – Design, Page layout, Inserting word art & pictures • Engagement: Destination PowerPoint Project • Closure –MS PowerPoint 2007

  33. MondayDecember 14, 2009 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Inserting Clip Art & text box in Excel • Deepening Understanding: Formatting an invoice • Engagement: Create an invoice for Classey Electronic • Closure – Review of Excel 2007

  34. TuesdayDecember 15, 2009 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – MS Office Publisher • Deepening Understanding: Formatting in MS Publisher • Engagement: Create a recipe booklet using MS programs – Create a cover to give the booklet as a gift • Closure – Compare Publisher, Word, & Excel

  35. Friday December 18, 2009 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – MS Office Publisher • Deepening Understanding: Formatting in MS Publisher • Engagement: Create a recipe booklet using MS programs – Create a cover to give the booklet as a gift • Closure – Compare Publisher, Word, & Excel

  36. TuesdayApril 13, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Introduction to Access • Deepening Understanding: Identify parts of Access Step 22.1 as a class • Engagement: Step-by-step 22.2 -22.5 • Closure – Uses for Access – What is a data base?

  37. WednesdayApril 14, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Introduction to Access – Queries/Reports • Deepening Understanding: Identify parts of Access as a class • Engagement: Inventory – change table & run Query • Closure – Uses for Access – What is a data base?

  38. WednesdayJanuary 6, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Review adding a table in Access • Deepening Understanding: Edit table in Access Steps 22.4 & 5 • Engagement: Step-by-step 22.6 -22.7 (page 319) • Closure – Access list other uses.

  39. ThursdayApril 15, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Review adding a table in Access • Deepening Understanding: Edit table in Access • Engagement: Creating the Resort Rental Database – 2 tables & 1 report • Closure – Access list other uses.

  40. FridayApril 16, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Watch Destination PowerPoint Presentations • Deepening Understanding: Creating table in Access • Engagement: Create a Customer & Worker table in Access • Closure – Access list other uses.

  41. April 19, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Creating forms in Access • Deepening Understanding: Modify a table • Engagement: Sidewalk Scrapers Database • Closure – Managing & using Reports in Access

  42. wednesdayJanuary 14, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Creating forms in Access • Deepening Understanding: Steps 23.1 • Engagement: Step-by-step 23.6 -23.9 (P338) • Closure – Managing & using Reports in Access

  43. TuesdayApril 20, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Earth Week • Deepening Understanding: Life Series with Oprah • Engagement: Earth Day activities on Internet • Closure – Recycle, Reduce, Reuse

  44. FridayJanuary 15, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Creating forms in Access • Deepening Understanding: Steps 23.9 • Engagement: Projects 23.1 - 23.3 (page 348) • Closure – Managing & using Reports in Access

  45. TuesdayJanuary 19, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Creating reports in Access • Deepening Understanding: Starting a Database from blank database • Engagement: Album Database • Closure – Managing & using Reports in Access

  46. WednesdayJanuary 20, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Creating reports & running Queries in Access • Deepening Understanding: Starting a Database from blank database • Engagement: Album Database & complete Project 23.1-23.3 (p348) • Closure – Living Online

  47. MondayApril 26, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Cyber bullying • Deepening Understanding: LMK Life Online • Engagement: Complete Cyber bullying packet & exercises on JCPS Online • Closure – Comprehension CASA

  48. TuesdayApril 27, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Cyber bullying • Deepening Understanding: You Can’t Take it Back • Engagement: Cyber bullying packet & exercises on JCPS Online • Closure – Comprehension CASA

  49. MondayMay 10, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Cyber bullying • Deepening Understanding: Standard Four Technology Comprehension • Engagement: Comprehension Scrimmages – Spreadsheet, Database, Word Processing, & Presentation • Closure – Comprehension CASA

  50. Tuesday May 11, 2010 • Establishing Engagement: • Sign in JCPS On-line • Fostering Connections – Cyber bullying • Deepening Understanding: Standard Four Technology Comprehension • Engagement: Comprehension Scrimmages – Operations/Concepts, Technology Research, Social/Ethical, & Telecommunications • Closure – Comprehension CASA

More Related