Andre' Lo - Course Description

» Campus Home | » Email Your Teacher | » Help

Andre' Lo

Mind is a terrible thing to waste

		Home
		Syllabus
		Course Description
		Powerpoint Download
		BCIS Test and documents Download
		TEKS for BCIS
		Our Calendar
		Soccer

1st Six Weeks Period
		LESSON ONE Welcome back statement Introduction: · Myself · Each others · Course requirement · Rules & Regulations Assignments: · Documents (signatures) LESSON TWO Collect paper works Word search Internet Research – computer history, today in the history of computers www.computerhistory.org LESSON THREE Bingo game – get to know each other Keyboarding: Keyboarding skills builder: Lesson A & B · Print reports for grade LESSON FOUR Present and discuss: · Power point in History of Computer Definitions form notes & decoding paper Jeopardy game for History of Computer Keyboarding: Lesson C LESSON FIVE Word Matching Type business letters – Full block Review Power point for Test Keyboarding: Lesson D LESSON SIX Test – History of Computer Show – Paint Practice Paint on keyboard Keyboarding: Lesson E LESSON SEVEN History of Computer Review · Power Point · Matching worksheet · Study for Quiz in next period Keyboarding · Lesson F – Skill Builder Section LESSON EIGHT History of Computer Jeopardy Internet Research: · Discuss o websites can have misinformation o find answers for the following topics on at least two websites · Labor Day · Hawaii Keyboarding · Lesson G – Skill Builder LESSON NINE History of Computer Test Internet Research · Abraham Lincoln Search Keyboarding · Lesson H – Skill Builder LESSON TEN Microsoft Office Introduction Part 1: Review of Microsoft Office Basic · Appendix A, B & C · Power point Presentation – Part 1 · Task 1 – 8 · Test – Part 1 Keyboarding: Lesson I LESSON ELEVEN Part 2: Using of Internet · Power point presentation – Part 2 · Task 1 – 3 · Review: o Application 1 & 2 o Test – Part 2 Keyboarding: Lesson J Project 4: Computer Ethic o Create a personal code of ethic TEKS: 1A, 1B, 1D, 1E & 6D LESSON TWELVE Using of Internet · Power Point presentation – Part 3 Task – Part II: Internet · Favorites Keyboarding: Lesson K TEKS: 1A, 1B, 1D, & 6D LESSON THIRTEEN Word Introduction · Power Point presentation – Part 3 · Read & discuss P.26 – 31 & 28 – 33 · Internet research - Texas Keyboarding: Lesson L LESSON FOURTEEN Word Basic and Editing Part I: Task 1 – open word, view document screen Task 2 – key text, save as “Time Plan” Task 3 – change view Task 4 – move the insertion point Task 5 – select text Task 6 – backspace, delete, Print TEKS: 1D, 3E Keyboarding: Full Block Letter; save as Full block letter LESSON FIFTEEN Part I Task 7 – undo, redo, overtype Task 8 – cut, copy, paste Task 9 – drag, drop Task 10 – print preview, page orientation · Open IW Task 1 – 10, save as Time Management TEKS: 3E Keyboarding : Modified Block Letter; save as Modified block letter LESSON SIXTEEN Part I Application 1 – open, save, key orientation, preview & print · IW App1-1, save as Study Skills Lecture Application 2 – open new document, key, save & print · Save as Thank You Letter Application 3 – key, drag and drop, copy, & paste · IW App1-3, save as SLW Checklist Application 4 – key, overtype, undo, cut, & paste · IW Appl-4, save as Golf Tournament TEKS: 1D, 3D, 3Fi Keyboarding: Lesson M LESSON SEVENTEEN Part I Test Part I Word Test 1A Application 5 – overtype, cut, paste, drag and drop, delete · IW Appl-5, save as Job Interview Application 6 – edit, proofreader’s marks, save & print · IW Appl-6, save as Telephone TEKS: 1D, 3D Keyboarding: Lesson N

