Computer Literacy ~ Assessing Assessments ~ Curriculum Map
EdPsy590ASA ~ Alternative Student Assessment
Instructor ~ Dr. Katherine Ryan
KRISTY SANDS

 

Computer Literacy ~ Curriculum Map
Units
Parts of the Computer
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Internet
Standards

IL Middle School Science Goal 13: Understand the relationships among science, technology & society in historical & contemporary contexts.

  • 13B.Know & apply concepts that describe the interactions between science, technology & society.

IL Middle School Language Arts Goal 3: Write to communicate for a variety of purposes.

  • 3A. Use correct grammar, spelling, punctuation, capitalization, & structure.
  • 3B. Compose well-organized & coherent writing for specific purposes & audiences.
  • 3C. Communicate ideas in writing to accomplish a variety of purposes.

IL Middle School Language Arts Goal 5: Use the language arts to acquire, assess, & communicate information.

  • 5C. Apply acquired information, concepts & ideas to communicate in a variety of formats.

IL Middle School Mathematics Goal 6: Demonstrate & apply a knowledge & sense of numbers.

  • 6A. Demonstrate knowledge & use of numbers & their representations in a broad range of theoretical & practical settings.
  • 6C. Compute & estimate using mental mathematics, paper-and-pencil methods, calculators, & computers.

IL Middle School Mathematics Goal 7: Estimate, make & use measurements of objects, quantities & relationships & determine acceptable levels of accuracy.

  • 7C. Select & use appropriate technology, instruments & formulas to solve problems.

IL Middle School Language Arts Goal 3: Write to communicate for a variety of purposes.

  • 3A. Use correct grammar, spelling, punctuation, capitalization, & structure.
  • 3B. Compose well-organized & coherent writing for specific purposes & audiences.
  • 3C. Commun-icate ideas in writing to accomplish a variety of purposes.

IL Middle School Language Arts Goal 4:Listen & speak effectively in a variety of situations.

  • 4B. Speak effectively using language appropriate to the situation & audience.

IL Middle School Language Arts Goal 5: Use the language arts to acquire, assess, & communicate information.

  • 5A. Locate, organize, & use information from various sources to answer questions, solve problems, & communicate ideas.
  • 5B. Analyze & evaluate information from various sources.
  • 5C. Apply acquired information, concepts & ideas to communicate in a variety of formats.
Content

Use & understand computer-related terms:

  • Troubleshooting
  • Desktop
  • Network
  • Software
  • Hardware
    • Keyboard
    • Mouse
    • Monitor
    • Printer
    • Hard drive
    • Disk Drives
    • Modemo
    • CPU
    • RAM
    • Mother-board
    • Power supply

Use & understand Word-related terms:

  • Word processing
  • Document
  • Cursor
  • Menubar
  • Toolbar
  • File window
  • Status bar

Use & understand Excel-related terms:

  • Spreadsheet
  • Cell selector
  • Cell
  • Column
  • Row
  • Range
  • Formula
  • Cell address
  • Range address
  • Name box
  • Formula bar
  • Autoformat
  • Merge & Center
  • Autosum

Use & understand PowerPoint-related terms:

  • Slideshow
  • Design
  • Layout
  • Transition
  • Animation
  • Buttons

Use & understand Internet-related terms:

  • Internet
  • Browser
  • Search engine
  • URL
  • Domain name
  • Hyperlink
  • Image map
  • E-mail
  • Emoticon
  • Acronym
  • Boolean search
  • Copyright
  • Citation
  • Plagiarism
  • Netiquette
Skills

Identify basic computer hardware components

Troubleshoot common problems

Demonstrate proper use & care of technology

Create & save a new document

  • Use save & save as
Open, view, & print documents
  • Use print preview
  • Print entire file or selected parts
Format documents
  • Justify text
  • Select font style & size
  • Line spacing
  • Select page orientation
  • Margins
  • Use headers, footers, & pagination

Edit text

  • Cut, copy, paste & deleting text
  • Use spell check & thesaurus
  • Use find & replace

Using desktop publishing techniques

  • Columns
  • Tables
  • Graphics

Creating & saving spreadsheets

  • Identify intended use
  • Specify data organization
  • Determine columns & rows
  • Set cell attributes
  • Create simple calculation formulas
  • Enter & edit data

Retrieving data§ Sort data

  • Create charts
  • Create graphs
  • Print spreadsheets

Editing data

  • Insert column or row
  • Delete column or row
  • Use fill down/across
  • Save updated spreadsheet
  • Add colors & borders to cells

Create & save a slideshow

  • Apply basic principles of presentation layout
  • Enhance slides with graphics, sound, & effects
  • Choose slide arrangement, transitions, & animations
Present slideshow to intended audience

Use effective search parameters

Evaluate the value of Internet content based on URL, domain name, home page, date of creation or update, author, & links

  • Accuracy
  • Authority
  • Objectivity
  • Up-to-date
  • Completeness
Use information obtained from the Internet appropriately
Assessments

Project: Create a poster of the computer parts

Performance/Oral Presentation: Troubleshoot common computer problems & explain what they checked for & why

Checklist/Performance: Students are given a list of skills & concepts that are covered in class, when they use or apply the skill or concept they demonstrate it for me & I initial their checklist

Project: Create a “How to…” manual about a feature from Word

Project/Self-Reflection: Create a table & graph of trimester grades & note 3 strengths & 3 weaknesses in Excel

Project/Checklist: Create a calendar for the current month using 6 features from Excel

Project/Presentation: Creates a slideshow about themselves to present to the class, a peer-evaluation is used as well

Project/Self-Reflection: Using Word, Excel, &/or PowerPoint students will plan a vacation using Internet resources & will reflect on their role of the project & knowledge of the Internet

Travel Through The Web

 

Areas of Weakness (Gaps):

Technology changes as rapidly as middle school students modify their styles, friends, and minds so there will certainly always be gaps in the curriculum. It is important however to be aware of the constant transformations that are occurring and to be flexible and willing to adapt as needed. In this particular curricular area there are other obstacles that may cause disruptions in the flow of everyday instruction and activities. It is inevitable that there will be technical difficulties, unavailability or inaccessibility of needed resources, and again flexibility and adaptability are necessary in order to avoid those obstacles without abandoning the curriculum.

Often because of time restriction I do not get to fully cover all areas of the curriculum. I would like to integrate more of the units together in order to cover everything. For example, the Internet could easily be used in conjunction with any of the other units. Then if time allows I can cover the topics in more detail. Frequently the programs that I teach are not used in isolation, but rather in unison so it only makes sense to provide more authentic instruction and assessment focusing on this particular learning need.

It was recently brought to my attention that I need to incorporate multiple choice test questions in my assessment practices in order to prepare the students for the state achievement tests. Although I see the advantages of using this method of assessment, I feel that this method is used so heavily in other classes that students need exposure to other forms. By the time students reach middle school they are experts at paper and pencil tests and need more experience with alternative methods of assessment in order to prepare them for high school and beyond. In this situation I feel that the benefits of my lack of use of multiple choice testing prevails the shortcomings.

 

Home
KWL
Assessments

 

Last updated: 04.05