Docstoc

Michigan Educational Technology Standards METS

Document Sample
Michigan Educational Technology Standards METS Powered By Docstoc
					                           Michigan 8th Grade Tech Lit Assessments
    Assessments are hyperlinked to table below. Click on the benchmark in the table to go
    directly to the assessment(s).

                     Michigan Educational Technology Standards (METS)
                                        6th to 8th Checklist
 Technology literacy is the ability to responsibly use appropriate technology to communicate,
  solve problems, and access, manage, integrate, evaluate, and create information to improve
 learning in all subject areas and to acquire lifelong knowledge and skills in the 21st century.
1. Basic Operations and Concepts.
    a. Students demonstrate a sound understanding of the nature and operation of technology
      systems.
        1.     Students understand that new technology tools can be developed to do what could not
        be done without the use of technology.
        2.     Students describe strategies for identifying, and preventing routine hardware and
        software problems that may occur during everyday technology use.
        3.     Students identify changes in hardware and software systems over time and discuss
        how these changes affected various groups (e.g., individual users, education, government,
        and businesses).
        4.     Students discuss common hardware and software difficulties and identify strategies
        for trouble-shooting and problem solving.

        5.    Students identify characteristics that suggest that the computer system hardware or
        software might need to be upgraded.
    b. Students are proficient in the use of technology.
        1.    Students use proper keyboarding posture, finger positions, and touch-typing
        techniques to improve accuracy, speed, and general efficiency in operating a computer.

       2.     Students use accurate technology terminology.

       3.     Students use a variety of technology tools (e.g., dictionary, thesaurus, grammar-
       checker, calculator) to maximize the accuracy of technology-produced products.
       4.     Students identify a variety of information storage devices (e.g., floppies, CDs, DVDs,
       flash drives, tapes) and provide a rationale for using a certain device for a specific purpose.
       5.     Students identify technology resources that assist with various consumer related
       activities (e.g., budgets, purchases, banking transactions, product descriptions).

       6.     Students can identify appropriate file formats for a variety of applications.

       7.    Students can use basic utility programs or built-in application functions to convert file
       formats.
       8. Students proofread and edit writing using appropriate resources (e.g., dictionary, spell
       check, grammar check, grammar references, writing references) and grade level appropriate
       checklists both individually and in groups.



                                                                                   Page 1 of 50
2. Social, ethical, and human issues.
    a. Students understand the ethical, cultural, and societal issues related to technology.

        1.  Students understand the potential risks and dangers associated with on-line
        communications.
        2.  Students identify security issues related to e-commerce.
        3.    Students describe possible consequences and costs related to unethical use of
        information and communication technologies.
        4.    Students discuss the societal impact of technology in the future.
    b. Students practice responsible use of technology systems, information, and software.

        1.    Students provide accurate citations when referencing information from outside
        sources in electronic reports.
        2.    Students discuss issues related to acceptable and responsible use of technology (e.g.,
        privacy, security, copyright, plagiarism, spam, viruses, file-sharing).
    c. Students develop positive attitudes toward technology uses that support lifelong
      learning, collaboration, personal pursuits, and productivity.

        1.    Students use technology to identify and explore various occupations or careers.

       2.     Students discuss uses of technology (present and future) to support personal pursuits
       and lifelong learning.
       3.     Students identify uses of technology to support communication with peers, family, or
       school personnel.
3. Technology productivity tools.
     a. Students use technology tools to enhance learning, increase productivity, and promote
     creativity.
         1. Students apply common software features (e.g., thesaurus, formulas, charts, graphics,
         sounds) to enhance communication and to support creativity.
        2. Students use a variety of resources, including the internet, to increase learning and
            productivity.
        3. Students explore basic applications that promote creativity (e.g., graphics, presentation,
            photo-editing, programming, video-editing).
       4. Students use available utilities for editing pictures, images, or charts.

    b. Students use productivity tools to collaborate in constructing technology-enhanced
        models, prepare publications, and produce other creative works.
       1. Students use collaborative tools to design, develop, and enhance materials, publications,
          or presentations.




                                                                                   Page 2 of 50
4. Technology communications tools
    a. Students use telecommunications to collaborate, publish, and interact with peers,
experts, and other audiences.
        1.     Students use a variety of telecommunication tools (e.g., e-mail, discussion groups,
        IM, chat rooms, blogs, video-conferences, web conferences) or other online resources to
        collaborate interactively with peers, experts, and other audiences.

    b. Students use a variety of media and formats to communicate information and ideas
        effectively to multiple audiences.
        1.     Students create a project (e.g., presentation, web page, newsletter, information
        brochure) using a variety of media and formats (e.g., graphs, charts, audio, graphics, video)
        to present content information to an audience.

5. Technology research tools
    a. Students use technology to locate, evaluate, and collect information from a variety of
    sources.
       1. Students use a variety of Web search engines to locate information.
       2. Students evaluate information from various online resources for accuracy, bias,
           appropriateness, and comprehensiveness.
       3. Students can identify types of internet sites based on their domain names (e.g., edu, com,
           org, gov, au).
    b. Students use technology tools to process data and report results.
       1. Students know how to create and populate a database.
       2. Students can perform queries on existing databases.
       3. Students know how to create and modify a simple database report.
    c. Students evaluate and select new information resources and technological innovations
        based on the appropriateness to specific tasks.
        1. Students evaluate new technology tools and resources and determine the most
            appropriate tool to use for accomplishing a specific task.
6. Technology problem-solving and decision-making tools
    a. Students use technology resources for solving problems and making informed decisions.
       1. Students use database or spreadsheet information to make predictions, develop strategies,
       and evaluate decisions to assist them with solving a basic problem.
    b. Students employ technology in the development of strategies for solving problems in the
    real world.
       1. Students describe the information and communication technology tools to use for
          collecting information from different sources, analyze their findings, and draw
          conclusions for addressing real-world problems.




                                                                                  Page 3 of 50
1. BASIC OPERATION AND CONCEPTS
      a: Students demonstrate a sound understanding of the nature and operation
      of technology systems.

1.a.1 Students understand that new technology tools can be developed to do what
could not be done without the use of technology.

1) Which of the following would be the best way to add a long column of numbers?
   a) Fingers and toes
   b) Paper and pencil
   c) Abacus
   d) Calculator
2) There will be new technology tools developed in the future.
   a) True
   b) False
3) Which of the following does not need technology to complete?
   a) Creating a web page about your favorite movie
   b) Carrying around 10,000 songs in your pocket
   c) Editing and revising a research paper with word processor
   d) Reading a book
4)       Which is the best reason to use on-line resources?
   a. Better charts
   b.Easier to understand tables
   c. More current information
   d.More legible diagrams
5)       Which of the following was made possible by computers?
      a.        Brain scans
      b.        Vaccines
      c.        Bandaging a wound
      d.        Heart surgery
6)       Match the following scenarios with the new technology you would use:
      ___ Your car breaks down and you need to contact help.
      ___ You want to purchase the latest music the day it is released.
      ___ At the school dance you want to tell if your friend had their eyes closed in the
      picture.
      ___ You need a current event article for class assignment.

         A Download mp3
         B Cell Phone
         C Internet Resource
         D Digital Camera
Correct answer: B, A, D, C




                                                                               Page 4 of 50
7) Match the same scenarios with the old technology you would have used in the past:

    ___ Your car breaks down and you need to contact help.
    ___ You want to purchase the latest music the day it is released.
    ___ At the school dance you want to tell if your friend had their eyes closed in the
picture.
    ___ You need a current event article for class assignment.

   A   Newspaper or magazine
   B   Wait for prints from photo store
   C   Walk to a pay phone
   D   Go to the music store

Correct answer: C, D, B, A

1.a.2 Students describe strategies for identifying and preventing routine hardware
and software problems that may occur during everyday technology use.

1) Which of the following will not prevent software problems?
   a) Anti-virus software
   b) Cleaning your computer screen
   c) Security software—firewalls
   d) Defragmenting your hard drive
2) The first thing to check if your computer is NOT working is the power source.
   a) True
   b) False
3) Which of the following would help prevent hardware problems?
   a) Reloading your software annually
   b) Periodically cleaning the dust out of the CPU
   c) Upgrading your anti-virus software
   d) Changing the screen saver