2nd Six Weeks Period
		Part II Helpful Word Features LESSON ONE Task 1 – Create New Folder · IW Task2-1 · Create a folder New York City Trip · Save as IW Task2-1 NYC Agenda Task 2 – AutoCorrect, AutoFormat As You Type · Use opened document to make corrections per instructions Task 3 – Automatic Spell and Grammar Check Task 4 – AutoComplete, AutoText Task 5 – Use AutoCorrect to insert Frequently Used Text · Check the work against the document on Introductory Word 28 · Save & Print for grade TEKS – 3.E Keyboarding: Lesson O LESSON TWO Task 6 - Spelling and Grammar Check · IW Task2-6 · Save in New York City Trip folder as NYC Letter Task 7 – Insert Date, Thesaurus Task 8 – Find, Replace · Check the work against the document on Introductory Word 31 · Save & Print for grade TEKS – 3.E; 3.F.i Keyboarding: Lesson P LESSON THREE Application 1 – AutoCorrect, Thesaurus, Replace · Key in new document on Page IW 32 · Save as Guidelines · Print Application 2 – Spell Check, Proofreader’s Marks · IW App2-2 · Save as Body Language Application 3 – Insert Date, AutoText, AutoComplete · IW App2-3 · Save as Business Letter Application 4 – Thesaurus · IW App2-4 · Save as New York City Trip TEKS – 3.D; 3.F.i; 1.D Keyboarding: Lesson Q LESSON FOUR Application 5 – Spelling and Grammar Check, Insert Date, AutoComplete, Find, Replace, Thesaurus · IW App2-5 · Save as Marina Minutes · Print for grade Keyboarding: Lesson R Part II Test · Word Test 2 &b LESSON FIVE Part III Format Text and Paragraphs Task 1 – Formatting Toolbar, Font Dialog Box, Apply a New Font · IW Task 3-1 · Save as Financial Planning Task 2 – Change Font Size and Color Task 3 – Font Style, Font Effects Task 4 – Underline Style and Color, Highlights Task 5 – Change Case, Format Painter Task 6 – Margins, Adjust Line Spacing · Save as Financial Planning · Print Task 7 – Align Text Task 8 – Indent Text (don’t print) Task 9 – Apply Styles, Vertical Alignment · Save as Financial Planning Title · Print TEKS: 3.E LESSON SIX Part III (continue…) Review previous work Application 1 & 2 – Font Size, Color, Bold, Italic, Page Orientation, Underline Style, Format Painter IW App 3-1 – Save as Certificate · Print IW App 3-2 – Save as Guidelines · Print Application 3 – Font, Font Size, Alignment, Vertical Alignment · IW APP 3-3 · Save as Weeding · Print Application 4 – Change Font, Alignment, Line Spacing, Margins · IW App 3-4 · Save as Realtors Online · Print Application 5 – Spelling and Grammar Check, Replace Text, Cut and Paste, Thesaurus, Change Font, Line Spacing, Font Effect, Style · IW App 3-5 · Save as Camp · Print TEKS: 3.E Keyboarding: Lesson S LESSON SEVEN Part III (continue…) Review Assignment: “Diving in the Cayman Islands” Part III Test – “Brazil” TEKS: 3.E, 3.D LESSON EIGHT Keyboarding: Lesson T Off date for catch up LESSON NINE Adjust to 3rd six weeks (Part IV)

