Docstoc

Gradebook Template

Document Sample
Gradebook Template Powered By Docstoc
					How to Use the Excel
Gradebook Template

EDIT 235 Skills-Based
Instructional Project
Minta Peterson
Table of Contents
      Development of Instruction..........3-13
      Actual Instructional Material…...14-24
      (Step-by-step guide)




Minta Peterson – EDIT 235 – Fall 2004
Overview / Scope
      Birdville elementary School is
      implementing a new student database.
      The principal has decided that she wants
      all teachers to use the database to keep
      track of grades.
      Each teacher’s gradebook will be imported
      into the database and associated with
      student records.
Minta Peterson – EDIT 235 – Fall 2004    Page 3 of 24
Course Goal & Objectives
Through a self-paced method, the overall goal of this course is to teach
the essential concepts and steps in order to use an Excel gradebook
template to enter student grades.


Using one of the computers which has Excel, at the end of the
instruction the instructor will be able to:
  Save the gradebook template file from email,
  open the file,
  enter in the student data,
  save the file as comma-delimited file, and
  email the file to tech support
With no reported errors from tech support.

Minta Peterson – EDIT 235 – Fall 2004                         Page 4 of 24
Target Audience
Target Audience                         Implications

All teachers at Birdville Elementary Most likely a variety of technical
School.                              skill levels & learning styles.

Most of the teachers use MS Word Should not need to cover
on a regular basis.              computer or windows basics.

A majority still use pencil and         Must explain basic purpose and
paper to compute grades.                concepts of Excel.




Minta Peterson – EDIT 235 – Fall 2004                           Page 5 of 24
Constraints
      The database will not be available over the school’s
      intranet, but they are connected to a LAN (which I
      assume has an email system), so the teachers may
      need to learn how to download and send the file as an
      attachment via email.
      As mentioned before, there is no funding available for
      instructor-led training.
      A majority of the teachers still use pencil and paper to
      compute grades, so a lot of basic concepts and
      procedures on Excel will be necessary.



Minta Peterson – EDIT 235 – Fall 2004                   Page 6 of 24
Delivery Method & Media
Given that:                             Given that:
                                         When teachers are trying to
 There is no funding available           learn the Excel gradebook, the
 for instructor-led training, and        monitor will be occupied with
 Each classroom has a                    displaying the Excel gradebook
                                         template, and
 computer with a copy of Excel
                                         Any additional windows (i.e. of
 and the library has three               of instructions) would reduce
 computers with Excel,                   the view of the gradebook and
                                         could cause confusion
The Delivery Method will be:            The Media will be:

Self-paced                              A printed step-by-
                                         step guide.
Minta Peterson – EDIT 235 – Fall 2004                           Page 7 of 24
Task Analysis Pyramid
                                                          Using an Excel
                                                        Gradebook Template
               Lesson 1                   Lesson 2                                 Lesson 3           Lesson 4


               What is Excel?            Download template          Open & edit template      Save & send file



                A spreadsheet           Save in correct folder          Edit and undo         Save copy of file



            Cells. intersection of…     Save email attachment         Type in information     Save as CSV file



            Automatic calculations      Use mouse & keyboard                 Open file          What is CSV?



                  Templates               Turn on computer               Open Excel           Send file via email



                                                                         Basic typing

        Prerequisites




Minta Peterson – EDIT 235 – Fall 2004                                                                     Page 8 of 24
Topic Outline (Lesson 3 – Open & Edit Template / File)




Minta Peterson – EDIT 235 – Fall 2004            Page 9 of 24
Instructional Planning Guide
Task                  Type of           Objective            Assessment         Instructional   Instructional         Practice
                      Learning                               Method             Approach,       Media                 Exercises
                                                                                Methods, &
                                                                                Generative
                                                                                Strategies

