|
|
|
Lesson 1
The following will be used to determine students grades on the finished Tally Sheet. The Quiz will be worth a max of 20 points. Two points will be removed for each incorrect answer. 18 points > =A, 16 points or > B, 14 points or > C, 12 points or > D, < 12 points F.
Grade for the Tally Sheet: 5 or < points F; 6 or more points D; 10 or > points C; 15 or > points B; 18 or > points A.
The grade from the Quiz and the Tally sheet will be added together than divided by two to determine the grade for lesson one, data collection. 18 points or more will be an A, 16 points or more will be a B, 14 points or more will be a C, 12 points or more will be a D, and less than 12 points will be an F.
This will be used to Grade the Tally Sheet.
| 1 point | 2 points | 3 points | 4 points | Total points |
| less than 6 variations | 6 or more variations | 8 or more variations | 10 or more variations | |
| Less than 100 tallies | 100 or more tallies | 120 or more tallies | 140 or more | |
| less than basic t/s | basic tally sheet | tally sheet neat/color | tally sheet n/c/creative | |
| needed help w/topic | topic accepted after several attempts. | ho hum topic/thinking not outside the box | unusual topic/showing thought and understanding | |
| does not meet deadlines | meets deadlines with teachers help | in early no help | in early/no help/outstanding or unusual work |
I will use a fudge factor for topics that lend themselves to have only 6 variations. For those I will need 160 tallies to make a "B", or 180 tallies to make an "A". For the topics with only 8 variations you will need 160 tallies to make an "A".
The following will be used to determine students grades on the finished bar graph. The Quiz will be worth a max of 20 points. Two points will be removed for each incorrect answer. 18 points > =A, 16 points or > B, 14 points or > C, 12 points or > D, < 12 points F.
Grade for the Bar Graph: 6 or < points F; 10 or less points D; 14 or < points C; 17 or < points B; 18 or > points A.
The grade from the Quiz and the Students Bar Graph will be added together than divided by two to determine the grade for lesson two, Bar Graph. 18 points or more will be an A, 16 points or more will be a B, 14 points or more will be a C, 12 points or more will be a D, and less than 12 points will be an F.
This will be used to Grade the Students Bar Graph.
| 1 point | 2 points | 3 points | 4 points | Total points |
| does not have all five parts of a graph | Bar graph has needed five parts | has all parts needed and neat used ruler to make | all of 3 and colorful | |
| bars not same width | visual attempt to make bars all the same width | 2 and bars proper used ruler to make | 3 and colorful | |
| less than basic b/g | basic over all neatness/it is a bar graph | 2 and neat/color overall appearance is correct | 3 and n/c/creative | |
| needed help with bar graph made little effort to find answer to questions | Graph starts with zero and incorporates grid numbers to fit data. | 2 and more | 3 and unusual topic/showing understanding of making a graph | |
| does not meet deadlines but has bar graph | meets deadlines with teachers help | in early no help | in early/no help/outstanding or unusual work |
The following will be used to determine students grades on the finished Excel Lesson. The Quiz will be worth a max of 20 points. Two points will be removed for each incorrect answer. 18 points > =A, 16 points or > B, 14 points or > C, 12 points or > D, < 12 points F.
Grade for the Excel lesson: 6 or < points F; 10 or less points D; 14 or < points C; 17 or < points B; 18 or > points A.
The grade from the Quiz and the Excel lesson will be added together than divided by two to determine the grade for lesson three. 18 points or more will be an A, 16 points or more will be a B, 14 points or more will be a C, 12 points or more will be a D, and less than 12 points will be an F.
This will be used to Grade the Excel Lesson 3.
| 1 point | 2 points | 3 points | 4 points | Total points |
| could not turn on machine | Open Excel and put data numbers | |||
| 4 or more mistakes on numbers from Data sheet | 3 mistakes on numbers from data sheet | 1 mistakes on numbers from data sheet | no mistakes on numbers | |
| 4 or more misspelled words typed in spread sheet | 3 misspelled words in spread sheet | 1 misspelled word in spread sheet | no misspelled words on spread sheet | |
| accepted work after several attempts | work accepted first attempt to turn in | |||
| does not meet deadlines | meets deadlines with teachers help | in early no help | in early/no help/outstanding or unusual work |
The following will be used to determine students grades on the finished Excel Lesson making Graphs. The Quiz will be worth a max of 20 points. Two points will be removed for each incorrect answer. 18 points > =A, 16 points or > B, 14 points or > C, 12 points or > D, < 12 points F.
Grade for the Graphs lesson four: 5 or < points F; 10 or less points D; 15 or < points C; 20 or < points B; 21 or > points A.
The grade from the Quiz and the Excel Lesson making graphs will be added together than divided by two to determine the grade for lesson four, making graphs. 18 points or more will be an A, 16 points or more will be a B, 14 points or more will be a C, 12 points or more will be a D, and less than 12 points will be an F.
This will be used to Grade the Make Graphs Lesson 4.
| 1 point | 2 points | 3 points | 4 points | Total points |
| Does not open excel and get lesson three work | Open Excel brings up lesson three work | only two of three title name x axis title name y axis |
All of three Includes different colors on each bar of the graphs |
|
| Gets extra cells | Select data to be Graphed | same as above | same as above | |
| Can't open Graph Program | Opens Graphs program | tally sheet neat/color | tally sheet n/c/creative | |
| Cant pick graph needed | Choose graph needed for data | makes two extra graphs of different types | Makes five different graphs | |
| does not meet deadlines | meets deadlines with teachers help | in early no help | in early/no help/outstanding or unusual work |
The following will be used to determine students grades on the finished Lesson five written report with Microsoft Word. The Quiz will be worth a max of 20 points. Two points will be removed for each incorrect answer. 18 points > =A, 16 points or > B, 14 points or > C, 12 points or > D, < 12 points F.
Grade for the Written report: 5 or < points F; 10 or less points D; 15 or < points C; 20 or < points B; 21 or > points A.
The grade from the Quiz and the written report will be added together than divided by two to determine the grade for lesson five. 18 points or more will be an A, 16 points or more will be a B, 14 points or more will be a C, 12 points or more will be a D, and less than 12 points will be an F.
This will be used to Grade Microsoft Lesson 5.
| 1 point | 2 points | 3 points | 4 points | Total points |
| same as below | Opens MSW And Excel | moves between the two programs | easily moves between the two programs | |
| same as below | Resize graphs/moves | resize to reasonable size | can move axis of words in Excel | |
| same as below | copy and paste with direct direction | copy and past with some help | copy and paste no help | |
| needed help writing cutting pasting, resizing | basic description of data and how to do each lesson | ho hum topic/thinking not outside the box on written material but all material needed covered | unusual topic/showing thought and understanding
expands on topic covering the material in written form
|
|
| does not meet deadlines | meets deadlines with teachers help | in early no help | in early/no help/outstanding or unusual work |
The scores from the five lessons will be added together to get a final grade. 90 > A; 80 > B; 70 > C; 60 > D; < 60 is an F.