3rd Six Weeks Period
		LESSON ONE Part IV Working with Documents Task 1 – Switch between Documents, Copy and Paste between Documents · IW Task 4-1 · Save as Financial Planning Final · IW Task 4-1a · Save as Financial Title 2 Task 2 – Insert Page Break Task 3 – Insert Header, Footer, Page Numbers · Save & Print on screen Task 4 – Bulleted and numbered Lists, Outline Numbered Listed · IW Task 4-4 · Save as Outline · Print Task 5 – Tabs, Sort · IW Task 4-5 · Save as Equipment · Print Task 6 – Insert Table · IW Task 4-6 · Save as Voting Memo Task 7 – Format, Revise Table Task 8 – Modify a Table, Add Borders, Shading · Save & Print TEKS: 1.E, 3.Fiii, 3.F.iv Keyboarding: Lesson U LESSON TWO Review previous works Application 1 – Tabs, Sort · IW App 4-1 · Save as Shipping Rates · Print Application 2 – Copy between Documents, Footer, Insert Page Number · IW App 4-2 · Save as Guidelines Final · Print Keyboarding: Lesson V LESSON THREE Application 3 – Outline Numbered List · Create a new word document · Save as Agenda · Print Application 4 – Tabs · Create a new word document · Save as Resume · Print Application 5 – Table, AutoFormat Table, Highlight · IW App 4-5 · Save as Baseball Schedule · Print TEKS: 1.E, 3.D, 3.Fvi Keyboarding: Lesson W LESSON FOUR Review Part IV Bullets Exercise 28 & 18 · Key document · Save & print Keyboarding: Lesson X LESSON FIVE Part IV Test LESSON SIX Part V Desktop Publishing Task 1 – Create Columns, Format Text · IW Task 5-1 · Save as PTA Newsletter Task 2 – Paragraph Borders, Shading Task 3 – Insert Clip Art Task 4 – Select, Resize Clip Art · Print TEKS: 3.F.ii; 3.F.v Keyboarding: Lesson Y LESSON SEVEN Task 5 – Page Break · IW Task 5-5 · Save as Wedding 2 Task 6 – Draw Graphics · Open New Document · Save as Park Map Task 7 – Edit Drawings Task 8 – add Colors, Line Styles to Objects Task 9 – Add Text to Drawings · Print Task 10 – Add Chart · IW Task 5-10 · Save as Organization Chart · Print TEKS: F.ii LESSON EIGHT Application 1 – Change Font, Alignment, Columns, Clip Art, Bullets · IW App 5-1 · Save as Paw Newsletter · Print Application 2 – Clip Art, page Border, Change Font · New Document · Save as Holiday Invitation · Print Application 3 – Draw Tools, Change Font · New Document · Save as House Sale Poster · Print Application 4 – Key Text, Text Box · New Document · Save as Key Financial Diagram · Print Application 5 – Key Text, Clip Art · New Document · Save as Key Cover Letter · Print TEKS: 1.E; 3.D; 3.F.ii; 3.F.v Keyboarding: Lesson Z LESSON NINE Part V Test Integrated Simulation Job 1 – Create Letterhead, Insert Clip Art, Key Letter · New Document · Save as Association Letter · Print Job 2 – Create Table · New Document · Save as Camper Table · Print TEKS: 3.C; 3.F.i LESSON TEN Semester Final

4th Six Weeks Period
		LESSON ONE Internet Research Martin Luther King Jr. o Worksheet LESSON TWO Integrated simulation exercises Job 1 & 2 (P.100 – 102) o Print for grade LESSON THREE Internet Research JFK o Worksheet LESSON FOUR Movie: Greatest American Speeches Review – MLK & JFK worksheets LESSON FIVE “Excel Unit” Part I Excel Basic Task 1 – Open Spreadsheet, Identify Worksheet Parts, Save Worksheet with Different Name · IE Task 1-1 · Save as Time Spent Task 2 – Move within Spreadsheet, Insert Column, Enter Data Task 3 – Insert Row Task 4 – Change Data, Verify Data Task 5 – Preview, Print Task 6 – create a New File · Create a new spreadsheet · Save as My Grade · Print LESSON SIX Application 1 – Open Spreadsheet, Save Workbook, Insert Row, Enter Data, Preview, Print · IE App 1-1 · Save as Accident Report · Print Application 2 – Replace Data · App 1-2 · Save as Home Down payment · Print Application 3 – Move within Spreadsheet · App 1-3 · Save as Budget Results · Print Application 4 – Insert Column · App 1-4 · Save as Game Statistics · Print LESSON SEVEN Part II Spreadsheet Appearance Task 1 – Change Font & Font Size · IE Task 2-1 · Save as Fruit Stand Task 2 – Change Column Width, Change Row Height Task 3 – Format Numbers, Format Currency Task 4 – Bold, Italics, Underline Task 5 – Borders, Fill Color, Text Color Task 6 – Wrapping, Rotating, Indenting, Aligning · Save & Print TEKS: 4.B.iv LESSON EIGHT Catch up date LESSON NINE Application 1 – Widen Columns, Reduce Row Height, Format Numbers, Bold, Underline, Fill with Color · IE App 2-1 · Save as Maple Syrup Production · Print Application 2 – Merge, Center, Change Font Color · IE App 2-2 · Save as Mesa Cafés · Print Application 3 – Format for Currency · IE App 2-3 · Save as Off Road Bikes · Print Application 4 – Change Format, Change Style, Fill with Color, Insert Borders, Rotate Text · IE App 2-4 · Save as Beet Red Bookstore · Print TEKS: 4.B.vi, 4.B.i LESSON TEN Movie: LESSON ELEVEN Application 5 – Change Font, Change Font Size · IE App 2-5 · Save as Limpia Creek Football · Print Application 6 – Wrap Text, Center Text · IE App 2-6 · Save as Antex · Print Application 7 – Indent Text · IE App2-7 · Save as Crop summaries · Print LESSON TWELVE Excel Test 1 Special Assignment: · Create a new Spreadsheet · Save as Referees · Print