Open Excel / File     Concepts,         Learner will be      If learner         Presentation:   Tutorial (Printed     Learner performs
template              procedure         able to open         performs            Overview       step-by-step          all of the steps
                                        Excel program        objective, it is    Concepts       guide which           indicated in the
                                        and open             assumed that                       includes text,        printed step-by-
                                        Gradebook Excel      they are able to    Definitions    screenshots, and      step guide.
                                        template file        identify and        Examples       callouts)             Practice occurs
                                                             comprehend          Analogies                            because most
                                                             concepts and       Activities:                           tasks need to be
                                                             procedure.          Action steps                         repeated several
                                                                                                                      times.
                                                                                 Practice


Select & edit         Concepts,         Learner will be      If learner         Presentation:   Tutorial (Printed     Learner performs
cells / enter data    procedure         able to select,      performs            Overview       step-by-step          all of the steps
                                        edit, & enter data   objective, it is    Concepts       guide which           indicated in the
                                        into cells           assumed that                       includes text,        printed step-by-
                                                             they are able to    Definitions    screenshots, and      step guide.
                                                             identify and        Examples       callouts)             Practice occurs
                                                             comprehend          Analogies                            because most
                                                             concepts and       Activities:                           tasks need to be
                                                             procedure.          Action steps                         repeated several
                                                                                                                      times.
                                                                                 Practice


Minta Peterson – EDIT 235 – Fall 2004                                                                               Page 10 of 24
Required Materials
      Computer with Excel software
      Computer connected to LAN (for email
      access)
      Current grade sheet of student’s social
      security number and grades




Minta Peterson – EDIT 235 – Fall 2004     Page 11 of 24
Prototype Lessons
While the assignment only asked for 1
 prototype, I did 2 lessons, because lesson
 1 was good practice for concepts, while
 lesson 3 was good practice for procedures.




Minta Peterson – EDIT 235 – Fall 2004   Page 12 of 24
Reflections
      Even though instructor-led training is not an
      option, it may not be necessary anyways. Self-
      paced learning may be sufficient.
      Design the training materials around the needs
      of the learner, not just the tool.
      Spending more time on the task & topic analysis
      provided for a smoother process of creating the
      prototype lessons.


Minta Peterson – EDIT 235 – Fall 2004         Page 13 of 24
How to Use the
Excel Gradebook
Template

Birdville
Elementary
School




             Page 14 of 24
 Overview / Objective

 This tutorial covers:
              Concepts used in this tutorial
              Step-by-step guide
 Objective
              By the end of this tutorial, you will be
              able to use and Excel template to
              record & submit grades


 For ease of use, it is recommended
   that you print out this tutorial while
   you use Excel on a computer.



Minta Peterson – EDIT 235 – Fall 2004          Page 15 of 24
                           Lesson 1, Module 1:

                           Why use
                           this tutorial?
                  Using the pre-created Excel
                  template is easy and will save you
                  time in the long run
                  This will reduce the manually sifting
                  of piles of grade sheets
                  There is no limit to the amount of
                  student grades you can save in
                  Excel
                  Automatically calculates data!
                  You can easily retrieve the saved
                  file at any time




Minta Peterson – EDIT 235 – Fall 2004            Page 16 of 24
 Lesson 1, Module 2:

 You already know
 how to….
                   Turn on a computer
                   Use a mouse
                   Use Microsoft Word
                         File
                         Open
                         Save as
                         Maximize/minimize
                         window
                   Use email
                   Basic typing
                   Use a paper
                   spreadsheet to
                   compute grades –
                   similar concept!

Minta Peterson – EDIT 235 – Fall 2004        Page 17 of 24
 Lesson 1, Module 3:

 What is Excel?
 Excel is a Spreadsheet.
 Think of a sheet of
 accounting paper:                      A paper
   Several boxes or “cells”             spreadsheet
   to record corresponding
   data
   May contain numerical or
   alphabetical data.
   Examples:
            Test scores
            Names and phone
            numbers

 With Excel, you can:
  Automatically calculate
  data
  Organize, manipulate,
  and analyze, and save
  data

                                              An Excel
                                              spreadsheet




