final topics

unix platform
servers on the campus
know the difference between single users
what are the different editions of windows
what is virtualization
know examples of virtualization software
how to create virtual machines
know client operating system
what is spooling
what is virtual memory
what is device manager
how do you get to the device manager
what is rj 11
what is a thin and thick coaxial cable
routers and switchers
know the difference between star
 what is the protocol of the internet
what is the encryption scheme on campus
know the difference between wifi and wimax
what are the database management systems
what is the one used on pc's (access)
 what is some of the data evaluation teqniques
how to use querry on access
what is metadata
what are Trojan horses

• instructor
• select Instructor ID
• Instructor name
• title
• from
• instructor
• where
• instructor ID
• select: Instructor ID, instructor name
• from instructor
• where: Instructor name "ganesan"
• select instructor ID, Instructor Name
• from instructor
• where instructor ID is greater than 1 an title = prof

• business IT environment
• data models
• extract, transform and load data
• data warehouse
• data marks
• data analytics
• data mining
• big data analytics 
• structure data - can put into neat fields
• unstructured data - analyze the data, the data that you collect from social media
• text mining
• some enterprise terms
• enterprise computing
• internet devices
• network devices
• internet of things
• these will all be connected
•   

• cloud computing - the practice of using a network of remote servers hosted on the internet to store, manage, and process data, rather than a local server or a personal computer
• cloud models
• on premises
• application
• data
• runtime
• middleware
• O/S
• virtualization
• servers
• storage
• networking
• infrastructure
• platform
• Microsoft azure
• Microsoft azure is an OS for the data center
• handles resource management, provisioning, and monitoring
• manages application lifecycle
• allows developers to concentrate on business logic
• features of windows azure virtual machines
• support for key server applications and workloads easy storage manageability
• features of windows azure
• virtual machines
• support for key server applications and workloads
• easy storage manageability
• high availability features
• 
  

• meta data - is the data bout the structure of your database
• pc bas is access
• Microsoft is oracale database
• relational database
• the entity-relationship
• entities (objects)
• students,classes etc.
• Relationships
• enrollment (student to classes)
• types of relationships
• 1 to 1
• 1to many
• many to many

what to know on the exam

• components of the system
• what does the ALU do
• know the components of the machine cycle
• components of the mother board
• operating systems on tablets
• unix operating system
• most powerful processor
• how to run multiple operating systems on apple
• different memories
• ddr 1 ddr2
• what is a bios
• what is a front side bus
• computer speed
• proccesors in smartphones
• coding systems
• how many bytes in a kilobyte
• what is esata
• what is a solid state drive
• what is papa
• sapa
• wind share devices
• speed of the processor
• number of cores
• optical care recognition
• examples of biometric devices
• what are some properties of a display
• how do you define color depth
• what is the different between inkject and laser
• digital cameras - what to look for
• consumer oriented video conferencing services 
• video conferencing services should have voice and face tracking
• what can you do with a multi function printer
• what are the different file formats
• what is network attach storage
• what is meant by mapping a drive
• what is a storage are network
• what is the definition of a workbook
• how do you toggle between values and formulas
• how do you reference a cell  value
• goal c
• how can you define document properties
• can cells be merged and centered
• what is flashville
• how to formati numbers in currency, accounting format
• what is floating format

• basic components
• sender
• receiver
• cabel modem connects to a computer with an rj-45 link
• there is also a thick coaxial cable
• there is multiple channels in one link
• you might be browsing or downloadingg but they are in 2 different sessions
• computer
• GET https://
• secure connection - VPN
• miracast secures wi di
• wi fi security is
• SSID - broadcast or don't broadcast
• the collaboration tool is called sharepoint
• office 365
• office
• onedrive
• share point
• office 365 as a collaboration platform
• LAN is a local area network which a network of computers
• you will connect a cable router to a wireless access point
• SC connects with a switch to a router
• P2P  LAN- all client
• client server LAN is computers connected together connecting clients and servers
• internet peer to peer networks
• internet may also host a client server network
• video conferencing 
• web ex
• adobe connect
• go to meeting
• zoom
• Skype for business
• consumer level conferencing
• Skype 
• zoom
• facetime
• oovoo
• google hangout
• facebook live
• client server network
• how to connect computers together
• star network
• ring network
• bus network   
• networking
• TCP/IP is the lifeline of your network
• Ethernet
• token ring
• Wi-Fi
• Bluetooth
• uwb
• IrDA
• RFID
• Wi MAX
• NFC
• connctions to the internet
• ISDN
• DSL
• Cable
• FTTP
• FTTH
• T1
• T3
• ATM
• OC3
• you have your home connected to the internet with a cable and fios and fiber
• organization this connects to the internet with OC# and ATM
• these are high speed connections
• ATM is the fastest connection to the internet
• file transfer program
• filezilla is an ftp client program
• you will have the router and the access point
• acces point is a
• switch
• firewall
• wireless router
• DHCP server
• RJ 45 port connects with an RJ 45 cable
• Ethernet is wired
• you have different types the best is fiber optics cables
• it sends more information and its faster
• 2 types of transmittion
• directional which is known as unidirectional
• the other is omnidirectional
• frequency spectrum
• band width is the frequency range for communication
• measured in mbps and gbps
• 1gbps
• Ethernet
• twist pair network
• broad band - high speed - multiple channels
• broadband - single channel

