Result Analysis - Lee Kai En(10)

Commands used:

To Convert to % --> x/total score*100

To Convert to Grade --> Vlookup

To Analyse --> Countif

Result Analysis - Owen Ong (15)

Results Analysis - Wee Chang Han, Register 20

ICT Task - Score Analysis using Numbers

by Mr johari

This is how the final table should look like.
It should contain the following information:

1. Table of values (score, Percentage, Grade)
2. Analysis (that automatically counts the number of students getting the various grades from A1 to F9) (the table in yellow highlights the category of score from A1 - F9)
3. mean subject grade (MSG), mean marks from column 2, Total number of candidates, Highest Score and Lowest Score - tabulated from column 2)
4. Visual representation in the form of a bar chart.

Your task: 

complete the table and the following students please post a link to your table.

index # 5, #10, #15, #20.

Lesson Summary: 6/3/13 NUMBERS!!!

To Do:
- Be prepared for performance task
- Play around with numbers

Here is my version of the file we did today: http://www.mediafire.com/?hm3e2dkqua1krm7

Using TI 84Plus and simple programme

INTRODUCTION TO TI84 Plus

Programming QUADRATIC INTO TI84 

Study the video provided for clarity of concept and greater appreciation of TI84plus.

Task 1: Simulate the programme into your TI84plus. Call it QUAD

Task 2: Extend your learning by considering the case when the answers are not Real ie. Imaginary