Computer
Microsoft Word
Excel
Powerpoint and Publisher
Ethics and Dreamweaver
100
What is the difference between hardware and software? Give examples.
The difference between hardware and software is that hardware is the physical parts that make up your computer and software are the programs on your computer. Examples of hardware are a mouse or speakers. Examples of software are Microsoft Word or SIMS.
100
Name eight items of information that should appear on a business’ letter
Return address, date line, inside address, salutation, subject line, body, complementary closing, writer’s identification, identification initials, and copy notation.
100
What is spreadsheet software used for?
Spreadsheets are mostly used for math and helping you with your calculations. They are also great for making graphs.
100
How do you change the order in which overlapping images appear on the screen? (e.g. Move to Back)
To change the order in which overlapping images appear on the screen, right click on an image, then select move to front or move to back. Another way is to select the image, then select an option from Picture Tools- Format toolbar in the Arrange group that says send backward or send forward.
100
What is ergonomics?
Ergonomics is the study of how the physical health of workers is affected by their workplace. Ergonomics affects the speed at which employees work, worker’s health, and how often workers are absent.
200
What are storage devices? Give 2 examples of each of the 3 types of storage devices. Which one can overwrite new info and which one can’t? Rank them in order of storage capacity and speed.
Storage devices are used to place info in storage media. The computer uses info that is stored on the storage media to perform tasks. Type 1: Optical EX. DVD, CDROM Type 2: Solid State EX. USB, memory cards Type 3: Magnetic EX. Hard drive, floppy drive The ones that can overwrite new info are solid state and magnetic, and the one that can’t is optical. Storage capacity in high to low: magnetic, solid state, optical Speed in high to low: magnetic, solid state, optical
200
What is the difference between page break and section break?
The difference between page break and section break is that a page break will make a new page but will keep the same general formatting as the page above it, because they are in the same section. A section break can be on a new page or the same page but will have different text formatting.
200
What is a formula? Give and example of a formula using cell addresses. What Math symbol do you use?
Formulas are equations that perform calculations on values in your worksheet. You type this into a cell, example “=A2*A5”. The symbols that are used include: Multiply * Subtract - Exponent ^ Divide / Add +
200
What are Normal, Outline and Slide Sorter Views in Power Point? When is each of them used?
Normal view is viewing your presentation without animations and transitions. It is usually used while creating the presentation In Outline view, PowerPoint displays your presentation as an outline made up of the titles and main text from each slide. Each title appears on the left side of the pane that contains the Outline tab, along with a slide icon and slide number. Slide Sorter view is viewing all your slides as small images so it is easy to rearrange. It is used if you want to re-order your slides.
200
What are the requirements for office equipment – chairs, monitors, and desks?
Chairs • Height-thighs roughly parallel to floor • Recline slightly • Sit back in chair • Able to move around (spin, wheels) Monitors • Top of screen at eye level • Monitor tilted slightly upward • 45-60cm away from face • Cleaned often Desks • Have enough room around you • Have enough room under desk • Edges of desk should be round and smooth • Medium to light coloured surface to reduce glare
300
What is memory? What is difference between RAM and ROM?
Memory is the information and data stored on the computer. The difference between RAM and ROM is that RAM goes away when you turn the computer off, accepts new information, and is volatile. ROM is programmed by the manufacturer and can’t be overwritten without special software.
300
What is the difference between “save” and “save as”? When would you use each of these commands?
'Save As' allows you to choose save destination, and file name. As well as allows you to save the file again under a new name or location. 'Save' just saves your file to a certain destination, and file name that has already been selected.
300
What are 3 common errors and what do they mean? How is each of them shown on the screen?
If there is a #REF! refers to a cell that you deleted or pasted over. #NULL! Is an error that occurs when two or more cell references are separated incorrectly in a formula. For example if in a formula two numbers are separated by a space instead of a mathematical operator. #NUM! will appear in a cell if there is a problem with a number in a formula, or if a calculation value is too large or too small to display.
300
Name five rules/guidelines that should be followed when creating a PowerPoint presentation.
Five rules that should be followed when creating a PowerPoint presentation are: a) Limit number of effects (distracting) b) Keep a consistent, neutral background c) Ensure that the font colour contrasts with the background d) The 7/7 rule: maximum 7 bullets per page with about 7 words per bullet e) Limit sound effects
300
What are the elements of an ergonomic work environment?
Give specific recommendations for each element? (e.g. temperature) Elements of an ergonomic work environment are: Computer hardware • Monitor: (already explained) • Keyboard: elbow height, fingers land on home row at 90° angle • Mouse: close to keyboard, wrists stay in straight position, elbows move mouse, use a light grip Furniture • Chair: (already explained) • Desk: (already explained) • Coloring: medium to light coloured surface, matte finish Work environment • Temperature: 15°C-22°C • Air circulation: plenty of air circulation but no open windows (drafty)
400
What is a LAN, MAN and WAN network? What is the network in our school? In our board?
LAN stands for local area network and connects computers in a single room or building. WAN stands for wide area network and you can access this Internet from anywhere. Lastly MAN stands for Metropolitan Area Network that can reach across a metropolitan area or campus. The network in our school is LAN and our board uses MAN.
400
How is clip art placed in a word document? What are the commands that move it, crop it, resize it, and wrap the text around it?
Select insert in the top tabs and choice clip art. When you select the image a new tab appears on the top. There you can move it, crop it, resize it, and wrap the text around it.
400
What are the fast ways to copy a formula to many rows? List at least three. Which one is the most and least effective?
The three ways to copy a formula on the worksheet is to: a) Highlight the cells and from the Editing group click Fill and select Down (or press control D) b) Highlight the cell that contains the formula, right click the mouse and choose copy, highlight the cells you want to paste your formula, and click paste c) Highlight the cell that contains the formula, drag the mouse pointer on the small black square at the lower-right corner of the cell downwards to the cells you want to apply the formula to. This is called Fill Handle.
400
How do we connect textboxes in Publisher to continue the text flow from one box to the other?
To link one text box to another, first click the text box that you want to link from, and then click the Create Text Box Link tool. The cursor becomes a little pitcher. When you click the empty text box that you want to link to, any overflow text pours into the text box.
400
What is the purpose of Firewalls, Antivirus Programs and Backup Systems? How is each of them protecting our computers?
The purpose of a firewall is to prevent unauthorized Internet access to and from your computer. The purpose of antivirus programs is to look for and eradicate a wide spectrum of problems, such as viruses, Trojan horses, and worms. The purpose of a backup system is to have a copy of all things on your computer in case your computer gets damaged or everything is deleted or reset.
500
Deference between Peer-to-Peer and Client-Server Network
The difference between Peer-to-Peer and Client-Server is that with Peer-to-Peer each computer on the network is considered equal in terms of responsibilities and resource sharing. It also provides easy communication, easy maintenance, limited number of connections and poor security. With client-server there is a main server that manages the transfer of files, schedules print-jobs, manages logins and logouts, verifies passwords, and determines which users have rights to certain files. This allows multiple users to share simultaneously the same resources.
500
What do bullets and automatic numbering do?
Word's automatic numbering and bullet formatting allows you to easily create lists and points. So as you are continuing to different points Microsoft automatically includes the next number or bullet.
500
Describe what the AVERAGE, MIN, MAX and SUM functions do. Write a formula for each suing cells A1 – A5.
Average finds the average amount for a range of cells: =AVERAGE(A1:A5) MIN finds the smallest number in a range of cells: =MIN(A1:A5) MAX finds the largest number in a range of cells: =MAX(A1:A5) SUM finds the total for a range of cells: =SUM(A1:A5)
500
What are the objects can be found in the Design Gallery?
Objects that can be found in the Design gallery are accent boxes, accessory bar, advertisements, attention getters, barbells, borders, boxes, calendars, checkerboards, coupons, dots, linear accents, logos, marquees, mastheads, phone tear-off, picture captions, pull quotes, punctuation, reply forms, sidebars, and table of contents.
500
What is Dreamweaver? What do you include in a Web page?
Dreamweaver is a program that enables you to build HTML pages with links, text, images, and multimedia. You create Web Pages on your computer and then use Dreamweaver to transfer the finished files to a Web Server where others can view them on the Web. Some things you include in a Web page are text, tables, images, links, videos, etc.
M
e
n
u