Nayland College Mathematics; More than just a school  
 
 

 
 
 
 

AS 3.7 Modelling

Modelling HOME | Achievement Criteria | Overview | Logs | What is e? | 2 Model Forms | Exponential Function | Exponential Model | Power Model | Selecting a Model | Using Excel | Example

Achievement Standard 3.7 Modelling is a 3 Credit Internal assessment

Jump to Exponential Model | Power Model |Computer Practice | Revision

1

 

 Modelling

Overview, Assessment Criteria,
Review of Level 2 Graphing with emphasis on the exponential and Log graphs,
modelling simulation fitting data points

Assessment Criteria, Lesson List,
Graphing review:MR notes, Blank Notes

Different graph functions: Sigma p390 Ex 19.01

Level 2 Graphing | Exponential Graphs | Log Graphs

Exponential demo | Log demo (contains macros) Power model demo

AIS p138 & 139


2

 

Logarithms, definition,
Convert between index and Log Equations, Log rules, Introduction of 'e'

     Log(A) + Log(B) = Log(AB), ( We will use this rule)
     Log(A) - Log(B) = Log(A/B),
     Log(A)n = nLog(A), (And we will use this rule)

Logs: MR notes, Blank Notes
Index Equations: | MR notes, Blank Notes

Logs: Sigma p393 Ex 19.02
Index Equations: p396 Ex 19.03

What is 'e' blind date video

Images: Log Rules | Eulers 'e'

  AIS p142, 143A,B
3

 

 Review of geometric model
Exploring exponential relationship: y = arx and solving problems.

Geometric Problems: MR notes, Blank Notes

Geometric problems p403 Ex 19.06

Geometric sequences
Exponential Equations

4

 

Investigate the graphs of exponential model.
How changing the coefficients 'a' and 'k' change the graph of y = aekx

Exponential graph demo

Exponential graphs: MR note, Blank Notes

Graphing exponential functions p400 Ex 19.05 #3 to 7

 AIS p144

5

 

Modelling Overview,
Linearising the Exponential model, Determining the Exponential Model for given data values.

Practice of the exponential model

Exponential Model: MR notes, Blank Notes

 Finding exponential model p411 Ex 20.01

AIS p145

6

 

 Exponential model practice.(continue from yesterday)
Swapping between two forms of exponential model
y = aekx & y = amx
Solving application Problems.

MR notes on 2 forms, Blank Notes

p398 Ex 19.04

Two forms of model
comparison demo (contains macros)

  p143C

7

 

Linearising the Power model, Determining the Power Model for given data values.

Practice of the Power model

 

MR notes on Power model, Blank Notes

p416 Ex 20.02

Power model
Power model demo

AIS p146

 
8

 

Review of the Exponential and Power Model
Demonstration of Computer modelling using EXCEL
Selecting the Model

Class Example

 pg407 Excel Notes

AIS p147
9

 

Setting up a report
'coefficient of determination' - R2
This value gives an indication of how close the data points are to the curve. More importantly the model must fit the nature of the data.

The concrete and pottery example

MR notes on Correlation Coefficient, Blank Notes

what is R2? Link to University of Auckland powerpoint

AIS p148, 149
10

 

 Computer modelling using EXCEL

Mr Bloomfield's plankton

p420 Ex 20.03

Excel Modelling

AIS p151,152
11

 

 Computer modelling using EXCEL

Practice and Write up

Beer example | Sales Data

p420 Ex 20.03 (cont)

AIS p153, 154
12

 

 Selecting a model, REVISION

Periwinkle Instructions

Mr Bloomfields Periwinkle Data

Thanks to Lucy Edmonds (Kelston Girls' College) for these excellent revision problems
Problem data sets (Q1 to 12)
Instructions and Questions

AIS p155, 156
13

 

 Selecting a model, REVISION

Logging Data | Weight data | Cell phone | Heartbeats

 

AIS p152, 154, Revision p154

Example

 
15

 

Assessment Part 1: Using Excel

 Assessment Part 2: Write Up

 

 

 

back to top