关键词 > FSPComputing&InformationSystems

FSP Computing & Information Systems

发布时间：2023-07-03

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

FSP Computing & Information Systems

TOPIC 1: COMPUTER BASICS

1. What are the advantages of saving your work on a network drive (such as the U: drive at the University of Adelaide College) rather than on to your C: drive (local drive).

2. In the filename, C:\CISF2\Word\written test.docx, list the following:

a) Extension: ______________________________________________________________________________

b) Path: ___________________________________________________________________________________

c) Application type: _________________________________________________________________________

3. You are going to send your teacher an email with a copy of your assignment. What are the 4 important parts of a business email that you would need to include? Provide an example for each one also.

One: _____________________________________________________________________________________

Two: _____________________________________________________________________________________

Three: ____________________________________________________________________________________

Four: _____________________________________________________________________________________

4. What are 2 differences between a folder and a file?

5. List 2 applications that we have studied in class.

6. Using the binary system, how many digits/numbers do we use? What are these numbers?

7. When using extended ASCII, how many bits are in a byte?__________________________________________

8. A byte is bigger than a bit? Is this a true or false statement? _________________________________________

9. George was asked by his teacher what is bigger, a megabyte or a gigabyte? What should his answer have been?

TOPIC 2: WORDPROCESSING USING MICROSOFT WORD

1. You open a document in Word and, next to the document name, are the words (read only). What does this mean? Can you change this document and save the changes?

CIRCLE THE CORRECT LETTER BELOW:

2. Which question below is one of the three settings that you might use for formatting a heading in order to make it clearly stand out in a document.

a) Bullets, borders and shading

b) Paragraph spacing, borders and shading

c) Text size, borders and shading

d) Table of contents, text size and centre alignment

3. What 3 examples of font changes can you make to text?

a) Paragraph spacing, line spacing and Font Type

b) Font style, Font size and Font Type

c) Bullets, Font Size and Font Style

d) Styles, Font Type and Font Size

4. What is one of the options that are available in Font Style?

a) Bold

b) Bullets

c) Paste

d) Cut

5. Which one of the answers below allows you to make your own colours and not use just the colours provided by Microsoft?

a) Standard colours

b) Custom colours

c) More colours

d) None of the above

6. Words that are spelled incorrectly in a document are shown by a:

a) Green wavy line

b) Underline

c) Red wavy line

d) Blue wavy line

7. Font sizes are measured in:

a) Bits

b) Pieces

c) Inches

d) Points

8. What is the effect of the superscript effect?

9. What is the difference between small caps and all caps?

10. Explain the difference between each of the text alignments below, how is your text positioned in the instances below?

Left alignment

___________________________________________________________________________________________________

Centre alignment

___________________________________________________________________________________________________

Right alignment

___________________________________________________________________________________________________

Fully justified

___________________________________________________________________________________________________

11. Explain what a margin is?

12. What is a “field” and give an example.

13. What are the line spacing options available?

14. What is the difference between the spacing before option and the line spacing option?

15. Where is a header placed on a document?

16. If you inserted a table and then wanted to create a total (add up) in the cell in the bottom right hand corner, what formula would you use?

17. If you wanted to make the two shaded cells at the bottom of the first column in bigger, what is that process called?

18. There are 4 main types of tabs in Word that we studied in class. What are they?

a) __________________________ c) _______________________________

b) __________________________ d) _______________________________

19. Explain the difference between a “page break” and a “section break” .

8. Label the different parts of the Word screen below.

a) _____________________________ i) ____________________________

b) _____________________________ j) ____________________________

c) _____________________________ k)____________________________

d) _____________________________ l) ____________________________

e) _____________________________ m) ___________________________

f) _____________________________ n)____________________________

g) _____________________________ o)____________________________

h) _____________________________ p)____________________________

TOPIC 3: PRESENTATION SOFTWARE USING MICROSOFT POWERPOINT

1. What is a slide transition?

2. What is “slide animation”?

3. What can we use Slide Master for when designing a presentation?

4. When creating a PowerPoint presentation, what are 5 features that you could use to make the presentation really effective?

1_________________________________________________________________________________________

2_________________________________________________________________________________________

3_________________________________________________________________________________________

4_________________________________________________________________________________________

5_________________________________________________________________________________________

5. When you are preparing your presentation, what can you use as a type of “back up” for your presentation, for example, what feature can you use in PowerPoint to help you remember what you are going to say?

TOPIC 4: SPREADSHEETS USING MICROSOFT EXCEL

1. What are the only three things that a cell can contain?

2. What is the difference between a worksheet and a workbook?

3. What are 3 uses of spreadsheets in the real world?

4. What are 3 good design rules that you should follow when constructing a spreadsheet?

5. What is the difference between an absolute address and a relative address?

6. When should you use an absolute address?

7. What values do the formulae in columns B and C display?

1 =INT(A5) __________________

2 =INT(A6) __________________

3 =INT(A8) __________________

4 =ROUND(A5,0) ____________________

5 =ROUND(A7,0)*100 ____________

6 =ROUND (A8,2) ____________________

8. What titles should you include in every Excel Chart?

1. __________________________________ 2. ____________________________

9. What is the “fill down” process?

10. When typing in the current date, why should you use the formula =TODAY() instead of just typing in the date, for

example, 19 November 2012? What effect does this have on a situation such as calculating a person’s age?

11. What is the difference between using COUNT and COUNTA? Provide a situation of each? Hint: think of the exercises completed in class.

12. When presenting a chart, what 3 titles should you ALWAYS show in a chart?

1. ______________________________________________________________________________________

2. ______________________________________________________________________________________

3. ______________________________________________________________________________________

TOPIC 5: COMPUTER COMPONENTS

1. List 3 input devices.

_________________________

2. List 3 output devices.

_________________________

3. Describe the difference between application software and operating system software.

4. What are 4 examples of Microsoft Office application software?

a) ________________________ c) _______________________________

b) ________________________ d) _______________________________

5. What is one function that the operating system performs. What is its purpose? Provide an example of an operating system?

6. What does RAM stand for? It is said to be volatile, what does this mean?

7. What is a utility program and how is it different from application software? Provide an example of a utility program.

8. A simple model of a computer system is like the one below:

a) How would it look if we changed it to the following , what is the equivalent:

b) Provide an explanation of each system activity, starting with input.

Input:

_______________________________________________________________________________________________

Process:

_______________________________________________________________________________________________

Information:

_______________________________________________________________________________________________

Storage:

_______________________________________________________________________________________________

9. What is a processor and what is it used for?

10. What is a byte? What does Mb stand for?

11. List 3 types of permanent storage devices.

1_________________________

2_________________________

3_________________________

12. Explain what “copyright” is with regards to computer software.

TOPIC 6: NETWORKS AND THE INTERNET

1. Define what a computer network is.

2. Describe 4 advantages of computer networking. 1_________________________________________________________________________________________

2_________________________________________________________________________________________

3_________________________________________________________________________________________

4_________________________________________________________________________________________

3. Explain the difference between a client server network and a peer-to-peer network.

4. Give an example of Local Area Network and a Wide Area Network.

5. Explain the purpose of a Network Operating System (NOS) .

6. What are the roles of a switch, modem and router in a network?

7. Explain the purpose of a network interface card in a computer.

8. Explain how a Uniform Resource Locator (URL) and a domain name differ.

9. What is a DNS server and why is it important?

10. Using theInternet, computers connect and communicate with one another, primarily using theTCP/IP (Transmission Control Protocol / Internet Protocol). Explain