BTT1O Grade 9 Business Technologies Exam

Hardware

  • Any physical part of a computer
  • Can be internal or external
  • Examples of internal – Bus, RAM, ROM, CPU, Power Supply, Hard Drive, etc.
  • Examples of external – Monitor, Speaker, Keyboard, Mouse, etc.

Software

  • Any non physical part of a computer
  • A set of electronic instructions that tell the computer what to do
  • There are various types such as application, utility, anti-virus
  • Examples – Anti-Virus Software, MS Word, etc.

Input

  • Information/devices that are put into the computer
  • Examples: Keyboard, Microphone, Mouse

Processing

  • The computer processes the input

Output

  • The computer outputs the processed input
  • Examples: Monitor, Speaker, Printer

Storage

  • The computer stores information in it
  • Example: Floppy Disks, CD-ROMs, DVDs, USBs

Ports

  • Parallel ports have 25 holes and connects a computer to a printer
  • Monitor ports connect monitors to the computer.
  • Serial ports connect modems and mousse
  • Keyboard ports connect keyboards
  • USB ports connect USB devices and other hardware.

RAM

  • Stands for Random-Access-Memory
  • Working memory, much quicker to access than ROM

ROM

  • Stands for Read-Only-Memory
  • Stored memory that cannot be altered

How Computers Work

  • They use a language called Binary Code
  • Each input into the computer is changed into binary code where a binary digit is one number
  • Combinations of bits create different results
  • 8 bits = 1 byte

Comuter Memory

  • 1024 (but more commonly 1000) bytes = 1 KB
  • 1000 KB = 1 MB
  • 1000 MB = 1 GB
  • Data can be letters, numbers, sound, or images

Peripherals

  • Devices that are not interior of the computer and can be used for input or output

Computer Types

  • Handheld, PDA, Tablet, Laptop/Notebook, Desktop, Tower, Workstation
  • Supercomputers handle massive calculations ordinary computers wouldn’t be able to handle
  • The leading creator of supercomputers is IBM
  • The first supercomputer was introduced in 1976

Security Threats and Viruses

  • A program made to harm computers
  • Different types – Stealth, Worm, Trojan, Armoured
  • The I Love You virus was a virus that was attached to an e-mail. Once activated, it then spread itself to everyone on the infected computer’s e-mail list
  • Firewalls protect computers from threats and hackers. It only allows certain information to enter or leave the computer
  • Data encryption makes data a code, and can only be decrypted by a designated computer

Word Processing

Word Wrap

  • MS Word allows users to continually type without having to hard return by using word wrap

Show/Hide Codes

  • In the standard toolbar represented by this symbol ¶
  • Shows hard returns and spaces
  • Hard returns are represented by this symbol ¶
  • Spaces are represented by this symbol •

Home/End Keys

  • Home key goes to the beginning of the line
  • CTRL + Home goes to the first character of the document
  • End key goes to the end of the line
  • CTRL + End goes to the last character of the document

Line Spacing

  • Spacing can be changed in the toolbar, go to Format, Paragraph, then change the line spacing and press ok

Parts of a Business Letter

  • Letterhead – The top of the document that usually includes company name, address, phone number, and any other similar information
  • Date – The date the business letter was created
  • Inside Address – The information of the receiver. Includes name, address, postal code, and anything else
  • Salutation – Opening of the letter. Example: Dear Brendan,
  • Body – The bulk of the letter that includes the details of the letter
  • Complimentary Closing – The end of the letter. Example: Yours truly,
  • Signature lines – Usually 4-6 lines that allow the sender to sign the paper.

Proofreading

  • Various methods
  • Comparison is checking the proofread piece against the original
  • Ruler is using a straight edge or ruler to keep your eye in a straight line
  • Buddy is saying the proofread piece aloud
  • Terminal is using your finger/hand to guide your reading. This method is for word processing or computer screens

Informal Reports

  • Informal give information about facts or information

Formal Reports

  • Formal give information about a study or particular topic

One Page Reports

  • Only one page, and may contain a title page depending on the requirements
  • If a title page is required, the authors name should appear under the title on the title page

Multi Page Reports

  • More than one page
  • Should consist of:
  1. Title Page
  2. Table of Contents (if the report is long)
  3. Body of Report
  4. Bibliography

Report Formatting

  • Title: Usually on line 13, centre and capitalize all letters
  • Spacing: Body is usually double spaced
  • Paragraphs: Use regular paragraphing and press tab at the beginning of every paragraph
  • Page Numbering: No number on the first page, number each page consecutively, usually at the top right corner of the page

