1 Shijina Jayaprasad EDIT-235 Excel Gradebook Project Submitted by Shijina Jayaprasad 2 Shijina Jayaprasad Table of Contents Overview…………………………………………………………………………………3 Problem Statement……………………………………………………………………….4 Target Audience………………………………………………………………………….4 Goal of the course………………………………………………………………………...4 Course Objectives………………………………………………………………………...4 Task Analysis Pyramid…………………………………………………………………...5 Course Map/Topic Map…………………………………………………………………..6 Instructional Planning Grid………………………………………………………………12 Proposed Media and Delivery Method…………………………………………………..13 Constraints……………………………………………………………………………….13 Required Materials……………………………………………………………………….13 Prototype Lesson………………………………………………………………………...14 Description of motivational strategies…………………………………………………...17 Peer Reviews…………………………………………………………………………….17 3 Shijina Jayaprasad Overview This project is aimed to develop a self-directed course for teachers at Birdville Elementary School. The course will train teachers in using Microsoft Excel 2007 based gradebook. The principle of Birdville Elementary School wants all teachers to use MS Excel to keep track of student grades. These excel files will then be exported to the new student database which was implemented recently. After preliminary needs assessment it was ascertained that: • Each classroom has a single computer connected to a LAN, as well as a copy of MS Excel(There is no computer lab on campus) • The principle wants the teachers to spend no more than one-two hours on the training • There is no funding available for instruction-led training (ILT) to use the Excel based gradebook • Teachers will complete the training during office hours or study hall • The library has three computers with MS Excel software • Most teachers use MS Word on a regular basis, but majorities still use pencil and paper to compute grades. After weighing the pros and cons of the needs assessment a task analysis was conducted to decide the course plan. It was decided that the course will have three modules: I. Introduction to MS Excel basics II. Introduction to gradebook template III. Working with gradebook template The treatment and ISD strategies were then ascertained. It was decided that there will be a mastery quiz at the end of the module. A pedagogical agent will be used to take the learners through the course. Learning objectives were defined for each module. A prototype lesson will be created as the first deliverable to the principle of Birdville elementary school. Finally two peer reviews were conducted for the prototype lesson. 4 Shijina Jayaprasad Problem Statement Birdville Elementary School has implemented a new database. MS Excel will be used to export files into the database as it ODBC compatible. Teachers have to be taught to use MS Excel to maintain a student gradebook which will then be exported to the database. Condition: Teachers do not know to use MS Excel to maintain student record and export it to the student database. Criterion: Teachers should be able to maintain gradebook using MS excel and export it to the student database. Possible Causes: MS Word is preferred over MS Excel to maintain student grades. Majority of teachers use pencil and paper to compute grades. Target Audience Teachers at Birdville Elementary School Goal of the Course The goal of the course is to train teachers to use MS Excel to maintain student records. Course Objectives At the end of this course teachers will be able to: • Identify the MS Excel Interface • Demonstrate the basic functionalities of MS Excel • Employ Excel gradebook to maintain student records 5 Shijina Jayaprasad Task Analysis Pyramid Introduce Excel Basics Introduce Gradebook Template Explain how to work with Excel Gradebook 6 Shijina Jayaprasad Course Map Using Excel to maintain student grades Lesson I Excel Basics A. Interface 1. Ribbons 2. Cells 3. Worksheets B. Working with worksheets 1. Renaming worksheets 2. Adding/Deleting worksheets C. Working with cells 1. Adding and deleting rows and columns 2. Entering data in cells 3. Deleting cell data and clearing formats D. Saving and Printing file 1. Exporting in csv format 2. Saving excel file 3. Printing Lesson II Introduction to Gradebook template A. Gradebook interface 1. Student name and ssn column 2. Total points/percentage/grade columns 3. Class average column 4. Homework, Quiz and Test scores table Lesson III Working with gradebook A. Entering student data and scores B. adding or deleting rows and columns C. Saving and printing file 1. Exporting in csv format 7 Shijina Jayaprasad Task Analysis Lesson 1 Excel basics Lesson I Excel Basics Interface Working with worksheets Ribbons Cells Worksheets Renaming worksheets Adding/ Deleting worksheets Working with cells Adding and deleting rows and columns Entering data in cells Deleting cell data and clearing formats Saving and Printing file Exporting in csv format Saving excel file Printing 8 Shijina Jayaprasad Topic 1 Interface Interface Ribbons Cells Worksheets Topic 2 Working with worksheets Working with worksheets Renaming worksheets Adding/ Deleting worksheets 9 Shijina Jayaprasad Topic 3 Working with cells Working with cells Adding and deleting rows and columns Entering data in cells Deleting cell data and clearing formats Topic 4 Saving and Printing file Saving and Printing file Exporting in csv format Saving excel file Printing 10 Shijina Jayaprasad Lesson 2 Introduction to Gradebook Template Lesson II Introduction to Gradebook template Gradebook interface Student name and ssn cloumn Total points/ percentage/ grade columns Class average column Homework, Quiz and Test scores table 11 Shijina Jayaprasad Lesson 3 Working with gradebook Saving and printing file Entering student data and scores adding or delting rows and columns Exporting in csv format Lesson III Working with gradebook Printing file 12 Shijina Jayaprasad Instructional Planning Grid Tasks Instructional Objectives Performance Content Matrix Initial Presentation Generative Strategy Assessment Items Explain the Excel Interface Teachers will be able to identify the components of Ms Excel Concept The Excel screen will be displayed and the components and its uses will be explained. Teachers will be able to identify and recall the components of Excel sheet. Multiple choice question, True or False Show how to work with worksheets Teachers will be able to add, delete and modify worksheets Concept and Apply The CBT will show the procedure for adding, deleting and modifying worksheets Teachers will be able to work with worksheets Multiple choice question, True or False Show how to work with cells Teachers will be able to add, delete and enter data in cells. Concept and Apply The CBT will show the procedure for adding, deleting and entering data in cells. Teachers will be able to work with cells Multiple choice question, True or False Show how to print and save MS Excel files in .csv files Teachers will be able to print and save MS Excel files in .csv format Concept and Apply The CBT will show the procedure for printing and saving files in .csv format Teachers will be able to print and save MS Excel files Multiple choice question, True or False 13 Shijina Jayaprasad Proposed media and Delivery Method The course will be delivered in a CD. Constraints The following constraints were recorded: • Each classroom has a single computer connected to a LAN, as well as a copy of MS Excel. • There is no funding available for instructor-led training (ILT) to use the Excel based gradebook. • Most teachers use MS Word on a regular basis, but a majority still uses pencil and paper to compute grades. Required Materials The required materials include: • Computer with CD drive. • Windows Vista operating system with MS Excel 2007 (for practice) 14 Shijina Jayaprasad Prototype Lesson Introduction Birdville Elementary School has implemented a new database. MS Excel will be used to export files into the database as it ODBC compatible. Teachers have to be taught to use MS Excel to maintain a student gradebook which will then be exported to the database. The first lesson aims at providing a basic introduction to MS Excel 2007. Objectives At the end of this lesson you will be able to: • Identify the MS Excel Interface • Employ the procedures of working with MS Excel Worksheets and Cells • Print and Save MS Excel files Duration 15-20 minutes Equipment Computer with Windows Vista, MS Excel 2007, Excel Simplified CD Overview The first lesson gives a basic introduction to MS Excel 2007. It includes four topics: I. Interface II. Working with worksheets III. Working with cells IV. Saving and Printing file The lesson will be created in Macromedia Captivate 3 and a pedagogical agent will be used to take the learners through the course. 15 Shijina Jayaprasad Procedures Topic 1 Interface This lesson will introduce the MS Excel 2007 interface. The learner will be able to rollover the the components of the interface for more information. Topic 2 Working with Worksheets Steps Actions Example Renaming Worksheets Inserting Worksheets Click on Sheet1 tab at the bottom of the window
Click Rename Click on Home tab
Select Insert menu
Click on Insert Sheet Topic 3 Working with Cells Steps Actions Example Inserting Rows and Columns Select Row/Column
Click on Insert menu
Select add 16 Shijina Jayaprasad row/column Topic 4 Saving and Printing Files Steps Actions Example Saving File Printing File Saving file Click on Microsoft Office button
Select Save As
In the Save As dialog box enter file name
Click Save As Printing file Printing File Click on Microsoft Office button
Select Print option 17 Shijina Jayaprasad Description of Motivational Strategies Names of teachers successfully completing the course will be displayed on the school notice board as a mark of appreciation. Inputs from these teachers will be taken for course feedback for further improvement. Peer Reviews Review 1- By Swathe Armani • Graphic Design and Layout The layout is interesting; I liked the talking PC, which grabbed my attention. • Relevance of instructional approach to course objectives The course objectives were met as basic Excel applications were demonstrated. • Relevance and applicability of Assessments to course objectives The assessments were generic and tested the overall understanding of the module. • Use of engaging and appropriate instructional strategies and media The use of instructions and rollover text was good. • Use of feedback, motivation, cueing and prompting Liked the summary at the end of the module • Regular opportunities for practice beyond basic recall I think learners can recall the information given in this course. • Application of visual literacy/dual coding (multimedia principle) Good use of computer that talks. Review 2- By Vidya Chichilli • Graphic Design and Layout Good use of colors and animation • Relevance of instructional approach to course objectives I think the course objectives were easily met. • Relevance and applicability of Assessments to course objectives I think that the assessment could have been made more interactive, I had taken one online course which has assessments with user interaction, it would have been appropriate for this course. • Use of engaging and appropriate instructional strategies and media 18 Shijina Jayaprasad I don’t know about the instructional strategies but I think that the overall approach is good. • Use of feedback, motivation, cueing and prompting The assessment feedback and review sections were good. • Regular opportunities for practice beyond basic recall I think the procedures shown to add sheets etc, will be recalled by the learner and put to practice. • Application of visual literacy/dual coding (multimedia principle) Talking about multimedia, the use of text and pictures add to the visuals.