5th Six Weeks Period
		LESSON ONE Part III Organizing a Spreadsheet Task 1 – Cut, Paste, and Drag to Move Data · IE Task 3-1 · Save as MWSL Task 2 – Copy, Paste, and Drag to Copy Data Task 3 – Fill Down Task 4 – Replace, Delete Data · Save & Print Task 5 – Fill Right · IE Task 3-5 · Save as Garmin · Print Task 6 – AutoFill · IE Task 3-6 · Save as Banner Travel · Print Application 1 – Fill Right · IE App 3-1 · Save as Jay’s Assets · Print TEKS: 4.B.v LESSON TWO Application 2 – AutoFill, Fill Down, Delete · IE App 3-2 · Save as Office Supply Inventory · Print Application 3 – AutoFill Weekdays, Fill Right · IE App 3-3 · Save as Burro Path Links · Print Application 4 – Move, AutoFill Weekdays, Copy, Replace Data · IE App 3-4 · Save as Calorie Counter · Print TEKS: 4.B.iii Part IV Calculation LESSON THREE Task 1 – Enter Formulas with Relative Cell References Task 2 – Delayed Calculation § IE Task4-1 § Save as Payroll § Print Task 3 – Order of Evaluation, Modify Formula with Formula Bar § IE Task4-3 § Save as Drama Attendance § Print Task 4 – Enter Formulas with Absolute Cell References § IE Task4-4 § Save as Your Time § Print TEKS: 4A.i, 4A.ii, 4Aiii, 4B.ii LESSON FOUR Application 1 – enter Formulas with Relative Cell reference § IE App4-1 § Save as Census § Print Application 2 – Order evaluation § IE Appl4-2 § Save as Football Score § Print Application 3 – Enter formulas with Absolute Cell references, Modify Formula with the Formula Bar § IE Appl4-3 § Save as Apartment Expenses § Print LESSON FIVE Application 4 – Delayed Calculation § IE Appl4-4 § Save as Interest Charge § Print Application 5 – Enter Formulas with Relative and Absolute Cell References § IE Appl4-5 § Save as Currency Conversion § Print Application 6 – Enter Formulas with Relative Cell Reference § IE Appl4-6 § Save as Tax Estimation § Print LESSON SIX Test Part IV Part V Function Formulas LESSON SEVEN Task 1 – Enter a SUM Function Formula Task 2 – Enter Date and Time Function Formulas § IE Task5-1 § Save as Fundraiser § Print Task 3 – Enter Statistic Function Formulas, Drag to Enter Range Task 4 – Enter Logical Function Formulas § IE Task5-3 § Save as Class Grade § Print Task 5 – Enter Financial Function Formulas § IE Task5-5 § Save as Interest Payment § Print LESSON EIGHT Application 1 – Enter SUM and Statistical Function Formulas § IE Appl5-1 § Save as Factory Production § Print Application 2 – Enter IF, NOW, and SUM Function Formulas § IE Appl5-2 § Save as Boreal § Print Application 3 – Enter Statistical Function Formulas § IE Appl5-3 § Save as Cross Country § Print Application 4 – Enter as IF Function Formula § IE Appl5-4 § Save as Bring My Jacket § Print Part VI Charts LESSON NINE Task 1 – Create Pie Chart § IE Task6-1 § Save as Survey Results § Print Task 2 – Create, Modify Column Chart § IE Task6-2 § Save as School Dropout § Print Task 3 – Create, Modify a Line Chart § IE Task6-3 § Save as Batting Average § Print Task 4 – Create a Stacked Column Chart § IE Task6-4 § Save as Product Mix § Print TEKS: 4.B.viii, 4.A.v LESSON TEN Application 1 – Create a Pie Chart § IE App6-1 § Save as Personal Expenditures § Print Application 2 – Insert Labels in a Chart § IE App6-2 § Save as Schedule § Print Application 3 – Create a Column Chart § IE App6-3 § Save as Violent Crime § Print Application 4 – Use Guidelines in a Chart § IE App6-4 § Save as Pay Increases § Print LESSON ELEVEN Application 5 – Create a Line Chart § IE App6-5 § Save as Inventory Change § Print Application 6 – Changing Label Fonts in a Chart § IE App6-6 § Save as Teenage Pregnancy § Print Application 7 – Create a Stacked Column Chart § IE App6-7 § Save as Grade Inflation § Print LESSON TWELVE Integrated Simulation – “Association for Hearing Impaired Children” Job 1 – Create a Spreadsheet, Enter Formulas § Create a New Spreadsheet file § Save as Funds Job 2 – Copy, Link Data from spreadsheet to Word Processing § Save as Fund Link Job 3 – Copy Data from Word Processing to Spreadsheet § Print TEKS: 3.C LESSON THIRTEEN Test Part V & VI PowerPoint Part I PowerPoint Basic LESSON FOURTEEN Task 1 – Start PowerPoint, Open and View Existing Presentation, Save Presentation Task 2 – Change Views Task 3 – Use Menus and Toolbars Task 4 – Delete Slides Task 5 – Print Presentations, Exit PowerPoint § IP Task1-1 § Save as Tornado § Print LESSON FIFTEEN Application 1 – Start PowerPoint, Open Presentation, Close Presentation Application 2 – Save a Presentation § IP App1-1 § Save as Geography Presentation § Print Application 3 – Use Menus, Change Views, Print a Presentation Application 4 – Use Toolbars Application 5 – Delete a Slide, Use Speaker Notes § IP App1-3 § Save as Jazz Presentation § Print TEKS: 8.B, 8.C LESSON SIXTEEN TEST PowerPoint Part I End of 5th six weeks

