Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Assessing Tech Competencies: Word, Excel, and PowerPoint, Study notes of History of Education

A performance-based assessment for edtl 230 students to demonstrate their technology competencies by creating three products: a word document with specific formatting, an excel spreadsheet with formulas and charts, and a powerpoint presentation with layout templates and multimedia elements. Students must save and upload their files in a zipped folder to the course shell.

Typology: Study notes

Pre 2010

Uploaded on 08/18/2009

koofers-user-ec8-1
koofers-user-ec8-1 🇺🇸

5

(1)

10 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Practice EDHD assessment of Technology Competencies—1
EDHD Assessment of Technology Competencies
EDTL 230 50-minute Timed Assessment
This assessment is performance-based in that you will use technology to create
three products that demonstrate your technology competency. These three
products are:
Word Document that utilizes: a 2-column format; a picture (located during a
web search); text formatted with two fonts, two sizes, and two styles; spell-
check; paint/draw tools; an imported chart; and a table.
Excel Spreadsheet that applies several formulas, number formats, and
creation of charts.
PowerPoint Presentation of two slides that applies layout template, Clip Art
image, paint/draw tools, transition, and animation.
This assessment is open book. You may use any books, handouts, notes, or other
material you choose. You may NOT consult with or look at others' work as you
complete the exam. You may not use previously created documents—all
products must be created in class during your assessment timeslot. For each
product/file created, it is essential that you save the files exactly as specified.
There is no need to print the files, but you will upload them in a “zipped” file
folder to the specified assignment area in your EDTL 230 course shell.
To begin the assessment, you should open/launch the following applications:
An Internet browser of your choice (Safari or Explorer).
Microsoft Word.
PowerPoint.
Excel.
Revised 11/28/20 ©1999, 2007 Savilla Banister
pf3
pf4
pf5

Partial preview of the text

Download Assessing Tech Competencies: Word, Excel, and PowerPoint and more Study notes History of Education in PDF only on Docsity!

EDHD Assessment of Technology Competencies EDTL 230 50-minute Timed Assessment This assessment is performance-based in that you will use technology to create three products that demonstrate your technology competency. These three products are:  Word Document that utilizes: a 2-column format; a picture (located during a web search); text formatted with two fonts, two sizes, and two styles; spell- check; paint/draw tools; an imported chart; and a table.  Excel Spreadsheet that applies several formulas, number formats, and creation of charts.  PowerPoint Presentation of two slides that applies layout template, Clip Art image, paint/draw tools, transition, and animation. This assessment is open book. You may use any books, handouts, notes, or other material you choose. You may NOT consult with or look at others' work as you complete the exam. You may not use previously created documents—all products must be created in class during your assessment timeslot. For each product/file created, it is essential that you save the files exactly as specified. There is no need to print the files, but you will upload them in a “zipped” file folder to the specified assignment area in your EDTL 230 course shell. To begin the assessment, you should open/launch the following applications:

 An Internet browser of your choice ( Safari or Explorer ).

 Microsoft Word.

 PowerPoint.

 Excel.

Product #1: Word Document

DIRECTIONS: Read each step first. Then complete each task in order. The disk icon is a reminder to save your work at that point. Create a folder on the desktop and name the folder “ Username ATC Files” where username is your bgnet username.

  1. Open Word, save the new file to the folder on the desktop. Name the file using your bgnet username, and file type. For instance: sbanist word.doc where sbanist = bgnet username, word = file type.
  2. At the top of the page, include a large title across both columns using WordArt that reads, “Animal Facts.”
  3. Using the drawing tools, draw a horizontal line across both columns separating the title from the text of the document. Change the thickness of the line to 3 points and the color of the line to blue.
  4. Format the remainder of the page as a 2-column document.
  5. In the left hand column, write one or two paragraphs describing your favorite animal. Be sure to include characteristics of its look, habitat, and food. “ Justify ” the text of your article and be sure to spell-check!
  6. Create a title for your article; include your name beneath the title. Place the title and your name above your article text in the left-hand column.
  7. Format the article text and title so that you use 2 font types, 2 font sizes, and 2 font styles.
  8. Go to your Internet browser, search for a picture that depicts your favorite animal. Insert this picture below your article, in the left hand column. You may need to resize the picture. In the left hand column of your Word document below the picture, include the URL where you retrieved the picture. Make sure that the URL is formatted as a hyperlink.
  9. In the right hand column, insert a table with 2 columns and 6 rows.
  10. Merge the cells in the top row of the table and then type the heading “Lunch Menu.”
  11. In the remainder of the table insert the text identified below: Lunch Menu Monday Hamburgers Save Often Save Often

a. Choose a columnar (vertical bar) chart format. b. Title the chart, Jane Doe’s Semester Grades. c. The categories on the x-axis indicate the assignment names. (HW 1, HW 2, Test 1, Test 2, Paper, Exam)

  1. Save the spreadsheet and chart now.
  2. Copy & paste the graphic chart into the right hand column of your Word document. You may need to resize your chart BEFORE copying and pasting into the Word document. Save word document again.

Product 3: PowerPoint Presentation

DIRECTIONS: Read each step first. Then complete each task in order. Remember to save often!

1. Open PowerPoint, save the new file to the folder on the desktop. Name the

file using your bgnet username, and file type. For instance: sbanistpres.ppt where sbanist = bgnet username, pres = file type.

2. Create a title slide. Select a slide design (other than blank) from the format

menu. Type the following text on the first slide. Center the text. Tutoring in Technology for BGSU Students Student Tech (Your First Name and Last Name) (Today's Date)

3. Format the text “Student Tech” as a hyperlink to the Student Tech website

at http://www.bgsu.edu/offices/cio/studenttech/.

4. On the title slide, insert an image of your choice from Clip Art (hint:> Insert

pull-down menu).

5. In the lower left hand corner of slide one, insert a textbox that reads

“Moving to a new location!”

6. Insert a second slide. Use the slide layout for title and bulleted text. Type

the text below into the second slide. Tutoring offered to students in:PowerPointDigital VideoPhotoshopWeb Page DesignMuch more! Walk-in or by appointment!

7. Insert the “heart” autoshape from the drawing tools into the content

box. Change the default color of the heart using your choice of fill color. Save Often Save Often Save Often

8. Create a “Dissolve In”(PC) or “Dissolve”(Mac) animation effect for the

individual bullet points.

9. Create a slide show transition of your choice. Apply the transition to all

slides.

10. Save your presentation.

Submitting your Work

  1. Check to see that all 3 of your files are in the folder named “ Username ATC Files.”
  2. Compress this folder by using the “zip” or “archive” feature of your computer operating system.
  3. Log in to you’re my.bgsu account, navigate to your EDTL 230 course shell.
  4. Go to the Assignment “ATC”, click on “View/Complete Assignment” and upload your zipped folder. NOTE: The instructions above are for the actual assessment protocol. Practice creating a zipped file and using you’re my.bgsu course shell for EDTL 230, but DO NOT actually upload your practice test.