Careers of Computing

  • Data Entry Operator: Their job is to type data into computers. They usually work for banks, or entering inventory. They must be able to type quickly and accurately. They must also be able to detect small details to find errors.
  • Computer Operator/Technician: They are responsible for setting up computer equipment. They must have a good understanding of computers, be able to understand technical manuals, detect computer errors, and have good social skills to help people with problems.
  • System Analyst: Their job is to design computers to accommodate with companies. They change the settings of the computer by determining how it will store data, and whether or not the computer will be useful in the future. They must have a good understanding of what they are asked, a good knowledge of data processing methods, a good understanding in programming languages and software, and the ability to work well with others.
  • System Programmer: Their job is to install software the system analyst determined would be best. They must have knowledge of software and programming languages, a good understanding of what they are being asked, detail to the smallest errors, problem solving techniques, patience, and great computer knowledge.
  • IT Manager: Their job is to run the Management Information Systems department. They must have a good idea of the company’s goals, good social skills, and a good understanding of computers.
  • Computer Scientist: Their job is to research new computer software and hardware. They must have a sense of curiosity, good mathematic and science skills, and incredible patience.
  • Computer Engineer: Their job is to design and create computers. They must be able to work with others, have an understanding of science and mathematics, and a passion for computers.

Memos

  • Memo is short for memorandum
  • They are short to let people know of a certain problem or issue
  • Templates are usually used to create the memo

Spreadsheets

What is a Spreadsheet?

  • An application software
  • Works mainly with functions
  • Organizes information into rows and columns
  • Able to perform calculations with the data inputted
  • Columns are identified by letters while rows are identified by numbers
  • Cells are where the columns and rows meet
  • Cells are identified by the number and letter of the row and column
  • The cell that is selected is also known as the active cell.
  • Various types of data can be inputted into cells
  1. Labels – Text information
  2. Values – Numerical information
  3. Formulas – Instructions

Entering Data

  • To move from one cell to the right, press TAB
  • To move from one cell down, press ENTER
  • Label values are automatically left aligned
  • Numerical values are automatically right aligned

Formulas and Functions

  • Every formula must begin with =
  • The spreadsheet automatically does BEDMAS (order of operations)
  • The formula bar is used to change the formulas and values in the cell
  • You also have the option of using auto sum or other formulas to apply the formula quickly

Pivot Tables and Charts

  • Charts can be accessed by going to the chart wizard button
  • Follow the steps and create the chart
  • Pivot tables can be accessed by going to data – Pivot Table
  • Follow the on-screen instructions and create the pivot table
  • Layout can be changed by going to Pivot Table options – Layout

Ergonomics

  • Carpal Tunnel Syndrome
    • A hand/wrist disorder that occurs when typing
  • The most common injury related to ergonomics
  • Musculoskeletal Injuries/Repetitive Strain Injuries
  • Ergonomic related injury that occurs when people perform the same tasks over and over again

Topology

  • The physical layout of wires which a network is created upon
  • 2 different types; bus and star

Business Letters

  • Full block letter – without indents in each paragraph
  • Semi-block letter – with indents in each paragraph
  • Carbon copy (CC) – a note letting the receiver known who else the letter was sent to

Resumes

  • Curriculum Vitae – a document summarizing academic achievements

Vocabulary

  • Wiki – a collection of data which is open for people to edit
  • E-Commerce – commercials appearing over the internet
  • Transmission Control Protocol/Internet Protocol (TCP-IP) – standard network protocols for communication across the net
  • Broadband – a type of internet connection with much more capacity than dial-up
  • Web Server – a designated computer that hosts an internet website
  • Phishing – a type of internet fraud where people try to get personal information
  • Downloading – the act of copying information from one computer to another
  • Uploading – the act of sending information from one computer to another
  • Switch – the device that allows nodes to connect to a network
  • Cookie – a web document that is created by websites that allows it to recognize certain computers when re-entering the website
  • Peripheral – computer hardware that is physically outside the computer. Examples: keyboards, mousse, speakers
  • Hypertext Markup Language (HTML) – the language of the internet
  • WAN (wide area network) – a network that has a larger area than LAN (local area network)

Commands

  • Control-C – Copy
  • Control-V – Paste
  • Control-S – Save
  • Control-Z – Undo
  • Control-X – Cut
  • IF Statements – In a cell, type =IF(logical test hereaction to be taken if the condition is trueaction to be taken if false) you can embed more IF statements into IF statements.