Computer Literacy

**A portion of the No Child Left Behind (NCLB) Act is the Enhancing Education Through Technology Act of 2001, also known as Title IID and/or E2T2. The goal of E2T2 is: To assist every student in crossing the digital divide by ensuring that every student is technologically literate by the time the student finishes the eighth grade, regardless of the student’s race, ethnicity, gender, family income, geographic location, or disability.
Each state is required by NCLB mandates and the Office of Elementary and Secondary Education's (OESE) measures under the Government Performance and Results Act (GPRA) to report on:

• Number of computers available to students and the type of Internet access (Building Level)
• Technology Literacy at the end of 8th Grade (LEA)

Rhode Island must be in compliance and reporting to the federal government by the end of the 2008-09 school year. 

By the 2009-2010 school year, additional requirements will include:

• Personnel Skilled in Technology (LEA)
• Integrated Technology Status (LEA)

 

 

**Taken from the Rhode Island Department of Education

Technology Literacy Assessment

 

 

Each year all 8th grade schools in Rhode Island are required to take a computer literacy Assessment to assess the students knowledge and skills as it relates to computer literacy.  As a Technology Educator teaching for the cumberland school deparment, I am required to teach computer literacy as part of the middle school curriculum.  However, there is a difference between computer literacy and Technology Education.  My aproach to teaching computer literacy is to combine both the knowledge and skills of using computers with the problem solving aproach to Technology Education.

 

                                                      -Keith Colwell

                                                       Technology Education Teacher

Computer Literacy Expectations

 

Microsoft Word Skills

 

      Open a  Word file

      Save and Organize Word Document files on the computer

      Format a page to Portrait or Landscape

      Set the Margins of a page

      View a document

      Save a document as a webpage

      Use Find and Replace to edit a document

      Use Undo and Redo to edit document

      View document using Print Layout, Normal and Web layout

      Print a document

      Insert page numbers to the document

      Insert clip art and pictures into the document

      Insert a diagram or chart into the document

      Format the document or  format items placed into the document such as:

      Change font size

      Bold, italicize and Underline text

      Change text color

      Change background color

      Use bullets and/or numbering

      Change document Theme

      Format the paragraphs

      Left Justify, Right Justify and Center Text

      Change line spacing      Use tools in Microsoft word such as:

      Spelling and grammar

      Language

      Templates

      Insert or draw a table into the document

 

Spreadsheet skills (Excel)

 

      Create new Excel document

      Open and existing Excel (Spreadsheet) document

      Save an organize spreadsheet documents on the computer

      Save Excel document as a Webpage

      Set up Excel Page

      Set Print Area

      Print Preview the document

      Print the document

      Use undo and redo

      Cut, copy, and paste information from and to the document

      Use find, replace and Go to… specific information in document

      Place a header and a Footer into the document

      Insert and Delete Rows and Columns

      Insert a Chart into the document

      Insert a picture from a file, camera, or scanner into the document

      Insert Clip Art into the document

      Insert a diagram into the document

      Insert a hyperlink into the document

      Format cells, rows, columns and sheet

      Format numbers and font

      Merge and align cells

      Format borders

      Correct Spelling in document

      Sort Data

      Change Font Size and Style

      Use Auto Sum key to add, subtract, multiply, divide, average and count

 

PowerPoint

 

      Open a PowerPoint document

      Save a PowerPoint document

      Save a PowerPoint document as a webpage

      Preview the webpage

      Set up the page

      Print preview

      Find and Replace items in the document

      View slide sorter and slide show

      Insert new slide

      Insert, pictures, videos, sounds into the PowerPoint presentation

      Insert a chart or a table

      Insert a text box

      Insert a hyperlink in the form of a picture or text

      Organize the PowerPoint slides using hyperlinks

      Format Slide Layout and Slide Design

      Format background color

      Correct Spelling in document

      Add animation to the slides

      Organize slideshow to include timings