ic3

MS. CURTISSYLLABUS

CLASSROOM EXPECTATIONSTEXTBOOK – COMPUTER LITERACY BASICS

JCPS ON-LINE

IC3

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 ________.

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

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 ________________.

FridayFebruary 26, 2010


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

March 1, 2010


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?

March 2, 2010


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?

MondayNovember 16, 2009


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? ___________

TuesdayNovember 17, 2009




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.

WednesdayMarch 3, 2010




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.

ThursdayMarch 4, 2010




Authentic Engagement: Projects 18-1, 18-2, & 18-3 (Module 2 – page 220) Miles per Gallon & Test Score Results

Closure: Chapter 18 Formulas

FridayMarch 5, 2010




Authentic Engagement: Projects 18-1, 18-2, & 18-3 (Module 2 – page 220) Building Dice

Closure: Chapter 18 Formulas

ThursdayNovember 19, 2009




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

MONDAYMARCH 8, 2010


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

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

WEDNESDAYMARCH 10, 2010



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

THURSDAYMARCH 11, 2010

Establishing Engagement: Sign in JCPS On-line 6N56L1


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

FRIDAYMARCH 12, 2010



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

MONDAYMARCH 12, 2010


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

TUESDAYMARCH 16, 2010


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

WEDNESDAYMARCH 17 2010


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

THURSDAYMARCH 18, 2010



Deepening Understanding: Excel 2007 – Creating an absolute cell reference =(D3*$J$3)

Engagement: CASA Scrimmages – Cyber & Postal


MondayMarch 22, 2010


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)


TuesdayMarch 23, 2010


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


Establishing Engagement: Sign in JCPS On-line & Tool tips

Fostering Connections: Merge & Center, formatting in Excel

Deepening Understanding: Excel 2007 – Engagement: Class Quiz ScoreClosure – CASA Test

ThursdayMarch 25, 2010


Fostering Connections: www.whitehouse.govDeepening Understanding: Past US Presidents

– current president, blogs weekly videos Engagement: Presidential Cyber InterviewClosure – CASA Test

FridayMarch 26, 2010


Fostering Connections: Grade sheetsDeepening Understanding: Missing

assignments/0’sEngagement:

CASA Scrimmages JCPS On-line (4 Fuel, Cyber Abuse, Global, & Postal)

Roth’s Invoice Charts (9)


MondayMarch 29, 2010



Deepening Understanding: Excel 2007 – Review for CASA Test

Engagement: CASA TestClosure – Review of MS PowerPoint 2007

TuesdayMarch 30, 2010


Fostering Connections – PowerPoint Presentation 2007

Deepening Understanding: PP 2007 – Design, Page layout, Inserting word art & pictures

Engagement: Destination PowerPoint ProjectClosure –MS PowerPoint 2007

ThursdayApril 1, 2010





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

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


Fostering Connections – MS Office PublisherDeepening 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

TuesdayDecember 15, 2009


Fostering Connections – MS Office PublisherDeepening 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

Friday December 18, 2009


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?

TuesdayApril 13, 2010


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?

WednesdayApril 14, 2010


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.

WednesdayJanuary 6, 2010


Fostering Connections – Review adding a table in Access

Deepening Understanding: Edit table in Access

Engagement: Creating the Resort Rental Database – 2 tables & 1 report


ThursdayApril 15, 2010

FRIDAYAPRIL 16, 2010


Fostering Connections – Watch Destination PowerPoint Presentations

Deepening Understanding: Creating table in Access

Engagement: Create a Customer & Worker table in Access


APRIL 19, 2010Establishing Engagement:

Sign in JCPS On-lineFostering Connections – Creating forms in Access

Deepening Understanding: Modify a table

Engagement: Sidewalk Scrapers Database

Closure – Managing & using Reports in Access

WEDNESDAYJANUARY 14, 2010


Fostering Connections – Creating forms in Access

Deepening Understanding: Steps 23.1

Engagement: Step-by-step 23.6 -23.9 (P338)


TUESDAYAPRIL 20, 2010


Fostering Connections – Earth Week

Deepening Understanding: Life Series with Oprah

Engagement: Earth Day activities on Internet

Closure – Recycle, Reduce, Reuse

FRIDAYJANUARY 15, 2010


Fostering Connections – Creating forms in Access

Deepening Understanding: Steps 23.9

Engagement: Projects 23.1 - 23.3 (page 348)


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

