Coverart for item
The Resource Excel for teachers, Colleen Conmy, Bill Hazlett, Bill Jelen & Adrienne Soucy

Excel for teachers, Colleen Conmy, Bill Hazlett, Bill Jelen & Adrienne Soucy

Label
Excel for teachers
Title
Excel for teachers
Statement of responsibility
Colleen Conmy, Bill Hazlett, Bill Jelen & Adrienne Soucy
Creator
Contributor
Subject
Genre
Language
eng
Cataloging source
UKM
http://library.link/vocab/creatorName
Conmy, Collen
Dewey number
371.100285536
Illustrations
illustrations
Index
index present
Literary form
non fiction
http://library.link/vocab/relatedWorkOrContributorName
  • Hazlett, Bill
  • Jelen, Bill
  • Soucy, Adrienne
http://library.link/vocab/subjectName
  • Computer managed instruction
  • Classroom management
Target audience
adult
Label
Excel for teachers, Colleen Conmy, Bill Hazlett, Bill Jelen & Adrienne Soucy
Instantiates
Publication
Note
  • Includes index
  • "By teachers for teachers"--Cover
Carrier category
volume
Carrier category code
nc
Carrier MARC source
rdacarrier
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • Introduction to Excel
  • 45
  • Opportunity
  • 45
  • Solution and Overview
  • 46
  • Creating the Solution
  • 46
  • Entering Student Names
  • 47
  • Entering Assignment Names
  • 5
  • 49
  • Formatting Assignment Headings
  • 50
  • Keeping Headings Visible
  • 51
  • Entering Formulas for Total Score
  • 52
  • Copying Excel Formulas
  • 52
  • Setting up an Average Formula - Using Absolute References
  • Rows and Columns
  • 53
  • Figuring out the Classroom Average
  • 55
  • Assigning Letter Grades
  • 56
  • Page Setup Settings for Printing
  • 57
  • Applying Color Formats
  • 60
  • Copying the Math Grade Book for Other Subjects
  • 5
  • 63
  • Using the Application
  • 64
  • Adding Grades
  • 64
  • Adding New Students
  • 64
  • Adding More Room for Assignments
  • 65
  • Excel Details
  • To Infinity and Beyond
  • 66
  • Chapter 6
  • Attendance Records
  • 67
  • Opportunity
  • 67
  • Solution and Overview
  • 67
  • Creating the Solution
  • 67
  • 6
  • Extending Workbooks for Additional Grading Periods
  • 69
  • Populating the YTD Figures
  • 70
  • Using the Application
  • 71
  • Excel Details
  • 71
  • Chapter 7
  • Lesson Plan Sheets
  • Calculating, Always Calculating
  • 73
  • Opportunity
  • 73
  • Solution and Overview
  • 73
  • Creating the Solution
  • 74
  • Using the Application
  • 76
  • Excel Details
  • 6
  • 77
  • Chapter 8
  • Random Sequence for Book Reports
  • 79
  • Opportunity
  • 79
  • Solution and Overview
  • 79
  • Creating the Solution
  • 79
  • Chapter 1
  • Using the Application
  • 80
  • Excel Details
  • 80
  • Chapter 9
  • Randomly Calling on a Student
  • 81
  • Opportunity
  • 81
  • Solution and Overview
  • Calculation Basics
  • 81
  • Creating the Solution
  • 81
  • Finding the Student with the Lowest Random Number
  • 81
  • Building a Single Formula from Intermediate Formulas
  • 83
  • Using the Application
  • 85
  • Excel Details
  • Windows vs. Mac
  • 9
  • 85
  • Chapter 10
  • Tracking Student Information
  • 87
  • Opportunity
  • 87
  • Solution and Overview
  • 87
  • Creating the Solution
  • 87
  • Opportunity
  • Building the First Student Worksheet
  • 88
  • Adding Navigation with Hyperlinks
  • 92
  • Making the Student Name a Dropdown
  • 92
  • Replicating the Worksheet for Each Student
  • 94
  • Optional: Adding Hyperlinks from the Class Worksheet to the Individual Worksheets
  • 94
  • 9
  • Using the Application
  • 95
  • Entering Incidents
  • 96
  • Excel Details
  • 96
  • Chapter 11
  • Student Mailing Lists
  • 97
  • Opportunity
  • Solution and Overview
  • 97
  • Solution and Overview
  • 97
  • Creating the Solution
  • 98
  • Getting the Data from the School Database
  • 98
  • Importing the Data into Excel
  • 98
  • Using the Application
  • 9
  • 105
  • Selecting Records with AutoFilter
  • 105
  • Copying Filtered Records
  • 107
  • Using Word to Create Mailing Labels from Excel Data
  • 107
  • Chapter 12
  • Sorting Class Lists by First Name
  • 113
  • Using the Touch-Typing Method (Addition)
  • Opportunity
  • 113
  • Solution and Overview
  • 113
  • Creating the Solution
  • 113
  • Splitting Data
  • 113
  • Joining Text from Two Columns
  • 116
  • 9
  • Joining Text with Dates or Numbers
  • 117
  • Freezing the Results of a Formula as Values
  • 118
  • Chapter 13
  • Reporting Long Term Testing Results
  • 119
  • Opportunity
  • 119
  • Solution and Overview
  • Using the Mouse Method (Subtraction)
  • 120
  • Creating the Solution
  • 121
  • Using the Criteria Fields
  • 124
  • Adding Fields to the Pivot Table
  • 125
  • Formatting a Data Field
  • 127
  • Moving Fields on a Pivot Table
  • 11
  • 128
  • Finding Top or Bottom Students
  • 134
  • Using the Application
  • 137
  • Excel Details
  • 137
  • Chapter 14
  • Reading Grade Level Test Results
  • 139
  • Using the Arrow Key Method (Addition and Subtraction)
  • Opportunity
  • 139
  • Solution and Overview
  • 139
  • Creating the Solution
  • 139
  • Building the Chart for Parent-Teacher Conferences
  • 139
  • Using the Application
  • 142
  • 1
  • 12
  • Chapter 15
  • Tracking Proficiency
  • 143
  • Opportunity
  • 143
  • Solution and Overview
  • 143
  • Creating the Solution
  • 143
  • Using the Application
  • Entering Multiplication Problems
  • 144
  • Using the IF Function
  • 144
  • Adding Summary Statistics for the Entire Class
  • 144
  • Using COUNTIF and SUMIF for Totals
  • 145
  • Chapter 16
  • Creating Checklists
  • 149
  • 14
  • Opportunity
  • 149
  • Solution and Overview
  • 149
  • Creating the Solution
  • 149
  • Using the Application
  • 151
  • Excel Details
  • 152
  • Entering Division Problems
  • Chapter 17
  • Requisition Forms
  • 153
  • Opportunity
  • 153
  • Solution and Overview
  • 153
  • Creating the Solution
  • 153
  • Using the Application
  • 14
  • 164
  • Chapter 18
  • Printing Grid Paper
  • 165
  • Opportunity
  • 165
  • Solution and Overview
  • 165
  • Creating The Solution
  • 165
  • Entering Fraction Problems
  • Using the Application
  • 167
  • Adding Gridlines
  • 167
  • Configuring Print Settings
  • 169
  • Saving the Document
  • 172
  • Printing the Grid Paper
  • 172
  • 15
  • Excel Details
  • 172
  • Making Larger Grids
  • 172
  • Producing Cartesian Coordinates
  • 173
  • Chapter 19
  • Math Exercise Sheets
  • 175
  • Opportunity
  • Using Parentheses to Control the Order of Operations
  • 175
  • Solution and Overview
  • 175
  • Creating the Solution
  • 175
  • Basic Math Facts: Adding Two Terms with an Answer Under 10
  • 176
  • Using the Application
  • 178
  • Keeping the Worksheet from Changing
  • 15
  • 178
  • Adapting for Multiplication
  • 179
  • Creating an Answer Key
  • 179
  • Excel Details
  • 180
  • Subtracting with Two-Digits Without Regrouping
  • 180
  • Expressing Problems That Go Across the Page
  • Calculating Squares, Cubes, Square Roots, Cube Roots
  • 181
  • Avoiding Duplicate Problems
  • 182
  • Chapter 20
  • Homework Checker
  • 183
  • Opportunity
  • 183
  • Solution and Overview
  • 183
  • Skills Required
  • 16
  • Creating the Solution
  • 183
  • Using the Application
  • 184
  • Excel Details
  • 185
  • Adding Color Based on a Result
  • 186
  • Where Did They Go Wrong?
  • 188
  • Adding a Column of Numbers
  • Chapter 21
  • Recording Rubric Data
  • 191
  • Opportunity
  • 191
  • Solution and Overview
  • 192
  • Creating the Solution
  • 192
  • Using Trickery to Double the Value of the Worksheet
  • 18
  • 195
  • Understanding the Basics of Chart Ranges
  • 196
  • Setting up the Chart
  • 198
  • Correcting the Y-Axis
  • 200
  • Correcting the X-Axis
  • 202
  • Using the Application
  • Calculating an Average
  • 203
  • Entering a Second Rubric
  • 203
  • Displaying a Trend for One Student
  • 204
  • Displaying All Students for the Most Recent Rubric
  • 205
  • Displaying Students Having Problems with Descriptions
  • 206
  • Excel Details
  • 19
  • 206
  • Chapter 22
  • Organizing Vocabulary Lists
  • 207
  • Opportunity
  • 207
  • Solution and Overview
  • 207
  • Creating the Solution
  • 207
  • Chapter 2
  • Using the Application
  • 209
  • Chapter 23
  • Reading Journal
  • 213
  • Opportunity
  • 213
  • Solution and Overview
  • 213
  • Creating the Solution
  • Multiplication Tables
  • 213
  • Using the Application
  • 216
  • Excel Details
  • 218
  • Chapter 24
  • Demonstrating Fractions with Charts
  • 219
  • Opportunity
  • 219
  • 21
  • Solution and Overview
  • 219
  • Creating the Solution
  • 219
  • Making a Worksheet Not Look Like Excel
  • 222
  • Customizing a Chart
  • 222
  • Using the Application
  • 225
  • Opportunity
  • Excel Details
  • 225
  • Chapter 25
  • Bar Charts
  • 227
  • Opportunity
  • 227
  • Solution and Overview
  • 227
  • Creating the Solution
  • 21
  • 227
  • Using the Application
  • 232
  • Excel Details
  • 232
  • Setting as Default Chart
  • 234
  • 3
  • Solution and Overview
  • 21
  • Creating the Solution
  • 21
  • Using the Fill Handle to Extend a Series
  • 21
  • Copying a Range on its Side
  • 21
  • Entering a Single Formula for Many Cells
  • 22
  • Before You Start
  • Using the Application
  • 23
  • Excel Details
  • 23
  • Simplifying Dollar Sign Entry in Absolute and Mixed References
  • 23
  • More Cool Fill Handle Tricks
  • 24
  • Chapter 3
  • Calculating with Times
  • 3
  • 27
  • Opportunity
  • 27
  • Solution and Overview
  • 27
  • Dates and Times in Excel
  • 27
  • Chapter 4
  • Classroom Libraries
  • 35
  • How the Book Is Set up
  • Opportunity
  • 35
  • Solution and Overview
  • 35
  • Creating the Solution
  • 35
  • Using the Application
  • 38
  • Entering Data
  • 38
  • 4
  • Sorting Data
  • 39
  • Filtering Data
  • 40
  • Locating Data
  • 42
  • Excel Details
  • 44
  • Chapter 5
  • Grade Books
