Higher Education Computer Science & Technology Resources

Are you teaching your students about SQL ? This resource is great for you! Plenty of examples and application exercises are included. You can also easily convert this to a Google Slides lesson by dragging it into your Google Drive.

These adaptable PowerPoint Presentations can be used by the teacher in class to guide students through the topic - SQL, or they can be used by the students independently.

What is included?

✦ 13 PowerPoint Lessons

✦ 146 slides for notes and examples.

The resources includes 13 PowerPoint lessons that cover:

01. SQL Statements Introduction - 13 Slides

02. Writing SQL Statements - 7 Slides

03. Restricting and Sorting Data - 18 Slides

04. SQL Single-Row Functions - 10 Slides

05. Displaying Data from Multiple Tables - 15 Slides

06. Aggregating Data Using Group Functions - 16 Slides

07. Using a Subquery - 17 Slides

08. Data Manipulation Language - 17 Slides

09. Creating and Maintaining Tables - 9 Slides

10. Constraints - 8 Slides

11. Creating Views - 7 Slides

12. Index - 5 Slides

13. SET Operations - 4 Slides

Course Objectives

✦ Introduction to SQL

✦ Database Fundamentals

✦ Data Retrieval

✦ Filtering and Sorting Data

✦ Data Manipulation

✦ Joining Tables

✦ Aggregation and Grouping

✦ Subqueries and Derived Tables

✦ Indexes and Performance Optimization

✦ Data Manipulation Language (DML)

This resource is great for:

• In-Classroom Teaching (Displaying for the Whole Class)
• Online Learning
• Homeschooling
• Sharing on Google Classroom or Other Platforms as a Tool for Revision

-Follow us on TeachShare to be informed with new products and updates.

Hello and welcome!

Are you math teacher and have been thrown into teaching a computer science course? Now you have NO IDEA where to start! Have you taught computer science, but want to try something else? Are you teaching AP Computer Science A and need materials? Math and computer science are related, but are not the same!

I have your back. I've been teaching math and computer science, including APCSP, APCSA, and Data Structures for almost two decades. I also teach an introduction course. This is part of the course I made up for my intro students. I have a BS in computer science and know what students need to know.

This mini bundle covers about a marking period of time. Students will work with the JSwing graphics package creating interactive forms. They'll work with JButtons, JTextFields, JPanels and more!

Topics:

Java 11: Introduction to JSwing

Java 12: More Components

Java 13: JSwing- Components and Layouts Extended

All lessons will come with the following:

a pdf slideshow - Can be teacher or student driven!

an assignment - differentiated with three different levels! - Almost 100 total

exercises!

a pacing guide with hints for teaching the section and common student
errors

an answer key in pdf form - For a quick check

an answer key in .java form - Runnable out of the box.

You can pick and choose the ones you like or have students do their best to reach the "Hacker" level. This will last about a mark period and can be extended easily!

Depending on your style, you could go over the slides as a group, then let students play around. Or you could just give them the slides and assignment and let them go.

Let students explore and make mistakes. Let them talk to each other and discuss their approaches. Programming takes a lot of trial and error and collaboration.

Great for asynchronous learning and homeschooling! Could be used as a self- taught course or go at your own pace! Everything for learning is included!

Welcome to the world of programming! It's going to be a blast!

How to earn TeachShare credits for future purchases:

1. Log in to your account
2. Navigate to your "My Purchases" page
3. Locate the "Provide Feedback" button next to each purchase
4. Click the button and rate the product, leaving a short comment
5. TeachShare will reward you with credit for every feedback provided, which can be used towards future purchases.