The Application of Formulas and Functions in Excel Teaching Plan Design Reference

The application of formulas and functions in excel. Teaching plan design reference

1. Teaching goal:

1. Knowledge goal: to master the formula composition format of Excel. Understand the concept of function and master the use of common functions such as (sum,average).

2. Ability goal: to master the sum and average of the given data calculated by sum,average), and to modify the function parameters according to the needs of work, and finally to solve the problems encountered in real life by using the learned knowledge and skills.

3. Emotional goal: The introduction of story situations has stimulated students' strong desire to learn excel spreadsheets, and they feel the necessity and importance of learning excel spreadsheets when the problems are solved one by one. Driven by the task, students' awareness of autonomous learning is activated, and the joy of success is realized in the process of completing the task, and the happiness and enrichment of helping others are felt in specific tasks.

2. Teaching emphases and difficulties:

1. Emphasis: input of formula format, insertion and use of sum and average functions.

2. Difficulties: modification of formula format, correct use and modification of function parameters.

third, teaching methods:

guided operation, independent inquiry, task-driven and mutual learning

fourth, preparation of teaching materials:

excel spreadsheet version of students' transcripts.

V. Teaching process

1. Introduction of situations:

(1) Mr. Liu is an old teacher with 28 years' teaching experience. During these 28 years, he has served as the head teacher, devoted himself to his work and won high praise from students, school leaders and parents! However, with the development of science and technology, the school began to step into paperless office this year. Facing the operation of computers, Ms. Liu felt that she was unable to do so. After all, she was old. Now, Ms. Liu has to analyze the students' first monthly exam results. Facing excel spreadsheets, she used a calculator to calculate them one by one, and then filled them in the forms, which took about two hours. For this job, if you can operate a spreadsheet, it only takes about two minutes to solve it. Students, do you want to have this ability? Would you like to help Mr. Liu a lot?

(2) excel spreadsheet that Teacher Liu wants to deal with.

(3) By observing the excel spreadsheet that Mr. Liu has to deal with, let the students know the content and purpose of learning, which leads to the learning goal of this lesson.

2. Make clear the learning goal

(1), understand the concept of formula, master the formula format, and use the formula to process the data.

(2) Understand the concept of function and master the use of common functions, such as sum function and average function.

(3) The function parameters can be modified according to the work needs, and finally the problems encountered in real life can be solved by using the learned knowledge and skills.

3. New class teaching

(1). One of the teaching activities

The concept of formula-formula is an equation for numerical calculation in excel spreadsheet.

formula composition format: = expression.

expressions can include: operators, cells, constants, functions, etc.

For example: =b2+6, =b2+c2+d2, =sum (parameter)

Explore in the preset spreadsheet-"Training Ground 1". First, let students master the composition of the formula and the use of the custom formula through guiding operation, then leave time for students, and finally master the most basic formula composition format and the use of the custom formula through independent exploration.

if * * * has 2 columns for a certain job, and we also need to sum them, then do we also add them one by one? Is there a faster solution? In order to improve work efficiency, a special formula-function is introduced.

(2) The second teaching activity

The concept of function-function is a special formula predefined by excel spreadsheet.

function composition: = function name (parameter)

For example: = sum (B2: D2)

= average (B2: D2)

Explore in the preset spreadsheet-"Training Ground 2". First, let students master the composition of the most commonly used function (sum,average) through guiding operation. Finally, master the composition and use of the most commonly used function (sum,average), and finally let them use the knowledge and skills they have learned to calculate the total score and average score of 1 students. ;