LAB REPORT
1 ACTIVITY 7A: CREATING CHARTS IN EXCEL
In this activity, we used the Charts function in the Insert tab of Excel to create visual
representations of our data. This approach enhances the understanding of the
information.
Steps:
1. Select Data: Highlight the dataset for the chart.
2. Insert Chart: Go to the Insert tab and select a chart type, such as bar or line.
Results:
The generated charts effectively illustrated trends in the data, making analysis
easier. We also created graphs as visual tools for data representation.
---
2 ACTIVITY 7B: USING HLOOKUP AND VLOOKUP
FUNCTIONS
In this activity, we learned to use the HLOOKUP and VLOOKUP functions in Excel to
locate specific data.
HLOOKUP Function:
- We used HLOOKUP to find data in a horizontal layout.
VLOOKUP Function:
- We employed VLOOKUP to search for data in a vertical layout.
Example Formula:
- HLOOKUP: `=HLOOKUP(lookup_value, table_array, row_index_num,
[range_lookup])`
- VLOOKUP: `=VLOOKUP(lookup_value, table_array, col_index_num,
[range_lookup])`
Results:
These functions improved our efficiency in retrieving specific data points.
---
3 C++ PROGRAMMING BASICS
In this section, we covered the basics of C++ programming, focusing on header files
and fundamental commands. We used Online GDB to run our code.
Key Concepts:
1. Header Files: Importance of including files like `<iostream>` for input-output
functions.
2. Basic Commands: Introduction to foundational commands.
Example Code Snippet:
```cpp
include <iostream>
using namespace std;
int main() {
cout << "Hello, World!" << endl;
return 0;
```
---
4 CONDITIONS IN PROGRAMMING
We examined various conditional statements that control the flow of execution.
Conditions Explored:
1. If: Executes code if a condition is true.
2. If-Else: Alternative block if the condition is false.
3. If-Else If: Checks multiple conditions in sequence.
Example:
```cpp
if (condition) {
// Code if true
} else if (another_condition) {
// Code if second condition is true
} else {
// Code if both conditions are false
}
```
---
5 LOOPS IN PROGRAMMING
We explored different types of loops for repeating statements.
Types of Loops:
1. For Loop: Iterates a set number of times.
2. While Loop: Executes as long as a condition is true.
3. Do While Loop: Executes at least once.
Example Code Snippets:
- For Loop:
```cpp
for (int i = 0; i < 5; i++) {
cout << i << " ";
}
```
- While Loop:
```cpp
int i = 0;
while (i < 5) {
cout << i << " ";
i++;
}
```
- Do While Loop:
```cpp
int j = 0;
do {
cout << j << " ";
j++;
} while (j < 5);
``
---
This report summarizes the key activities and lessons learned throughout the lab
sessions, providing an overview of the skills and concepts developed in Excel and
C++ programming.