4) If only some of the pages of your document print, what should you check first?
   a) Toner supply
   b) Paper supply
   c) Power source
   d) Printer selection
5) What things could you try if your cursor does not move?
   a) Restart the computer
   b) Check the mouse connection
   c) Replace the mouse
   d) All of the above
6) Which piece of hardware can be used to connect the Internet?
   a) Hard drive
   b) Modem
   c) Mouse
   d) Keyboard


                                                                               Page 5 of 50
7) Identify a possible problem with one of the following hardware devices. Describe
how you would prevent this problem from occurring again.

   CPU
   Monitor
   Login screen
   Keyboard
   Mouse
   Printer
   Diskette
   Flash Drive
   CD-ROM
   Scanner
   NOTE: Schools may choose to edit the list of hardware devices used in this test item
   and the number of problems students must address.

8) Describe a problem that you have had (or could have) with one of the following
hardware devices and explain the steps you or your teacher took (or could take) to fix the
problem. How could you prevent this problem from happening again?
    CPU
    Monitor
    Login screen
    Keyboard
    Mouse
    Printer
    Diskette
    Flash Drive
    CD-ROM
    Scanner
    NOTE: Schools may choose to edit the list of hardware devices used in this test item
    and the number of problems students must address.

9) You send a print job to the printer and nothing comes out of the printer. Describe one
reason that this might happen and how you/your teacher might fix it. How could you
prevent this problem from happening in the future?

Sample answers:
    Paper jam – clear jam; store paper appropriately; clean printer rollers; do not
      overfill paper trays; keep objects off of printer
    Out of paper – add paper; check paper trays
    Offline – press online/reset button and/or check network cable and/or check
      network card/interface for connection and blinking light; check printers before
      you begin
    Out of ink/toner – add more ink/toner; check printers before you begin




                                                                              Page 6 of 50
10) How should you store your floppy disk?
    a) In your backpack next to your water bottle
    b) In your desk
    c) In your gym bag
    d) In a protective case
11) Is it okay to drink water or pop near your computer?
    a) True
    b) False
12) The way to prevent a computer virus from infecting your home computer is to
    a) Download software from any site
    b) Open an e-mail attachment
    c) Scan your computer frequently using a virus checker
    d) Backup your data weekly
13) Your computer does not turn on, what do you NOT do first?
    a) Check network cable
    b) Call your teacher
    c) Listen to computer
    d) Check the power cable

1.a.3
Students identify changes in hardware and software systems over time and discuss
how these changes affected various groups (e.g., individual users, education,
government, and businesses.)
 1) Cost is a major reason schools and businesses do not upgrade to newer software.
    a) True
    b) False
 2) Which of the following software applications should be updated on a regular basis?
    a) Anti-virus
    b) Media player
    c) Word processing
    d) Firewall

questions continued on next page




                                                                           Page 7 of 50
                                                                     Note: This question
                                                                     is in jpeg file format.
                                                                     See below for Word
                                                                     format.

                                                                     Correct Answers:
                                                                        1. c
                                                                        2. a
                                                                        3. d
                                                                        4. e
                                                                        5. b




3) Match the following storage devices to their name.



1. ____
                                            a. Internal Hard Drive

2. ____                                     b. Flash Drive

                                            c. 5” Floppy Disk

                                            d. CD/DVD
3. ____
                                            e. 3 ½” Floppy Disk



4. ____



5. ____


Correct Answers: 1. c, 2. a, 3. d, 4. e, 5. b



                                                                               Page 8 of 50
1.a.4
Students discuss common hardware and software difficulties and identify strategies
for trouble-shooting and problem solving.
1) To protect your data or documents in the case of power outage you should.
    a) Save frequently
    b) Back up your hard drive
    c) Perform regular computer maintenance
    d) All of the above
2) If movie clips will not play on your computer, you will likely need to install
    a) QuickTime or Windows Media Player
    b) Anti-virus and firewall software
    c) PhotoShop
    d) Windows XP
3) Discuss common hardware and software difficulties and identify strategies for trouble-
shooting and problem solving.
    CPU
    Monitor
    Login screen
    Keyboard
    Mouse
    Printer
    Diskette
    Flash Drive
    CD-ROM
    Scanner
NOTE: Schools may choose to edit the list of hardware devices used in this test item and
the number of problems students must address.

4) You are trying to login to a computer. You enter your user ID and password but are
not able to login. Describe two possible troubleshooting strategies.
[Sample answers: retyping more slowly, checking the Caps Lock, checking to see if the
network wire is plugged in, checking to see if there is a light on the network card,
rechecking their password/ID, etc.]

5) You want to take a file home to work on. You have attached your flash drive and you
can’t save to this device. Discuss one troubleshooting strategy that you might try.
[Sample answers: Check connection (e.g. fully plugged in, check for light, etc.), open My
Computer and refresh, etc.]

 6) You sit down at a computer and you can’t move your cursor with your mouse. Discuss
one troubleshooting strategy that you might try.
[Sample answers: Check connection (e.g. fully plugged in, check for light on optical
mouse, check for mouse ball, etc.)]




                                                                             Page 9 of 50
7) You sit down at a computer and your screen is black. Discuss one troubleshooting
strategy that you might try.
[Sample answers: Check for power light, check plugs (power and/or video), move mouse
to check for sleep status, etc.]

8) You send a print job to the printer and nothing comes out of the printer. Describe one
reason that this might happen.
[Sample answers: paper jam, out of paper, offline, out of ink/toner, etc.]

9) You are word processing and the program freezes so that you cannot type. Discuss
one troubleshooting strategy that you might try.
[Sample answers: Force quit/close and restart application, etc. ]

1.a.5
Students identify characteristics that suggest that the computer system hardware or
software might need to be upgraded.
  1) What is the most likely reason your computer might be running very slowly or
frequently?
     a) Not enough RAM
     b) Not enough electricity
     c) Not enough software
     d) None of the above
  2) If you want to save information from your computer and store it, which of the
following could be used?
     a) A floppy disk drive
     b) A CD burner
     c) a USB storage device
     d) Any of the above would work
 3) Before you purchase software you should check the minimum operating system
     requirements.
     a) True
     b) False
 4) Which of the following messages suggests that a computer system’s software needs to
     be upgraded?
     a) Your session has been
     b) Are you sure you want to quit?
     c) A newer version of the software is available
     d) Insufficient memory to open this application.




                                                                            Page 10 of 50
1. BASIC OPERATIONS AND CONCEPTS
      b Students are proficient in the use of technology.

1.b.1 Students use proper keyboarding posture, finger positions, and touch typing
techniques to improve accuracy, speed, and general efficiency in operating a computer.
1) Which key is used to indent text within a document? (NC)
   a) Ctrl
   b) Tab
   c) Space Bar
   d) Esc
2) If while typing a story you realize that you have left out an important paragraph, which
would be the most efficient thing to do?
   a) Place the cursor where you need the paragraph and insert the needed text
   b) Type the needed text at the end of the paper and use the “Move” command to place
    the paragraph at the proper location
   c) Place the cursor at the start of the story, type the needed the text, and use the
      “Move” command to place the paragraph at the proper location
   d) Type the needed text in a new document and use the “Copy” command to place the
      paragraph at the proper location
3) What would be the most efficient way to enter repeating choruses to a song that you
are typing into a word processor?
   a) Copy the chorus on a copy machine and the cut and paste it into his document
   b) Use the Copy and Paste command
   c) Highlight the text and change it to Bold
   d) Type the chorus four times
4) For correct keyboarding, what is the recommended placement of fingers on the home
row keys?
   a) Fingers of left hand on Q-W-E-R; fingers on right hand on U-I-O-P
   b) Fingers of left hand on A-S-E-F; fingers on right hand on J-K-O-P
   c) Fingers of left hand on A-S-D-F; fingers on right hand on J-K-L-;
   d) Fingers of left hand on A-S-D-F; fingers on right hand on J-I-O-P




                                                                             Page 11 of 50
             As the students perform each task, place a checkmark in the appropriate
 Yes     No
             box where proficiency is shown.
Does the student display correct body posture?
               Spine straight, against back of chair, leaning slightly forward from the waist.
               Centered in front of keyboard (body directly in front of "J" key).
               Sitting a comfortable distance from keyboard (a handspan is suggested).
               Feet on the floor (if possible), slightly apart for body balance.
Does the student display correct arm and hand position?
               Arms relaxed; elbows naturally close to body.
               Forearms nearly parallel with slope of keyboard.
               Fingers curved, tips of fingers resting lightly on keys.
               Hands close enough together to "lock" thumbs. Fingers upright, not leaning
              toward little fingers.
               Hands and wrists "quiet," - almost motionless.
               Wrists low, but palms of hands not resting on the keyboard.
Does the student display correct keystroke techniques?
               Beginning and ending all keystrokes at home row position.
               Keying each key with the correct finger.
               Keying the space bar with the thumb of the right hand.
              Shifting with the appropriate "little" finger.
              When shifting, when depressing shift key, when striking key, when releasing
             shift.
              Using the "little" finger of the right hand for the enter or return key.
              Keeping eyes on copy (text, screen, board, etc.) rather than the keyboard, once
             a key has been learned.
              When students forget the location of a previously learned key, are they
             encouraged to consult the text/wall chart/software keyboard illustration, rather
             than looking down at the actual keyboard.
Performance Checklist




                                                                               Page 12 of 50
1.b.2 Students use accurate technology terminology.
1) Printers and fax machines are examples of which of the following?
   a) Input devices
   b) Output devices
    c) Processing devices
    d) Storage devices
2) The Central Processing Unit (CPU) is an example of which of the following?
    a) Input devices
    b) Output devices
    c) Processing devices
    d) Storage devices
3) The keyboard and mouse are examples of which of the following?
    a) Input devices
    b) Output devices
    c) Processing devices
    d) Storage devices
4) CD’s, DVD’s, tapes, floppy disks, flash drives, and hard disks are all examples of
which of the following:
     a) Input devices
     b) Output devices
     c) Processing devices
     d) Storage devices
5) What computer component is labeled 5 on the diagram?



                                                           a. CD-ROM drive

                                                           b. CPU

                                                           c. external disk drive

                                                           d. printer




6) What command should be used to recall a document saved previously?
   a) Enter
   b) Copy
   c) Open
   d) Save



                                                                             Page 13 of 50
7)       Yesterday, Cassie wrote a story using her word processing program. Today, she
wants to print the story. What must she do before she can print the story? (NC)
     a) Open the story
     b) Check her handwritten copy
     c) Nothing, just print the story
     d) Save the story
8)       What general term describes the physical equipment of a computer system, such
as its screen, keyboard, and storage devices?
     a) Hardware
     b) Software
     c) Output
     d) Input
9)       What small, hand-held device is used to move the cursor to a specific location on
the screen?
     a) A keypad
     b) A mouse
     c) A frog
     d) A message pad
10)      Which of the following is used to indicate the location that you will enter text in
your word processing document?
     a) A cursor
     b) A scroll bar
     c) A light pen
     d) A magic marker
11)      Which of the following is not an example of computer hardware?
     a) Monitor
     b) Mouse
     c) Keyboard
     d) Database

12) Fill in the blanks in the statements below with terms from the following list.
   a. CPU
   b. Monitor
   c. RAM
   d. Login screen
   e. Presentation software
   f. Word processor
   g. Scanner
   h. Network
   i. Internet
   j. WiFi
   k. Hard drive

____1. A ______ is used to view computer output.
____2. ______ is what the computer uses for temporary storage.
____3. ______ is what the computer uses for permanent storage



                                                                               Page 14 of 50
____4. ______ is the ‘brains’ of the computer
____5. Microsoft PowerPoint is ______
____6. Microsoft Word is a ______
____7. Multiple computers connected so that they can share resources with each other is
        a ______
____8. The ______ asks for user name and password to provide authentication to the
        computer or network.
____9. _____ is used to access the Internet without wires.
____10. A device that converts visual data to digital data is a _______
____11. The connection of computers throughout the world is the ______.

Correct answers:
          1. b. Monitor
          2. c. RAM
          3. k. Hard drive
          4. a. CPU
          5. e. Presentation software
          6. f. Word processor
          7. h. Network
          8. d. Login screen
          9. j. WiFi
          10. g. Scanner
          11. i. Internet

7) The initials ISP stand for ______________.
   a) Improved student progress
   b) Internet service provider
   c) Internet systems provider
   d) International systems project

1.b.3
Students use a variety of technology tools (e.g., dictionary, thesaurus, grammar
checker, calculator) to maximize the accuracy of technology – produced products.

1) When looking for a word that means the same as “cold” what word processing tool
   would be used?
   a) Computer dictionary
   b) Computer thesaurus
   c) Spelling and Grammar Checker
   d) Computer Calculator
   Computer Dictionary
2) When looking for a definition of a word what word processing tool would be used?
   a) Computer dictionary
   b) Computer thesaurus
   c) Spelling and Grammar checker
   d) Computer Calculator


                                                                          Page 15 of 50
3)      What tool on the computer can you use to add numbers?
    a) Computer dictionary
    b) Computer Thesaurus
    c) Spelling and Grammar checker
    d) Computer Calculator
4)      Which tool would you use to fix this? Those boy ain’t good.
    a) Computer Dictionary
    b) Computer Thesaurus
    c) Spelling and Grammar checker
    d) Computer calculator
5) You have just written an essay for your English class, list three word processing tools
to help make sure your document is free of errors.

1 ______________________________
2 ______________________________
3 ______________________________

Possible Answers:
dictionary, spell check, grammar check, thesaurus

1.b.4
Students identify a variety of information storage devices (e.g., floppies, CDs, DVDs,
flash drives, tapes) and provide a rationale for using a certain device for a specific
purpose.
1) Which of the following is a removable, optical, storage device capable of holding over
650 mg of data and used for music and data files?
    a) CD-RW
    b) Floppy Disk
    c) Flash Drive
    d) Hard Drive
2) Which of the following is the primary storage device for full length movies?
    a) CR-RW
    b) DVD
    c) Flash Drive
    d) Hard Drive
3) Which of the following is a compact storage device that easily carries files from one
computer to another via the USB port?
    a) CD-RW
    b) DVD
    c) Flash Drive
    d) Hard Drive
4) What is the primary function of floppy disk and CD drives? (NC)
   a) To calculate numbers
   b) To save or open data
   c) To print sheets of paper
   d) To display information or pictures on a screen


                                                                             Page 16 of 50
5) You’ve written a brief essay for class and you need to edit this at home and school.
Which of the following would be the BEST storage device?
   a) Floppy Disk
   b) CD-R
   c) DVD
   d) Network server
6) You just finished editing a digital video for a social studies project. Which of the
following would be the BEST storage device?
    a) Floppy Disk
    b) CR-R
    c) DVD
    d) Flash Drive
7) You are working on a multimedia project in social studies that may include pictures, a
word processing document, digital video, and audio files. What would be the BEST
storage device for working on this at home as well as at school? Explain your answer.
Possible Answers: DVD, Flash Drive, CD-R
8) What would be the BEST storage device for a collection of slide shows to share with
your family?
    a) CD-ROM
    b) Floppy Disk
    c) Network Server
    d) None of the above
9) Half of your class is working on a paper in the classroom, while the other half is
working in the media center. In order to access your paper in either location, which of
the following would be the most appropriate storage device?
     a) DVD
     b) Tape
     c) CD-ROM
     d) Network Server

1.b.5
Students identify technology resources that assist with various consumer related
activities (e.g., budgets, purchases, banking transactions, product descriptions).
1) When setting up a budget for the upcoming year, what is the most appropriate
application?
   a) Word Processing
   b) Spreadsheet
   c) Presentation
   d. Desktop Publishing
2) To organize a large collection of CDs, which is the most appropriate application to
use?
   a) Word processing
   b) Presentation
   c) Database
   d) Desktop Publishing




                                                                            Page 17 of 50
3) To show information to the school board about the Playground Cleanup Project, which
is the most appropriate application to use?
     a) Word Processing
     b) Spreadsheet
     c) Presentation
     d) Database

4) To create a classroom newsletter, which is the most appropriate application to be used?
    a) Spreadsheet
    b) Presentation
    c) Database
    d) Desktop Publishing
5) To create a table and graph for the Science fair, which is the most appropriate
application to be used?
    a) Word Processing
    b) Spreadsheet
    c) Database
    d) Desktop Publishing
6) What type of computer program would you most likely use to design an invitation for
an award banquet?
    a) Simulation
    b) Spreadsheet
    c) Virtual reality
    d) Desktop publishing
7) Which of the following would be the best way to track food items in the cafeteria on a
weekly basis?
                                                                    a. adding
                                                                    machine

                                                                  b. paper
                                                                  spreadsheet

                                                                  c.
                                                                  electronic
                                                                  spreadsheet

                                                                  d. calculator



8) You are saving your money for a large purchase. Which software application would
BEST help you plan your budget?
   a) Word processing
   b) Spreadsheet
   c) Multimedia slide show
   d) Database


                                                                            Page 18 of 50
1.b.6
Students can identify appropriate file formats for a variety of applications.
1) Assessment Matching Question:

Match the following icons with the program that they represent:

____1. PowerPoint                                a.

____2. Word                                      b.
____3. Excel                                     c.
____4. Paint                                     d.
____5. Access                                    e.


Answer: 1.e , 2. a, 3. d, 4. c, 5. b

2) Which of the following would be the correct extension for a word processing
application?

    a. .jpg                       b. .exe

    c. .doc                      d.. .tif

3) To save a graphic in the Paint application which of the following would use the least
amount of storage space?

    a. png                       b. bmp

    c. jpg                        d. tif

4) On the line to the left of the file extension, indicate the letter of the corresponding
application or file format.

 1 _____.doc         A     Microsoft PowerPoint
 2 _____.wps         B     AppleWorks
 3 _____.xls         C     Microsoft Word
 4 _____.pdf         D     Web Page
 5 _____.ppt         E     Word Perfect
 6 _____.wks         F     Microsoft Excel
 7 _____.jpg         G     Photo
 8 _____.gif         H     Clip Art
 9 _____.html        I     Adobe Acrobat Reader
10 _____.cwk         J     Microsoft Works
                     K     Inspiration




                                                                                 Page 19 of 50
 Correct Answer:
 1 ___C__.doc
 2 ___E__.wps
 3 ___F__.xls
 4 ___I__.pdf
 5 ___A__.ppt
 6 ___J__.wks
 7 ___G__.jpg
 8 ___H__.gif
 9 ___D__.html
10 ___B__.cwk

5) What is the proper file extension for a PowerPoint file?
    a) .doc
    b) .jpg
    c) .mpg
    d) .ppt


1.b.7
Students can use basic utility programs or built-in application functions to convert
file formats.
1) If your hard drive becomes full, what can you do in order to be able to SAVE your
document without deleting anything?
     a) Log off and give up thus losing your document.
     b) Compress a graphic file
     c) Delete Word documents
     d) Save your document to the Desktop
2) What is the most common file format to save a word processing document or file?
     a) .exe                   b) .doc
     c) .pdf                   d) .tif
3) To change the file format of a Word document select the following option:
    a) Save in:                b) File name:
    c) Save as type:           d)
look in:




                                                                        Page 20 of 50
4)
Yes     No    As the students perform each task, place a checkmark in the
             appropriate box where proficiency is shown.

             File Save As

             Locate file format drop down menu

             Select the appropriate file format

             Click on the Save button

             Ability to retrieve/open the file after saving it


5) Microsoft Word can save in all of the following file formats EXCEPT for:
   a) .rtf
   b) .xls
   c) .doc
   d) .html

1.b.8
Students proofread and edit writing using appropriate resources (e.g., dictionary,
spell check, grammar check, grammar references, writing references) and grade
level appropriate checklists both individually and in groups.
1) Most word processors will indicate if a word is misspelled.
   a) True
   b) False
2) Spell check will find all spelling errors.
   a) True
   b) False
3) Which of the following tools would be used to find a synonym?
   a) Thesaurus
   b) Spell check
   c) Grammar check
   d) Autoformat
4) A word processing program can provide a word count for a document.
   a) True
   b) False
5) To check a sentence for correct verb tense, use the following tool.
   a) Thesaurus
   b) Grammar check
   c) Paragraph format
   d) Word count



                                                                          Page 21 of 50
6) Sara typed the following sentence: “The girl was very beautiful.” In which word
processing utility could she find a synonym for “beautiful?”
   a) Grammar check
   b) Spell checker
   c) Thesaurus
   d) Outliner
7) When proofreading and editing a document, which of the following resources would
be the LEAST beneficial?
   a) Spell check
   b) Thesaurus
   c) Grammar check
   d) Font Type


2: SOCIAL, ETHICAL, AND HUMAN ISSUES.
     a. Students understand the ethical, cultural, and societal issues related to
     technology.

2.a.1. Students understand the potential risks and dangers associated with on-line
communications.
1) While in a Chat room at home, you meet a really cool friend. He/she asks to meet you
at the mall. Do you go?
    a) Yes
    b) No
2) You should report a hostile E-mail message that you have received.
    a) True
    b) False
3) You are doing research for a class project in the lab. You use a search engine to find
     links for the project. You click on one of the links and it shows an inappropriate
     picture. What do you do?
     a) Inform your teacher
     b) Show your peers
     c) Print the picture
     d) Share the url
4) Sending a threatening email message may result in negative consequences.
     a) True
     b) False
5) You are playing games on the Internet and the website asks you to register as a user
     for a contest using your name, address, phone number and/or e-mail. Do you give
     them your personal information?
     a) Yes
     b) No




                                                                            Page 22 of 50
6) You are using the Internet in a teen chat room. The “teen” at the other end of the chat
asks for your name and phone number. How do you respond?
    a) Give them your information
    b) Send them your picture
    c) Notify your parents or teachers
    d) Ask them for their name and number
7) You are using a clipart website that asks for personal information and a credit card
    number to register to use the 30-day free trial graphics. Do you get your parents credit
    card and enter the info?
    a) Yes
    b) No
8) You open a webpage and a scrolling banner across the top declares you a winner. You
click on it because it promises a vacation to an exotic island paradise. It asks you for your
complete e-mail and password to send you information about your prize. What do you
do?
     a) Close out because you know it is a scam
     b) Give them your e-mail and password and wait for your vacation
     c) Forward the message to all of your friends
     d) Enter for your friends and family
9) You receive a “chain letter” via e-mail. It promises that if you send it on to twenty of
    your friends you will receive a large sum of money. It also tells of misfortune that has
    befallen non-believers who did not forward the e-mail. What do you do?
     a) Delete it
     b) Forward to all of your contacts
     c) Forward it to your friends
     d) Print it out
10) What rules/etiquette should you follow while you are in a chat room?
     a) Do not spread untruth or false rumors
     b) Give out personal information
     c) Use a person’s real name when entering a chat room
     d) Jump into a chat without checking it out first. They are all safe
11) While you are on-line _______________.
      a) Don’t give out confidential information (phone number, address, full name, credit
      card number)
      b) Use the back button if you are somewhere that you did not intend to be
      c) If you see something that is confusing or threatening, tell an adult
      d) All of the above
12) What is the best step to take in the event you come across an inappropriate site while
researching on the Internet?
       a) Close the window and notify an adult
       b) Close the window and avoid returning to that site
       c) Ignore it and continue your research
       d) Share the site with your friend




                                                                              Page 23 of 50
    13) Which of the following topics would be appropriate to chat about in an instant
    messaging (IM) program or chat room?
      a) Name and address
      b) Phone number
      c) Common interests
      d) Name of your school
14) In a chat room, Sally Smith reveals that she is a 14 year old girl who plays soccer.
That is one of your favorite sports. You have been meeting with her regularly in a chat
room discussing soccer, what possible danger could occur in this scenario?
    a) Sally may be collecting data for a consumer survey involving the sports interests of
    14 year old girls
    b) Sally may invite you to join her soccer team and teach you false soccer moves
    c) Sally may be a boy who really doesn’t play soccer at all, but likes to chat
    d) Sally could be a predator using a false identity awaiting the opportunity to
    meet with you in person
15) Your email inbox contains a message with an unrecognized attachment. Which
action best describes what you should NOT do?
     a) Open the email but not the attachment
     b) Open the email and the attachment
     c) Delete the entire email without opening it
     d) Request confirmation from the sender that the email is valid
