Spreadsheets for Teachers

Learning Objectives:

• Importing your class-lists from SIMS
• Adding target grades
• Adding descriptors
• Adding assessment categories
• Converting test scores to percentages
• Use “IF” statements to calculate over and under-achievement
• Use Conditional Formatting colours to highlight over and under-achievement
• Use Sorting to arrange learners by degrees of over and under-achievement
• Use Filtering to focus on specific groups
• Seating Plans (you can adapt our template)
• Nice charts and graphs to impress SMT
• Mail-merge your data into reports, you just add the personal guidance