Control code
ocm62089473
Dimensions
22 cm
Extent
vi, a-c, 243 pages
Isbn
9781932802115
Lccn
2005929675
Media category
unmediated
Media MARC source
rdamedia
Media type code
n
Note
005.54 C761 ; P ; XX-N ; C0306QU2 (GN).
Other control number
9781932802115
Other physical details
illustrations
System control number
  • (Sirsi) o62089473
  • (Sirsi) o62089473
Label
Excel for teachers, Colleen Conmy, Bill Hazlett, Bill Jelen & Adrienne Soucy
Publication
Note
  • Includes index
  • "By teachers for teachers"--Cover
Carrier category
volume
Carrier category code
nc
Carrier MARC source
rdacarrier
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • Introduction to Excel
  • 45
  • Opportunity
  • 45
  • Solution and Overview
  • 46
  • Creating the Solution
  • 46
  • Entering Student Names
  • 47
  • Entering Assignment Names
  • 5
  • 49
  • Formatting Assignment Headings
  • 50
  • Keeping Headings Visible
  • 51
  • Entering Formulas for Total Score
  • 52
  • Copying Excel Formulas
  • 52
  • Setting up an Average Formula - Using Absolute References
  • Rows and Columns
  • 53
  • Figuring out the Classroom Average
  • 55
  • Assigning Letter Grades
  • 56
  • Page Setup Settings for Printing
  • 57
  • Applying Color Formats
  • 60
  • Copying the Math Grade Book for Other Subjects
  • 5
  • 63
  • Using the Application
  • 64
  • Adding Grades
  • 64
  • Adding New Students
  • 64
  • Adding More Room for Assignments
  • 65
  • Excel Details
  • To Infinity and Beyond
  • 66
  • Chapter 6
  • Attendance Records
  • 67
  • Opportunity
  • 67
  • Solution and Overview
  • 67
  • Creating the Solution
  • 67
  • 6
  • Extending Workbooks for Additional Grading Periods
  • 69
  • Populating the YTD Figures
  • 70
  • Using the Application
  • 71
  • Excel Details
  • 71
  • Chapter 7
  • Lesson Plan Sheets
  • Calculating, Always Calculating
  • 73
  • Opportunity
  • 73
  • Solution and Overview
  • 73
  • Creating the Solution
  • 74
  • Using the Application
  • 76
  • Excel Details
  • 6
  • 77
  • Chapter 8
  • Random Sequence for Book Reports
  • 79
  • Opportunity
  • 79
  • Solution and Overview
  • 79
  • Creating the Solution
  • 79
  • Chapter 1
  • Using the Application
  • 80
  • Excel Details
  • 80
  • Chapter 9
  • Randomly Calling on a Student
  • 81
  • Opportunity
  • 81
  • Solution and Overview
  • Calculation Basics
  • 81
  • Creating the Solution
  • 81
  • Finding the Student with the Lowest Random Number
  • 81
  • Building a Single Formula from Intermediate Formulas
  • 83
  • Using the Application
  • 85
  • Excel Details
  • Windows vs. Mac
  • 9
  • 85
  • Chapter 10
  • Tracking Student Information
  • 87
  • Opportunity
  • 87
  • Solution and Overview
  • 87
  • Creating the Solution
  • 87
  • Opportunity
  • Building the First Student Worksheet
  • 88
  • Adding Navigation with Hyperlinks
  • 92
  • Making the Student Name a Dropdown
  • 92
  • Replicating the Worksheet for Each Student
  • 94
  • Optional: Adding Hyperlinks from the Class Worksheet to the Individual Worksheets
  • 94
  • 9
  • Using the Application
  • 95
  • Entering Incidents
  • 96
  • Excel Details
  • 96
  • Chapter 11
  • Student Mailing Lists
  • 97
  • Opportunity
  • Solution and Overview
  • 97
  • Solution and Overview
  • 97
  • Creating the Solution
  • 98
  • Getting the Data from the School Database
  • 98
  • Importing the Data into Excel
  • 98
  • Using the Application
  • 9
  • 105
  • Selecting Records with AutoFilter
  • 105
  • Copying Filtered Records
  • 107
  • Using Word to Create Mailing Labels from Excel Data
  • 107
  • Chapter 12
  • Sorting Class Lists by First Name
  • 113
  • Using the Touch-Typing Method (Addition)
  • Opportunity
  • 113
  • Solution and Overview
  • 113
  • Creating the Solution
  • 113
  • Splitting Data
  • 113
  • Joining Text from Two Columns
  • 116
  • 9
  • Joining Text with Dates or Numbers
  • 117
  • Freezing the Results of a Formula as Values
  • 118
  • Chapter 13
  • Reporting Long Term Testing Results
  • 119
  • Opportunity
  • 119
  • Solution and Overview
  • Using the Mouse Method (Subtraction)
  • 120
  • Creating the Solution
  • 121
  • Using the Criteria Fields
  • 124
  • Adding Fields to the Pivot Table
  • 125
  • Formatting a Data Field
  • 127
  • Moving Fields on a Pivot Table
  • 11
  • 128
  • Finding Top or Bottom Students
  • 134
  • Using the Application
  • 137
  • Excel Details
  • 137
  • Chapter 14
  • Reading Grade Level Test Results
  • 139
  • Using the Arrow Key Method (Addition and Subtraction)
  • Opportunity
  • 139
  • Solution and Overview
  • 139
  • Creating the Solution
  • 139
  • Building the Chart for Parent-Teacher Conferences
  • 139
  • Using the Application
  • 142
  • 1
  • 12
  • Chapter 15
  • Tracking Proficiency
  • 143
  • Opportunity
  • 143
  • Solution and Overview
  • 143
  • Creating the Solution
  • 143
  • Using the Application
  • Entering Multiplication Problems
  • 144
  • Using the IF Function
  • 144
  • Adding Summary Statistics for the Entire Class
  • 144
  • Using COUNTIF and SUMIF for Totals
  • 145
  • Chapter 16
  • Creating Checklists
  • 149
  • 14
  • Opportunity
  • 149
  • Solution and Overview
  • 149
  • Creating the Solution
  • 149
  • Using the Application
  • 151
  • Excel Details
  • 152
  • Entering Division Problems
  • Chapter 17
  • Requisition Forms
  • 153
  • Opportunity
  • 153
  • Solution and Overview
  • 153
  • Creating the Solution
  • 153
  • Using the Application
  • 14
  • 164
  • Chapter 18
  • Printing Grid Paper
  • 165
  • Opportunity
  • 165
  • Solution and Overview
  • 165
  • Creating The Solution
  • 165
  • Entering Fraction Problems
  • Using the Application
  • 167
  • Adding Gridlines
  • 167
  • Configuring Print Settings
  • 169
  • Saving the Document
  • 172
  • Printing the Grid Paper
  • 172
  • 15
  • Excel Details
  • 172
  • Making Larger Grids
  • 172
  • Producing Cartesian Coordinates
  • 173
  • Chapter 19
  • Math Exercise Sheets
  • 175
  • Opportunity
  • Using Parentheses to Control the Order of Operations
  • 175
  • Solution and Overview
  • 175
  • Creating the Solution
  • 175
  • Basic Math Facts: Adding Two Terms with an Answer Under 10
  • 176
  • Using the Application
  • 178
  • Keeping the Worksheet from Changing
  • 15
  • 178
  • Adapting for Multiplication
  • 179
  • Creating an Answer Key
  • 179
  • Excel Details
  • 180
  • Subtracting with Two-Digits Without Regrouping
  • 180
  • Expressing Problems That Go Across the Page
  • Calculating Squares, Cubes, Square Roots, Cube Roots
  • 181
  • Avoiding Duplicate Problems
  • 182
  • Chapter 20
  • Homework Checker
  • 183
  • Opportunity
  • 183
  • Solution and Overview
  • 183
  • Skills Required
  • 16
  • Creating the Solution
  • 183
  • Using the Application
  • 184
  • Excel Details
  • 185
  • Adding Color Based on a Result
  • 186
  • Where Did They Go Wrong?
  • 188
  • Adding a Column of Numbers
  • Chapter 21
  • Recording Rubric Data
  • 191
  • Opportunity
  • 191
  • Solution and Overview
  • 192
  • Creating the Solution
  • 192
  • Using Trickery to Double the Value of the Worksheet
  • 18
  • 195
  • Understanding the Basics of Chart Ranges
  • 196
  • Setting up the Chart
  • 198
  • Correcting the Y-Axis
  • 200
  • Correcting the X-Axis
  • 202
  • Using the Application
  • Calculating an Average
  • 203
  • Entering a Second Rubric
  • 203
  • Displaying a Trend for One Student
  • 204
  • Displaying All Students for the Most Recent Rubric
  • 205
  • Displaying Students Having Problems with Descriptions
  • 206
  • Excel Details
  • 19
  • 206
  • Chapter 22
  • Organizing Vocabulary Lists
  • 207
  • Opportunity
  • 207
  • Solution and Overview
  • 207
  • Creating the Solution
  • 207
  • Chapter 2
  • Using the Application
  • 209
  • Chapter 23
  • Reading Journal
  • 213
  • Opportunity
  • 213
  • Solution and Overview
  • 213
  • Creating the Solution
  • Multiplication Tables
  • 213
  • Using the Application
  • 216
  • Excel Details
  • 218
  • Chapter 24
  • Demonstrating Fractions with Charts
  • 219
  • Opportunity
  • 219
  • 21
  • Solution and Overview
  • 219
  • Creating the Solution
  • 219
  • Making a Worksheet Not Look Like Excel
  • 222
  • Customizing a Chart
  • 222
  • Using the Application
  • 225
  • Opportunity
  • Excel Details
  • 225
  • Chapter 25
  • Bar Charts
  • 227
  • Opportunity
  • 227
  • Solution and Overview
  • 227
  • Creating the Solution
  • 21
  • 227
  • Using the Application
  • 232
  • Excel Details
  • 232
  • Setting as Default Chart
  • 234
  • 3
  • Solution and Overview
  • 21
  • Creating the Solution
  • 21
  • Using the Fill Handle to Extend a Series
  • 21
  • Copying a Range on its Side
  • 21
  • Entering a Single Formula for Many Cells
  • 22
  • Before You Start
  • Using the Application
  • 23
  • Excel Details
  • 23
  • Simplifying Dollar Sign Entry in Absolute and Mixed References
  • 23
  • More Cool Fill Handle Tricks
  • 24
  • Chapter 3
  • Calculating with Times
  • 3
  • 27
  • Opportunity
  • 27
  • Solution and Overview
  • 27
  • Dates and Times in Excel
  • 27
  • Chapter 4
  • Classroom Libraries
  • 35
  • How the Book Is Set up
  • Opportunity
  • 35
  • Solution and Overview
  • 35
  • Creating the Solution
  • 35
  • Using the Application
  • 38
  • Entering Data
  • 38
  • 4
  • Sorting Data
  • 39
  • Filtering Data
  • 40
  • Locating Data
  • 42
  • Excel Details
  • 44
  • Chapter 5
  • Grade Books
Control code
ocm62089473
Dimensions
22 cm
Extent
vi, a-c, 243 pages
Isbn
9781932802115
Lccn
2005929675
Media category
unmediated
Media MARC source
rdamedia
Media type code
n
Note
005.54 C761 ; P ; XX-N ; C0306QU2 (GN).
Other control number
9781932802115
Other physical details
illustrations
System control number
  • (Sirsi) o62089473
  • (Sirsi) o62089473

Library Locations

    • Boardwalk BranchBorrow it
      8656 N. Ambassador Drive, Kansas City, MO, 64154 , US
      39.25022 -94.65048
    • North Independence BranchBorrow it
      317 W. 24 Hwy., Independence, MO, 64050 , US
      39.100794 -94.418828
    • South Independence BranchBorrow it
      13700 E. 35th St., Independence, MO, 64055 , US
      39.05803 -94.41822
Processing Feedback ...