16) There are many potential risks and dangers associated with on-line communications.
List three types of personal information you should not share and explain why.
Possible answers:
Social Security Number: Identity thief
Telephone number: Enables predators to locate you
Credit Card information: Identity thief
Home address: Enables predators to locate you
Full name: Enables predators to locate you

2.a.2 Students identify security issues related to e-commerce.
1) You are shopping on-line and feel pressured to place your order immediately, or you’ll
lose your chance to buy the item. You’re not sure if the website is secure, but you really
want the item. You should purchase it even though your gut tells you no.
    a) True
    b) False
2) A friend told you about an online auction. You don’t take the time to read the online
auction’s return policies, but most on-line auctions will let you return it if you don’t like
it and get your money back.
    a) True, they all have the same policies
    b) False, each online auction or shopping may have different return policies




                                                                               Page 24 of 50
3) You found a super cheap price on a CD online that you really want. It’s a real steal.
You should
    a) Compare prices at other websites and check for extra shipping and handling
costs first.
    b) It’s so cheap, so you just buy it right away.
4) You find a website that doesn’t have a privacy policy posted. You assume it’s a secure
site. It requires your name and email address in order to view the items for sale. Should
you give them the required information?
    a) Yes
    b) No
5) Should you purchase products from an online seller if their return, refund, shipping
handling policies and contact information are not posted on their website?
    a) Yes
    b) No
6) You’ve heard of “Identity Theft” but don’t think it will happen to you. Is it okay to
give out your payment information without checking first that the Internet connection is
secure?
    a) Yes
    b) No
7) You order an item from the Internet. Should you
    a) Print out all terms and records of this purchase
    b) Wait to receive ordering information with your purchase
    c) Trust the seller to keep records of your purchase
    d) Send cash
8) When ordering items over the Internet, how can you be sure that you are ordering from
a valid site? (Choose the best answer.)
     a) A valid site is any site with a lot of links to other companies
     b) All sites on the Internet are valid
     c) A valid site is a site that provides information about the company with a
     professional logo
     d) A closed padlock icon appears at the bottom of the browser window
9) When ordering items over the Internet, how do you know the personal information you
provide is secured on the site? (Choose the best answer.)
      a) A secure site may have “https” in the web address (URL) instead of just
     “http”.
      b) A secure site will ask you to verify your address and phone number.
      c) A secure site will require a password.
      d) A secure site requires you to instant message photo identification.




                                                                           Page 25 of 50
2.a.3 Students describe possible consequences in cost related to unethical use of
information and communication technologies.

1) Robert, 13 years old, is very good with computers and likes a challenge. Exploring the
Internet, he figures out how to enter the computer system used by his city. Just for fun,
and to prove he was there, Robert makes a very small change to the city’s home page. He
adds, “It’s MY town!” Would the authorities consider this a harmless joke?
    a) Yes
    b) No
2) Sonia and Brandon are at work on a school project. They come upon a hate site that
really upsets them. It says the Nazis were the heroes of World War II and denies that they
murdered innocent people. The two figure out how to enter the site. They type, “It’s a
bunch of lies!” Are Sonia and Brandon’s actions right or wrong?
    a) Right
    b) Wrong
3) Every computer, and the files it contains, is the property of some person or
organization.
    a) True
    b) False
4) People who enter computer systems without permission are committing a crime.
    a) True
    b) False
5) Why do kids hack in or enter a computer system without permission?
    a) They are looking for a challenge
    b) They think that it doesn’t hurt anyone
    c) They don’t think that they could get caught
    d) All of the above
6) Unauthorized computer entry causes a lot of trouble for computer system owners.
Teen hackers also cause trouble for themselves when they are eventually caught. What
can happen to a teen who is caught?
    a) Their Internet connection can be taken away
    b) They can be fined
    c) A few, tried in court as adults, even face jail time
    d) All of the above
7) When a computer system is entered without permission, valuable information can be
lost.
     a) True
     b) False


8) When a computer system is entered without permission hacking can cause trouble for
    people whose data is stored in these computer systems.
    a) True
     b) False




                                                                            Page 26 of 50
9) When a computer system is entered without permission a person’s private
information may be stolen, changed, or deleted.
    a) True
     b) False
10) Frances has a report due on cell division. While doing the research on the Internet,
she discovers a report written by a 7th grader posted online. She downloads a copy of the
paper and changes the name and class information to reflect her own. Frances turns in the
paper and the teacher recognizes the style of the work to be inconsistent with previous
work by Frances. The teacher confronts Frances. Is there anything wrong with what
Frances has done? Explain your answer.

Possible explanations:
    Yes
        Frances has copied someone else’s work and represented it as her own, which is
        plagiarism. She would receive a failing grade. She could lose her privilege to use
        the Internet as a resource.
11) Billy has a CD containing mp3 files of his favorite music. He downloaded the files
without paying for them. Billy burned copies of his CD and sold them at school to his
classmates. Describe the consequences and costs related to participating in this type of
activity.

Possible explanations:
Consequences may include suspension of system privileges, either alone or in
conjunction with other disciplinary measures as appropriate which may include
notification of authorities. The financial impact of unethical activities causes the loss of
income to the musician and music industry and can result in legal fees and/or fines to the
individual committing the act.




                                                                              Page 27 of 50
2.a.4 Students discuss the societal impact of technology in the future.
1) Technology in the future will change our world by
    a) Providing vehicles that use very different fuels than are used now.
    b) Allowing you to work daily with someone who lives in a different country than
you do
    c) Providing homes that can be managed off site
    d) All of the above.
2) In the future, technology will
    a) Allow us to do many things that we cannot do at the present time
    b) Be extremely expensive
    c) Cause people to be less connected to residents in other countries
    d) Not help very much with health care
3) Future societies may be connected by
    a) Voice-over IP
    b) Cell phone
     c) Video conferencing
     d) All of the above
4) Technology will have an impact on society in the future.
     a) True
     b) False

2: SOCIAL, ETHICAL, AND HUMAN ISSUES.

       b. Students practice responsible use of technology systems, information and
       software.

2.b.1 Students provide accurate citations when referencing information from
outside sources in electronic reports.

1) When using the MLA format to reference a web site, which of the following citations
is the correct one to use?
     a) Landsburg, Steven E. "Who Shall Inherit the Earth?" Slate 1 May 1997. 1
Oct. 1999 <http://www.slate.com/Economics/97-05-01/ Economics. asp>.
     b) <http://sunset.backbone.olemiss.edu/~jmitchel/pmla. Mitchell, Jason P. "PMLA
Letter." Homepage. 10 May 1997. 1 Nov. 1999
     c) “Who cares” WWW.whocares.com Tucker, Steve A Homepage. 30 Nov 2002. 30
November 2005.
     d) http://google.com

2) Using the MLA format and the information below, which of the following citations is
the correct one to use when referencing a web site?
                                   Steven E. Landsburg
                                          Slate
                             1 May 1997 (site published date)
                              “Who Shall Inherit the Earth?”


                                                                          Page 28 of 50
             <http://www.slate.com/Economics/97-05-01/ Economics.asp>
                              1 Oct. 1999. (access date)

   a) Landsburg, Steven E. "Who Shall Inherit the Earth?" Slate 1 May 1997. 1
   Oct. 1999 <http://www.slate.com/Economics/97-05-01/ Economics.asp>
   b) <http://sunset.backbone.olemiss.edu/~jmitchel/pmla. Mitchell, Jason P. "PMLA
   Letter." Homepage. 10 May 1997. 1 Nov. 1999
   c) “Who cares” WWW.whocares.com Tucker, Steve A Homepage. 30 Nov 2002. 30
   November 2005.
   d) http://google.com

3) Author(s). Name of Page. Date of Posting/Revision. Name of institution/organization
affiliated with the site. Date of Access <electronic address>.
The above is an example of MLA format citing of sources from an electronic report.
     a) True
     b) False
4) When copying and pasting a quote while writing a paper, which of the following is
correct?
     a) Placing quotations in any research paper requires citing the source to avoid
copyright law violations
    b) Footnoting material is handled automatically by electronic encyclopedias
    c) Using electronic tools for papers eliminates the need to footnote sources.
    d) Using electronic tools eliminates the need to cite references
5) To cite a web page you must always include the retrieval date.
    a) True
    b) False
6) The city of publication must always be included when citing a web page.
    a) True
    b) False
7) You must always cite your source when using information gathered from a personal
web page.
    a) True
    b) False
8) It is NOT necessary to cite a source when using information gathered from a personal
web page.
    a) True
    b) False
9) When citing a web page you must include the day you accessed the web page.
    a) True
    b) False
10) When citing a web page one must include the day the web page was last updated.
    a) True
    b) False
11) You must cite the source of a picture you found online.
    a) True
    b) False



                                                                           Page 29 of 50
12) All pictures found online can be used without citing the source.
   a) True
   b) False
13) It is permissible to copy and paste information from an online document with proper
references and citations.
   a) True
   b) False
14) Please indicate which items require a citation in your writing and which do not. A
table or graph produced by someone else.
   a) Requires a citation
   b) Does not require a citation
15) Please indicate which items require a citation in your writing and which do not. A
summary of someone’s spoken words
     a) Requires a citation
     b) Does not require a citation
16) Please indicate which items require a citation in your writing and which do not. An
idea, experience or conclusion you have about a topic
     a) Requires a citation
     b) Does not require a citation
17) Please indicate which items require a citation in your writing and which do not. A
picture a friend draws for the cover of your project
     a) Requires a citation
     b) Does not require a citation

2.b.2 Students discuss issues related to acceptable and responsible use of
technology (e.g., privacy, security, copyright, plagiarism, spam, viruses, file-
sharing).

1) Inserting a picture from the Internet into a Power Point slideshow without properly
citing the source is an example of:
    a) Spam
    b) Viruses
    c) File-sharing
    d) Copyright Violation
2) Hacking into your school network is illegal.
    a) True
    b) False
3) When writing a program or designing a system, you should think about the impact it
has on ____________.
    a) Yourself
    b) Society
    c) Computer
    d) Earth
4) Copying somebody else’s program or software without permission is an example of
____________.
     a) Software piracy
     b) Copyright law



                                                                           Page 30 of 50
    c) Permission
    d) Both A and B

5) On a school computer, Tina, learned how to copy programs. A classmate asked her to
copy a program for his home use. Her most ethical response would be which of the
following? (NC)
     a) “I’ll copy it for you, but you can’t copy it for anyone else.”
     b) “I’ll copy it, but you have to promise not to tell anyone.”
     c) “I don’t know how to copy diskettes.”
     d) “I can’t copy it because it will break copyright laws.”
6) A Middle School purchased a single-user copy of a word processing program. They
may do which of the following?
     a) Copy it onto all the computers in the lab
     b) Duplicate the disk and give it to everyone in one class
     c) Use it on only one computer in the lab
     d) Use it on all computers in one classroom
7) Upon walking into your teacher’s workroom you see a test on the computer screen.
Which of the following would be an ethical choice?
     a) Leave the room without reading the test questions
     b) Add a few well-chosen questions that were left out
     c) Read the questions as a study guide
     d) Correct obvious errors on the test to help your teacher avoid embarrassment
8) When facts are known to many people and sources, (i.e. George Washington was the
first president.) it is called common knowledge.
     a) True
     b) False
9) Facts that are common knowledge (i.e. George Washington was the first president)
need to be cited.
     a) True
     b) False
10) If you do not know that you are breaking the Academic Dishonesty Code you will not
get in trouble.
     a) True
     b) False
11) All students are responsible for understanding and following the Acceptable Use
Policy.
     a) True
     b) False
12) What can a computer virus do?
     a) Send fraudulent emails using your address.
     b) Delete saved work
     c) Destroy the computer’s hard drive
     d) All of the above
13) It’s OK to share your password with friends.
     a) True
     b) False



                                                                        Page 31 of 50
14) It is acceptable to loan your log-in password to. . .
    a) Your good friend that you trust
    b) Members of your cooperative learning group
    c) The new kid who doesn’t have one yet
    d) It is never acceptable to share your password
15) You can download any files you find on the Internet without permission.
     a) True
     b) False
16) There are legal consequences for downloading copyrighted material from the Internet
without permission.
     a) True
     b) False


2: SOCIAL, ETHICAL, AND HUMAN ISSUES.
     c. Students develop positive attitudes toward technology uses that support
     lifelong learning, collaboration, personal pursuits, and productivity.

2.c.1 Students use technology to identify and explore various occupations or
careers.

1) Which of the following is NOT an effective way to use technology in order to identify
and explore various careers?
    a) Call a company
    b) Access job search sites such as, Monster.com
    c) Use your online EDP (educational development plan)
    d) Access a company’s website
2) List three ways you could use technology to explore various occupations or careers.
Possible answers: Exchange email with someone working in a field of interest requesting
information about their field; search the Internet for information about a particular career;
explore an online database of career information; participate in an interactive
videoconference with someone in your field of interest




                                                                               Page 32 of 50
2.c.2     Students discuss uses of technology (present and future) to support
personal pursuits and lifelong learning.

1) What technology would give you the most information about your personal hobby?
     a) Email
     b) Internet
     c) MP3 player
     d) Handheld computer
2) Which is the best technology to use to keep track of appointments?
     a) Email
     b) Sticky notes
     c) Internet
     d) Handheld computer
3) You want to regularly communicate with a friend who lives in another state. What is
the best way to contact him/her, using technology?
     a) Email
     b) Postcards
     c) MP3 player
     d) Handheld computer
4) How can you use a computer for learning outside of school?
     a) Take an online course with a university
     b) Join a discussion group on a subject that interests you
     c) Research a topic by using an online search engine
     d) All of the above
5) You want to learn about investing money in the stock market. What key words could
you enter into a Google to give you the most useful results?
     a) Stock market
     b) “Stock market”
     c) Stock
     d) Market

2.c.3
       Students discuss uses of technology (present and future) to support personal
pursuits and lifelong learning.

1) Of the following, which technical tool is not useful to support communication with
peers, family or school personnel?
    a) Cell phone
    b) Email
    c) MP3 Player
    d) Fax machine
2) What is the best way to send a written document to your teacher from home?
   a) Email attachment
   b) Cell phone
   c) Pony Express
   d) Instant Message


                                                                           Page 33 of 50
3) List five technologies you can use for communication.
Possible answers: Blogs, IM, chat room, cell phones, land phones, text messaging, email

3. TECHNOLOGY PRODUCTIVITY TOOLS.
      a. Students use technology tools to enhance learning, increase productivity,
      and promote creativity.

3.a.1 Students apply common software features (e.g., thesaurus, formulas, charts,
graphics, sounds) to enhance communication and to support creativity.

1) Multiple-choice question: Which of the following is a resource to make projects more
creative?
     a) Graphics
     b) Clip Art
     c) Sound
     d) All of the above
2) In a word processor, which tool would you use to find a synonym for the word
“conflict”?
     a) Thesaurus
     b) Spell Check
     c) Word Count
     d) Grammar Check
3) A formula for adding 50 rows of numbers in the same column could be SUM(D3:D52)
     a) True
     b) False
4) It is acceptable to have blank columns in your data table when creating a chart.
    a) True
    b) False
5) The thesaurus is the tool to check your spelling and grammar errors.
    a) True
    b) False
6) To resize a graphic you should grab the resize tool from any corner.
   a) True
   b) False
7) Name and describe the purpose of two commonly used built-in functions in a
spreadsheet.
Possible answers: Sum adds numbers in selected cells; Max finds the largest number in
selected cells; Min finds the smallest number in selected cells; Average calculates the
average of selected cells; If returns one value when a condition is true, another when
false; Count returns the number of cells that contain a number
8) Describe two ways to access the spell checker or thesaurus in your document.
Possible answers: Use the icon on the tool bar; go thru the tools menu; click on red or
green lines




                                                                          Page 34 of 50
3.a.2 Students use a variety of resources, including the internet, to increase
learning and productivity.

1) If you wanted to do research on the U.S. Space Program, what are the most common
and reliable resources students would use.
    a) Internet search engine
    b) Video clips
    c) NASA website
    d) All of the above