Minta Peterson – EDIT 235 – Fall 2004                 Page 18 of 24
 Lesson 1, Module 4:

 What is a Cell?
 An Excel
 spreadsheet is
 made up of Cells –
 What is a cell?
       The intersection of a
       row and a column
       row labeled with
       numbers (1 to 65,536!)
       column labeled with
       letters of the alphabet
       (A-Z)
       About 15 million cells
       available per sheet!
       Simply double-click to
       edit a cell
       Move among cells using
       tab or arrow keys
       Hit enter key after each
       entry




Minta Peterson – EDIT 235 – Fall 2004   Page 19 of 24
 Lesson 1, Module 5:

 What is a Template?
  In this tutorial, a Template will be used. A Template is a
      ready-made design product/file can be used as a basis
      for fast and high-quality file. Templates not only save
      time but also standardizes a specified format.
  We will use a Gradebook template in which calculation
      formulas are already setup, so all you have to do is
      enter in the data!

  Partial view of the Excel Gradebook Template.




Minta Peterson – EDIT 235 – Fall 2004           Page 20 of 24
  Lesson 3, Module 1:
  Open Excel and Gradebook Template

 1.       Double-click Excel
          icon to open Excel

 2.       Click "File,"
          "Open“

 3.       Locate file where
          you saved
          Gradebook
          template file

 4.       If you don't see
          file, click drop
          down menu

 5.       Click once on file
          name to select

 6.       Click "Open"



Minta Peterson – EDIT 235 – Fall 2004   Page 21 of 24
 Lesson 3, Module 2:
 Enter Teacher & Class Name, & Quarter

                                             Need to make a
                                               correction?
                                               Position the
                                             mouse over the
                                             cell and double-
                                                   click
 1.     Look for "Birdville Elementary
        School“

 2.     Position mouse over
        "Type in Teacher Name here“

 3.     Click mouse once

 4.     Type in your name (Example:
        Minta Peterson)

 5.     Hit "Enter“

 6.     Make sure "Type in Class Name
        here" cell is selected

 7.     Type in the name of the class for
        this gradebook

 8.     Hit "Enter“

 9.     Make sure "Type in the Quarter
        here" cell is selected

 10.    Type in the name of the quarter
        for this gradebook

 11.    Hit "Enter“




Minta Peterson – EDIT 235 – Fall 2004       Page 22 of 24
 Lesson 3, Module 3:
 Enter Assignment/Quiz Names &
 Total Points Possible


 1.      Position mouse over cell
         "Assign 1“

 2.      Click mouse once to select cell

 3.      Type in the name of your
         assignment, test, etc.

 4.      Notice that the title of the item
         you just typed is reflected in the
         item in the gradebook listing
         directly below.

 5.      Hit "Enter“

 6.      Make sure cell directly below is
         selected

 7.      Type in the points possible

 8.      For each assignment or
         quiz/test that you want to enter,
         repeat steps 1-6.




Minta Peterson – EDIT 235 – Fall 2004         Page 23 of 24
 Lesson 3, Module 4:
 Enter Student Names and Points Earned
   1.    Position mouse over cell "Last Name, First Name“




   2.    Click mouse once to select cell

   3.    Type in a student's name, in the format specified

   4.    Hit "Enter“

   5.    Repeat the previous steps until you have entered each student

   6.    Position mouse in the cell directly under your first item in the roster (cell F22)




   7.    Type in the points for the student in the same row

   8.    Hit "Enter“

   9.    Repeat the previous steps until all scores are entered

   10.   After all scores are entered, notice the automatic totals towards the bottom under
         "Class Summary!"




Minta Peterson – EDIT 235 – Fall 2004                                                Page 24 of 24

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:1680
posted:11/2/2009
language:English
pages:24