WednesdayJanuary 20, 2010


◦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

MondayApril 26, 2010


◦Fostering Connections – Cyber bullying

◦Deepening Understanding: LMK Life Online

◦ Engagement: Complete Cyber bullying packet & exercises on JCPS Online

◦Closure – Comprehension CASA

TuesdayApril 27, 2010


◦Fostering Connections – Cyber bullying

◦Deepening Understanding: You Can’t Take it Back

◦ Engagement: Cyber bullying packet & exercises on JCPS Online

◦Closure – Comprehension CASA

MondayMay 10, 2010


Fostering Connections – Cyber bullying

Deepening Understanding: Standard Four Technology Comprehension

Engagement: Comprehension Scrimmages – Spreadsheet, Database, Word Processing, & Presentation

Closure – Comprehension CASA

Tuesday May 11, 2010


Fostering Connections – Cyber bullyingDeepening Understanding: Standard

Four Technology Comprehension Engagement: Comprehension

Scrimmages – Operations/Concepts, Technology Research, Social/Ethical, & Telecommunications


ThursdayMay 6, 2010


Fostering Connections – Open MS Word

Deepening Understanding: Follow directions on handout

Engagement: Type Ice Cream Paint Job (insert pictures & border)


WednesdayMay 12, 2010


Fostering Connections – Grade sheetDeepening Understanding:

Complete any missing work Engagement: FBI Scavenger Hunt,

CASA ScrimmagesClosure – Comprehension CASA

FridayMay 14, 2010


Fostering Connections – Excel & Word

Deepening Understanding: Creating charts & Import into Word

Engagement: Silver Hills ResortClosure – Comprehension CASA

FridayJanuary 29, 2010


Fostering Connections – Living On-line

Deepening Understanding: GRADE SHEETS

Engagement: Computer Hardware worksheet, FBI-SOS.org, Comprehension Scrimmages


MondayFebruary 1, 2010

▫Establishing Engagement: Sign in JCPS On-line

▫Fostering Connections – Living On-line – Moving and Living Independently

▫Deepening Understanding: Compare job offers from four companies in different cities

▫ Engagement: www.homefair.com ▫Closure – Comprehension CASA

TuesdayFebruary 2, 2010


▫Fostering Connections – Living On-line – Moving and Living Independently www.homefair.com

▫Deepening Understanding: Compare job offers from four companies in different cities

▫ Engagement: Study guide for Test & complete Moving & Living Independently

▫Closure – Comprehension CASA

Monday May 17, 2010


▫Fostering Connections – Review Study Guide

▫Deepening Understanding: Discuss concerns over questions

▫ Engagement: – Comprehension CASA

▫Closure Photos

WednesdayMay 19, 2010


▫Fostering Connections – Create documents in Publisher

▫Deepening Understanding: Inserting Shapes & text

▫ Engagement: – Create Learning Pyramid & What is Success

▫Closure Photos

TuesdayMay 25, 2010

▫Establishing Engagement: JCPS Online

▫Fostering Connections – Windows Movie Maker

▫Deepening Understanding: Making a movie using photos

▫Authentic Engagement: Start assembling a movie

▫Closure: Final - Tuesday

Friday May 21, 2010


▫Fostering Connections – Adobe Photoshop▫Deepening Understanding: Copy photo in

your documents from 031-Net Apps▫Authentic Engagement: Work in Photoshop▫Closure

ThursdayMay 27, 2010



▫www.soundzabound.com – shsmca – login & password

▫Deepening Understanding: Adding music & Adjusting time for each photo/music


▫Closure: No School Monday June 30▫Last Day of School June 1, 2010

http://www.soundzabound.com/

WednesdayFebruary 17, 2010



▫www.soundzabound.com – shsmca – login & password

▫Deepening Understanding: Adding music & Adjusting time for each photo/music


▫Closure: Finals Friday


FridayFebruary 19, 2010


▫Fostering Connections – Windows Movie Maker – saving movie as a movie file

▫Deepening Understanding: File should be first & last name Browse- put movie in 031-Net Apps Curtis computer Apps Appropriate folder (1,2, 4)

▫Authentic Engagement: Final▫Closure: Watching Movies

•www.soundzabound.com – shsmca


ic3

Documents

parts of excel

dataauthentic engagement

deepening understanding

linefostering connections

auto fillauthentic engagement

jcps onlineclosure

worksheet data

document stepbystep