3) What would be the most efficient way to enter repeating choruses to a song that you
are typing into a word processor?
    a) Copy the chorus on a copy machine and the cut and paste it into his document
    b) Use the Copy and Paste command
    c) Highlight the text and change it to Bold
    d) Type the chorus four times
4) On the line to the left of each assignment, indicate the letter of the best resource to use
to complete the following:

1. ____   Determine the average temperature for Cancun for the second week in March.
2. ____   Find the hours of operation for your local shopping mall.
3. ____   Share a presentation on the food pyramid with your class.
4. ____   Critique 2 music artists.
5. ____   List 5 of your local government officials.


A.   DVD – Video
B.   Overhead Projector
C.   Search Engine
D.   Telephone
E.   Website


Correct Answer:
1. C
2. D
3. B
4. A
5. E




                                                                                Page 35 of 50
3.a.3 Students explore basic applications that promote creativity (e.g., graphics,
presentation, photo-editing, programming, video-editing).

1) In most cases photos should be resized before placing them on a webpage.
     a) True
     b) False
2) On the line to the left of each example, write the letter of the most appropriate program
that you would use to create the following:
_____ Picture Editing
_____ Video Editing
_____ Drawing
_____ Brochures
          A. Publisher
          B. iMovie / Premier
          C. PhotoShop
          D. Illustrator
Correct answer: C, B, D, A
3) When working with a digital image, pick the program that is most suitable to edit or
transform the image.
     a) Microsoft Word
     b) Microsoft PowerPoint
     c) PhotoShop
    d) Internet Explorer
4) If you were asked to make a presentation to your class that requires you to show
pictures, text and video, which program would be the best choice?
     a) Internet Explorer
     b) Photo Shop
     c) Microsoft Word
     d) Microsoft PowerPoint
5) When working with a digital image, pick the program that can be used to edit or
transform the image.
      a) Microsoft Word
      b) Microsoft PowerPoint
      c) PhotoShop
      d) Internet Explorer
6) On the line to the left of each example, write the letter of the most appropriate program
to use.
_____ Picture editing
_____ Video editing
_____ Creating a drawing
_____ Designing a brochure
          A      Publisher
          B      iMovie/ Premier
          C      PhotoShop
          D      llustrator
          Correct answers: C, B, D, A


                                                                              Page 36 of 50
3.a.4 Students use available utilities for editing pictures, images, or charts.
1) Which of the following applications could be used to create or edit pictures and charts?
     a) Photo editor
     b) Spreadsheet
     c) Paint program
     d) All of the above
2) If you were asked to design a poster for an upcoming school activity, which software
programs would NOT be appropriate to use?
      a) Microsoft Access
      b) Microsoft Word
      c) Microsoft Paint
      d) Microsoft Publisher

3. TECHNOLOGY PRODUCTIVITY TOOLS.
      b. Students use productivity tools to collaborate in constructing technology-
      enhanced models, prepare publications, and produce other creative works.

3.b. 1 Students use productivity tools to collaborate in constructing technology-
enhanced models, prepare publications, and produce other creative works.

1) Which of these tools could you use, if it were available, to collaborate with other
students on a project?
    a) Email
    b) Instant Messaging
    c) Chat Room
    d) All of the above
2) Which of the following tools would be most appropriate for developing a student
newsletter?
    a) Microsoft Excel
    b) Microsoft Outlook
    c) Microsoft Publisher
    d) Microsoft PowerPoint

4. TECHNOLOGY COMMUNICATIONS TOOLS
      a. Students use telecommunications to collaborate, publish, and interact with
      peers, experts, and other audiences.




                                                                              Page 37 of 50
 4.a.1 Students use a variety of telecommunication tools (e.g., e-mail, discussion
 groups, IM, chat rooms, blogs, video-conferences, web conferences) or other online
 resources to collaborate interactively with peers, experts, and other audiences.

 1) When using an electronic bulletin board, you can do all of the following except which
 one?
    a) Send a public message to friends interested in one topic
    b) Send pictures to a friend
    c) Send private messages to a friend
    d) Send a package to a friend
 2) You just purchased a game cube and you wish to contact Nintendo with a question.
 What steps you would take to e-mail a company?
 Correct Answer: E-mail – Obtain Company’s email address, login to your email, select
 new message, insert email address, type message and send
 3) Name two instant message programs to use to IM your friends? Correct Answer:
 Yahoo, MSN, ICQ, etc.
 4) Name two applications can you use for e-mail. Correct Answer: Outlook, Hotmail,
 Yahoo, Entourage, etc.

 Match each telecommunications tool with its purpose.

____1. Blog                             a. Communicating text asynchronously
____2. Instant Message                  b. Deciding on a background
____3. Threaded Discussion              c. Posting and responding to discussion issues on a message
        Group                              board
____4. Chat Room                        d. Selecting a ring tone
____5. E-mail                           e. Communicating text in real-time between two people
____6. Video Conferencing               f. Communicating text in real-time among three or more
                                           people
                                        g. Creating an on-line journal
                                        h. Transmitting video and audio between two or more locations

 Correct Answers:    G, E, C, F, A, H

 6) Which is the best tool for hundreds of students to post their comments in response to
 specific topics?
     a) Instant Messaging
     b) Email
     c) Web Chat
     d) Threaded Discussion Board
 7) Chat rooms facilitate real-time web conversations.
     a) True
     b) False
 8) Blogs facilitate real-time web conversations.
    a) True
    b) False


                                                                             Page 38 of 50
4. TECHNOLOGY COMMUNICATIONS TOOLS
      b. Students use telecommunications to collaborate, publish, and interact with
      peers, experts, and other audiences.

4.b.1 Students create a project (e.g., presentation, web page, newsletter,
information brochure) using a variety of media and formats (e.g., graphs, charts,
audio, graphics, video) to present content information to an audience.

1) If you were required to print your next English report with columns like a newspaper
and had to include at least one picture which of the following computer applications
would you most likely use? (NC)
    a) Desktop publishing
    b) Spreadsheet
    c) Database
    d) Telecomputing



5. TECHNOLOGY RESEARCH TOOLS
       a. Students use technology to locate, evaluate, and collect information from a
variety of sources.

5.a.1. Students use a variety of Web search engines to locate information.
        Recommended Resources:
1) Which of these websites is NOT a search engine?
    a) Dogpile.com
    b) Google.com
    c) Hooray.com
    d)Yahoo.com
2) When using a search engine, the first result is always the best.
   a) True
   b) False
3) Give several reasons why the first result from a search engine isn’t always the best?
   Possible correct answers: Some search engines allow companies to pay for premium
spots. Some search engines search based on where the term is located on the website.
4) You can optimize your search results on the Internet by;
    a) Using several different search engines
    b) Sticking to your topic and resisting distractions
    c) Using reliable Web resources such as National Geographic
    d) All of the above
5) Which of the following is an example of effective online searching?
    a) Search on a search engine of your choice and then browse for the most useful
information.
    b) Formulate research questions, list possible sources of information, identify
keywords, and begin your search.
    c) Visit chat rooms and find out what others are saying about your topic.
    d) Post a question about your topic on a message board and read all the responses.
6) Using any search engine, which of the following would narrow your search outcome?


                                                                           Page 39 of 50
    a) Type the search question to be answered
    b) Group key words with quotation marks “……”
    c) Eliminate only key words from your search
    d) Type the URL as your search question.



5.a.2. Students evaluate information from various online resources for accuracy,
bias and appropriateness.

1) When using the Internet, all information you locate will be accurate
    a) True
    b) False
2) Which of the following should you use to evaluate information from online resources?
    a) The author of the website
    b) Date it was last updated
    c) Content on page
    d) All of the above
3) To find information about a particular college or university you may want to attend,
you would go to an .edu website.
    a) True
    b) False
4) Which of the following extensions would assist you in locating information about
colleges and universities?
    a) .mil
    b) .edu
    c) .com
    d) .org
5) Which of the following is the best indicator that a Web site is reliable?
    a) The author of the site tells you the information is reliable.
    b) The author of the site provides contact information and his or her credentials.
    c) The author links to his or her favorite Web sites.
    d) The author states in bold letters that the site was proofread by a librarian.
