SPL Programming Exercise  Chapter 1 Doing Arithmetic
1.1 Data
1. Write 3.5*10^{8 }in a programming language.
2. Have a try
A 
B 
C 

1 
=2+5 
=25 
=2*5 
2 
=10/5 
=10\5 
=10%5 
3 
=11/5 
=11\5 
=11%5 
4 
=2+3*30 
=(2+3)*30 
=2.0+3*30 
5 
=4194304*4194304 
=4194304*4194304*4194304 
=4194304*4194304*4194304.0 
ⅰ Check result of the code in every cell and find which are integers and which are floating point numbers.
ⅱ Try running the above code and observe the result.
1.2 Variable and statement
1. Write a piece of code to calculate the area of a square.
When side length is 3, calculate area of the square;
Increase the square’s side length two times and calculate the area.
2. Write a piece of code to convert Fahrenheit to Celsius using the formula C=(F32)*5/9.
Enter F=68 and calculate Celsius.
Enter F=100 and calculate Celsius.
3. Write a piece of code to calculate the volume of a hollow cylinder. Enter outer diameter R, inner diameter r and height h to calculate the volume.
Tips: The formula for calculating volume of a cylinder is .
4. Give meanings of the following statements.
x+=y
x=y
x*=y
x/=y
x%=y
5. Find value of A1 when each line of the following codes is executed.
A 

1 
5 
2 
=A1+=3 
3 
=A1=2 
4 
=A1*=5 
5 
=A1*=A2+2 
6 
=A1\=2 
7 
=A1%=2 
1.3 Function
1. Find result of the piece of code below after it is executed.
A 
B 

1 
=ceil(9.2) 
=ceil(9.8) 
2 
=floor(9.2) 
=floor(9.8) 
3 
=lg(10) 
=lg(100) 
4 
=power(2,7) 
=power(900,0.5) 
5 
=sqrt(900) 
=sqrt(16,4) 
6 
=exp(1) 
=exp(2) 
2. Reference Function Reference and find the right function to finish the following programming exercises.
ⅰ Calculate absolute value of 3245;
ⅱ Input three random numbers and find the largest value;
ⅲ Generate three random numbers within [0,100] using rand() function to represent the exam scores, and calculate the total score and average score.
ⅳ Write a piece of code to implement the coordinate rotation formula. Input and the angle (rotation angle) and output x, y.
Tips:
ⅴ Input coordinate (x,y) of two points and output the distance between the two points.
Formular of distance between two points:
Answers:
1.1 Data
1. 3.5E8
2. Results of A1, B1, C1, B2, C2, B3, C3, A4, B4 and A5 are integers; result of B5 is out of range; results of other cells are floating point numbers.
1.2 Variable and statement
1.
A 

1 
3 
2 
=A1*A1 
3 
>A1=2*A1 
4 
=A1*A1 
2.
A 

1 
>F=68 
2 
=(F32)*5/9 
3 
>F=100 
4 
=(F32)*5/9 
3.
A 
B 
C 

1 
>R=8 
>r=3 
>h=5 
2 
=3.14*R*R*h3.14*r*r*h 
1.3 Function
2.
ⅰ
A 

1 
=abs(3245) 
ⅱ
A 
B 
C 

1 
1 
2 
3 
2 
=max(A1,B1,C1) 
ⅲ
A 
B 
C 

1 
=rand(100) 
=rand(100) 
=rand(100) 
2 
=sum(A1,B1,C1) 

3 
=avg(A1,B1,C1) 
ⅳ
A 
B 
C 

1 
3 
4 
90 
2 
=C1*pi()/180 

3 
=A1*cos(A2)B1*sin(A2) 

4 
=A1*sin(A2)+B1*cos(A2) 

5 
>output(A3,A4) 
ⅴ
A 
B 

1 
3 
4 
2 
4 
3 
3 
=sqrt(power(A2A1)+power(B2B1)) 
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_SPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL