Web applications standards

These are the PROPOSED standards used in the course for web applications. The standards are framed by a draft version of the K-12 computer science framework. The standards borrow from ideas in IB computer science course, from CSTA standards, the W3 consortium, and from professional web developers. In many cases, the standards are pulled from industry leaders. For example, the databases standards are used (with permission) from Oracle and the PHP programming standards are used (pending permission) from the creator of PHP, Rasmus Lerdorf.

A note

Concepts answer the question: What does a computer scientist need to know? Practices answer the question: How do people do computer science? (source)

Essential Understandings

When this course is over, students will have the skills and knowledge to:

• Understand the foundations of the web
• Apply a design process to build quality web applications
• Apply computational thinking to problems, designs and solutions

Assessment Statement	Big Idea
Inquiring and Analyzing
Explain and justify the need for a solution to a problem for a specified client/target audience
Identify and prioritize the primary and secondary research needed to develop a solution to the problem
Analyse a range of existing products that inspire a solution to the problem
Develop a detailed design brief which summarizes the analysis of relevant research
Developing Ideas
Develop a design specification which clearly states the success criteria for the design of a solution
Develop a range of feasible design ideas which can be correctly interpreted by others
Present the final chosen design and justify its selection
Develop accurate and detailed planning drawings/diagrams and outline the requirements for the creation of the chosen solution.
Creating the Solution
Outline a plan, which considers the use of resources and time, sufficient for peers to be able to follow to create the solution
Demonstrate excellent technical skills when making the solution
Follow the plan to create the solution, which functions as intended
List the changes made to the chosen design and plan when making the solution
Present the solution as a whole
Evaluating
Outline simple, relevant testing methods, which generate data, to measure the success of the solution
Outline the success of the solution against the design specification
Outline how the solution could be improved
Outline the impact of the solution on the client/target audience
Computational thinking, problem-solving and programming
Demonstrate skill and knowledge to decompose tasks into smaller, manageable parts	Computational Thinking
Create solutions for each part of a decomposed unit	Computational Thinking
Demonstrate skill and knowledge to reducing complexity to define main idea	Computational Thinking
Demonstrate skill and knowledge to organize resources to simultaneously carry out tasks to reach a common goal	Computational Thinking
Demonstrate skill and knowledge to gather appropriate information for a task	Computational Thinking
Demonstrate skill and knowledge in making sense of data, finding patterns, and drawing conclusions	Computational Thinking
Demonstrate skill and knowledge in depicting and organizing data in appropriate graphs, charts, words, or images	Computational Thinking
Demonstrate skill and knoweldge in creating an algorithm (a series of ordered steps taken to solve a problem or achieve some end)	Computational Thinking
Demonstrate skill and knowledge to use modeling and simulation to represent and understand natural phenomena.	Computational Thinking
Create a representation or model of a process	Computational Thinking
Discuss the value of abstraction to manage problem complexity	Computational Thinking
Explain how sequence, selection, iteration, and recursion are building blocks of algorithms	Computational Thinking
Interpret the flow of execution of algorithms and predict their outcomes.	Computational Thinking
How the web works
Distinguish between the internet and World Wide Web (web)	Web Science
Describe how the web is constantly evolving	Web Science
Identify the characteristics of the following: HTTP, HTTPS, HTML, URL, XML, XSLT, CSS	Web Science
Identify the characteristics of a uniform resource identifier (URI) URL	Web Science
Describe the purpose of a URL	Web Science
Describe how a domain name server functions	Web Science
Identify the characteristics of the internet protocol (IP) transmission control protocol (TCP) file transfer protocol (FTP)	Web Science
Outline the different components of a web page	Web Science
Explain the importance of protocols and standards on the web	Web Science
Describe the different types of web page	Web Science
Explain the differences between a static web page and a dynamic web page	Web Science
Explain the functions of a browser	Web Science
Evaluate the use of client-side scripting and server-side scripting in web pages	Web Science
Describe how web pages can be connected to underlying data sources	Web Science
Evaluate the structure of different types of web pages	Web Science
Explain the characteristics of a web server	Web Science
HTML
Demonstrate knowledge and skill in developing and saving	HTML
Demonstrate knowledge and skill in working between local and remote systems	HTML
Demonstrate knowledge and skill in tags, attributes and elements	HTML
Demonstrate knowledge and skill in page titles	HTML
Demonstrate knowledge and skill in paragraphs	HTML
Demonstrate knowledge and skill in headings (the six levels of headings)	HTML
Demonstrate knowledge and skill in lists (how to define ordered and unordered lists)	HTML
Demonstrate knowledge and skill in links (how to makes links to other pages, and elsewhere)	HTML
Demonstrate knowledge and skill in images	HTML
Demonstrate knowledge and skill in tables how and when to use tabular data	HTML
Demonstrate knowledge and skill in forms, including text boxes and other user-input	HTML
CSS
Define CSS	CSS
Discuss structure of CSS and the cascade	CSS
Demonstrate knowledge and skill using selectors	CSS
Demonstrate knowledge and skill using values and units	CSS
Demonstrate knowledge and skill using text properties	CSS
Demonstrate knowledge and skill using basic visual properties	CSS
Demonstrate knowledge and skill using padding, borders and margins	CSS
Demonstrate knowledge and skill using colors, borders and backgrounds	CSS
Demonstrate knowledge and skill using floating and positioning	CSS
Demonstrate knowledge and skill using box model	CSS
Demonstrate knowledge and skill using text effects	CSS
Demonstrate knowledge and skill using 2D/3D transformations	CSS
Demonstrate knowledge and skill using multiple column layout	CSS
Demonstrate knowledge and skill using user interface	CSS
Databases
Discuss the need for databases.	Databases
Outline the differences between data and information.
Outline the differences between an information system and a database.
Describe the use of transactions, states and updates to maintain data consistency (and integrity).
Define the term database transaction.
Explain concurrency in a data sharing situation.
Explain the importance of the ACID properties of a database transaction.
Describe the two functions databases require to be performed on them.
Explain the role of data validation and data verification.
Explain data modeling
Apply understanding of entity relationship diagramming
Define entity relationships
Use unique identifiers and normalization

Use an idea, equation, principle, theory or law in relation to a given problem or issue.

Produce a plan, simulation or model.

Give a detailed account including reasons or causes.

Give valid reasons or evidence to support an answer or conclusion.

Provide an answer from a number of possibilities. Recognize and state briefly a distinguishing fact or feature.

Break down in order to bring out the essential elements or structure. To identify parts and relationships, and to interpret information to reach conclusions.

Offer for display, observation, examination or consideration.

Give a brief account.

Give a brief account.

Prove or make clear by reasoning or evidence, illustrating with examples or practical application.

Give a sequence of brief answers with no explanation.

Separate into simpler constituents.

Give the precise meaning of a word, phrase, concept or physical quantity.

Offer a considered and balanced review that includes a range of arguments, factors or hypotheses. Opinions or conclusions should be presented clearly and supported by appropriate evidence.

Use knowledge and understanding to recognize trends and draw conclusions from given information.

Give an expected result of an upcoming action or event.

Make clear the differences between two or more concepts or items.

Give a detailed account or picture of a situation, event, pattern or process.

Assess the implications and limitations; make judgments about the ideas, works, solutions or methods in relation to selected criteria.

Give the precise meaning of a word, phrase, concept or physical quantity.

Apply knowledge or rules to put theory into practice.

Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.