Teaching Resources

Keyword
Search

Resource Rating

Excel Gradebook Spreadsheet for Primary with Graphs Sem 1

Seller: PeterLindsay

ITEM No: 000702

Grade: Staff 
Subject: For All Subject Areas
No Of Pages/Slides: 30
Answers provided: No
Type: Excel Spreadsheets
Aligned To: Not Specified
Duration: Lifelong Tool
Price: $7.20
Details:

1st & 2nd TERM/QUARTER

Have you ever wanted to keep all your subject marks together on the one file and display a graph to parents at interview time of their student's progress compared to the class average? Here is the answer.

A flexible and customisable spreadsheet that allows for the following:
• up to ten subjects covering two terms/quarters
• up to ten tasks per term/quarter
• customise maximum mark for task
• customise weightings for different tasks
• adjust weightings to different terms/quarters for final mark
• automatically allocates a grade
• automatically allocates a class rank
• displays class average for each task
• customise subject names

This spreadsheet covers Terms/Quarters 1 & 2. A separate file also available covers Terms/Quarters 3 & 4.

A brief 1 minute YouTube clip shows the main features at the following link: http://youtu.be/HHP_UEj7fQ0

A more comprehensive clip shows the finer details:
http://youtu.be/FSBmf2s-DwY

It is advisable to "Save As" first of all to keep your original file in tact and create a working copy. Comments have also been built in on the first two spreadsheet tabs to explain features in detail. (Small red triangles on some cells.)

Please note: the file was created using 2011 version of Excel. Not all embedded features may work on earlier versions.

Enjoy!

Be a friend...
recommend

Recommend to someone who could benefit from this resource

Buyer's Feedback
No feedback available at the moment
  • (0)
(Follower) '0'
Registered: 14 / 10 / 2015
From: NSW, Australia

More From This Teacher >


Submit Comment>

More From This Teacher

Title: Primary Excel ...
Seller: Peterlindsay
Grade/s: Staff
Subjects: For All Subjec...
Type: Excel Spreadsh...
File: .XLSX
Duration: Lifelong Tool

$7.20

Title: Excel Gradeboo...
Seller: Peterlindsay
Grade/s: Staff
Subjects: For All Subjec...
Type: Excel Spreadsh...
File: .XLSX
Duration: Lifelong Tool

$9.60

Title: Excel Gradeboo...
Seller: Peterlindsay
Grade/s: Staff
Subjects: For All Subjec...
Type: Excel Spreadsh...
File: .XLSX
Duration: Lifelong Tool

$7.20

You may also be interested in

Title: How To Quickly...
Seller: Bartoneducatio...
Grade/s: Staff
Subjects: Professional ...
Type: Excel Spreadsh...
File: .PDF
Duration: Lifelong Tool

$10.00