EXCEL

Part 1 – Create a Worksheet

In this workshop you will learn how to create a worksheet and use an existing set of data. 

Students Performance in Exams

Description

The grades that students earned across a range of topics make up this data set.

• Acknowledgements
• http://roycekimmons.com/tools/generated_data/exams
• https://www.kaggle.com/datasets/spscientist/students-performance-in-exams

Part 1: Create a Spreadsheet

Your task is to create a spreadsheet. You are given a dataset that contains the grades that students earned across a range of topics.

Guidelines:

1. You must choose 4 variables from this dataset in which at least two variables are numeric.
2. Select randomly 20 rows.
3. Sort data in descending order.
4. Use built-in formulas and create a formula to evaluate the data you have
   (Ex: median, mean, sum, group by , etc.)
5. Demonstrate your data using the appropriate graph

Steps:

1. Open the Excel file called “StudentsPerformance”
2. Insert a new column to the right or to the left of your table. Call it RAND Formula
3. In the first cell of the inserted column, excluding the column headers, enter the RAND formula: =RAND()
4. Double-click the cell with the random number and bring it down with your curser to the end. As the result, you will have a random number assigned to each row.
5. Sort the random numbers largest to smallest. For this, head over to the Data tab > Sort & Filter group, and click the ZA button. Excel will automatically expand the selection and sort the entire rows in random order.
6. If you are not quite satisfied with how your table has been randomized, hit the sort button again to resort it
7. Create a new sheet by selecting the New Sheet plus icon + at the bottom of the workbook.
8. Or, select Home > Insert > Insert Sheet. Name it PART 1.
9. Choose 4 variables from this dataset in which at least two variables are numeric (Excluding the Random Formula column)).
10. Select the first 20 rows of those 3 variables you chose. Copy past them into a new worksheet.
11. To evaluate your data, select your numerical column and head over to the Formula tab and click the little downward arrow just beside the Auto Sum button. From there you can choose how to evaluate your data. (Example here: Average)
12. Just like you did above, you have to select Min and Max functions. Then create your own function to calculate the difference between the two. For this, select an empty cell and write :=C21-C22
13. Where C is the letter of my colum and 21 and 22 are the numbers of the selected rows.
14. Finally, to demonstrate your data, go on the Insert tab > Recommended Charts tab, to preview the chart.

You will be evaluated on:

• Efficient data entry
• Efficient use of automatic data entry options.
• Efficient use of align, copy, move and delete functions.
• Efficient data sorting.
• Appropriate formula creation.
• Use of relevant integrated functions.
• Appropriate graph

Part 2 – Modify a Spreadsheet

In this workshop you will begin modifying elements within a spreadsheet.

Part 2:Modify a Spreadsheet

Guidelines:

1. Delete 2 rows.
2. Interchange the rows with the columns.
3. Change the dimension of your cells.
4. Change the color of your table.
5. Change the color of one of the variables in your graph.

Steps:

1. Duplicate the sheet PART 1 and name PART 2.
2. Right-click the Sheet tab and select Delete cells.
   Or, select the sheet, and then select Home > Delete > Delete Sheet.
3. If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.

Select your table, including any row or column labels, and press Ctrl+C.

Go to the Sheet PART 2 and paste the transposed table.
Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose

1. To change the dimension of your cells: On the Home tab, in the Cells group, click Format.
   Under Cell Size, click Column Width.
   In the Column width box, type the value that you want.
   Click OK.
2. To change the color of your table:
   Go to Table Tools> Design, and then in the Table Styles group, click the arrow next to Shading, and then point to Table Background.
   Click the color that you want, or to choose no color, click No Fill.
3. To change the color of one of the variables in your chart: Left-click your graph,click on the variable/ section you want to change the color of. Then
   In a chart, click to select the data series for which you want to change the colors.
   On the Format tab, in the Current Selection group, click Format Selection.
   In the Format Data Series pane, click the Fill & Line tab, expand Fill, and then select a new color.

You will be evaluated on:

• Appropriate modification of row and column dimensions.
• Efficient insertion and deletion of rows and columns.
• Appropriate changes of cell format and display.
• Efficient insertion of elements from the same application or
• different applications.

Part 3 – Presenting a Spreadsheet

In this workshop you will present your findings to the class.

Part 3: Presenting a Spreadsheet

Guidelines:

You are required to present your observations on how students perform on exams. You will have to:

1. Present the table and the graphs on different worksheets.
2. Insert a small text explaining your observations
   (Ex: By looking at the gender and math scores in the table, the average for women is 75 and for men 73.)
3. Make it as clear as possible for the viewer.
   Steps:
4. Create a new Spreadsheet and name it Part 3

You will be evaluated on:

• Relevant use of styles and page setup possibilities.
• Using readable and professional font size and type
• Don’t use overbearing colors
• The Charts and Tables must be easy to understand

Our Pedagogy

Further details on our innovative design.

By the nature of our categorization process, we have integrated the concept of Bloom’s Taxonomy through our challenge levels. 

Classroom levels target explorative challenges where students remember, understand and apply their theories. 

Competition levels showcase a spectrum of challenges based on their complexity level. For example: Easy targets a single topic such as inventory control, Medium fuses multiple topics, while Hard binds together a case with multiple disciplines. 

Other levels – Metaverse, Pressure Tank are other level categories with a variety of presentation medium for example: Metaverse levels are built with virtual reality in mind, Pressure tank is a series of multiple learning steps within a short time period. 

Conquering Boredom

While students learn in the classroom, they can challenge themselves to explore more about a topic and participate in the open market. 

Conquering Fear and Stress

When a subject matter is overwhelming, it is not pleasant and it can be discouraging. Educators can create a flexible timeline, allowing students to listen in the classroom, while being able to take things at their own pace. Take it one step at a time. 

In addition, students are encouraged to participate often in writing and receiving feedback from their peers via our 360 Feedback system. This brings out the best from students who may be too shy to raise their hands in class.

Imagine how stressful students can be when they only have 3 shots for success in a University class. The midterm, final and an assignment or project. 

We believe that feedback is essential to improvement. Innovatank’s modular nature allows students to learn by writing (it doesn’t matter whether it is right or wrong, they just have to try!). This turns their tacit knowlege into explicit knowledge. Then, by receiving feedback, this socialization aspect allows knowledge to form and improve through reflection. 

Now, imagine 3 shots and 10 practices. Students definitely feel more at ease with the subject because they tried 10 times. As for the educator, this process is fully automatic. 

Our Link to Industry

Nibble is our Industry Experts Interview Hub, we discover and discuss the world’s most pressing issues with experts at the forefront of the action. 

The objective of this project is to give students access to real stories and provide them the opportunity to step into the shoes of subject matter experts.