Entries in CODE77 (13)

Saturday
Mar082008

Beginning rubric 6 - databases

This a continuation of the 2008 revision of the CODE77 rubrics - Basic level. An introduction is here.

VI. Database use (1995)
Level 1 I do not use a database, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2 I understand the use of a database and can locate information within one that has been pre-made. I can add or delete data in a database.
Level 3 I use databases for personal applications. I can create an original database - defining fields and creating layouts. I can find, sort, and print information in layouts which are clear and useful to me.
Level 4 I can use formulas with my database to create summaries of numerical data. I can use database information to do mail merge in a word processing document. I use the database not only for my work, but have used it with students to help them improve their own data keeping and analysis skills.

VI. Database use (NETS I.A., I.B., V.C.) (2002)
Level 1 I do not use a database, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2 I understand the function of a database and can locate information within one that has been pre-made. I can add or delete data in a database.
Level 3 I use databases for professional applications. I can create a simple original database that has a professional application such as an address book by defining fields and creating layouts. I can find, sort and print information that is useful to me. I can use my building’s student information system database to find information about students in my class.
Level 4 I can use formulas with my database to create summaries of numerical data. I can use database information to do mail merge in a word processing document. I use the database not only for my work, but have used it with students to help them improve their own data keeping and analysis skills.

VI. Database use (NETS ?) (2008)
Level 1 I do not use a database, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2 I understand the function of a database and can locate information within one that has been pre-made. I can add or delete data in a database.
Level 3 I use databases for professional applications. I can create a simple original database that has a professional application such as an address book by defining fields and creating layouts. I can find, sort and print information that is useful to me. I can use database information to do mail merge in a word processing document. I can use my building’s student information system database to find information about students in my class.
Level 4 I can use formulas with my database to create summaries of numerical data. I can use database information to do mail merge in a word processing document. I use the database not only for my work, but have used it with students to help them improve their own data keeping and analysis skills. I can use cloud-based databases for collaborative and shared work.

Hmmm, again not many changes here. I see fewer teachers creating databases and more using already created ones. Hey, I seem to be using a database less and less myself. (I still love FileMakerPro!) Should database creation even remain a "basic" computer competency?

Other time database tasks? Next up: VII. Graphics and digital image use

Wednesday
Mar052008

Beginning rubric 5 - spreadsheets

This a continuation of the 2008 revision of the CODE77 rubrics - Basic level. An introduction is here.

V. Spreadsheet use (1995)
Level 1 I do not use a spreadsheet, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2 I understand the use of a spreadsheet and can navigate within one. I can create a simple spreadsheet which adds a column of numbers.
Level 3 I use a spreadsheet for several applications. These spreadsheets use labels, formulas and cell references. I can change the format of the spreadsheets by changing column widths and text style. I can use the spreadsheet to make a simple graph or chart.
Level 4 I use the spreadsheet not only for my work, but have used it with students to help them improve their own data keeping and analysis skills.

V. Spreadsheet use (NETS I.A., I.B., V.C.) (2002)
Level 1 I do not use a spreadsheet, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2 I understand the use of a spreadsheet and can navigate within one. I can create a simple spreadsheet that adds a column of numbers.
Level 3 I use a spreadsheet for several professional applications such as keeping a budget or analyzing student data. My spreadsheets use labels, formulas and cell references. I can change the format of the spreadsheets by changing column widths and text style. I can use the spreadsheet to make a simple graph or chart.
Level 4 I can import a spreadsheet into a word processing document or presentation program when needed. I use the spreadsheet not only for my work, but have used it with students to help them improve their own data keeping and analysis skills.

V. Spreadsheet use (NETS ?) (2008)
Level 1 I do not use a spreadsheet, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2 I understand the use of a spreadsheet and can navigate within one. I can create a simple spreadsheet that adds a column of numbers. I understand the basic types of data that can be placed in cells: labels, numbers, formulas, and references.
Level 3 I use a spreadsheet for several professional applications such as keeping a budget or analyzing student data. My spreadsheets use labels, formulas and cell references. I can change the format of the spreadsheets by changing column widths and text style. I can use the spreadsheet to make a simple graph or chart. I can import and export data from a spreadsheet. I understand the difference between a workbook and a worksheet, and can create a workbook with multiple worksheets.
Level 4 I can import or link a spreadsheet into a word processing document or presentation program when needed. I can custom design a variety of graphs and charts. use the spreadsheet not only for my work, but have used it with students to help them improve their own data keeping and analysis skills. I can use cloud-based spreadsheets for collaborative and shared work.

This is an interesting rubric since in my experience, spreadsheets at their most basic level have changed very little since the days of Visicalc in the early '80s. It is among the easiest, most powerful, most feared and most underutilized tools in education. Or maybe I am just a latent math teacher.

Other time spreadsheet tasks? Next up: VI. Database use

Thursday
Feb212008

Beginning rubric 4 - word processing

This a continuation of the 2008 revision of the CODE77 rubrics - Basic level. An introduction is here.

III.     Word processing (1995)
Level 1    I do not use a word processor, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2    I occasionally use the word processor for simple documents which I know I will modify and use again. I generally find it easier to hand write or type most written work I do.
Level 3    I use the word processor for nearly all my written professional work: memos, tests, worksheets, and home communication. I can edit, spell check, and change the format of a document. I can paginate, preview and print my work. I feel my work looks professional.
Level 4     I use the word processor not only for my work, but have used it with students to help them improve their own communication skills.
 

IV. Word processing (NETS I.A., I.B. V.C.) (2002)
Level 1     I do not use a word processor, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2     I occasionally use the word processor for simple documents that I know I will modify and use again. I generally find it easier to handwrite or type most written work I do.
Level 3     I use the word processor for nearly all my written professional work: memos, tests, worksheets, and home communication. I can edit my document using commands like copy and paste, find, undo, and save as. I can spell check, and change the format of a document. I can paginate, preview and print my work. I can use tables within my documents. I feel my work looks professional.
Level 4     I can save my document as a text or rtf document so it can be opened by others who may use the same word processor I use. I take advantage of collaborative writing/editing environments when available. I use the word processor not only for my work, but have used it with students to help them improve their own communication skills.

 V. Word processing (NETS ?) (2008)
Level 1     I do not use a word processor, nor can I identify any uses or features it might have which would benefit the way I work.
Level 2     I occasionally use the word processor for simple documents that I know I will modify and use again. I generally find it easier to handwrite or type most written work I do.
Level 3     I use the word processor for nearly all my written professional work: memos, tests, worksheets, and home communication. I can edit my document using commands like copy and paste, find, undo, and save as. I can spell check, and change the format of a document. I can paginate, preview and print my work. I can use tables within my documents and insert graphics. I can save my document as a .pdf file. I feel my work looks professional.
Level 4     I can save my document as a text or rtf document so it can be opened by others who may not use the same word processor I use. I take advantage of collaborative writing/editing environments when available, including online word processors and wikis. I can suggest an open source word processor for those who wish or need to use one. I use the word processor not only for my work, but have used it with students to help them improve their own communication skills.

Other word processing tasks? Next up: V. Spreadsheet use