• device manager
• update driver
• disk management  it will show you the disk
• system
• system
• system creates patricians to restore
• 100gb - windows 10 - drive d  
• 100gb - windows 2010r2 - drive c
• data
• ntfs
• FAT32 - insecure, mostly on flash drives
• after you format you get a new logical drive which is the F drive
• viruses affect patricians where the programs are
• you can re install your applications and still have the data
• Internet Options - many times its done automatically
• security ( 3 zones)
• internet
• local ( intranet) - organizations network  
• trusted sites - you will have access to those sites
• restricted sites - those sites can't communicate with you  

Operating Systems

• software 
• System - Makes computer work 
• OS utilities 
• Application  - Extras ( word, excel etc.)
• Immediate application  - GET
• Application development  - Microsoft access
• Tools 
• major database 
• windows  ( Microsoft 365)
• unix ( linux, AIX, Solaris, android) 
• OS types 
• windows 10, windows 8.1
• windows 10 ( homes, education, professional, enterprise) 
• physical computer 
• virtual server 
• unix 
• open source version available 
• linux 
• android 
• virtual machines 
• virtual box 
• virtual PC 
• dual boot 
• multiple positions to run multiple windows operating systems, for example
• bootcamp
• usage share of operating systems 
• booting the operating system 
• cold boot 
• warm boot ( ctrl, alt, delete) 
• interacting with the computer 
• GUI 
• command prompt 
• to get to the command prompt search cmd  
• get ssd
• memory managment 
• contact tasks 
• buffering and pooling 
• computer  to printer 
• can have multiple printing jobs 
• if you cant stop printing it is in the printers memory 
• device configuration 
• plug and play ( put something in it automatically works) 
• Hot-plugging (there are computers if one supply goes wrong it can be taken away without turning off the computer) 
• windows update 
• automatic update of windows 
• installing a service pack 
• exploring current version 
• network operating system  
• particians 
• windows  10 
• data 
• windows 2012 server 
• server operating systems 
• mainfram operating systems 
• supercomputers 
• administration security 
• administrator 
• user 
• creating and managing users 
• password 
• changing passwords 
• your username is everywhere with Microsoft cloud
• you can give the user different privileges by going to properties
• you should create a fall black account with administrator privileges
• tablet operating systems 
• android versions 
• latest version is nuget 
• windows 10 versions 
• 32 bit 
• 64 bit 
• bellr
• windows 10 pro 
•   

• network storages
• network attached storage
• home and enterprise networks
• connect wing using different credentials
• my cloud
• when a computer is working very well make a restore point then make an image of patrician 1
• restore computer must be working
• re image computer need not boot
• SAN - storage area network
• fiber channel
• storage capacities
• k,m,g,t,p,e,z an y bytes
• windows
• FAT 32 NTFS
• Apple
• HFS+ -  hierarchical File system
•  defragmentation
• error checking
• this will check for errors and fix the errors
• hard disk - re drive head
• basic disk operation
• reading head
• bites per second through put
• disk management tools
• disk partition
• a hard disk can be partitioned for each partition to behave like a logical drive
• different operating systems can be installed on different partitions
• dual boot system
• hdd and ssd
• ssd
• hybrid drives
• sshd
• contains both ssd and a hdd
• raid storage
• redundant array of inexpensive
• NAS connects directly
• external removable drives
• usb drives and enclosures
• usb 2.0 and 3.0 
• desktops
• PATA: older technology
• USB3.0
• speed
• usb high capacity
• usb 3.0 speed comparisons
• copy 300 4mb pictures/songs
• 12 gb 1080HD movie
•  note on encryption
• tapes
• DVD
• DVD+
• cloud storage
• one drive
• google drive
• I cloud
• drop box
• sugar synch
• folder synchronization
• enterprise storage
• storage area network
• fiber channel - network of storage devices
• storage area network
• fiber channel
• tape drive
• DVD
• SSD
• SAS HDD
• Network of storage
• http://www.wdc.com/en/
• http://www.wdc.com/en/products/external/desktop/
• http://www.wdc.com/en/products/internal/desktop/
• http://www.wdc.com/en/products/products.aspx?id=1140
• http://www.wdc.com/wdproducts/library/?id=439&type=20&cn=4879-705142
• http://products.wdc.com/library/QIG/global/4879-705142.pdf
• 

 

 

 

 



 

