US$20
weeklyor US$99 for all content
Excel |初學者 | 05 週 SP |電子表格謀殺之謎
由 36 位學習者完成
年齡 11-16
自訂進度課程
平均評分：
4.8
評論數量：(1,188 評論)
5 預錄課程
5 教師支援週
自行選擇何時開始
1 年內容存取權
立即報名，隨時開始
按照自己的步調走
您的學習者可以在他們想要的時候開始學習，並以最適合他們的速度進步。當你想要的時候開始。
按照自己的步調學習
訪問一整年的課程材料。
獲得老師的實際支持。
包含什麼
5 預錄課程
5 週
教師的支持1 年訪問權
到內容作業
每週 1-2 小時. Students should work to solve the puzzles on their own code each week using the Excel sheets, videos, and slides provided. Each module should take about one to two hours to work through and homework should take about the same, but can take longer or shorter, depending on the interest of the learners and how quickly they can solve the puzzles and learn about the new features we work on in Excel each week.評估
Feedback is provided for all assignments.我們無法翻譯此文，請刷新頁面並再試一次。
課堂經歷
Welcome to Spreadsheet Murder Mystery - Learn Excel While Solving a Mystery! Self Paced Course 1, a 5 week self paced class. In this class we will learn all about Microsoft Excel while solving puzzles and using clues. Each module includes video, slides, and an Excel sheet of data to sort through. Clues are provided each week and require learners to sort through the data using various techniques to find who did it. Each week we are going to work on a new puzzle that involves new formulas in excel and new features to sort through complicated data. From going through list of suspects, narrowing down who could've done it, and learning many new options in Excel, this course will teach learners how to use Excel, work with formulas to sort data, and have fun solving puzzles. The solutions to the previous week will be provided the following week. The course will focus on fun and interesting examples to help students understand concepts that can be applied elsewhere. Because this is a self paced class, students will get detailed videos each week that cover the topic of the week, as well as handouts or PowerPoint slides that cover the topic. Students have a weekly assignment at the end of each module, and post their feedback to the classroom without spoilers. My goal is to respond to student messages quickly as my schedule allows.
學習目標
Students will learn how to use Microsoft Excel formulas while playing a fun and challenging mystery game.教學大綱
5 課程
超過 5 週課 1:
Module 1: Foundations of Data Analysis in Criminal Investigation
Module 1: Introduction to the case and the data we will be using. This module covers the functions SUM, AVERAGE, MIN, and MAX. We will use these tools to sort through simulated demographic data of suspects, and solve five clues to narrow down the list of suspects. 課 2:
Module 2: Expanding the Investigation with Advanced Data Techniques
Module 2: Another victim! The mystery deepens as the police have a new (and connected?) case. In this module we will cover the Excel functions COUNT, PRODUCT, QUOTIENT, and TEXT. By filtering and sorting through clues, we will narrow down the suspects on the second data set. 課 3:
Module 3: Reevaluating Evidence with Logical Data Functions
Module 3: Did we make a mistake? We may need to go back to the drawing board with a new list of suspects. Police found a number of new clues that may show us which direction to go in. In this module we will work on logical functions in Excel including IF, COUNTIF, SUMIF and the TEXT function. By working through a new data set with these tools we should be able to narrow down the suspect list. 課 4:
Module 4: Uncovering Hidden Connections in Data
Module 4: Is there an accomplice that we don't know about? In this module we will use more advanced functions to sort through our data and solve clues using IF, nested IF, COUNTBLANK, and TEXT. 其他詳情
父母的引導和規範
This course involves a murder mystery and has some themes that may not be appropriate for all students. While there is no graphic content, there is discussion of a murder mystery, various clues, DNA, victims, detectives, and other related elements. You will need a computer with Microsoft Excel on PC or Mac. Any version of Excel from 2016 onwards that can use .xlsx files should work. A keyboard and mouse are strongly recommended. It may be possible to complete the course using Google Sheets, but some features may not work properly. Flies for the modules will be shared with Sync, video feedback with Loom, class videos via YouTube, accounts are not required.
供應清單
You will need a computer with Microsoft Excel on PC or Mac. Any version of Excel from 2016 onwards that can use .xlsx files should work. A keyboard and mouse are strongly recommended. It may be possible to complete the course using Google Sheets, but some features may not work properly.
外部資源
除了 Outschool 教室外，本課程也使用：
來源
Videos, spreadsheets, and slides are provided each week in addition to solutions (which are provided the following week).
提供自
教師專業知識和證書
I love teaching programming and data analysis using fun and interesting examples because it helps students go farther than learning hard to contextualize concepts. Understanding what we are doing and why means that students will be able to apply algebraic concepts (like x+y) having understood examples like (red bike + blue bike) in a way that has context and meaning. I have taught Excel to hundreds of college students and learners of all ages. In data analysis, Excel is often the first step to exploring data and figuring things out.評論
Sidney - KidsSpeakCode的其他課程
Sidney - KidsSpeakCode的其他課程
其他家長也喜歡
1:1 Microsoft Office（適合初學者）
Ms. Katrena
US$55 每堂課
一對一輔導
依需求開班
11-14
MS PowerPoint 技能巡遊 - 中學 - 營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 3 PM Mon 5/19
團體課
1 週， 4/週， 50 分鐘
10-13
電腦技能：掌握 Google 文件、投影片和表格
Thrive Virtual Academy by Patch Kulp
4.9
(654)
US$20 每班
下次會議在 3 PM Mon 6/16
團體課
4 週， 1/週， 45 分鐘
11-16
MS Excel 技能巡遊 - 中學第 1 部分 - 訓練營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 4 PM Mon 5/19
團體課
1 週， 4/週， 50 分鐘
10-13
MS Excel 技能巡遊 - 高中和大學預科 - 營
Ms. Ryan, M.S.
5.0
(62)
US$18 每班
下次會議在 2 PM Mon 5/19
團體課
1 週， 5/週， 50 分鐘
14-18
MS Word 技能巡遊 - 第 1 部分 - 中學營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 4 PM Mon 5/19
團體課
1 週， 4/週， 50 分鐘
10-13
MS Word 技能巡遊 - 高中和大學預科 - 夏令營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 2 PM Mon 5/19
團體課
1 週， 5/週， 50 分鐘
14-18
電腦技能選修：Microsoft Word、Powerpoint 和 Excel 第 1 部分
Thrive Virtual Academy by Patch Kulp
4.9
(654)
US$20 每班
下次會議在 3 PM Mon 6/16
團體課
6 週， 1/週， 45 分鐘
12-16
AI軟體週刊俱樂部
Daniel Solomon Kaplan
4.9
(400)
US$12 每班
下次會議在 5 PM Friday
團體課
1/週， 55 分鐘
10-14
文字與圖片趣味夏令營：用 MS Word 製作一本彩色故事書！
Ghada
US$32 每班
下次會議在 4 PM Tue 6/3
團體課
5 週， 2/週， 1.42 小時
7-10
微軟PowerPoint簡介
Brandon
4.9
(36)
US$10 每班
下次會議在 2 PM Wednesday
團體課
1 週， 1/週， 55 分鐘
13-18
Adobe 爆炸：私人課程！
Bethanie Jones
4.8
(623)
US$86 每堂課
一對一課程
依需求開班
10-15
一對一 Microsoft PowerPoint 學習課程
Motivational Mario
5.0
(1)
US$50 每堂課
一對一課程
依需求開班
13-18
Microsoft Excel 營 3 天
Anita Whitehill
4.9
(126)
US$33 每班
下次會議在 6 PM Tuesday
團體課
1 週， 3/週， 50 分鐘
10-15
Google 投影片的基本簡單介紹、初學者投影片一對一
Teni
5.0
(46)
US$43 每堂課
一對一課程
依需求開班
8-13
PowerPoint 簡介
Anita Whitehill
4.9
(126)
US$29 每班
下次會議在 8 PM Wed 5/21
團體課
1 週， 1/週， 50 分鐘
10-15