6th Six Weeks Period
		Part II Enhancing a PowerPoint Presentation LESSON ONE Task 1 – Create Presentation Task 2 – Apply Design Templates Task 3 – Change Color Schemes, Add or Change Slides Animation Task 4 – Format a Single Slides Task 5 – Use the Slide Master Task 6 – Work with Text, add Text to Slides § Save as Website LESSON TWO Task 7 – Add Notes to a Slide Task 8 – Change Alignment, spacing, Case, and Tabs Task 9 – Working with Bullets Task 10 – Change Text Appearance Task 11 – Check Spelling, Style Task 12 – Add a Slide § Save as Website LESSON THREE Task 13 – Apply slide Layouts Task 14 – Use Multimedia, Work with Clipart Task 15 – Customize Animation Task 16 – Insert a Hyperlink Task 17 – Add a Sound Task 18 – Add a Header or Footer Task 19 – Use Slide transition Task 20 – Save as Rich Text Format § Save as Web Site § Print TEKS: 8.A, 8.B, 8.C LESSON FOUR Application 1 – Create Presentation, Use slides, Use slide Master, Work with Text on Slides Application 2 – Add Multimedia to Slides, Use Slide Transitions, Format Slides § IP App2-2 § Save as Prairie Dogs Application 3 – Change Bullet Appearance, Add Footer Part III Working with Visual Elements LESSON FIVE Task 1 – Work with Organization Charts Task 2 – Modify Organization Charts Task 3 – Build a Chart Task 4 – Modify a Chart Task 5 – Create Tables Task 6 – Modify Tables § IP Task3-1 § Save as Buffalo LESSON SIX Task 7 – Draw Objects, Add Shapes, Select Objects Task 8 – Select Objects, Select More Than One Object, Group, and Rotate an Object Task 9 – Apply Formatting, Fill Objects, Change Line Color Task 10 – Scale, Size Objects, Copy, Move Objects Task 11 – Create a Text Box § Save as Buffalo § Print a handout with 6 slides LESSON SEVEN Application 1 – Build, Modify organization Charts, Create a Text box, Draw, Scale, and size objects § IP App3-1 § Save as Prairie Dogs3 Application 2 – Build. Modify Charts § IP App3-2 § Save as Hawaii Economy Application – Build, Modify Tables; Rotate, Fill Objects § IP App3-3 § Save as Hawaii Agriculture LESSON EIGHT Integrated Simulation Job 1 – Create Presentation § New Presentation § Save as Camp Presentation Job 2 – Embed Table in Presentation § Camp Table.doc § Save Job 3 – Link a Spreadsheet in a Presentation § Funds.xis § Save § Print with 6 slides § Close camper table & Funds TEKS: 3.C LESSON NINE Test PowerPoint – Part III

©2006 Pine Tree ISD - All rights reserved.