550 likes | 804 Views
Computer Skills and Applications. Teresa Lester Bailey Road Middle School Cindi Sweeney J.M. Alexander Middle School. Activities for Computer Skills and Applications Suggestions What worked for us On-line - FREE Culminating. Objective. Free Digital Literacy
E N D
Computer Skills and Applications Teresa Lester Bailey Road Middle SchoolCindi SweeneyJ.M. Alexander Middle School
Activities for Computer Skills and Applications • Suggestions What worked for us • On-line - FREE • Culminating Objective
Free Digital Literacy Free Financial Literacy (Vault) http://www.ignition.everfi.net NEW address: http://assembly.everfi.net Ignition
After the survey, the first module is complete – no assessment
www.ignition.everfi.net Let’s see a Module
Practice formatting • Prekeyed body • Students add formatting and various components • *Color code for quick check • Reports • Summary of Ignition* Modules • Current Event • “What technology trend has had the biggest impact on you?” • “What are some Internet Safety rules?” Word Processing
Letters/Memorandums • To the editor, legislature • School issue • CTE funding • Military personnel • School connection? • https://about.bankofamerica.com/en-us/military/gallery.html?cm_mmc=EBZ-EnterpriseBrand-_-vanity-_-EB01VN001Y_troopthanks-_-NA#fbid=rRL3QnoHL5o • Compliment/Complaint/Request for Information • Letters from a Nut – Ted Nancy • Senior citizens/hospital patient Personal Correspondence
Flyer • School events • Dance, Sports, FBLA, NJHS, NAL, Future Cities • Book Fair • PTSA Fundraising • CTE registration –what are course offerings • Anti-bullying • Print and Post – display student name Desktop Publishing
Brochure • CTE course offerings –PTSA meetings, registration • School • Famous Individuals (can differentiate) • Travel brochure (can differentiate) • Internet Safety – for elementary school • Enhance Igntion* modules • Search Engine – • Evaluations and tips
Newsletter • End of Quarter/Semester review of CTE activities • Grade level activities • School based activities • Ignition* review • What you should know about Middle School (rising 6th grade students)
Business Card • Collect business cards to show, ask students to evaluate • Attach to projects • Summer employment • “10 years from now”
Identify various components • Color code fonts = values/lable • Border = formula/function • Pattern = attributes • Lock formula view (Hide formulas) • Peer check • Topics • Book characters (Hunger Games) • Teachers • Politicians Spreadsheet
Break down IF Statement into sections =IF(“Logic Statement”,“true”,”False”) • Weather • Grades • Payroll • Bonus IF Statements
Weather • If 950 HOT • If 800 WARM • If 650 BRISK • If 400 CHILLY • If 250 FREEZING • Change color and/or font style for labels
Enhance Internet search skills • finding current temperature • Add country • Add other cities
Time management data • Student’s weekly or biweekly schedule • Create spreadsheet,create 5 different charts • EVALUATE • Which style displays information best? • Overall • One day • All school based activities Charts
Introduction • Youtube • Search Engine • Samples (Screen shots) • PowerSchool • NCWise • Actual Business Database
Superbowl • http://www.nfl.com/superbowl/history • Stanley Cup • http://www.nhl.com/ice/page.htm?id=31252 • World Series • http://www.baseball-reference.com/postseason/ • Basketball Championship • http://www.basketball-reference.com/playoffs/ • All Star Game • http://www.basketball-reference.com/allstar/ • http://espn.go.com/mlb/allstargame/history Learn to Manipulate
Books • Newbury Awards • http://www.ala.org/alsc/awardsgrants/bookmedia/newberymedal/newberyhonors/newberymedal • Caldecott Medal • http://www.ala.org/alsc/awardsgrants/bookmedia/caldecottmedal/caldecotthonors/caldecottmedal
Movies • www.imdb.com • http://www.1728.org/page8.htm • Television • http://en.wikipedia.org/wiki/List_of_Primetime_Emmy_Award_winners • www.emmys.com • Music • http://www.grammy.com/ • Amusement Parks • http://www.ultimaterollercoaster.com/
Travel • http://travel.state.gov/travel/cis_pa_tw/cis_p a_tw_1168.html • Ships • www.ships-register.com • Berlitz – Complete Guide to Cruising • Airlines • http://www.airlinequality.com/Forum/seats.htm • Trains - Global • http://en.wikipedia.org/wiki/Lists_of_named_passenger_trains • Places to see in the USA
Olympics • http://www.sports-reference.com/olympics/ • Cars • http://www.all-car-brands.com • Food labels • Candy labels • Music collection • Any personal collection
US States What should be the primary key? • Name, Capital, Region, Population, Number of Counties, • Name, Governor, Lt. Gov, Secretary, Treasurer • Name, Major cities, Places of Interest –Natural, Man-Made • Name, Rivers, Elevation high and low, Temperature High/Low www.measureofamerica.org www.infoplease.com/states.html www.infoplease.com/ipa/A0004920.htm http://quickfacts.census.gov/qfd/index.html Relational Database
People What should be the primary key? • ID Number (Student Id or Social Security), First Name, Last Name, birthdate, Address (Sep fields) • ID Number, classes enrolled, room number, teacher • ID Number Academic activities (FBLA, NJHS, SciOly) Sports activities (Football, Soccer) • ID number, Emergency contact information: Guardian/Parent address, phone number • ID number, Siblings – names, ages, school attending Individual Class? School? Use fake information
Topics • Famous people • Travel – place to see/things to do • CTE program • FBLA • Jeopardy review – any standard • Enhance Ignition* modules • College Review Multimedia
Alternatives to Power Point™ or Movie Maker ™ • http://prezi.com/ • http://www.powtoon.com/ • http://prezentit.com/ • http://www.sliderocket.com/ • http://www.voki.com • http://animoto.com • http://www.smilebox.com/lp/video-slideshow-maker.html?partner=msn&campaign=search_core_slideshow_make_video&utm_source=bing&utm_medium=cpc&utm_campaign=search_core_slideshow&gclid=CKicgZLmr7gCFWWd7AodjxYAAA&gclsrc=ds
Internet Basics • http://www.gcflearnfree.org/internet • Internet Safety • http://www.gcflearnfree.org/internetsafetyforkids • Fakebook Page Internet
https://sos.fbi.gov/ • Monthly Contest • JMA won for November 2013 Internet Safety
Current event • Key response to prompt – 3 -5 minutes for 1 week, peer edit last session • Improve speed and/or accuracy • 1 – 3 minute key fast as possible • Timed Writings • NASCAR theme • Individual car – race track around classroom • Combined • Team of 3 or 4 – average timed writing • Key to music – “camptown races” • www.dojo.com – email technique feedback Keyboarding
“The only difference between free and expensive programs – is the number of bells and whistles!” • http://www.goodtyping.com/ • Offers Spanish version • http://www.abcya.com/keyboard.htm • Elementary level • http://www.learnkeyboardtyping.com/ • Includes learn to key tips teacher resource • http://www.learntyping.org/ • Different levels and keyboarding short cuts Learn to Key – on line
http://www.sense-lang.org/typing/tutor/keyboarding.php • Offers other keyboard options • http://www.typingweb.com/ • Has teacher tips • http://www.learn2type.com/ • Includes numeric keypad • http://www.berniestypingtravels.com • easy
Online resources • www.powertyping.com • www.typeonline.co.uk • www.freetypinggame.net Keyboarding
Use www.cfnc.org (must register) and www.ncwiseowl.org (High School > Careers) Investigate 10 colleges/universities – 8 instate, 2 out of state Create database of choices required fields – 8 – 10 1 number 1 currency 1 text Only 1 yes/no Rest, student choice Culminating activities
Print database report showing all information Create multimedia presentation with 2 choices, include 2 graphics 6 -10 slides must include Works Cited Print and present multimedia Create a spreadsheet showing cost for 1 year and 4 years for top 2 choices, create chart
Create flyer/brochure displaying highpoints of colleges Report – summarizing what you learned about colleges. What you learned about each software Evaluate your work ethic, what worked what didn’t what you would change
Word Clouds – intro/review concepts • www.wordle.net • www.tagxedo.com/ • www.worditout.com • http://www.imagechef.com/ic/word_mosaic/ Student enrichment
Popplet • http://popplet.com/app/#/1501020 • Padlet • http://padlet.com/wall/wwdw2h4ye4 • http://padlet.com/wall/nx6z7on7lk • Wordle • http://www.wordle.net/delete?index=7108675&d=RWBR Enrichment
www.wittycomics.com www.pixton.com www.sploder.com www.agame.com www.scribblitt.com www.ted.com http://fun2think.com/free-online-music-making-for-kids/ Enrichment
http://soundation.com/ http://www.jamstudio.com/Studio/index.htm http://looplabs.com/ older students http://fun2think.com/free-online-music-making-for-kids/ Add music to presentation, need earbuds or headphones Music
http://geogreeting.com building letters http://www.kerpoof.com booklet http://www.flipsnack.com booklet http://www.kitzkikz.com/flashcards/ http://quizlet.com/create-set review http://marvel.com/games/play/34/create_your_own_comic (more for Males) http://www.makebeliefscomics.com http://www.toondoo.com/ http://www.pixton.com/for-fun - customize Fun Sites (enrichment or review)
http://www.free-computer-tutorials.net/ • http://www.flashcardmachine.com/ • http://www.playlist.com/ - music while working • http://www.teachercreated.com/free/ • http://www.discoveryeducation.com/teachers/ • Videos are a bit out of date • http://www.theteacherscorner.net/ Teacher Resources
http://www.discoveryeducation.com/search/page/-/-/lesson-plan/technology/index.cfm?campaign=flyout_teachers_lesson_techhttp://www.discoveryeducation.com/search/page/-/-/lesson-plan/technology/index.cfm?campaign=flyout_teachers_lesson_tech http://free.ed.gov/ http://www.teacherview.com/ http://www.collaborizeclassroom.com/resources http://www.intel.com/education/teachers http://www.watchknow.org www.youtube.com Teacher Resources
c.sweeney@cms.k12.nc.us teresa.lester@cms.k12.nc.us Electronic copy of presentation