• Input devices
• keyboard
• mouse
• pen
• tablets and touch screens
• a note on mouse
• wired - usb connection 
• wireless - usb connection 
• Bluetooth- doesn't take up a usb port
• optical and laser
• inpute devices
• video/web conferencing
• consumer based - Skype, facetime 
• commercial - web ex, go to meeting, zoom, adobe connect
• zoom - video conferencing
• snapchat
• team viewer - screen sharing
• webcams
• instillation - using drivers
• usb device installation rule
• always install the drivers ( software) first  and then connect and configure the device ex: webcam
• install drivers for complete features
• internet audio and video formats
• image: raw file format, compressed file format
• raw file : bmp
• compressed: jpg or gif
• audio: raw, compressed
• raw: wav : 44100 khz 
• when record set the sampling frequency then the sampling depth, then the channels
• compressed file: mp4
• ipad: compressed file  
• web: streaming file
• ipad and web run on mp4
• html 4
• html 5 - doesn't need flash
• scanner
• Images - cant edit the document  
• OCR - an editable word document
• switch - network printer
• mfp- multifunction printer - scans, fax, copy - prints
• software OCR
• biometric input - fingerprint, facial features, Iris, handwriting
• more printers
• network printer uses an IP address - all computers can print with this
• 4 different types of printers
• free software at adobe creative cloud
• inkjet - color, cheap initial price - long term expensive
• laser - initially expensive, long - term cheaper
• LCD-LED technology
• resolution
• refresh rate - response time
• color depth
• Dot pitch
• Contrast ration
• Brightness ( nit)
• Replace older CRT monitors  
• port connection _ display, dvi port, hdmi port, VGA,
• wi di - projecting the screen from a tablet by wireless communication onto a projector
• intel's technology 
• both the laptop and the projector must support widi
• other wireless screen projection
• USB based wireless projection - diamond
• streaming from the screen
• cloud printing 
•  printing on a printer over the internet
• university printing at CSULA
• email document to printer
• HP laser jet
• printer characteristics
• printing speed
• printing speed
• printer drivers
• checking for driver errors
• device manager
• an exclamation mark against a printer on the device manager would indicate that the printer may not be fully functional  
• virtual printers
• virtual pdf printers
• directing printer output to pdf,xml, and snagit printer  

System Components

• module contents
• describe the system units
• motherboard components
• processor
• memory
• expansion slots and cards
• Components of the system unit
• motherboard
• processor
• memory
• hard disk
• expansion bus - video cards
• minimum power is 500 watts
• ddr 2   
• ddr 3
• ddr 4
• things in the system unit
• motherboard mad of a processor,memory, ports, chip set,
• storage - hard drive, HDD, SSD
• power supply - 500 watts  
• other storage - DVD
• should have an I5 processor
• 8 gb of memory
• The motherboard - processor socket , expansion slots
• chip set
• drivers are essential
• DCI expansion slot: 32 bit or 64 bit
• System unit : SATA, DATA
• BIOS setup : a program code stored in your computer
• Only reason to update BIOS is to change the boot order of your drives
• NBT your whole operating stick can be operated on a stick
• Processor
• Intel
• Pentium Dual core
• Pentium Quad core
• i3,i5,i7 
• Atom
• AMD
• Nvidia
• ARM
• Qualcomm
• Motorola
• speed in Gb
• don't be carried away with speed
• to compare computers use the bench mark test
• cache capacity - very high speed capacity - L1, L2, L3
• threads - number of things it can do in power
• get more slots because you can always upgrade your memory
• HDD technology - moving parts
• SSD- no moving parts
• SATA -
• PATA -
• Graphics Card - AMD Radeon
• Processor Components - ALU, Registers, Control Unit , Cache
• CPU and Components 
• Front Side bus
• center of your computer is the memory
• processor
• input
• output
• permanent storage or hard drive
• Processor Specs
• Front side bus
•  bus width
• popular processor - Intel, AMD, Apple, IBM
• Intel - Windows
• use Unicode now
• memory functional types - volatile or nonvolatile

