Electronic Gradebook and Analysis Essay Assignment Paper
Electronic Gradebook and Analysis Essay Assignment Paper
Electronic Grade Book
EDF 4444
You will track data from fictional students in the class using Excel or other format. Follow the course syllabus for the grading scheme to determine an evaluation of the students’ and class’s success in mastering course objectives. Be sure to attach the rubric to your project. Electronic Gradebook and Analysis Essay Assignment Paper
Components
For this project you will turn in 3 parts. Part 1 will contain your spreadsheet and grade calculations. Part 2 will be a Word document with the required components. Part 3 will address student performance.
ORDER HERE A PLAGIARISM-FREE PAPER HERE
Part 1 Excel Spreadsheet/Table
You will create an Excel spreadsheet or your first data table, listing each student’s name in rows on the left hand column and providing spaces for each of the raw scores for assignments and then converted to letter grades (rounded to the nearest whole number) in columns for the EDF 4444 class. Be sure to compute the final letter and number grade (as found in grading scale below and rounded to the nearest whole number) for each student and include in your spreadsheet/table. You will find the students and their grades on the attached sheet. Put names in alphabetical order according to their last names.
Part 2 Class Statistics Word Document/Tables
(1) Provide a second table calculating the class mean (round to the nearest whole number), median, and mode (include all) for each assignment (listed in the order presented in the task). You may wish to add this data on your excel spreadsheet/table. Present the mean, median, and mode as a raw score and letter grade.
(2) Then provide a brief analysis of these three statistics (measures of central tendency) for each assignment. Do not simply repeat the numbers calculated but analyze what the statistics mean (e.g., mastery, partial mastery, non-mastery, etc.) for each assignment. Do the measures of central tendency represent mastery? Explain why or why not. Also consider addressing range, skew, outliers or other information as necessary. Research what it suggests if the mean and median are the same, etc. Electronic Gradebook and Analysis Essay Assignment Paper
(3) Provide a third table aligning each of the tasks with the objectives they are to measure – see the course syllabus for this information about tasks and objectives.
(4) Using the information from your tables, now make judgments about the overall class mastery of each course objective (see objectives below). Organize your discussion around mastery of the four course objectives and the course tasks that are aligned with each as provided in our class syllabus using the table you have just created. I should see 4 separate paragraphs – each one focusing on a course objective. Be sure to use assessment concepts correctly. Electronic Gradebook and Analysis Essay Assignment Paper
Part 3 Analysis on Student Mastery
Pick two students to analyze and report on mastery. Using the information in the syllabus regarding assignments and alignment to each of the course objectives, provide a report on the students’ mastery of each of these four objectives. Provide 2-3 recommendations for overall continued growth in the subject area and/or remediation activities regardless of how well a student has mastered the objectives.
Course Objectives:
The teacher candidate will be able to:
- Develop instructional plans based upon a variety of assessment data.
- Identify assessments that produce valid and reliable results.
- Interpret and analyze assessment data to identify student needs and instructional differentiation.
- Create formative and summative, informal and formal, performance, authentic, and portfolios aligned to instructional objectives. Electronic Gradebook and Analysis Essay Assignment Paper
Student Grades
| Jay Gatsby
Midterm Exam 49 Final Exam 43 Case Study 50 Test Writing 38 Alternative Assessment 50 Electronic Grade Book 30 Participation 50
|
Gregor Samsa
Midterm Exam 45 Final Exam 42 Case Study 45 Test Writing 40 Alternative Assessment 48 Electronic Grade Book 30 Participation 50 Electronic Gradebook and Analysis Essay Assignment Paper
|
| Holden Caulfield
Midterm Exam 38 Final Exam 39 Case Study 38 Test Writing 35 Alternative Assessment 45 Electronic Grade Book 28 Participation 34
|
Elizabeth Bennet
Midterm Exam 48 Final Exam 41 Case Study 47 Test Writing 37 Alternative Assessment 49 Electronic Grade Book 30 Participation 45 |
| Atticus Finch
Midterm Exam 43 Final Exam 39 Case Study 46 Test Writing 36 Alternative Assessment 48 Electronic Grade Book 28 Participation Electronic Gradebook and Analysis Essay Assignment Paper 45 |
Jane Eyre
Midterm Exam 39 Final Exam 40 Case Study 48 Test Writing 35 Alternative Assessment 44 Electronic Grade Book 28 Participation 30
|
| Participation | 50 |
| *2 Exams (53 pts. for Midterm and 47 pts. for Final) | 100 |
| *Test Writing
|
40 |
| *Performance (Alternative) Assessment and Scoring Tool
|
50 |
| * Case Study Project | 50 |
| * Electronic Grade Book | 30 |
| TOTAL | 320 |
| GRADE | PERCENTAGE |
| A | 94-100% |
| A- | 91-93% |
| B+ | 88-90% |
| B | 85-87% |
| B- | 82-84% |
| C | 78-81% |
| D | 70-77% |
| F | below 70% |
Electronic Grade Book Rubric
Name______________________________________________________________________________
| Mastery | Partial Mastery | Minimal Mastery | ||
| Accuracy of Data Tables
(6 points) |
All three data tables are correct and include all information.
(6 points) |
The data tables may have missing information.
(5 points) |
The data tables lack most information.
(4-0 points) |
|
| Calculations of Class Statistics
(6 points) |
The class statistics are calculated correctly. Electronic Gradebook and Analysis Essay Assignment Paper
(6 points) |
The class statistics are calculated somewhat correctly.
(5 points) |
The class statistics are calculated incorrectly.
(4-0 points) |
|
| Analysis
Of Class Statistics /Judgments
(12 points)
|
The analysis of the statistics for each task is accurate and judgments about mastery of course objectives are well developed. Assessment concepts are used correctly.
(12-10 points) |
The analysis of the statistics for each task is somewhat appropriate and/or judgments about mastery of course objectives partially developed.
Assessment concepts used are partially correct. (9-5 points) |
The analysis of the statistics for each task is inappropriate and/or judgments about mastery of course objectives lack development.
Assessment concepts used are incorrect.
(4-0 points) |
|
| Analysis on Students’ Performance
(6 points) |
The analysis on students’ mastery is aligned to course objectives and contains 2-3 appropriate recommendations for future work.
(6-5 points) |
The analysis on students’ mastery is somewhat aligned to course objectives and/or provides less than 2 and/or sketchy recommendations for future work.
(4-3 points) |
The analysis on students’ mastery lacks the inclusion of two students, alignment to course objectives, and/or appropriate recommendations for future work.
(2-0 points) Electronic Gradebook and Analysis Essay Assignment Paper |