6) Critically evaluating content on the Web is important because
    a) Web authors are always less professional than traditional authors
    b) Web authors are always biased
    c) Anyone can publish on the Web
    d) Printed information is always more accurate

5.a.3 Students can identify types of internet sites based on their domain names
1) On the line to the left of the domain name, indicate the number of the correct response.


               _______.gov                           1) country
               _______ edu                           2) commercial enterprise


                                                                             Page 40 of 50
               _______.com                            3) non-profit organization
               _______ .org                           4) Hosted by National or local
                                                      government
               _______ .ca                            5) sponsored by an educational
                                                      institution
Correct answers: 4, 5, 2, 3, 1
2) On the line to the left of the organization, indicate the letter of the domain name below

_________ US Army

_________ Michigan State University

_________ General Motors

_________ State of Michigan

_________ American Red Cross

Domain Name

   A .edu
   B .com
   C .org
   D .au
   E .mil
   F .gov
Correct Answers: E, A, B, F, C

3) What does this URL tell you about the source? http://vos.ucsb.edu
   a) It is associated with an educational institution
   b) It is an English teacher’s personal home page
   c) It is an article from a magazine
   d) It is from a directory5. TECHNOLOGY RESEARCH TOOLS
        b Students use technology tools to process data and report results

5.b.1 Students know how to create and populate a database.
1) If you wanted to add the amount of carbohydrates per serving into the table below you
should do which of the following?

                                                    a. change a cell (spreadsheet) or field
                                                    name (database)

                                                    b. match all records on row field
                                                    names

                                                    c. add a new field (database) or



                                                                              Page 41 of 50
                                                     column (spreadsheet)

                                                     d. add a new row (spreadsheet) or
                                                     record (database)

2) What process is used to find a collection of related records in a database?
   a) Layout
   b) Clipboard
   c) Field
   d) Query
3) Which of the following terms are related to computerized databases?
   a) Search
   b) Sort
   c) Field Names
   d) All of the Above
4) What is the first step in creating a database?
   a) Identify data sheet
   b) Identify data fields
   c) Alphabetize data
   d) Create a report

5.b.2 Students can perform queries on existing databases.
1) In a search for a specific book in your local school library, check the fields that can be
    used:
    _________Title
    _________ISBN number
    _________Author
    _________Book color
    _________Number of pages
    _________Number of images
    _________Topic

Correct answers: Title, ISBN number, Author, Topic

5.b.3 Students know how to create and modify a simple database report.

1) If the database below was sorted such that the information for "Nation" appeared as
follows: US, France, US, Sweden, Switzerland, which field would have been used to sort
the database.




                                                                                 Page 42 of 50
                                                                  a. Nation

                                                                  b. Inventor

                                                                  c. Invention

                                                                  d. Date




2) If you planned to run for governor and one part of your platform dealt with increasing
medical services to rural areas, which of the following would best help determine where
money should be spent to open clinics?
   a) Search a state database for type of community-“rural” and then Sort on the
   field showing the number of doctors.
   b) Sort a state database on the type of community and then Search number of doctors
   c) Sort a state database on the type of community and Sort on the field showing the
  number of doctors
   d) Search a state database for type of community= “rural” and then Search number of
  doctors
3) If you needed to determine which countries lie below the equator and have at least one
seaport, which of the following search statements would be which most appropriate?
(NC)
   a) Location=”below equator” and Seaports >+1
   b) Location+”equator” and Seaports>1
   c) Location+”equatpr” or Seaports>=1
   d) Location+”below equator” and Seaports>1

4) If the computer searched the database records shown for all cereals with less that 2 g
of Protein and less than 2 g of Fat, which of the following would appear when the search
was completed?
                                                          a. Total Corn Flakes

                                                          b. Rice Krispies Treats

                                                          c. Almond Delight

                                                          d. Fruit Loops




                                                                              Page 43 of 50
5) How could the database below be most efficiently searched to find all of the inventions
of Samuel Morse?




                                                       a. Inventor = "Morse"

                                                       b. Invention = "telegraph"

                                                       c. Nation = "US"

                                                       d. Date= "1837"




                                                                            Page 44 of 50
6) By which field are the entries sorted in the database below?




                                                              a. Inventions

                                                              b. Nation

                                                              c. Date

                                                              d. Inventor




5. TECHNOLOGY RESEARCH TOOLS
       c. Students evaluate and select new information resources and technological
      innovations based on the appropriateness to specific tasks

5.c.1 Students evaluate and select new information resources and technological
innovations based on the appropriateness to specific tasks.
1. Students evaluate new technology tools and resources and determine the most
appropriate tool to use for accomplishing a specific task.

1) The gym teacher has a new program to calculate physical fitness in terms of weight
and exercise. It is used to input different weights and amounts of exercise to predict
physical fitness. Which of the following would be most appropriate to use?
   a) Word processing
   b) Desktop publishing
   c) Presentation
   d) Spreadsheet
2) A word processor would most likely be used to do which of the following?
   a) Type a biography
   b) Keep an account of money spent
   c) Compose music
   d) Do a computer search in the media center




                                                                              Page 45 of 50
3) Match the following tasks to the most appropriate tool for completion
   ____ making a book report with short media clips
   ____ generating text documents
   ____ modifying a digital movie
   ____ analyzing data for average performance
   ____ developing an HTML document

       A Word processor
       B Multimedia presentation software
       C Spreadsheet
       D Web authoring tool
       E Movie editor


       Correct answers: B, A, E, C, D

6. TECHNOLOGY PROBLEM-SOLVING AND DECISION-MAKING TOOLS
      a. Students use technology resources for solving problems and making
      informed decisions.

6.a.1 Students use database or spreadsheet information to make predictions,
develop strategies, and evaluate decisions to assist them with solving a basic
problem.

1) How could the total cost of food sold in the cafeteria for one day be calculated?


                                                       add cells A2 through A6

                                                       add cells A6 through D6

                                                       add cells C2 through C6

                                                       add cells D2 through D6




                                                                             Page 46 of 50
2) If 186 more hot dogs were sold, which cells would change?



                                                       a. C2 and C5

                                                       b. A3 and A5

                                                       c. A2 and D2

                                                       d. A2 and C2




3) If you want to lose weight, which of the following products would you select with the
fewest calories?


                                                         a. Banana Nut Crunch

                                                         b. Kellogg's Corn Flakes

                                                         c. Total Corn Flakes

                                                         d. Almond Delight


4) How would the total cost per year for all the instruments be calculated?


                                                         a. by adding cells D2 through
                                                         D6

                                                         b. by adding cells E2 through
                                                         E6

                                                         c. by adding cells C2 through
                                                         C6

                                                         d. by adding cells C7 through
                                                         E7




                                                                              Page 47 of 50
5) Where was the total amount for the sale of TV Guide calculated?


                                                              a. D7

                                                              b. C4

                                                              c. B4

                                                              d. D4




6) Which of the following best describes the place where the costs in column C are
entered?



                                                           a. fields

                                                           b. formulas

                                                           c. values

                                                           d. cells




                                                                           Page 48 of 50
7) The total amount of money received for each magazine is calculated in which
column?




                                                                a. Column A

                                                                b. Column B

                                                                c. Column C

                                                                d. Column D




8) The most subscriptions were sold for which magazine?



                                                    a. Time

                                                    b. Sports Illustrated

                                                    c. TV Guide

                                                    d. Newsweek




                                                                         Page 49 of 50
6. TECHNOLOGY PROBLEM-SOLVING AND DECISION-MAKING TOOLS
      b. Standard: Students employ technology in the development of strategies for
      solving problems in the real world.

6.b.1 Students describe the information and communication technology tools to use
for collecting information from different sources, analyze their findings, and draw
conclusions for addressing real-world problems.


1) The gym teacher has a new program to calculate physical fitness in terms of weight
and exercise. It is used to input different weights and amounts of exercise to predict
physical fitness. This "What if" program is most likely which of the following types of
software?
   a) Word processing
   b) Desktop publishing
   c) Presentation
   d) Spreadsheet
2) A chart is most commonly created utilizing data found in which application type?
   a) Word processing
   b) Desktop publishing
   c) Spreadsheet
   d) Presentation software




End of Document




                                                                            Page 50 of 50

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:30
posted:7/7/2012
language:English
pages:50