Important Notes 1: I will bring to your awareness things that are important. Emphasis is on Practical, & Useful. You will be given feedback enabling you to keep track of your grade. Please set phones to silent. I expect your full attention when I am lecturing. Show veterans respect and do not make loud noises around them, insult them or harass them. These persons have put their lives on the line for years for you. Many have had to kill or seen others die. Treat them as you would want to be treated yourself.
SIGN SIGN-IN SHEET EVERY CLASS and PUT YOUR NAME SIGN UP EVERY CLASS.
HOW TO GET A GOOD GRADE: LISTEN, MAKE NOTES, STUDY MY NOTES, REVIEW OFTEN
LEARN EVERYTHING in these NOTES as it will be on unannounced tests more than once.
Set time aside daily for study. This is a college level class. You are expected to spend at least 1 hour in preparation for each hour in class. If you do that you will get an A or B in this class, 4 nice college credits, and a nice reference if you ever need it but if you don't you will get an E.
Learn how to learn. Find what works for you. Learn how to take quick notes. When time is short use abbreviations for subject words. Example if lecture is on computers make a note c=computer then every time the professor says the word computer you can just write down a c. Leave out vowels when time is short. Later rewrite the notes while the lecture is still fresh in your head. To help you to learn and think do the following:
Learn to Ask the 6 learning Questions What, Who, Where, When, How and Why.
Always treat others as you would want to be treated yourself. This is the best way to get along with people. This is the best rule of human relations. (AKA Golden Rule) also Bring no harm to another by your actions or your inaction. You are responsible for treating the equipment and fellow students with respect and care. Treat the equipment as if it were yours because it is. You paid for it. No open containers of liquids.
Make a backup copy of all important work and notes on your flash drives. That is reason for 2 of them. A good copy is best insurance. Please shut off computer and monitor before you leave (required). Clean up any mess. If the room lights blink immediately note where your belongings are. The room may go black. Be prepared to leave if the lights stay out for over a minute. Fire: go out nearest safe exit. There are free tutors available for PowerPoint, Word, Excel and Access in the open Lab. If terrorist around, stay out of sight.
You can buy both of books used for as little as $10-25 each if you shop around. But the college requires you use the myitlab program. By the way you can get Win 7 for under $30 as a student. If you do not own MS Office, DO NOT BUY MS Office FOR THIS CLASS. Bring pen, paper, two USB flash drives, set of ear sound buds and your full attention to every class. Yellow ribbon handy to avoid loss. Put phone number on flash drive. Do not over rely on computers. Have a plan B if computer fails such as records on paper or CD or flash drive. Flash drives fail. Cloud storage is not always available.
Academic discussion is an important part of the college experience. Our graduates are to learn how to think competently, identify problems, approach them systematically, explore viable solutions evaluate reasoning , arguments, evidence and communicate competently. We will have just a few minutes of academic discussion at the start of each class in which you may raise any issues of importance. Your personal security depends not only on computer knowledge but on knowledge of what is happening in the world around you including understanding of multicultural factors and societal significance. See inside cover of class schedule for more of Macomb's Common Degree Outcomes. So pay attention and learn for your future success. DEFINITION OF: COMPUTER: 5 parts Is an Electronic device that Accepts Data, Processes it by its own program, Provides output. Stores it. Know Parts of computer system: The system unit is the case either a vertical tower, or horizontally oriented desk top unit. Many can be used either way if CD is grasped. keyboard what you type on. Monitor is screen. Old big CRT vacuum tube 180-500 Watts has High Dangerous voltage even years after being unplugged, & electro magnetic radiation EMR. LCD about 15 Watts no high voltage, runs cooler, LED uses even less power & thinner. Pixel = Dot Coming are Organic screens which will be thinner, flexible and use less power. Mouse is pointing device. two kinds mechanical, optical has a light and is more reliable easier to clean. Printer quality is measured in dots per inch dpi, speed in ppm pages per minute. Plotters draw on bigger paper. Laser has cheapest ink usually better quality & built for high volume, Ink Jet sprays, Thermal melts is Diesub color last 100 years. storage medium magnetic is faster but optical is more permanent and rugged, flash chips smaller. CD Compact Disk optical storage device capacities: mini 8cm CD 200 Mb mini DVD 1 side1.4GB 1 side 2 layer 2.66GB, 2 side 2.8 GB, 2 side 2 layer 5.2GB, fullsize 12cm CD-R or CD-RW 700 MB but DVD 4.7, dual layer DVD DL 8.5 GB, blue ray BD 25 GB dual layer 50 GB. FDD Floppy Disk Drive a magnetic media storage device capacity 1.44 MB, SSD 5T see p 71 52 facts 36 important
53. HDD Hard Disk Drive magnetic media storage device in system case or external capacity up to # TB
55. USB flash drive a solid state storage device capacity up to 256GB This memory is not volatile so this keeps its memory when power is turned off. They have limited life.
59. USB Universal Serial Bus socket can automatically quick connect up to 127 devices. Storage is used by programs. RAM is the volatile memory & ROM nonvolatile memory both used by CPU. Desktop is main screen of a GUI (Windows like) operating system containing icons & menus. A student computer should have: at least hard drive over 20G plus DVD drive, processor of more than 600 MB, at least 128 MB RAM but 2GB ram much better, several USB ports, a network connection, and functioning operating system such as Windows XP or Linux such as Ubuntu. Be aware of price deals. Referbs are often bargains.
76. Keys, which 6 can usually be safely held down? Ctrl, Alt, Shift, Num Lock, Caps Lock, Scroll Lock
83. Windows is Microsoft's GUI (graphical user interface). Old command line interface was DOS.
86. Knoppix is Linux OS on CD. Why useful? It has anti-Virus-free web surfing, can help recover data on damaged Windows PC, has over 900 free installed good programs, 38 games. All run directly from CD. Does not change anything in computer. Sets up on most PCs with or without working Windows in about 3 minutes.
90. Ubuntu is the easiest to install and run Linux operating system. It comes with the equivalent of Microsoft Office (Open Office) word processor, spreadsheet, slide show creator and database plus equivalent of photo shop GIMP, a CD player, song ripper, a CD and DVD burner, Firefox browser, many games and much more.
100. How to avoid repetitive stress injury? Use pad under wrist. keyboard legs should be folded, switch hands
101. Extra Credit may be awarded for sharing valuable info with class and helping others.
102. The mouse wheel is used for scrolling. Trackball is like an upside down mouse. Ball is on top.
104. Plug in USB flash drive (memory stick) easy to break, best use extension cord, put phone number on it
108. How to avoid viruses and spy programs? install up to date anti malware
109. nano one billionth milli one thousandth Kilo = 1000 Mega means million MB megabyte
114. Giga billion = 10003 GB gigabyte Tera = Trillion = 10004 Peta = Quadrillion = 10005
118. Exa = Quintillion = 10006 Zetta- sextillion = 10007 Yotta- = septillion = 10008
121. Exaflood a supposedly impending flood of exabytes What is Esperanto?
122. lowercase b is for bit which is a binary digit which is a 1 or 0 or an on or off, or higher/lower voltage
124. the capitol B is Byte usually contains 8 bits
126. Computer security and privacy both corporate and personal is a big issue now and promising job field. In the US there are new laws but first you need to know the basics. The basic law of our land is the US constitution which purpose is to establish justice, insure domestic tranquility, provide for the common defense, promote the general welfare, and secure the blessings of liberty to ourselves and our posterity. The Bill of Rights is first 10 amendments. First Amendment guarantees the freedom of religion, of speech, of the press, of assembly, and of petition to the government for redress of grievances. Second Amendment The right to bear arms openly, Third Amendment freedom from quartering soldiers in a house without owner's consent Fourth Amendment protects people against unreasonable search and seizure. No searches without warrant or probable cause. And this about privacy. Fifth Amendment no person shall be held for "a capital or otherwise infamous crime" without indictment, be twice put in "jeopardy of life or limb" for the same offense, be compelled to testify against himself, or "be deprived of life, liberty, or property without due process of law." It also prohibits government from taking private property without "just compensation," Sixth Amendment guarantees the right of speedy and public trial by an impartial jury in all criminal proceedings and the right to have legal counsel for the accused and guarantees that the accused may require witnesses to attend the trial and testify in the presence of the accused. It also guarantees the accused a right to know the charges against him. Seventh Amendment guarantees right of trial by jury in almost all civil cases. Eighth Amendment. Excessive bail, fines "cruel and unusual" punishment prohibited.
136. OpenOffice is free, open source equivalent of Microsoft Office. No serial number is required.
138. GIMP is open source equivalent of Photoshop Photo editor but in Public Domain called Open Source
141. What is ESD Electro Static Discharge. Is IMPORTANT because this spark can kill your computer.
144.PORTS see p74 VGA, S-Video, DVI, HDMI, Ethernet,USB, FireWire, audio. Smart labels MaxiCode 7
156. know about RFID, VeriChip, mu-chhip 18, Nanometer, Nanoscience, Nanotechnology Careers p20
163.Digital divide, privacy 22, Orwell 1984, govt and private companies are collecting info about you. Spam 5
IT p5 Read chapter 3 in Technology in Action as our first topic will be Internet. Read Chapt 1 also. 170 facts 76 imt
171. Computers will replace 60% of workers in future. See chapter 1. You must prepare for future jobs not just jobs that exist now. Do not assume you will have a job waiting for you. There will be stiff competition from other countries like India and China and others seeking jobs. See Did you Know? Video on YouTube.
176. avoid eyestrain. Keep screen about 20 inches away and not higher than eyes. Take breaks.
177. Other Chapter 1 notes Computers are tools offering us many benefits and they can be a curse depending on how they are used or misused. Becoming skillful and knowledgeable in use of computers will serve you well. The more you know the better for you. The less you know the better for those who want to use you.
180. See p 15 Braingate neural interface can control a limb. It pg 5, Bluetooth p8, offshored 9, surveilance by employers & Govt, Yes they can do it legally, like read your email, micro camera 23
182 INTERNET since 1969 What is difference between Internet and WWW? Internet is network of networks & equipment but WWW is billions of digital documents enabled by Mosaic 1993. Web 2 is social networking myspace, facebook, twitter, web logs, video logs, wikis, podcasts, webcasts, VOIP, Newsgroups, chat
187. Internet Two I2 is faster hardware allowing 1Gps-8.8Gbps bandwidth see page 127 in text
188 Free email is available from yahoo or Gmail.com hotmail.com is web based. ISP is client based WOW
190. email is not private, not secure need PGP Pretty Good Privacy encryption to protect
192. What is the cloud? Using programs that are Internet based rather than ones on your PC
193. What is good about cloud computing. Can be free, no need to install, lots of storage, good security
What are cons of cloud? Internet not always available, others may see what you are doing if you use WIFI or if unencrypted. Data can be lost in transmission. Does not work during power outages, or solar storms, in tunnels, in basements and at some public places. Requires internet setup. Using air card or cell fone is problematic and often very slow and sometimes expensive.
200. Why Internet is important? facilitates getting and giving information, knowledge, trade, goods, cooperation
201. How to add addresses to favorites. in browser click on Favorites or bookmarks, click Add, OK
202. Echelon government program
203. Where is the Internet censored? China, Jordan, Saudi Arabia, Vietnam, and the USA. What is Esperanto?
204. What is an ISP? Internet Service Provider
205. Where to get free email? Gmail, hotmail.com, Yahoo,and others
206.What are the services of the Internet E-Mail, Web, FTP, Discussion Groups, Telnet, Lists, messaging
207.What is the digital divide? World is divided into those who have access and Knowledge and not
208. Ways to connect to internet, fastest, cable, DSL. Then: wireless, cell, air card slowest dialup.
209. top level domain names .com .edu .org .mil .net .gov .bus .us .tv
210. browser? program used to see web pages Firefox, Chrome, Explorer, Safari
211. How to clear out cookies and temporary files? Internet Options in IE or Tools Clear Private Data
212. Home page? the main page on a web site
213. URL? The total web address, the domain and computer name http://www.yahoo.com/
214. What is an IP address? 564.123.555.192
215. What is a client? the computer being served such as your computer
216. What is a server? a computer that provides file service to client computers
217. a Protocol is a set of rules and standards to accomplish something
218. What is HTTP? the protocol used to control communication between web clients & servers
219. What is a LINK? a hyperlink connection pointer to a document or website.
220. What is asynchronous? not in synchronization like e-mail
221. What is surfing? looking at one web page after another
222. What is downloading? bringing files from the Internet to a local computer
223. What is portal? (Large Door) a website that offers a lot of links to others
224. What is multimedia? using text, video, audio, graphics and or VR
225. GIF Graphics Interchange Format picture compression method makes files smaller limited to 255 colors
226. What is audio? sound BREAD CRUMBS is the path to a web page
227. What is MP3, and OGG? a method to compress sound files as much as 1/10 th the original size
228. streaming? file loading method so that they can be heard and or seen almost immediately p106
229. VR virtual reality computer generated reality used for simulations teaching or gaming
230. avatar a 3D representation of a participant in a virtual world 30 impt 106 tot page 3
231. JPEG? most common method of compressing foto files
232. What are plug-ins? helping programs for browsers. Name some Flash, Quick time
233. What is FTP? File Transfer Protocol used for transferring files on Internet click on download icon
234. What are newsgroups? Discussion boards on thousands of topics can be useful
235. What is IM? instant messaging
236. What is netiquette? etiquette on the Internet basic rule Do only as you would want to be done to
237. Why use it? Actually is safer and better Flaming can have serious negative consequences
238. What is web publishing? making and uploading web documents to an Internet server
239. How to track where children have been History, Cookies, Net Nanny
240. examples of antivirus programs AVG Free, Norton, McAffee, Kaspersky
241. examples of anti-spyware programs Spy Sweeper, CounterSpy, SpyBot, Ad-Aware
242. What is firewall? hardware and software that stops undesirable traffic in and out like Zone Alarm
244. What is cyberterrorism? terrorism using computers. Now is serious threat
245. What can you do to protect your computer? Use up to date Antivirus and anti spyware programs, stay off of dangerous web sites, don’t open files sent by unknown persons. Or use Knoppix, Ubuntu or other Linux OS.
246. Malware = computer viruses, spyware, worms, Trojan horses, time bombs and other hostile programs.
247. How to safeguard your personal information don’t give it out. Use a firewall. Store your data on a DVD 248. or CD not on your hard drive. Do sensitive work on a pass-worded computer not hooked up to Internet.
249. How to throw off hackers and those who collect information about you. Give phony info, encrypt
250. FAQ frequently asked questions. the place to go for beginning or common questions
251. Verichip implantable RFID used in thousands of humans and animals for ID & tracking them
252. RFID see http://www.michaeljournal.org/newtechno.htm also see spychips.com
253. The mu chip is even smaller and mu powder even smaller. Can be placed in or on you without your knowledge and used to spy on you. Can be read from up to 10” Readers are under $100 and can be bought and installed by anyone. However it can have many other useful applications such as inventory, tracking food.
Mu Nano chip only as big as a dot of ink. See foto page 19. Can hold info about you.
255 Nano science page 21 study of structures 1-100 nano meters in size
256. Read info at portableapps.com Allows you to take your word processor, spreadsheet, music player, browser and other programs with you to any computer (except Apple)
257. Affective computing deals with emotion p 31
258. Max code inkblot like code used to process packages by UPS
259. Data mining looking at a large among of data to find a pattern. P 6
260. check the searchenginelist.com Lists 29 types, http://www.20search.com/ is an excellent tool.
262. Wikipedia http://en.wikipedia.org/wiki/List_of_search_engines lists around 30
263. The following web pages have been found to be practical and useful: unless noted add .com
264. for General Information Wikipedia, MCC Library, ask, How stuff works
General Search Engines Google, Yahoo, webcrawler, Bing, duckduckgo (is not tracked), Dogpile, Lycos, ask, answers, topix, see page 117 in text book for search tips
Info on living people pipl,Yahoo, people finder, intellius, anywho, google, wink, exalead, finding-people, facebook, myspace, classmates, lexisnexis
News/Weather myfoxdetroit, MacombDaily, freep, detroitnews, CNN ,newslive.com TV stations
Free books 1 million ebooks free openlibrary.org/
Students have stated the following have uncensored news: PBS, detroit.cbslocal, wnd.com,
TIME time.gov/, www.bbc.co.uk/, thereligionofpeace.com, bigbrothergovernment. wordpress.com/
www.pbs.org/newshour/?cc=1234, Citizens against government waste cagw.org/
wolframalpha.com a computational knowledge engine that computes answers
How to find used items? Try ebay,com, craigslist.com, amazon.com
Shopping Craigslist but be careful, ebay, Google shopping, shopzilla, dealoz, good shop, bookprice. nextag
Gas prices detroitgasprices, gasbuddy
Other CityofWarren, Library of Congress= loc.gov,pickaprof.com, ratemyteachers,
Yahoo Maps, Google Earth, mapquest
330. Pictures/clipart google Images 30 impt 136 tot page 4
334. Videos Youtube, Google videos
Groups: groups.google.com,
Civil war video must see http://www.youtube.com/watch?feature=fvwp&v=n5ooBiCLlqA&NR=1
Warren History macombhistory.us macomb county history mtclib.org/
anonymous proxy protects your online privacy https://proxify.com/
For sources Alibaba.com, for forums OMGILI for forums, exam questions examcram
Project vote smart, amazon, music, StateofMichigan, kids.yahoo.com, YouTube, Google more and more, google docs, wnd.com, delicious.com, see pages 114,115, digg.com, stumble.com, archived,
personalized search engine, good search.com, Electronic Frontier Foundation eff.org, aclu.org, free speech http://endoftheamericandream.com/archives/freedom-of-speech-is-dead
http://www.isil.org/resources/lit/free-speech.html http://www.freedom4ever.net/freedom_of_speech.htm
Text book also mentions flooding on p 9, create own network ning.com
To find job sites first do a Google search on “job sites” select Michigan jobs if you wish
You can also search for “hot jobs” government jobs, non profit jobs, local jobs to get many sites.
Also consider searching Google for careers, Visit school, city, government, organization, company and potential employer web sites. Monster, careerbuilder, detroit.computerjobs, dice, computerwork
fierst-computer-job, odinjobs, indeed, hotjobs.yahoo, jobserve.us, itjobs, flipdog, careerboard, thingamajob, governmentjobsearch, Mlive, careermatrix, talentsoo, michigan.gov/careers, hostedjobs.openhire, tech-centric.net, usajobs, myfoxdetroit , detnot WXYZ, clickondetroit WDIV, michiganworks, mied.uscourts.gov,
macomb.edu, wayne.edu, meditjobs, nationjob, itjobsfor graduates, cityitjobs, jobs4it, joblist.als.org, jobsmlive, career finder, any city, school, temporary or placement services or business website, websites of newspapers
Some text book notes
Read TIA page 148 summary kleptocratic society. p 150 "Like respect and dignity, privacy is a basic human right...is the right to be left alone to do as one pleases." Social media threat, GPS location threat, censorship154
Cyberbullying serious threat to many 156
B2B Business to Business, B2C to consumer, C2C example Ebay, Craigs List
399 10 impt 146 tot page 5
What are the Basic things to know about Windows
400. How to move Icons Drag them.
401. Left mouse button is for Selecting
402. Right mouse button is for Context sensitive MENUS
403. How to use “Help” in windows and other programs to get answers Click the help icon
404. How to move a window Drag title bar
405. How to maximize. Click the maximize button
406. How to minimize Click the minimize button
407. How to bring it back in view. Click window Icon on Taskbar
408. How to display view menu if mouse is broken. Alt V try it
409. How to resize any window. Drag the sizing handles
410. The + - before a folder in Windows Explorer does Expands list or Contracts the list
411. How to Scroll vertically, horizontally. Use wheel, scroll bars, scroll arrows or auto scroll
412. Windows Explorer (not Internet Explorer) allows you to accomplish what 7 things. see files or folders, also open them, cut them, copy them, delete them, rename them, move them, see properties
413. How to see disk space. In Win Explorer Right Click drive, select properties
414. What does Details view show Name, Size,Type, Date Modified
415. How to create a new folder. New folder button in Save As, or File New, Folder
416. How to do a disk clean up? Right click drive icon, select Properties, Click on Disk Cleanup
417. What program repairs fragmented files? Defragmenter
418. What program repairs files? Scandisk (Error checking program)
419. How could you start the above two programs? Right click drive icon, select Properties, Tools
420. What is Word Pad? a basic word processor that comes with Windows
421. How to save any file to a new location and name File? Save as, select location, give name
422. How to find files? Right Click drive icon, Search
423. How to make a short cut? Right Click the Icon, Create Shortcut
424. What is recycle bin used for? Temporary storage place for files no longer used but recoverable
425. How to get a file back that is deleted? Restore from recycle b Indiana But if recycle Bin is emptied can files be recovered? use web sites like officerecovery.com, pcsupport.about.com
427. How to copy anything? Right click it select Copy, or Save Picture as, or Print Screen.
428. How to paste anything? Right Click, select Paste
429. How to set time or date? Right Click the time, select Adjust Time & Date
430. Why not bump, kick or hit the computer? Can cause HDD to begin damaging itself by crash
431. Why Shut down computer during storms? To protect it from surges.
432. If power goes off in your area what should you do? Unlug electrical equipment.
433. Why unplug electrical equipment? To protect it against surges and brownouts.
434. When to replug in? Wait at least ten minutes after power comes back on to avoid most surges.
435. How to make a copy of a file? Right click file select Copy. Paste to another location, Burn to CD
436. What can one do with a CD-RW that one cannot do with a CD-R? Rewrite to it
437. Shortcut to Windows Explorer: Right Click the Start button, Select Explore
438. Smart card a small card with an embedded computer chip. Some are credit cards or ID cards.
439. How to print anything from the screen, such as a directory? PrintScreen Key paste into a programs like OpenOffice, Word, Wordpad, Paint, GIMP, then File, Print
440. Burning The process of writing data to an optical disk.
441. How to maintain computer. First thing when you get it is make the restore disks right away. And if possible image the drive. Turn on auto recover and set a recover point. If the computer ever stops working because of software you can restore it back to a recent restore point. Don’t jar it while it is running, run scan disk often use anti malware programs often, blow out dust yearly, keep it from overheating, non humid room, use UPS, turn off when not in use.
At least once a month. Do a disk clean up, a scan disk and a defrag. Defrag may take hours so is best done when computer is not needed for a few hours.
More on Windows operations at beginning of Tech in Action and in Chapt 5 p 222. 44 imp 190 total page 6
450. What to do if Windows locks up? Try Ctrl-Alt-Del, to get Task manager and end offending program
Reset button, F8, F11 Safe Mode or last resort reinstall Windows. P 220 has checklist
hold down power button for 8 seconds. Then wait at least a minute for everything to clear.
If problem repeats turn on Problem Steps Recorder.
451. Start, Run, MSCONFIG is a useful tool. Can control what is started at start up, and more. Turn off all unneeded programs. Usually all you need is antivirus program.
452. Ctrl-Alt-Del also gets you the task manager useful to see processes, find spy ware, and stop tasks.
453. Sort processes by clicking on CPU tab until idle process is on top then observe what is using CPU.
454. Computer running too slow. Get rid of unnecessary files use Disk Cleanup by right clicking C drive select properties. The Disk Cleanup button is there. Then click on the Tools tab and run error check. This is the old Scan disk program. It is good to run this monthly. Then over-night run disk defragmenter as it takes hours. Get rig of unnecessary programs like Weather Bee and all unnecessary programs on the desktop and taskbar. Get rid of unnecessary running programs with MSCONFIG to turn off everything but your anti-virus program and ask Manager. Use up-to-date anti malware. Add more memory. Run fewer programs at same time. Run registry cleaner.
How to get rid of viruses and spyware. Use up to date anti malware such as AVG free, SpyBot Search & Destroy, Ad-Aware all free. Norton antivirus. Keep these up to date and run often. If infected run these in safe mode. Start computer and tap F8. Or run anti-virus disk at start up. Run anti spyware programs
Go to control panel programs or add/remove programs and remove all unnecessary programs and questionable ones. However some are used by windows so run a Google search on them before removing those.
465. Install a second browser to use in case explorer gets corrupted.
If browser has been redirected clean out the Hosts file. Which is a text file.
To recover data from crashed windows system. Put in a live CD such as Ubuntu. Boot it up. Plug in a USB flash memory drive. Copy important files to the flash memory or is not big enough to another hard drive or burn it to a CD..
470. Consider storing important data on a portable USB hard drive and CD or DVD. This is easily switched to any other machine.
471. Consider turn on firewall or use one such as Zone alarm which has both free and paid versions.
472.Create a shortcut to any program by Right clicking it and select create a shortcut or Right Drag it to where wanted and then select copy shortcut here.
Shortcuts Ctrl+a Select All Ctrl+c Copy Ctrl+x Cut Ctrl+p Paste Ctrl+z Undo see p 54
474. Shortcut to Explorer Right click start or windows explorer icon. Windowskey+r starts the Run program
475. to add a folder to desktop just right click a blank area of screen select New, Folder, type name, Enter
476. Notepad is a simple plain text word processor used to write simple text for notes and programming.
477. Wordpad is a simple word processor without a spell checker.
478. The calculator is just that. It can be set for standard or scientific (has more features) displays.
Computer related jobs students can do to earn money while still in school. Install and run anti-virus software, computer tun-up, blow out dust, data recovery, removing viruses, making web pages, tutoring, show people how to use computers, there are thousands who don't know. show people and businesses how to use social networking to increase sales, get a part time job doing that for the business.
Chapt 2 most important facts are in these notes. 48 data vs information, but note nice chart on page 49
Hardware follows next page and software which is programming follows that.
23 impt 213 total
page 7
HARDWARE
500. What is HARDWARE the physical parts of the computer system and network
examples of input, keyboard, mouse, microphone
501. output devices monitor, printer, speaker
502. monitor what you look at same as screen
503. CPU central processing unit the main processor that does the computing
504. GHz, gigahertz billions of cycles per second
505. MHz megahertz millions of cycles per second
506. memory a temporary storage place for data waiting to be used by the CPU
507. storage device a drive that allows data to be stored on it for possible future use
508. NIC Network Interface Card. a card or device that interfaces the computer to a network.
509. modem a device that interfaces the computer to/from a phone line or cable line
510. Network, a collection of computers and other devices connected to share data and resources.
511. What is Data? unorganized input used by computers
512. Information: organized data output with additional value used by Humans
513. Why are computers powerful? Stores a lot, Very Fast, Accurate, Reliable, Consistent, communicates
514. Information processing cycle. Input, Process, Output, Storage, sometimes Communicate
515. PDA Personal Digital Assistant a handheld computer
516. What is a PC personal computer for one person sometimes means IBM clone, Mac an apple computer
517. kiosk Public computer station often having a touch screen
518. main board also known as mother board jargon mobo
519. chip piece of plastic with micro circuitry inside newer processors have millions of transistors in them
520. system speed. How fast is adequate? Depends for word processing 100 MHz for Graphics 2GHz
521. RAM random access memory readable writable memory used by the CPU
522. ROM read only memory can not be written to
523. CMOS chip where the computer settings are held
524. expansion card. a circuit board that is plugged into the main board to add circuits
525. sound card a circuit board that adds sound producing capability
526. video card a circuit board that adds video capability
527. PC cards little credit sized circuit boards that add electronic circuits like WiFi, USB, Bluetooth
528. port a place in the system unit to add connections or devices
529. Old serial port interface connects device to the system unit. It transmits only one bit at a time.
530. parallel port connects devices that are capable of transferring more than one bit at a time, printers.
531. firewire special high speed port that can connect multiple types of devices
532. touchpad flat pointing device used on a laptop computer.
533. Males don’t use a laptop on your on your lap for long as can damage sperm causing birth defects.
534. pointing stick pointing device on a laptop computer
535. stylus device that looks like a ballpoint pen, but uses pressure, to write text. Used on handhelds.
536. pixel picture element, a single point in an electronic image the more the better
537. optical scanner device that scans documents and pictures for computer input
538. OCR Optical character recognition changes scanned document fotos into text
539. bar code a series of lines readable by a computer scanner
540. POS terminal point of sale computer such as a store checkout
541. biometric device reads human physical features and inputs them to a computer for ID
542. how to change resolution of screen right click desktop, select properties or resolution
543. acceptable pitch the distance between pixels A pitch of .29 or smaller is acceptable
544. acceptable refresh is rate over 60. Below 60 Hz you get flicker and eyestrain
545. CRT cathode ray tube the old type of monitor and TV a big vacuum tube
546. EMR electromagnetic radiation
547. LCD liquid crystal diode
548. ink-jet a printer that sprays ink on to the paper
42 impt 255 total page 8
549. S-video port s special port that efficiently transfers video signal
550. how to save money on ink while printing use the draft mode, change density level in printer
551. what is important about laser printer it is very efficient, more reliable, has permanent and cheapest ink
552. What is important about dye-sub makes more permanent color prints. Some printers under $100
553. ripping generaly copying songs from a CD
554. How many songs can be stored on a CD using WMA 20, MP3 200
555. write protect notch is used to stop someone from writing to a FDD
556. shutter The snap shut door on FDD that protects it from finterprints & dust
557. head crash occurs when head touches the platter caused by bumpingmoving or hitting computer
558. best care of disks keep them protected in case, avoid dirt, fluids, heat, scratching
559. miniature storage media examples SD & compact flash card, memory stick
560. micro SD is the smallest flash memory form available
561. Micro SDHC has higher capacities
562. Micro SD has adapters to the larger sizes
563. see page 60 monitors specs, LCD, LED pixel CRT 61 aspect rato 4:3 now 16:9 16:10 1600x1200
contrast 400-1000-1 viewing angle 150 recommended
brightness 55 300cd/m^3 62 projectors, printers, 67 mobo, cpu 68 ram, hd floppy
564 ports speeds 72ports USB1 USB 2 480mBPS =40X USB3 4.8 Gbps=10x Parallel 500kbps
Firewire 400Mvps Firewire 800Mbps Firewire 3200=3.2Gbps Connectivity port ethernet 1000Mbps
serial 4 pin 8 pin 9 pin
565 VIDEO PORTS p 74 Video VGA DVI only video S Video HDML high definition
566. ergonomics efficient human interaction use wrist pad p 76
567. New tini PC slightly bigger than USB drive is Raspberry Pi. With an expected retail price of just $25.
566. LED monitors offer more intense lighting and finer color resolution, and sharper contrast. They use 40% less power than their LCD. LED’s have a much sharper image from an angle. But they are more expensive. Currently LEDs are not small enough to be used for individual pixels in domestic screens, and so the use of true LED used in much larger screens in public places. See http://www.youtube.com/watch?v=YjglBWoRg0s
567. OLED displays, see http://www.youtube.com/watch?feature=endscreen&v=3uBR_M9bSCc&NR=1
An OLED (organic light-emitting diode) is a light-emitting diode (LED) in which the emissive electroluminescent layer is a film of organic compounds which emit light in response to an electric current. This layer of organic semiconductor material is situated between two electrodes. Generally, at least one of these electrodes is transparent. These are thinner 3mm, Brighter, Nobacklight needed, uses less power, flexible, transparent, will work on windshields, eye glasses and wearable on clothing.
What are the categories of computers. hand held, mobile computer, are all PCs next up in size and power is server, mainframe, super computer. Computer chips are also embedded in other devices such as cars, electronic thermostat. Note discussion on keyboards on 52 and 53 and Dvorak keyboard which was better. Numbers are best entered from numeric keypad. Ethics p 58 Avoid causing harm. Projectors check bulb price first 62. Printers 63 all-in-one has scanner, fax. Table of capacities on 71 Dual layer DVD DL 88.5 GB
HZ means cycle per second. Port speeds USB2 480MB USB3 4.86GB, Ethernet 1 GB
Wearable screen glasses myvu.com personal media viewer from zetronix giving big screen experience. The effect is that you feel as though you are watching a 80" flat screen television, from 2 meters away, in a dark room.
Bistable screens use less power show display with power off.b The zenithal bistable device (ZBD), developed by QinetiQ, can retain an image without power. The crystals may exist in one of two stable orientations ("Black" and "White") and power is only required to change the image.
Kent Displays has also developed a "no power" display that uses polymer stabilized cholesteric liquid crystal (ChLCD). Used to cover the entire surface of a mobile phone, allowing it to change colors, and keep that color even when power is cut off.
20 impt 275 total
Page 9
OPERATING SYSTEM SOFTWARE
600. What is Software, programs
601. What is a program sets of instructions that tell the computer what to do
602. How are programs installed Usually put CD in follow prompts
603. How are programs best uninstalled Start, Control Panel, Add Remove programs. So that all parts are removed. Don’t just delete them. This leaves scattered parts.
604. byte 8 bits bit binary digit a 1 or 0 smallest unit a computer can understand
605. file a named collection of data or information
606. how does GUI compare with DOS has black screen with words all commands must be typed in. 332 But the GUI is like Windows. user clicks on objects, buttons & menus.
607. DOS Disk Operating System command line interface uses typed commands at command prompt
608. Operating System OS software that runs computer coordinates all activities of hardware devices
609. examples of system software Windows, DOS, Mac OS, Linux, Ubuntu, Unix
610. utility programs maintain computer or files.
611. examples of utility programs: Windows Explorer, Defrag, Scandisk disk cleanup.msconfig
612. Linux a free UNIX like operating system often has a GUI on top
613. Linus Torwalds invented Linux and gave it to the world for free
614. Why is Linux important? it is both a free and very good operating system. No crazy long serial number needed, eliminates need to pay tribute to the Microsoft God.
615. Why is open source software important? gives you good software for free
616. What is shareware? try before you buy software
617. public-domain software. Software that has been put in the public-domain
618. menu A list of choices
619. pointer a movable icon that shows where one is on the screen
620. OLE Object Linking & Embedding programming that allows one to cut and paste
621. scandisk (error check) This program tunes up the directory of disks. Run it often
622. GUI Graphical User Interface where a user can click on objects. example Windows
623. Disk formatter a program that prepares a disk to be used.
624. Memory a temporary storage place for data waiting for use by the CPU. is usually volatile.
625. Driver is a small program that runs or interfaces with a device
626. Plug and Play series of programs that allow the computer to install devices.
627. file compression the process of making a file take up less space.
628. Defragmenter a program which repairs fragmented files.
629. How to warm boot Ctrl-Alt-Del or reset button is a faster than cold boot less shock
630. Cold boot is starting the computer from a power off state
631. ASCII American Standard Code for Information Interchange, most widely used data coding system.
632. digital convergence the trend to merge multiple digital services into one device.
633. digital counting digits or a sudden large change of state on off high voltage low voltage
634. Columns in Binary 1024, 512, 256, 128, 64, 32, 16, 8, 4, 2, 1
635. Binary 1 10 11 100 101 110 111 1000 1001 1010 1011 1100 1101 1110 1111 10000 10001 10010
636.binary number system uses only 0 & 1 is used by digital devices be able to count to 1024 in bninary
637.To see table go to Wikipedia search for ASCII scroll down observe table
638. hexadecimal (hex) is the base-16 numbering system introduced by IBM The number 79 in binary is
01001111 in hex is 4F. Hex is used in computing as the most common form of expressing human- readable byte as all 256 values in a byte can be represented using 2 digits in hex.
640. What is 1-16 in hexadecimal 1 2 3 4 5 6 7 8 9 a b c d e f 10
641.Columns in hex are 1048576, 65536, 4096, 256, 16, 1 Use the Windows calculator to compute
642. gigaflop: speed measurement of microprocessors billions of floating point operations per second
643 Unix multiuser operating system often used by large computers
644 smart fones use a small OS like symbian, BlackBerry, Windows Mobile, OS x, Android and web OS. These can run more than one application concurrently. 30 impt 305 total
Page 10
645. Gaming consoles have an OS. Often called firmware.
646 Linux is increasingly used.
647. Android OS by Google is Linux based.
648. Noktia MeeGo is also based on Linux.
649. Sugar the sweet OS for every child laptop.org used on XO-1 notebook
650. See page 221 for boot process. Good to read for understanding.
651. Safe mode hit f8 during early boot process p223
700 Application SOFTWARE
701. Application Software programs that are dedicated to doing a specific task for the user.
702. word processor is a program that helps create text documents.
703. spreadsheet is a program that involves numbers contains rows and columns and allows formulas.
704. presentation graphics another term for slide show maker example PowerPoint & Impress
705. database a program that organizes data to make it more usable
706. How to start an application program? Click on its icon or select it hit Enter
707. know common file extensions such as .txt and how is it used for text documents
708. .doc is used by Word for word documents.
709. .xls is used by Excel for spreadsheets 710. .ppt is it used by PowerPoint for sideshows
711. mdb. is the file extension used by Access for database files 34 bold
712. odt is the file extension used by OpenOffice for document files.
713. ods is the file extension used by OpenOffice for spreadsheet files.
714. become aware of other kinds of application software. Business accounting, legal, education,
715. entertainment, education, children's learning software, publishing, web page creation, music.
716. Evernote.com free notetaking app can save txt, images, screens, audio, webpages, fotos all searchable.
717. To save and publish fotos can use snapfish, kodak, shutterfly, flickr, google picasa
718. speech recognition software P174 some included in windows and office or buy Dragon
719. Free word processor, spreadsheet, slide show is at Google Docs, MSLive, Zoho.com, Thinkfree.com
720. Web creator Dreamweaver MS expression
721. VR Virtual Reality secondlife
722. Audio editors Audacity, sourceforge.net
723. sonysoundforge, sonycreative software.com
724. Video editor Mslive movie maker, download.com For Youtube flu(flashvideo) Ipod used MP4
725. p 188 pcdecrapifier.com to clean up new PC. P190 Freewarehome.com butterscotch.com free software
726. sourceforge.net tucows.com techsmith.com also can try beta versions free
Computer Crime, Security
Best Insurance is good copies on other drives and DVDs stored in secure place have duplicate in another safe place. Always use up to date anti malware, turn off computer when not using,
Use a firewall, don't store sensitive data on HDD or don't use that machine on network or Internet.
Can Linux help? Yes you can surf the Web without fear of viruses or spyware see pendrivelinux.com
MALWARE viruses, spyware, worms, Trojan horses, time bombs, logic bombs, adware
virus a hostile program that may damage your files, software or computer
worm a program that actively self replicates itself without being opened
Trojan Horse a program that poses as a good program but actually is a hostile virus
anti-virus programs look for a virus signature (pattern)
quarantine putting the virus in a place by itself where it is harmless
spyware software allowing malicious monitoring or control of your computer
logic bomb hostile program triggered by logical event such as employee fired or opening file # of times
time bomb a hostile program that is triggered by a time Michaelangelo
What is spybot? a free and good anti spyware program
23 impt 328 total page 11
adware is software that secretly spys on you & collects info for advertising purposes
What is Ad-aware? an anti spyware and anti ad ware program
Hacker a person who wants to snoop in your computer
teenage hackers also called script kiddies use tools already created to wreak havoc.
cracker is a criminal hacker is hostile may be subverting systems and stealing your identity.
Countries and organizations do sponsor hackers to steal information this is called espionage. It is happening big time right now. Our country has lost much information to China and others in this way and because of poor and self serving leadership not doing their job to protect our country. Check it out yourself see if I am correct. Just take a look at congress actions and boondogglers.
Packet sniffer a computer program that looks at packets as they travel in a network to get your passwords and other information. Use a firewall and encryption to fight them.
firewall is hardware and software to stop unsafe traffic in and out of your computer
bot an automated program. Some perform searches
How to reduce spam? delete unknown emails, do not subscribe to offers
Should computer always be on? no save money, less wear, better security, fire safety.
What does Alt+F4 do? closes windows
safeguards against information theft: do not give out sensitive info or save it on hard drives
What makes a better password? longer with numbers no common words. Saying letters wysiwyg
biometric identifier uses face recognition, voice, finger, retina, hand recognition. Another example showing up all over in public places are cameras. If a face scanner is hooked up to it it can scan hundreds of faces an hour and pass identity info on to whoever is running it. You will soon be video taped in public places. This would be great for catching wanted individuals, dissidents or protestors the government doesn't like. See the movie Enemy of the State. Cameras and listen devices are now so small they can easily be hidden almost anywhere. YOU MUST must read 1984 by George Orwell. If you don't have time read a summary of it.
EULA User License Agreement you agree to by just opening a software package
surge protector is an electronic device that renders surges harmless
UPS uninterruptable power supply protects from power surges, low voltages and outages
Encryption making data unreadable except to intended recipient. Why is Encryption important? It stops others from seeing your information. But government can break it. Privacy is dead.
How to make a copy. File save as save to different drive or to a CD-R. Back up programs are good fur businesses to use on regular basis but they are worthless if you change OS version. And you can't just pull out one file. You have to restore the whole drive. For individuals and students just a good copy is less work.
secure transactions are encrypted transactions. How do you recognize them? https
How to protect your privacy: don’t give out your date of birth, social security number address phone and other correct personal information. Use an email without your name. Also make up a phony one with a different year and month and day and continually use that one. Use a phony name and address and keep using that. Make sure that it is to a vacant lot or property. Make up a phony set of data. phone number address. Look up your deceased relative on the Social Security Death Index and give out that social security number. If someone who is not entitled wants your social security number give then that one. No one is entitled to your social security number except You, IRS, your bank, your employer. No one else. Just give them the dead one. These numbers are not reused and raise a D (deceased) flag causing those who try to use it for credit cards to be caught. Same with drivers license number. Tell then no you will just take your business elsewhere.
information privacy The right to keep your personal information private.
electronic profiles Information about you used by organizations to sell you things.
identity theft The use of your personal information by someone else steal identity and your money
key logger a program that records your keystrokes often to obtain your passwords
phishing scam involving spoofed email and websites to acquire your personal information
pharming scam of hijacking web sites to steal personal information
port-scanning software looks for open ports where hackers can get into your computer
piracy illegal copying & distribution of digital intellectual property
30 impt + 328 = 358 total page 12
zombie a computer under remote control of a malicious program or hacker
botnet a large group of programs running autonomously on zombies.
forensics looking for evidence of illegal activities in equipment.
war driving cruising neighborhoods looking for open WiFi networks
Cookies little files placed on your computer by websites, some violate privacy, possible harmful
spam junk email
Chapter 9 securing your system. Security p 410
boot-sector virus replicates itself into a master boot record.
Script viruses hidden in form of scripts
macro viruses attaches itself to a document that uses macros
email virus Like Melissa uses the address book to distribute the virus.
Encryption virus encrypts our files making them useless to you and demands money to fix.
Polymorphic virus changes its own code to avoid detection
CAPTCHA completely automated public turing test to tell computers and humans apart. P 413
Free antivirus program try free.avg.com
Instant messaging is ripe for viruses especially if used on public computers.
Is your computer secure go to Grc.com Gibson Research for a free test. p422
CAREERS IN IT SEE P 456
Communications & Networks chapter 7
network a collection of computers and other equipment for sharing data and resources
What are benefits? Allows sharing of Internet source, sharing a printer and other devices on the network. Allows the government and others to spy on you. Often violates your privacy. Has potential for outsider control.
wireless. networking is using electronic waves rather than wires
node a device hooked up to a network.
WiFi wireless 802.11 standard using radio waves range 150-1000 ft~3KM outside WiFi-N 270 Mbps
hotspot: area within range of a WiFi network or networks with speeds of 2-50 Mbits,
IR Port that transmits data from wireless devices using infrared light waves
Bluetooth short range radio communications standard using radio waves range 100 Meters 2 Mbits/s
bay an opening inside the system unit where additional equipment can be placed.
analog signal:a signal that continuously fluctuates over time between high and low voltage.
digital devices that understand only two discrete states, on and off; describe most computers
Internet telephony using the Internet for telephoning
VOIP Voice over Internet Protocol allows phone conversations over Internet or network
Public Access Point a wireless transmitter for public use
Bandwidth the speed of a connection. is measured in bits per second
Throughput is the actual speed of data transfer that is achieved. Usually measured in Mbps megabits per second. Cat 6 best to use as is designed for gigabyte connections. But Cat 5 was for 100Mbps.
Test internet connection speed at speedtest.net or broadband.gov
UTP unshielded twisted pair cable composed of 4 pairs of wire twisted around themselves is the most commonly used network cable. P317 limit 100 meters (328')
Broadband high speed (over 200Kbps) Internet connection usually using Cable, DSL or T lines
Coax coaxial cable consists of a single copper wire surrounded by three layers.
GPS global positioning system a satellite system for finding location
voice mail is e-mail using voice
wireless messaging sending messages without using wires
LAN Local area network which is a network covering a small area
Ethernet protocol that allows PCs to contend for access to the network. 10-100 Mbps
NAS network attached storage device
TCP/IP Communications protocol used to define packet switching on the internet.
Packet is an organized collection of data that is transmitted over a network .
34 impt + 358 = 392 total Page 13
radio waves electromagnetic radiation used to transmit signals over a distance
RFID Radio frequency Identification a wireless identification system replacing barcodes
WAN Wide Area Network example the Internet
microwave a short electromagnetic wave used for communication
Wireless Access Point central communications device that allows data transfer wirelessly
802.11 wireless communication standard known as Wi-Fi also spelled WiFi
Why not go wireless? more expensive, possible security problems, interference, batteries
WIMAX 802.16 next generation wireless broadband which is faster than WiFi and has 31 mile range
Intranet? Internal private network; sometimes called an enterprise network.
DSL what is significant about it? probably best price bargain for higher speed
Cable fastest affordable connection for most people
twisted-pair cable is the most commonly used networking method.
.fiber-optic cable is superior, faster10 Gbps, static free, smaller, more secure. lighter
BMP Bit Mapped picture a graphics format in which every dot is mapped, very big file
.PNG replaces JPEG and is better
CAD computer aided design used by engineers and designers
GIMP program that is a free photoshop replacement
Irfanview a very good free foto viewing program and more
MIDI interface for musical instruments
podcast is a MP3 audio file less than 10% of original size or with video MP4 to make just record, edit export to MP3 RSS is really simple Youtube RSS video
sampler digitally records real musical instrument to be played back at various pitches
sequencer allows adding tracks 289
synthesizer 289 produce sounds electronically
ADC analog to digital uses sampling to encode a sound wave 44,100 sps
P2P Kinds of networks Peer to peer just one machine hooked up to another with crossover cable
Ethernet newtowk machines hooked up by CAT 6 cables hooked to a router
Client-Server a client machine hooked up to another called a server to share files from the server
How to make a wireless set up more secure? Disable broadcasting of network SSID, Change the network name to a name differently from that of the factory name, use new password, turn on security protocols to WPA, Impliment media access control so it only accepts to certain computers, Limit the signal range, apply firmware upgrades. See page 328.
Chapt 7 p 333 has info on career in computer security and binary number system, ASCII
SEE P 354 CPU MACHINE CYCLE 1 FETCH FROM RAM AND MOVE TO CPU, 2 DECODE INTO COMMANDS, 3 EXECUTE THE WORK OF THE COMMAND, 4 STORE RESULT IN REGISTER IN CPU ALL DONE IN SYNC WITH SYSTEM CLOCK. 2 Billion clock ticks a second.
Cache memory located on or near CPU for faster access. Se page 357
word size is the number of bits a computer can work with at a time. Example 32 bit or 64 bit processor. Moore's Law # of transistors will double every 18 months. 8086 chip had 29,000 transistors in 1980 and ran at 5 Mhz. Pentium 4 had about 43 million transistors and ran at 1.3 Ghz- 3.8 Fhz in 2000-2008 at 100 Mhz but has a quad pumped Front side bus. In 2010 Intel i7 has 774 million transistors and Intel Itanium 9300 has 2.3 billion transistors execute six instructions per clock cycle at 1.73 Ghz Six cores.
Intel i7 2600K processor machine has 16 GB ram 2 2TB Hard drives and 2 video cards.
AMD PhenomII has six cores so one CPU does work of six.
Pipelining a technique that allows the CPU to work on more than one instruction at a time thereby boosting performance.
Super computer info is at top500.org Current fastest supercomputer is at Japan and China Japan’s “K Computer” maintained its position atop List of the world’s most powerful supercomputers, it is four times as powerful as its nearest competitor. In Kobe, Japan, achieved an impressive 10.51 Petaflop/s on the Linpack benchmark using 705,024 SPARC64 processing cores.
38 impt + 392 = 430 Page 14
Chapt 8 Digital Lifestyle Digital everywhere
Advantages of digital more accurate, easily transmitted, possible cost savings.
Telephony voice communication over distance has shifted from analog to digital equipment.
Cell fones use cell towers transceiver station and mobile switching center.
Fones have many OS Palm uses webOS, Symbian now open source used by NokiaN8, Openmoko is open source. Most successful is Android by Google is Linux based.
gotomypc.com and logmein.comallow connection with your home computer from old cell phones.
Cell fone software: fone functions, to-do-list, contact manager, calendar, word, excel, outlook, PPT, games, email, Internet (see getjar.com for applications) 32GBsd cards have room for thousands of videos.
Communicating between smart fone and computer use card reader or USB port or bluetooth or use cloud. Can be set to push.
Free info call 800 GOOG-411 OR TRY ChaCha 800-2chacha or text 242 242 with any kind of question and real human guides will find the answer. See p 372
Internet on smartfone provided by fone co called wireless ISP is usually separate pay plan. Speed is slower than cable. EDGE 3G as fast as 1.4 Mbps. WiFi in range is faster EDGE has less interferance and is more reliable.
4G claim100 Mbps but deliver 3 Mbps-6. MiFi devices instantly create a mobile hot spot. It used 3G network and converts it into a WiFihot spot good for 30 feet. Ifone 3Ghas bluetooth tethering like MiFu.
SPEEDS Edge in 13,000 cities 1 Mbps, 3G in 300 major markets .6-2.3 Mbps, WiFi hot spots 4-5 Mbps, 4G major cities 5-12 Mbps. On p 373.
VOIP create an account with skype.com converts Internet connection into a fone. Vonage.com lower cost but lower security and no 911 location.
Finding WiFi keychain fobs that light up when they detect a WiFi hotspot. Go to thinkgeek.com to get easy to use WiFi detector t-shirt.
Smartfones are ripe for viruses and identity thieves.
Virtual smartfone number at tossabledigits.com can even set up time to receive calls.
PMP portable media players
GPS Navigation
E-Commerce
B2C Business to Consumer like most websites selling something
B2B Business to Business like a wholesaler site selling to businesses
C2C Consumer to Consumer like eBay
Digital Certificate: electronic business card that verifys the sender of the data
MAC Media Access Control address a unique code in NIC and wireless adapter is like a fingerprint
SSL Secure Socket Layer encrypts your data so that it becomes very difficult to read by outsiders.
HTTPS secure web page
Globalization Digital society, Ethics
Code of Conduct is something that all humans should abide by.
Bring no harm to another by your action or inaction. Don’t do to others what you would not want done to yourself. It appears in this age of terrorism that practicing and enforcing this through rule of law may soon be a matter of life and death for us. Terrorists must be eliminated from this planet 532 otherwise no one is safe. Terrorists must be marked and expelled from civilization or they will continue kill. Not if but when they get their hands on WMG they will kill millions to billions if you consider nuclear winter.
Intellectual property rights are your rights to profit from your mental work (papers, songs, books)
plagiarism taking credit for another’s work
employee monitoring observing employees activities. It is very legal and upheld by supreme court.
Health concerns RSI Repetitive Stress Injury
CTS Carpal tunnel syndrome aggravation of nerve pathway on wrist
offshoring: relocation of an entire production line to another country
outsourcing: using an outside company to take over portions of the workload
ergonomics: designing things we work with to promote health
22 impt + 430 = 452 page 15
globalization: changes in society and economy resulting from international trade & cultural exchange
ethics: matters dealing with what is generally considered right or wrong
protocol a set of rules and programming allowing computers to talk with each other
Unicode a coding scheme that can code all of the world’s languages so all can read them
What is the World language problem. There are over 5000 languages in use around the world. The world communication problem is a huge problem costing thousands of lives in aircraft and ship accidents, misunderstandings or disagreements that cannot be resolved because they cannot understand each others language so end up settling it with violence and death. American Internet users do not realize it but they are often shut off from getting complete information because it is posted in another language. English is very difficult to learn has the worst spelling of any language is very ambiguous and has over 2000 common idioms. 90% of the world’s people do not understand English and will not learn it in our lifetime. There have been thousands of deaths and very much misery caused by language nonunderstanding. Bad for Peace and trade.
Esperanto is an international vocabulary, quickest & easiest to learn, you can recognize over 1000 words of this language which can save thousands of lives if a few people from each community learn it.
It has speakers in over 100 countries. It helps people learn other languages and English.
The most time and cost efficient solution to the world language problem is international vocabulary now spoken in over 100 countries. You already know many words in this language. To learn more go to Esperanto.net. No it is not Spanish rather an easy to learn vocabulary based on international words.
What is big brother? In general the government or organizations spying on you
Is someone watching you? Yes Employer, Government, school (note camera by restroom, TIA, Echelon & other organizations. Who else is gathering information about you?
Who is selling information about you? Intellius an organization that gathers personal information about you & sells it Choicepoint an organization that gathers personal information about you and sells it
Echelon a spying program used by government agencies to record everything you do on the Internet and phone. Google it! At least read what is in Wikipedia about it Do we need it in this time of terrorism?
Carnivore is another spying program used by government agencies to monitor people.
libel deliberate act of defamation of character by making false statements of fact.
heuristics: procedures that usually find a good solution in decision making process 442
Censorship the control of speech, reading matter, communication practiced around the world
Computer related jobs students can do to earn money, data recovery, tuning up computers, recovering lost data, making web pages, tutoring, helping people understand how to use computers
telecommuting & work at home offer great possibilities
Best way to find a job is networking.
DATABASE LANGUAGES
DBMS
GIGO Garbage In Garbage Out
Database is made of records, Records are made of Fields, Fields are made of characters
Database is a collection of related data that can be easily stored, sorted, organized and queried. Databases allow large quantities of information to be stored, organized, queried and retrieved easily.
know how to create a field name and set field size
primary key is a unique field used by the database
relational database organizes data in a table format by logically grouping similar data into a relation.
Object-oriented database stores data in objects like fotos, videos, audio clips
BLOB binary large object like video
OQL object query language
multidimensional database stores data in more than two dimensions. Makes them easily custimized and can process data much faster.
Data integrity ensuring that data in a database is accurate and up to date
Documentation is the written directions on how to use a program
20 impt + 452 = 472 page 16
brainstorming a good method for getting good ideas where members present ideas without criticism
DSS decision support system is used to support problem-specific decision making
Artificial Intelligence computers ability to mimic or duplicate functions of human brain
programming Languages a computer program used to program computers
What is the only language computers understand machine language
web page applet is a helping program to a browser example Flash, QuickTime to view movies
What is HTML hypertext markup language is used to create web pages
XML Extensible Markup Language for organizing the content of a web page
1GL first generation computer language machine language written in binary is 0s and 1s
2GL second generation computer language assembly language used symbols LDA
above two are low level languages and must be written for a specific machine
Compiler a program that changes object code into machine language all at one time.
The languages below are high level and can work on any machine.
3GL third generation computer language English-like words, is a procedural language, program tells computer what to do and how to do it,
examples of 3GLs BASIC, COBOL, C
BASIC:(Beginner’s All-purpose Symbolic Instruction Code) = Programming language developed in the mid 1960’s for use as a simple, interactive problem solving language.
4GL forth generation computer language uses English-like words but is nonprocedural. Specifies what the program should do without explaining how
examples of 4GLs An example is SQL a query language, OOP, Java C ++
5GL fifth generation high level language used to create AI or expert systems programs
examples of 5th Gen language Visual BASIC, VB.net, Visual C++.net Delphi power Builder.
OOP Object oriented programming used in GUIs
flowchart a graphical diagram of the path of a program from start to finish
SQL Structured Query Language is the standard query language for relational databases. 47 bold
see the chapter for those of you interested in more detail on languages
Chapt 12 more networking and security
extranet an area of an intranet that only certain folks can access.
VPN virtual private network uses the public Internet to build a secure, private network among various locations. Uses tunneling data packets placed inside other data packets encrypted.
ViFi vehicle WiFi allows a moving device to connect to more than one access point at the same time
Fiber Optic Cable made of glass or plastic fibers. Data can only travel in one direction. Comparison with wired max run length w 328' FO 62miles, bandwidth 10Gbps FO 10-40Gbps, FO less interferance but higher cost. RFID p 590
OSI Model p 582 Network adapters 584 Switches, Bridges, Routers p 587
MAC addresses media access control address 586 Network security, Authentication, access privileges
Chapt 13 more on Internet 608 Users connect to an ISP thru a POP point of presence. Could be bank of routers, modems, servers. Most done on client/server model but BitTorrent uses peer-to-peer
TCP/IP is the main suite of protocols Transmission Control Protocol and Internet Protocol
DNS domain name server stores the ip addresses of each top level domain
HTTP is the protocol used by a browser to transfer documents across the internet.
SSL secure socket layer and TLS are network security protocols
HTML and XHTML are scripting languages to mark up text for use as a web page
XML extensible mark up scripting language describes the content in terms of what data is being described rather than how it is to be displayed.
CGI common gateway interface provides a methodology by which your browser can request that a program file be executed instead of just being delivered to the browser. CGI scripts are placed in a directory called cgi-bin. This holds scripts to be run by the server. Called a server-side-program.
Dynamic HTML is used to create web pages that change after being loaded.
JavaScript is the most commonly used scripting language for creating DHTML effects.
23 impt + 472 = 495 page 17
Private Browsing feature stops recording of site history
To have more privacy use PGP Pretty Good Privacy from download.com also hushmail.com and comodo.com have encrypted mail
WIMAX a wireless alternative to WiFi worldwide interoperability for microwave access. Range 31 miles speed of up to 72Mbps faster than DSL also on page 14 of these notes
Crowdsourcing giving a task to a large group of people
cloud-computing p 634 business services online.
What To Know about Slide making Programs Like PowerPoint, OpenOffice
The following are the minimum features you should learn to pass the test.
Add text to slides
Vary The Font.
Vary The Font Size.
Change Font Color.
Insert a graphic (clip art, picture) into a slide
Animate the graphic
Animate text fly in is most common
Use WordArt and its features such as change its shape
use Transitions between slides
make background colors solid or gradients
Add A Table
Add “No” Symbol
Delete A Slide
Add an AutoShape add fill color
Crop A Graphic.
Resize A Graphic.
Create a hyperlink.
Correct Spelling.
Add Banner or AutoShape such as a banner or 5 pointed star
Add A Column Chart, 3 D chart, Pie chart
Add An Organization Chart.
Rotate a graphic. Not an animation
Add a PowerPoint sound to play
Make the background a gradient using two colors
Change View To Slide Sorter View.
Add A Note To A Slide (at bottom)
Insert an excel chart
Make a Gradient fill on a drawing object or auto shape.
Animate the text upon text entry so that each line comes in separately
Include a footer on all slides with your name on it
know how to include background music in the presentation with added animation sounds
Use a presentation design theme.
Omit the background graphics from a slide.
Save The Presentation As A Web Page.
Rehearse (Set) Timings
Make a notes page
Print notes page
Print Presentation As An Outline
Print the entire presentation at six slides per page
know how to make a back up copy of your presentation.
Page 18
What to Know about Word Processors
Know how to do the following things with a word processor such as WORD or OpenOffice
insert words in a document
move text in a document
cut copy and paste
find and replace text
use autocorrect
spell check a document
find a synonym
make text bold italic underline
highlight text
add a border
add shading
indent text
make decimal tab
set tab settings
add bullets
add number paragraphs
add numbered outline
create a header
create a footer
create columns
add page numbers
set margins
set orientation
add a table
autoformat a table
add grid, borders
add row to a table
delete column from table
table set centering of text
print preview
print a document
create an envelope
create a label
save a document
make a resume using a template
add word chart
chart data
make a diagram
format a diagram
center and merge text
insert a comment
delete or edit a comment
preview document as web page
save a document as web page
track changes in a document
show insertions
review changes one by one
add a hyperlink
change a hyperlink
insert a symbol
insert date field in a heading
show reading layout view
use clipboard
create autotext entry
change font size
change font
format a picture
insert a text box
email a document
show hidden text
change document properties
do a save as
save as RTF
right align text
delete a word
do a word count
use research task pane
hide white space between pages
use auto text
format page numbers
justify a document
edit a comment
Page 19
SPREADSHEET You may use OpenOffice or Microsoft Office. Know how to do the following:
Insert cells
Delete cells
Move contents
Edit text
Format decimals %
Change date format
Unhide a column
find and Replace
Go to
use Autofilter
make a new worksheet from template
Hide a column
change Row height
change column width
apply style
change page orientation
add header
set print area
print worksheet
preview worksheet
print data in two ranges
insert a blank worksheet
remove a worksheet
move a sheet tab
format a sheet tab
create formula to subtract
edit a formula
create a formula with an absolute reference
create formula using relative references
total
MIN
MAX
DATE
Insert current date
PMT
IF
Pie chart
use Chart wizard
Move graphics
Preview as webpage
Save as web page
Add hyperlink
Add comment
Edit comment
Cut Copy and Paste
Insert row
Delete row
Fill handle
Fill series
Alphabetize list
Sort list
Change margins
Print part on one page
Move chart
Hide worksheet
Hide workbook
use thesaurus
Center text hor/vert
Print all worksheets
Select, print non adjacent worksheets
Hide page breaks
print formulas
insert hyperlink
freeze
use of NOW
make a payroll
PAGE 20
The Excel assignment has several parts and is to be checked for credit when all is complete
Make a payroll for ten employees.
Exl101 Excel Assignment Payroll
My Payroll |
|||||
|
NAME |
HOURS |
RATE |
GROSS |
TAXES |
NETPAY |
|
Sue |
40 |
15 |
Hours * rate |
Gross * .12 |
Gross - taxes |
|
Tom |
30 |
10 |
300 |
36 |
264 |
1. Type My Payroll in one cell that spans all cells, in Red 12pt. Roman font
2. Column A is for NAME, column B HOURS, C RATE, D GROSS, E TAXES, F NET PAY, G OTHER
3. Make payroll for 10 employees. Vary names, hours and rate.
4. Your name in 16 point bold Roman type in the center of a header with the date on the left side and the time on the right side.
4. Create correct formula for GROSS (hours times rate).
5. Create correct formula for taxes (gross times .12).
6. Create correct formula for NET PAY (GROSS MINUS TAXES), make background yellow.
7. Format all cells with money to right aligned currency. (format menu/ cells/ number)
8. Auto fit the worksheet. (select all/double click dividing line at right of any header)
9. Change RATE column to 11 points wide, format three decimal places, left aligned currency, green type.
10. Modify the words in the column header line to Roman, 12 pt type.
11. Make TOTALS along the bottom for columns with numbers, use comma format.
Center items in column A. Right align items in column B.
Make the average column show the average of all pay rates. Use the average formula.
Use the MAX formula to show max rate in the MAX column.
Use the MINIMUM formula to show the minimum rate in the MIN column.
Use the correct count formula (there are more than one) to show the count of employees.
Place red double border lines around the outside
Make blue inside border lines around the inside borders.
Set the print area. Print the worksheet using landscape so it fills one sheet.
Turn on print formulas and print the worksheet to show formulas.
Sort the worksheet by name keeping all headings at the top and all lines correctly aligned.
Make an Inventory for 10 items.
|
Item # |
Name |
Quantity in stock |
Cost |
Retail Price |
Value of Inventory |
Order Or No |
special |
|
12345 |
Bolt |
100 |
100 |
200 |
10,000 |
ORDER |
average |
|
12346 |
washer |
50 |
50 |
100 |
2500 |
no |
75 |
|
|
|
|
|
|
|
|
MAX |
|
|
|
TOTAL |
TOTAL |
TOTAL |
TOTAL |
|
100 |
Place your name in 16 point bold Roman type in the center of a header with the date on the left side and the time on the right side.
Make a footer that places the word inventory in the center, the file name on the left and the sheet tab on the right.
Create an inventory spreadsheet of 20 parts. Vary names. Vary cost between 50 and 200.
Use fill handle to fill in part numbers.
Use any short name for part name such as nail, bolt, pin, plug, mat, disk, nut, nail.
Right align name column.
Vary quantity in stock from 50-200. Half should be under 100 the other half over 100. Assort these at random. Format the word QUANTITY into italic, format that column so contents are centered.
Format COST column to have fixed currency, bold type, and yellow background but show inside borders.
In RETAIL column make formula for 2 times cost. Format column to right aligned currency with three decimal places.
Make value of inventory = quantity in stock times cost.
In ORDER COLUMN format the word ORDER to bold and underlined and make IF formula to figure whether we need to restock. (any quantity under 100 needs to be ordered. Hint IF quantity in stock <100, ORDER, no
In Special column type the following labels leaving a blank cell under each in which you will make a formulas that show AVERAGE, MIN, MAX, COUNT, COUNTA.
Make count a cell that counts the number of items having an quantity in stock, and COUNTA one that counts the number of names.
Insert a row at the top of the worksheet that contains the word INVENTORY in red, 16 point bold Roman type centered across all columns.
Put double red borders around the outside of your data and blue borders inside.
Make a bar graph with title and legend, showing cost of all parts and part name on chart.
Make the background of the graph yellow.
Print worksheet then print again showing formulas.
Sort on the part names so all data stays with name
Print and turn in for credit before exam.
Make an absolute reference example.
Relative and Absolute References
|
|
A |
B |
C |
D |
E |
|
1 |
DATE |
PRICE |
BUY EARLY DISCOUNT |
SAME USING ABSOLUTE |
PERCENT |
|
2 |
10/4/99 |
10 |
=B2*E2 |
=B2*$E$2 |
3% |
|
3 |
11/4/99 |
20 |
=B3*E3 |
=B3*$E$2 |
|
|
4 |
12/4/99 |
30 |
=B4*E4 |
=B4*$E$2 |
|
|
5 |
1/4/00 |
40 |
=B5*E5 |
=B5*$E$2 |
|
Make a separate small table and demonstrate relative and absolute references. On the back of the paper write me a note explaining the difference between relative and absolute references. Format date as a date and percent column as percents. Print above both normal and also showing formulas. (Ctrl+ `at top left of keyboard) Turn in for credit before exam. No credit after exam.
Make an example of the PMT function of Excel
Make an example of an electronic checkbook. See How to for how to do this.
All of the above Excel work is one assignment.
follow along on my Excel Demos
enter data, edit cells, esc
fill handle
formatting buttons
payroll
sum avg, max, min, count
making, editing formulas
inventory
widen col/ rows too narrow, scintfic notaton, autofit
if
center across cols
hide col /row/sheet /workbook/ page breaks
freeze
insert/remove cells rows/cols sheets
header/footers add date page numbers
borders
pie/ bar chart
now automaticaly updates
date formats
align text horz, vert
comments add edit
print formulas
insert hyperlink
insert blank worksheet
absolute reference
margins
move /cell /worksheet
order of precedence
set page orientation
PMT
Printing size, noncontiguous ranges, sheets
save as web page
sort, within sort
tab rename / color
thesaurus
What To Know about making a DATABASE
Know how to
Make a table
create a form
make a query
make a report
set criteria
Know about relationships
Know how to make a setting to enforce referential integrity
How to set a primary key
How to delete columns
How to sort in querys
How to use criteria
How to use filter by selection
How to use the show boxes
How to do math in Access
Do the Access review project.
Create a table of customers with the following fields CUSTNUM, FIRSTNAME, STATE, OLDBILL, NEWBILL.
Put in data for 10 customers, with short two letter names, 3 from NY, 3 from VT and 3 from AK. Put numbers greater than 9 and less than 100 into the OLDBILL and NEWBILL fields.
Make the ST field only two characters wide.
Name the table using the naming style taught in class.
Write on it how to set the primary key.
Print the full table. Hand write “1” on this sheet.
Sort the table by FIRSTNAME. (do not print it yet)
Filter the table so that only customers living in VT are seen.
Print this table. Hand write the words "2" on the top of this sheet.
Create a query that shows only fields FIRSTNAME, OLDBILL, NEWBILL.
Add an expression that adds the amount of the OLDBILL to the amount of the NEWBILL.
Name the expression "Balance" so it shows at the top of that column.
Print the results of this query. Hand write "3" on this printed sheet.
Create a form showing all fields from your query.
Modify the form to Put your name in 16 point BOLD and in RED ink at the top.
Print only one customers form. Hand write "4"on this single sheet. Do not print or turn in any extra sheets.
Make a report based on your query.
Put a label at the top of the report containing your name in 16 point bold with Green ink.
Print the report. Hand write “5" on this sheet and turn in only the first page.
If there is more than one page do not turn it in.
Add four more customers from OH and add a Comp Name field.
Fill in short company names in all.
Modify your first query to show just 4 fields: FirstName, CompName, ST, Balance (showing total of LASTBILL and NEWBILL)
Set the query to sort by states.
Print it. Hand write on it “6".
Modify the query criteria so that it will show only the 6 highest balances, with FirstName, CompName, ST.
Print that. Write on it how you did that and hand write “7” on the sheet.
Make a report based on that query of highest balances with your name on top in Blue 16 point, Bold, Italic type. Hand write “8” on that sheet.
Total bolded 463
bold terms Intro 37, Internet 30, Win 46, Hardware 45, Software 34, Security 32, Networking 33, digital 47, Presentation Graphics program 41, Word Processing program 72, Spread Sheet program 66, Database 26