Spreadsheets Intermediate Course

Intermediate Course Overview

Table of Contents

• Content
• Aspects
  • 👶 Introduction
  • 💪 Workout
  • 🦑 Deep
  • ✨ New
  • 🔮 Obscura

Content

Below you can find the ordered content of the topic, in a linear progression

The linear progression of content aims to cover all content, course by course, workout by workout as follows:

• first course is the only core one, denoted by its manifest
• the next course is denoted by the first item of the next array in each course manifest
• each course has its order of workouts designated by the sections field in the same aforementioned manifest

1. tips-and-tricks-part-1

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	change-numbers-to-negative	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
2	find-and-select-functions	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
3	the-functions-menu	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
4	edit-cells	✅	👶 introduction 💪 workout	❌	✅	❌	❌	❌
5	move-cells-content	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

2. tips-and-tricks-part-2

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	use-shortcuts-to-select-cells	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
2	always-check-function-range	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
3	autofill-feature	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
4	see-version-history	✅	👶 introduction 💪 workout	❌	✅	✅	❌	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

3. common-mistakes

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	always-check-functions-names	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
2	never-delete-old-data	✅	👶 introduction 💪 workout	❌	❌	❌	❌	❌
3	spreadsheet-pemdas	✅	👶 introduction 💪 workout	❌	✅	❌	❌	❌
4	never-experiment-on-originals	✅	👶 introduction 💪 workout	❌	✅	❌	❌	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

4. spreadsheets-shortcuts

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	spreadsheet-shortcuts	✅	👶 introduction	❌	❌	❌	❌	❌
2	common-actions-shortcuts	✅	👶 introduction	❌	❌	❌	❌	❌
3	navigation-shortcuts	✅	👶 introduction	❌	❌	❌	❌	❌
4	formatting-editing-shortcuts	✅	👶 introduction	❌	❌	❌	❌	❌
5	formatting-editing-shortcuts-ii	✅	👶 introduction	❌	❌	❌	❌	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

5. logical-functions

Insights:

no	name	content	aspects	standards	PQ	RQ	Quiz	done
1	what-are-logical-functions	✅	👶 introduction	❌	❌	❌	❌	❌
2	if	✅	👶 introduction 💪 workout	❌	✅	❌	❌	❌
3	and	✅	👶 introduction 💪 workout	❌	✅	❌	❌	❌
4	or	✅	👶 introduction 💪 workout	❌	✅	❌	❌	❌
5	not	✅	👶 introduction 💪 workout	❌	✅	❌	❌	❌

Exercises:

⚠️ There are no insights in this workout.

Game:

⚠️ There is no game in this workout.

Aspects

Given the insights are tagged with aspects, we can filter over the linear content progression and create learning sub-paths.

These sub-path progressions will most likely not cover all content, but they will ensure and enforce an unified learning experience, tailor for the user wish.

For example, a user might be interested in new additions and updates of a language, rather than introduction lessions. Note that these sub-paths don't take games into consideration

👶 Introduction

If you are being introduced to the topic for the first time

Insights:

1. change-numbers-to-negative
2. find-and-select-functions
3. the-functions-menu
4. edit-cells
5. move-cells-content
6. use-shortcuts-to-select-cells
7. always-check-function-range
8. autofill-feature
9. see-version-history
10. always-check-functions-names
11. never-delete-old-data
12. spreadsheet-pemdas
13. never-experiment-on-originals
14. spreadsheet-shortcuts
15. common-actions-shortcuts
16. navigation-shortcuts
17. formatting-editing-shortcuts
18. formatting-editing-shortcuts-ii
19. what-are-logical-functions
20. if
21. and
22. or
23. not

⚠️ There are no exercises tagged with this aspect in intermediate. :warning: There are no games tagged with this aspect in intermediate.

💪 Workout

Theory put into practice/that’s how you achieve X points

Insights:

1. change-numbers-to-negative
2. find-and-select-functions
3. the-functions-menu
4. edit-cells
5. move-cells-content
6. use-shortcuts-to-select-cells
7. always-check-function-range
8. autofill-feature
9. see-version-history
10. always-check-functions-names
11. never-delete-old-data
12. spreadsheet-pemdas
13. never-experiment-on-originals
14. if
15. and
16. or
17. not

⚠️ There are no exercises tagged with this aspect in intermediate. :warning: There are no games tagged with this aspect in intermediate.

🦑 Deep

Prerequisite knowledge consisting of 2 or more 👶/💪 workouts

⚠️ There are no insights tagged with this aspect in intermediate. :warning: There are no exercises tagged with this aspect in intermediate. :warning: There are no games tagged with this aspect in intermediate.

✨ New

Recently added/gained traction feature

⚠️ There are no insights tagged with this aspect in intermediate. :warning: There are no exercises tagged with this aspect in intermediate. :warning: There are no games tagged with this aspect in intermediate.

🔮 Obscura

Stories, obscure details that don’t specifically relate to a learning objective

⚠️ There are no insights tagged with this aspect in intermediate. :warning: There are no exercises tagged with this aspect in intermediate. :warning: There are no games tagged with this aspect in intermediate.

✅ All content has been tagged with aspects.