FAST program concept-giving beginners with Program Design

Starting from

In front of the company, meow invited the company to open the program of VBA for excel in the company. Some of the members of the above team had the program written, some have learned some Program Statement in school, but there are still many people who have no idea about program. This kind of confrontation is a challenge for teaching. The degree of knowledge varies, so it is not easy to master easily. Therefore, Xiao Meow has made this teaching material, so that some experienced readers can understand it in the shortest time, about 3 hours) you can know the basic program design. After such content, we can bring everyone's horizontal attention to the same level, so that the students do not know what Xiao Meow is doing.

Here, Xiao meow will share with you the content of the related videos.

Programming content

• What is programming
• Change Data
• A = a + 1 misunderstandings
• Sub-Program
• Event producer
• Object adequacy Method
• Incircle

What is a program?

• Actions with sort order are performed one by one
• Program Design in life: Bubble computing
  • Open a bubble
  • Place the bubble in a bowl
  • Open the flavor package and place the seasoning in the bowl.
  • Place in open water
  • Soak in triples
  • Complete bubble renewal

What is a program (Program feature)

• Sequential: Move rows from top to bottom
  • Bubble progress response
• Event producer:
  • When I clap hands: Ask boys to stand up and girls to sit down
  • When I speak, ask a girl to stand up and sit down.
• Program process: different conditions have different results
  • Standing up at noon
  • Other referers
• Re-Attention: Circle

Change Data

• Use a token to store a specific value.
  • X: indicates the person who eats the timer at noon.
  • Y: indicates the person who eats the week at noon.
• Variable Calculation
  • Z: Total number of people who eat lunch + lunch
  • Z = x + y
• Material type labels:
• Text, data, and date

A = a + 1 misunderstandings

• An invalid table in Mathematics
• Meaning on the program
  • LaterA =OriginalA + 1
• A = a + B
  • LaterA =OriginalA + B

Sub-Program

• In common, many places use the same action.
• Chapter:
  • Sub branch (specified position)
    • Pick up Seal
    • Expiry date
    • Muyin
    • Move the chapter to the specified position
  • End sub
• Sub-program handling: convenient Modification

Objects, adequacy, and methods

• Object: refers to an object that exists (such as a car)
• Adequacy: used to describe the characteristics of Vehicle Information
  • For example, colors, flags, heights, degrees, and durations
• Method: actions of an object
  • For example, forward, backward, and backward

Objects, adequacy, and methods in Excel

• Excel is a collection of many objects
• The object contains the object.
  • There are many worksheets in the Excel worksheet case
  • There are many memory cells in the worksheet.
• Features: Describes features or content.
  • Text in the escape cell: range ("A1"). Text
• Method: One action
  • Division of a column

Meaning of the circle

• Fast Power Supply
• Re-upload the email
• Repeat the line in the program → repeat the circle
• Circle types:
  • Known count:
    • For... Next
  • Condition settings
    • While .... Wend
    • Do... Loop while
    • Do... Loop

Loop (... Next)

• Known repeated times
• Fixed Number of duplicates
• Example: clap hands for five times
  • For x = 1 to 5
    • Clap hands
    • Returns x
  • Next

Loop (while vs)

• Determined by the condition.
• Example: clap your hands until I say stop
• While:
  • When
  • Set incircle content
  • Conformity → content
  • Non-conforming → open
• Until:
  • Until
  • Set the Enable ring Condition
  • Non-conforming → internal
  • Yes → open

Loop (while vs)

 

	Italian	Set a condition	Conformity	Non-conforming condition
While	When	Incircle	Internal	Open
Until	Until	Open circle	Open	Internal

Circle (do... Loop)

• While/until before: first judge and then enter the circle
  • Do while... Loop
  • Do... Loop
• While/until after: first in and then judge again
  • Do... Loop while
  • Do... Loop

Circle (do... Loop)

• Until: Until → set the condition
• Non-conforming items → incircle
• Compliant with the condition → open the loop
• Example:
  • Clap your hands until I say stop
    • Do
      • Clap hands
    • Loop until (I said stop)

Loop (while... Wend)

• Equivalent to do while... Loop
• Example: The number of each shot is as small as 5.
  • X = 1
  • While (x <= 5)
    • Clap hands
    • Data (x = x + 1)
  • Wend

PS.

1. the above content is the internal content of the proposal. When it comes to practice, we also need examples and students to cooperate with the notebook (standing up, sitting down, and clapping ), the workload allows students to understand what programming is based on examples of life and activity.
2. because the goal of the students is to test the skill assignment, there are more details about the circle, if you are a real-time employee, you only need to pick up a token for while/Until.