|
Capacitación
- Escuelas -
Empresas
|
  |
|
The Fourth R | Cursos |
|
|
|
Table of Contents Elementary Concepts FTS0A Elementary Concepts
GETTING STARTED • MOUSE AS AN INPUT DEVICE • USING TIP OF ARROW TO CHOOSE • GOOD HABITS • OPEN A PROGRAM USING THE ICON • INTRODUCTION TO KID PIX STUDIO • CLOSE A PROGRAM KEYBOARDING BASICS • KID PIX STUDIO STAMPS • SHAPE CHALLENGE • KEYBOARD INTRODUCTION INTRODUCTION TO JUMP START KINDERGARTEN • ENTER KEY • INTRODUCTION TO JUMP START • JUMP START READING GRAPHIC ACTIVITIES • CREATE YOUR OWN STORY • HOME ROW KEYBOARDING BUILD CREATIVITY • JUMP START PAINTING • MENUS (START MENU)5-3 MUSIC • JUMP START MUSIC • HOME ROW KEYBOARDING REVIEW PATTERNS • JUMP START PATTERNS • COLLAGE READING • NAME OF COMPUTER PARTS • JUMP START PHONICS MATH • KEYBOARDING REVIEW • JUMP START MATH ARTISTIC DESIGNS • KID PIX STUDIO - ANIMAL • KID PIX – COLORING THE COMPUTER SYSTEM • OPERATING SYSTEM • ADJUSTING SPEAKERS • INPUT/PROCESS/OUTPUT • KID PIX – AIRPLANE • SHUTTING DOWN THE COMPUTER FINAL PROJECT • KID PIX PROJECT
Table Contents of Patterns Logic Thinking FTS0B Patterns Logic Thinking
GETTING STARTED • MAXIMIZE, MINIMIZE, AND RESTORE • GOOD KEYBOARDING HABITS • SMALL, MEDIUM, LARGE INTRODUCTION TO FRIPPLES • GETTING STARTED WITH THINKIN’ THINGS FRIPPLETOWN • FRIPPLETOWN COOKIES KID PIX FUN • CREATE A CARD • FLOPPY DISK DRIVE • KEYBOARDING - NUMBERS, LETTERS • PIXELS GRAPHIC ACTIVITIES • CD-ROM - CORRECT HANDLING/ CLEANING LOAD/ EJECT • MAKE A BOOK • KEYBOARDING DATE AND TIME • COMPUTER CLOCK • CALENDAR ACTIVITY PRINTING AND PATTERNS • INTRODUCTION TO PRINTERS • FRIPPLETOWN SKATE PARK COMPUTER HARDWARE • COMPUTER PARTS • RECORDING SOUND • HOME ROW KEYBOARDING REVIEW DESIGNS • FRIPPLETOWN FLAGS PRACTICING WHAT YOU KNOW • WORDPAD ENTRY • HATS • MEASURE DIRECTIONS AND MAPS • FRIPPLETOWN DELIVERIES • KID PIX STUDIO MAPS AMAZING WORK • KID PIX – MAZE • KID PIX AND PAINT FINAL PROJECT • KID PIX PROJECT
Table Contents of Getting Started FTS1A Getting Started
BASICS OF A COMPUTER/ INTRO TO KID PIX • POWER THE COMPUTER ON / OFF • MOUSE BASICS • INTRODUCTION TO KID PIX • SAVE A FILE COMPUTER HARDWARE • GOOD HABITS • COMPUTER POWER AND DATA CABLES • ELEMENTS OF A WINDOW • STORAGE DEVICES SOFTWARE PROGRAMS • KEYBOARD BASICS • EXPLORE THE START MENU • PROGRAMS AND ASSOCIATED ICONS • MINIMIZE AND MAXIMIZE A WINDOW • PRINTING MORE KID PIX • DESIGN A BUG • ADD SIMPLE TEXT • OPEN A FILE • IMPORT A PICTURE • EDIT A PICTURE INSIDE A COMPUTER AND KID PIX • DISSECT A COMPUTER • KID PIX DELUXE 3 PROGRAM BASICS OF WORD PROCESSING • WORD PROCESSING MENUS AND BUTTONS • BASIC WORD PROCESSING OPERATIONS • CHARACTER MAP INTERNET BASICS • INTERNET SEARCHING • COPY INTERNET INFORMATION • COPYRIGHT RULES • QUALITY OF ONLINE INFORMATION • IMPORT AN INTERNET PICTURE INTO WORD WRITING A STORY • IMPORT A PICTURE INTO WORD • WRITE A STORY • EDIT A STORY • WORKING WITH SOUND FILES • WORKING WITH VIDEO FILES MULTIMEDIA • INTRODUCTION TO A SLIDESHOW PRODUCING A SLIDESHOW • COMPLETE THE SLIDESHOW • REVIEW
Table Contents of Adventures in Writing FTS2A Adventures in Writing
SPIN A STORY • OPERATING SYSTEMS AND MENUS • SPIN A STORY • SPIN A STORY ON THE INTERNET (OPTIONAL) SPIN A POEM • INPUT/ PROCESS/ OUTPUT • BROWSE POEM SITES • KID WORKS DELUXE SPIN A POEM WRITING AND ILLUSTRATING POEMS • WRITE A LIMERICK POEM • KID PIX • SENSE MATRIX USING KID WORKS STORY STARTERS • SENSE MATRIX POEM • SECRET CODE • SECRET CODE CHALLENGE MAPS AND CHALLENGES • CAPTURE IMAGES • EMAIL WITH ATTACHMENTS (OPTIONAL) • KID PIX DELUXE MAKE THIS PICTURE WORD PROCESSING CHALLENGES • SURF FOR MAPS • MAKE A REAL MAP STORY CHALLENGES • STORY CHALLENGE MORE WORD PROCESSING CHALLENGES • KEYBOARD SHORTCUTS • SCROLL BARS • COMPUTER TRIVIA CHALLENGES • WORD PROCESSING CHALLENGE COMPARING PRODUCTS • MULTI-TASKING IN WINDOWS • KID WORKS DELUXE VS. KID PIX STUDIO • BRAINSTORMING • FINAL PROJECT: CREATE TEXT COLLECTING DATA • FINAL PROJECT: ADD TEXT • COLLECTING PICTURES • FINAL PROJECT: ADD GRAPHICS CONCLUDE PROJECT • FINAL PROJECT: ADD AUDIO • COMPLETE PROJECT
Contents of Fundamental Technology Skill Series FTS3A Keyboarding Wizard
PREFACE • COURSE OBJECTIVES • COURSE PREREQUISITES • SECTION TIMINGS • FUNDAMENTAL TECHNOLOGY SKILLS COURSEWARE SERIES (K-6) • ASSESSMENT GETTING READY TO KEYBOARD KEYBOARDING CONTINUE KEYBOARDING KEYBOARDING COMPETITION APPENDIX • KEYBOARD LOG • ERGONOMICS
Table Contents of Word Processing FTS3B Word Processing
GETTING STARTED WITH MICROSOFT WORD • GETTING STARTED WITH WORD PROCESSING • CREATE A DOCUMENT • FONTS CREATIVITY IN WORD • SPECIAL CHARACTERS • MODIFYING TEXT IN A DOCUMENT • MOVING TEXT IN A DOCUMENT • COPY TEXT IN A DOCUMENT MODIFYING A WORD DOCUMENT • PARAGRAPH LINE SPACING • TEXT ALIGNMENT • SET INDENTS, MARGINS • SET MARGINS USING ARTISTIC OBJECTS IN WORD • USE CLIPART • MODIFY CLIP ART • WORKING WITH WORDART WRITE A REPORT • SEARCH THE INTERNET AND DOWNLOAD PICTURES • HOLIDAYS AROUND THE GLOBE • WEATHER REPORT PRODUCE A FLYER • DIGITAL CAMERA/SCANNER • EDIT A GRAPHIC IN PAINT • CREATE A FLYER TABLES • CREATE A TABLE • COLUMN OPTIONS • CREATE A TABLE • BIRTHDAY INVITATION CARDS AND JOURNALS • CREATE A CARD • ZIP FILES • JOURNAL • SOUND FILES ASSEMBLE A NEWSLETTER • NEWSPAPERS / MAGAZINES ONLINE • BRAINSTORMING NEWSLETTER • NEWSLETTER • SPELL CHECK AND GRAMMAR CHECK PUZZLES, BRAINTEASERS, AND OTHER CHALLENGES • WORD SEARCH • CREATE A HOLIDAY SHAPE • KEYBOARD SHORTCUTS NEWSLETTER PROJECT • NEWSLETTER ARTICLES NEWSLETTER PROJECT CONTINUED • CREATE A NEWSLETTER • EDIT THE NEWSLETTER
Contents of Fundamental Technology Skill Series FTS3CMD Multimedia Director
REVIEW KID PIX • KID PIX REVIEW TOOLS • KID PIX REVIEW • STORYBOARDING • CREATING PICTURES CREATE A KID PIX PRESENTATION • CREATING AND MODIFYING PICTURES • PRESENTATIONS—TIPS • CREATE A KID PIX SLIDESHOW KID PIX ADVANCED FEATURES • SPEECH FEATURES IN KID PIX • IMPORT PICTURE MULTIMEDIA PICTURES • IMPORT A BACKGROUND • ADD SOUND OBTAINING PICTURES AND GRAPHICS • PLAN A GREETING CARD • DIGITAL CAMERA/SCANNER • EDIT A DIGITAL PICTURE • CREATE A GREETING CARD INTERNET SOURCES • SEARCH THE INTERNET • DOWNLOAD PICTURES • IMPORT A MOVIE ADVANCED KID PIX ACTIVITIES • USING SOUND ART • SHARING KID PIX SLIDESHOWS FINAL PROJECT: TOPIC AND GRAPHICS • BRAINSTORMING • STORYBOARDING • PICTURES FINAL PROJECT: CONCLUSION FINAL PROJECT: PRESENTATION AND REVIEW • COMPLETE THE SLIDESHOW • JEOPARDY!
Contents of Fundamental Technology Skill Series FTS3COK Old Kid Pix Multimedia Director
CLASS 1 • PRESENTATIONS—TIPS • STORYBOARDING CLASS 2 • KID PIX STUDIO DELUXE—OVERVIEW • DESIGN CREATION • COLORME PROJECT CLASS 3 • BIOGRAPHICAL SLIDE SHOW • WRITE A BIOGRAPHY CLASS 4 • DIGITAL CAMERA/SCANNER • EDIT A DIGITAL PICTURE • CLASS PHOTO ALBUM • CLASS PHOTO ALBUM SLIDE SHOW CLASS 5 • STORYBOARDING • COMIC STRIP CLASS 6 • INTERNET/ ENCARTA • STAMPIMATOR • STAMPIMATOR ANIMATION CLASS 7 • NATURAL DISASTERS CLASS 8 • INTERNET/ ENCARTA • MUSEUM TOUR CLASS 9 • JEOPARDY! • REVIEW—REVISE PROJECTS CLASS 10 • FINAL PROJECT—BRAINSTORMING • FINAL PROJECT—SLIDE SHOW PROJECT CLASS 11 • FINAL PROJECT—SLIDE SHOW PROJECT CLASS 12 • FINAL PROJECT—SLIDE SHOW PROJECT • CLASS PRESENTATIONS
Contents of Fundamental Technology Skill FTS4A Junior Techie
WHAT IS A COMPUTER HISTORY OF COMPUTERS HARDWARE—INPUT, PROCESSING, OUTPUT AND STORAGE DEVICES MORE HARDWARE ERGONOMICS AND PERFORMANCE SOFTWARE—WINDOWS AND APPLICATIONS PROGRAMMING, COPYRIGHT AND SOFTWARE PIRACY
• INSTALL/ UNINSTALL SOFTWARE INTERNET • BEGINNINGS OF THE INTERNET • NETWORKS • INTERNET AND THE WORLD WIDE WEB • USING THE INTERNET • INTERNET SECURITY • FIREWALLS • PROTECTING YOUR INTERNET PASSWORD • UNDERSTANDING COOKIES • SECURE SITES • BACKUP DATA MORE INTERNET • INTERNET TERMINOLOGY REVIEW
Contents of Fundamental Technology Skill Series Key Into FTS4B Word Processing
REVIEWING MICROSOFT WORD OPTIONS • THE WORD APPLICATION WINDOW • USING WORD TOOLBARS • USING WORD TASK PANES • DISPLAYING HELP INFORMATION • REOPENING A DOCUMENT EDITING TECHNIQUES • MOVING THE INSERTION POINT WITHIN A DOCUMENT • MOVING A TEXT BLOCK • COPYING A TEXT BLOCK • SIMULTANEOUSLY APPLYING MULTIPLE FONT OPTIONS TO TEXT • ADJUSTING CHARACTER SPACING IN A DOCUMENT FORMATTING OPTIONS • INDENTING A PARAGRAPH • FORMATTING EXISTING TEXT • CREATING A NUMBERED/BULLETED LIST PRESENTATION OF TEXT • SORTING PARAGRAPHS AND LISTS • CHANGING THE ZOOM LEVEL FOR A DOCUMENT • RESETTING THE LEFT AND RIGHT MARGINS OF A DOCUMENT • RESETTING THE PAGE ORIENTATION OF A DOCUMENT • SETTING AND CLEARING TAB STOPS IN A DOCUMENT FORMATTING A DOCUMENT • USING DECIMAL TAB STOPS • SETTING A TAB STOP WITH A LEADER • RESETTING LINE AND PARAGRAPH SPACING IN A DOCUMENT • RESETTING PARAGRAPH ALIGNMENT IN A DOCUMENT INTERMEDIATE EDITING AND FORMATTING • FINDING SPECIFIC TEXT IN A DOCUMENT • FINDING AND REPLACING SPECIFIC TEXT IN A DOCUMENT • APPLYING UNDERLINE AND EFFECT OPTIONS TO TEXT • INSERTING SYMBOLS INTO A DOCUMENT ADVANCED EDITING AND FORMATTING • INSERTING A HARD PAGE BREAK / CREATING A MULTIPLE-PAGE DOCUMENT • CONTROLLING PAGE BREAKS IN A DOCUMENT • USING THE THESAURUS • CUSTOMIZING THE AUTOCORRECT DICTIONARY PICTURES AND TEMPLATES • USING A WORD TEMPLATE TO CREATE A DOCUMENT • INSERTING A PICTURE INTO A DOCUMENT SETTING UP MULTIPLE-COLUMN DOCUMENTS • CREATING PARALLEL COLUMNS IN A DOCUMENT • ENTERING TEXT INTO NEWSLETTER-STYLE COLUMNS • EDITING AND RESTRUCTURING NEWSLETTER-STYLE COLUMNS
USING STYLES • USING THE FORMAT PAINTER • REVEALING AND CLEARING FORMATTING IN A DOCUMENT • APPLYING A STYLE TO TEXT • MODIFYING A STYLE FOR THE CURRENT DOCUMENT FINAL CASE STUDY • FINAL PROJECT OPTION 1 • FINAL PROJECT OPTION 2 FINAL CASE STUDY CONTINUED • COMPLETE THE FINAL PROJECT • PRESENT THE FINAL PROJECT
Contents of Fundamental Technology Skill Series FTS4C Integrated Projects
A Cultural Tour Jokes and Laughs Find Your School Online Online Stories Math Problems Geometry Investigations Picture Creation Meteorology Zoology Archeological Expedition Music Video Erupting Volcanoes Family Tree
Contents of Fundamental Technology Skill Series FTS4D Web Publishing
GETTING STARTED • ONLINE RESOURCES • CREATING A WEB DOCUMENT • PUBLISHING ONLINE ADDING HYPERLINKS • FAVORITE MENUS & RECIPES • RECIPES ONLINE USING A TEMPLATE • MOVIE, VIDEO OR BOOK REVIEWS • PUBLISHING A REVIEW • FILE FORMATS INCORPORATING WORDART • ADVERTISEMENT PLAN • ADVERTISEMENT PAGE • HTML CODE THE IMPACT OF FONTS • PICK-UP A STORY MULTIPLE PAGES • PUBLISH AN INTERACTIVE STORY COMBINING TEXT AND GRAPHICS • ONLINE RIDDLES • PUBLISHING RIDDLES • ENHANCING RIDDLES ONLINE AND OFF LINE PUBLISHING • CREATE A MINI BOOK • PUBLISH ONLINE8-4 USE THE DRAWING TOOLS • POETRY • SHOWING OFF POETRY TABLES • SPORTS NET FINAL PROJECT • PROJECT THEME COMPLETE THE FINAL PROJECT • FINAL PROJECT CONTINUED
Contents of Fundamental Technology Skill Series FTS5A Super Slide Shows
GETTING STARTED WITH MICROSOFT POWERPOINT • OVERVIEW OF PRESENTATIONS • CREATING TEXT SLIDE • BIOGRAPHIES PERSONAL PRESENTATIONS • PHOTO ALBUM • SWITCHING VIEWS EDITING A PRESENTATION • ADDING DATA TO A SLIDE SHOW • EDITING DATA ON SLIDES • FORMATTING DATA IN A SLIDE SHOW • ADJUSTING SPACING AND ALIGNMENT PLANNING A PRESENTATION • STORYBOARDING • INTERNET SEARCH • EDITING TEXT • MOVIE REVIEW CREATING A PRESENTATION USING ONLINE RESEARCH • EXPLORING PHENOMENA • ADDING GRAPHICS • DESIGN TEMPLATES PUBLISHING PRESENTATIONS • PRODUCING A SLIDE SHOW • TRANSITION EFFECTS • ANIMATION EFFECTS USING DRAWING TOOLS • PLAN A PRESENTATION • DRAWING TOOLBAR • COMIC STRIP MULTIMEDIA • NATURAL DISASTER • MULTIMEDIA • NATURAL DISASTERS PROJECTS • PROJECT IDEAS • ACQUIRING INFORMATION PROJECT SLIDES • CREATING SLIDES FINAL PROJECT • UPDATE SLIDES PROJECT PRESENTATIONS • CLASS PRESENTATIONS
Contents of Fundamental Technology Skill Series FTS5B Number Crunching
GETTING STARTED WITH MICROSOFT EXCEL • STARTING EXCEL • MOVING THE CELL POINTER • RESETTING THE FONT OF CELL ENTRIES • SAVING A WORKBOOK • USING THE SPELLING CHECKER • EXITING FROM EXCEL CREATING A SPREADSHEET • OPENING A NEW WORKBOOK • TRACKING SUGAR CONTENT • REVERSING AN EDIT OPERATION • ADDING A BORDER AND SHADING TO A WORKSHEET • ADJUSTING COLUMN WIDTH IN A WORKSHEET • CLEARING CELLS MODIFYING A SPREADSHEET • USING AUTOFILL • INSERTING AND DELETING ROWS AND COLUMNS • ADJUSTING ROW HEIGHT IN A WORKSHEET • REALIGNING CELL ENTRIES • USING AUTOFORMAT • PRINTING A WORKSHEET • CHANGING DATA IN A WORKSHEET • COPYING CELL ENTRIES FUNCTIONS IN EXCEL • WHAT IS A FUNCTION? • USING AUTOSUM • USING THE AVERAGE FUNCTION • TRACKING STATS • COUNTRIES MORE FUNCTIONS IN EXCEL • USING THE MAX AND MIN FUNCTIONS • USING THE COUNT FUNCTION • CALCULATING A GRADE POINT AVERAGE • RESETTING THE NUMBER FORMAT OF CELL ENTRIES FORMULAS IN EXCEL • INTRODUCTION TO FORMULAS • ENTERING A FORMULA INTO A WORKSHEET • BEATS PER MINUTE (BPM) MORE FORMULAS IN EXCEL • A PENNY A DAY! • SEARCH FOR RECIPES ONLINE EXCEL CHARTS • CAFETERIA CLUTTER • HEALTHY MENU? • CLASS SURVEY ADDING DATA TO SPREADSHEETS AND CHARTS • ADDING DATA TO A WORKSHEET • EXERCISE PULSE RATE PUZZLES AND OTHER CHALLENGES • MAGIC SQUARES • FUNCTION MACHINE! PROJECT • SPORTS ONLINE • ENTERTAINMENT GALORE • WEATHERING THE STORM APPENDIX
Contents of Fundamental Technology Skill Series Fundamental FTS5C Technology Skill Series Scavenger Hunt Sports Cards Transportation Write a Magazine or Book Mathematics and Art Cookies Museum Early History Harlem Renaissance Television Weather Report Science Discovery Investigate a Career Study Guides
Contents of Fundamental Technology Skill Series Word FTS5D Processing Concepts
TABLES • INSERTING A TABLE IN A DOCUMENT • FORMATTING A TABLE • INSERTING AND DELETING ROWS/COLUMNS IN A TABLE • USING TABLE AUTOFORMAT TABLES CALCULATIONS • PRODUCING CALCULATIONS IN A WORD TABLE • TOTALING NUMERIC ENTRIES IN A TABLE PROJECTS WITH TABLES WORKING WITH CHARTS AND DIAGRAMS • INSERTING A CHART INTO A DOCUMENT • MODIFYING A CHART • INSERTING A DIAGRAM INTO A DOCUMENT LINKING AND EMBEDDING FILES • CREATING A TABLE BY LINKING OR EMBEDDING A MICROSOFT EXCEL WORKSHEET • CREATING A WORD CHART BY IMPORTING MICROSOFT EXCEL DATA • LINKING EXTERNAL DATA TO A WORD DOCUMENT ADDING GRAPHICS • WRAPPING TEXT AROUND A PICTURE • DRAWING SHAPES • ADDING A BORDER AND SHADING TO TEXT • ADDING A HEADER/FOOTER TO A DOCUMENT • ADDING PAGE NUMBERS TO A DOCUMENT PROJECTS USING GRAPHICS ADDITIONAL PROJECTS USING GRAPHICS WRITING TOOLS • PRINTING SPECIFIC PAGES OF A DOCUMENT • PRINTING AN ENVELOPE AND A LABEL SETTING UP OUTLINE DOCUMENTS • FORMATTING A DOCUMENT FOR OUTLINE VIEW • WORKING IN OUTLINE VIEW • CREATING AN OUTLINE NUMBERED LIST • CREATING A TABLE OF CONTENTS • COMPARING AND MERGING DOCUMENTS (OPTIONAL) ADDITIONAL INTERMEDIATE WORD FEATURES • CREATING CROSS-REFERENCES • INSERTING COMMENTS INTO A DOCUMENT FINAL CASE STUDY • FINAL PROJECT 1 • FINAL PROJECT 2 • FINAL PROJECT 3 • CHECK THE FINAL PROJECT
Contents of Fundamental Technology Skill Series FTS6A Excelling at Spreadsheet
REVIEWING EXCEL • REVIEW EXCEL FUNCTIONS • MOVING CELL ENTRIES • INSERTING AND DELETING A RANGE OF CELLS • WORKING IN EDIT MODE • RESETTING THE NUMBER FORMAT OF CELL ENTRIES • ADDING BORDERS AND SHADING TO A WORKSHEET • USING THE SUM FUNCTION ENHANCING PRINTED OUTPUT • CHANGING THE PAGE SETUP FOR A WORKSHEET • PREVIEWING A WORKSHEET • PRINTING SELECTED WORKSHEET ENTRIES • CREATING A NEW STYLE / APPLYING A STYLE INTERMEDIATE EDITING AND FORMATTING TECHNIQUES • FINDING A SPECIFIC ENTRY IN A WORKSHEET • FINDING AND REPLACING A SPECIFIC ENTRY IN A WORKSHEET • USING ALIGNMENT OPTIONS IN THE FORMAT CELLS DIALOG BOX USING ABSOLUTE CELL REFERENCES • ENTERING AN ABSOLUTE COLUMN AND ABSOLUTE ROW CELL REFERENCE • ENTERING AN ABSOLUTE COLUMN OR ABSOLUTE ROW CELL REFERENCE • REVIEWING FUNCTIONS USING FUNCTIONS • USING THE PMT FUNCTION • USING THE FV FUNCTION • USING THE IF FUNCTION • NESTING IF FUNCTIONS • USING THE DATE FUNCTION • USING THE NOW FUNCTION CHARTS • WHAT IS A CHART? • PLOTTING A BASIC CHART • MODIFYING AND ENHANCING A BASIC CHART • PREVIEWING AND PRINTING A CHART • INCLUDING NON-CONTIGUOUS DATA RANGES IN A CHART • PLOTTING A PIE CHART CHARTS AND WORKBOOKS • ADDING NEW DATA TO AN EXISTING CHART • SETTING UP RELATED WORKSHEETS WITHIN A WORKBOOK • MOVING THE CELL POINTER FROM ONE WORKSHEET TO ANOTHER • COPYING DATA FROM ONE WORKSHEET TO ANOTHER EDITING DATA • EDITING THE DATA • ENTERING A FORMULA TO LINK RELATED WORKSHEETS • FORMATTING MULTIPLE WORKSHEETS IN ONE OPERATION • MOVING AND COPYING WORKSHEETS • PREVIEWING AND PRINTING MULTIPLE WORKSHEETS IN ONE OPERATION • ADDING DATA LABELS TO AXES ADDING DRAWINGS AND PICTURES TO A WORKBOOK • CREATING A DRAWING ON A WORKSHEET • INSERTING A PICTURE INTO A WORKSHEET ADVANCED DATA ENTRY AND FORMATTING TECHNIQUES • RESTRICTING CELL ENTRIES TO SPECIFIC NUMBERS, DATES OR TIMES • RESTRICTING CELL ENTRIES TO SPECIFIC ENTRIES IN A LIST • CREATING A CUSTOM NUMBER FORMAT MISCELLANEOUS WORKSHEET OPERATIONS • APPLYING CONDITIONAL FORMATTING TO A WORKSHEET • DEFINING A RANGE NAME • USING A RANGE NAME IN A FORMULA • SELECTING A NAMED RANGE • REPLACING A RANGE OF CELLS • FINDING A PAYMENT FINAL CASE STUDIES • FINAL PROJECT #1 • FINAL PROJECT #2
Table of Contents Powerful Presentations FTS6B Powerful Presentations
REVIEWING POWERPOINT • THE POWERPOINT APPLICATION WINDOW • DISPLAYING HELP INFORMATION • CREATING A NEW PRESENTATION • WORKING IN THE SLIDES TAB • WORKING IN THE OUTLINE TAB • RESETTING THE LINE SPACING OF PARAGRAPHS ON A SLIDE USING THE DRAWING TOOLBAR • REOPENING A PRESENTATION • MOVING A PLACEHOLDER • ADDING AN AUTOSHAPE TO A SLIDE AUTOSHAPES • ADDING TEXT TO AN AUTOSHAPE • PRINTING SLIDES TABLES • ADDING A POWERPOINT TABLE TO A SLIDE • FORMATTING A POWERPOINT TABLE USING THE MICROSOFT CLIP ORGANIZER • INSERTING A CLIP ART IMAGE INTO A SLIDE • ADDING A TEXT BLOCK TO A SLIDE USING DESIGN TEMPLATES • APPLYING A DESIGN TEMPLATE TO A PRESENTATION • CHANGING THE COLOR SCHEME FOR SLIDES SLIDE MASTERS • ADDING A FOOTER TO SLIDES • MODIFYING THE SLIDE MASTER AND TITLE MASTER CREATING SPEAKER NOTES • ENTERING TEXT ON A NOTES PAGE • ADDING A HEADER AND FOOTER TO NOTES PAGES AND HANDOUTS • USING POWERPOINT PRINT OPTIONS PRODUCING A SLIDE SHOW • RUNNING A SLIDE SHOW • CHANGING THE ORDER OF SLIDES IN A SLIDE SHOW • ADDING TRANSITION EFFECTS TO SLIDES ADDITIONAL POWERPOINT FEATURES • BASING A NEW PRESENTATION ON A DESIGN TEMPLATE • USING THE AUTOCONTENT WIZARD • USING THE SPELLING CHECKER • RESETTING AND REPLACING FONTS IN A PRESENTATION REVIEW OF POWERPOINT FINAL CASE STUDIES • FINAL PROJECT #1 • FINAL PROJECT #2 • FINAL PROJECT #3
Contents of Fundamental Technology Skill Series FTS6C Integrated Projects
Around the Globe Trivial Pursuit Explore Fractals Math Facts Telecommunications Astronomy Biology Earthquakes Energy Flow Historical Development Government Activities World Languages Job Hunt Market a Product or Service
Contents of Fundamental Technology Skill Series FTS7A Spreadsheet Master
REVIEWING EXCEL OPERATIONS • USING THE DIAGRAMMING TOOL • CALCULATING DATA • SPLITTING THE WORKBOOK WINDOW INTO PANES • FREEZING WINDOW PANES FUNCTIONS AND FILTERS • WHAT IS A LIST? • FILTERING A LIST • SPECIFYING A CRITERIA RANGE IN A FILTER OPERATION CONTROLLING THE WORKSHEET DISPLAY • HIDING ROWS AND COLUMNS OF A WORKSHEET • CHANGING THE ZOOM LEVEL FOR A WORKSHEET • ADDING LABELS TO CHARTS • VIEWING ALL DATA • CREATING A NEW WORKBOOK TEMPLATE • MODIFYING THE DEFAULT WORKBOOK TEMPLATE STYLE • BASING A NEW WORKBOOK ON A CUSTOM WORKBOOK TEMPLATE USING LOOKUP FUNCTIONS • USING THE VLOOKUP FUNCTION • USING THE HLOOKUP FUNCTION • COLLECT AND ANALYZE DATA AUDITING A WORKSHEET • TRACING PRECEDENTS AND DEPENDENTS IN A WORKSHEET • TRACING ERRORS IN A WORKSHEET • ENTERING A FORMULA TO LINK MULTIPLE WORKBOOKS • CREATING A WORKSPACE REORDERING AND SUMMARIZING WORKSHEET DATA • SORTING THE RECORDS OF A LIST • ADDING SUBTOTALS TO A LIST • APPLYING A CUSTOM FILTER TO A LIST • OUTLINING A WORKSHEET ANALYZING WORKSHEET DATA • CREATING A PIVOTTABLE REPORT • RESETTING THE SUMMARY FUNCTION IN A PIVOTTABLE REPORT • CREATING A PIVOTCHART REPORT SCENARIOS AND REPORTS • CREATING AND DISPLAYING A SCENARIO • DCOUNTA FUNCTION • AUTOFORMAT DASHES • FILTERING WITH EXCEL'S PIVOTTABLE ADDITIONAL INTERMEDIATE EXCEL FEATURES • USING AN EXCEL TEMPLATE TO CREATE A WORKBOOK • PREVIEWING AND SAVING EXCEL DATA AS A WEB PAGE • INSERTING A HYPERLINK INTO A WORKSHEET • INSERTING COMMENTS INTO A WORKSHEET • CREATING A DISCUSSION (OPTIONAL) IMPORTING AND EXPORTING DATA • IMPORTING DATA IN A TEXT FILE INTO EXCEL • IMPORTING DATA IN A DATABASE FILE INTO EXCEL • IMPORTING DATA FROM A WEB PAGE INTO EXCEL • EXPORTING EXCEL DATA TO OTHER APPLICATIONS MISCELLANEOUS • CONDITIONAL FORMATTING • FUNCTION REFERENCES • DROP-DOWN BOX REFERENCE • DATA ACCURACY • SORT BY STREET NAME • METRIC CONVERSION • DOLLAR FUNCTION FINAL CASE STUDIES • FINAL PROJECT #1 • FINAL PROJECT #2 • FINAL PROJECT #3 • FINAL PROJECT #4
Contents of Fundamental Technology Skill Series FTS7B Presentations Presentations
SHARING DATA WITH MICROSOFT EXCEL • WHAT IS OBJECT LINKING AND EMBEDDING? • LINKING MICROSOFT EXCEL WORKSHEET ENTRIES TO A POWERPOINT PRESENTATION • EMBEDDING MICROSOFT EXCEL WORKSHEET ENTRIES IN A POWERPOINT PRESENTATION • ENHANCING MICROSOFT EXCEL WORKSHEET ENTRIES ON A POWERPOINT SLIDE SHARING DATA WITH MICROSOFT WORD • EMBEDDING MICROSOFT WORD TEXT IN A POWERPOINT PRESENTATION • ENHANCING MICROSOFT WORD TEXT ON A POWERPOINT SLIDE CREATING A POWERPOINT CHART • PLOTTING A POWERPOINT CHART • MODIFYING THE COMPONENTS OF A POWERPOINT CHART • EDITING THE DATA IN A POWERPOINT CHART CREATING AN ORGANIZATION CHART • SETTING UP AN ORGANIZATION CHART • REFORMATTING AN ORGANIZATION CHART ADDING SPECIAL EFFECTS TO TEXT • CREATING AN ARTISTIC TEXT BLOCK • USING THE FORMATTING TOOLBAR TO ENHANCE TEXT • USING THE FORMAT PAINTER TO COPY TEXT ATTRIBUTES REVIEW OF INTERMEDIATE CONCEPTS • PROJECTS TO REVIEW CONCEPTS INTRODUCED WORKING WITH AUTOSHAPES • STACKING AUTOSHAPES • CHANGING THE LEVEL OF AN AUTOSHAPE • APPLYING A TRANSPARENT FILL COLOR TO AN AUTOSHAPE • GROUPING AUTOSHAPES • CREATING A THREE-DIMENSIONAL AUTOSHAPE INTERMEDIATE SLIDE SHOW TECHNIQUES • MANUALLY BRANCHING TO A SPECIFIC SLIDE IN A SLIDE SHOW • ADDING ANIMATION EFFECTS TO SLIDES • ADDING TIMINGS TO SLIDES REVIEW AND CREATE A WEB PAGE FROM A SLIDESHOW • AUTOSHAPE REVIEW • PREVIEWING AND SAVING A PRESENTATION AS A WEB PAGE ADDITIONAL INTERMEDIATE POWERPOINT FEATURES • IMPORTING A MICROSOFT WORD OUTLINE INTO POWERPOINT • APPLYING A CUSTOM BACKGROUND TO SLIDES • FINDING AND REPLACING SPECIFIC TEXT IN A PRESENTATION • APPLYING MULTIPLE DESIGN TEMPLATES TO A PRESENTATION • PREVIEWING AND SAVING A PRESENTATION AS A WEB PAGE COURSE REVIEW FINAL CASE STUDIES • PROJECT #1 • PROJECT #2 • PROJECT #3
Contents of Fundamental Technology Skill Series FTS9A Word Processing Macros
COLLABORATING WITH OTHER WORD USERS • ADDING A MAP • TRACKING CHANGES IN A DOCUMENT • RESPONDING TO PROPOSED CHANGES AND COMMENTS IN A DOCUMENT • PROTECTING A DOCUMENT • MERGING REVISED COPIES OF A DOCUMENT • DISTRIBUTING A DOCUMENT FOR REVIEW VIA E-MAIL • SETTING A DEFAULT LOCATION FOR WORKGROUP TEMPLATES EDITING TECHNIQUES • CREATING A NEW STYLE • CREATING A MULTIPLE-SECTION DOCUMENT • CREATING AN INDEX • NAVIGATING THROUGH A MULTIPLE-PAGE DOCUMENT • CREATING FOOTNOTES AND ENDNOTES • CREATING A TABLE OF FIGURES AND A TABLE OF AUTHORITIES ADVANCED WORD FEATURES • CREATING A WEB PAGE FROM WORD • ADDING A HYPERLINK TO A WEB PAGE • ATTACHING A DIGITAL SIGNATURE TO A DOCUMENT • SAVING MULTIPLE VERSIONS OF A DOCUMENT • WORKING WITH A MASTER DOCUMENT AND SUBDOCUMENTS • ADDITIONAL MASTER DOCUMENT/SUBDOCUMENT TOPICS • SPLIT OR COMBINE SUBDOCUMENTS • REMOVAL/CONVERSION OF SUBDOCUMENTS • TRANSLATION OF WORD DOCUMENTS RECORDING SIMPLE MACROS • WHAT IS A MACRO? • RECORDING A TEXT MACRO • RUNNING A MACRO • RECORDING A COMMAND MACRO • SAVING A MACRO RECORDING AND REVISING MACRO INSTRUCTIONS • RECORDING A MACRO TO SET UP A COMPANY LETTER • RECORDING A MACRO TO SET UP A WORD TABLE • DISPLAYING MACRO INSTRUCTIONS • EDITING MACRO INSTRUCTIONS • COPYING MACRO INSTRUCTIONS USING VISUAL BASIC TO WRITE MACROS • CREATING A NEW PROCEDURE IN THE VISUAL BASIC EDITOR • WRITING A SIMPLE MACRO • DISPLAYING VISUAL BASIC HELP INFORMATION CREATING A WORD FORM • WORD FORMS • CREATING A FORM TEMPLATE • ADDING FORM FIELDS TO A FORM • TESTING A FORM • DISTRIBUTING A FORM VIA E-MAIL CREATING INTERACTIVE MACROS • DISPLAYING A DATA PROMPT DURING MACRO EXECUTION • USING A CONDITIONAL STATEMENT IN A MACRO • USING A CONTROL LOOP IN A MACRO • ADDITIONAL CONTROL STATEMENTS CREATING CUSTOM TEMPLATE MACROS AND TOOLBARS • CREATING A NEW TEMPLATE • CREATING AN AUTONEW MACRO
CREATING A MACROS MENU • CREATING A NEW TOOLBAR • ADDING A MACRO BUTTON TO A TOOLBAR • CREATING A NEW MENU • ADDING A MACRO ITEM TO A MENU PERFORMING A MAIL MERGE • THE MAIL MERGE FEATURE • INITIATING A MAIL MERGE • CREATING A DATA SOURCE • CREATING A MAIN DOCUMENT • MERGING A MAIN DOCUMENT AND A DATA SOURCE • PRINTING MAILING LABELS • USING AN EXTERNAL DATA SOURCE IN A MAIL MERGE FINAL CASE STUDY CONTINUED • FINAL PROJECT #1 • FINAL PROJECT #2 • INTERACTIVE PAPER • GRADE REPORT MACRO
Contents of Fundamental Technology Skill Series FTS9B Customizing Spreadsheet
REVIEWING EXCEL • SWITCHING ROWS AND COLUMNS • WHAT IF SCENARIO • WATCH WINDOW WORKING WITH OTHER EXCEL USERS • TRACKING CHANGES IN A WORKBOOK • RESPONDING TO PROPOSED CHANGES AND COMMENTS IN A WORKBOOK • PROTECTING A SHARED WORKBOOK • PROTECTING AN UNSHARED WORKBOOK • DISTRIBUTING A WORKBOOK • MERGING REVISED COPIES OF A WORKBOOK ADDITIONAL WORKSHEET TOPICS • ADDITIONAL WORKGROUP TOPICS • PROTECT A WORKSHEET • USING THE DATA CONSOLIDATION FEATURE ADDITIONAL ADVANCED EXCEL FEATURES • ADDING A TRENDLINE TO A CHART • DATA ANALYSIS • SAVING AN EXCEL WORKBOOK AS AN XML SPREADSHEET • DISPLAYING VISUAL BASIC HELP INFORMATION CREATING AND USING PERSONAL MACROS • WHAT IS A MACRO? • RECORDING A PERSONAL MACRO • RUNNING A PERSONAL MACRO • DISPLAYING MACRO INSTRUCTIONS CREATING AND USING PERSONAL MACROS • EDITING A MACRO • INCLUDING RELATIVE CELL REFERENCES IN A MACRO • RECORDING AND RUNNING A WORKBOOK MACRO CREATING AND USING WORKBOOK MACROS • ADDING A MACRO BUTTON TO A WORKSHEET • OPENING A NEW MODULE IN THE VISUAL BASIC EDITOR USING VISUAL BASIC TO WRITE MACROS • DISPLAYING A DATA PROMPT DURING MACRO EXECUTION • USING A CONDITIONAL STATEMENT IN A MACRO • USING A CONTROL LOOP IN A MACRO PLACING CONTROLS ON A WORKSHEET • ADD A COMBO BOX AND CHECK BOX/LINK A CONTROL TO WORKSHEET DATA • COMBO BOXES IN EXCEL • ADDITIONAL CONTROL STATEMENTS CREATING A MACROS TOOLBAR • CREATING A NEW TOOLBAR • ADDING A BUTTON TO A TOOLBAR / ASSIGNING A MACRO TO A TOOLBAR BUTTON CREATING A MACROS MENU • CREATING A NEW MENU • ADDING AN ITEM TO A MENU / ASSIGNING A MACRO TO A MENU ITEM FINAL CASE STUDY
Contents of Fundamental Technology Skill Series FTS9C Masterful Presentations
ADVANCED FORMATTING TECHNIQUES • RESETTING PARAGRAPH INDENTATION IN A TEXT PLACEHOLDER • SETTING AND CLEARING TAB STOPS IN A TEXT PLACEHOLDER • REFORMATTING BULLETS IN A TEXT PLACEHOLDER • ADJUSTING AN AUTOSHAPE TO FIT TEXT/ADJUSTING TEXT TO FIT WITHIN AN AUTOSHAPE USING DATA FROM OTHER APPLICATIONS • ADDING A MICROSOFT WORD TABLE TO A SLIDE • ADDING A MICROSOFT EXCEL CHART TO A SLIDE ADDITIONAL DATA FROM OTHER APPLICATIONS • REVIEW/ ADDING DATA FROM OTHER APPLICATIONS SOUND AND VIDEO • INSERTING A SOUND CLIP INTO A SLIDE • INSERTING A VIDEO CLIP INTO A SLIDE • PLAYING A SOUND CLIP AND VIDEO CLIP IN A SLIDE SHOW HYPERLINKING IN POWERPOINT • EXCLUDING A SLIDE FROM A SLIDE SHOW • CREATING A HYPERLINK BRANCH TO A SPECIFIC SLIDE • CREATING A HYPERLINK BRANCH TO ANOTHER FILE CUSTOMIZING POWERPOINT SLIDE SHOWS • USING THE MEETING MINDER • CREATING A CUSTOM SLIDE SHOW • CREATING A CONTINUOUSLY-RUNNING SLIDE SHOW WORKING WITH OTHER POWERPOINT USERS • INCLUDING COMMENTS IN A PRESENTATION • DISTRIBUTING A PRESENTATION FOR REVIEW VIA E-MAIL • MERGING EDITED VERSIONS OF A PRESENTATION INTO THE ORIGINAL PRESENTATION • ACCEPTING AND REJECTING REVIEWER CHANGES TO A PRESENTATION CREATING A CUSTOM DESIGN TEMPLATE • DEFINING THE OVERALL SLIDE COLOR SCHEME FOR A NEW DESIGN TEMPLATE • CUSTOMIZING THE SLIDE BACKGROUND FOR A NEW DESIGN TEMPLATE • MODIFYING THE SLIDE MASTER AND TITLE MASTER FOR A NEW DESIGN TEMPLATE • ADDING A COMPANY LOGO TO THE TITLE MASTER FOR A NEW DESIGN TEMPLATE • SAVING A NEW DESIGN TEMPLATE ADDITIONAL ADVANCED POWERPOINT FEATURES • REVIEW OF TEMPLATES • CREATING A SUMMARY SLIDE • EXPORTING A POWERPOINT PRESENTATION TO MICROSOFT WORD • SAVING A PRESENTATION OUTLINE IN A RICH TEXT FORMAT FILE • MODIFYING THE GRAYSCALE VIEW OF A PRESENTATION MORE ADVANCED POWERPOINT FEATURES • SAVING A PRESENTATION FOR USE ON ANOTHER COMPUTER • EMBEDDING FONTS IN A PRESENTATION • SCHEDULING A PRESENTATION BROADCAST REVIEW • REVIEW ACTIVITIES FINAL CASE STUDIES • PROJECT #1 • PROJECT #2 • PROJECT #3 Tabla Contenido del curso de Mision Control A Jump Nivel: MCAL1 Jump Start 1
INTRODUCCIÓN USO DEL PLANNER INSTRUCCIONES OBJETIVOS • OBJETIVOS PRIMARIOS DE ACTIVIDADES DE SOFTWARE ACTIVIDADES SOBRE HABILIDADES FUNDAMENTALES CONCERNIENTES A OBJETIVOS PRIMARIOS
CLASE 1 • FS401-1 NO JUGAR CON LA ELECTRICIDAD. • FS401-2 BUENOS HÁBITOS • 2007 LA CASA DE LAS MATEMÁTICAS DE MILLIE: PEQUEÑO, MEDIANO, GRANDE • 1002 THE PLAYROOM: MIXED-UP TOY CLASE 2 • FS401-3 NOMBRE PARTES ORDENADOR • 2007 LA CASA DE LAS MATEMÁTICAS DE MILLIE: LA CASA DE LOS RATONES • 3000 KID PIX STUDIO: KID PIX CLASE 3 • FS401-4 ENCENDER / APAGAR • FS401-5 EL RATÓN COMO DISPOSITIVO DE ENTRADA CLIC / DOBLE CLIC • 2000 LA CASA DE LAS MATEMÁTICAS DE MILLIE: CONSTRUYE UN BICHO • 1002 THE PLAYROOM: SPINNER TOY • 3000 KID PIX STUDIO: KID PIX CLASE 4 • FS401-6 UTILIZANDO LA PUNTA DE LA FLECHA DEL RATÓN PARA SELECCIONAR Ó ESCOGER. • 2000 LA CASA DE LAS MATEMÁTICAS DE MILLIE: FÁBRICA DE GALLETAS • 2000 LA CASA DE LAS MATEMÁTICAS DE MILLIE: MÁQUINA DE LOS NÚMEROS CLASE 5 • FS401-7 EXISTENCIA DE LA BOLA DEL RATÓN: ALFOMBRILLA • 1002 THE PLAYROOM: EL ORDENADOR • 3000 KID PIX STUDIO: KID PIX CLASE 6 • FS401 - 8 ABRIR / CERRAR PROGRAMAS USO DE ICONOS • 1002 THE PLAYROOM: THE ABC BOOK • 1025 BAILEY’S BOOK HOUSE: KID CARDS CLASE 7 • FS401 - 9 MENÚ DE INICIO • 2000 LA CASA DE LAS MATEMÁTICAS DE MILLIE: BING & BOING • 1025 BAILEY’S BOOK HOUSE: LETTER MACHINE CLASE 8 • DINIFS401 - 10 MAXIMIZAR, MINIMIZAR Y RESTAURAR • 1002 THE PLAYROOM: RELOJ • 1025 BAILEY’S BOOK HOUSE: EDMO & HOU CLASE 9 • FS401 - 11 PICK-UP TRACKING, ARRASTRAR ALFOMBRILLA • 1025 BAILEY’S BOOK HOUSE: CREAR UNA HISTORIA • 1025 BAILEY’S BOOK HOUSE: LEER UNA RIMA CLASE 10 • FS401 - 12 CD-ROM - MANEJARLO CORRECTAMENTE / LIMPIAR / CARGARLO/ SACARLO • 1002 THE PLAYROOM: MOUSEHOLE • 3000 KID PIX STUDIO: KID PIX CLASE 11-12 • PROYECTO LIBRO DE LETRAS USANDO KID PIX
Tabla Contenido del curso de Mision Control A Jump Nivel: MCAL2 Jump Start 2
INTRODUCCION USO DEL PLANNING INSTRUCCIONES OBJETIVOS • OBJETIVOS PRIMARIOS DE ACTIVIDADES DE SOFTWARE • OBJETIVOS PRIMARIOS ACTIVIDADES FUNDAMENTALES VALORACION DE MISSION CONTROL Y SEGUIMIENTO CLASE 1 • FS402-1 DISQUETERA COMO COGERLO PARTES DE UN DISQUETE • FS402-2 HACER UN DISQUETE • 2050 JAMES DISCOVERS MATH: BULLETIN BOARD • 3181 LION KING PRINT STUDIO: PUNTO DE LIBRO • 3181 LION KING PRINT STUDIO: ETIQUETA PARA DISQUETE (OPCIONAL) CLASE 2 • FS402-3 INTRODUCCIÓN AL TECLADO • 2050 JAMES DISCOVERS MATH: REFRIGERATOR MAGNETS • 3000 KID PIX STUDIO: KID PIX • CÁMARA DIGITAL O ESCÁNER KID PIX STUDIO: DIBUJO DE CARA • 2050 JAMES DISCOVERS MATH: REMOLCADOR CLASE 3 • FS402-4 TECLADO - NÚMEROS, LETRAS •& | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