2 kinds of address

Latest IPV

IPV address

Gateway address IP Adress : IPV, IPV6, Domain, Mac Adress, Gateway
private and public
Microsoft sway
web 1.0- download, web2.0- upload and download
wifi is location based
wi max is 3g or 4g
business internet ramps - T1 and T3
Internet service provider - AOL
fully qualified domain name
calstatela.edu
Nanda
nanda.calstatela.com77

2 kinds of address

Latest IPV

IPV address

Gateway address IP Adress : IPV, IPV6, Domain, Mac Adress, Gateway
private and public
Microsoft sway
web 1.0- download, web2.0- upload and download
wifi is location based
wi max is 3g or 4g
business internet ramps - T1 and T3
Internet service provider - AOL
fully qualified domain name
calstatela.edu
Nanda
nanda.calstatela.com77

System Components

• module contents
• describe the system units
• motherboard components
• processor
• memory
• expansion slots and cards
• Components of the system unit
• motherboard
• processor
• memory
• hard disk
• expansion bus - video cards
• minimum power is 500 watts
• ddr 2   
• ddr 3
• ddr 4
• things in the system unit
• motherboard mad of a processor,memory, ports, chip set,
• storage - hard drive, HDD, SSD
• power supply - 500 watts  
• other storage - DVD
• should have an I5 processor
• 8 gb of memory
• The motherboard - processor socket , expansion slots
• chip set
• drivers are essential
• DCI expansion slot: 32 bit or 64 bit
• System unit : SATA, DATA
• BIOS setup : a program code stored in your computer
• Only reason to update BIOS is to change the boot order of your drives
• NBT your whole operating stick can be operated on a stick
• Processor
• Intel
• Pentium Dual core
• Pentium Quad core
• i3,i5,i7 
• Atom
• AMD
• Nvidia
• ARM
• Qualcomm
• Motorola
• speed in Gb
• don't be carried away with speed
• to compare computers use the bench mark test
• cache capacity - very high speed capacity - L1, L2, L3
• threads - number of things it can do in power

• symptoms of a virus
• OS running slow, stops intermitermittently or does not start
• less memory available
• corrupt files and programs
• programs do not operate properly
• unknown programs are activated
• mapping
• email attachments macros must be disabled
• clicking on websites
• flash drives
• cable router
• wireless router
• linxus
• netgear
•  tp link
• d link
• wireless access point
• is a switch
• is a firewall
• dstcp server
• software firewall - windows firewall
• antivirus
• malware protection
• security settings
• windows update
• security setting in internet explorer
• good practice
• email script and attachments
• document macros
• UAC is activated
• digital signature
• digital certificate
•  no more service packs its automatically done with windows updates
• Back - up
• forget password - boot disk using a usb drive
• image of your hard disk
• hardware firewalls
• used for blocking access to ports on computers behind a firewall
• hides the IP address behind a private IP address
• hardware firewall brands
• wireless routers from the following brands have built-in firewalls
• software firewall
• blocks access to ports on individual computers
• examples
• windows firewall
• access point
• two sides
• public side
• private side
• public IP - people can identify the IP
• forced execution
• some website would force the execution of scripts
• cookies
• cookies are stored on computers by websites
• Information stored in cookies are accessed by the website each time the site is visited
• cookies can be and possibly should be removed as soon as possible, if not, periodically
• types of cookies
• authentication cookies
• cookies store by websites
• third party tracking cookies
• Firefox examples
• Types of attacks
• botnets
• denial of service
• back doors
• spoofing - impersonating a website
• spamming
• firewalls
• hardwar firewalls
• Linksys firewall
• dlink wbr 1310
• spftware firewalls
• windows firewall example
• Authorizing Access
• password
• access auditing
• possessed object
• PINs
• biometric devices
• authentication
• one factor
• two factor
• three factor
• four factor
• IOT - Internet of things
• A digital signature is an encrypted code that a person, website, or organization attaches an electronic verification  
• Bit Locker - encryption of your hard drive
• you can also encrypt data on your flash drive - trucrypt
• If C drive is too full the system will slow down
• Veracrypt can be used to encrypt part of a drive
• when encrypted you will have 2 drives
• an e drive
• and an f drive