CURRICULUM MAPPING TEMPLATE



August/September

Texts Used: Office XP Introductory Concepts and Techniques and Advanced Concepts and Techniques

|Intro to Computers

*History

*Parts/Components

*Terminology

Word XP

Excel XP

|

Design a tutorial to teach class about assigned topic

Create cover letter and resume

Create professional newsletter

Setting up a mail merge

Create worksheet and embedded

chart

Determine formulas and

functions

Familiarize oneself with the

stock market, how it works

Investigate stocks for potential

mock purchase

Invest money at smartstocks

website

Analysis – using what-if

function

|

Word document or PPT, assessed with rubric

Projects 1, 3 (In the Lab 1&2), 4 (In the Lab 2), 5 (In the Lab 1 or 2), 6 (In the Lab 2&3)

Project 1, In the Lab #1&3

Project 2, In the Lab #2&3

(online tutorial)



Project 3, In the Lab #2

|

| |

|October |Access |Create a database using design |Project 1, Apply Your | |

| | |and datasheet views |Knowledge, In the Lab #2 | |

| | |Querying a database using the |Project 2, Apply Your | |

| | |select query window |Knowledge, In the Lab #2 | |

| | | |Project 3, Apply Your | |

| | | |Knowledge, In the Lab #2 | |

| | | | | |

| |FrontPage XP |Analyze current sites on web for |Observation | |

| |*Design Elements and |effectiveness |Worksheet (website analysis) | |

| |Considerations |Set up a web site |Observation | |

| |*Website Creation |Design 5 pages (personal) |Rubric | |

| | |Produce a website on a given |Rubric | |

| | |topic | | |

|November/December |MS Photodraw |Demonstrate 4 main steps to |Projects– Observations and | |

| | |creating a pdraw project |Rubrics to assess: | |

| | |Use text tools |*Business Cards | |

| | |Use Format and Fill options |*ID Cards | |

| | |Use Shapes and Line features |*Greeting Cards | |

| | |Use Cut and Crop |*Landscape Picture | |

| | |Use Cloning feature |*Face-Off | |

| | |Use 3 D effects |*Announcement/Post Card | |

| | |Show ability to edit images |*Flag Project | |

| | |using minimum of 3 methods |*Web Effects project | |

| | | | | |

| |Macromedia Fireworks |Edit bitmap images |Projects – Observations and | |

| | |Recognition of Tools |Rubrics to assess: | |

| | |Demonstrate ability to utilize |*Cloned Objects – sum pic | |

| | |window setup |*Egg Yolk – change hue | |

| | |Import objects |*Silhouette-Ski Pic | |

| | |Arrange layers |*Rounded edges | |

| | |Insert and format text |*Text on a path | |

| | |Demonstrate ability to mask |*Difference Mode | |

| | |Create unique animations |*Creating stars/shapes | |

| | | |*Creating 3D Sphere | |

| | | |*Web Commercial (as class) | |

| | | |*Commercial (with partner) | |

| | | |*Movie (Black History Month or President’s| |

| | | |Day) | |

| | | |*B-Day Card | |

| | | |*Text with sphere (bonus activity) | |

|December/January |Internet/Networking Unit |Create bookmarks |Observation | |

| | |Locate definitions for |Completed worksheet/vocab | |

|Text Used: Internet Concepts and | |networking terms |Quizzes | |

|Activities | |Identify potential questions after | | |

| | |filtering web information | |

| | |Discuss issues involving Internet |ones/bones.shtml | |

| | |Safety and/or personal info |Questionnaire – T/F and M/C | |

| | |Write a reflection about Dave | | |

| | |Lunzman’s presentation on |Written Reflection Paragraph | |

| | |Net Safety | | |

| | |Appreciate tour at DSU of their | | |

| | |network and innovative |Written Reflection | |

| | |technologies | | |

| | | | | |

| |Cross Curricular Projects – utilizing all |Combine elements of all software learned |Projects to choose from: (The Job, The | |

| |office software |this semester |Menu, Let’s Eat, The Wedding, The Teacher,| |

| | | |The Recipe Book, Fish – the Philosophy) | |

| | | |**All assessed with rubrics | |

Need to do for Class of 2010:

|When and where it fits |SDCAP testing : Future Plans (joint project with |Complete interest inventory and |Interest Inventory |

| |counselor) |other online profiles |Online Profiles (Counselor) |

| | |Determine personality |Jelly Bean Activity/profile |

| | |Research information about post |Reaction paragraph from |

| | |high school options |Minnesota West guest speaker |

| | |Record and organize |Completed Worksheets |

| | |information on worksheets |resources |

| | |Plan story board, create ppt |PowerPoint Presentation – rubric |

| | | |that assesses it |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download